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_CO_GEN_003 dependencies on IGS_AD_PS_APPL_INST

Line 168: l_column_value igs_ad_ps_appl_inst_all.attribute1%TYPE;

164: AND usg.enabled_flag = 'Y'
165: AND usg.application_id = 8405;
166:
167: l_return_value VARCHAR2(6000);
168: l_column_value igs_ad_ps_appl_inst_all.attribute1%TYPE;
169:
170: BEGIN
171:
172: -- Check if the required parameter values are passed as Null. If any of these are null then return NULL value

Line 182: ' FROM igs_ad_ps_appl_inst_all '||

178:
179: FOR rec_cur_enabled_attributes IN cur_enabled_attributes LOOP
180: -- Get the registered flex filed Column values for the Admission Application Instance
181: EXECUTE IMMEDIATE ' SELECT '|| rec_cur_enabled_attributes.application_column_name||
182: ' FROM igs_ad_ps_appl_inst_all '||
183: ' WHERE person_id = :1' ||
184: ' AND admission_appl_number = :2'||
185: ' AND nominated_course_cd = :3' ||
186: ' AND sequence_number = :4'

Line 210: p_course_cd IN igs_ad_ps_appl_inst_aplinst_v.course_cd%TYPE,

206: END get_prg_appl_inst_dff_values;
207:
208:
209: FUNCTION get_program_completion_dt (
210: p_course_cd IN igs_ad_ps_appl_inst_aplinst_v.course_cd%TYPE,
211: p_version_number IN igs_ad_ps_appl_inst_aplinst_v.crv_version_number%TYPE,
212: p_acad_cal_type IN igs_ad_ps_appl_inst_aplinst_v.acad_cal_type%TYPE,
213: p_adm_cal_type IN igs_ad_ps_appl_inst_aplinst_v.adm_cal_type%TYPE,
214: p_adm_ci_sequence_number IN igs_ad_ps_appl_inst_aplinst_v.adm_ci_sequence_number%TYPE,

Line 211: p_version_number IN igs_ad_ps_appl_inst_aplinst_v.crv_version_number%TYPE,

207:
208:
209: FUNCTION get_program_completion_dt (
210: p_course_cd IN igs_ad_ps_appl_inst_aplinst_v.course_cd%TYPE,
211: p_version_number IN igs_ad_ps_appl_inst_aplinst_v.crv_version_number%TYPE,
212: p_acad_cal_type IN igs_ad_ps_appl_inst_aplinst_v.acad_cal_type%TYPE,
213: p_adm_cal_type IN igs_ad_ps_appl_inst_aplinst_v.adm_cal_type%TYPE,
214: p_adm_ci_sequence_number IN igs_ad_ps_appl_inst_aplinst_v.adm_ci_sequence_number%TYPE,
215: p_attendance_type IN igs_ad_ps_appl_inst_aplinst_v.attendance_type%TYPE,

Line 212: p_acad_cal_type IN igs_ad_ps_appl_inst_aplinst_v.acad_cal_type%TYPE,

208:
209: FUNCTION get_program_completion_dt (
210: p_course_cd IN igs_ad_ps_appl_inst_aplinst_v.course_cd%TYPE,
211: p_version_number IN igs_ad_ps_appl_inst_aplinst_v.crv_version_number%TYPE,
212: p_acad_cal_type IN igs_ad_ps_appl_inst_aplinst_v.acad_cal_type%TYPE,
213: p_adm_cal_type IN igs_ad_ps_appl_inst_aplinst_v.adm_cal_type%TYPE,
214: p_adm_ci_sequence_number IN igs_ad_ps_appl_inst_aplinst_v.adm_ci_sequence_number%TYPE,
215: p_attendance_type IN igs_ad_ps_appl_inst_aplinst_v.attendance_type%TYPE,
216: p_attendance_mode IN igs_ad_ps_appl_inst_aplinst_v.attendance_mode%TYPE,

Line 213: p_adm_cal_type IN igs_ad_ps_appl_inst_aplinst_v.adm_cal_type%TYPE,

209: FUNCTION get_program_completion_dt (
210: p_course_cd IN igs_ad_ps_appl_inst_aplinst_v.course_cd%TYPE,
211: p_version_number IN igs_ad_ps_appl_inst_aplinst_v.crv_version_number%TYPE,
212: p_acad_cal_type IN igs_ad_ps_appl_inst_aplinst_v.acad_cal_type%TYPE,
213: p_adm_cal_type IN igs_ad_ps_appl_inst_aplinst_v.adm_cal_type%TYPE,
214: p_adm_ci_sequence_number IN igs_ad_ps_appl_inst_aplinst_v.adm_ci_sequence_number%TYPE,
215: p_attendance_type IN igs_ad_ps_appl_inst_aplinst_v.attendance_type%TYPE,
216: p_attendance_mode IN igs_ad_ps_appl_inst_aplinst_v.attendance_mode%TYPE,
217: p_location_cd IN igs_ad_ps_appl_inst_aplinst_v.location_cd%TYPE

Line 214: p_adm_ci_sequence_number IN igs_ad_ps_appl_inst_aplinst_v.adm_ci_sequence_number%TYPE,

210: p_course_cd IN igs_ad_ps_appl_inst_aplinst_v.course_cd%TYPE,
211: p_version_number IN igs_ad_ps_appl_inst_aplinst_v.crv_version_number%TYPE,
212: p_acad_cal_type IN igs_ad_ps_appl_inst_aplinst_v.acad_cal_type%TYPE,
213: p_adm_cal_type IN igs_ad_ps_appl_inst_aplinst_v.adm_cal_type%TYPE,
214: p_adm_ci_sequence_number IN igs_ad_ps_appl_inst_aplinst_v.adm_ci_sequence_number%TYPE,
215: p_attendance_type IN igs_ad_ps_appl_inst_aplinst_v.attendance_type%TYPE,
216: p_attendance_mode IN igs_ad_ps_appl_inst_aplinst_v.attendance_mode%TYPE,
217: p_location_cd IN igs_ad_ps_appl_inst_aplinst_v.location_cd%TYPE
218: ) RETURN DATE IS

Line 215: p_attendance_type IN igs_ad_ps_appl_inst_aplinst_v.attendance_type%TYPE,

211: p_version_number IN igs_ad_ps_appl_inst_aplinst_v.crv_version_number%TYPE,
212: p_acad_cal_type IN igs_ad_ps_appl_inst_aplinst_v.acad_cal_type%TYPE,
213: p_adm_cal_type IN igs_ad_ps_appl_inst_aplinst_v.adm_cal_type%TYPE,
214: p_adm_ci_sequence_number IN igs_ad_ps_appl_inst_aplinst_v.adm_ci_sequence_number%TYPE,
215: p_attendance_type IN igs_ad_ps_appl_inst_aplinst_v.attendance_type%TYPE,
216: p_attendance_mode IN igs_ad_ps_appl_inst_aplinst_v.attendance_mode%TYPE,
217: p_location_cd IN igs_ad_ps_appl_inst_aplinst_v.location_cd%TYPE
218: ) RETURN DATE IS
219:

Line 216: p_attendance_mode IN igs_ad_ps_appl_inst_aplinst_v.attendance_mode%TYPE,

212: p_acad_cal_type IN igs_ad_ps_appl_inst_aplinst_v.acad_cal_type%TYPE,
213: p_adm_cal_type IN igs_ad_ps_appl_inst_aplinst_v.adm_cal_type%TYPE,
214: p_adm_ci_sequence_number IN igs_ad_ps_appl_inst_aplinst_v.adm_ci_sequence_number%TYPE,
215: p_attendance_type IN igs_ad_ps_appl_inst_aplinst_v.attendance_type%TYPE,
216: p_attendance_mode IN igs_ad_ps_appl_inst_aplinst_v.attendance_mode%TYPE,
217: p_location_cd IN igs_ad_ps_appl_inst_aplinst_v.location_cd%TYPE
218: ) RETURN DATE IS
219:
220: /*******************************************************************************

Line 217: p_location_cd IN igs_ad_ps_appl_inst_aplinst_v.location_cd%TYPE

213: p_adm_cal_type IN igs_ad_ps_appl_inst_aplinst_v.adm_cal_type%TYPE,
214: p_adm_ci_sequence_number IN igs_ad_ps_appl_inst_aplinst_v.adm_ci_sequence_number%TYPE,
215: p_attendance_type IN igs_ad_ps_appl_inst_aplinst_v.attendance_type%TYPE,
216: p_attendance_mode IN igs_ad_ps_appl_inst_aplinst_v.attendance_mode%TYPE,
217: p_location_cd IN igs_ad_ps_appl_inst_aplinst_v.location_cd%TYPE
218: ) RETURN DATE IS
219:
220: /*******************************************************************************
221: Created by : rbezawad

Line 233: l_expected_completion_yr igs_ad_ps_appl_inst.expected_completion_yr%TYPE;

229: knag 29-OCT-2002 For bug 2647482 Added parameters
230: p_attendance_type and p_location_cd
231: *******************************************************************************/
232:
233: l_expected_completion_yr igs_ad_ps_appl_inst.expected_completion_yr%TYPE;
234: l_expected_completion_perd igs_ad_ps_appl_inst.expected_completion_perd%TYPE;
235: l_completion_dt DATE;
236: l_course_start_dt DATE;
237: BEGIN

Line 234: l_expected_completion_perd igs_ad_ps_appl_inst.expected_completion_perd%TYPE;

230: p_attendance_type and p_location_cd
231: *******************************************************************************/
232:
233: l_expected_completion_yr igs_ad_ps_appl_inst.expected_completion_yr%TYPE;
234: l_expected_completion_perd igs_ad_ps_appl_inst.expected_completion_perd%TYPE;
235: l_completion_dt DATE;
236: l_course_start_dt DATE;
237: BEGIN
238: