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.AS_TAP_MERGE_PKG dependencies on AS_CHANGED_ACCOUNTS_ALL

Line 310: delete from as_changed_accounts_all

306:
307: IF p_from_fk_id <> p_to_fk_id THEN
308: BEGIN
309: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
310: delete from as_changed_accounts_all
311: where customer_id = p_to_fk_id;
312:
313: UPDATE AS_CHANGED_ACCOUNTS_ALL
314: set object_version_number = nvl(object_version_number,0) + 1,

Line 313: UPDATE AS_CHANGED_ACCOUNTS_ALL

309: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
310: delete from as_changed_accounts_all
311: where customer_id = p_to_fk_id;
312:
313: UPDATE AS_CHANGED_ACCOUNTS_ALL
314: set object_version_number = nvl(object_version_number,0) + 1,
315: customer_id = p_to_fk_id,
316: last_update_date = hz_utility_pub.last_update_date,
317: last_updated_by = hz_utility_pub.user_id,

Line 327: delete from as_changed_accounts_all b

323:
324:
325: ELSif p_parent_entity_name = 'HZ_PARTY_SITES' THEN -- merge party_site
326:
327: delete from as_changed_accounts_all b
328: where b.address_id=p_from_fk_id
329: and b.customer_id in
330: (select customer_id
331: from as_changed_accounts_all c

Line 331: from as_changed_accounts_all c

327: delete from as_changed_accounts_all b
328: where b.address_id=p_from_fk_id
329: and b.customer_id in
330: (select customer_id
331: from as_changed_accounts_all c
332: where c.address_id=p_to_fk_id) ;
333:
334:
335: UPDATE AS_CHANGED_ACCOUNTS_ALL

Line 335: UPDATE AS_CHANGED_ACCOUNTS_ALL

331: from as_changed_accounts_all c
332: where c.address_id=p_to_fk_id) ;
333:
334:
335: UPDATE AS_CHANGED_ACCOUNTS_ALL
336: set object_version_number = nvl(object_version_number,0) + 1,
337: address_id = p_to_fk_id,
338: last_update_date = hz_utility_pub.last_update_date,
339: last_updated_by = hz_utility_pub.user_id,

Line 345: and customer_id not in(select customer_id from as_changed_accounts_all

341: program_application_id = hz_utility_pub.program_application_id,
342: program_id = hz_utility_pub.program_id,
343: program_update_date = sysdate
344: where address_id = p_from_fk_id
345: and customer_id not in(select customer_id from as_changed_accounts_all
346: where address_id=p_to_fk_id) ;
347:
348: END IF;
349: EXCEPTION