1 PACKAGE IGS_CA_VAL_DAIP AUTHID CURRENT_USER AS
2 /* $Header: IGSCA10S.pls 115.3 2002/11/28 22:58:34 nsidana ship $ */
3 -- Validate dt alias instance pair related value.
4 FUNCTION calp_val_daip_value(
5 p_dt_alias IN VARCHAR2 ,
6 p_dai_sequence_number IN NUMBER ,
7 p_cal_type IN VARCHAR2 ,
8 p_ci_sequence_number IN NUMBER ,
9 p_related_dt_alias IN VARCHAR2 ,
10 p_related_dai_sequence_number IN NUMBER ,
11 p_related_cal_type IN VARCHAR2 ,
12 p_related_ci_sequence_number IN NUMBER ,
13 p_message_name OUT NOCOPY VARCHAR2 )
14 RETURN BOOLEAN;
15 PRAGMA RESTRICT_REFERENCES(calp_val_daip_value, WNDS);
16 --
17 -- Validate dt alias instance pair calendar type.
18 FUNCTION calp_val_daip_ct(
19 p_cal_type IN VARCHAR2 ,
20 p_related_cal_type IN VARCHAR2 ,
21 p_message_name OUT NOCOPY VARCHAR2 )
22 RETURN BOOLEAN;
23 PRAGMA RESTRICT_REFERENCES(calp_val_daip_ct, WNDS);
24 --
25 -- Validate dt alias instance pair values are different.
26 FUNCTION calp_val_daip_dai(
27 p_dt_alias IN VARCHAR2 ,
28 p_dai_sequence_number IN NUMBER ,
29 p_cal_type IN VARCHAR2 ,
30 p_ci_sequence_number IN NUMBER ,
31 p_related_dt_alias IN VARCHAR2 ,
32 p_related_dai_sequence_number IN NUMBER ,
33 p_related_cal_type IN VARCHAR2 ,
34 p_related_ci_sequence_number IN NUMBER ,
35 p_message_name OUT NOCOPY VARCHAR2 )
36 RETURN BOOLEAN;
37 PRAGMA RESTRICT_REFERENCES(calp_val_daip_dai, WNDS);
38 --
39 -- Validate only one date alias instance pair exists.
40 FUNCTION calp_val_daip_unique(
41 p_dt_alias IN VARCHAR2 ,
42 p_dai_sequence_number IN NUMBER ,
43 p_cal_type IN VARCHAR2 ,
44 p_ci_sequence_number IN NUMBER ,
45 p_related_dt_alias IN VARCHAR2 ,
46 p_related_dai_sequence_number IN NUMBER ,
47 p_related_cal_type IN VARCHAR2 ,
48 p_related_ci_sequence_number IN NUMBER ,
49 p_message_name OUT NOCOPY VARCHAR2 )
50 RETURN BOOLEAN;
51 PRAGMA RESTRICT_REFERENCES(calp_val_daip_unique, WNDS);
52 END IGS_CA_VAL_DAIP;