APPS.PON_AUCTION_PKG dependencies on PON_AUCTION_ITEM_PRICES_ALL

Line 2854: pon_auction_item_prices_all paip

2850:
2851: select count(pbip.line_number)
2852: into x_number_awarded
2853: from pon_bid_item_prices pbip,
2854: pon_auction_item_prices_all paip
2855: where paip.auction_header_id = p_auction_header_id
2856: and paip.line_number = pbip.line_number
2857: and pbip.bid_number = p_bid_id
2858: and nvl(pbip.award_status,'NONE')= 'AWARDED'

Line 2864: pon_auction_item_prices_all paip

2860:
2861: select count(pbip.line_number)
2862: into x_number_rejected
2863: from pon_bid_item_prices pbip,
2864: pon_auction_item_prices_all paip
2865: where paip.auction_header_id = p_auction_header_id
2866: and paip.line_number = pbip.line_number
2867: and pbip.bid_number = p_bid_id
2868: and nvl(pbip.award_status,'NONE')= 'REJECTED'

Line 5241: from pon_auction_headers_all pah, pon_auction_item_prices_all paip

5237:
5238: select pah.auction_status, pah.open_bidding_date, nvl(paip.close_bidding_date, pah.close_bidding_date),
5239: nvl( pah.last_pause_date, sysdate ), nvl( pah.is_paused, 'N' )
5240: into v_auction_status, v_startdate, v_enddate, v_pausedate, v_ispaused
5241: from pon_auction_headers_all pah, pon_auction_item_prices_all paip
5242: where pah.auction_header_id = p_auction_header_id and
5243: paip.auction_header_id = pah.auction_header_id and
5244: paip.line_number = p_line_number;
5245:

Line 8135: from pon_auction_item_prices_all

8131: clmNeedByDate Date := null;
8132: sLanguage varchar2(10) := 'US';
8133: cursor c1(auctionID number,lineNumber number) is
8134: select clm_need_by_date,need_by_start_date,need_by_date
8135: from pon_auction_item_prices_all
8136: where auction_header_id = auctionID and
8137: line_number = lineNumber;
8138: Begin
8139: begin

Line 9705: FROM PON_AUCTION_ITEM_PRICES_ALL

9701: l_requisition_line_id po_requisition_lines_all.requisition_line_id%TYPE;
9702:
9703: CURSOR deletedItems IS
9704: SELECT LINE_NUMBER
9705: FROM PON_AUCTION_ITEM_PRICES_ALL
9706: WHERE auction_header_id = x_old_negotiation_id and
9707: line_number not in ( select line_number
9708: from PON_AUCTION_ITEM_PRICES_ALL
9709: where auction_header_id = x_new_negotiation_id);

Line 9708: from PON_AUCTION_ITEM_PRICES_ALL

9704: SELECT LINE_NUMBER
9705: FROM PON_AUCTION_ITEM_PRICES_ALL
9706: WHERE auction_header_id = x_old_negotiation_id and
9707: line_number not in ( select line_number
9708: from PON_AUCTION_ITEM_PRICES_ALL
9709: where auction_header_id = x_new_negotiation_id);
9710:
9711: BEGIN
9712:

Line 9926: FROM PON_AUCTION_ITEM_PRICES_ALL

9922:
9923: -- check if the item is still in the next round negotiation
9924: SELECT count(*)
9925: INTO neg_item_count
9926: FROM PON_AUCTION_ITEM_PRICES_ALL
9927: WHERE auction_header_id = x_new_negotiation_id and
9928: line_number = l_line_number;
9929:
9930: IF ((l_count = 0) AND (neg_item_count) = 1) THEN

Line 10391: -- for pon_auction_item_prices_all table.

10387:
10388:
10389: -- this procedure is added for header price break default
10390: -- The procedure determines the price_break_type and price_break_neg_flag
10391: -- for pon_auction_item_prices_all table.
10392: -- It assumes the auction header already exists.
10393: -- It's used in plsql routines where lines are inserted, including line spreadsheet upload,
10394: -- negotiation copy/new round/amendment, autocreation and renegotiation.
10395:

Line 10405: l_template_pb_type pon_auction_item_prices_all.price_break_type%type;

10401: l_contract_type pon_auction_headers_all.contract_type%type;
10402: l_doctype_id pon_auction_headers_all.doctype_id%type;
10403: l_po_style_id pon_auction_headers_all.po_style_id%type;
10404: l_template_id pon_auction_headers_all.template_id%type;
10405: l_template_pb_type pon_auction_item_prices_all.price_break_type%type;
10406: l_org_id pon_auction_headers_all.org_id%type;
10407: l_po_pb_type po_system_parameters_all.price_break_lookup_code%type;
10408: l_price_break_display_flag PON_AUC_DOCTYPE_RULES.display_flag%type;
10409: l_price_break_enabled_flag VARCHAR2(1);

Line 10488: from pon_auction_item_prices_all

10484:
10485: BEGIN
10486: select price_break_type
10487: into l_template_pb_type
10488: from pon_auction_item_prices_all
10489: where auction_header_id = l_template_id;
10490: EXCEPTION
10491: WHEN OTHERS THEN
10492: l_template_pb_type := 'NONE';

Line 10610: FROM pon_auction_item_prices_all al

10606: SELECT 'N'
10607: INTO x_req_backed
10608: FROM dual
10609: WHERE EXISTS (SELECT 1
10610: FROM pon_auction_item_prices_all al
10611: WHERE al.auction_header_id = p_auction_header_id
10612: AND al.group_type NOT IN ('GROUP','LOT_LINE')
10613: AND nvl(al.line_origination_code,'-9998') <> 'REQUISITION');
10614: EXCEPTION