APPS.IGS_EN_SPL_PERM_PKG dependencies on IGS_EN_SPL_PERM_S

Line 157: l_spl_perm_request_id igs_en_spl_perm.spl_perm_request_id%TYPE;

153: (reverse chronological order - newest change first)
154: *************************************************************************/
155: l_message_name VARCHAR2(30);
156: l_return_type VARCHAR2(1);
157: l_spl_perm_request_id igs_en_spl_perm.spl_perm_request_id%TYPE;
158: l_date_submission igs_en_spl_perm.date_submission%TYPE;
159: l_audit_the_course igs_en_spl_perm.audit_the_course%TYPE;
160: l_approval_status igs_en_spl_perm.approval_status%TYPE;
161: l_reason_for_request igs_en_spl_perm.reason_for_request%TYPE;

Line 164: l_student_more_info igs_en_spl_perm.student_more_info%TYPE;

160: l_approval_status igs_en_spl_perm.approval_status%TYPE;
161: l_reason_for_request igs_en_spl_perm.reason_for_request%TYPE;
162: l_instructor_more_info igs_en_spl_perm.instructor_more_info%TYPE;
163: l_instructor_deny_info igs_en_spl_perm.instructor_deny_info%TYPE;
164: l_student_more_info igs_en_spl_perm.student_more_info%TYPE;
165: l_transaction_type igs_en_spl_perm.transaction_type%TYPE;
166: l_rowid VARCHAR2(20);
167: l_spl_perm_request_h_id igs_en_spl_perm_h.spl_perm_request_h_id%TYPE;
168:

Line 715: SELECT igs_en_spl_perm_s.NEXTVAL

711: igs_ge_msg_stack.add;
712: app_exception.raise_exception;
713: END IF;
714:
715: SELECT igs_en_spl_perm_s.NEXTVAL
716: INTO x_spl_perm_request_id
717: FROM dual;
718:
719: