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.PO_CREATE_SR_ASL dependencies on WF_ENGINE

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

55:
56:
57: -- Do nothing in cancel or timeout mode
58: --
59: if (funcmode <> wf_engine.eng_run) then
60: resultout := wf_engine.eng_null;
61: return;
62: end if;
63:

Line 60: resultout := wf_engine.eng_null;

56:
57: -- Do nothing in cancel or timeout mode
58: --
59: if (funcmode <> wf_engine.eng_run) then
60: resultout := wf_engine.eng_null;
61: return;
62: end if;
63:
64: /* Bug# 2846210

Line 71: l_document_id := wf_engine.GetItemAttrNumber ( itemtype, itemkey, 'DOCUMENT_ID');

67: */
68:
69: PO_REQAPPROVAL_INIT1.Set_doc_mgr_context(itemtype, itemkey);
70:
71: l_document_id := wf_engine.GetItemAttrNumber ( itemtype, itemkey, 'DOCUMENT_ID');
72:
73: l_po_line_num := wf_engine.GetItemAttrNumber ( itemtype, itemkey, 'PO_LINE_NUM');
74:
75: l_org_assign_change := PO_WF_UTIL_PKG.GetItemAttrText (itemtype , itemkey,'GA_ORG_ASSIGN_CHANGE'); -- GA FPI

Line 73: l_po_line_num := wf_engine.GetItemAttrNumber ( itemtype, itemkey, 'PO_LINE_NUM');

69: PO_REQAPPROVAL_INIT1.Set_doc_mgr_context(itemtype, itemkey);
70:
71: l_document_id := wf_engine.GetItemAttrNumber ( itemtype, itemkey, 'DOCUMENT_ID');
72:
73: l_po_line_num := wf_engine.GetItemAttrNumber ( itemtype, itemkey, 'PO_LINE_NUM');
74:
75: l_org_assign_change := PO_WF_UTIL_PKG.GetItemAttrText (itemtype , itemkey,'GA_ORG_ASSIGN_CHANGE'); -- GA FPI
76:
77:

Line 101: wf_engine.SetItemAttrNumber(itemtype, itemkey, 'PO_LINE_ID',l_po_line_id);

97:
98: if l_po_line_id is null then
99: l_process_po := 'N';
100: else
101: wf_engine.SetItemAttrNumber(itemtype, itemkey, 'PO_LINE_ID',l_po_line_id);
102: wf_engine.SetItemAttrNumber(itemtype, itemkey,'PO_VENDOR_ID',l_vendor_id);
103: wf_engine.SetItemAttrNumber(itemtype,itemkey,'PO_VENDOR_SITE_ID',l_vendor_site_id);
104: wf_engine.SetItemAttrNumber(itemtype, itemkey,'PO_LINE_ITEM_ID',l_item_id);
105: wf_engine.SetItemAttrText(itemtype , itemkey, 'PO_APPROVED_FLAG',l_approved_flag);

Line 102: wf_engine.SetItemAttrNumber(itemtype, itemkey,'PO_VENDOR_ID',l_vendor_id);

98: if l_po_line_id is null then
99: l_process_po := 'N';
100: else
101: wf_engine.SetItemAttrNumber(itemtype, itemkey, 'PO_LINE_ID',l_po_line_id);
102: wf_engine.SetItemAttrNumber(itemtype, itemkey,'PO_VENDOR_ID',l_vendor_id);
103: wf_engine.SetItemAttrNumber(itemtype,itemkey,'PO_VENDOR_SITE_ID',l_vendor_site_id);
104: wf_engine.SetItemAttrNumber(itemtype, itemkey,'PO_LINE_ITEM_ID',l_item_id);
105: wf_engine.SetItemAttrText(itemtype , itemkey, 'PO_APPROVED_FLAG',l_approved_flag);
106: wf_engine.SetItemAttrDate(itemtype,itemkey,'PO_START_DATE',l_start_date);

Line 103: wf_engine.SetItemAttrNumber(itemtype,itemkey,'PO_VENDOR_SITE_ID',l_vendor_site_id);

