DBA Data[Home] [Help]

APPS.POR_AME_APPROVAL_LIST_WF1S dependencies on PO_WF_UTIL_PKG

Line 116: l_interface_source := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

112: l_transaction_type := wf_engine.GetItemAttrText (itemtype => itemtype,
113: itemkey => itemkey,
114: aname => 'AME_TRANSACTION_TYPE');
115:
116: l_interface_source := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
117: itemkey => itemkey,
118: aname => 'INTERFACE_SOURCE_CODE');
119:
120: IF ( l_transaction_type is not null) THEN

Line 147: l_forward_to := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

143: END IF;
144:
145: IF l_interface_source = 'PO_FORM' THEN
146:
147: l_forward_to := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
148: itemkey => itemkey,
149: aname => 'FORWARD_TO_ID');
150: l_progress := '002';
151: IF (g_po_wf_debug = 'Y') THEN

Line 270: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemType,

266: and document_subtype = l_document_subtype;
267:
268: if (l_transaction_type is not null) then
269:
270: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemType,
271: itemkey => itemkey,
272: aname => 'AME_TRANSACTION_TYPE',
273: avalue => l_transaction_type);
274: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemType,

Line 274: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemType,

270: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemType,
271: itemkey => itemkey,
272: aname => 'AME_TRANSACTION_TYPE',
273: avalue => l_transaction_type);
274: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemType,
275: itemkey => itemkey,
276: aname => 'IS_AME_APPROVAL',
277: avalue => 'Y');
278:

Line 282: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemType,

278:
279: resultout:='COMPLETE:'||'Y';
280:
281: else
282: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemType,
283: itemkey => itemkey,
284: aname => 'IS_AME_APPROVAL',
285: avalue => 'N');
286:

Line 358: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemType,

354: WHERE document_type_code = 'CHANGE_REQUEST'
355: and document_subtype = 'REQUISITION' ;
356: exception
357: when others then
358: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemType,
359: itemkey => itemkey,
360: aname => 'IS_AME_APPROVAL',
361: avalue => 'N');
362: return;

Line 372: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemType,

368: END IF;
369:
370: if (l_transaction_type is not null) then
371:
372: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemType,
373: itemkey => itemkey,
374: aname => 'AME_TRANSACTION_TYPE',
375: avalue => l_transaction_type);
376: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemType,

Line 376: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemType,

372: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemType,
373: itemkey => itemkey,
374: aname => 'AME_TRANSACTION_TYPE',
375: avalue => l_transaction_type);
376: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemType,
377: itemkey => itemkey,
378: aname => 'IS_AME_APPROVAL',
379: avalue => 'Y');
380:

Line 385: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemType,

381: resultout:='COMPLETE:'||'Y';
382:
383: else
384:
385: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemType,
386: itemkey => itemkey,
387: aname => 'IS_AME_APPROVAL',
388: avalue => 'N');
389: resultout:='COMPLETE:'||'N';

Line 957: po_wf_util_pkg.SetItemAttrNumber( itemtype => itemtype,

953: IF (g_po_wf_debug = 'Y') THEN
954: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
955: END IF;
956:
957: po_wf_util_pkg.SetItemAttrNumber( itemtype => itemtype,
958: itemkey => itemkey,
959: aname => 'APPROVER_EMPID',
960: avalue => l_forward_to_id
961: );

Line 972: po_wf_util_pkg.SetItemAttrText( itemtype => itemtype,

968: x_username =>l_user_name,
969: x_user_display_name => l_disp_user_name);
970:
971:
972: po_wf_util_pkg.SetItemAttrText( itemtype => itemtype,
973: itemkey => itemkey,
974: aname => 'APPROVER_USER_NAME',
975: avalue => l_user_name
976: );