1 PACKAGE LNS_LOAN_LINE_PUB AUTHID CURRENT_USER AS
2 /* $Header: LNS_LINE_PUBP_S.pls 120.4.12010000.2 2010/03/17 13:18:53 scherkas ship $ */
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 ,p_adjustment_date IN DATE
26 ,p_original_flag IN VARCHAR2
27 ,x_return_status OUT NOCOPY VARCHAR2
28 ,x_msg_count OUT NOCOPY NUMBER
29 ,x_msg_data OUT NOCOPY VARCHAR2);
30
31
32 /*========================================================================
33 | PUBLIC FUNCTION GET_LOAN_PARTY_ID
34 |
35 | DESCRIPTION
36 | This function will be used by rules engine as a filter to the bulk processing rules api when executing query.
37 | The function returns the value for the package variable LNS_LOAN_PARTY_ID
38 |
39 | NOTES
40 | This function is used in the bulk rule processing api for better performance
41 |
42 | MODIFICATION HISTORY
43 | Date Author Description of Changes
44 | 13-Jan-2006 karamach Created
45 *=======================================================================*/
46 FUNCTION GET_LOAN_PARTY_ID RETURN NUMBER;
47
48 /*========================================================================
49 | PUBLIC FUNCTION GET_LOAN_CURRENCY_CODE
50 |
51 | DESCRIPTION
52 | This function will be used by rules engine as a filter to the bulk processing rules api when executing query.
53 | The function returns the value for the package variable LNS_LOAN_CURRENCY_CODE
54 |
55 | NOTES
56 | This function is used in the bulk rule processing api for better performance
57 |
58 | MODIFICATION HISTORY
59 | Date Author Description of Changes
60 | 13-Jan-2006 karamach Created
61 *=======================================================================*/
62 FUNCTION GET_LOAN_CURRENCY_CODE RETURN VARCHAR2;
63
64 /*========================================================================
65 | PUBLIC FUNCTION GET_LOAN_ORG_ID
66 |
67 | DESCRIPTION
68 | This function will be used by rules engine as a filter to the bulk processing rules api when executing query.
69 | The function returns the value for the package variable LNS_LOAN_ORG_ID
70 |
71 | NOTES
72 | This function is used in the bulk rule processing api for better performance
73 |
74 | MODIFICATION HISTORY
75 | Date Author Description of Changes
76 | 13-Jan-2006 karamach Created
77 *=======================================================================*/
78 FUNCTION GET_LOAN_ORG_ID RETURN NUMBER;
79
80 /*========================================================================
81 | PUBLIC FUNCTION GET_RULES_DERIVED_ERS_AMOUNT
82 |
83 | DESCRIPTION
84 | This function applies rules defined on the loan product
85 | for ERS loan receivables derivation and inserts into loan lines table.
86 | If NO rules have been defined for the loan product, calling this api retrieves
87 | ALL OPEN Receivables for the customer and inserts them into loan lines.
88 | The function returns the total requested amount for updating loan header
89 | after inserting the receivables into lns_loan_lines table.
90 |
91 | NOTES
92 | This api does a bulk select if max_requested_amount is NOT specified on the product.
93 | This api does bulk insert into lns_loan_lines after retrieving the matching receivables into table types.
94 | Incase an error is encountered during processing the api returns zero with error message in the stack.
95 | The api also returns zero if no receivables found for inserting into loan lines.
96 |
97 | MODIFICATION HISTORY
98 | Date Author Description of Changes
99 | 13-Jan-2006 karamach Created
100 *=======================================================================*/
101 FUNCTION GET_RULES_DERIVED_ERS_AMOUNT(
102 p_loan_id IN NUMBER,
103 p_primary_borrower_id IN NUMBER,
104 p_currency_code IN VARCHAR2,
105 p_org_id IN NUMBER,
106 p_loan_product_id IN NUMBER
107 ) RETURN NUMBER;
108
109 END LNS_LOAN_LINE_PUB;