APPS.PO_PDOI_ERR_UTL dependencies on PO_LINE_LOCATIONS_INTERFACE

Line 407: -- PO_PDOI_CONSTANTS.g_PO_LINE_LOCATIONS_INTERFACE

403: --IN:
404: --x_results - po_validation_results_type
405: --p_table_name - values include: PO_PDOI_CONSTANTS.g_PO_HEADERS_INTERFACE
406: -- PO_PDOI_CONSTANTS.g_PO_LINES_INTERFACE
407: -- PO_PDOI_CONSTANTS.g_PO_LINE_LOCATIONS_INTERFACE
408: -- PO_PDOI_CONSTANTS.g_PO_DISTRIBUTIONS_INTERFACE
409: -- PO_PDOI_CONSTANTS.g_PO_PRICE_DIFF_INTERFACE
410: --
411: --IN OUT:

Line 559: -- PO_PDOI_CONSTANTS.g_PO_LINE_LOCATIONS_INTERFACE

555: --Parameters:
556: --IN:
557: --p_table_name - values include: PO_PDOI_CONSTANTS.g_PO_HEADERS_INTERFACE
558: -- PO_PDOI_CONSTANTS.g_PO_LINES_INTERFACE
559: -- PO_PDOI_CONSTANTS.g_PO_LINE_LOCATIONS_INTERFACE
560: -- PO_PDOI_CONSTANTS.g_PO_DISTRIBUTIONS_INTERFACE
561: -- PO_PDOI_CONSTANTS.g_PO_PRICE_DIFF_INTERFACE
562: --
563: --p_table_id_tbl - Table of interface ids that correspond to the table name passed in

Line 660: ELSIF (p_table_name = PO_PDOI_CONSTANTS.g_PO_LINE_LOCATIONS_INTERFACE) THEN

656: WHERE PSG.key = l_key
657: AND PSG.num1 = PLI.interface_line_id
658: ORDER BY PSG.index_num1;
659:
660: ELSIF (p_table_name = PO_PDOI_CONSTANTS.g_PO_LINE_LOCATIONS_INTERFACE) THEN
661:
662: d_position := 60;
663:
664: SELECT PLLI.interface_header_id,

Line 672: po_line_locations_interface PLLI

668: INTO x_intf_header_id_tbl,
669: x_intf_line_id_tbl,
670: x_intf_line_loc_id_tbl
671: FROM po_session_gt PSG,
672: po_line_locations_interface PLLI
673: WHERE PSG.key = l_key
674: AND PSG.num1 = PLLI.interface_line_location_id
675: ORDER BY PSG.index_num1;
676:

Line 1136: WHEN PO_PDOI_CONSTANTS.g_PO_LINE_LOCATIONS_INTERFACE THEN

1132: l_value := p_lines.hd_created_language_tbl(l_index);
1133: ELSE
1134: NULL;
1135: END IF;
1136: WHEN PO_PDOI_CONSTANTS.g_PO_LINE_LOCATIONS_INTERFACE THEN
1137: d_position := 30;
1138: l_index := p_line_locs.intf_id_index_tbl(p_interface_line_location_id);
1139: IF (p_key = PO_MSG_MAPPING_UTL.c_ship_to_organization_code) THEN
1140: l_value := p_line_locs.ship_to_org_code_tbl(l_index);