[Home] [Help]
157: new_references.alternative_title := x_alternative_title;
158: -- As part of ENCR013 DLD
159: IF p_action = 'INSERT' THEN
160: -- If the user is override the Value then don't populate the default value
161: new_references.override_enrolled_cp := NVL(IGS_EN_GEN_015.enrp_get_appr_cr_pt(x_person_id,x_uoo_id), x_override_enrolled_cp);
162: -- Modified as a part of EN317 build.
163: new_references.override_achievable_cp := NVL( IGS_EN_GEN_015.enrp_get_appr_cr_pt(x_person_id,x_uoo_id),x_override_achievable_cp);
164: ELSE
165: new_references.override_enrolled_cp := x_override_enrolled_cp;
159: IF p_action = 'INSERT' THEN
160: -- If the user is override the Value then don't populate the default value
161: new_references.override_enrolled_cp := NVL(IGS_EN_GEN_015.enrp_get_appr_cr_pt(x_person_id,x_uoo_id), x_override_enrolled_cp);
162: -- Modified as a part of EN317 build.
163: new_references.override_achievable_cp := NVL( IGS_EN_GEN_015.enrp_get_appr_cr_pt(x_person_id,x_uoo_id),x_override_achievable_cp);
164: ELSE
165: new_references.override_enrolled_cp := x_override_enrolled_cp;
166: new_references.override_achievable_cp := x_override_achievable_cp;
167: END IF;
1007: (new_references.override_eftsu IS NOT NULL AND
1008: (old_references.override_eftsu IS NULL OR
1009: old_references.override_eftsu <> new_references.override_eftsu)))
1010: THEN
1011: IF IGS_EN_GEN_015.enrp_get_appr_cr_pt(new_references.person_id,new_references.uoo_id) IS NULL AND
1012: IGS_EN_VAL_SUA.enrp_val_sua_ovrd_cp(
1013: new_references.unit_cd,
1014: new_references.version_number,
1015: new_references.override_enrolled_cp,
2152: X_SS_SOURCE_IND IN VARCHAR2
2153: ) AS
2154: -------------------------------------------------------------------------------------
2155: --who when what
2156: --smadathi 25-jul-2001 Call to Igs_En_Gen_015.validation_step_is_overridden added
2157: -- to check for unit section status, if it is CLOSED, check whether
2158: -- that has been overriden or not
2159: --kkillams 27-Mar-03 Modified usec_cur Cursor, replaced * with unit_section_status
2160: -- w.r.t. bug 2749648
2308: -- Also display error if it is PLANNED or CANCELLED
2309: --added on 25-jul-2001 by smadathi
2310:
2311: -- removed the closed section override code added by smadathi
2312: -- this will now be checked in IGS_EN_GEN_015.get_usec_status
2313: -- amuthu 02-Jul-2002
2314:
2315: IF (USEC_CUR_ROW.UNIT_SECTION_STATUS IN ('CANCELLED','PLANNED','NOT_OFFERED') ) THEN
2316: FND_MESSAGE.SET_NAME('IGS','IGS_EN_SS_CANNOT_WAITLIST');
2436: -- already exist, when a student enrolls or waitlists
2437: -- for a unit. Part of Term Records Build
2438: -- vkarthik 13-Feb-04 Waitlist position re-sequencing logic was not present
2439: -- in 'Insert' action, added as part bug 3433446
2440: -- stutta 10-MAR-2004 Added call to igs_en_gen_015.get_academic_cal to get acad cal
2441: -- instance and pass it to c_teach_to_load cursor. BUG# 3481403
2442: -- stutta 16-Mar-2004 Passing new parameter p_update_rec in call
2443: -- to igs_en_spa_terms_api.create_update_term_rec. Bug # 3421436
2444: -- stutta 11-Jan-2004 Modified c_teach_to_load to allow term record creation for terms