[Home] [Help]
PACKAGE: APPS.IGS_FI_VAL_FAR
Source
1 PACKAGE IGS_FI_VAL_FAR AS
2 /* $Header: IGSFI22S.pls 120.1 2005/06/05 20:27:24 appldev $ */
3 --
4 --Who When What
5 -- svuppala 03-Jun-2005 Enh# 3442712 - Modified finp_val_far_unique
6 --pathipat 10-Sep-2003 Enh 3108052 - Add Unit Sets to Rate Table
7 -- Modified finp_val_far_unique() - Added 2 new params
8 -- vvutukur 29-Nov-2002 Enh#2584986.Obsoleted function FINP_VAL_FAR_CUR.
9 -- npalanis 23-OCT-2002 Bug : 2608360
10 -- p_residency_status_id column is changed to p_residency_status_cd of
11 -- datatype varchar2.
12 -- bug id : 1956374
13 -- sjadhav , 28-aug-2001
14 -- removed FUNCTION enrp_val_att_closed
15 --
16 -- Validate fee assessment rate can be created for the relation type.
17 FUNCTION finp_val_far_create(
18 p_fee_type IN VARCHAR2 ,
19 p_fee_cal_type IN VARCHAR2 ,
20 p_fee_ci_sequence_number IN NUMBER ,
21 p_s_relation_type IN VARCHAR2 ,
22 p_message_name OUT NOCOPY VARCHAR2 )
23 RETURN BOOLEAN;
24 pragma restrict_references(finp_val_far_create,wnds);
25 --
26 -- Validate IGS_PS_COURSE IGS_AD_LOCATION code.
27 FUNCTION crsp_val_loc_cd(
28 p_location_cd IN VARCHAR2 ,
29 p_message_name OUT NOCOPY VARCHAR2 )
30 RETURN BOOLEAN;
31 pragma restrict_references(crsp_val_loc_cd,wnds);
32 --
33 -- Ensure IGS_FI_GOV_HEC_PA_OP is specified.
34 FUNCTION finp_val_far_rqrd(
35 p_fee_type IN VARCHAR2 ,
36 p_govt_hecs_payment_option IN VARCHAR2 ,
37 p_message_name OUT NOCOPY VARCHAR2 )
38 RETURN BOOLEAN;
39 pragma restrict_references(finp_val_far_rqrd,wnds);
40 --
41 -- Validate fee assessment rate is unqiue.
42 FUNCTION finp_val_far_unique(
43 p_fee_type IN VARCHAR2 ,
44 p_fee_cal_type IN VARCHAR2 ,
45 p_fee_ci_sequence_number IN NUMBER ,
46 p_s_relation_type IN VARCHAR2 ,
47 p_rate_number IN NUMBER ,
48 p_fee_cat IN VARCHAR2 ,
49 p_location_cd IN VARCHAR2 ,
50 p_attendance_type IN VARCHAR2 ,
51 p_attendance_mode IN VARCHAR2 ,
52 p_govt_hecs_payment_option IN VARCHAR2 ,
53 p_govt_hecs_cntrbtn_band IN NUMBER ,
54 p_chg_rate IN NUMBER ,
55 p_unit_class IN VARCHAR2,
56 -- Added by Nishikant , to include the following five new fields for enhancement bug#1851586
57 p_residency_status_cd IN VARCHAR2 DEFAULT NULL,
58 p_course_cd IN VARCHAR2 DEFAULT NULL,
59 p_version_number IN NUMBER DEFAULT NULL,
60 p_org_party_id IN NUMBER DEFAULT NULL,
61 p_class_standing IN VARCHAR2 DEFAULT NULL,
62 p_message_name OUT NOCOPY VARCHAR2,
63 p_unit_set_cd IN VARCHAR2,
64 p_us_version_number IN NUMBER,
65 p_unit_cd IN VARCHAR2 ,
66 p_unit_version_number IN NUMBER ,
67 p_unit_level IN VARCHAR2 ,
68 p_unit_type_id IN NUMBER ,
69 p_unit_mode IN VARCHAR2
70
71 ) RETURN BOOLEAN;
72 pragma restrict_references(finp_val_far_unique,wnds);
73 --
74 -- Validate fee assessment rate order of precednce.
75 FUNCTION finp_val_far_order(
76 p_fee_type IN VARCHAR2 ,
77 p_fee_cal_type IN VARCHAR2 ,
78 p_fee_ci_sequence_number IN NUMBER ,
79 p_s_relation_type IN VARCHAR2 ,
80 p_rate_number IN NUMBER ,
81 p_fee_cat IN VARCHAR2 ,
82 p_location_cd IN VARCHAR2 ,
83 p_attendance_type IN VARCHAR2 ,
84 p_attendance_mode IN VARCHAR2 ,
85 p_govt_hecs_payment_option IN VARCHAR2 ,
86 p_govt_hecs_cntrbtn_band IN NUMBER ,
87 p_order_of_precedence IN NUMBER ,
88 p_message_name OUT NOCOPY VARCHAR2 )
89 RETURN BOOLEAN;
90 pragma restrict_references(finp_val_far_order,wnds);
91 --
92 -- Ensure fee assessment rate fields can be populated.
93 FUNCTION finp_val_far_defntn(
94 p_fee_type IN VARCHAR2 ,
95 p_location_cd IN VARCHAR2 ,
96 p_attendance_type IN VARCHAR2 ,
97 p_attendance_mode IN VARCHAR2 ,
98 p_govt_hecs_payment_option IN VARCHAR2 ,
99 p_govt_hecs_cntrbtn_band IN NUMBER ,
100 p_message_name OUT NOCOPY VARCHAR2 )
101 RETURN BOOLEAN;
102 pragma restrict_references(finp_val_far_defntn,wnds);
103 --
104 -- Validate the attendance mode closed indicator.
105 FUNCTION enrp_val_am_closed(
106 p_attend_mode IN VARCHAR2 ,
107 p_message_name OUT NOCOPY VARCHAR2 )
108 RETURN BOOLEAN;
109 pragma restrict_references(enrp_val_am_closed,wnds);
110 --
111 -- Validate if IGS_FI_GOVT_HEC_CNTB.govt_hecs_contrbn_band is closed.
112 FUNCTION finp_val_ghc_closed(
113 p_govt_hecs_cntrbtn_band IN NUMBER ,
114 p_message_name OUT NOCOPY VARCHAR2 )
115 RETURN BOOLEAN;
116 pragma restrict_references(finp_val_ghc_closed,wnds);
117 --
118 -- Validate if IGS_FI_GOV_HEC_PA_OP.govt_hecs_payment_opt is closed.
119 FUNCTION finp_val_ghpo_closed(
120 p_govt_hecs_payment_option IN VARCHAR2 ,
121 p_message_name OUT NOCOPY VARCHAR2 )
122 RETURN BOOLEAN;
123 pragma restrict_references(finp_val_ghpo_closed,wnds);
124 --
125 -- Ensure fee assessment rate can be created.
126 FUNCTION finp_val_far_ins(
127 p_fee_type IN VARCHAR2 ,
128 p_message_name OUT NOCOPY VARCHAR2 )
129 RETURN BOOLEAN;
130 pragma restrict_references(finp_val_far_ins,wnds);
131 --
132 --
133 -- Validate the unit class closed indicator.
134 FUNCTION unit_class_closed(
135 p_unit_class IN VARCHAR2 ,
136 p_message_name OUT NOCOPY VARCHAR2 )
137 RETURN BOOLEAN ;
138 pragma restrict_references(unit_class_closed,wnds);
139 --
140 -- Ensure fee ass rate relations are valid.
141 FUNCTION finp_val_far_rltn(
142 p_s_relation_type IN VARCHAR2 ,
143 p_fee_cat IN VARCHAR2 ,
144 p_message_name OUT NOCOPY VARCHAR2 )
145 RETURN BOOLEAN;
146 pragma restrict_references(finp_val_far_rltn,wnds);
147
148 END IGS_FI_VAL_FAR;