DBA Data[Home] [Help]

APPS.POR_AMENDMENT_PKG dependencies on PO_WF_UTIL_PKG

Line 7599: l_conformed_header_id := po_wf_util_pkg.Getitemattrnumber(itemtype => itemtype,itemkey => itemkey,aname => 'CONFORMED_HEADER_ID');

7595: resultout := wf_engine.eng_null;
7596: RETURN;
7597: END IF;
7598: l_req_encumbrance_on := po_core_s.Is_encumbrance_on(p_doc_type => 'REQUISITION',p_org_id => NULL);
7599: l_conformed_header_id := po_wf_util_pkg.Getitemattrnumber(itemtype => itemtype,itemkey => itemkey,aname => 'CONFORMED_HEADER_ID');
7600: l_revision_num := po_wf_util_pkg.Getitemattrnumber(itemtype => itemtype,itemkey => itemkey,aname => 'REVISION_NUM');
7601: l_amendment_approval := po_wf_util_pkg.Getitemattrtext(itemtype => itemtype,itemkey => itemkey,aname => 'IS_AMENDMENT_APPROVAL');
7602: l_employee_id := po_wf_util_pkg.Getitemattrnumber(itemtype => itemtype,itemkey => itemkey,aname => 'APPROVER_EMPID');
7603: l_document_id := po_wf_util_pkg.Getitemattrnumber(itemtype => itemtype,itemkey => itemkey,aname => 'DOCUMENT_ID');

Line 7600: l_revision_num := po_wf_util_pkg.Getitemattrnumber(itemtype => itemtype,itemkey => itemkey,aname => 'REVISION_NUM');

7596: RETURN;
7597: END IF;
7598: l_req_encumbrance_on := po_core_s.Is_encumbrance_on(p_doc_type => 'REQUISITION',p_org_id => NULL);
7599: l_conformed_header_id := po_wf_util_pkg.Getitemattrnumber(itemtype => itemtype,itemkey => itemkey,aname => 'CONFORMED_HEADER_ID');
7600: l_revision_num := po_wf_util_pkg.Getitemattrnumber(itemtype => itemtype,itemkey => itemkey,aname => 'REVISION_NUM');
7601: l_amendment_approval := po_wf_util_pkg.Getitemattrtext(itemtype => itemtype,itemkey => itemkey,aname => 'IS_AMENDMENT_APPROVAL');
7602: l_employee_id := po_wf_util_pkg.Getitemattrnumber(itemtype => itemtype,itemkey => itemkey,aname => 'APPROVER_EMPID');
7603: l_document_id := po_wf_util_pkg.Getitemattrnumber(itemtype => itemtype,itemkey => itemkey,aname => 'DOCUMENT_ID');
7604: l_document_type := po_wf_util_pkg.Getitemattrtext(itemtype => itemtype,itemkey => itemkey,aname => 'DOCUMENT_TYPE');

Line 7601: l_amendment_approval := po_wf_util_pkg.Getitemattrtext(itemtype => itemtype,itemkey => itemkey,aname => 'IS_AMENDMENT_APPROVAL');

7597: END IF;
7598: l_req_encumbrance_on := po_core_s.Is_encumbrance_on(p_doc_type => 'REQUISITION',p_org_id => NULL);
7599: l_conformed_header_id := po_wf_util_pkg.Getitemattrnumber(itemtype => itemtype,itemkey => itemkey,aname => 'CONFORMED_HEADER_ID');
7600: l_revision_num := po_wf_util_pkg.Getitemattrnumber(itemtype => itemtype,itemkey => itemkey,aname => 'REVISION_NUM');
7601: l_amendment_approval := po_wf_util_pkg.Getitemattrtext(itemtype => itemtype,itemkey => itemkey,aname => 'IS_AMENDMENT_APPROVAL');
7602: l_employee_id := po_wf_util_pkg.Getitemattrnumber(itemtype => itemtype,itemkey => itemkey,aname => 'APPROVER_EMPID');
7603: l_document_id := po_wf_util_pkg.Getitemattrnumber(itemtype => itemtype,itemkey => itemkey,aname => 'DOCUMENT_ID');
7604: l_document_type := po_wf_util_pkg.Getitemattrtext(itemtype => itemtype,itemkey => itemkey,aname => 'DOCUMENT_TYPE');
7605: l_document_subtype := po_wf_util_pkg.Getitemattrtext(itemtype => itemtype,itemkey => itemkey,aname => 'DOCUMENT_SUBTYPE');

Line 7602: l_employee_id := po_wf_util_pkg.Getitemattrnumber(itemtype => itemtype,itemkey => itemkey,aname => 'APPROVER_EMPID');

7598: l_req_encumbrance_on := po_core_s.Is_encumbrance_on(p_doc_type => 'REQUISITION',p_org_id => NULL);
7599: l_conformed_header_id := po_wf_util_pkg.Getitemattrnumber(itemtype => itemtype,itemkey => itemkey,aname => 'CONFORMED_HEADER_ID');
7600: l_revision_num := po_wf_util_pkg.Getitemattrnumber(itemtype => itemtype,itemkey => itemkey,aname => 'REVISION_NUM');
7601: l_amendment_approval := po_wf_util_pkg.Getitemattrtext(itemtype => itemtype,itemkey => itemkey,aname => 'IS_AMENDMENT_APPROVAL');
7602: l_employee_id := po_wf_util_pkg.Getitemattrnumber(itemtype => itemtype,itemkey => itemkey,aname => 'APPROVER_EMPID');
7603: l_document_id := po_wf_util_pkg.Getitemattrnumber(itemtype => itemtype,itemkey => itemkey,aname => 'DOCUMENT_ID');
7604: l_document_type := po_wf_util_pkg.Getitemattrtext(itemtype => itemtype,itemkey => itemkey,aname => 'DOCUMENT_TYPE');
7605: l_document_subtype := po_wf_util_pkg.Getitemattrtext(itemtype => itemtype,itemkey => itemkey,aname => 'DOCUMENT_SUBTYPE');
7606: fnd_profile.Get('PO_REQAPPR_OVERRIDE_FUNDS',l_override_funds);

Line 7603: l_document_id := po_wf_util_pkg.Getitemattrnumber(itemtype => itemtype,itemkey => itemkey,aname => 'DOCUMENT_ID');

7599: l_conformed_header_id := po_wf_util_pkg.Getitemattrnumber(itemtype => itemtype,itemkey => itemkey,aname => 'CONFORMED_HEADER_ID');
7600: l_revision_num := po_wf_util_pkg.Getitemattrnumber(itemtype => itemtype,itemkey => itemkey,aname => 'REVISION_NUM');
7601: l_amendment_approval := po_wf_util_pkg.Getitemattrtext(itemtype => itemtype,itemkey => itemkey,aname => 'IS_AMENDMENT_APPROVAL');
7602: l_employee_id := po_wf_util_pkg.Getitemattrnumber(itemtype => itemtype,itemkey => itemkey,aname => 'APPROVER_EMPID');
7603: l_document_id := po_wf_util_pkg.Getitemattrnumber(itemtype => itemtype,itemkey => itemkey,aname => 'DOCUMENT_ID');
7604: l_document_type := po_wf_util_pkg.Getitemattrtext(itemtype => itemtype,itemkey => itemkey,aname => 'DOCUMENT_TYPE');
7605: l_document_subtype := po_wf_util_pkg.Getitemattrtext(itemtype => itemtype,itemkey => itemkey,aname => 'DOCUMENT_SUBTYPE');
7606: fnd_profile.Get('PO_REQAPPR_OVERRIDE_FUNDS',l_override_funds);
7607: l_clm_funds_Override := po_wf_util_pkg.Getitemattrtext(itemtype => itemtype,itemkey => itemkey,aname => 'CLM_FUNDS_OVERRIDE');

