1 PACKAGE IGS_RE_VAL_CAH AS
2 /* $Header: IGSRE06S.pls 120.0 2005/06/01 17:23:05 appldev noship $ */
3 -------------------------------------------------------------------------------------------
4 --Change History:
5 --Who When What
6 --smadathi 25-AUG-2001 Bug No. 1956374 .Modified function GENP_VAL_SDTT_SESS
7 --svanukur 15-APR-2004 Removed procedure resp_val_cah_strt_dt as part of bug 3544986
8 -------------------------------------------------------------------------------------------
9 -- Allow for specified IGS_RE_CANDIDATURE trigger validation.
10 PROCEDURE RESP_VAL_CA_TRG(
11 p_table_name IN VARCHAR2 ,
12 p_insert_delete_ind IN VARCHAR2 DEFAULT 'N')
13 ;
14 --
15 -- Validate IGS_RE_CANDIDATURE attendance history changes prior to census date.
16 FUNCTION resp_val_cah_census(
17 p_person_id IN NUMBER ,
18 p_ca_sequence_number IN NUMBER ,
19 p_effective_dt IN DATE ,
20 p_message_name OUT NOCOPY VARCHAR2 )
21 RETURN BOOLEAN;
22
23 -- Validate IGS_RE_CANDIDATURE update.
24 FUNCTION resp_val_ca_childupd(
25 p_person_id IN NUMBER ,
26 p_ca_sequence_number IN NUMBER ,
27 p_message_name OUT NOCOPY VARCHAR2 )
28 RETURN BOOLEAN;
29
30 -- Validate IGS_RE_CANDIDATURE attendance history dates.
31 FUNCTION resp_val_cah_hist_dt(
32 p_person_id IN NUMBER ,
33 p_ca_sequence_number IN NUMBER ,
34 p_validate_first_hist_ind IN VARCHAR2 DEFAULT 'N',
35 p_message_name OUT NOCOPY VARCHAR2 )
36 RETURN BOOLEAN;
37
38 -- Validate IGS_RE_CANDIDATURE attendance history insert.
39 FUNCTION resp_val_cah_ca_ins(
40 p_person_id IN NUMBER ,
41 p_ca_sequence_number IN NUMBER ,
42 p_sca_course_cd IN VARCHAR2 ,
43 p_commencement_dt OUT NOCOPY DATE ,
44 p_attendance_type OUT NOCOPY VARCHAR2 ,
45 p_message_name OUT NOCOPY VARCHAR2 )
46 RETURN BOOLEAN;
47
48 -- Validate IGS_RE_CANDIDATURE attendance hist start date and SCA commencement.
49 FUNCTION resp_val_cah_comm(
50 p_person_id IN NUMBER ,
51 p_ca_sequence_number IN NUMBER ,
52 p_sca_course_cd IN VARCHAR2 ,
53 p_commencement_dt IN DATE ,
54 p_message_name OUT NOCOPY VARCHAR2 )
55 RETURN BOOLEAN;
56
57 -- Validate IGS_RE_CANDIDATURE attendance history end date.
58 FUNCTION resp_val_cah_end_dt(
59 p_person_id IN NUMBER ,
60 p_ca_sequence_number IN NUMBER ,
61 p_hist_start_dt IN DATE ,
62 p_hist_end_dt IN DATE ,
63 p_message_name OUT NOCOPY VARCHAR2 )
64 RETURN BOOLEAN;
65
66
67
68 END IGS_RE_VAL_CAH;