eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_AWARD_PKG dependencies on PON_BID_ITEM_PRICES

Line 17: * from pon_bid_item_prices table.

13: p_auctioneer_id IN Number);
14:
15: /* Bug : 16721126 : This function checks if supplier placed offer on a line or not?
16: * If supplier does not place offer on a line, record is deleted
17: * from pon_bid_item_prices table.
18: */
19: FUNCTION check_bid_line_exist(p_auction_header_id IN Number,
20: p_bid_number IN NUMBER,
21: p_line_number IN NUMBER)

Line 30: FROM pon_bid_item_prices

26: BEGIN
27:
28: SELECT Count(1)
29: INTO l_count
30: FROM pon_bid_item_prices
31: WHERE auction_header_id = p_auction_header_id
32: AND bid_number = p_bid_number
33: AND auction_line_number = p_line_number;
34:

Line 234: from pon_bid_item_prices

230:
231: -- just set award_qty same as bid_qty
232: select nvl(max(line_number),0)
233: into l_max_line_number
234: from pon_bid_item_prices
235: where bid_number = p_bid_number
236: AND auction_line_number <> -1; --Unsolicited Lines Project : Fetch only solicitation lines.
237:
238: l_batch_size := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;

Line 251: UPDATE PON_BID_ITEM_PRICES pbip

247:
248:
249: WHILE (l_batch_start <= l_max_line_number) LOOP --{ main-batching-loop
250:
251: UPDATE PON_BID_ITEM_PRICES pbip
252: SET
253: (pbip.award_status,
254: pbip.award_quantity,
255: pbip.award_date,

Line 366: pon_bid_item_prices pbip,

362: g_AWARD_QUOTE,
363: p_award_date,
364: p_auctioneer_id
365: from
366: pon_bid_item_prices pbip,
367: pon_auction_headers_all paha
368: where pbip.bid_number = p_bid_number
369: and pbip.auction_header_id = paip.auction_header_id
370: and pbip.line_number = paip.line_number

Line 440: pon_bid_item_prices bl,

436: bl.bid_number,
437: bl.order_number,
438: bl.award_quantity
439: from pon_auction_item_prices_all al,
440: pon_bid_item_prices bl,
441: pon_bid_headers bh
442: where al.auction_header_id = p_auction_header_id
443: and bl.auction_header_id = al.auction_header_id
444: and bl.line_number = al.line_number

Line 468: x_award_quantity pon_bid_item_prices.award_quantity%type;

464: x_old_line_number pon_auction_item_prices_all.line_number%type;
465: x_line_origination_code pon_auction_item_prices_all.line_origination_code%type;
466: x_bid_number pon_bid_headers.bid_number%type;
467: x_order_number pon_bid_headers.order_number%type;
468: x_award_quantity pon_bid_item_prices.award_quantity%type;
469: x_line_award_status pon_auction_item_prices_all.award_status%type;
470: x_stored_note_to_rejected pon_acceptances.reason%type;
471: x_error_code VARCHAR2(20);
472:

Line 697: pon_bid_item_prices pbip,

693: AND line_origination_code = 'REQUISITION'
694: AND NOT EXISTS
695: (SELECT 1
696: FROM pon_auction_headers_all pah,
697: pon_bid_item_prices pbip,
698: pon_bid_item_references pbir
699: WHERE pah.auction_header_id = p_auction_header_id
700: AND Nvl(pah.ALLOW_UNSOL_OFFER_LINES,'N') = 'Y'
701: AND pbip.auction_header_id = pah.auction_header_id

Line 1042: FROM pon_bid_item_prices

1038: exit when all_bidders%notfound;
1039:
1040: SELECT Count(*)
1041: INTO x_completed_lines
1042: FROM pon_bid_item_prices
1043: WHERE auction_header_id = p_auction_header_id
1044: AND bid_number = x_bid_number
1045: AND auction_line_number IN (SELECT line_number FROM pon_auction_item_prices_all WHERE auction_header_id = p_auction_header_id AND Nvl(award_status, 'NO') = 'COMPLETED');
1046:

Line 1148: l_award_price pon_bid_item_prices.award_price%TYPE;

1144: AND paip.auction_header_id = paed.auction_header_id
1145: AND paip.exhibit_number IS NOT NULL
1146: AND paip.exhibit_number = paed.exhibit_number ;
1147:
1148: l_award_price pon_bid_item_prices.award_price%TYPE;
1149: l_award_quantity pon_bid_item_prices.award_quantity%TYPE;
1150: l_size NUMBER;
1151: l_index NUMBER;
1152: l_auction_award_qty NUMBER;

Line 1149: l_award_quantity pon_bid_item_prices.award_quantity%TYPE;

1145: AND paip.exhibit_number IS NOT NULL
1146: AND paip.exhibit_number = paed.exhibit_number ;
1147:
1148: l_award_price pon_bid_item_prices.award_price%TYPE;
1149: l_award_quantity pon_bid_item_prices.award_quantity%TYPE;
1150: l_size NUMBER;
1151: l_index NUMBER;
1152: l_auction_award_qty NUMBER;
1153:

Line 1181: FROM pon_bid_item_prices pbip,

1177: 'FIXED PRICE', 1,
1178: 'AMOUNT', 1,
1179: 'RATE', decode (paip.purchase_basis, 'TEMP LABOR', pbip.quantity, 1), pbip.quantity ))
1180: INTO l_award_quantity
1181: FROM pon_bid_item_prices pbip,
1182: pon_auction_item_prices_all paip
1183: WHERE pbip.bid_number = p_award_lines(l_index).bid_Number
1184: AND pbip.auction_line_number = elin.line_number
1185: AND paip.auction_header_id = pbip.auction_header_id

Line 1195: FROM pon_bid_item_prices pbip,

1191:
1192: SELECT decode(pbip.award_status, 'REJECTED', null,
1193: pbip.per_unit_price_component + pbip.fixed_amount_component /l_award_quantity)
1194: INTO l_award_price
1195: FROM pon_bid_item_prices pbip,
1196: pon_auction_item_prices_all paip
1197: WHERE pbip.bid_number = p_award_lines(l_index).bid_Number
1198: AND pbip.auction_line_number = elin.line_number
1199: AND paip.auction_header_id = pbip.auction_header_id

Line 1204: UPDATE pon_bid_item_prices pbip

1200: AND paip.line_number = pbip.line_number;
1201:
1202: END IF;
1203:
1204: UPDATE pon_bid_item_prices pbip
1205: SET award_price = l_award_price,
1206: award_quantity = l_award_quantity
1207: WHERE pbip.bid_number = p_award_lines(l_index).bid_Number
1208: AND pbip.auction_line_number = elin.line_number;

Line 1235: l_award_price pon_bid_item_prices.award_price%TYPE;

1231: p_auctioneer_id IN Number)
1232: IS
1233: l_parent_line pon_auction_item_prices_all.line_number%TYPE;
1234: is_parent_slin VARCHAR2(1);
1235: l_award_price pon_bid_item_prices.award_price%TYPE;
1236: l_award_quantity pon_bid_item_prices.award_quantity%TYPE;
1237: l_size NUMBER;
1238: l_index NUMBER;
1239: l_auction_award_qty NUMBER;

Line 1236: l_award_quantity pon_bid_item_prices.award_quantity%TYPE;

1232: IS
1233: l_parent_line pon_auction_item_prices_all.line_number%TYPE;
1234: is_parent_slin VARCHAR2(1);
1235: l_award_price pon_bid_item_prices.award_price%TYPE;
1236: l_award_quantity pon_bid_item_prices.award_quantity%TYPE;
1237: l_size NUMBER;
1238: l_index NUMBER;
1239: l_auction_award_qty NUMBER;
1240: l_award_status VARCHAR2(10);

Line 1265: UPDATE PON_BID_ITEM_PRICES

1261: FOR l_index IN 1..l_size LOOP
1262:
1263: /* Bug : 16721126 : Update parent only when offer exisits on parent line. */
1264: IF check_bid_line_exist(p_auction_header_id, p_award_lines(l_index).bid_number, l_parent_line) = 1 THEN
1265: UPDATE PON_BID_ITEM_PRICES
1266: set award_status = p_award_lines(l_index).award_status,
1267: award_date = p_award_lines(l_index).award_date,
1268: last_update_date = p_award_lines(l_index).award_date,
1269: last_updated_by = p_auctioneer_id

Line 1305: FROM pon_bid_item_prices pbip,

1301: 'FIXED PRICE', 1,
1302: 'AMOUNT', 1,
1303: 'RATE', decode (paip.purchase_basis, 'TEMP LABOR', pbip.quantity, 1), pbip.quantity ))
1304: INTO l_award_quantity
1305: FROM pon_bid_item_prices pbip,
1306: pon_auction_item_prices_all paip
1307: WHERE pbip.bid_number = p_award_lines(l_index).bid_Number
1308: AND pbip.auction_line_number = l_parent_line
1309: AND paip.auction_header_id = pbip.auction_header_id

Line 1319: FROM pon_bid_item_prices pbip,

1315:
1316: SELECT decode(pbip.award_status, 'REJECTED', null,
1317: pbip.per_unit_price_component + pbip.fixed_amount_component /l_award_quantity)
1318: INTO l_award_price
1319: FROM pon_bid_item_prices pbip,
1320: pon_auction_item_prices_all paip
1321: WHERE pbip.bid_number = p_award_lines(l_index).bid_Number
1322: AND pbip.auction_line_number = l_parent_line
1323: AND paip.auction_header_id = pbip.auction_header_id

Line 1328: UPDATE pon_bid_item_prices pbip

1324: AND paip.line_number = pbip.line_number;
1325:
1326: END IF;
1327:
1328: UPDATE pon_bid_item_prices pbip
1329: SET award_price = l_award_price,
1330: award_quantity = l_award_quantity
1331: WHERE pbip.bid_number = p_award_lines(l_index).bid_Number
1332: AND pbip.auction_line_number = l_parent_line;

Line 1551: FROM pon_bid_item_prices bi, pon_auction_item_prices_all ai

1547: -- Construct Matrix only in case of awarded bids
1548: IF l_rec.award_outcome = g_AWARD_OUTCOME_WIN THEN
1549: IF ( l_neg_contract_type = 'BLANKET' ) THEN --Get Award Qty FROM Response Qty
1550: SELECT decode (ai.order_type_lookup_code, 'FIXED PRICE', 1, 'AMOUNT', 1, 'RATE', decode(ai.purchase_basis , 'TEMP LABOR' ,bi.quantity, 1) , ai.quantity) INTO l_tmp_award_quantity
1551: FROM pon_bid_item_prices bi, pon_auction_item_prices_all ai
1552: WHERE bi.bid_number = l_rec.bid_number
1553: AND bi.line_number = l_rec.line_number
1554: AND ai.auction_header_id = bi.auction_header_id
1555: AND ai.line_number = bi.line_number;

Line 1558: FROM pon_bid_item_prices bi, pon_auction_item_prices_all ai

1554: AND ai.auction_header_id = bi.auction_header_id
1555: AND ai.line_number = bi.line_number;
1556: ELSE ---- Get Award Qty FROM response Qty
1557: SELECT decode (ai.order_type_lookup_code, 'FIXED PRICE', 1, 'AMOUNT', 1, 'RATE', decode(ai.purchase_basis , 'TEMP LABOR' ,bi.quantity, 1) , bi.quantity) INTO l_tmp_award_quantity
1558: FROM pon_bid_item_prices bi, pon_auction_item_prices_all ai
1559: WHERE bi.bid_number = l_rec.bid_number
1560: AND bi.line_number = l_rec.line_number
1561: AND ai.auction_header_id = bi.auction_header_id
1562: AND ai.line_number = bi.line_number;

Line 1566: FROM pon_bid_item_prices bi, pon_auction_item_prices_all ai

1562: AND ai.line_number = bi.line_number;
1563: END IF;
1564: --
1565: SELECT ai.group_type INTO l_group_type
1566: FROM pon_bid_item_prices bi, pon_auction_item_prices_all ai
1567: WHERE bi.bid_number = l_rec.bid_number
1568: AND bi.line_number = l_rec.line_number
1569: AND ai.auction_header_id = bi.auction_header_id
1570: AND ai.line_number = bi.line_number;

Line 1633: from pon_bid_item_prices

1629: l_rec := p_award_table(l_index);
1630:
1631: --R12.1 price tiers changes
1632: select nvl(has_quantity_tiers,'N') into l_has_quantity_tiers
1633: from pon_bid_item_prices
1634: where bid_number = l_rec.bid_number
1635: and line_number = p_line_num;
1636:
1637: IF (g_debug_mode = 'Y') THEN

Line 1701: , 'PON_BID_ITEM_PRICES'

1697: Values(
1698: p_batch_id
1699: , fnd_message.get_string('PON','PON_AUCTION_AWARD_QTY')
1700: , 'PON_QUANTITY_TIER_VIOLATION' || l_suffix
1701: , 'PON_BID_ITEM_PRICES'
1702: , p_line_num
1703: , SYSDATE+7
1704: , fnd_global.user_id
1705: , sysdate

Line 1907: SELECT Count(*) INTO l_awarded_subline from PON_BID_ITEM_PRICES

1903: l_size := p_award_lines.count;
1904: for l_index in 1..l_size loop
1905:
1906: --Mark Clin AS awarded IF ANY one of slin IS awarded
1907: SELECT Count(*) INTO l_awarded_subline from PON_BID_ITEM_PRICES
1908: WHERE bid_number = p_award_lines(l_index).bid_number
1909: AND group_line_id = p_line_num
1910: AND award_status = 'AWARDED';
1911:

Line 1913: UPDATE PON_BID_ITEM_PRICES

1909: AND group_line_id = p_line_num
1910: AND award_status = 'AWARDED';
1911:
1912: IF (l_awarded_subline > 0) THEN
1913: UPDATE PON_BID_ITEM_PRICES
1914: set award_status = 'AWARDED',
1915: award_date = p_award_lines(l_index).award_date,
1916: last_update_date = p_award_lines(l_index).award_date,
1917: last_updated_by = p_auctioneer_id

Line 1921: UPDATE PON_BID_ITEM_PRICES

1917: last_updated_by = p_auctioneer_id
1918: where bid_number = p_award_lines(l_index).bid_number
1919: and line_number = p_line_num;
1920: ELSE
1921: UPDATE PON_BID_ITEM_PRICES
1922: set award_status = p_award_lines(l_index).award_status,
1923: award_date = p_award_lines(l_index).award_date,
1924: last_update_date = p_award_lines(l_index).award_date,
1925: last_updated_by = p_auctioneer_id

Line 1971: l_award_price pon_bid_item_prices.award_price%TYPE;

1967: p_auctioneer_id IN Number)
1968: IS
1969: Cursor optCursor Is select line_number from pon_auction_item_prices_all where
1970: auction_header_id = p_auction_header_id and clm_base_line_num = p_line_num;
1971: l_award_price pon_bid_item_prices.award_price%TYPE;
1972: l_award_quantity pon_bid_item_prices.award_quantity%TYPE;
1973: l_size NUMBER;
1974: l_index NUMBER;
1975: l_auction_award_qty NUMBER; -- bug 9940219

Line 1972: l_award_quantity pon_bid_item_prices.award_quantity%TYPE;

1968: IS
1969: Cursor optCursor Is select line_number from pon_auction_item_prices_all where
1970: auction_header_id = p_auction_header_id and clm_base_line_num = p_line_num;
1971: l_award_price pon_bid_item_prices.award_price%TYPE;
1972: l_award_quantity pon_bid_item_prices.award_quantity%TYPE;
1973: l_size NUMBER;
1974: l_index NUMBER;
1975: l_auction_award_qty NUMBER; -- bug 9940219
1976:

Line 2015: FROM pon_bid_item_prices pbip,

2011: 'FIXED PRICE', 1,
2012: 'AMOUNT', 1,
2013: 'RATE', decode (paip.purchase_basis, 'TEMP LABOR', pbip.quantity, 1), pbip.quantity ))
2014: INTO l_award_quantity
2015: FROM pon_bid_item_prices pbip,
2016: pon_auction_item_prices_all paip
2017: WHERE pbip.bid_number = p_award_lines(l_index).bid_Number
2018: AND pbip.auction_line_number = optLine.line_number
2019: AND paip.auction_header_id = pbip.auction_header_id

Line 2029: FROM pon_bid_item_prices pbip,

