eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.LNS_LOAN_PUB dependencies on LNS_LOAN_PUB

Line 1: PACKAGE BODY LNS_LOAN_PUB as

1: PACKAGE BODY LNS_LOAN_PUB as
2: /* $Header: LNS_LOAN_PUBP_B.pls 120.22.12020000.2 2013/02/11 20:00:37 scherkas ship $ */
3:
4: /*========================================================================
5: | PUBLIC PROCEDURE SELECT_WF_PROCESS

Line 2: /* $Header: LNS_LOAN_PUBP_B.pls 120.22.12020000.2 2013/02/11 20:00:37 scherkas ship $ */

1: PACKAGE BODY LNS_LOAN_PUB as
2: /* $Header: LNS_LOAN_PUBP_B.pls 120.22.12020000.2 2013/02/11 20:00:37 scherkas ship $ */
3:
4: /*========================================================================
5: | PUBLIC PROCEDURE SELECT_WF_PROCESS
6: |

Line 32: G_PKG_NAME CONSTANT VARCHAR2(30):= 'LNS_LOAN_PUB';

28:
29: /*=======================================================================+
30: | Package Global Constants
31: +=======================================================================*/
32: G_PKG_NAME CONSTANT VARCHAR2(30):= 'LNS_LOAN_PUB';
33: G_LOG_ENABLED varchar2(5);
34: G_MSG_LEVEL NUMBER;
35: g_org_id number;
36: g_errors_rec Loan_create_errors_type := Loan_create_errors_type();

Line 337: PROCEDURE validate_loan_header_details(P_Loan_Details_Rec IN OUT NOCOPY LNS_LOAN_PUB.Loan_Details_Rec_Type

333: ) CUSTOM_CALC_METHOD_TBL;
334:
335: l_override_rec Csr_override_flags%ROWTYPE;
336:
337: PROCEDURE validate_loan_header_details(P_Loan_Details_Rec IN OUT NOCOPY LNS_LOAN_PUB.Loan_Details_Rec_Type
338: ,p_loan_cust_sched_tbl IN OUT NOCOPY LNS_LOAN_PUB.loan_cust_sched_tbl_type
339: ,x_return_status OUT nocopy VARCHAR2
340: ,x_msg_count OUT nocopy NUMBER
341: ,x_msg_data OUT nocopy VARCHAR2);

Line 338: ,p_loan_cust_sched_tbl IN OUT NOCOPY LNS_LOAN_PUB.loan_cust_sched_tbl_type

334:
335: l_override_rec Csr_override_flags%ROWTYPE;
336:
337: PROCEDURE validate_loan_header_details(P_Loan_Details_Rec IN OUT NOCOPY LNS_LOAN_PUB.Loan_Details_Rec_Type
338: ,p_loan_cust_sched_tbl IN OUT NOCOPY LNS_LOAN_PUB.loan_cust_sched_tbl_type
339: ,x_return_status OUT nocopy VARCHAR2
340: ,x_msg_count OUT nocopy NUMBER
341: ,x_msg_data OUT nocopy VARCHAR2);
342:

Line 343: PROCEDURE validate_participants(p_loan_part_tbl IN OUT NOCOPY LNS_LOAN_PUB.LOAN_PART_TBL_TYPE

339: ,x_return_status OUT nocopy VARCHAR2
340: ,x_msg_count OUT nocopy NUMBER
341: ,x_msg_data OUT nocopy VARCHAR2);
342:
343: PROCEDURE validate_participants(p_loan_part_tbl IN OUT NOCOPY LNS_LOAN_PUB.LOAN_PART_TBL_TYPE
344: ,x_return_status OUT nocopy VARCHAR2
345: ,x_msg_count OUT nocopy NUMBER
346: ,x_msg_data OUT nocopy VARCHAR2);
347:

Line 348: PROCEDURE validate_loan_lines(P_Loan_Details_Rec IN OUT NOCOPY LNS_LOAN_PUB.Loan_Details_Rec_Type

344: ,x_return_status OUT nocopy VARCHAR2
345: ,x_msg_count OUT nocopy NUMBER
346: ,x_msg_data OUT nocopy VARCHAR2);
347:
348: PROCEDURE validate_loan_lines(P_Loan_Details_Rec IN OUT NOCOPY LNS_LOAN_PUB.Loan_Details_Rec_Type
349: ,p_loan_lines_tbl IN OUT nocopy LNS_LOAN_PUB.loan_lines_tbl_type
350: ,x_return_status OUT nocopy VARCHAR2
351: ,x_msg_count OUT nocopy NUMBER
352: ,x_msg_data OUT nocopy VARCHAR2);

Line 349: ,p_loan_lines_tbl IN OUT nocopy LNS_LOAN_PUB.loan_lines_tbl_type

345: ,x_msg_count OUT nocopy NUMBER
346: ,x_msg_data OUT nocopy VARCHAR2);
347:
348: PROCEDURE validate_loan_lines(P_Loan_Details_Rec IN OUT NOCOPY LNS_LOAN_PUB.Loan_Details_Rec_Type
349: ,p_loan_lines_tbl IN OUT nocopy LNS_LOAN_PUB.loan_lines_tbl_type
350: ,x_return_status OUT nocopy VARCHAR2
351: ,x_msg_count OUT nocopy NUMBER
352: ,x_msg_data OUT nocopy VARCHAR2);
353:

Line 354: PROCEDURE validate_rate_sched(P_Loan_Details_Rec IN OUT NOCOPY LNS_LOAN_PUB.Loan_Details_Rec_Type

350: ,x_return_status OUT nocopy VARCHAR2
351: ,x_msg_count OUT nocopy NUMBER
352: ,x_msg_data OUT nocopy VARCHAR2);
353:
354: PROCEDURE validate_rate_sched(P_Loan_Details_Rec IN OUT NOCOPY LNS_LOAN_PUB.Loan_Details_Rec_Type
355: ,p_loan_rates_tbl IN OUT nocopy LNS_LOAN_PUB.LOAN_RATES_TBL_TYPE
356: ,p_phase IN VARCHAR2
357: ,x_return_status OUT nocopy VARCHAR2
358: ,x_msg_count OUT nocopy NUMBER

Line 355: ,p_loan_rates_tbl IN OUT nocopy LNS_LOAN_PUB.LOAN_RATES_TBL_TYPE

351: ,x_msg_count OUT nocopy NUMBER
352: ,x_msg_data OUT nocopy VARCHAR2);
353:
354: PROCEDURE validate_rate_sched(P_Loan_Details_Rec IN OUT NOCOPY LNS_LOAN_PUB.Loan_Details_Rec_Type
355: ,p_loan_rates_tbl IN OUT nocopy LNS_LOAN_PUB.LOAN_RATES_TBL_TYPE
356: ,p_phase IN VARCHAR2
357: ,x_return_status OUT nocopy VARCHAR2
358: ,x_msg_count OUT nocopy NUMBER
359: ,x_msg_data OUT nocopy VARCHAR2);

Line 361: procedure synchRateSchedule(p_rate_tbl IN OUT NOCOPY LNS_LOAN_PUB.LOAN_RATES_TBL_TYPE, p_num_installments in number);

