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_COPY_UDAS_GRP dependencies on PON_AUCTION_HEADERS_ALL

Line 191: select uda_template_id into l_template_id from pon_auction_headers_all where

187: WHERE template_id = p_template_id and ATTRIBUTE_CATEGORY <> 'DOCUMENT_NUMBERING');
188: BEGIN
189:
190: -- get Uda Template Id
191: select uda_template_id into l_template_id from pon_auction_headers_all where
192: auction_header_id = p_source_auction_header_id;
193: log_message('COPY_Header_UDAs','Got Template Id '||l_template_id);
194: --get Attribute Groups exclude doc numbering
195: open attr_groups_cur(l_template_id);

Line 229: select nvl(amendment_flag,'N') into l_amd_flag from pon_auction_headers_all where auction_header_id = p_source_auction_header_id;

225: p_tar_pkey.extend(1);
226: p_tar_pkey(1) := p_target_auction_header_id;
227:
228:
229: select nvl(amendment_flag,'N') into l_amd_flag from pon_auction_headers_all where auction_header_id = p_source_auction_header_id;
230:
231: if ( l_amd_flag = 'Y' ) THEN
232: select auction_header_id_prev_amend into l_prev_hdr_id1 from pon_auction_headers_all where auction_header_id = p_source_auction_header_id;
233: select auction_header_id_prev_amend into l_prev_hdr_id2 from pon_auction_headers_all where auction_header_id = p_target_auction_header_id;

Line 232: select auction_header_id_prev_amend into l_prev_hdr_id1 from pon_auction_headers_all where auction_header_id = p_source_auction_header_id;

228:
229: select nvl(amendment_flag,'N') into l_amd_flag from pon_auction_headers_all where auction_header_id = p_source_auction_header_id;
230:
231: if ( l_amd_flag = 'Y' ) THEN
232: select auction_header_id_prev_amend into l_prev_hdr_id1 from pon_auction_headers_all where auction_header_id = p_source_auction_header_id;
233: select auction_header_id_prev_amend into l_prev_hdr_id2 from pon_auction_headers_all where auction_header_id = p_target_auction_header_id;
234: --conformed amendment copy
235: if ( l_prev_hdr_id1 = l_prev_hdr_id2 ) then
236: open addTypCur;

Line 233: select auction_header_id_prev_amend into l_prev_hdr_id2 from pon_auction_headers_all where auction_header_id = p_target_auction_header_id;

229: select nvl(amendment_flag,'N') into l_amd_flag from pon_auction_headers_all where auction_header_id = p_source_auction_header_id;
230:
231: if ( l_amd_flag = 'Y' ) THEN
232: select auction_header_id_prev_amend into l_prev_hdr_id1 from pon_auction_headers_all where auction_header_id = p_source_auction_header_id;
233: select auction_header_id_prev_amend into l_prev_hdr_id2 from pon_auction_headers_all where auction_header_id = p_target_auction_header_id;
234: --conformed amendment copy
235: if ( l_prev_hdr_id1 = l_prev_hdr_id2 ) then
236: open addTypCur;
237: fetch addTypCur bulk collect into l_excl_addr_types;