DBA Data[Home] [Help]

APPS.LNS_FINANCIALS dependencies on LNS_CUSTOM_PUB

Line 599: l_custom_tbl LNS_CUSTOM_PUB.CUSTOM_TBL;

595: l_fund_sched_count number;
596:
597: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
598: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;
599: l_custom_tbl LNS_CUSTOM_PUB.CUSTOM_TBL;
600: l_AMORT_METHOD varchar2(30);
601: l_rate_tbl LNS_FINANCIALS.RATE_SCHEDULE_TBL;
602: l_CUSTOM_SET_REC LNS_CUSTOM_PUB.custom_settings_type;
603:

Line 602: l_CUSTOM_SET_REC LNS_CUSTOM_PUB.custom_settings_type;

598: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;
599: l_custom_tbl LNS_CUSTOM_PUB.CUSTOM_TBL;
600: l_AMORT_METHOD varchar2(30);
601: l_rate_tbl LNS_FINANCIALS.RATE_SCHEDULE_TBL;
602: l_CUSTOM_SET_REC LNS_CUSTOM_PUB.custom_settings_type;
603:
604: cursor c_fund_sched_exist(p_loan_id number) is
605: select decode(loan.loan_class_code,
606: '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),

Line 809: LNS_CUSTOM_PUB.loadCustomSchedule(

805: l_amort_tbl(i).total := l_fee_amount;
806: end if;
807:
808: -- load custom schedule
809: LNS_CUSTOM_PUB.loadCustomSchedule(
810: P_API_VERSION => 1.0,
811: P_INIT_MSG_LIST => FND_API.G_TRUE,
812: P_COMMIT => FND_API.G_FALSE,
813: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

Line 1583: l_custom_tbl LNS_CUSTOM_PUB.CUSTOM_TBL;

1579: --l_begin_balance number; -- used for fees calculation
1580: l_customized varchar2(1);
1581: l_loan_start_date date;
1582: l_funded_amount number;
1583: l_custom_tbl LNS_CUSTOM_PUB.CUSTOM_TBL;
1584: l_AMORT_METHOD varchar2(30);
1585: l_CUSTOM_SET_REC LNS_CUSTOM_PUB.custom_settings_type;
1586:
1587: /* query custom amortization */

Line 1585: l_CUSTOM_SET_REC LNS_CUSTOM_PUB.custom_settings_type;

1581: l_loan_start_date date;
1582: l_funded_amount number;
1583: l_custom_tbl LNS_CUSTOM_PUB.CUSTOM_TBL;
1584: l_AMORT_METHOD varchar2(30);
1585: l_CUSTOM_SET_REC LNS_CUSTOM_PUB.custom_settings_type;
1586:
1587: /* query custom amortization */
1588: CURSOR cust_amort_cur(P_LOAN_ID number, P_PAYMENT_NUMBER number) IS
1589: select

Line 1678: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - calling LNS_CUSTOM_PUB.loadCustomSchedule....');

1674:
1675: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - loan is customized');
1676: if p_installment_number > 0 then
1677:
1678: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - calling LNS_CUSTOM_PUB.loadCustomSchedule....');
1679: -- load custom schedule
1680: LNS_CUSTOM_PUB.loadCustomSchedule(
1681: P_API_VERSION => 1.0,
1682: P_INIT_MSG_LIST => FND_API.G_TRUE,

Line 1680: LNS_CUSTOM_PUB.loadCustomSchedule(

1676: if p_installment_number > 0 then
1677:
1678: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - calling LNS_CUSTOM_PUB.loadCustomSchedule....');
1679: -- load custom schedule
1680: LNS_CUSTOM_PUB.loadCustomSchedule(
1681: P_API_VERSION => 1.0,
1682: P_INIT_MSG_LIST => FND_API.G_TRUE,
1683: P_COMMIT => FND_API.G_FALSE,
1684: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

Line 7387: l_payment_tbl := LNS_CUSTOM_PUB.buildCustomPaySchedule(p_loan_details.LOAN_ID);

7383:
7384: else
7385:
7386: -- build custom payment schedule
7387: l_payment_tbl := LNS_CUSTOM_PUB.buildCustomPaySchedule(p_loan_details.LOAN_ID);
7388:
7389: end if;
7390:
7391: l_num_pay_dates := l_payment_tbl.count;