1 PACKAGE LNS_LOAN_HEADER_ALL_PKG AS
2 /*$Header: LNS_LNHDR_TBLH_S.pls 120.6.12010000.3 2008/11/17 13:11:32 mbolli ship $ */
3
4 PROCEDURE Insert_Row (
5 X_LOAN_ID IN OUT NOCOPY NUMBER,
6 X_ORG_ID IN NUMBER,
7 X_LOAN_NUMBER IN OUT NOCOPY VARCHAR2,
8 X_LOAN_DESCRIPTION IN VARCHAR2,
9 X_OBJECT_VERSION_NUMBER IN NUMBER,
10 X_LOAN_APPLICATION_DATE IN DATE,
11 X_END_DATE IN DATE,
12 X_INITIAL_LOAN_BALANCE IN NUMBER,
13 X_LAST_PAYMENT_DATE IN DATE,
14 X_LAST_PAYMENT_AMOUNT IN NUMBER,
15 X_LOAN_TERM IN NUMBER,
16 X_LOAN_TERM_PERIOD IN VARCHAR2,
17 X_AMORTIZED_TERM IN NUMBER,
18 X_AMORTIZED_TERM_PERIOD IN VARCHAR2,
19 X_LOAN_STATUS IN VARCHAR2,
20 X_LOAN_ASSIGNED_TO IN NUMBER,
21 X_LOAN_CURRENCY IN VARCHAR2,
22 X_LOAN_CLASS_CODE IN VARCHAR2,
23 X_LOAN_TYPE IN VARCHAR2,
24 X_LOAN_SUBTYPE IN VARCHAR2,
25 X_LOAN_PURPOSE_CODE IN VARCHAR2,
26 X_CUST_ACCOUNT_ID IN NUMBER,
27 X_BILL_TO_ACCT_SITE_ID IN NUMBER,
28 X_LOAN_MATURITY_DATE IN DATE,
29 X_LOAN_START_DATE IN DATE,
30 X_LOAN_CLOSING_DATE IN DATE,
31 X_REFERENCE_ID IN NUMBER,
32 X_REFERENCE_NUMBER IN VARCHAR2,
33 X_REFERENCE_DESCRIPTION IN VARCHAR2,
34 X_REFERENCE_AMOUNT IN NUMBER,
35 X_PRODUCT_FLAG IN VARCHAR2,
36 X_PRIMARY_BORROWER_ID IN NUMBER,
37 X_PRODUCT_ID IN NUMBER,
38 X_REQUESTED_AMOUNT IN NUMBER,
39 X_FUNDED_AMOUNT IN NUMBER,
40 X_LOAN_APPROVAL_DATE IN DATE,
41 X_LOAN_APPROVED_BY IN NUMBER,
42 X_ATTRIBUTE_CATEGORY IN VARCHAR2,
43 X_ATTRIBUTE1 IN VARCHAR2,
44 X_ATTRIBUTE2 IN VARCHAR2,
45 X_ATTRIBUTE3 IN VARCHAR2,
46 X_ATTRIBUTE4 IN VARCHAR2,
47 X_ATTRIBUTE5 IN VARCHAR2,
48 X_ATTRIBUTE6 IN VARCHAR2,
49 X_ATTRIBUTE7 IN VARCHAR2,
50 X_ATTRIBUTE8 IN VARCHAR2,
51 X_ATTRIBUTE9 IN VARCHAR2,
52 X_ATTRIBUTE10 IN VARCHAR2,
53 X_ATTRIBUTE11 IN VARCHAR2,
54 X_ATTRIBUTE12 IN VARCHAR2,
55 X_ATTRIBUTE13 IN VARCHAR2,
56 X_ATTRIBUTE14 IN VARCHAR2,
57 X_ATTRIBUTE15 IN VARCHAR2,
58 X_ATTRIBUTE16 IN VARCHAR2,
59 X_ATTRIBUTE17 IN VARCHAR2,
60 X_ATTRIBUTE18 IN VARCHAR2,
61 X_ATTRIBUTE19 IN VARCHAR2,
62 X_ATTRIBUTE20 IN VARCHAR2,
63 X_LAST_BILLED_DATE IN DATE,
64 X_CUSTOM_PAYMENTS_FLAG IN VARCHAR2,
65 X_BILLED_FLAG IN VARCHAR2,
66 X_REFERENCE_NAME IN VARCHAR2,
67 X_REFERENCE_TYPE IN VARCHAR2,
68 X_REFERENCE_TYPE_ID IN NUMBER,
69 X_USSGL_TRANSACTION_CODE IN VARCHAR2,
70 X_GL_DATE IN DATE,
71 X_REC_ADJUSTMENT_NUMBER IN VARCHAR2,
72 X_CONTACT_REL_PARTY_ID IN NUMBER,
73 X_CONTACT_PERS_PARTY_ID IN NUMBER,
74 X_CREDIT_REVIEW_FLAG IN VARCHAR2,
75 X_EXCHANGE_RATE_TYPE IN VARCHAR2,
76 X_EXCHANGE_DATE IN DATE,
77 X_EXCHANGE_RATE IN NUMBER,
78 X_COLLATERAL_PERCENT IN NUMBER,
79 X_LAST_PAYMENT_NUMBER IN NUMBER,
80 X_LAST_AMORTIZATION_ID IN NUMBER,
81 X_LEGAL_ENTITY_ID IN NUMBER,
82 X_OPEN_TO_TERM_FLAG IN VARCHAR2,
83 X_MULTIPLE_FUNDING_FLAG IN VARCHAR2,
84 X_LOAN_TYPE_ID IN NUMBER,
85 X_SECONDARY_STATUS IN VARCHAR2,
86 X_OPEN_TO_TERM_EVENT IN VARCHAR2,
87 X_BALLOON_PAYMENT_TYPE IN VARCHAR2,
88 X_BALLOON_PAYMENT_AMOUNT IN NUMBER,
89 X_CURRENT_PHASE IN VARCHAR2,
90 X_OPEN_LOAN_START_DATE IN DATE,
91 X_OPEN_LOAN_TERM IN NUMBER,
92 X_OPEN_LOAN_TERM_PERIOD IN VARCHAR2,
93 X_OPEN_MATURITY_DATE IN DATE,
94 X_FUNDS_RESERVED_FLAG IN VARCHAR2,
95 X_FUNDS_CHECK_DATE IN DATE,
96 X_SUBSIDY_RATE IN NUMBER,
97 X_APPLICATION_ID IN NUMBER,
98 X_CREATED_BY_MODULE IN VARCHAR2,
99 X_PARTY_TYPE IN VARCHAR2,
100 X_FORGIVENESS_FLAG IN VARCHAR2,
101 X_FORGIVENESS_PERCENT IN NUMBER
102 );
103
104 PROCEDURE Update_Row (
105 X_Rowid IN OUT NOCOPY VARCHAR2,
106 X_LOAN_ID IN NUMBER,
107 X_ORG_ID IN NUMBER,
108 X_LOAN_NUMBER IN VARCHAR2,
109 X_LOAN_DESCRIPTION IN VARCHAR2,
110 X_OBJECT_VERSION_NUMBER IN NUMBER,
111 X_LOAN_APPLICATION_DATE IN DATE,
112 X_END_DATE IN DATE,
113 X_INITIAL_LOAN_BALANCE IN NUMBER,
114 X_LAST_PAYMENT_DATE IN DATE,
115 X_LAST_PAYMENT_AMOUNT IN NUMBER,
116 X_LOAN_TERM IN NUMBER,
117 X_LOAN_TERM_PERIOD IN VARCHAR2,
118 X_AMORTIZED_TERM IN NUMBER,
119 X_AMORTIZED_TERM_PERIOD IN VARCHAR2,
120 X_LOAN_STATUS IN VARCHAR2,
121 X_LOAN_ASSIGNED_TO IN NUMBER,
122 X_LOAN_CURRENCY IN VARCHAR2,
123 X_LOAN_CLASS_CODE IN VARCHAR2,
124 X_LOAN_TYPE IN VARCHAR2,
125 X_LOAN_SUBTYPE IN VARCHAR2,
126 X_LOAN_PURPOSE_CODE IN VARCHAR2,
127 X_CUST_ACCOUNT_ID IN NUMBER,
128 X_BILL_TO_ACCT_SITE_ID IN NUMBER,
129 X_LOAN_MATURITY_DATE IN DATE,
130 X_LOAN_START_DATE IN DATE,
131 X_LOAN_CLOSING_DATE IN DATE,
132 X_REFERENCE_ID IN NUMBER,
133 X_REFERENCE_NUMBER IN VARCHAR2,
134 X_REFERENCE_DESCRIPTION IN VARCHAR2,
135 X_REFERENCE_AMOUNT IN NUMBER,
136 X_PRODUCT_FLAG IN VARCHAR2,
137 X_PRIMARY_BORROWER_ID IN NUMBER,
138 X_PRODUCT_ID IN NUMBER,
139 X_REQUESTED_AMOUNT IN NUMBER,
140 X_FUNDED_AMOUNT IN NUMBER,
141 X_LOAN_APPROVAL_DATE IN DATE,
142 X_LOAN_APPROVED_BY IN NUMBER,
143 X_ATTRIBUTE_CATEGORY IN VARCHAR2,
144 X_ATTRIBUTE1 IN VARCHAR2,
145 X_ATTRIBUTE2 IN VARCHAR2,
146 X_ATTRIBUTE3 IN VARCHAR2,
147 X_ATTRIBUTE4 IN VARCHAR2,
148 X_ATTRIBUTE5 IN VARCHAR2,
149 X_ATTRIBUTE6 IN VARCHAR2,
150 X_ATTRIBUTE7 IN VARCHAR2,
151 X_ATTRIBUTE8 IN VARCHAR2,
152 X_ATTRIBUTE9 IN VARCHAR2,
153 X_ATTRIBUTE10 IN VARCHAR2,
154 X_ATTRIBUTE11 IN VARCHAR2,
155 X_ATTRIBUTE12 IN VARCHAR2,
156 X_ATTRIBUTE13 IN VARCHAR2,
157 X_ATTRIBUTE14 IN VARCHAR2,
158 X_ATTRIBUTE15 IN VARCHAR2,
159 X_ATTRIBUTE16 IN VARCHAR2,
160 X_ATTRIBUTE17 IN VARCHAR2,
161 X_ATTRIBUTE18 IN VARCHAR2,
162 X_ATTRIBUTE19 IN VARCHAR2,
163 X_ATTRIBUTE20 IN VARCHAR2,
164 X_LAST_BILLED_DATE IN DATE,
165 X_CUSTOM_PAYMENTS_FLAG IN VARCHAR2,
166 X_BILLED_FLAG IN VARCHAR2,
167 X_REFERENCE_NAME IN VARCHAR2,
168 X_REFERENCE_TYPE IN VARCHAR2,
169 X_REFERENCE_TYPE_ID IN NUMBER,
170 X_USSGL_TRANSACTION_CODE IN VARCHAR2,
171 X_GL_DATE IN DATE,
172 X_REC_ADJUSTMENT_NUMBER IN VARCHAR2,
173 X_CONTACT_REL_PARTY_ID IN NUMBER,
174 X_CONTACT_PERS_PARTY_ID IN NUMBER,
175 X_CREDIT_REVIEW_FLAG IN VARCHAR2,
176 X_EXCHANGE_RATE_TYPE IN VARCHAR2,
177 X_EXCHANGE_DATE IN DATE,
178 X_EXCHANGE_RATE IN NUMBER,
179 X_COLLATERAL_PERCENT IN NUMBER,
180 X_LAST_PAYMENT_NUMBER IN NUMBER,
181 X_LAST_AMORTIZATION_ID IN NUMBER,
182 X_LEGAL_ENTITY_ID IN NUMBER,
183 X_OPEN_TO_TERM_FLAG IN VARCHAR2,
184 X_MULTIPLE_FUNDING_FLAG IN VARCHAR2,
185 X_LOAN_TYPE_ID IN NUMBER,
186 X_SECONDARY_STATUS IN VARCHAR2,
187 X_OPEN_TO_TERM_EVENT IN VARCHAR2,
188 X_BALLOON_PAYMENT_TYPE IN VARCHAR2,
189 X_BALLOON_PAYMENT_AMOUNT IN NUMBER,
190 X_CURRENT_PHASE IN VARCHAR2,
191 X_OPEN_LOAN_START_DATE IN DATE,
192 X_OPEN_LOAN_TERM IN NUMBER,
193 X_OPEN_LOAN_TERM_PERIOD IN VARCHAR2,
194 X_OPEN_MATURITY_DATE IN DATE,
195 X_FUNDS_RESERVED_FLAG IN VARCHAR2,
196 X_FUNDS_CHECK_DATE IN DATE,
197 X_SUBSIDY_RATE IN NUMBER,
198 X_APPLICATION_ID IN NUMBER,
199 X_CREATED_BY_MODULE IN VARCHAR2,
200 X_PARTY_TYPE IN VARCHAR2,
201 X_FORGIVENESS_FLAG IN VARCHAR2,
202 X_FORGIVENESS_PERCENT IN NUMBER
203 );
204
205 PROCEDURE Lock_Row (
206 x_rowid VARCHAR2
207 ,p_LOAN_ID NUMBER
208 ,p_LAST_UPDATE_DATE DATE
209 ,p_LAST_UPDATED_BY NUMBER
210 ,p_LAST_UPDATE_LOGIN NUMBER
211 ,p_CREATION_DATE DATE
212 ,p_CREATED_BY NUMBER
213 ,p_PROGRAM_ID NUMBER
214 ,p_OBJECT_VERSION_NUMBER NUMBER
215 ,p_REQUEST_ID NUMBER
216 ,p_ORG_ID NUMBER
217 ,p_LOAN_NUMBER VARCHAR2
218 ,p_LOAN_DESCRIPTION VARCHAR2
219 ,p_LOAN_APPLICATION_DATE DATE
220 ,p_END_DATE DATE
221 ,p_INITIAL_LOAN_BALANCE NUMBER
222 ,p_LAST_PAYMENT_DATE DATE
223 ,p_LAST_PAYMENT_AMOUNT NUMBER
224 ,p_LOAN_TERM NUMBER
225 ,p_LOAN_TERM_PERIOD VARCHAR2
226 ,p_AMORTIZED_TERM NUMBER
227 ,p_AMORTIZED_TERM_PERIOD VARCHAR2
228 ,p_LOAN_STATUS VARCHAR2
229 ,p_LOAN_ASSIGNED_TO NUMBER
230 ,p_LOAN_CURRENCY VARCHAR2
231 ,p_LOAN_CLASS_CODE VARCHAR2
232 ,p_LOAN_TYPE VARCHAR2
233 ,p_LOAN_SUBTYPE VARCHAR2
234 ,p_LOAN_PURPOSE_CODE VARCHAR2
235 ,p_CUST_ACCOUNT_ID NUMBER
236 ,p_BILL_TO_ACCT_SITE_ID NUMBER
237 ,p_LOAN_MATURITY_DATE DATE
238 ,p_LOAN_START_DATE DATE
239 ,p_LOAN_CLOSING_DATE DATE
240 ,p_REFERENCE_ID NUMBER
241 ,p_REFERENCE_NUMBER VARCHAR2
242 ,p_REFERENCE_DESCRIPTION VARCHAR2
243 ,p_REFERENCE_AMOUNT NUMBER
244 ,p_PRODUCT_FLAG VARCHAR2
245 ,p_PRIMARY_BORROWER_ID NUMBER
246 ,p_PRODUCT_ID NUMBER
247 ,p_REQUESTED_AMOUNT NUMBER
248 ,p_FUNDED_AMOUNT NUMBER
249 ,p_LOAN_APPROVAL_DATE DATE
250 ,p_LOAN_APPROVED_BY NUMBER
251 ,p_ATTRIBUTE_CATEGORY VARCHAR2
252 ,p_ATTRIBUTE1 VARCHAR2
253 ,p_ATTRIBUTE2 VARCHAR2
254 ,p_ATTRIBUTE3 VARCHAR2
255 ,p_ATTRIBUTE4 VARCHAR2
256 ,p_ATTRIBUTE5 VARCHAR2
257 ,p_ATTRIBUTE6 VARCHAR2
258 ,p_ATTRIBUTE7 VARCHAR2
259 ,p_ATTRIBUTE8 VARCHAR2
260 ,p_ATTRIBUTE9 VARCHAR2
261 ,p_ATTRIBUTE10 VARCHAR2
262 ,p_ATTRIBUTE11 VARCHAR2
263 ,p_ATTRIBUTE12 VARCHAR2
264 ,p_ATTRIBUTE13 VARCHAR2
265 ,p_ATTRIBUTE14 VARCHAR2
266 ,p_ATTRIBUTE15 VARCHAR2
267 ,p_ATTRIBUTE16 VARCHAR2
268 ,p_ATTRIBUTE17 VARCHAR2
269 ,p_ATTRIBUTE18 VARCHAR2
270 ,p_ATTRIBUTE19 VARCHAR2
271 ,p_ATTRIBUTE20 VARCHAR2
272 ,p_LAST_BILLED_DATE DATE
273 ,p_CUSTOM_PAYMENTS_FLAG VARCHAR2
274 ,p_BILLED_FLAG VARCHAR2
275 ,p_REFERENCE_NAME VARCHAR2
276 ,p_REFERENCE_TYPE VARCHAR2
277 ,p_REFERENCE_TYPE_ID NUMBER
278 ,p_USSGL_TRANSACTION_CODE VARCHAR2
279 ,p_GL_DATE DATE
280 ,p_REC_ADJUSTMENT_NUMBER VARCHAR2
281 ,p_CONTACT_REL_PARTY_ID NUMBER
282 ,p_CONTACT_PERS_PARTY_ID NUMBER
283 ,p_CREDIT_REVIEW_FLAG VARCHAR2
284 ,p_EXCHANGE_RATE_TYPE VARCHAR2
285 ,p_EXCHANGE_DATE DATE
286 ,p_EXCHANGE_RATE NUMBER
287 ,p_COLLATERAL_PERCENT NUMBER
288 ,p_LAST_PAYMENT_NUMBER NUMBER
289 ,p_LAST_AMORTIZATION_ID NUMBER
290 ,p_LEGAL_ENTITY_ID NUMBER
291 ,p_OPEN_TO_TERM_FLAG VARCHAR2
292 ,p_MULTIPLE_FUNDING_FLAG VARCHAR2
293 ,p_LOAN_TYPE_ID NUMBER
294 ,p_SECONDARY_STATUS VARCHAR2
295 ,p_OPEN_TO_TERM_EVENT VARCHAR2
296 ,p_BALLOON_PAYMENT_TYPE VARCHAR2
297 ,p_BALLOON_PAYMENT_AMOUNT NUMBER
298 ,p_CURRENT_PHASE VARCHAR2
299 ,p_OPEN_LOAN_START_DATE DATE
300 ,p_OPEN_LOAN_TERM NUMBER
301 ,p_OPEN_LOAN_TERM_PERIOD VARCHAR2
302 ,p_OPEN_MATURITY_DATE DATE
303 ,p_FUNDS_RESERVED_FLAG VARCHAR2
304 ,p_FUNDS_CHECK_DATE DATE
305 ,p_SUBSIDY_RATE NUMBER
306 ,p_APPLICATION_ID NUMBER
307 ,p_CREATED_BY_MODULE VARCHAR2
308 ,p_PARTY_TYPE VARCHAR2
309 ,p_FORGIVENESS_FLAG VARCHAR2
310 ,p_FORGIVENESS_PERCENT NUMBER
311 );
312
313 PROCEDURE Select_Row (
314 X_LOAN_ID IN OUT NOCOPY NUMBER,
315 X_ORG_ID OUT NOCOPY NUMBER,
316 X_LOAN_NUMBER OUT NOCOPY VARCHAR2,
317 X_LOAN_DESCRIPTION OUT NOCOPY VARCHAR2,
318 X_LOAN_APPLICATION_DATE OUT NOCOPY DATE,
319 X_END_DATE OUT NOCOPY DATE,
320 X_INITIAL_LOAN_BALANCE OUT NOCOPY NUMBER,
321 X_LAST_PAYMENT_DATE OUT NOCOPY DATE,
322 X_LAST_PAYMENT_AMOUNT OUT NOCOPY NUMBER,
323 X_LOAN_TERM OUT NOCOPY NUMBER,
324 X_LOAN_TERM_PERIOD OUT NOCOPY VARCHAR2,
325 X_AMORTIZED_TERM OUT NOCOPY NUMBER,
326 X_AMORTIZED_TERM_PERIOD OUT NOCOPY VARCHAR2,
327 X_LOAN_STATUS OUT NOCOPY VARCHAR2,
328 X_LOAN_ASSIGNED_TO OUT NOCOPY NUMBER,
329 X_LOAN_CURRENCY OUT NOCOPY VARCHAR2,
330 X_LOAN_CLASS_CODE OUT NOCOPY VARCHAR2,
331 X_LOAN_TYPE OUT NOCOPY VARCHAR2,
332 X_LOAN_SUBTYPE OUT NOCOPY VARCHAR2,
333 X_LOAN_PURPOSE_CODE OUT NOCOPY VARCHAR2,
334 X_CUST_ACCOUNT_ID OUT NOCOPY NUMBER,
335 X_BILL_TO_ACCT_SITE_ID OUT NOCOPY NUMBER,
336 X_LOAN_MATURITY_DATE OUT NOCOPY DATE,
337 X_LOAN_START_DATE OUT NOCOPY DATE,
338 X_LOAN_CLOSING_DATE OUT NOCOPY DATE,
339 X_REFERENCE_ID OUT NOCOPY NUMBER,
340 X_REFERENCE_NUMBER OUT NOCOPY VARCHAR2,
341 X_REFERENCE_DESCRIPTION OUT NOCOPY VARCHAR2,
342 X_REFERENCE_AMOUNT OUT NOCOPY NUMBER,
343 X_PRODUCT_FLAG OUT NOCOPY VARCHAR2,
344 X_PRIMARY_BORROWER_ID OUT NOCOPY NUMBER,
345 X_PRODUCT_ID OUT NOCOPY NUMBER,
346 X_REQUESTED_AMOUNT OUT NOCOPY NUMBER,
347 X_FUNDED_AMOUNT OUT NOCOPY NUMBER,
348 X_LOAN_APPROVAL_DATE OUT NOCOPY DATE,
349 X_LOAN_APPROVED_BY OUT NOCOPY NUMBER,
350 X_ATTRIBUTE_CATEGORY OUT NOCOPY VARCHAR2,
351 X_ATTRIBUTE1 OUT NOCOPY VARCHAR2,
352 X_ATTRIBUTE2 OUT NOCOPY VARCHAR2,
353 X_ATTRIBUTE3 OUT NOCOPY VARCHAR2,
354 X_ATTRIBUTE4 OUT NOCOPY VARCHAR2,
355 X_ATTRIBUTE5 OUT NOCOPY VARCHAR2,
356 X_ATTRIBUTE6 OUT NOCOPY VARCHAR2,
357 X_ATTRIBUTE7 OUT NOCOPY VARCHAR2,
358 X_ATTRIBUTE8 OUT NOCOPY VARCHAR2,
359 X_ATTRIBUTE9 OUT NOCOPY VARCHAR2,
360 X_ATTRIBUTE10 OUT NOCOPY VARCHAR2,
361 X_ATTRIBUTE11 OUT NOCOPY VARCHAR2,
362 X_ATTRIBUTE12 OUT NOCOPY VARCHAR2,
363 X_ATTRIBUTE13 OUT NOCOPY VARCHAR2,
364 X_ATTRIBUTE14 OUT NOCOPY VARCHAR2,
365 X_ATTRIBUTE15 OUT NOCOPY VARCHAR2,
366 X_ATTRIBUTE16 OUT NOCOPY VARCHAR2,
367 X_ATTRIBUTE17 OUT NOCOPY VARCHAR2,
368 X_ATTRIBUTE18 OUT NOCOPY VARCHAR2,
369 X_ATTRIBUTE19 OUT NOCOPY VARCHAR2,
370 X_ATTRIBUTE20 OUT NOCOPY VARCHAR2,
371 X_LAST_BILLED_DATE OUT NOCOPY DATE,
372 X_CUSTOM_PAYMENTS_FLAG OUT NOCOPY VARCHAR2,
373 X_BILLED_FLAG OUT NOCOPY VARCHAR2,
374 X_REFERENCE_NAME OUT NOCOPY VARCHAR2,
375 X_REFERENCE_TYPE OUT NOCOPY VARCHAR2,
376 X_REFERENCE_TYPE_ID OUT NOCOPY NUMBER,
377 X_USSGL_TRANSACTION_CODE OUT NOCOPY VARCHAR2,
378 X_GL_DATE OUT NOCOPY DATE,
379 X_REC_ADJUSTMENT_NUMBER OUT NOCOPY VARCHAR2,
380 X_CONTACT_REL_PARTY_ID OUT NOCOPY NUMBER,
381 X_CONTACT_PERS_PARTY_ID OUT NOCOPY NUMBER,
382 X_CREDIT_REVIEW_FLAG OUT NOCOPY VARCHAR2,
383 X_EXCHANGE_RATE_TYPE OUT NOCOPY VARCHAR2,
384 X_EXCHANGE_DATE OUT NOCOPY DATE,
385 X_EXCHANGE_RATE OUT NOCOPY NUMBER,
386 X_COLLATERAL_PERCENT OUT NOCOPY NUMBER,
387 X_LAST_PAYMENT_NUMBER OUT NOCOPY NUMBER,
388 X_LAST_AMORTIZATION_ID OUT NOCOPY NUMBER,
389 X_LEGAL_ENTITY_ID OUT NOCOPY NUMBER,
390 X_OPEN_TO_TERM_FLAG OUT NOCOPY VARCHAR2,
391 X_MULTIPLE_FUNDING_FLAG OUT NOCOPY VARCHAR2,
392 X_LOAN_TYPE_ID OUT NOCOPY NUMBER,
393 X_SECONDARY_STATUS OUT NOCOPY VARCHAR2,
394 X_OPEN_TO_TERM_EVENT OUT NOCOPY VARCHAR2,
395 X_BALLOON_PAYMENT_TYPE OUT NOCOPY VARCHAR2,
396 X_BALLOON_PAYMENT_AMOUNT OUT NOCOPY NUMBER,
397 X_CURRENT_PHASE OUT NOCOPY VARCHAR2,
398 X_OPEN_LOAN_START_DATE OUT NOCOPY DATE,
399 X_OPEN_LOAN_TERM OUT NOCOPY NUMBER,
400 X_OPEN_LOAN_TERM_PERIOD OUT NOCOPY VARCHAR2,
401 X_OPEN_MATURITY_DATE OUT NOCOPY DATE,
402 X_FUNDS_RESERVED_FLAG OUT NOCOPY VARCHAR2,
403 X_FUNDS_CHECK_DATE OUT NOCOPY DATE,
404 X_SUBSIDY_RATE OUT NOCOPY NUMBER,
405 X_APPLICATION_ID OUT NOCOPY NUMBER,
406 X_CREATED_BY_MODULE OUT NOCOPY VARCHAR2,
407 X_PARTY_TYPE OUT NOCOPY VARCHAR2,
408 X_FORGIVENESS_FLAG OUT NOCOPY VARCHAR2,
409 X_FORGIVENESS_PERCENT OUT NOCOPY NUMBER
410 );
411
412 PROCEDURE Delete_Row (
413 X_LOAN_ID IN NUMBER
414 );
415
416 procedure ADD_LANGUAGE;
417
418 END LNS_LOAN_HEADER_ALL_PKG;