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.

[Home] [Help]

APPS.IGS_AD_VAL_APCOO dependencies on IGS_AD_PRD_PS_OF_OPT

Line 183: cp_adm_cal_type IGS_AD_PRD_PS_OF_OPT.adm_cal_type%TYPE,

179: -- conflicting or duplicate course offering option components.
180: DECLARE
181: v_message_name VARCHAR2(30);
182: CURSOR c_apcoo (
183: cp_adm_cal_type IGS_AD_PRD_PS_OF_OPT.adm_cal_type%TYPE,
184: cp_adm_ci_sequence_number
185: IGS_AD_PRD_PS_OF_OPT.adm_ci_sequence_number%TYPE,
186: cp_admission_cat IGS_AD_PRD_PS_OF_OPT.admission_cat%TYPE,
187: cp_s_admission_process_type

Line 185: IGS_AD_PRD_PS_OF_OPT.adm_ci_sequence_number%TYPE,

181: v_message_name VARCHAR2(30);
182: CURSOR c_apcoo (
183: cp_adm_cal_type IGS_AD_PRD_PS_OF_OPT.adm_cal_type%TYPE,
184: cp_adm_ci_sequence_number
185: IGS_AD_PRD_PS_OF_OPT.adm_ci_sequence_number%TYPE,
186: cp_admission_cat IGS_AD_PRD_PS_OF_OPT.admission_cat%TYPE,
187: cp_s_admission_process_type
188: IGS_AD_PRD_PS_OF_OPT.s_admission_process_type%TYPE,
189: cp_course_cd IGS_AD_PRD_PS_OF_OPT.course_cd%TYPE,

Line 186: cp_admission_cat IGS_AD_PRD_PS_OF_OPT.admission_cat%TYPE,

182: CURSOR c_apcoo (
183: cp_adm_cal_type IGS_AD_PRD_PS_OF_OPT.adm_cal_type%TYPE,
184: cp_adm_ci_sequence_number
185: IGS_AD_PRD_PS_OF_OPT.adm_ci_sequence_number%TYPE,
186: cp_admission_cat IGS_AD_PRD_PS_OF_OPT.admission_cat%TYPE,
187: cp_s_admission_process_type
188: IGS_AD_PRD_PS_OF_OPT.s_admission_process_type%TYPE,
189: cp_course_cd IGS_AD_PRD_PS_OF_OPT.course_cd%TYPE,
190: cp_version_number IGS_AD_PRD_PS_OF_OPT.version_number%TYPE,

Line 188: IGS_AD_PRD_PS_OF_OPT.s_admission_process_type%TYPE,

184: cp_adm_ci_sequence_number
185: IGS_AD_PRD_PS_OF_OPT.adm_ci_sequence_number%TYPE,
186: cp_admission_cat IGS_AD_PRD_PS_OF_OPT.admission_cat%TYPE,
187: cp_s_admission_process_type
188: IGS_AD_PRD_PS_OF_OPT.s_admission_process_type%TYPE,
189: cp_course_cd IGS_AD_PRD_PS_OF_OPT.course_cd%TYPE,
190: cp_version_number IGS_AD_PRD_PS_OF_OPT.version_number%TYPE,
191: cp_acad_cal_type IGS_AD_PRD_PS_OF_OPT.acad_cal_type%TYPE,
192: cp_sequence_number IGS_AD_PRD_PS_OF_OPT.sequence_number%TYPE) IS

Line 189: cp_course_cd IGS_AD_PRD_PS_OF_OPT.course_cd%TYPE,

185: IGS_AD_PRD_PS_OF_OPT.adm_ci_sequence_number%TYPE,
186: cp_admission_cat IGS_AD_PRD_PS_OF_OPT.admission_cat%TYPE,
187: cp_s_admission_process_type
188: IGS_AD_PRD_PS_OF_OPT.s_admission_process_type%TYPE,
189: cp_course_cd IGS_AD_PRD_PS_OF_OPT.course_cd%TYPE,
190: cp_version_number IGS_AD_PRD_PS_OF_OPT.version_number%TYPE,
191: cp_acad_cal_type IGS_AD_PRD_PS_OF_OPT.acad_cal_type%TYPE,
192: cp_sequence_number IGS_AD_PRD_PS_OF_OPT.sequence_number%TYPE) IS
193: SELECT apcoo.location_cd,

Line 190: cp_version_number IGS_AD_PRD_PS_OF_OPT.version_number%TYPE,

186: cp_admission_cat IGS_AD_PRD_PS_OF_OPT.admission_cat%TYPE,
187: cp_s_admission_process_type
188: IGS_AD_PRD_PS_OF_OPT.s_admission_process_type%TYPE,
189: cp_course_cd IGS_AD_PRD_PS_OF_OPT.course_cd%TYPE,
190: cp_version_number IGS_AD_PRD_PS_OF_OPT.version_number%TYPE,
191: cp_acad_cal_type IGS_AD_PRD_PS_OF_OPT.acad_cal_type%TYPE,
192: cp_sequence_number IGS_AD_PRD_PS_OF_OPT.sequence_number%TYPE) IS
193: SELECT apcoo.location_cd,
194: apcoo.attendance_mode,

