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_AS_SUAO_LGCY_PUB dependencies on IGS_PS_OFR_PAT

Line 1330: cp_acad_cal_type IGS_PS_OFR_PAT.CAL_TYPE%TYPE ,

1326: -- If the grading schema precedence number is set to N at the unit section level then
1327: -- retrieve the grading schema code and version number set at the program offering pattern level
1328: -- for the corresponding student unit attempt.
1329: CURSOR cur_cop (
1330: cp_acad_cal_type IGS_PS_OFR_PAT.CAL_TYPE%TYPE ,
1331: cp_acad_ci_seq_num IGS_PS_OFR_PAT.CI_SEQUENCE_NUMBER%TYPE
1332: )
1333: IS
1334: SELECT

Line 1331: cp_acad_ci_seq_num IGS_PS_OFR_PAT.CI_SEQUENCE_NUMBER%TYPE

1327: -- retrieve the grading schema code and version number set at the program offering pattern level
1328: -- for the corresponding student unit attempt.
1329: CURSOR cur_cop (
1330: cp_acad_cal_type IGS_PS_OFR_PAT.CAL_TYPE%TYPE ,
1331: cp_acad_ci_seq_num IGS_PS_OFR_PAT.CI_SEQUENCE_NUMBER%TYPE
1332: )
1333: IS
1334: SELECT
1335: cop.grading_schema_cd,

Line 1341: igs_ps_ofr_pat cop

1337: FROM
1338: igs_en_su_attempt sua,
1339: igs_en_stdnt_ps_att sca,
1340: igs_ps_unit_ofr_opt uoo,
1341: igs_ps_ofr_pat cop
1342: WHERE
1343: sua.person_id = p_person_id
1344: AND sua.course_cd = p_lgcy_suo_rec.program_cd
1345: AND sua.unit_cd = p_lgcy_suo_rec.unit_cd

Line 1363: cp_grading_schema_cd IGS_PS_OFR_PAT.GRADING_SCHEMA_CD%TYPE,

1359:
1360: -- get the to grade for the grading schema and to grading schema (set at the unit section/unit
1361: -- level and the program offering pattern level.
1362: CURSOR cur_gsgt(
1363: cp_grading_schema_cd IGS_PS_OFR_PAT.GRADING_SCHEMA_CD%TYPE,
1364: cp_gs_ver_num IGS_PS_OFR_PAT.GS_VERSION_NUMBER%TYPE
1365: )
1366: IS
1367: SELECT

Line 1364: cp_gs_ver_num IGS_PS_OFR_PAT.GS_VERSION_NUMBER%TYPE

1360: -- get the to grade for the grading schema and to grading schema (set at the unit section/unit
1361: -- level and the program offering pattern level.
1362: CURSOR cur_gsgt(
1363: cp_grading_schema_cd IGS_PS_OFR_PAT.GRADING_SCHEMA_CD%TYPE,
1364: cp_gs_ver_num IGS_PS_OFR_PAT.GS_VERSION_NUMBER%TYPE
1365: )
1366: IS
1367: SELECT
1368: gsgt.to_grade