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_MAINPROC_UTL_PVT dependencies on PO_PDOI_PARAMS

Line 281: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id

277: max(intf_lines.line_num) AS max_line_num
278: FROM po_lines_interface intf_lines,
279: po_headers_interface intf_headers
280: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
281: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
282: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
283: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
284: AND intf_headers.po_header_id IS NOT NULL AND p_po_header_id_tbl(i) IS NOT NULL -- Added as part of 9799280 to handle & avoid NULL cases
285: AND intf_headers.po_header_id = p_po_header_id_tbl(i)) v

Line 282: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num

278: FROM po_lines_interface intf_lines,
279: po_headers_interface intf_headers
280: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
281: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
282: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
283: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
284: AND intf_headers.po_header_id IS NOT NULL AND p_po_header_id_tbl(i) IS NOT NULL -- Added as part of 9799280 to handle & avoid NULL cases
285: AND intf_headers.po_header_id = p_po_header_id_tbl(i)) v
286: WHERE v.max_line_num IS NOT NULL;

Line 283: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id

279: po_headers_interface intf_headers
280: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
281: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
282: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
283: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
284: AND intf_headers.po_header_id IS NOT NULL AND p_po_header_id_tbl(i) IS NOT NULL -- Added as part of 9799280 to handle & avoid NULL cases
285: AND intf_headers.po_header_id = p_po_header_id_tbl(i)) v
286: WHERE v.max_line_num IS NOT NULL;
287:

Line 534: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id

530: l_index_tbl(i)
531: FROM po_lines_interface intf_lines,
532: po_headers_interface intf_headers
533: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
534: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
535: AND intf_headers.processing_round_num =
536: PO_PDOI_PARAMS.g_current_round_num
537: AND intf_headers.po_header_id = p_po_header_id_tbl(i)
538: AND intf_lines.interface_line_id < p_intf_line_id_tbl(i)

Line 536: PO_PDOI_PARAMS.g_current_round_num

532: po_headers_interface intf_headers
533: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
534: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
535: AND intf_headers.processing_round_num =
536: PO_PDOI_PARAMS.g_current_round_num
537: AND intf_headers.po_header_id = p_po_header_id_tbl(i)
538: AND intf_lines.interface_line_id < p_intf_line_id_tbl(i)
539: AND intf_lines.interface_line_id >= p_intf_line_id_tbl(1)
540: AND intf_lines.line_num = p_line_num_tbl(i)

Line 662: IF (PO_PDOI_PARAMS.g_request.document_type =

658:
659: -- search in txn table only for blanket
660: -- for SPO, there is never existing shipments
661: -- for quotation, existing price breaks will be removed
662: IF (PO_PDOI_PARAMS.g_request.document_type =
663: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN
664: d_position := 10;
665:
666: FORALL i IN INDICES OF l_processing_row_tbl

Line 718: AND intf_locs.processing_id = PO_PDOI_PARAMS.g_processing_id

714: po_lines_interface intf_lines,
715: po_headers_interface intf_headers
716: WHERE intf_locs.interface_line_id = intf_lines.interface_line_id
717: AND intf_lines.interface_header_id = intf_headers.interface_header_id
718: AND intf_locs.processing_id = PO_PDOI_PARAMS.g_processing_id
719: AND intf_headers.processing_round_num =
720: PO_PDOI_PARAMS.g_current_round_num
721: AND intf_lines.po_line_id = p_po_line_id_tbl(i)
722: AND intf_lines.po_line_id IS NOT NULL AND p_po_line_id_tbl(i) IS NOT NULL ) v

Line 720: PO_PDOI_PARAMS.g_current_round_num

716: WHERE intf_locs.interface_line_id = intf_lines.interface_line_id
717: AND intf_lines.interface_header_id = intf_headers.interface_header_id
718: AND intf_locs.processing_id = PO_PDOI_PARAMS.g_processing_id
719: AND intf_headers.processing_round_num =
720: PO_PDOI_PARAMS.g_current_round_num
721: AND intf_lines.po_line_id = p_po_line_id_tbl(i)
722: AND intf_lines.po_line_id IS NOT NULL AND p_po_line_id_tbl(i) IS NOT NULL ) v
723: WHERE v.max_shipment_num IS NOT NULL;
724:

Line 959: AND intf_locs.processing_id = PO_PDOI_PARAMS.g_processing_id

955: po_lines_interface intf_lines,
956: po_headers_interface intf_headers
957: WHERE intf_locs.interface_line_id = intf_lines.interface_line_id
958: AND intf_lines.interface_header_id = intf_headers.interface_header_id
959: AND intf_locs.processing_id = PO_PDOI_PARAMS.g_processing_id
960: AND intf_headers.processing_round_num =
961: PO_PDOI_PARAMS.g_current_round_num
962: AND intf_lines.po_line_id = p_po_line_id_tbl(i)
963: AND intf_locs.interface_line_location_id < p_intf_line_loc_id_tbl(i)

Line 961: PO_PDOI_PARAMS.g_current_round_num

957: WHERE intf_locs.interface_line_id = intf_lines.interface_line_id
958: AND intf_lines.interface_header_id = intf_headers.interface_header_id
959: AND intf_locs.processing_id = PO_PDOI_PARAMS.g_processing_id
960: AND intf_headers.processing_round_num =
961: PO_PDOI_PARAMS.g_current_round_num
962: AND intf_lines.po_line_id = p_po_line_id_tbl(i)
963: AND intf_locs.interface_line_location_id < p_intf_line_loc_id_tbl(i)
964: AND intf_locs.interface_line_location_id >= p_intf_line_loc_id_tbl(1)
965: AND intf_locs.shipment_num = p_shipment_num_tbl(i)

Line 1114: AND intf_dists.processing_id = PO_PDOI_PARAMS.g_processing_id

1110: po_headers_interface intf_headers
1111: WHERE intf_dists.interface_line_location_id =
1112: intf_locs.interface_line_location_id
1113: AND intf_locs.interface_header_id = intf_headers.interface_header_id
1114: AND intf_dists.processing_id = PO_PDOI_PARAMS.g_processing_id
1115: AND intf_headers.processing_round_num =
1116: PO_PDOI_PARAMS.g_current_round_num
1117: AND intf_locs.line_location_id = p_line_loc_id_tbl(i)) v
1118: WHERE v.max_dist_num IS NOT NULL;

Line 1116: PO_PDOI_PARAMS.g_current_round_num

1112: intf_locs.interface_line_location_id
1113: AND intf_locs.interface_header_id = intf_headers.interface_header_id
1114: AND intf_dists.processing_id = PO_PDOI_PARAMS.g_processing_id
1115: AND intf_headers.processing_round_num =
1116: PO_PDOI_PARAMS.g_current_round_num
1117: AND intf_locs.line_location_id = p_line_loc_id_tbl(i)) v
1118: WHERE v.max_dist_num IS NOT NULL;
1119:
1120: d_position := 30;

Line 1366: AND intf_dists.processing_id = PO_PDOI_PARAMS.g_processing_id

1362: po_headers_interface intf_headers
1363: WHERE intf_dists.interface_line_location_id =
1364: intf_locs.interface_line_location_id
1365: AND intf_locs.interface_header_id = intf_headers.interface_header_id
1366: AND intf_dists.processing_id = PO_PDOI_PARAMS.g_processing_id
1367: AND intf_headers.processing_round_num =
1368: PO_PDOI_PARAMS.g_current_round_num
1369: AND intf_locs.line_location_id = p_line_loc_id_tbl(i)
1370: AND intf_dists.interface_distribution_id < p_intf_dist_id_tbl(i)

Line 1368: PO_PDOI_PARAMS.g_current_round_num

1364: intf_locs.interface_line_location_id
1365: AND intf_locs.interface_header_id = intf_headers.interface_header_id
1366: AND intf_dists.processing_id = PO_PDOI_PARAMS.g_processing_id
1367: AND intf_headers.processing_round_num =
1368: PO_PDOI_PARAMS.g_current_round_num
1369: AND intf_locs.line_location_id = p_line_loc_id_tbl(i)
1370: AND intf_dists.interface_distribution_id < p_intf_dist_id_tbl(i)
1371: AND intf_dists.interface_distribution_id >= p_intf_dist_id_tbl(1)
1372: AND intf_dists.distribution_num = p_dist_num_tbl(i);