357: ,x_return_status OUT nocopy VARCHAR2
358: ,x_msg_count OUT nocopy NUMBER
359: ,x_msg_data OUT nocopy VARCHAR2);
360:
361: procedure synchRateSchedule(p_rate_tbl IN OUT NOCOPY LNS_LOAN_PUB.LOAN_RATES_TBL_TYPE, p_num_installments in number);
362:
363: PROCEDURE validate_disbursements(P_Loan_Details_Rec IN OUT nocopy LNS_LOAN_PUB.Loan_Details_Rec_Type
364: ,P_DISB_TBL IN OUT NOCOPY LNS_LOAN_PUB.Loan_Disb_Tbl_Type
365: , x_return_status OUT nocopy VARCHAR2

Line 363: PROCEDURE validate_disbursements(P_Loan_Details_Rec IN OUT nocopy LNS_LOAN_PUB.Loan_Details_Rec_Type

359: ,x_msg_data OUT nocopy VARCHAR2);
360:
361: procedure synchRateSchedule(p_rate_tbl IN OUT NOCOPY LNS_LOAN_PUB.LOAN_RATES_TBL_TYPE, p_num_installments in number);
362:
363: PROCEDURE validate_disbursements(P_Loan_Details_Rec IN OUT nocopy LNS_LOAN_PUB.Loan_Details_Rec_Type
364: ,P_DISB_TBL IN OUT NOCOPY LNS_LOAN_PUB.Loan_Disb_Tbl_Type
365: , x_return_status OUT nocopy VARCHAR2
366: , x_msg_count OUT nocopy NUMBER
367: , x_msg_data OUT nocopy VARCHAR2);

Line 364: ,P_DISB_TBL IN OUT NOCOPY LNS_LOAN_PUB.Loan_Disb_Tbl_Type

360:
361: procedure synchRateSchedule(p_rate_tbl IN OUT NOCOPY LNS_LOAN_PUB.LOAN_RATES_TBL_TYPE, p_num_installments in number);
362:
363: PROCEDURE validate_disbursements(P_Loan_Details_Rec IN OUT nocopy LNS_LOAN_PUB.Loan_Details_Rec_Type
364: ,P_DISB_TBL IN OUT NOCOPY LNS_LOAN_PUB.Loan_Disb_Tbl_Type
365: , x_return_status OUT nocopy VARCHAR2
366: , x_msg_count OUT nocopy NUMBER
367: , x_msg_data OUT nocopy VARCHAR2);
368:

Line 483: PROCEDURE validate_loan_header_details(P_Loan_Details_Rec IN OUT NOCOPY LNS_LOAN_PUB.Loan_Details_Rec_Type

479:
480:
481:
482:
483: PROCEDURE validate_loan_header_details(P_Loan_Details_Rec IN OUT NOCOPY LNS_LOAN_PUB.Loan_Details_Rec_Type
484: ,p_loan_cust_sched_tbl IN OUT NOCOPY LNS_LOAN_PUB.loan_cust_sched_tbl_type
485: ,x_return_status OUT nocopy VARCHAR2
486: ,x_msg_count OUT nocopy NUMBER
487: ,x_msg_data OUT nocopy VARCHAR2)

Line 484: ,p_loan_cust_sched_tbl IN OUT NOCOPY LNS_LOAN_PUB.loan_cust_sched_tbl_type

480:
481:
482:
483: PROCEDURE validate_loan_header_details(P_Loan_Details_Rec IN OUT NOCOPY LNS_LOAN_PUB.Loan_Details_Rec_Type
484: ,p_loan_cust_sched_tbl IN OUT NOCOPY LNS_LOAN_PUB.loan_cust_sched_tbl_type
485: ,x_return_status OUT nocopy VARCHAR2
486: ,x_msg_count OUT nocopy NUMBER
487: ,x_msg_data OUT nocopy VARCHAR2)
488: IS

Line 1866: PROCEDURE validate_participants(p_loan_part_tbl IN OUT NOCOPY LNS_LOAN_PUB.loan_part_tbl_type

1862:
1863:
1864:
1865:
1866: PROCEDURE validate_participants(p_loan_part_tbl IN OUT NOCOPY LNS_LOAN_PUB.loan_part_tbl_type
1867: ,x_return_status OUT nocopy VARCHAR2
1868: ,x_msg_count OUT nocopy NUMBER
1869: ,x_msg_data OUT nocopy VARCHAR2)
1870: IS

Line 2142: PROCEDURE validate_loan_lines(P_Loan_Details_Rec IN OUT NOCOPY LNS_LOAN_PUB.Loan_Details_Rec_Type

2138:
2139:
2140:
2141:
2142: PROCEDURE validate_loan_lines(P_Loan_Details_Rec IN OUT NOCOPY LNS_LOAN_PUB.Loan_Details_Rec_Type
2143: ,p_loan_lines_tbl IN OUT nocopy LNS_LOAN_PUB.loan_lines_tbl_type
2144: ,x_return_status OUT nocopy VARCHAR2
2145: ,x_msg_count OUT nocopy NUMBER
2146: ,x_msg_data OUT nocopy VARCHAR2)

Line 2143: ,p_loan_lines_tbl IN OUT nocopy LNS_LOAN_PUB.loan_lines_tbl_type

2139:
2140:
2141:
2142: PROCEDURE validate_loan_lines(P_Loan_Details_Rec IN OUT NOCOPY LNS_LOAN_PUB.Loan_Details_Rec_Type
2143: ,p_loan_lines_tbl IN OUT nocopy LNS_LOAN_PUB.loan_lines_tbl_type
2144: ,x_return_status OUT nocopy VARCHAR2
2145: ,x_msg_count OUT nocopy NUMBER
2146: ,x_msg_data OUT nocopy VARCHAR2)
2147: IS

Line 2267: PROCEDURE validate_rate_sched(P_Loan_Details_Rec IN OUT NOCOPY LNS_LOAN_PUB.Loan_Details_Rec_Type

2263: END;
2264:
2265:
2266:
2267: PROCEDURE validate_rate_sched(P_Loan_Details_Rec IN OUT NOCOPY LNS_LOAN_PUB.Loan_Details_Rec_Type
2268: ,p_loan_rates_tbl IN OUT nocopy LNS_LOAN_PUB.LOAN_RATES_TBL_TYPE
2269: ,p_phase IN VARCHAR2
2270: ,x_return_status OUT nocopy VARCHAR2
2271: ,x_msg_count OUT nocopy NUMBER

Line 2268: ,p_loan_rates_tbl IN OUT nocopy LNS_LOAN_PUB.LOAN_RATES_TBL_TYPE

2264:
2265:
2266:
2267: PROCEDURE validate_rate_sched(P_Loan_Details_Rec IN OUT NOCOPY LNS_LOAN_PUB.Loan_Details_Rec_Type
2268: ,p_loan_rates_tbl IN OUT nocopy LNS_LOAN_PUB.LOAN_RATES_TBL_TYPE
2269: ,p_phase IN VARCHAR2
2270: ,x_return_status OUT nocopy VARCHAR2
2271: ,x_msg_count OUT nocopy NUMBER
2272: ,x_msg_data OUT nocopy VARCHAR2)

Line 2430: procedure synchRateSchedule(p_rate_tbl IN OUT NOCOPY LNS_LOAN_PUB.LOAN_RATES_TBL_TYPE, p_num_installments in number)

2426:
2427: /*
2428: This procedure synchs rate schedule with new number of installments in memory only, no changes to db
2429: */
2430: procedure synchRateSchedule(p_rate_tbl IN OUT NOCOPY LNS_LOAN_PUB.LOAN_RATES_TBL_TYPE, p_num_installments in number)
2431:
2432: is
2433:
2434: /*-----------------------------------------------------------------------+

Line 2442: l_rate_tbl LNS_LOAN_PUB.LOAN_RATES_TBL_TYPE;

2438: l_RATE_ID number;
2439: l_BEGIN_INSTALLMENT number;
2440: l_END_INSTALLMENT number;
2441: i number;
2442: l_rate_tbl LNS_LOAN_PUB.LOAN_RATES_TBL_TYPE;
2443:
2444: /*-----------------------------------------------------------------------+
2445: | Cursor Declarations |
2446: +-----------------------------------------------------------------------*/

Line 2715: PROCEDURE validate_disbursements(P_Loan_Details_Rec IN OUT nocopy LNS_LOAN_PUB.loan_details_rec_type

2711:
2712:
2713:
2714:
2715: PROCEDURE validate_disbursements(P_Loan_Details_Rec IN OUT nocopy LNS_LOAN_PUB.loan_details_rec_type
2716: ,P_DISB_TBL IN OUT NOCOPY LNS_LOAN_PUB.Loan_Disb_Tbl_Type
2717: , x_return_status OUT nocopy VARCHAR2
2718: , x_msg_count OUT nocopy NUMBER
2719: , x_msg_data OUT nocopy VARCHAR2)

Line 2716: ,P_DISB_TBL IN OUT NOCOPY LNS_LOAN_PUB.Loan_Disb_Tbl_Type

2712:
2713:
2714:
2715: PROCEDURE validate_disbursements(P_Loan_Details_Rec IN OUT nocopy LNS_LOAN_PUB.loan_details_rec_type
2716: ,P_DISB_TBL IN OUT NOCOPY LNS_LOAN_PUB.Loan_Disb_Tbl_Type
2717: , x_return_status OUT nocopy VARCHAR2
2718: , x_msg_count OUT nocopy NUMBER
2719: , x_msg_data OUT nocopy VARCHAR2)
2720: IS

Line 2818: P_Loan_Details_Rec IN OUT NOCOPY LNS_LOAN_PUB.Loan_Details_Rec_Type, -- mandatory

2814: P_API_VERSION IN NUMBER,
2815: P_INIT_MSG_LIST IN VARCHAR2,
2816: P_COMMIT IN VARCHAR2,
2817: P_VALIDATION_LEVEL IN NUMBER,
2818: P_Loan_Details_Rec IN OUT NOCOPY LNS_LOAN_PUB.Loan_Details_Rec_Type, -- mandatory
2819: P_Loan_Lines_Tbl IN OUT NOCOPY LNS_LOAN_PUB.Loan_Lines_Tbl_Type, --only for ERS loan
2820: P_DISB_TBL IN OUT NOCOPY LNS_LOAN_PUB.Loan_Disb_Tbl_Type, -- only for direct loans
2821: P_LOAN_PART_TBL IN OUT NOCOPY LNS_LOAN_PUB.LOAN_PART_TBL_TYPE, -- optional
2822: P_OPEN_RATES_TBL IN OUT NOCOPY LNS_LOAN_PUB.LOAN_RATES_TBL_TYPE, -- optional

Line 2819: P_Loan_Lines_Tbl IN OUT NOCOPY LNS_LOAN_PUB.Loan_Lines_Tbl_Type, --only for ERS loan

2815: P_INIT_MSG_LIST IN VARCHAR2,
2816: P_COMMIT IN VARCHAR2,
2817: P_VALIDATION_LEVEL IN NUMBER,
2818: P_Loan_Details_Rec IN OUT NOCOPY LNS_LOAN_PUB.Loan_Details_Rec_Type, -- mandatory
2819: P_Loan_Lines_Tbl IN OUT NOCOPY LNS_LOAN_PUB.Loan_Lines_Tbl_Type, --only for ERS loan
2820: P_DISB_TBL IN OUT NOCOPY LNS_LOAN_PUB.Loan_Disb_Tbl_Type, -- only for direct loans
2821: P_LOAN_PART_TBL IN OUT NOCOPY LNS_LOAN_PUB.LOAN_PART_TBL_TYPE, -- optional
2822: P_OPEN_RATES_TBL IN OUT NOCOPY LNS_LOAN_PUB.LOAN_RATES_TBL_TYPE, -- optional
2823: P_TERM_RATES_TBL IN OUT NOCOPY LNS_LOAN_PUB.LOAN_RATES_TBL_TYPE, -- optional

Line 2820: P_DISB_TBL IN OUT NOCOPY LNS_LOAN_PUB.Loan_Disb_Tbl_Type, -- only for direct loans

2816: P_COMMIT IN VARCHAR2,
2817: P_VALIDATION_LEVEL IN NUMBER,
2818: P_Loan_Details_Rec IN OUT NOCOPY LNS_LOAN_PUB.Loan_Details_Rec_Type, -- mandatory
2819: P_Loan_Lines_Tbl IN OUT NOCOPY LNS_LOAN_PUB.Loan_Lines_Tbl_Type, --only for ERS loan
2820: P_DISB_TBL IN OUT NOCOPY LNS_LOAN_PUB.Loan_Disb_Tbl_Type, -- only for direct loans
2821: P_LOAN_PART_TBL IN OUT NOCOPY LNS_LOAN_PUB.LOAN_PART_TBL_TYPE, -- optional
2822: P_OPEN_RATES_TBL IN OUT NOCOPY LNS_LOAN_PUB.LOAN_RATES_TBL_TYPE, -- optional
2823: P_TERM_RATES_TBL IN OUT NOCOPY LNS_LOAN_PUB.LOAN_RATES_TBL_TYPE, -- optional
2824: p_loan_cust_sched_tbl IN OUT NOCOPY LNS_LOAN_PUB.loan_cust_sched_tbl_type, -- optional

Line 2821: P_LOAN_PART_TBL IN OUT NOCOPY LNS_LOAN_PUB.LOAN_PART_TBL_TYPE, -- optional

2817: P_VALIDATION_LEVEL IN NUMBER,
2818: P_Loan_Details_Rec IN OUT NOCOPY LNS_LOAN_PUB.Loan_Details_Rec_Type, -- mandatory
2819: P_Loan_Lines_Tbl IN OUT NOCOPY LNS_LOAN_PUB.Loan_Lines_Tbl_Type, --only for ERS loan
2820: P_DISB_TBL IN OUT NOCOPY LNS_LOAN_PUB.Loan_Disb_Tbl_Type, -- only for direct loans
2821: P_LOAN_PART_TBL IN OUT NOCOPY LNS_LOAN_PUB.LOAN_PART_TBL_TYPE, -- optional
2822: P_OPEN_RATES_TBL IN OUT NOCOPY LNS_LOAN_PUB.LOAN_RATES_TBL_TYPE, -- optional
2823: P_TERM_RATES_TBL IN OUT NOCOPY LNS_LOAN_PUB.LOAN_RATES_TBL_TYPE, -- optional
2824: p_loan_cust_sched_tbl IN OUT NOCOPY LNS_LOAN_PUB.loan_cust_sched_tbl_type, -- optional
2825: P_Application_id IN NUMBER,

Line 2822: P_OPEN_RATES_TBL IN OUT NOCOPY LNS_LOAN_PUB.LOAN_RATES_TBL_TYPE, -- optional

2818: P_Loan_Details_Rec IN OUT NOCOPY LNS_LOAN_PUB.Loan_Details_Rec_Type, -- mandatory
2819: P_Loan_Lines_Tbl IN OUT NOCOPY LNS_LOAN_PUB.Loan_Lines_Tbl_Type, --only for ERS loan
2820: P_DISB_TBL IN OUT NOCOPY LNS_LOAN_PUB.Loan_Disb_Tbl_Type, -- only for direct loans
2821: P_LOAN_PART_TBL IN OUT NOCOPY LNS_LOAN_PUB.LOAN_PART_TBL_TYPE, -- optional
2822: P_OPEN_RATES_TBL IN OUT NOCOPY LNS_LOAN_PUB.LOAN_RATES_TBL_TYPE, -- optional
2823: P_TERM_RATES_TBL IN OUT NOCOPY LNS_LOAN_PUB.LOAN_RATES_TBL_TYPE, -- optional
2824: p_loan_cust_sched_tbl IN OUT NOCOPY LNS_LOAN_PUB.loan_cust_sched_tbl_type, -- optional
2825: P_Application_id IN NUMBER,
2826: P_Created_by_module IN VARCHAR2,

Line 2823: P_TERM_RATES_TBL IN OUT NOCOPY LNS_LOAN_PUB.LOAN_RATES_TBL_TYPE, -- optional

2819: P_Loan_Lines_Tbl IN OUT NOCOPY LNS_LOAN_PUB.Loan_Lines_Tbl_Type, --only for ERS loan
2820: P_DISB_TBL IN OUT NOCOPY LNS_LOAN_PUB.Loan_Disb_Tbl_Type, -- only for direct loans
2821: P_LOAN_PART_TBL IN OUT NOCOPY LNS_LOAN_PUB.LOAN_PART_TBL_TYPE, -- optional
2822: P_OPEN_RATES_TBL IN OUT NOCOPY LNS_LOAN_PUB.LOAN_RATES_TBL_TYPE, -- optional
2823: P_TERM_RATES_TBL IN OUT NOCOPY LNS_LOAN_PUB.LOAN_RATES_TBL_TYPE, -- optional
2824: p_loan_cust_sched_tbl IN OUT NOCOPY LNS_LOAN_PUB.loan_cust_sched_tbl_type, -- optional
2825: P_Application_id IN NUMBER,
2826: P_Created_by_module IN VARCHAR2,
2827: X_LOAN_ID OUT NOCOPY NUMBER,

Line 2824: p_loan_cust_sched_tbl IN OUT NOCOPY LNS_LOAN_PUB.loan_cust_sched_tbl_type, -- optional

2820: P_DISB_TBL IN OUT NOCOPY LNS_LOAN_PUB.Loan_Disb_Tbl_Type, -- only for direct loans
2821: P_LOAN_PART_TBL IN OUT NOCOPY LNS_LOAN_PUB.LOAN_PART_TBL_TYPE, -- optional
2822: P_OPEN_RATES_TBL IN OUT NOCOPY LNS_LOAN_PUB.LOAN_RATES_TBL_TYPE, -- optional
2823: P_TERM_RATES_TBL IN OUT NOCOPY LNS_LOAN_PUB.LOAN_RATES_TBL_TYPE, -- optional
2824: p_loan_cust_sched_tbl IN OUT NOCOPY LNS_LOAN_PUB.loan_cust_sched_tbl_type, -- optional
2825: P_Application_id IN NUMBER,
2826: P_Created_by_module IN VARCHAR2,
2827: X_LOAN_ID OUT NOCOPY NUMBER,
2828: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 4324: END LNS_LOAN_PUB;

4320: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);
4321: end if;
4322:
4323: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
4324: END LNS_LOAN_PUB;