APPS.IGS_AV_GEN_001 dependencies on IGS_PS_UNIT_VER

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

28: records processing.Also changes the percentage logic as mentioned in the dld Acedemic
29: Records Maintanence Build(bug no:1960126)
30: knaraset 02-May-03 Modified the function advp_upd_sua_advstnd to pass uoo_id to internal function enrpl_delete_sua_recs
31: as part of MUS build bug 2829262
32: rvivekan 09-sep-2003 Modified the behaviour of repeatable_ind column in igs_ps_unit_ver table. PSP integration build #3052433
33: stutta 27-Oct-2003 Modified funcion advp_upd_sua_advstnd by removing calls to functions IGS_EN_VAL_SUA.enrp_val_sca_supunit,
34: IGS_EN_VAL_SUA.enrp_val_sca_subunit as part of build #3052438
35: nalkumar 10-Dec-2003 Bug# 3270446 RECR50 Build; Obsoleted the IGS_AV_STND_UNIT.CREDIT_PERCENTAGE column.
36: swaghmar 15-Jun-2005 Bug# 4377816. Changed the cursor queries to pick party_number from igs_pe_hz_parties instead of hz_parties

Line 245: FROM igs_av_stnd_unit asu,igs_ps_unit_ver puv WHERE

241: CURSOR c_adv_cp_sum IS
242: SELECT SUM(NVL(asu.achievable_credit_points,0)) advance_standing_credits,
243: SUM(NVL(puv.achievable_Credit_points,puv.enrolled_Credit_points)) enrolled_cp ,
244: asu.unit_cd,asu.version_number
245: FROM igs_av_stnd_unit asu,igs_ps_unit_ver puv WHERE
246: asu.person_id = p_person_id AND
247: asu.as_course_cd = p_course_cd AND
248: puv.unit_cd = asu.unit_cd AND
249: puv.version_number = asu.version_number AND

Line 258: FROM igs_av_stnd_unit asu,igs_ps_unit_ver puv

254:
255: CURSOR c_adv_cp_per(cp_unit_cd igs_av_stnd_unit.unit_cd%TYPE,
256: cp_version_number igs_av_stnd_unit.version_number%TYPE) IS
257: SELECT NVL(puv.achievable_Credit_points,puv.enrolled_Credit_points) enrolled_credits
258: FROM igs_av_stnd_unit asu,igs_ps_unit_ver puv
259: WHERE asu.person_id = p_person_id
260: AND asu.as_course_cd = p_course_cd
261: AND asu.unit_cd = cp_unit_cd
262: AND asu.version_number = cp_version_number

Line 471: igs_ps_unit_ver_all uv

467: asu.as_version_number version_number,
468: asu.exemption_institution_cd exemption_institution_cd,
469: uv.achievable_credit_points credit
470: FROM igs_av_stnd_unit_all asu,
471: igs_ps_unit_ver_all uv
472: WHERE asu.unit_cd = uv.unit_cd
473: AND asu.version_number = uv.version_number
474: AND asu.s_adv_stnd_recognition_type = 'CREDIT'
475: AND asu.s_adv_stnd_granting_status = 'GRANTED'

Line 1374: IGS_PS_UNIT_VER uv

1370: sua.enrolled_dt,
1371: uv.repeatable_ind,
1372: sua.uoo_id
1373: FROM IGS_EN_SU_ATTEMPT sua,
1374: IGS_PS_UNIT_VER uv
1375: WHERE sua.person_id = cp_person_id AND
1376: sua.course_cd = cp_course_cd AND
1377: sua.unit_cd = cp_unit_cd AND
1378: sua.version_number = cp_version_number AND

Line 1436: gv_repeatable_ind IGS_PS_UNIT_VER.repeatable_ind%TYPE;

1432: gv_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE;
1433: gv_ci_start_dt IGS_EN_SU_ATTEMPT.ci_start_dt%TYPE;
1434: gv_enrolled_dt IGS_EN_SU_ATTEMPT.enrolled_dt%TYPE;
1435: gv_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
1436: gv_repeatable_ind IGS_PS_UNIT_VER.repeatable_ind%TYPE;
1437: gv_census_dt IGS_CA_DA_INST_V.alias_val%TYPE;
1438: gv_message_num VARCHAR2(30);
1439: gv_message_num2 VARCHAR2(30);
1440: gv_sub_unit BOOLEAN;

