[Home] [Help]
134: ,nvl(ass.begin_installment_number, 0) -- fix for bug 8928398
135: ,nvl(ass.phase, 'TERM')
136: from lns_fee_assignments ass
137: ,lns_disb_headers head
138: ,lns_fees_all fee
139: where ass.loan_id is null
140: and ass.disb_header_id = head.disb_header_id
141: and fee.fee_id = ass.fee_id
142: and ass.disb_header_id = p_disb_head_id;
146: ,decode(ass.rate_type, 'FIXED', nvl(ass.fee,fee.fee), 'VARIABLE', nvl(ass.fee,fee.fee)/100)
147: ,fee.fee_description
148: ,ass.fee_basis
149: from lns_fee_assignments ass
150: ,lns_fees_all fee
151: where ass.fee_type = 'EVENT_CONVERSION'
152: and ass.fee_id = fee.fee_id
153: and loan_id = c_loan_id;
154:
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
395: and lines.fee_schedule_id = sched.fee_schedule_id
578: ,0
579: ,0
580: ,nvl(fees.fee_editable_flag,'N')
581: ,nvl(fees.fee_waivable_flag,'N')
582: from lns_fees_all fees
583: where fees.fee_id = p_fee_id;
584:
585: begin
586: l_api_name := 'getFeeStructures';
715: ,assgn.disb_header_id
716: ,nvl(assgn.phase, 'TERM')
717: ,nvl(assgn.CUSTOM_PROCEDURE, fees.CUSTOM_PROCEDURE)
718: from lns_fee_assignments assgn
719: ,lns_fees_all fees
720: where assgn.loan_id = nvl(p_loan_id, assgn.loan_id)
721: and assgn.fee_id = fees.fee_id
722: and nvl(trunc(assgn.end_date_active), trunc(sysdate) + 1) >= trunc(sysdate)
723: and nvl(trunc(assgn.start_date_active), trunc(sysdate) - 1) <= trunc(sysdate)
888: ,dh.target_date
889: ,dh.header_amount
890: ,nvl(assgn.phase, 'TERM')
891: from lns_fee_assignments assgn
892: ,lns_fees_all fees
893: ,lns_disb_headers dh
894: where dh.loan_id = nvl(p_loan_id, dh.loan_id)
895: and dh.disb_header_id = nvl(p_disb_header_id, dh.disb_header_id)
896: and fees.fee_id = nvl(p_fee_id, fees.fee_id)
1052: l_fee_basis_tbl(1).fee_basis_amount := l_original_loan_amount;
1053: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - orig_loan ' || l_original_loan_amount);
1054:
1055: IF l_orig_fee_structures.count = 0 THEN
1056: -- this fee has not yet been assigned to the loan, we need to get the fee structure from LNS_FEES, NOT
1057: -- FROM LNS_FEE_ASSIGNMENTS
1058: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee is unassigned ');
1059: l_orig_fee_structures := getFeeStructures(p_fee_id => p_fee_id);
1060: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - structs ' || l_orig_fee_structures.count);
1193: ,p_fee_id => p_fee_id);
1194: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - structs ' || l_fee_structures.count);
1195:
1196: if l_fee_structures.count = 0 then
1197: -- this fee has not yet been assigned to the loan, we need to get the fee structure from LNS_FEES, NOT LNS_FEE_ASSIGNMENTS
1198: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee is unassigned ');
1199: l_fee_structures := getFeeStructures(p_fee_id => p_fee_id);
1200: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - structs ' || l_fee_structures.count);
1201: l_installment := l_fee_structures(1).fee_from_installment;
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
1555: and nvl(phase, 'TERM') = c_phase
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;
1592:
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
1791: and nvl(phase, 'TERM') = c_phase
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
1822: and nvl(phase, 'TERM') = c_phase
2384: ,x_msg_data => l_msg_data
2385: ,x_return_status => l_return_status
2386: ,p_col_id => p_fees_tbl(k).FEE_ID
2387: ,p_col_name => 'FEE_ID'
2388: ,p_table_name => 'LNS_FEES');
2389:
2390: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2391: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2392: FND_MESSAGE.SET_TOKEN('PARAMETER', 'FEE_ID');
2607: ,x_msg_data => l_msg_data
2608: ,x_return_status => l_return_status
2609: ,p_col_id => p_fees_tbl(k).FEE_ID
2610: ,p_col_name => 'FEE_ID'
2611: ,p_table_name => 'LNS_FEES');
2612:
2613: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2614: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2615: FND_MESSAGE.SET_TOKEN('PARAMETER', 'FEE_ID');
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
2766: and sched.active_flag = 'Y'
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
3810: and struct.FEE_CATEGORY = 'EVENT'