[Home] [Help]
PACKAGE: APPS.LNS_BORROWERS_SUMMARY_PUB
Source
1 PACKAGE LNS_BORROWERS_SUMMARY_PUB AUTHID CURRENT_USER as
2 /* $Header: LNS_BORR_SUM_S.pls 120.1 2005/09/19 13:38:06 scherkas noship $ */
3
4 /*=======================================================================+
5 | Declare PUBLIC Data Types and Variables
6 +=======================================================================*/
7
8 TYPE BORROWER_REC IS RECORD(
9
10 /*------------- Borrower Overview ---------------*/
11 BORROWER_PARTY_ID NUMBER,
12 BORROWER_NAME VARCHAR2(360),
13 TAX_PAYER_CODE VARCHAR2(50),
14 CUSTOMER_CLASSIFICATION VARCHAR2(100),
15 INDUSTRIAL_CLASSIFICATION VARCHAR2(100),
16 YEAR_ESTABLISHED NUMBER,
17 COUNTRY VARCHAR2(60),
18 ADDRESS1 VARCHAR2(240),
19 ADDRESS2 VARCHAR2(240),
20 ADDRESS3 VARCHAR2(240),
21 ADDRESS4 VARCHAR2(240),
22 CITY VARCHAR2(60),
23 POSTAL_CODE VARCHAR2(60),
24 STATE VARCHAR2(60),
25 PRIMARY_CONTACT_NAME VARCHAR2(360),
26 PRIMARY_PHONE_COUNTRY_CODE VARCHAR2(10),
27 PRIMARY_PHONE_AREA_CODE VARCHAR2(10),
28 PRIMARY_PHONE_NUMBER VARCHAR2(40),
29 PRIMARY_PHONE_EXTENSION VARCHAR2(20),
30 ANNUAL_REVENUE NUMBER,
31 CUSTOMER_SINCE DATE,
32
33 /*------------- Loans Summary -----------------*/
34 NUM_ACTIVE_LOANS NUMBER,
35 TOTAL_REMAINING_PRINCIPAL NUMBER,
36 TOTAL_PRINCIPAL_PAID_YTD NUMBER,
37 TOTAL_INTEREST_PAID_YTD NUMBER,
38 TOTAL_FEE_PAID_YTD NUMBER,
39 TOTAL_REQUESTED_LOAN_AMOUNT NUMBER,
40 TOTAL_APPROVED_LOAN_AMOUNT NUMBER,
41 PLEDGED_COLL_AMOUNT NUMBER,
42 LAST_COLL_VALUATION_DATE DATE,
43 ORG_ID NUMBER,
44 ORG_NAME VARCHAR2(240),
45 LEGAL_ENTITY_ID NUMBER,
46 LEGAL_ENTITY_NAME VARCHAR2(240),
47 FUNCTIONAL_CURRENCY VARCHAR2(15),
48
49 /*------------- Credit Summary -----------------*/
50 CREDIT_CLASSIFICATION VARCHAR2(30),
51 REVIEW_CYCLE VARCHAR2(30),
52 LAST_CREDIT_REVIEW_DATE DATE,
53 CREDIT_RATING VARCHAR2(30),
54 CREDIT_HOLD VARCHAR2(1),
55 CREDIT_CHECKING VARCHAR2(1),
56 TOLERANCE NUMBER
57 );
58
59 TYPE BORROWER_TBL IS TABLE OF BORROWER_REC INDEX BY BINARY_INTEGER;
60
61
62 /*========================================================================
63 | PUBLIC PROCEDURE LNS_BORR_SUM_CONCUR
64 |
65 | DESCRIPTION
66 | This procedure gets called from CM to start borrower summary generation program.
67 |
68 | PSEUDO CODE/LOGIC
69 |
70 | PARAMETERS
71 | ERRBUF OUT Returns errors to CM
72 | RETCODE OUT Returns error code to CM
73 | BORROWER_PARTY_ID IN Inputs borrower party id
74 |
75 | KNOWN ISSUES
76 | None
77 |
78 | NOTES
79 |
80 | MODIFICATION HISTORY
81 | Date Author Description of Changes
82 | 30-12-2003 scherkas Created
83 |
84 *=======================================================================*/
85 PROCEDURE LNS_BORR_SUM_CONCUR(
86 ERRBUF OUT NOCOPY VARCHAR2,
87 RETCODE OUT NOCOPY VARCHAR2,
88 BORROWER_PARTY_ID IN NUMBER);
89
90
91
92
93 /*========================================================================
94 | PUBLIC PROCEDURE GENERATE_BORROWERS_SUMMARY
95 |
96 | DESCRIPTION
97 | This procedure generates summary info for all available borrowers
98 |
99 | PSEUDO CODE/LOGIC
100 |
101 | PARAMETERS
102 | P_API_VERSION IN Standard in parameter
103 | P_INIT_MSG_LIST IN Standard in parameter
104 | P_COMMIT IN Standard in parameter
105 | P_VALIDATION_LEVEL IN Standard in parameter
106 | P_BORROWER_PARTY_ID IN Inputs borrower party id
107 | X_RETURN_STATUS OUT NOCOPY Standard out parameter
108 | X_MSG_COUNT OUT NOCOPY Standard out parameter
109 | X_MSG_DATA OUT NOCOPY Standard out parameter
110 |
111 | KNOWN ISSUES
112 | None
113 |
114 | NOTES
115 | Any interesting aspect of the code in the package body which needs
116 | to be stated.
117 |
118 | MODIFICATION HISTORY
119 | Date Author Description of Changes
120 | 04-14-2004 scherkas Created
121 |
122 *=======================================================================*/
123 PROCEDURE GENERATE_BORROWERS_SUMMARY(
124 P_API_VERSION IN NUMBER,
125 P_INIT_MSG_LIST IN VARCHAR2,
126 P_COMMIT IN VARCHAR2,
127 P_VALIDATION_LEVEL IN NUMBER,
128 P_BORROWER_PARTY_ID IN NUMBER,
129 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
130 X_MSG_COUNT OUT NOCOPY NUMBER,
131 X_MSG_DATA OUT NOCOPY VARCHAR2);
132
133
134 END LNS_BORROWERS_SUMMARY_PUB;