2025: IF (l_award_quantity <> 0 ) THEN
2026: SELECT decode(pbip.award_status, 'REJECTED', null,
2027: pbip.per_unit_price_component + pbip.fixed_amount_component /l_award_quantity)
2028: INTO l_award_price
2029: FROM pon_bid_item_prices pbip,
2030: pon_auction_item_prices_all paip
2031: WHERE pbip.bid_number = p_award_lines(l_index).bid_Number
2032: AND pbip.auction_line_number = optLine.line_number
2033: AND paip.auction_header_id = pbip.auction_header_id

Line 2038: UPDATE pon_bid_item_prices pbip

2034: AND paip.line_number = pbip.line_number;
2035:
2036: END IF;
2037:
2038: UPDATE pon_bid_item_prices pbip
2039: SET award_price = l_award_price,
2040: award_quantity = l_award_quantity
2041: WHERE pbip.bid_number = p_award_lines(l_index).bid_Number
2042: AND pbip.auction_line_number = optLine.line_number;

Line 2151: pon_bid_item_prices pbip

2147: CURSOR get_elins_for_line IS
2148: SELECT paip.line_number
2149: FROM pon_auction_exhibit_details exhibit,
2150: pon_auction_item_prices_all paip,
2151: pon_bid_item_prices pbip
2152: WHERE exhibit.auction_header_id = p_auction_id
2153: AND exhibit.associated_to_line = p_line_number
2154: AND paip.auction_header_id = exhibit.auction_header_id
2155: AND paip.exhibit_number IS NOT NULL

Line 2179: FROM pon_bid_item_prices bi, pon_auction_item_prices_all ai

2175: END IF;
2176: IF Nvl(p_award_status, 'REJECTED') = 'AWARDED' THEN
2177: IF ( p_contract_type IN ('BLANKET','CONTRACT') ) THEN --Get Award Qty FROM Response Qty
2178: SELECT decode (ai.order_type_lookup_code, 'FIXED PRICE', 1, 'AMOUNT', 1, 'RATE', decode(ai.purchase_basis , 'TEMP LABOR' ,bi.quantity, 1) , ai.quantity) INTO l_tmp_award_quantity
2179: FROM pon_bid_item_prices bi, pon_auction_item_prices_all ai
2180: WHERE bi.bid_number = p_bid_number
2181: AND bi.line_number = elin.line_number
2182: AND ai.auction_header_id = bi.auction_header_id
2183: AND ai.line_number = bi.line_number;

Line 2186: FROM pon_bid_item_prices bi, pon_auction_item_prices_all ai

2182: AND ai.auction_header_id = bi.auction_header_id
2183: AND ai.line_number = bi.line_number;
2184: ELSE ---- Get Award Qty FROM response Qty
2185: SELECT decode (ai.order_type_lookup_code, 'FIXED PRICE', 1, 'AMOUNT', 1, 'RATE', decode(ai.purchase_basis , 'TEMP LABOR' ,bi.quantity, 1) , bi.quantity) INTO l_tmp_award_quantity
2186: FROM pon_bid_item_prices bi, pon_auction_item_prices_all ai
2187: WHERE bi.bid_number = p_bid_number
2188: AND bi.line_number = elin.line_number
2189: AND ai.auction_header_id = bi.auction_header_id
2190: AND ai.line_number = bi.line_number;

Line 2199: UPDATE PON_BID_ITEM_PRICES pbip

2195: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.update_bid_exhibit_lines', 'Updating line : ' || elin.line_number || ' Quantity : ' ||l_tmp_award_quantity);
2196: END IF;
2197: END IF;
2198:
2199: UPDATE PON_BID_ITEM_PRICES pbip
2200: SET award_quantity = Decode(Nvl(p_award_status, 'REJECTED'), 'REJECTED', null, l_tmp_award_quantity),
2201: award_price = Decode(Nvl(p_award_status, 'REJECTED'), 'REJECTED', null,
2202: decode(nvl(l_tmp_award_quantity, 0), 0, pbip.price,
2203: pbip.per_unit_price_component + pbip.fixed_amount_component /l_tmp_award_quantity)),

Line 2233: l_award_quantity pon_bid_item_prices.award_quantity%type;

2229: IS
2230: l_size NUMBER;
2231: l_index NUMBER;
2232: l_group_type pon_auction_item_prices_all.group_type%type;
2233: l_award_quantity pon_bid_item_prices.award_quantity%type;
2234: l_award_shipment_number NUMBER;
2235: --
2236: /* for updating group for each bid's group line,
2237: we maintain an associative array (hashmap equivalant)

Line 2246: l_bid_number pon_bid_item_prices.bid_number%type;

2242: type bid_line_asso is table of varchar2(30) index by varchar2(30);
2243: l_bid_group_map bid_line_asso;
2244: l_bid_line_key VARCHAR2(30);
2245: l_parent_line_number pon_auction_item_prices_all.parent_line_number%type;
2246: l_bid_number pon_bid_item_prices.bid_number%type;
2247:
2248: --ELINs project
2249: l_are_exhibits_enabled VARCHAR2(1);
2250: l_org_id pon_auction_headers_all.org_id%TYPE;

Line 2439: FROM pon_bid_item_prices pbip,

2435: SELECT decode(p_award_status, 'REJECTED', null,
2436: decode(nvl(p_award_quantity,0), 0,pbip.price,
2437: pbip.per_unit_price_component + pbip.fixed_amount_component /p_award_quantity))
2438: INTO l_award_price
2439: FROM pon_bid_item_prices pbip,
2440: pon_auction_item_prices_all paip
2441: WHERE pbip.bid_number = p_bid_number
2442: AND pbip.line_number = p_line_number
2443: AND paip.auction_header_id = pbip.auction_header_id

Line 2455: UPDATE PON_BID_ITEM_PRICES

2451:
2452: --
2453: -- as this procedure will be called only if price tiers are not applicable so reseting the award_Shipment_number
2454: --
2455: UPDATE PON_BID_ITEM_PRICES
2456: SET award_quantity = p_award_quantity,
2457: award_price = l_award_price,
2458: award_status = p_award_status,
2459: award_date = p_award_date,

Line 2468: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_SINGLE_BID_ITEM_PRICES', 'PON_BID_ITEM_PRICES has been updated. Returning to the caller....');

2464: Line_Number = p_line_number;
2465:
2466: IF (g_debug_mode = 'Y') THEN
2467: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2468: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPDATE_SINGLE_BID_ITEM_PRICES', 'PON_BID_ITEM_PRICES has been updated. Returning to the caller....');
2469: END IF;
2470: END IF;
2471:
2472: END update_single_bid_item_prices;

Line 2484: * corresponding to the award shipment number. PON_BID_ITEM_PRICES is updated accordingly

2480: * 5. p_award_date -- Award Datw
2481: * 6. p_auctioneer_id - Id of person who is saving award
2482: * 7. p_award_shipment_number - Quantity awarded falls in the tiers range corresponding to the shipment number
2483: * COMMENT : This procedure calculates the award price based on the per unit and fixed amount component and
2484: * corresponding to the award shipment number. PON_BID_ITEM_PRICES is updated accordingly
2485: *==========================================================================================================================*/
2486: PROCEDURE upd_single_bid_item_prices_qt
2487: (
2488: p_bid_number IN NUMBER,

Line 2518: FROM pon_bid_item_prices pbip,

2514: SELECT DECODE(p_award_status, 'REJECTED', NULL,
2515: DECODE (NVL(p_award_quantity,0), 0, pbs.price,
2516: pbs.per_unit_price_component+pbip.fixed_amount_component/p_award_quantity))
2517: INTO l_award_price
2518: FROM pon_bid_item_prices pbip,
2519: pon_auction_item_prices_all paip,
2520: pon_bid_shipments pbs
2521: WHERE pbip.bid_number = p_bid_number
2522: AND pbip.line_number = p_line_number

Line 2535: UPDATE PON_BID_ITEM_PRICES

2531: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPD_SINGLE_BID_ITEM_PRICES_QT', 'award_price: ' || l_award_price);
2532: END IF; --}
2533: END IF; --}
2534:
2535: UPDATE PON_BID_ITEM_PRICES
2536: SET award_quantity = p_award_quantity,
2537: award_status = p_award_status,
2538: award_date = p_award_date,
2539: last_update_date = p_award_date,

Line 2548: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPD_SINGLE_BID_ITEM_PRICES_QT', 'PON_BID_ITEM_PRICES has been updated. Returning to the caller....');

2544: Line_Number = p_line_number;
2545:
2546: IF (g_debug_mode = 'Y') THEN
2547: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2548: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, 'pon.plsql.PON_AWARD_PKG.UPD_SINGLE_BID_ITEM_PRICES_QT', 'PON_BID_ITEM_PRICES has been updated. Returning to the caller....');
2549: END IF;
2550: END IF;
2551:
2552: END upd_single_bid_item_prices_qt;

Line 2574: SELECT bh.bid_number,Decode((SELECT Count(*) FROM pon_bid_item_prices pbip WHERE pbip.bid_number = bh.bid_number),0,'N','Y') has_lines

2570: AND bid_status = 'ACTIVE';
2571:
2572: /* Unsolicited Lines Project : New cursor if unsol lines are allowed. Check if lines exist in each bid or not. */
2573: CURSOR c_unsol_active_bids (c_auction_id NUMBER) is
2574: SELECT bh.bid_number,Decode((SELECT Count(*) FROM pon_bid_item_prices pbip WHERE pbip.bid_number = bh.bid_number),0,'N','Y') has_lines
2575: FROM pon_bid_headers bh
2576: WHERE bh.auction_header_id = c_auction_id
2577: AND bid_status = 'ACTIVE';
2578:

Line 2689: FROM pon_bid_item_prices bi, pon_auction_item_prices_all ai

2685:
2686: ((SELECT bi.Line_number,
2687: bi.award_status,
2688: nvl(bi.award_price , bi.price) * bi.award_quantity award_price
2689: FROM pon_bid_item_prices bi, pon_auction_item_prices_all ai
2690: WHERE bi.bid_number = c_bid_number
2691: and bi.auction_header_id = ai.auction_header_id
2692: and bi.line_number = ai.line_number
2693: and ai.group_type in ('LOT', 'LINE', 'GROUP_LINE'))

Line 2698: FROM pon_bid_item_prices pbip

2694: UNION
2695: (SELECT pbip.line_number,
2696: pbip.award_status,
2697: nvl(pbip.award_price , pbip.price) * pbip.award_quantity award_price
2698: FROM pon_bid_item_prices pbip
2699: WHERE pbip.bid_number = c_bid_number
2700: AND pbip.auction_line_number = -1));
2701:
2702: l_bid_lines_rec c_bid_lines%ROWTYPE;

Line 2856: FROM pon_bid_item_prices bi,

2852: ai.order_type_lookup_code,
2853: bi.award_status,
2854: bi.award_quantity,
2855: ai.group_type
2856: FROM pon_bid_item_prices bi,
2857: pon_bid_headers bh,
2858: pon_auction_item_prices_all ai
2859: WHERE bi.auction_header_id = c_auction_id
2860: AND bi.line_number = c_line_number

Line 3032: FROM pon_bid_item_prices

3028: * award_status as 'PARTIAL'
3029: */
3030: SELECT sum(Decode(award_status, 'AWARDED', 1, 0))
3031: INTO l_awarded_unsol_line_count
3032: FROM pon_bid_item_prices
3033: WHERE auction_header_id = p_auction_id
3034: AND auction_line_number = -1;
3035:
3036: IF l_awarded_unsol_line_count > 0 THEN

Line 3143: FROM pon_bid_item_prices bi, pon_bid_headers bh, pon_auction_item_prices_all ai

3139: p_award_date,
3140: null,
3141: p_award_date,
3142: p_auctioneer_id
3143: FROM pon_bid_item_prices bi, pon_bid_headers bh, pon_auction_item_prices_all ai
3144: WHERE bi.auction_header_id = ai.auction_header_id
3145: AND ai.line_number = bi.line_number
3146: AND (bi.award_status = 'AWARDED'
3147: OR bi.award_status = 'REJECTED')

Line 3183: FROM pon_bid_item_prices bi, pon_bid_headers bh

3179: 'REJECTED', p_note_to_rejected,
3180: null),
3181: SYSDATE,
3182: p_auctioneer_id
3183: FROM pon_bid_item_prices bi, pon_bid_headers bh
3184: WHERE bi.auction_header_id = p_auction_header_id
3185: AND bi.line_number = p_line_number
3186: AND (bi.award_status = 'AWARDED'
3187: OR bi.award_status = 'REJECTED')

Line 3221: FROM pon_bid_item_prices bi, pon_bid_headers bh, pon_auction_item_prices_all ai

3217: 'REJECTED', p_note_to_rejected,
3218: null),
3219: p_award_date,
3220: p_auctioneer_id
3221: FROM pon_bid_item_prices bi, pon_bid_headers bh, pon_auction_item_prices_all ai
3222: WHERE bi.auction_header_id = p_auction_header_id
3223: AND (bi.award_status = 'AWARDED'
3224: OR bi.award_status = 'REJECTED')
3225: AND bi.bid_number = bh.bid_number

Line 3299: FROM pon_bid_item_prices bi, pon_bid_headers bh

3295: p_award_date,
3296: p_note_to_rejected,
3297: p_award_date,
3298: p_auctioneer_id
3299: FROM pon_bid_item_prices bi, pon_bid_headers bh
3300: WHERE bi.auction_header_id = p_auction_header_id
3301: AND bi.line_number = p_line_number
3302: AND nvl(bi.award_status, 'NO') <> 'AWARDED' -- can be REJECTED/ NO
3303: AND bi.bid_number = bh.bid_number

Line 3341: UPDATE pon_bid_item_prices

3337:
3338: IF (p_line_number IS NULL OR p_line_number <= 0 )THEN
3339: -- Header level awards
3340: --Update award status to REJECTED for all the bids
3341: UPDATE pon_bid_item_prices
3342: SET award_status = 'REJECTED',
3343: award_quantity = NULL,
3344: award_date = p_award_date,
3345: last_update_date = p_award_date,

Line 3370: UPDATE pon_bid_item_prices

3366: WHERE auction_header_id = p_auction_header_id;
3367: ELSE
3368: -- Group Level awards need to be rejected first
3369: --Update award status to REJECTED for all the bids
3370: UPDATE pon_bid_item_prices
3371: SET award_status = 'REJECTED',
3372: award_quantity = NULL,
3373: award_date = p_award_date,
3374: last_update_date = p_award_date,

Line 3429: UPDATE pon_bid_item_prices

3425: )
3426: IS
3427: BEGIN
3428: --Update award status to REJECTED for all the bids
3429: UPDATE pon_bid_item_prices
3430: SET award_status = 'REJECTED',
3431: award_quantity = NULL,
3432: award_date = p_award_date,
3433: last_update_date = SYSDATE,

Line 3518: pon_bid_item_prices pbip

3514: por.award_quantity,
3515: por.award_shipment_number
3516: FROM pon_optimize_results por, pon_auction_item_prices_all paip,
3517: pon_auction_headers_all pah,
3518: pon_bid_item_prices pbip
3519: WHERE pah.auction_header_id = l_auction_header_id
3520: AND pah.auction_header_id = paip.auction_header_id
3521: AND por.bid_number = pbip.bid_number
3522: AND por.line_number = pbip.line_number

Line 4049: pon_bid_item_prices bi,

4045: ai.group_type,
4046: aii.award_shipment_number
4047: FROM pon_award_items_interface aii,
4048: pon_auction_item_prices_all ai,
4049: pon_bid_item_prices bi,
4050: pon_auction_headers_all pah
4051: WHERE
4052: aii.batch_id = c_batch_id
4053: AND aii.auction_header_id = c_auction_header_id

Line 4311: p_parent_line_number IN pon_bid_item_prices.line_number%TYPE,

4307: --
4308: PROCEDURE award_bi_subline (
4309: p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
4310: p_bid_number IN pon_bid_headers.bid_number%TYPE,
4311: p_parent_line_number IN pon_bid_item_prices.line_number%TYPE,
4312: p_award_status IN pon_bid_item_prices.award_status%TYPE,
4313: p_award_date IN pon_bid_item_prices.award_date%TYPE,
4314: p_auctioneer_id pon_bid_item_prices.LAST_UPDATED_BY%TYPE)
4315: IS

Line 4312: p_award_status IN pon_bid_item_prices.award_status%TYPE,

4308: PROCEDURE award_bi_subline (
4309: p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
4310: p_bid_number IN pon_bid_headers.bid_number%TYPE,
4311: p_parent_line_number IN pon_bid_item_prices.line_number%TYPE,
4312: p_award_status IN pon_bid_item_prices.award_status%TYPE,
4313: p_award_date IN pon_bid_item_prices.award_date%TYPE,
4314: p_auctioneer_id pon_bid_item_prices.LAST_UPDATED_BY%TYPE)
4315: IS
4316: CURSOR c_sublines (c_auction_header_id pon_bid_headers.auction_header_id%TYPE,

Line 4313: p_award_date IN pon_bid_item_prices.award_date%TYPE,

4309: p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
4310: p_bid_number IN pon_bid_headers.bid_number%TYPE,
4311: p_parent_line_number IN pon_bid_item_prices.line_number%TYPE,
4312: p_award_status IN pon_bid_item_prices.award_status%TYPE,
4313: p_award_date IN pon_bid_item_prices.award_date%TYPE,
4314: p_auctioneer_id pon_bid_item_prices.LAST_UPDATED_BY%TYPE)
4315: IS
4316: CURSOR c_sublines (c_auction_header_id pon_bid_headers.auction_header_id%TYPE,
4317: c_bid_number pon_bid_headers.bid_number%TYPE,

Line 4314: p_auctioneer_id pon_bid_item_prices.LAST_UPDATED_BY%TYPE)

4310: p_bid_number IN pon_bid_headers.bid_number%TYPE,
4311: p_parent_line_number IN pon_bid_item_prices.line_number%TYPE,
4312: p_award_status IN pon_bid_item_prices.award_status%TYPE,
4313: p_award_date IN pon_bid_item_prices.award_date%TYPE,
4314: p_auctioneer_id pon_bid_item_prices.LAST_UPDATED_BY%TYPE)
4315: IS
4316: CURSOR c_sublines (c_auction_header_id pon_bid_headers.auction_header_id%TYPE,
4317: c_bid_number pon_bid_headers.bid_number%TYPE,
4318: c_parent_line_number pon_bid_item_prices.line_number%TYPE) IS

Line 4318: c_parent_line_number pon_bid_item_prices.line_number%TYPE) IS

4314: p_auctioneer_id pon_bid_item_prices.LAST_UPDATED_BY%TYPE)
4315: IS
4316: CURSOR c_sublines (c_auction_header_id pon_bid_headers.auction_header_id%TYPE,
4317: c_bid_number pon_bid_headers.bid_number%TYPE,
4318: c_parent_line_number pon_bid_item_prices.line_number%TYPE) IS
4319: --Query retrives sublines for the given parent line
4320: SELECT
4321: bi.line_number,
4322: DECODE (p_award_status, 'AWARDED',decode (aii.group_type,

Line 4327: FROM pon_bid_item_prices bi, pon_auction_item_prices_all aii

4323: 'LOT_LINE', null, decode (aii.order_type_lookup_code,
4324: 'FIXED PRICE', 1,
4325: 'AMOUNT', 1,
4326: 'RATE', decode (aii.purchase_basis, 'TEMP LABOR', bi.quantity, 1), bi.quantity )), null) award_quantity
4327: FROM pon_bid_item_prices bi, pon_auction_item_prices_all aii
4328: WHERE
4329: bi.bid_number = c_bid_number
4330: AND bi.line_number IN (SELECT ai.line_number
4331: FROM pon_auction_item_prices_all ai

Line 4367: p_award_date IN pon_bid_item_prices.award_date%TYPE,

4363: PROCEDURE update_bi_group_award (
4364: p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
4365: p_bid_number IN pon_bid_headers.bid_number%TYPE,
4366: p_parent_line_number IN pon_auction_item_prices_all.parent_line_number%TYPE,
4367: p_award_date IN pon_bid_item_prices.award_date%TYPE,
4368: p_auctioneer_id IN pon_bid_item_prices.last_updated_by%TYPE )
4369: IS
4370: l_total_lines NUMBER;
4371: l_awarded_lines NUMBER;

Line 4368: p_auctioneer_id IN pon_bid_item_prices.last_updated_by%TYPE )

4364: p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
4365: p_bid_number IN pon_bid_headers.bid_number%TYPE,
4366: p_parent_line_number IN pon_auction_item_prices_all.parent_line_number%TYPE,
4367: p_award_date IN pon_bid_item_prices.award_date%TYPE,
4368: p_auctioneer_id IN pon_bid_item_prices.last_updated_by%TYPE )
4369: IS
4370: l_total_lines NUMBER;
4371: l_awarded_lines NUMBER;
4372: l_rejected_lines NUMBER;

Line 4373: l_award_status pon_bid_item_prices.award_status%TYPE;

4369: IS
4370: l_total_lines NUMBER;
4371: l_awarded_lines NUMBER;
4372: l_rejected_lines NUMBER;
4373: l_award_status pon_bid_item_prices.award_status%TYPE;
4374: BEGIN
4375: --get total, awarded/ rejected lines
4376: --
4377: SELECT count (*) ,

Line 4383: FROM pon_auction_item_prices_all ai, pon_bid_item_prices bi

4379: sum(decode(bi.award_status,'REJECTED',1,0))
4380: INTO l_total_lines,
4381: l_awarded_lines,
4382: l_rejected_lines
4383: FROM pon_auction_item_prices_all ai, pon_bid_item_prices bi
4384: WHERE ai.parent_line_number = p_parent_line_number
4385: AND ai.auction_header_id = p_auction_header_id
4386: and ai.auction_header_id = bi.auction_header_id(+)
4387: and bi.bid_number = p_bid_number

Line 4415: p_line_number IN pon_bid_item_prices.line_number%TYPE,

4411: --
4412: --
4413: PROCEDURE update_ai_group_award (
4414: p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
4415: p_line_number IN pon_bid_item_prices.line_number%TYPE,
4416: p_award_date IN pon_bid_item_prices.award_date%TYPE,
4417: p_auctioneer_id IN pon_bid_item_prices.last_updated_by%TYPE)
4418: IS
4419: l_total_lines NUMBER;

Line 4416: p_award_date IN pon_bid_item_prices.award_date%TYPE,

4412: --
4413: PROCEDURE update_ai_group_award (
4414: p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
4415: p_line_number IN pon_bid_item_prices.line_number%TYPE,
4416: p_award_date IN pon_bid_item_prices.award_date%TYPE,
4417: p_auctioneer_id IN pon_bid_item_prices.last_updated_by%TYPE)
4418: IS
4419: l_total_lines NUMBER;
4420: l_awarded_lines NUMBER;

Line 4417: p_auctioneer_id IN pon_bid_item_prices.last_updated_by%TYPE)

4413: PROCEDURE update_ai_group_award (
4414: p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
4415: p_line_number IN pon_bid_item_prices.line_number%TYPE,
4416: p_award_date IN pon_bid_item_prices.award_date%TYPE,
4417: p_auctioneer_id IN pon_bid_item_prices.last_updated_by%TYPE)
4418: IS
4419: l_total_lines NUMBER;
4420: l_awarded_lines NUMBER;
4421: l_parent_line_number NUMBER;

Line 4488: FROM pon_bid_item_prices PBIP,

4484: SELECT sum(nvl2(PAIP.current_price,
4485: PAIP.current_price * nvl(PAIP.awarded_quantity, 0),
4486: sum(decode(PBIP.award_status, 'AWARDED', nvl(PBIP.award_quantity, 0), 0) * nvl(PBIP.award_price, 0))))
4487: INTO p_current_total
4488: FROM pon_bid_item_prices PBIP,
4489: pon_bid_headers PBH,
4490: pon_auction_item_prices_all PAIP
4491: WHERE PAIP.auction_header_id = p_auction_header_id
4492: AND PAIP.auction_header_id = PBIP.auction_header_id (+)

Line 4502: FROM pon_bid_item_prices PBIP,

4498: PAIP.line_number, PAIP.current_price, PAIP.awarded_quantity;
4499:
4500: SELECT sum(decode(PBIP.award_status, 'AWARDED', nvl(PBIP.award_quantity, 0), 0) * nvl(PBIP.award_price, 0))
4501: INTO l_sol_lines_award_total
4502: FROM pon_bid_item_prices PBIP,
4503: pon_bid_headers PBH
4504: WHERE PBH.auction_header_id = p_auction_header_id
4505: AND PBIP.bid_number = PBH.bid_number (+)
4506: AND PBH.bid_status (+) = 'ACTIVE'

Line 4515: FROM pon_bid_item_prices bl

4511: --Donot include unsolicited lines amount when calculating the Savings Amount and Savings Percent
4512:
4513: SELECT nvl(sum(bl.award_quantity * bl.price), 0)
4514: INTO l_unsol_lines_award_total
4515: FROM pon_bid_item_prices bl
4516: WHERE bl.auction_header_id = p_auction_header_id
4517: AND bl.auction_line_number = -1
4518: AND bl.award_status = 'AWARDED';
4519:

Line 5497: pon_bid_item_prices bi,

5493: l_current_total_spend_col,
5494: l_fixed_incentive_col,
5495: l_current_rebate_col
5496: FROM
5497: pon_bid_item_prices bi,
5498: pon_auction_item_prices_all ai,
5499: pon_optimize_scenarios pos,
5500: pon_optimize_results por,
5501: pon_bid_shipments pbs,

Line 5650: FROM pon_bid_item_prices bi,

5646: SELECT bi.Line_number,
5647: bi.award_status,
5648: NVL(bi.award_price , bi.price) * Nvl(BI.AWARD_QUANTITY, DECODE(AI.ORDER_TYPE_LOOKUP_CODE, 'FIXED PRICE',1 , ai.quantity)) award_amount,
5649: pbh.po_agreed_amount
5650: FROM pon_bid_item_prices bi,
5651: pon_auction_item_prices_all ai,
5652: pon_bid_headers pbh
5653: WHERE bi.bid_number = p_bid_number
5654: AND bi.auction_header_id = ai.auction_header_id

Line 5714: UPDATE pon_bid_item_prices

5710:
5711: IF (p_line_number IS NULL OR p_line_number <= 0 )THEN
5712: -- Header level awards
5713: --Update award status to REJECTED for all the bids
5714: UPDATE pon_bid_item_prices
5715: SET award_status = 'REJECTED',
5716: award_quantity = NULL,
5717: award_date = p_award_date,
5718: last_update_date = p_award_date,

Line 5752: UPDATE pon_bid_item_prices

5748: AND Nvl(award_status, 'NO') = 'COMPLETED';
5749: ELSE
5750: -- Group Level awards need to be rejected first
5751: --Update award status to REJECTED for all the bids
5752: UPDATE pon_bid_item_prices
5753: SET award_status = 'REJECTED',
5754: award_quantity = NULL,
5755: award_date = p_award_date,
5756: last_update_date = p_award_date,