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_CALC_AWARD_MARK dependencies on IGS_AS_GRD_SCH_GRADE

Line 120: FROM igs_as_grd_sch_grade

116: CURSOR c_mark (cp_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE,
117: cp_gs_version_number igs_as_su_stmptout.version_number%TYPE,
118: cp_grade igs_as_su_stmptout.grade%TYPE) IS
119: SELECT upper_mark_range
120: FROM igs_as_grd_sch_grade
121: WHERE grading_schema_cd = cp_grading_schema_cd
122: AND version_number = cp_gs_version_number
123: AND grade = cp_grade;
124: l_mark igs_as_grd_sch_grade.upper_mark_range%TYPE;

Line 124: l_mark igs_as_grd_sch_grade.upper_mark_range%TYPE;

120: FROM igs_as_grd_sch_grade
121: WHERE grading_schema_cd = cp_grading_schema_cd
122: AND version_number = cp_gs_version_number
123: AND grade = cp_grade;
124: l_mark igs_as_grd_sch_grade.upper_mark_range%TYPE;
125:
126: BEGIN
127: l_mark := NULL;
128: -- get the mark

Line 1226: igs_as_grd_sch_grade gsg,

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,
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'

Line 1240: igs_as_grd_sch_grade gsg

1236:
1237: CURSOR c_honors_level1 (cp_sum NUMBER) IS
1238: SELECT gsg.grade, gs.grading_schema_cd, gs.version_number
1239: FROM igs_as_grd_schema gs,
1240: igs_as_grd_sch_grade gsg
1241: WHERE gs.grading_schema_cd = gsg.grading_schema_cd
1242: AND gs.version_number = gsg.version_number
1243: AND gs.grading_schema_type = 'HONORS'
1244: AND gs.start_dt <= SYSDATE

Line 1249: l_grading_schema_cd IGS_AS_GRD_SCH_GRADE.GRADING_SCHEMA_CD%TYPE;

1245: AND nvl(gs.end_dt,SYSDATE) >= SYSDATE
1246: AND gsg.lower_mark_range <= (cp_sum)
1247: AND gsg.upper_mark_range >= (cp_sum);
1248:
1249: l_grading_schema_cd IGS_AS_GRD_SCH_GRADE.GRADING_SCHEMA_CD%TYPE;
1250: l_gs_version_number IGS_AS_GRD_SCH_GRADE.VERSION_NUMBER%TYPE;
1251: l_honors_level igs_as_grd_sch_grade.grade%TYPE; -- stores honors level
1252: l_honors_level_not_used VARCHAR2(30);
1253: BEGIN

Line 1250: l_gs_version_number IGS_AS_GRD_SCH_GRADE.VERSION_NUMBER%TYPE;

1246: AND gsg.lower_mark_range <= (cp_sum)
1247: AND gsg.upper_mark_range >= (cp_sum);
1248:
1249: l_grading_schema_cd IGS_AS_GRD_SCH_GRADE.GRADING_SCHEMA_CD%TYPE;
1250: l_gs_version_number IGS_AS_GRD_SCH_GRADE.VERSION_NUMBER%TYPE;
1251: l_honors_level igs_as_grd_sch_grade.grade%TYPE; -- stores honors level
1252: l_honors_level_not_used VARCHAR2(30);
1253: BEGIN
1254: OPEN c_honors_level (p_award_cd,p_sum);

Line 1251: l_honors_level igs_as_grd_sch_grade.grade%TYPE; -- stores honors level

1247: AND gsg.upper_mark_range >= (cp_sum);
1248:
1249: l_grading_schema_cd IGS_AS_GRD_SCH_GRADE.GRADING_SCHEMA_CD%TYPE;
1250: l_gs_version_number IGS_AS_GRD_SCH_GRADE.VERSION_NUMBER%TYPE;
1251: l_honors_level igs_as_grd_sch_grade.grade%TYPE; -- stores honors level
1252: l_honors_level_not_used VARCHAR2(30);
1253: BEGIN
1254: OPEN c_honors_level (p_award_cd,p_sum);
1255: FETCH c_honors_level INTO l_honors_level, l_grading_schema_cd, l_GS_VERSION_NUMBER;

Line 1360: l_honors_level igs_as_grd_sch_grade.grade%TYPE; -- stores honors level

1356:
1357: --local variables
1358: l_unit_level_mark NUMBER; -- stores unit level mark
1359: l_sum NUMBER; -- sum of l_unit_level_mark*l_unit_level_wam
1360: l_honors_level igs_as_grd_sch_grade.grade%TYPE; -- stores honors level
1361: l_gpa_value NUMBER;
1362: l_gpa_cp NUMBER;
1363: l_gpa_quality_points NUMBER;
1364: l_acad_cal_type VARCHAR2(30);

Line 1372: l_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE;

1368: l_load_ci_alt_code VARCHAR2(30);
1369: l_load_ci_start_dt DATE;
1370: l_load_ci_end_dt DATE;
1371: l_message_name VARCHAR2(30):=NULL;
1372: l_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE;
1373: l_gs_version_number igs_as_grd_sch_grade.version_number%TYPE;
1374: BEGIN
1375: --Initialize the variables
1376: FND_MSG_PUB.initialize;

Line 1373: l_gs_version_number igs_as_grd_sch_grade.version_number%TYPE;

1369: l_load_ci_start_dt DATE;
1370: l_load_ci_end_dt DATE;
1371: l_message_name VARCHAR2(30):=NULL;
1372: l_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE;
1373: l_gs_version_number igs_as_grd_sch_grade.version_number%TYPE;
1374: BEGIN
1375: --Initialize the variables
1376: FND_MSG_PUB.initialize;
1377: l_unit_level_mark :=0;

Line 1614: FROM igs_as_grd_schema gs, igs_as_grd_sch_grade gsg

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,
1613: gsg.lower_mark_range, gsg.upper_mark_range
1614: FROM igs_as_grd_schema gs, igs_as_grd_sch_grade gsg
1615: WHERE gs.grading_schema_cd = gsg.grading_schema_cd
1616: AND gs.version_number = gsg.version_number
1617: AND gs.grading_schema_type = 'HONORS'
1618: AND gs.grading_schema_cd = cp_grd_sch

Line 1623: lAwadrdGrade IGS_as_grd_sch_grade.Grade%TYPE;

1619: AND gs.version_number = cp_grd_ver
1620: AND gsg.GRADE = cp_grade;
1621:
1622: lAwdMark igs_en_spa_awd_aim.AWARD_MARK%TYPE;
1623: lAwadrdGrade IGS_as_grd_sch_grade.Grade%TYPE;
1624: lReturnStatus VARCHAR2(10);
1625: lMsgData VARCHAR2(2000);
1626: l_enc_msg VARCHAR2(2000);
1627: l_mesg_text VARCHAR2(4000);