APPS.LNS_REP_UTILS dependencies on LNS_FINANCIALS

Line 275: ',LNS_FINANCIALS.getActiveRate(lh.LOAN_ID) current_interest_rate ' ||

271: ',lh.ORG_ID ' ||
272: ',lh.LOAN_TYPE ' ||
273: ',lh.LOAN_CLASS_CODE ' ||
274: ',lh.LOAN_CURRENCY ' ||
275: ',LNS_FINANCIALS.getActiveRate(lh.LOAN_ID) current_interest_rate ' ||
276: ', llkrt.meaning interest_type ' ||
277: ',lh.LOAN_SUBTYPE ' ||
278: ',(select max(last_update_date) from LNS_APPROVAL_ACTIONS ' ||
279: 'where loan_id = lh.LOAN_ID ' ||

Line 1082: l_amort_tbl LNS_FINANCIALS.AMORTIZATION_TBL;

1078: l_rows_processed NUMBER;
1079: l_new_line VARCHAR2(1);
1080: l_org_name hr_operating_units.NAME%TYPE;
1081: l_sob_currency_code gl_sets_of_books.CURRENCY_CODE%TYPE;
1082: l_amort_tbl LNS_FINANCIALS.AMORTIZATION_TBL;
1083: l_return_status VARCHAR2(10);
1084: l_msg_count NUMBER;
1085: l_msg_data VARCHAR2(32767);
1086:

Line 1229: ,LNS_FINANCIALS.getActiveRate(lh.LOAN_ID) current_interest_rate

1225: ,to_char(lh.loan_maturity_date, 'YYYY-MM-DD') loan_maturity_date
1226: ,lh.ORG_ID
1227: ,lh.LOAN_TYPE LOAN_TYPE_CODE
1228: ,lh.LOAN_CLASS_CODE
1229: ,LNS_FINANCIALS.getActiveRate(lh.LOAN_ID) current_interest_rate
1230: ,lh.LOAN_SUBTYPE
1231: ,lh.LAST_BILLED_DATE
1232: ,to_char(lh.LOAN_APPROVAL_DATE, 'YYYY-MM-DD') LOAN_APPROVAL_DATE
1233: ,loc.address1 || ' ' || loc.city || ' ' || loc.state || ' ' ||

Line 1704: lns_financials.runAmortization(p_api_version => 1.0

1700: lh.org_id = lh.org_id;
1701: BEGIN
1702: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
1703:
1704: lns_financials.runAmortization(p_api_version => 1.0
1705: ,p_init_msg_list => 'T'
1706: ,p_commit => 'F'
1707: ,p_loan_ID => p_loan_id
1708: ,p_based_on_terms => p_based_on_terms --'CURRENT'

Line 2855: l_amort_tbl LNS_FINANCIALS.AMORTIZATION_TBL;

2851: l_failed_count number;
2852: l_succeed_count number;
2853: l_LOAN_AMOUNT number;
2854:
2855: l_amort_tbl LNS_FINANCIALS.AMORTIZATION_TBL;
2856: l_cursor SYS_REFCURSOR;
2857: l_sql varchar2(500);
2858: l_where varchar2(200);
2859: l_clause varchar2(100);

Line 3077: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_FINANCIALS.runAmortization for ' || l_BASED_ON_TERMS || ' SCHEDULE_TYPE...');

3073:
3074: end if;
3075:
3076: l_amort_tbl.delete;
3077: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_FINANCIALS.runAmortization for ' || l_BASED_ON_TERMS || ' SCHEDULE_TYPE...');
3078: LNS_FINANCIALS.runAmortization(
3079: P_API_VERSION => 1.0,
3080: P_INIT_MSG_LIST => FND_API.G_TRUE,
3081: P_COMMIT => FND_API.G_FALSE,

Line 3078: LNS_FINANCIALS.runAmortization(

3074: end if;
3075:
3076: l_amort_tbl.delete;
3077: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_FINANCIALS.runAmortization for ' || l_BASED_ON_TERMS || ' SCHEDULE_TYPE...');
3078: LNS_FINANCIALS.runAmortization(
3079: P_API_VERSION => 1.0,
3080: P_INIT_MSG_LIST => FND_API.G_TRUE,
3081: P_COMMIT => FND_API.G_FALSE,
3082: P_LOAN_ID => l_loan_id,

Line 3212: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_FINANCIALS.runAmortization for ORIGINAL SCHEDULE_TYPE...');

3208:
3209: if SCHEDULE_TYPE = 'BOTH' then
3210:
3211: l_amort_tbl.delete;
3212: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_FINANCIALS.runAmortization for ORIGINAL SCHEDULE_TYPE...');
3213: LNS_FINANCIALS.runAmortization(
3214: P_API_VERSION => 1.0,
3215: P_INIT_MSG_LIST => FND_API.G_TRUE,
3216: P_COMMIT => FND_API.G_FALSE,

Line 3213: LNS_FINANCIALS.runAmortization(

3209: if SCHEDULE_TYPE = 'BOTH' then
3210:
3211: l_amort_tbl.delete;
3212: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_FINANCIALS.runAmortization for ORIGINAL SCHEDULE_TYPE...');
3213: LNS_FINANCIALS.runAmortization(
3214: P_API_VERSION => 1.0,
3215: P_INIT_MSG_LIST => FND_API.G_TRUE,
3216: P_COMMIT => FND_API.G_FALSE,
3217: P_LOAN_ID => l_loan_id,