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 ASG_USER

Line 132: FROM asg_user au,

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
136: FROM fnd_profile_options opt,

Line 138: asg_user au

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'
142: ,'CS_INV_VALIDATION_ORG' ,'INC_DEFAULT_INCIDENT_TYPE' ,'INC_DEFAULT_INCIDENT_STATUS' ,'CSM_ENABLE_CREATE_SR'

Line 181: csm_profile_option_values_acc acc,asg_user au

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)
185: AND (val.level_id<> 10002 OR val.level_value=au.app_id)

Line 372: FROM asg_user au,

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
376: FROM fnd_profile_options opt,

Line 378: asg_user au

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'
382: ,'CLIENT_TIMEZONE_ID' ,'CSF_BUSINESS_PROCESS'

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 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'