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_AD_GEN_002 dependencies on IGS_CA_TYPE

Line 1302: cst_academic CONSTANT IGS_CA_TYPE.s_cal_cat%TYPE := 'ACADEMIC';

1298: cst_exc_crs_gp CONSTANT IGS_PE_CRS_GRP_EXCL.s_encmb_effect_type%TYPE :=
1299: 'EXC_CRS_GP';
1300: cst_sus_course CONSTANT IGS_PE_COURSE_EXCL.s_encmb_effect_type%TYPE :=
1301: 'SUS_COURSE';
1302: cst_academic CONSTANT IGS_CA_TYPE.s_cal_cat%TYPE := 'ACADEMIC';
1303: cst_load CONSTANT IGS_CA_TYPE.s_cal_cat%TYPE := 'LOAD';
1304: cst_student_rec_type CONSTANT VARCHAR2(1) := 'M';
1305: cst_subject_rec_type CONSTANT VARCHAR2(1) := 'S';
1306: cst_withdrawn CONSTANT IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE :=

Line 1303: cst_load CONSTANT IGS_CA_TYPE.s_cal_cat%TYPE := 'LOAD';

1299: 'EXC_CRS_GP';
1300: cst_sus_course CONSTANT IGS_PE_COURSE_EXCL.s_encmb_effect_type%TYPE :=
1301: 'SUS_COURSE';
1302: cst_academic CONSTANT IGS_CA_TYPE.s_cal_cat%TYPE := 'ACADEMIC';
1303: cst_load CONSTANT IGS_CA_TYPE.s_cal_cat%TYPE := 'LOAD';
1304: cst_student_rec_type CONSTANT VARCHAR2(1) := 'M';
1305: cst_subject_rec_type CONSTANT VARCHAR2(1) := 'S';
1306: cst_withdrawn CONSTANT IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE :=
1307: 'WITHDRAWN';

Line 1337: v_arts_teaching_cal_type_cd IGS_CA_TYPE.arts_teaching_cal_type_cd%TYPE;

1333: v_all_subjects_inc_flag VARCHAR2(1);
1334: v_subject_code IGS_PS_UNIT_VER.unit_cd%TYPE;
1335: v_subject_title IGS_PS_UNIT_VER.title%TYPE;
1336: v_year_enrolled IGS_EN_SUA_V.acad_alternate_code%TYPE;
1337: v_arts_teaching_cal_type_cd IGS_CA_TYPE.arts_teaching_cal_type_cd%TYPE;
1338: v_semester_enrolled NUMBER(1);
1339: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
1340: v_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
1341: v_subject_completion_code NUMBER(1);

Line 1444: cp_cal_type IGS_CA_TYPE.cal_type%TYPE) IS

1440: pcge.course_group_cd = cgr.course_group_cd AND
1441: cgr.course_group_cd = cgm.course_group_cd AND
1442: cgm.course_cd = cp_course_cd;
1443: CURSOR c_cat (
1444: cp_cal_type IGS_CA_TYPE.cal_type%TYPE) IS
1445: SELECT cat.arts_teaching_cal_type_cd
1446: FROM IGS_CA_TYPE cat
1447: WHERE cat.cal_type = cp_cal_type;
1448: CURSOR c_cir_cat (

Line 1446: FROM IGS_CA_TYPE cat

1442: cgm.course_cd = cp_course_cd;
1443: CURSOR c_cat (
1444: cp_cal_type IGS_CA_TYPE.cal_type%TYPE) IS
1445: SELECT cat.arts_teaching_cal_type_cd
1446: FROM IGS_CA_TYPE cat
1447: WHERE cat.cal_type = cp_cal_type;
1448: CURSOR c_cir_cat (
1449: cp_teach_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE,
1450: cp_teach_ci_sequence_number

Line 1456: IGS_CA_TYPE cat1,

1452: SELECT cir2.sub_cal_type,
1453: cir2.sub_ci_sequence_number
1454: FROM IGS_CA_INST_REL cir1,
1455: IGS_CA_INST_REL cir2,
1456: IGS_CA_TYPE cat1,
1457: IGS_CA_TYPE cat2
1458: WHERE cir1.sup_cal_type = cat1.cal_type AND
1459: cat1.s_cal_cat = cst_academic AND
1460: cir1.sub_cal_type = cp_teach_cal_type AND

Line 1457: IGS_CA_TYPE cat2

1453: cir2.sub_ci_sequence_number
1454: FROM IGS_CA_INST_REL cir1,
1455: IGS_CA_INST_REL cir2,
1456: IGS_CA_TYPE cat1,
1457: IGS_CA_TYPE cat2
1458: WHERE cir1.sup_cal_type = cat1.cal_type AND
1459: cat1.s_cal_cat = cst_academic AND
1460: cir1.sub_cal_type = cp_teach_cal_type AND
1461: cir1.sub_ci_sequence_number = cp_teach_ci_sequence_number AND