DBA Data[Home] [Help]

APPS.POR_AME_RCO_WF_PVT dependencies on WF_ENGINE

Line 240: n_varname Wf_Engine.NameTabTyp;

236: l_org_id number;
237: l_functional_currency VARCHAR2(30);
238: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
239:
240: n_varname Wf_Engine.NameTabTyp;
241: n_varval Wf_Engine.NumTabTyp;
242:
243: t_varname Wf_Engine.NameTabTyp;
244: t_varval Wf_Engine.TextTabTyp;

Line 241: n_varval Wf_Engine.NumTabTyp;

237: l_functional_currency VARCHAR2(30);
238: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
239:
240: n_varname Wf_Engine.NameTabTyp;
241: n_varval Wf_Engine.NumTabTyp;
242:
243: t_varname Wf_Engine.NameTabTyp;
244: t_varval Wf_Engine.TextTabTyp;
245:

Line 243: t_varname Wf_Engine.NameTabTyp;

239:
240: n_varname Wf_Engine.NameTabTyp;
241: n_varval Wf_Engine.NumTabTyp;
242:
243: t_varname Wf_Engine.NameTabTyp;
244: t_varval Wf_Engine.TextTabTyp;
245:
246: l_no_positionholder exception;
247: l_preparer_user_name fnd_user.user_name%TYPE;

Line 244: t_varval Wf_Engine.TextTabTyp;

240: n_varname Wf_Engine.NameTabTyp;
241: n_varval Wf_Engine.NumTabTyp;
242:
243: t_varname Wf_Engine.NameTabTyp;
244: t_varval Wf_Engine.TextTabTyp;
245:
246: l_no_positionholder exception;
247: l_preparer_user_name fnd_user.user_name%TYPE;
248: l_doc_string varchar2(200);

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

288: INTO l_item_key
289: FROM sys.dual;
290:
291: -- Create a child process for the retrieved approver.
292: wf_engine.CreateProcess( itemtype => itemtype,
293: itemkey => l_item_key,
294: process => 'RCO_AME_PARALLEL_APPROVAL');
295:
296:

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

294: process => 'RCO_AME_PARALLEL_APPROVAL');
295:
296:
297: /* Need to set the parent child relationship between processes */
298: wf_engine.SetItemParent( itemtype => itemtype,
299: itemkey => l_item_key,
300: parent_itemtype => itemtype,
301: parent_itemkey => itemkey,
302: parent_context => NULL);

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

473: l_start_block_activity := 'Y';
474: end if;
475:
476: -- Set the item attributes.
477: Wf_Engine.SetItemAttrTextArray(itemtype, l_item_key,t_varname,t_varval);
478:
479: n_varname(1) := 'DOCUMENT_ID';
480: n_varval(1) := l_document_id;
481:

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

493:
494: n_varname(6) := 'CHANGE_REQUEST_GROUP_ID';
495: n_varval(6) := l_change_request_group_id;
496:
497: Wf_Engine.SetItemAttrNumberArray(itemtype, l_item_key,n_varname,n_varval);
498:
499: l_progress := 'Launch_Parallel_Approval: 005 -- Launch Parallel Approval';
500: IF (g_po_wf_debug = 'Y') THEN
501: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);

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

499: l_progress := 'Launch_Parallel_Approval: 005 -- Launch Parallel Approval';
500: IF (g_po_wf_debug = 'Y') THEN
501: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
502: END IF;
503: wf_engine.StartProcess( itemtype => itemtype,
504: itemkey => l_item_key );
505:
506: l_approver_index := g_next_approvers.next(l_approver_index);
507:

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

831: itemkey => l_parent_item_key,
832: aname => 'AME_SUB_APPROVAL_RESPONSE',
833: avalue => 'REJECT');
834:
835: wf_engine.CompleteActivity (itemtype => l_parent_item_type,
836: itemkey => l_parent_item_key,
837: activity => 'BLOCK',
838: result => null);
839:

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

1431: BEGIN
1432:
1433: x_progress := 'POR_AME_RCO_WF_PVT.Set_Rco_Stat_Approved: 01';
1434:
1435: if (funcmode <> wf_engine.eng_run) then
1436: resultout := wf_engine.eng_null;
1437: return;
1438: end if;
1439:

