[Home] [Help]
1: PACKAGE BODY LNS_BORROWERS_SUMMARY_PUB as
2: /* $Header: LNS_BORR_SUM_B.pls 120.7 2006/07/11 23:09:48 karamach noship $ */
3:
4:
5: /*=======================================================================+
4:
5: /*=======================================================================+
6: | Package Global Constants
7: +=======================================================================*/
8: G_PKG_NAME CONSTANT VARCHAR2(30):= 'LNS_BORROWERS_SUMMARY_PUB';
9: G_LOG_ENABLED varchar2(5);
10: G_MSG_LEVEL NUMBER;
11:
12:
131: | Date Author Description of Changes
132: | 04-14-2004 scherkas Created
133: |
134: *=======================================================================*/
135: PROCEDURE GET_BORROWER_OVERVIEW(P_BORROWER_TBL IN OUT NOCOPY LNS_BORROWERS_SUMMARY_PUB.BORROWER_TBL)
136: IS
137:
138: /*-----------------------------------------------------------------------+
139: | Local Variable Declarations and initializations |
290: | Date Author Description of Changes
291: | 04-14-2004 scherkas Created
292: |
293: *=======================================================================*/
294: PROCEDURE GET_LOAN_SUMMARY(P_BORROWER_TBL IN OUT NOCOPY LNS_BORROWERS_SUMMARY_PUB.BORROWER_TBL)
295: IS
296:
297: /*-----------------------------------------------------------------------+
298: | Local Variable Declarations and initializations |
425: | Date Author Description of Changes
426: | 04-14-2004 scherkas Created
427: |
428: *=======================================================================*/
429: PROCEDURE GET_CREDIT_SUMMARY(P_BORROWER_TBL IN OUT NOCOPY LNS_BORROWERS_SUMMARY_PUB.BORROWER_TBL)
430: IS
431:
432: /*-----------------------------------------------------------------------+
433: | Local Variable Declarations and initializations |
542: l_LEGAL_ENTITY_ID NUMBER;
543: l_LEGAL_ENTITY_NAME VARCHAR2(240);
544: l_Count number;
545:
546: l_borrower_tbl LNS_BORROWERS_SUMMARY_PUB.BORROWER_TBL;
547:
548: /*-----------------------------------------------------------------------+
549: | Cursor Declarations |
550: +-----------------------------------------------------------------------*/