Friday, 8 July 2011

Create,Update, Delete Example....

Used:
XXTestMainCO          -->Attached in your start page to Display all details at the time of page loading
XXTestEmpCO           --> Used to submit data for creating New Employee
XXTestUpdateCO       --> used to update Employee Details
XXTestEmpVOImpl     --> Employee Details
XXTestUpdateVOImpl --> Handle update operation
XXTestEmpEOImpl      --> Used to pick all Data and interaction with DB
OAFTestAM                -->to handle all your bussiness logic

**XXTestMainCO :

/*===========================================================================+
 |   Copyright (c) 2001, 2005 Oracle Corporation, Redwood Shores, CA, USA    |
 |                         All rights reserved.                              |
 +===========================================================================+
 |  HISTORY                                                                  |
 +===========================================================================*/
package XXTest.oracle.apps.per.SelfService.test.webui;
import java.io.Serializable;
import oracle.apps.fnd.common.MessageToken;
import oracle.apps.fnd.common.VersionInfo;
import oracle.apps.fnd.framework.OAApplicationModule;
import oracle.apps.fnd.framework.webui.OAControllerImpl;
import oracle.apps.fnd.framework.webui.OAPageContext;
import oracle.apps.fnd.framework.webui.OAWebBeanConstants;
import oracle.apps.fnd.framework.webui.beans.OAWebBean;
import oracle.apps.fnd.framework.OAException;
import oracle.apps.fnd.framework.webui.OADialogPage;
/**
 * Controller for ...
 */
public class XXTestMainCO extends OAControllerImpl
{
  public static final String RCS_ID="$Header$";
  public static final boolean RCS_ID_RECORDED =
        VersionInfo.recordClassVersion(RCS_ID, "%packagename%");
  /**
   * Layout and page setup logic for a region.
   * @param pageContext the current OA page context
   * @param webBean the web bean corresponding to the region
   */
  public void processRequest(OAPageContext pageContext, OAWebBean webBean)
  {
    super.processRequest(pageContext, webBean);
    OAApplicationModule am=  pageContext.getApplicationModule(webBean);
    am.invokeMethod("initEmpDetVo");
  
   
   
    if(pageContext.getParameter("TRANSACTION_STATUS")=="S"){
        pageContext.removeParameter("TRANSACTION_STATUS");
        throw new OAException("Emplouee Created successfully.",OAException.CONFIRMATION);
    }
    if(pageContext.getParameter("TRANSACTION_STATUS")=="D"){
        pageContext.removeParameter("TRANSACTION_STATUS");
        throw new OAException("Employee Deleted successfully.",OAException.CONFIRMATION);
    }
   
    if(pageContext.getParameter("TRANSACTION_STATUS")=="U"){
        pageContext.removeParameter("TRANSACTION_STATUS");
        throw new OAException("Employee Updated successfully.",OAException.CONFIRMATION);
    }
    if(pageContext.getParameter("TRANSACTION_STATUS")=="C"){
        pageContext.removeParameter("TRANSACTION_STATUS");
        throw new OAException("Transaction Canceled.",OAException.CONFIRMATION);
    }
  }
  /**
   * Procedure to handle form submissions for form elements in
   * a region.
   * @param pageContext the current OA page context
   * @param webBean the web bean corresponding to the region
   */
  public void processFormRequest(OAPageContext pageContext, OAWebBean webBean)
  {
    super.processFormRequest(pageContext, webBean);
    if(pageContext.getParameter("Create")!=null){
      pageContext.forwardImmediately("OA.jsp?page=/XXTest/oracle/apps/per/SelfService/test/webui/OAFTestPG",
                                     null,
                                     OAWebBeanConstants.KEEP_MENU_CONTEXT,
                                     null, null, true,
                                     OAWebBeanConstants.ADD_BREAD_CRUMB_NO);
     
      }
    else if ("update".equals(pageContext.getParameter(EVENT_PARAM))){
      pageContext.forwardImmediately("OA.jsp?page=/XXTest/oracle/apps/per/SelfService/test/webui/XXTestUpdatePG",
                                     null,
                                     OAWebBeanConstants.KEEP_MENU_CONTEXT,
                                     null, null, true,
                                     OAWebBeanConstants.ADD_BREAD_CRUMB_NO);
    }
    else if ("Delete".equals(pageContext.getParameter(EVENT_PARAM))){
      String EmpID= pageContext.getParameter("EmployeeId");
      String empName= pageContext.getParameter("EmployeeName");
      MessageToken[] tokens = { new MessageToken("EMP_NAME", empName)};
      OAException mainMessage = new OAException("AK", "FWK_TBX_T_EMP_DELETE_WARN", tokens);
      OADialogPage dialogPage = new OADialogPage(OAException.WARNING, mainMessage, null, "", "");
      String yes = pageContext.getMessage("AK", "FWK_TBX_T_YES", null);
      String no = pageContext.getMessage("AK", "FWK_TBX_T_NO", null);
     
      dialogPage.setOkButtonItemName("DeleteYesButton");
      dialogPage.setOkButtonToPost(true);
      dialogPage.setNoButtonToPost(true);
      dialogPage.setPostToCallingPage(true);
      dialogPage.setOkButtonLabel(yes);
      dialogPage.setNoButtonLabel(no);
      java.util.Hashtable formParams = new java.util.Hashtable(1);
      formParams.put("EmployeeId", EmpID);
      dialogPage.setFormParameters(formParams);
      pageContext.redirectToDialogPage(dialogPage);
    }
      else if (pageContext.getParameter("DeleteYesButton") != null)
   {
      String EmpID= pageContext.getParameter("EmployeeId");
      Serializable[] params = { EmpID };
      OAApplicationModule am= pageContext.getApplicationModule(webBean); 
      am.invokeMethod("DeleteEmp",params);
      pageContext.putParameter("TRANSACTION_STATUS","D");
      pageContext.forwardImmediately("OA.jsp?page=/XXTest/oracle/apps/per/SelfService/test/webui/MainOATestPG",
                                   null,
                                   OAWebBeanConstants.KEEP_MENU_CONTEXT,
                                   null, null, true,
                                   OAWebBeanConstants.ADD_BREAD_CRUMB_NO);
    }
  }
}
=========================================================================

