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_TESTS

Line 730: l_test_id OTA_TESTS.TEST_ID%type:=null;

726: rel.object_table_name = 'HZ_PARTIES' and
727: act.activity_version_id = offr.activity_version_id;
728:
729: l_event_id OTA_EVENTS.EVENT_ID%TYPE:= null;
730: l_test_id OTA_TESTS.TEST_ID%type:=null;
731: Cursor csr_attempt_info is
732: select attempt_id from ota_attempts where
733: event_id = l_event_id
734: and test_id = l_test_id

Line 781: l_act_eval_id OTA_TESTS.TEST_ID%TYPE:=null;

777:
778:
779:
780: l_proc varchar2(72) := g_package||'update_enroll_status_for_lo';
781: l_act_eval_id OTA_TESTS.TEST_ID%TYPE:=null;
782: l_evt_eval_id OTA_TESTS.TEST_ID%TYPE:=null;
783: l_eval_mand_flag varchar2(1);
784: l_dummy ota_attempts.attempt_id%type;
785: l_is_attempted boolean :=false;

Line 782: l_evt_eval_id OTA_TESTS.TEST_ID%TYPE:=null;

778:
779:
780: l_proc varchar2(72) := g_package||'update_enroll_status_for_lo';
781: l_act_eval_id OTA_TESTS.TEST_ID%TYPE:=null;
782: l_evt_eval_id OTA_TESTS.TEST_ID%TYPE:=null;
783: l_eval_mand_flag varchar2(1);
784: l_dummy ota_attempts.attempt_id%type;
785: l_is_attempted boolean :=false;
786: l_status varchar2(80) :='ATTENDED';

Line 1376: v_max_attempts ota_tests.max_attempts%type;

1372: p_user_id fnd_user.user_id%type,
1373: p_user_type ota_attempts.user_type%type,
1374: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return boolean is
1375:
1376: v_max_attempts ota_tests.max_attempts%type;
1377: v_user_attempts number;
1378: begin
1379: begin
1380: select t.max_attempts

Line 1382: from ota_tests t, ota_learning_objects lo

1378: begin
1379: begin
1380: select t.max_attempts
1381: into v_max_attempts
1382: from ota_tests t, ota_learning_objects lo
1383: where lo.learning_object_id = p_lo_id and
1384: lo.test_id = t.test_id;
1385: exception
1386: when NO_DATA_FOUND then -- the LO is not a test, so no attempt limit exists

Line 1398: from ota_attempts a, ota_tests t

1394: -- Count the user's attempts
1395: begin
1396: select count(*)
1397: into v_user_attempts
1398: from ota_attempts a, ota_tests t
1399: where a.user_id = p_user_id and
1400: a.user_type = p_user_type and
1401: a.learning_object_id = p_lo_id and
1402: nvl(a.cert_prd_enrollment_id, -1) = nvl(p_cert_prd_enrollment_id, -1) and

Line 1432: from ota_tests t,

1428: v_earliest_attempt_date date;
1429: begin
1430: select nvl(max(a.timestamp), sysdate) + nvl(t.duration_between_attempt, 0)
1431: into v_earliest_attempt_date
1432: from ota_tests t,
1433: ota_attempts a
1434: where t.test_id = a.test_id
1435: and a.initialized_flag = 'Y'
1436: and a.internal_state <> 'A' --14598945

Line 2170: from ota_tests ot,

2166:
2167: --7622768
2168: cursor lo_type is
2169: select nvl(test_type_flag,'LO')
2170: from ota_tests ot,
2171: ota_learning_objects lo
2172: where ot.test_id(+) = lo.test_id
2173: and lo.learning_object_id = p_lo_id;
2174:

Line 2258: l_tst_grade_flag ota_tests.grade_flag%TYPE;

