APPS.IGS_AS_GEN_005 dependencies on IGS_CA_INST

Line 92: v_acad_cal_type igs_ca_inst.cal_type%TYPE;

88: v_suao_rec_exists VARCHAR2 (1);
89: v_to_grade igs_as_grd_sch_trn.to_grade%TYPE;
90: v_suao_exists BOOLEAN DEFAULT FALSE;
91: v_alt_cd VARCHAR2 (10);
92: v_acad_cal_type igs_ca_inst.cal_type%TYPE;
93: v_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
94: v_acad_ci_start_dt DATE;
95: v_acad_ci_end_dt DATE;
96: v_message_name VARCHAR2 (30);

Line 93: v_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

89: v_to_grade igs_as_grd_sch_trn.to_grade%TYPE;
90: v_suao_exists BOOLEAN DEFAULT FALSE;
91: v_alt_cd VARCHAR2 (10);
92: v_acad_cal_type igs_ca_inst.cal_type%TYPE;
93: v_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
94: v_acad_ci_start_dt DATE;
95: v_acad_ci_end_dt DATE;
96: v_message_name VARCHAR2 (30);
97: CURSOR c_suao IS

Line 491: igs_ca_inst ci,

487: PRAGMA EXCEPTION_INIT (e_resource_busy, -54);
488: CURSOR c_uai (cp_ass_id igs_as_unitass_item.ass_id%TYPE) IS
489: SELECT uai.ass_id
490: FROM igs_ca_stat cs,
491: igs_ca_inst ci,
492: igs_ps_unit_stat ust,
493: igs_ps_unit_ver uv,
494: igs_as_unitass_item uai
495: WHERE cs.s_cal_status <> 'INACTIVE'

Line 582: igs_ca_inst ci

578: )
579: FROM igs_en_stdnt_ps_att sca,
580: igs_en_su_attempt suav,
581: igs_ps_ofr_pat cop,
582: igs_ca_inst ci
583: WHERE sca.person_id = p_person_id
584: AND sca.course_cd = p_course_cd
585: AND sca.person_id = suav.person_id
586: AND sca.course_cd = suav.course_cd

Line 667: igs_ca_inst ci

663: SELECT MAX (SUBSTR (igs_en_gen_014.enrs_get_acad_alt_cd (suav.cal_type, suav.ci_sequence_number), 1, 10)) acad_alternate_code
664: FROM igs_en_stdnt_ps_att sca,
665: igs_en_su_attempt suav,
666: igs_ps_ofr_pat cop,
667: igs_ca_inst ci
668: WHERE sca.person_id = p_person_id
669: AND sca.course_cd = p_course_cd
670: AND sca.person_id = suav.person_id
671: AND sca.course_cd = suav.course_cd