**XXTestEmpCO:

/*===========================================================================+
 |   Copyright (c) 2001, 2005 Oracle Corporation, Redwood Shores, CA, USA    |
 |                         All rights reserved.                              |
 +===========================================================================+
 |  HISTORY                                                                  |
 +===========================================================================*/
package XXTest.oracle.apps.per.SelfService.test.webui;
import oracle.apps.fnd.common.VersionInfo;
import oracle.apps.fnd.framework.webui.OAControllerImpl;
import oracle.apps.fnd.framework.webui.OAPageContext;
import oracle.apps.fnd.framework.webui.beans.OAWebBean;
import oracle.apps.fnd.framework.OAApplicationModule;
import oracle.apps.fnd.framework.OAException;
import oracle.apps.fnd.framework.webui.OAWebBeanConstants;
/**
 * Controller for ...
 */
public class XXTestEmpCO extends OAControllerImpl
{
  public static final String RCS_ID="$Header$";
  public static final boolean RCS_ID_RECORDED =
        VersionInfo.recordClassVersion(RCS_ID, "%packagename%");
  /**
   * Layout and page setup logic for a region.
   * @param pageContext the current OA page context
   * @param webBean the web bean corresponding to the region
   */
  public void processRequest(OAPageContext pageContext, OAWebBean webBean)
  {
    super.processRequest(pageContext, webBean);
    /*write any code required at the time of page initialization
     * */
    OAApplicationModule am=  pageContext.getApplicationModule(webBean);
    am.invokeMethod("initEmpVo");
   
  }
  /**
   * Procedure to handle form submissions for form elements in
   * a region.
   * @param pageContext the current OA page context
   * @param webBean the web bean corresponding to the region
   */
  public void processFormRequest(OAPageContext pageContext, OAWebBean webBean)
  {
    /*write code required at the time of any action or event required from the page
     * */
    super.processFormRequest(pageContext, webBean);
   
    if(pageContext.getParameter("Submit")!=null){
        OAApplicationModule am=pageContext.getApplicationModule(webBean);
        am.invokeMethod("apply");
        pageContext.putParameter("TRANSACTION_STATUS","S");
        pageContext.forwardImmediately("OA.jsp?page=/XXTest/oracle/apps/per/SelfService/test/webui/MainOATestPG",
                                     null,
                                     OAWebBeanConstants.KEEP_MENU_CONTEXT,
                                     null, null, true,
                                     OAWebBeanConstants.ADD_BREAD_CRUMB_NO);
       
       
    
    }
    if(pageContext.getParameter("Cancel")!=null){
        pageContext.putParameter("TRANSACTION_STATUS","C");
        pageContext.forwardImmediately("OA.jsp?page=/XXTest/oracle/apps/per/SelfService/test/webui/MainOATestPG",
                                     null,
                                     OAWebBeanConstants.KEEP_MENU_CONTEXT,
                                     null, null, true,
                                     OAWebBeanConstants.ADD_BREAD_CRUMB_NO);
       
        //throw new  OAException("Transaction Completed Successfully",OAException.INFORMATION);
    
    }
  }
 
}
=============================================================================

** XXTestUpdateCO:

