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

Line 10: ass_ind igs_en_su_attempt.no_assessment_ind%TYPE,

6: g_person_type igs_pe_typ_instances.person_type_code%TYPE;
7:
8: TYPE l_units_rec IS RECORD (
9: uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
10: ass_ind igs_en_su_attempt.no_assessment_ind%TYPE,
11: grading_schema_cd igs_en_su_attempt.grading_schema_code%TYPE,
12: gs_version_number igs_en_su_attempt. gs_version_number %TYPE,
13: override_enrolled_cp igs_en_su_attempt.override_enrolled_cp%TYPE,
14: spl_perm_step VARCHAR2(200),

Line 11: grading_schema_cd igs_en_su_attempt.grading_schema_code%TYPE,

7:
8: TYPE l_units_rec IS RECORD (
9: uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
10: ass_ind igs_en_su_attempt.no_assessment_ind%TYPE,
11: grading_schema_cd igs_en_su_attempt.grading_schema_code%TYPE,
12: gs_version_number igs_en_su_attempt. gs_version_number %TYPE,
13: override_enrolled_cp igs_en_su_attempt.override_enrolled_cp%TYPE,
14: spl_perm_step VARCHAR2(200),
15: aud_perm_step VARCHAR2(200),

Line 12: gs_version_number igs_en_su_attempt. gs_version_number %TYPE,

8: TYPE l_units_rec IS RECORD (
9: uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
10: ass_ind igs_en_su_attempt.no_assessment_ind%TYPE,
11: grading_schema_cd igs_en_su_attempt.grading_schema_code%TYPE,
12: gs_version_number igs_en_su_attempt. gs_version_number %TYPE,
13: override_enrolled_cp igs_en_su_attempt.override_enrolled_cp%TYPE,
14: spl_perm_step VARCHAR2(200),
15: aud_perm_step VARCHAR2(200),
16: wlst_step VARCHAR2(200),

Line 13: override_enrolled_cp igs_en_su_attempt.override_enrolled_cp%TYPE,

9: uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
10: ass_ind igs_en_su_attempt.no_assessment_ind%TYPE,
11: grading_schema_cd igs_en_su_attempt.grading_schema_code%TYPE,
12: gs_version_number igs_en_su_attempt. gs_version_number %TYPE,
13: override_enrolled_cp igs_en_su_attempt.override_enrolled_cp%TYPE,
14: spl_perm_step VARCHAR2(200),
15: aud_perm_step VARCHAR2(200),
16: wlst_step VARCHAR2(200),
17: create_wlst VARCHAR2(1)

Line 24: p_person_id IN igs_en_su_attempt.person_id%TYPE,

20: TYPE t_params_table IS TABLE OF l_units_rec INDEX BY BINARY_INTEGER;
21:
22:
23: FUNCTION set_deny_warn (
24: p_person_id IN igs_en_su_attempt.person_id%TYPE,
25: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
26: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
27: p_load_sequence_number IN igs_ca_inst.sequence_number%TYPE
28: )

Line 25: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

21:
22:
23: FUNCTION set_deny_warn (
24: p_person_id IN igs_en_su_attempt.person_id%TYPE,
25: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
26: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
27: p_load_sequence_number IN igs_ca_inst.sequence_number%TYPE
28: )
29: RETURN VARCHAR2 AS

Line 138: FROM igs_en_su_attempt

134:
135:
136: CURSOR c_sua_exists(cp_uoo_id NUMBER) IS
137: SELECT 'X'
138: FROM igs_en_su_attempt
139: WHERE person_id = p_person_id
140: AND course_cd = p_course_cd
141: AND uoo_id = cp_uoo_id
142: AND unit_attempt_status <> 'DROPPED';

Line 242: FROM igs_en_su_attempt

238:
239: -- cursor to check if sua record exits
240: CURSOR chk_sua_exists (cp_uoo_id NUMBER)IS
241: SELECT 'X'
242: FROM igs_en_su_attempt
243: WHERE person_id = p_person_id
244: AND course_cd = p_course_cd
245: AND uoo_id = cp_uoo_id
246: AND unit_attempt_Status <> 'DROPPED';

Line 580: CURSOR cur_chk_unit_is_sub(cp_uoo_id igs_en_su_attempt.uoo_id%TYPE)IS

576:
577:
578:
579: -- cursor to check wheter a unit is subordinate
580: CURSOR cur_chk_unit_is_sub(cp_uoo_id igs_en_su_attempt.uoo_id%TYPE)IS
581: SELECT sup_uoo_id
582: FROM igs_ps_unit_ofr_opt
583: WHERE uoo_id = cp_uoo_id
584: AND sup_uoo_id IS NOT NULL

Line 589: CURSOR cur_chk_sup_exists(cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS

585: AND relation_type = 'SUBORDINATE';
586:
587:
588: -- cursor to check whheter a unit attempt exists in particular statuses
589: CURSOR cur_chk_sup_exists(cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
590: SELECT 'X' FROM igs_en_su_attempt
591: WHERE person_id = p_person_id
592: AND course_cd = p_course_cd
593: AND uoo_id = cp_uoo_id

Line 590: SELECT 'X' FROM igs_en_su_attempt

586:
587:
588: -- cursor to check whheter a unit attempt exists in particular statuses
589: CURSOR cur_chk_sup_exists(cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
590: SELECT 'X' FROM igs_en_su_attempt
591: WHERE person_id = p_person_id
592: AND course_cd = p_course_cd
593: AND uoo_id = cp_uoo_id
594: AND unit_attempt_status IN ('UNCONFIRM','INVALID','WAITLISTED','ENROLLED');

Line 970: l_core_indicator_code igs_en_su_attempt.core_indicator_code%TYPE;

966: AND course_cd = p_course_cd
967: AND uoo_id = p_uoo_id
968: AND cart_error_flag = 'Y';
969:
970: l_core_indicator_code igs_en_su_attempt.core_indicator_code%TYPE;
971: l_person_number hz_parties.party_number%TYPE;
972: l_rowid VARCHAR2(30);
973: l_enc_message_name VARCHAR2(2000);
974: l_app_short_name VARCHAR2(100);

Line 1128: l_core_indicator_code igs_en_su_attempt.core_indicator_code%TYPE;

1124: AND course_cd = p_course_cd
1125: AND uoo_id = p_uoo_id
1126: AND cart_error_flag = 'Y';
1127:
1128: l_core_indicator_code igs_en_su_attempt.core_indicator_code%TYPE;
1129: l_person_number hz_parties.party_number%TYPE;
1130: l_rowid VARCHAR2(30);
1131: l_enc_message_name VARCHAR2(2000);
1132: l_app_short_name VARCHAR2(100);

Line 1470: FROM IGS_EN_SU_ATTEMPT

1466: --cursor to check if unit is preenrolled
1467:
1468: CURSOR cur_is_unit_preenroled IS
1469: SELECT 'Y'
1470: FROM IGS_EN_SU_ATTEMPT
1471: WHERE person_id = p_person_id
1472: AND course_cd = p_course_cd
1473: AND uoo_id = p_uoo_id ;
1474:

Line 1476: l_sup_uoo_id igs_en_su_attempt.uoo_id%TYPE;

1472: AND course_cd = p_course_cd
1473: AND uoo_id = p_uoo_id ;
1474:
1475:
1476: l_sup_uoo_id igs_en_su_attempt.uoo_id%TYPE;
1477: l_unit_sec VARCHAR2(50);
1478: l_message_icon VARCHAR2(1);
1479: l_message_name VARCHAR2(4000);
1480: l_message_action VARCHAR2(100);

Line 1827: l_core_indicator_code igs_en_su_attempt.core_indicator_code%TYPE;

1823: WHERE uoo_id = cp_uoo_id
1824: AND relation_type = 'SUBORDINATE';
1825:
1826: l_unit_sec VARCHAR2(50);
1827: l_core_indicator_code igs_en_su_attempt.core_indicator_code%TYPE;
1828: l_sup_uoo_id igs_en_su_attempt.uoo_id%TYPE;
1829: l_return_status VARCHAR2(100);
1830: l_enc_message_name VARCHAR2(2000);
1831: l_app_short_name VARCHAR2(100);

Line 1828: l_sup_uoo_id igs_en_su_attempt.uoo_id%TYPE;

1824: AND relation_type = 'SUBORDINATE';
1825:
1826: l_unit_sec VARCHAR2(50);
1827: l_core_indicator_code igs_en_su_attempt.core_indicator_code%TYPE;
1828: l_sup_uoo_id igs_en_su_attempt.uoo_id%TYPE;
1829: l_return_status VARCHAR2(100);
1830: l_enc_message_name VARCHAR2(2000);
1831: l_app_short_name VARCHAR2(100);
1832: l_msg_index NUMBER;

Line 2271: FROM igs_en_su_attempt

2267:
2268: -- cursor which checks wheter a unit attempt exists
2269: CURSOR c_sua_exists(cp_uoo_id IGS_PS_UNIT_OFR_OPT.sup_uoo_id%TYPE) IS
2270: SELECT 'X'
2271: FROM igs_en_su_attempt
2272: WHERE person_id = p_person_id
2273: AND course_cd = p_course_cd
2274: AND uoo_id = cp_uoo_id
2275: AND unit_attempt_status NOT IN ('DROPPED');

Line 2288: l_ass_ind igs_en_su_attempt.no_assessment_ind%TYPE;

2284: l_uoo_ids VARCHAR2(10000);
2285: l_ps_units VARCHAR2(3000);
2286: l_temp VARCHAR2(200);
2287: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
2288: l_ass_ind igs_en_su_attempt.no_assessment_ind%TYPE;
2289: l_gradsch_cd igs_en_su_attempt.grading_schema_code%TYPE;
2290: l_gs_version_number NUMBER;
2291: l_override_cp NUMBER;
2292: lunit VARCHAR2(500);

Line 2289: l_gradsch_cd igs_en_su_attempt.grading_schema_code%TYPE;

2285: l_ps_units VARCHAR2(3000);
2286: l_temp VARCHAR2(200);
2287: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
2288: l_ass_ind igs_en_su_attempt.no_assessment_ind%TYPE;
2289: l_gradsch_cd igs_en_su_attempt.grading_schema_code%TYPE;
2290: l_gs_version_number NUMBER;
2291: l_override_cp NUMBER;
2292: lunit VARCHAR2(500);
2293: l_rel_type IGS_PS_UNIT_OFR_OPT.relation_type%TYPE;

Line 2751: FROM igs_en_su_attempt

2747:
2748: -- cursor to get the unit code and unit class
2749: CURSOR c_sua_exists(cp_uoo_id IGS_PS_UNIT_OFR_OPT.sup_uoo_id%TYPE) IS
2750: SELECT unit_cd||'/'||unit_class
2751: FROM igs_en_su_attempt
2752: WHERE person_id = p_person_id
2753: AND course_cd = p_course_cd
2754: AND uoo_id = cp_uoo_id
2755: AND unit_attempt_status <> 'DROPPED';

Line 2758: CURSOR c_unit_dtls (cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS

2754: AND uoo_id = cp_uoo_id
2755: AND unit_attempt_status <> 'DROPPED';
2756:
2757: -- cursor to get the unit details
2758: CURSOR c_unit_dtls (cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
2759: SELECT ofr.unit_cd, ofr.version_number, ofr.cal_type, ofr.ci_sequence_number,
2760: ofr.location_cd, ofr.unit_class, ca.start_dt, ca.end_dt
2761: FROM igs_ps_unit_ofr_opt ofr, igs_ca_inst_all ca
2762: WHERE ofr.uoo_id = cp_uoo_id

Line 2766: CURSOR c_sua(cp_person_id igs_en_su_attempt_all.person_id%TYPE,

2762: WHERE ofr.uoo_id = cp_uoo_id
2763: AND ofr.cal_type = ca.cal_type
2764: AND ofr.ci_sequence_number = ca.sequence_number;
2765:
2766: CURSOR c_sua(cp_person_id igs_en_su_attempt_all.person_id%TYPE,
2767: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,
2768: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS
2769: SELECT sua.rowid
2770: FROM IGS_EN_SU_ATTEMPT_ALL SUA

Line 2767: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,

2763: AND ofr.cal_type = ca.cal_type
2764: AND ofr.ci_sequence_number = ca.sequence_number;
2765:
2766: CURSOR c_sua(cp_person_id igs_en_su_attempt_all.person_id%TYPE,
2767: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,
2768: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS
2769: SELECT sua.rowid
2770: FROM IGS_EN_SU_ATTEMPT_ALL SUA
2771: WHERE sua.person_id=cp_person_id

Line 2768: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS

2764: AND ofr.ci_sequence_number = ca.sequence_number;
2765:
2766: CURSOR c_sua(cp_person_id igs_en_su_attempt_all.person_id%TYPE,
2767: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,
2768: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS
2769: SELECT sua.rowid
2770: FROM IGS_EN_SU_ATTEMPT_ALL SUA
2771: WHERE sua.person_id=cp_person_id
2772: AND sua.course_cd=cp_course_cd

Line 2770: FROM IGS_EN_SU_ATTEMPT_ALL SUA

2766: CURSOR c_sua(cp_person_id igs_en_su_attempt_all.person_id%TYPE,
2767: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,
2768: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS
2769: SELECT sua.rowid
2770: FROM IGS_EN_SU_ATTEMPT_ALL SUA
2771: WHERE sua.person_id=cp_person_id
2772: AND sua.course_cd=cp_course_cd
2773: AND sua.uoo_id=cp_uoo_id
2774: AND sua.unit_attempt_status='DROPPED';

Line 2904: INSERT INTO IGS_EN_SU_ATTEMPT_ALL (

2900: --unit section was not attempted and dropped, so create new unit attempt
2901: IF c_sua%NOTFOUND THEN
2902: CLOSE c_sua;
2903:
2904: INSERT INTO IGS_EN_SU_ATTEMPT_ALL (
2905: PERSON_ID,
2906: COURSE_CD,
2907: UNIT_CD,
2908: VERSION_NUMBER,

Line 3068: UPDATE IGS_EN_SU_ATTEMPT_ALL SET

3064: ELSE
3065: -- unit attempt was attempted and dropped previously, so update that record
3066: CLOSE c_sua;
3067:
3068: UPDATE IGS_EN_SU_ATTEMPT_ALL SET
3069: VERSION_NUMBER =l_unit_dtsl_rec.version_number,
3070: LOCATION_CD = l_unit_dtsl_rec.location_cd,
3071: UNIT_CLASS = l_unit_dtsl_rec.unit_class,
3072: CI_START_DT = l_unit_dtsl_rec.start_dt,

Line 3295: --bdeviset 14-NOV-2005 Added cursor c_sua and update igs_en_su_attempt all for bug# 4723960

3291: -- Purpose : makes unit abd program step validations for the passed units along with
3292: -- preenroll units (units that are added by admin through preenrollment job or through admin self-service)
3293: --Change History:
3294: --Who When What
3295: --bdeviset 14-NOV-2005 Added cursor c_sua and update igs_en_su_attempt all for bug# 4723960
3296: -- ckasu 27-NOV-2005 modified create_planned_sua by changing direct DML insert,update with
3297: -- INSERT_ROW,UPDATE_ROW of SUA TBH as a part of bug#4666102
3298: -------------------------------------------------------------------------------------------
3299:

Line 3301: CURSOR c_get_unit_dtls (cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS

3297: -- INSERT_ROW,UPDATE_ROW of SUA TBH as a part of bug#4666102
3298: -------------------------------------------------------------------------------------------
3299:
3300: -- cursor to fetch the unit details
3301: CURSOR c_get_unit_dtls (cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
3302: SELECT ofr.unit_cd, ofr.version_number, ofr.cal_type, ofr.ci_sequence_number,
3303: ofr.location_cd, ofr.unit_class, ca.start_dt, ca.end_dt
3304: FROM igs_ps_unit_ofr_opt ofr, igs_ca_inst_all ca
3305: WHERE ofr.uoo_id = cp_uoo_id

Line 3313: FROM igs_en_su_attempt sua,igs_ca_teach_to_load_v load

3309:
3310: -- cursor to fetch preenroll units
3311: CURSOR c_get_preenr_units IS
3312: SELECT DISTINCT sua.uoo_id, sua.sup_unit_cd, no_assessment_ind,unit_Attempt_Status,ss_source_ind
3313: FROM igs_en_su_attempt sua,igs_ca_teach_to_load_v load
3314: WHERE sua.person_id = p_person_id
3315: AND sua.course_cd = p_course_cd
3316: AND sua.unit_attempt_status = 'UNCONFIRM'
3317: AND NVL(sua.ss_source_ind ,'N') <> 'S'

Line 3325: CURSOR c_get_sua_dtls (cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS

3321: AND load_ci_sequence_number = p_load_sequence_number
3322: ORDER BY sua.sup_unit_cd DESC;
3323:
3324: -- Get the details of unit attempt
3325: CURSOR c_get_sua_dtls (cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
3326: SELECT sua.*
3327: FROM igs_en_su_attempt sua
3328: WHERE person_id = p_person_id
3329: AND course_cd = p_course_cd

Line 3327: FROM igs_en_su_attempt sua

3323:
3324: -- Get the details of unit attempt
3325: CURSOR c_get_sua_dtls (cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
3326: SELECT sua.*
3327: FROM igs_en_su_attempt sua
3328: WHERE person_id = p_person_id
3329: AND course_cd = p_course_cd
3330: AND uoo_id = cp_uoo_id;
3331:

Line 3338: l_core_indicator_code igs_en_su_attempt.core_indicator_code%TYPE;

3334: PRAGMA EXCEPTION_INIT(NO_AUSL_RECORD_FOUND , -20010);
3335:
3336: l_rowid VARCHAR2(100);
3337: l_unit_rec c_get_unit_dtls%ROWTYPE;
3338: l_core_indicator_code igs_en_su_attempt.core_indicator_code%TYPE;
3339: l_combined_unit_params t_params_table;
3340: l_return_status VARCHAR2(20);
3341: v_comb_index BINARY_INTEGER := 1;
3342: l_uoo_id igs_en_su_attempt.uoo_id%TYPE;

Line 3342: l_uoo_id igs_en_su_attempt.uoo_id%TYPE;

3338: l_core_indicator_code igs_en_su_attempt.core_indicator_code%TYPE;
3339: l_combined_unit_params t_params_table;
3340: l_return_status VARCHAR2(20);
3341: v_comb_index BINARY_INTEGER := 1;
3342: l_uoo_id igs_en_su_attempt.uoo_id%TYPE;
3343: l_sup_unit_cd igs_en_su_attempt.sup_unit_cd%TYPE;
3344: l_message_name VARCHAR2(4000);
3345: l_deny_warn VARCHAR2(30);
3346: l_deny_warn_max_cp VARCHAR2(10);

Line 3343: l_sup_unit_cd igs_en_su_attempt.sup_unit_cd%TYPE;

3339: l_combined_unit_params t_params_table;
3340: l_return_status VARCHAR2(20);
3341: v_comb_index BINARY_INTEGER := 1;
3342: l_uoo_id igs_en_su_attempt.uoo_id%TYPE;
3343: l_sup_unit_cd igs_en_su_attempt.sup_unit_cd%TYPE;
3344: l_message_name VARCHAR2(4000);
3345: l_deny_warn VARCHAR2(30);
3346: l_deny_warn_max_cp VARCHAR2(10);
3347: l_deny_warn_min_cp VARCHAR2(10);

Line 3348: l_sua_rec igs_en_su_attempt%ROWTYPE;

3344: l_message_name VARCHAR2(4000);
3345: l_deny_warn VARCHAR2(30);
3346: l_deny_warn_max_cp VARCHAR2(10);
3347: l_deny_warn_min_cp VARCHAR2(10);
3348: l_sua_rec igs_en_su_attempt%ROWTYPE;
3349: l_credit_points NUMBER;
3350: l_min_credit_point NUMBER;
3351: l_enc_message_name VARCHAR2(2000);
3352: l_app_short_name VARCHAR2(100);

Line 3358: l_no_ass_ind igs_en_su_attempt.no_assessment_ind%TYPE;

3354: l_unit_sec VARCHAR2(100);
3355: l_max_cp_fail BOOLEAN;
3356: l_min_cp_fail BOOLEAN;
3357: l_create_wlst VARCHAR2(1);
3358: l_no_ass_ind igs_en_su_attempt.no_assessment_ind%TYPE;
3359: x_OVERRIDE_ACHIEVABLE_CP NUMBER;
3360: x_OVERRIDE_ENROLLED_CP NUMBER;
3361: lv_message_name VARCHAR2(100);
3362: lv_teach_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE;

Line 3539: IGS_EN_SU_ATTEMPT_PKG.INSERT_ROW (

3535: END IF;
3536: END LOOP;
3537:
3538: l_message_tokens := NULL;
3539: IGS_EN_SU_ATTEMPT_PKG.INSERT_ROW (
3540: X_ROWID => l_rowid ,
3541: X_PERSON_ID => p_person_id ,
3542: X_COURSE_CD => p_course_cd ,
3543: X_UNIT_CD => l_unit_rec.unit_cd ,

Line 3834: IGS_EN_SU_ATTEMPT_PKG.UPDATE_ROW(

3830: IF c_get_sua_dtls%FOUND THEN
3831: CLOSE c_get_sua_dtls;
3832:
3833: -- enroll the unit attempts
3834: IGS_EN_SU_ATTEMPT_PKG.UPDATE_ROW(
3835: X_ROWID => l_sua_rec.row_id ,
3836: X_PERSON_ID => l_sua_rec.person_id ,
3837: X_COURSE_CD => l_sua_rec.course_cd ,
3838: X_UNIT_CD => l_sua_rec.unit_cd ,

Line 3951: IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop := NULL;

3947: END IF; -- IF c_get_sua_dtls%FOUND
3948: EXCEPTION
3949:
3950: WHEN NO_AUSL_RECORD_FOUND THEN
3951: IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop := NULL;
3952: p_message := 'IGS_SS_CANTDET_ADM_UNT_STATUS';
3953: p_return_status := 'FALSE';
3954: RETURN;
3955:

Line 4032: IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop := NULL;

4028:
4029: EXCEPTION
4030:
4031: WHEN NO_AUSL_RECORD_FOUND THEN
4032: IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop := NULL;
4033: p_message := 'IGS_SS_CANTDET_ADM_UNT_STATUS';
4034: p_return_status := 'FALSE';
4035: RETURN;
4036:

Line 4091: IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop := NULL;

4087: END IF;
4088:
4089: EXCEPTION
4090: WHEN OTHERS THEN
4091: IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop := NULL;
4092: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
4093: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.create_planned_sua :',SQLERRM);
4094: END IF;
4095: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

Line 4131: CURSOR chk_sua_exists (cp_uoo_id igs_en_su_attempt.uoo_id%TYPE)IS

4127:
4128: -------------------------------------------------------------------------------------------
4129:
4130: -- cursor to check wheter a unit attempt exists
4131: CURSOR chk_sua_exists (cp_uoo_id igs_en_su_attempt.uoo_id%TYPE)IS
4132: SELECT 'X'
4133: FROM igs_en_su_attempt
4134: WHERE person_id = p_person_id
4135: AND course_cd = p_course_cd

Line 4133: FROM igs_en_su_attempt

4129:
4130: -- cursor to check wheter a unit attempt exists
4131: CURSOR chk_sua_exists (cp_uoo_id igs_en_su_attempt.uoo_id%TYPE)IS
4132: SELECT 'X'
4133: FROM igs_en_su_attempt
4134: WHERE person_id = p_person_id
4135: AND course_cd = p_course_cd
4136: AND uoo_id = cp_uoo_id
4137: AND unit_attempt_status <> 'DROPPED';

Line 4378: FROM igs_en_su_attempt sua, igs_ca_teach_to_load_v lod

4374:
4375: -- cursor to fetch the swap units
4376: CURSOR cur_swap_units IS
4377: SELECT DISTINCT sua.uoo_id, sua.sup_unit_cd, sua.no_assessment_ind
4378: FROM igs_en_su_attempt sua, igs_ca_teach_to_load_v lod
4379: WHERE sua.person_id = p_person_Id
4380: AND sua.course_cd = p_course_cd
4381: AND sua.unit_attempt_status = 'UNCONFIRM'
4382: AND lod.teach_cal_type = sua.cal_type

Line 4392: FROM igs_en_su_attempt sua, igs_ca_teach_to_load_v lod

4388:
4389: -- cursor to get the cart units
4390: CURSOR cur_cart_units IS
4391: SELECT DISTINCT sua.uoo_id, sua.sup_unit_cd
4392: FROM igs_en_su_attempt sua, igs_ca_teach_to_load_v lod
4393: WHERE sua.person_id = p_person_Id
4394: AND sua.course_cd = p_course_cd
4395: AND sua.unit_attempt_status = 'UNCONFIRM'
4396: AND sua.SS_SOURCE_IND <> 'S'

Line 4404: CURSOR chk_unconfirm_sua (cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS

4400: AND lod.load_ci_sequence_number = p_load_sequence_number
4401: ORDER BY sua.sup_unit_cd DESC;
4402:
4403: -- To get student unit attempt and unit code
4404: CURSOR chk_unconfirm_sua (cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
4405: SELECT unit_attempt_status,unit_cd,version_number
4406: FROM igs_en_su_attempt
4407: WHERE person_id = p_person_id
4408: AND course_cd = p_course_cd

Line 4406: FROM igs_en_su_attempt

4402:
4403: -- To get student unit attempt and unit code
4404: CURSOR chk_unconfirm_sua (cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
4405: SELECT unit_attempt_status,unit_cd,version_number
4406: FROM igs_en_su_attempt
4407: WHERE person_id = p_person_id
4408: AND course_cd = p_course_cd
4409: AND uoo_id = cp_uoo_id;
4410:

Line 4420: l_uoo_id igs_en_su_attempt.uoo_id%TYPE;

4416:
4417: l_swap_unit_params t_params_table;
4418:
4419: l_uoo_ids VARCHAR2(2000);
4420: l_uoo_id igs_en_su_attempt.uoo_id%TYPE;
4421: l_deny_warn_coreq VARCHAR2(10);
4422: l_deny_warn_prereq VARCHAR2(10);
4423: l_deny_warn_min_cp VARCHAR2(10);
4424: l_message_icon VARCHAR2(30);

Line 4425: l_sua_status igs_en_su_attempt.unit_attempt_status%TYPE;

4421: l_deny_warn_coreq VARCHAR2(10);
4422: l_deny_warn_prereq VARCHAR2(10);
4423: l_deny_warn_min_cp VARCHAR2(10);
4424: l_message_icon VARCHAR2(30);
4425: l_sua_status igs_en_su_attempt.unit_attempt_status%TYPE;
4426: l_message_name VARCHAR2(4000);
4427: l_app_short_name VARCHAR2(100);
4428: l_msg_index NUMBER;
4429: l_unit_sec VARCHAR2(100);

Line 4432: l_unit_ver igs_en_su_attempt.version_number%TYPE;

4428: l_msg_index NUMBER;
4429: l_unit_sec VARCHAR2(100);
4430: l_enc_message_name VARCHAR2(2000);
4431: l_succ_new_uoo_ids VARCHAR2(1000);
4432: l_unit_ver igs_en_su_attempt.version_number%TYPE;
4433: l_unit_cd igs_en_su_attempt.unit_cd%TYPE;
4434: l_return_status VARCHAR2(30);
4435: l_deny_warn VARCHAR2(30);
4436: l_message_for VARCHAR2(100);

Line 4433: l_unit_cd igs_en_su_attempt.unit_cd%TYPE;

4429: l_unit_sec VARCHAR2(100);
4430: l_enc_message_name VARCHAR2(2000);
4431: l_succ_new_uoo_ids VARCHAR2(1000);
4432: l_unit_ver igs_en_su_attempt.version_number%TYPE;
4433: l_unit_cd igs_en_su_attempt.unit_cd%TYPE;
4434: l_return_status VARCHAR2(30);
4435: l_deny_warn VARCHAR2(30);
4436: l_message_for VARCHAR2(100);
4437:

Line 4968: FROM igs_en_su_attempt sua, igs_ca_load_to_teach_v load

4964: -- modified this cursor as a part of bug#5036954.
4965:
4966: OPEN c_get_swap_units FOR
4967: 'SELECT SUA.uoo_id
4968: FROM igs_en_su_attempt sua, igs_ca_load_to_teach_v load
4969: WHERE person_id = :p_person_id
4970: AND course_cd = :p_course_cd
4971: AND unit_attempt_status IN (''ENROLLED'',''INVALID'')
4972: AND cal_type = teach_cal_type

Line 5368: IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop := 'PLAN';

5364: IF p_calling_obj = 'PLAN' THEN
5365:
5366: SAVEPOINT sp_plan_sua;
5367: l_return_status := NULL;
5368: IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop := 'PLAN';
5369: create_planned_sua( p_person_id,
5370: p_course_cd,
5371: p_course_version,
5372: p_load_cal_type,

Line 5381: IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop := NULL;

5377: l_enr_comm,
5378: p_message,
5379: l_return_status,
5380: p_calling_obj);
5381: IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop := NULL;
5382: ROLLBACK TO sp_plan_sua; -- needs to be rollbacked as this is just for making validations
5383:
5384: IF l_return_status = 'FALSE' THEN
5385: p_return_status := 'FALSE';

Line 5611: IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop := NULL;

5607: EXCEPTION
5608:
5609: WHEN OTHERS THEN
5610: igs_en_add_units_api.g_ss_session_id := NULL;
5611: IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop := NULL;
5612: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
5613: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.add_selected_units :',SQLERRM);
5614: END IF;
5615: ROLLBACK TO sp_add_units_api;