99: l_process_po := 'N';
100: else
101: wf_engine.SetItemAttrNumber(itemtype, itemkey, 'PO_LINE_ID',l_po_line_id);
102: wf_engine.SetItemAttrNumber(itemtype, itemkey,'PO_VENDOR_ID',l_vendor_id);
103: wf_engine.SetItemAttrNumber(itemtype,itemkey,'PO_VENDOR_SITE_ID',l_vendor_site_id);
104: wf_engine.SetItemAttrNumber(itemtype, itemkey,'PO_LINE_ITEM_ID',l_item_id);
105: wf_engine.SetItemAttrText(itemtype , itemkey, 'PO_APPROVED_FLAG',l_approved_flag);
106: wf_engine.SetItemAttrDate(itemtype,itemkey,'PO_START_DATE',l_start_date);
107: wf_engine.SetItemAttrDate(itemtype, itemkey, 'PO_END_DATE',l_end_date);

Line 104: wf_engine.SetItemAttrNumber(itemtype, itemkey,'PO_LINE_ITEM_ID',l_item_id);

100: else
101: wf_engine.SetItemAttrNumber(itemtype, itemkey, 'PO_LINE_ID',l_po_line_id);
102: wf_engine.SetItemAttrNumber(itemtype, itemkey,'PO_VENDOR_ID',l_vendor_id);
103: wf_engine.SetItemAttrNumber(itemtype,itemkey,'PO_VENDOR_SITE_ID',l_vendor_site_id);
104: wf_engine.SetItemAttrNumber(itemtype, itemkey,'PO_LINE_ITEM_ID',l_item_id);
105: wf_engine.SetItemAttrText(itemtype , itemkey, 'PO_APPROVED_FLAG',l_approved_flag);
106: wf_engine.SetItemAttrDate(itemtype,itemkey,'PO_START_DATE',l_start_date);
107: wf_engine.SetItemAttrDate(itemtype, itemkey, 'PO_END_DATE',l_end_date);
108: wf_engine.SetItemAttrNumber(itemtype,itemkey,'PO_INTERFACE_HEADER_ID',l_interface_header_id);

Line 105: wf_engine.SetItemAttrText(itemtype , itemkey, 'PO_APPROVED_FLAG',l_approved_flag);

101: wf_engine.SetItemAttrNumber(itemtype, itemkey, 'PO_LINE_ID',l_po_line_id);
102: wf_engine.SetItemAttrNumber(itemtype, itemkey,'PO_VENDOR_ID',l_vendor_id);
103: wf_engine.SetItemAttrNumber(itemtype,itemkey,'PO_VENDOR_SITE_ID',l_vendor_site_id);
104: wf_engine.SetItemAttrNumber(itemtype, itemkey,'PO_LINE_ITEM_ID',l_item_id);
105: wf_engine.SetItemAttrText(itemtype , itemkey, 'PO_APPROVED_FLAG',l_approved_flag);
106: wf_engine.SetItemAttrDate(itemtype,itemkey,'PO_START_DATE',l_start_date);
107: wf_engine.SetItemAttrDate(itemtype, itemkey, 'PO_END_DATE',l_end_date);
108: wf_engine.SetItemAttrNumber(itemtype,itemkey,'PO_INTERFACE_HEADER_ID',l_interface_header_id);
109: wf_engine.SetItemAttrNumber(itemtype,itemkey,'PO_INTERFACE_LINE_ID',l_interface_line_id);

Line 106: wf_engine.SetItemAttrDate(itemtype,itemkey,'PO_START_DATE',l_start_date);

102: wf_engine.SetItemAttrNumber(itemtype, itemkey,'PO_VENDOR_ID',l_vendor_id);
103: wf_engine.SetItemAttrNumber(itemtype,itemkey,'PO_VENDOR_SITE_ID',l_vendor_site_id);
104: wf_engine.SetItemAttrNumber(itemtype, itemkey,'PO_LINE_ITEM_ID',l_item_id);
105: wf_engine.SetItemAttrText(itemtype , itemkey, 'PO_APPROVED_FLAG',l_approved_flag);
106: wf_engine.SetItemAttrDate(itemtype,itemkey,'PO_START_DATE',l_start_date);
107: wf_engine.SetItemAttrDate(itemtype, itemkey, 'PO_END_DATE',l_end_date);
108: wf_engine.SetItemAttrNumber(itemtype,itemkey,'PO_INTERFACE_HEADER_ID',l_interface_header_id);
109: wf_engine.SetItemAttrNumber(itemtype,itemkey,'PO_INTERFACE_LINE_ID',l_interface_line_id);
110: wf_engine.SetItemAttrNumber(itemtype,itemkey,'PO_LINE_NUM',l_new_line_num);

