APPS.IGS_EN_SPI_LGCY_PUB dependencies on IGS_EN_STDNT_PS_ATT_ALL

Line 378: p_course_attempt_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE;

374: ***********************************************************************************************/
375:
376: l_person_id igs_en_stdnt_ps_intm.person_id%TYPE;
377: l_approver_person_id igs_en_stdnt_ps_intm.approver_id%TYPE;
378: p_course_attempt_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE;
379: l_insert_flag BOOLEAN := TRUE;
380: l_ret_val VARCHAR2(1);
381: l_api_name CONSTANT VARCHAR2(30) := 'create_student_intm';
382: l_api_version CONSTANT NUMBER := 1.0;

Line 612: UPDATE igs_en_stdnt_ps_att_all SET course_attempt_status = 'INTERMIT'

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;
616: ELSE