APPS.AS_SALES_LEAD_ENGINE_PVT dependencies on AS_ACCESSES_ALL

Line 76: -- lead_rank_score in as_accesses_all table

72: -- Add one more parameter p_lead_action in
73: -- aml_monitor_wf.launch_monitor
74: -- 05/01/2003 SOLIN Bug 2877904
75: -- Add open_flag, object_creation_date, and
76: -- lead_rank_score in as_accesses_all table
77: -- 06/17/2003 SWKHANNA changed lead_process_after_update to include logic for starting
78: -- monitor after grade change.
79: --
80: -- 09/09/2003 SWKHANNA Added extra parameter to be passed in to launch monitor

Line 2475: UPDATE as_accesses_all

2471: UPDATE as_sales_leads
2472: SET lead_rank_score = l_lead_rank_score
2473: WHERE sales_lead_id = p_sales_lead_id;
2474:
2475: UPDATE as_accesses_all
2476: SET lead_rank_score = l_lead_rank_score
2477: WHERE sales_lead_id = p_sales_lead_id;
2478: END IF;
2479: -- end CRMAP denorm project

Line 3076: FROM as_accesses_all acc

3072:
3073: -- Check whether owner exists or not
3074: CURSOR c_check_owner_exists(c_sales_lead_id NUMBER) IS
3075: SELECT 'Y'
3076: FROM as_accesses_all acc
3077: WHERE acc.sales_lead_id = c_sales_lead_id
3078: AND acc.owner_flag = 'Y';
3079:
3080: CURSOR C_Get_Person(C_Resource_Id NUMBER) IS

Line 3245: -- remove owner in as_accesses_all

3241: RAISE FND_API.G_EXC_ERROR;
3242: END IF;
3243:
3244: -- Check owner again here because Rebuild_Lead_Sales_Team may
3245: -- remove owner in as_accesses_all
3246: l_owner_exists_flag := 'N';
3247: OPEN c_check_owner_exists(p_sales_lead_id);
3248: FETCH c_check_owner_exists INTO l_owner_exists_flag;
3249: CLOSE c_check_owner_exists;