eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PON_VALIDATE_ITEM_PRICES_INT dependencies on PON_AWARD_ITEMS_INTERFACE

Line 20: from pon_award_items_interface

16: BEGIN
17:
18: select count(*)
19: into l_num_of_award_lines
20: from pon_award_items_interface
21: where batch_id = p_batch_id
22: and rownum = 1;
23:
24: IF (l_num_of_award_lines = 0) THEN

Line 205: from pon_award_items_interface

201: END IF; --}
202:
203: select count(*)
204: into l_num_of_award_lines
205: from pon_award_items_interface
206: where batch_id = p_batch_id
207: and rownum = 1;
208:
209: IF (l_num_of_award_lines = 0) THEN

Line 222: pon_award_items_interface paii

218:
219: select paha.auction_header_id , paha.request_id, paha.contract_type, paha.price_tiers_indicator
220: into l_auction_id, l_request_id, l_contract_type, l_price_tiers_indicator
221: from pon_auction_headers_all paha,
222: pon_award_items_interface paii
223: where paii.auction_header_id = paha.auction_header_id
224: and paii.batch_id = p_batch_id
225: and rownum = 1;
226:

Line 240: message => 'updating the award shipment number PON_AWARD_ITEMS_INTERFACE for batch id = ' || p_batch_id || ' ; p_spreadsheet_type = '|| p_spreadsheet_type);

