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_FEE_ENGINE dependencies on LNS_FEE_SCHEDULES

Line 333: update lns_fee_schedules

329: l_return_status := FND_API.G_RET_STS_SUCCESS;
330: /* - Bug#6961250 Commented bcoz the above code is commented, so that the
331: FeeSchedule is not billed and its flag doesn't be a billedFlag.
332: if l_return_status = FND_API.G_RET_STS_SUCCESS then
333: update lns_fee_schedules
334: set billed_flag = 'Y'
335: where disb_header_id = p_disb_head_id;
336: end if;
337: */

Line 428: from lns_fee_schedules sched

424: -- need to get the max (amortization_id) in case of multiple credits
425: cursor c_manual_fees (p_loan_id number, p_installment number) is
426: select sched.fee_id
427: ,sched.fee_description
428: from lns_fee_schedules sched
429: ,lns_fees fees
430: ,lns_amortization_lines lines
431: ,lns_amortization_scheds am
432: where fees.fee_id = sched.fee_id

Line 1398: from lns_fee_schedules sched

1394: ,struct.fee_description
1395: ,sched.fee_waivable_flag -- should be struct right
1396: ,decode(struct.fee_category, 'MANUAL', 'Y', 'N')
1397: ,nvl(struct.fee_editable_flag, 'N')
1398: from lns_fee_schedules sched
1399: ,lns_fees struct
1400: where sched.loan_id = p_loan_id
1401: and sched.fee_id = struct.fee_id
1402: and fee_installment = p_installment

Line 1433: from lns_fee_schedules sched

1429: select sched.fee_id
1430: ,sched.fee_amount - nvl(sched.waived_amount, 0)
1431: ,struct.fee_name
1432: ,struct.fee_description
1433: from lns_fee_schedules sched
1434: ,lns_fees_all struct
1435: where disb_header_id = p_disb_header_id
1436: and sched.fee_id = struct.fee_id;
1437:

Line 1947: from lns_fee_schedules

1943: i number;
1944:
1945: cursor c_fee_schedule_id (p_loan_id number, p_fee_id number) is
1946: select fee_schedule_id
1947: from lns_fee_schedules
1948: where loan_id = p_loan_id
1949: and fee_id = p_fee_id
1950: and billed_flag = 'N'
1951: and active_flag = 'Y';

