1 PACKAGE IGS_EN_VAL_PUE AUTHID CURRENT_USER AS
2 /* $Header: IGSEN58S.pls 115.4 2002/11/29 00:04:36 nsidana ship $ */
3
4 --
5 --
6 -- gt_rowid_table t_pue_rowids;
7 --
8 --
9 -- gt_empty_table t_pue_rowids;
10 --
11 --
12 -- gv_table_index BINARY_INTEGER;
13 --
14 -- bug id : 1956374
15 -- sjadhav , 28-aug-2001
16 -- removed FUNCTION enrp_val_encmb_dt
17 -- removed FUNCTION enrp_val_encmb_dts
18 --
19 -- To validate that expiry date is greater than or equal to start date.
20
21 --
22 -- Validate that person doesn't already have an open IGS_PS_UNIT exclusion.
23 FUNCTION enrp_val_pue_open(
24 p_person_id IN NUMBER ,
25 p_encumbrance_type IN VARCHAR2 ,
26 p_pen_start_dt IN DATE ,
27 p_s_encmb_effect_type IN VARCHAR2 ,
28 p_pee_start_dt IN DATE ,
29 p_unit_cd IN VARCHAR2 ,
30 p_pue_start_dt IN DATE ,
31 p_message_name OUT NOCOPY VARCHAR2)
32 RETURN BOOLEAN;
33 --PRAGMA RESTRICT_REFERENCES( enrp_val_pue_open , WNDS);
34 --
35 -- Validate if person is enrolled in an exluded IGS_PS_UNIT.
36 FUNCTION enrp_val_pue_unit(
37 p_person_id IN NUMBER ,
38 p_unit_cd IN VARCHAR2 ,
39 p_course_cd IN VARCHAR2 ,
40 p_message_name OUT NOCOPY VARCHAR2)
41 RETURN BOOLEAN;
42 --PRAGMA RESTRICT_REFERENCES( enrp_val_pue_unit , WNDS);
43 --
44 -- Validate the encumbrance effect table
45 --
46 -- bug id : 1956374
47 -- removed FUNCTION enrp_val_encmb_dts
48 END IGS_EN_VAL_PUE;