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_HEADERS_EXT_B

Line 272: FROM pon_auction_headers_ext_b

268:
269: BEGIN
270:
271: SELECT 'Y' INTO l_sol_num_given
272: FROM pon_auction_headers_ext_b
273: WHERE auction_header_id = p_auction_header_id
274: AND attr_group_id = l_solnum_group_id;
275:
276: IF l_sol_num_given = 'Y' THEN

Line 292: print_Log('Solicitation number columns in pon_auction_headers_ext_b are '|| l_delimiter||','||

288: l_dodaac := solnum_attr(2);
289: l_fiscal_year := solnum_attr(3);
290: l_instrument_type := solnum_attr(4);
291: l_serial_number := solnum_attr(5);
292: print_Log('Solicitation number columns in pon_auction_headers_ext_b are '|| l_delimiter||','||
293: l_dodaac||',' || l_fiscal_year||','|| l_instrument_type||','|| l_serial_number );
294:
295: l_query:='SELECT '||l_delimiter||','
296: || l_dodaac||',' || l_fiscal_year||','|| l_instrument_type||','|| l_serial_number

Line 297: || ' FROM pon_auction_headers_ext_b WHERE auction_header_id = '

293: l_dodaac||',' || l_fiscal_year||','|| l_instrument_type||','|| l_serial_number );
294:
295: l_query:='SELECT '||l_delimiter||','
296: || l_dodaac||',' || l_fiscal_year||','|| l_instrument_type||','|| l_serial_number
297: || ' FROM pon_auction_headers_ext_b WHERE auction_header_id = '
298: || l_auction_header_id || ' AND attr_group_id = ' || l_solnum_group_id;
299:
300: EXECUTE IMMEDIATE l_query INTO l_delimiter, l_dodaac, l_fiscal_year, l_instrument_type, l_serial_number;
301:

Line 307: UPDATE pon_auction_headers_ext_b

303: || l_fiscal_year || l_delimiter
304: || l_instrument_type || l_delimiter
305: || l_serial_number ;
306:
307: UPDATE pon_auction_headers_ext_b
308: SET C_EXT_ATTR40 = l_document_number
309: WHERE auction_header_id = p_auction_header_id
310: AND attr_group_id = l_solnum_group_id;
311:

Line 3843: DELETE FROM pon_auction_headers_ext_b WHERE auction_header_id = l_auction_header_id;

3839: DELETE FROM pon_auction_attributes WHERE auction_header_id = l_auction_header_id;
3840: DELETE FROM pon_bidding_parties WHERE auction_header_id = l_auction_header_id;
3841: DELETE FROM pon_attribute_scores WHERE auction_header_id = l_auction_header_id;
3842: DELETE FROM pon_auction_sections WHERE auction_header_id = l_auction_header_id;
3843: DELETE FROM pon_auction_headers_ext_b WHERE auction_header_id = l_auction_header_id;
3844: DELETE FROM pon_auction_headers_ext_tl WHERE auction_header_id = l_auction_header_id;
3845: DELETE FROM pon_auction_item_prices_ext_b WHERE auction_header_id = l_auction_header_id;
3846: DELETE FROM pon_auction_item_prices_ext_tl WHERE auction_header_id = l_auction_header_id;
3847: END IF;

Line 7059: DELETE FROM pon_auction_headers_ext_b WHERE auction_header_id = l_auction_header_id;

7055: DELETE FROM pon_auction_attributes WHERE auction_header_id = l_auction_header_id;
7056: DELETE FROM pon_bidding_parties WHERE auction_header_id = l_auction_header_id;
7057: DELETE FROM pon_attribute_scores WHERE auction_header_id = l_auction_header_id;
7058: DELETE FROM pon_auction_sections WHERE auction_header_id = l_auction_header_id;
7059: DELETE FROM pon_auction_headers_ext_b WHERE auction_header_id = l_auction_header_id;
7060: DELETE FROM pon_auction_headers_ext_tl WHERE auction_header_id = l_auction_header_id;
7061: DELETE FROM pon_auction_item_prices_ext_b WHERE auction_header_id = l_auction_header_id;
7062: DELETE FROM pon_auction_item_prices_ext_tl WHERE auction_header_id = l_auction_header_id;
7063: END IF;