[Home] [Help]
985: bh.bid_number,
986: bl.bid_currency_unit_price
987: BULK COLLECT INTO l_award_col, l_bid_number_col, l_bid_price_col
988: FROM pon_auction_item_prices_all itm,
989: pon_bid_item_prices bl,
990: pon_bid_headers bh,
991: pon_auction_headers_all pah
992: WHERE itm.auction_header_id = p_auctionID AND
993: itm.line_number = p_line_number AND
1783: , pbip.award_shipment_number
1784:
1785: FROM
1786: pon_auction_item_prices_all paip,
1787: pon_bid_item_prices pbip,
1788: mtl_units_of_measure mtluom,
1789: pon_bid_headers pbh,
1790: fnd_currencies fc
1791: WHERE pbip.bid_number = p_bid_number and
2384:
2385: --get the number of rows to be copied
2386: select nvl(max(line_number),0)
2387: into l_max_line_number
2388: from pon_bid_item_prices
2389: where bid_number = x_pdoi_header.bid_number;
2390:
2391: l_batch_size := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
2392: l_commit_flag := FALSE;
2506: ,'N') --Line_loc_populated
2507:
2508: FROM
2509: pon_auction_item_prices_all paip,
2510: pon_bid_item_prices pbip,
2511: mtl_units_of_measure mtluom,
2512: pon_bid_headers pbh,
2513: fnd_currencies fc,
2514: pon_bid_shipments pbs
2641: sysdate, -- creation_date
2642: x_user_id -- created_by
2643:
2644: FROM pon_auction_item_prices_all paip,
2645: pon_bid_item_prices pbip,
2646: pon_bid_payments_shipments bpys,
2647: pon_auc_payments_shipments apys,
2648: po_lines_interface pli,
2649: mtl_units_of_measure mtluom
2717:
2718: --get the number of rows to be copied
2719: select nvl(max(line_number),0)
2720: into l_max_line_number
2721: from pon_bid_item_prices
2722: where bid_number = x_pdoi_header.bid_number;
2723:
2724: -- always reset -> although it is not possible that both bpa+spo cases are satisfied :)
2725: l_batch_size := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
2827: decode(paip.order_type_lookup_code,
2828: 'FIXED PRICE', round(pbip.bid_currency_unit_price, fc.precision),
2829: null) -- amount
2830: FROM pon_auction_item_prices_all paip,
2831: pon_bid_item_prices pbip,
2832: mtl_units_of_measure mtluom,
2833: pon_bid_headers pbh,
2834: fnd_currencies fc,
2835: pon_bid_shipments pbs
2905: pbs.effective_end_date, -- expiration_date
2906: pbs.auction_header_id, -- auction_header_id
2907: pbs.auction_line_number -- auction_line_number
2908: FROM pon_auction_item_prices_all paip,
2909: pon_bid_item_prices pbip,
2910: pon_bid_shipments pbs,
2911: po_lines_interface pli
2912: WHERE pbip.bid_number = p_bid_number and
2913: pbip.auction_header_id = p_auction_header_id and
2955: sysdate, -- creation_date,
2956: p_user_id, -- created_by
2957: fnd_global.login_id -- last_update_login
2958: FROM pon_price_differentials ppd,
2959: pon_bid_item_prices pbip,
2960: pon_bid_price_differentials pbpd,
2961: pon_auction_headers_all pah,
2962: po_lines_interface pli
2963: WHERE pbip.bid_number = p_bid_number
3008: sysdate, -- creation_date,
3009: p_user_id, -- created_by
3010: fnd_global.login_id -- last_update_login
3011: FROM pon_price_differentials ppd,
3012: pon_bid_item_prices pbip,
3013: (select pbpd.bid_number, pbpd.line_number,
3014: pbpd.shipment_number, pbs.auction_shipment_number,
3015: pbpd.price_differential_number, pbpd.price_type,
3016: pbpd.multiplier, pbpd.auction_header_id
3193: icx.stored_in_table,
3194: icx.stored_in_column,
3195: pbav.value,
3196: paa.attribute_name
3197: FROM pon_bid_item_prices pbip,
3198: pon_auction_item_prices_all paip,
3199: po_lines_interface pli,
3200: pon_bid_attribute_values pbav,
3201: pon_auction_attributes paa,