DBA Data[Home] [Help]

APPS.PO_PDOI_ERR_UTL dependencies on PO_PRICE_DIFF_INTERFACE

Line 424: -- PO_PDOI_CONSTANTS.g_PO_PRICE_DIFF_INTERFACE

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:
428: --End of Comments

Line 576: -- PO_PDOI_CONSTANTS.g_PO_PRICE_DIFF_INTERFACE

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: --
580: --IN OUT:

Line 711: ELSIF (p_table_name = PO_PDOI_CONSTANTS.g_PO_PRICE_DIFF_INTERFACE) THEN

707: WHERE PSG.key = l_key
708: AND PSG.num1 = PDI.interface_distribution_id
709: ORDER BY PSG.index_num1;
710:
711: ELSIF (p_table_name = PO_PDOI_CONSTANTS.g_PO_PRICE_DIFF_INTERFACE) THEN
712:
713: d_position := 80;
714:
715: SELECT PPDI.interface_header_id,

Line 725: po_price_diff_interface PPDI

721: x_intf_line_id_tbl,
722: x_intf_line_loc_id_tbl,
723: x_intf_price_diff_id_tbl
724: FROM po_session_gt PSG,
725: po_price_diff_interface PPDI
726: WHERE PSG.key = l_key
727: AND PSG.num1 = PPDI.price_diff_interface_id
728: ORDER BY PSG.index_num1;
729:

Line 1173: WHEN PO_PDOI_CONSTANTS.g_PO_PRICE_DIFF_INTERFACE THEN

1169: l_value := p_line_locs.start_date_tbl(l_index);
1170: ELSE
1171: NULL;
1172: END IF;
1173: WHEN PO_PDOI_CONSTANTS.g_PO_PRICE_DIFF_INTERFACE THEN
1174: NULL;
1175: END CASE;
1176:
1177: IF (PO_LOG.d_proc) THEN