[Home] [Help]
PACKAGE: APPS.OKL_SIL_PVT
Source
1 Package OKL_SIL_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSSILS.pls 120.4.12010000.3 2009/07/21 00:21:11 sechawla ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE sil_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 state_depre_dmnshing_value_rt NUMBER := OKC_API.G_MISS_NUM,
9 book_depre_dmnshing_value_rt NUMBER := OKC_API.G_MISS_NUM,
10 residual_guarantee_method OKL_SIF_LINES.RESIDUAL_GUARANTEE_METHOD%TYPE := OKC_API.G_MISS_CHAR,
11 residual_date OKL_SIF_LINES.RESIDUAL_DATE%TYPE := OKC_API.G_MISS_DATE,
12 fed_depre_term NUMBER := OKC_API.G_MISS_NUM,
13 fed_depre_dmnshing_value_rate NUMBER := OKC_API.G_MISS_NUM,
14 fed_depre_adr_conve OKL_SIF_LINES.FED_DEPRE_ADR_CONVE%TYPE := OKC_API.G_MISS_CHAR,
15 state_depre_basis_percent NUMBER := OKC_API.G_MISS_NUM,
16 state_depre_method OKL_SIF_LINES.STATE_DEPRE_METHOD%TYPE := OKC_API.G_MISS_CHAR,
17 purchase_option OKL_SIF_LINES.PURCHASE_OPTION%TYPE := OKC_API.G_MISS_CHAR,
18 purchase_option_amount NUMBER := OKC_API.G_MISS_NUM,
19 asset_cost NUMBER := OKC_API.G_MISS_NUM,
20 state_depre_term NUMBER := OKC_API.G_MISS_NUM,
21 state_depre_adr_convent OKL_SIF_LINES.STATE_DEPRE_ADR_CONVENT%TYPE := OKC_API.G_MISS_CHAR,
22 fed_depre_method OKL_SIF_LINES.FED_DEPRE_METHOD%TYPE := OKC_API.G_MISS_CHAR,
23 residual_amount NUMBER := OKC_API.G_MISS_NUM,
24 fed_depre_salvage OKL_SIF_LINES.FED_DEPRE_SALVAGE%TYPE,
25 date_fed_depre OKL_SIF_LINES.DATE_FED_DEPRE%TYPE := OKC_API.G_MISS_DATE,
26 book_salvage NUMBER := OKC_API.G_MISS_NUM,
27 book_adr_convention OKL_SIF_LINES.BOOK_ADR_CONVENTION%TYPE := OKC_API.G_MISS_CHAR,
28 state_depre_salvage NUMBER := OKC_API.G_MISS_NUM,
29 fed_depre_basis_percent NUMBER := OKC_API.G_MISS_NUM,
30 book_basis_percent NUMBER := OKC_API.G_MISS_NUM,
31 date_delivery OKL_SIF_LINES.DATE_DELIVERY%TYPE := OKC_API.G_MISS_DATE,
32 book_term NUMBER := OKC_API.G_MISS_NUM,
33 residual_guarantee_amount NUMBER := OKC_API.G_MISS_NUM,
34 date_funding OKL_SIF_LINES.DATE_FUNDING%TYPE := OKC_API.G_MISS_DATE,
35 date_book OKL_SIF_LINES.DATE_BOOK%TYPE := OKC_API.G_MISS_DATE,
36 date_state_depre OKL_SIF_LINES.DATE_STATE_DEPRE%TYPE := OKC_API.G_MISS_DATE,
37 book_method OKL_SIF_LINES.BOOK_METHOD%TYPE := OKC_API.G_MISS_CHAR,
38 stream_interface_attribute08 OKL_SIF_LINES.STREAM_INTERFACE_ATTRIBUTE08%TYPE := OKC_API.G_MISS_CHAR,
39 stream_interface_attribute03 OKL_SIF_LINES.STREAM_INTERFACE_ATTRIBUTE03%TYPE := OKC_API.G_MISS_CHAR,
40 stream_interface_attribute01 OKL_SIF_LINES.STREAM_INTERFACE_ATTRIBUTE01%TYPE := OKC_API.G_MISS_CHAR,
41 index_number NUMBER := OKC_API.G_MISS_NUM,
42 stream_interface_attribute05 OKL_SIF_LINES.STREAM_INTERFACE_ATTRIBUTE05%TYPE := OKC_API.G_MISS_CHAR,
43 description OKL_SIF_LINES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
44 stream_interface_attribute10 OKL_SIF_LINES.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
45 stream_interface_attribute06 OKL_SIF_LINES.STREAM_INTERFACE_ATTRIBUTE06%TYPE := OKC_API.G_MISS_CHAR,
46 stream_interface_attribute09 OKL_SIF_LINES.STREAM_INTERFACE_ATTRIBUTE09%TYPE := OKC_API.G_MISS_CHAR,
47 stream_interface_attribute07 OKL_SIF_LINES.STREAM_INTERFACE_ATTRIBUTE07%TYPE := OKC_API.G_MISS_CHAR,
48 stream_interface_attribute14 OKL_SIF_LINES.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
49 stream_interface_attribute12 OKL_SIF_LINES.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
50 stream_interface_attribute15 OKL_SIF_LINES.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
51 stream_interface_attribute02 OKL_SIF_LINES.STREAM_INTERFACE_ATTRIBUTE02%TYPE := OKC_API.G_MISS_CHAR,
52 stream_interface_attribute11 OKL_SIF_LINES.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
53 stream_interface_attribute04 OKL_SIF_LINES.STREAM_INTERFACE_ATTRIBUTE04%TYPE := OKC_API.G_MISS_CHAR,
54 stream_interface_attribute13 OKL_SIF_LINES.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
55 date_start OKL_SIF_LINES.DATE_START%TYPE := OKC_API.G_MISS_DATE,
56 date_lending OKL_SIF_LINES.DATE_LENDING%TYPE := OKC_API.G_MISS_DATE,
57 sif_id NUMBER := OKC_API.G_MISS_NUM,
58 object_version_number NUMBER := OKC_API.G_MISS_NUM,
59 kle_id NUMBER := OKC_API.G_MISS_NUM,
60 sil_type OKL_SIF_LINES.SIL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
61 created_by NUMBER := OKC_API.G_MISS_NUM,
62 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
63 creation_date OKL_SIF_LINES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
64 last_update_date OKL_SIF_LINES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
65 last_update_login NUMBER := OKC_API.G_MISS_NUM,
66 -- mvasudev, 05/13/2002
67 residual_guarantee_type OKL_SIF_LINES.RESIDUAL_GUARANTEE_TYPE%TYPE := OKC_API.G_MISS_CHAR
68 -- rgooty: Bug #4629365
69 ,down_payment_amount NUMBER := OKC_API.G_MISS_NUM
70 ,capitalize_down_payment_yn OKL_SIF_LINES.CAPITALIZE_DOWN_PAYMENT_YN%TYPE := OKC_API.G_MISS_CHAR
71 ,orig_contract_line_id NUMBER := OKC_API.G_MISS_NUM);
72 g_miss_sil_rec sil_rec_type;
73 TYPE sil_tbl_type IS TABLE OF sil_rec_type
74 INDEX BY BINARY_INTEGER;
75 TYPE silv_rec_type IS RECORD (
76 id NUMBER := OKC_API.G_MISS_NUM,
77 state_depre_dmnshing_value_rt NUMBER := OKC_API.G_MISS_NUM,
78 book_depre_dmnshing_value_rt NUMBER := OKC_API.G_MISS_NUM,
79 residual_guarantee_method OKL_SIF_LINES_V.RESIDUAL_GUARANTEE_METHOD%TYPE := OKC_API.G_MISS_CHAR,
80 residual_date OKL_SIF_LINES_V.RESIDUAL_DATE%TYPE := OKC_API.G_MISS_DATE,
81 fed_depre_term NUMBER := OKC_API.G_MISS_NUM,
82 fed_depre_dmnshing_value_rate NUMBER := OKC_API.G_MISS_NUM,
83 fed_depre_adr_conve OKL_SIF_LINES_V.FED_DEPRE_ADR_CONVE%TYPE := OKC_API.G_MISS_CHAR,
84 state_depre_basis_percent NUMBER := OKC_API.G_MISS_NUM,
85 state_depre_method OKL_SIF_LINES_V.STATE_DEPRE_METHOD%TYPE := OKC_API.G_MISS_CHAR,
86 purchase_option OKL_SIF_LINES_V.PURCHASE_OPTION%TYPE := OKC_API.G_MISS_CHAR,
87 purchase_option_amount NUMBER := OKC_API.G_MISS_NUM,
88 asset_cost NUMBER := OKC_API.G_MISS_NUM,
89 state_depre_term NUMBER := OKC_API.G_MISS_NUM,
90 state_depre_adr_convent OKL_SIF_LINES_V.STATE_DEPRE_ADR_CONVENT%TYPE := OKC_API.G_MISS_CHAR,
91 fed_depre_method OKL_SIF_LINES_V.FED_DEPRE_METHOD%TYPE := OKC_API.G_MISS_CHAR,
92 residual_amount NUMBER := OKC_API.G_MISS_NUM,
93 fed_depre_salvage OKL_SIF_LINES_V.FED_DEPRE_SALVAGE%TYPE,
94 date_fed_depre OKL_SIF_LINES_V.DATE_FED_DEPRE%TYPE := OKC_API.G_MISS_DATE,
95 book_salvage NUMBER := OKC_API.G_MISS_NUM,
96 book_adr_convention OKL_SIF_LINES_V.BOOK_ADR_CONVENTION%TYPE := OKC_API.G_MISS_CHAR,
97 state_depre_salvage NUMBER := OKC_API.G_MISS_NUM,
98 fed_depre_basis_percent NUMBER := OKC_API.G_MISS_NUM,
99 book_basis_percent NUMBER := OKC_API.G_MISS_NUM,
100 date_delivery OKL_SIF_LINES_V.DATE_DELIVERY%TYPE := OKC_API.G_MISS_DATE,
101 book_term NUMBER := OKC_API.G_MISS_NUM,
102 residual_guarantee_amount NUMBER := OKC_API.G_MISS_NUM,
103 date_funding OKL_SIF_LINES_V.DATE_FUNDING%TYPE := OKC_API.G_MISS_DATE,
104 date_book OKL_SIF_LINES_V.DATE_BOOK%TYPE := OKC_API.G_MISS_DATE,
105 date_state_depre OKL_SIF_LINES_V.DATE_STATE_DEPRE%TYPE := OKC_API.G_MISS_DATE,
106 book_method OKL_SIF_LINES_V.BOOK_METHOD%TYPE := OKC_API.G_MISS_CHAR,
107 stream_interface_attribute08 OKL_SIF_LINES_V.STREAM_INTERFACE_ATTRIBUTE08%TYPE := OKC_API.G_MISS_CHAR,
108 stream_interface_attribute03 OKL_SIF_LINES_V.STREAM_INTERFACE_ATTRIBUTE03%TYPE := OKC_API.G_MISS_CHAR,
109 stream_interface_attribute01 OKL_SIF_LINES_V.STREAM_INTERFACE_ATTRIBUTE01%TYPE := OKC_API.G_MISS_CHAR,
110 index_number NUMBER := OKC_API.G_MISS_NUM,
111 stream_interface_attribute05 OKL_SIF_LINES_V.STREAM_INTERFACE_ATTRIBUTE05%TYPE := OKC_API.G_MISS_CHAR,
112 description OKL_SIF_LINES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
113 stream_interface_attribute10 OKL_SIF_LINES_V.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
114 stream_interface_attribute06 OKL_SIF_LINES_V.STREAM_INTERFACE_ATTRIBUTE06%TYPE := OKC_API.G_MISS_CHAR,
115 stream_interface_attribute09 OKL_SIF_LINES_V.STREAM_INTERFACE_ATTRIBUTE09%TYPE := OKC_API.G_MISS_CHAR,
116 stream_interface_attribute07 OKL_SIF_LINES_V.STREAM_INTERFACE_ATTRIBUTE07%TYPE := OKC_API.G_MISS_CHAR,
117 stream_interface_attribute14 OKL_SIF_LINES_V.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
118 stream_interface_attribute12 OKL_SIF_LINES_V.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
119 stream_interface_attribute15 OKL_SIF_LINES_V.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
120 stream_interface_attribute02 OKL_SIF_LINES_V.STREAM_INTERFACE_ATTRIBUTE02%TYPE := OKC_API.G_MISS_CHAR,
121 stream_interface_attribute11 OKL_SIF_LINES_V.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
122 stream_interface_attribute04 OKL_SIF_LINES_V.STREAM_INTERFACE_ATTRIBUTE04%TYPE := OKC_API.G_MISS_CHAR,
123 stream_interface_attribute13 OKL_SIF_LINES_V.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
124 date_start OKL_SIF_LINES_V.DATE_START%TYPE := OKC_API.G_MISS_DATE,
125 date_lending OKL_SIF_LINES_V.DATE_LENDING%TYPE := OKC_API.G_MISS_DATE,
126 sif_id NUMBER := OKC_API.G_MISS_NUM,
127 object_version_number NUMBER := OKC_API.G_MISS_NUM,
128 kle_id NUMBER := OKC_API.G_MISS_NUM,
129 sil_type OKL_SIF_LINES_V.SIL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
130 created_by NUMBER := OKC_API.G_MISS_NUM,
131 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
132 creation_date OKL_SIF_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
133 last_update_date OKL_SIF_LINES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
134 last_update_login NUMBER := OKC_API.G_MISS_NUM,
135 -- mvasudev, 05/13/2002
136 residual_guarantee_type OKL_SIF_LINES_V.RESIDUAL_GUARANTEE_TYPE%TYPE := OKC_API.G_MISS_CHAR
137 -- rgooty: Bug #4629365
138 ,down_payment_amount NUMBER := OKC_API.G_MISS_NUM
139 ,capitalize_down_payment_yn OKL_SIF_LINES_V.CAPITALIZE_DOWN_PAYMENT_YN%TYPE := OKC_API.G_MISS_CHAR
140 ,orig_contract_line_id NUMBER := OKC_API.G_MISS_NUM
141 );
142 g_miss_silv_rec silv_rec_type;
143 TYPE silv_tbl_type IS TABLE OF silv_rec_type
144 INDEX BY BINARY_INTEGER;
145 ---------------------------------------------------------------------------
146 -- GLOBAL MESSAGE CONSTANTS
147 ---------------------------------------------------------------------------
148 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
149 G_OKC_APP CONSTANT VARCHAR2(200) := OKC_API.G_APP_NAME;
150 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
151 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
152 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
153 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
154 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
155 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
156 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
157 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
158 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
159 G_OKL_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) :='OKL_CONTRACTS_UNEXPECTED_ERROR';
160 G_OKL_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
161 G_OKL_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
162
163 ---------------------------------------------------------------------------
164 -- GLOBAL VARIABLES
165 ---------------------------------------------------------------------------
166 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SIL_PVT';
167 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
168 G_SIL_TYPE_LEASE CONSTANT VARCHAR2(10) := 'SGA';
169 G_SIL_TYPE_LOAN CONSTANT VARCHAR2(10) := 'SGN';
170
171 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
172 ---------------------------------------------------------------------------
173 -- Procedures and Functions
174 ---------------------------------------------------------------------------
175
176 PROCEDURE qc;
177 PROCEDURE change_version;
178 PROCEDURE api_copy;
179 PROCEDURE insert_row(
180 p_api_version IN NUMBER,
181 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
182 x_return_status OUT NOCOPY VARCHAR2,
183 x_msg_count OUT NOCOPY NUMBER,
184 x_msg_data OUT NOCOPY VARCHAR2,
185 p_silv_rec IN silv_rec_type,
186 x_silv_rec OUT NOCOPY silv_rec_type);
187
188 PROCEDURE insert_row(
189 p_api_version IN NUMBER,
190 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
191 x_return_status OUT NOCOPY VARCHAR2,
192 x_msg_count OUT NOCOPY NUMBER,
193 x_msg_data OUT NOCOPY VARCHAR2,
194 p_silv_tbl IN silv_tbl_type,
195 x_silv_tbl OUT NOCOPY silv_tbl_type);
196
197 PROCEDURE lock_row(
198 p_api_version IN NUMBER,
199 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
200 x_return_status OUT NOCOPY VARCHAR2,
201 x_msg_count OUT NOCOPY NUMBER,
202 x_msg_data OUT NOCOPY VARCHAR2,
203 p_silv_rec IN silv_rec_type);
204
205 PROCEDURE lock_row(
206 p_api_version IN NUMBER,
207 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
208 x_return_status OUT NOCOPY VARCHAR2,
209 x_msg_count OUT NOCOPY NUMBER,
210 x_msg_data OUT NOCOPY VARCHAR2,
211 p_silv_tbl IN silv_tbl_type);
212
213 PROCEDURE update_row(
214 p_api_version IN NUMBER,
215 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
216 x_return_status OUT NOCOPY VARCHAR2,
217 x_msg_count OUT NOCOPY NUMBER,
218 x_msg_data OUT NOCOPY VARCHAR2,
219 p_silv_rec IN silv_rec_type,
220 x_silv_rec OUT NOCOPY silv_rec_type);
221
222 PROCEDURE update_row(
223 p_api_version IN NUMBER,
224 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
225 x_return_status OUT NOCOPY VARCHAR2,
226 x_msg_count OUT NOCOPY NUMBER,
227 x_msg_data OUT NOCOPY VARCHAR2,
228 p_silv_tbl IN silv_tbl_type,
229 x_silv_tbl OUT NOCOPY silv_tbl_type);
230
231 PROCEDURE delete_row(
232 p_api_version IN NUMBER,
233 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
234 x_return_status OUT NOCOPY VARCHAR2,
235 x_msg_count OUT NOCOPY NUMBER,
236 x_msg_data OUT NOCOPY VARCHAR2,
237 p_silv_rec IN silv_rec_type);
238
239 PROCEDURE delete_row(
240 p_api_version IN NUMBER,
241 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
242 x_return_status OUT NOCOPY VARCHAR2,
243 x_msg_count OUT NOCOPY NUMBER,
244 x_msg_data OUT NOCOPY VARCHAR2,
245 p_silv_tbl IN silv_tbl_type);
246
247 PROCEDURE validate_row(
248 p_api_version IN NUMBER,
249 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
250 x_return_status OUT NOCOPY VARCHAR2,
251 x_msg_count OUT NOCOPY NUMBER,
252 x_msg_data OUT NOCOPY VARCHAR2,
253 p_silv_rec IN silv_rec_type);
254
255 PROCEDURE validate_row(
256 p_api_version IN NUMBER,
257 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
258 x_return_status OUT NOCOPY VARCHAR2,
259 x_msg_count OUT NOCOPY NUMBER,
260 x_msg_data OUT NOCOPY VARCHAR2,
261 p_silv_tbl IN silv_tbl_type);
262
263 END OKL_SIL_PVT;