DBA Data[Home] [Help]

APPS.PO_PDOI_ERR_UTL dependencies on PO_LINES_INTERFACE

Line 421: -- PO_PDOI_CONSTANTS.g_PO_LINES_INTERFACE

417: --Parameters:
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: --

Line 573: -- PO_PDOI_CONSTANTS.g_PO_LINES_INTERFACE

569: -- Procedure to derive the parent interface ids for a given entity
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: --

Line 660: ELSIF (p_table_name = PO_PDOI_CONSTANTS.g_PO_LINES_INTERFACE) THEN

656: WHERE PSG.key = l_key AND
657: PSG.num1 = PHI.interface_header_id
658: ORDER BY PSG.index_num1;
659:
660: ELSIF (p_table_name = PO_PDOI_CONSTANTS.g_PO_LINES_INTERFACE) THEN
661:
662: d_position := 50;
663:
664: SELECT PLI.interface_header_id,

Line 670: po_lines_interface PLI

666: BULK COLLECT
667: INTO x_intf_header_id_tbl,
668: x_intf_line_id_tbl
669: FROM po_session_gt PSG,
670: po_lines_interface PLI
671: WHERE PSG.key = l_key
672: AND PSG.num1 = PLI.interface_line_id
673: ORDER BY PSG.index_num1;
674:

Line 1099: WHEN PO_PDOI_CONSTANTS.g_PO_LINES_INTERFACE THEN

1095: l_value := p_headers.from_rfq_num_tbl(l_index);
1096: ELSE
1097: NULL;
1098: END IF;
1099: WHEN PO_PDOI_CONSTANTS.g_PO_LINES_INTERFACE THEN
1100: d_position := 20;
1101: l_index := p_lines.intf_id_index_tbl(p_interface_line_id);
1102: IF (p_key = PO_MSG_MAPPING_UTL.c_item) THEN
1103: l_value := p_lines.item_tbl(l_index);