1 PACKAGE IGS_RE_VAL_CA AS
2 /* $Header: IGSRE04S.pls 120.0 2005/06/02 03:47:46 appldev noship $ */
3 -------------------------------------------------------------------------------------------
4 --Change History:
5 --Who When What
6 --smadathi 29-AUG-2001 Bug No. 1956374 .The function declaration of genp_val_sdtt_sess removed
7 --kkillams 11-11-2002 As part of Legacy Build bug no:2661533,
8 -- New parameter p_legacy is added to following functions
9 -- resp_val_ca_minsbmsn,resp_val_ca_maxsbmsn and resp_val_ca_topic
10 -------------------------------------------------------------------------------------------
11
12 /***** Bug No : 1956374
13 Task : Duplicated Procedures and functions
14 || Removed program unit (RESP_VAL_CA_ATT_PERC) - from the spec and body. -- kdande
15 PROCEDURE admp_val_ca_comm , admp_val_ca_comm_val is removed *****/
16
17 -- Validate adm IGS_PS_COURSE application proposed commencement date.
18
19 FUNCTION admp_val_acai_comm(
20
21 p_person_id IN NUMBER ,
22
23 p_course_cd IN VARCHAR2 ,
24
25 p_crv_version_number IN NUMBER ,
26
27 p_acai_admission_appl_number IN NUMBER ,
28
29 p_acai_nominated_course_cd IN VARCHAR2 ,
30
31 p_acai_sequence_number IN NUMBER ,
32
33 p_adm_cal_type IN VARCHAR2 ,
34
35 p_adm_ci_sequence_number IN NUMBER ,
36
37 p_adm_outcome_status IN VARCHAR2 ,
38
39 p_prpsd_commencement_dt IN DATE ,
40
41 p_min_submission_dt IN DATE ,
42
43 p_ca_sequence_number IN OUT NOCOPY NUMBER ,
44
45 p_parent IN VARCHAR2 ,
46
47 p_message_name OUT NOCOPY VARCHAR2 )
48
49 RETURN BOOLEAN;
50 --
51
52 -- Validate IGS_RE_CANDIDATURE update.
53
54 FUNCTION resp_val_ca_upd(
55
56 p_person_id IN NUMBER ,
57
58 p_sca_course_cd IN VARCHAR2 ,
59
60 p_message_name OUT NOCOPY VARCHAR2 )
61
62 RETURN BOOLEAN;
63
64 --
65
66 -- Validate IGS_RE_CANDIDATURE research topic.
67
68 FUNCTION resp_val_ca_topic(
69 p_person_id IN NUMBER ,
70 p_sca_course_cd IN VARCHAR2 ,
71 p_acai_admission_appl_number IN NUMBER ,
72 p_acai_nominated_course_cd IN VARCHAR2 ,
73 p_acai_sequence_number IN NUMBER ,
74 p_research_topic IN VARCHAR2 ,
75 p_message_name OUT NOCOPY VARCHAR2 ,
76 p_legacy IN VARCHAR2 DEFAULT 'N' )
77
78 RETURN BOOLEAN;
79
80
81
82 -- Validate IGS_RE_CANDIDATURE ACAI link.
83
84 FUNCTION resp_val_ca_acai(
85
86 p_person_id IN NUMBER ,
87
88 p_ca_sequence_number IN NUMBER ,
89
90 p_sca_course_cd IN VARCHAR2 ,
91
92 p_old_acai_admission_appl_num IN NUMBER ,
93
94 p_old_acai_nominated_course_cd IN VARCHAR2 ,
95
96 p_old_acai_sequence_number IN NUMBER ,
97
98 p_acai_admission_appl_number IN NUMBER ,
99
100 p_acai_nominated_course_cd IN VARCHAR2 ,
101
102 p_acai_sequence_number IN NUMBER ,
103
104 p_message_name OUT NOCOPY VARCHAR2 )
105
106 RETURN BOOLEAN;
107
108
109 --
110
111 -- Validate IGS_RE_CANDIDATURE maximum submission date.
112
113 FUNCTION resp_val_ca_maxsbmsn(
114 p_person_id IN NUMBER ,
115 p_sca_course_cd IN VARCHAR2 ,
116 p_acai_admission_appl_number IN NUMBER ,
117 p_acai_nominated_course_cd IN VARCHAR2 ,
118 p_acai_sequence_number IN NUMBER ,
119 p_min_submission_dt IN DATE ,
120 p_max_submission_dt IN DATE ,
121 p_attendance_percentage IN NUMBER ,
122 p_commencement_dt IN DATE ,
123 p_message_name OUT NOCOPY VARCHAR2,
124 p_legacy IN VARCHAR2 DEFAULT 'N' )
125
126 RETURN BOOLEAN;
127
128
129 -- Validate IGS_RE_CANDIDATURE minimum submission date.
130
131 FUNCTION resp_val_ca_minsbmsn(
132 p_person_id IN NUMBER ,
133 p_sca_course_cd IN VARCHAR2 ,
134 p_acai_admission_appl_number IN NUMBER ,
135 p_acai_nominated_course_cd IN VARCHAR2 ,
136 p_acai_sequence_number IN NUMBER ,
137 p_min_submission_dt IN DATE ,
138 p_max_submission_dt IN DATE ,
139 p_attendance_percentage IN NUMBER ,
140 p_commencement_dt IN DATE ,
141 p_message_name OUT NOCOPY VARCHAR2,
142 p_legacy IN VARCHAR2 DEFAULT 'N' )
143
144 RETURN BOOLEAN;
145
146 -- Validate IGS_RE_CANDIDATURE SCA link.
147
148 FUNCTION resp_val_ca_sca(
149
150 p_person_id IN NUMBER ,
151
152 p_ca_sequence_number IN NUMBER ,
153
154 p_old_sca_course_cd IN VARCHAR2 ,
155
156 p_sca_course_cd IN VARCHAR2 ,
157
158 p_acai_admission_appl_number IN NUMBER ,
159
160 p_acai_nominated_course_cd IN VARCHAR2 ,
161
162 p_acai_sequence_number IN NUMBER ,
163
164 p_message_name OUT NOCOPY VARCHAR2 )
165
166 RETURN BOOLEAN;
167
168 -- Validate IGS_RE_CANDIDATURE deletion and ACAI link.
169
170 FUNCTION resp_val_ca_acai_del(
171
172 p_person_id IN NUMBER ,
173
174 p_acai_admission_appl_number IN NUMBER ,
175
176 p_acai_nominated_course_cd IN VARCHAR2 ,
177
178 p_acai_sequence_number IN NUMBER ,
179
180 p_message_name OUT NOCOPY VARCHAR2 )
181
182 RETURN BOOLEAN;
183
184 -- Validate IGS_RE_CANDIDATURE SCA link when deleting.
185
186 FUNCTION resp_val_ca_sca_del(
187
188 p_person_id IN NUMBER ,
189
190 p_sca_course_cd IN VARCHAR2 ,
191
192 p_message_name OUT NOCOPY VARCHAR2 )
193
194 RETURN BOOLEAN;
195
196 -- Validate if Government Type of Activity Classification Code is closed.
197
198 FUNCTION resp_val_gtcc_closed(
199
200 p_govt_toa_class_cd IN VARCHAR2 ,
201
202 p_message_name OUT NOCOPY VARCHAR2 )
203
204 RETURN BOOLEAN;
205
206 -- Validate IGS_RE_CANDIDATURE SCA/ACAI link.
207
208 FUNCTION resp_val_ca_sca_acai(
209
210 p_person_id IN NUMBER ,
211
212 p_sca_course_cd IN VARCHAR2 ,
213
214 p_acai_admission_appl_number IN NUMBER ,
215
216 p_acai_nominated_course_cd IN VARCHAR2 ,
217
218 p_acai_sequence_number IN NUMBER ,
219
220 p_message_name OUT NOCOPY VARCHAR2 )
221
222 RETURN BOOLEAN;
223
224 END IGS_RE_VAL_CA;