APPS.PON_AUCTION_INTERFACE_PKG dependencies on PO_REQUISITION_LINES_ALL

Line 917: v_blanket_po_header_id po_requisition_lines_all.blanket_po_header_id%TYPE;

913: v_service_based_line VARCHAR2(1);
914: v_from_ip_catalog VARCHAR2(1);
915: l_line_exist VARCHAR2(1) := 'N';
916: l_line_valid VARCHAR2(1) := 'Y';
917: v_blanket_po_header_id po_requisition_lines_all.blanket_po_header_id%TYPE;
918: v_blanket_po_line_num po_requisition_lines_all.blanket_po_line_num%TYPE;
919: v_msg_count NUMBER; --
920: v_return_status VARCHAR2(1); --
921: v_doctype_id pon_auction_headers_all.doctype_id%TYPE; --

Line 918: v_blanket_po_line_num po_requisition_lines_all.blanket_po_line_num%TYPE;

914: v_from_ip_catalog VARCHAR2(1);
915: l_line_exist VARCHAR2(1) := 'N';
916: l_line_valid VARCHAR2(1) := 'Y';
917: v_blanket_po_header_id po_requisition_lines_all.blanket_po_header_id%TYPE;
918: v_blanket_po_line_num po_requisition_lines_all.blanket_po_line_num%TYPE;
919: v_msg_count NUMBER; --
920: v_return_status VARCHAR2(1); --
921: v_doctype_id pon_auction_headers_all.doctype_id%TYPE; --
922: need_by_dt pon_auction_item_prices_all.need_by_date%TYPE;

Line 1208: FROM po_requisition_lines_all

1204: SELECT blanket_po_header_id,
1205: blanket_po_line_num
1206: INTO v_blanket_po_header_id,
1207: v_blanket_po_line_num
1208: FROM po_requisition_lines_all
1209: WHERE requisition_header_id = p_requisition_header_id
1210: AND requisition_line_id = p_requisition_line_id;
1211: IF (v_blanket_po_header_id IS NOT NULL AND v_blanket_po_line_num IS NOT NULL) THEN
1212: -- get the ip category from the catalog

Line 1304: po_requisition_lines_all prl

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
1308: AND NVL(p_item_id, -1) = NVL(paip.item_id, -1)

Line 1375: po_requisition_lines_all prl

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)
1379: AND NVL(p_item_revision, -1) = NVL(paip.item_revision, -1)

Line 1684: FROM po_requisition_lines_all

1680: clm_period_perf_end_date
1681: INTO need_by_dt,
1682: pop_start_dt,
1683: pop_end_dt
1684: FROM po_requisition_lines_all
1685: WHERE requisition_header_id = p_requisition_header_id
1686: AND requisition_line_id = p_requisition_line_id;
1687: UPDATE pon_auction_item_prices_all
1688: SET clm_need_by_date = DECODE(V_CONTRACT_TYPE, 'BLANKET', to_date(NULL), need_by_dt),

Line 1975: po_requisition_lines_all prl

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
1979: AND pbr.requisition_header_id = prl.requisition_header_id

Line 2559: FROM po_requisition_lines_all prl,

2555: pv.party_id party_id,
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