Line 107: wf_engine.SetItemAttrDate(itemtype, itemkey, 'PO_END_DATE',l_end_date);

103: wf_engine.SetItemAttrNumber(itemtype,itemkey,'PO_VENDOR_SITE_ID',l_vendor_site_id);
104: wf_engine.SetItemAttrNumber(itemtype, itemkey,'PO_LINE_ITEM_ID',l_item_id);
105: wf_engine.SetItemAttrText(itemtype , itemkey, 'PO_APPROVED_FLAG',l_approved_flag);
106: wf_engine.SetItemAttrDate(itemtype,itemkey,'PO_START_DATE',l_start_date);
107: wf_engine.SetItemAttrDate(itemtype, itemkey, 'PO_END_DATE',l_end_date);
108: wf_engine.SetItemAttrNumber(itemtype,itemkey,'PO_INTERFACE_HEADER_ID',l_interface_header_id);
109: wf_engine.SetItemAttrNumber(itemtype,itemkey,'PO_INTERFACE_LINE_ID',l_interface_line_id);
110: wf_engine.SetItemAttrNumber(itemtype,itemkey,'PO_LINE_NUM',l_new_line_num);
111: l_process_po := 'Y';

Line 108: wf_engine.SetItemAttrNumber(itemtype,itemkey,'PO_INTERFACE_HEADER_ID',l_interface_header_id);

104: wf_engine.SetItemAttrNumber(itemtype, itemkey,'PO_LINE_ITEM_ID',l_item_id);
105: wf_engine.SetItemAttrText(itemtype , itemkey, 'PO_APPROVED_FLAG',l_approved_flag);
106: wf_engine.SetItemAttrDate(itemtype,itemkey,'PO_START_DATE',l_start_date);
107: wf_engine.SetItemAttrDate(itemtype, itemkey, 'PO_END_DATE',l_end_date);
108: wf_engine.SetItemAttrNumber(itemtype,itemkey,'PO_INTERFACE_HEADER_ID',l_interface_header_id);
109: wf_engine.SetItemAttrNumber(itemtype,itemkey,'PO_INTERFACE_LINE_ID',l_interface_line_id);
110: wf_engine.SetItemAttrNumber(itemtype,itemkey,'PO_LINE_NUM',l_new_line_num);
111: l_process_po := 'Y';
112: end if;

Line 109: wf_engine.SetItemAttrNumber(itemtype,itemkey,'PO_INTERFACE_LINE_ID',l_interface_line_id);

105: wf_engine.SetItemAttrText(itemtype , itemkey, 'PO_APPROVED_FLAG',l_approved_flag);
106: wf_engine.SetItemAttrDate(itemtype,itemkey,'PO_START_DATE',l_start_date);
107: wf_engine.SetItemAttrDate(itemtype, itemkey, 'PO_END_DATE',l_end_date);
108: wf_engine.SetItemAttrNumber(itemtype,itemkey,'PO_INTERFACE_HEADER_ID',l_interface_header_id);
109: wf_engine.SetItemAttrNumber(itemtype,itemkey,'PO_INTERFACE_LINE_ID',l_interface_line_id);
110: wf_engine.SetItemAttrNumber(itemtype,itemkey,'PO_LINE_NUM',l_new_line_num);
111: l_process_po := 'Y';
112: end if;
113:

Line 110: wf_engine.SetItemAttrNumber(itemtype,itemkey,'PO_LINE_NUM',l_new_line_num);

106: wf_engine.SetItemAttrDate(itemtype,itemkey,'PO_START_DATE',l_start_date);
107: wf_engine.SetItemAttrDate(itemtype, itemkey, 'PO_END_DATE',l_end_date);
108: wf_engine.SetItemAttrNumber(itemtype,itemkey,'PO_INTERFACE_HEADER_ID',l_interface_header_id);
109: wf_engine.SetItemAttrNumber(itemtype,itemkey,'PO_INTERFACE_LINE_ID',l_interface_line_id);
110: wf_engine.SetItemAttrNumber(itemtype,itemkey,'PO_LINE_NUM',l_new_line_num);
111: l_process_po := 'Y';
112: end if;
113:
114:

Line 115: resultout := wf_engine.eng_completed || ':' || l_process_po;

111: l_process_po := 'Y';
112: end if;
113:
114:
115: resultout := wf_engine.eng_completed || ':' || l_process_po;
116: x_progress := ': 02. Result= ' || l_process_po;
117: IF (g_po_wf_debug = 'Y') THEN
118: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
119: END IF;

