DBA Data[Home] [Help]

APPS.POR_AMENDMENT_PKG dependencies on PO_CORE_S

Line 5426: l_currency_code := PO_CORE_S2.get_base_currency;

5422: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
5423: itemkey => itemkey,
5424: aname => 'DOCUMENT_ID');
5425:
5426: l_currency_code := PO_CORE_S2.get_base_currency;
5427: fnd_currency.get_info(l_currency_code, l_precision, l_ext_precision, l_min_acct_unit);
5428:
5429: wf_engine.SetItemAttrText ( itemtype => itemtype,
5430: itemkey => itemkey,

Line 5923: po_core_s.get_period_name(x_sob_id,x_period_name,x_date);

5919: AND rcv.organization_id (+) = fsp.inventory_organization_id;
5920:
5921:
5922: IF(x_po_encumbrance_flag = 'Y') THEN
5923: po_core_s.get_period_name(x_sob_id,x_period_name,x_date);
5924: END IF;
5925:
5926:
5927: BEGIN

Line 7598: l_req_encumbrance_on := po_core_s.Is_encumbrance_on(p_doc_type => 'REQUISITION',p_org_id => NULL);

7594: IF (funcmode <> wf_engine.eng_run) THEN
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');

Line 7744: IF (po_core_s.Is_encumbrance_on(p_doc_type => 'REQUISITION',p_org_id => NULL)) THEN

7740: po_wf_debug_pkg.Insert_debug(itemtype,itemkey,'Merge Amendment Successful');
7741: END IF;
7742: END IF; -- p_amendment_approval
7743:
7744: IF (po_core_s.Is_encumbrance_on(p_doc_type => 'REQUISITION',p_org_id => NULL)) THEN
7745: IF (g_po_wf_debug = 'Y') THEN
7746: po_wf_debug_pkg.Insert_debug(itemtype,itemkey,'Requisition Encumbrance is On');
7747: END IF;
7748: IF p_amendment_approval = 'Y' THEN

Line 8156: l_req_encumbrance_on := POR_UTIL_PKG.BOOL_TO_VARCHAR(po_core_s.Is_encumbrance_on(p_doc_type => 'REQUISITION',p_org_id => x_org_id));

8152: INTO x_amendment_reason, x_preparer_id, x_org_id
8153: FROM PO_REQUISITION_HEADERS_ALL
8154: WHERE requisition_header_id = p_req_header_id;
8155:
8156: l_req_encumbrance_on := POR_UTIL_PKG.BOOL_TO_VARCHAR(po_core_s.Is_encumbrance_on(p_doc_type => 'REQUISITION',p_org_id => x_org_id));
8157:
8158: OPEN get_cancel_lines(p_req_header_id);
8159: LOOP
8160: FETCH get_cancel_lines INTO x_req_line_id, x_conf_line_id;

Line 8173: po_core_s.get_product_install_status('OE')));

8169: l_valid_cancel_action := 'N';
8170: ELSE
8171: l_valid_cancel_action := POR_UTIL_PKG.BOOL_TO_VARCHAR(PO_REQS_CONTROL_SV.val_reqs_action(
8172: p_conf_hdr_id, x_conf_line_id, x_preparer_id, 'REQUISITION', 'PURCHASE', 'CANCEL', '', sysdate, l_req_encumbrance_on,
8173: po_core_s.get_product_install_status('OE')));
8174:
8175: IF l_valid_cancel_action = 'Y' THEN
8176:
8177: IF l_req_encumbrance_on = 'Y' THEN

Line 8248: po_core_s.get_product_install_status('OE'),

8244: 'CANCEL',
8245: x_amendment_reason,
8246: SYSDATE,
8247: l_req_encumbrance_on,
8248: po_core_s.get_product_install_status('OE'),
8249: X_req_control_error_rc);
8250:
8251: po_negotiation_req_notif.call_negotiation_wf('REQ HEADER', p_conf_hdr_id);
8252: