APPS.PON_AUCTION_INTERFACE_PKG dependencies on PO_REQUISITION_LINES_ALL

Line 502: v_blanket_po_header_id po_requisition_lines_all.blanket_po_header_id%TYPE;

498: v_att_category_id fnd_document_categories.category_id%TYPE;
499: v_service_based_line VARCHAR2(1);
500: v_from_ip_catalog VARCHAR2(1);
501:
502: v_blanket_po_header_id po_requisition_lines_all.blanket_po_header_id%TYPE;
503: v_blanket_po_line_num po_requisition_lines_all.blanket_po_line_num%TYPE;
504:
505: BEGIN
506: IF (P_DOCUMENT_NUMBER IS NULL) THEN

Line 503: v_blanket_po_line_num po_requisition_lines_all.blanket_po_line_num%TYPE;

499: v_service_based_line VARCHAR2(1);
500: v_from_ip_catalog VARCHAR2(1);
501:
502: v_blanket_po_header_id po_requisition_lines_all.blanket_po_header_id%TYPE;
503: v_blanket_po_line_num po_requisition_lines_all.blanket_po_line_num%TYPE;
504:
505: BEGIN
506: IF (P_DOCUMENT_NUMBER IS NULL) THEN
507: P_RESULT := error;

Line 718: FROM po_requisition_lines_all

714: IF (p_contract_type = 'BLANKET') THEN
715:
716: SELECT blanket_po_header_id, blanket_po_line_num
717: INTO v_blanket_po_header_id, v_blanket_po_line_num
718: FROM po_requisition_lines_all
719: WHERE requisition_header_id = p_requisition_header_id and
720: requisition_line_id = p_requisition_line_id;
721:
722: IF (v_blanket_po_header_id is not null and v_blanket_po_line_num is not null) THEN

Line 778: po_requisition_lines_all prl

774: SELECT max(paip.line_number)
775: INTO P_LINE_NUMBER
776: FROM pon_auction_item_prices_all paip,
777: pon_backing_requisitions pbr,
778: po_requisition_lines_all prl
779: WHERE paip.auction_header_id = P_DOCUMENT_NUMBER
780: AND paip.line_type_id = P_LINE_TYPE_ID
781: AND nvl(p_item_id, -1) = nvl(paip.item_id, -1)
782: AND nvl(p_item_revision, -1) = nvl(paip.item_revision, -1)

Line 1158: po_requisition_lines_all prl

1154: CURSOR nonCatalogLines IS
1155: SELECT distinct paip.line_number, paip.ip_category_id
1156: FROM pon_auction_item_prices_all paip,
1157: pon_backing_requisitions pbr,
1158: po_requisition_lines_all prl
1159: WHERE paip.auction_header_id = p_document_number and
1160: paip.auction_header_id = pbr.auction_header_id and
1161: paip.line_number = pbr.line_number and
1162: pbr.requisition_header_id = prl.requisition_header_id and

Line 1715: FROM po_requisition_lines_all prl,

1711: pv.party_id party_id,
1712: ponah.number_price_decimals number_price_decimals,
1713: nvl(prl.vendor_site_id, -1) vendor_site_id,
1714: nvl(ps.vendor_site_code, -1) vendor_site_code
1715: FROM po_requisition_lines_all prl,
1716: pon_backing_requisitions ponbr,
1717: pon_auction_headers_all ponah,
1718: po_vendors pv,
1719: po_vendor_sites_all ps