DBA Data[Home] [Help]

APPS.POR_AME_REQ_WF_PVT dependencies on WF_ENGINE

Line 257: n_varname Wf_Engine.NameTabTyp;

253: l_org_id number;
254: l_functional_currency VARCHAR2(30);
255: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
256:
257: n_varname Wf_Engine.NameTabTyp;
258: n_varval Wf_Engine.NumTabTyp;
259:
260: t_varname Wf_Engine.NameTabTyp;
261: t_varval Wf_Engine.TextTabTyp;

Line 258: n_varval Wf_Engine.NumTabTyp;

254: l_functional_currency VARCHAR2(30);
255: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
256:
257: n_varname Wf_Engine.NameTabTyp;
258: n_varval Wf_Engine.NumTabTyp;
259:
260: t_varname Wf_Engine.NameTabTyp;
261: t_varval Wf_Engine.TextTabTyp;
262:

Line 260: t_varname Wf_Engine.NameTabTyp;

256:
257: n_varname Wf_Engine.NameTabTyp;
258: n_varval Wf_Engine.NumTabTyp;
259:
260: t_varname Wf_Engine.NameTabTyp;
261: t_varval Wf_Engine.TextTabTyp;
262:
263: l_no_positionholder exception;
264: l_preparer_user_name fnd_user.user_name%TYPE;

Line 261: t_varval Wf_Engine.TextTabTyp;

257: n_varname Wf_Engine.NameTabTyp;
258: n_varval Wf_Engine.NumTabTyp;
259:
260: t_varname Wf_Engine.NameTabTyp;
261: t_varval Wf_Engine.TextTabTyp;
262:
263: l_no_positionholder exception;
264: l_preparer_user_name fnd_user.user_name%TYPE;
265: l_doc_string varchar2(200);

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

302: INTO l_item_key
303: FROM sys.dual;
304:
305: -- Create a child process for the retrieved approver.
306: wf_engine.CreateProcess( itemtype => itemtype,
307: itemkey => l_item_key,
308: process => 'AME_PARALLEL_APPROVAL');
309:
310:

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

308: process => 'AME_PARALLEL_APPROVAL');
309:
310:
311: /* Need to set the parent child relationship between processes */
312: wf_engine.SetItemParent( itemtype => itemtype,
313: itemkey => l_item_key,
314: parent_itemtype => itemtype,
315: parent_itemkey => itemkey,
316: parent_context => NULL);

Line 548: Wf_Engine.SetItemAttrTextArray(itemtype, l_item_key,t_varname,t_varval);

544: itemkey => itemkey,
545: aname => 'OPEN_FORM_COMMAND');
546:
547: -- Set the item attributes.
548: Wf_Engine.SetItemAttrTextArray(itemtype, l_item_key,t_varname,t_varval);
549:
550: n_varname(1) := 'DOCUMENT_ID';
551: n_varval(1) := l_document_id;
552:

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

