APPS.PON_AUCTION_INTERFACE_PKG dependencies on PON_BACKING_REQUISITIONS

Line 777: pon_backing_requisitions pbr,

773:
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)

Line 1035: -- Insert row into PON_BACKING_REQUISITIONS

1031: AUCTION_HEADER_ID = P_DOCUMENT_NUMBER;
1032:
1033: END IF;
1034:
1035: -- Insert row into PON_BACKING_REQUISITIONS
1036: v_debug_status := 'INSERT_PBR_YUMMY';
1037: INSERT INTO PON_BACKING_REQUISITIONS (
1038: AUCTION_HEADER_ID,
1039: LINE_NUMBER,

Line 1037: INSERT INTO PON_BACKING_REQUISITIONS (

1033: END IF;
1034:
1035: -- Insert row into PON_BACKING_REQUISITIONS
1036: v_debug_status := 'INSERT_PBR_YUMMY';
1037: INSERT INTO PON_BACKING_REQUISITIONS (
1038: AUCTION_HEADER_ID,
1039: LINE_NUMBER,
1040: REQUISITION_HEADER_ID,
1041: REQUISITION_LINE_ID,

Line 1157: pon_backing_requisitions pbr,

1153:
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

Line 1716: pon_backing_requisitions ponbr,

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
1720: WHERE ponah.auction_header_id = p_document_number