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.

[Home] [Help]

APPS.PO_NEGOTIATION_REQ_NOTIF dependencies on WF_ENGINE

Line 132: wf_engine.CreateProcess( ItemType => ItemType,

128:
129: commit;
130:
131: if x_wf_created = 0 then
132: wf_engine.CreateProcess( ItemType => ItemType,
133: ItemKey => ItemKey,
134: process => WorkflowProcess);
135:
136:

Line 172: wf_engine.SetItemAttrNumber ( itemtype => ItemType,

168:
169: PO_MOAC_UTILS_PVT.set_org_context(x_org_id) ; --
170:
171: -- Initialize workflow item attributes
172: wf_engine.SetItemAttrNumber ( itemtype => ItemType,
173: itemkey => ItemKey,
174: aname => 'ORG_ID',
175: avalue => x_org_id);
176:

Line 178: wf_engine.SetItemAttrText ( itemtype => ItemType,

174: aname => 'ORG_ID',
175: avalue => x_org_id);
176:
177: --
178: wf_engine.SetItemAttrText ( itemtype => ItemType,
179: itemkey => ItemKey,
180: aname => 'NEGOTIATION_NUM',
181: avalue => NegotiationNum);
182: --

Line 183: wf_engine.SetItemAttrNumber ( itemtype => ItemType,

179: itemkey => ItemKey,
180: aname => 'NEGOTIATION_NUM',
181: avalue => NegotiationNum);
182: --
183: wf_engine.SetItemAttrNumber ( itemtype => ItemType,
184: itemkey => ItemKey,
185: aname => 'DOCUMENT_ID',
186: avalue => DocumentId);
187: --

Line 188: wf_engine.SetItemAttrText ( itemtype => ItemType,

184: itemkey => ItemKey,
185: aname => 'DOCUMENT_ID',
186: avalue => DocumentId);
187: --
188: wf_engine.SetItemAttrText ( itemtype => ItemType,
189: itemkey => ItemKey,
190: aname => 'SOURCE',
191: avalue => Source);
192:

Line 194: wf_engine.SetItemAttrNumber ( itemtype => ItemType,

190: aname => 'SOURCE',
191: avalue => Source);
192:
193: --
194: wf_engine.SetItemAttrNumber ( itemtype => ItemType,
195: itemkey => ItemKey,
196: aname => 'MRP_PROCESSID',
197: avalue => ProcessId);
198: --

Line 199: wf_engine.SetItemAttrText ( itemtype => ItemType,

195: itemkey => ItemKey,
196: aname => 'MRP_PROCESSID',
197: avalue => ProcessId);
198: --
199: wf_engine.SetItemAttrText ( itemtype => ItemType,
200: itemkey => ItemKey,
201: aname => 'USER_NAME' ,
202: avalue => OwnerName);
203:

Line 205: wf_engine.SetItemAttrText ( itemtype => ItemType,

201: aname => 'USER_NAME' ,
202: avalue => OwnerName);
203:
204: --
205: wf_engine.SetItemAttrText ( itemtype => ItemType,
206: itemkey => ItemKey,
207: aname => 'USER_DISPLAY_NAME' ,
208: avalue => x_user_display_name);
209:

Line 217: wf_engine.SetItemAttrText(itemtype => Itemtype,

213:
214: -- Bug 3346038
215: po_negotiation_req_notif.set_req_line_details_mrp_wd(ItemType,ItemKey,x_document);
216:
217: wf_engine.SetItemAttrText(itemtype => Itemtype,
218: itemkey => ItemKey,
219: aname => 'PO_REQ_CHN_MSG_SUB_MRP',
220: avalue => l_message_sub1);
221:

Line 223: wf_engine.SetItemAttrText(itemtype => Itemtype,

219: aname => 'PO_REQ_CHN_MSG_SUB_MRP',
220: avalue => l_message_sub1);
221:
222: -- Bug 3346038
223: wf_engine.SetItemAttrText(itemtype => Itemtype,
224: itemkey => ItemKey,
225: aname => 'PO_REQ_CHN_MSG_BODY_TMP',
226: avalue => x_document);
227:

Line 228: wf_engine.SetItemAttrText(itemtype => Itemtype,

224: itemkey => ItemKey,
225: aname => 'PO_REQ_CHN_MSG_BODY_TMP',
226: avalue => x_document);
227:
228: wf_engine.SetItemAttrText(itemtype => Itemtype,
229: itemkey => ItemKey,
230: aname => 'PO_REQ_CHN_MSG_BODY_MRP',
231: -- Bug 3346038, Should use PLSQLCLOB
232: -- avalue => x_document);

Line 238: wf_engine.SetItemAttrText(itemtype => Itemtype,

234: 'PLSQLCLOB:PO_NEGOTIATION_REQ_NOTIF.GET_REQ_LINE_DETAILS_MRP_WD/'||
235: itemtype||':'||itemkey);
236: ELSE
237:
238: wf_engine.SetItemAttrText(itemtype => Itemtype,
239: itemkey => ItemKey,
240: aname => 'PO_REQ_CHN_MSG_SUB',
241: avalue => l_message_sub);
242:

Line 243: wf_engine.SetItemAttrText(itemtype => itemtype,

239: itemkey => ItemKey,
240: aname => 'PO_REQ_CHN_MSG_SUB',
241: avalue => l_message_sub);
242:
243: wf_engine.SetItemAttrText(itemtype => itemtype,
244: itemkey => itemkey,
245: aname => 'PO_REQ_CHN_MSG_BODY',
246: avalue =>
247: 'PLSQLCLOB:PO_NEGOTIATION_REQ_NOTIF.GET_REQ_LINE_DETAILS/'||

Line 255: wf_engine.StartProcess(itemtype => itemtype,

251: END IF;
252:
253: /* Start the workflow process */
254:
255: wf_engine.StartProcess(itemtype => itemtype,
256: itemkey => itemkey );
257:
258:
259:

Line 356: l_org_id := wf_engine.GetItemAttrNumber

352:
353: x_progress := '000';
354:
355: /* Get all the attribute values needed to build the body */
356: l_org_id := wf_engine.GetItemAttrNumber
357: (itemtype => l_item_type,
358: itemkey => l_item_key,
359: aname => 'ORG_ID');
360:

Line 364: l_document_id := wf_engine.GetItemAttrNumber

360:
361: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --
362:
363: x_progress := '001';
364: l_document_id := wf_engine.GetItemAttrNumber
365: (itemtype => l_item_type,
366: itemkey => l_item_key,
367: aname => 'DOCUMENT_ID');
368:

Line 370: l_negotiation_num := wf_engine.GetItemAttrText

366: itemkey => l_item_key,
367: aname => 'DOCUMENT_ID');
368:
369: x_progress := '002';
370: l_negotiation_num := wf_engine.GetItemAttrText
371: (itemtype => l_item_type,
372: itemkey => l_item_key,
373: aname => 'NEGOTIATION_NUM');
374:

Line 376: l_source := wf_engine.GetItemAttrText

372: itemkey => l_item_key,
373: aname => 'NEGOTIATION_NUM');
374:
375: x_progress := '003';
376: l_source := wf_engine.GetItemAttrText
377: (itemtype => l_item_type,
378: itemkey => l_item_key,
379: aname => 'SOURCE');
380:

Line 627: l_org_id := wf_engine.GetItemAttrNumber

623: l_item_type := itemtype;
624: l_item_key := itemkey;
625:
626: x_progress := '000';
627: l_org_id := wf_engine.GetItemAttrNumber
628: (itemtype => l_item_type,
629: itemkey => l_item_key,
630: aname => 'ORG_ID');
631:

Line 635: l_negotiation_num := wf_engine.GetItemAttrText

631:
632: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --
633:
634: x_progress := '002';
635: l_negotiation_num := wf_engine.GetItemAttrText
636: (itemtype => l_item_type,
637: itemkey => l_item_key,
638: aname => 'NEGOTIATION_NUM');
639:

Line 641: l_source := wf_engine.GetItemAttrText

637: itemkey => l_item_key,
638: aname => 'NEGOTIATION_NUM');
639:
640: x_progress := '003';
641: l_source := wf_engine.GetItemAttrText
642: (itemtype => l_item_type,
643: itemkey => l_item_key,
644: aname => 'SOURCE');
645:

Line 647: l_process_id := wf_engine.GetItemAttrNumber

643: itemkey => l_item_key,
644: aname => 'SOURCE');
645:
646: x_progress := '004';
647: l_process_id := wf_engine.GetItemAttrNumber
648: (itemtype => l_item_type,
649: itemkey => l_item_key,
650: aname => 'MRP_PROCESSID');
651:

Line 653: l_document_id := wf_engine.GetItemAttrNumber

649: itemkey => l_item_key,
650: aname => 'MRP_PROCESSID');
651:
652: x_progress := '005';
653: l_document_id := wf_engine.GetItemAttrNumber
654: (itemtype => l_item_type,
655: itemkey => l_item_key,
656: aname => 'DOCUMENT_ID');
657:

Line 864: l_message_text := wf_engine.GetItemAttrText

860: l_item_key := substr(document_id, instr(document_id, ':') + 1,
861: length(document_id) - 2);
862:
863: x_progress := '010';
864: l_message_text := wf_engine.GetItemAttrText
865: (itemtype => l_item_type,
866: itemkey => l_item_key,
867: aname => 'PO_REQ_CHN_MSG_BODY_TMP');
868:

Line 1031: if (funcmode <> wf_engine.eng_run) then

1027: funcmode in varchar2,
1028: resultout out NOCOPY varchar2 ) is
1029: l_source varchar2(30);
1030: begin
1031: if (funcmode <> wf_engine.eng_run) then
1032:
1033: resultout := wf_engine.eng_null;
1034: return;
1035:

Line 1033: resultout := wf_engine.eng_null;

1029: l_source varchar2(30);
1030: begin
1031: if (funcmode <> wf_engine.eng_run) then
1032:
1033: resultout := wf_engine.eng_null;
1034: return;
1035:
1036: end if;
1037:

Line 1038: l_source := wf_engine.GetItemAttrText

1034: return;
1035:
1036: end if;
1037:
1038: l_source := wf_engine.GetItemAttrText
1039: (itemtype => itemtype,
1040: itemkey => itemkey,
1041: aname => 'SOURCE');
1042:

Line 1044: resultout := wf_engine.eng_completed || ':' || 'MRP';

1040: itemkey => itemkey,
1041: aname => 'SOURCE');
1042:
1043: if l_source in ('MRP','WITHDRAW') then
1044: resultout := wf_engine.eng_completed || ':' || 'MRP';
1045: else
1046: resultout := wf_engine.eng_completed || ':' || 'OTHERS';
1047: end if;
1048: end;

Line 1046: resultout := wf_engine.eng_completed || ':' || 'OTHERS';

1042:
1043: if l_source in ('MRP','WITHDRAW') then
1044: resultout := wf_engine.eng_completed || ':' || 'MRP';
1045: else
1046: resultout := wf_engine.eng_completed || ':' || 'OTHERS';
1047: end if;
1048: end;
1049: END po_negotiation_req_notif;