APPS.IGS_AD_VAL_APAC dependencies on IGS_AD_PRD_PS_OF_OPT

Line 13: -- Routine to validate that at least on IGS_AD_PRD_PS_OF_OPT can be

9: p_message_name OUT NOCOPY VARCHAR2 )
10: RETURN BOOLEAN IS
11: gv_other_detail VARCHAR2(255);
12: BEGIN -- admp_val_apac_dup
13: -- Routine to validate that at least on IGS_AD_PRD_PS_OF_OPT can be
14: -- duplicated for the new admission category.
15: DECLARE
16: v_apcoo_course_cd IGS_AD_PRD_PS_OF_OPT.course_cd%TYPE;
17: v_apcoo_version_number IGS_AD_PRD_PS_OF_OPT.version_number%TYPE;

Line 16: v_apcoo_course_cd IGS_AD_PRD_PS_OF_OPT.course_cd%TYPE;

12: BEGIN -- admp_val_apac_dup
13: -- Routine to validate that at least on IGS_AD_PRD_PS_OF_OPT can be
14: -- duplicated for the new admission category.
15: DECLARE
16: v_apcoo_course_cd IGS_AD_PRD_PS_OF_OPT.course_cd%TYPE;
17: v_apcoo_version_number IGS_AD_PRD_PS_OF_OPT.version_number%TYPE;
18: v_apcoo_acad_cal_type IGS_AD_PRD_PS_OF_OPT.acad_cal_type%TYPE;
19: v_ret_val BOOLEAN DEFAULT TRUE;
20: v_message_name varchar2(30);

Line 17: v_apcoo_version_number IGS_AD_PRD_PS_OF_OPT.version_number%TYPE;

13: -- Routine to validate that at least on IGS_AD_PRD_PS_OF_OPT can be
14: -- duplicated for the new admission category.
15: DECLARE
16: v_apcoo_course_cd IGS_AD_PRD_PS_OF_OPT.course_cd%TYPE;
17: v_apcoo_version_number IGS_AD_PRD_PS_OF_OPT.version_number%TYPE;
18: v_apcoo_acad_cal_type IGS_AD_PRD_PS_OF_OPT.acad_cal_type%TYPE;
19: v_ret_val BOOLEAN DEFAULT TRUE;
20: v_message_name varchar2(30);
21: v_apcoo_found BOOLEAN DEFAULT FALSE;

Line 18: v_apcoo_acad_cal_type IGS_AD_PRD_PS_OF_OPT.acad_cal_type%TYPE;

14: -- duplicated for the new admission category.
15: DECLARE
16: v_apcoo_course_cd IGS_AD_PRD_PS_OF_OPT.course_cd%TYPE;
17: v_apcoo_version_number IGS_AD_PRD_PS_OF_OPT.version_number%TYPE;
18: v_apcoo_acad_cal_type IGS_AD_PRD_PS_OF_OPT.acad_cal_type%TYPE;
19: v_ret_val BOOLEAN DEFAULT TRUE;
20: v_message_name varchar2(30);
21: v_apcoo_found BOOLEAN DEFAULT FALSE;
22: v_match_found BOOLEAN DEFAULT FALSE;

Line 27: FROM IGS_AD_PRD_PS_OF_OPT

23: CURSOR c_apcoo IS
24: SELECT DISTINCT course_cd,
25: version_number,
26: acad_cal_type
27: FROM IGS_AD_PRD_PS_OF_OPT
28: WHERE adm_cal_type = p_old_adm_cal_type AND
29: adm_ci_sequence_number = p_old_adm_ci_sequence_number AND
30: admission_cat = p_old_admission_cat;
31: BEGIN