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.

APPS.PON_OPEN_INTERFACE_PVT dependencies on PON_AUCTION_EVENTS

Line 5588: AND NOT EXISTS(select 'Y' from pon_auction_events

5584: -- in case of amendment, event information wont be updated
5585: -- so no need to validate for amendments
5586: WHEN ( p_is_amendment <> 'Y' AND
5587: neg_header_record_data.event_id IS NOT NULL AND neg_header_record_data.event_id <> -1
5588: AND NOT EXISTS(select 'Y' from pon_auction_events
5589: where event_id = neg_header_record_data.event_id and
5590: trading_partner_id = p_tp_id
5591: and event_status <> 'CANCELLED'
5592: and NVL(open_date, SYSDATE - 100) >= SYSDATE)) THEN

Line 6892: from pon_auction_events

6888:
6889: BEGIN
6890: select event_id
6891: INTO neg_header_record_data.event_id
6892: from pon_auction_events
6893: where event_title = neg_header_record_data.event_title
6894: AND neg_header_record_data.event_title IS NOT NULL
6895: and trading_partner_id = neg_header_record_data.trading_partner_id
6896: and event_status <> 'CANCELLED' and NVL(open_date, SYSDATE - 100) >= SYSDATE;