Line 126: resultout := wf_engine.eng_completed || ':' || l_process_po;

122: WHEN OTHERS THEN
123: l_process_po := 'N';
124: x_progress := ': 03. Result= ' || l_process_po;
125: --PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
126: resultout := wf_engine.eng_completed || ':' || l_process_po;
127:
128: END PROCESS_PO_LINES_FOR_SR_ASL;
129:
130: PROCEDURE GET_LINE_FOR_PROCESS

Line 271: l_interface_header_id := wf_engine.GetItemAttrNumber (itemtype, itemkey,'PO_INTERFACE_HEADER_ID');

267: IF (g_po_wf_debug = 'Y') THEN
268: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
269: END IF;
270:
271: l_interface_header_id := wf_engine.GetItemAttrNumber (itemtype, itemkey,'PO_INTERFACE_HEADER_ID');
272:
273: l_interface_line_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'PO_INTERFACE_LINE_ID');
274:
275: l_item_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'PO_LINE_ITEM_ID');

Line 273: l_interface_line_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'PO_INTERFACE_LINE_ID');

269: END IF;
270:
271: l_interface_header_id := wf_engine.GetItemAttrNumber (itemtype, itemkey,'PO_INTERFACE_HEADER_ID');
272:
273: l_interface_line_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'PO_INTERFACE_LINE_ID');
274:
275: l_item_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'PO_LINE_ITEM_ID');
276:
277: l_document_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'DOCUMENT_ID');

Line 275: l_item_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'PO_LINE_ITEM_ID');

271: l_interface_header_id := wf_engine.GetItemAttrNumber (itemtype, itemkey,'PO_INTERFACE_HEADER_ID');
272:
273: l_interface_line_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'PO_INTERFACE_LINE_ID');
274:
275: l_item_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'PO_LINE_ITEM_ID');
276:
277: l_document_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'DOCUMENT_ID');
278: l_po_line_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'PO_LINE_ID');
279:

Line 277: l_document_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'DOCUMENT_ID');

273: l_interface_line_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'PO_INTERFACE_LINE_ID');
274:
275: l_item_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'PO_LINE_ITEM_ID');
276:
277: l_document_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'DOCUMENT_ID');
278: l_po_line_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'PO_LINE_ID');
279:
280: l_document_type := wf_engine.GetItemAttrText ( itemtype, itemkey, 'DOCUMENT_TYPE');
281:

Line 278: l_po_line_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'PO_LINE_ID');

274:
275: l_item_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'PO_LINE_ITEM_ID');
276:
277: l_document_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'DOCUMENT_ID');
278: l_po_line_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'PO_LINE_ID');
279:
280: l_document_type := wf_engine.GetItemAttrText ( itemtype, itemkey, 'DOCUMENT_TYPE');
281:
282: l_rel_gen_method := wf_engine.GetItemAttrText ( itemtype, itemkey, 'RELEASE_GENERATION_METHOD');

Line 280: l_document_type := wf_engine.GetItemAttrText ( itemtype, itemkey, 'DOCUMENT_TYPE');

276:
277: l_document_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'DOCUMENT_ID');
278: l_po_line_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'PO_LINE_ID');
279:
280: l_document_type := wf_engine.GetItemAttrText ( itemtype, itemkey, 'DOCUMENT_TYPE');
281:
282: l_rel_gen_method := wf_engine.GetItemAttrText ( itemtype, itemkey, 'RELEASE_GENERATION_METHOD');
283:
284: l_sr_organization_id := Wf_Engine.GetActivityAttrNumber(itemtype, itemkey, actid, 'PO_SR_ORGANIZATION_ID');

Line 282: l_rel_gen_method := wf_engine.GetItemAttrText ( itemtype, itemkey, 'RELEASE_GENERATION_METHOD');

278: l_po_line_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'PO_LINE_ID');
279:
280: l_document_type := wf_engine.GetItemAttrText ( itemtype, itemkey, 'DOCUMENT_TYPE');
281:
282: l_rel_gen_method := wf_engine.GetItemAttrText ( itemtype, itemkey, 'RELEASE_GENERATION_METHOD');
283:
284: l_sr_organization_id := Wf_Engine.GetActivityAttrNumber(itemtype, itemkey, actid, 'PO_SR_ORGANIZATION_ID');
285:
286: l_category_id := Wf_Engine.GetActivityAttrNumber(itemtype, itemkey, actid, 'PO_ASL_CATEGORY_ID');

Line 284: l_sr_organization_id := Wf_Engine.GetActivityAttrNumber(itemtype, itemkey, actid, 'PO_SR_ORGANIZATION_ID');

280: l_document_type := wf_engine.GetItemAttrText ( itemtype, itemkey, 'DOCUMENT_TYPE');
281:
282: l_rel_gen_method := wf_engine.GetItemAttrText ( itemtype, itemkey, 'RELEASE_GENERATION_METHOD');
283:
284: l_sr_organization_id := Wf_Engine.GetActivityAttrNumber(itemtype, itemkey, actid, 'PO_SR_ORGANIZATION_ID');
285:
286: l_category_id := Wf_Engine.GetActivityAttrNumber(itemtype, itemkey, actid, 'PO_ASL_CATEGORY_ID');
287:
288:

Line 286: l_category_id := Wf_Engine.GetActivityAttrNumber(itemtype, itemkey, actid, 'PO_ASL_CATEGORY_ID');

282: l_rel_gen_method := wf_engine.GetItemAttrText ( itemtype, itemkey, 'RELEASE_GENERATION_METHOD');
283:
284: l_sr_organization_id := Wf_Engine.GetActivityAttrNumber(itemtype, itemkey, actid, 'PO_SR_ORGANIZATION_ID');
285:
286: l_category_id := Wf_Engine.GetActivityAttrNumber(itemtype, itemkey, actid, 'PO_ASL_CATEGORY_ID');
287:
288:
289: /* GA FPI start */
290: /* Check if the document is a global agreement */

Line 347: resultout := wf_engine.eng_completed || ':' || l_create_asl;

343: x_progress := ': 02. Result= ' || l_create_asl;
344: IF (g_po_wf_debug = 'Y') THEN
345: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
346: END IF;
347: resultout := wf_engine.eng_completed || ':' || l_create_asl;
348:
349: EXCEPTION
350: WHEN OTHERS THEN
351: l_create_asl := 'Y';

Line 356: resultout := wf_engine.eng_completed || ':' || l_create_asl;

352: x_progress := ': 03. Result= ' || l_create_asl;
353: IF (g_po_wf_debug = 'Y') THEN
354: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
355: END IF;
356: resultout := wf_engine.eng_completed || ':' || l_create_asl;
357: END Create_ASL;
358:
359:
360: procedure Create_Sourcing_Rule(itemtype in varchar2,

Line 394: l_interface_header_id := wf_engine.GetItemAttrNumber (itemtype, itemkey,'PO_INTERFACE_HEADER_ID');

390: IF (g_po_wf_debug = 'Y') THEN
391: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
392: END IF;
393:
394: l_interface_header_id := wf_engine.GetItemAttrNumber (itemtype, itemkey,'PO_INTERFACE_HEADER_ID');
395:
396: l_interface_line_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'PO_INTERFACE_LINE_ID');
397:
398: l_item_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'PO_LINE_ITEM_ID');

Line 396: l_interface_line_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'PO_INTERFACE_LINE_ID');

392: END IF;
393:
394: l_interface_header_id := wf_engine.GetItemAttrNumber (itemtype, itemkey,'PO_INTERFACE_HEADER_ID');
395:
396: l_interface_line_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'PO_INTERFACE_LINE_ID');
397:
398: l_item_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'PO_LINE_ITEM_ID');
399:
400: l_vendor_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'PO_VENDOR_ID');

Line 398: l_item_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'PO_LINE_ITEM_ID');

394: l_interface_header_id := wf_engine.GetItemAttrNumber (itemtype, itemkey,'PO_INTERFACE_HEADER_ID');
395:
396: l_interface_line_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'PO_INTERFACE_LINE_ID');
397:
398: l_item_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'PO_LINE_ITEM_ID');
399:
400: l_vendor_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'PO_VENDOR_ID');
401:
402: l_document_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'DOCUMENT_ID');

Line 400: l_vendor_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'PO_VENDOR_ID');

396: l_interface_line_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'PO_INTERFACE_LINE_ID');
397:
398: l_item_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'PO_LINE_ITEM_ID');
399:
400: l_vendor_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'PO_VENDOR_ID');
401:
402: l_document_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'DOCUMENT_ID');
403:
404: l_po_line_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'PO_LINE_ID');

Line 402: l_document_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'DOCUMENT_ID');

398: l_item_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'PO_LINE_ITEM_ID');
399:
400: l_vendor_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'PO_VENDOR_ID');
401:
402: l_document_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'DOCUMENT_ID');
403:
404: l_po_line_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'PO_LINE_ID');
405:
406: l_document_type := wf_engine.GetItemAttrText ( itemtype, itemkey, 'DOCUMENT_TYPE');

Line 404: l_po_line_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'PO_LINE_ID');

400: l_vendor_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'PO_VENDOR_ID');
401:
402: l_document_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'DOCUMENT_ID');
403:
404: l_po_line_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'PO_LINE_ID');
405:
406: l_document_type := wf_engine.GetItemAttrText ( itemtype, itemkey, 'DOCUMENT_TYPE');
407:
408: l_approved_flag := wf_engine.GetItemAttrText (itemtype, itemkey, 'PO_APPROVED_FLAG');

Line 406: l_document_type := wf_engine.GetItemAttrText ( itemtype, itemkey, 'DOCUMENT_TYPE');

402: l_document_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'DOCUMENT_ID');
403:
404: l_po_line_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'PO_LINE_ID');
405:
406: l_document_type := wf_engine.GetItemAttrText ( itemtype, itemkey, 'DOCUMENT_TYPE');
407:
408: l_approved_flag := wf_engine.GetItemAttrText (itemtype, itemkey, 'PO_APPROVED_FLAG');
409:
410: l_start_date := wf_engine.GetItemAttrDate(itemtype, itemkey, 'PO_START_DATE');

Line 408: l_approved_flag := wf_engine.GetItemAttrText (itemtype, itemkey, 'PO_APPROVED_FLAG');

404: l_po_line_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'PO_LINE_ID');
405:
406: l_document_type := wf_engine.GetItemAttrText ( itemtype, itemkey, 'DOCUMENT_TYPE');
407:
408: l_approved_flag := wf_engine.GetItemAttrText (itemtype, itemkey, 'PO_APPROVED_FLAG');
409:
410: l_start_date := wf_engine.GetItemAttrDate(itemtype, itemkey, 'PO_START_DATE');
411:
412: l_end_date := wf_engine.GetItemAttrDate(itemtype, itemkey, 'PO_END_DATE');

Line 410: l_start_date := wf_engine.GetItemAttrDate(itemtype, itemkey, 'PO_START_DATE');

406: l_document_type := wf_engine.GetItemAttrText ( itemtype, itemkey, 'DOCUMENT_TYPE');
407:
408: l_approved_flag := wf_engine.GetItemAttrText (itemtype, itemkey, 'PO_APPROVED_FLAG');
409:
410: l_start_date := wf_engine.GetItemAttrDate(itemtype, itemkey, 'PO_START_DATE');
411:
412: l_end_date := wf_engine.GetItemAttrDate(itemtype, itemkey, 'PO_END_DATE');
413:
414: l_sr_organization_id := Wf_Engine.GetActivityAttrNumber(itemtype, itemkey, actid, 'PO_SR_ORGANIZATION_ID');

Line 412: l_end_date := wf_engine.GetItemAttrDate(itemtype, itemkey, 'PO_END_DATE');

408: l_approved_flag := wf_engine.GetItemAttrText (itemtype, itemkey, 'PO_APPROVED_FLAG');
409:
410: l_start_date := wf_engine.GetItemAttrDate(itemtype, itemkey, 'PO_START_DATE');
411:
412: l_end_date := wf_engine.GetItemAttrDate(itemtype, itemkey, 'PO_END_DATE');
413:
414: l_sr_organization_id := Wf_Engine.GetActivityAttrNumber(itemtype, itemkey, actid, 'PO_SR_ORGANIZATION_ID');
415:
416: l_assignment_type_id := Wf_Engine.GetActivityAttrNumber(itemtype, itemkey, actid, 'PO_SR_ASSIGNMENT_TYPE_ID');

Line 414: l_sr_organization_id := Wf_Engine.GetActivityAttrNumber(itemtype, itemkey, actid, 'PO_SR_ORGANIZATION_ID');

410: l_start_date := wf_engine.GetItemAttrDate(itemtype, itemkey, 'PO_START_DATE');
411:
412: l_end_date := wf_engine.GetItemAttrDate(itemtype, itemkey, 'PO_END_DATE');
413:
414: l_sr_organization_id := Wf_Engine.GetActivityAttrNumber(itemtype, itemkey, actid, 'PO_SR_ORGANIZATION_ID');
415:
416: l_assignment_type_id := Wf_Engine.GetActivityAttrNumber(itemtype, itemkey, actid, 'PO_SR_ASSIGNMENT_TYPE_ID');
417:
418: l_rule_prefix := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'PO_SR_RULENAME_PREFIX');

