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

Line 2022: FROM AS_CHANGED_ACCOUNTS_ALL

2018: )
2019: IS
2020: CURSOR C_Check_Changed(C_Sales_Lead_Id NUMBER) IS
2021: SELECT ADDRESS_ID
2022: FROM AS_CHANGED_ACCOUNTS_ALL
2023: WHERE SALES_LEAD_ID = C_Sales_Lead_Id
2024: AND PROCESSED_FLAG = 'N';
2025:
2026: CURSOR C_Get_Lead_Info(C_Sales_Lead_Id NUMBER) IS

Line 2394: -- l_old_address_id comes from as_changed_accounts_all.

2390: -- Api body
2391: --
2392:
2393: -- Get sales lead info.
2394: -- l_old_address_id comes from as_changed_accounts_all.
2395: -- If user changed address_id, l_old_address_id is OLD address_id.
2396: -- Hense, cursor C_Get_Acc_Terr can get original records.
2397: OPEN C_Get_Lead_Info(p_Sales_Lead_Id);
2398: FETCH C_Get_Lead_Info INTO

Line 2413: -- because there's no record in as_changed_accounts_all

2409:
2410: IF l_old_address_id = FND_API.G_MISS_NUM
2411: THEN
2412: -- There's no need to rebuild sales team for this sales lead
2413: -- because there's no record in as_changed_accounts_all
2414: IF (AS_DEBUG_LOW_ON) THEN
2415: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2416: 'Lead not in AS_CHANGED_ACCOUNTS_ALL');
2417: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 2416: 'Lead not in AS_CHANGED_ACCOUNTS_ALL');

2412: -- There's no need to rebuild sales team for this sales lead
2413: -- because there's no record in as_changed_accounts_all
2414: IF (AS_DEBUG_LOW_ON) THEN
2415: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2416: 'Lead not in AS_CHANGED_ACCOUNTS_ALL');
2417: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2418: 'PVT: ' || l_api_name || ' End');
2419: END IF;
2420:

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

2430: IF NVL(fnd_profile.value('AS_ENABLE_LEAD_ONLINE_TAP'), 'Y') = 'Y'
2431: THEN
2432: -- 1. If AS_ENABLE_LEAD_ONLINE_TAP is 'Y', delete record.
2433: -- 2. If AS_ENABLE_LEAD_ONLINE_TAP is 'N', still keep it in
2434: -- as_changed_accounts_all, so TAP New Mode will pick up this
2435: -- record.
2436: UPDATE as_changed_accounts_all
2437: SET processed_flag = 'Y'
2438: WHERE sales_lead_id = p_sales_lead_id;

Line 2436: UPDATE as_changed_accounts_all

2432: -- 1. If AS_ENABLE_LEAD_ONLINE_TAP is 'Y', delete record.
2433: -- 2. If AS_ENABLE_LEAD_ONLINE_TAP is 'N', still keep it in
2434: -- as_changed_accounts_all, so TAP New Mode will pick up this
2435: -- record.
2436: UPDATE as_changed_accounts_all
2437: SET processed_flag = 'Y'
2438: WHERE sales_lead_id = p_sales_lead_id;
2439: IF (AS_DEBUG_LOW_ON) THEN
2440: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 2441: 'Delete as_changed_accounts_all record');

2437: SET processed_flag = 'Y'
2438: WHERE sales_lead_id = p_sales_lead_id;
2439: IF (AS_DEBUG_LOW_ON) THEN
2440: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2441: 'Delete as_changed_accounts_all record');
2442: END IF;
2443: ELSIF l_assign_to_salesforce_id IS NOT NULL AND
2444: l_reject_reason_code IS NULL
2445: THEN

Line 3034: FROM AS_CHANGED_ACCOUNTS_ALL

3030: FUNCTION Changed_Accounts_Record_Exist(
3031: P_Sales_Lead_Id NUMBER) RETURN BOOLEAN IS
3032: CURSOR c1(C_Sales_Lead_Id NUMBER) IS
3033: SELECT CUSTOMER_ID
3034: FROM AS_CHANGED_ACCOUNTS_ALL
3035: WHERE SALES_LEAD_ID = C_Sales_Lead_Id
3036: AND REQUEST_ID IS NULL;
3037: l_dummy NUMBER;
3038: BEGIN

Line 3135: -- need to insert into as_changed_accounts_all

3131: -- IF (P_Trigger_Mode IN ('ON-INSERT', 'ON-DELETE'))
3132: -- IF (P_Trigger_Mode = 'ON-DELETE')
3133: -- THEN
3134: -- Build_Lead_Sales_Team will take care of assignment, no
3135: -- need to insert into as_changed_accounts_all
3136: RETURN;
3137: -- END IF;
3138: -- l_address_id := p_old_address_id;
3139: ELSE

Line 3199: INSERT INTO AS_CHANGED_ACCOUNTS_ALL(

3195: END IF;
3196: -- IF NOT Changed_Accounts_Record_Exist(P_Sales_Lead_Id)
3197: -- THEN
3198: BEGIN
3199: INSERT INTO AS_CHANGED_ACCOUNTS_ALL(
3200: customer_id, address_id, sales_lead_id, last_update_date,
3201: last_updated_by, creation_date, created_by, last_update_login,
3202: change_type, delete_flag, insert_flag, processed_flag)
3203: VALUES

Line 3208: UPDATE AS_CHANGED_ACCOUNTS_ALL

3204: (P_Customer_Id, l_Address_id, P_Sales_Lead_id, SYSDATE, 0,
3205: SYSDATE, 0, 0, 'LEAD', 'N', l_insert_flag, 'N');
3206: EXCEPTION
3207: WHEN OTHERS THEN
3208: UPDATE AS_CHANGED_ACCOUNTS_ALL
3209: SET processed_flag = 'N'
3210: WHERE sales_lead_id = p_sales_lead_id;
3211: END;
3212: -- END IF;

Line 3313: INSERT INTO AS_CHANGED_ACCOUNTS_ALL(

3309: IF( Is_Changed = TRUE)
3310: -- AND NOT Changed_Accounts_Record_Exist(p_sales_lead_id))
3311: THEN
3312: BEGIN
3313: INSERT INTO AS_CHANGED_ACCOUNTS_ALL(
3314: customer_id, address_id, sales_lead_id, last_update_date,
3315: last_updated_by, creation_date, created_by,
3316: last_update_login, change_type, delete_flag, insert_flag,
3317: processed_flag)

Line 3323: UPDATE AS_CHANGED_ACCOUNTS_ALL

3319: (l_customer_id, l_address_id, p_sales_lead_id, SYSDATE, 0,
3320: SYSDATE, 0, 0, 'LEAD', 'N', 'N', 'N');
3321: EXCEPTION
3322: WHEN OTHERS THEN
3323: UPDATE AS_CHANGED_ACCOUNTS_ALL
3324: SET processed_flag = 'N'
3325: WHERE sales_lead_id = p_sales_lead_id;
3326: END;
3327: END IF;