DBA Data[Home] [Help]

APPS.IGS_EN_ELGBL_PROGRAM dependencies on IGS_PS_OFR_OPT

Line 1367: CURSOR c_get_att_type(p_coo_id IGS_PS_OFR_OPT.coo_id%TYPE) IS

1363: AND course_cd = p_course_cd
1364: AND uoo_id = p_uoo_id;
1365:
1366: -- added by ckasu as a part of EN317 SS UI Build bug#4377985
1367: CURSOR c_get_att_type(p_coo_id IGS_PS_OFR_OPT.coo_id%TYPE) IS
1368: SELECT attendance_type
1369: FROM IGS_PS_OFR_OPT
1370: WHERE coo_id = p_coo_id;
1371:

Line 1369: FROM IGS_PS_OFR_OPT

1365:
1366: -- added by ckasu as a part of EN317 SS UI Build bug#4377985
1367: CURSOR c_get_att_type(p_coo_id IGS_PS_OFR_OPT.coo_id%TYPE) IS
1368: SELECT attendance_type
1369: FROM IGS_PS_OFR_OPT
1370: WHERE coo_id = p_coo_id;
1371:
1372:
1373:

Line 1399: l_att_type IGS_PS_OFR_OPT.ATTENDANCE_TYPE%TYPE;

1395: l_credit_points igs_en_config_enr_cp.min_cp_per_term%TYPE;
1396: l_min_credit_point igs_en_config_enr_cp.min_cp_per_term%TYPE;
1397: l_deny_warn VARCHAR2(20);
1398:
1399: l_att_type IGS_PS_OFR_OPT.ATTENDANCE_TYPE%TYPE;
1400:
1401: l_message VARCHAR2(2000);
1402: l_message_icon VARCHAR2(1);
1403: