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_IN_GEN_001 dependencies on IGS_PS_UNIT_VER

Line 9: column in igs_ps_unit_ver table. PSP integration build #3052433

5: Who When What
6: jbegum 25-Jun-2003 BUG#2930935
7: Modified local procedure INQP_GET_PRG_CP
8: rvivekan 09-sep-2003 Modified the behaviour of repeatable_ind
9: column in igs_ps_unit_ver table. PSP integration build #3052433
10: -- rnirwani 13-Sep-2004 changed cursor c_sci, procedure inqp_get_sci, inqp_get_sca_status to not consider logically
11: -- deleted records and also to avoid un-approved intermission records. Bug# 3885804
12:
13: */

Line 674: IGS_PS_UNIT_VER uv ,

670: )
671: )
672: )
673: FROM IGS_EN_SU_ATTEMPT sua,
674: IGS_PS_UNIT_VER uv ,
675: IGS_PS_USEC_CPS cps
676: WHERE sua.person_id = p_person_id AND
677: sua.course_cd = p_course_cd AND
678: sua.unit_attempt_status = cst_enrolled AND

Line 993: | rvivekan 09-sep-2003 Modified the behaviour of repeatable_ind column in igs_ps_unit_ver table. PSP integration build #3052433

989: | Who When What
990: |
991: | knaraset 09-May-03 Modified cursors c_sua and c_sua1 and passed uoo_id in call IGS_AS_GEN_003.ASSP_GET_SUA_OUTCOME,
992: | as part of MUS build bug 2829262
993: | rvivekan 09-sep-2003 Modified the behaviour of repeatable_ind column in igs_ps_unit_ver table. PSP integration build #3052433
994: |
995: */
996: gv_other_detail VARCHAR2(255);
997: BEGIN -- inqp_get_sua_achvd

Line 1009: v_repeatable_ind IGS_PS_UNIT_VER.repeatable_ind%TYPE;

1005: cst_duplicate CONSTANT VARCHAR2(12) := 'DUPLICATE';
1006: cst_pass CONSTANT VARCHAR2(7) := 'PASS';
1007: v_override_achievable_cp IGS_EN_SU_ATTEMPT.override_achievable_cp%TYPE;
1008: v_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
1009: v_repeatable_ind IGS_PS_UNIT_VER.repeatable_ind%TYPE;
1010: v_achievable_credit_points IGS_PS_UNIT_VER.achievable_credit_points%TYPE;
1011: v_enrolled_credit_points IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;
1012: v_result_found BOOLEAN DEFAULT FALSE;
1013: v_outcome_dt DATE;

Line 1010: v_achievable_credit_points IGS_PS_UNIT_VER.achievable_credit_points%TYPE;

1006: cst_pass CONSTANT VARCHAR2(7) := 'PASS';
1007: v_override_achievable_cp IGS_EN_SU_ATTEMPT.override_achievable_cp%TYPE;
1008: v_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
1009: v_repeatable_ind IGS_PS_UNIT_VER.repeatable_ind%TYPE;
1010: v_achievable_credit_points IGS_PS_UNIT_VER.achievable_credit_points%TYPE;
1011: v_enrolled_credit_points IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;
1012: v_result_found BOOLEAN DEFAULT FALSE;
1013: v_outcome_dt DATE;
1014: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;

Line 1011: v_enrolled_credit_points IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;

1007: v_override_achievable_cp IGS_EN_SU_ATTEMPT.override_achievable_cp%TYPE;
1008: v_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
1009: v_repeatable_ind IGS_PS_UNIT_VER.repeatable_ind%TYPE;
1010: v_achievable_credit_points IGS_PS_UNIT_VER.achievable_credit_points%TYPE;
1011: v_enrolled_credit_points IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;
1012: v_result_found BOOLEAN DEFAULT FALSE;
1013: v_outcome_dt DATE;
1014: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
1015: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;

Line 1052: FROM IGS_PS_UNIT_VER uv

1048: cst_duplicate) AND
1049: TRUNC(sua.ci_end_dt) < TRUNC(cp_ci_end_dt);
1050: CURSOR c_uv IS
1051: SELECT uv.repeatable_ind
1052: FROM IGS_PS_UNIT_VER uv
1053: WHERE uv.unit_cd = p_unit_cd AND
1054: uv.version_number = p_version_number;
1055: BEGIN
1056: -- If any of the unit atempt details are null then select from the