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 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 189: fnd_profile_option_values val

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'
193: OR opt.profile_option_name = 'CSF_DEBRIEF_OVERLAPPING_LABOR'

Line 291: FROM fnd_profile_option_values val,

287: val.level_value_application_id,
288: val.profile_option_value,
289: acc.user_id,
290: acc.access_id
291: FROM fnd_profile_option_values val,
292: csm_profile_option_values_acc acc
293: WHERE val.profile_option_id = acc.profile_option_id
294: AND val.application_id = acc.application_id
295: AND acc.level_id = val.level_id

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 371: FROM fnd_profile_option_values val

367: OR opt.profile_option_name = 'JTF_TASK_DEFAULT_TASK_TYPE'
368: )
369: AND NOT EXISTS
370: (SELECT 1
371: FROM fnd_profile_option_values val
372: WHERE val.application_id = acc.application_id
373: AND val.profile_option_id = acc.profile_option_id
374: AND val.level_id = acc.level_id
375: AND val.level_value = acc.level_value

Line 379: FROM fnd_profile_option_values val,

375: AND val.level_value = acc.level_value
376: AND val.level_id <> 10003
377: UNION
378: SELECT 1
379: FROM fnd_profile_option_values val,
380: fnd_responsibility resp
381: WHERE val.application_id = acc.application_id
382: AND val.profile_option_id = acc.profile_option_id
383: AND val.level_id = acc.level_id

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 499: fnd_profile_option_values val

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
503: AND opt.application_id = val.application_id

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 532: fnd_profile_option_values val

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
536: AND opt.application_id = val.application_id

Line 569: l_old_profile_option_value fnd_profile_option_values.profile_option_value%TYPE;

565: FROM dual;
566:
567: l_csm_appl_id fnd_application.application_id%TYPE;
568: l_csm_resp_id fnd_responsibility.responsibility_id%TYPE;
569: l_old_profile_option_value fnd_profile_option_values.profile_option_value%TYPE;
570: l_old_level_id fnd_profile_option_values.level_id%TYPE;
571: l_profile_option_value fnd_profile_option_values.profile_option_value%TYPE;
572: l_level_id fnd_profile_option_values.level_id%TYPE;
573: l_level_value fnd_profile_option_values.level_value%TYPE;

Line 570: l_old_level_id fnd_profile_option_values.level_id%TYPE;

566:
567: l_csm_appl_id fnd_application.application_id%TYPE;
568: l_csm_resp_id fnd_responsibility.responsibility_id%TYPE;
569: l_old_profile_option_value fnd_profile_option_values.profile_option_value%TYPE;
570: l_old_level_id fnd_profile_option_values.level_id%TYPE;
571: l_profile_option_value fnd_profile_option_values.profile_option_value%TYPE;
572: l_level_id fnd_profile_option_values.level_id%TYPE;
573: l_level_value fnd_profile_option_values.level_value%TYPE;
574: l_level_value_application_id fnd_profile_option_values.level_value_application_id%TYPE;

Line 571: l_profile_option_value fnd_profile_option_values.profile_option_value%TYPE;

567: l_csm_appl_id fnd_application.application_id%TYPE;
568: l_csm_resp_id fnd_responsibility.responsibility_id%TYPE;
569: l_old_profile_option_value fnd_profile_option_values.profile_option_value%TYPE;
570: l_old_level_id fnd_profile_option_values.level_id%TYPE;
571: l_profile_option_value fnd_profile_option_values.profile_option_value%TYPE;
572: l_level_id fnd_profile_option_values.level_id%TYPE;
573: l_level_value fnd_profile_option_values.level_value%TYPE;
574: l_level_value_application_id fnd_profile_option_values.level_value_application_id%TYPE;
575:

Line 572: l_level_id fnd_profile_option_values.level_id%TYPE;

568: l_csm_resp_id fnd_responsibility.responsibility_id%TYPE;
569: l_old_profile_option_value fnd_profile_option_values.profile_option_value%TYPE;
570: l_old_level_id fnd_profile_option_values.level_id%TYPE;
571: l_profile_option_value fnd_profile_option_values.profile_option_value%TYPE;
572: l_level_id fnd_profile_option_values.level_id%TYPE;
573: l_level_value fnd_profile_option_values.level_value%TYPE;
574: l_level_value_application_id fnd_profile_option_values.level_value_application_id%TYPE;
575:
576: TYPE num_tab_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 573: l_level_value fnd_profile_option_values.level_value%TYPE;

569: l_old_profile_option_value fnd_profile_option_values.profile_option_value%TYPE;
570: l_old_level_id fnd_profile_option_values.level_id%TYPE;
571: l_profile_option_value fnd_profile_option_values.profile_option_value%TYPE;
572: l_level_id fnd_profile_option_values.level_id%TYPE;
573: l_level_value fnd_profile_option_values.level_value%TYPE;
574: l_level_value_application_id fnd_profile_option_values.level_value_application_id%TYPE;
575:
576: TYPE num_tab_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
577: l_acc_tab num_tab_type;

Line 574: l_level_value_application_id fnd_profile_option_values.level_value_application_id%TYPE;

570: l_old_level_id fnd_profile_option_values.level_id%TYPE;
571: l_profile_option_value fnd_profile_option_values.profile_option_value%TYPE;
572: l_level_id fnd_profile_option_values.level_id%TYPE;
573: l_level_value fnd_profile_option_values.level_value%TYPE;
574: l_level_value_application_id fnd_profile_option_values.level_value_application_id%TYPE;
575:
576: TYPE num_tab_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
577: l_acc_tab num_tab_type;
578: l_user_tab num_tab_type;

Line 677: fnd_profile.GET(NAME => r_profiles_del_rec.profile_option_name, VAL => r_profiles_rec.profile_option_value );

673: FETCH c_profiles_csr INTO r_profiles_rec;
674: IF c_profiles_csr%FOUND THEN
675: IF r_profiles_rec.profile_option_value IS NULL THEN
676: -- get profile at site level
677: fnd_profile.GET(NAME => r_profiles_del_rec.profile_option_name, VAL => r_profiles_rec.profile_option_value );
678: r_profiles_rec.level_id := 10001;
679: r_profiles_rec.level_value := 0;
680: END IF;
681:

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 860: fnd_profile_option_values val

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'
864: OR opt.profile_option_name = 'CSF_MOBILE_TASK_TIMES_UPDATABLE'

Line 964: l_old_profile_option_value fnd_profile_option_values.profile_option_value%TYPE;

960: AND user_id = p_user_id
961: ORDER BY level_id desc
962: FOR UPDATE OF profile_option_value, level_id, level_value, last_update_date NOWAIT;
963:
964: l_old_profile_option_value fnd_profile_option_values.profile_option_value%TYPE;
965: l_old_level_id fnd_profile_option_values.level_id%TYPE;
966:
967: CURSOR c_csm_appl IS
968: SELECT APPLICATION_ID

Line 965: l_old_level_id fnd_profile_option_values.level_id%TYPE;

961: ORDER BY level_id desc
962: FOR UPDATE OF profile_option_value, level_id, level_value, last_update_date NOWAIT;
963:
964: l_old_profile_option_value fnd_profile_option_values.profile_option_value%TYPE;
965: l_old_level_id fnd_profile_option_values.level_id%TYPE;
966:
967: CURSOR c_csm_appl IS
968: SELECT APPLICATION_ID
969: FROM fnd_application

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: