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