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_AS_CALC_AWARD_MARK dependencies on IGS_PS_AWD

Line 1222: CURSOR c_honors_level (cp_award_cd igs_ps_awd.award_cd%TYPE,

1218: || (reverse chronological order - newest change first) ||
1219: ||==============================================================================||
1220: */
1221: -- cursor to derive the grade (honors level)
1222: CURSOR c_honors_level (cp_award_cd igs_ps_awd.award_cd%TYPE,
1223: cp_sum NUMBER) IS
1224: SELECT gsg.grade, gs.grading_schema_cd, gs.version_number
1225: FROM igs_as_grd_schema gs,
1226: igs_as_grd_sch_grade gsg,

Line 1227: igs_ps_awd pa

1223: cp_sum NUMBER) IS
1224: SELECT gsg.grade, gs.grading_schema_cd, gs.version_number
1225: FROM igs_as_grd_schema gs,
1226: igs_as_grd_sch_grade gsg,
1227: igs_ps_awd pa
1228: WHERE gs.grading_schema_cd = gsg.grading_schema_cd
1229: AND gs.version_number = gsg.version_number
1230: AND gs.grading_schema_type = 'HONORS'
1231: AND pa.award_cd = cp_award_cd

Line 1308: -- the unit level in table igs_ps_awd_hnr_base and the student has attempted some unit at that level, then the weghted avg mark should be

1304:
1305: */
1306:
1307: -- cursor to fetch all associated unit level with the passed award code. Note that if there is no configuration done here for
1308: -- the unit level in table igs_ps_awd_hnr_base and the student has attempted some unit at that level, then the weghted avg mark should be
1309: -- considered as 1.
1310: CURSOR c_unit_levels (cp_award_cd igs_ps_awd.award_cd%TYPE) IS
1311: SELECT unit_level, weighted_average
1312: FROM igs_ps_awd_hnr_base

Line 1310: CURSOR c_unit_levels (cp_award_cd igs_ps_awd.award_cd%TYPE) IS

1306:
1307: -- cursor to fetch all associated unit level with the passed award code. Note that if there is no configuration done here for
1308: -- the unit level in table igs_ps_awd_hnr_base and the student has attempted some unit at that level, then the weghted avg mark should be
1309: -- considered as 1.
1310: CURSOR c_unit_levels (cp_award_cd igs_ps_awd.award_cd%TYPE) IS
1311: SELECT unit_level, weighted_average
1312: FROM igs_ps_awd_hnr_base
1313: WHERE award_cd = cp_award_cd
1314: AND unit_level IS NOT NULL

Line 1312: FROM igs_ps_awd_hnr_base

1308: -- the unit level in table igs_ps_awd_hnr_base and the student has attempted some unit at that level, then the weghted avg mark should be
1309: -- considered as 1.
1310: CURSOR c_unit_levels (cp_award_cd igs_ps_awd.award_cd%TYPE) IS
1311: SELECT unit_level, weighted_average
1312: FROM igs_ps_awd_hnr_base
1313: WHERE award_cd = cp_award_cd
1314: AND unit_level IS NOT NULL
1315: UNION
1316: SELECT NVL(ul.unit_level, uv.unit_level) AS unit_level, 1 AS weighted_average

Line 1326: NOT EXISTS (SELECT 1 FROM igs_ps_awd_hnr_base hb WHERE NVL(ul.unit_level, uv.unit_level) = hb.unit_level);

1322: sua.course_cd = ul.course_cd(+) AND
1323: sua.unit_cd = ul.unit_cd(+) AND
1324: sua.version_number = ul.version_number(+) AND
1325: sua.person_id = p_person_id and sua.course_cd = p_course_cd AND
1326: NOT EXISTS (SELECT 1 FROM igs_ps_awd_hnr_base hb WHERE NVL(ul.unit_level, uv.unit_level) = hb.unit_level);
1327:
1328: -- cursor to get the stat details
1329: CURSOR c_stat_dtls (cp_award_cd igs_ps_awd.award_cd%TYPE) IS
1330: SELECT stat_type,

Line 1329: CURSOR c_stat_dtls (cp_award_cd igs_ps_awd.award_cd%TYPE) IS

1325: sua.person_id = p_person_id and sua.course_cd = p_course_cd AND
1326: NOT EXISTS (SELECT 1 FROM igs_ps_awd_hnr_base hb WHERE NVL(ul.unit_level, uv.unit_level) = hb.unit_level);
1327:
1328: -- cursor to get the stat details
1329: CURSOR c_stat_dtls (cp_award_cd igs_ps_awd.award_cd%TYPE) IS
1330: SELECT stat_type,
1331: s_stat_element,
1332: timeframe
1333: FROM igs_ps_awd_hnr_base

Line 1333: FROM igs_ps_awd_hnr_base

1329: CURSOR c_stat_dtls (cp_award_cd igs_ps_awd.award_cd%TYPE) IS
1330: SELECT stat_type,
1331: s_stat_element,
1332: timeframe
1333: FROM igs_ps_awd_hnr_base
1334: WHERE award_cd = cp_award_cd
1335: AND stat_type IS NOT NULL;
1336:
1337: rec_stat_dtls c_stat_dtls%ROWTYPE;

Line 1597: p_award_cd igs_ps_awd.AWARD_CD%TYPE) IS

1593: END fn_derive_honors_level;
1594:
1595: PROCEDURE upgrade_awards (errbuff OUT NOCOPY VARCHAR2,
1596: retcode OUT NOCOPY NUMBER,
1597: p_award_cd igs_ps_awd.AWARD_CD%TYPE) IS
1598: -- Cursor to get all the award aims which are to be updated with the award marks and award grades...
1599: CURSOR cur_spaa(cp_awd_cd VARCHAR2) IS
1600: SELECT spaa.rowid row_id, spaa.*
1601: FROM igs_en_spa_awd_aim spaa

Line 1608: FROM igs_ps_awd pa

1604: spaa.AWARD_GRADE IS NULL;
1605:
1606: CURSOR Cur_awd_grd_sch IS
1607: SELECT pa.grading_schema_cd, pa.gs_version_number
1608: FROM igs_ps_awd pa
1609: WHERE pa.award_cd = p_award_cd;
1610:
1611: CURSOR Cur_Awd_grd(cp_grd_sch VARCHAR2, cp_grd_ver NUMBER, cp_grade VARCHAR2) IS
1612: SELECT gsg.grade, gs.grading_schema_cd, gs.version_number,