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_OPTION_VALUES

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