Here we will create an another page and call from search page and do create another record or update the record in update page and return back to the search page.
1> Create an edit icon
Right click on table type object and create a new item of type image, change below properties
Item style > image
Prompt > Edit
Image URL > updateicon_enabled.gif
(These images are there in C:\Jdeveloper\jdevhome\jdev\myhtml\OA_MEDIA)
Action Type > fireaction
Event > updateRecord
Parameters > create parameter which can be primary key, here I am creating based on these two columns
PPensionOption ${oa.xxhwHrNicVO1.PensionOption}
PLowerLimit ${oa.xxhwHrNicVO1.LowerLimit}
2> Create an update page
>> /xxhw/oracle/apps/per/nic/webui/xxhwHrNicUpdPG
ID > PageLayoutRN
Region Style > pageLayout
Use same CO and AM
Window Title and Title > Update National Insurance Contributions
3> Right click the layout region and create new region using wizard, select same AM and VO as the search page.
4> Set a new controller for new page, name it as 'xxhwHrNicUpdCO'
5> Create new 'messageComponentLayout' (ButtonRN) under it
> and 'messageLayout' under it.
6. Create 4 items with property > submitButton
We will write the insert logic for 'Split' button
7> For 'Split' button set Action Type > fireaction and set parameters
PSPensionOption ${oa.xxhwHrNicVO1.PensionOption}
PSLowerLimit ${oa.xxhwHrNicVO1.LowerLimit}
PSUpperLimit ${oa.xxhwHrNicVO1.UpperLimit}
PSNicPercentage ${oa.xxhwHrNicVO1.NicPercentage}
PSRebate ${oa.xxhwHrNicVO1.Rebate}
PSDescription ${oa.xxhwHrNicVO1.Description}
> These parameter values will be used for new record creration
8> Now it is time to write some logic.
Go to the controller of the main page and handle logic for the newly added 'Edit' icon.
In the processFormRequest of xxhwHrNicCO add below code
//Logic for edit icon
//Initialising attribute to get value of any event (Note we have added edit button as event)
String actionFired = pageContext.getParameter("event");
//It will get parameter created in Edit button
String PPensionOption = pageContext.getParameter("PPensionOption");
String PLowerLimit = pageContext.getParameter("PLowerLimit");
//Now logic is:
if(actionFired.equals("updateRecord"))
{
// create a hash map and put values for parameters and action
HashMap phm = new HashMap();
phm.put("xxPPensionOption", PPensionOption);
phm.put("xxPLowerLimit", PLowerLimit);
phm.put("xxActionOnRecord", actionFired);
// go to update page
pageContext.setForwardURL("OA.jsp?page=/xxhw/oracle/apps/per/nic/webui/xxhwHrNicUpdPG", null, (byte)0, null, phm, true, "N", (byte)99);
}
9> Run the page
10> Go
11> Click on the edit icon and you can see the update page with one record
12> Now add logic to handle
Edit and (Split Record or Insert) button
> Create a method ' updateRecordMethod' in Application Module '
xxhwHrNicAMImpl'
public void updateRecordMethod(String pAction, String PPensionOption, String PLowerLimit)
{
try
{
System.out.println("Inside xxhwHrNicAMImpl.updateRecordMethod");
OAViewObjectImpl pervo = getxxhwHrNicVO1();
String existingWhereClause = pervo.getWhereClause();
pervo.setWhereClauseParams(null);
pervo.setWhereClause("PENSION_OPTION = :1 AND LOWER_LIMIT = to_number(:2)");
pervo.setWhereClauseParam(0, PPensionOption);
pervo.setWhereClauseParam(1, PLowerLimit);
pervo.executeQuery();
pervo.setWhereClauseParams(null);
pervo.setWhereClause(existingWhereClause);
}
catch(Exception exception1)
{
throw OAException.wrapperException(exception1);
}
}
> Now change the Controller of Update Page --
xxhwHrNicUpdCO
In the
processrequest
> Get all the parameter values and execute query based on these parameters
public void processRequest(OAPageContext pageContext, OAWebBean webBean)
{
super.processRequest(pageContext, webBean);
super.processRequest(pageContext, webBean);
String actionOnRecord = pageContext.getParameter("xxActionOnRecord");
String PPensionOption = pageContext.getParameter("xxPPensionOption");
String PLowerLimit = pageContext.getParameter("xxPLowerLimit");
OAApplicationModule recAM = pageContext.getApplicationModule(webBean);
Serializable recordParamList[] = {
actionOnRecord, PPensionOption, PLowerLimit
};
if(actionOnRecord != null && actionOnRecord.equals("updateRecord"))
{
recAM.invokeMethod("updateRecordMethod", recordParamList);
}
}
>> Done with the Edit button logic.
>> Do the same for Cancel and Save button logic what you did in Main page
>> Now add
logic for 'Split Record ' Button, it should create a new record with some values from parent record.
> Create another method
insertRecord in Application Module
xxhwHrNicAMImpl
public void insertRecord(String PSPensionOption, String PSLowerLimit, String PSUpperLimit, String PSNicPercentage, String PSRebate, String PSDescription)
{
OAViewObjectImpl HrNicVOImpl = (OAViewObjectImpl)getxxhwHrNicVO1();
Row hrnicrow = HrNicVOImpl.createRow();
hrnicrow.setAttribute("PensionOption", PSPensionOption);
hrnicrow.setAttribute("LowerLimit", 0);// PSLowerLimit);
hrnicrow.setAttribute("UpperLimit", 0);//PSUpperLimit);
hrnicrow.setAttribute("NicPercentage", PSNicPercentage);
hrnicrow.setAttribute("Rebate", PSRebate);
hrnicrow.setAttribute("Description", PSDescription);
HrNicVOImpl.insertRow(hrnicrow);
hrnicrow.setNewRowState((byte)-1);
getTransaction().commit();
}
>> Update the
Processformrequest of the update page controller
xxhwHrNicUpdCO
public void processFormRequest(OAPageContext pageContext, OAWebBean webBean)
{
super.processFormRequest(pageContext, webBean);
OAApplicationModule am = pageContext.getApplicationModule(webBean);
String actionFired = pageContext.getParameter("event");
String PSPensionOption = pageContext.getParameter("PSPensionOption");
String PSLowerLimit = pageContext.getParameter("PSLowerLimit");
String PSUpperLimit = pageContext.getParameter("PSUpperLimit");
String PSNicPercentage = pageContext.getParameter("PSNicPercentage");
String PSRebate = pageContext.getParameter("PSRebate");
String PSDescription = pageContext.getParameter("PSDescription");
Serializable pcardList[] = {
PSPensionOption, PSLowerLimit, PSUpperLimit, PSNicPercentage, PSRebate, PSDescription
};
if (pageContext.getParameter("Save") != null)
{
am.getOADBTransaction().commit();
}
else if (pageContext.getParameter("Cancel") != null)
{
am.getOADBTransaction().rollback();
}
// if retuen then return for Main page
else if (pageContext.getParameter("Return") != null)
{
pageContext.setForwardURL("OA.jsp?page=/xxhw/oracle/apps/per/nic/webui/xxhwHrNicPG", null, (byte)0, null, null, true, "N", (byte)99);
}
// if splitrecord then call a insertrecord method with all the parameter values
if(actionFired.equals("splitRecord"))
{
am.invokeMethod("insertRecord", pcardList);
}
}
13> Run the page again
On the update page click on 'Split Record' button
Change and save, return to the main page.
Done. :)
>> Now it's time to
deploy your custom page and access from application
