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_EN_GEN_016 dependencies on IGS_CA_INST

Line 68: FROM igs_ca_inst ca

64: -- cursor to get Academic Calendar Details
65: --
66: CURSOR get_acad_cal_dtls ( p_alternate_code IN VARCHAR2) IS
67: SELECT ca.cal_type , ca.sequence_number , ca.start_dt , ca.end_dt
68: FROM igs_ca_inst ca
69: WHERE ca.alternate_code = p_alternate_code;
70:
71: -- Cursor to check if multiple matches are found for a given Altenate Code .
72: --

Line 75: FROM igs_ca_inst ca

71: -- Cursor to check if multiple matches are found for a given Altenate Code .
72: --
73: CURSOR get_acad_cnt( p_alternate_code IN VARCHAR2) IS
74: SELECT COUNT(*)
75: FROM igs_ca_inst ca
76: WHERE ca.alternate_code = p_alternate_code;
77:
78: --cursor to get all INACTIVE program attempts
79: --

Line 94: FROM igs_ca_inst ci , igs_ca_type ct , igs_ca_stat cs , igs_ca_inst_rel cir

90: --
91: CURSOR get_load_cal_inst (p_acad_cal_type IN VARCHAR2 , p_acad_ci_sequence_number IN NUMBER ,
92: p_start_dt IN DATE , p_end_dt IN DATE )IS
93: SELECT ci.cal_type , ci.start_dt , ci.end_dt , ci.sequence_number
94: FROM igs_ca_inst ci , igs_ca_type ct , igs_ca_stat cs , igs_ca_inst_rel cir
95: WHERE ct.cal_type = ci.cal_type
96: AND ct.s_cal_cat = 'LOAD'
97: AND cir.sup_cal_type = p_acad_cal_type
98: AND cir.sup_ci_sequence_number = p_acad_ci_sequence_number

Line 125: FROM igs_as_sc_atmpt_enr asa , igs_ca_inst ci

121: --cursor to get SUA Administrative details
122: --
123: CURSOR get_as_sc_atmpt_enr (p_start_dt IN DATE , p_end_dt IN DATE , p_person_id IN NUMBER , p_course_cd IN VARCHAR2)IS
124: SELECT asa.ROWID , asa.*
125: FROM igs_as_sc_atmpt_enr asa , igs_ca_inst ci
126: WHERE ci.start_dt >= p_start_dt AND ci.end_dt <= p_end_dt
127: AND asa.cal_type = ci.cal_type
128: AND asa.ci_sequence_number = ci.sequence_number
129: AND asa.course_cd = p_course_cd

Line 160: l_acad_ci_Sequence_number igs_ca_inst.sequence_number%TYPE;

156:
157: l_prgm_inactive_chk VARCHAR2(1) := 'N';
158:
159: l_acad_cal_type igs_ca_type.cal_type%TYPE;
160: l_acad_ci_Sequence_number igs_ca_inst.sequence_number%TYPE;
161: l_acad_cal_Start_dt igs_ca_inst.start_dt%TYPE;
162: l_acad_cal_end_dt igs_ca_inst.end_dt%TYPE;
163: l_load_cal_type igs_ca_type.cal_type%TYPE;
164: l_load_ci_Sequence_number igs_ca_inst.sequence_number%TYPE;

Line 161: l_acad_cal_Start_dt igs_ca_inst.start_dt%TYPE;

157: l_prgm_inactive_chk VARCHAR2(1) := 'N';
158:
159: l_acad_cal_type igs_ca_type.cal_type%TYPE;
160: l_acad_ci_Sequence_number igs_ca_inst.sequence_number%TYPE;
161: l_acad_cal_Start_dt igs_ca_inst.start_dt%TYPE;
162: l_acad_cal_end_dt igs_ca_inst.end_dt%TYPE;
163: l_load_cal_type igs_ca_type.cal_type%TYPE;
164: l_load_ci_Sequence_number igs_ca_inst.sequence_number%TYPE;
165: l_teach_cal_type igs_ca_type.cal_type%TYPE;

Line 162: l_acad_cal_end_dt igs_ca_inst.end_dt%TYPE;

158:
159: l_acad_cal_type igs_ca_type.cal_type%TYPE;
160: l_acad_ci_Sequence_number igs_ca_inst.sequence_number%TYPE;
161: l_acad_cal_Start_dt igs_ca_inst.start_dt%TYPE;
162: l_acad_cal_end_dt igs_ca_inst.end_dt%TYPE;
163: l_load_cal_type igs_ca_type.cal_type%TYPE;
164: l_load_ci_Sequence_number igs_ca_inst.sequence_number%TYPE;
165: l_teach_cal_type igs_ca_type.cal_type%TYPE;
166: l_teach_ci_Sequence_number igs_ca_inst.sequence_number%TYPE;

Line 164: l_load_ci_Sequence_number igs_ca_inst.sequence_number%TYPE;

160: l_acad_ci_Sequence_number igs_ca_inst.sequence_number%TYPE;
161: l_acad_cal_Start_dt igs_ca_inst.start_dt%TYPE;
162: l_acad_cal_end_dt igs_ca_inst.end_dt%TYPE;
163: l_load_cal_type igs_ca_type.cal_type%TYPE;
164: l_load_ci_Sequence_number igs_ca_inst.sequence_number%TYPE;
165: l_teach_cal_type igs_ca_type.cal_type%TYPE;
166: l_teach_ci_Sequence_number igs_ca_inst.sequence_number%TYPE;
167:
168: l_error_status VARCHAR2(1);

Line 166: l_teach_ci_Sequence_number igs_ca_inst.sequence_number%TYPE;

162: l_acad_cal_end_dt igs_ca_inst.end_dt%TYPE;
163: l_load_cal_type igs_ca_type.cal_type%TYPE;
164: l_load_ci_Sequence_number igs_ca_inst.sequence_number%TYPE;
165: l_teach_cal_type igs_ca_type.cal_type%TYPE;
166: l_teach_ci_Sequence_number igs_ca_inst.sequence_number%TYPE;
167:
168: l_error_status VARCHAR2(1);
169: l_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE;
170: l_course_version_number igs_en_stdnt_ps_att_all.version_number%TYPE;

Line 200: l_en_cal_type IGS_CA_INST.CAL_TYPE%TYPE;

196: l_processed BOOLEAN;
197: l_dummy VARCHAR2(100);
198:
199: l_commencement_type VARCHAR2(20) DEFAULT NULL;
200: l_en_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
201: l_en_ci_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
202: l_person_type IGS_PE_PERSON_TYPES.person_type_code%TYPE;
203: l_sua_rec get_sua%ROWTYPE;
204:

Line 201: l_en_ci_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE;

197: l_dummy VARCHAR2(100);
198:
199: l_commencement_type VARCHAR2(20) DEFAULT NULL;
200: l_en_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
201: l_en_ci_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
202: l_person_type IGS_PE_PERSON_TYPES.person_type_code%TYPE;
203: l_sua_rec get_sua%ROWTYPE;
204:
205: