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.IGS_AS_ANON_GRD_PKG dependencies on IGS_CA_TEACH_TO_LOAD_V

Line 35: igs_ca_teach_to_load_v ttl

31: IS
32: SELECT 'X'
33: FROM igs_ps_unit_ofr_opt uoo,
34: igs_as_anon_method anm,
35: igs_ca_teach_to_load_v ttl
36: WHERE uoo.uoo_id = p_uoo_id
37: AND uoo.anon_unit_grading_ind = 'Y'
38: AND uoo.cal_type = ttl.teach_cal_type
39: AND uoo.ci_sequence_number = ttl.teach_ci_sequence_number

Line 41: FROM igs_ca_teach_to_load_v ttl2

37: AND uoo.anon_unit_grading_ind = 'Y'
38: AND uoo.cal_type = ttl.teach_cal_type
39: AND uoo.ci_sequence_number = ttl.teach_ci_sequence_number
40: AND ttl.load_start_dt = (SELECT MIN(ttl2.load_start_dt)
41: FROM igs_ca_teach_to_load_v ttl2
42: WHERE uoo.cal_type = ttl2.teach_cal_type
43: AND uoo.ci_sequence_number = ttl2.teach_ci_sequence_number)
44: AND anm.load_cal_type = ttl.load_cal_type
45: AND (anm.method <> 'ASSESSMENT'

Line 84: igs_ca_teach_to_load_v ttl

80: IS
81: SELECT 'X'
82: FROM igs_ps_unit_ofr_opt uoo,
83: igs_as_anon_method anm,
84: igs_ca_teach_to_load_v ttl
85: WHERE uoo.uoo_id = p_uoo_id
86: AND uoo.anon_assess_grading_ind = 'Y'
87: AND uoo.cal_type = ttl.teach_cal_type
88: AND uoo.ci_sequence_number = ttl.teach_ci_sequence_number

Line 90: FROM igs_ca_teach_to_load_v ttl2

86: AND uoo.anon_assess_grading_ind = 'Y'
87: AND uoo.cal_type = ttl.teach_cal_type
88: AND uoo.ci_sequence_number = ttl.teach_ci_sequence_number
89: AND ttl.load_start_dt = (SELECT MIN(ttl2.load_start_dt)
90: FROM igs_ca_teach_to_load_v ttl2
91: WHERE uoo.cal_type = ttl2.teach_cal_type
92: AND uoo.ci_sequence_number = ttl2.teach_ci_sequence_number)
93: AND anm.load_cal_type = ttl.load_cal_type
94: AND (EXISTS ( SELECT 'X'

Line 404: igs_ca_teach_to_load_v ttl

400: IS
401: SELECT COUNT(*)
402: FROM igs_en_su_attempt sua,
403: igs_ps_unit_ofr_opt uoo,
404: igs_ca_teach_to_load_v ttl
405: WHERE sua.unit_attempt_status = 'ENROLLED'
406: AND ttl.load_cal_type = cp_load_cal_type
407: AND ttl.load_ci_sequence_number = cp_load_ci_sequence_number
408: AND uoo.cal_type = ttl.teach_cal_type

Line 411: FROM igs_ca_teach_to_load_v ttl2

407: AND ttl.load_ci_sequence_number = cp_load_ci_sequence_number
408: AND uoo.cal_type = ttl.teach_cal_type
409: AND uoo.ci_sequence_number = ttl.teach_ci_sequence_number
410: AND ttl.load_start_dt = (SELECT MIN(ttl2.load_start_dt)
411: FROM igs_ca_teach_to_load_v ttl2
412: WHERE uoo.cal_type = ttl2.teach_cal_type
413: AND uoo.ci_sequence_number = ttl2.teach_ci_sequence_number)
414: AND (uoo.anon_assess_grading_ind = 'Y'
415: OR uoo.anon_unit_grading_ind = 'Y')

Line 435: FROM igs_ca_teach_to_load_v ttl,

431: IS
432: SELECT COUNT(*)
433: FROM(
434: SELECT DISTINCT sua.person_id, ast.assessment_type
435: FROM igs_ca_teach_to_load_v ttl,
436: igs_en_su_attempt sua,
437: igs_ps_unit_ofr_opt uoo,
438: igs_as_assessmnt_typ ast
439: WHERE sua.unit_attempt_status = 'ENROLLED'

Line 443: FROM igs_ca_teach_to_load_v ttl2

439: WHERE sua.unit_attempt_status = 'ENROLLED'
440: AND ttl.load_cal_type = cp_load_cal_type
441: AND ttl.load_ci_sequence_number = cp_load_ci_sequence_number
442: AND ttl.load_start_dt = (SELECT MIN(ttl2.load_start_dt)
443: FROM igs_ca_teach_to_load_v ttl2
444: WHERE uoo.cal_type = ttl2.teach_cal_type
445: AND uoo.ci_sequence_number = ttl2.teach_ci_sequence_number)
446: AND ttl.teach_cal_type = uoo.cal_type
447: AND ttl.teach_ci_sequence_number = uoo.ci_sequence_number

Line 496: FROM igs_ca_teach_to_load_v ttl,

492: sua.unit_cd,
493: sua.cal_type,
494: sua.ci_sequence_number,
495: sua.uoo_id
496: FROM igs_ca_teach_to_load_v ttl,
497: igs_en_su_attempt sua,
498: igs_ps_unit_ofr_opt uoo
499: WHERE sua.unit_attempt_status = 'ENROLLED'
500: AND ttl.load_cal_type = cp_load_cal_type

Line 503: FROM igs_ca_teach_to_load_v ttl2

499: WHERE sua.unit_attempt_status = 'ENROLLED'
500: AND ttl.load_cal_type = cp_load_cal_type
501: AND ttl.load_ci_sequence_number = cp_load_ci_sequence_number
502: AND ttl.load_start_dt = (SELECT MIN(ttl2.load_start_dt)
503: FROM igs_ca_teach_to_load_v ttl2
504: WHERE uoo.cal_type = ttl2.teach_cal_type
505: AND uoo.ci_sequence_number = ttl2.teach_ci_sequence_number)
506: AND ttl.teach_cal_type = uoo.cal_type
507: AND ttl.teach_ci_sequence_number = uoo.ci_sequence_number

Line 526: FROM igs_ca_teach_to_load_v ttl,

522: cp_load_ci_sequence_number igs_as_anon_number.load_ci_sequence_number%TYPE)
523: IS
524: SELECT DISTINCT sua.person_id,
525: ast.assessment_type
526: FROM igs_ca_teach_to_load_v ttl,
527: igs_en_su_attempt sua,
528: igs_ps_unit_ofr_opt uoo,
529: igs_as_assessmnt_typ ast
530: WHERE sua.unit_attempt_status = 'ENROLLED'

Line 534: FROM igs_ca_teach_to_load_v ttl2

530: WHERE sua.unit_attempt_status = 'ENROLLED'
531: AND ttl.load_cal_type = cp_load_cal_type
532: AND ttl.load_ci_sequence_number = cp_load_ci_sequence_number
533: AND ttl.load_start_dt = (SELECT MIN(ttl2.load_start_dt)
534: FROM igs_ca_teach_to_load_v ttl2
535: WHERE uoo.cal_type = ttl2.teach_cal_type
536: AND uoo.ci_sequence_number = ttl2.teach_ci_sequence_number)
537: AND ttl.teach_cal_type = uoo.cal_type
538: AND ttl.teach_ci_sequence_number = uoo.ci_sequence_number

Line 1058: igs_ca_teach_to_load_v ttl

1054: SELECT anonymous_id
1055: FROM igs_as_anon_id_ass ania,
1056: igs_en_su_attempt sua,
1057: igs_ps_unit_ofr_opt uoo,
1058: igs_ca_teach_to_load_v ttl
1059: WHERE sua.person_id = p_person_id
1060: AND sua.course_cd = p_course_cd
1061: AND sua.unit_cd = p_unit_cd
1062: AND sua.cal_type = p_teach_cal_type

Line 1076: FROM igs_ca_teach_to_load_v ttl2

1072: AND ania.load_ci_sequence_number = ttl.load_ci_sequence_number
1073: AND ttl.teach_cal_type = p_teach_cal_type
1074: AND ttl.teach_ci_sequence_number = p_teach_ci_sequence_number
1075: AND ttl.load_start_dt = (SELECT MIN(ttl2.load_start_dt)
1076: FROM igs_ca_teach_to_load_v ttl2
1077: WHERE ttl2.teach_cal_type = p_teach_cal_type
1078: AND ttl2.teach_ci_sequence_number = p_teach_ci_sequence_number)
1079: AND ( ( p_unit_grading_ind = 'Y'
1080: AND uoo.anon_unit_grading_ind = 'Y'

Line 1098: FROM igs_ca_teach_to_load_v ttl,

1094:
1095: CURSOR c_method
1096: IS
1097: SELECT anm.method
1098: FROM igs_ca_teach_to_load_v ttl,
1099: igs_as_anon_method anm
1100: WHERE ttl.teach_cal_type = p_teach_cal_type
1101: AND ttl.teach_ci_sequence_number = p_teach_ci_sequence_number
1102: AND ttl.load_start_dt = (SELECT MIN(ttl2.load_start_dt)

Line 1103: FROM igs_ca_teach_to_load_v ttl2

1099: igs_as_anon_method anm
1100: WHERE ttl.teach_cal_type = p_teach_cal_type
1101: AND ttl.teach_ci_sequence_number = p_teach_ci_sequence_number
1102: AND ttl.load_start_dt = (SELECT MIN(ttl2.load_start_dt)
1103: FROM igs_ca_teach_to_load_v ttl2
1104: WHERE ttl2.teach_cal_type = p_teach_cal_type
1105: AND ttl2.teach_ci_sequence_number = p_teach_ci_sequence_number)
1106: AND ttl.load_cal_type = anm.load_cal_type;
1107:

Line 1211: igs_ca_teach_to_load_v ttl

1207: CURSOR c_aniu
1208: IS
1209: SELECT person_id
1210: FROM igs_as_anon_id_us aniu,
1211: igs_ca_teach_to_load_v ttl
1212: WHERE aniu. anonymous_id = p_anonymous_id
1213: AND aniu.load_cal_type = ttl.load_cal_type
1214: AND aniu.load_ci_sequence_number = ttl.load_ci_sequence_number
1215: AND ttl.teach_cal_type = p_teach_cal_type

Line 1218: FROM igs_ca_teach_to_load_v ttl2

1214: AND aniu.load_ci_sequence_number = ttl.load_ci_sequence_number
1215: AND ttl.teach_cal_type = p_teach_cal_type
1216: AND ttl.teach_ci_sequence_number = p_teach_ci_sequence_number
1217: AND ttl.load_start_dt = ( SELECT MIN(ttl2.load_start_dt)
1218: FROM igs_ca_teach_to_load_v ttl2
1219: WHERE ttl2.teach_cal_type = p_teach_cal_type
1220: AND ttl2.teach_ci_sequence_number = p_teach_ci_sequence_number);
1221: CURSOR c_ania
1222: IS

Line 1225: igs_ca_teach_to_load_v ttl

1221: CURSOR c_ania
1222: IS
1223: SELECT person_id
1224: FROM igs_as_anon_id_ass ania,
1225: igs_ca_teach_to_load_v ttl
1226: WHERE ania. anonymous_id = p_anonymous_id
1227: AND ania.load_cal_type = ttl.load_cal_type
1228: AND ania.load_ci_sequence_number = ttl.load_ci_sequence_number
1229: AND ttl.teach_cal_type = p_teach_cal_type

Line 1232: FROM igs_ca_teach_to_load_v ttl2

1228: AND ania.load_ci_sequence_number = ttl.load_ci_sequence_number
1229: AND ttl.teach_cal_type = p_teach_cal_type
1230: AND ttl.teach_ci_sequence_number = p_teach_ci_sequence_number
1231: AND ttl.load_start_dt = ( SELECT MIN(ttl2.load_start_dt)
1232: FROM igs_ca_teach_to_load_v ttl2
1233: WHERE ttl2.teach_cal_type = p_teach_cal_type
1234: AND ttl2.teach_ci_sequence_number = p_teach_ci_sequence_number);
1235:
1236:

Line 1241: FROM igs_ca_teach_to_load_v ttl,

1237: -- Get the Anonymous Grading Method for this Load Calendar
1238: CURSOR c_method
1239: IS
1240: SELECT anm.method
1241: FROM igs_ca_teach_to_load_v ttl,
1242: igs_as_anon_method anm
1243: WHERE ttl.teach_cal_type = p_teach_cal_type
1244: AND ttl.teach_ci_sequence_number = p_teach_ci_sequence_number
1245: AND ttl.load_start_dt = (SELECT MIN(ttl2.load_start_dt)

Line 1246: FROM igs_ca_teach_to_load_v ttl2

1242: igs_as_anon_method anm
1243: WHERE ttl.teach_cal_type = p_teach_cal_type
1244: AND ttl.teach_ci_sequence_number = p_teach_ci_sequence_number
1245: AND ttl.load_start_dt = (SELECT MIN(ttl2.load_start_dt)
1246: FROM igs_ca_teach_to_load_v ttl2
1247: WHERE ttl2.teach_cal_type = p_teach_cal_type
1248: AND ttl2.teach_ci_sequence_number = p_teach_ci_sequence_number)
1249: AND ttl.load_cal_type = anm.load_cal_type;
1250: