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_OPP_MERGE_PKG dependencies on AS_LEADS_LOG

Line 188: -- add AS_LEADS_LOG.customer_id and AS_LEADS_LOG.close_competitor_id

184: program_id = hz_utility_pub.program_id,
185: program_update_date = sysdate
186: where customer_id = p_from_fk_id;
187:
188: -- add AS_LEADS_LOG.customer_id and AS_LEADS_LOG.close_competitor_id
189: -- add AS_SALES_CREDITS_DENORM.close_competitor_id
190:
191: l_col_name := 'AS_LEADS_LOG.customer_id';
192:

Line 191: l_col_name := 'AS_LEADS_LOG.customer_id';

187:
188: -- add AS_LEADS_LOG.customer_id and AS_LEADS_LOG.close_competitor_id
189: -- add AS_SALES_CREDITS_DENORM.close_competitor_id
190:
191: l_col_name := 'AS_LEADS_LOG.customer_id';
192:
193: UPDATE AS_LEADS_LOG
194: set object_version_number = nvl(object_version_number,0) + 1, customer_id = p_to_fk_id
195: --last_update_date = hz_utility_pub.last_update_date,

Line 193: UPDATE AS_LEADS_LOG

189: -- add AS_SALES_CREDITS_DENORM.close_competitor_id
190:
191: l_col_name := 'AS_LEADS_LOG.customer_id';
192:
193: UPDATE AS_LEADS_LOG
194: set object_version_number = nvl(object_version_number,0) + 1, customer_id = p_to_fk_id
195: --last_update_date = hz_utility_pub.last_update_date,
196: --last_updated_by = hz_utility_pub.user_id,
197: --last_update_login = hz_utility_pub.last_update_login

Line 204: l_col_name := 'AS_LEADS_LOG.close_competitor_id';

200: --program_id = hz_utility_pub.program_id,
201: --program_update_date = sysdate
202: where customer_id = p_from_fk_id;
203:
204: l_col_name := 'AS_LEADS_LOG.close_competitor_id';
205:
206: UPDATE AS_LEADS_LOG
207: set object_version_number = nvl(object_version_number,0) + 1, close_competitor_id = p_to_fk_id
208: --last_update_date = hz_utility_pub.last_update_date,

Line 206: UPDATE AS_LEADS_LOG

202: where customer_id = p_from_fk_id;
203:
204: l_col_name := 'AS_LEADS_LOG.close_competitor_id';
205:
206: UPDATE AS_LEADS_LOG
207: set object_version_number = nvl(object_version_number,0) + 1, close_competitor_id = p_to_fk_id
208: --last_update_date = hz_utility_pub.last_update_date,
209: --last_updated_by = hz_utility_pub.user_id,
210: --last_update_login = hz_utility_pub.last_update_login,

Line 313: -- add AS_LEADS_LOG.address_id

309: program_id = hz_utility_pub.program_id,
310: program_update_date = sysdate
311: where address_id = p_from_fk_id;
312:
313: -- add AS_LEADS_LOG.address_id
314:
315: l_col_name := 'AS_LEADS_LOG.address_id';
316:
317: UPDATE AS_LEADS_LOG

Line 315: l_col_name := 'AS_LEADS_LOG.address_id';

311: where address_id = p_from_fk_id;
312:
313: -- add AS_LEADS_LOG.address_id
314:
315: l_col_name := 'AS_LEADS_LOG.address_id';
316:
317: UPDATE AS_LEADS_LOG
318: set object_version_number = nvl(object_version_number,0) + 1, address_id = p_to_fk_id
319: --last_update_date = hz_utility_pub.last_update_date,

Line 317: UPDATE AS_LEADS_LOG

313: -- add AS_LEADS_LOG.address_id
314:
315: l_col_name := 'AS_LEADS_LOG.address_id';
316:
317: UPDATE AS_LEADS_LOG
318: set object_version_number = nvl(object_version_number,0) + 1, address_id = p_to_fk_id
319: --last_update_date = hz_utility_pub.last_update_date,
320: --last_updated_by = hz_utility_pub.user_id,
321: --last_update_login = hz_utility_pub.last_update_login,