DBA Data[Home] [Help]

APPS.PO_PDOI_ERR_UTL dependencies on PO_PRICE_DIFF_INTERFACE

Line 409: -- PO_PDOI_CONSTANTS.g_PO_PRICE_DIFF_INTERFACE

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

Line 561: -- PO_PDOI_CONSTANTS.g_PO_PRICE_DIFF_INTERFACE

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

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

692: WHERE PSG.key = l_key
693: AND PSG.num1 = PDI.interface_distribution_id
694: ORDER BY PSG.index_num1;
695:
696: ELSIF (p_table_name = PO_PDOI_CONSTANTS.g_PO_PRICE_DIFF_INTERFACE) THEN
697:
698: d_position := 80;
699:
700: SELECT PPDI.interface_header_id,

Line 710: po_price_diff_interface PPDI

706: x_intf_line_id_tbl,
707: x_intf_line_loc_id_tbl,
708: x_intf_price_diff_id_tbl
709: FROM po_session_gt PSG,
710: po_price_diff_interface PPDI
711: WHERE PSG.key = l_key
712: AND PSG.num1 = PPDI.price_diff_interface_id
713: ORDER BY PSG.index_num1;
714:

Line 1158: WHEN PO_PDOI_CONSTANTS.g_PO_PRICE_DIFF_INTERFACE THEN

1154: l_value := p_line_locs.start_date_tbl(l_index);
1155: ELSE
1156: NULL;
1157: END IF;
1158: WHEN PO_PDOI_CONSTANTS.g_PO_PRICE_DIFF_INTERFACE THEN
1159: NULL;
1160: END CASE;
1161:
1162: IF (PO_LOG.d_proc) THEN