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;