OAF PLSQL Invocation from OAPLSQLEOImpl

package cnsi.oracle.apps.fnd.schema.server;

import java.sql.CallableStatement;
import java.sql.SQLException;

import oracle.apps.fnd.framework.server.OAEntityDefImpl;
import oracle.apps.fnd.framework.server.OAEntityImpl;

import oracle.apps.fnd.framework.server.OAPlsqlEntityImpl;

import oracle.jbo.Key;
import oracle.jbo.domain.Date;
import oracle.jbo.domain.Number;
import oracle.jbo.server.AttributeDefImpl;
import oracle.jbo.server.EntityDefImpl;

import oracle.jdbc.OracleCallableStatement;
import oracle.jdbc.OracleTypes;
// ---------------------------------------------------------------------
// ---    File generated by Oracle ADF Business Components Design Time.
// ---    Custom code may be added to this class.
// ---    Warning: Do not modify method signatures of generated methods.
// ---------------------------------------------------------------------
public class EmpOAPlsqlEOImpl extends OAPlsqlEntityImpl {
    public static final int EMPNO = 0;
    public static final int ENAME = 1;
    public static final int JOB = 2;
    public static final int MGR = 3;
    public static final int HIREDATE = 4;
    public static final int SAL = 5;
    public static final int COMM = 6;
    public static final int DEPTNO = 7;
    private static OAEntityDefImpl mDefinitionObject;

    /**This is the default constructor (do not remove)
     */
    public EmpOAPlsqlEOImpl() {
    }

    /**Retrieves the definition object for this instance class.
     */
    public static synchronized EntityDefImpl getDefinitionObject() {
        if (mDefinitionObject == null) {
            mDefinitionObject = 
                    (OAEntityDefImpl)EntityDefImpl.findDefObject("cnsi.oracle.apps.fnd.schema.server.EmpOAPlsqlEO");
        }
        return mDefinitionObject;
    }

    /**Gets the attribute value for Empno, using the alias name Empno
     */
    public Number getEmpno() {
        return (Number)getAttributeInternal(EMPNO);
    }

    /**Sets <code>value</code> as the attribute value for Empno
     */
    public void setEmpno(Number value) {
        setAttributeInternal(EMPNO, value);
    }

    /**Gets the attribute value for Ename, using the alias name Ename
     */
    public String getEname() {
        return (String)getAttributeInternal(ENAME);
    }

    /**Sets <code>value</code> as the attribute value for Ename
     */
    public void setEname(String value) {
        setAttributeInternal(ENAME, value);
    }

    /**Gets the attribute value for Job, using the alias name Job
     */
    public String getJob() {
        return (String)getAttributeInternal(JOB);
    }

    /**Sets <code>value</code> as the attribute value for Job
     */
    public void setJob(String value) {
        setAttributeInternal(JOB, value);
    }

    /**Gets the attribute value for Mgr, using the alias name Mgr
     */
    public Number getMgr() {
        return (Number)getAttributeInternal(MGR);
    }

    /**Sets <code>value</code> as the attribute value for Mgr
     */
    public void setMgr(Number value) {
        setAttributeInternal(MGR, value);
    }

    /**Gets the attribute value for Hiredate, using the alias name Hiredate
     */
    public Date getHiredate() {
        return (Date)getAttributeInternal(HIREDATE);
    }

    /**Sets <code>value</code> as the attribute value for Hiredate
     */
    public void setHiredate(Date value) {
        setAttributeInternal(HIREDATE, value);
    }

    /**Gets the attribute value for Sal, using the alias name Sal
     */
    public Number getSal() {
        return (Number)getAttributeInternal(SAL);
    }

    /**Sets <code>value</code> as the attribute value for Sal
     */
    public void setSal(Number value) {
        setAttributeInternal(SAL, value);
    }

    /**Gets the attribute value for Comm, using the alias name Comm
     */
    public Number getComm() {
        return (Number)getAttributeInternal(COMM);
    }

    /**Sets <code>value</code> as the attribute value for Comm
     */
    public void setComm(Number value) {
        setAttributeInternal(COMM, value);
    }

    /**Gets the attribute value for Deptno, using the alias name Deptno
     */
    public Number getDeptno() {
        return (Number)getAttributeInternal(DEPTNO);
    }

    /**Sets <code>value</code> as the attribute value for Deptno
     */
    public void setDeptno(Number value) {
        setAttributeInternal(DEPTNO, value);
    }

    /**getAttrInvokeAccessor: generated method. Do not modify.
     */
    protected Object getAttrInvokeAccessor(int index, 
                                           AttributeDefImpl attrDef) throws Exception {
        switch (index) {
        case EMPNO:
            return getEmpno();
        case ENAME:
            return getEname();
        case JOB:
            return getJob();
        case MGR:
            return getMgr();
        case HIREDATE:
            return getHiredate();
        case SAL:
            return getSal();
        case COMM:
            return getComm();
        case DEPTNO:
            return getDeptno();
        default:
            return super.getAttrInvokeAccessor(index, attrDef);
        }
    }

    /**setAttrInvokeAccessor: generated method. Do not modify.
     */
    protected void setAttrInvokeAccessor(int index, Object value, 
                                         AttributeDefImpl attrDef) throws Exception {
        switch (index) {
        case EMPNO:
            setEmpno((Number)value);
            return;
        case ENAME:
            setEname((String)value);
            return;
        case JOB:
            setJob((String)value);
            return;
        case MGR:
            setMgr((Number)value);
            return;
        case HIREDATE:
            setHiredate((Date)value);
            return;
        case SAL:
            setSal((Number)value);
            return;
        case COMM:
            setComm((Number)value);
            return;
        case DEPTNO:
            setDeptno((Number)value);
            return;
        default:
            super.setAttrInvokeAccessor(index, value, attrDef);
            return;
        }
    }

    /**Creates a Key object based on given key constituents
     */
    public static Key createPrimaryKey(Number empno) {
        return new Key(new Object[]{empno});
    }

    public void setCreationDate(Date date) {
    }

    public void setCreatedBy(Number number) {
    }

    public void setLastUpdateDate(Date date) {
    }

    public void setLastUpdatedBy(Number number) {
    }

    public void setLastUpdateLogin(Number number) {
    }
    
    public void insertRow()
    { 
    
    System.out.println("Inside Insert Row ");
    
        Number empno = null , mgr= null , sal=null, comm= null, deptno= null ; 
        String empname = null,  job=null ; 
        Date hrieDate=null ; 
        String returnStatus=null, returnMsg = null ; 
        
        empno = getEmpno() ; 
        empname = getEname(); 
        job = getJob(); 
        mgr = getMgr(); 
        hrieDate = getHiredate(); 
        sal = getSal(); 
        comm = getComm(); 
        deptno = getDeptno() ; 
        
          String sql = "BEGIN  xxcus_oaf_emp_utils.insert_emp("
                         +"P_EMPNO       =>:1,"
                         +"P_ENAME        =>:2,"
                         +"P_JOB        => :3 , "
                         +"P_MGR        => :4 , "
                         +"P_HIREDATE        => :5 , "
                         +"P_SAL        => :6 , "
                         +"P_COMM        => :7 , "                  
                         +"P_DEPTNO        => :8 , "          
                         +"x_return_status    => :9,"
                         +"x_message => :10); END;";
        
        CallableStatement cstmt = getOADBTransaction().createCallableStatement(sql,1) ;


          try {
              
              cstmt.setInt(1,empno.intValue());
              cstmt.setString(2,empname);
              
              if(job!=null)
                  cstmt.setString(3,job);
              else
                  cstmt.setNull(3,OracleTypes.NULL);
              
              if(mgr!=null)    
              cstmt.setInt(4,mgr.intValue());
              else
              cstmt.setNull(4,OracleTypes.NULL);
              
              if(hrieDate!=null)
              cstmt.setDate(5,hrieDate.dateValue());
              else
              cstmt.setNull(5,OracleTypes.NULL);
              
              if(sal!=null)
              cstmt.setInt(6,sal.intValue());
              else
              cstmt.setNull(6,OracleTypes.NULL);
              
              if(comm!=null)
              cstmt.setInt(7,comm.intValue());
              else
              cstmt.setNull(7,OracleTypes.NULL);
              
              if(deptno!=null)
              cstmt.setInt(8,deptno.intValue());
              else
              cstmt.setNull(8,OracleTypes.NULL);
              
              
              ((OracleCallableStatement)cstmt).registerOutParameter(9, OracleTypes.VARCHAR, 0, 10);
              ((OracleCallableStatement)cstmt).registerOutParameter(10, OracleTypes.VARCHAR, 0, 4000);
              cstmt.execute();

              returnStatus = cstmt.getString(9);  
              returnMsg = cstmt.getString(10);
              
              cstmt.close();
        
              
          } catch (SQLException e) {
          
              // throw new OAException("error while calling plsql insert"+ e.getMessage());
              // TODO
          }
          
    
    
    }

