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

Line 981: v_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;

977: */
978: FUNCTION sua_credit_points (
979: p_member_index BINARY_INTEGER )
980: RETURN NUMBER IS
981: v_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
982: v_override_achievable_cp IGS_EN_SU_ATTEMPT.override_achievable_cp%TYPE;
983: BEGIN
984: -- added logic to obtain the advance standing credit points when the coo_id is null , bug#4283221
985:

Line 982: v_override_achievable_cp IGS_EN_SU_ATTEMPT.override_achievable_cp%TYPE;

978: FUNCTION sua_credit_points (
979: p_member_index BINARY_INTEGER )
980: RETURN NUMBER IS
981: v_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
982: v_override_achievable_cp IGS_EN_SU_ATTEMPT.override_achievable_cp%TYPE;
983: BEGIN
984: -- added logic to obtain the advance standing credit points when the coo_id is null , bug#4283221
985:
986: -- added logic to obtain the advance standing credit points when the coo_id is null , bug#4283221

Line 1010: FROM IGS_EN_SU_ATTEMPT

1006: SELECT unit_attempt_status,
1007: override_achievable_cp
1008: INTO v_unit_attempt_status,
1009: v_override_achievable_cp
1010: FROM IGS_EN_SU_ATTEMPT
1011: WHERE person_id = p_person_id
1012: AND course_cd = p_course_cd
1013: AND uoo_id = gv_member(p_member_index).f5;
1014: END IF;

Line 1037: v_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;

1033: p_attribute IN VARCHAR2,
1034: p_member_index IN BINARY_INTEGER,
1035: p_final_ind IN VARCHAR2)
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;

Line 1038: v_override_achievable_cp IGS_EN_SU_ATTEMPT.override_achievable_cp%TYPE;

1034: p_member_index IN BINARY_INTEGER,
1035: p_final_ind IN VARCHAR2)
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;

Line 1044: v_original_course_cd IGS_EN_SU_ATTEMPT.course_cd%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
1047: SELECT unit_attempt_status,
1048: override_achievable_cp

Line 1051: FROM IGS_EN_SU_ATTEMPT

1047: SELECT unit_attempt_status,
1048: override_achievable_cp
1049: INTO v_unit_attempt_status,
1050: v_override_achievable_cp
1051: FROM IGS_EN_SU_ATTEMPT
1052: WHERE person_id = p_person_id
1053: AND course_cd = p_course_cd
1054: AND uoo_id = gv_member(p_member_index).f5;
1055:

Line 1276: v_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE;

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;
1280: BEGIN

Line 1277: v_unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE;

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;
1280: BEGIN
1281: /*

Line 1299: FROM IGS_EN_SU_ATTEMPT

1295: SELECT location_cd,
1296: unit_class
1297: INTO v_location_cd,
1298: v_unit_class
1299: FROM IGS_EN_SU_ATTEMPT
1300: WHERE person_id = p_person_id
1301: AND course_cd = p_course_cd
1302: AND uoo_id = p_tds.uoo_id;
1303: IF IGS_AS_GEN_003.ASSP_GET_SUA_GS(p_person_id,

Line 1414: v_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE;

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;
1418:

Line 1415: v_unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE;

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;
1418:
1419: CURSOR c_grad_sch IS

Line 2676: FROM IGS_EN_SU_ATTEMPT

2672: version_number,
2673: cal_type,
2674: ci_sequence_number,
2675: uoo_id
2676: FROM IGS_EN_SU_ATTEMPT
2677: WHERE person_id = p_person_id
2678: AND course_cd = p_course_cd
2679: AND (p_param_8 IS NULL OR p_param_8 <> uoo_id)
2680: -- AND sup_unit_cd IS NULL 99/05/04 hrt

Line 2768: v_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE;

2764: -- are not processed later.
2765: FUNCTION advanced_standing
2766: RETURN BINARY_INTEGER IS
2767: v_cal_type IGS_CA_TYPE.cal_type%TYPE;
2768: v_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE;
2769: BEGIN
2770: IF gv_asu_set IS NOT NULL
2771: THEN
2772: RETURN gv_asu_set;

Line 4168: FROM igs_en_su_attempt sua,

4164: sua.version_number,
4165: sua.cal_type,
4166: sua.ci_sequence_number,
4167: sua.uoo_id
4168: FROM igs_en_su_attempt sua,
4169: igs_ca_inst_rel cir,
4170: igs_ca_type cat,
4171: igs_ca_inst ci1,
4172: igs_ca_inst ci2

Line 4186: v_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;

4182: AND ci2.sequence_number = p_ci_sequence_number
4183: AND ci1.start_dt <= ci2.start_dt;
4184:
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;

Line 4187: v_override_achievable_cp IGS_EN_SU_ATTEMPT.override_achievable_cp%TYPE;

4183: AND ci1.start_dt <= ci2.start_dt;
4184:
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;

Line 4193: v_original_course_cd IGS_EN_SU_ATTEMPT.course_cd%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 ;
4196: l_failed_cp NUMBER := 0;
4197: l_attempted_cp NUMBER := 0;

Line 4249: FROM igs_en_su_attempt

4245: SELECT unit_attempt_status,
4246: override_achievable_cp
4247: INTO v_unit_attempt_status,
4248: v_override_achievable_cp
4249: FROM igs_en_su_attempt
4250: WHERE person_id = p_person_id
4251: AND course_cd = p_course_cd
4252: AND uoo_id = sua_rec.uoo_id;
4253: -- Get the outcome of the unit attempt

Line 4685: FROM igs_en_su_attempt sua,

4681: sua.cal_type,
4682: sua.ci_sequence_number,
4683: sua.unit_attempt_status,
4684: uoo_id
4685: FROM igs_en_su_attempt sua,
4686: igs_ca_inst ci_cur,
4687: igs_ca_inst_rel cir,
4688: igs_ca_inst ci,
4689: igs_ca_type ct

Line 4712: FROM igs_en_su_attempt sua,

4708: sua.cal_type,
4709: sua.ci_sequence_number,
4710: sua.unit_attempt_status,
4711: uoo_id
4712: FROM igs_en_su_attempt sua,
4713: igs_ca_inst_rel cir
4714: WHERE sua.person_id = p_person_id
4715: AND sua.course_cd = p_course_cd
4716: AND sua.unit_attempt_status = 'COMPLETED'

Line 4735: l_origin_course_cd igs_en_su_attempt.course_cd%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 :=
4738: l_total_attempted_units NUMBER := 0; -- Replaced Default by :=
4739: l_set_attempted_cp NUMBER := 0; -- Replaced Default by :=

Line 4964: FROM igs_en_su_attempt sua,

4960: sua.version_number,
4961: sua.cal_type,
4962: sua.ci_sequence_number,
4963: sua.uoo_id
4964: FROM igs_en_su_attempt sua,
4965: igs_ca_inst ci_cur,
4966: igs_ca_inst_rel cir,
4967: igs_ca_inst ci,
4968: igs_ca_type ct

Line 4988: FROM igs_en_su_attempt sua,

4984: sua.version_number,
4985: sua.cal_type,
4986: sua.ci_sequence_number,
4987: sua.uoo_id
4988: FROM igs_en_su_attempt sua,
4989: igs_ca_inst_rel cir
4990: WHERE sua.person_id = p_person_id
4991: AND sua.course_cd = p_course_cd
4992: AND sua.unit_attempt_status = 'COMPLETED'