[Home] [Help]
1044: bl.bid_currency_unit_price,
1045: Decode(Nvl(itm.clm_info_flag,'N'), 'Y', 1, 0) AS clm_info_indicator
1046: BULK COLLECT INTO l_award_col, l_bid_number_col, l_bid_price_col , l_clm_info_flag
1047: FROM pon_auction_item_prices_all itm,
1048: pon_bid_item_prices bl,
1049: pon_bid_headers bh,
1050: pon_auction_headers_all pah
1051: WHERE itm.auction_header_id = p_auctionID AND
1052: itm.line_number = p_line_number AND
1963: ,pbip.CLM_PROMISE_POP_DURATION
1964: ,pbip.CLM_PROMISE_POP_DURATION_UOM
1965: FROM
1966: pon_auction_item_prices_all paip,
1967: pon_bid_item_prices pbip,
1968: mtl_units_of_measure mtluom,
1969: pon_bid_headers pbh,
1970: fnd_currencies fc
1971: WHERE pbip.bid_number = p_bid_number and
2829:
2830: --get the number of rows to be copied
2831: select nvl(max(line_number),0)
2832: into l_max_line_number
2833: from pon_bid_item_prices
2834: where bid_number = x_pdoi_header.bid_number
2835: AND auction_line_number <> -1; --Unsolicited Lines Project
2836:
2837: l_batch_size := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
3008: ,Decode(Nvl(l_is_fed,'N'),'Y',pbip.CLM_PROMISE_POP_DURATION_UOM,null)
3009:
3010: FROM
3011: pon_auction_item_prices_all paip,
3012: pon_bid_item_prices pbip,
3013: mtl_units_of_measure mtluom,
3014: pon_bid_headers pbh,
3015: fnd_currencies fc,
3016: pon_bid_shipments pbs
3154: sysdate, -- creation_date
3155: x_user_id -- created_by
3156:
3157: FROM pon_auction_item_prices_all paip,
3158: pon_bid_item_prices pbip,
3159: pon_bid_payments_shipments bpys,
3160: pon_auc_payments_shipments apys,
3161: po_lines_interface pli,
3162: mtl_units_of_measure mtluom
3246:
3247: --get the number of rows to be copied
3248: select nvl(max(line_number),0)
3249: into l_max_line_number
3250: from pon_bid_item_prices
3251: where bid_number = x_pdoi_header.bid_number;
3252:
3253: -- always reset -> although it is not possible that both bpa+spo cases are satisfied :)
3254: l_batch_size := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
3402: , pbh.idv_header_id
3403: , pbip.idv_line_id
3404: , paip.exhibit_number --ELINs project
3405: FROM pon_auction_item_prices_all paip,
3406: pon_bid_item_prices pbip,
3407: mtl_units_of_measure mtluom,
3408: pon_bid_headers pbh,
3409: fnd_currencies fc,
3410: pon_bid_shipments pbs
3548: , paip.CLM_COST_CONSTRAINT
3549: , paip.CLM_IDC_TYPE
3550:
3551: FROM pon_auction_item_prices_all paip,
3552: pon_bid_item_prices pbip,
3553: pon_bid_shipments pbs,
3554: po_lines_interface pli
3555: WHERE pbip.bid_number = p_bid_number and
3556: pbip.auction_header_id = p_auction_header_id and
3598: sysdate, -- creation_date,
3599: p_user_id, -- created_by
3600: fnd_global.login_id -- last_update_login
3601: FROM pon_price_differentials ppd,
3602: pon_bid_item_prices pbip,
3603: pon_bid_price_differentials pbpd,
3604: pon_auction_headers_all pah,
3605: po_lines_interface pli
3606: WHERE pbip.bid_number = p_bid_number
3651: sysdate, -- creation_date,
3652: p_user_id, -- created_by
3653: fnd_global.login_id -- last_update_login
3654: FROM pon_price_differentials ppd,
3655: pon_bid_item_prices pbip,
3656: (select pbpd.bid_number, pbpd.line_number,
3657: pbpd.shipment_number, pbs.auction_shipment_number,
3658: pbpd.price_differential_number, pbpd.price_type,
3659: pbpd.multiplier, pbpd.auction_header_id
4085: icx.stored_in_table,
4086: icx.stored_in_column,
4087: pbav.value,
4088: paa.attribute_name
4089: FROM pon_bid_item_prices pbip,
4090: pon_auction_item_prices_all paip,
4091: po_lines_interface pli,
4092: pon_bid_attribute_values pbav,
4093: pon_auction_attributes paa,
4407: WHERE pbh.auction_header_id = p_auction_header_id and
4408: nvl(pbh.bid_status, 'NONE') = 'ACTIVE' and
4409: --pbh.po_header_id is NULL and
4410: nvl(pbh.award_status, 'NO') IN ('AWARDED', 'PARTIAL') and
4411: exists (select 1 from pon_bid_item_prices pbip
4412: where pbip.bid_number = pbh.bid_number
4413: and nvl(pbip.award_status,'NO') = 'AWARDED'
4414: and pbip.order_number is null)
4415: GROUP BY pbh.bid_number;
4701: where auction_header_id = p_auction_header_id and
4702: bid_number = x_bid_number;
4703:
4704: --Added for Staggered Awards, update order_number for each bid line
4705: UPDATE pon_bid_item_prices
4706: SET po_header_id = decode(x_error_code, PO_SUCCESS, x_po_header_id, null),
4707: order_number = x_order_number,
4708: po_error_code = x_error_code,
4709: po_error_msg = x_error_msg,
6103: l_user_id,
6104: l_login_id,
6105: SYSDATE
6106:
6107: FROM pon_bid_item_prices pbip,
6108: pon_bid_headers pbh,
6109: po_clmreq_lines_v prl,
6110: (SELECT pbip1.auction_header_id, pbip1.auction_line_number,pbip1.bid_number, pbip1.line_number AS bid_line_number,
6111: pbr.requisition_line_id, pbr.requisition_header_id
6108: pon_bid_headers pbh,
6109: po_clmreq_lines_v prl,
6110: (SELECT pbip1.auction_header_id, pbip1.auction_line_number,pbip1.bid_number, pbip1.line_number AS bid_line_number,
6111: pbr.requisition_line_id, pbr.requisition_header_id
6112: FROM pon_bid_item_references pir, pon_bid_backing_requisitions pbr, pon_bid_item_prices pbip1
6113: WHERE pir.auction_header_id = p_auction_header_id
6114: AND pir.auction_header_id = pbr.auction_header_id
6115: AND pir.auction_line_number = pbr.auction_line_number
6116: AND pir.bid_number = pbip1.bid_number
6122: FROM pon_bid_backing_requisitions pbr
6123: WHERE pbr.auction_header_id = p_auction_header_id) pbrv,
6124:
6125: (SELECT pbrv1.requisition_line_id, sum (pbip.award_quantity * pbip.award_price) AS tot_bid_line_amount
6126: FROM pon_bid_item_prices pbip,
6127: (SELECT pbip1.auction_header_id, pbip1.auction_line_number,pbip1.bid_number, pbip1.line_number AS bid_line_number,
6128: pbr.requisition_line_id, pbr.requisition_header_id
6129: FROM pon_bid_item_references pir, pon_bid_backing_requisitions pbr, pon_bid_item_prices pbip1
6130: WHERE pir.auction_header_id = p_auction_header_id
6125: (SELECT pbrv1.requisition_line_id, sum (pbip.award_quantity * pbip.award_price) AS tot_bid_line_amount
6126: FROM pon_bid_item_prices pbip,
6127: (SELECT pbip1.auction_header_id, pbip1.auction_line_number,pbip1.bid_number, pbip1.line_number AS bid_line_number,
6128: pbr.requisition_line_id, pbr.requisition_header_id
6129: FROM pon_bid_item_references pir, pon_bid_backing_requisitions pbr, pon_bid_item_prices pbip1
6130: WHERE pir.auction_header_id = p_auction_header_id
6131:
6132: AND pir.auction_header_id = pbr.auction_header_id
6133: AND pir.auction_line_number = pbr.auction_line_number
6182: --equate allocated funds to bid_line_amount
6183: THEN ((paa.allocated_funds * (pbip.award_quantity * pbip.award_price ))/tot_amt_per_bid.allocated_funds )
6184: ELSE paa.allocated_funds
6185: END
6186: FROM pon_bid_item_prices pbip,
6187: (SELECT paa1.bid_number, paa1.bid_line_number, Sum(paa1.allocated_funds) AS allocated_funds
6188: FROM pon_award_allocations paa1
6189: GROUP BY (paa1.bid_number, paa1.bid_line_number)) tot_amt_per_bid
6190: WHERE paa.auction_header_id = p_auction_header_id