Line 7604: l_document_type := po_wf_util_pkg.Getitemattrtext(itemtype => itemtype,itemkey => itemkey,aname => 'DOCUMENT_TYPE');

7600: l_revision_num := po_wf_util_pkg.Getitemattrnumber(itemtype => itemtype,itemkey => itemkey,aname => 'REVISION_NUM');
7601: l_amendment_approval := po_wf_util_pkg.Getitemattrtext(itemtype => itemtype,itemkey => itemkey,aname => 'IS_AMENDMENT_APPROVAL');
7602: l_employee_id := po_wf_util_pkg.Getitemattrnumber(itemtype => itemtype,itemkey => itemkey,aname => 'APPROVER_EMPID');
7603: l_document_id := po_wf_util_pkg.Getitemattrnumber(itemtype => itemtype,itemkey => itemkey,aname => 'DOCUMENT_ID');
7604: l_document_type := po_wf_util_pkg.Getitemattrtext(itemtype => itemtype,itemkey => itemkey,aname => 'DOCUMENT_TYPE');
7605: l_document_subtype := po_wf_util_pkg.Getitemattrtext(itemtype => itemtype,itemkey => itemkey,aname => 'DOCUMENT_SUBTYPE');
7606: fnd_profile.Get('PO_REQAPPR_OVERRIDE_FUNDS',l_override_funds);
7607: l_clm_funds_Override := po_wf_util_pkg.Getitemattrtext(itemtype => itemtype,itemkey => itemkey,aname => 'CLM_FUNDS_OVERRIDE');
7608:

Line 7605: l_document_subtype := po_wf_util_pkg.Getitemattrtext(itemtype => itemtype,itemkey => itemkey,aname => 'DOCUMENT_SUBTYPE');

7601: l_amendment_approval := po_wf_util_pkg.Getitemattrtext(itemtype => itemtype,itemkey => itemkey,aname => 'IS_AMENDMENT_APPROVAL');
7602: l_employee_id := po_wf_util_pkg.Getitemattrnumber(itemtype => itemtype,itemkey => itemkey,aname => 'APPROVER_EMPID');
7603: l_document_id := po_wf_util_pkg.Getitemattrnumber(itemtype => itemtype,itemkey => itemkey,aname => 'DOCUMENT_ID');
7604: l_document_type := po_wf_util_pkg.Getitemattrtext(itemtype => itemtype,itemkey => itemkey,aname => 'DOCUMENT_TYPE');
7605: l_document_subtype := po_wf_util_pkg.Getitemattrtext(itemtype => itemtype,itemkey => itemkey,aname => 'DOCUMENT_SUBTYPE');
7606: fnd_profile.Get('PO_REQAPPR_OVERRIDE_FUNDS',l_override_funds);
7607: l_clm_funds_Override := po_wf_util_pkg.Getitemattrtext(itemtype => itemtype,itemkey => itemkey,aname => 'CLM_FUNDS_OVERRIDE');
7608:
7609:

Line 7607: l_clm_funds_Override := po_wf_util_pkg.Getitemattrtext(itemtype => itemtype,itemkey => itemkey,aname => 'CLM_FUNDS_OVERRIDE');

7603: l_document_id := po_wf_util_pkg.Getitemattrnumber(itemtype => itemtype,itemkey => itemkey,aname => 'DOCUMENT_ID');
7604: l_document_type := po_wf_util_pkg.Getitemattrtext(itemtype => itemtype,itemkey => itemkey,aname => 'DOCUMENT_TYPE');
7605: l_document_subtype := po_wf_util_pkg.Getitemattrtext(itemtype => itemtype,itemkey => itemkey,aname => 'DOCUMENT_SUBTYPE');
7606: fnd_profile.Get('PO_REQAPPR_OVERRIDE_FUNDS',l_override_funds);
7607: l_clm_funds_Override := po_wf_util_pkg.Getitemattrtext(itemtype => itemtype,itemkey => itemkey,aname => 'CLM_FUNDS_OVERRIDE');
7608:
7609:
7610:
7611: IF l_amendment_approval IS NULL THEN