APPS.PO_PDOI_ERR_UTL dependencies on PO_DISTRIBUTIONS_INTERFACE

Line 423: -- PO_PDOI_CONSTANTS.g_PO_DISTRIBUTIONS_INTERFACE

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:
427: --OUT:

Line 575: -- PO_PDOI_CONSTANTS.g_PO_DISTRIBUTIONS_INTERFACE

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
579: --

Line 692: ELSIF (p_table_name = PO_PDOI_CONSTANTS.g_PO_DISTRIBUTIONS_INTERFACE) THEN

688: WHERE PSG.key = l_key
689: AND PSG.num1 = PLLI.interface_line_location_id
690: ORDER BY PSG.index_num1;
691:
692: ELSIF (p_table_name = PO_PDOI_CONSTANTS.g_PO_DISTRIBUTIONS_INTERFACE) THEN
693:
694: d_position := 70;
695:
696: SELECT PDI.interface_header_id,

Line 706: po_distributions_interface PDI

702: x_intf_line_id_tbl,
703: x_intf_line_loc_id_tbl,
704: x_intf_dist_id_tbl
705: FROM po_session_gt PSG,
706: po_distributions_interface PDI
707: WHERE PSG.key = l_key
708: AND PSG.num1 = PDI.interface_distribution_id
709: ORDER BY PSG.index_num1;
710: