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.

[Home] [Help]

APPS.IGS_AD_GEN_002 dependencies on IGS_PS_UNIT_VER

Line 1334: v_subject_code IGS_PS_UNIT_VER.unit_cd%TYPE;

1330: v_exclusion_flag VARCHAR2(1);
1331: v_s_encmb_effect_type IGS_PE_COURSE_EXCL.s_encmb_effect_type%TYPE;
1332: v_course_completed_flag VARCHAR2(1);
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);

Line 1335: v_subject_title IGS_PS_UNIT_VER.title%TYPE;

1331: v_s_encmb_effect_type IGS_PE_COURSE_EXCL.s_encmb_effect_type%TYPE;
1332: v_course_completed_flag VARCHAR2(1);
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;

Line 1384: IGS_PS_UNIT_VER uv

1380: sua.no_assessment_ind
1381: FROM IGS_EN_SU_ATTEMPT sua,
1382: IGS_EN_STDNT_PS_ATT sca,
1383: IGS_PS_VER crv,
1384: IGS_PS_UNIT_VER uv
1385: WHERE sua.person_id = p_matched_id AND
1386: sua.unit_attempt_status IN (
1387: cst_enrolled,
1388: cst_completed,

Line 1467: cp_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,

1463: cat2.s_cal_cat = cst_load AND
1464: cir1.sup_cal_type = cir2.sup_cal_type AND
1465: cir1.sup_ci_sequence_number = cir2.sup_ci_sequence_number;
1466: CURSOR c_di_ud (
1467: cp_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,
1468: cp_unit_version_number IGS_PS_UNIT_VER.version_number%TYPE) IS
1469: SELECT di.govt_discipline_group_cd
1470: FROM IGS_PS_DSCP di,
1471: IGS_PS_UNIT_DSCP ud

Line 1468: cp_unit_version_number IGS_PS_UNIT_VER.version_number%TYPE) IS

1464: cir1.sup_cal_type = cir2.sup_cal_type AND
1465: cir1.sup_ci_sequence_number = cir2.sup_ci_sequence_number;
1466: CURSOR c_di_ud (
1467: cp_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,
1468: cp_unit_version_number IGS_PS_UNIT_VER.version_number%TYPE) IS
1469: SELECT di.govt_discipline_group_cd
1470: FROM IGS_PS_DSCP di,
1471: IGS_PS_UNIT_DSCP ud
1472: WHERE di.discipline_group_cd = ud.discipline_group_cd AND