DBA Data[Home] [Help]

APPS.FUN_MULTI_SYSTEM_WF_PKG dependencies on WF_ENGINE

Line 90: l_resp_id := wf_engine.GetItemAttrNumber

86: WHERE batch_id = p_batch_id;
87:
88:
89: BEGIN
90: l_resp_id := wf_engine.GetItemAttrNumber
91: (itemtype => itemtype,
92: itemkey => itemkey,
93: aname =>'RESP_ID');
94: l_user_id := wf_engine.GetItemAttrNumber

Line 94: l_user_id := wf_engine.GetItemAttrNumber

90: l_resp_id := wf_engine.GetItemAttrNumber
91: (itemtype => itemtype,
92: itemkey => itemkey,
93: aname =>'RESP_ID');
94: l_user_id := wf_engine.GetItemAttrNumber
95: (itemtype => itemtype,
96: itemkey => itemkey,
97: aname =>'USER_ID');
98: l_appl_id := wf_engine.GetItemAttrNumber

Line 98: l_appl_id := wf_engine.GetItemAttrNumber

94: l_user_id := wf_engine.GetItemAttrNumber
95: (itemtype => itemtype,
96: itemkey => itemkey,
97: aname =>'USER_ID');
98: l_appl_id := wf_engine.GetItemAttrNumber
99: (itemtype => itemtype,
100: itemkey => itemkey,
101: aname =>'APPL_ID');
102: l_user_env_lang := wf_engine.GetItemAttrText

Line 102: l_user_env_lang := wf_engine.GetItemAttrText

98: l_appl_id := wf_engine.GetItemAttrNumber
99: (itemtype => itemtype,
100: itemkey => itemkey,
101: aname =>'APPL_ID');
102: l_user_env_lang := wf_engine.GetItemAttrText
103: (itemtype => itemtype,
104: itemkey => itemkey,
105: aname => 'USER_LANG');
106:

Line 111: l_batch_id := wf_engine.getitemattrnumber(itemtype,

107: if(funcmode='RUN') then
108:
109: -- get the batch_id from the item attributes
110:
111: l_batch_id := wf_engine.getitemattrnumber(itemtype,
112: itemkey,
113: 'BATCH_ID');
114:
115: -- open the cursor, and raise the business event for each recipient

Line 245: l_batch_id := wf_engine.getitemattrnumber(itemtype,

241: -- Currently we do not need additional attributes. This may change
242: -- when handling the remote instances case.
243:
244: -- get the item attributes from the WF
245: l_batch_id := wf_engine.getitemattrnumber(itemtype,
246: itemkey,
247: 'BATCH_ID');
248:
249: -- We only need to check if invoice is required and set the

Line 307: wf_engine.setitemattrnumber(itemtype,

303: IF (funcmode = 'RUN') THEN
304:
305: -- Set the attribute to zero
306:
307: wf_engine.setitemattrnumber(itemtype,
308: itemkey,
309: 'NUM_REMOTE_INSTANCE',
310: 0);
311:

Line 376: l_batch_id := wf_engine.getitemattrnumber(itemtype,

372:
373: IF (funcmode = 'RUN') THEN
374:
375: -- get the item attributes from the WF
376: l_batch_id := wf_engine.getitemattrnumber(itemtype,
377: itemkey,
378: 'BATCH_ID');
379:
380: l_trx_id := wf_engine.getitemattrnumber(itemtype,

Line 380: l_trx_id := wf_engine.getitemattrnumber(itemtype,

376: l_batch_id := wf_engine.getitemattrnumber(itemtype,
377: itemkey,
378: 'BATCH_ID');
379:
380: l_trx_id := wf_engine.getitemattrnumber(itemtype,
381: itemkey,
382: 'TRX_ID');
383:
384: l_event_name := wf_engine.getitemattrtext (itemtype,

Line 384: l_event_name := wf_engine.getitemattrtext (itemtype,

380: l_trx_id := wf_engine.getitemattrnumber(itemtype,
381: itemkey,
382: 'TRX_ID');
383:
384: l_event_name := wf_engine.getitemattrtext (itemtype,
385: itemkey,
386: 'EVENT_NAME');
387:
388: -- obtain the initiator_id and recipient_id

Line 416: l_invoice_num := wf_engine.getitemattrtext (itemtype,

412: then
413: l_tp_party_id :=l_recipient_id;
414:
415: -- get the Invoice Number
416: l_invoice_num := wf_engine.getitemattrtext (itemtype,
417: itemkey,
418: 'INVOICE_NUM');
419:
420:

Line 441: wf_engine.setitemattrtext(itemtype,

437: -- temp solution
438: l_event_key :=to_char(l_batch_id) || '_' || to_char(l_trx_id) || SYS_GUID();
439:
440: --set the WF item value
441: wf_engine.setitemattrtext(itemtype,
442: itemkey,
443: 'RECEIVE_EVENT_NAME',
444: l_new_event_name);
445:

Line 446: wf_engine.setitemattrtext(itemtype,

442: itemkey,
443: 'RECEIVE_EVENT_NAME',
444: l_new_event_name);
445:
446: wf_engine.setitemattrtext(itemtype,
447: itemkey,
448: 'LOCAL_EVT_KEY',
449: l_event_key);
450: wf_engine.setitemattrtext(itemtype,

Line 450: wf_engine.setitemattrtext(itemtype,

446: wf_engine.setitemattrtext(itemtype,
447: itemkey,
448: 'LOCAL_EVT_KEY',
449: l_event_key);
450: wf_engine.setitemattrtext(itemtype,
451: itemkey,
452: 'INVOICE_NUM',
453: l_invoice_num);
454: else