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_EN_SU_ATTEMPT

Line 180: p_course_cd IN igs_en_su_attempt_all.course_cd%TYPE,

176:
177: PROCEDURE sub_get_insert(
178: p_method IN igs_as_anon_method.method%TYPE,
179: p_person_id IN hz_parties.party_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,

Line 181: p_unit_cd IN igs_en_su_attempt_all.unit_cd%TYPE,

177: PROCEDURE sub_get_insert(
178: p_method IN igs_as_anon_method.method%TYPE,
179: p_person_id IN hz_parties.party_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,

Line 402: FROM igs_en_su_attempt sua,

398: CURSOR c_count_section_reqd(cp_load_cal_type igs_as_anon_number.load_cal_type%TYPE,
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

Line 436: igs_en_su_attempt sua,

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

Line 497: igs_en_su_attempt sua,

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
501: AND ttl.load_ci_sequence_number = cp_load_ci_sequence_number

Line 527: igs_en_su_attempt sua,

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

Line 970: p_course_cd IN igs_en_su_attempt_all.course_cd%TYPE,

966:
967:
968: FUNCTION get_anon_id (
969: p_person_id IN hz_parties.party_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,

Line 971: p_unit_cd IN igs_en_su_attempt_all.unit_cd%TYPE,

967:
968: FUNCTION get_anon_id (
969: p_person_id IN hz_parties.party_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,

Line 992: igs_en_su_attempt sua,

988: CURSOR c_anip
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

Line 1022: igs_en_su_attempt sua,

1018: CURSOR c_aniu
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

Line 1056: igs_en_su_attempt sua,

1052: CURSOR c_ania
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

Line 1323: p_course_cd IN igs_en_su_attempt_all.course_cd%TYPE,

1319: FUNCTION user_anon_id (
1320: p_anonymous_number IN varchar2,
1321: p_method IN igs_as_anon_method.METHOD%TYPE,
1322: p_person_id IN hz_parties.party_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,

Line 1324: p_unit_cd IN igs_en_su_attempt_all.unit_cd%TYPE,

1320: p_anonymous_number IN varchar2,
1321: p_method IN igs_as_anon_method.METHOD%TYPE,
1322: p_person_id IN hz_parties.party_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,