1 PACKAGE IGS_EN_VAL_PCE AUTHID CURRENT_USER AS
2 /* $Header: IGSEN50S.pls 115.4 2002/11/29 00:02:19 nsidana ship $ */
3 --
4 /* Bug 1956374
5 Who msrinivi
6 What duplicate removal Rremoved genp_prc_clear_rowid, genp_set_rowid
7 */
8 --
9 TYPE t_pce_rowids IS TABLE OF
10 ROWID
11 INDEX BY BINARY_INTEGER;
12 --
13 --
14 gt_rowid_table t_pce_rowids;
15 --
16 --
17 gt_empty_table t_pce_rowids;
18 --
19 --
20 gv_table_index BINARY_INTEGER;
21 --
22 -- Validate that IGS_PE_PERSON doesn't already have an open crs exclusion.
23 FUNCTION enrp_val_pce_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_course_cd IN VARCHAR2 ,
30 p_pce_start_dt IN DATE ,
31 p_message_name OUT NOCOPY VARCHAR2)
32 RETURN BOOLEAN;
33 --PRAGMA RESTRICT_REFERENCES (enrp_val_pce_open,WNDS);
34 --
35 -- Routine to process pce rowids in PL/SQL TABLE for the current commit.
36 FUNCTION enrp_prc_pce_rowids(
37 p_inserting IN BOOLEAN ,
38 p_updating IN BOOLEAN ,
39 p_deleting IN BOOLEAN ,
40 p_message_name IN OUT NOCOPY VARCHAR2 )
41 RETURN BOOLEAN;
42 --PRAGMA RESTRICT_REFERENCES (enrp_prc_pce_rowids,WNDS);
43 --
44
45 -- To validate the nominated date is not less than current date..
46 FUNCTION enrp_val_encmb_dt(
47 p_date IN DATE ,
48 p_message_name OUT NOCOPY VARCHAR2)
49 RETURN BOOLEAN;
50 --PRAGMA RESTRICT_REFERENCES (enrp_val_encmb_dt,WNDS);
51 --
52 -- To validate that expiry date is greater than or equal to start date.
53 FUNCTION enrp_val_strt_exp_dt(
54 p_start_dt IN DATE ,
55 p_expiry_dt IN DATE ,
56 p_message_name OUT NOCOPY VARCHAR2)
57 RETURN BOOLEAN;
58 --PRAGMA RESTRICT_REFERENCES (enrp_val_strt_exp_dt,WNDS);
59 --
60 -- Validate if a IGS_PS_COURSE must be discontinued before it can excluded.
61 FUNCTION enrp_val_crs_exclsn(
62 p_person_id IN NUMBER ,
63 p_course_cd IN VARCHAR2 ,
64 p_exclusion_start_dt IN DATE ,
65 p_message_name OUT NOCOPY VARCHAR2,
66 p_return_type OUT NOCOPY VARCHAR2 )
67 RETURN BOOLEAN;
68 --PRAGMA RESTRICT_REFERENCES (enrp_val_crs_exclsn,WNDS);
69 --
70 -- Validate the IGS_PS_COURSE code on the IGS_PE_PERSON IGS_PS_COURSE exclusion table.
71 FUNCTION enrp_val_pce_crs(
72 p_person_id IN NUMBER ,
73 p_course_cd IN VARCHAR2 ,
74 p_exclusion_start_dt IN DATE ,
75 p_message_name OUT NOCOPY VARCHAR2,
76 p_return_type OUT NOCOPY VARCHAR2 )
77 RETURN BOOLEAN;
78 --PRAGMA RESTRICT_REFERENCES (enrp_val_pce_crs,WNDS);
79 --
80 -- Validate the encumbrance effect table
81 FUNCTION enrp_val_pee_table(
82 p_effect_type IN VARCHAR2 ,
83 p_table_name IN VARCHAR2 ,
84 p_message_name OUT NOCOPY VARCHAR2)
85 RETURN BOOLEAN;
86 --PRAGMA RESTRICT_REFERENCES (enrp_val_pee_table,WNDS);
87 --
88 -- To validate that child date is not less than parent start date.
89 FUNCTION enrp_val_encmb_dts(
90 p_parent_start_dt IN DATE ,
91 p_child_start_dt IN DATE ,
92 p_message_name OUT NOCOPY VARCHAR2)
93 RETURN BOOLEAN;
94 --PRAGMA RESTRICT_REFERENCES (enrp_val_encmb_dts,WNDS);
95 END IGS_EN_VAL_PCE;