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

Line 1040: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;

1036: RETURN VARCHAR2 IS
1037: v_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
1038: v_override_achievable_cp IGS_EN_SU_ATTEMPT.override_achievable_cp%TYPE;
1039: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE;
1040: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
1041: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
1042: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
1043: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;
1044: v_original_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;

Line 1041: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;

1037: v_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
1038: v_override_achievable_cp IGS_EN_SU_ATTEMPT.override_achievable_cp%TYPE;
1039: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE;
1040: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
1041: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
1042: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
1043: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;
1044: v_original_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
1045: v_result VARCHAR2(30);

Line 1042: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;

1038: v_override_achievable_cp IGS_EN_SU_ATTEMPT.override_achievable_cp%TYPE;
1039: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE;
1040: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
1041: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
1042: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
1043: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;
1044: v_original_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
1045: v_result VARCHAR2(30);
1046: BEGIN

Line 1115: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;

1111: -- This query may return multiple records but we should consider only the least ranked record.
1112:
1113: FUNCTION adv_attribute (p_attribute IN VARCHAR2, p_member_index IN BINARY_INTEGER)
1114: RETURN VARCHAR2 IS
1115: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
1116: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
1117:
1118: CURSOR c_grad_sch IS
1119: SELECT av.grading_schema_cd, av.grade

Line 1116: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;

1112:
1113: FUNCTION adv_attribute (p_attribute IN VARCHAR2, p_member_index IN BINARY_INTEGER)
1114: RETURN VARCHAR2 IS
1115: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
1116: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
1117:
1118: CURSOR c_grad_sch IS
1119: SELECT av.grading_schema_cd, av.grade
1120: FROM igs_av_stnd_unit av , igs_as_grd_sch_grade grad

Line 1120: FROM igs_av_stnd_unit av , igs_as_grd_sch_grade grad

1116: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
1117:
1118: CURSOR c_grad_sch IS
1119: SELECT av.grading_schema_cd, av.grade
1120: FROM igs_av_stnd_unit av , igs_as_grd_sch_grade grad
1121: WHERE av.as_course_cd = p_course_cd
1122: AND av.person_id = p_person_id
1123: AND av.unit_cd = gv_member(p_member_index).f1
1124: AND av.version_number = gv_member(p_member_index).f2

Line 1274: v_lhs_rank IGS_AS_GRD_SCH_GRADE.rank%TYPE;

1270: RETURN VARCHAR2 IS
1271: /*
1272: 'true' or 'false'
1273: */
1274: v_lhs_rank IGS_AS_GRD_SCH_GRADE.rank%TYPE;
1275: v_rhs_rank IGS_AS_GRD_SCH_GRADE.rank%TYPE;
1276: v_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE;
1277: v_unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE;
1278: v_grading_schema IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;

Line 1275: v_rhs_rank IGS_AS_GRD_SCH_GRADE.rank%TYPE;

1271: /*
1272: 'true' or 'false'
1273: */
1274: v_lhs_rank IGS_AS_GRD_SCH_GRADE.rank%TYPE;
1275: v_rhs_rank IGS_AS_GRD_SCH_GRADE.rank%TYPE;
1276: v_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE;
1277: v_unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE;
1278: v_grading_schema IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
1279: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;

Line 1278: v_grading_schema IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;

1274: v_lhs_rank IGS_AS_GRD_SCH_GRADE.rank%TYPE;
1275: v_rhs_rank IGS_AS_GRD_SCH_GRADE.rank%TYPE;
1276: v_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE;
1277: v_unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE;
1278: v_grading_schema IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
1279: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
1280: BEGIN
1281: /*
1282: if grading schema not same then only <> is true

Line 1279: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;

1275: v_rhs_rank IGS_AS_GRD_SCH_GRADE.rank%TYPE;
1276: v_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE;
1277: v_unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE;
1278: v_grading_schema IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
1279: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
1280: BEGIN
1281: /*
1282: if grading schema not same then only <> is true
1283: */

Line 1334: FROM IGS_AS_GRD_SCH_GRADE

1330: */
1331: BEGIN
1332: SELECT rank
1333: INTO v_lhs_rank
1334: FROM IGS_AS_GRD_SCH_GRADE
1335: WHERE grading_schema_cd = v_grading_schema
1336: AND version_number = v_gs_version_number
1337: AND grade = p_lhs_grade;
1338: SELECT rank

Line 1340: FROM IGS_AS_GRD_SCH_GRADE

1336: AND version_number = v_gs_version_number
1337: AND grade = p_lhs_grade;
1338: SELECT rank
1339: INTO v_rhs_rank
1340: FROM IGS_AS_GRD_SCH_GRADE
1341: WHERE grading_schema_cd = v_grading_schema
1342: AND version_number = v_gs_version_number
1343: AND grade = p_rhs_grade;
1344: EXCEPTION

Line 1412: v_lhs_rank IGS_AS_GRD_SCH_GRADE.rank%TYPE;

1408: RETURN VARCHAR2 IS
1409: /*
1410: 'true' or 'false'
1411: */
1412: v_lhs_rank IGS_AS_GRD_SCH_GRADE.rank%TYPE;
1413: v_rhs_rank IGS_AS_GRD_SCH_GRADE.rank%TYPE;
1414: v_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE;
1415: v_unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE;
1416: v_grading_schema IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;

Line 1413: v_rhs_rank IGS_AS_GRD_SCH_GRADE.rank%TYPE;

1409: /*
1410: 'true' or 'false'
1411: */
1412: v_lhs_rank IGS_AS_GRD_SCH_GRADE.rank%TYPE;
1413: v_rhs_rank IGS_AS_GRD_SCH_GRADE.rank%TYPE;
1414: v_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE;
1415: v_unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE;
1416: v_grading_schema IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
1417: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;

Line 1416: v_grading_schema IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;

1412: v_lhs_rank IGS_AS_GRD_SCH_GRADE.rank%TYPE;
1413: v_rhs_rank IGS_AS_GRD_SCH_GRADE.rank%TYPE;
1414: v_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE;
1415: v_unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE;
1416: v_grading_schema IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
1417: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
1418:
1419: CURSOR c_grad_sch IS
1420: SELECT av.grading_schema_cd, av.grd_sch_version_number

Line 1417: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;

1413: v_rhs_rank IGS_AS_GRD_SCH_GRADE.rank%TYPE;
1414: v_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE;
1415: v_unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE;
1416: v_grading_schema IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
1417: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
1418:
1419: CURSOR c_grad_sch IS
1420: SELECT av.grading_schema_cd, av.grd_sch_version_number
1421: FROM IGS_AV_STND_UNIT av , igs_as_grd_sch_grade grad

Line 1421: FROM IGS_AV_STND_UNIT av , igs_as_grd_sch_grade grad

1417: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
1418:
1419: CURSOR c_grad_sch IS
1420: SELECT av.grading_schema_cd, av.grd_sch_version_number
1421: FROM IGS_AV_STND_UNIT av , igs_as_grd_sch_grade grad
1422: WHERE av.as_course_cd = p_course_cd
1423: AND av.person_id = p_person_id
1424: AND av.unit_cd = p_tds.unit_cd
1425: AND av.version_number = p_tds.unit_version

Line 1472: FROM IGS_AS_GRD_SCH_GRADE

1468: */
1469: BEGIN
1470: SELECT rank
1471: INTO v_lhs_rank
1472: FROM IGS_AS_GRD_SCH_GRADE
1473: WHERE grading_schema_cd = v_grading_schema
1474: AND version_number = v_gs_version_number
1475: AND grade = p_lhs_grade;
1476: SELECT rank

Line 1478: FROM IGS_AS_GRD_SCH_GRADE

1474: AND version_number = v_gs_version_number
1475: AND grade = p_lhs_grade;
1476: SELECT rank
1477: INTO v_rhs_rank
1478: FROM IGS_AS_GRD_SCH_GRADE
1479: WHERE grading_schema_cd = v_grading_schema
1480: AND version_number = v_gs_version_number
1481: AND grade = p_rhs_grade;
1482: EXCEPTION

Line 3536: CURSOR cur_gscd_set_members(cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,

3532:
3533: -- Get All the Grading Schema Code, Grade pairs for the Grading Schema Code given in Rule Definition.
3534: /* added DISTINCT to select query as the rule 34420 has DISTINCT in its query */
3535:
3536: CURSOR cur_gscd_set_members(cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,
3537: cp_grade igs_as_grd_sch_grade.grade%TYPE) IS
3538: SELECT DISTINCT grading_schema_cd, grade
3539: FROM igs_as_grd_sch_grade
3540: WHERE grading_schema_cd = cp_grading_schema_cd

Line 3537: cp_grade igs_as_grd_sch_grade.grade%TYPE) IS

3533: -- Get All the Grading Schema Code, Grade pairs for the Grading Schema Code given in Rule Definition.
3534: /* added DISTINCT to select query as the rule 34420 has DISTINCT in its query */
3535:
3536: CURSOR cur_gscd_set_members(cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,
3537: cp_grade igs_as_grd_sch_grade.grade%TYPE) IS
3538: SELECT DISTINCT grading_schema_cd, grade
3539: FROM igs_as_grd_sch_grade
3540: WHERE grading_schema_cd = cp_grading_schema_cd
3541: AND grade = cp_grade

Line 3539: FROM igs_as_grd_sch_grade

3535:
3536: CURSOR cur_gscd_set_members(cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,
3537: cp_grade igs_as_grd_sch_grade.grade%TYPE) IS
3538: SELECT DISTINCT grading_schema_cd, grade
3539: FROM igs_as_grd_sch_grade
3540: WHERE grading_schema_cd = cp_grading_schema_cd
3541: AND grade = cp_grade
3542: ORDER BY grading_schema_cd;
3543:

Line 4189: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;

4185: --
4186: v_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
4187: v_override_achievable_cp IGS_EN_SU_ATTEMPT.override_achievable_cp%TYPE;
4188: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE;
4189: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
4190: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
4191: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
4192: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;
4193: v_original_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;

Line 4190: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;

4186: v_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
4187: v_override_achievable_cp IGS_EN_SU_ATTEMPT.override_achievable_cp%TYPE;
4188: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE;
4189: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
4190: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
4191: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
4192: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;
4193: v_original_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
4194: v_result VARCHAR2(30);

Line 4191: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;

4187: v_override_achievable_cp IGS_EN_SU_ATTEMPT.override_achievable_cp%TYPE;
4188: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE;
4189: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
4190: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
4191: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
4192: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;
4193: v_original_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
4194: v_result VARCHAR2(30);
4195: l_progression_period NUMBER ;

Line 4727: l_result_type igs_as_grd_sch_grade.s_result_type%TYPE;

4723: l_msg_count NUMBER;
4724: l_msg_data VARCHAR2(2000);
4725: l_earned_cp igs_ps_unit_ver.achievable_credit_points%TYPE;
4726: l_attempted_cp igs_ps_unit_ver.achievable_credit_points%TYPE;
4727: l_result_type igs_as_grd_sch_grade.s_result_type%TYPE;
4728:
4729: --OUT varibales to be passed to igs_as_gen_003.assp_get_sua_outcomes Function
4730: l_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE;
4731: l_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE;

Line 4731: l_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE;

4727: l_result_type igs_as_grd_sch_grade.s_result_type%TYPE;
4728:
4729: --OUT varibales to be passed to igs_as_gen_003.assp_get_sua_outcomes Function
4730: l_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE;
4731: l_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE;
4732: l_version_number igs_as_grd_sch_grade.version_number%TYPE;
4733: l_grade igs_as_grd_sch_grade.grade%TYPE;
4734: l_mark igs_as_su_stmptout.mark%TYPE;
4735: l_origin_course_cd igs_en_su_attempt.course_cd%TYPE;

Line 4732: l_version_number igs_as_grd_sch_grade.version_number%TYPE;

4728:
4729: --OUT varibales to be passed to igs_as_gen_003.assp_get_sua_outcomes Function
4730: l_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE;
4731: l_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE;
4732: l_version_number igs_as_grd_sch_grade.version_number%TYPE;
4733: l_grade igs_as_grd_sch_grade.grade%TYPE;
4734: l_mark igs_as_su_stmptout.mark%TYPE;
4735: l_origin_course_cd igs_en_su_attempt.course_cd%TYPE;
4736:

Line 4733: l_grade igs_as_grd_sch_grade.grade%TYPE;

4729: --OUT varibales to be passed to igs_as_gen_003.assp_get_sua_outcomes Function
4730: l_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE;
4731: l_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE;
4732: l_version_number igs_as_grd_sch_grade.version_number%TYPE;
4733: l_grade igs_as_grd_sch_grade.grade%TYPE;
4734: l_mark igs_as_su_stmptout.mark%TYPE;
4735: l_origin_course_cd igs_en_su_attempt.course_cd%TYPE;
4736:
4737: l_total_attempted_cp NUMBER := 0; -- Replaced Default by :=