[Home] [Help]
PACKAGE: APPS.OKL_SFE_PVT
Source
1 Package OKL_SFE_PVT AS
2 /* $Header: OKLSSFES.pls 120.5 2005/10/11 05:31:11 rgooty noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE sfe_rec_type IS RECORD (
7 id NUMBER:= OKC_API.G_MISS_NUM,
8 sfe_type OKL_SIF_FEES.SFE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
9 date_start OKL_SIF_FEES.DATE_START%TYPE := OKC_API.G_MISS_DATE,
10 date_paid OKL_SIF_FEES.DATE_PAID%TYPE := OKC_API.G_MISS_DATE,
11 amount NUMBER := OKC_API.G_MISS_NUM,
12 idc_accounting_flag OKL_SIF_FEES.IDC_ACCOUNTING_FLAG%TYPE := OKC_API.G_MISS_CHAR,
13 income_or_expense OKL_SIF_FEES.INCOME_OR_EXPENSE%TYPE := OKC_API.G_MISS_CHAR,
14 description OKL_SIF_FEES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
15 fee_index_number NUMBER := OKC_API.G_MISS_NUM,
16 level_index_number NUMBER := OKC_API.G_MISS_NUM,
17 advance_or_arrears OKL_SIF_FEES.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
18 level_type OKL_SIF_FEES.LEVEL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
19 lock_level_step OKL_SIF_FEES.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR,
20 period OKL_SIF_FEES.PERIOD%TYPE := OKC_API.G_MISS_CHAR,
21 number_of_periods NUMBER := OKC_API.G_MISS_NUM,
22 level_line_number NUMBER := OKC_API.G_MISS_NUM,
23 sif_id NUMBER := OKC_API.G_MISS_NUM,
24 kle_id NUMBER := OKC_API.G_MISS_NUM,
25 sil_id NUMBER:= OKC_API.G_MISS_NUM,
26 rate NUMBER := OKC_API.G_MISS_NUM,
27 -- 05/13/2002, mvasudev
28 -- added for "Restructure" requirements
29 query_level_yn OKL_SIF_FEES.QUERY_LEVEL_YN%TYPE := OKC_API.G_MISS_CHAR,
30 structure OKL_SIF_FEES.STRUCTURE%TYPE := OKC_API.G_MISS_CHAR,
31 days_in_period NUMBER := OKC_API.G_MISS_NUM,
32 --
33 object_version_number NUMBER := OKC_API.G_MISS_NUM,
34 cash_effect_yn OKL_SIF_FEES.cash_effect_yn%TYPE := OKC_API.G_MISS_CHAR,
35 tax_effect_yn OKL_SIF_FEES.tax_effect_yn%TYPE := OKC_API.G_MISS_CHAR,
36 DAYS_IN_MONTH OKL_SIF_FEES.DAYS_IN_MONTH%TYPE := OKC_API.G_MISS_CHAR,
37 DAYS_IN_YEAR OKL_SIF_FEES.DAYS_IN_YEAR%TYPE := OKC_API.G_MISS_CHAR,
38 BALANCE_TYPE_CODE OKL_SIF_FEES.BALANCE_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR,
39 stream_interface_attribute01 OKL_SIF_FEES.STREAM_INTERFACE_ATTRIBUTE01%TYPE := OKC_API.G_MISS_CHAR,
40 stream_interface_attribute02 OKL_SIF_FEES.STREAM_INTERFACE_ATTRIBUTE02%TYPE := OKC_API.G_MISS_CHAR,
41 stream_interface_attribute03 OKL_SIF_FEES.STREAM_INTERFACE_ATTRIBUTE03%TYPE := OKC_API.G_MISS_CHAR,
42 stream_interface_attribute04 OKL_SIF_FEES.STREAM_INTERFACE_ATTRIBUTE04%TYPE := OKC_API.G_MISS_CHAR,
43 stream_interface_attribute05 OKL_SIF_FEES.STREAM_INTERFACE_ATTRIBUTE05%TYPE := OKC_API.G_MISS_CHAR,
44 stream_interface_attribute06 OKL_SIF_FEES.STREAM_INTERFACE_ATTRIBUTE06%TYPE := OKC_API.G_MISS_CHAR,
45 stream_interface_attribute07 OKL_SIF_FEES.STREAM_INTERFACE_ATTRIBUTE07%TYPE := OKC_API.G_MISS_CHAR,
46 stream_interface_attribute08 OKL_SIF_FEES.STREAM_INTERFACE_ATTRIBUTE08%TYPE := OKC_API.G_MISS_CHAR,
47 stream_interface_attribute09 OKL_SIF_FEES.STREAM_INTERFACE_ATTRIBUTE09%TYPE := OKC_API.G_MISS_CHAR,
48 stream_interface_attribute10 OKL_SIF_FEES.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
49 stream_interface_attribute11 OKL_SIF_FEES.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
50 stream_interface_attribute12 OKL_SIF_FEES.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
51 stream_interface_attribute13 OKL_SIF_FEES.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
52 stream_interface_attribute14 OKL_SIF_FEES.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
53 stream_interface_attribute15 OKL_SIF_FEES.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
54 stream_interface_attribute16 OKL_SIF_FEES.STREAM_INTERFACE_ATTRIBUTE16%TYPE := OKC_API.G_MISS_CHAR,
55 stream_interface_attribute17 OKL_SIF_FEES.STREAM_INTERFACE_ATTRIBUTE17%TYPE := OKC_API.G_MISS_CHAR,
56 stream_interface_attribute18 OKL_SIF_FEES.STREAM_INTERFACE_ATTRIBUTE18%TYPE := OKC_API.G_MISS_CHAR,
57 stream_interface_attribute19 OKL_SIF_FEES.STREAM_INTERFACE_ATTRIBUTE19%TYPE := OKC_API.G_MISS_CHAR,
58 stream_interface_attribute20 OKL_SIF_FEES.STREAM_INTERFACE_ATTRIBUTE20%TYPE := OKC_API.G_MISS_CHAR,
59 created_by NUMBER:= OKC_API.G_MISS_NUM,
60 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
61 creation_date OKL_SIF_FEES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
62 last_update_date OKL_SIF_FEES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
63 last_update_login NUMBER := OKC_API.G_MISS_NUM,
64 down_payment_amount NUMBER := OKC_API.G_MISS_NUM);
65 g_miss_sfe_rec sfe_rec_type;
66 TYPE sfe_tbl_type IS TABLE OF sfe_rec_type
67 INDEX BY BINARY_INTEGER;
68 TYPE sfev_rec_type IS RECORD (
69 id NUMBER:= OKC_API.G_MISS_NUM,
70 sfe_type OKL_SIF_FEES_V.SFE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
71 date_start OKL_SIF_FEES_V.DATE_START%TYPE := OKC_API.G_MISS_DATE,
72 date_paid OKL_SIF_FEES_V.DATE_PAID%TYPE := OKC_API.G_MISS_DATE,
73 amount NUMBER := OKC_API.G_MISS_NUM,
74 idc_accounting_flag OKL_SIF_FEES_V.IDC_ACCOUNTING_FLAG%TYPE := OKC_API.G_MISS_CHAR,
75 income_or_expense OKL_SIF_FEES_V.INCOME_OR_EXPENSE%TYPE := OKC_API.G_MISS_CHAR,
76 description OKL_SIF_FEES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
77 fee_index_number NUMBER := OKC_API.G_MISS_NUM,
78 level_index_number NUMBER := OKC_API.G_MISS_NUM,
79 advance_or_arrears OKL_SIF_FEES_V.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
80 level_type OKL_SIF_FEES_V.LEVEL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
81 lock_level_step OKL_SIF_FEES_V.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR,
82 period OKL_SIF_FEES_V.PERIOD%TYPE := OKC_API.G_MISS_CHAR,
83 number_of_periods NUMBER := OKC_API.G_MISS_NUM,
84 level_line_number NUMBER := OKC_API.G_MISS_NUM,
85 sif_id NUMBER := OKC_API.G_MISS_NUM,
86 kle_id NUMBER := OKC_API.G_MISS_NUM,
87 sil_id NUMBER:= OKC_API.G_MISS_NUM,
88 rate NUMBER := OKC_API.G_MISS_NUM,
89 -- 05/13/2002, mvasudev
90 -- added for "Restructure" requirements
91 query_level_yn OKL_SIF_FEES_V.QUERY_LEVEL_YN%TYPE := OKC_API.G_MISS_CHAR,
92 structure OKL_SIF_FEES_V.STRUCTURE%TYPE := OKC_API.G_MISS_CHAR,
93 days_in_period NUMBER := OKC_API.G_MISS_NUM,
94 --
95 object_version_number NUMBER := OKC_API.G_MISS_NUM,
96 cash_effect_yn OKL_SIF_FEES_v.cash_effect_yn%TYPE := OKC_API.G_MISS_CHAR,
97 tax_effect_yn OKL_SIF_FEES_v.tax_effect_yn%TYPE := OKC_API.G_MISS_CHAR,
98 days_in_month OKL_SIF_FEES.DAYS_IN_MONTH%TYPE := OKC_API.G_MISS_CHAR,
99 days_in_year OKL_SIF_FEES.DAYS_IN_YEAR%TYPE := OKC_API.G_MISS_CHAR,
100 balance_type_code OKL_SIF_FEES.BALANCE_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR,
101 stream_interface_attribute01 OKL_SIF_FEES_V.STREAM_INTERFACE_ATTRIBUTE01%TYPE := OKC_API.G_MISS_CHAR,
102 stream_interface_attribute02 OKL_SIF_FEES_V.STREAM_INTERFACE_ATTRIBUTE02%TYPE := OKC_API.G_MISS_CHAR,
103 stream_interface_attribute03 OKL_SIF_FEES_V.STREAM_INTERFACE_ATTRIBUTE03%TYPE := OKC_API.G_MISS_CHAR,
104 stream_interface_attribute04 OKL_SIF_FEES_V.STREAM_INTERFACE_ATTRIBUTE04%TYPE := OKC_API.G_MISS_CHAR,
105 stream_interface_attribute05 OKL_SIF_FEES_V.STREAM_INTERFACE_ATTRIBUTE05%TYPE := OKC_API.G_MISS_CHAR,
106 stream_interface_attribute06 OKL_SIF_FEES_V.STREAM_INTERFACE_ATTRIBUTE06%TYPE := OKC_API.G_MISS_CHAR,
107 stream_interface_attribute07 OKL_SIF_FEES_V.STREAM_INTERFACE_ATTRIBUTE07%TYPE := OKC_API.G_MISS_CHAR,
108 stream_interface_attribute08 OKL_SIF_FEES_V.STREAM_INTERFACE_ATTRIBUTE08%TYPE := OKC_API.G_MISS_CHAR,
109 stream_interface_attribute09 OKL_SIF_FEES_V.STREAM_INTERFACE_ATTRIBUTE09%TYPE := OKC_API.G_MISS_CHAR,
110 stream_interface_attribute10 OKL_SIF_FEES_V.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
111
112 stream_interface_attribute11 OKL_SIF_FEES_V.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
113 stream_interface_attribute12 OKL_SIF_FEES_V.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
114 stream_interface_attribute13 OKL_SIF_FEES_V.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
115 stream_interface_attribute14 OKL_SIF_FEES_V.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
116 stream_interface_attribute15 OKL_SIF_FEES_V.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
117 stream_interface_attribute16 OKL_SIF_FEES_V.STREAM_INTERFACE_ATTRIBUTE16%TYPE := OKC_API.G_MISS_CHAR,
118 stream_interface_attribute17 OKL_SIF_FEES_V.STREAM_INTERFACE_ATTRIBUTE17%TYPE := OKC_API.G_MISS_CHAR,
119 stream_interface_attribute18 OKL_SIF_FEES_V.STREAM_INTERFACE_ATTRIBUTE18%TYPE := OKC_API.G_MISS_CHAR,
120 stream_interface_attribute19 OKL_SIF_FEES_V.STREAM_INTERFACE_ATTRIBUTE19%TYPE := OKC_API.G_MISS_CHAR,
121 stream_interface_attribute20 OKL_SIF_FEES_V.STREAM_INTERFACE_ATTRIBUTE20%TYPE := OKC_API.G_MISS_CHAR,
122 created_by NUMBER:= OKC_API.G_MISS_NUM,
123 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
124 creation_date OKL_SIF_FEES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
125 last_update_date OKL_SIF_FEES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
126 last_update_login NUMBER := OKC_API.G_MISS_NUM,
127 down_payment_amount NUMBER := OKC_API.G_MISS_NUM);
128 g_miss_sfev_rec sfev_rec_type;
129 TYPE sfev_tbl_type IS TABLE OF sfev_rec_type
130 INDEX BY BINARY_INTEGER;
131 ---------------------------------------------------------------------------
132 -- GLOBAL MESSAGE CONSTANTS
133 ---------------------------------------------------------------------------
134 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
135 G_OKC_APP CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
136 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
137 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
138 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
139 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
140 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
141 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
142 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
143 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
144 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
145
146
147
148 -- START CHANGE : akjain -- 09/05/2001
149 -- Adding MESSAGE CONSTANTs
150 G_OKL_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
151 G_OKL_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
152 G_OKL_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
153 G_OKL_UNQS CONSTANT VARCHAR2(200) := 'OKL_SFE_NOT_UNIQUE';
154 G_SFE_TYPE_ONE_OFF CONSTANT VARCHAR2(200) := 'SFO';
155
156 -- 04/23/2003 , mvasudev
157 G_SFE_TYPE_PERIODIC_EXPENSE CONSTANT VARCHAR2(200) := 'SFP';
158 G_SFE_TYPE_RENT CONSTANT VARCHAR2(200) := 'SFR';
159 G_SFE_TYPE_LOAN CONSTANT VARCHAR2(200) := 'SFN';
160 G_SFE_TYPE_PERIODIC_INCOME CONSTANT VARCHAR2(200) := 'SFI';
161 -- end, mvasudev -- 04/23/2003
162 -- start smahapat fee type soln
163 G_SFE_TYPE_SECURITY_DEPOSIT CONSTANT VARCHAR2(200) := 'SFD';
164
165 -- start sgorantl for subsidies
166 G_SFE_TYPE_SUBSIDY CONSTANT VARCHAR2(200) := 'SFB';
167
168 -- start smahapat fee type soln
169
170 -- Added Exception for Halt_validation
171 --------------------------------------------------------------------------------
172 -- ERRORS AND EXCEPTIONS
173 --------------------------------------------------------------------------------
174 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
175 -- END change : akjain
176
177
178 ---------------------------------------------------------------------------
179 -- GLOBAL VARIABLES
180 ---------------------------------------------------------------------------
181 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SFE_PVT';
182 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
183 ---------------------------------------------------------------------------
184 -- Procedures and Functions
185 ---------------------------------------------------------------------------
186
187 PROCEDURE qc;
188 PROCEDURE change_version;
189 PROCEDURE api_copy;
190 PROCEDURE insert_row(
191 p_api_version IN NUMBER,
192 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
193 x_return_status OUT NOCOPY VARCHAR2,
194 x_msg_count OUT NOCOPY NUMBER,
195 x_msg_data OUT NOCOPY VARCHAR2,
196 p_sfev_rec IN sfev_rec_type,
197 x_sfev_rec OUT NOCOPY sfev_rec_type);
198
199 PROCEDURE insert_row(
200 p_api_version IN NUMBER,
201 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
202 x_return_status OUT NOCOPY VARCHAR2,
203 x_msg_count OUT NOCOPY NUMBER,
204 x_msg_data OUT NOCOPY VARCHAR2,
205 p_sfev_tbl IN sfev_tbl_type,
206 x_sfev_tbl OUT NOCOPY sfev_tbl_type);
207
208 PROCEDURE lock_row(
209 p_api_version IN NUMBER,
210 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
211 x_return_status OUT NOCOPY VARCHAR2,
212
213 x_msg_count OUT NOCOPY NUMBER,
214 x_msg_data OUT NOCOPY VARCHAR2,
215 p_sfev_rec IN sfev_rec_type);
216
217 PROCEDURE lock_row(
218 p_api_version IN NUMBER,
219 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
220 x_return_status OUT NOCOPY VARCHAR2,
221 x_msg_count OUT NOCOPY NUMBER,
222 x_msg_data OUT NOCOPY VARCHAR2,
223 p_sfev_tbl IN sfev_tbl_type);
224
225 PROCEDURE update_row(
226 p_api_version IN NUMBER,
227 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
228 x_return_status OUT NOCOPY VARCHAR2,
229 x_msg_count OUT NOCOPY NUMBER,
230 x_msg_data OUT NOCOPY VARCHAR2,
231 p_sfev_rec IN sfev_rec_type,
232 x_sfev_rec OUT NOCOPY sfev_rec_type);
233
234 PROCEDURE update_row(
235 p_api_version IN NUMBER,
236 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
237 x_return_status OUT NOCOPY VARCHAR2,
238 x_msg_count OUT NOCOPY NUMBER,
239 x_msg_data OUT NOCOPY VARCHAR2,
240 p_sfev_tbl IN sfev_tbl_type,
241 x_sfev_tbl OUT NOCOPY sfev_tbl_type);
242
243 PROCEDURE delete_row(
244 p_api_version IN NUMBER,
245 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
246 x_return_status OUT NOCOPY VARCHAR2,
247 x_msg_count OUT NOCOPY NUMBER,
248 x_msg_data OUT NOCOPY VARCHAR2,
249 p_sfev_rec IN sfev_rec_type);
250
251 PROCEDURE delete_row(
252 p_api_version IN NUMBER,
253 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
254 x_return_status OUT NOCOPY VARCHAR2,
255 x_msg_count OUT NOCOPY NUMBER,
256 x_msg_data OUT NOCOPY VARCHAR2,
257 p_sfev_tbl IN sfev_tbl_type);
258
259 PROCEDURE validate_row(
260 p_api_version IN NUMBER,
261 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
262 x_return_status OUT NOCOPY VARCHAR2,
263 x_msg_count OUT NOCOPY NUMBER,
264 x_msg_data OUT NOCOPY VARCHAR2,
265 p_sfev_rec IN sfev_rec_type);
266
267 PROCEDURE validate_row(
268 p_api_version IN NUMBER,
269 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
270 x_return_status OUT NOCOPY VARCHAR2,
271 x_msg_count OUT NOCOPY NUMBER,
272 x_msg_data OUT NOCOPY VARCHAR2,
273 p_sfev_tbl IN sfev_tbl_type);
274
275 END OKL_SFE_PVT;