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.CSM_PROFILE_EVENT_PKG dependencies on FND_PROFILE

Line 10: WHERE NOT EXISTS (SELECT 1 FROM fnd_profile_option_values val

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

Line 18: WHERE NOT EXISTS( SELECT 1 FROM FND_PROFILE_OPTIONS OPT

14: AND acc.level_value = val.level_value
15: AND (acc.level_id <> 10003 OR acc.level_value_application_id=val.level_value_application_id))
16: UNION
17: SELECT access_id,user_id FROM csm_profile_option_values_acc ACC
18: WHERE NOT EXISTS( SELECT 1 FROM FND_PROFILE_OPTIONS OPT
19: WHERE OPT.PROFILE_OPTION_ID = ACC.PROFILE_OPTION_ID
20: AND OPT.APPLICATION_ID = ACC.APPLICATION_ID
21: AND NVL(OPT.start_date_active, SYSDATE) <= SYSDATE
22: AND NVL(OPT.end_date_active, SYSDATE) >= SYSDATE

Line 131: fnd_profile.value_specific(profile_option_name,au.user_id,au.responsibility_id,au.APP_ID) PRF_VALUE,profile_option_name prf_name

127: -- get the profiles with values to be inserted
128: CURSOR l_profiles_ins_csr
129: IS
130: SELECT csm_profiles_acc_s.NEXTVAL as ACCESS_ID,au.user_id,application_id,profile_option_id,level_id,level_value,LEVEL_VALUE_APPLICATION_ID,
131: fnd_profile.value_specific(profile_option_name,au.user_id,au.responsibility_id,au.APP_ID) PRF_VALUE,profile_option_name prf_name
132: FROM asg_user au,
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

Line 136: FROM fnd_profile_options opt,

132: FROM asg_user au,
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'

Line 137: fnd_profile_option_values val,

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'

Line 180: FROM fnd_profile_option_values val,

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)

Line 371: fnd_profile.value_specific(profile_option_name,au.user_id,au.responsibility_id,au.APP_ID) PRF_VALUE,profile_option_name prf_name

367: -- get the profiles with values to be inserted
368: CURSOR l_profiles_ins_csr
369: IS
370: SELECT csm_profiles_acc_s.NEXTVAL as ACCESS_ID,au.user_id,application_id,profile_option_id,level_id,level_value,LEVEL_VALUE_APPLICATION_ID,
371: fnd_profile.value_specific(profile_option_name,au.user_id,au.responsibility_id,au.APP_ID) PRF_VALUE,profile_option_name prf_name
372: FROM asg_user au,
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

Line 376: FROM fnd_profile_options opt,

372: FROM asg_user au,
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'

Line 377: fnd_profile_option_values val,

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'

Line 493: FROM fnd_profile_options opt,asg_user au

489: IF PROFILES with no "value" set, is required, then add this inside "tab" of insert cursor */
490: /*
491: UNION ALL
492: SELECT opt.profile_option_name,opt.application_id, opt.profile_option_id,au.user_id,null as LEVEL_ID , null LEVEL_VALUE, null LEVEL_VALUE_APPLICATION_ID
493: FROM fnd_profile_options opt,asg_user au
494: WHERE opt.profile_option_name in ( 'CSF_M_RECIPIENTS_BOUNDARY' ,'CSF_MOBILE_TASK_TIMES_UPDATABLE' ,'CSF_DEBRIEF_OVERLAPPING_LABOR'
495: ,'INC_DEFAULT_INCIDENT_SEVERITY' ,'INC_DEFAULT_INCIDENT_URGENCY'
496: ,'JTF_TIME_UOM_CLASS' ,'ICX_PREFERRED_CURRENCY' ,'JTF_TASK_DEFAULT_ASSIGNEE_STATUS' ,'CS_SR_RESTRICT_IB' ,'SERVER_TIMEZONE_ID'
497: ,'CLIENT_TIMEZONE_ID' ,'CSF_BUSINESS_PROCESS'

Line 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)

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

Line 532: FROM fnd_profile_options opt,asg_user au

528: ******/
529: /*
530: SELECT csm_profiles_acc_s.NEXTVAL as ACCESS_ID,au.user_id,opt.profile_option_name,opt.application_id, opt.profile_option_id,au.user_id,
531: null as LEVEL_ID , null LEVEL_VALUE, null LEVEL_VALUE_APPLICATION_ID,opt.profile_option_name
532: FROM fnd_profile_options opt,asg_user au
533: WHERE opt.profile_option_name in ( 'CSF_M_RECIPIENTS_BOUNDARY' ,'CSF_MOBILE_TASK_TIMES_UPDATABLE' ,'CSF_DEBRIEF_OVERLAPPING_LABOR'
534: ,'INC_DEFAULT_INCIDENT_SEVERITY' ,'INC_DEFAULT_INCIDENT_URGENCY'
535: ,'JTF_TIME_UOM_CLASS' ,'ICX_PREFERRED_CURRENCY' ,'JTF_TASK_DEFAULT_ASSIGNEE_STATUS' ,'CS_SR_RESTRICT_IB' ,'SERVER_TIMEZONE_ID'
536: ,'CLIENT_TIMEZONE_ID' ,'CSF_BUSINESS_PROCESS'