Line 416: l_assignment_type_id := Wf_Engine.GetActivityAttrNumber(itemtype, itemkey, actid, 'PO_SR_ASSIGNMENT_TYPE_ID');

412: l_end_date := wf_engine.GetItemAttrDate(itemtype, itemkey, 'PO_END_DATE');
413:
414: l_sr_organization_id := Wf_Engine.GetActivityAttrNumber(itemtype, itemkey, actid, 'PO_SR_ORGANIZATION_ID');
415:
416: l_assignment_type_id := Wf_Engine.GetActivityAttrNumber(itemtype, itemkey, actid, 'PO_SR_ASSIGNMENT_TYPE_ID');
417:
418: l_rule_prefix := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'PO_SR_RULENAME_PREFIX');
419:
420: l_create_sourcing_rule_flag := wf_engine.GetItemAttrText(itemtype, itemkey, 'CREATE_SOURCING_RULE');

Line 418: l_rule_prefix := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'PO_SR_RULENAME_PREFIX');

414: l_sr_organization_id := Wf_Engine.GetActivityAttrNumber(itemtype, itemkey, actid, 'PO_SR_ORGANIZATION_ID');
415:
416: l_assignment_type_id := Wf_Engine.GetActivityAttrNumber(itemtype, itemkey, actid, 'PO_SR_ASSIGNMENT_TYPE_ID');
417:
418: l_rule_prefix := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'PO_SR_RULENAME_PREFIX');
419:
420: l_create_sourcing_rule_flag := wf_engine.GetItemAttrText(itemtype, itemkey, 'CREATE_SOURCING_RULE');
421:
422: l_update_sourcing_rule_flag := wf_engine.GetItemAttrText(itemtype, itemkey, 'UPDATE_SOURCING_RULE');

Line 420: l_create_sourcing_rule_flag := wf_engine.GetItemAttrText(itemtype, itemkey, 'CREATE_SOURCING_RULE');

416: l_assignment_type_id := Wf_Engine.GetActivityAttrNumber(itemtype, itemkey, actid, 'PO_SR_ASSIGNMENT_TYPE_ID');
417:
418: l_rule_prefix := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'PO_SR_RULENAME_PREFIX');
419:
420: l_create_sourcing_rule_flag := wf_engine.GetItemAttrText(itemtype, itemkey, 'CREATE_SOURCING_RULE');
421:
422: l_update_sourcing_rule_flag := wf_engine.GetItemAttrText(itemtype, itemkey, 'UPDATE_SOURCING_RULE');
423:
424: if l_create_sourcing_rule_flag = 'Y' then

Line 422: l_update_sourcing_rule_flag := wf_engine.GetItemAttrText(itemtype, itemkey, 'UPDATE_SOURCING_RULE');

418: l_rule_prefix := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'PO_SR_RULENAME_PREFIX');
419:
420: l_create_sourcing_rule_flag := wf_engine.GetItemAttrText(itemtype, itemkey, 'CREATE_SOURCING_RULE');
421:
422: l_update_sourcing_rule_flag := wf_engine.GetItemAttrText(itemtype, itemkey, 'UPDATE_SOURCING_RULE');
423:
424: if l_create_sourcing_rule_flag = 'Y' then
425: l_create_update_flag := 'CREATE';
426: end if;

Line 463: resultout := wf_engine.eng_completed || ':' || l_create_sr;

459: x_progress := ': 02. Result= ' || l_create_sr;
460: IF (g_po_wf_debug = 'Y') THEN
461: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
462: END IF;
463: resultout := wf_engine.eng_completed || ':' || l_create_sr;
464:
465: EXCEPTION
466: WHEN OTHERS THEN
467: l_create_sr := 'Y';

Line 472: resultout := wf_engine.eng_completed || ':' || l_create_sr;

468: x_progress := ': 03. Result= ' || l_create_sr;
469: IF (g_po_wf_debug = 'Y') THEN
470: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
471: END IF;
472: resultout := wf_engine.eng_completed || ':' || l_create_sr;
473: END Create_Sourcing_Rule;
474:
475:
476: --