[Home] [Help]
PACKAGE: APPS.IGS_AD_GEN_002
Source
1 PACKAGE IGS_AD_GEN_002 AS
2 /* $Header: IGSAD02S.pls 120.6 2005/11/02 18:42:22 appldev ship $ */
3 -------------------------------------------------------------------------------------------
4 --Change History:
5 --Who When What
6 --knag 04-Oct-02 Bug 2602096 : Created the function Admp_Get_Appl_ID to return Application ID
7 -- and the function Admp_Get_Fee_Status to return Appl Fee Status
8 --anwest 20-Jul-05 IGS.M ADTD003:Created for the Submitted
9 -- Applications Reusable Component
10 -- to further derive the PENDING fee
11 -- status
12 --anwest 03-Nov-05 IGS.M ADTD002:Created function Is_EntQualCode_Allowed
13 -------------------------------------------------------------------------------------------
14
15 Procedure Admp_Ext_Tac_Arts(
16 p_input_file IN VARCHAR2 ,
17 p_output_file IN VARCHAR2 ,
18 p_directory IN VARCHAR2 );
19
20
21
22 Procedure Admp_Ext_Vtac_Return(
23 errbuf OUT NOCOPY VARCHAR2 ,
24 retcode OUT NOCOPY NUMBER ,
25 p_acad_perd IN VARCHAR2,
26 p_input_file IN VARCHAR2,
27 p_org_id IN NUMBER);
28
29 Function Admp_Get_Aal_Sent_Dt(
30 p_person_id IN NUMBER ,
31 p_admission_appl_number IN NUMBER ,
32 p_correspondence_type IN VARCHAR2 ,
33 p_sequence_number IN NUMBER )
34 RETURN DATE;
35
36 Function Admp_Get_Aa_Aas(
37 p_person_id IN NUMBER ,
38 p_admission_appl_number IN NUMBER ,
39 p_adm_appl_status IN VARCHAR2 )
40 RETURN VARCHAR2;
41
42 Procedure Admp_Get_Aa_Created(
43 p_person_id IN NUMBER ,
44 p_admission_appl_number IN NUMBER ,
45 p_create_who OUT NOCOPY VARCHAR2 ,
46 p_create_on OUT NOCOPY DATE );
47
48 Procedure Admp_Get_Aa_Dtl(
49 p_person_id IN NUMBER ,
50 p_admission_appl_number IN NUMBER ,
51 p_admission_cat OUT NOCOPY VARCHAR2 ,
52 p_s_admission_process_type OUT NOCOPY VARCHAR2 ,
53 p_acad_cal_type OUT NOCOPY VARCHAR2 ,
54 p_acad_ci_sequence_number OUT NOCOPY NUMBER ,
55 p_adm_cal_type OUT NOCOPY VARCHAR2 ,
56 p_adm_ci_sequence_number OUT NOCOPY NUMBER ,
57 p_appl_dt OUT NOCOPY DATE ,
58 p_adm_appl_status OUT NOCOPY VARCHAR2 ,
59 p_adm_fee_status OUT NOCOPY VARCHAR2 );
60
61 Function Admp_Get_Acai_Acadcd(
62 p_person_id IN NUMBER ,
63 p_admission_appl_number IN NUMBER ,
64 p_acad_cal_type IN VARCHAR2 ,
65 p_adm_cal_type IN VARCHAR2 ,
66 p_adm_ci_sequence_number IN NUMBER )
67 RETURN VARCHAR2;
68
69 PRAGMA RESTRICT_REFERENCES (Admp_Get_Acai_Acadcd,WNDS);
70
71 Function Admp_Get_Acai_Aos_Dt(
72 p_person_id IN NUMBER ,
73 p_admission_appl_number IN NUMBER ,
74 p_nominated_course_cd IN VARCHAR2 ,
75 p_acai_sequence_number IN NUMBER )
76 RETURN DATE;
77
78
79
80 Procedure ADMS_EXT_TAC_ARTS (
81
82 errbuf out NOCOPY varchar2,
83
84 retcode out NOCOPY number,
85
86 p_input_file IN VARCHAR2 ,
87 p_org_id IN NUMBER);
88
89 Function Admp_Get_Appl_ID(
90 p_person_id IN NUMBER ,
91 p_admission_appl_number IN NUMBER)
92 RETURN NUMBER;
93
94 Function Admp_Get_Fee_Status(
95 p_person_id IN NUMBER ,
96 p_admission_appl_number IN NUMBER)
97 RETURN VARCHAR2;
98
99 PROCEDURE check_adm_appl_inst_stat(
100 p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
101 p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
102 p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE DEFAULT NULL,
103 p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE DEFAULT NULL,
104 p_updateable VARCHAR2 DEFAULT 'N' -- apadegal - TD001 - IGS.M.
105 );
106
107
108 -- This function will return true if for this application at least one application instance has an application offer response
109 -- status of 'Accepted' OR the offer response status is 'Deffered' with the deferment status as 'Confirmed'. For all other
110 -- cases it will return false. -- rghosh (bug#2901627)
111 FUNCTION valid_ofr_resp_status(
112 p_person_id igs_ad_ps_appl_inst.person_id%TYPE ,
113 p_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE)
114 RETURN BOOLEAN ;
115
116 -- 20-Jul-2005 ANWEST Created for the Submitted Applications Reusable Component
117 -- (ADTD003) in IGS.M
118 FUNCTION res_pending_fee_status
119 (
120 p_application_id IN NUMBER
121 )
122 RETURN VARCHAR2;
123
124 PROCEDURE Admp_resub_inst(
125 p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
126 p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
127 p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
128 p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
129 p_do_commit VARCHAR2 DEFAULT NULL,
130 x_return_status OUT NOCOPY VARCHAR2,
131 x_msg_count OUT NOCOPY NUMBER,
132 x_msg_data OUT NOCOPY VARCHAR2
133 );
134
135 --Begin apadegal TD001 IGS.M
136
137 FUNCTION check_any_offer_inst
138 (p_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,
139 p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
140 p_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE DEFAULT NULL,
141 p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE DEFAULT NULL
142 )
143 RETURN BOOLEAN;
144
145 FUNCTION Is_App_Inst_Complete (
146 p_person_id IN NUMBER ,
147 p_admission_appl_number IN NUMBER ,
148 p_nominated_course_cd IN VARCHAR2,
149 p_sequence_number IN NUMBER
150 )
151 RETURN VARCHAR2;
152
153 PROCEDURE Is_inst_recon_allowed ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
154 p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
155 p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
156 p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
157 p_success out nocopy VARCHAR2,
158 p_message_name out nocopy VARCHAR2
159 );
160 FUNCTION Is_inst_recon_allowed ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
161 p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
162 p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
163 p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE
164 )
165 RETURN VARCHAR2;
166
167
168 PROCEDURE Reconsider_Appl_Inst (
169 p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
170 p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
171 p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
172 p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
173 p_interface VARCHAR2 -- Interface which has raised reconsideration ( Forms,Self service, Import process)
174 ) ;
175
176
177 PROCEDURE Recon_Appl_inst (
178 p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
179 p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
180 p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
181 p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
182 p_interface VARCHAR2 -- Interface which has raised reconsideration ( Forms,Self service, Import process)
183 ); --- this procedure would be invoked from
184
185 FUNCTION check_adm_appl_inst_stat( -- An overloaded function - would be invoked in Self Service
186 p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
187 p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
188 p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE DEFAULT NULL,
189 p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE DEFAULT NULL,
190 p_updateable VARCHAR2 DEFAULT 'N' -- apadegal - TD001 - IGS.M.
191 )
192 RETURN VARCHAR2;
193
194
195 PROCEDURE ins_dummy_pend_hist_rec ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
196 p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
197 p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE
198 ) ;
199
200 --End apadegal TD001 IGS.m
201
202 -- 02-NOV-05 ANWEST Created for IGS.M ADTD002 AT Testing Issue #327
203 FUNCTION Is_EntQualCode_Allowed (p_person_id IN NUMBER ,
204 p_admission_appl_number IN NUMBER ,
205 p_nominated_course_cd IN VARCHAR2,
206 p_sequence_number IN NUMBER)
207 RETURN VARCHAR2;
208
209 END IGS_AD_GEN_002;