APPS.IGS_PS_VALIDATE_LGCY_PKG dependencies on IGS_PS_USEC_LIM_WLST

Line 3004: FROM igs_ps_usec_lim_wlst

3000: AND a.delete_flag='N';
3001:
3002: CURSOR c_usec_lim(cp_n_uoo_id NUMBER) IS
3003: SELECT *
3004: FROM igs_ps_usec_lim_wlst
3005: WHERE uoo_id = cp_n_uoo_id;
3006:
3007: c_usec_lim_rec c_usec_lim%ROWTYPE;
3008: rec_act c_act%ROWTYPE;

Line 3015: CURSOR cur_db_value(cp_uoo_id igs_ps_usec_lim_wlst.uoo_id%TYPE) IS

3011: FROM igs_en_su_attempt
3012: WHERE uoo_id = cp_uoo_id
3013: AND no_assessment_ind = 'Y';
3014:
3015: CURSOR cur_db_value(cp_uoo_id igs_ps_usec_lim_wlst.uoo_id%TYPE) IS
3016: SELECT max_auditors_allowed
3017: FROM igs_ps_usec_lim_wlst
3018: WHERE uoo_id = cp_uoo_id;
3019:

Line 3017: FROM igs_ps_usec_lim_wlst

3013: AND no_assessment_ind = 'Y';
3014:
3015: CURSOR cur_db_value(cp_uoo_id igs_ps_usec_lim_wlst.uoo_id%TYPE) IS
3016: SELECT max_auditors_allowed
3017: FROM igs_ps_usec_lim_wlst
3018: WHERE uoo_id = cp_uoo_id;
3019:
3020: CURSOR c_usec_wlst_pri(cp_n_uoo_id NUMBER) IS
3021: SELECT 'X' FROM igs_ps_usec_wlst_pri

Line 3035: l_max_auditors_allowed igs_ps_usec_lim_wlst.max_auditors_allowed%TYPE;

3031: AND a.unit_cd=cp_unit_cd
3032: AND a.version_number=cp_version_number;
3033: c_usec_st_rec c_usec_st%ROWTYPE;
3034:
3035: l_max_auditors_allowed igs_ps_usec_lim_wlst.max_auditors_allowed%TYPE;
3036: l_ctx_value igs_ps_usec_lim_wlst.max_auditors_allowed%TYPE := p_usec_rec.max_auditors_allowed;
3037: l_count NUMBER;
3038: l_c_waitlist_allowed igs_ps_unit_ofr_pat_all.waitlist_allowed%TYPE;
3039: l_message_name VARCHAR2(30);

Line 3036: l_ctx_value igs_ps_usec_lim_wlst.max_auditors_allowed%TYPE := p_usec_rec.max_auditors_allowed;

3032: AND a.version_number=cp_version_number;
3033: c_usec_st_rec c_usec_st%ROWTYPE;
3034:
3035: l_max_auditors_allowed igs_ps_usec_lim_wlst.max_auditors_allowed%TYPE;
3036: l_ctx_value igs_ps_usec_lim_wlst.max_auditors_allowed%TYPE := p_usec_rec.max_auditors_allowed;
3037: l_count NUMBER;
3038: l_c_waitlist_allowed igs_ps_unit_ofr_pat_all.waitlist_allowed%TYPE;
3039: l_message_name VARCHAR2(30);
3040:

Line 3041: l_n_enr_max IGS_PS_USEC_LIM_WLST.ENROLLMENT_MAXIMUM%TYPE;

3037: l_count NUMBER;
3038: l_c_waitlist_allowed igs_ps_unit_ofr_pat_all.waitlist_allowed%TYPE;
3039: l_message_name VARCHAR2(30);
3040:
3041: l_n_enr_max IGS_PS_USEC_LIM_WLST.ENROLLMENT_MAXIMUM%TYPE;
3042: l_n_wlst_max IGS_PS_USEC_LIM_WLST.MAX_STUDENTS_PER_WAITLIST%TYPE;
3043: l_c_wlst_allowed IGS_PS_USEC_LIM_WLST.WAITLIST_ALLOWED%TYPE;
3044: l_n_enr_act IGS_PS_UNIT_OFR_OPT_ALL.ENROLLMENT_ACTUAL%TYPE;
3045: l_n_wlst_act IGS_PS_UNIT_OFR_OPT_ALL.WAITLIST_ACTUAL%TYPE;

Line 3042: l_n_wlst_max IGS_PS_USEC_LIM_WLST.MAX_STUDENTS_PER_WAITLIST%TYPE;

3038: l_c_waitlist_allowed igs_ps_unit_ofr_pat_all.waitlist_allowed%TYPE;
3039: l_message_name VARCHAR2(30);
3040:
3041: l_n_enr_max IGS_PS_USEC_LIM_WLST.ENROLLMENT_MAXIMUM%TYPE;
3042: l_n_wlst_max IGS_PS_USEC_LIM_WLST.MAX_STUDENTS_PER_WAITLIST%TYPE;
3043: l_c_wlst_allowed IGS_PS_USEC_LIM_WLST.WAITLIST_ALLOWED%TYPE;
3044: l_n_enr_act IGS_PS_UNIT_OFR_OPT_ALL.ENROLLMENT_ACTUAL%TYPE;
3045: l_n_wlst_act IGS_PS_UNIT_OFR_OPT_ALL.WAITLIST_ACTUAL%TYPE;
3046: l_c_usec_status IGS_PS_UNIT_OFR_OPT_ALL.UNIT_SECTION_STATUS%TYPE := NULL;

Line 3043: l_c_wlst_allowed IGS_PS_USEC_LIM_WLST.WAITLIST_ALLOWED%TYPE;

3039: l_message_name VARCHAR2(30);
3040:
3041: l_n_enr_max IGS_PS_USEC_LIM_WLST.ENROLLMENT_MAXIMUM%TYPE;
3042: l_n_wlst_max IGS_PS_USEC_LIM_WLST.MAX_STUDENTS_PER_WAITLIST%TYPE;
3043: l_c_wlst_allowed IGS_PS_USEC_LIM_WLST.WAITLIST_ALLOWED%TYPE;
3044: l_n_enr_act IGS_PS_UNIT_OFR_OPT_ALL.ENROLLMENT_ACTUAL%TYPE;
3045: l_n_wlst_act IGS_PS_UNIT_OFR_OPT_ALL.WAITLIST_ACTUAL%TYPE;
3046: l_c_usec_status IGS_PS_UNIT_OFR_OPT_ALL.UNIT_SECTION_STATUS%TYPE := NULL;
3047: l_request_id NUMBER;