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.OTA_LO_UTILITY dependencies on OTA_EVALUATIONS

Line 443: from ota_evaluations evt_eval, ota_evaluations act_eval,ota_events evt

439: select evt_eval.evaluation_id evt_eval_id
440: ,decode(nvl(evt_eval.eval_mandatory_flag,'N'), 'Y', 'Y',
441: decode(act_eval.evaluation_id,null,'N',decode(nvl(act_eval.eval_mandatory_flag,'N'),'Y','Y','N'))) flag --bug 7184369
442: ,act_eval.evaluation_id act_eval_id
443: from ota_evaluations evt_eval, ota_evaluations act_eval,ota_events evt
444: where
445: evt_eval.object_id(+) = evt.event_id and
446: (evt_eval.object_type is null or evt_eval.object_type = 'E') and
447: act_eval.object_id(+) = evt.activity_version_id and

Line 2343: p_object_id OTA_EVALUATIONS.OBJECT_ID%TYPE,

2339: function get_play_eval_button(
2340: p_event_id OTA_EVENTS.EVENT_ID%TYPE,
2341: p_user_id fnd_user.user_id%type,
2342: p_booking_status_type_id OTA_DELEGATE_BOOKINGS.BOOKING_STATUS_TYPE_ID%TYPE,
2343: p_object_id OTA_EVALUATIONS.OBJECT_ID%TYPE,
2344: p_object_type OTA_EVALUATIONS.OBJECT_TYPE%TYPE,
2345: p_mand_flag OTA_EVALUATIONS.EVAL_MANDATORY_FLAG%TYPE,
2346: p_test_id OTA_TESTS.TEST_ID%TYPE) return varchar2 is
2347:

Line 2344: p_object_type OTA_EVALUATIONS.OBJECT_TYPE%TYPE,

2340: p_event_id OTA_EVENTS.EVENT_ID%TYPE,
2341: p_user_id fnd_user.user_id%type,
2342: p_booking_status_type_id OTA_DELEGATE_BOOKINGS.BOOKING_STATUS_TYPE_ID%TYPE,
2343: p_object_id OTA_EVALUATIONS.OBJECT_ID%TYPE,
2344: p_object_type OTA_EVALUATIONS.OBJECT_TYPE%TYPE,
2345: p_mand_flag OTA_EVALUATIONS.EVAL_MANDATORY_FLAG%TYPE,
2346: p_test_id OTA_TESTS.TEST_ID%TYPE) return varchar2 is
2347:
2348: l_is_mandatory boolean:= true;

Line 2345: p_mand_flag OTA_EVALUATIONS.EVAL_MANDATORY_FLAG%TYPE,

2341: p_user_id fnd_user.user_id%type,
2342: p_booking_status_type_id OTA_DELEGATE_BOOKINGS.BOOKING_STATUS_TYPE_ID%TYPE,
2343: p_object_id OTA_EVALUATIONS.OBJECT_ID%TYPE,
2344: p_object_type OTA_EVALUATIONS.OBJECT_TYPE%TYPE,
2345: p_mand_flag OTA_EVALUATIONS.EVAL_MANDATORY_FLAG%TYPE,
2346: p_test_id OTA_TESTS.TEST_ID%TYPE) return varchar2 is
2347:
2348: l_is_mandatory boolean:= true;
2349: l_is_attempted boolean:= false;

Line 2350: l_act_mandatory OTA_EVALUATIONS.EVAL_MANDATORY_FLAG%TYPE;

2346: p_test_id OTA_TESTS.TEST_ID%TYPE) return varchar2 is
2347:
2348: l_is_mandatory boolean:= true;
2349: l_is_attempted boolean:= false;
2350: l_act_mandatory OTA_EVALUATIONS.EVAL_MANDATORY_FLAG%TYPE;
2351: l_booking_status_type OTA_BOOKING_STATUS_TYPES.TYPE%TYPE;
2352: l_attempt_id number;
2353: l_act_eval_id OTA_EVALUATIONS.evaluation_id%TYPE;
2354:

Line 2353: l_act_eval_id OTA_EVALUATIONS.evaluation_id%TYPE;

2349: l_is_attempted boolean:= false;
2350: l_act_mandatory OTA_EVALUATIONS.EVAL_MANDATORY_FLAG%TYPE;
2351: l_booking_status_type OTA_BOOKING_STATUS_TYPES.TYPE%TYPE;
2352: l_attempt_id number;
2353: l_act_eval_id OTA_EVALUATIONS.evaluation_id%TYPE;
2354:
2355: CURSOR c_attempts_info is
2356: Select attempt_id
2357: From ota_attempts

Line 2367: from ota_evaluations eval,ota_events evt

2363: and internal_state = 'F'; --bug#7311115
2364:
2365: CURSOR c_mandatory_info is
2366: select eval.eval_mandatory_flag,eval.evaluation_id
2367: from ota_evaluations eval,ota_events evt
2368: where evt.activity_version_id = eval.object_id(+)
2369: and evt.event_id = p_event_id
2370: and eval.evaluation_id is not null --bug 7184369
2371: and (eval.object_type = 'A' or eval.object_type is null);

Line 2449: p_mand_flag OTA_EVALUATIONS.EVAL_MANDATORY_FLAG%TYPE,

2445: function get_admin_eval_status(
2446: p_event_id OTA_EVENTS.EVENT_ID%TYPE,
2447: p_user_id fnd_user.user_id%type,
2448: p_booking_status_type_id OTA_DELEGATE_BOOKINGS.BOOKING_STATUS_TYPE_ID%TYPE,
2449: p_mand_flag OTA_EVALUATIONS.EVAL_MANDATORY_FLAG%TYPE,
2450: p_test_id OTA_TESTS.TEST_ID%TYPE) return varchar2 is
2451:
2452: l_is_mandatory boolean:= true;
2453: l_is_attempted boolean:= false;

Line 2454: l_act_mandatory OTA_EVALUATIONS.EVAL_MANDATORY_FLAG%TYPE;

2450: p_test_id OTA_TESTS.TEST_ID%TYPE) return varchar2 is
2451:
2452: l_is_mandatory boolean:= true;
2453: l_is_attempted boolean:= false;
2454: l_act_mandatory OTA_EVALUATIONS.EVAL_MANDATORY_FLAG%TYPE;
2455: l_booking_status_type OTA_BOOKING_STATUS_TYPES.TYPE%TYPE;
2456: l_attempt_id number;
2457: l_act_eval_id OTA_EVALUATIONS.evaluation_id%TYPE;
2458:

Line 2457: l_act_eval_id OTA_EVALUATIONS.evaluation_id%TYPE;

2453: l_is_attempted boolean:= false;
2454: l_act_mandatory OTA_EVALUATIONS.EVAL_MANDATORY_FLAG%TYPE;
2455: l_booking_status_type OTA_BOOKING_STATUS_TYPES.TYPE%TYPE;
2456: l_attempt_id number;
2457: l_act_eval_id OTA_EVALUATIONS.evaluation_id%TYPE;
2458:
2459: CURSOR c_attempts_info is
2460: Select attempt_id
2461: From ota_attempts

Line 2470: from ota_evaluations eval,ota_events evt

2466: and internal_state = 'F';
2467:
2468: CURSOR c_mandatory_info is
2469: select eval.eval_mandatory_flag,eval.evaluation_id
2470: from ota_evaluations eval,ota_events evt
2471: where evt.activity_version_id = eval.object_id(+)
2472: and evt.event_id = p_event_id
2473: and eval.evaluation_id is not null --bug 7184369
2474: and (eval.object_type = 'A' or eval.object_type is null);