1 PACKAGE IGS_FI_VAL_FCCI AS
2 /* $Header: IGSFI25S.pls 120.0 2005/06/02 04:28:43 appldev noship $ */
3 --
4 -- Validate FCCI can be made ACTIVE.
5 FUNCTION finp_val_fcci_active(
6 p_fee_cat_ci_status IN VARCHAR2 ,
7 p_fee_cal_type IN VARCHAR2 ,
8 p_fee_ci_sequence_number IN NUMBER ,
9 p_message_name OUT NOCOPY VARCHAR2 )
10 RETURN BOOLEAN;
11 PRAGMA RESTRICT_REFERENCES(finp_val_fcci_active,WNDS);
12 --
13 -- Update the status of related FCFL records.
14 FUNCTION finp_upd_fcci_status(
15 p_fee_cat IN VARCHAR2 ,
16 p_fee_cal_type IN VARCHAR2 ,
17 p_fee_ci_sequence_number IN NUMBER ,
18 p_fee_cat_ci_status IN VARCHAR2 ,
19 p_message_name OUT NOCOPY VARCHAR2 )
20 RETURN BOOLEAN;
21 --
22 -- Validate the IGS_FI_F_CAT_CA_INST status
23 FUNCTION finp_val_fcci_status(
24 p_fee_cat IN VARCHAR2 ,
25 p_fee_cal_type IN VARCHAR2 ,
26 p_fee_ci_sequence_number IN NUMBER ,
27 p_new_fcci_status IN VARCHAR2 ,
28 p_old_fcci_status IN VARCHAR2 ,
29 p_message_name OUT NOCOPY VARCHAR2 )
30 RETURN BOOLEAN;
31 PRAGMA RESTRICT_REFERENCES(finp_val_fcci_status,WNDS);
32 --
33 -- Ensure cal instance dates are consistent.
34 FUNCTION finp_val_fcci_dates(
35 p_fee_cal_type IN VARCHAR2 ,
36 p_fee_ci_sequence_number IN NUMBER ,
37 p_start_dt_alias IN VARCHAR2 ,
38 p_start_dai_sequence_number IN NUMBER ,
39 p_end_dt_alias IN VARCHAR2 ,
40 p_end_dai_sequence_number IN NUMBER ,
41 p_retro_dt_alias IN VARCHAR2 ,
42 p_retro_dai_sequence_number IN NUMBER ,
43 p_message_name OUT NOCOPY VARCHAR2 )
44 RETURN BOOLEAN;
45 PRAGMA RESTRICT_REFERENCES(finp_val_fcci_dates,WNDS);
46 --
47 -- Validate the fee structure status closed indicator
48 FUNCTION finp_val_fss_closed(
49 p_fee_structure_status IN VARCHAR2 ,
50 p_message_name OUT NOCOPY VARCHAR2 )
51 RETURN BOOLEAN;
52 PRAGMA RESTRICT_REFERENCES(finp_val_fss_closed,WNDS);
53 --
54 -- Ensure calendar instance is FEE and ACTIVE.
55 FUNCTION finp_val_ci_fee(
56 p_fee_cal_type IN VARCHAR2 ,
57 p_fee_ci_sequence_number IN NUMBER ,
58 p_message_name OUT NOCOPY VARCHAR2 )
59 RETURN BOOLEAN;
60 PRAGMA RESTRICT_REFERENCES(finp_val_ci_fee,WNDS);
61
62 END IGS_FI_VAL_FCCI;