DBA Data[Home] [Help]

APPS.POR_AMENDMENT_PKG dependencies on POR_UTIL_PKG

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 8171: l_valid_cancel_action := POR_UTIL_PKG.BOOL_TO_VARCHAR(PO_REQS_CONTROL_SV.val_reqs_action(

8167:
8168: IF x_po_line_id IS NOT NULL OR x_line_loc_id IS NOT NULL THEN
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