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 2023: FROM AS_CHANGED_ACCOUNTS_ALL

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

Line 2395: -- l_old_address_id comes from as_changed_accounts_all.

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

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

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

Line 2417: 'Lead not in AS_CHANGED_ACCOUNTS_ALL');

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

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

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

Line 2437: UPDATE as_changed_accounts_all

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

Line 2442: 'Delete as_changed_accounts_all record');

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

Line 3035: FROM AS_CHANGED_ACCOUNTS_ALL

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

Line 3136: -- need to insert into as_changed_accounts_all

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

Line 3200: INSERT INTO AS_CHANGED_ACCOUNTS_ALL(

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

Line 3209: UPDATE AS_CHANGED_ACCOUNTS_ALL

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

Line 3314: INSERT INTO AS_CHANGED_ACCOUNTS_ALL(

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

Line 3324: UPDATE AS_CHANGED_ACCOUNTS_ALL

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