PACKAGE: APPS.IGS_ST_VAL_GDHC

Source

1 PACKAGE IGS_ST_VAL_GDHC AUTHID CURRENT_USER AS
2 /* $Header: IGSST07S.pls 115.4 2002/11/29 04:11:52 nsidana ship $ */
3  --
4   --
5   -- Ensure the start and end dates don't overlap with other records.
6   FUNCTION stap_val_gdhc_ovrlp(
7   p_govt_discipline_group_cd IN VARCHAR2 ,
8   p_start_dt IN DATE ,
9   p_end_dt IN DATE ,
10   p_message_name OUT NOCOPY  VARCHAR2)
11   RETURN BOOLEAN;
12 
13   --
14   -- Validate that only one record has an open end date.
15   FUNCTION stap_val_gdhc_open(
16   p_govt_discipline_group_cd IN VARCHAR2 ,
17   p_start_dt IN DATE ,
18   p_message_name OUT NOCOPY  VARCHAR2)
19   RETURN BOOLEAN;
20   --
21   -- Ensure the govt discipline group id not closed.
22   FUNCTION stap_val_gdhc_gd(
23   p_govt_discipline_group_cd IN VARCHAR2 ,
24   p_message_name OUT NOCOPY  VARCHAR2)
25   RETURN BOOLEAN;
26   --
27   -- Validate that end date is null or >= start date.
28   FUNCTION stap_val_gdhc_end_dt(
29   p_start_dt IN DATE ,
30   p_end_dt IN DATE ,
31   p_message_name OUT NOCOPY  VARCHAR2)
32   RETURN BOOLEAN;
33 
34   END IGS_ST_VAL_GDHC;