APPS.OTA_LO_UTILITY dependencies on OTA_EVALUATIONS

Line 2753: p_object_id OTA_EVALUATIONS.OBJECT_ID%TYPE,

2749: function get_play_eval_button(
2750: p_event_id OTA_EVENTS.EVENT_ID%TYPE,
2751: p_user_id fnd_user.user_id%type,
2752: p_booking_status_type_id OTA_DELEGATE_BOOKINGS.BOOKING_STATUS_TYPE_ID%TYPE,
2753: p_object_id OTA_EVALUATIONS.OBJECT_ID%TYPE,
2754: p_object_type OTA_EVALUATIONS.OBJECT_TYPE%TYPE,
2755: p_mand_flag OTA_EVALUATIONS.EVAL_MANDATORY_FLAG%TYPE,
2756: p_test_id OTA_TESTS.TEST_ID%TYPE) return varchar2 is
2757:

Line 2754: p_object_type OTA_EVALUATIONS.OBJECT_TYPE%TYPE,

2750: p_event_id OTA_EVENTS.EVENT_ID%TYPE,
2751: p_user_id fnd_user.user_id%type,
2752: p_booking_status_type_id OTA_DELEGATE_BOOKINGS.BOOKING_STATUS_TYPE_ID%TYPE,
2753: p_object_id OTA_EVALUATIONS.OBJECT_ID%TYPE,
2754: p_object_type OTA_EVALUATIONS.OBJECT_TYPE%TYPE,
2755: p_mand_flag OTA_EVALUATIONS.EVAL_MANDATORY_FLAG%TYPE,
2756: p_test_id OTA_TESTS.TEST_ID%TYPE) return varchar2 is
2757:
2758: l_is_mandatory boolean:= true;

Line 2755: p_mand_flag OTA_EVALUATIONS.EVAL_MANDATORY_FLAG%TYPE,

2751: p_user_id fnd_user.user_id%type,
2752: p_booking_status_type_id OTA_DELEGATE_BOOKINGS.BOOKING_STATUS_TYPE_ID%TYPE,
2753: p_object_id OTA_EVALUATIONS.OBJECT_ID%TYPE,
2754: p_object_type OTA_EVALUATIONS.OBJECT_TYPE%TYPE,
2755: p_mand_flag OTA_EVALUATIONS.EVAL_MANDATORY_FLAG%TYPE,
2756: p_test_id OTA_TESTS.TEST_ID%TYPE) return varchar2 is
2757:
2758: l_is_mandatory boolean:= true;
2759: l_is_attempted boolean:= false;

Line 2760: l_act_mandatory OTA_EVALUATIONS.EVAL_MANDATORY_FLAG%TYPE;

2756: p_test_id OTA_TESTS.TEST_ID%TYPE) return varchar2 is
2757:
2758: l_is_mandatory boolean:= true;
2759: l_is_attempted boolean:= false;
2760: l_act_mandatory OTA_EVALUATIONS.EVAL_MANDATORY_FLAG%TYPE;
2761: l_booking_status_type OTA_BOOKING_STATUS_TYPES.TYPE%TYPE;
2762: l_attempt_id number;
2763: l_act_eval_id OTA_EVALUATIONS.evaluation_id%TYPE;
2764:

Line 2763: l_act_eval_id OTA_EVALUATIONS.evaluation_id%TYPE;

2759: l_is_attempted boolean:= false;
2760: l_act_mandatory OTA_EVALUATIONS.EVAL_MANDATORY_FLAG%TYPE;
2761: l_booking_status_type OTA_BOOKING_STATUS_TYPES.TYPE%TYPE;
2762: l_attempt_id number;
2763: l_act_eval_id OTA_EVALUATIONS.evaluation_id%TYPE;
2764:
2765: CURSOR c_attempts_info is
2766: Select attempt_id
2767: From ota_attempts

Line 2777: from ota_evaluations eval,ota_events evt

2773: and internal_state = 'F'; --bug#7311115
2774:
2775: CURSOR c_mandatory_info is
2776: select eval.eval_mandatory_flag,eval.evaluation_id
2777: from ota_evaluations eval,ota_events evt
2778: where evt.activity_version_id = eval.object_id(+)
2779: and evt.event_id = p_event_id
2780: and eval.evaluation_id is not null --bug 7184369
2781: and (eval.object_type = 'A' or eval.object_type is null);

Line 2861: l_mand_flag OTA_EVALUATIONS.EVAL_MANDATORY_FLAG%TYPE;

2857: p_event_id OTA_EVENTS.EVENT_ID%TYPE,
2858: p_sign_eval_status OTA_DELEGATE_BOOKINGS.SIGN_EVAL_STATUS%TYPE
2859: ) return varchar2 is
2860:
2861: l_mand_flag OTA_EVALUATIONS.EVAL_MANDATORY_FLAG%TYPE;
2862: l_symbol varchar2(100);
2863:
2864: Cursor csr_evt_evaluations is
2865: select decode(nvl(evt_eval.eval_mandatory_flag,'N'), 'Y', 'Y',

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

2863:
2864: Cursor csr_evt_evaluations is
2865: select decode(nvl(evt_eval.eval_mandatory_flag,'N'), 'Y', 'Y',
2866: decode(act_eval.evaluation_id,null,'N',decode(nvl(act_eval.eval_mandatory_flag,'N'),'Y','Y','N'))) flag
2867: from ota_evaluations evt_eval, ota_evaluations act_eval,ota_events evt
2868: where evt_eval.object_id(+) = evt.event_id
2869: and evt_eval.object_type(+) = 'E'
2870: and act_eval.object_id(+) = evt.activity_version_id
2871: and act_eval.object_type(+) = 'A'