/*===========================================================================+
 |   Copyright (c) 2001, 2005 Oracle Corporation, Redwood Shores, CA, USA    |
 |                         All rights reserved.                              |
 +===========================================================================+
 |  HISTORY                                                                  |
 +===========================================================================*/
package XXTest.oracle.apps.per.SelfService.test.webui;
import java.io.Serializable;
import oracle.apps.fnd.common.VersionInfo;
import oracle.apps.fnd.framework.OAApplicationModule;
import oracle.apps.fnd.framework.OAException;
import oracle.apps.fnd.framework.webui.OAControllerImpl;
import oracle.apps.fnd.framework.webui.OAPageContext;
import oracle.apps.fnd.framework.webui.OAWebBeanConstants;
import oracle.apps.fnd.framework.webui.beans.OAWebBean;

/**
 * Controller for ...
 */
public class XXTestUpdateCO extends OAControllerImpl
{
  public static final String RCS_ID="$Header$";
  public static final boolean RCS_ID_RECORDED =
        VersionInfo.recordClassVersion(RCS_ID, "%packagename%");
  /**
   * Layout and page setup logic for a region.
   * @param pageContext the current OA page context
   * @param webBean the web bean corresponding to the region
   */
  public void processRequest(OAPageContext pageContext, OAWebBean webBean)
  {
    super.processRequest(pageContext, webBean);
    OAApplicationModule am=  pageContext.getApplicationModule(webBean);
    String EmpID= pageContext.getParameter("EmployeeID");
    System.out.println("EmpID :"+EmpID);
    Serializable[] params = { EmpID };
    am.invokeMethod("UpdateEmpDetVo",params);
  }
  /**
   * Procedure to handle form submissions for form elements in
   * a region.
   * @param pageContext the current OA page context
   * @param webBean the web bean corresponding to the region
   */
  public void processFormRequest(OAPageContext pageContext, OAWebBean webBean)
  {
    super.processFormRequest(pageContext, webBean);
   
    if(pageContext.getParameter("updateSubmit")!=null){
        OAApplicationModule am=pageContext.getApplicationModule(webBean);
        am.invokeMethod("applyUpdate");
        pageContext.putParameter("TRANSACTION_STATUS","U");
        pageContext.forwardImmediately("OA.jsp?page=/XXTest/oracle/apps/per/SelfService/test/webui/MainOATestPG",
                                     null,
                                     OAWebBeanConstants.KEEP_MENU_CONTEXT,
                                     null, null, true,
                                     OAWebBeanConstants.ADD_BREAD_CRUMB_NO);
      throw new OAException("Transaction Completed Successfully",OAException.INFORMATION);
   
    }
  
  }
}
=============================================================================

** XXTestEmpVOImpl:

package XXTest.oracle.apps.per.SelfService.test.server;
import oracle.apps.fnd.framework.server.OAViewObjectImpl;
// ---------------------------------------------------------------------
// ---    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 XXTestEmpVOImpl extends OAViewObjectImpl
{
  /**This is the default constructor (do not remove)
   */
  public XXTestEmpVOImpl()
  {
  }
 
  public void initQuery(){
    clearCache();
    executeQuery();
  }
}
=============================================================================
**XXTestUpdateVOImpl:

package XXTest.oracle.apps.per.SelfService.test.server;
import oracle.apps.fnd.framework.server.OAViewObjectImpl;
// ---------------------------------------------------------------------
// ---    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 XXTestUpdateVOImpl extends OAViewObjectImpl
{
  /**This is the default constructor (do not remove)
   */
  public XXTestUpdateVOImpl()
  {
  }
 
 
  public void initUpdateQuery(String EmpId){
  clearCache();
  setWhereClause(null);
  setWhereClauseParam(0,EmpId);
  executeQuery();
 
  }
}
=============================================================================
** XXTestEmpEOImpl:

