DBA Data[Home] [Help]

APPS.PO_MOD_SYNC_PROCESS_PVT dependencies on PO_WF_UTIL_PKG

Line 4776: l_document_type := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,

4772: l_draftid := wf_engine.GetItemAttrNumber (itemtype => itemtype,
4773: itemkey => itemkey,
4774: aname => 'DRAFT_ID');
4775:
4776: l_document_type := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,
4777: itemkey => itemkey,
4778: aname => 'DOCUMENT_TYPE');
4779:
4780: l_document_subtype := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,

Line 4780: l_document_subtype := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,

4776: l_document_type := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,
4777: itemkey => itemkey,
4778: aname => 'DOCUMENT_TYPE');
4779:
4780: l_document_subtype := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,
4781: itemkey => itemkey,
4782: aname => 'DOCUMENT_SUBTYPE');
4783:
4784: l_document_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,

Line 4784: l_document_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,

4780: l_document_subtype := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,
4781: itemkey => itemkey,
4782: aname => 'DOCUMENT_SUBTYPE');
4783:
4784: l_document_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,
4785: itemkey => itemkey,
4786: aname => 'DOCUMENT_ID');
4787:
4788: sync_with_award_process(

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

4847: else
4848: resultout:='COMPLETE:'||'FAILURE';
4849:
4850: end if;
4851: po_wf_util_pkg.SetItemAttrText(itemtype => itemtype,
4852: itemkey => itemkey,
4853: aname => 'ONLINE_REPORT_TEXT',
4854: avalue => l_errormessage);
4855: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.sync_with_award_wf: 02'||resultout;

Line 5034: l_draft_id := po_wf_util_pkg.Getitemattrnumber (itemtype => itemtype,

5030: x_progress VARCHAR2(1000);
5031:
5032: BEGIN
5033:
5034: l_draft_id := po_wf_util_pkg.Getitemattrnumber (itemtype => itemtype,
5035: itemkey => itemkey,
5036: aname => 'DRAFT_ID');
5037:
5038: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.IS_LOCK_FOR_SGD_GEN_AVAILABLE: Draft_id: ' || l_draft_id;

Line 5100: l_draft_id := po_wf_util_pkg.Getitemattrnumber (itemtype => itemtype,

5096: l_header_base_rev_num NUMBER;
5097: draft_revision_num NUMBER;
5098: BEGIN
5099:
5100: l_draft_id := po_wf_util_pkg.Getitemattrnumber (itemtype => itemtype,
5101: itemkey => itemkey,
5102: aname => 'DRAFT_ID');
5103:
5104: --Fetch the header id

Line 5234: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemtype,

5230: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
5231: END IF;
5232:
5233:
5234: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemtype,
5235: itemkey => itemkey,
5236: aname => 'REQUEST_ID',
5237: avalue => l_request_id);
5238:

Line 5285: l_draft_id := po_wf_util_pkg.Getitemattrnumber (itemtype => itemtype,

5281: PRAGMA AUTONOMOUS_TRANSACTION ;
5282:
5283: BEGIN
5284:
5285: l_draft_id := po_wf_util_pkg.Getitemattrnumber (itemtype => itemtype,
5286: itemkey => itemkey,
5287: aname => 'DRAFT_ID');
5288:
5289: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.RELEASE_SYNC_SGD_LOCK: Draft_id: '