SELECT ACCTG_COST FROM gl_item_cst gic, org_acct_periods_v oap WHERE 1 = 1 AND gic.organization_id = oap.organization_id AND gic.organization_id =:P_org_id AND gic.inventory_item_id = :P_item_id AND oap.rec_type = ‘ORG_PERIOD’ AND oap.period_name =:P_period_name AND…
Read MoreWe can call Workflow in 2 ways from the OAF 1) Using PL SQL Procedure, call procedure from OAF page using callable statement. CREATE OR REPLACE PROCEDURE start_wf_prc IS l_itemtype…
Read MoreBEGIN SELECT DISTINCT assa.vendor_id,LISTAGG(assa.vendor_site_id, ‘,’) WITHIN GROUP (ORDER BY assa.vendor_id) INTO v_vendor_id,v_vendor_site_id FROM ak_web_user_sec_attr_values aw, ap_supplier_sites_all assa WHERE aw.web_user_id = FND_GLOBAL.USER_ID AND aw.attribute_code = ‘ICX_SUPPLIER_ORG_ID’ AND assa.vendor_id = aw.number_value AND…
Read Morepackage xxdynmcdata.oracle.apps.pos.project.webu; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.Connection; import java.sql.SQLException; import java.sql.Statement; import oracle.apps.fnd.common.VersionInfo; import oracle.apps.fnd.framework.OAApplicationModule; import oracle.apps.fnd.framework.OAViewObject; import oracle.apps.fnd.framework.server.OADBTransaction; import oracle.apps.fnd.framework.server.OAViewDef; import oracle.apps.fnd.framework.webui.OAControllerImpl; import oracle.apps.fnd.framework.webui.OAPageContext; import oracle.apps.fnd.framework.webui.beans.OAWebBean;…
Read Morepackage XXBlob.oracle.apps.pos.xxit.webui; import java.io.File; import java.io.FileOutputStream; import java.io.InputStream; import oracle.apps.fnd.common.VersionInfo; 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; import oracle.cabo.ui.data.DataObject; import oracle.jbo.domain.BlobDomain; import java.sql.PreparedStatement; import java.sql.Connection; import javax.xml.bind.DatatypeConverter; /** *…
Read Moreimport java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; try { Connection conn = pageContext.getApplicationModule(webBean).getOADBTransaction().getJdbcConnection(); String Query = “SELECT count(*) count from RCV_HEADERS_INTERFACE where INTERFACE_HEADER_ID=:1 and ASN_TYPE=’DARFT_ASN'”; PreparedStatement stmt = conn.prepareStatement(Query); stmt.setString(1, project_id);…
Read Morepublic void processRequest(OAPageContext pageContext, OAWebBean webBean) { super.processRequest(pageContext, webBean); String ExternalUrl = pageContext.getParameter(“ExternalUrl”); if ((ExternalUrl != null) || (!””.equals(ExternalUrl))) { String extrnlurl = “function externalurlfunc(){document.location='”+ExternalUrl+”‘;}”; OABodyBean bodyBean = (OABodyBean)pageContext.getRootWebBean(); pageContext.putJavaScriptFunction(“externalurlfunc”,…
Read MoreAssign DB sequence value to VO OAViewObject ASNvo = (OAViewObject)findViewObject(“XXASNDetailsVO”); OARow row = (OARow)ASNvo.first(); row.setAttribute(“ASNId”, getOADBTransaction().getSequenceValue(“XXASN_HEADER_SEQ”).toString());
Read MoreOAApplicationModule am = oapagecontext.getApplicationModule(oawebbean); OADBTransaction oadbtransaction = am.getOADBTransaction(); OAViewObject XXDraftASNLineEOVO = (OAViewObject)am.findViewObject(“XXDraftASNLineEOVO1”); if (XXDraftASNLineEOVO!= null) XXDraftASNLineEOVO.reset(); while (XXDraftASNLineEOVO.hasNext()) { OARow XXDraftASNLineEOVORow = (OARow)XXDraftASNLineEOVO. next (); XXDraftASNLineEOVORow.setAttributes String XXAsn=(String)XXDraftASNLineEOVORow.getAttribute(“XXASN”); XXDraftASNLineEOVORow.setAttribute(“XXASN”,”ASN”); }
Read MoreAfter deploy the code to server we need to generate “customall.jar” file from $JAVA_TOP by using “adcgnjar customall.jar” from the R12.2
Read More