Line 2079: LNS_FEE_SCHEDULES_PKG.UPDATE_ROW(P_FEE_SCHEDULE_ID => l_fee_schedule_id

2075: l_fee_schedule_id := p_fees_tbl(k).FEE_SCHEDULE_ID;
2076:
2077: end if;
2078: -- fee structure has been validated write to the fee schedule
2079: LNS_FEE_SCHEDULES_PKG.UPDATE_ROW(P_FEE_SCHEDULE_ID => l_fee_schedule_id
2080: ,P_FEE_ID => p_fees_tbl(k).FEE_ID
2081: ,P_LOAN_ID => p_loan_id
2082: ,P_FEE_AMOUNT => round(p_fees_tbl(k).FEE_AMOUNT,l_precision)
2083: ,P_FEE_INSTALLMENT => p_fees_tbl(k).FEE_INSTALLMENT

Line 2287: LNS_FEE_SCHEDULES_PKG.INSERT_ROW(X_FEE_SCHEDULE_ID => l_fee_schedule_id

2283: into l_fee_schedule_id
2284: from dual;
2285:
2286: -- fee structure has been validated write to the fee schedule
2287: LNS_FEE_SCHEDULES_PKG.INSERT_ROW(X_FEE_SCHEDULE_ID => l_fee_schedule_id
2288: ,P_FEE_ID => p_fees_tbl(k).FEE_ID
2289: ,P_LOAN_ID => p_loan_id
2290: ,P_FEE_AMOUNT => round(p_fees_tbl(k).FEE_AMOUNT, l_loan_details.currency_precision)
2291: ,P_FEE_INSTALLMENT => p_fees_tbl(k).FEE_INSTALLMENT

Line 2404: from lns_fee_schedules sched

2400: l_processed_fees number;
2401:
2402: cursor c_processed(p_loan_id number, p_installment number, p_category varchar2, p_type varchar2) is
2403: select nvl(sum(fee_amount), 0)
2404: from lns_fee_schedules sched
2405: ,lns_fees fees
2406: where sched.loan_id = p_loan_id
2407: and sched.fee_id = fees.fee_id
2408: and sched.fee_installment = p_installment

Line 2597: from lns_fee_schedules sched

2593: -- waived_amount cannot be > fee_amount less any previously waived amount
2594: cursor c_fee_waive_amount(p_fee_schedule_id number) is
2595: select sched.fee_amount - nvl(sched.waived_amount, 0) amount_remaining
2596: ,nvl(sched.waived_amount, 0) previously_waived
2597: from lns_fee_schedules sched
2598: where sched.loan_id = p_loan_id
2599: and sched.fee_schedule_id = p_fee_schedule_id
2600: and sched.fee_waivable_flag = 'Y'
2601: and sched.active_flag = 'Y'

Line 2647: ,p_table_name => 'LNS_FEE_SCHEDULES');

2643: ,x_msg_data => l_msg_data
2644: ,x_return_status => l_return_status
2645: ,p_col_id => p_fee_schedule_id
2646: ,p_col_name => 'FEE_SCHEDULE_ID'
2647: ,p_table_name => 'LNS_FEE_SCHEDULES');
2648:
2649: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2650: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2651: FND_MESSAGE.SET_TOKEN('PARAMETER', 'FEE_SCHEDULE_ID');

Line 2677: lns_fee_schedules_pkg.update_row(P_FEE_SCHEDULE_ID => p_fee_schedule_id

2673: end if;
2674:
2675: -- fee is valid and waive amount is valid. update the fee schedule
2676: -- check on updating object_version_number
2677: lns_fee_schedules_pkg.update_row(P_FEE_SCHEDULE_ID => p_fee_schedule_id
2678: ,P_FEE_ID => null
2679: ,P_LOAN_ID => p_loan_id
2680: ,P_FEE_AMOUNT => null
2681: ,P_FEE_INSTALLMENT => null

Line 2779: ' from lns_fee_schedules sched ' ||

2775: begin
2776: l_api_name := 'getFeesTotal';
2777:
2778: vPLSQL := 'SELECT decode(:p_waived_flag, ''Y'', nvl(sum(sched.waived_amount),0), nvl(sum(sched.fee_amount) - sum(sched.waived_amount),0))' ||
2779: ' from lns_fee_schedules sched ' ||
2780: --' ,lns_fee_assignments assign ' ||
2781: --' where assgn.fee_id = sched.fee_id ' ||
2782: ' Where sched.loan_id = :p_loan_id ' ||
2783: ' and sched.billed_flag = :p_billed_flag ' ||

Line 2820: || write them to the lns_fee_schedules

2816: || PUBLIC PROCEDURE processLateFees
2817: ||
2818: || DESCRIPTION
2819: || Overview: this procedure will determine late fees, calculate them and
2820: || write them to the lns_fee_schedules
2821: || PSEUDO CODE/LOGIC
2822: ||
2823: || PARAMETERS
2824: || Parameter: p_loan_id => loan_id

Line 2929: ' from lns_fee_schedules sched ' ||

2925: ' am.reversed_flag <> ''Y'' and ' ||
2926: ' am.due_date + nvl(fees.number_grace_days, 0) < trunc(sysdate) ' ||
2927: ' and (not exists ' ||
2928: ' (select ''X'' ' ||
2929: ' from lns_fee_schedules sched ' ||
2930: ' where sched.loan_id = am.loan_id ' ||
2931: ' and fee_id = fees.fee_id ' ||
2932: ' and fee_installment = am.payment_number + 1' ||
2933: ' and billed_flag = ''N'' ' ||

Line 3076: from lns_fee_schedules

3072: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_LOAN_ID ' || p_loan_id);
3073: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_BORROWER_ID ' || p_borrower_id);
3074:
3075: select count(1) into l_fee_records1
3076: from lns_fee_schedules
3077: where active_flag = 'Y'
3078: and billed_flag = 'N';
3079:
3080: if p_loan_id is not null then

Line 3131: from lns_fee_schedules

3127:
3128: end if;
3129:
3130: select count(1) into l_fee_records2
3131: from lns_fee_schedules
3132: where active_flag = 'Y'
3133: and billed_flag = 'N';
3134:
3135: l_processed_fees := l_fee_records2 - l_fee_records1;