Line 2048: cp_unit_cd igs_ps_unit_ver.unit_cd%TYPE,

2044: --
2045: -- Cursor to select all the Unit Attempts of the Student.
2046: --
2047: CURSOR cur_student_attempts (
2048: cp_unit_cd igs_ps_unit_ver.unit_cd%TYPE,
2049: cp_version_number igs_ps_unit_ver.version_number%TYPE
2050: ) IS
2051: SELECT 'X'
2052: FROM igs_en_su_attempt

Line 2049: cp_version_number igs_ps_unit_ver.version_number%TYPE

2045: -- Cursor to select all the Unit Attempts of the Student.
2046: --
2047: CURSOR cur_student_attempts (
2048: cp_unit_cd igs_ps_unit_ver.unit_cd%TYPE,
2049: cp_version_number igs_ps_unit_ver.version_number%TYPE
2050: ) IS
2051: SELECT 'X'
2052: FROM igs_en_su_attempt
2053: WHERE person_id = p_person_id

Line 2059: FROM igs_ps_unit_ver

2055: OR (unit_attempt_status = 'WAITLISTED' AND FND_PROFILE.VALUE('IGS_EN_VAL_WLST') ='Y'))
2056: AND (unit_cd, version_number) IN
2057: (SELECT unit_cd,
2058: version_number
2059: FROM igs_ps_unit_ver
2060: WHERE (unit_cd = cp_unit_cd AND version_number = cp_version_number)
2061: OR rpt_fmly_id =
2062: ( SELECT psu.rpt_fmly_id
2063: FROM igs_ps_unit_ver psu,

Line 2063: FROM igs_ps_unit_ver psu,

2059: FROM igs_ps_unit_ver
2060: WHERE (unit_cd = cp_unit_cd AND version_number = cp_version_number)
2061: OR rpt_fmly_id =
2062: ( SELECT psu.rpt_fmly_id
2063: FROM igs_ps_unit_ver psu,
2064: igs_ps_rpt_fmly rep
2065: WHERE psu.unit_cd = cp_unit_cd
2066: AND psu.version_number = cp_version_number
2067: AND psu.rpt_fmly_id = rep.rpt_fmly_id

Line 2072: CURSOR cur_unit_repeat_for_cp(cp_unit_cd igs_ps_unit_ver.unit_cd%TYPE,

2068: AND NVL(rep.closed_ind,'N') = 'N' ));
2069: --
2070: -- Cursor to find if the unit version is repeatable
2071: --
2072: CURSOR cur_unit_repeat_for_cp(cp_unit_cd igs_ps_unit_ver.unit_cd%TYPE,
2073: cp_version_number igs_ps_unit_ver.version_number%TYPE) IS
2074: SELECT repeatable_ind
2075: FROM igs_ps_unit_ver
2076: WHERE unit_cd = cp_unit_cd

Line 2073: cp_version_number igs_ps_unit_ver.version_number%TYPE) IS

2069: --
2070: -- Cursor to find if the unit version is repeatable
2071: --
2072: CURSOR cur_unit_repeat_for_cp(cp_unit_cd igs_ps_unit_ver.unit_cd%TYPE,
2073: cp_version_number igs_ps_unit_ver.version_number%TYPE) IS
2074: SELECT repeatable_ind
2075: FROM igs_ps_unit_ver
2076: WHERE unit_cd = cp_unit_cd
2077: AND version_number = cp_version_number;

Line 2075: FROM igs_ps_unit_ver

2071: --
2072: CURSOR cur_unit_repeat_for_cp(cp_unit_cd igs_ps_unit_ver.unit_cd%TYPE,
2073: cp_version_number igs_ps_unit_ver.version_number%TYPE) IS
2074: SELECT repeatable_ind
2075: FROM igs_ps_unit_ver
2076: WHERE unit_cd = cp_unit_cd
2077: AND version_number = cp_version_number;
2078:
2079: -- sepalani 22-Mar-2006 Bug# 5104563