Tuesday 19 March 2013

Create ViewObject(VO) Dynamically



In ProcessRequest
import oracle.apps.fnd.framework.server.OAViewDef
import oracle.apps.fnd.framework.OAViewObject 

    AdminRegAMImpl am=(AdminRegAMImpl)pageContext.getApplicationModule(webBean);
    if(am!=null)
    {
        OAViewDef viewdef=(OAViewDef)am.getOADBTransaction().createViewDef();
    viewdef.setSql("select ename from scott.emp");
         OAViewObject vo=(OAViewObject)am.createViewObject("SampleVO1",viewdef);
//SampleVO1 is ViewObject Name
            
    }
   

2 comments: