APPS.IGS_AD_VAL_APCOO dependencies on IGS_PS_OFR_PAT

Line 39: IGS_PS_OFR_PAT cop

35: cop.location_cd,
36: cop.attendance_mode,
37: cop.attendance_type
38: FROM IGS_CA_INST_REL cir,
39: IGS_PS_OFR_PAT cop
40: WHERE cir.sub_cal_type = p_adm_cal_type AND
41: cir.sub_ci_sequence_number = p_adm_ci_sequence_number AND
42: cir.sup_cal_type = p_acad_cal_type AND
43: cop.course_cd = p_course_cd AND

Line 279: FROM IGS_PS_OFR_PAT_APCOO_V acov

275: cp_adm_ci_sequence_number IGS_AD_PRD_AD_PRC_CA.adm_ci_sequence_number%TYPE) IS
276: SELECT DISTINCT acov.course_cd,
277: acov.version_number,
278: acov.acad_cal_type
279: FROM IGS_PS_OFR_PAT_APCOO_V acov
280: WHERE acov.adm_cal_type = cp_adm_cal_type AND
281: acov.adm_ci_sequence_number = cp_adm_ci_sequence_number AND
282: acov.admission_cat = p_admission_cat AND
283: acov.s_admission_process_type = p_s_admission_process_type AND

Line 290: v_course_cd IGS_PS_OFR_PAT.course_cd%TYPE DEFAULT NULL;

286: acov.version_number,
287: p_s_admission_process_type,
288: 'N') = 'Y' );
289: v_acov_rec c_acov%ROWTYPE;
290: v_course_cd IGS_PS_OFR_PAT.course_cd%TYPE DEFAULT NULL;
291: v_version_number IGS_PS_OFR_PAT.version_number%TYPE DEFAULT NULL;
292: v_cal_type IGS_PS_OFR_PAT.cal_type%TYPE DEFAULT NULL;
293: v_rowid VARCHAR2(25);
294: v_sequence_number NUMBER(6);

Line 291: v_version_number IGS_PS_OFR_PAT.version_number%TYPE DEFAULT NULL;

287: p_s_admission_process_type,
288: 'N') = 'Y' );
289: v_acov_rec c_acov%ROWTYPE;
290: v_course_cd IGS_PS_OFR_PAT.course_cd%TYPE DEFAULT NULL;
291: v_version_number IGS_PS_OFR_PAT.version_number%TYPE DEFAULT NULL;
292: v_cal_type IGS_PS_OFR_PAT.cal_type%TYPE DEFAULT NULL;
293: v_rowid VARCHAR2(25);
294: v_sequence_number NUMBER(6);
295: BEGIN

Line 292: v_cal_type IGS_PS_OFR_PAT.cal_type%TYPE DEFAULT NULL;

288: 'N') = 'Y' );
289: v_acov_rec c_acov%ROWTYPE;
290: v_course_cd IGS_PS_OFR_PAT.course_cd%TYPE DEFAULT NULL;
291: v_version_number IGS_PS_OFR_PAT.version_number%TYPE DEFAULT NULL;
292: v_cal_type IGS_PS_OFR_PAT.cal_type%TYPE DEFAULT NULL;
293: v_rowid VARCHAR2(25);
294: v_sequence_number NUMBER(6);
295: BEGIN
296: -- Set the default message number

Line 663: v_location_cd IGS_PS_OFR_PAT.location_cd%TYPE;

659: gv_other_detail VARCHAR2(255);
660: BEGIN -- admp_val_apcoo_opt
661: -- Validate the admission period course offering option details
662: DECLARE
663: v_location_cd IGS_PS_OFR_PAT.location_cd%TYPE;
664: v_attendance_mode IGS_PS_OFR_PAT.attendance_mode%TYPE;
665: v_attendance_type IGS_PS_OFR_PAT.attendance_type%TYPE;
666: v_message_name varchar2(30);
667: CURSOR c_acov IS

Line 664: v_attendance_mode IGS_PS_OFR_PAT.attendance_mode%TYPE;

660: BEGIN -- admp_val_apcoo_opt
661: -- Validate the admission period course offering option details
662: DECLARE
663: v_location_cd IGS_PS_OFR_PAT.location_cd%TYPE;
664: v_attendance_mode IGS_PS_OFR_PAT.attendance_mode%TYPE;
665: v_attendance_type IGS_PS_OFR_PAT.attendance_type%TYPE;
666: v_message_name varchar2(30);
667: CURSOR c_acov IS
668: SELECT location_cd,

Line 665: v_attendance_type IGS_PS_OFR_PAT.attendance_type%TYPE;

661: -- Validate the admission period course offering option details
662: DECLARE
663: v_location_cd IGS_PS_OFR_PAT.location_cd%TYPE;
664: v_attendance_mode IGS_PS_OFR_PAT.attendance_mode%TYPE;
665: v_attendance_type IGS_PS_OFR_PAT.attendance_type%TYPE;
666: v_message_name varchar2(30);
667: CURSOR c_acov IS
668: SELECT location_cd,
669: attendance_mode,

Line 671: FROM IGS_PS_OFR_PAT_APCOO_V

667: CURSOR c_acov IS
668: SELECT location_cd,
669: attendance_mode,
670: attendance_type
671: FROM IGS_PS_OFR_PAT_APCOO_V
672: WHERE course_cd = p_course_cd AND
673: version_number = p_version_number AND
674: acad_cal_type = p_acad_cal_type AND
675: adm_cal_type = p_adm_cal_type AND