APPS.PON_BUYER_SUMMARY_PKG dependencies on PON_AUCTION_SUMMARY

Line 59: select pon_auction_summary_s.nextval

55: v_rank NUMBER;
56: --
57: BEGIN
58: --
59: select pon_auction_summary_s.nextval
60: into v_batch_id
61: from dual;
62: --
63: SELECT nvl(auction_type, 'REVERSE') INTO v_auction_type

Line 90: insert into pon_auction_summary

86: else
87: v_qty_award := v_qty_remaining;
88: end if;
89: --
90: insert into pon_auction_summary
91: (batch_id,
92: auction_id,
93: line_number,
94: bid_number,

Line 132: insert into pon_auction_summary

128: close c_bid_item;
129: --
130: END LOOP;
131: --
132: insert into pon_auction_summary
133: (batch_id,
134: auction_id,
135: line_number,
136: bid_number,

Line 157: not exists (select 'exist' from pon_auction_summary where

153: 0,
154: 0
155: from pon_bidding_parties bp
156: where auction_header_id = p_auction_id and
157: not exists (select 'exist' from pon_auction_summary where
158: trading_partner_id = bp.trading_partner_id and
159: batch_id = v_batch_id and
160: auction_header_id = p_auction_id);
161: --