APPS.IGS_EN_SUA_LGCY_PUB dependencies on IGS_EN_STDNT_PS_ATT_ALL

Line 972: UPDATE IGS_EN_STDNT_PS_ATT_ALL SET COURSE_ATTEMPT_STATUS = l_course_attempt_status_after ,

968:
969: -- If the course attempt status changes as a result of the Unit Import , Update the Course Attempt Status .
970: BEGIN
971: IF l_last_dt_of_att IS NOT NULL THEN
972: UPDATE IGS_EN_STDNT_PS_ATT_ALL SET COURSE_ATTEMPT_STATUS = l_course_attempt_status_after ,
973: LAST_DATE_OF_ATTENDANCE = l_last_dt_of_att WHERE ROWID = l_spa_row.ROWID;
974: ELSE
975: UPDATE IGS_EN_STDNT_PS_ATT_ALL SET COURSE_ATTEMPT_STATUS = l_course_attempt_status_after WHERE ROWID = l_spa_row.ROWID;
976: END IF;

Line 975: UPDATE IGS_EN_STDNT_PS_ATT_ALL SET COURSE_ATTEMPT_STATUS = l_course_attempt_status_after WHERE ROWID = l_spa_row.ROWID;

971: IF l_last_dt_of_att IS NOT NULL THEN
972: UPDATE IGS_EN_STDNT_PS_ATT_ALL SET COURSE_ATTEMPT_STATUS = l_course_attempt_status_after ,
973: LAST_DATE_OF_ATTENDANCE = l_last_dt_of_att WHERE ROWID = l_spa_row.ROWID;
974: ELSE
975: UPDATE IGS_EN_STDNT_PS_ATT_ALL SET COURSE_ATTEMPT_STATUS = l_course_attempt_status_after WHERE ROWID = l_spa_row.ROWID;
976: END IF;
977:
978: -- If the Primary Program Status is updated, mirror all the secondary Programs with the same status as the primary program.
979: IF l_spa_row.primary_program_type = 'PRIMARY' THEN

Line 982: UPDATE IGS_EN_STDNT_PS_ATT_ALL SET COURSE_ATTEMPT_STATUS = l_course_attempt_status_after WHERE ROWID = get_spa_sec_prgm_rec.ROWID ;

978: -- If the Primary Program Status is updated, mirror all the secondary Programs with the same status as the primary program.
979: IF l_spa_row.primary_program_type = 'PRIMARY' THEN
980: FOR get_spa_sec_prgm_rec IN get_spa_sec_prgm(l_course_type)
981: LOOP
982: UPDATE IGS_EN_STDNT_PS_ATT_ALL SET COURSE_ATTEMPT_STATUS = l_course_attempt_status_after WHERE ROWID = get_spa_sec_prgm_rec.ROWID ;
983: END LOOP;
984: END IF;
985:
986: EXCEPTION