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 1162: from pon_auction_item_prices_all

1158: sysdate,
1159: p_user_id,
1160: 'SUPPLIER',
1161: 'Y'
1162: from pon_auction_item_prices_all
1163: where auction_header_id = p_auction_header_id and
1164: (has_price_elements_flag = 'Y' or has_buyer_pfs_flag = 'Y');
1165:
1166: insert into pon_pf_supplier_formula

Line 1192: from pon_auction_item_prices_all paip,

1188: p_user_id,
1189: sysdate,
1190: p_user_id,
1191: p_login_id
1192: from pon_auction_item_prices_all paip,
1193: pon_bidding_parties pbp,
1194: pon_pf_supplier_values ppsv,
1195: pon_price_elements ppe
1196: where paip.auction_header_id = p_auction_header_id and

Line 1223: v_auction_last_line_number PON_AUCTION_ITEM_PRICES_ALL.LINE_NUMBER%TYPE;

1219:
1220: l_module_name VARCHAR2 (30);
1221: x_temp PON_AUCTION_HEADERS_ALL.LAST_UPDATE_DATE%TYPE;
1222: x_close_bidding_date PON_AUCTION_HEADERS_ALL.CLOSE_BIDDING_DATE%TYPE;
1223: v_auction_last_line_number PON_AUCTION_ITEM_PRICES_ALL.LINE_NUMBER%TYPE;
1224: p_new_close_date PON_AUCTION_HEADERS_ALL.CLOSE_BIDDING_DATE%TYPE;
1225: BEGIN
1226:
1227: l_module_name := 'MANUAL_CLOSE_LINE';

Line 1260: update pon_auction_item_prices_all

1256:
1257: p_new_close_date := sysdate;
1258:
1259: -- update item close date
1260: update pon_auction_item_prices_all
1261: set close_bidding_date = p_new_close_date,
1262: last_update_date = sysdate,
1263: last_updated_by = p_user_id
1264: where auction_header_id = p_auction_header_id

Line 1276: from pon_auction_item_prices_all

1272: END IF;
1273:
1274: --In case this is the last line then the auction has to be closed.
1275: select line_number into v_auction_last_line_number
1276: from pon_auction_item_prices_all
1277: where auction_header_id = p_auction_header_id
1278: and disp_line_number =
1279: (select max(disp_line_number)
1280: from pon_auction_item_prices_all

Line 1280: from pon_auction_item_prices_all

1276: from pon_auction_item_prices_all
1277: where auction_header_id = p_auction_header_id
1278: and disp_line_number =
1279: (select max(disp_line_number)
1280: from pon_auction_item_prices_all
1281: where auction_header_id=p_auction_header_id
1282: and group_type in ('LINE', 'LOT', 'GROUP'));
1283:
1284: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN