APPS.PO_PDOI_ERR_UTL dependencies on PO_HEADERS_INTERFACE

Line 135: even though it was entered in po_headers_interface.

131: l_rec.error_message := p_error_message; -- bug5385342
132:
133: /* Bug 9918507 start
134: Batch_id was not getting populated in the po_interface_errors
135: even though it was entered in po_headers_interface.
136: Query for batch_id using interface_header_id and populate l_rec.batch_id
137: with that value*/
138: SELECT batch_id
139: INTO l_rec.batch_id

Line 140: FROM po_headers_interface

136: Query for batch_id using interface_header_id and populate l_rec.batch_id
137: with that value*/
138: SELECT batch_id
139: INTO l_rec.batch_id
140: FROM po_headers_interface
141: WHERE interface_header_id = p_interface_header_id;
142: /* Bug 9918507 end*/
143:
144: PO_INTERFACE_ERRORS_UTL.add_to_errors_tbl

Line 420: --p_table_name - values include: PO_PDOI_CONSTANTS.g_PO_HEADERS_INTERFACE

416: -- Procedure to process the PDOI Validation results.
417: --Parameters:
418: --IN:
419: --x_results - po_validation_results_type
420: --p_table_name - values include: PO_PDOI_CONSTANTS.g_PO_HEADERS_INTERFACE
421: -- PO_PDOI_CONSTANTS.g_PO_LINES_INTERFACE
422: -- PO_PDOI_CONSTANTS.g_PO_LINE_LOCATIONS_INTERFACE
423: -- PO_PDOI_CONSTANTS.g_PO_DISTRIBUTIONS_INTERFACE
424: -- PO_PDOI_CONSTANTS.g_PO_PRICE_DIFF_INTERFACE

Line 572: --p_table_name - values include: PO_PDOI_CONSTANTS.g_PO_HEADERS_INTERFACE

568: --Function:
569: -- Procedure to derive the parent interface ids for a given entity
570: --Parameters:
571: --IN:
572: --p_table_name - values include: PO_PDOI_CONSTANTS.g_PO_HEADERS_INTERFACE
573: -- PO_PDOI_CONSTANTS.g_PO_LINES_INTERFACE
574: -- PO_PDOI_CONSTANTS.g_PO_LINE_LOCATIONS_INTERFACE
575: -- PO_PDOI_CONSTANTS.g_PO_DISTRIBUTIONS_INTERFACE
576: -- PO_PDOI_CONSTANTS.g_PO_PRICE_DIFF_INTERFACE

Line 647: IF (p_table_name = PO_PDOI_CONSTANTS.g_PO_HEADERS_INTERFACE) THEN

643: (l_key, l_seq(i), p_table_id_tbl(i));
644:
645: d_position := 30;
646:
647: IF (p_table_name = PO_PDOI_CONSTANTS.g_PO_HEADERS_INTERFACE) THEN
648:
649: d_position := 40;
650:
651: SELECT PHI.interface_header_id

Line 655: po_headers_interface PHI

651: SELECT PHI.interface_header_id
652: BULK COLLECT
653: INTO x_intf_header_id_tbl
654: FROM po_session_gt PSG,
655: po_headers_interface PHI
656: WHERE PSG.key = l_key AND
657: PSG.num1 = PHI.interface_header_id
658: ORDER BY PSG.index_num1;
659:

Line 1073: WHEN PO_PDOI_CONSTANTS.g_PO_HEADERS_INTERFACE THEN

1069: END IF;
1070:
1071: -- get value from each interface record based on p_table_name
1072: CASE p_table_name
1073: WHEN PO_PDOI_CONSTANTS.g_PO_HEADERS_INTERFACE THEN
1074: d_position := 10;
1075: l_index := p_headers.intf_id_index_tbl(p_interface_header_id);
1076: IF (p_key = PO_MSG_MAPPING_UTL.c_rate_type) THEN
1077: l_value := p_headers.rate_type_tbl(l_index);