DBA Data[Home] [Help]

APPS.POR_AME_REQ_WF_PVT dependencies on WF_ENGINE

Line 306: n_varname Wf_Engine.NameTabTyp;

302: l_org_id number;
303: l_functional_currency VARCHAR2(30);
304: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
305:
306: n_varname Wf_Engine.NameTabTyp;
307: n_varval Wf_Engine.NumTabTyp;
308:
309: t_po_varname Wf_Engine.NameTabTyp;
310: t_po_varval Wf_Engine.TextTabTyp;

Line 307: n_varval Wf_Engine.NumTabTyp;

303: l_functional_currency VARCHAR2(30);
304: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
305:
306: n_varname Wf_Engine.NameTabTyp;
307: n_varval Wf_Engine.NumTabTyp;
308:
309: t_po_varname Wf_Engine.NameTabTyp;
310: t_po_varval Wf_Engine.TextTabTyp;
311:

Line 309: t_po_varname Wf_Engine.NameTabTyp;

305:
306: n_varname Wf_Engine.NameTabTyp;
307: n_varval Wf_Engine.NumTabTyp;
308:
309: t_po_varname Wf_Engine.NameTabTyp;
310: t_po_varval Wf_Engine.TextTabTyp;
311:
312: t_req_varname Wf_Engine.NameTabTyp;
313: t_req_varval Wf_Engine.TextTabTyp;

Line 310: t_po_varval Wf_Engine.TextTabTyp;

306: n_varname Wf_Engine.NameTabTyp;
307: n_varval Wf_Engine.NumTabTyp;
308:
309: t_po_varname Wf_Engine.NameTabTyp;
310: t_po_varval Wf_Engine.TextTabTyp;
311:
312: t_req_varname Wf_Engine.NameTabTyp;
313: t_req_varval Wf_Engine.TextTabTyp;
314:

Line 312: t_req_varname Wf_Engine.NameTabTyp;

308:
309: t_po_varname Wf_Engine.NameTabTyp;
310: t_po_varval Wf_Engine.TextTabTyp;
311:
312: t_req_varname Wf_Engine.NameTabTyp;
313: t_req_varval Wf_Engine.TextTabTyp;
314:
315: l_no_positionholder exception;
316: l_preparer_user_name fnd_user.user_name%TYPE;

Line 313: t_req_varval Wf_Engine.TextTabTyp;

309: t_po_varname Wf_Engine.NameTabTyp;
310: t_po_varval Wf_Engine.TextTabTyp;
311:
312: t_req_varname Wf_Engine.NameTabTyp;
313: t_req_varval Wf_Engine.TextTabTyp;
314:
315: l_no_positionholder exception;
316: l_preparer_user_name fnd_user.user_name%TYPE;
317: l_doc_string varchar2(200);

