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 2899: INSERT INTO AS_CHANGED_ACCOUNTS_ALL(

2895: -- ER 3052066
2896: -- Leave a record for TAP New mode
2897: -- Used to sync TRANS and NM_TRANS table
2898: BEGIN
2899: INSERT INTO AS_CHANGED_ACCOUNTS_ALL(
2900: customer_id, address_id, sales_lead_id, last_update_date,
2901: last_updated_by, creation_date, created_by,
2902: last_update_login, change_type, delete_flag, insert_flag,
2903: processed_flag)

Line 2911: UPDATE AS_CHANGED_ACCOUNTS_ALL

2907: FND_GLOBAL.CONC_LOGIN_ID, 'LEAD', 'N', 'Y',
2908: 'Y');
2909: EXCEPTION
2910: WHEN OTHERS THEN
2911: UPDATE AS_CHANGED_ACCOUNTS_ALL
2912: SET processed_flag = 'Y'
2913: WHERE sales_lead_id = p_sales_lead_id;
2914: END;
2915: -- IF NVL(fnd_profile.value('AS_ENABLE_LEAD_ONLINE_TAP'), 'Y') = 'Y'

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

2915: -- IF NVL(fnd_profile.value('AS_ENABLE_LEAD_ONLINE_TAP'), 'Y') = 'Y'
2916: -- THEN
2917: -- 1. If AS_ENABLE_LEAD_ONLINE_TAP is 'Y', update record.
2918: -- 2. If AS_ENABLE_LEAD_ONLINE_TAP is 'N', still keep it in
2919: -- as_changed_accounts_all, so TAP New Mode will pick up this
2920: -- record.
2921: -- DELETE FROM as_changed_accounts_all
2922: -- WHERE sales_lead_id = p_sales_lead_id;
2923: -- IF (AS_DEBUG_LOW_ON) THEN

Line 2921: -- DELETE FROM as_changed_accounts_all

2917: -- 1. If AS_ENABLE_LEAD_ONLINE_TAP is 'Y', update record.
2918: -- 2. If AS_ENABLE_LEAD_ONLINE_TAP is 'N', still keep it in
2919: -- as_changed_accounts_all, so TAP New Mode will pick up this
2920: -- record.
2921: -- DELETE FROM as_changed_accounts_all
2922: -- WHERE sales_lead_id = p_sales_lead_id;
2923: -- IF (AS_DEBUG_LOW_ON) THEN
2924: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2925: -- 'Delete as_changed_accounts_all record');

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

2921: -- DELETE FROM as_changed_accounts_all
2922: -- WHERE sales_lead_id = p_sales_lead_id;
2923: -- IF (AS_DEBUG_LOW_ON) THEN
2924: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2925: -- 'Delete as_changed_accounts_all record');
2926: -- END IF;
2927: -- UPDATE as_changed_accounts_all
2928: -- SET processed_flag = 'Y'
2929: -- WHERE sales_lead_id = p_sales_lead_id;

Line 2927: -- UPDATE as_changed_accounts_all

2923: -- IF (AS_DEBUG_LOW_ON) THEN
2924: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2925: -- 'Delete as_changed_accounts_all record');
2926: -- END IF;
2927: -- UPDATE as_changed_accounts_all
2928: -- SET processed_flag = 'Y'
2929: -- WHERE sales_lead_id = p_sales_lead_id;
2930: -- END IF;
2931:

Line 3539: INSERT INTO AS_CHANGED_ACCOUNTS_ALL(

3535: -- ER 3052066
3536: -- Leave a record for TAP New mode
3537: -- Used to sync TRANS and NM_TRANS table
3538: BEGIN
3539: INSERT INTO AS_CHANGED_ACCOUNTS_ALL(
3540: customer_id, address_id, sales_lead_id, last_update_date,
3541: last_updated_by, creation_date, created_by,
3542: last_update_login, change_type, delete_flag, insert_flag,
3543: processed_flag)

Line 3551: UPDATE AS_CHANGED_ACCOUNTS_ALL

3547: FND_GLOBAL.CONC_LOGIN_ID, 'LEAD', 'N', 'Y',
3548: 'Y');
3549: EXCEPTION
3550: WHEN OTHERS THEN
3551: UPDATE AS_CHANGED_ACCOUNTS_ALL
3552: SET processed_flag = 'Y'
3553: WHERE sales_lead_id = p_sales_lead_id;
3554: END;
3555: -- IF NVL(fnd_profile.value('AS_ENABLE_LEAD_ONLINE_TAP'), 'Y') = 'Y'

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

3555: -- IF NVL(fnd_profile.value('AS_ENABLE_LEAD_ONLINE_TAP'), 'Y') = 'Y'
3556: -- THEN
3557: -- 1. If AS_ENABLE_LEAD_ONLINE_TAP is 'Y', delete record.
3558: -- 2. If AS_ENABLE_LEAD_ONLINE_TAP is 'N', still keep it in
3559: -- as_changed_accounts_all, so TAP New Mode will pick up this
3560: -- record.
3561: -- DELETE FROM as_changed_accounts_all
3562: -- WHERE sales_lead_id = p_sales_lead_id;
3563: -- IF (AS_DEBUG_LOW_ON) THEN

Line 3561: -- DELETE FROM as_changed_accounts_all

3557: -- 1. If AS_ENABLE_LEAD_ONLINE_TAP is 'Y', delete record.
3558: -- 2. If AS_ENABLE_LEAD_ONLINE_TAP is 'N', still keep it in
3559: -- as_changed_accounts_all, so TAP New Mode will pick up this
3560: -- record.
3561: -- DELETE FROM as_changed_accounts_all
3562: -- WHERE sales_lead_id = p_sales_lead_id;
3563: -- IF (AS_DEBUG_LOW_ON) THEN
3564: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3565: -- 'Delete as_changed_accounts_all record');

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

3561: -- DELETE FROM as_changed_accounts_all
3562: -- WHERE sales_lead_id = p_sales_lead_id;
3563: -- IF (AS_DEBUG_LOW_ON) THEN
3564: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3565: -- 'Delete as_changed_accounts_all record');
3566: -- END IF;
3567: -- END IF;
3568:
3569: IF l_return_status = 'W'