1 PACKAGE IGS_FI_VAL_FCFL AUTHID CURRENT_USER AS
2 /* $Header: IGSFI26S.pls 115.6 2002/11/29 00:20:41 nsidana ship $ */
3 --
4 --who when what
5 --vvutukur 29-Jul-2002 Bug#2425767. Removed function finp_val_fcfl_rank,as payment_hierarchy_rank column
6 -- is obsoleted.
7 /* Bug 1956374
8 What : Duplicate code removal Removed finp_val_fss_closed
9 Who :msrinivi
10 */
11 -- Validate FCFL can be made ACTIVE.
12 FUNCTION finp_val_fcfl_active(
13 p_fee_liability_status IN VARCHAR2 ,
14 p_fee_cal_type IN VARCHAR2 ,
15 p_fee_ci_sequence_number IN NUMBER ,
16 p_message_name OUT NOCOPY VARCHAR2 )
17 RETURN BOOLEAN;
18 PRAGMA RESTRICT_REFERENCES(finp_val_fcfl_active,WNDS);
19 --
20 -- Ensure fields are/are not allowable.
21 FUNCTION finp_val_fcfl_rqrd(
22 p_fee_cal_type IN VARCHAR2 ,
23 p_fee_ci_sequence_number IN NUMBER ,
24 p_fee_type IN VARCHAR2 ,
25 p_chg_method IN VARCHAR2 ,
26 p_rule_sequence IN NUMBER ,
27 p_message_name OUT NOCOPY VARCHAR2 )
28 RETURN BOOLEAN;
29 PRAGMA RESTRICT_REFERENCES(finp_val_fcfl_rqrd,WNDS);
30 --
31 -- Ensure status value is allowed.
32 FUNCTION finp_val_fcfl_status(
33 p_fee_cal_type IN VARCHAR2 ,
34 p_fee_ci_sequence_number IN NUMBER ,
35 p_fee_cat IN VARCHAR2 ,
36 p_fee_type IN VARCHAR2 ,
37 p_fee_status IN VARCHAR2 ,
38 p_message_name OUT NOCOPY VARCHAR2 )
39 RETURN BOOLEAN;
40 PRAGMA RESTRICT_REFERENCES(finp_val_fcfl_status,WNDS);
41 --
42 -- Validate insert of FCFL does not clash currency with FTCI definitions
43 FUNCTION finp_val_fcfl_cur(
44 p_fee_cal_type IN IGS_CA_TYPE.cal_type%TYPE ,
45 p_fee_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
46 p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,
47 p_fee_cat IN IGS_FI_FEE_CAT_ALL.fee_cat%TYPE ,
48 p_message_name OUT NOCOPY VARCHAR2 )
49 RETURN BOOLEAN;
50 PRAGMA RESTRICT_REFERENCES(finp_val_fcfl_cur,WNDS);
51 --
52 -- Duplicate code removal msrinivi
53 -- Validate the PAYMENT_HIERARCHY_RANK
54 -- Removed function finp_val_fcfl_rank, as part of bug fix#2425767, as this function validates
55 -- an obsoleted column, payment_hierarchy_rank.
56 END IGS_FI_VAL_FCFL;