1 PACKAGE IGS_FI_VAL_FTCI AS
2 /* $Header: IGSFI34S.pls 120.0 2005/06/02 03:53:22 appldev noship $ */
3 --
4 /* Bug 1956374
5 What :Duplicate code removal removed finp_val_ft_closed
6 Who :msrinivi
7 */
8
9 /* Who When What
10 vvutukur 29-Jul-2002 Bug#2425767.Removed function finp_val_ftci_rank,as this function is
11 removed from package body also.
12 vchappid 25-Apr-2002 Bug# 2329407, Removed the parameters account_cd, fin_cal_type
13 and fin_ci_sequence_number from the function call finp_val_ftci_rqrd
14 vivuyyur 10-sep-2001 Bug No :1966961
15 PROCEDURE finp_val_ftci_ac is changed */
16
17 -- Validate the IGS_FI_ACC has the correct calendar relations.
18 FUNCTION finp_val_ftci_ac(
19 p_fee_cal_type IN VARCHAR2 ,
20 p_fee_ci_sequence_number IN NUMBER ,
21 p_message_name OUT NOCOPY VARCHAR2 )
22 RETURN BOOLEAN;
23 PRAGMA RESTRICT_REFERENCES(finp_val_ftci_ac,WNDS);
24 --
25 -- Ensure Fee calendar has relationship to Teaching Calendar
26 FUNCTION finp_chk_tchng_prds(
27 p_fee_cal_type IN VARCHAR2 ,
28 p_fee_ci_sequence_number IN NUMBER ,
29 p_message_name OUT NOCOPY VARCHAR2 )
30 RETURN BOOLEAN;
31 PRAGMA RESTRICT_REFERENCES(finp_chk_tchng_prds,WNDS);
32 --
33 -- Update the status of related FCFL records.
34 FUNCTION finp_upd_fcfl_status(
35 p_fee_type IN VARCHAR2 ,
36 p_fee_cal_type IN VARCHAR2 ,
37 p_fee_ci_sequence_number IN NUMBER ,
38 p_fee_type_ci_status IN VARCHAR2 ,
39 p_message_name OUT NOCOPY VARCHAR2 )
40 RETURN BOOLEAN;
41 --
42 --Duplicate code removal , msrinivi removed proc finp_val_ci_fee
43
44 -- Validate the fee structure status closed indicator
45 -- Bug 1956374 Duplicate code removal REmoved proc finp_val_fss_closed
46 -- Validate the IGS_FI_F_TYP_CA_INST s_chg_method_type.
47 FUNCTION finp_val_ftci_c_mthd(
48 p_fee_type IN VARCHAR ,
49 p_chg_method IN VARCHAR2 ,
50 p_message_name OUT NOCOPY VARCHAR2 )
51 RETURN BOOLEAN;
52 PRAGMA RESTRICT_REFERENCES(finp_val_ftci_c_mthd,WNDS);
53 --
54 -- Validate the IGS_FI_F_TYP_CA_INST date aliases
55 FUNCTION finp_val_ftci_dates(
56 p_fee_cal_type IN VARCHAR2 ,
57 p_fee_ci_sequence_number IN NUMBER ,
58 p_start_dt_alias IN VARCHAR2 ,
59 p_start_dai_sequence_number IN NUMBER ,
60 p_end_dt_alias IN VARCHAR2 ,
61 p_end_dai_sequence_number IN NUMBER ,
62 p_retro_dt_alias IN VARCHAR2 ,
63 p_retro_dai_sequence_number IN NUMBER ,
64 p_message_name OUT NOCOPY VARCHAR2 )
65 RETURN BOOLEAN;
66 PRAGMA RESTRICT_REFERENCES(finp_val_ftci_dates,WNDS);
67 --
68 -- Validate the IGS_FI_F_TYP_CA_INST required data
69 FUNCTION finp_val_ftci_rqrd(
70 p_fee_cal_type IN VARCHAR2 ,
71 p_fee_ci_sequence_number IN NUMBER ,
72 p_fee_type IN VARCHAR2 ,
73 p_old_chg_method IN VARCHAR2 ,
74 p_old_rule_sequence IN NUMBER ,
75 p_chg_method IN VARCHAR2 ,
76 p_rule_sequence IN NUMBER ,
77 p_fee_type_ci_status IN VARCHAR2 ,
78 p_message_name OUT NOCOPY VARCHAR2 )
79 RETURN BOOLEAN;
80 PRAGMA RESTRICT_REFERENCES(finp_val_ftci_rqrd,WNDS);
81 --
82 -- Validate the IGS_FI_F_TYP_CA_INST status
83 FUNCTION finp_val_ftci_status(
84 p_fee_type IN VARCHAR2 ,
85 p_fee_cal_type IN VARCHAR2 ,
86 p_fee_ci_sequence_number IN NUMBER ,
87 p_new_ftci_status IN VARCHAR2 ,
88 p_old_ftci_status IN VARCHAR2 ,
89 p_message_name OUT NOCOPY VARCHAR2 )
90 RETURN BOOLEAN;
91 PRAGMA RESTRICT_REFERENCES(finp_val_ftci_status,WNDS);
92 --
93 -- Validate the IGS_FI_FEE_TYPE in the fee_type_account is not closed.
94 -- bug 1956374 Removed finp_val_ft_closed duplicate code msrinivi
95 -- Validate PAYMENT HIERARCHY RAN
96 -- As part of bugfix#2425767,removed function finp_val_ftci_rank.
97 END IGS_FI_VAL_FTCI;