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_IMPORT_LOAN_PUB dependencies on LNS_IMPORT_LOAN_PUB

Line 1: PACKAGE BODY LNS_IMPORT_LOAN_PUB as

1: PACKAGE BODY LNS_IMPORT_LOAN_PUB as
2: /* $Header: LNS_IMPORT_LOAN_B.pls 120.5 2011/01/06 14:02:21 scherkas noship $ */
3:
4:
5: /*=======================================================================+

Line 8: g_pkg_name constant VARCHAR2(30) := 'LNS_IMPORT_LOAN_PUB';

4:
5: /*=======================================================================+
6: | Package Global Constants
7: +=======================================================================*/
8: g_pkg_name constant VARCHAR2(30) := 'LNS_IMPORT_LOAN_PUB';
9: g_log_enabled VARCHAR2(5);
10: g_msg_level NUMBER;
11: g_errors_rec Loan_create_errors_type := Loan_create_errors_type();
12: g_error_count number := 0;

Line 14: PROCEDURE validate_pay_history(P_Loan_Details_Rec IN OUT nocopy lns_import_loan_pub.loan_details_rec_type

10: g_msg_level NUMBER;
11: g_errors_rec Loan_create_errors_type := Loan_create_errors_type();
12: g_error_count number := 0;
13:
14: PROCEDURE validate_pay_history(P_Loan_Details_Rec IN OUT nocopy lns_import_loan_pub.loan_details_rec_type
15: ,P_PAY_HIST_TBL IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.PAYMENT_HIST_TBL_TYPE
16: , x_return_status OUT nocopy VARCHAR2
17: , x_msg_count OUT nocopy NUMBER
18: , x_msg_data OUT nocopy VARCHAR2);

Line 15: ,P_PAY_HIST_TBL IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.PAYMENT_HIST_TBL_TYPE

11: g_errors_rec Loan_create_errors_type := Loan_create_errors_type();
12: g_error_count number := 0;
13:
14: PROCEDURE validate_pay_history(P_Loan_Details_Rec IN OUT nocopy lns_import_loan_pub.loan_details_rec_type
15: ,P_PAY_HIST_TBL IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.PAYMENT_HIST_TBL_TYPE
16: , x_return_status OUT nocopy VARCHAR2
17: , x_msg_count OUT nocopy NUMBER
18: , x_msg_data OUT nocopy VARCHAR2);
19:

Line 20: PROCEDURE validate_disbursements(P_Loan_Details_Rec IN OUT nocopy lns_import_loan_pub.loan_details_rec_type

16: , x_return_status OUT nocopy VARCHAR2
17: , x_msg_count OUT nocopy NUMBER
18: , x_msg_data OUT nocopy VARCHAR2);
19:
20: PROCEDURE validate_disbursements(P_Loan_Details_Rec IN OUT nocopy lns_import_loan_pub.loan_details_rec_type
21: ,P_DISB_TBL IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.Loan_Disb_Tbl_Type
22: , x_return_status OUT nocopy VARCHAR2
23: , x_msg_count OUT nocopy NUMBER
24: , x_msg_data OUT nocopy VARCHAR2);

Line 21: ,P_DISB_TBL IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.Loan_Disb_Tbl_Type

17: , x_msg_count OUT nocopy NUMBER
18: , x_msg_data OUT nocopy VARCHAR2);
19:
20: PROCEDURE validate_disbursements(P_Loan_Details_Rec IN OUT nocopy lns_import_loan_pub.loan_details_rec_type
21: ,P_DISB_TBL IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.Loan_Disb_Tbl_Type
22: , x_return_status OUT nocopy VARCHAR2
23: , x_msg_count OUT nocopy NUMBER
24: , x_msg_data OUT nocopy VARCHAR2);
25:

Line 139: PROCEDURE validate_pay_history(P_Loan_Details_Rec IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.Loan_Details_Rec_Type

135: END;
136:
137:
138:
139: PROCEDURE validate_pay_history(P_Loan_Details_Rec IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.Loan_Details_Rec_Type
140: ,P_PAY_HIST_TBL IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.PAYMENT_HIST_TBL_TYPE
141: , x_return_status OUT nocopy VARCHAR2
142: , x_msg_count OUT nocopy NUMBER
143: , x_msg_data OUT nocopy VARCHAR2)

Line 140: ,P_PAY_HIST_TBL IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.PAYMENT_HIST_TBL_TYPE

136:
137:
138:
139: PROCEDURE validate_pay_history(P_Loan_Details_Rec IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.Loan_Details_Rec_Type
140: ,P_PAY_HIST_TBL IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.PAYMENT_HIST_TBL_TYPE
141: , x_return_status OUT nocopy VARCHAR2
142: , x_msg_count OUT nocopy NUMBER
143: , x_msg_data OUT nocopy VARCHAR2)
144: IS

Line 148: l_temp LNS_IMPORT_LOAN_PUB.PAYMENT_HIST_REC_TYPE;

144: IS
145: l_api_name constant VARCHAR2(30) := 'VALIDATE_PAY_HISTORY';
146: i NUMBER;
147: j NUMBER;
148: l_temp LNS_IMPORT_LOAN_PUB.PAYMENT_HIST_REC_TYPE;
149: l_tem_pay_hist_tbl LNS_IMPORT_LOAN_PUB.PAYMENT_HIST_TBL_TYPE;
150:
151: BEGIN
152: logmessage(fnd_log.level_procedure, g_pkg_name || '.' || l_api_name || ' +');

Line 149: l_tem_pay_hist_tbl LNS_IMPORT_LOAN_PUB.PAYMENT_HIST_TBL_TYPE;

145: l_api_name constant VARCHAR2(30) := 'VALIDATE_PAY_HISTORY';
146: i NUMBER;
147: j NUMBER;
148: l_temp LNS_IMPORT_LOAN_PUB.PAYMENT_HIST_REC_TYPE;
149: l_tem_pay_hist_tbl LNS_IMPORT_LOAN_PUB.PAYMENT_HIST_TBL_TYPE;
150:
151: BEGIN
152: logmessage(fnd_log.level_procedure, g_pkg_name || '.' || l_api_name || ' +');
153:

Line 349: PROCEDURE validate_disbursements(P_Loan_Details_Rec IN OUT nocopy lns_import_loan_pub.loan_details_rec_type

345: END;
346:
347:
348:
349: PROCEDURE validate_disbursements(P_Loan_Details_Rec IN OUT nocopy lns_import_loan_pub.loan_details_rec_type
350: ,P_DISB_TBL IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.Loan_Disb_Tbl_Type
351: , x_return_status OUT nocopy VARCHAR2
352: , x_msg_count OUT nocopy NUMBER
353: , x_msg_data OUT nocopy VARCHAR2)

Line 350: ,P_DISB_TBL IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.Loan_Disb_Tbl_Type

346:
347:
348:
349: PROCEDURE validate_disbursements(P_Loan_Details_Rec IN OUT nocopy lns_import_loan_pub.loan_details_rec_type
350: ,P_DISB_TBL IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.Loan_Disb_Tbl_Type
351: , x_return_status OUT nocopy VARCHAR2
352: , x_msg_count OUT nocopy NUMBER
353: , x_msg_data OUT nocopy VARCHAR2)
354: IS

Line 509: P_Loan_Details_Rec IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.Loan_Details_Rec_Type, -- mandatory

505: P_API_VERSION IN NUMBER,
506: P_INIT_MSG_LIST IN VARCHAR2,
507: P_COMMIT IN VARCHAR2,
508: P_VALIDATION_LEVEL IN NUMBER,
509: P_Loan_Details_Rec IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.Loan_Details_Rec_Type, -- mandatory
510: P_Loan_Lines_Tbl IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.Loan_Lines_Tbl_Type, -- mandatory for ERS loans
511: P_DISB_TBL IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.Loan_Disb_Tbl_Type, -- mandatory for direct loans
512: P_LOAN_PART_TBL IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.LOAN_PART_TBL_TYPE, -- optional
513: P_LOAN_RATES_TBL IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.LOAN_RATES_TBL_TYPE, -- mandatory

Line 510: P_Loan_Lines_Tbl IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.Loan_Lines_Tbl_Type, -- mandatory for ERS loans

506: P_INIT_MSG_LIST IN VARCHAR2,
507: P_COMMIT IN VARCHAR2,
508: P_VALIDATION_LEVEL IN NUMBER,
509: P_Loan_Details_Rec IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.Loan_Details_Rec_Type, -- mandatory
510: P_Loan_Lines_Tbl IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.Loan_Lines_Tbl_Type, -- mandatory for ERS loans
511: P_DISB_TBL IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.Loan_Disb_Tbl_Type, -- mandatory for direct loans
512: P_LOAN_PART_TBL IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.LOAN_PART_TBL_TYPE, -- optional
513: P_LOAN_RATES_TBL IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.LOAN_RATES_TBL_TYPE, -- mandatory
514: p_loan_cust_sched_tbl IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.loan_cust_sched_tbl_type, -- optional

Line 511: P_DISB_TBL IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.Loan_Disb_Tbl_Type, -- mandatory for direct loans

507: P_COMMIT IN VARCHAR2,
508: P_VALIDATION_LEVEL IN NUMBER,
509: P_Loan_Details_Rec IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.Loan_Details_Rec_Type, -- mandatory
510: P_Loan_Lines_Tbl IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.Loan_Lines_Tbl_Type, -- mandatory for ERS loans
511: P_DISB_TBL IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.Loan_Disb_Tbl_Type, -- mandatory for direct loans
512: P_LOAN_PART_TBL IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.LOAN_PART_TBL_TYPE, -- optional
513: P_LOAN_RATES_TBL IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.LOAN_RATES_TBL_TYPE, -- mandatory
514: p_loan_cust_sched_tbl IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.loan_cust_sched_tbl_type, -- optional
515: p_distribution_tbl IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.distribution_tbl, -- optional

Line 512: P_LOAN_PART_TBL IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.LOAN_PART_TBL_TYPE, -- optional

508: P_VALIDATION_LEVEL IN NUMBER,
509: P_Loan_Details_Rec IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.Loan_Details_Rec_Type, -- mandatory
510: P_Loan_Lines_Tbl IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.Loan_Lines_Tbl_Type, -- mandatory for ERS loans
511: P_DISB_TBL IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.Loan_Disb_Tbl_Type, -- mandatory for direct loans
512: P_LOAN_PART_TBL IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.LOAN_PART_TBL_TYPE, -- optional
513: P_LOAN_RATES_TBL IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.LOAN_RATES_TBL_TYPE, -- mandatory
514: p_loan_cust_sched_tbl IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.loan_cust_sched_tbl_type, -- optional
515: p_distribution_tbl IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.distribution_tbl, -- optional
516: P_PAY_HIST_TBL IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.PAYMENT_HIST_TBL_TYPE, -- optional

Line 513: P_LOAN_RATES_TBL IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.LOAN_RATES_TBL_TYPE, -- mandatory

509: P_Loan_Details_Rec IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.Loan_Details_Rec_Type, -- mandatory
510: P_Loan_Lines_Tbl IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.Loan_Lines_Tbl_Type, -- mandatory for ERS loans
511: P_DISB_TBL IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.Loan_Disb_Tbl_Type, -- mandatory for direct loans
512: P_LOAN_PART_TBL IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.LOAN_PART_TBL_TYPE, -- optional
513: P_LOAN_RATES_TBL IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.LOAN_RATES_TBL_TYPE, -- mandatory
514: p_loan_cust_sched_tbl IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.loan_cust_sched_tbl_type, -- optional
515: p_distribution_tbl IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.distribution_tbl, -- optional
516: P_PAY_HIST_TBL IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.PAYMENT_HIST_TBL_TYPE, -- optional
517: X_LOAN_ID OUT NOCOPY NUMBER,

Line 514: p_loan_cust_sched_tbl IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.loan_cust_sched_tbl_type, -- optional

510: P_Loan_Lines_Tbl IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.Loan_Lines_Tbl_Type, -- mandatory for ERS loans
511: P_DISB_TBL IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.Loan_Disb_Tbl_Type, -- mandatory for direct loans
512: P_LOAN_PART_TBL IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.LOAN_PART_TBL_TYPE, -- optional
513: P_LOAN_RATES_TBL IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.LOAN_RATES_TBL_TYPE, -- mandatory
514: p_loan_cust_sched_tbl IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.loan_cust_sched_tbl_type, -- optional
515: p_distribution_tbl IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.distribution_tbl, -- optional
516: P_PAY_HIST_TBL IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.PAYMENT_HIST_TBL_TYPE, -- optional
517: X_LOAN_ID OUT NOCOPY NUMBER,
518: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 515: p_distribution_tbl IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.distribution_tbl, -- optional

511: P_DISB_TBL IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.Loan_Disb_Tbl_Type, -- mandatory for direct loans
512: P_LOAN_PART_TBL IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.LOAN_PART_TBL_TYPE, -- optional
513: P_LOAN_RATES_TBL IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.LOAN_RATES_TBL_TYPE, -- mandatory
514: p_loan_cust_sched_tbl IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.loan_cust_sched_tbl_type, -- optional
515: p_distribution_tbl IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.distribution_tbl, -- optional
516: P_PAY_HIST_TBL IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.PAYMENT_HIST_TBL_TYPE, -- optional
517: X_LOAN_ID OUT NOCOPY NUMBER,
518: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
519: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 516: P_PAY_HIST_TBL IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.PAYMENT_HIST_TBL_TYPE, -- optional

512: P_LOAN_PART_TBL IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.LOAN_PART_TBL_TYPE, -- optional
513: P_LOAN_RATES_TBL IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.LOAN_RATES_TBL_TYPE, -- mandatory
514: p_loan_cust_sched_tbl IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.loan_cust_sched_tbl_type, -- optional
515: p_distribution_tbl IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.distribution_tbl, -- optional
516: P_PAY_HIST_TBL IN OUT NOCOPY LNS_IMPORT_LOAN_PUB.PAYMENT_HIST_TBL_TYPE, -- optional
517: X_LOAN_ID OUT NOCOPY NUMBER,
518: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
519: X_MSG_COUNT OUT NOCOPY NUMBER,
520: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 560: l_LOAN_RATES_REC LNS_IMPORT_LOAN_PUB.LOAN_RATES_REC_TYPE;

556: l_bill_lines_tbl lns_billing_batch_pub.bill_lines_tbl;
557: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
558: l_OPEN_RATES_TBL LNS_LOAN_PUB.LOAN_RATES_TBL_TYPE;
559: l_loan_cust_sched_tbl LNS_LOAN_PUB.loan_cust_sched_tbl_type;
560: l_LOAN_RATES_REC LNS_IMPORT_LOAN_PUB.LOAN_RATES_REC_TYPE;
561: l_distribution_tbl lns_distributions_pub.distribution_tbl;
562: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
563: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
564: l_DISB_TBL LNS_LOAN_PUB.Loan_Disb_Tbl_Type;