[Home] [Help]
PACKAGE: APPS.LNS_APPL_ENGINE_PUB
Source
1 PACKAGE LNS_APPL_ENGINE_PUB AUTHID CURRENT_USER as
2 /* $Header: LNS_APPL_ENG_S.pls 120.0.12010000.3 2010/03/10 16:18:56 scherkas ship $ */
3
4 /*=======================================================================+
5 | Declare PUBLIC Data Types and Variables
6 +=======================================================================*/
7
8 /* input types */
9 TYPE SEARCH_REC IS RECORD(
10 LOAN_BORROWER_ID NUMBER, -- optional
11 LOAN_PRODUCT_ID NUMBER, -- optional
12 LOAN_ID NUMBER, -- optional
13 RECEIPT_ID NUMBER, -- optional
14 RECEIPT_MATCH_CRITERIA VARCHAR2(250), -- optional
15 RC_FROM_DATE VARCHAR2(20), -- optional
16 RC_TO_DATE VARCHAR2(20), -- optional
17 UNAPPLY_FLAG VARCHAR2(1) -- Hard coded as No
18 );
19
20 TYPE SEARCH_RECEIPTS_REC IS RECORD(
21 LOAN_ID NUMBER, -- mandatory
22 RECEIPT_ID NUMBER, -- optional
23 RECEIPT_MATCH_CRITERIA VARCHAR2(250), -- optional
24 RC_FROM_DATE VARCHAR2(20), -- optional
25 RC_TO_DATE VARCHAR2(20) -- optional
26 );
27
28 /* output types */
29 TYPE RECEIPT_REC IS RECORD(
30 RECEIPT_ID NUMBER,
31 RECEIPT_NUMBER VARCHAR2(30),
32 RECEIPT_DATE DATE,
33 PARTY_NAME VARCHAR2(360),
34 REMAINING_AMOUNT NUMBER,
35 RECEIPT_CURRENCY VARCHAR(15)
36 );
37 TYPE RECEIPTS_TBL IS TABLE OF RECEIPT_REC INDEX BY BINARY_INTEGER;
38
39 TYPE LOAN_INVOICE_REC IS RECORD(
40 CUST_TRX_ID NUMBER,
41 PAYMENT_SCHEDULE_ID NUMBER,
42 TRX_NUMBER VARCHAR2(30),
43 LOAN_BORROWER_ID NUMBER,
44 BORROWER_NAME VARCHAR2(360),
45 LOAN_PRODUCT_ID NUMBER,
46 PRODUCT_NAME VARCHAR2(80),
47 LOAN_ID NUMBER,
48 LOAN_NUMBER VARCHAR2(60),
49 AMORTIZATION_ID NUMBER,
50 PAYMENT_NUMBER NUMBER,
51 DUE_DATE DATE,
52 BILL_DATE DATE,
53 PHASE VARCHAR2(30),
54 INVOICE_TYPE_CODE VARCHAR2(30),
55 INVOICE_TYPE_DESC VARCHAR2(80),
56 REMAINING_AMOUNT NUMBER,
57 INVOICE_CURRENCY VARCHAR2(15),
58 EXCHANGE_RATE NUMBER
59 );
60 TYPE LOAN_INVOICES_TBL IS TABLE OF LOAN_INVOICE_REC INDEX BY BINARY_INTEGER;
61
62 /* internal types */
63 TYPE LOAN_REC IS RECORD(
64 SEQUENCE_NUMBER NUMBER,
65 LOAN_ID NUMBER,
66 LOAN_NUMBER VARCHAR2(60),
67 LOAN_BORROWER_ID NUMBER,
68 BORROWER_NAME VARCHAR2(360),
69 LOAN_PRODUCT_ID NUMBER,
70 PRODUCT_NAME VARCHAR2(80),
71 LOAN_CURRENCY VARCHAR2(15)
72 );
73
74 /*========================================================================
75 | PUBLIC PROCEDURE SEARCH_RECEIPTS
76 |
77 | DESCRIPTION
78 | This procedure searches for receipts using passed search criteria record
79 |
80 | PSEUDO CODE/LOGIC
81 |
82 | PARAMETERS
83 | P_SEARCH_RECEIPTS_REC IN Search record
84 | X_RECEIPTS_TBL OUT NOCOPY Receipts table
85 |
86 | KNOWN ISSUES
87 | None
88 |
89 | NOTES
90 | Any interesting aspect of the code in the package body which needs
91 | to be stated.
92 |
93 | MODIFICATION HISTORY
94 | Date Author Description of Changes
95 | 25-10-2005 scherkas Created
96 |
97 *=======================================================================*/
98 PROCEDURE SEARCH_RECEIPTS(
99 P_SEARCH_RECEIPTS_REC IN LNS_APPL_ENGINE_PUB.SEARCH_RECEIPTS_REC,
100 X_RECEIPTS_TBL OUT NOCOPY LNS_APPL_ENGINE_PUB.RECEIPTS_TBL);
101
102
103
104 /*========================================================================
105 | PUBLIC PROCEDURE SEARCH_LOAN_INVOICES
106 |
107 | DESCRIPTION
108 | This procedure searches for available loan invoices
109 |
110 | PSEUDO CODE/LOGIC
111 |
112 | PARAMETERS
113 | P_LOAN_ID IN Loan
114 | X_LOAN_INVOICES_TBL OUT NOCOPY Table of loan invoices
115 |
116 | KNOWN ISSUES
117 | None
118 |
119 | NOTES
120 | Any interesting aspect of the code in the package body which needs
121 | to be stated.
122 |
123 | MODIFICATION HISTORY
124 | Date Author Description of Changes
125 | 25-10-2005 scherkas Created
126 |
127 *=======================================================================*/
128 PROCEDURE SEARCH_LOAN_INVOICES(
129 P_LOAN_ID IN NUMBER,
130 P_FOR_ACTION IN VARCHAR2,
131 X_LOAN_INVOICES_TBL OUT NOCOPY LNS_APPL_ENGINE_PUB.LOAN_INVOICES_TBL);
132
133
134
135 /*========================================================================
136 | PUBLIC PROCEDURE SEARCH_AND_APPLY
137 |
138 | DESCRIPTION
139 | This procedure applies receipts to loan invoices based on passed search criteria
140 |
141 | PSEUDO CODE/LOGIC
142 |
143 | PARAMETERS
144 | P_API_VERSION IN Standard in parameter
145 | P_INIT_MSG_LIST IN Standard in parameter
146 | P_COMMIT IN Standard in parameter
147 | P_VALIDATION_LEVEL IN Standard in parameter
148 | P_SEARCH_REC IN Search record
149 | X_RETURN_STATUS OUT NOCOPY Standard out parameter
150 | X_MSG_COUNT OUT NOCOPY Standard out parameter
151 | X_MSG_DATA OUT NOCOPY Standard out parameter
152 |
153 | KNOWN ISSUES
154 | None
155 |
156 | NOTES
157 | Any interesting aspect of the code in the package body which needs
158 | to be stated.
159 |
160 | MODIFICATION HISTORY
161 | Date Author Description of Changes
162 | 26-10-2005 scherkas Created
163 |
164 *=======================================================================*/
165 PROCEDURE SEARCH_AND_APPLY(
166 P_API_VERSION IN NUMBER,
167 P_INIT_MSG_LIST IN VARCHAR2,
168 P_COMMIT IN VARCHAR2,
169 P_VALIDATION_LEVEL IN NUMBER,
170 P_SEARCH_REC IN LNS_APPL_ENGINE_PUB.SEARCH_REC,
171 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
172 X_MSG_COUNT OUT NOCOPY NUMBER,
173 X_MSG_DATA OUT NOCOPY VARCHAR2);
174
175
176
177 /*========================================================================
178 | PUBLIC PROCEDURE LNS_APPL_RC_CONCUR
179 |
180 | DESCRIPTION
181 | This procedure got called from concurent manager to apply receipts to loan invoices
182 |
183 | PSEUDO CODE/LOGIC
184 |
185 | PARAMETERS
186 | ERRBUF OUT Returns errors to CM
187 | RETCODE OUT Returns error code to CM
188 | LOAN_BORROWER_ID IN Loan primary borrower id
189 | LOAN_PRODUCT_ID IN Loan product id
190 | LOAN_ID IN Loan id
191 | RECEIPT_ID IN Receipt id
192 | RC_FROM_DATE IN From receipt date
193 | RC_TO_DATE IN To receipt date
194 |
195 | KNOWN ISSUES
196 | None
197 |
198 | NOTES
199 | Any interesting aspect of the code in the package body which needs
200 | to be stated.
201 |
202 | MODIFICATION HISTORY
203 | Date Author Description of Changes
204 | 24-10-2005 scherkas Created
205 |
206 *=======================================================================*/
207 PROCEDURE LNS_APPL_RC_CONCUR(
208 ERRBUF OUT NOCOPY VARCHAR2,
209 RETCODE OUT NOCOPY VARCHAR2,
210 LOAN_BORROWER_ID IN NUMBER,
211 LOAN_PRODUCT_ID IN NUMBER,
212 LOAN_ID IN NUMBER,
213 RECEIPT_ID IN NUMBER,
214 RECEIPT_MATCH_CRITERIA IN VARCHAR2,
215 RC_FROM_DATE IN VARCHAR2,
216 RC_TO_DATE IN VARCHAR2);
217
218
219
220 END LNS_APPL_ENGINE_PUB;