DBA Data[Home] [Help]

APPS.PO_REQAPPROVAL_LAUNCH dependencies on WF_ENGINE

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

47:
48:
49: -- Do nothing in cancel or timeout mode
50: --
51: if (funcmode <> wf_engine.eng_run) then
52:
53: resultout := wf_engine.eng_null;
54: return;
55:

Line 53: resultout := wf_engine.eng_null;

49: -- Do nothing in cancel or timeout mode
50: --
51: if (funcmode <> wf_engine.eng_run) then
52:
53: resultout := wf_engine.eng_null;
54: return;
55:
56: end if;
57:

Line 62: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

58:
59: LaunchCreatePOWF(itemtype, itemkey);
60:
61: --
62: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
63: --
64:
65:
66: EXCEPTION

Line 96: l_requisition_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

92: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
93: END IF;
94:
95:
96: l_requisition_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
97: itemkey => itemkey,
98: aname => 'DOCUMENT_ID');
99:
100: /* This is used for integration with Web Requisitions. Web requisition has

Line 109: l_emergency_po_num := wf_engine.GetItemAttrText (itemtype => itemtype,

105: ** approval. If the requisition is approved and we get to this point, then
106: ** we pass this PO NUMBER to the CREATE_PO workflow, which will create a
107: ** STANDARD PO using this PO NUMBER as SEGMENT1.
108: */
109: l_emergency_po_num := wf_engine.GetItemAttrText (itemtype => itemtype,
110: itemkey => itemkey,
111: aname => 'EMERGENCY_PO_NUMBER');
112:
113:

Line 160: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,

156: BEGIN
157:
158:
159: /* Get the org context */
160: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,
161: itemkey => itemkey,
162: aname => 'ORG_ID');
163:
164: IF l_orgid is NOT NULL THEN

Line 170: l_user_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

166: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
167:
168: END IF;
169:
170: l_user_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
171: itemkey => itemkey,
172: aname => 'USER_ID');
173:
174: l_resp_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 174: l_resp_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

170: l_user_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
171: itemkey => itemkey,
172: aname => 'USER_ID');
173:
174: l_resp_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
175: itemkey => itemkey,
176: aname => 'RESPONSIBILITY_ID');
177:
178: l_appl_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 178: l_appl_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

174: l_resp_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
175: itemkey => itemkey,
176: aname => 'RESPONSIBILITY_ID');
177:
178: l_appl_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
179: itemkey => itemkey,
180: aname => 'APPLICATION_ID');
181:
182: /* Since the call may be started from background engine (new seesion),

Line 236: l_interface_source := wf_engine.GetItemAttrNumber

232: * We also need to pass in the interface_source_code into the
233: * start_wf_process for the create document process.
234: */
235:
236: l_interface_source := wf_engine.GetItemAttrNumber
237: (itemtype => itemtype,
238: itemkey => itemkey,
239: aname => 'INTERFACE_SOURCE_CODE');
240:

Line 422: if (wf_engine.preserved_context = TRUE) then

418: -- context. This is required since the mailer/bckgrnd ps carries the
419: -- context from the last wf processed and hence even if the context values
420: -- are present, they might not be correct.
421:
422: if (wf_engine.preserved_context = TRUE) then
423: p_x_result := 'TRUE';
424: else
425: p_x_result:= 'NOTSET';
426: end if;

Line 448: l_resp_id_to_set :=wf_engine.GetItemAttrNumber (

444:
445: ELSIF (p_funcmode = 'SET_CTX') THEN
446: if l_responder_id is not null then
447: l_user_id_to_set := l_responder_id;
448: l_resp_id_to_set :=wf_engine.GetItemAttrNumber (
449: itemtype => p_itemtype,
450: itemkey => p_itemkey,
451: aname => 'RESPONDER_RESP_ID');
452: l_appl_id_to_set :=wf_engine.GetItemAttrNumber (

Line 452: l_appl_id_to_set :=wf_engine.GetItemAttrNumber (

448: l_resp_id_to_set :=wf_engine.GetItemAttrNumber (
449: itemtype => p_itemtype,
450: itemkey => p_itemkey,
451: aname => 'RESPONDER_RESP_ID');
452: l_appl_id_to_set :=wf_engine.GetItemAttrNumber (
453: itemtype => p_itemtype,
454: itemkey => p_itemkey,
455: aname => 'RESPONDER_APPL_ID');
456: --

Line 472: l_user_id_to_set := wf_engine.GetItemAttrNumber (

468: END IF;
469: --
470:
471: else
472: l_user_id_to_set := wf_engine.GetItemAttrNumber (
473: itemtype => p_itemtype,
474: itemkey => p_itemkey,
475: aname => 'USER_ID');
476: l_resp_id_to_set :=wf_engine.GetItemAttrNumber (

Line 476: l_resp_id_to_set :=wf_engine.GetItemAttrNumber (

472: l_user_id_to_set := wf_engine.GetItemAttrNumber (
473: itemtype => p_itemtype,
474: itemkey => p_itemkey,
475: aname => 'USER_ID');
476: l_resp_id_to_set :=wf_engine.GetItemAttrNumber (
477: itemtype => p_itemtype,
478: itemkey => p_itemkey,
479: aname => 'RESPONSIBILITY_ID');
480: l_appl_id_to_set :=wf_engine.GetItemAttrNumber (

Line 480: l_appl_id_to_set :=wf_engine.GetItemAttrNumber (

476: l_resp_id_to_set :=wf_engine.GetItemAttrNumber (
477: itemtype => p_itemtype,
478: itemkey => p_itemkey,
479: aname => 'RESPONSIBILITY_ID');
480: l_appl_id_to_set :=wf_engine.GetItemAttrNumber (
481: itemtype => p_itemtype,
482: itemkey => p_itemkey,
483: aname => 'APPLICATION_ID');
484: --