Codes for Create , Apply ,Delete Via Image & Delete All
Code Of Application Module:-
package New_projects.oracle.apps.ak.AM1.server;
import
krishna.oracle.apps.ak.SearchVendor.server.XxApSuppliersVOImpl;
import
krishna.oracle.apps.ak.SearchVendor.server.XxApSuppliersVORowImpl;
import oracle.apps.fnd.framework.OARow;
import oracle.apps.fnd.framework.OAViewObject;
import
oracle.apps.fnd.framework.server.OAApplicationModuleImpl;
import oracle.apps.fnd.framework.server.OADBTransaction;
import oracle.jbo.RowSetIterator;
//
---------------------------------------------------------------------
// --- 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 AM1Impl extends OAApplicationModuleImpl {
/**This is the
default constructor (do not remove)
*/
public AM1Impl() {
}
/**Sample main for
debugging Business Components code using the tester.
*/
public static void
main(String[] args) {
launchTester("New_projects.oracle.apps.ak.AM1.server", /*
package name */
"AM1Local" /* Configuration Name */);
}
/**Container's
getter for VO1
*/
public VO1Impl
getVO1() {
return
(VO1Impl)findViewObject("VO1");
}
/**Container's
getter for VO_LOV
*/
public VO_LOVImpl
getVO_LOV() {
return
(VO_LOVImpl)findViewObject("VO_LOV");
}
public void
FilterRecords(String SearchVendorname)
{
OAViewObject vo = getVO1();
vo.clearCache();
vo.setWhereClauseParams(null);
vo.setWhereClause(null);
vo.setWhereClause("VENDOR_NAME=
"+"'"+SearchVendorname+"'");
vo.executeQuery();
}
public void apply()
{
getTransaction().commit();
}
public void
CreateNewRecords()
{
OAViewObject vo = getVO1();
OADBTransaction tr =
getOADBTransaction();
VO1RowImpl row = null;
vo.setMaxFetchSize(0);
OARow prow=(OARow)vo.createRow();
vo.last();
vo.next();
vo.insertRow(prow);
oracle.sql.NUMBER
VendorId1 = tr.getSequenceValue("xx_vendor_id");
vo.getCurrentRow().setAttribute("VendorId",VendorId1);
vo.getCurrentRow().setAttribute("Segment1",VendorId1);
vo.getCurrentRow().setAttribute("SummaryFlag",'N');
vo.getCurrentRow().setAttribute("EnabledFlag",'Y');
}
public void
deleteRecord()
{
OAViewObject vo
= getVO1();
VO1RowImpl row
= null;
int
fetchedRowCount = vo.getFetchedRowCount();
RowSetIterator
deleteIter = vo.createRowSetIterator("deleteIter");
if
(fetchedRowCount > 0)
{ deleteIter.setRangeStart(0);
deleteIter.setRangeSize(fetchedRowCount);
for (int i
= 0; i < fetchedRowCount; i++)
{
row =
(VO1RowImpl)deleteIter.getRowAtRangeIndex(i);
row.remove();
getTransaction().commit();
break;
}
}
deleteIter.closeRowSetIterator();
}
public void
DeleteChildrecord(String SearchVendorname1)
{
OAViewObject vo = getVO1();
VO1RowImpl row = null;
int fetchedRowCount =
vo.getFetchedRowCount();
// (Main VO)
RowSetIterator deleteIter =
vo.createRowSetIterator("deleteIter");
if (fetchedRowCount > 0)
{ deleteIter.setRangeStart(0);
deleteIter.setRangeSize(fetchedRowCount);
for (int i = 0; i < fetchedRowCount; i++)
{
row =
(VO1RowImpl)deleteIter.getRowAtRangeIndex(i);
if (row.getVendorName().equals(SearchVendorname1))
//System.out.println("SearchVendorName1=
"+row.getVendorName());
{
row.remove();
getTransaction().commit();
break;
}
}
deleteIter.closeRowSetIterator();
}
}
}
Code Of
Controller:- /*===========================================================================+
|
Copyright (c) 2001, 2005 Oracle Corporation, Redwood Shores, CA,
USA |
| All rights reserved. |
+===========================================================================+
|
HISTORY
|
+===========================================================================*/
package
New_projects.oracle.apps.ak.AM1.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.beans.OAWebBean;
/**
* Controller for ...
*/
public class
CO1 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);
}
/**
* 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);
OAApplicationModule am =
pageContext.getApplicationModule(webBean) ;
if
(pageContext.getParameter("Go")!=null)
{
String
SearchVendorname=pageContext.getParameter("Vendor_name");
//String
SearchVendorID1=pageContext.getParameter("SearchVendorID");
//System.out.println("SearchVendorName1= "+SearchVendorName1);
//System.out.println("SearchVendorID1=
"+SearchVendorID1);
Serializable[] parameters1 = {SearchVendorname };
am.invokeMethod("FilterRecords", parameters1);
}
if
(pageContext.getParameter("apply")!=null)
{
//System.out.println("Save
Pressed= ");
am.invokeMethod("apply");
String message = "Transaction
Complete " + "!";
throw new
OAException(message,OAException.CONFIRMATION );
}
if
(pageContext.getParameter("create")!=null)
{
am.invokeMethod("CreateNewRecords");
}
if
(pageContext.getParameter("delete")!=null)
{
am.invokeMethod("deleteRecord");
}
String
Action=pageContext.getParameter(EVENT_PARAM);
if(Action.equals("Delete_Row"))
{
String
pvendorname=pageContext.getParameter("Pvendorid");
//System.out.println("Vendor
id is = "+Pvendorid);
Serializable[] parameters1 = {
pvendorname };
am.invokeMethod("DeleteChildrecord", parameters1);
String message =
"Record Deleted " + "!";
throw new
OAException(message,OAException.CONFIRMATION );
} }