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

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

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

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

Line 408: -- PO_PDOI_CONSTANTS.g_PO_DISTRIBUTIONS_INTERFACE

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: --
411: --IN OUT:
412: --OUT:

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

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

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

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

Line 560: -- PO_PDOI_CONSTANTS.g_PO_DISTRIBUTIONS_INTERFACE

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

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

628: (l_key, l_seq(i), p_table_id_tbl(i));
629:
630: d_position := 30;
631:
632: IF (p_table_name = PO_PDOI_CONSTANTS.g_PO_HEADERS_INTERFACE) THEN
633:
634: d_position := 40;
635:
636: SELECT PHI.interface_header_id

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

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

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

673: WHERE PSG.key = l_key
674: AND PSG.num1 = PLLI.interface_line_location_id
675: ORDER BY PSG.index_num1;
676:
677: ELSIF (p_table_name = PO_PDOI_CONSTANTS.g_PO_DISTRIBUTIONS_INTERFACE) THEN
678:
679: d_position := 70;
680:
681: SELECT PDI.interface_header_id,

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

1054: END IF;
1055:
1056: -- get value from each interface record based on p_table_name
1057: CASE p_table_name
1058: WHEN PO_PDOI_CONSTANTS.g_PO_HEADERS_INTERFACE THEN
1059: d_position := 10;
1060: l_index := p_headers.intf_id_index_tbl(p_interface_header_id);
1061: IF (p_key = PO_MSG_MAPPING_UTL.c_rate_type) THEN
1062: l_value := p_headers.rate_type_tbl(l_index);

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

Line 1104: PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD) THEN

1100: -- bug5619358
1101: -- For Catalog Upload, we need to get the value from
1102: -- UNI_MEAS_LOOKUP_CODE if UOM_CODE is NULL
1103: IF (PO_PDOI_PARAMS.g_request.calling_module =
1104: PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD) THEN
1105:
1106: l_value := NVL(p_lines.uom_code_tbl(l_index),
1107: p_lines.unit_of_measure_tbl(l_index));
1108: END IF;

Line 1136: WHEN PO_PDOI_CONSTANTS.g_PO_LINE_LOCATIONS_INTERFACE THEN

1132: l_value := p_lines.hd_created_language_tbl(l_index);
1133: ELSE
1134: NULL;
1135: END IF;
1136: WHEN PO_PDOI_CONSTANTS.g_PO_LINE_LOCATIONS_INTERFACE THEN
1137: d_position := 30;
1138: l_index := p_line_locs.intf_id_index_tbl(p_interface_line_location_id);
1139: IF (p_key = PO_MSG_MAPPING_UTL.c_ship_to_organization_code) THEN
1140: l_value := p_line_locs.ship_to_org_code_tbl(l_index);

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