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_AD_INS_ADMPERD dependencies on IGS_AD_PRD_PS_OF_OPT

Line 161: SELECT IGS_AD_PRD_PS_OF_OPT_SEQ_NUM_S.NEXTVAL FROM DUAL;

157: v_apcoo_one_not_insert BOOLEAN DEFAULT FALSE;
158: v_apcoo_one_insert BOOLEAN DEFAULT FALSE;
159: v_apcoo_one_apcoo BOOLEAN DEFAULT FALSE;
160: CURSOR C_IGS_ADPRD_NUM_S IS
161: SELECT IGS_AD_PRD_PS_OF_OPT_SEQ_NUM_S.NEXTVAL FROM DUAL;
162: CURSOR c_apapc IS
163: SELECT s_admission_process_type
164: FROM IGS_AD_PRD_AD_PRC_CA
165: WHERE adm_cal_type = p_adm_cal_type AND

Line 216: FROM IGS_AD_PRD_PS_OF_OPT

212: location_cd,
213: attendance_mode,
214: attendance_type,
215: rollover_inclusion_ind
216: FROM IGS_AD_PRD_PS_OF_OPT
217: WHERE adm_cal_type = p_adm_cal_type AND
218: adm_ci_sequence_number = p_old_adm_ci_sequence_number AND
219: admission_cat = p_old_admission_cat AND
220: s_admission_process_type = cp_s_admission_process_type;

Line 223: cp_course_cd IGS_AD_PRD_PS_OF_OPT.course_cd%TYPE,

219: admission_cat = p_old_admission_cat AND
220: s_admission_process_type = cp_s_admission_process_type;
221: v_apcoo_rec c_apcoo%ROWTYPE;
222: CURSOR c_val_entry_point(
223: cp_course_cd IGS_AD_PRD_PS_OF_OPT.course_cd%TYPE,
224: cp_version_number IGS_AD_PRD_PS_OF_OPT.version_number%TYPE,
225: cp_acad_cal_type IGS_AD_PRD_PS_OF_OPT.acad_cal_type%TYPE) IS
226: SELECT 'x'
227: FROM IGS_PS_OFR_PAT cop,

Line 224: cp_version_number IGS_AD_PRD_PS_OF_OPT.version_number%TYPE,

220: s_admission_process_type = cp_s_admission_process_type;
221: v_apcoo_rec c_apcoo%ROWTYPE;
222: CURSOR c_val_entry_point(
223: cp_course_cd IGS_AD_PRD_PS_OF_OPT.course_cd%TYPE,
224: cp_version_number IGS_AD_PRD_PS_OF_OPT.version_number%TYPE,
225: cp_acad_cal_type IGS_AD_PRD_PS_OF_OPT.acad_cal_type%TYPE) IS
226: SELECT 'x'
227: FROM IGS_PS_OFR_PAT cop,
228: IGS_CA_INST_REL cir

Line 225: cp_acad_cal_type IGS_AD_PRD_PS_OF_OPT.acad_cal_type%TYPE) IS

221: v_apcoo_rec c_apcoo%ROWTYPE;
222: CURSOR c_val_entry_point(
223: cp_course_cd IGS_AD_PRD_PS_OF_OPT.course_cd%TYPE,
224: cp_version_number IGS_AD_PRD_PS_OF_OPT.version_number%TYPE,
225: cp_acad_cal_type IGS_AD_PRD_PS_OF_OPT.acad_cal_type%TYPE) IS
226: SELECT 'x'
227: FROM IGS_PS_OFR_PAT cop,
228: IGS_CA_INST_REL cir
229: WHERE cir.sub_cal_type = p_adm_cal_type AND

Line 256: IGS_AD_PRD_PS_OF_OPT.adm_ci_sequence_number%TYPE,

252: lv_rowid VARCHAR2(25);
253: lv_nextval Number;
254: PROCEDURE admpl_ins_insert_log(
255: p_adm_ci_sequence_number
256: IGS_AD_PRD_PS_OF_OPT.adm_ci_sequence_number%TYPE,
257: p_admission_cat IGS_AD_PRD_PS_OF_OPT.admission_cat%TYPE,
258: p_s_admission_process_type
259: IGS_AD_PRD_PS_OF_OPT.s_admission_process_type%TYPE,
260: p_course_cd IGS_AD_PRD_PS_OF_OPT.course_cd%TYPE,

Line 257: p_admission_cat IGS_AD_PRD_PS_OF_OPT.admission_cat%TYPE,

253: lv_nextval Number;
254: PROCEDURE admpl_ins_insert_log(
255: p_adm_ci_sequence_number
256: IGS_AD_PRD_PS_OF_OPT.adm_ci_sequence_number%TYPE,
257: p_admission_cat IGS_AD_PRD_PS_OF_OPT.admission_cat%TYPE,
258: p_s_admission_process_type
259: IGS_AD_PRD_PS_OF_OPT.s_admission_process_type%TYPE,
260: p_course_cd IGS_AD_PRD_PS_OF_OPT.course_cd%TYPE,
261: p_version_number IGS_AD_PRD_PS_OF_OPT.version_number%TYPE,

Line 259: IGS_AD_PRD_PS_OF_OPT.s_admission_process_type%TYPE,

255: p_adm_ci_sequence_number
256: IGS_AD_PRD_PS_OF_OPT.adm_ci_sequence_number%TYPE,
257: p_admission_cat IGS_AD_PRD_PS_OF_OPT.admission_cat%TYPE,
258: p_s_admission_process_type
259: IGS_AD_PRD_PS_OF_OPT.s_admission_process_type%TYPE,
260: p_course_cd IGS_AD_PRD_PS_OF_OPT.course_cd%TYPE,
261: p_version_number IGS_AD_PRD_PS_OF_OPT.version_number%TYPE,
262: p_acad_cal_type IGS_AD_PRD_PS_OF_OPT.acad_cal_type%TYPE,
263: p_sequence_number IGS_AD_PRD_PS_OF_OPT.sequence_number%TYPE,

Line 260: p_course_cd IGS_AD_PRD_PS_OF_OPT.course_cd%TYPE,

256: IGS_AD_PRD_PS_OF_OPT.adm_ci_sequence_number%TYPE,
257: p_admission_cat IGS_AD_PRD_PS_OF_OPT.admission_cat%TYPE,
258: p_s_admission_process_type
259: IGS_AD_PRD_PS_OF_OPT.s_admission_process_type%TYPE,
260: p_course_cd IGS_AD_PRD_PS_OF_OPT.course_cd%TYPE,
261: p_version_number IGS_AD_PRD_PS_OF_OPT.version_number%TYPE,
262: p_acad_cal_type IGS_AD_PRD_PS_OF_OPT.acad_cal_type%TYPE,
263: p_sequence_number IGS_AD_PRD_PS_OF_OPT.sequence_number%TYPE,
264: p_message_name VARCHAR2)

Line 261: p_version_number IGS_AD_PRD_PS_OF_OPT.version_number%TYPE,

257: p_admission_cat IGS_AD_PRD_PS_OF_OPT.admission_cat%TYPE,
258: p_s_admission_process_type
259: IGS_AD_PRD_PS_OF_OPT.s_admission_process_type%TYPE,
260: p_course_cd IGS_AD_PRD_PS_OF_OPT.course_cd%TYPE,
261: p_version_number IGS_AD_PRD_PS_OF_OPT.version_number%TYPE,
262: p_acad_cal_type IGS_AD_PRD_PS_OF_OPT.acad_cal_type%TYPE,
263: p_sequence_number IGS_AD_PRD_PS_OF_OPT.sequence_number%TYPE,
264: p_message_name VARCHAR2)
265: IS

Line 262: p_acad_cal_type IGS_AD_PRD_PS_OF_OPT.acad_cal_type%TYPE,

258: p_s_admission_process_type
259: IGS_AD_PRD_PS_OF_OPT.s_admission_process_type%TYPE,
260: p_course_cd IGS_AD_PRD_PS_OF_OPT.course_cd%TYPE,
261: p_version_number IGS_AD_PRD_PS_OF_OPT.version_number%TYPE,
262: p_acad_cal_type IGS_AD_PRD_PS_OF_OPT.acad_cal_type%TYPE,
263: p_sequence_number IGS_AD_PRD_PS_OF_OPT.sequence_number%TYPE,
264: p_message_name VARCHAR2)
265: IS
266: BEGIN -- admpl_ins_insert_log

Line 263: p_sequence_number IGS_AD_PRD_PS_OF_OPT.sequence_number%TYPE,

259: IGS_AD_PRD_PS_OF_OPT.s_admission_process_type%TYPE,
260: p_course_cd IGS_AD_PRD_PS_OF_OPT.course_cd%TYPE,
261: p_version_number IGS_AD_PRD_PS_OF_OPT.version_number%TYPE,
262: p_acad_cal_type IGS_AD_PRD_PS_OF_OPT.acad_cal_type%TYPE,
263: p_sequence_number IGS_AD_PRD_PS_OF_OPT.sequence_number%TYPE,
264: p_message_name VARCHAR2)
265: IS
266: BEGIN -- admpl_ins_insert_log
267: DECLARE

Line 369: -- Continue processing next IGS_AD_PRD_PS_OF_OPT.

365: FETCH c_apcoo INTO v_apcoo_rec;
366: EXIT WHEN c_apcoo%NOTFOUND;
367: IF (p_rollover_ind = 'Y' AND
368: v_apcoo_rec.rollover_inclusion_ind = 'N') THEN
369: -- Continue processing next IGS_AD_PRD_PS_OF_OPT.
370: NULL;
371: ELSE
372: -- Set variable to indicate one admission period COURSE offering option
373: -- found.

Line 452: IGS_AD_PRD_PS_OF_OPT_Pkg.Insert_Row (

448: RAISE NO_DATA_FOUND;
449: END IF;
450: CLOSE C_IGS_ADPRD_NUM_S;
451:
452: IGS_AD_PRD_PS_OF_OPT_Pkg.Insert_Row (
453: X_Mode => 'R',
454: X_RowId => lv_rowid,
455: X_Adm_Cal_Type => p_adm_cal_type,
456: X_Adm_Ci_Sequence_Number => p_new_adm_ci_sequence_number,

Line 546: FROM IGS_AD_PRD_PS_OF_OPT apcoo

542: v_end_dt IGS_CA_INST.end_dt%TYPE;
543: v_alternate_code IGS_CA_INST.alternate_code%TYPE;
544: CURSOR c_apcoo IS
545: SELECT 'X'
546: FROM IGS_AD_PRD_PS_OF_OPT apcoo
547: WHERE apcoo.adm_cal_type = p_adm_cal_type AND
548: apcoo.adm_ci_sequence_number = p_new_adm_ci_sequence_number AND
549: (p_admission_cat IS NULL OR
550: apcoo.admission_cat = p_admission_cat);

Line 599: --Check that one IGS_AD_PRD_PS_OF_OPT does not already exist

595: p_message_name := v_message_name;
596: p_return_type := cst_error;
597: RETURN FALSE;
598: END IF;
599: --Check that one IGS_AD_PRD_PS_OF_OPT does not already exist
600: OPEN c_apcoo;
601: FETCH c_apcoo INTO v_apcoo_exist;
602: IF (c_apcoo%FOUND) THEN
603: --Admission perd COURSE offering option restrictions