APPS.IGS_SS_EN_WRAPPERS dependencies on IGS_EN_SPL_PERM

Line 3500: FROM igs_en_spl_perm spl

3496: cur_plan_unit_rec cur_plan_unit%ROWTYPE;
3497:
3498: CURSOR cur_permission_unit(cp_uoo_id IN NUMBER) IS
3499: SELECT spl.spl_perm_request_id
3500: FROM igs_en_spl_perm spl
3501: WHERE spl.student_person_id= p_person_id
3502: AND spl.uoo_id = cp_uoo_id
3503: AND spl.transaction_type <> 'WITHDRAWN';
3504:

Line 4104: FROM Igs_En_Spl_Perm

4100:
4101:
4102: CURSOR c_approv_perm IS
4103: SELECT approval_status
4104: FROM Igs_En_Spl_Perm
4105: WHERE student_person_id = p_person_id
4106: AND uoo_id = p_uoo_id
4107: AND request_type = 'AUDIT_PERM'
4108: AND transaction_type <> 'WITHDRAWN' ;

Line 4152: l_approval_status igs_en_spl_perm.approval_status%TYPE;

4148: l_alternate_code igs_ca_inst.alternate_code%TYPE;
4149: l_notification_flag igs_en_cpd_ext.notification_flag%TYPE;
4150: l_message fnd_new_messages.message_name%TYPE;
4151: l_acad_cal_type igs_ca_inst_rel.sub_cal_type%TYPE;
4152: l_approval_status igs_en_spl_perm.approval_status%TYPE;
4153: l_audit_allowed igs_ps_unit_ofr_opt.auditable_ind%TYPE;
4154: l_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;
4155: l_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE;
4156: l_au_perm_req igs_ps_unit_ofr_opt.audit_permission_ind%TYPE;

Line 4494: FROM igs_en_spl_perm spl

4490: -------------------------------------------------------------------
4491:
4492: CURSOR c_perm(cp_request_id NUMBER) IS
4493: SELECT spl.ROWID,spl.*
4494: FROM igs_en_spl_perm spl
4495: WHERE spl.spl_perm_request_id=cp_request_id;
4496: l_data c_perm%ROWTYPE;
4497:
4498: BEGIN

Line 4502: igs_en_spl_perm_pkg.update_row(

4498: BEGIN
4499: OPEN c_perm(p_request_id);
4500: FETCH c_perm INTO l_data;
4501: IF c_perm%FOUND THEN
4502: igs_en_spl_perm_pkg.update_row(
4503: x_rowid => l_data.rowid,
4504: x_spl_perm_request_id => l_data.spl_perm_request_id,
4505: x_student_person_id => l_data.student_person_id,
4506: x_uoo_id => l_data.uoo_id,

Line 4946: SELECT 'X' FROM igs_en_spl_perm perm

4942: p_request_type IN VARCHAR2) return varchar2 as
4943:
4944:
4945: CURSOR cur_perm_exists is
4946: SELECT 'X' FROM igs_en_spl_perm perm
4947: WHERE perm.uoo_id = p_uoo_id
4948: AND perm.student_person_id = p_person_id
4949: AND perm.approval_status <> 'A'
4950: AND perm.request_type <> p_request_type;