DBA Data[Home] [Help]

PACKAGE: APPS.IGS_CA_VAL_CI

Source


1 PACKAGE IGS_CA_VAL_CI AUTHID CURRENT_USER AS
2 /* $Header: IGSCA05S.pls 115.4 2002/11/28 22:57:21 nsidana ship $ */
3   -------------------------------------------------------------------------------------------
4   --Change History:
5   --Who         When            What
6   --smadathi    27-AUG-2001     Bug No. 1956374 .The function declaration of genp_val_strt_end_dt
7   --                            removed .
8   -------------------------------------------------------------------------------------------
9   -- Validate if calendar status is closed.
10   FUNCTION calp_val_cs_closed(
11   p_cal_status IN VARCHAR2 ,
12   p_message_name OUT NOCOPY VARCHAR2 )
13 RETURN BOOLEAN;
14  PRAGMA RESTRICT_REFERENCES(calp_val_cs_closed, WNDS);
15  --
16   -- To validate calendar instance alternate code
17   FUNCTION calp_val_ci_alt_cd(
18   p_cal_type IN VARCHAR2 ,
19   p_alternate_code IN VARCHAR2 ,
20   p_message_name OUT NOCOPY VARCHAR2)
21 RETURN boolean;
22  PRAGMA RESTRICT_REFERENCES(calp_val_ci_alt_cd, WNDS);
23  --
24   -- To validate a change of calendar instance
25   FUNCTION calp_val_ci_status(
26   p_cal_type IN VARCHAR2 ,
27   p_sequence_number IN NUMBER DEFAULT NULL,
28   p_old_cal_status IN VARCHAR2 ,
29   p_new_cal_status IN VARCHAR2 ,
30   p_message_name OUT NOCOPY VARCHAR2 )
31 RETURN boolean;
32   PRAGMA RESTRICT_REFERENCES(calp_val_ci_status, WNDS);
33 --
34   -- To validate columns on insert or update of calendar instance.
35   FUNCTION calp_val_ci_upd(
36   p_cal_type IN VARCHAR2 ,
37   p_sequence_number IN NUMBER DEFAULT NULL,
38   p_alternate_code IN VARCHAR2 ,
39   p_message_name OUT NOCOPY VARCHAR2)
40 RETURN boolean;
41 END IGS_CA_VAL_CI;