APPS.PO_AUTOCREATE_MAINPROC_PVT dependencies on PO_HEADERS_INTERFACE

Line 11: po_headers_interface table and insert records into

7:
8: /* ============================================================================
9: NAME: process_headers
10: DESC: Handle the logic to derive, default, validate records from
11: po_headers_interface table and insert records into
12: po_headers_draft_all table.
13: PO_AUTO_HEADER_PROCESS_PVT.fetch_headers
14: PO_AUTO_HEADER_PROCESS_PVT.derive_and_default_headers
15: PO_AUTO_HEADER_PROCESS_PVT.validate_headers

Line 81: po_headers_interface phi

77: draft_id_tbl ,
78: delete_flag_tbl
79: FROM po_lines_interface pli ,
80: po_lines_all pla ,
81: po_headers_interface phi
82: WHERE PLI.interface_header_id = po_autocreate_params.g_interface_header_id
83: AND phi.interface_header_id = PLI.interface_header_id
84: AND PLA.po_header_id = PhI.po_header_id
85: AND PLI.line_num = PLA.line_num

Line 133: po_headers_interface phi

129: delete_flag_tbl
130: FROM TABLE(po_line_id_tbl) pl ,
131: po_line_locations_all plla ,
132: po_lines_interface PLI ,
133: po_headers_interface phi
134: WHERE PLI.interface_header_id = po_autocreate_params.g_interface_header_id
135: AND phi.interface_header_id = PLI.interface_header_id
136: AND plla.po_header_id = PhI.po_header_id
137: AND PLI.shipment_num = PLlA.shipment_num

Line 479: po_headers_interface phi,

475: 'PERIOD END', 'N', 'Y')),
476: 'INVENTORY', 'Y', 'SHOP FLOOR', 'Y')
477: INTO x_receipt_required_flag
478: FROM po_lines_interface pli,
479: po_headers_interface phi,
480: po_requisition_lines_all prl, --
481: mtl_system_items msi,
482: po_line_types plt,
483: po_vendors pov,

Line 535: PO_HEADERS_INTERFACE PHI

531: PO_LINE_TYPES PLT,
532: PO_SYSTEM_PARAMETERS_ALL PSP, --
533: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --
534: PO_VENDORS POV,
535: PO_HEADERS_INTERFACE PHI
536: WHERE PLI.LINE_NUM = x_po_line_num
537: AND PLI.shipment_num IS NOT NULL
538: AND NVL(psp.org_id,-99) = NVL(po_autocreate_params.g_purchasing_ou_id, -99) --
539: AND NVL(fsp.org_id,-99) = NVL(po_autocreate_params.g_purchasing_ou_id, -99) --

Line 624: PO_HEADERS_INTERFACE PHI

620: PO_LINE_TYPES PLT,
621: PO_SYSTEM_PARAMETERS_ALL PSP, --
622: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --
623: PO_VENDORS POV,
624: PO_HEADERS_INTERFACE PHI
625: WHERE PLI.LINE_NUM = x_po_line_num
626: AND PLI.shipment_num IS NOT NULL
627: AND PLI.item_id = MSI.inventory_item_id
628: AND MSI.organization_id = FSP.inventory_organization_id

Line 904: po_headers_interface table and insert records into

900:
901: /* ============================================================================
902: NAME: process_headers
903: DESC: Handle the logic to derive, default, validate records from
904: po_headers_interface table and insert records into
905: po_headers_draft_all table.
906: PO_AUTO_HEADER_PROCESS_PVT.fetch_headers
907: PO_AUTO_HEADER_PROCESS_PVT.derive_and_default_headers
908: PO_AUTO_HEADER_PROCESS_PVT.validate_headers

Line 1315: FROM po_headers_interface phi

1311: x_document_type_code,
1312: x_document_subtype,
1313: x_group_code,
1314: x_mode
1315: FROM po_headers_interface phi
1316: WHERE phi.interface_header_id = x_interface_header_id;
1317:
1318: l_progress := '020';
1319: IF g_debug_stmt THEN