APPS.PO_PDOI_ERR_UTL dependencies on PO_LINE_LOCATIONS_INTERFACE

Line 422: -- PO_PDOI_CONSTANTS.g_PO_LINE_LOCATIONS_INTERFACE

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
425: --
426: --IN OUT:

Line 574: -- PO_PDOI_CONSTANTS.g_PO_LINE_LOCATIONS_INTERFACE

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
577: --
578: --p_table_id_tbl - Table of interface ids that correspond to the table name passed in

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

671: WHERE PSG.key = l_key
672: AND PSG.num1 = PLI.interface_line_id
673: ORDER BY PSG.index_num1;
674:
675: ELSIF (p_table_name = PO_PDOI_CONSTANTS.g_PO_LINE_LOCATIONS_INTERFACE) THEN
676:
677: d_position := 60;
678:
679: SELECT PLLI.interface_header_id,

Line 687: po_line_locations_interface PLLI

683: INTO x_intf_header_id_tbl,
684: x_intf_line_id_tbl,
685: x_intf_line_loc_id_tbl
686: FROM po_session_gt PSG,
687: po_line_locations_interface PLLI
688: WHERE PSG.key = l_key
689: AND PSG.num1 = PLLI.interface_line_location_id
690: ORDER BY PSG.index_num1;
691:

Line 1151: WHEN PO_PDOI_CONSTANTS.g_PO_LINE_LOCATIONS_INTERFACE THEN

1147: l_value := p_lines.hd_created_language_tbl(l_index);
1148: ELSE
1149: NULL;
1150: END IF;
1151: WHEN PO_PDOI_CONSTANTS.g_PO_LINE_LOCATIONS_INTERFACE THEN
1152: d_position := 30;
1153: l_index := p_line_locs.intf_id_index_tbl(p_interface_line_location_id);
1154: IF (p_key = PO_MSG_MAPPING_UTL.c_ship_to_organization_code) THEN
1155: l_value := p_line_locs.ship_to_org_code_tbl(l_index);