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