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# 4640038 Start, Added the following variable
145:

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

684: l_original_org_id NUMBER := PO_MOAC_UTILS_PVT.get_current_org_id ; --
685: l_approved_date PO_LINE_LOCATIONS_ALL.approved_date%TYPE;
686: l_chg PO_CHANGES_REC_TYPE;
687: -- Bug 3248723 END
688: l_document_org_id PO_HEADERS.ORG_ID%TYPE; -- Bug 3362534
689:
690: -- Bug 3639067 START
691: l_drop_ship_flag PO_LINE_LOCATIONS_ALL.drop_ship_flag%TYPE;
692: l_session_gt_key PO_SESSION_GT.key%TYPE;

Line 732: from PO_HEADERS_ALL

728: SELECT TYPE_LOOKUP_CODE,
729: org_id -- Bug 3362534
730: INTO l_doc_subtype,
731: l_document_org_id
732: from PO_HEADERS_ALL
733: WHERE po_header_id = p_po_header_id(i);
734: l_doc_type := 'PO';
735: END IF;
736:

Line 962: l_authorization_status PO_HEADERS.AUTHORIZATION_STATUS%TYPE;

958: ) IS
959: l_proc_name CONSTANT VARCHAR2(30) := 'call_po_change_api';
960:
961: l_progress VARCHAR2(3) := '000';
962: l_authorization_status PO_HEADERS.AUTHORIZATION_STATUS%TYPE;
963: l_document_org_id PO_HEADERS.ORG_ID%TYPE;
964: l_run_submission_checks VARCHAR2(1);
965: l_launch_approvals_flag VARCHAR2(1);
966: l_errors PO_API_ERRORS_REC_TYPE;

Line 963: l_document_org_id PO_HEADERS.ORG_ID%TYPE;

959: l_proc_name CONSTANT VARCHAR2(30) := 'call_po_change_api';
960:
961: l_progress VARCHAR2(3) := '000';
962: l_authorization_status PO_HEADERS.AUTHORIZATION_STATUS%TYPE;
963: l_document_org_id PO_HEADERS.ORG_ID%TYPE;
964: l_run_submission_checks VARCHAR2(1);
965: l_launch_approvals_flag VARCHAR2(1);
966: l_errors PO_API_ERRORS_REC_TYPE;
967: BEGIN

Line 977: FROM po_headers_all

973: WHERE po_release_id = p_chg.po_release_id;
974: ELSE -- PO
975: SELECT org_id, authorization_status
976: INTO l_document_org_id, l_authorization_status
977: FROM po_headers_all
978: WHERE po_header_id = p_chg.po_header_id;
979: END IF;
980:
981: l_progress := '010';

Line 1378: po_headers_all PH,

1374: 'Y', 'Y', -- po is cancelled
1375: 'N')))
1376: BULK COLLECT INTO x_purge_allowed_tbl
1377: FROM po_session_gt PSG,
1378: po_headers_all PH,
1379: po_line_locations_all PLL
1380: WHERE PSG.key = l_seq_id
1381: AND PSG.num1 = PLL.line_location_id (+)
1382: AND PLL.po_header_id = PH.po_header_id (+)