eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CLN_3A9_CANCELPO_PKG dependencies on WF_ENGINE

Line 131: l_po_header_id := TO_NUMBER(wf_engine.GetActivityAttrText(p_itemtype, p_itemkey, p_actid, 'POHEADERID'));

127: IF (l_Debug_Level <= 2) THEN
128: cln_debug_pub.Add('CLN_3A9_CANCELPO_PKG.SETATTRIBUTES CALLED', 2);
129: END IF;
130:
131: l_po_header_id := TO_NUMBER(wf_engine.GetActivityAttrText(p_itemtype, p_itemkey, p_actid, 'POHEADERID'));
132: l_po_release_id := TO_NUMBER(wf_engine.GetActivityAttrText(p_itemtype, p_itemkey, p_actid, 'PORELEASEID'));
133:
134: IF (l_Debug_Level <= 1) THEN
135: cln_debug_pub.Add('l_po_header_id:' || l_po_header_id, 1);

Line 132: l_po_release_id := TO_NUMBER(wf_engine.GetActivityAttrText(p_itemtype, p_itemkey, p_actid, 'PORELEASEID'));

128: cln_debug_pub.Add('CLN_3A9_CANCELPO_PKG.SETATTRIBUTES CALLED', 2);
129: END IF;
130:
131: l_po_header_id := TO_NUMBER(wf_engine.GetActivityAttrText(p_itemtype, p_itemkey, p_actid, 'POHEADERID'));
132: l_po_release_id := TO_NUMBER(wf_engine.GetActivityAttrText(p_itemtype, p_itemkey, p_actid, 'PORELEASEID'));
133:
134: IF (l_Debug_Level <= 1) THEN
135: cln_debug_pub.Add('l_po_header_id:' || l_po_header_id, 1);
136: cln_debug_pub.Add('l_po_release_id:' || l_po_release_id, 1);

Line 153: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'POHEADERID', l_po_header_id);

149: INTO l_po_header_id, l_po_number, l_rel_number, l_rev_number, l_supp_ord_number
150: FROM po_headers_all poh, po_releases_all por
151: WHERE por.po_release_id = l_po_release_id
152: AND poh.po_header_id = por.po_header_id(+);
153: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'POHEADERID', l_po_header_id);
154: END IF;
155:
156: IF (l_Debug_Level <= 1) THEN
157: cln_debug_pub.Add('l_po_header_id:' || l_po_header_id, 1);

Line 176: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PONUMBER', l_po_number);

172: */
173:
174:
175: -- Set the PO details
176: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PONUMBER', l_po_number);
177: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PORELEASENO', l_rel_number);
178: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'POREVISIONNUMBER', l_rev_number);
179: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'SUPPLIERORDERNUM', l_supp_ord_number);
180:

Line 177: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PORELEASENO', l_rel_number);

173:
174:
175: -- Set the PO details
176: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PONUMBER', l_po_number);
177: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PORELEASENO', l_rel_number);
178: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'POREVISIONNUMBER', l_rev_number);
179: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'SUPPLIERORDERNUM', l_supp_ord_number);
180:
181: -- Query PO base tables/views to get Party ID and Party Site ID

Line 178: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'POREVISIONNUMBER', l_rev_number);

174:
175: -- Set the PO details
176: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PONUMBER', l_po_number);
177: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PORELEASENO', l_rel_number);
178: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'POREVISIONNUMBER', l_rev_number);
179: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'SUPPLIERORDERNUM', l_supp_ord_number);
180:
181: -- Query PO base tables/views to get Party ID and Party Site ID
182: -- based on PO Header ID

Line 179: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'SUPPLIERORDERNUM', l_supp_ord_number);

175: -- Set the PO details
176: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PONUMBER', l_po_number);
177: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PORELEASENO', l_rel_number);
178: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'POREVISIONNUMBER', l_rev_number);
179: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'SUPPLIERORDERNUM', l_supp_ord_number);
180:
181: -- Query PO base tables/views to get Party ID and Party Site ID
182: -- based on PO Header ID
183: SELECT VENDOR_ID, VENDOR_SITE_ID

Line 193: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARTYID', l_party_id);

