APPS.PON_UNSOL_AWARD_PKG dependencies on PON_ACCEPTANCES

Line 32: DELETE FROM pon_acceptances

28: AND bid_status = 'ACTIVE')
29: AND auction_line_number = -1;
30:
31: -- Delete All Unsol line Awards since it is a header-level awarding
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,

Line 237: l_stored_note_to_rejected pon_acceptances.reason%type;

233: l_rejected_bid_numbers integerList;
234: l_line_number_list integerList;
235: l_line_number_found BOOLEAN;
236: l_count NUMBER;
237: l_stored_note_to_rejected pon_acceptances.reason%type;
238: l_error_code VARCHAR2(20);
239:
240: BEGIN
241: l_update_auction_headers := 'N';

Line 309: SELECT count(*) INTO l_count FROM pon_acceptances

305: ELSE
306: -- Update acceptances for the lines with award decision already made
307: l_stored_note_to_rejected := null;
308: l_count := 0;
309: SELECT count(*) INTO l_count FROM pon_acceptances
310: WHERE auction_header_id = p_auction_header_id
311: AND line_number = l_lines_rec.line_number
312: AND ACCEPTANCE_TYPE = 'REJECTED';
313: --

Line 317: FROM pon_acceptances

313: --
314: IF l_count > 0 THEN
315: -- rejection note exists and carried over for rejected suppliers
316: SELECT distinct REASON INTO l_stored_note_to_rejected
317: FROM pon_acceptances
318: WHERE auction_header_id = p_auction_header_id
319: AND line_number = l_lines_rec.line_number
320: AND ACCEPTANCE_TYPE = 'REJECTED';
321: