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 280: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id

276: FROM (SELECT max(intf_lines.line_num) AS max_line_num
277: FROM po_lines_interface intf_lines,
278: po_headers_interface intf_headers
279: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
280: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
281: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
282: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
283: AND intf_headers.po_header_id = p_po_header_id_tbl(i)) v
284: WHERE v.max_line_num IS NOT NULL;

Line 281: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num

277: FROM po_lines_interface intf_lines,
278: po_headers_interface intf_headers
279: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
280: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
281: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
282: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
283: AND intf_headers.po_header_id = p_po_header_id_tbl(i)) v
284: WHERE v.max_line_num IS NOT NULL;
285:

Line 282: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id

278: po_headers_interface intf_headers
279: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
280: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
281: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
282: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
283: AND intf_headers.po_header_id = p_po_header_id_tbl(i)) v
284: WHERE v.max_line_num IS NOT NULL;
285:
286: d_position := 40;

Line 532: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id

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

Line 534: PO_PDOI_PARAMS.g_current_round_num

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

Line 659: IF (PO_PDOI_PARAMS.g_request.document_type =

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

Line 715: AND intf_locs.processing_id = PO_PDOI_PARAMS.g_processing_id

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

Line 717: PO_PDOI_PARAMS.g_current_round_num

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

Line 956: AND intf_locs.processing_id = PO_PDOI_PARAMS.g_processing_id

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

Line 958: PO_PDOI_PARAMS.g_current_round_num

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

Line 1111: AND intf_dists.processing_id = PO_PDOI_PARAMS.g_processing_id

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

Line 1113: PO_PDOI_PARAMS.g_current_round_num

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

Line 1363: AND intf_dists.processing_id = PO_PDOI_PARAMS.g_processing_id

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

Line 1365: PO_PDOI_PARAMS.g_current_round_num

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