eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_EN_SPI_RCOND_LGCY_PUB dependencies on IGS_EN_STDNT_PS_ATT

Line 158: l_course_attempt_status igs_en_stdnt_ps_att.course_attempt_status%TYPE;

154: Who When What
155: ***********************************************************************************************/
156:
157: l_rowid ROWID;
158: l_course_attempt_status igs_en_stdnt_ps_att.course_attempt_status%TYPE;
159: l_person_id hz_parties.party_id%TYPE;
160: l_sca_rec igs_en_stdnt_ps_att%ROWTYPE;
161: l_insert_flag BOOLEAN;
162: l_creation_date igs_en_stdnt_ps_intm.creation_date%TYPE;

Line 160: l_sca_rec igs_en_stdnt_ps_att%ROWTYPE;

156:
157: l_rowid ROWID;
158: l_course_attempt_status igs_en_stdnt_ps_att.course_attempt_status%TYPE;
159: l_person_id hz_parties.party_id%TYPE;
160: l_sca_rec igs_en_stdnt_ps_att%ROWTYPE;
161: l_insert_flag BOOLEAN;
162: l_creation_date igs_en_stdnt_ps_intm.creation_date%TYPE;
163: l_last_update_date igs_en_stdnt_ps_intm.last_update_date%TYPE;
164: l_created_by igs_en_stdnt_ps_intm.created_by%TYPE;

Line 172: CURSOR c_crs_status (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE) IS

168: l_api_version CONSTANT NUMBER := 1.0;
169: l_approver_id hz_parties.party_id%TYPE;
170: l_ret_val VARCHAR2(1);
171:
172: CURSOR c_crs_status (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE) IS
173: SELECT course_attempt_status
174: FROM igs_en_stdnt_ps_att
175: WHERE person_id = cp_person_id
176: AND course_cd = p_intm_rcond_rec.program_cd;

Line 174: FROM igs_en_stdnt_ps_att

170: l_ret_val VARCHAR2(1);
171:
172: CURSOR c_crs_status (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE) IS
173: SELECT course_attempt_status
174: FROM igs_en_stdnt_ps_att
175: WHERE person_id = cp_person_id
176: AND course_cd = p_intm_rcond_rec.program_cd;
177:
178: BEGIN

Line 317: UPDATE igs_en_stdnt_ps_att_all SET course_attempt_status = 'INTERMIT'

313: p_program_cd => p_intm_rcond_rec.program_cd,
314: p_called_from => 'SPI',
315: p_course_attempt_status => l_course_attempt_status
316: ) THEN
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