DBA Data[Home] [Help]

APPS.IGS_EN_SPI_RCOND_LGCY_PUB dependencies on IGS_EN_GEN_LEGACY

Line 311: IF igs_en_gen_legacy.check_sca_status_upd (

307: IF l_course_attempt_status <> 'INTERMIT' AND p_intm_rcond_rec.status_code IN ('PENDING','FAILED') THEN
308:
309: -- call the api to know whether program attempt status has changed
310: -- if so update the spa table with new status
311: IF igs_en_gen_legacy.check_sca_status_upd (
312: p_person_id => l_person_id,
313: p_program_cd => p_intm_rcond_rec.program_cd,
314: p_called_from => 'SPI',
315: p_course_attempt_status => l_course_attempt_status

Line 321: END IF;-- IF igs_en_gen_legacy.check_sca_status_upd

317: UPDATE igs_en_stdnt_ps_att_all SET course_attempt_status = 'INTERMIT'
318: WHERE person_id = l_person_id
319: AND course_cd = p_intm_rcond_rec.program_cd;
320:
321: END IF;-- IF igs_en_gen_legacy.check_sca_status_upd
322:
323: END IF; -- IF l_course_attempt_status <> 'INTERMIT' AND p_intm_rcond_rec.status_code IN ('PENDING','FAILED')
324:
325: ELSE