APPS.PON_AUCTION_PKG dependencies on PON_AUCTION_ITEM_PRICES_ALL

Line 2370: pon_auction_item_prices_all paip

2366:
2367: select count(pbip.line_number)
2368: into x_number_awarded
2369: from pon_bid_item_prices pbip,
2370: pon_auction_item_prices_all paip
2371: where paip.auction_header_id = p_auction_header_id
2372: and paip.line_number = pbip.line_number
2373: and pbip.bid_number = p_bid_id
2374: and nvl(pbip.award_status,'NONE')= 'AWARDED'

Line 2380: pon_auction_item_prices_all paip

2376:
2377: select count(pbip.line_number)
2378: into x_number_rejected
2379: from pon_bid_item_prices pbip,
2380: pon_auction_item_prices_all paip
2381: where paip.auction_header_id = p_auction_header_id
2382: and paip.line_number = pbip.line_number
2383: and pbip.bid_number = p_bid_id
2384: and nvl(pbip.award_status,'NONE')= 'REJECTED'

Line 4646: from pon_auction_headers_all pah, pon_auction_item_prices_all paip

4642:
4643: select pah.auction_status, pah.open_bidding_date, nvl(paip.close_bidding_date, pah.close_bidding_date),
4644: nvl( pah.last_pause_date, sysdate ), nvl( pah.is_paused, 'N' )
4645: into v_auction_status, v_startdate, v_enddate, v_pausedate, v_ispaused
4646: from pon_auction_headers_all pah, pon_auction_item_prices_all paip
4647: where pah.auction_header_id = p_auction_header_id and
4648: paip.auction_header_id = pah.auction_header_id and
4649: paip.line_number = p_line_number;
4650:

Line 7464: from pon_auction_item_prices_all

7460: needByToDate Date := null;
7461: sLanguage varchar2(10) := 'US';
7462: cursor c1(auctionID number,lineNumber number) is
7463: select need_by_start_date,need_by_date
7464: from pon_auction_item_prices_all
7465: where auction_header_id = auctionID and
7466: line_number = lineNumber;
7467: Begin
7468: begin

Line 8973: FROM PON_AUCTION_ITEM_PRICES_ALL

8969: l_line_number number;
8970:
8971: CURSOR deletedItems IS
8972: SELECT LINE_NUMBER
8973: FROM PON_AUCTION_ITEM_PRICES_ALL
8974: WHERE auction_header_id = x_old_negotiation_id and
8975: line_number not in ( select line_number
8976: from PON_AUCTION_ITEM_PRICES_ALL
8977: where auction_header_id = x_new_negotiation_id);

Line 8976: from PON_AUCTION_ITEM_PRICES_ALL

8972: SELECT LINE_NUMBER
8973: FROM PON_AUCTION_ITEM_PRICES_ALL
8974: WHERE auction_header_id = x_old_negotiation_id and
8975: line_number not in ( select line_number
8976: from PON_AUCTION_ITEM_PRICES_ALL
8977: where auction_header_id = x_new_negotiation_id);
8978:
8979: BEGIN
8980:

Line 9094: FROM PON_AUCTION_ITEM_PRICES_ALL

9090:
9091: -- check if the item is still in the next round negotiation
9092: SELECT count(*)
9093: INTO neg_item_count
9094: FROM PON_AUCTION_ITEM_PRICES_ALL
9095: WHERE auction_header_id = x_new_negotiation_id and
9096: line_number = l_line_number;
9097:
9098: IF ((l_count = 0) AND (neg_item_count) = 1) THEN

Line 9555: -- for pon_auction_item_prices_all table.

9551:
9552:
9553: -- this procedure is added for header price break default
9554: -- The procedure determines the price_break_type and price_break_neg_flag
9555: -- for pon_auction_item_prices_all table.
9556: -- It assumes the auction header already exists.
9557: -- It's used in plsql routines where lines are inserted, including line spreadsheet upload,
9558: -- negotiation copy/new round/amendment, autocreation and renegotiation.
9559:

Line 9569: l_template_pb_type pon_auction_item_prices_all.price_break_type%type;

9565: l_contract_type pon_auction_headers_all.contract_type%type;
9566: l_doctype_id pon_auction_headers_all.doctype_id%type;
9567: l_po_style_id pon_auction_headers_all.po_style_id%type;
9568: l_template_id pon_auction_headers_all.template_id%type;
9569: l_template_pb_type pon_auction_item_prices_all.price_break_type%type;
9570: l_org_id pon_auction_headers_all.org_id%type;
9571: l_po_pb_type po_system_parameters_all.price_break_lookup_code%type;
9572: l_price_break_display_flag PON_AUC_DOCTYPE_RULES.display_flag%type;
9573: l_price_break_enabled_flag VARCHAR2(1);

Line 9652: from pon_auction_item_prices_all

9648:
9649: BEGIN
9650: select price_break_type
9651: into l_template_pb_type
9652: from pon_auction_item_prices_all
9653: where auction_header_id = l_template_id;
9654: EXCEPTION
9655: WHEN OTHERS THEN
9656: l_template_pb_type := 'NONE';

Line 9774: FROM pon_auction_item_prices_all al

9770: SELECT 'N'
9771: INTO x_req_backed
9772: FROM dual
9773: WHERE EXISTS (SELECT 1
9774: FROM pon_auction_item_prices_all al
9775: WHERE al.auction_header_id = p_auction_header_id
9776: AND al.group_type NOT IN ('GROUP','LOT_LINE')
9777: AND nvl(al.line_origination_code,'-9998') <> 'REQUISITION');
9778: EXCEPTION