189: cln_debug_pub.Add('l_party_id:' || l_party_id, 1);
190: cln_debug_pub.Add('l_party_site_id:' || l_party_site_id, 1);
191: END IF;
192:
193: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARTYID', l_party_id);
194: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARTYSIDEID', l_party_site_id);
195:
196: -- Set the event key
197: SELECT cln_generic_s.nextval INTO l_cln_event_key FROM dual;

Line 194: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARTYSIDEID', l_party_site_id);

190: cln_debug_pub.Add('l_party_site_id:' || l_party_site_id, 1);
191: END IF;
192:
193: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARTYID', l_party_id);
194: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARTYSIDEID', l_party_site_id);
195:
196: -- Set the event key
197: SELECT cln_generic_s.nextval INTO l_cln_event_key FROM dual;
198: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'CLNEVENTKEY', l_cln_event_key);

Line 198: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'CLNEVENTKEY', l_cln_event_key);

194: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARTYSIDEID', l_party_site_id);
195:
196: -- Set the event key
197: SELECT cln_generic_s.nextval INTO l_cln_event_key FROM dual;
198: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'CLNEVENTKEY', l_cln_event_key);
199:
200: -- Set the XML Gateway Document ID
201: SELECT cln_generic_s.nextval INTO l_xmlg_doc_id FROM dual;
202: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'XMLGDOCUMENTID', l_xmlg_doc_id);

Line 202: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'XMLGDOCUMENTID', l_xmlg_doc_id);

198: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'CLNEVENTKEY', l_cln_event_key);
199:
200: -- Set the XML Gateway Document ID
201: SELECT cln_generic_s.nextval INTO l_xmlg_doc_id FROM dual;
202: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'XMLGDOCUMENTID', l_xmlg_doc_id);
203:
204: -- Set Transaction Type and Subtype
205: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'TRANSACTIONTYPE', 'CLN');
206: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'TRANSACTIONSUBTYPE', 'CANCELPO');

Line 205: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'TRANSACTIONTYPE', 'CLN');

201: SELECT cln_generic_s.nextval INTO l_xmlg_doc_id FROM dual;
202: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'XMLGDOCUMENTID', l_xmlg_doc_id);
203:
204: -- Set Transaction Type and Subtype
205: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'TRANSACTIONTYPE', 'CLN');
206: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'TRANSACTIONSUBTYPE', 'CANCELPO');
207:
208: x_resultout:='Yes';
209: IF (l_Debug_Level <= 2) THEN

Line 206: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'TRANSACTIONSUBTYPE', 'CANCELPO');

202: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'XMLGDOCUMENTID', l_xmlg_doc_id);
203:
204: -- Set Transaction Type and Subtype
205: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'TRANSACTIONTYPE', 'CLN');
206: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'TRANSACTIONSUBTYPE', 'CANCELPO');
207:
208: x_resultout:='Yes';
209: IF (l_Debug_Level <= 2) THEN
210: cln_debug_pub.Add('CLN_3A9_CANCELPO_PKG.SETATTRIBUTES EXITED', 2);

Line 257: l_po_header_id := TO_NUMBER(wf_engine.GetActivityAttrText(p_itemtype, p_itemkey, p_actid, 'POHEADERID'));

253: END IF;
254:
255: x_resultout := 'COMPLETE:F';
256:
257: l_po_header_id := TO_NUMBER(wf_engine.GetActivityAttrText(p_itemtype, p_itemkey, p_actid, 'POHEADERID'));
258: l_po_release_id := TO_NUMBER(wf_engine.GetActivityAttrText(p_itemtype, p_itemkey, p_actid, 'PORELEASEID'));
259:
260: -- Query for XML flag based on PO Header ID or PO Release ID
261: IF l_po_release_id = -1 THEN

Line 258: l_po_release_id := TO_NUMBER(wf_engine.GetActivityAttrText(p_itemtype, p_itemkey, p_actid, 'PORELEASEID'));

254:
255: x_resultout := 'COMPLETE:F';
256:
257: l_po_header_id := TO_NUMBER(wf_engine.GetActivityAttrText(p_itemtype, p_itemkey, p_actid, 'POHEADERID'));
258: l_po_release_id := TO_NUMBER(wf_engine.GetActivityAttrText(p_itemtype, p_itemkey, p_actid, 'PORELEASEID'));
259:
260: -- Query for XML flag based on PO Header ID or PO Release ID
261: IF l_po_release_id = -1 THEN
262: SELECT poh.xml_flag