DBA Data[Home] [Help]

APPS.PO_PDOI_ERR_UTL dependencies on PO_LINES_INTERFACE

Line 406: -- PO_PDOI_CONSTANTS.g_PO_LINES_INTERFACE

402: --Parameters:
403: --IN:
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: --

Line 558: -- PO_PDOI_CONSTANTS.g_PO_LINES_INTERFACE

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

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

641: WHERE PSG.key = l_key AND
642: PSG.num1 = PHI.interface_header_id
643: ORDER BY PSG.index_num1;
644:
645: ELSIF (p_table_name = PO_PDOI_CONSTANTS.g_PO_LINES_INTERFACE) THEN
646:
647: d_position := 50;
648:
649: SELECT PLI.interface_header_id,

Line 655: po_lines_interface PLI

651: BULK COLLECT
652: INTO x_intf_header_id_tbl,
653: x_intf_line_id_tbl
654: FROM po_session_gt PSG,
655: po_lines_interface PLI
656: WHERE PSG.key = l_key
657: AND PSG.num1 = PLI.interface_line_id
658: ORDER BY PSG.index_num1;
659:

Line 1084: WHEN PO_PDOI_CONSTANTS.g_PO_LINES_INTERFACE THEN

1080: l_value := p_headers.from_rfq_num_tbl(l_index);
1081: ELSE
1082: NULL;
1083: END IF;
1084: WHEN PO_PDOI_CONSTANTS.g_PO_LINES_INTERFACE THEN
1085: d_position := 20;
1086: l_index := p_lines.intf_id_index_tbl(p_interface_line_id);
1087: IF (p_key = PO_MSG_MAPPING_UTL.c_item) THEN
1088: l_value := p_lines.item_tbl(l_index);