APPS.CSM_PROFILE_EVENT_PKG dependencies on FND_PROFILE_OPTIONS

Line 114: FROM fnd_profile_options opt,

110: CURSOR l_profiles_wovalue_ins_csr
111: IS
112: SELECT csm_profiles_acc_s.NEXTVAL as ACCESS_ID, au.user_id ,
113: opt.profile_option_id, opt.application_id
114: FROM fnd_profile_options opt,
115: ASG_USER au
116: WHERE (opt.profile_option_name = 'CSF_M_RECIPIENTS_BOUNDARY'
117: OR opt.profile_option_name = 'CSF_MOBILE_TASK_TIMES_UPDATABLE'
118: OR opt.profile_option_name = 'CSF_DEBRIEF_OVERLAPPING_LABOR'

Line 188: FROM fnd_profile_options opt,

184: p_csm_resp_id fnd_responsibility.responsibility_id%TYPE)
185: IS
186: SELECT val.application_id, val.profile_option_id, val.level_id, val.level_value,
187: val.level_value_application_id, val.profile_option_value, opt.profile_option_name
188: FROM fnd_profile_options opt,
189: fnd_profile_option_values val
190: WHERE (opt.profile_option_name = 'CSF_M_RECIPIENTS_BOUNDARY'
191: -- OR opt.profile_option_name = 'CSF_M_AGENDA_ALLOWCHANGESCOMPLETEDTASK' ---end_dated
192: OR opt.profile_option_name = 'CSF_MOBILE_TASK_TIMES_UPDATABLE'

Line 306: fnd_profile_options opt

302: SELECT acc.access_id, acc.application_id, acc.profile_option_id, acc.level_id, acc.level_value,
303: acc.level_value_application_id, acc.profile_option_value, opt.profile_option_name,
304: acc.user_id
305: FROM csm_profile_option_values_acc acc,
306: fnd_profile_options opt
307: WHERE acc.profile_option_id = opt.profile_option_id
308: AND acc.application_id = opt.application_id
309: AND acc.level_id IS NOT NULL
310: AND acc.level_value IS NOT NULL

Line 401: FROM FND_PROFILE_OPTIONS OPT

397: ACC.APPLICATION_ID,
398: ACC.PROFILE_OPTION_ID
399: FROM csm_profile_option_values_acc ACC
400: WHERE NOT EXISTS( SELECT 1
401: FROM FND_PROFILE_OPTIONS OPT
402: WHERE OPT.PROFILE_OPTION_ID = ACC.PROFILE_OPTION_ID
403: AND OPT.APPLICATION_ID = ACC.APPLICATION_ID
404: AND OPT.PROFILE_OPTION_NAME IN
405: ( 'CSF_M_RECIPIENTS_BOUNDARY'

Line 498: FROM fnd_profile_options opt,

494: val.level_id,
495: val.level_value,
496: val.level_value_application_id,
497: val.profile_option_id
498: FROM fnd_profile_options opt,
499: fnd_profile_option_values val
500: WHERE opt.profile_option_name = p_profile_option_name
501: AND NVL(opt.start_date_active, SYSDATE) <= SYSDATE
502: AND NVL(opt.end_date_active, SYSDATE) >= SYSDATE

Line 531: FROM fnd_profile_options opt,

527: SELECT val.profile_option_value,
528: val.level_id,
529: val.level_value,
530: val.level_value_application_id
531: FROM fnd_profile_options opt,
532: fnd_profile_option_values val
533: WHERE opt.profile_option_name = p_profile_option_name
534: AND NVL(opt.start_date_active, SYSDATE) <= SYSDATE
535: AND NVL(opt.end_date_active, SYSDATE) >= SYSDATE

Line 859: FROM fnd_profile_options opt,

855: )
856: IS
857: SELECT val.application_id, val.profile_option_id, val.level_id, val.level_value,
858: val.level_value_application_id, val.profile_option_value, opt.profile_option_name
859: FROM fnd_profile_options opt,
860: fnd_profile_option_values val
861: WHERE (opt.profile_option_name = 'CSF_M_RECIPIENTS_BOUNDARY'
862: -- OR opt.profile_option_name = 'CSF_M_AGENDA_ALLOWCHANGESCOMPLETEDTASK'
863: OR opt.profile_option_name = 'CSF_DEBRIEF_OVERLAPPING_LABOR'

Line 1071: l_profile_option_name fnd_profile_options.profile_option_name%TYPE;

1067: l_sqlerrmsg VARCHAR2(4000);
1068: l_error_msg VARCHAR2(4000);
1069: l_return_status VARCHAR2(2000);
1070:
1071: l_profile_option_name fnd_profile_options.profile_option_name%TYPE;
1072:
1073: BEGIN
1074: l_profile_option_name := p_profile_option_name;
1075: