APPS.PO_OM_INTEGRATION_GRP dependencies on PO_HEADERS

Line 128: l_cur_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;

124: l_processed_pos INDEXED_TBL_NUMBER;
125: l_processed_releases INDEXED_TBL_NUMBER;
126: l_processed_reqs INDEXED_TBL_NUMBER;
127:
128: l_cur_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
129: l_cur_po_release_id PO_RELEASES_ALL.po_release_id%TYPE;
130: l_cur_req_header_id PO_REQUISITION_HEADERS_ALL.requisition_header_id%TYPE;
131: l_start_index NUMBER;
132:

Line 141: l_document_org_id PO_HEADERS.ORG_ID%TYPE;

137:
138: l_quantity_ordered PO_TBL_NUMBER := p_quantity;
139:
140: l_original_org_id NUMBER := PO_MOAC_UTILS_PVT.get_current_org_id ; -- added
141: l_document_org_id PO_HEADERS.ORG_ID%TYPE;
142: l_count NUMBER;
143:
144: -- Bug# 8970502 : Added the following variables
145:

Line 814: l_document_org_id PO_HEADERS.ORG_ID%TYPE; -- Bug 3362534

810: l_original_org_id NUMBER := PO_MOAC_UTILS_PVT.get_current_org_id ; --
811: l_approved_date PO_LINE_LOCATIONS_ALL.approved_date%TYPE;
812: l_chg PO_CHANGES_REC_TYPE;
813: -- Bug 3248723 END
814: l_document_org_id PO_HEADERS.ORG_ID%TYPE; -- Bug 3362534
815:
816: -- Bug 3639067 START
817: l_drop_ship_flag PO_LINE_LOCATIONS_ALL.drop_ship_flag%TYPE;
818: l_session_gt_key PO_SESSION_GT.key%TYPE;

Line 858: from PO_HEADERS_ALL

854: SELECT TYPE_LOOKUP_CODE,
855: org_id -- Bug 3362534
856: INTO l_doc_subtype,
857: l_document_org_id
858: from PO_HEADERS_ALL
859: WHERE po_header_id = p_po_header_id(i);
860: l_doc_type := 'PO';
861: END IF;
862:

Line 1088: l_authorization_status PO_HEADERS.AUTHORIZATION_STATUS%TYPE;

1084: ) IS
1085: l_proc_name CONSTANT VARCHAR2(30) := 'call_po_change_api';
1086:
1087: l_progress VARCHAR2(3) := '000';
1088: l_authorization_status PO_HEADERS.AUTHORIZATION_STATUS%TYPE;
1089: l_document_org_id PO_HEADERS.ORG_ID%TYPE;
1090: l_run_submission_checks VARCHAR2(1);
1091: l_launch_approvals_flag VARCHAR2(1);
1092: l_errors PO_API_ERRORS_REC_TYPE;

Line 1089: l_document_org_id PO_HEADERS.ORG_ID%TYPE;

1085: l_proc_name CONSTANT VARCHAR2(30) := 'call_po_change_api';
1086:
1087: l_progress VARCHAR2(3) := '000';
1088: l_authorization_status PO_HEADERS.AUTHORIZATION_STATUS%TYPE;
1089: l_document_org_id PO_HEADERS.ORG_ID%TYPE;
1090: l_run_submission_checks VARCHAR2(1);
1091: l_launch_approvals_flag VARCHAR2(1);
1092: l_errors PO_API_ERRORS_REC_TYPE;
1093: BEGIN

Line 1103: FROM po_headers_all

1099: WHERE po_release_id = p_chg.po_release_id;
1100: ELSE -- PO
1101: SELECT org_id, authorization_status
1102: INTO l_document_org_id, l_authorization_status
1103: FROM po_headers_all
1104: WHERE po_header_id = p_chg.po_header_id;
1105: END IF;
1106:
1107: l_progress := '010';

Line 1504: po_headers_all PH,

1500: 'Y', 'Y', -- po is cancelled
1501: 'N')))
1502: BULK COLLECT INTO x_purge_allowed_tbl
1503: FROM po_session_gt PSG,
1504: po_headers_all PH,
1505: po_line_locations_all PLL
1506: WHERE PSG.key = l_seq_id
1507: AND PSG.num1 = PLL.line_location_id (+)
1508: AND PLL.po_header_id = PH.po_header_id (+)