Line 1436: resultout := wf_engine.eng_null;

1432:
1433: x_progress := 'POR_AME_RCO_WF_PVT.Set_Rco_Stat_Approved: 01';
1434:
1435: if (funcmode <> wf_engine.eng_run) then
1436: resultout := wf_engine.eng_null;
1437: return;
1438: end if;
1439:
1440: l_doc_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 1440: l_doc_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1436: resultout := wf_engine.eng_null;
1437: return;
1438: end if;
1439:
1440: l_doc_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1441: itemkey => itemkey,
1442: aname => 'DOCUMENT_ID');
1443:
1444: l_doc_type := wf_engine.GetItemAttrText( itemtype => itemtype,

Line 1444: l_doc_type := wf_engine.GetItemAttrText( itemtype => itemtype,

1440: l_doc_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1441: itemkey => itemkey,
1442: aname => 'DOCUMENT_ID');
1443:
1444: l_doc_type := wf_engine.GetItemAttrText( itemtype => itemtype,
1445: itemkey => itemkey,
1446: aname => 'DOCUMENT_TYPE');
1447:
1448: x_progress := 'POR_AME_RCO_WF_PVT.Set_Rco_Stat_Approved: 02 - l_doc_header_id ' || l_doc_header_id || ' -- l_doc_type :' || l_doc_type ;

Line 1458: wf_engine.SetItemAttrText( itemtype => itemtype,

1454:
1455: UpdateActionHistory(l_doc_header_id, 'NO ACTION',
1456: fnd_message.get_string('ICX', 'ICX_POR_REQ_ALREADY_APPROVED'), NULL);
1457:
1458: wf_engine.SetItemAttrText( itemtype => itemtype,
1459: itemkey => itemkey,
1460: aname => 'AUTHORIZATION_STATUS',
1461: avalue => 'APPROVED');
1462:

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

1459: itemkey => itemkey,
1460: aname => 'AUTHORIZATION_STATUS',
1461: avalue => 'APPROVED');
1462:
1463: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
1464:
1465: x_progress := 'POR_AME_RCO_WF_PVT.Set_Rco_Stat_Approved: 03';
1466: IF (g_po_wf_debug = 'Y') THEN
1467: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

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

1518: BEGIN
1519:
1520: x_progress := 'POR_AME_RCO_WF_PVT.Set_Rco_Stat_Rejected: 01';
1521:
1522: if (funcmode <> wf_engine.eng_run) then
1523: resultout := wf_engine.eng_null;
1524: return;
1525: end if;
1526:

Line 1523: resultout := wf_engine.eng_null;

1519:
1520: x_progress := 'POR_AME_RCO_WF_PVT.Set_Rco_Stat_Rejected: 01';
1521:
1522: if (funcmode <> wf_engine.eng_run) then
1523: resultout := wf_engine.eng_null;
1524: return;
1525: end if;
1526:
1527: l_doc_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 1527: l_doc_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1523: resultout := wf_engine.eng_null;
1524: return;
1525: end if;
1526:
1527: l_doc_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1528: itemkey => itemkey,
1529: aname => 'DOCUMENT_ID');
1530:
1531: x_progress := 'POR_AME_RCO_WF_PVT.Set_Rco_Stat_Rejected: 02 - l_doc_header_id ' || l_doc_header_id;

Line 1541: wf_engine.SetItemAttrText( itemtype => itemtype,

1537:
1538: UpdateActionHistory(l_doc_header_id, 'NO ACTION',
1539: fnd_message.get_string('ICX', 'ICX_POR_REQ_ALREADY_REJECTED'), NULL);
1540:
1541: wf_engine.SetItemAttrText( itemtype => itemtype,
1542: itemkey => itemkey,
1543: aname => 'AUTHORIZATION_STATUS',
1544: avalue => 'REJECTED');
1545:

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

1542: itemkey => itemkey,
1543: aname => 'AUTHORIZATION_STATUS',
1544: avalue => 'REJECTED');
1545:
1546: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
1547:
1548: x_progress := 'POR_AME_RCO_WF_PVT.Set_Rco_Stat_Rejected: 03';
1549: IF (g_po_wf_debug = 'Y') THEN
1550: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);