DBA Data[Home] [Help]

APPS.IGS_EN_SPI_LGCY_PUB dependencies on IGS_EN_GEN_LEGACY

Line 240: IF NOT igs_en_gen_legacy.check_institution ( p_intermiss_rec.institution_name ) THEN

236: END IF;
237:
238: -- Check for institution existance
239: IF p_intermiss_rec.institution_name IS NOT NULL THEN
240: IF NOT igs_en_gen_legacy.check_institution ( p_intermiss_rec.institution_name ) THEN
241: FND_MESSAGE.SET_NAME('IGS','IGS_EN_INST_NOT_EXIST');
242: FND_MSG_PUB.ADD;
243: l_valid_db_constr := FALSE;
244: END IF;

Line 297: IF NOT igs_en_gen_legacy.validate_intm_ua_ovrlp ( p_person_id, p_intermiss_rec.program_cd, p_intermiss_rec.start_dt,

293: END IF;
294:
295: -- Validate whether Period of intermission overlaps enrolled/completed
296: -- unit attempt teaching period census dates.
297: IF NOT igs_en_gen_legacy.validate_intm_ua_ovrlp ( p_person_id, p_intermiss_rec.program_cd, p_intermiss_rec.start_dt,
298: p_intermiss_rec.end_dt ) THEN
299: FND_MESSAGE.SET_NAME('IGS','IGS_EN_INTM_CANT_OVRLP_UA');
300: FND_MSG_PUB.ADD;
301: l_validation_success := FALSE;

Line 307: l_result := igs_en_gen_legacy.check_approv_reqd (p_intermiss_rec.intermission_type);

303:
304: -- Validate whether approval is required for the intermission type.
305: IF p_intermiss_rec.intermission_type IS NOT NULL THEN
306:
307: l_result := igs_en_gen_legacy.check_approv_reqd (p_intermiss_rec.intermission_type);
308:
309: IF (l_result = FALSE) AND (p_intermiss_rec.approver_person_number IS NOT NULL) THEN
310: FND_MESSAGE.SET_NAME('IGS','IGS_EN_NOT_SET_APPROV_DET');
311: FND_MSG_PUB.ADD;

Line 341: IF NOT igs_en_gen_legacy.check_study_antr_instu ( p_intermiss_rec.intermission_type ) THEN

337: (p_intermiss_rec.max_credit_pts IS NOT NULL) THEN
338:
339: IF p_intermiss_rec.intermission_type IS NOT NULL THEN
340:
341: IF NOT igs_en_gen_legacy.check_study_antr_instu ( p_intermiss_rec.intermission_type ) THEN
342: FND_MESSAGE.SET_NAME('IGS','IGS_EN_CANT_SET_INSTI_DET');
343: FND_MSG_PUB.ADD;
344: l_validation_success := FALSE;
345: END IF;

Line 477: IF NOT igs_en_gen_legacy.check_approv_reqd (p_intermiss_rec.intermission_type) THEN

473:
474:
475: -- Check whether approval is required for the intermission type
476: IF l_insert_flag = TRUE THEN
477: IF NOT igs_en_gen_legacy.check_approv_reqd (p_intermiss_rec.intermission_type) THEN
478: l_approver_person_id := NULL;
479: END IF;
480: END IF;
481:

Line 485: IF igs_en_gen_legacy.check_study_antr_instu (p_intermiss_rec.intermission_type) THEN

481:
482: -- Check whether student is studying in another instiution or not. If yes, use the
483: -- institution related details else pass null to all institution details
484: IF l_insert_flag = TRUE THEN
485: IF igs_en_gen_legacy.check_study_antr_instu (p_intermiss_rec.intermission_type) THEN
486: l_institution_name := p_intermiss_rec.institution_name;
487: l_max_credit_pts := p_intermiss_rec.max_credit_pts;
488: l_max_terms := p_intermiss_rec.max_terms;
489: l_anticipated_credit_points := p_intermiss_rec.anticipated_credit_points;

Line 611: IF igs_en_gen_legacy.check_sca_status_upd ( l_person_id, p_intermiss_rec.program_cd, 'SPI', p_course_attempt_status ) THEN

607: );
608:
609: -- Check whether program attempt status need to be updated or not.
610: -- If needed update it with INTERMIT status.
611: IF igs_en_gen_legacy.check_sca_status_upd ( l_person_id, p_intermiss_rec.program_cd, 'SPI', p_course_attempt_status ) THEN
612: UPDATE igs_en_stdnt_ps_att_all SET course_attempt_status = 'INTERMIT'
613: WHERE person_id = l_person_id
614: AND course_cd = p_intermiss_rec.program_cd;
615: END IF;