236:
237: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN --{
238: FND_LOG.string(log_level => FND_LOG.level_statement,
239: module => g_module_prefix || 'validateAwardBid',
240: message => 'updating the award shipment number PON_AWARD_ITEMS_INTERFACE for batch id = ' || p_batch_id || ' ; p_spreadsheet_type = '|| p_spreadsheet_type);
241: END IF; --}
242:
243: UPDATE PON_AWARD_ITEMS_INTERFACE PAII
244: set AWARD_SHIPMENT_NUMBER = ( select -1

Line 243: UPDATE PON_AWARD_ITEMS_INTERFACE PAII

239: module => g_module_prefix || 'validateAwardBid',
240: message => 'updating the award shipment number PON_AWARD_ITEMS_INTERFACE for batch id = ' || p_batch_id || ' ; p_spreadsheet_type = '|| p_spreadsheet_type);
241: END IF; --}
242:
243: UPDATE PON_AWARD_ITEMS_INTERFACE PAII
244: set AWARD_SHIPMENT_NUMBER = ( select -1
245: from pon_bid_item_prices pbip
246: where pbip.bid_number = PAII.bid_number
247: and pbip.auction_line_number = PAII.auction_line_number

Line 253: UPDATE PON_AWARD_ITEMS_INTERFACE PAII

249: )
250: WHERE PAII.batch_id = p_batch_id
251: AND PAII.award_status = 'Y';
252:
253: UPDATE PON_AWARD_ITEMS_INTERFACE PAII
254: set AWARD_SHIPMENT_NUMBER = (select nvl(( select shipment_number
255: from pon_bid_shipments pbs
256: where pbs.bid_number = PAII.bid_number
257: and pbs.auction_line_number = PAII.AUCTION_LINE_NUMBER

Line 300: , 'PON_AWARD_ITEMS_INTERFACE'

296: VALUES ( 'AWARDBID'
297: , fnd_message.get_string('PON','PON_INTEL_BID_NUMBER' || l_suffix)
298: , 'PON_AUC_BID_NUMBER_INVALID' || l_suffix
299: , s_bid_number
300: , 'PON_AWARD_ITEMS_INTERFACE'
301: , s_batch_id
302: , s_worksheet_name
303: , s_worksheet_sequence_number
304: , s_entity_message_code

Line 342: , 'PON_AWARD_ITEMS_INTERFACE'

338: )
339: VALUES ( 'AWARDBID'
340: , fnd_message.get_string('PON','PON_INTEL_BID_NUMBER' || l_suffix)
341: , 'PON_AUC_ITEM_AWARDED'
342: , 'PON_AWARD_ITEMS_INTERFACE'
343: , s_batch_id
344: , s_worksheet_name
345: , s_worksheet_sequence_number
346: , s_entity_message_code

Line 386: , 'PON_AWARD_ITEMS_INTERFACE'

382: VALUES ( 'AWARDBID'
383: , fnd_message.get_string('PON','PON_INTEL_BID_NUMBER' || l_suffix)
384: , 'PON_AWARD_EXCLUDE_SHLIST_ERR' || l_suffix
385: , s_bid_number
386: , 'PON_AWARD_ITEMS_INTERFACE'
387: , s_batch_id
388: , s_worksheet_name
389: , s_worksheet_sequence_number
390: , s_entity_message_code

Line 430: , 'PON_AWARD_ITEMS_INTERFACE'

426: VALUES ( 'AWARDBID'
427: , fnd_message.get_string('PON','PON_INTEL_BID_NUMBER' || l_suffix)
428: , 'PON_AWARD_BID_NOT_ACTIVE' || l_suffix
429: , s_bid_number
430: , 'PON_AWARD_ITEMS_INTERFACE'
431: , s_batch_id
432: , s_worksheet_name
433: , s_worksheet_sequence_number
434: , s_entity_message_code

Line 474: , 'PON_AWARD_ITEMS_INTERFACE'

470: VALUES ( 'AWARDBID'
471: , decode(p_spreadsheet_type, PON_AWARD_PKG.g_xml_upload_mode, fnd_message.get_string('PON','PON_ACCTS_SUPPLIER'), fnd_message.get_string('PON','PON_BIDS_BIDDER' || l_suffix))
472: , 'PON_AWARD_INACTIVE_SUPPLIER'
473: , s_trading_partner_name
474: , 'PON_AWARD_ITEMS_INTERFACE'
475: , s_batch_id
476: , s_worksheet_name
477: , s_worksheet_sequence_number
478: , s_entity_message_code

Line 518: , 'PON_AWARD_ITEMS_INTERFACE'

514: , decode(l_contract_type, 'STANDARD', fnd_message.get_string('PON','PON_AUCTION_AWARD_QTY'), fnd_message.get_string('PON','PON_AUCTS_AGREED_QUANTITY'))
515: , decode(l_contract_type, 'STANDARD', 'PON_AUC_AWARD_QTY_COL_NEG', 'PON_AUC_QTY_AGREED_COL_NEG')
516: , s_award_quantity
517: , 'NUM'
518: , 'PON_AWARD_ITEMS_INTERFACE'
519: , s_batch_id
520: , s_worksheet_name
521: , s_worksheet_sequence_number
522: , s_entity_message_code

Line 562: , 'PON_AWARD_ITEMS_INTERFACE'

558: )
559: VALUES ( 'AWARDBID'
560: , fnd_message.get_string('PON','PON_AUCTION_AWARD_QTY')
561: , 'PON_AUCTS_MUST_AWARD'
562: , 'PON_AWARD_ITEMS_INTERFACE'
563: , s_batch_id
564: , s_worksheet_name
565: , s_worksheet_sequence_number
566: , s_entity_message_code

Line 611: , 'PON_AWARD_ITEMS_INTERFACE'

607: )
608: VALUES ( 'AWARDBID'
609: , fnd_message.get_string('PON','PON_AUCTION_AWARD_QTY')
610: , 'PON_QUANTITY_TIER_VIOLATION' || l_suffix
611: , 'PON_AWARD_ITEMS_INTERFACE'
612: , s_award_quantity
613: , s_batch_id
614: , s_worksheet_name
615: , s_worksheet_sequence_number

Line 648: FROM pon_award_items_interface ap

644: , bh.shortlist_flag AS s_shortlist_flag
645: , bh.bid_status AS s_bid_status
646: , pv.end_date_active AS s_end_date_active
647: , ap.award_shipment_number as s_award_shipment_number
648: FROM pon_award_items_interface ap
649: , pon_auction_item_prices_all ai
650: , pon_bid_headers bh
651: , po_vendors pv
652: WHERE ap.batch_id = p_batch_id

Line 686: , 'PON_AWARD_ITEMS_INTERFACE'

682: 'AWARDBID'
683: , fnd_message.get_string('PON','PON_AUC_LINE_TYPE')
684: , 'PON_AWARD_FIXED_PRICE'|| l_suffix
685: , pltt.line_type
686: , 'PON_AWARD_ITEMS_INTERFACE'
687: , paii.BATCH_ID
688: , paii.worksheet_name
689: , paii.worksheet_sequence_number
690: , 'PON_AUC_ITEMS' entity_message_code

Line 701: FROM PON_AWARD_ITEMS_INTERFACE paii,

697: , sysdate
698: , l_login_id
699: , 'LINE_NUMBER'
700: , ai.document_disp_line_number
701: FROM PON_AWARD_ITEMS_INTERFACE paii,
702: pon_auction_item_prices_all ai,
703: pon_auction_headers_all ah,
704: po_line_types_tl pltt
705: WHERE paii.batch_id = p_batch_id