DBA Data[Home] [Help]

APPS.PON_UNSOL_AWARD_PKG dependencies on PON_AWARD_PKG

Line 36: PON_AWARD_PKG.update_bid_headers(p_auction_id => p_auc_header_id,

32: DELETE FROM pon_acceptances
33: WHERE auction_header_id = p_auc_header_id
34: AND auction_line_number = -1;
35:
36: PON_AWARD_PKG.update_bid_headers(p_auction_id => p_auc_header_id,
37: p_auctioneer_id => p_auctioneer_id,
38: p_neg_has_lines => 'Y');
39: ELSE
40: --Unsolicited Lines donot Exist

Line 174: PON_AWARD_PKG.update_bid_headers(p_auction_id => p_auction_header_id,

170: AND line_number = l_rec.line_number;
171:
172: END LOOP;
173:
174: PON_AWARD_PKG.update_bid_headers(p_auction_id => p_auction_header_id,
175: p_auctioneer_id => p_auctioneer_id,
176: p_neg_has_lines => 'Y');
177: PON_AWARD_PKG.update_auction_headers(p_auction_header_id, p_mode, l_award_date, p_auctioneer_id, 'Y');
178:

Line 177: PON_AWARD_PKG.update_auction_headers(p_auction_header_id, p_mode, l_award_date, p_auctioneer_id, 'Y');

173:
174: PON_AWARD_PKG.update_bid_headers(p_auction_id => p_auction_header_id,
175: p_auctioneer_id => p_auctioneer_id,
176: p_neg_has_lines => 'Y');
177: PON_AWARD_PKG.update_auction_headers(p_auction_header_id, p_mode, l_award_date, p_auctioneer_id, 'Y');
178:
179: x_status := 'SUCCESS';
180:
181: END award_unsol_lines;

Line 275: pon_award_pkg.update_single_bid_item_prices

271: if (l_lines_rec.line_origination_code = 'REQUISITION' AND l_lines_rec.award_status = 'NO') then
272: PON_AUCTION_PKG.CANCEL_NEGOTIATION_REF_BY_LINE(p_auction_header_id, l_lines_rec.line_number, l_error_code);
273: end if;
274:
275: pon_award_pkg.update_single_bid_item_prices
276: (
277: l_active_bids_rec.bid_number,
278: l_lines_rec.line_number,
279: 'REJECTED',

Line 299: pon_award_pkg.update_unawarded_acceptances(

295: IF NOT(l_line_number_found) THEN
296: l_line_number_list(l_line_number_list.COUNT + 1) := l_lines_rec.line_number;
297: IF (l_lines_rec.award_status = 'NO') THEN
298: -- Update acceptances for the lines with no award decision made
299: pon_award_pkg.update_unawarded_acceptances(
300: p_auction_header_id, -- auction header id
301: l_lines_rec.line_number, -- line number
302: p_note_to_rejected, --note to rejected suppliers
303: SYSDATE, -- award_date

Line 324: pon_award_pkg.update_unawarded_acceptances(

320: AND ACCEPTANCE_TYPE = 'REJECTED';
321:
322: END IF; --End if x_count > 0
323: --
324: pon_award_pkg.update_unawarded_acceptances(
325: p_auction_header_id, -- auction header id
326: l_lines_rec.line_number, -- line number
327: l_stored_note_to_rejected, --note to rejected suppliers
328: SYSDATE, -- award_date

Line 333: pon_award_pkg.award_item_disposition (p_auction_header_id, l_lines_rec.line_number, 0);

329: p_user_id);
330:
331: END IF; -- end if award_status = 'NO'
332:
333: pon_award_pkg.award_item_disposition (p_auction_header_id, l_lines_rec.line_number, 0);
334:
335: END IF; -- End if x_line_number_found
336: --END IF;
337:

Line 346: pon_award_pkg.update_single_bid_header(l_active_bids_rec.bid_number, p_user_id);

342: CLOSE c_bid_lines_with_no_award;
343:
344: -- Update bid header if there are lines with no award decision.
345: IF l_update_bid_header = 'Y' THEN
346: pon_award_pkg.update_single_bid_header(l_active_bids_rec.bid_number, p_user_id);
347:
348: --If there is atleast one bid line with no award decision,
349: --then call update_auction_headers procedure
350: l_update_auction_headers := 'Y';

Line 376: PON_AWARD_PKG.update_auction_headers(p_auction_header_id, PON_AWARD_PKG.g_AWARD_LINE, SYSDATE,

372: WHERE bid_number = l_rejected_bid_numbers(k);
373: -- update the award status for the auction that was bidded on
374: -- and no award decision made
375: IF l_update_auction_headers = 'Y' THEN
376: PON_AWARD_PKG.update_auction_headers(p_auction_header_id, PON_AWARD_PKG.g_AWARD_LINE, SYSDATE,
377: p_user_id, 'Y');
378: END IF;
379:
380: