1 PACKAGE BODY igs_da_reqst_pkg AS
2 /* $Header: IGSDA04B.pls 115.41 2003/04/07 07:08:39 nalkumar noship $ */
3
4
5 /**************************************************************************************************************************
6
7 Created By: Arun Iyer
8
9 Date Created By: 20-11-2001
10
11 Purpose: The various procedures in this package would be called by the Self service Request screen
12 and the In and Out NOCOPY Degree Audit Packages.
13 This has been made as per the Degree Audit Dld Bug # 2033208
14 This package does the functionality of storing request information that has been given by
15 the self service screen and updated by the various packages
16
17 Known limitations,enhancements,remarks:
18
19 Change History
20
21 Who When What
22 Aiyer 19-Feb-2002 Changes have been made as a part of the code fix for the bug 2233298
23 Added IN OUT NOCOPY parameters p_major_seq_num ,p_minor_seq_num,p_track_seq_num
24 to procedures insert_majors, insert_minors, insert_tracks respectively
25
26 rgangara 22-Feb-2002 Enchancements as per CCR SWCR009. Bug# 2237145.
27 Added Alt_person_id as parameter in Insert_batch_request, Insert_student_request procedures
28 rgangara 25-Feb-2002 Fixing of Review comments
29 Aiyer 08-Mar-2002 Fix for the bug 2248040. Validation 10 in Validate Request procedure was added as a part of this bug
30 Aiyer 20-Mar-2002 The procedure delete_request has been modified due to the performance bug #2219307
31 Aiyer 16-May-2002 The procedure insert_batch_student was changed for the fix of the bugs 2370194,2370165
32 Aiyer 16-May-2002 The procedure insert_batch_student was modified for the fix of the bug 2369716
33 Aiyer 22-May-2002 The procedure insert_batch_student was modified for the fix of the bug 2370124
34 Aiyer 19-Jun-2002 The procedure Update_request and Submit_audit_request have been modifed for the fix of the bug 2422143.
35 Aiyer 29-May-2002 This has been done as a part of the bug fix for the bug 2415113. The procedure insert_batch_students has
36 been modified for this fix.
37 Aiyer 11-Jul-2002 This has been done as a part of the bug fix for the bug 2453391. The procedure insert_batch_students has
38 been modified for this fix.
39 DDEY 09-Aug-2002 The Dyanmic SQL query for Graduation Term is changed as per the bug # 2436029 .
40 kumma 18-OCT-2002 Changed the query to fetch the new columns from igs_pe_athletic_dtl_v and igs_pe_athletic_prg_v, 2608360
41 kumma 08-NOV-2002 Removed the Default Keywords from the procedure signatures
42 Aiyer 12-Dec-2002 Procedure validate_batch_request and insert_batch_request modified for
43 the bug #2638656.Obsoletion of athletic_program_id field from these procedures
44 Nalin Kumar 07-Apr-2003 Obsoleted the 'Degree Audit Single Request Submission' & 'Degree Audit Multiple Request Submission' Job.
45 This is as per DA UI Build. Bug# 2829285.
46 ******************************************************************************************************************************/
47 PROCEDURE single_da_request (errbuf OUT NOCOPY VARCHAR2,
48 retcode OUT NOCOPY NUMBER,
49 p_batch_id IN NUMBER,
50 p_org_id IN NUMBER) IS
51 BEGIN
52 -- This concurrent job is made obsolete as part of Enh#2829285. If user tried to
53 -- run the program then an error message should be written to the Log file that
54 -- the Concurrent Program is obsolete and this should not be run. DA UI Build.
55 FND_MESSAGE.Set_Name('IGS', 'IGS_GE_OBSOLETE_JOB');
56 FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
57 retcode := 0;
58 END single_da_request;
59
60 PROCEDURE multiple_da_request (errbuf OUT NOCOPY VARCHAR2,
61 retcode OUT NOCOPY NUMBER,
62 p_batch_id IN NUMBER,
63 p_org_id IN NUMBER) IS
64 BEGIN
65 -- This concurrent job is made obsolete as part of Enh#2829285. If user tried to
66 -- run the program then an error message should be written to the Log file that
67 -- the Concurrent Program is obsolete and this should not be run. DA UI Build.
68 FND_MESSAGE.Set_Name('IGS', 'IGS_GE_OBSOLETE_JOB');
69 FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
70 retcode := 0;
71 END multiple_da_request;
72 END igs_da_reqst_pkg;