DBA Data[Home] [Help]

PACKAGE: APPS.IGS_CA_VAL_DAIOC

Source


1 PACKAGE IGS_CA_VAL_DAIOC AUTHID CURRENT_USER AS
2 /* $Header: IGSCA09S.pls 115.3 2002/11/28 22:58:20 nsidana ship $ */
3   -- Ensure dt alias instance offset constraints can be created.
4   FUNCTION calp_val_daioc_ins(
5   p_cal_type IN VARCHAR2 ,
6   p_message_name OUT NOCOPY VARCHAR2 )
7 RETURN BOOLEAN;
8   --
9   -- Validate dt alias offset constraints do not clash.
10   FUNCTION calp_val_sdoct_clash(
11   p_dt_alias IN VARCHAR2 ,
12   p_offset_dt_alias IN VARCHAR2 ,
13   p_dai_sequence_number IN NUMBER ,
14   p_offset_dai_sequence_number IN NUMBER ,
15   p_cal_type IN VARCHAR2 ,
16   p_offset_cal_type IN VARCHAR2 ,
17   p_ci_sequence_number IN NUMBER ,
18   p_offset_ci_sequence_number IN NUMBER ,
19   p_s_dt_offset_constraint_type IN VARCHAR2 ,
20   p_constraint_condition IN VARCHAR2 ,
21   p_constraint_resolution IN NUMBER ,
22   p_message_name OUT NOCOPY VARCHAR2 )
23 RETURN BOOLEAN;
24  PRAGMA RESTRICT_REFERENCES(calp_val_sdoct_clash, WNDS);
25  --
26   -- Validate if date alias instance offset constraints exist.
27   FUNCTION calp_val_daioc_exist(
28   p_dt_alias IN VARCHAR2 ,
29   p_dai_sequence_number IN NUMBER ,
30   p_cal_type IN VARCHAR2 ,
31   p_ci_sequence_number IN NUMBER ,
32   p_message_name OUT NOCOPY VARCHAR2 )
33 RETURN BOOLEAN;
34   PRAGMA RESTRICT_REFERENCES(calp_val_daioc_exist, WNDS);
35 --
36   -- Validate if offset constraint type code is closed.
37   FUNCTION calp_val_sdoct_clsd(
38   p_s_dt_offset_constraint_type IN VARCHAR2 ,
39   p_message_name OUT NOCOPY VARCHAR2 )
40 RETURN BOOLEAN;
41 PRAGMA RESTRICT_REFERENCES(calp_val_sdoct_clsd, WNDS);
42 END IGS_CA_VAL_DAIOC;