1 PACKAGE LNS_DISTRIBUTIONS_PUB AUTHID CURRENT_USER AS
2 /* $Header: LNS_DIST_PUBP_S.pls 120.18.12020000.2 2012/07/19 20:55:51 scherkas ship $ */
3 /*=======================================================================+
4 | Declare PUBLIC Data Types and Variables
5 +=======================================================================*/
6
7 -- this type is for writing to distributions table from default
8 type distribution_rec is record(DISTRIBUTION_ID NUMBER(15)
9 ,LOAN_ID NUMBER(15)
10 ,LINE_TYPE VARCHAR2(30)
11 ,ACCOUNT_NAME VARCHAR2(30)
12 ,CODE_COMBINATION_ID NUMBER
13 ,ACCOUNT_TYPE VARCHAR2(30)
14 ,DISTRIBUTION_PERCENT NUMBER
15 ,DISTRIBUTION_AMOUNT NUMBER
16 ,CALCULATE_FLAG VARCHAR2(1)
17 ,DISTRIBUTION_TYPE VARCHAR2(30)
18 ,EVENT_ID NUMBER
19 ,DISB_HEADER_ID NUMBER
20 ,LOAN_AMOUNT_ADJ_ID NUMBER
21 ,LOAN_LINE_ID NUMBER
22 ,ACTIVITY VARCHAR2(30)
23 ,ACCRUAL_DATE DATE
24 ,ACCRUAL_COMPLETED_FLAG VARCHAR2(1)
25 ,ACCRUAL_PERIOD VARCHAR2(15)
26 ,PROJECT_ID Number
27 ,TASK_ID NUMBER
28 ,AWARD_ID NUMBER
29 ,EXPENDITURE_TYPE VARCHAR2(30)
30 ,EXPENDITURE_ITEM_DATE DATE);
31
32 type distribution_tbl is table of distribution_rec index by binary_integer;
33
34 type default_distribution_rec is record(LOAN_CLASS VARCHAR2(30)
35 ,LOAN_TYPE VARCHAR2(30)
36 ,LINE_TYPE VARCHAR2(30)
37 ,ACCOUNT_NAME VARCHAR2(30)
38 ,CODE_COMBINATION_ID NUMBER
39 ,ACCOUNT_TYPE VARCHAR2(30)
40 ,DISTRIBUTION_PERCENT NUMBER
41 ,DISTRIBUTION_TYPE VARCHAR2(30)
42 ,FEE_ID NUMBER
43 ,ORG_ID NUMBER
44 ,MFAR_BALANCING_SEGMENT VARCHAR2(60)
45 ,MFAR_NATURAL_ACCOUNT_REC VARCHAR2(60)
46 ,MFAR_NATURAL_ACCOUNT_CLR VARCHAR2(60)
47 ,PROJECT_ID Number
48 ,TASK_ID NUMBER
49 ,AWARD_ID NUMBER
50 ,EXPENDITURE_TYPE VARCHAR2(30)
51 ,EXPENDITURE_ITEM_DATE DATE);
52
53 type default_distributions_tbl is table of default_distribution_rec index by binary_integer;
54
55 -- for accounting events
56 type acc_event_rec is record(LOAN_ID NUMBER(15)
57 ,EVENT_TYPE_CODE VARCHAR2(30)
58 ,EVENT_DATE DATE
59 ,EVENT_STATUS VARCHAR2(1)
60 ,DISB_HEADER_ID number
61 ,BUDGETARY_CONTROL_FLAG varchar2(1)
62 ,LOAN_AMOUNT_ADJ_ID NUMBER
63 ,LOAN_LINE_ID NUMBER);
64
65 type acc_event_tbl is table of acc_event_rec index by binary_integer;
66
67 type g_number_tbl is table of number index by binary_integer;
68
69 FUNCTION GENERATE_BC_REPORT(p_loan_id number
70 ,p_source varchar2 default NULL
71 ,p_loan_amount_adj_id number default NULL
72 ) RETURN NUMBER;
73
74 procedure cancel_disbursements(p_init_msg_list in varchar2
75 ,p_commit in varchar2
76 ,p_loan_id in number
77 ,x_return_status OUT NOCOPY VARCHAR2
78 ,x_msg_count OUT NOCOPY NUMBER
79 ,x_msg_data OUT NOCOPY VARCHAR2);
80
81 procedure budgetary_control(p_init_msg_list in varchar2
82 ,p_commit in varchar2
83 ,p_loan_id in number
84 ,p_budgetary_control_mode in varchar2
85 ,x_budgetary_status_code out nocopy varchar2
86 ,x_return_status OUT NOCOPY VARCHAR2
87 ,x_msg_count OUT NOCOPY NUMBER
88 ,x_msg_data OUT NOCOPY VARCHAR2);
89
90 -- this type is to getLedgerDetails
91 type gl_ledger_details is record(SET_OF_BOOKS_ID NUMBER(15) -- aka LEDGER_ID
92 ,NAME VARCHAR2(30)
93 ,SHORT_NAME VARCHAR2(20)
94 ,CHART_OF_ACCOUNTS_ID NUMBER(15)
95 ,PERIOD_SET_NAME VARCHAR2(15)
96 ,CURRENCY_CODE VARCHAR2(15)
97 ,CURRENCY_PRECISION NUMBER(1));
98
99 procedure create_event(p_acc_event_tbl in LNS_DISTRIBUTIONS_PUB.acc_event_tbl
100 ,p_init_msg_list in varchar2
101 ,p_commit in varchar2
102 ,x_return_status out nocopy varchar2
103 ,x_msg_count out nocopy number
104 ,x_msg_data out nocopy varchar2);
105
106 procedure create_DisbursementDistribs(p_api_version IN NUMBER
107 ,p_init_msg_list IN VARCHAR2
108 ,p_commit IN VARCHAR2
109 ,p_loan_id IN NUMBER
110 ,p_disb_header_id IN NUMBER
111 ,p_loan_amount_adj_id IN NUMBER DEFAULT NULL
112 ,p_activity_type IN VARCHAR2 DEFAULT NULL
113 ,p_project_id IN NUMBER DEFAULT NULL
114 ,p_award_id IN NUMBER DEFAULT NULL
115 ,p_task_id IN NUMBER DEFAULT NULL
116 ,p_expenditure_type IN VARCHAR2 DEFAULT NULL
117 ,p_expenditure_ITEM_date IN DATE DEFAULT NULL
118 ,x_return_status OUT NOCOPY VARCHAR2
119 ,x_msg_count OUT NOCOPY NUMBER
120 ,x_msg_data OUT NOCOPY VARCHAR2);
121
122 function getDistributions(p_loan_id in number
123 ,p_account_type in varchar2
124 ,p_account_name in varchar2
125 ,p_line_type in varchar2
126 ,p_distribution_type in varchar2) return LNS_DISTRIBUTIONS_PUB.distribution_tbl;
127
128 function getDistributions(p_distribution_id in number) return LNS_DISTRIBUTIONS_PUB.distribution_rec;
129
130 function getDistributions(p_loan_id in number
131 ,p_loan_line_id in number
132 ,p_account_type in varchar2
133 ,p_account_name in varchar2
134 ,p_line_type in varchar2
135 ,p_distribution_type in varchar2) return LNS_DISTRIBUTIONS_PUB.distribution_tbl;
136
137 function getDefaultDistributions(p_loan_class in varchar2
138 ,p_loan_type_id in number
139 ,p_account_type in varchar2
140 ,p_account_name in varchar2
141 ,p_line_type in varchar2
142 ,p_distribution_type in varchar2) return LNS_DISTRIBUTIONS_PUB.default_distributions_tbl;
143
144 procedure defaultDistributionsCatch(p_api_version IN NUMBER
145 ,p_init_msg_list IN VARCHAR2
146 ,p_commit IN VARCHAR2
147 ,p_loan_id IN NUMBER
148 ,p_disb_header_id IN NUMBER
149 ,p_loan_amount_adj_id IN NUMBER DEFAULT NULL
150 ,p_include_loan_receivables IN VARCHAR2
151 ,p_distribution_type IN VARCHAR2
152 ,x_distribution_tbl OUT NOCOPY lns_distributions_pub.distribution_tbl
153 ,x_return_status OUT NOCOPY VARCHAR2
154 ,x_msg_count OUT NOCOPY NUMBER
155 ,x_msg_data OUT NOCOPY VARCHAR2);
156
157 function getLedgerDetails return lns_distributions_pub.gl_ledger_details;
158
159 function calculateDistributionAmount (p_distribution_id in number) return number;
160
161 function calculateDistributionAmount(p_distribution_id in number
162 ,p_accounted_flag in varchar2) return number;
163
164 function calculateDistAmount(p_distribution_id in number
165 ,p_accounted_flag in varchar2) return varchar2;
166
167 function getValueSetID(p_segment_attribute_type in varchar) return number;
168
169 function getFlexSegmentNumber(p_flex_code in varchar2
170 ,p_application_id in number
171 ,p_segment_attribute_type in varchar2) return number;
172
173 procedure validateAccounting(p_loan_id in number
174 ,p_init_msg_list IN VARCHAR2
175 ,x_return_status OUT NOCOPY VARCHAR2
176 ,x_msg_count OUT NOCOPY NUMBER
177 ,x_msg_data OUT NOCOPY VARCHAR2);
178
179 procedure validateDefaultAccounting(p_loan_class in varchar2
180 ,p_loan_type_id in number
181 ,p_init_msg_list IN VARCHAR2
182 ,x_return_status OUT NOCOPY VARCHAR2
183 ,x_msg_count OUT NOCOPY NUMBER
184 ,x_msg_data OUT NOCOPY VARCHAR2);
185
186 procedure validateLoanLines(p_init_msg_list IN VARCHAR2
187 ,p_loan_id IN number
188 ,x_MFAR OUT NOCOPY boolean
189 ,x_return_status OUT NOCOPY VARCHAR2
190 ,x_msg_count OUT NOCOPY NUMBER
191 ,x_msg_data OUT NOCOPY VARCHAR2);
192
193 procedure defaultDistributions(p_api_version IN NUMBER
194 ,p_init_msg_list IN VARCHAR2
195 ,p_commit IN VARCHAR2
196 ,p_loan_id IN NUMBER
197 ,p_loan_class_code IN varchar2
198 ,x_return_status OUT NOCOPY VARCHAR2
199 ,x_msg_count OUT NOCOPY NUMBER
200 ,x_msg_data OUT NOCOPY VARCHAR2);
201
202
203 function transformDistribution(p_distribution_id number
204 ,p_distribution_type varchar2
205 ,p_loan_id number) return number;
206
207 procedure onlineAccounting(p_loan_id IN NUMBER
208 ,p_init_msg_list IN VARCHAR2
209 ,p_accounting_mode IN VARCHAR2
210 ,p_transfer_flag IN VARCHAR2
211 ,p_offline_flag IN VARCHAR2
212 ,p_gl_posting_flag IN VARCHAR2
213 ,x_return_status OUT NOCOPY VARCHAR2
214 ,x_msg_count OUT NOCOPY NUMBER
215 ,x_msg_data OUT NOCOPY VARCHAR2);
216
217 PROCEDURE LNS_ACCOUNTING_CONCUR(ERRBUF OUT NOCOPY VARCHAR2
218 ,RETCODE OUT NOCOPY VARCHAR2
219 ,P_LOAN_ID IN NUMBER);
220
221 procedure createDistrForImport(p_api_version IN NUMBER
222 ,p_init_msg_list IN VARCHAR2
223 ,p_commit IN VARCHAR2
224 ,p_loan_id IN NUMBER
225 ,x_distribution_tbl IN OUT NOCOPY lns_distributions_pub.distribution_tbl
226 ,x_return_status OUT NOCOPY VARCHAR2
227 ,x_msg_count OUT NOCOPY NUMBER
228 ,x_msg_data OUT NOCOPY VARCHAR2);
229
230 /*=========================================================================
231 || PROCEDURE LOAN_ADJUSTMENT_BUDGET_CONTROL
232 ||
233 || DESCRIPTION
234 || this function does funds check / funds reserve for loanAdjustment
235 ||
236 ||
237 || PARAMETERS p_loan_id => loan identifier
238 || p_budgetary_control_mode => 'C' Check ; 'R' Reserve
239 ||
240 || Return value: x_budgetary_status_code
241 || SUCCESS = FUNDS CHECK / RESERVE SUCCESSFUL
242 || PARTIAL = AT LEAST ONE EVENT FAILED
243 || FAIL = FUNDS CHECK / RESERVE FAILED
244 || XLA_ERROR = XLA SetUp ERROR
245 || ADVISORY = BUDGETARY WARNING
246 ||
247 || Source Tables: NA
248 ||
249 || Target Tables: NA
250 ||
251 || MODIFICATION HISTORY
252 || Date Author Description of Changes
253 || 15-Mar-2010 mbolli Created
254 *=======================================================================*/
255 procedure LOAN_ADJUSTMENT_BUDGET_CONTROL(p_init_msg_list in varchar2
256 ,p_commit in varchar2
257 ,p_loan_amount_adj_id in number DEFAULT NULL
258 ,p_loan_id in number
259 ,p_budgetary_control_mode in varchar2
260 ,x_budgetary_status_code out nocopy varchar2
261 ,x_return_status OUT NOCOPY VARCHAR2
262 ,x_msg_count OUT NOCOPY NUMBER
263 ,x_msg_data OUT NOCOPY VARCHAR2);
264
268 || DESCRIPTION
265 /*=========================================================================
266 || PROCEDURE DEFAULT_ADJUSTMENT_DISTRIBS
267 ||
269 || This procedure does funds check / funds reserve for negative loanAdjustment
270 ||
271 ||
272 || PARAMETERS p_loan_amount_adj_id => loan adjustment identifier
273 || p_loan_id => loan_id is considered to retrieve
274 || pending adjustment if loan_amount_adj_id is NULL
275 ||
276 || Return value: None
277 ||
278 || Source Tables: NA
279 ||
280 || Target Tables: NA
281 ||
282 || MODIFICATION HISTORY
283 || Date Author Description of Changes
284 || 26-Mar-2010 mbolli Created
285 *=======================================================================*/
286 PROCEDURE DEFAULT_ADJUSTMENT_DISTRIBS(p_init_msg_list in varchar2
287 ,p_commit in varchar2
288 ,p_loan_amount_adj_id in number DEFAULT NULL
289 ,p_loan_id in number
290 ,x_return_status OUT NOCOPY VARCHAR2
291 ,x_msg_count OUT NOCOPY NUMBER
292 ,x_msg_data OUT NOCOPY VARCHAR2);
293
294 /*=========================================================================
295 | PUBLIC procedure validateAddRecAccounting
296 |
297 | DESCRIPTION
298 | validates accounting records for a given additional receivable
299 |
300 | PSEUDO CODE/LOGIC
301 |
302 | PARAMETERS
303 | p_loan_id => id of loan
304 | p_loan_line_id => loan line id
305 |
306 | Return value: standard api values
307 |
308 | Source Tables: lns_Distritbutions
309 |
310 | Target Tables: NA
311 |
312 | KNOWN ISSUES
313 |
314 | NOTES
315 |
316 |
317 | MODIFICATION HISTORY
318 | Date Author Description of Changes
319 | 04-01-2010 scherkas Created
320 |
321 *=======================================================================*/
322 procedure validateAddRecAccounting(p_loan_id in number
323 ,p_loan_line_id IN NUMBER
324 ,p_init_msg_list IN VARCHAR2
325 ,x_return_status OUT NOCOPY VARCHAR2
326 ,x_msg_count OUT NOCOPY NUMBER
327 ,x_msg_data OUT NOCOPY VARCHAR2);
328
329
330 /*=========================================================================
331 | PUBLIC procedure createDistrForAddRec
332 |
333 | DESCRIPTION
334 | This procedure creates accounting records for an additional receivable
335 |
336 | PSEUDO CODE/LOGIC
337 |
338 | PARAMETERS
339 | p_loan_id => id of loan
340 | p_loan_line_id => loan line id
341 |
342 | Return value: standard api values
343 |
344 | Source Tables: lns_Distritbutions
345 |
346 | Target Tables: NA
347 |
348 | KNOWN ISSUES
349 |
350 | NOTES
351 |
352 |
353 | MODIFICATION HISTORY
354 | Date Author Description of Changes
355 | 04-01-2010 scherkas Created
356 |
357 *=======================================================================*/
358 procedure createDistrForAddRec(p_api_version IN NUMBER
359 ,p_init_msg_list IN VARCHAR2
360 ,p_commit IN VARCHAR2
361 ,p_loan_id IN NUMBER
362 ,p_loan_line_id IN NUMBER
363 ,x_return_status OUT NOCOPY VARCHAR2
364 ,x_msg_count OUT NOCOPY NUMBER
365 ,x_msg_data OUT NOCOPY VARCHAR2);
366
367 /*=========================================================================
368 || PUBLIC PROCEDURE generateCancelDistributions
369 ||
370 || DESCRIPTION
371 || This procedure generates distributions for cancellation of the loan
372 ||
373 || PSEUDO CODE/LOGIC
374 ||
375 || PARAMETERS
376 || Parameter: p_loan_id => loan to default
377 ||
378 || Return value: Standard S = Success E = Error U = Unexpected
379 ||
380 || Source Tables: LNS_DISTRIBUTIONS, lns_loan_headers_all
381 ||
382 || Target Tables: LNS_DISTRIBUTIONS
383 ||
384 || KNOWN ISSUES
385 ||
386 || NOTES
387 ||
388 || MODIFICATION HISTORY
389 || Date Author Description of Changes
390 || 01-Jun-2010 Mbolli Created - Bug#9764500
391 *=======================================================================*/
392 PROCEDURE generateCancelDistributions(p_api_version IN NUMBER
393 ,p_init_msg_list IN VARCHAR2
394 ,p_commit IN VARCHAR2
395 ,p_loan_id IN NUMBER
396 ,x_return_status OUT NOCOPY VARCHAR2
397 ,x_msg_count OUT NOCOPY NUMBER
398 ,x_msg_data OUT NOCOPY VARCHAR2);
399
400
401 procedure submit_disbursement_bc(p_init_msg_list in varchar2
402 ,p_commit in varchar2
403 ,p_loan_id IN NUMBER
404 ,p_disb_header_id in number
405 ,p_activity IN VARCHAR2
409
406 ,x_return_status OUT NOCOPY VARCHAR2
407 ,x_msg_count OUT NOCOPY NUMBER
408 ,x_msg_data OUT NOCOPY VARCHAR2);
410
411 PROCEDURE create_AccrualDistribs(p_api_version IN NUMBER
412 ,p_init_msg_list IN VARCHAR2
413 ,p_commit IN VARCHAR2
414 ,p_loan_id IN NUMBER
415 ,p_period_name IN VARCHAR2
416 ,p_accrual_date IN DATE
417 ,p_accrued_amount IN NUMBER
418 ,p_activity_type IN VARCHAR2
419 ,p_accounting_mode IN VARCHAR2
420 ,x_return_status OUT NOCOPY VARCHAR2
421 ,x_msg_count OUT NOCOPY NUMBER
422 ,x_msg_data OUT NOCOPY VARCHAR2);
423
424
425 PROCEDURE do_int_accrual_reversal(p_api_version IN NUMBER
426 ,p_init_msg_list IN VARCHAR2
427 ,p_commit IN VARCHAR2
428 ,p_loan_id IN NUMBER
429 ,p_period_name IN VARCHAR2
430 ,p_accrual_date IN DATE
431 ,p_accounting_mode IN VARCHAR2
432 ,X_STATEMENT_XML IN OUT NOCOPY CLOB
433 ,x_return_status OUT NOCOPY VARCHAR2
434 ,x_msg_count OUT NOCOPY NUMBER
435 ,x_msg_data OUT NOCOPY VARCHAR2);
436
437 /*========================================================================
438 | PUBLIC PROCEDURE ACCRUE_LOANS_INTEREST
439 |
440 | DESCRIPTION
441 | This procedure process all available loans
442 |
443 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
444 | LNS_ACCRUAL_ACCOUNTING_CONCUR
445 |
446 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
447 | LogMessage
448 |
449 | PARAMETERS
450 | P_API_VERSION IN Standard in parameter
451 | P_INIT_MSG_LIST IN Standard in parameter
452 | P_COMMIT IN Standard in parameter
453 | P_VALIDATION_LEVEL IN Standard in parameter
454 | P_BORROWER_ID IN Inputs Borrower Id
455 | P_LEDGER_ID IN Inputs Ledger id
456 | P_ORG_ID IN Inputs Organization Id
457 | P_LOAN_ID IN Inputs Loan Id
458 | P_PERIOD_NAME IN Inputs the period name for which the interest accrual requires
459 | P_ACCRUAL_DATE IN Inputs Accrual date
460 | P_MODE IN Inputs Draft or Final Mode
461 | X_RETURN_STATUS OUT NOCOPY Standard out parameter
462 | X_MSG_COUNT OUT NOCOPY Standard out parameter
463 | X_MSG_DATA OUT NOCOPY Standard out parameter
464 |
465 | KNOWN ISSUES
466 | None
467 |
468 | NOTES
469 | Any interesting aspect of the code in the package body which needs
470 | to be stated.
471 |
472 | MODIFICATION HISTORY
473 | Date Author Description of Changes
474 | 15-OCT-2010 MBOLLI Created
475 |
476 *=======================================================================*/
477 PROCEDURE ACCRUE_LOANS_INTEREST(
478 P_API_VERSION IN NUMBER,
479 P_INIT_MSG_LIST IN VARCHAR2,
480 P_COMMIT IN VARCHAR2,
481 P_VALIDATION_LEVEL IN NUMBER,
482 P_BORROWER_ID IN NUMBER,
483 P_LEDGER_ID IN NUMBER,
484 P_ORG_ID IN NUMBER,
485 P_LOAN_ID IN NUMBER,
486 P_PERIOD_NAME IN VARCHAR2,
487 P_ACCRUAL_DATE IN DATE,
488 P_MODE IN VARCHAR2,
489 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
490 X_MSG_COUNT OUT NOCOPY NUMBER,
491 X_MSG_DATA OUT NOCOPY VARCHAR2);
492
493 /*========================================================================
494 | PUBLIC PROCEDURE LNS_ACCRUAL_ACCOUNTING_CONCUR
495 |
496 | DESCRIPTION
497 | This procedure got called from concurent manager to accrue loans interest
498 |
499 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
500 | None
501 |
502 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
503 | LogMessage
504 |
505 | PARAMETERS
506 | ERRBUF OUT Returns errors to CM
507 | RETCODE OUT Returns error code to CM
508 | BORROWER_ID IN Inputs Borrower Id
509 | LEDGER_ID IN Ledger
510 | ORG_ID IN Operating Unit
511 | LOAN_ID IN Inputs Loan Id
512 | ACCRUAL_TYPE IN It tells whether the accrual is Period_end or daily_accrual
513 | PERIOD_DUMMY IN It is a dummy parameter used to enable the period param in CP if the accrual_type is 'PERIOD_END_ACCRUAL'
514 | PERIOD IN Inputs the Period for which the period-end accrual requires
515 | ACCRUAL_DATE_DUMMY IN It is a dummy parameter used to enable the accrual_date param in CP if the accrual_type is 'DAILY_ACCRUAL'
516 | ACCRUAL_DATE IN Inputs accrual Date
517 | P_MODE IN Mode - Preview or Final
518 |
519 | KNOWN ISSUES
520 | None
521 |
522 | NOTES
523 | Any interesting aspect of the code in the package body which needs
524 | to be stated.
525 |
526 | MODIFICATION HISTORY
527 | Date Author Description of Changes
528 | 15-OCT-2010 MBOLLI Created
529 |
530 *=======================================================================*/
531 PROCEDURE LNS_ACCRUAL_ACCOUNTING_CONCUR(
532 ERRBUF OUT NOCOPY VARCHAR2,
533 RETCODE OUT NOCOPY VARCHAR2,
534 BORROWER_ID IN NUMBER,
535 LEDGER_ID IN NUMBER,
536 ORG_ID IN NUMBER,
537 LOAN_ID IN NUMBER,
538 ACCRUAL_TYPE IN VARCHAR2,
539 PERIOD_DUMMY IN VARCHAR2 DEFAULT NULL,
540 PERIOD IN VARCHAR2,
541 ACCRUAL_DATE_DUMMY IN VARCHAR2 DEFAULT NULL,
542 ACCRUAL_DATE IN VARCHAR2,
543 P_MODE IN VARCHAR2);
544
545 /*=========================================================================
546 || PUBLIC PROCEDURE defaultBookDistForActivity
547 ||
548 || DESCRIPTION
549 || This procedure returns loan Booking distributions
550 || For NegativeLoanAdjutment, it returns the distributions in reverse
551 ||
552 || PSEUDO CODE/LOGIC
553 ||
554 || PARAMETERS p_activity
555 ||
556 ||
557 || Return value: x_distribution_tbl distribution table set to write to database
558 ||
559 || Source Tables: lns_distributions
560 ||
561 || Target Tables: NA
562 ||
563 || KNOWN ISSUES
564 ||
565 || NOTES
566 ||
567 ||
568 || MODIFICATION HISTORY
569 || Date Author Description of Changes
570 || 24-Feb-2011 mbolli Created
571 *=======================================================================*/
572 PROCEDURE defaultBookDistForActivity(p_api_version IN NUMBER
573 ,p_init_msg_list IN VARCHAR2
574 ,p_commit IN VARCHAR2
575 ,p_loan_id IN NUMBER
576 ,p_disb_header_id IN NUMBER DEFAULT NULL
577 ,p_loan_amount_adj_id IN NUMBER DEFAULT NULL
578 ,p_activity IN VARCHAR2
579 ,x_distribution_tbl OUT NOCOPY lns_distributions_pub.distribution_tbl
580 ,x_return_status OUT NOCOPY VARCHAR2
581 ,x_msg_count OUT NOCOPY NUMBER
582 ,x_msg_data OUT NOCOPY VARCHAR2);
583
584
585
586 PROCEDURE GENERATE_CCID_FOR_PROJECTS(p_loan_id in number
587 ,p_distribution_id in number
588 ,p_project_id in number
589 ,p_task_id in number
590 ,p_award_id in number
591 ,p_expenditure_type in varchar2
592 ,p_expenditure_date date
593 ,x_ccid OUT NOCOPY NUMBER
594 ,x_conc_segment_values OUT NOCOPY VARCHAR2
595 ,x_return_status OUT NOCOPY VARCHAR2
596 ,x_msg_count OUT NOCOPY NUMBER
597 ,x_msg_data OUT NOCOPY VARCHAR2) ;
598
599 END LNS_DISTRIBUTIONS_PUB;