APPS.IGS_AD_VAL_ACAI dependencies on IGS_PS_OFR_PAT

Line 1170: FROM IGS_PS_OFR_PAT

1166: cp_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE,
1167: cp_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE,
1168: cp_attendance_type IGS_AD_PS_APPL_INST.attendance_type%TYPE) IS
1169: SELECT 'x'
1170: FROM IGS_PS_OFR_PAT
1171: WHERE course_cd = cp_course_cd AND
1172: version_number = cp_version_number AND
1173: cal_type = cp_acad_cal_type AND
1174: ci_sequence_number = cp_acad_ci_sequence_number AND

Line 1508: v_location_cd IGS_PS_OFR_PAT.location_cd%TYPE;

1504: BEGIN -- admp_val_acai_opt
1505: -- Validate the admission course application instance offering option details.
1506: DECLARE
1507: v_rec_found BOOLEAN :=FALSE;
1508: v_location_cd IGS_PS_OFR_PAT.location_cd%TYPE;
1509: v_attendance_mode IGS_PS_OFR_PAT.attendance_mode%TYPE;
1510: v_attendance_type IGS_PS_OFR_PAT.attendance_type%TYPE;
1511: v_message_name VARCHAR2(30);
1512: CURSOR c_acopv IS

Line 1509: v_attendance_mode IGS_PS_OFR_PAT.attendance_mode%TYPE;

1505: -- Validate the admission course application instance offering option details.
1506: DECLARE
1507: v_rec_found BOOLEAN :=FALSE;
1508: v_location_cd IGS_PS_OFR_PAT.location_cd%TYPE;
1509: v_attendance_mode IGS_PS_OFR_PAT.attendance_mode%TYPE;
1510: v_attendance_type IGS_PS_OFR_PAT.attendance_type%TYPE;
1511: v_message_name VARCHAR2(30);
1512: CURSOR c_acopv IS
1513: SELECT location_cd,

Line 1510: v_attendance_type IGS_PS_OFR_PAT.attendance_type%TYPE;

1506: DECLARE
1507: v_rec_found BOOLEAN :=FALSE;
1508: v_location_cd IGS_PS_OFR_PAT.location_cd%TYPE;
1509: v_attendance_mode IGS_PS_OFR_PAT.attendance_mode%TYPE;
1510: v_attendance_type IGS_PS_OFR_PAT.attendance_type%TYPE;
1511: v_message_name VARCHAR2(30);
1512: CURSOR c_acopv IS
1513: SELECT location_cd,
1514: attendance_mode,

Line 1516: FROM IGS_PS_OFR_PAT_OFERPAT_V

1512: CURSOR c_acopv IS
1513: SELECT location_cd,
1514: attendance_mode,
1515: attendance_type
1516: FROM IGS_PS_OFR_PAT_OFERPAT_V
1517: WHERE course_cd = p_course_cd AND
1518: version_number = p_version_number AND
1519: acad_cal_type = p_acad_cal_type AND
1520: acad_ci_sequence_number = p_acad_ci_sequence_number AND