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 368: FROM po_headers_interface PHI,

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

Line 469: p_table_name => 'PO_HEADERS_INTERFACE',

465:
466: PO_PDOI_ERR_UTL.add_fatal_error
467: ( p_interface_header_id => l_intf_header_id_tbl(i),
468: p_error_message_name => 'PO_LOCKED_OR_INVALID_STS',
469: p_table_name => 'PO_HEADERS_INTERFACE',
470: p_column_name => 'DRAFT_ID',
471: p_column_value => l_tmp_draft_id
472: );
473:

Line 518: UPDATE po_headers_interface

514: d_position := 120;
515:
516: -- stamp draft_id value to interface table
517: FORALL i IN 1..l_intf_header_id_tbl.COUNT
518: UPDATE po_headers_interface
519: SET draft_id = l_draft_id_tbl(i)
520: WHERE interface_header_id = l_intf_header_id_tbl(i)
521: AND processing_id = PO_PDOI_PARAMS.g_processing_id;
522:

Line 647: FROM po_headers_interface PHI,

643: POL.po_line_id
644: BULK COLLECT
645: INTO l_draft_id_tbl,
646: l_line_id_tbl
647: FROM po_headers_interface PHI,
648: po_lines_all POL
649: WHERE PHI.processing_id = PO_PDOI_PARAMS.g_processing_id
650: AND PHI.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
651: AND PHI.po_header_id = POL.po_header_id

Line 721: l_id PO_HEADERS_INTERFACE.interface_header_id%TYPE;

717: d_api_name CONSTANT VARCHAR2(30) := 'init_doc_info_tbl';
718: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
719: d_position NUMBER;
720:
721: l_id PO_HEADERS_INTERFACE.interface_header_id%TYPE;
722:
723:
724: -- bug5215871 START
725: l_reject_count NUMBER;