DBA Data[Home] [Help]

APPS.LNS_BORROWERS_SUMMARY_PUB dependencies on LNS_BORROWERS_SUMMARY_PUB

Line 1: PACKAGE BODY LNS_BORROWERS_SUMMARY_PUB as

1: PACKAGE BODY LNS_BORROWERS_SUMMARY_PUB as
2: /* $Header: LNS_BORR_SUM_B.pls 120.9 2011/08/22 10:37:57 gparuchu ship $ */
3:
4:
5: /*=======================================================================+

Line 8: G_PKG_NAME CONSTANT VARCHAR2(30):= 'LNS_BORROWERS_SUMMARY_PUB';

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:

Line 135: PROCEDURE GET_BORROWER_OVERVIEW(P_BORROWER_TBL IN OUT NOCOPY LNS_BORROWERS_SUMMARY_PUB.BORROWER_TBL)

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 |

Line 294: PROCEDURE GET_LOAN_SUMMARY(P_BORROWER_TBL IN OUT NOCOPY LNS_BORROWERS_SUMMARY_PUB.BORROWER_TBL)

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 |

Line 447: PROCEDURE GET_CREDIT_SUMMARY(P_BORROWER_TBL IN OUT NOCOPY LNS_BORROWERS_SUMMARY_PUB.BORROWER_TBL)

443: | Date Author Description of Changes
444: | 04-14-2004 scherkas Created
445: |
446: *=======================================================================*/
447: PROCEDURE GET_CREDIT_SUMMARY(P_BORROWER_TBL IN OUT NOCOPY LNS_BORROWERS_SUMMARY_PUB.BORROWER_TBL)
448: IS
449:
450: /*-----------------------------------------------------------------------+
451: | Local Variable Declarations and initializations |

Line 564: l_borrower_tbl LNS_BORROWERS_SUMMARY_PUB.BORROWER_TBL;

560: l_LEGAL_ENTITY_ID NUMBER;
561: l_LEGAL_ENTITY_NAME VARCHAR2(240);
562: l_Count number;
563:
564: l_borrower_tbl LNS_BORROWERS_SUMMARY_PUB.BORROWER_TBL;
565:
566: /*-----------------------------------------------------------------------+
567: | Cursor Declarations |
568: +-----------------------------------------------------------------------*/