1 PACKAGE LNS_LOAN_LINE_PUB AS
2 /* $Header: LNS_LINE_PUBP_S.pls 120.4 2006/01/16 18:05:49 karamach noship $ */
3
4 /*========================================================================
5 | PUBLIC PROCEDURE UPDATE_LINE_ADJUSTMENT_NUMBER
6 |
7 | DESCRIPTION
8 | This procedure updates the rec number column in loan lines table based on AR Adjustment api out parameter during loan approval
9 |
10 | NOTES
11 | There are no table-handler apis for loan lines table since it uses java-based EO
12 |
13 | MODIFICATION HISTORY
14 | Date Author Description of Changes
15 | 20-Dec-2004 karamach Created
16 *=======================================================================*/
17 PROCEDURE UPDATE_LINE_ADJUSTMENT_NUMBER(
18 p_init_msg_list IN VARCHAR2
19 ,p_loan_id IN NUMBER
20 ,p_loan_line_id IN NUMBER
21 ,p_rec_adjustment_number IN VARCHAR2
22 ,p_rec_adjustment_id IN NUMBER
23 ,p_payment_schedule_id IN NUMBER
24 ,p_installment_number IN NUMBER
25 ,x_return_status OUT NOCOPY VARCHAR2
26 ,x_msg_count OUT NOCOPY NUMBER
27 ,x_msg_data OUT NOCOPY VARCHAR2);
28
29
30 /*========================================================================
31 | PUBLIC FUNCTION GET_LOAN_PARTY_ID
32 |
33 | DESCRIPTION
34 | This function will be used by rules engine as a filter to the bulk processing rules api when executing query.
35 | The function returns the value for the package variable LNS_LOAN_PARTY_ID
36 |
37 | NOTES
38 | This function is used in the bulk rule processing api for better performance
39 |
40 | MODIFICATION HISTORY
41 | Date Author Description of Changes
42 | 13-Jan-2006 karamach Created
43 *=======================================================================*/
44 FUNCTION GET_LOAN_PARTY_ID RETURN NUMBER;
45
46 /*========================================================================
47 | PUBLIC FUNCTION GET_LOAN_CURRENCY_CODE
48 |
49 | DESCRIPTION
50 | This function will be used by rules engine as a filter to the bulk processing rules api when executing query.
51 | The function returns the value for the package variable LNS_LOAN_CURRENCY_CODE
52 |
53 | NOTES
54 | This function is used in the bulk rule processing api for better performance
55 |
56 | MODIFICATION HISTORY
57 | Date Author Description of Changes
58 | 13-Jan-2006 karamach Created
59 *=======================================================================*/
60 FUNCTION GET_LOAN_CURRENCY_CODE RETURN VARCHAR2;
61
62 /*========================================================================
63 | PUBLIC FUNCTION GET_LOAN_ORG_ID
64 |
65 | DESCRIPTION
66 | This function will be used by rules engine as a filter to the bulk processing rules api when executing query.
67 | The function returns the value for the package variable LNS_LOAN_ORG_ID
68 |
69 | NOTES
70 | This function is used in the bulk rule processing api for better performance
71 |
72 | MODIFICATION HISTORY
73 | Date Author Description of Changes
74 | 13-Jan-2006 karamach Created
75 *=======================================================================*/
76 FUNCTION GET_LOAN_ORG_ID RETURN NUMBER;
77
78 /*========================================================================
79 | PUBLIC FUNCTION GET_RULES_DERIVED_ERS_AMOUNT
80 |
81 | DESCRIPTION
82 | This function applies rules defined on the loan product
83 | for ERS loan receivables derivation and inserts into loan lines table.
84 | If NO rules have been defined for the loan product, calling this api retrieves
85 | ALL OPEN Receivables for the customer and inserts them into loan lines.
86 | The function returns the total requested amount for updating loan header
87 | after inserting the receivables into lns_loan_lines table.
88 |
89 | NOTES
90 | This api does a bulk select if max_requested_amount is NOT specified on the product.
91 | This api does bulk insert into lns_loan_lines after retrieving the matching receivables into table types.
92 | Incase an error is encountered during processing the api returns zero with error message in the stack.
93 | The api also returns zero if no receivables found for inserting into loan lines.
94 |
95 | MODIFICATION HISTORY
96 | Date Author Description of Changes
97 | 13-Jan-2006 karamach Created
98 *=======================================================================*/
99 FUNCTION GET_RULES_DERIVED_ERS_AMOUNT(
100 p_loan_id IN NUMBER,
101 p_primary_borrower_id IN NUMBER,
102 p_currency_code IN VARCHAR2,
103 p_org_id IN NUMBER,
104 p_loan_product_id IN NUMBER
105 ) RETURN NUMBER;
106
107 END LNS_LOAN_LINE_PUB;