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

Line 138: FROM igs_ca_inst ci,

134: l_prg_ver igs_en_stdnt_ps_att.version_number%TYPE;
135: -- Cursor to check whether the passed calendar is Teaching or not
136: CURSOR cur_cal_cat(cp_cal_type VARCHAR2) IS
137: SELECT 'x'
138: FROM igs_ca_inst ci,
139: igs_ca_type ct
140: WHERE ci.cal_type = cp_cal_type AND
141: ci.cal_type = ct.cal_type AND
142: ct.s_cal_cat = 'TEACHING';

Line 207: l_enr_cal_type igs_ca_inst.cal_type%type;

203: l_ret_status VARCHAR2(10);
204: l_enr_meth_type igs_en_method_type.ENR_METHOD_TYPE%type;
205: l_enr_comm igs_en_cpd_ext.s_student_comm_type%type;
206: l_enr_cat igs_en_cpd_ext.enrolment_cat%type;
207: l_enr_cal_type igs_ca_inst.cal_type%type;
208: l_enr_ci_seq igs_ca_inst.sequence_number%type;
209: cst_mincp varchar2(10) := 'FMAX_CRDT';
210: cst_maxcp varchar2(10) := 'FMIN_CRDT';
211: cst_fatd varchar2(10) := 'FATD_TYPE';

Line 208: l_enr_ci_seq igs_ca_inst.sequence_number%type;

204: l_enr_meth_type igs_en_method_type.ENR_METHOD_TYPE%type;
205: l_enr_comm igs_en_cpd_ext.s_student_comm_type%type;
206: l_enr_cat igs_en_cpd_ext.enrolment_cat%type;
207: l_enr_cal_type igs_ca_inst.cal_type%type;
208: l_enr_ci_seq igs_ca_inst.sequence_number%type;
209: cst_mincp varchar2(10) := 'FMAX_CRDT';
210: cst_maxcp varchar2(10) := 'FMIN_CRDT';
211: cst_fatd varchar2(10) := 'FATD_TYPE';
212: cst_crossfac varchar2(10) := 'CROSS_FAC';

Line 218: l_acad_cal_type igs_ca_inst.cal_type%type;

214: cst_crossloc varchar2(10) := 'CROSS_LOC';
215: cst_reenroll varchar2(10) := 'REENROLL';
216: cst_program varchar2(10) :='PROGRAM';
217: cst_unit varchar2(10) :='UNIT';
218: l_acad_cal_type igs_ca_inst.cal_type%type;
219: l_acad_ci_sequence_number igs_ca_inst.sequence_number%type;
220: l_acad_start_dt igs_ca_inst.start_dt%type;
221: l_acad_end_dt igs_ca_inst.end_dt%type;
222: l_alternate_code igs_ca_inst.alternate_code%type;

Line 219: l_acad_ci_sequence_number igs_ca_inst.sequence_number%type;

215: cst_reenroll varchar2(10) := 'REENROLL';
216: cst_program varchar2(10) :='PROGRAM';
217: cst_unit varchar2(10) :='UNIT';
218: l_acad_cal_type igs_ca_inst.cal_type%type;
219: l_acad_ci_sequence_number igs_ca_inst.sequence_number%type;
220: l_acad_start_dt igs_ca_inst.start_dt%type;
221: l_acad_end_dt igs_ca_inst.end_dt%type;
222: l_alternate_code igs_ca_inst.alternate_code%type;
223: l_acad_message varchar2(100);

Line 220: l_acad_start_dt igs_ca_inst.start_dt%type;

216: cst_program varchar2(10) :='PROGRAM';
217: cst_unit varchar2(10) :='UNIT';
218: l_acad_cal_type igs_ca_inst.cal_type%type;
219: l_acad_ci_sequence_number igs_ca_inst.sequence_number%type;
220: l_acad_start_dt igs_ca_inst.start_dt%type;
221: l_acad_end_dt igs_ca_inst.end_dt%type;
222: l_alternate_code igs_ca_inst.alternate_code%type;
223: l_acad_message varchar2(100);
224: l_load_cal_type igs_ca_inst.cal_type%TYPE;

Line 221: l_acad_end_dt igs_ca_inst.end_dt%type;

217: cst_unit varchar2(10) :='UNIT';
218: l_acad_cal_type igs_ca_inst.cal_type%type;
219: l_acad_ci_sequence_number igs_ca_inst.sequence_number%type;
220: l_acad_start_dt igs_ca_inst.start_dt%type;
221: l_acad_end_dt igs_ca_inst.end_dt%type;
222: l_alternate_code igs_ca_inst.alternate_code%type;
223: l_acad_message varchar2(100);
224: l_load_cal_type igs_ca_inst.cal_type%TYPE;
225: l_load_sequence_number igs_ca_inst.sequence_number%TYPE;

Line 222: l_alternate_code igs_ca_inst.alternate_code%type;

218: l_acad_cal_type igs_ca_inst.cal_type%type;
219: l_acad_ci_sequence_number igs_ca_inst.sequence_number%type;
220: l_acad_start_dt igs_ca_inst.start_dt%type;
221: l_acad_end_dt igs_ca_inst.end_dt%type;
222: l_alternate_code igs_ca_inst.alternate_code%type;
223: l_acad_message varchar2(100);
224: l_load_cal_type igs_ca_inst.cal_type%TYPE;
225: l_load_sequence_number igs_ca_inst.sequence_number%TYPE;
226: l_unit_incurred_cp NUMBER;

Line 224: l_load_cal_type igs_ca_inst.cal_type%TYPE;

220: l_acad_start_dt igs_ca_inst.start_dt%type;
221: l_acad_end_dt igs_ca_inst.end_dt%type;
222: l_alternate_code igs_ca_inst.alternate_code%type;
223: l_acad_message varchar2(100);
224: l_load_cal_type igs_ca_inst.cal_type%TYPE;
225: l_load_sequence_number igs_ca_inst.sequence_number%TYPE;
226: l_unit_incurred_cp NUMBER;
227: l_dummy NUMBER;
228: l_dummy_c VARCHAR2(2000);

Line 225: l_load_sequence_number igs_ca_inst.sequence_number%TYPE;

221: l_acad_end_dt igs_ca_inst.end_dt%type;
222: l_alternate_code igs_ca_inst.alternate_code%type;
223: l_acad_message varchar2(100);
224: l_load_cal_type igs_ca_inst.cal_type%TYPE;
225: l_load_sequence_number igs_ca_inst.sequence_number%TYPE;
226: l_unit_incurred_cp NUMBER;
227: l_dummy NUMBER;
228: l_dummy_c VARCHAR2(2000);
229: l_over_incurred_cp NUMBER;