Line 191: cp_acad_cal_type IGS_AD_PRD_PS_OF_OPT.acad_cal_type%TYPE,

187: cp_s_admission_process_type
188: IGS_AD_PRD_PS_OF_OPT.s_admission_process_type%TYPE,
189: cp_course_cd IGS_AD_PRD_PS_OF_OPT.course_cd%TYPE,
190: cp_version_number IGS_AD_PRD_PS_OF_OPT.version_number%TYPE,
191: cp_acad_cal_type IGS_AD_PRD_PS_OF_OPT.acad_cal_type%TYPE,
192: cp_sequence_number IGS_AD_PRD_PS_OF_OPT.sequence_number%TYPE) IS
193: SELECT apcoo.location_cd,
194: apcoo.attendance_mode,
195: apcoo.attendance_type

Line 192: cp_sequence_number IGS_AD_PRD_PS_OF_OPT.sequence_number%TYPE) IS

188: IGS_AD_PRD_PS_OF_OPT.s_admission_process_type%TYPE,
189: cp_course_cd IGS_AD_PRD_PS_OF_OPT.course_cd%TYPE,
190: cp_version_number IGS_AD_PRD_PS_OF_OPT.version_number%TYPE,
191: cp_acad_cal_type IGS_AD_PRD_PS_OF_OPT.acad_cal_type%TYPE,
192: cp_sequence_number IGS_AD_PRD_PS_OF_OPT.sequence_number%TYPE) IS
193: SELECT apcoo.location_cd,
194: apcoo.attendance_mode,
195: apcoo.attendance_type
196: FROM IGS_AD_PRD_PS_OF_OPT apcoo

Line 196: FROM IGS_AD_PRD_PS_OF_OPT apcoo

192: cp_sequence_number IGS_AD_PRD_PS_OF_OPT.sequence_number%TYPE) IS
193: SELECT apcoo.location_cd,
194: apcoo.attendance_mode,
195: apcoo.attendance_type
196: FROM IGS_AD_PRD_PS_OF_OPT apcoo
197: WHERE apcoo.adm_cal_type = cp_adm_cal_type AND
198: apcoo.adm_ci_sequence_number = cp_adm_ci_sequence_number AND
199: apcoo.admission_cat = cp_admission_cat AND
200: apcoo.s_admission_process_type = cp_s_admission_process_type AND

Line 267: FROM IGS_AD_PRD_PS_OF_OPT

263: cp_adm_ci_sequence_number IGS_AD_PRD_AD_PRC_CA.adm_ci_sequence_number%TYPE,
264: cp_admission_cat IGS_AD_PRD_AD_PRC_CA.admission_cat%TYPE,
265: cp_s_admission_process_type IGS_AD_PRD_AD_PRC_CA.s_admission_process_type%TYPE) IS
266: SELECT 'x'
267: FROM IGS_AD_PRD_PS_OF_OPT
268: WHERE adm_cal_type = cp_adm_cal_type AND
269: adm_ci_sequence_number = cp_adm_ci_sequence_number AND
270: admission_cat = cp_admission_cat AND
271: s_admission_process_type = cp_s_admission_process_type;

Line 315: select IGS_AD_PRD_PS_OF_OPT_SEQ_NUM_S.NEXTVAL into

311: FOR v_acov_rec IN c_acov(
312: p_adm_cal_type,
313: p_adm_ci_sequence_number) LOOP
314:
315: select IGS_AD_PRD_PS_OF_OPT_SEQ_NUM_S.NEXTVAL into
316: v_sequence_number
317: from dual;
318:
319: IGS_AD_PRD_PS_OF_OPT_PKG.INSERT_ROW(

Line 319: IGS_AD_PRD_PS_OF_OPT_PKG.INSERT_ROW(

315: select IGS_AD_PRD_PS_OF_OPT_SEQ_NUM_S.NEXTVAL into
316: v_sequence_number
317: from dual;
318:
319: IGS_AD_PRD_PS_OF_OPT_PKG.INSERT_ROW(
320: X_ROWID => v_rowid,
321: X_ADM_CAL_TYPE => p_adm_cal_type,
322: X_ADM_CI_SEQUENCE_NUMBER => p_adm_ci_sequence_number,
323: X_ADMISSION_CAT => p_admission_cat,