1 PACKAGE igs_da_reqst_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSDA04S.pls 115.8 2003/04/07 06:59:17 nalkumar noship $ */
3
4 /***************************************************************************************************************
5
6 Created By: Arun Iyer
7
8 Date Created By: 26-11-2001
9
10 Purpose: This package is called from the Request self service screens.
11 It has procedure which captures the request information into the Degree Audit data exchange area
12 and call the out NOCOPY packages to fetch data from the Oss tables.
13
14 Known limitations,enhancements,remarks:
15
16 Change History
17
18 Who When What
19 Aiyer 19-Feb-2002 Changes have been made as a part of the code fix for the bug 2233298
20 Added IN OUT NOCOPY parameters p_major_seq_num ,p_minor_seq_num,p_track_seq_num
21 to procedures insert_majors, insert_minors, insert_tracks respectively
22
23 rgangara 22-Feb-2002 Added parameter Alt_Person_id to Insert_student_requesst procedure
24 as part of CCR SWCR009 Bug# 2237145
25
26 Aiyer 12-Dec-2002 Procedure validate_batch_request and insert_batch_request modified for
27 the bug #2638656.Obsoletion of athletic_program_id field from these procedures
28 Nalin Kumar 07-Apr-2003 Obsoleted the 'Degree Audit Single Request Submission' & 'Degree Audit Multiple Request Submission' Job.
29 This is as per DA UI Build. Bug# 2829285.
30 ****************************************************************************************************************** */
31
32 PROCEDURE single_da_request (errbuf OUT NOCOPY VARCHAR2,
33 retcode OUT NOCOPY NUMBER,
34 p_batch_id IN NUMBER,
35 p_org_id IN NUMBER);
36
37 PROCEDURE multiple_da_request (errbuf OUT NOCOPY VARCHAR2,
38 retcode OUT NOCOPY NUMBER,
39 p_batch_id IN NUMBER,
40 p_org_id IN NUMBER);
41 END igs_da_reqst_pkg;