1 PACKAGE IGS_FI_VAL_ER AUTHID CURRENT_USER AS
2 /* $Header: IGSFI20S.pls 115.4 2002/11/29 00:18:52 nsidana ship $ */
3 --
4 -- Validate elements ranges can be created for the relation type.
5 FUNCTION finp_val_er_defn(
6 p_fee_type IN VARCHAR2 ,
7 p_fee_cal_type IN VARCHAR2 ,
8 p_fee_ci_sequence_number IN NUMBER ,
9 p_s_relation_type IN VARCHAR2 ,
10 p_message_name OUT NOCOPY VARCHAR2 )
11 RETURN BOOLEAN;
12 pragma restrict_references(finp_val_er_defn,wnds);
13 --
14 -- Ensure elements range values do not overlap.
15 FUNCTION finp_val_er_ovrlp(
16 p_fee_type IN VARCHAR2 ,
17 p_fee_cal_type IN VARCHAR2 ,
18 p_fee_ci_sequence_number IN NUMBER ,
19 p_s_relation_type IN VARCHAR2 ,
20 p_fee_cat IN VARCHAR2 ,
21 p_range_number IN NUMBER ,
22 p_lower_range IN NUMBER ,
23 p_upper_range IN NUMBER ,
24 p_message_name OUT NOCOPY VARCHAR2 )
25 RETURN BOOLEAN;
26 pragma restrict_references(finp_val_er_ovrlp,wnds);
27 --
28 -- Ensure elements range rate can be created.
29 --Duplicate code removal, msrinivi Removed proc finp_val_err_ins
30 -- Ensure elements range can be created.
31 FUNCTION finp_val_er_create(
32 p_fee_cal_type IN VARCHAR2 ,
33 p_fee_ci_sequence_number IN NUMBER ,
34 p_fee_type IN VARCHAR2 ,
35 p_fee_cat IN VARCHAR2 ,
36 p_message_name OUT NOCOPY VARCHAR2 )
37 RETURN BOOLEAN;
38 pragma restrict_references(finp_val_er_create,wnds);
39 --
40 -- Ensure elements range values are valid.
41 FUNCTION finp_val_er_ranges(
42 p_lower_range IN NUMBER ,
43 p_upper_range IN NUMBER ,
44 p_message_name OUT NOCOPY VARCHAR2 )
45 RETURN BOOLEAN;
46 pragma restrict_references(finp_val_er_ranges,wnds);
47 --
48 -- Ensure elements range relations are valid.
49 FUNCTION finp_val_er_rltn(
50 p_s_relation_type IN VARCHAR2 ,
51 p_fee_cat IN VARCHAR2 ,
52 p_message_name OUT NOCOPY VARCHAR2 )
53 RETURN BOOLEAN;
54 pragma restrict_references(finp_val_er_rltn,wnds);
55 --
56 -- Ensure elements range can be created.
57 FUNCTION finp_val_er_ins(
58 p_fee_type IN VARCHAR2 ,
59 p_message_name OUT NOCOPY VARCHAR2 )
60 RETURN BOOLEAN;
61 pragma restrict_references(finp_val_er_ins,wnds);
62 END IGS_FI_VAL_ER;