package XXTest.oracle.apps.per.SelfService.test.schema.server;
import XXTest.oracle.apps.per.SelfService.Practice.schema.server.PracticeEOImpl;
import oracle.apps.fnd.framework.server.OAEntityDefImpl;
import oracle.apps.fnd.framework.server.OAEntityImpl;
import oracle.jbo.AttributeList;
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.jbo.server.TransactionEvent;
// ---------------------------------------------------------------------
// ---    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 XXTestEmpEOImpl extends OAEntityImpl {
    public static final int EMPLOYEEID = 0;
    public static final int TITLE = 1;
    public static final int FIRSTNAME = 2;
    public static final int MIDDLENAMES = 3;
    public static final int LASTNAME = 4;
    public static final int FULLNAME = 5;
    public static final int EMAILADDRESS = 6;
    public static final int MANAGERID = 7;
    public static final int POSITIONCODE = 8;
    public static final int SALARY = 9;
    public static final int STARTDATE = 10;
    public static final int ENDDATE = 11;
    public static final int LASTUPDATEDATE = 12;
    public static final int LASTUPDATEDBY = 13;
    public static final int CREATIONDATE = 14;
    public static final int CREATEDBY = 15;
    public static final int LASTUPDATELOGIN = 16;
    public static final int ATTRIBUTECATEGORY = 17;
    public static final int ATTRIBUTE1 = 18;
    public static final int ATTRIBUTE2 = 19;
    public static final int ATTRIBUTE3 = 20;
    public static final int ATTRIBUTE4 = 21;
    public static final int ATTRIBUTE5 = 22;
    public static final int ATTRIBUTE6 = 23;
    public static final int ATTRIBUTE7 = 24;
    public static final int ATTRIBUTE8 = 25;
    public static final int ATTRIBUTE9 = 26;
    public static final int ATTRIBUTE10 = 27;
    public static final int ATTRIBUTE11 = 28;
    public static final int ATTRIBUTE12 = 29;
    public static final int ATTRIBUTE13 = 30;
    public static final int ATTRIBUTE14 = 31;
    public static final int ATTRIBUTE15 = 32;
    public static final int PRACTICEEO = 33;
    private static OAEntityDefImpl mDefinitionObject;
    /**This is the default constructor (do not remove)
     */
    public XXTestEmpEOImpl()
  {
  }

    /**Retrieves the definition object for this instance class.
     */
    public static synchronized EntityDefImpl getDefinitionObject() {
        if (mDefinitionObject == null) {
            mDefinitionObject =
                    (OAEntityDefImpl)EntityDefImpl.findDefObject("XXTest.oracle.apps.per.SelfService.test.schema.server.XXTestEmpEO");
        }
        return mDefinitionObject;
    }
    /**Add attribute defaulting logic in this method.
     */
    public void create(AttributeList attributeList)
  {
    super.create(attributeList);
  }
  /**Add entity remove logic in this method.
   */
  public void remove()
  {
    super.remove();
  }
  /**Add Entity validation code in this method.
   */
  protected void validateEntity()
  {
    super.validateEntity();
  }
  /**Add locking logic here.
   */
  public void lock()
  {
    super.lock();
  }
  /**Custom DML update/insert/delete logic here.
   */
  protected void doDML(int operation, TransactionEvent e)
  {
    super.doDML(operation, e);
  }
  /**Gets the attribute value for EmployeeId, using the alias name EmployeeId
   */
  public Number getEmployeeId()
  {
    return (Number)getAttributeInternal(EMPLOYEEID);
  }
  /**Sets <code>value</code> as the attribute value for EmployeeId
   */
  public void setEmployeeId(Number value)
  {
    setAttributeInternal(EMPLOYEEID, value);
  }
  /**Gets the attribute value for Title, using the alias name Title
   */
  public String getTitle()
  {
    return (String)getAttributeInternal(TITLE);
  }
  /**Sets <code>value</code> as the attribute value for Title
   */
  public void setTitle(String value)
  {
    setAttributeInternal(TITLE, value);
  }
  /**Gets the attribute value for FirstName, using the alias name FirstName
   */
  public String getFirstName()
  {
    return (String)getAttributeInternal(FIRSTNAME);
  }
  /**Sets <code>value</code> as the attribute value for FirstName
   */
  public void setFirstName(String value)
  {
    setAttributeInternal(FIRSTNAME, value);
  }
  /**Gets the attribute value for MiddleNames, using the alias name MiddleNames
   */
  public String getMiddleNames()
  {
    return (String)getAttributeInternal(MIDDLENAMES);
  }
  /**Sets <code>value</code> as the attribute value for MiddleNames
   */
  public void setMiddleNames(String value)
  {
    setAttributeInternal(MIDDLENAMES, value);
  }
  /**Gets the attribute value for LastName, using the alias name LastName
   */
  public String getLastName()
  {
    return (String)getAttributeInternal(LASTNAME);
  }
  /**Sets <code>value</code> as the attribute value for LastName
   */
  public void setLastName(String value)
  {
    setAttributeInternal(LASTNAME, value);
  }
  /**Gets the attribute value for FullName, using the alias name FullName
   */
  public String getFullName()
  {
    return (String)getAttributeInternal(FULLNAME);
  }
  /**Sets <code>value</code> as the attribute value for FullName
   */
  public void setFullName(String value)
  {
    setAttributeInternal(FULLNAME, value);
  }
  /**Gets the attribute value for EmailAddress, using the alias name EmailAddress
   */
  public String getEmailAddress()
  {
    return (String)getAttributeInternal(EMAILADDRESS);
  }
  /**Sets <code>value</code> as the attribute value for EmailAddress
   */
  public void setEmailAddress(String value)
  {
    setAttributeInternal(EMAILADDRESS, value);
  }
  /**Gets the attribute value for ManagerId, using the alias name ManagerId
   */
  public Number getManagerId()
  {
    return (Number)getAttributeInternal(MANAGERID);
  }
  /**Sets <code>value</code> as the attribute value for ManagerId
   */
  public void setManagerId(Number value)
  {
    setAttributeInternal(MANAGERID, value);
  }
  /**Gets the attribute value for PositionCode, using the alias name PositionCode
   */
  public String getPositionCode()
  {
    return (String)getAttributeInternal(POSITIONCODE);
  }
  /**Sets <code>value</code> as the attribute value for PositionCode
   */
  public void setPositionCode(String value)
  {
    setAttributeInternal(POSITIONCODE, value);
  }
  /**Gets the attribute value for Salary, using the alias name Salary
   */
  public Number getSalary()
  {
    return (Number)getAttributeInternal(SALARY);
  }
  /**Sets <code>value</code> as the attribute value for Salary
   */
  public void setSalary(Number value)
  {
    setAttributeInternal(SALARY, value);
  }
  /**Gets the attribute value for StartDate, using the alias name StartDate
   */
  public Date getStartDate()
  {
    return (Date)getAttributeInternal(STARTDATE);
  }
  /**Sets <code>value</code> as the attribute value for StartDate
   */
  public void setStartDate(Date value)
  {
    setAttributeInternal(STARTDATE, value);
  }
  /**Gets the attribute value for EndDate, using the alias name EndDate
   */
  public Date getEndDate()
  {
    return (Date)getAttributeInternal(ENDDATE);
  }
  /**Sets <code>value</code> as the attribute value for EndDate
   */
  public void setEndDate(Date value)
  {
    setAttributeInternal(ENDDATE, value);
  }
  /**Gets the attribute value for LastUpdateDate, using the alias name LastUpdateDate
   */
  public Date getLastUpdateDate()
  {
    return (Date)getAttributeInternal(LASTUPDATEDATE);
  }
  /**Sets <code>value</code> as the attribute value for LastUpdateDate
   */
  public void setLastUpdateDate(Date value)
  {
    setAttributeInternal(LASTUPDATEDATE, value);
  }
  /**Gets the attribute value for LastUpdatedBy, using the alias name LastUpdatedBy
   */
  public Number getLastUpdatedBy()
  {
    return (Number)getAttributeInternal(LASTUPDATEDBY);
  }
  /**Sets <code>value</code> as the attribute value for LastUpdatedBy
   */
  public void setLastUpdatedBy(Number value)
  {
    setAttributeInternal(LASTUPDATEDBY, value);
  }
  /**Gets the attribute value for CreationDate, using the alias name CreationDate
   */
  public Date getCreationDate()
  {
    return (Date)getAttributeInternal(CREATIONDATE);
  }
  /**Sets <code>value</code> as the attribute value for CreationDate
   */
  public void setCreationDate(Date value)
  {
    setAttributeInternal(CREATIONDATE, value);
  }
  /**Gets the attribute value for CreatedBy, using the alias name CreatedBy
   */
  public Number getCreatedBy()
  {
    return (Number)getAttributeInternal(CREATEDBY);
  }
  /**Sets <code>value</code> as the attribute value for CreatedBy
   */
  public void setCreatedBy(Number value)
  {
    setAttributeInternal(CREATEDBY, value);
  }
  /**Gets the attribute value for LastUpdateLogin, using the alias name LastUpdateLogin
   */
  public Number getLastUpdateLogin()
  {
    return (Number)getAttributeInternal(LASTUPDATELOGIN);
  }
  /**Sets <code>value</code> as the attribute value for LastUpdateLogin
   */
  public void setLastUpdateLogin(Number value)
  {
    setAttributeInternal(LASTUPDATELOGIN, value);
  }
  /**Gets the attribute value for AttributeCategory, using the alias name AttributeCategory
   */
  public String getAttributeCategory()
  {
    return (String)getAttributeInternal(ATTRIBUTECATEGORY);
  }
  /**Sets <code>value</code> as the attribute value for AttributeCategory
   */
  public void setAttributeCategory(String value)
  {
    setAttributeInternal(ATTRIBUTECATEGORY, value);
  }
  /**Gets the attribute value for Attribute1, using the alias name Attribute1
   */
  public String getAttribute1()
  {
    return (String)getAttributeInternal(ATTRIBUTE1);
  }
  /**Sets <code>value</code> as the attribute value for Attribute1
   */
  public void setAttribute1(String value)
  {
    setAttributeInternal(ATTRIBUTE1, value);
  }
  /**Gets the attribute value for Attribute2, using the alias name Attribute2
   */
  public String getAttribute2()
  {
    return (String)getAttributeInternal(ATTRIBUTE2);
  }
  /**Sets <code>value</code> as the attribute value for Attribute2
   */
  public void setAttribute2(String value)
  {
    setAttributeInternal(ATTRIBUTE2, value);
  }
  /**Gets the attribute value for Attribute3, using the alias name Attribute3
   */
  public String getAttribute3()
  {
    return (String)getAttributeInternal(ATTRIBUTE3);
  }
  /**Sets <code>value</code> as the attribute value for Attribute3
   */
  public void setAttribute3(String value)
  {
    setAttributeInternal(ATTRIBUTE3, value);
  }
  /**Gets the attribute value for Attribute4, using the alias name Attribute4
   */
  public String getAttribute4()
  {
    return (String)getAttributeInternal(ATTRIBUTE4);
  }
  /**Sets <code>value</code> as the attribute value for Attribute4
   */
  public void setAttribute4(String value)
  {
    setAttributeInternal(ATTRIBUTE4, value);
  }
  /**Gets the attribute value for Attribute5, using the alias name Attribute5
   */
  public String getAttribute5()
  {
    return (String)getAttributeInternal(ATTRIBUTE5);
  }
  /**Sets <code>value</code> as the attribute value for Attribute5
   */
  public void setAttribute5(String value)
  {
    setAttributeInternal(ATTRIBUTE5, value);
  }
  /**Gets the attribute value for Attribute6, using the alias name Attribute6
   */
  public String getAttribute6()
  {
    return (String)getAttributeInternal(ATTRIBUTE6);
  }
  /**Sets <code>value</code> as the attribute value for Attribute6
   */
  public void setAttribute6(String value)
  {
    setAttributeInternal(ATTRIBUTE6, value);
  }
  /**Gets the attribute value for Attribute7, using the alias name Attribute7
   */
  public String getAttribute7()
  {
    return (String)getAttributeInternal(ATTRIBUTE7);
  }
  /**Sets <code>value</code> as the attribute value for Attribute7
   */
  public void setAttribute7(String value)
  {
    setAttributeInternal(ATTRIBUTE7, value);
  }
  /**Gets the attribute value for Attribute8, using the alias name Attribute8
   */
  public String getAttribute8()
  {
    return (String)getAttributeInternal(ATTRIBUTE8);
  }
  /**Sets <code>value</code> as the attribute value for Attribute8
   */
  public void setAttribute8(String value)
  {
    setAttributeInternal(ATTRIBUTE8, value);
  }
  /**Gets the attribute value for Attribute9, using the alias name Attribute9
   */
  public String getAttribute9()
  {
    return (String)getAttributeInternal(ATTRIBUTE9);
  }
  /**Sets <code>value</code> as the attribute value for Attribute9
   */
  public void setAttribute9(String value)
  {
    setAttributeInternal(ATTRIBUTE9, value);
  }
  /**Gets the attribute value for Attribute10, using the alias name Attribute10
   */
  public String getAttribute10()
  {
    return (String)getAttributeInternal(ATTRIBUTE10);
  }
  /**Sets <code>value</code> as the attribute value for Attribute10
   */
  public void setAttribute10(String value)
  {
    setAttributeInternal(ATTRIBUTE10, value);
  }
  /**Gets the attribute value for Attribute11, using the alias name Attribute11
   */
  public String getAttribute11()
  {
    return (String)getAttributeInternal(ATTRIBUTE11);
  }
  /**Sets <code>value</code> as the attribute value for Attribute11
   */
  public void setAttribute11(String value)
  {
    setAttributeInternal(ATTRIBUTE11, value);
  }
  /**Gets the attribute value for Attribute12, using the alias name Attribute12
   */
  public String getAttribute12()
  {
    return (String)getAttributeInternal(ATTRIBUTE12);
  }
  /**Sets <code>value</code> as the attribute value for Attribute12
   */
  public void setAttribute12(String value)
  {
    setAttributeInternal(ATTRIBUTE12, value);
  }
  /**Gets the attribute value for Attribute13, using the alias name Attribute13
   */
  public String getAttribute13()
  {
    return (String)getAttributeInternal(ATTRIBUTE13);
  }
  /**Sets <code>value</code> as the attribute value for Attribute13
   */
  public void setAttribute13(String value)
  {
    setAttributeInternal(ATTRIBUTE13, value);
  }
  /**Gets the attribute value for Attribute14, using the alias name Attribute14
   */
  public String getAttribute14()
  {
    return (String)getAttributeInternal(ATTRIBUTE14);
  }
  /**Sets <code>value</code> as the attribute value for Attribute14
   */
  public void setAttribute14(String value)
  {
    setAttributeInternal(ATTRIBUTE14, value);
  }
  /**Gets the attribute value for Attribute15, using the alias name Attribute15
   */
  public String getAttribute15()
  {
    return (String)getAttributeInternal(ATTRIBUTE15);
  }
  /**Sets <code>value</code> as the attribute value for Attribute15
   */
  public void setAttribute15(String value)
  {
    setAttributeInternal(ATTRIBUTE15, value);
  }
  /**getAttrInvokeAccessor: generated method. Do not modify.
   */
  protected Object getAttrInvokeAccessor(int index,
                                         AttributeDefImpl attrDef) throws Exception
  {
        switch (index) {
        case EMPLOYEEID:
            return getEmployeeId();
        case TITLE:
            return getTitle();
        case FIRSTNAME:
            return getFirstName();
        case MIDDLENAMES:
            return getMiddleNames();
        case LASTNAME:
            return getLastName();
        case FULLNAME:
            return getFullName();
        case EMAILADDRESS:
            return getEmailAddress();
        case MANAGERID:
            return getManagerId();
        case POSITIONCODE:
            return getPositionCode();
        case SALARY:
            return getSalary();
        case STARTDATE:
            return getStartDate();
        case ENDDATE:
            return getEndDate();
        case LASTUPDATEDATE:
            return getLastUpdateDate();
        case LASTUPDATEDBY:
            return getLastUpdatedBy();
        case CREATIONDATE:
            return getCreationDate();
        case CREATEDBY:
            return getCreatedBy();
        case LASTUPDATELOGIN:
            return getLastUpdateLogin();
        case ATTRIBUTECATEGORY:
            return getAttributeCategory();
        case ATTRIBUTE1:
            return getAttribute1();
        case ATTRIBUTE2:
            return getAttribute2();
        case ATTRIBUTE3:
            return getAttribute3();
        case ATTRIBUTE4:
            return getAttribute4();
        case ATTRIBUTE5:
            return getAttribute5();
        case ATTRIBUTE6:
            return getAttribute6();
        case ATTRIBUTE7:
            return getAttribute7();
        case ATTRIBUTE8:
            return getAttribute8();
        case ATTRIBUTE9:
            return getAttribute9();
        case ATTRIBUTE10:
            return getAttribute10();
        case ATTRIBUTE11:
            return getAttribute11();
        case ATTRIBUTE12:
            return getAttribute12();
        case ATTRIBUTE13:
            return getAttribute13();
        case ATTRIBUTE14:
            return getAttribute14();
        case ATTRIBUTE15:
            return getAttribute15();
        case PRACTICEEO:
            return getPracticeEO();
        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 EMPLOYEEID:
            setEmployeeId((Number)value);
            return;
        case TITLE:
            setTitle((String)value);
            return;
        case FIRSTNAME:
            setFirstName((String)value);
            return;
        case MIDDLENAMES:
            setMiddleNames((String)value);
            return;
        case LASTNAME:
            setLastName((String)value);
            return;
        case FULLNAME:
            setFullName((String)value);
            return;
        case EMAILADDRESS:
            setEmailAddress((String)value);
            return;
        case MANAGERID:
            setManagerId((Number)value);
            return;
        case POSITIONCODE:
            setPositionCode((String)value);
            return;
        case SALARY:
            setSalary((Number)value);
            return;
        case STARTDATE:
            setStartDate((Date)value);
            return;
        case ENDDATE:
            setEndDate((Date)value);
            return;
        case LASTUPDATEDATE:
            setLastUpdateDate((Date)value);
            return;
        case LASTUPDATEDBY:
            setLastUpdatedBy((Number)value);
            return;
        case CREATIONDATE:
            setCreationDate((Date)value);
            return;
        case CREATEDBY:
            setCreatedBy((Number)value);
            return;
        case LASTUPDATELOGIN:
            setLastUpdateLogin((Number)value);
            return;
        case ATTRIBUTECATEGORY:
            setAttributeCategory((String)value);
            return;
        case ATTRIBUTE1:
            setAttribute1((String)value);
            return;
        case ATTRIBUTE2:
            setAttribute2((String)value);
            return;
        case ATTRIBUTE3:
            setAttribute3((String)value);
            return;
        case ATTRIBUTE4:
            setAttribute4((String)value);
            return;
        case ATTRIBUTE5:
            setAttribute5((String)value);
            return;
        case ATTRIBUTE6:
            setAttribute6((String)value);
            return;
        case ATTRIBUTE7:
            setAttribute7((String)value);
            return;
        case ATTRIBUTE8:
            setAttribute8((String)value);
            return;
        case ATTRIBUTE9:
            setAttribute9((String)value);
            return;
        case ATTRIBUTE10:
            setAttribute10((String)value);
            return;
        case ATTRIBUTE11:
            setAttribute11((String)value);
            return;
        case ATTRIBUTE12:
            setAttribute12((String)value);
            return;
        case ATTRIBUTE13:
            setAttribute13((String)value);
            return;
        case ATTRIBUTE14:
            setAttribute14((String)value);
            return;
        case ATTRIBUTE15:
            setAttribute15((String)value);
            return;
        default:
            super.setAttrInvokeAccessor(index, value, attrDef);
            return;
        }
    }

    /**Gets the associated entity XXTest.oracle.apps.per.SelfService.Practice.schema.server.PracticeEOImpl
     */
    public PracticeEOImpl getPracticeEO() {
        return (PracticeEOImpl)getAttributeInternal(PRACTICEEO);
    }
    /**Sets <code>value</code> as the associated entity XXTest.oracle.apps.per.SelfService.Practice.schema.server.PracticeEOImpl
     */
    public void setPracticeEO(PracticeEOImpl value) {
        setAttributeInternal(PRACTICEEO, value);
    }
    /**Creates a Key object based on given key constituents
     */
    public static Key createPrimaryKey(Number employeeId) {
        return new Key(new Object[]{employeeId});
    }
}
==============================================================================
** OAFTestAM:

package XXTest.oracle.apps.per.SelfService.test.server;
import oracle.apps.fnd.framework.server.OAApplicationModuleImpl;
import oracle.apps.fnd.framework.server.OAViewObjectImpl;
import XXTest.oracle.apps.per.SelfService.test.server.XXTestEmpVOImpl;
import XXTest.oracle.apps.per.SelfService.test.server.XXTestUpdateVOImpl;
import oracle.apps.fnd.framework.OAViewObject;
import oracle.jbo.Row;
import oracle.jbo.RowSetIterator;
import oracle.jbo.domain.Number;
import oracle.jbo.Transaction;
// ---------------------------------------------------------------------
// ---    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 OAFTestAMImpl extends OAApplicationModuleImpl
{
  /**This is the default constructor (do not remove)
   */
  public OAFTestAMImpl()
  {
  }
  /**Sample main for debugging Business Components code using the tester.
   */
  public static void main(String[] args)
  {
    launchTester("XXTest.oracle.apps.per.SelfService.test.server", /* package name */
      "OAFTestAMLocal" /* Configuration Name */);
  }
  /**Container's getter for XXTestEmpVO
   */
  public XXTestEmpVOImpl getXXTestEmpVO()
  {
    return (XXTestEmpVOImpl)findViewObject("XXTestEmpVO");
  }
 
  public void initEmpVo(){
    OAViewObject vo= (OAViewObject)getXXTestEmpVO();
  //  vo.initQuery();
   vo.executeQuery();
   
    Row row= vo.createRow();
    vo.insertRow(row);
    row.setNewRowState(Row.STATUS_INITIALIZED);
  
  }
 
  public void initEmpDetVo(){
 
    XXTestEmpVOImpl vo= getXXTestEmpVO();
   
    vo.clearCache();
    vo.initQuery();

  }
 
  public void UpdateEmpDetVo(String EmpID){
    XXTestUpdateVOImpl updateVO= getXXTestUpdateVO();
    updateVO.clearCache();
    updateVO.initUpdateQuery(EmpID);
   
  }
  public void applyUpdate(){
      getTransaction().commit();
  }
 
  public void DeleteEmp(String EmpID){
   
    int empToDelete = Integer.parseInt(EmpID);
    System.out.println("empToDelete :"+empToDelete);
   
    OAViewObject vo = (OAViewObject)getXXTestEmpVO();
   // vo.clearCache();
   // vo.setWhereClause(null);
   // vo.setWhereClauseParam(0,empToDelete);
    if(!vo.isPreparedForExecution()){
        vo.executeQuery();
    }
   
    XXTestEmpVORowImpl row=null;
   
    int fetchRowCount = vo.getRowCount();
   // int RowCount = vo.getRowCount();
    System.out.println("fetchRowCount :"+fetchRowCount);
    //System.out.println("RowCount :"+RowCount);
   
    RowSetIterator deleteIter = vo.createRowSetIterator("deleteIter");
    if (fetchRowCount>0){
      deleteIter.setRangeStart(0);
      deleteIter.setRangeSize(fetchRowCount);
          for(int i=0;i<fetchRowCount;i++){
            row = (XXTestEmpVORowImpl)deleteIter.getRowAtRangeIndex(i);
            Number primaryKey = row.getEmployeeId();
                    if (primaryKey.compareTo(empToDelete) == 0)
                    {
                      row.remove();
                      getTransaction().commit();
                      break;
                    } 
          }
     
    }
   
  }
 
  public void apply(){
      getTransaction().commit();
  }
  /**Container's getter for XXTestUpdateVO
   */
  public XXTestUpdateVOImpl getXXTestUpdateVO()
  {
    return (XXTestUpdateVOImpl)findViewObject("XXTestUpdateVO");
  }
}

No comments:

Post a Comment