APPS.PO_PDOI_HEADER_GROUPING_PVT dependencies on PO_HEADERS_INTERFACE

Line 175: FROM po_headers_interface

171: SELECT interface_header_id
172: BULK COLLECT
173: INTO l_intf_header_id_tbl
174: FROM (SELECT interface_header_id
175: FROM po_headers_interface
176: WHERE processing_round_num IS NULL
177: AND processing_id = PO_PDOI_PARAMS.g_processing_id
178: AND action IN (PO_PDOI_CONSTANTS.g_action_ORIGINAL,
179: PO_PDOI_CONSTANTS.g_action_ADD)

Line 203: UPDATE po_headers_interface

199:
200: d_position := 30;
201:
202: FORALL i IN 1..l_intf_header_id_tbl.COUNT
203: UPDATE po_headers_interface
204: SET processing_round_num = PO_PDOI_PARAMS.g_current_round_num
205: WHERE interface_header_id = l_intf_header_id_tbl(i);
206:
207: IF (PO_LOG.d_stmt) THEN

Line 231: FROM po_headers_interface

227: po_header_id
228: BULK COLLECT
229: INTO l_intf_header_id_tbl,
230: l_po_header_id_tbl
231: FROM po_headers_interface
232: WHERE processing_round_num IS NULL
233: AND processing_id = PO_PDOI_PARAMS.g_processing_id
234: AND po_header_id IS NOT NULL
235: AND action IN (PO_PDOI_CONSTANTS.g_action_UPDATE,

Line 269: UPDATE po_headers_interface

265:
266: IF (l_process_list.COUNT > 0) THEN
267: -- assign round number for those in process list
268: FORALL i IN INDICES OF l_process_list
269: UPDATE po_headers_interface
270: SET processing_round_num = PO_PDOI_PARAMS.g_current_round_num
271: WHERE interface_header_id = l_process_list(i);
272:
273: IF (PO_LOG.d_stmt) THEN

Line 369: FROM po_headers_interface PHI,

365: INTO l_intf_header_id_tbl,
366: l_po_header_id_tbl,
367: l_action_tbl,
368: l_revision_num_tbl
369: FROM po_headers_interface PHI,
370: po_headers_all PH
371: WHERE PHI.processing_id = PO_PDOI_PARAMS.g_processing_id
372: AND PHI.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
373: AND PHI.po_header_id = PH.po_header_id(+);

Line 488: p_table_name => 'PO_HEADERS_INTERFACE',

484:
485: PO_PDOI_ERR_UTL.add_fatal_error
486: ( p_interface_header_id => l_intf_header_id_tbl(i),
487: p_error_message_name => 'PO_LOCKED_OR_INVALID_STS',
488: p_table_name => 'PO_HEADERS_INTERFACE',
489: p_column_name => 'DRAFT_ID',
490: p_column_value => l_tmp_draft_id
491: );
492:

Line 537: UPDATE po_headers_interface

533: d_position := 120;
534:
535: -- stamp draft_id value to interface table
536: FORALL i IN 1..l_intf_header_id_tbl.COUNT
537: UPDATE po_headers_interface
538: SET draft_id = l_draft_id_tbl(i)
539: WHERE interface_header_id = l_intf_header_id_tbl(i)
540: AND processing_id = PO_PDOI_PARAMS.g_processing_id;
541:

Line 666: FROM po_headers_interface PHI,

662: POL.po_line_id
663: BULK COLLECT
664: INTO l_draft_id_tbl,
665: l_line_id_tbl
666: FROM po_headers_interface PHI,
667: po_lines_all POL
668: WHERE PHI.processing_id = PO_PDOI_PARAMS.g_processing_id
669: AND PHI.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
670: AND PHI.po_header_id = POL.po_header_id

Line 740: l_id PO_HEADERS_INTERFACE.interface_header_id%TYPE;

736: d_api_name CONSTANT VARCHAR2(30) := 'init_doc_info_tbl';
737: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
738: d_position NUMBER;
739:
740: l_id PO_HEADERS_INTERFACE.interface_header_id%TYPE;
741:
742:
743: -- bug5215871 START
744: l_reject_count NUMBER;