Line 383: wf_engine.CreateProcess( itemtype => itemtype,

379:
380: -- Create a child process for the retrieved approver.
381:
382: if l_document_type = 'REQUISITION' then
383: wf_engine.CreateProcess( itemtype => itemtype,
384: itemkey => l_item_key,
385: process => 'AME_PARALLEL_APPROVAL');
386: ELSE
387: wf_engine.CreateProcess( itemtype => itemtype,

Line 387: wf_engine.CreateProcess( itemtype => itemtype,

383: wf_engine.CreateProcess( itemtype => itemtype,
384: itemkey => l_item_key,
385: process => 'AME_PARALLEL_APPROVAL');
386: ELSE
387: wf_engine.CreateProcess( itemtype => itemtype,
388: itemkey => l_item_key,
389: process => 'PARALLEL_APPROVAL_PROCESS');
390: END IF;
391:

Line 393: wf_engine.SetItemParent( itemtype => itemtype,

389: process => 'PARALLEL_APPROVAL_PROCESS');
390: END IF;
391:
392: /* Need to set the parent child relationship between processes */
393: wf_engine.SetItemParent( itemtype => itemtype,
394: itemkey => l_item_key,
395: parent_itemtype => itemtype,
396: parent_itemkey => itemkey,
397: parent_context => NULL);

Line 831: Wf_Engine.SetItemAttrTextArray(itemtype, l_item_key,t_req_varname,t_req_varval);

827: end if;
828: -- Set the item attributes.
829: -- CLM Apprvl --
830: if l_document_type = 'REQUISITION' then
831: Wf_Engine.SetItemAttrTextArray(itemtype, l_item_key,t_req_varname,t_req_varval);
832: else
833:
834:
835: Wf_Engine.SetItemAttrTextArray(itemtype, l_item_key,t_po_varname,t_po_varval);

Line 835: Wf_Engine.SetItemAttrTextArray(itemtype, l_item_key,t_po_varname,t_po_varval);

831: Wf_Engine.SetItemAttrTextArray(itemtype, l_item_key,t_req_varname,t_req_varval);
832: else
833:
834:
835: Wf_Engine.SetItemAttrTextArray(itemtype, l_item_key,t_po_varname,t_po_varval);
836: end if;
837:
838: l_progress:= 'after setting text array';
839: IF (g_po_wf_debug = 'Y') THEN

Line 903: Wf_Engine.SetItemAttrNumberArray(itemtype, l_item_key,n_varname,n_varval);

899:
900: end if;
901:
902:
903: Wf_Engine.SetItemAttrNumberArray(itemtype, l_item_key,n_varname,n_varval);
904:
905: wf_engine.SetItemAttrDocument( itemtype => itemtype,
906: itemkey => l_item_key,
907: aname => 'ATTACHMENT',

Line 905: wf_engine.SetItemAttrDocument( itemtype => itemtype,

901:
902:
903: Wf_Engine.SetItemAttrNumberArray(itemtype, l_item_key,n_varname,n_varval);
904:
905: wf_engine.SetItemAttrDocument( itemtype => itemtype,
906: itemkey => l_item_key,
907: aname => 'ATTACHMENT',
908: documentid => ( wf_engine.GetItemAttrDocument( itemtype => itemtype,
909: itemkey => itemkey,

Line 908: documentid => ( wf_engine.GetItemAttrDocument( itemtype => itemtype,

904:
905: wf_engine.SetItemAttrDocument( itemtype => itemtype,
906: itemkey => l_item_key,
907: aname => 'ATTACHMENT',
908: documentid => ( wf_engine.GetItemAttrDocument( itemtype => itemtype,
909: itemkey => itemkey,
910: aname => 'ATTACHMENT')));
911: po_wf_util_pkg.SetItemAttrText(itemtype => itemtype,
912: itemkey => l_item_key,

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

919: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
920: END IF;
921:
922:
923: wf_engine.StartProcess( itemtype => itemtype,
924: itemkey => l_item_key );
925:
926: l_approver_index := g_next_approvers.next(l_approver_index);
927: end loop; -- end of for loop.

Line 1263: wf_engine.CompleteActivity( itemtype => l_parent_item_type,

1259: itemkey => l_parent_item_key,
1260: aname => 'AME_EXCEPTION' );
1261:
1262: IF l_ame_exception IS NOT NULL THEN
1263: wf_engine.CompleteActivity( itemtype => l_parent_item_type,
1264: itemkey => l_parent_item_key,
1265: activity => 'BLOCK',
1266: result => null);
1267: resultout:='COMPLETE' || ':' || 'ACTIVITY_PERFORMED';

Line 1467: wf_engine.AbortProcess(l_child_wf_cur.item_type ,l_child_wf_cur.item_key);

1463: -- Bug 10043085 extra condition is added to check whether the notification is a delegated one.
1464: IF ((l_child_approver_empid = l_person_id OR (l_child_wf_cur.recipient_role <> l_child_wf_cur.original_recipient)) and
1465: l_child_approver_groupid = l_approver_group_id) THEN
1466:
1467: wf_engine.AbortProcess(l_child_wf_cur.item_type ,l_child_wf_cur.item_key);
1468: EXIT;
1469:
1470: END IF;
1471:

Line 1508: wf_engine.AbortProcess(l_child_wf_cur.item_type ,l_child_wf_cur.item_key);

1504: IF (g_po_wf_debug = 'Y') THEN
1505: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
1506: END IF;
1507:
1508: wf_engine.AbortProcess(l_child_wf_cur.item_type ,l_child_wf_cur.item_key);
1509:
1510: -- update the action history table with the ICX_POR_REQ_ALREADY_APPROVED note
1511: UpdateActionHistory(l_req_header_id, 'NO ACTION',
1512: l_note, l_person_id);

Line 1539: wf_engine.AbortProcess(l_child_wf_cur.item_type ,l_child_wf_cur.item_key);

1535: IF (g_po_wf_debug = 'Y') THEN
1536: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
1537: END IF;
1538:
1539: wf_engine.AbortProcess(l_child_wf_cur.item_type ,l_child_wf_cur.item_key);
1540:
1541: -- update the action history table
1542: --Bug 12944203
1543: if l_document_type = 'REQUISITION' THEN

Line 1575: wf_engine.CompleteActivity( itemtype => l_parent_item_type,

1571: IF (g_po_wf_debug = 'Y') THEN
1572: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
1573: END IF;
1574:
1575: wf_engine.CompleteActivity( itemtype => l_parent_item_type,
1576: itemkey => l_parent_item_key,
1577: activity => 'BLOCK',
1578: result => null);
1579:

Line 1919: wf_engine.CompleteActivity (itemtype => l_parent_item_type,

1915: aname => 'APPROVER_DISPLAY_NAME',
1916: avalue => l_child_approver_display_name );
1917:
1918:
1919: wf_engine.CompleteActivity (itemtype => l_parent_item_type,
1920: itemkey => l_parent_item_key,
1921: activity => 'BLOCK',
1922: result => null);
1923:

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

3015: BEGIN
3016:
3017: x_progress := 'POR_AME_REQ_WF_PVT.Update_Action_History_No_Act: 01';
3018:
3019: if (funcmode <> wf_engine.eng_run) then
3020: resultout := wf_engine.eng_null;
3021: return;
3022: end if;
3023:

Line 3020: resultout := wf_engine.eng_null;

3016:
3017: x_progress := 'POR_AME_REQ_WF_PVT.Update_Action_History_No_Act: 01';
3018:
3019: if (funcmode <> wf_engine.eng_run) then
3020: resultout := wf_engine.eng_null;
3021: return;
3022: end if;
3023:
3024:

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

3062: UpdateActionHistory(l_doc_header_id, 'NO ACTION', l_note, NULL);
3063:
3064: END IF;
3065:
3066: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
3067:
3068: x_progress := 'POR_AME_REQ_WF_PVT.Update_Action_History_No_Act: 03';
3069: IF (g_po_wf_debug = 'Y') THEN
3070: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

Line 3185: resultout := wf_engine.eng_completed || ':' ||'Y';

3181: itemkey => itemkey,
3182: aname => 'AME_EXCEPTION');
3183:
3184: if l_ame_exception IS NOT NULL then
3185: resultout := wf_engine.eng_completed || ':' ||'Y';
3186: else
3187: resultout := wf_engine.eng_completed || ':' ||'N';
3188: end if;
3189: END IF;

Line 3187: resultout := wf_engine.eng_completed || ':' ||'N';

3183:
3184: if l_ame_exception IS NOT NULL then
3185: resultout := wf_engine.eng_completed || ':' ||'Y';
3186: else
3187: resultout := wf_engine.eng_completed || ':' ||'N';
3188: end if;
3189: END IF;
3190: EXCEPTION
3191: when others then