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_PO_CHANGE_RESPONSE_PKG dependencies on WF_ENGINE

Line 71: l_change_request_group_id := TO_NUMBER(wf_engine.GetActivityAttrText(p_itemtype, p_itemkey, p_actid, 'CHANGE_REQUEST_GP_ID'));

67: IF (l_Debug_Level <= 1) THEN
68: cln_debug_pub.Add('Getting change request group ID from the workflow......',1);
69: END IF;
70:
71: l_change_request_group_id := TO_NUMBER(wf_engine.GetActivityAttrText(p_itemtype, p_itemkey, p_actid, 'CHANGE_REQUEST_GP_ID'));
72: IF (l_Debug_Level <= 1) THEN
73: cln_debug_pub.Add('Change Request Group ID : ' || l_change_request_group_id, 1);
74:
75: cln_debug_pub.Add('Querying the PO_CHANGE_REQUESTS table.....',1);

Line 197: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'TRADING_PARTNER_TYPE', 'S');

193: IF (l_Debug_Level <= 1) THEN
194: cln_debug_pub.Add('---------- SETTING WORKFLOW PARAMETERS---------', 1);
195: END IF;
196:
197: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'TRADING_PARTNER_TYPE', 'S');
198: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'TRADING_PARTNER_ID', l_party_id);
199: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'TRADING_PARTNER_SITE', l_party_site_id);
200:
201: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_HEADER_ID',l_header_id);

Line 198: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'TRADING_PARTNER_ID', l_party_id);

194: cln_debug_pub.Add('---------- SETTING WORKFLOW PARAMETERS---------', 1);
195: END IF;
196:
197: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'TRADING_PARTNER_TYPE', 'S');
198: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'TRADING_PARTNER_ID', l_party_id);
199: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'TRADING_PARTNER_SITE', l_party_site_id);
200:
201: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_HEADER_ID',l_header_id);
202: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_RELEASE_ID',l_release_id);

Line 199: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'TRADING_PARTNER_SITE', l_party_site_id);

195: END IF;
196:
197: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'TRADING_PARTNER_TYPE', 'S');
198: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'TRADING_PARTNER_ID', l_party_id);
199: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'TRADING_PARTNER_SITE', l_party_site_id);
200:
201: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_HEADER_ID',l_header_id);
202: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_RELEASE_ID',l_release_id);
203: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_REVISION_NUM',l_revision_num);

Line 201: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_HEADER_ID',l_header_id);

197: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'TRADING_PARTNER_TYPE', 'S');
198: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'TRADING_PARTNER_ID', l_party_id);
199: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'TRADING_PARTNER_SITE', l_party_site_id);
200:
201: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_HEADER_ID',l_header_id);
202: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_RELEASE_ID',l_release_id);
203: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_REVISION_NUM',l_revision_num);
204: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'SO_NUMBER',l_so_number);
205:

Line 202: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_RELEASE_ID',l_release_id);

198: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'TRADING_PARTNER_ID', l_party_id);
199: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'TRADING_PARTNER_SITE', l_party_site_id);
200:
201: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_HEADER_ID',l_header_id);
202: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_RELEASE_ID',l_release_id);
203: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_REVISION_NUM',l_revision_num);
204: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'SO_NUMBER',l_so_number);
205:
206: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_NO',l_document_num );

Line 203: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_REVISION_NUM',l_revision_num);

199: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'TRADING_PARTNER_SITE', l_party_site_id);
200:
201: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_HEADER_ID',l_header_id);
202: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_RELEASE_ID',l_release_id);
203: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_REVISION_NUM',l_revision_num);
204: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'SO_NUMBER',l_so_number);
205:
206: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_NO',l_document_num );
207: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'XMLG_INTERNAL_TXN_TYPE','CLN');

Line 204: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'SO_NUMBER',l_so_number);

200:
201: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_HEADER_ID',l_header_id);
202: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_RELEASE_ID',l_release_id);
203: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_REVISION_NUM',l_revision_num);
204: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'SO_NUMBER',l_so_number);
205:
206: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_NO',l_document_num );
207: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'XMLG_INTERNAL_TXN_TYPE','CLN');
208: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'XMLG_INTERNAL_TXN_SUBTYPE','CHANGE_PO_RESPONSE');

Line 206: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_NO',l_document_num );

202: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_RELEASE_ID',l_release_id);
203: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_REVISION_NUM',l_revision_num);
204: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'SO_NUMBER',l_so_number);
205:
206: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_NO',l_document_num );
207: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'XMLG_INTERNAL_TXN_TYPE','CLN');
208: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'XMLG_INTERNAL_TXN_SUBTYPE','CHANGE_PO_RESPONSE');
209: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_DIRECTION', 'OUT');
210: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'XMLG_DOCUMENT_ID',l_xmlg_document_id);

Line 207: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'XMLG_INTERNAL_TXN_TYPE','CLN');

203: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_REVISION_NUM',l_revision_num);
204: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'SO_NUMBER',l_so_number);
205:
206: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_NO',l_document_num );
207: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'XMLG_INTERNAL_TXN_TYPE','CLN');
208: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'XMLG_INTERNAL_TXN_SUBTYPE','CHANGE_PO_RESPONSE');
209: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_DIRECTION', 'OUT');
210: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'XMLG_DOCUMENT_ID',l_xmlg_document_id);
211: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'HEADER_ACKCODE', l_header_ack_code);

Line 208: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'XMLG_INTERNAL_TXN_SUBTYPE','CHANGE_PO_RESPONSE');

204: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'SO_NUMBER',l_so_number);
205:
206: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_NO',l_document_num );
207: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'XMLG_INTERNAL_TXN_TYPE','CLN');
208: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'XMLG_INTERNAL_TXN_SUBTYPE','CHANGE_PO_RESPONSE');
209: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_DIRECTION', 'OUT');
210: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'XMLG_DOCUMENT_ID',l_xmlg_document_id);
211: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'HEADER_ACKCODE', l_header_ack_code);
212: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'HEADER_RESPONSE_REASON', l_header_response_reason);

Line 209: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_DIRECTION', 'OUT');

205:
206: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_NO',l_document_num );
207: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'XMLG_INTERNAL_TXN_TYPE','CLN');
208: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'XMLG_INTERNAL_TXN_SUBTYPE','CHANGE_PO_RESPONSE');
209: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_DIRECTION', 'OUT');
210: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'XMLG_DOCUMENT_ID',l_xmlg_document_id);
211: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'HEADER_ACKCODE', l_header_ack_code);
212: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'HEADER_RESPONSE_REASON', l_header_response_reason);
213: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'EVENT_KEY', l_event_key);

Line 210: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'XMLG_DOCUMENT_ID',l_xmlg_document_id);

206: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_NO',l_document_num );
207: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'XMLG_INTERNAL_TXN_TYPE','CLN');
208: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'XMLG_INTERNAL_TXN_SUBTYPE','CHANGE_PO_RESPONSE');
209: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_DIRECTION', 'OUT');
210: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'XMLG_DOCUMENT_ID',l_xmlg_document_id);
211: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'HEADER_ACKCODE', l_header_ack_code);
212: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'HEADER_RESPONSE_REASON', l_header_response_reason);
213: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'EVENT_KEY', l_event_key);
214:

Line 211: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'HEADER_ACKCODE', l_header_ack_code);

207: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'XMLG_INTERNAL_TXN_TYPE','CLN');
208: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'XMLG_INTERNAL_TXN_SUBTYPE','CHANGE_PO_RESPONSE');
209: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_DIRECTION', 'OUT');
210: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'XMLG_DOCUMENT_ID',l_xmlg_document_id);
211: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'HEADER_ACKCODE', l_header_ack_code);
212: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'HEADER_RESPONSE_REASON', l_header_response_reason);
213: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'EVENT_KEY', l_event_key);
214:
215: x_resultout:='Yes';

Line 212: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'HEADER_RESPONSE_REASON', l_header_response_reason);

208: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'XMLG_INTERNAL_TXN_SUBTYPE','CHANGE_PO_RESPONSE');
209: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_DIRECTION', 'OUT');
210: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'XMLG_DOCUMENT_ID',l_xmlg_document_id);
211: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'HEADER_ACKCODE', l_header_ack_code);
212: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'HEADER_RESPONSE_REASON', l_header_response_reason);
213: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'EVENT_KEY', l_event_key);
214:
215: x_resultout:='Yes';
216:

Line 213: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'EVENT_KEY', l_event_key);

209: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_DIRECTION', 'OUT');
210: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'XMLG_DOCUMENT_ID',l_xmlg_document_id);
211: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'HEADER_ACKCODE', l_header_ack_code);
212: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'HEADER_RESPONSE_REASON', l_header_response_reason);
213: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'EVENT_KEY', l_event_key);
214:
215: x_resultout:='Yes';
216:
217: -- check the error message

Line 309: l_change_request_group_id := TO_NUMBER(wf_engine.GetActivityAttrText(p_itemtype, p_itemkey, p_actid, 'CHANGE_REQUEST_GP_ID'));

305: IF (l_Debug_Level <= 1) THEN
306: cln_debug_pub.Add('Getting change request group ID from the workflow......',1);
307: END IF;
308:
309: l_change_request_group_id := TO_NUMBER(wf_engine.GetActivityAttrText(p_itemtype, p_itemkey, p_actid, 'CHANGE_REQUEST_GP_ID'));
310:
311: IF (l_Debug_Level <= 1) THEN
312: cln_debug_pub.Add('Change Request Group ID : ' || l_change_request_group_id, 1);
313: END IF;

Line 339: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'COLLABORATION_ID',l_coll_id);

335: IF (l_Debug_Level <= 1) THEN
336: cln_debug_pub.Add('Collaboration ID got as : ' || l_coll_id, 1);
337: END IF;
338:
339: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'COLLABORATION_ID',l_coll_id);
340:
341:
342: EXCEPTION
343: WHEN OTHERS THEN