APPS.PO_PDOI_ERR_UTL dependencies on PO_DISTRIBUTIONS_INTERFACE

Line 408: -- PO_PDOI_CONSTANTS.g_PO_DISTRIBUTIONS_INTERFACE

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

Line 560: -- PO_PDOI_CONSTANTS.g_PO_DISTRIBUTIONS_INTERFACE

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

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

673: WHERE PSG.key = l_key
674: AND PSG.num1 = PLLI.interface_line_location_id
675: ORDER BY PSG.index_num1;
676:
677: ELSIF (p_table_name = PO_PDOI_CONSTANTS.g_PO_DISTRIBUTIONS_INTERFACE) THEN
678:
679: d_position := 70;
680:
681: SELECT PDI.interface_header_id,

Line 691: po_distributions_interface PDI

687: x_intf_line_id_tbl,
688: x_intf_line_loc_id_tbl,
689: x_intf_dist_id_tbl
690: FROM po_session_gt PSG,
691: po_distributions_interface PDI
692: WHERE PSG.key = l_key
693: AND PSG.num1 = PDI.interface_distribution_id
694: ORDER BY PSG.index_num1;
695: