[Home] [Help]
6: -- get the profiles to be deleted
7: CURSOR l_profiles_del_csr
8: IS
9: SELECT acc.access_id,acc.user_id FROM csm_profile_option_values_acc acc
10: WHERE NOT EXISTS (SELECT 1 FROM fnd_profile_option_values val
11: WHERE acc.profile_option_id = val.profile_option_id
12: AND acc.application_id = val.application_id
13: AND acc.level_id = val.level_id
14: AND acc.level_value = val.level_value
133: (SELECT opt.profile_option_name,val.application_id, val.profile_option_id,au.user_id,max(val.level_id) as LEVEL_ID ,
134: decode(max(val.level_id),10004,au.user_id,10003,asg_base.get_resp_id(au.user_name),10002,asg_base.get_application_id(au.user_name),0) LEVEL_VALUE,
135: decode(max(val.level_id),10003,max(level_value_application_id),null) LEVEL_VALUE_APPLICATION_ID
136: FROM fnd_profile_options opt,
137: fnd_profile_option_values val,
138: asg_user au
139: WHERE opt.profile_option_name in ( 'CSF_M_RECIPIENTS_BOUNDARY' ,'CSF_MOBILE_TASK_TIMES_UPDATABLE' ,'CSF_DEBRIEF_OVERLAPPING_LABOR' ,'INC_DEFAULT_INCIDENT_SEVERITY'
140: ,'INC_DEFAULT_INCIDENT_URGENCY' ,'JTF_TIME_UOM_CLASS' ,'ICX_PREFERRED_CURRENCY' ,'JTF_TASK_DEFAULT_ASSIGNEE_STATUS' ,'CS_SR_RESTRICT_IB' ,'SERVER_TIMEZONE_ID'
141: ,'CLIENT_TIMEZONE_ID' ,'CSF_BUSINESS_PROCESS' ,'CSM_SEARCH_RESULT_SET_SIZE' ,'CSM_IB_ITEMS_AT_LOCATION' ,'CSM_ITEM_CATEGORY_SET_FILTER' ,'CSM_ITEM_CATEGORY_FILTER'
176: -- get the profiles to be updated
177: CURSOR l_profiles_upd_csr
178: IS
179: SELECT acc.access_id,acc.user_id,val.level_id,val.level_value,val.LEVEL_VALUE_APPLICATION_ID,val.profile_option_value
180: FROM fnd_profile_option_values val,
181: csm_profile_option_values_acc acc,asg_user au
182: WHERE val.profile_option_id = acc.profile_option_id
183: AND val.application_id = acc.application_id
184: AND val.level_id in (10001,10002,10003,10004)
373: (SELECT opt.profile_option_name,val.application_id, val.profile_option_id,au.user_id,max(val.level_id) as LEVEL_ID ,
374: decode(max(val.level_id),10004,au.user_id,10003,asg_base.get_resp_id(au.user_name),10002,asg_base.get_application_id(au.user_name),0) LEVEL_VALUE,
375: decode(max(val.level_id),10003,max(level_value_application_id),null) LEVEL_VALUE_APPLICATION_ID
376: FROM fnd_profile_options opt,
377: fnd_profile_option_values val,
378: asg_user au
379: WHERE opt.profile_option_name in ( 'CSF_M_RECIPIENTS_BOUNDARY' ,'CSF_MOBILE_TASK_TIMES_UPDATABLE' ,'CSF_DEBRIEF_OVERLAPPING_LABOR'
380: ,'INC_DEFAULT_INCIDENT_SEVERITY' ,'INC_DEFAULT_INCIDENT_URGENCY'
381: ,'JTF_TIME_UOM_CLASS' ,'ICX_PREFERRED_CURRENCY' ,'JTF_TASK_DEFAULT_ASSIGNEE_STATUS' ,'CS_SR_RESTRICT_IB' ,'SERVER_TIMEZONE_ID'
518: ,'JTF_NTS_NOTE_TYPE','CSF_DEBRIEF_RESTRICT_INSTANCE' ,'CSF_ENABLE_RETURN_ROUTING_DBF','CSP_PART_REQ_DEF_SHIP_TO'
519: ,'CSF_GOOGLE_MAP_KEY','CSF_GOOGLE_MAP_CLIENT_ID','CSF_GOOGLE_MAP_ADDENDUM','CSM_CUSTOMIZATION_KEY','CSM_DFLT_TASK_STATUS_SYNC_UPD')
520: AND NVL(opt.start_date_active, SYSDATE) <= SYSDATE
521: AND NVL(opt.end_date_active, SYSDATE) >= SYSDATE
522: AND NOT EXISTS(SELECT 1 FROM fnd_profile_option_values val WHERE val.application_id = opt.application_id AND val.profile_option_id = opt.profile_option_id)
523: AND au.enabled='Y'
524: */
525:
526: /****** AFTER INSERT IS COMPLETE, there may be profiles with values set not at site but at app/resp/user level not macthing user-s ; don't think it;s required to be downloaded