eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_PDOI_ERR_UTL dependencies on PO_PDOI_CONSTANTS

Line 420: --p_table_name - values include: PO_PDOI_CONSTANTS.g_PO_HEADERS_INTERFACE

416: -- Procedure to process the PDOI Validation results.
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

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 422: -- PO_PDOI_CONSTANTS.g_PO_LINE_LOCATIONS_INTERFACE

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

Line 423: -- PO_PDOI_CONSTANTS.g_PO_DISTRIBUTIONS_INTERFACE

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: --
426: --IN OUT:
427: --OUT:

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 572: --p_table_name - values include: PO_PDOI_CONSTANTS.g_PO_HEADERS_INTERFACE

568: --Function:
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

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 574: -- PO_PDOI_CONSTANTS.g_PO_LINE_LOCATIONS_INTERFACE

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: --
578: --p_table_id_tbl - Table of interface ids that correspond to the table name passed in

Line 575: -- PO_PDOI_CONSTANTS.g_PO_DISTRIBUTIONS_INTERFACE

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: --
578: --p_table_id_tbl - Table of interface ids that correspond to the table name passed in
579: --

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 647: IF (p_table_name = PO_PDOI_CONSTANTS.g_PO_HEADERS_INTERFACE) THEN

643: (l_key, l_seq(i), p_table_id_tbl(i));
644:
645: d_position := 30;
646:
647: IF (p_table_name = PO_PDOI_CONSTANTS.g_PO_HEADERS_INTERFACE) THEN
648:
649: d_position := 40;
650:
651: SELECT PHI.interface_header_id

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 675: ELSIF (p_table_name = PO_PDOI_CONSTANTS.g_PO_LINE_LOCATIONS_INTERFACE) THEN

671: WHERE PSG.key = l_key
672: AND PSG.num1 = PLI.interface_line_id
673: ORDER BY PSG.index_num1;
674:
675: ELSIF (p_table_name = PO_PDOI_CONSTANTS.g_PO_LINE_LOCATIONS_INTERFACE) THEN
676:
677: d_position := 60;
678:
679: SELECT PLLI.interface_header_id,

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

688: WHERE PSG.key = l_key
689: AND PSG.num1 = PLLI.interface_line_location_id
690: ORDER BY PSG.index_num1;
691:
692: ELSIF (p_table_name = PO_PDOI_CONSTANTS.g_PO_DISTRIBUTIONS_INTERFACE) THEN
693:
694: d_position := 70;
695:
696: SELECT PDI.interface_header_id,

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 1073: WHEN PO_PDOI_CONSTANTS.g_PO_HEADERS_INTERFACE THEN

1069: END IF;
1070:
1071: -- get value from each interface record based on p_table_name
1072: CASE p_table_name
1073: WHEN PO_PDOI_CONSTANTS.g_PO_HEADERS_INTERFACE THEN
1074: d_position := 10;
1075: l_index := p_headers.intf_id_index_tbl(p_interface_header_id);
1076: IF (p_key = PO_MSG_MAPPING_UTL.c_rate_type) THEN
1077: l_value := p_headers.rate_type_tbl(l_index);

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);

Line 1119: PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD) THEN

1115: -- bug5619358
1116: -- For Catalog Upload, we need to get the value from
1117: -- UNI_MEAS_LOOKUP_CODE if UOM_CODE is NULL
1118: IF (PO_PDOI_PARAMS.g_request.calling_module =
1119: PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD) THEN
1120:
1121: l_value := NVL(p_lines.uom_code_tbl(l_index),
1122: p_lines.unit_of_measure_tbl(l_index));
1123: END IF;

Line 1151: WHEN PO_PDOI_CONSTANTS.g_PO_LINE_LOCATIONS_INTERFACE THEN

1147: l_value := p_lines.hd_created_language_tbl(l_index);
1148: ELSE
1149: NULL;
1150: END IF;
1151: WHEN PO_PDOI_CONSTANTS.g_PO_LINE_LOCATIONS_INTERFACE THEN
1152: d_position := 30;
1153: l_index := p_line_locs.intf_id_index_tbl(p_interface_line_location_id);
1154: IF (p_key = PO_MSG_MAPPING_UTL.c_ship_to_organization_code) THEN
1155: l_value := p_line_locs.ship_to_org_code_tbl(l_index);

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