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_DISTRIBUTIONS_PUB dependencies on LNS_LOAN_HEADER_PUB

Line 57: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;

53: l_packet_id number;
54: l_msg_count number;
55: l_msg_data VARCHAR2(2000);
56: l_version number;
57: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
58: l_disbursement_id number;
59:
60: cursor c_events(p_loan_id number) is
61: select event_id

Line 515: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;

511: l_budget_req_approval varchar2(1);
512: l_funds_reserved_flag varchar2(1);
513: l_gl_date date;
514: l_budget_event_exists number;
515: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
516: l_disbursement_id number;
517: x_event_id number;
518:
519: cursor c_budget_req(p_loan_id number) is

Line 767: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_version

763:
764: l_loan_header_rec.loan_id := p_loan_id;
765: l_loan_header_rec.FUNDS_CHECK_DATE := sysdate;
766: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - updating loan');
767: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_version
768: ,P_LOAN_HEADER_REC => l_loan_header_rec
769: ,P_INIT_MSG_LIST => FND_API.G_FALSE
770: ,X_RETURN_STATUS => l_return_status
771: ,X_MSG_COUNT => l_msg_count

Line 4122: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;

4118: l_percent number;
4119: l_subsidy_rate number;
4120: l_loan_class varchar2(30);
4121: l_loan_type_id number;
4122: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
4123: adj_info xla_events_pub_pkg.t_event_source_info;
4124: inv_info xla_events_pub_pkg.t_event_source_info;
4125: l_adjustment_id number;
4126: l_customer_trx_id number;

Line 4414: -- in API LNS_LOAN_HEADER_PUB.do_create_loan.

4410:
4411:
4412: /*
4413: -- Bug#6711399 Subsidy_rate defaulted from loanProduct to loan at the time of loanCreation
4414: -- in API LNS_LOAN_HEADER_PUB.do_create_loan.
4415:
4416: -- we are creating accounting for DIRECT loan class
4417: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' fetching subsidy rate');
4418: begin

Line 4438: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_version

4434:
4435: l_loan_header_rec.subsidy_rate := l_subsidy_rate;
4436: l_loan_header_rec.loan_id := p_loan_id;
4437: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || 'updating loan');
4438: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_version
4439: ,P_LOAN_HEADER_REC => l_loan_header_rec
4440: ,P_INIT_MSG_LIST => p_init_msg_list
4441: ,X_RETURN_STATUS => l_return_status
4442: ,X_MSG_COUNT => l_msg_count

Line 5352: l_loan_header_rec LNS_LOAN_HEADER_PUB.LOAN_HEADER_REC_TYPE;

5348: l_msg_data VARCHAR2(2000);
5349: l_return_Status VARCHAR2(1);
5350: x_event_id number;
5351: l_object_version_number number;
5352: l_loan_header_rec LNS_LOAN_HEADER_PUB.LOAN_HEADER_REC_TYPE;
5353: l_return boolean;
5354: l_do_billing number;
5355: l_last_api_called varchar2(100);
5356: l_request_id number;

Line 5472: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Before call to LNS_LOAN_HEADER_PUB.update_loan');

5468: -- finally update the loan header
5469: l_loan_header_rec.loan_id := P_LOAN_ID;
5470: l_loan_header_rec.loan_status := 'ACTIVE';
5471: l_loan_header_rec.secondary_status := FND_API.G_MISS_CHAR;
5472: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Before call to LNS_LOAN_HEADER_PUB.update_loan');
5473: LNS_LOAN_HEADER_PUB.update_loan(p_init_msg_list => FND_API.G_FALSE
5474: ,p_loan_header_rec => l_loan_header_rec
5475: ,p_object_version_number => l_object_version_number
5476: ,x_return_status => l_return_status

Line 5473: LNS_LOAN_HEADER_PUB.update_loan(p_init_msg_list => FND_API.G_FALSE

5469: l_loan_header_rec.loan_id := P_LOAN_ID;
5470: l_loan_header_rec.loan_status := 'ACTIVE';
5471: l_loan_header_rec.secondary_status := FND_API.G_MISS_CHAR;
5472: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Before call to LNS_LOAN_HEADER_PUB.update_loan');
5473: LNS_LOAN_HEADER_PUB.update_loan(p_init_msg_list => FND_API.G_FALSE
5474: ,p_loan_header_rec => l_loan_header_rec
5475: ,p_object_version_number => l_object_version_number
5476: ,x_return_status => l_return_status
5477: ,x_msg_count => l_msg_count

Line 5965: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;

5961: l_budget_req_approval varchar2(1);
5962: l_funds_reserved_flag varchar2(1);
5963: l_gl_date date;
5964: l_budget_event_exists number;
5965: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
5966: l_loan_id number;
5967: l_loan_amount_adj_id number;
5968: l_adj_status varchar2(30);
5969: l_adj_amount number;

Line 6281: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_version

6277:
6278: l_loan_header_rec.loan_id := p_loan_id;
6279: l_loan_header_rec.FUNDS_CHECK_DATE := sysdate;
6280: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || 'updating loan');
6281: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_version
6282: ,P_LOAN_HEADER_REC => l_loan_header_rec
6283: ,P_INIT_MSG_LIST => FND_API.G_FALSE
6284: ,X_RETURN_STATUS => l_return_status
6285: ,X_MSG_COUNT => l_msg_count

Line 7639: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;

7635: l_packet_id number;
7636: l_msg_count number;
7637: l_msg_data VARCHAR2(2000);
7638: l_version number;
7639: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
7640: l_event_type_code VARCHAR2(30);
7641: l_PAYMENT_REQUEST_DATE date;
7642:
7643: cursor c_events(p_loan_id number) is