    public void updateRow()
    
    {
    System.out.println("Inside Update Row ");
    
        Number empno = null , mgr= null , sal=null, comm= null, deptno= null ; 
        String empname = null,  job=null ; 
        Date hrieDate=null ; 
        String returnStatus=null, returnMsg = null ; 
        
        empno = getEmpno() ; 
        empname = getEname(); 
        job = getJob(); 
        mgr = getMgr(); 
        hrieDate = getHiredate(); 
        sal = getSal(); 
        comm = getComm(); 
        deptno = getDeptno() ; 
        
          String sql = "BEGIN  xxcus_oaf_emp_utils.update_emp("
                         +"P_EMPNO       =>:1,"
                         +"P_ENAME        =>:2,"
                         +"P_JOB        => :3 , "
                         +"P_MGR        => :4 , "
                         +"P_HIREDATE        => :5 , "
                         +"P_SAL        => :6 , "
                         +"P_COMM        => :7 , "                  
                         +"P_DEPTNO        => :8 , "          
                         +"x_return_status    => :9,"
                         +"x_message => :10); END;";
        
        CallableStatement cstmt = getOADBTransaction().createCallableStatement(sql,1) ;


          try {
              
              cstmt.setInt(1,empno.intValue());
              cstmt.setString(2,empname);
              
              if(job!=null)
                  cstmt.setString(3,job);
              else
                  cstmt.setNull(3,OracleTypes.NULL);
              
              if(mgr!=null)    
              cstmt.setInt(4,mgr.intValue());
              else
              cstmt.setNull(4,OracleTypes.NULL);
              
              if(hrieDate!=null)
              cstmt.setDate(5,hrieDate.dateValue());
              else
              cstmt.setNull(5,OracleTypes.NULL);
              
              if(sal!=null)
              cstmt.setInt(6,sal.intValue());
              else
              cstmt.setNull(6,OracleTypes.NULL);
              
              if(comm!=null)
              cstmt.setInt(7,comm.intValue());
              else
              cstmt.setNull(7,OracleTypes.NULL);
              
              if(deptno!=null)
              cstmt.setInt(8,deptno.intValue());
              else
              cstmt.setNull(8,OracleTypes.NULL);
              
              
              ((OracleCallableStatement)cstmt).registerOutParameter(9, OracleTypes.VARCHAR, 0, 10);
              ((OracleCallableStatement)cstmt).registerOutParameter(10, OracleTypes.VARCHAR, 0, 4000);
              cstmt.execute();

              returnStatus = cstmt.getString(9);  
              returnMsg = cstmt.getString(10);
              
              cstmt.close();
        
              
          } catch (SQLException e) {
          
              // throw new OAException("error while calling plsql insert"+ e.getMessage());
              // TODO
          }
        
    
    }

    public void deleteRow()
     { 
      
      System.out.println("Inside Delete Row Method");
      
       Number empNo = getEmpno(); 
       
         String sql = "BEGIN  xxcus_oaf_emp_utils.delete_emp("
                            +"p_emp_id       =>:1); END;";
         
         CallableStatement cstmt = getOADBTransaction().createCallableStatement(sql,1) ;
         try {
             cstmt.setInt(1,empNo.intValue());
             cstmt.execute();
         } catch (SQLException e) 
          {
             // TODO
          }
     
     }
}

Comments |0|

Legend *) Required fields are marked
**) You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>
Category: OAF