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_SALES_LEAD_ENGINE_PVT dependencies on AS_CHANGED_ACCOUNTS_ALL

Line 2953: INSERT INTO AS_CHANGED_ACCOUNTS_ALL(

2949: -- ER 3052066
2950: -- Leave a record for TAP New mode
2951: -- Used to sync TRANS and NM_TRANS table
2952: BEGIN
2953: INSERT INTO AS_CHANGED_ACCOUNTS_ALL(
2954: customer_id, address_id, sales_lead_id, last_update_date,
2955: last_updated_by, creation_date, created_by,
2956: last_update_login, change_type, delete_flag, insert_flag,
2957: processed_flag)

Line 2965: UPDATE AS_CHANGED_ACCOUNTS_ALL

2961: FND_GLOBAL.CONC_LOGIN_ID, 'LEAD', 'N', 'Y',
2962: 'Y');
2963: EXCEPTION
2964: WHEN OTHERS THEN
2965: UPDATE AS_CHANGED_ACCOUNTS_ALL
2966: SET processed_flag = 'Y'
2967: WHERE sales_lead_id = p_sales_lead_id;
2968: END;
2969: -- IF NVL(fnd_profile.value('AS_ENABLE_LEAD_ONLINE_TAP'), 'Y') = 'Y'

Line 2973: -- as_changed_accounts_all, so TAP New Mode will pick up this

2969: -- IF NVL(fnd_profile.value('AS_ENABLE_LEAD_ONLINE_TAP'), 'Y') = 'Y'
2970: -- THEN
2971: -- 1. If AS_ENABLE_LEAD_ONLINE_TAP is 'Y', update record.
2972: -- 2. If AS_ENABLE_LEAD_ONLINE_TAP is 'N', still keep it in
2973: -- as_changed_accounts_all, so TAP New Mode will pick up this
2974: -- record.
2975: -- DELETE FROM as_changed_accounts_all
2976: -- WHERE sales_lead_id = p_sales_lead_id;
2977: -- IF (AS_DEBUG_LOW_ON) THEN

Line 2975: -- DELETE FROM as_changed_accounts_all

2971: -- 1. If AS_ENABLE_LEAD_ONLINE_TAP is 'Y', update record.
2972: -- 2. If AS_ENABLE_LEAD_ONLINE_TAP is 'N', still keep it in
2973: -- as_changed_accounts_all, so TAP New Mode will pick up this
2974: -- record.
2975: -- DELETE FROM as_changed_accounts_all
2976: -- WHERE sales_lead_id = p_sales_lead_id;
2977: -- IF (AS_DEBUG_LOW_ON) THEN
2978: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2979: -- 'Delete as_changed_accounts_all record');

Line 2979: -- 'Delete as_changed_accounts_all record');

2975: -- DELETE FROM as_changed_accounts_all
2976: -- WHERE sales_lead_id = p_sales_lead_id;
2977: -- IF (AS_DEBUG_LOW_ON) THEN
2978: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2979: -- 'Delete as_changed_accounts_all record');
2980: -- END IF;
2981: -- UPDATE as_changed_accounts_all
2982: -- SET processed_flag = 'Y'
2983: -- WHERE sales_lead_id = p_sales_lead_id;

Line 2981: -- UPDATE as_changed_accounts_all

2977: -- IF (AS_DEBUG_LOW_ON) THEN
2978: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2979: -- 'Delete as_changed_accounts_all record');
2980: -- END IF;
2981: -- UPDATE as_changed_accounts_all
2982: -- SET processed_flag = 'Y'
2983: -- WHERE sales_lead_id = p_sales_lead_id;
2984: -- END IF;
2985:

Line 3593: INSERT INTO AS_CHANGED_ACCOUNTS_ALL(

3589: -- ER 3052066
3590: -- Leave a record for TAP New mode
3591: -- Used to sync TRANS and NM_TRANS table
3592: BEGIN
3593: INSERT INTO AS_CHANGED_ACCOUNTS_ALL(
3594: customer_id, address_id, sales_lead_id, last_update_date,
3595: last_updated_by, creation_date, created_by,
3596: last_update_login, change_type, delete_flag, insert_flag,
3597: processed_flag)

Line 3605: UPDATE AS_CHANGED_ACCOUNTS_ALL

3601: FND_GLOBAL.CONC_LOGIN_ID, 'LEAD', 'N', 'Y',
3602: 'Y');
3603: EXCEPTION
3604: WHEN OTHERS THEN
3605: UPDATE AS_CHANGED_ACCOUNTS_ALL
3606: SET processed_flag = 'Y'
3607: WHERE sales_lead_id = p_sales_lead_id;
3608: END;
3609: -- IF NVL(fnd_profile.value('AS_ENABLE_LEAD_ONLINE_TAP'), 'Y') = 'Y'

Line 3613: -- as_changed_accounts_all, so TAP New Mode will pick up this

3609: -- IF NVL(fnd_profile.value('AS_ENABLE_LEAD_ONLINE_TAP'), 'Y') = 'Y'
3610: -- THEN
3611: -- 1. If AS_ENABLE_LEAD_ONLINE_TAP is 'Y', delete record.
3612: -- 2. If AS_ENABLE_LEAD_ONLINE_TAP is 'N', still keep it in
3613: -- as_changed_accounts_all, so TAP New Mode will pick up this
3614: -- record.
3615: -- DELETE FROM as_changed_accounts_all
3616: -- WHERE sales_lead_id = p_sales_lead_id;
3617: -- IF (AS_DEBUG_LOW_ON) THEN

Line 3615: -- DELETE FROM as_changed_accounts_all

3611: -- 1. If AS_ENABLE_LEAD_ONLINE_TAP is 'Y', delete record.
3612: -- 2. If AS_ENABLE_LEAD_ONLINE_TAP is 'N', still keep it in
3613: -- as_changed_accounts_all, so TAP New Mode will pick up this
3614: -- record.
3615: -- DELETE FROM as_changed_accounts_all
3616: -- WHERE sales_lead_id = p_sales_lead_id;
3617: -- IF (AS_DEBUG_LOW_ON) THEN
3618: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3619: -- 'Delete as_changed_accounts_all record');

Line 3619: -- 'Delete as_changed_accounts_all record');

3615: -- DELETE FROM as_changed_accounts_all
3616: -- WHERE sales_lead_id = p_sales_lead_id;
3617: -- IF (AS_DEBUG_LOW_ON) THEN
3618: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3619: -- 'Delete as_changed_accounts_all record');
3620: -- END IF;
3621: -- END IF;
3622:
3623: IF l_return_status = 'W'