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 390: from lns_fee_schedules sched

386: cursor c_manual_fees (c_loan_id number, c_installment number, c_phase varchar2) is
387: select sched.fee_id
388: ,sched.fee_description
389: ,nvl(sched.phase, 'TERM')
390: from lns_fee_schedules sched
391: ,lns_fees fees
392: ,lns_amortization_lines lines
393: ,lns_amortization_scheds am
394: where fees.fee_id = sched.fee_id

Line 1550: from lns_fee_schedules sched

1546: ,decode(struct.fee_category, 'MANUAL', 'Y', 'N')
1547: ,nvl(struct.fee_editable_flag, 'N')
1548: ,struct.billing_option
1549: ,sched.phase
1550: from lns_fee_schedules sched
1551: ,lns_fees struct
1552: where sched.loan_id = c_loan_id
1553: and sched.fee_id = struct.fee_id
1554: and fee_installment = c_installment

Line 1587: from lns_fee_schedules sched

1583: ,sched.fee_amount - nvl(sched.waived_amount, 0)
1584: ,struct.fee_name
1585: ,struct.fee_description
1586: ,sched.phase
1587: from lns_fee_schedules sched
1588: ,lns_fees_all struct
1589: where disb_header_id = c_disb_header_id
1590: and sched.fee_id = struct.fee_id
1591: and nvl(sched.phase, 'TERM') = c_phase;

Line 1786: from lns_fee_schedules sched

1782: ,decode(struct.fee_category, 'MANUAL', 'Y', 'N')
1783: ,decode(struct.fee_category, 'MANUAL', nvl(struct.fee_editable_flag, 'N'), 'N')
1784: ,struct.billing_option
1785: ,sched.phase
1786: from lns_fee_schedules sched
1787: ,lns_fees struct
1788: where sched.loan_id = c_loan_id
1789: and sched.fee_id = struct.fee_id
1790: and fee_installment = c_installment

Line 1817: from lns_fee_schedules sched

1813: ,decode(struct.fee_category, 'MANUAL', 'Y', 'N')
1814: ,decode(struct.fee_category, 'MANUAL', nvl(struct.fee_editable_flag, 'N'), 'N')
1815: ,struct.billing_option
1816: ,sched.phase
1817: from lns_fee_schedules sched
1818: ,lns_fees struct
1819: where sched.loan_id = c_loan_id
1820: and sched.fee_id = struct.fee_id
1821: and fee_installment = c_installment

Line 1829: FROM LNS_FEE_SCHEDULES schd

1825:
1826: -- filtering out fees for current stage
1827: CURSOR cur_fee_schd_inst_exist(c_loan_id NUMBER, c_fee_id NUMBER, c_installment NUMBER, c_phase VARCHAR2, c_disb_header_id NUMBER) IS
1828: SELECT 'X'
1829: FROM LNS_FEE_SCHEDULES schd
1830: WHERE schd.fee_id = c_fee_id
1831: AND schd.fee_installment = c_installment
1832: AND schd.loan_id = c_loan_id
1833: AND schd.ACTIVE_FLAG = 'Y'

Line 1841: FROM LNS_FEE_SCHEDULES schd

1837:
1838: -- filtering out fees for origination stage
1839: CURSOR cur_fee_schd_inst_exist1(c_loan_id NUMBER, c_fee_id NUMBER, c_installment NUMBER, c_phase VARCHAR2, c_disb_header_id NUMBER) IS
1840: SELECT 'X'
1841: FROM LNS_FEE_SCHEDULES schd
1842: WHERE schd.fee_id = c_fee_id
1843: AND schd.fee_installment = c_installment
1844: AND schd.loan_id = c_loan_id
1845: AND schd.ACTIVE_FLAG = 'Y'

Line 2275: from lns_fee_schedules

2271: i number;
2272:
2273: cursor c_fee_schedule_id (p_loan_id number, p_fee_id number) is
2274: select fee_schedule_id
2275: from lns_fee_schedules
2276: where loan_id = p_loan_id
2277: and fee_id = p_fee_id
2278: and billed_flag = 'N'
2279: and active_flag = 'Y';

Line 2417: LNS_FEE_SCHEDULES_PKG.UPDATE_ROW(P_FEE_SCHEDULE_ID => l_fee_schedule_id

2413:
2414: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Fee_schedule_id is '||p_fees_tbl(k).FEE_SCHEDULE_ID);
2415:
2416: -- fee structure has been validated write to the fee schedule
2417: LNS_FEE_SCHEDULES_PKG.UPDATE_ROW(P_FEE_SCHEDULE_ID => l_fee_schedule_id
2418: ,P_FEE_ID => p_fees_tbl(k).FEE_ID
2419: ,P_LOAN_ID => p_loan_id
2420: ,P_FEE_AMOUNT => round(p_fees_tbl(k).FEE_AMOUNT,l_precision)
2421: ,P_FEE_INSTALLMENT => p_fees_tbl(k).FEE_INSTALLMENT

Line 2631: LNS_FEE_SCHEDULES_PKG.INSERT_ROW(X_FEE_SCHEDULE_ID => l_fee_schedule_id

2627: into l_fee_schedule_id
2628: from dual;
2629:
2630: -- fee structure has been validated write to the fee schedule
2631: LNS_FEE_SCHEDULES_PKG.INSERT_ROW(X_FEE_SCHEDULE_ID => l_fee_schedule_id
2632: ,P_FEE_ID => p_fees_tbl(k).FEE_ID
2633: ,P_LOAN_ID => p_loan_id
2634: ,P_FEE_AMOUNT => round(p_fees_tbl(k).FEE_AMOUNT, l_loan_details.currency_precision)
2635: ,P_FEE_INSTALLMENT => p_fees_tbl(k).FEE_INSTALLMENT

Line 2761: from lns_fee_schedules sched

2757: c_type varchar2,
2758: c_phase varchar2,
2759: C_BILLING_OPTION VARCHAR2) is
2760: select nvl(sum(fee_amount), 0)
2761: from lns_fee_schedules sched
2762: ,lns_fees fees
2763: where sched.loan_id = c_loan_id
2764: and sched.fee_id = fees.fee_id
2765: and sched.fee_installment = c_installment

Line 2884: FROM lns_fee_schedules

2880: l_fee_schedule_id := NULL;
2881:
2882: BEGIN
2883: SELECT fee_schedule_id, billed_flag INTO l_fee_schedule_id, l_billed_flag
2884: FROM lns_fee_schedules
2885: WHERE loan_id = p_loan_id
2886: AND fee_id = l_fee_calc_tbl(f).fee_id
2887: AND fee_installment = l_fee_calc_tbl(f).fee_installment
2888: AND nvl(phase, 'TERM') = l_fee_calc_tbl(f).phase

Line 3043: from lns_fee_schedules sched

3039: -- waived_amount cannot be > fee_amount less any previously waived amount
3040: cursor c_fee_waive_amount(c_fee_schedule_id number) is
3041: select sched.fee_amount - nvl(sched.waived_amount, 0) amount_remaining
3042: ,nvl(sched.waived_amount, 0) previously_waived
3043: from lns_fee_schedules sched
3044: where sched.loan_id = p_loan_id
3045: and sched.fee_schedule_id = c_fee_schedule_id
3046: and sched.fee_waivable_flag = 'Y'
3047: and sched.active_flag = 'Y'

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

3089: ,x_msg_data => l_msg_data
3090: ,x_return_status => l_return_status
3091: ,p_col_id => p_fee_schedule_id
3092: ,p_col_name => 'FEE_SCHEDULE_ID'
3093: ,p_table_name => 'LNS_FEE_SCHEDULES');
3094:
3095: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3096: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
3097: FND_MESSAGE.SET_TOKEN('PARAMETER', 'FEE_SCHEDULE_ID');

Line 3123: lns_fee_schedules_pkg.update_row(P_FEE_SCHEDULE_ID => p_fee_schedule_id

3119: end if;
3120:
3121: -- fee is valid and waive amount is valid. update the fee schedule
3122: -- check on updating object_version_number
3123: lns_fee_schedules_pkg.update_row(P_FEE_SCHEDULE_ID => p_fee_schedule_id
3124: ,P_FEE_ID => null
3125: ,P_LOAN_ID => p_loan_id
3126: ,P_FEE_AMOUNT => null
3127: ,P_FEE_INSTALLMENT => null

Line 3227: ' from lns_fee_schedules sched ' ||

3223: begin
3224: l_api_name := 'getFeesTotal';
3225:
3226: vPLSQL := 'SELECT decode(:p_waived_flag, ''Y'', nvl(sum(sched.waived_amount),0), nvl(sum(sched.fee_amount) - sum(sched.waived_amount),0))' ||
3227: ' from lns_fee_schedules sched ' ||
3228: --' ,lns_fee_assignments assign ' ||
3229: --' where assgn.fee_id = sched.fee_id ' ||
3230: ' Where sched.loan_id = :p_loan_id ' ||
3231: ' and sched.billed_flag = :p_billed_flag ' ||

Line 3268: || write them to the lns_fee_schedules

3264: || PUBLIC PROCEDURE processLateFees
3265: ||
3266: || DESCRIPTION
3267: || Overview: this procedure will determine late fees, calculate them and
3268: || write them to the lns_fee_schedules
3269: || PSEUDO CODE/LOGIC
3270: ||
3271: || PARAMETERS
3272: || Parameter: p_loan_id => loan_id

Line 3468: FROM lns_fee_schedules

3464: end if;
3465:
3466: BEGIN
3467: SELECT fee_schedule_id INTO l_fee_schedule_id
3468: FROM lns_fee_schedules
3469: WHERE loan_id = p_loan_id
3470: AND fee_id = l_fee_calc_tbl(1).fee_id
3471: AND fee_installment = l_fee_calc_tbl(1).fee_installment
3472: AND nvl(phase, 'TERM') = l_fee_calc_tbl(1).phase

Line 3502: delete from lns_fee_schedules

3498:
3499: else
3500: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - Deleting fee with fee_id = ' || l_late_fee_structure(1).fee_id);
3501:
3502: delete from lns_fee_schedules
3503: WHERE loan_id = p_loan_id
3504: AND fee_id = l_late_fee_structure(1).fee_id
3505: AND fee_installment = l_current_installment
3506: AND nvl(phase, 'TERM') = l_late_fee_structure(1).phase

Line 3635: from lns_fee_schedules

3631: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_LOAN_ID ' || p_loan_id);
3632: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_BORROWER_ID ' || p_borrower_id);
3633:
3634: select count(1) into l_fee_records1
3635: from lns_fee_schedules
3636: where active_flag = 'Y'
3637: and billed_flag = 'N';
3638:
3639: if p_loan_id is not null then

Line 3696: from lns_fee_schedules

3692:
3693: end if;
3694:
3695: select count(1) into l_fee_records2
3696: from lns_fee_schedules
3697: where active_flag = 'Y'
3698: and billed_flag = 'N';
3699:
3700: l_processed_fees := l_fee_records2 - l_fee_records1;

Line 3805: from lns_fee_schedules sched

3801: ,sched.fee_waivable_flag -- should be struct right
3802: ,decode(struct.fee_category, 'MANUAL', 'Y', 'N')
3803: ,nvl(struct.fee_editable_flag, 'N')
3804: ,nvl(sched.phase, 'TERM')
3805: from lns_fee_schedules sched
3806: ,lns_fees struct
3807: where sched.loan_id = c_loan_id
3808: and sched.fee_id = struct.fee_id
3809: and fee_installment = c_installment