567: else
568: n_varval(5) := g_next_approvers(l_approver_index).group_or_chain_id;
569: end if;
570:
571: Wf_Engine.SetItemAttrNumberArray(itemtype, l_item_key,n_varname,n_varval);
572:
573: wf_engine.SetItemAttrDocument( itemtype => itemtype,
574: itemkey => l_item_key,
575: aname => 'ATTACHMENT',

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

569: end if;
570:
571: Wf_Engine.SetItemAttrNumberArray(itemtype, l_item_key,n_varname,n_varval);
572:
573: wf_engine.SetItemAttrDocument( itemtype => itemtype,
574: itemkey => l_item_key,
575: aname => 'ATTACHMENT',
576: documentid => ( wf_engine.GetItemAttrDocument( itemtype => itemtype,
577: itemkey => itemkey,

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

572:
573: wf_engine.SetItemAttrDocument( itemtype => itemtype,
574: itemkey => l_item_key,
575: aname => 'ATTACHMENT',
576: documentid => ( wf_engine.GetItemAttrDocument( itemtype => itemtype,
577: itemkey => itemkey,
578: aname => 'ATTACHMENT')));
579:
580:

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

583: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
584: END IF;
585:
586:
587: wf_engine.StartProcess( itemtype => itemtype,
588: itemkey => l_item_key );
589:
590: l_approver_index := g_next_approvers.next(l_approver_index);
591: end loop; -- end of for loop.

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

849: itemkey => l_parent_item_key,
850: aname => 'AME_EXCEPTION' );
851:
852: IF l_ame_exception IS NOT NULL THEN
853: wf_engine.CompleteActivity( itemtype => l_parent_item_type,
854: itemkey => l_parent_item_key,
855: activity => 'BLOCK',
856: result => null);
857: resultout:='COMPLETE' || ':' || 'ACTIVITY_PERFORMED';

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

993:
994: IF (l_child_approver_empid = l_person_id and
995: l_child_approver_groupid = l_approver_group_id) THEN
996:
997: wf_engine.AbortProcess(l_child_wf_cur.item_type ,l_child_wf_cur.item_key);
998: EXIT;
999:
1000: END IF;
1001:

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

1028:
1029: -- Note for rejection
1030: l_note := fnd_message.get_string('ICX', 'ICX_POR_REQ_ALREADY_REJECTED');
1031:
1032: wf_engine.AbortProcess(l_child_wf_cur.item_type ,l_child_wf_cur.item_key);
1033:
1034: -- update the action history table
1035: UpdateActionHistory(l_req_header_id, 'NO ACTION',
1036: l_note, l_person_id);

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

1050: IF (g_po_wf_debug = 'Y') THEN
1051: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
1052: END IF;
1053:
1054: wf_engine.CompleteActivity( itemtype => l_parent_item_type,
1055: itemkey => l_parent_item_key,
1056: activity => 'BLOCK',
1057: result => null);
1058:

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

1394: aname => 'APPROVER_DISPLAY_NAME',
1395: avalue => l_child_approver_display_name );
1396:
1397:
1398: wf_engine.CompleteActivity (itemtype => l_parent_item_type,
1399: itemkey => l_parent_item_key,
1400: activity => 'BLOCK',
1401: result => null);
1402:

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

1982: BEGIN
1983:
1984: x_progress := 'POR_AME_REQ_WF_PVT.Update_Action_History_No_Act: 01';
1985:
1986: if (funcmode <> wf_engine.eng_run) then
1987: resultout := wf_engine.eng_null;
1988: return;
1989: end if;
1990:

Line 1987: resultout := wf_engine.eng_null;

1983:
1984: x_progress := 'POR_AME_REQ_WF_PVT.Update_Action_History_No_Act: 01';
1985:
1986: if (funcmode <> wf_engine.eng_run) then
1987: resultout := wf_engine.eng_null;
1988: return;
1989: end if;
1990:
1991:

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

2029: UpdateActionHistory(l_doc_header_id, 'NO ACTION', l_note, NULL);
2030:
2031: END IF;
2032:
2033: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
2034:
2035: x_progress := 'POR_AME_REQ_WF_PVT.Update_Action_History_No_Act: 03';
2036: IF (g_po_wf_debug = 'Y') THEN
2037: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

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

2148: itemkey => itemkey,
2149: aname => 'AME_EXCEPTION');
2150:
2151: if l_ame_exception IS NOT NULL then
2152: resultout := wf_engine.eng_completed || ':' ||'Y';
2153: else
2154: resultout := wf_engine.eng_completed || ':' ||'N';
2155: end if;
2156: END IF;

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

2150:
2151: if l_ame_exception IS NOT NULL then
2152: resultout := wf_engine.eng_completed || ':' ||'Y';
2153: else
2154: resultout := wf_engine.eng_completed || ':' ||'N';
2155: end if;
2156: END IF;
2157: EXCEPTION
2158: when others then