2254: l_formatted_sec varchar(20) := '';
2255: l_formatted_time varchar(20) := '';
2256: l_return_tree_title varchar(500) := '';
2257: l_max_performance_id ota_performances.performance_id%type;
2258: l_tst_grade_flag ota_tests.grade_flag%TYPE;
2259: l_var_score VARCHAR2(100);
2260: l_lo_completed_date VARCHAR2(100);
2261: l_lo_completed_time VARCHAR2(10);
2262: l_lo_completed_date_tz VARCHAR2(100);

Line 2290: OTA_TESTS tst

2286: , opf.lesson_status
2287: , ota_timezone_util.get_date_time(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), 'Y', ota_timezone_util.get_server_timezone_code, 'HH24:MI:SS') Comp_Date_Tz
2288: ,ota_timezone_util.get_dateDT(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), 'Y', ota_timezone_util.get_server_timezone_code) Comp_Date
2289: From OTA_LEARNING_OBJECTS olo, OTA_PERFORMANCES opf,
2290: OTA_TESTS tst
2291: Where
2292: olo.learning_object_id = opf.learning_object_id(+)
2293: AND tst.test_id(+) = olo.test_id
2294: And olo.Learning_object_id = p_lo_id

Line 2325: OTA_TESTS tst

2321: , opf.lesson_status
2322: , ota_timezone_util.get_date_time(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), 'Y', ota_timezone_util.get_server_timezone_code, 'HH24:MI:SS') Comp_Date_Tz
2323: ,ota_timezone_util.get_dateDT(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), 'Y', ota_timezone_util.get_server_timezone_code) Comp_Date
2324: From OTA_LEARNING_OBJECTS olo, OTA_PERFORMANCES opf,
2325: OTA_TESTS tst
2326: Where
2327: olo.learning_object_id = opf.learning_object_id(+)
2328: AND tst.test_id(+) = olo.test_id
2329: And olo.Learning_object_id = p_lo_id

Line 2756: p_test_id OTA_TESTS.TEST_ID%TYPE) return varchar2 is

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;
2760: l_act_mandatory OTA_EVALUATIONS.EVAL_MANDATORY_FLAG%TYPE;

Line 4195: l_tst_grade_flag ota_tests.grade_flag%TYPE;

4191: l_formatted_sec varchar(20) := '';
4192: l_formatted_time varchar(20) := '';
4193: l_return_tree_title varchar(500) := '';
4194: l_max_performance_id ota_performances.performance_id%type;
4195: l_tst_grade_flag ota_tests.grade_flag%TYPE;
4196: l_var_score VARCHAR2(100);
4197: l_lo_completed_date VARCHAR2(100);
4198: l_lo_completed_time VARCHAR2(10);
4199: l_lo_completed_date_tz VARCHAR2(100);

Line 4227: OTA_TESTS tst

4223: , opf.lesson_status
4224: , ota_timezone_util.get_date_time(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), 'Y', ota_timezone_util.get_server_timezone_code, 'HH24:MI:SS') Comp_Date_Tz
4225: , ota_timezone_util.get_dateDT(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), 'Y', ota_timezone_util.get_server_timezone_code) Comp_Date
4226: From OTA_LEARNING_OBJECTS olo, OTA_PERFORMANCES opf,
4227: OTA_TESTS tst
4228: Where
4229: olo.learning_object_id = opf.learning_object_id(+)
4230: AND tst.test_id(+) = olo.test_id
4231: And olo.Learning_object_id = p_lo_id

Line 4261: OTA_TESTS tst

4257: , opf.lesson_status
4258: , ota_timezone_util.get_date_time(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), 'Y', ota_timezone_util.get_server_timezone_code, 'HH24:MI:SS') Comp_Date_Tz
4259: , ota_timezone_util.get_dateDT(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), 'Y', ota_timezone_util.get_server_timezone_code) Comp_Date
4260: From OTA_LEARNING_OBJECTS olo, OTA_PERFORMANCES opf,
4261: OTA_TESTS tst
4262: Where
4263: olo.learning_object_id = opf.learning_object_id(+)
4264: AND tst.test_id(+) = olo.test_id
4265: And olo.Learning_object_id = p_lo_id