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_PS_UNIT_OFR_OPT

Line 16: p_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,

12: || c_uoo_ug to select active (not closed) unit classes.
13: */
14:
15: FUNCTION chk_anon_graded (
16: p_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
17: p_ass_id IN igs_as_assessmnt_itm_all.ass_id%TYPE
18: ) RETURN VARCHAR2 IS
19: /*
20: || Created By : pkpatel

Line 33: FROM igs_ps_unit_ofr_opt uoo,

29:
30: CURSOR c_uoo_ug
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'

Line 82: FROM igs_ps_unit_ofr_opt uoo,

78:
79: CURSOR c_uoo_ai
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'

Line 184: p_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,

180: p_course_cd IN igs_en_su_attempt_all.course_cd%TYPE,
181: p_unit_cd IN igs_en_su_attempt_all.unit_cd%TYPE,
182: p_teach_cal_type IN igs_ca_inst_all.cal_type%TYPE,
183: p_teach_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
184: p_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
185: p_assessment_type IN igs_as_assessmnt_typ.assessment_type%TYPE,
186: p_load_cal_type IN igs_ca_inst_all.cal_type%TYPE,
187: p_load_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE )
188: IS

Line 403: igs_ps_unit_ofr_opt uoo,

399: cp_load_ci_sequence_number igs_as_anon_number.load_ci_sequence_number%TYPE)
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

Line 437: igs_ps_unit_ofr_opt uoo,

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'
440: AND ttl.load_cal_type = cp_load_cal_type
441: AND ttl.load_ci_sequence_number = cp_load_ci_sequence_number

Line 498: igs_ps_unit_ofr_opt uoo

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
501: AND ttl.load_ci_sequence_number = cp_load_ci_sequence_number
502: AND ttl.load_start_dt = (SELECT MIN(ttl2.load_start_dt)

Line 528: igs_ps_unit_ofr_opt uoo,

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'
531: AND ttl.load_cal_type = cp_load_cal_type
532: AND ttl.load_ci_sequence_number = cp_load_ci_sequence_number

Line 974: p_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,

970: p_course_cd IN igs_en_su_attempt_all.course_cd%TYPE,
971: p_unit_cd IN igs_en_su_attempt_all.unit_cd%TYPE,
972: p_teach_cal_type IN igs_ca_inst_all.cal_type%TYPE,
973: p_teach_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
974: p_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
975: p_ass_id IN igs_as_assessmnt_itm_all.ass_id%TYPE,
976: p_unit_grading_ind IN VARCHAR2
977: ) RETURN VARCHAR2 IS
978: /*

Line 993: igs_ps_unit_ofr_opt uoo

989: IS
990: SELECT anonymous_id
991: FROM igs_as_anon_id_ps anip,
992: igs_en_su_attempt sua,
993: igs_ps_unit_ofr_opt uoo
994: WHERE sua.person_id = p_person_id
995: AND sua.course_cd = p_course_cd
996: AND sua.unit_cd = p_unit_cd
997: AND sua.cal_type = p_teach_cal_type

Line 1023: igs_ps_unit_ofr_opt uoo

1019: IS
1020: SELECT anonymous_id
1021: FROM igs_as_anon_id_us aniu,
1022: igs_en_su_attempt sua,
1023: igs_ps_unit_ofr_opt uoo
1024: WHERE sua.person_id = p_person_id
1025: AND sua.course_cd = p_course_cd
1026: AND sua.unit_cd = p_unit_cd
1027: AND sua.cal_type = p_teach_cal_type

Line 1057: igs_ps_unit_ofr_opt uoo,

1053: IS
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

Line 1327: p_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,

1323: p_course_cd IN igs_en_su_attempt_all.course_cd%TYPE,
1324: p_unit_cd IN igs_en_su_attempt_all.unit_cd%TYPE,
1325: p_teach_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1326: p_teach_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
1327: p_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
1328: p_assessment_type IN igs_as_assessmnt_typ.assessment_type%TYPE,
1329: p_load_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1330: p_load_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
1331: ) RETURN VARCHAR2 IS