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_CUSTOM_PUB dependencies on LNS_LOAN_HEADERS_ALL

Line 111: FROM lns_loan_headers_all h

107: l_skip_update boolean;
108:
109: cursor c_customized (p_loan_id number) is
110: SELECT nvl(h.custom_payments_flag, 'N')
111: FROM lns_loan_headers_all h
112: WHERE loan_id = p_loan_id;
113:
114: begin
115:

Line 141: ,p_table_name => 'LNS_LOAN_HEADERS_ALL');

137: ,x_msg_data => l_msg_data
138: ,x_return_status => l_return_status
139: ,p_col_id => p_loan_id
140: ,p_col_name => 'LOAN_ID'
141: ,p_table_name => 'LNS_LOAN_HEADERS_ALL');
142:
143: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
144: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
145: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');

Line 188: from lns_loan_headers_all

184:
185: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - resetting header');
186: if p_update_header and not l_skip_update then
187: select object_version_number into l_object_version
188: from lns_loan_headers_all
189: where loan_id = p_loan_id;
190: l_loan_header_rec.loan_id := p_loan_id;
191: l_loan_header_rec.custom_payments_flag := 'N';
192: lns_loan_header_pub.update_loan(p_init_msg_list => FND_API.G_FALSE

Line 506: from lns_loan_headers_all

502:
503: -- if we get this far now we update the header table flag for custom payments
504: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - attempting to update header set custom = Y');
505: select object_version_number into l_object_version
506: from lns_loan_headers_all
507: where loan_id = p_loan_id;
508: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_object_version ' || l_object_version);
509:
510: l_loan_header_rec.loan_id := p_loan_id;

Line 1641: FROM lns_loan_headers_all h

1637: ,nvl(t.REAMORTIZE_ON_FUNDING, 'REST')
1638: ,nvl(h.ADD_REQUESTED_AMOUNT, 0)
1639: ,CUSTOM_SCHED_DESC
1640: ,nvl(t.CAPITALIZE_INT, 'N')
1641: FROM lns_loan_headers_all h
1642: ,lns_terms t
1643: ,fnd_currencies curr
1644: WHERE h.loan_id = p_loan_id
1645: AND h.loan_id = t.loan_id

Line 2236: from lns_loan_headers_all loan

2232: cursor c_fund_sched_exist(p_loan_id number) is
2233: select decode(loan.loan_class_code,
2234: 'DIRECT', (select count(1) from lns_disb_headers where loan_id = p_loan_id and status is null and PAYMENT_REQUEST_DATE is not null),
2235: 'ERS', (select count(1) from lns_loan_lines where loan_id = p_loan_id and (status is null or status = 'PENDING') and end_date is null))
2236: from lns_loan_headers_all loan
2237: where loan.loan_id = p_loan_id;
2238:
2239: cursor c_get_bill_opt(p_loan_id number) is
2240: select nvl(BILL_ON_APPR_AMOUNT_FLAG, 'N')

Line 2241: from lns_loan_headers_all

2237: where loan.loan_id = p_loan_id;
2238:
2239: cursor c_get_bill_opt(p_loan_id number) is
2240: select nvl(BILL_ON_APPR_AMOUNT_FLAG, 'N')
2241: from lns_loan_headers_all
2242: where loan_id = p_loan_id;
2243:
2244: BEGIN
2245:

Line 3530: lns_loan_headers_all loan,

3526: CURSOR last_billed_due_date_cur(P_LOAN_ID NUMBER) IS
3527: SELECT trunc(max(DUE_DATE)),
3528: max(term.first_payment_date)
3529: FROM lns_amortization_scheds am,
3530: lns_loan_headers_all loan,
3531: lns_terms term
3532: WHERE loan.loan_id = P_LOAN_ID
3533: AND loan.loan_id = term.loan_id
3534: AND loan.loan_id = am.loan_id(+)

Line 3645: -- getting info from lns_loan_headers_all

3641: end if;
3642:
3643: if l_custom_tbl(i).ACTION = 'U' and l_custom_tbl(i).CUSTOM_SCHEDULE_ID is not null then
3644:
3645: -- getting info from lns_loan_headers_all
3646: select object_version_number
3647: into l_custom_rec.OBJECT_VERSION_NUMBER
3648: from LNS_CUSTOM_PAYMNT_SCHEDS
3649: where loan_id = p_loan_id and

Line 3714: -- getting info from lns_loan_headers_all

3710: for i in 1..l_custom_tbl.count loop
3711: l_custom_tbl(i).ACTION := null;
3712: end loop;
3713:
3714: -- getting info from lns_loan_headers_all
3715: select object_version_number
3716: into l_object_version
3717: from lns_loan_headers_all
3718: where loan_id = p_loan_id;

Line 3717: from lns_loan_headers_all

3713:
3714: -- getting info from lns_loan_headers_all
3715: select object_version_number
3716: into l_object_version
3717: from lns_loan_headers_all
3718: where loan_id = p_loan_id;
3719:
3720: -- update lns_loan_headers_all only if loan is not custom yet
3721: if l_loan_details.CUSTOM_SCHEDULE = 'N' or l_loan_header_rec.BILLED_FLAG is not null then

Line 3720: -- update lns_loan_headers_all only if loan is not custom yet

3716: into l_object_version
3717: from lns_loan_headers_all
3718: where loan_id = p_loan_id;
3719:
3720: -- update lns_loan_headers_all only if loan is not custom yet
3721: if l_loan_details.CUSTOM_SCHEDULE = 'N' or l_loan_header_rec.BILLED_FLAG is not null then
3722: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating lns_loan_headers_all w following values:');
3723: l_loan_header_rec.loan_id := P_LOAN_ID;
3724: l_loan_header_rec.CUSTOM_PAYMENTS_FLAG := 'Y';

Line 3722: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating lns_loan_headers_all w following values:');

3718: where loan_id = p_loan_id;
3719:
3720: -- update lns_loan_headers_all only if loan is not custom yet
3721: if l_loan_details.CUSTOM_SCHEDULE = 'N' or l_loan_header_rec.BILLED_FLAG is not null then
3722: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating lns_loan_headers_all w following values:');
3723: l_loan_header_rec.loan_id := P_LOAN_ID;
3724: l_loan_header_rec.CUSTOM_PAYMENTS_FLAG := 'Y';
3725:
3726: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'CUSTOM_PAYMENTS_FLAG = ' || l_loan_header_rec.CUSTOM_PAYMENTS_FLAG);

Line 3739: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully updated lns_loan_headers_all');

3735:
3736: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);
3737:
3738: IF l_return_status = 'S' THEN
3739: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully updated lns_loan_headers_all');
3740: ELSE
3741: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
3742: FND_MSG_PUB.Add;
3743: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

Line 3936: -- getting info from lns_loan_headers_all

3932:
3933: delete from LNS_CUSTOM_PAYMNT_SCHEDS
3934: where loan_id = p_loan_id;
3935: /*
3936: -- getting info from lns_loan_headers_all
3937: select object_version_number
3938: into l_object_version
3939: from lns_loan_headers_all
3940: where loan_id = p_loan_id;

Line 3939: from lns_loan_headers_all

3935: /*
3936: -- getting info from lns_loan_headers_all
3937: select object_version_number
3938: into l_object_version
3939: from lns_loan_headers_all
3940: where loan_id = p_loan_id;
3941:
3942: -- update lns_loan_headers_all only if loan is not custom yet
3943: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating lns_loan_headers_all set custom = N');

Line 3942: -- update lns_loan_headers_all only if loan is not custom yet

3938: into l_object_version
3939: from lns_loan_headers_all
3940: where loan_id = p_loan_id;
3941:
3942: -- update lns_loan_headers_all only if loan is not custom yet
3943: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating lns_loan_headers_all set custom = N');
3944: l_loan_header_rec.loan_id := P_LOAN_ID;
3945: l_loan_header_rec.CUSTOM_PAYMENTS_FLAG := 'N';
3946:

Line 3943: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating lns_loan_headers_all set custom = N');

3939: from lns_loan_headers_all
3940: where loan_id = p_loan_id;
3941:
3942: -- update lns_loan_headers_all only if loan is not custom yet
3943: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating lns_loan_headers_all set custom = N');
3944: l_loan_header_rec.loan_id := P_LOAN_ID;
3945: l_loan_header_rec.CUSTOM_PAYMENTS_FLAG := 'N';
3946:
3947: lns_loan_header_pub.update_loan(p_init_msg_list => FND_API.G_TRUE

Line 3957: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully updated lns_loan_headers_all');

3953:
3954: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'l_return_status: ' || l_return_status);
3955:
3956: IF l_return_status = 'S' THEN
3957: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully updated lns_loan_headers_all');
3958: ELSE
3959: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
3960: FND_MSG_PUB.Add;
3961: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

Line 4177: from lns_loan_headers_all lh

4173: from lns_terms
4174: where loan_id = P_LOAN_ID;
4175: */
4176: select lh.loan_status into l_loan_status
4177: from lns_loan_headers_all lh
4178: where lh.loan_id = P_LOAN_ID;
4179:
4180: if(l_loan_status = 'INCOMPLETE' or l_loan_status = 'PENDING') then
4181: l_BASED_ON_TERMS := 'ORIGINAL';