1 PACKAGE IGS_EN_VAL_PUSE AUTHID CURRENT_USER AS
2 /* $Header: IGSEN60S.pls 115.4 2002/11/29 00:05:24 nsidana ship $ */
3 --
4 --
5 --
6 -- bug id : 1956374
7 -- sjadhav, 28-aug-2001
8 -- removed FUNCTION enrp_val_encmb_dt
9 -- removed FUNCTION enrp_val_encmb_dts
10 --
11 -- gt_rowid_table t_puse_rowids;
12 --
13 --
14 -- gt_empty_table t_puse_rowids;
15 --
16 --
17 -- gv_table_index BINARY_INTEGER;
18 --
19 -- Validate if PERSON is enrolled in an excluded UNIT set.
20 FUNCTION enrp_val_puse_us(
21 p_person_id IN NUMBER ,
22 p_unit_set_cd IN VARCHAR2 ,
23 p_us_version_number IN NUMBER ,
24 p_course_cd IN VARCHAR2 ,
25 p_message_name OUT NOCOPY VARCHAR2)
26 RETURN BOOLEAN;
27 --PRAGMA RESTRICT_REFERENCES( enrp_val_puse_us , WNDS);
28 --
29 -- Validate that PERSON doesn't already have an open UNIT set exclusion.
30 FUNCTION enrp_val_puse_open(
31 p_person_id IN NUMBER ,
32 p_encumbrance_type IN VARCHAR2 ,
33 p_pen_start_dt IN DATE ,
34 p_s_encmb_effect_type IN VARCHAR2 ,
35 p_pee_start_dt IN DATE ,
36 p_unit_set_cd IN VARCHAR2 ,
37 p_us_version_number IN NUMBER ,
38 p_puse_start_dt IN DATE ,
39 p_message_name OUT NOCOPY VARCHAR2)
40 RETURN BOOLEAN;
41 --PRAGMA RESTRICT_REFERENCES( enrp_val_puse_open , WNDS);
42 --
43 -- Validate UNIT set exists
44 FUNCTION crsp_val_us_exists(
45 p_unit_set_cd IN VARCHAR2 ,
46 p_version_number IN NUMBER ,
47 p_message_name OUT NOCOPY VARCHAR2)
48 RETURN BOOLEAN;
49 --PRAGMA RESTRICT_REFERENCES( crsp_val_us_exists, WNDS);
50
51
52 END IGS_EN_VAL_PUSE;