APPS.PON_NEG_UPDATE_PKG dependencies on PON_AUCTION_ITEM_PRICES_ALL

Line 38: update pon_auction_item_prices_all

34: last_updated_by = p_user_id
35: where auction_header_id = p_auction_header_id;
36:
37: -- update item close date
38: update pon_auction_item_prices_all
39: set close_bidding_date = p_new_close_date,
40: last_update_date = sysdate,
41: last_updated_by = p_user_id
42: where auction_header_id = p_auction_header_id

Line 240: UPDATE PON_AUCTION_ITEM_PRICES_ALL

236: WHERE AUCTION_HEADER_ID = p_auction_header_id;
237:
238: -- update the item prices all table close bidding date.
239: -- do not update the close date for already closed items.
240: UPDATE PON_AUCTION_ITEM_PRICES_ALL
241: SET CLOSE_BIDDING_DATE = CLOSE_BIDDING_DATE + (x_new_close_date-p_close_date),
242: LAST_UPDATE_DATE= sysdate,
243: LAST_UPDATED_BY = p_user_id
244: WHERE AUCTION_HEADER_ID = p_auction_header_id

Line 250: UPDATE PON_AUCTION_ITEM_PRICES_ALL

246:
247:
248: -- for manual extend, if the need by date is before the new close bidding
249: -- date, then need extend need by date behind the scene
250: UPDATE PON_AUCTION_ITEM_PRICES_ALL
251: SET NEED_BY_DATE = NEED_BY_DATE + (x_new_close_date-p_close_date),
252: LAST_UPDATE_DATE= sysdate,
253: LAST_UPDATED_BY = p_user_id
254: WHERE AUCTION_HEADER_ID = p_auction_header_id

Line 257: UPDATE PON_AUCTION_ITEM_PRICES_ALL

253: LAST_UPDATED_BY = p_user_id
254: WHERE AUCTION_HEADER_ID = p_auction_header_id
255: AND NEED_BY_DATE < x_new_close_date;
256:
257: UPDATE PON_AUCTION_ITEM_PRICES_ALL
258: SET NEED_BY_START_DATE = NEED_BY_START_DATE + (x_new_close_date-p_close_date),
259: LAST_UPDATE_DATE= sysdate,
260: LAST_UPDATED_BY = p_user_id
261: WHERE AUCTION_HEADER_ID = p_auction_header_id

Line 1220: from pon_auction_item_prices_all

1216: sysdate,
1217: p_user_id,
1218: 'SUPPLIER',
1219: 'Y'
1220: from pon_auction_item_prices_all
1221: where auction_header_id = p_auction_header_id and
1222: (has_price_elements_flag = 'Y' or has_buyer_pfs_flag = 'Y');
1223:
1224: insert into pon_pf_supplier_formula

Line 1250: from pon_auction_item_prices_all paip,

1246: p_user_id,
1247: sysdate,
1248: p_user_id,
1249: p_login_id
1250: from pon_auction_item_prices_all paip,
1251: pon_bidding_parties pbp,
1252: pon_pf_supplier_values ppsv,
1253: pon_price_elements ppe
1254: where paip.auction_header_id = p_auction_header_id and

Line 1281: v_auction_last_line_number PON_AUCTION_ITEM_PRICES_ALL.LINE_NUMBER%TYPE;

1277:
1278: l_module_name VARCHAR2 (30);
1279: x_temp PON_AUCTION_HEADERS_ALL.LAST_UPDATE_DATE%TYPE;
1280: x_close_bidding_date PON_AUCTION_HEADERS_ALL.CLOSE_BIDDING_DATE%TYPE;
1281: v_auction_last_line_number PON_AUCTION_ITEM_PRICES_ALL.LINE_NUMBER%TYPE;
1282: p_new_close_date PON_AUCTION_HEADERS_ALL.CLOSE_BIDDING_DATE%TYPE;
1283: BEGIN
1284:
1285: l_module_name := 'MANUAL_CLOSE_LINE';

Line 1318: update pon_auction_item_prices_all

1314:
1315: p_new_close_date := sysdate;
1316:
1317: -- update item close date
1318: update pon_auction_item_prices_all
1319: set close_bidding_date = p_new_close_date,
1320: last_update_date = sysdate,
1321: last_updated_by = p_user_id
1322: where auction_header_id = p_auction_header_id

Line 1334: from pon_auction_item_prices_all

1330: END IF;
1331:
1332: --In case this is the last line then the auction has to be closed.
1333: select line_number into v_auction_last_line_number
1334: from pon_auction_item_prices_all
1335: where auction_header_id = p_auction_header_id
1336: and disp_line_number =
1337: (select max(disp_line_number)
1338: from pon_auction_item_prices_all

Line 1338: from pon_auction_item_prices_all

1334: from pon_auction_item_prices_all
1335: where auction_header_id = p_auction_header_id
1336: and disp_line_number =
1337: (select max(disp_line_number)
1338: from pon_auction_item_prices_all
1339: where auction_header_id=p_auction_header_id
1340: and group_type in ('LINE', 'LOT', 'GROUP'));
1341:
1342: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN