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_INTM

Line 72: FROM igs_en_stdnt_ps_intm

68: AND lookup_Code = p_intm_rcond_rec.status_code;
69:
70: CURSOR chk_intermission (cp_person_id hz_parties.party_id%TYPE) IS
71: SELECT cond_return_flag
72: FROM igs_en_stdnt_ps_intm
73: WHERE person_id = cp_person_id
74: AND course_cd = p_intm_rcond_rec.program_cd
75: AND start_dt = p_intm_rcond_rec.start_dt
76: AND logical_delete_date = to_date('31-12-4712','DD-MM-YYYY');

Line 162: l_creation_date igs_en_stdnt_ps_intm.creation_date%TYPE;

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;
165: l_last_updated_by igs_en_stdnt_ps_intm.last_updated_by%TYPE;
166: l_last_update_login igs_en_stdnt_ps_intm.last_update_login%TYPE;

Line 163: l_last_update_date igs_en_stdnt_ps_intm.last_update_date%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;
165: l_last_updated_by igs_en_stdnt_ps_intm.last_updated_by%TYPE;
166: l_last_update_login igs_en_stdnt_ps_intm.last_update_login%TYPE;
167: l_api_name CONSTANT VARCHAR2(30) := 'create_student_intm_rcond';

Line 164: l_created_by igs_en_stdnt_ps_intm.created_by%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;
165: l_last_updated_by igs_en_stdnt_ps_intm.last_updated_by%TYPE;
166: l_last_update_login igs_en_stdnt_ps_intm.last_update_login%TYPE;
167: l_api_name CONSTANT VARCHAR2(30) := 'create_student_intm_rcond';
168: l_api_version CONSTANT NUMBER := 1.0;

Line 165: l_last_updated_by igs_en_stdnt_ps_intm.last_updated_by%TYPE;

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;
165: l_last_updated_by igs_en_stdnt_ps_intm.last_updated_by%TYPE;
166: l_last_update_login igs_en_stdnt_ps_intm.last_update_login%TYPE;
167: l_api_name CONSTANT VARCHAR2(30) := 'create_student_intm_rcond';
168: l_api_version CONSTANT NUMBER := 1.0;
169: l_approver_id hz_parties.party_id%TYPE;

Line 166: l_last_update_login igs_en_stdnt_ps_intm.last_update_login%TYPE;

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;
165: l_last_updated_by igs_en_stdnt_ps_intm.last_updated_by%TYPE;
166: l_last_update_login igs_en_stdnt_ps_intm.last_update_login%TYPE;
167: l_api_name CONSTANT VARCHAR2(30) := 'create_student_intm_rcond';
168: l_api_version CONSTANT NUMBER := 1.0;
169: l_approver_id hz_parties.party_id%TYPE;
170: l_ret_val VARCHAR2(1);