[Home] [Help]
PACKAGE: APPS.OKL_SIL_PVT
Source
1 Package OKL_SIL_PVT AS
2 /* $Header: OKLSSILS.pls 120.4 2005/10/11 05:28:06 rgooty noship $ */
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 g_miss_sil_rec sil_rec_type;
72 TYPE sil_tbl_type IS TABLE OF sil_rec_type
73 INDEX BY BINARY_INTEGER;
74 TYPE silv_rec_type IS RECORD (
75 id NUMBER := OKC_API.G_MISS_NUM,
76 state_depre_dmnshing_value_rt NUMBER := OKC_API.G_MISS_NUM,
77 book_depre_dmnshing_value_rt NUMBER := OKC_API.G_MISS_NUM,
78 residual_guarantee_method OKL_SIF_LINES_V.RESIDUAL_GUARANTEE_METHOD%TYPE := OKC_API.G_MISS_CHAR,
79 residual_date OKL_SIF_LINES_V.RESIDUAL_DATE%TYPE := OKC_API.G_MISS_DATE,
80 fed_depre_term NUMBER := OKC_API.G_MISS_NUM,
81 fed_depre_dmnshing_value_rate NUMBER := OKC_API.G_MISS_NUM,
82 fed_depre_adr_conve OKL_SIF_LINES_V.FED_DEPRE_ADR_CONVE%TYPE := OKC_API.G_MISS_CHAR,
83 state_depre_basis_percent NUMBER := OKC_API.G_MISS_NUM,
84 state_depre_method OKL_SIF_LINES_V.STATE_DEPRE_METHOD%TYPE := OKC_API.G_MISS_CHAR,
85 purchase_option OKL_SIF_LINES_V.PURCHASE_OPTION%TYPE := OKC_API.G_MISS_CHAR,
86 purchase_option_amount NUMBER := OKC_API.G_MISS_NUM,
87 asset_cost NUMBER := OKC_API.G_MISS_NUM,
88 state_depre_term NUMBER := OKC_API.G_MISS_NUM,
89 state_depre_adr_convent OKL_SIF_LINES_V.STATE_DEPRE_ADR_CONVENT%TYPE := OKC_API.G_MISS_CHAR,
90 fed_depre_method OKL_SIF_LINES_V.FED_DEPRE_METHOD%TYPE := OKC_API.G_MISS_CHAR,
91 residual_amount NUMBER := OKC_API.G_MISS_NUM,
92 fed_depre_salvage OKL_SIF_LINES_V.FED_DEPRE_SALVAGE%TYPE,
93 date_fed_depre OKL_SIF_LINES_V.DATE_FED_DEPRE%TYPE := OKC_API.G_MISS_DATE,
94 book_salvage NUMBER := OKC_API.G_MISS_NUM,
95 book_adr_convention OKL_SIF_LINES_V.BOOK_ADR_CONVENTION%TYPE := OKC_API.G_MISS_CHAR,
96 state_depre_salvage NUMBER := OKC_API.G_MISS_NUM,
97 fed_depre_basis_percent NUMBER := OKC_API.G_MISS_NUM,
98 book_basis_percent NUMBER := OKC_API.G_MISS_NUM,
99 date_delivery OKL_SIF_LINES_V.DATE_DELIVERY%TYPE := OKC_API.G_MISS_DATE,
100 book_term NUMBER := OKC_API.G_MISS_NUM,
101 residual_guarantee_amount NUMBER := OKC_API.G_MISS_NUM,
102 date_funding OKL_SIF_LINES_V.DATE_FUNDING%TYPE := OKC_API.G_MISS_DATE,
103 date_book OKL_SIF_LINES_V.DATE_BOOK%TYPE := OKC_API.G_MISS_DATE,
104 date_state_depre OKL_SIF_LINES_V.DATE_STATE_DEPRE%TYPE := OKC_API.G_MISS_DATE,
105 book_method OKL_SIF_LINES_V.BOOK_METHOD%TYPE := OKC_API.G_MISS_CHAR,
106 stream_interface_attribute08 OKL_SIF_LINES_V.STREAM_INTERFACE_ATTRIBUTE08%TYPE := OKC_API.G_MISS_CHAR,
107 stream_interface_attribute03 OKL_SIF_LINES_V.STREAM_INTERFACE_ATTRIBUTE03%TYPE := OKC_API.G_MISS_CHAR,
108 stream_interface_attribute01 OKL_SIF_LINES_V.STREAM_INTERFACE_ATTRIBUTE01%TYPE := OKC_API.G_MISS_CHAR,
109 index_number NUMBER := OKC_API.G_MISS_NUM,
110 stream_interface_attribute05 OKL_SIF_LINES_V.STREAM_INTERFACE_ATTRIBUTE05%TYPE := OKC_API.G_MISS_CHAR,
111 description OKL_SIF_LINES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
112 stream_interface_attribute10 OKL_SIF_LINES_V.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
113 stream_interface_attribute06 OKL_SIF_LINES_V.STREAM_INTERFACE_ATTRIBUTE06%TYPE := OKC_API.G_MISS_CHAR,
114 stream_interface_attribute09 OKL_SIF_LINES_V.STREAM_INTERFACE_ATTRIBUTE09%TYPE := OKC_API.G_MISS_CHAR,
115 stream_interface_attribute07 OKL_SIF_LINES_V.STREAM_INTERFACE_ATTRIBUTE07%TYPE := OKC_API.G_MISS_CHAR,
116 stream_interface_attribute14 OKL_SIF_LINES_V.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
117 stream_interface_attribute12 OKL_SIF_LINES_V.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
118 stream_interface_attribute15 OKL_SIF_LINES_V.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
119 stream_interface_attribute02 OKL_SIF_LINES_V.STREAM_INTERFACE_ATTRIBUTE02%TYPE := OKC_API.G_MISS_CHAR,
120 stream_interface_attribute11 OKL_SIF_LINES_V.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
121 stream_interface_attribute04 OKL_SIF_LINES_V.STREAM_INTERFACE_ATTRIBUTE04%TYPE := OKC_API.G_MISS_CHAR,
122 stream_interface_attribute13 OKL_SIF_LINES_V.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
123 date_start OKL_SIF_LINES_V.DATE_START%TYPE := OKC_API.G_MISS_DATE,
124 date_lending OKL_SIF_LINES_V.DATE_LENDING%TYPE := OKC_API.G_MISS_DATE,
125 sif_id NUMBER := OKC_API.G_MISS_NUM,
126 object_version_number NUMBER := OKC_API.G_MISS_NUM,
127 kle_id NUMBER := OKC_API.G_MISS_NUM,
128 sil_type OKL_SIF_LINES_V.SIL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
129 created_by NUMBER := OKC_API.G_MISS_NUM,
130 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
131 creation_date OKL_SIF_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
132 last_update_date OKL_SIF_LINES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
133 last_update_login NUMBER := OKC_API.G_MISS_NUM,
134 -- mvasudev, 05/13/2002
135 residual_guarantee_type OKL_SIF_LINES_V.RESIDUAL_GUARANTEE_TYPE%TYPE := OKC_API.G_MISS_CHAR
136 -- rgooty: Bug #4629365
137 ,down_payment_amount NUMBER := OKC_API.G_MISS_NUM
138 ,capitalize_down_payment_yn OKL_SIF_LINES_V.CAPITALIZE_DOWN_PAYMENT_YN%TYPE := OKC_API.G_MISS_CHAR
139 );
140 g_miss_silv_rec silv_rec_type;
141 TYPE silv_tbl_type IS TABLE OF silv_rec_type
142 INDEX BY BINARY_INTEGER;
143 ---------------------------------------------------------------------------
144 -- GLOBAL MESSAGE CONSTANTS
145 ---------------------------------------------------------------------------
146 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
147 G_OKC_APP CONSTANT VARCHAR2(200) := OKC_API.G_APP_NAME;
148 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
149 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
150 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
151 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
152 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
153 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
154 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
155 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
156 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
157 G_OKL_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) :='OKL_CONTRACTS_UNEXPECTED_ERROR';
158 G_OKL_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
159 G_OKL_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
160
161 ---------------------------------------------------------------------------
162 -- GLOBAL VARIABLES
163 ---------------------------------------------------------------------------
164 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SIL_PVT';
165 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
166 G_SIL_TYPE_LEASE CONSTANT VARCHAR2(10) := 'SGA';
167 G_SIL_TYPE_LOAN CONSTANT VARCHAR2(10) := 'SGN';
168
169 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
170 ---------------------------------------------------------------------------
171 -- Procedures and Functions
172 ---------------------------------------------------------------------------
173
174 PROCEDURE qc;
175 PROCEDURE change_version;
176 PROCEDURE api_copy;
177 PROCEDURE insert_row(
178 p_api_version IN NUMBER,
179 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
180 x_return_status OUT NOCOPY VARCHAR2,
181 x_msg_count OUT NOCOPY NUMBER,
182 x_msg_data OUT NOCOPY VARCHAR2,
183 p_silv_rec IN silv_rec_type,
184 x_silv_rec OUT NOCOPY silv_rec_type);
185
186 PROCEDURE insert_row(
187 p_api_version IN NUMBER,
188 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
189 x_return_status OUT NOCOPY VARCHAR2,
190 x_msg_count OUT NOCOPY NUMBER,
191 x_msg_data OUT NOCOPY VARCHAR2,
192 p_silv_tbl IN silv_tbl_type,
193 x_silv_tbl OUT NOCOPY silv_tbl_type);
194
195 PROCEDURE lock_row(
196 p_api_version IN NUMBER,
197 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
198 x_return_status OUT NOCOPY VARCHAR2,
199 x_msg_count OUT NOCOPY NUMBER,
200 x_msg_data OUT NOCOPY VARCHAR2,
201 p_silv_rec IN silv_rec_type);
202
203 PROCEDURE lock_row(
204 p_api_version IN NUMBER,
205 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
206 x_return_status OUT NOCOPY VARCHAR2,
207 x_msg_count OUT NOCOPY NUMBER,
208 x_msg_data OUT NOCOPY VARCHAR2,
209 p_silv_tbl IN silv_tbl_type);
210
211 PROCEDURE update_row(
212 p_api_version IN NUMBER,
213 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
214 x_return_status OUT NOCOPY VARCHAR2,
215 x_msg_count OUT NOCOPY NUMBER,
216 x_msg_data OUT NOCOPY VARCHAR2,
217 p_silv_rec IN silv_rec_type,
218 x_silv_rec OUT NOCOPY silv_rec_type);
219
220 PROCEDURE update_row(
221 p_api_version IN NUMBER,
222 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
223 x_return_status OUT NOCOPY VARCHAR2,
224 x_msg_count OUT NOCOPY NUMBER,
225 x_msg_data OUT NOCOPY VARCHAR2,
226 p_silv_tbl IN silv_tbl_type,
227 x_silv_tbl OUT NOCOPY silv_tbl_type);
228
229 PROCEDURE delete_row(
230 p_api_version IN NUMBER,
231 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
232 x_return_status OUT NOCOPY VARCHAR2,
233 x_msg_count OUT NOCOPY NUMBER,
234 x_msg_data OUT NOCOPY VARCHAR2,
235 p_silv_rec IN silv_rec_type);
236
237 PROCEDURE delete_row(
238 p_api_version IN NUMBER,
239 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
240 x_return_status OUT NOCOPY VARCHAR2,
241 x_msg_count OUT NOCOPY NUMBER,
242 x_msg_data OUT NOCOPY VARCHAR2,
243 p_silv_tbl IN silv_tbl_type);
244
245 PROCEDURE validate_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_silv_rec IN silv_rec_type);
252
253 PROCEDURE validate_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_silv_tbl IN silv_tbl_type);
260
261 END OKL_SIL_PVT;