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.PON_AUCTION_INTERFACE_PKG dependencies on PON_BACKING_REQUISITIONS

Line 1303: pon_backing_requisitions pbr,

1299: BEGIN
1300: SELECT 'Y'
1301: INTO l_line_valid
1302: FROM pon_auction_item_prices_all paip,
1303: pon_backing_requisitions pbr,
1304: po_requisition_lines_all prl
1305: WHERE paip.auction_header_id = P_DOCUMENT_NUMBER
1306: AND paip.line_number = P_LINE_NUMBER
1307: AND paip.line_type_id = P_LINE_TYPE_ID

Line 1374: pon_backing_requisitions pbr,

1370: ELSE
1371: SELECT MAX(paip.line_number)
1372: INTO P_LINE_NUMBER
1373: FROM pon_auction_item_prices_all paip,
1374: pon_backing_requisitions pbr,
1375: po_requisition_lines_all prl
1376: WHERE paip.auction_header_id = P_DOCUMENT_NUMBER
1377: AND paip.line_type_id = P_LINE_TYPE_ID
1378: AND NVL(p_item_id, -1) = NVL(paip.item_id, -1)

Line 1705: -- Insert row into PON_BACKING_REQUISITIONS

1701: SET NUMBER_OF_LINES = P_LINE_NUMBER,
1702: LAST_LINE_NUMBER = P_LINE_NUMBER
1703: WHERE AUCTION_HEADER_ID = P_DOCUMENT_NUMBER;
1704: END IF;
1705: -- Insert row into PON_BACKING_REQUISITIONS
1706: v_debug_status := 'INSERT_PBR_YUMMY';
1707: logme(l_log_module, v_debug_status);
1708: INSERT
1709: INTO PON_BACKING_REQUISITIONS

Line 1709: INTO PON_BACKING_REQUISITIONS

1705: -- Insert row into PON_BACKING_REQUISITIONS
1706: v_debug_status := 'INSERT_PBR_YUMMY';
1707: logme(l_log_module, v_debug_status);
1708: INSERT
1709: INTO PON_BACKING_REQUISITIONS
1710: (
1711: AUCTION_HEADER_ID,
1712: LINE_NUMBER,
1713: REQUISITION_HEADER_ID,

Line 1974: pon_backing_requisitions pbr,

1970: IS
1971: SELECT DISTINCT paip.line_number,
1972: paip.ip_category_id
1973: FROM pon_auction_item_prices_all paip,
1974: pon_backing_requisitions pbr,
1975: po_requisition_lines_all prl
1976: WHERE paip.auction_header_id = p_document_number
1977: AND paip.auction_header_id = pbr.auction_header_id
1978: AND paip.line_number = pbr.line_number

Line 2560: pon_backing_requisitions ponbr,

2556: ponah.number_price_decimals number_price_decimals,
2557: NVL(prl.vendor_site_id, -1) vendor_site_id,
2558: NVL(ps.vendor_site_code, -1) vendor_site_code
2559: FROM po_requisition_lines_all prl,
2560: pon_backing_requisitions ponbr,
2561: pon_auction_headers_all ponah,
2562: po_vendors pv,
2563: po_vendor_sites_all ps
2564: WHERE ponah.auction_header_id = p_document_number

Line 2650: FROM pon_backing_requisitions

2646: CURSOR req_based_lines
2647: IS
2648: SELECT requisition_line_id ,
2649: line_number
2650: FROM pon_backing_requisitions
2651: WHERE auction_header_id = P_DOCUMENT_NUMBER;
2652: BEGIN
2653: logme(l_log_module, 'in maintain_clm_relations');
2654: FOR oneline IN req_based_lines

Line 2702: FROM pon_backing_requisitions

2698: IF ( p_req_line_clin IS NOT NULL ) THEN
2699: --first update group_line_id
2700: SELECT line_number
2701: INTO l_line_number
2702: FROM pon_backing_requisitions
2703: WHERE auction_header_id = p_document_number
2704: AND requisition_line_id = p_req_line_clin;
2705: UPDATE pon_auction_item_prices_all
2706: SET group_line_id = l_line_number

Line 2721: FROM pon_backing_requisitions

2717: IF ( p_req_line_opt IS NOT NULL ) THEN
2718: --update base line for option
2719: SELECT line_number
2720: INTO l_line_number
2721: FROM pon_backing_requisitions
2722: WHERE auction_header_id = p_document_number
2723: AND requisition_line_id = p_req_line_opt;
2724: UPDATE pon_auction_item_prices_all
2725: SET clm_base_line_num = l_line_number