eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.IGS_EN_VAL_SCHO

Source


1 PACKAGE IGS_EN_VAL_SCHO AUTHID CURRENT_USER AS
2 /* $Header: IGSEN63S.pls 115.4 2002/11/29 00:06:28 nsidana ship $ */
3   -------------------------------------------------------------------------------------------
4   --Change History:
5   --Who         When            What
6   --smadathi    27-AUG-2001     Bug No. 1956374 .The function Declaration GENP_VAL_STRT_END_DT
7   --                            removed .
8   --smadathi    25-AUG-2001     Bug No. 1956374 .The function Declaration GENP_VAL_SDTT_SESS
9   --                            removed .
10   -------------------------------------------------------------------------------------------
11   -- The pl/sql table of rowid has been removed according to vaw008 step 3.9
12   -- Dt :08-Nov-99
13 
14   cst_error CONSTANT VARCHAR2(1) DEFAULT 'E';
15   --
16   --
17   cst_warn CONSTANT VARCHAR2(1) DEFAULT 'W';
18   --
19   --
20   cst_info CONSTANT VARCHAR2(1) DEFAULT 'I';
21   --
22   --
23   cst_collection_yr CONSTANT NUMBER(4) DEFAULT TO_NUMBER(TO_CHAR(SYSDATE, 'YYYY'));
24   --
25   --
26   cst_hecs_deferred CONSTANT VARCHAR2(10) DEFAULT '10';
27   --
28   --
29   cst_hecs_upfront_discount CONSTANT VARCHAR2(10) DEFAULT '11';
30   --
31   --
32   cst_hecs_upfront CONSTANT VARCHAR2(10) DEFAULT '12';
33   --
34   --
35   cst_hecs_os_spec_crs CONSTANT VARCHAR2(10) DEFAULT '72';
36   --
37   --
38   cst_hecs_non_os_spec_crs CONSTANT VARCHAR2(10) DEFAULT '71';
39   --
40   --
41   cst_hecs_non_os_fee_paying_ug CONSTANT VARCHAR2(10) DEFAULT '19';
42   --
43   --
44   cst_hecs_fee_paying_pg CONSTANT VARCHAR2(10) DEFAULT '20';
45   --
46   --
47   cst_hecs_fee_paying_os CONSTANT VARCHAR2(10) DEFAULT '22';
48   --
49   --
50   cst_hecs_os_student_charge CONSTANT VARCHAR2(10) DEFAULT '23';
51   --
52   --
53   cst_hecs_fee_paying_os_spnsr CONSTANT VARCHAR2(10) DEFAULT '24';
54   --
55   --
56   cst_hecs_enabling_crs CONSTANT VARCHAR2(10) DEFAULT '25';
57   --
58   --
59   cst_hecs_non_award_crs CONSTANT VARCHAR2(10) DEFAULT '26';
60   --
61   --
62   cst_hecs_employer_funded_crs CONSTANT VARCHAR2(10) DEFAULT '27';
63   --
64   --
65   cst_hecs_os_exchange_student CONSTANT VARCHAR2(10) DEFAULT '30';
66   --
67   --
68   cst_hecs_non_os_comm_ug_dis CONSTANT VARCHAR2(10) DEFAULT '31';
69   --
70   --
71   cst_hecs_comm_industry CONSTANT VARCHAR2(10) DEFAULT '32';
72   --
73   --
74   cst_hecs_work_experience CONSTANT VARCHAR2(10) DEFAULT '33';
75   --
76   --
77   cst_hecs_pg_award CONSTANT VARCHAR2(10) DEFAULT '40';
78   --
79   --
80   cst_hecs_special_course CONSTANT VARCHAR2(10) DEFAULT '70';
81   --
82   --
83   cst_hecs_avondale_special CONSTANT VARCHAR2(10) DEFAULT '99';
84   --
85   --
86   cst_hecs_type_deferred CONSTANT VARCHAR2(10) DEFAULT 'DEFERRED';
87   --
88   --
89   cst_hecs_type_upfront_discount CONSTANT VARCHAR2(10) DEFAULT 'UPFRONT_D';
90   --
91   --
92   cst_hecs_type_upfront CONSTANT VARCHAR2(10) DEFAULT 'UPFRONT';
93   --
94   --
95   cst_hecs_type_exempt CONSTANT VARCHAR2(10) DEFAULT 'EXEMPT';
96   --
97   --
98   cst_fee_paying_not CONSTANT NUMBER(1) DEFAULT 1;
99   --
100   --
101   cst_fee_paying_os CONSTANT NUMBER(1) DEFAULT 2;
102   --
103   --
104   cst_fee_paying_pg_course CONSTANT NUMBER(1) DEFAULT 3;
105   --
106   --
107   cst_crs_higher_doctorate CONSTANT NUMBER(2) DEFAULT 1;
108   --
109   --
110   cst_crs_cross_inst_pg CONSTANT NUMBER(2) DEFAULT 42;
111   --
112   --
113   cst_crs_cross_inst_ug CONSTANT NUMBER(2) DEFAULT 41;
114   --
115   --
116   cst_other_award CONSTANT NUMBER(2) DEFAULT 22;
117   --
118   --
119   cst_crs_diploma CONSTANT NUMBER(2) DEFAULT 21;
120   --
121   --
122   cst_crs_adv_diploma CONSTANT NUMBER(2) DEFAULT 20;
123   --
124   --
125   cst_crs_assoc_degree CONSTANT NUMBER(2) DEFAULT 13;
126   --
127   --
128   cst_crs_bachelor_pass CONSTANT NUMBER(2) DEFAULT 10;
129   --
130   --
131   cst_crs_doctorate_research CONSTANT NUMBER(2) DEFAULT 2;
132   --
133   --
134   cst_crs_masters_research CONSTANT NUMBER(2) DEFAULT 3;
135   --
136   --
137   cst_crs_masters_crs_work CONSTANT NUMBER(2) DEFAULT 4;
138   --
139   --
140   cst_crs_postgrad CONSTANT NUMBER(2) DEFAULT 5;
141   --
142   --
143   cst_crs_grad_dip_pg_dip_new CONSTANT NUMBER(2) DEFAULT 6;
144   --
145   --
146   cst_crs_grad_dip_pg_dip_extend CONSTANT NUMBER(2) DEFAULT 7;
147   --
148   --
149   cst_crs_bachelor_graduate CONSTANT NUMBER(2) DEFAULT 8;
150   --
151   --
152   cst_crs_bachelor_honours CONSTANT NUMBER(2) DEFAULT 9;
153   --
154   --
155   cst_crs_graduate CONSTANT NUMBER(2) DEFAULT 11;
156   --
157   --
158   cst_crs_doctorate_crs_work CONSTANT NUMBER(2) DEFAULT 12;
159   --
160   --
161   cst_crs_enabling CONSTANT NUMBER(2) DEFAULT 30;
162   --
163   --
164   cst_crs_cross_inst CONSTANT NUMBER(2) DEFAULT 40;
165   --
166   --
167   cst_crs_non_award CONSTANT NUMBER(2) DEFAULT 50;
168   --
169   --
170   cst_spcl_crs_amc CONSTANT VARCHAR2(2) DEFAULT '15';
171   --
172   --
173   cst_citizen_aust CONSTANT NUMBER(1) DEFAULT 1;
174   --
175   --
176   cst_citizen_nz CONSTANT NUMBER(1) DEFAULT 2;
177   --
178   --
179   cst_citizen_perm CONSTANT NUMBER(1) DEFAULT 3;
180   --
181   --
182   cst_citizen_temp_dip CONSTANT NUMBER(1) DEFAULT 4;
183   --
184   --
185   cst_citizen_other CONSTANT NUMBER(1) DEFAULT 5;
186   --
187   --
188   cst_perm_no CONSTANT NUMBER(1) DEFAULT 0;
189   --
190   --
191   cst_born_os_no_info CONSTANT VARCHAR2(4) DEFAULT 'S999';
192   --
193   --
194   cst_perm_in_out_aust_crs CONSTANT NUMBER(1) DEFAULT 1;
195   --
196   --
197   cst_perm_out_aust_not_crs CONSTANT NUMBER(1) DEFAULT 2;
198   --
199   --
200   cst_perm CONSTANT NUMBER(1) DEFAULT 3;
201   --
202   --
203   cst_deleted CONSTANT VARCHAR2(7) DEFAULT 'DELETED';
204   --
205   --
206   cst_completed CONSTANT VARCHAR2(9) DEFAULT 'COMPLETED';
207   --
208   --
209   cst_off_shore CONSTANT VARCHAR2(2) DEFAULT '00';
210   --
211   --
212   cst_no_arrival CONSTANT VARCHAR2(2) DEFAULT '01';
213   --
214   --
215   cst_arrival_prior_1903 CONSTANT VARCHAR2(2) DEFAULT '02';
216   --
217   --
218   cst_arrival_no_info CONSTANT VARCHAR2(2) DEFAULT 'A8';
219   --
220   --
221   cst_no_info_aust CONSTANT VARCHAR2(2) DEFAULT 'A9';
222   --
223   -- Validate the delete of a student course HECS option record.
224   FUNCTION enrp_val_scho_trgdel(
225   p_person_id IN NUMBER ,
226   p_course_cd IN VARCHAR2 ,
227   p_start_dt IN DATE ,
228   p_message_name OUT NOCOPY VARCHAR2)
229 RETURN BOOLEAN;
230 --PRAGMA RESTRICT_REFERENCES(  enrp_val_scho_trgdel, WNDS);
231   --
232   -- To perform all validations on a scho record
233   FUNCTION ENRP_VAL_SCHO_ALL(
234   p_person_id IN NUMBER ,
235   p_course_cd IN VARCHAR2 ,
236   p_start_dt IN DATE ,
237   p_end_dt IN DATE ,
238   p_hecs_payment_option IN VARCHAR2 ,
239   p_differential_hecs_ind IN VARCHAR2 ,
240   p_diff_hecs_ind_update_who IN VARCHAR2 ,
241   p_diff_hecs_ind_update_on IN DATE ,
242   p_diff_hecs_ind_update_comment IN VARCHAR2 ,
243   p_outside_aus_res_ind IN VARCHAR2 ,
244   p_nz_citizen_ind IN VARCHAR2 ,
245   p_nz_citizen_less2yr_ind IN VARCHAR2 ,
246   p_nz_citizen_not_res_ind IN VARCHAR2 ,
247   p_safety_net_ind IN VARCHAR2 ,
248   p_tax_file_number IN NUMBER ,
249   p_tax_file_number_collected_dt IN DATE ,
250   p_tax_file_invalid_dt IN DATE ,
251   p_tax_file_certificate_number IN NUMBER ,
252   p_message_name OUT NOCOPY VARCHAR2)
253 RETURN boolean;
254 --PRAGMA RESTRICT_REFERENCES(  ENRP_VAL_SCHO_ALL, WNDS);
255 
256   --
257   --
258   -- Validate that there are no other open ended student course hecs option
259   FUNCTION ENRP_VAL_SCHO_OPEN(
260   p_person_id IN NUMBER ,
261   p_course_cd IN VARCHAR2 ,
262   p_start_dt IN DATE ,
263   p_message_name OUT NOCOPY VARCHAR2)
264 RETURN BOOLEAN;
265 --PRAGMA RESTRICT_REFERENCES( ENRP_VAL_SCHO_OPEN , WNDS);
266   --
267   -- Check for overlap in a students course hecs option records
268   FUNCTION enrp_val_scho_ovrlp(
269   p_person_id IN NUMBER ,
270   p_course_cd IN VARCHAR2 ,
271   p_start_dt IN DATE ,
272   p_end_dt IN DATE ,
273   p_message_name OUT NOCOPY VARCHAR2)
274 RETURN BOOLEAN;
275 --PRAGMA RESTRICT_REFERENCES( enrp_val_scho_ovrlp , WNDS);
276   --
277   -- Validate student course HECS option start and end date.
278   FUNCTION enrp_val_scho_st_end(
279   p_person_id IN NUMBER ,
280   p_course_cd IN VARCHAR2 ,
281   p_start_dt IN DATE ,
282   p_end_dt IN DATE ,
283   p_message_name OUT NOCOPY VARCHAR2)
284 RETURN BOOLEAN;
285 --PRAGMA RESTRICT_REFERENCES(  enrp_val_scho_st_end, WNDS);
286   --
287   -- Validate student course attempt HECS payment option visa indicators.
288   FUNCTION enrp_val_scho_visa(
289   p_outside_aus_res_ind IN VARCHAR2 DEFAULT 'N',
290   p_nz_citizen_ind IN VARCHAR2 DEFAULT 'N',
291   p_nz_citizen_less2yrind IN VARCHAR2 DEFAULT 'N',
292   p_nz_citizen_not_res_ind IN VARCHAR2 DEFAULT 'N',
293   p_message_name OUT NOCOPY VARCHAR2)
294 RETURN BOOLEAN;
295 --PRAGMA RESTRICT_REFERENCES( enrp_val_scho_visa , WNDS);
296   --
297   -- Validate student course attempt HECS payment option tax file number.
298   FUNCTION enrp_val_scho_tfn(
299   p_person_id IN NUMBER ,
300   p_course_cd IN VARCHAR2 ,
301   p_start_dt IN DATE ,
302   p_tax_file_number IN NUMBER ,
303   p_message_name OUT NOCOPY VARCHAR2,
304   p_return_type OUT NOCOPY VARCHAR2 )
305 RETURN BOOLEAN;
306 --PRAGMA RESTRICT_REFERENCES(  enrp_val_scho_tfn, WNDS);
307   --
308   -- To validate the HECS Payment Option for a Student course HECS option
309   FUNCTION enrp_val_scho_hpo(
310   p_hecs_payment_option IN VARCHAR2 ,
311   p_outside_aus_res_ind IN VARCHAR2 DEFAULT 'N',
312   p_nz_citizen_ind IN VARCHAR2 DEFAULT 'N',
313   p_nz_citizen_less2yr_ind IN VARCHAR2 DEFAULT 'N',
314   p_nz_citizen_not_res_ind IN VARCHAR2 DEFAULT 'N',
315   p_safety_net_ind IN VARCHAR2 DEFAULT 'N',
316   p_tax_file_number IN NUMBER ,
317   p_tax_file_number_collected_dt IN DATE ,
318   p_tax_file_certificate_number IN NUMBER ,
319   p_differential_hecs_ind IN VARCHAR2 DEFAULT 'N',
320   p_message_name OUT NOCOPY VARCHAR2,
321   p_return_type OUT NOCOPY VARCHAR2 )
322 RETURN BOOLEAN;
323 --PRAGMA RESTRICT_REFERENCES(  enrp_val_scho_hpo, WNDS);
324   --
325   -- Validate the insert of a student course HECS option record.
326   FUNCTION enrp_val_scho_insert(
327   p_person_id IN NUMBER ,
328   p_course_cd IN VARCHAR2 ,
329   p_message_name OUT NOCOPY VARCHAR2)
330 RETURN BOOLEAN;
331 --PRAGMA RESTRICT_REFERENCES( enrp_val_scho_insert , WNDS);
332   --
333   -- Validate the update of a student course HECS option record.
334   FUNCTION enrp_val_scho_update(
335   p_start_dt IN DATE ,
336   p_message_name OUT NOCOPY VARCHAR2)
337 RETURN BOOLEAN;
338 --PRAGMA RESTRICT_REFERENCES( enrp_val_scho_update , WNDS);
339   --
340   -- Validate the delete of a student course HECS option record.
341   FUNCTION enrp_val_scho_delete(
342   p_start_dt IN DATE ,
343   p_message_name OUT NOCOPY VARCHAR2)
344 RETURN BOOLEAN;
345 --PRAGMA RESTRICT_REFERENCES( enrp_val_scho_delete , WNDS);
346   --
347   -- Validate HECS option, citizenship code and permanent resident.
348   FUNCTION enrp_val_ho_cic_prc(
349   p_person_id IN NUMBER ,
350   p_course_cd IN VARCHAR2 ,
351   p_scho_start_dt IN DATE ,
352   p_scho_end_dt IN DATE ,
353   p_hecs_payment_option IN VARCHAR2 ,
354   p_outside_aus_res_ind IN VARCHAR2 DEFAULT 'N',
355   p_ps_start_dt IN DATE ,
356   p_ps_end_dt IN DATE ,
357   p_citizenship_cd IN VARCHAR2 ,
358   p_perm_resident_cd IN VARCHAR2 ,
359   p_message_name OUT NOCOPY VARCHAR2,
360   p_return_type OUT NOCOPY VARCHAR2 )
361 RETURN BOOLEAN;
362 --PRAGMA RESTRICT_REFERENCES(  enrp_val_ho_cic_prc, WNDS);
363   --
364   -- Validate HECS visa indicators, citizenship cd and permanent resident.
365   FUNCTION enrp_val_vis_cic_prc(
366   p_person_id IN NUMBER ,
367   p_course_cd IN VARCHAR2 ,
368   p_scho_start_dt IN DATE ,
369   p_scho_end_dt IN DATE ,
370   p_outside_aus_res_ind IN VARCHAR2 DEFAULT 'N',
371   p_nz_citizen_ind IN VARCHAR2 DEFAULT 'N',
372   p_nz_citizen_less2yr_ind IN VARCHAR2 DEFAULT 'N',
373   p_nz_citizen_not_res_ind IN VARCHAR2 DEFAULT 'N',
374   p_ps_start_dt IN DATE ,
375   p_ps_end_dt IN DATE ,
376   p_citizenship_cd IN VARCHAR2 ,
377   p_perm_resident_cd IN VARCHAR2 ,
378   p_message_name OUT NOCOPY VARCHAR2,
379   p_return_type OUT NOCOPY VARCHAR2 )
380 RETURN BOOLEAN;
381 --PRAGMA RESTRICT_REFERENCES(  enrp_val_vis_cic_prc, WNDS);
382   --
383   -- Validate the HECS Payment Option against the course type.
384   FUNCTION enrp_val_hpo_crs_typ(
385   p_person_id IN NUMBER ,
386   p_course_cd IN VARCHAR2 ,
387   p_hecs_payment_option IN VARCHAR2 ,
388   p_message_name OUT NOCOPY VARCHAR2,
389   p_return_type OUT NOCOPY VARCHAR2 )
390 RETURN BOOLEAN;
391 --PRAGMA RESTRICT_REFERENCES( enrp_val_hpo_crs_typ , WNDS);
392   --
393   -- Validate the HECS Payment Option against the special course type.
394   FUNCTION enrp_val_hpo_spc_crs(
395   p_person_id IN NUMBER ,
396   p_course_cd IN VARCHAR2 ,
397   p_hecs_payment_option IN VARCHAR2 ,
398   p_message_name OUT NOCOPY VARCHAR2,
399   p_return_type OUT NOCOPY VARCHAR2 )
400 RETURN BOOLEAN;
401 --PRAGMA RESTRICT_REFERENCES( enrp_val_hpo_spc_crs , WNDS);
402   --
403   -- Validate HECS payment option, visa indicators and citizenship code.
404   FUNCTION enrp_val_hpo_vis_cic(
405   p_person_id IN NUMBER ,
406   p_course_cd IN VARCHAR2 ,
407   p_scho_start_dt IN DATE ,
408   p_scho_end_dt IN DATE ,
409   p_hecs_payment_option IN VARCHAR2 ,
410   p_outside_aus_res_ind IN VARCHAR2 ,
411   p_nz_citizen_ind IN VARCHAR2 DEFAULT 'N',
412   p_nz_citizen_less2yr_ind IN VARCHAR2 DEFAULT 'N',
413   p_nz_citizen_not_res_ind IN VARCHAR2 DEFAULT 'N',
414   p_ps_start_dt IN DATE ,
415   p_ps_end_dt IN DATE ,
416   p_yr_arrival IN VARCHAR2 ,
417   p_citizenship_cd IN VARCHAR2 ,
418   p_message_name OUT NOCOPY VARCHAR2,
419   p_return_type OUT NOCOPY VARCHAR2 )
420 RETURN BOOLEAN;
421 --PRAGMA RESTRICT_REFERENCES( enrp_val_hpo_vis_cic , WNDS);
422   --
423   -- Validate HECS payment option, citizenship code and permanent resident.
424   FUNCTION enrp_val_hpo_cic_prc(
425   p_person_id IN NUMBER ,
426   p_course_cd IN VARCHAR2 ,
427   p_scho_start_dt IN DATE ,
428   p_scho_end_dt IN DATE ,
429   p_hecs_payment_option IN VARCHAR2 ,
430   p_ps_start_dt IN DATE ,
431   p_ps_end_dt IN DATE ,
432   p_citizenship_cd IN VARCHAR2 ,
433   p_perm_resident_cd IN VARCHAR2 ,
434   p_message_name OUT NOCOPY VARCHAR2,
435   p_return_type OUT NOCOPY VARCHAR2 )
436 RETURN BOOLEAN;
437 --PRAGMA RESTRICT_REFERENCES( enrp_val_hpo_cic_prc , WNDS);
438   --
439   -- Validate the HECS pay option, the course type and the citizenship cd.
440   FUNCTION enrp_val_hpo_crs_cic(
441   p_person_id IN NUMBER ,
442   p_course_cd IN VARCHAR2 ,
443   p_scho_start_dt IN DATE ,
444   p_scho_end_dt IN DATE ,
445   p_hecs_payment_option IN VARCHAR2 ,
446   p_ps_start_dt IN DATE ,
447   p_ps_end_dt IN DATE ,
451 RETURN BOOLEAN;
448   p_citizenship_cd IN VARCHAR2 ,
449   p_message_name OUT NOCOPY VARCHAR2,
450   p_return_type OUT NOCOPY VARCHAR2 )
452 --PRAGMA RESTRICT_REFERENCES(  enrp_val_hpo_crs_cic, WNDS);
453   --
454   -- Validate HECS payment option and the citizenship code.
455   FUNCTION enrp_val_hpo_cic(
456   p_person_id IN NUMBER ,
457   p_course_cd IN VARCHAR2 ,
458   p_scho_start_dt IN DATE ,
459   p_scho_end_dt IN DATE ,
460   p_hecs_payment_option IN VARCHAR2 ,
461   p_ps_start_dt IN DATE ,
462   p_ps_end_dt IN DATE ,
463   p_citizenship_cd IN VARCHAR2 ,
464   p_message_name OUT NOCOPY VARCHAR2,
465   p_return_type OUT NOCOPY VARCHAR2 )
466 RETURN BOOLEAN;
467 --PRAGMA RESTRICT_REFERENCES( enrp_val_hpo_cic , WNDS);
468   --
469   -- Validate the HECS payment option closed indicator.
470   FUNCTION enrp_val_hpo_closed(
471   p_hecs_payment_option IN VARCHAR2 ,
472   p_message_name OUT NOCOPY VARCHAR2)
473 RETURN BOOLEAN;
474 --PRAGMA RESTRICT_REFERENCES( enrp_val_hpo_closed , WNDS);
475   --
476   -- Validate HECS payment option, citizenship code and other statistics.
477   FUNCTION enrp_val_hpo_cic_ps(
478   p_person_id IN NUMBER ,
479   p_course_cd IN VARCHAR2 ,
480   p_scho_start_dt IN DATE ,
481   p_scho_end_dt IN DATE ,
482   p_hecs_payment_option IN VARCHAR2 ,
483   p_ps_start_dt IN DATE ,
484   p_ps_end_dt IN DATE ,
485   p_citizenship_cd IN VARCHAR2 ,
486   p_yr_arrival IN VARCHAR2 ,
487   p_term_location_country IN VARCHAR2 ,
488   p_term_location_postcode IN NUMBER ,
489   p_collection_yr IN DATE ,
490   p_message_name OUT NOCOPY VARCHAR2,
491   p_return_type OUT NOCOPY VARCHAR2 )
492 RETURN BOOLEAN;
493 --PRAGMA RESTRICT_REFERENCES(  enrp_val_hpo_cic_ps, WNDS);
494   --
495   -- Validate that scho end date is in accordance with expiry restriction.
496   FUNCTION enrp_val_scho_expire(
497   p_person_id IN NUMBER ,
498   p_course_cd IN VARCHAR2 ,
499   p_start_dt IN DATE ,
500   p_end_dt IN DATE ,
501   p_hecs_payment_option IN VARCHAR2 ,
502   p_message_name OUT NOCOPY VARCHAR2)
503 RETURN BOOLEAN;
504   --
505   -- Validate the HECS option tax file number certificate number.
506   FUNCTION enrp_val_tfn_crtfct(
507   p_tax_file_number IN NUMBER ,
508   p_tax_file_invalid_dt IN DATE ,
509   p_tax_file_certificate_number IN NUMBER ,
510   p_message_name OUT NOCOPY VARCHAR2)
511 RETURN BOOLEAN;
512 --PRAGMA RESTRICT_REFERENCES( enrp_val_tfn_crtfct , WNDS);
513   --
514   -- Validate the HECS option tax file number invalid date.
515   FUNCTION enrp_val_tfn_invalid(
516   p_tax_file_number IN NUMBER ,
517   p_tax_file_invalid_dt IN DATE ,
518   p_message_name OUT NOCOPY VARCHAR2)
519 RETURN BOOLEAN;
520 --PRAGMA RESTRICT_REFERENCES( enrp_val_tfn_invalid , WNDS);
521 END IGS_EN_VAL_SCHO;