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_DISTRIBUTIONS_PUB dependencies on LNS_DISTRIBUTIONS_PUB

Line 1: PACKAGE BODY LNS_DISTRIBUTIONS_PUB AS

1: PACKAGE BODY LNS_DISTRIBUTIONS_PUB AS
2: /* $Header: LNS_DIST_PUBP_B.pls 120.75.12020000.6 2013/03/07 16:32:04 scherkas ship $ */
3:
4: /*========================================================================+
5: | Package Global Constants

Line 10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'LNS_DISTRIBUTIONS_PUB';

6: +=======================================================================*/
7: G_DEBUG_COUNT NUMBER := 0;
8: G_DEBUG BOOLEAN := FALSE;
9:
10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'LNS_DISTRIBUTIONS_PUB';
11: g_cr_return_status VARCHAR2(10);
12: g_last_accrual_report CLOB;
13: g_last_all_statements CLOB;
14: g_cp_statements CLOB;

Line 107: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling lns_distributions_pub.onlineAccounting...');

103: -- Initialize API return status to SUCCESS
104: x_return_status := FND_API.G_RET_STS_SUCCESS;
105:
106: -- first complete accounting for any unprocessed events / documents for the loan transaction
107: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling lns_distributions_pub.onlineAccounting...');
108: lns_distributions_pub.onlineAccounting(p_loan_id => p_loan_id
109: ,p_init_msg_list => fnd_api.g_false
110: ,p_accounting_mode => 'F'
111: ,p_transfer_flag => 'Y'

Line 108: lns_distributions_pub.onlineAccounting(p_loan_id => p_loan_id

104: x_return_status := FND_API.G_RET_STS_SUCCESS;
105:
106: -- first complete accounting for any unprocessed events / documents for the loan transaction
107: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling lns_distributions_pub.onlineAccounting...');
108: lns_distributions_pub.onlineAccounting(p_loan_id => p_loan_id
109: ,p_init_msg_list => fnd_api.g_false
110: ,p_accounting_mode => 'F'
111: ,p_transfer_flag => 'Y'
112: ,p_offline_flag => 'N'

Line 132: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Invoking LNS_DISTRIBUTIONS_PUB.generateCancelDistributions...');

128: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || 'l_disbusement_id ' || l_disbursement_id);
129:
130: if (lns_utility_pub.IS_FED_FIN_ENABLED = 'Y' OR LNS_UTILITY_PUB.IS_ENCUM_FIN_ENABLED = 'Y') then
131:
132: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Invoking LNS_DISTRIBUTIONS_PUB.generateCancelDistributions...');
133: LNS_DISTRIBUTIONS_PUB.generateCancelDistributions(p_api_version => 1
134: ,p_init_msg_list => 'F'
135: ,p_commit => 'F'
136: ,p_loan_id => p_loan_id

Line 133: LNS_DISTRIBUTIONS_PUB.generateCancelDistributions(p_api_version => 1

129:
130: if (lns_utility_pub.IS_FED_FIN_ENABLED = 'Y' OR LNS_UTILITY_PUB.IS_ENCUM_FIN_ENABLED = 'Y') then
131:
132: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Invoking LNS_DISTRIBUTIONS_PUB.generateCancelDistributions...');
133: LNS_DISTRIBUTIONS_PUB.generateCancelDistributions(p_api_version => 1
134: ,p_init_msg_list => 'F'
135: ,p_commit => 'F'
136: ,p_loan_id => p_loan_id
137: ,x_return_status => l_return_status

Line 842: procedure do_insert_distributions(p_distributions_tbl in lns_distributions_pub.distribution_tbl

838: || MODIFICATION HISTORY
839: || Date Author Description of Changes
840: || 04-20-2005 raverma Created
841: *=======================================================================*/
842: procedure do_insert_distributions(p_distributions_tbl in lns_distributions_pub.distribution_tbl
843: ,p_loan_id in number)
844:
845: is
846: l_total_distributions number;

Line 994: ,x_distribution_tbl OUT NOCOPY lns_distributions_pub.distribution_tbl

990: ,p_disb_header_id IN NUMBER
991: ,p_loan_amount_adj_id IN NUMBER DEFAULT NULL
992: ,p_include_loan_receivables IN VARCHAR2
993: ,p_distribution_type IN VARCHAR2
994: ,x_distribution_tbl OUT NOCOPY lns_distributions_pub.distribution_tbl
995: ,x_return_status OUT NOCOPY VARCHAR2
996: ,x_msg_count OUT NOCOPY NUMBER
997: ,x_msg_data OUT NOCOPY VARCHAR2)
998:

Line 1020: l_distributions lns_distributions_pub.distribution_tbl;

1016: l_funded_amount number;
1017: l_adj_reversal varchar2(1);
1018: l_loan_receivables_count number;
1019: l_loan_payables_count number;
1020: l_distributions lns_distributions_pub.distribution_tbl;
1021: l_running_amount1 number;
1022: l_running_amount2 number;
1023: l_running_amount3 number;
1024: l_running_amount4 number;

Line 1029: l_ledger_details lns_distributions_pub.gl_ledger_details;

1025: k number;
1026: n number;
1027: l number;
1028: m number;
1029: l_ledger_details lns_distributions_pub.gl_ledger_details;
1030: Type refCur is ref cursor;
1031: sql_Cur refCur;
1032: vSqlCur varchar2(1000);
1033: vPLSQL VARCHAR2(1000);

Line 1131: l_ledger_details := lns_distributions_pub.getLedgerDetails;

1127: l_running_amount1 := 0;
1128: l_running_amount2 := 0;
1129: l_running_amount3 := 0;
1130: l_running_amount4 := 0;
1131: l_ledger_details := lns_distributions_pub.getLedgerDetails;
1132:
1133: -- get class and type for the loan
1134: l_adj_reversal := 'N';
1135: if p_loan_amount_adj_id is not null then

Line 1407: procedure create_event(p_acc_event_tbl in LNS_DISTRIBUTIONS_PUB.acc_event_tbl

1403: || Date Author Description of Changes
1404: || 8/3/2005 raverma Created
1405: ||
1406: *=======================================================================*/
1407: procedure create_event(p_acc_event_tbl in LNS_DISTRIBUTIONS_PUB.acc_event_tbl
1408: ,p_init_msg_list in varchar2
1409: ,p_commit in varchar2
1410: ,x_return_status out nocopy varchar2
1411: ,x_msg_count out nocopy number

Line 1418: l_distributions LNS_DISTRIBUTIONS_PUB.distribution_tbl;

1414: is
1415: l_api_name varchar2(25);
1416: l_loan_class varchar2(30);
1417: l_loan_type_id number;
1418: l_distributions LNS_DISTRIBUTIONS_PUB.distribution_tbl;
1419: l_msg_count NUMBER;
1420: l_msg_data VARCHAR2(2000);
1421: l_return_Status VARCHAR2(1);
1422: l_event_id number;

Line 1515: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'In LNS_DISTRIBUTIONS_PUB.createEvent(), updation of event_id is done for '||SQL%ROWCOUNT||' rows');

1511: and activity = l_activity
1512: and nvl(disb_header_id, -1) = nvl(p_acc_event_tbl(k).disb_header_id,-1)
1513: and nvl(loan_amount_adj_id, -1) = nvl(p_acc_event_tbl(k).loan_amount_adj_id, -1);
1514:
1515: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'In LNS_DISTRIBUTIONS_PUB.createEvent(), updation of event_id is done for '||SQL%ROWCOUNT||' rows');
1516:
1517: end if;
1518:
1519: end loop;

Line 1765: l_ledger_details lns_distributions_pub.gl_ledger_details;

1761: ,p_loan_id number) return number
1762: is
1763:
1764: l_new_cc_id number;
1765: l_ledger_details lns_distributions_pub.gl_ledger_details;
1766: l_natural_account_rec varchar2(25); -- the lns_def_distribs replacement for Loans Receivable
1767: l_nat_acct_seg_number number;
1768: l_api_name varchar2(25);
1769:

Line 1782: l_ledger_details := lns_distributions_pub.getLedgerDetails;

1778: and h.loan_type_id = d.loan_type_id;
1779:
1780: begin
1781:
1782: l_ledger_details := lns_distributions_pub.getLedgerDetails;
1783: -- given a code_combination
1784: if p_distribution_type = 'LOAN_RECEIVABLE' then
1785:
1786: -- build new cc_id

Line 1876: ,p_distribution_type in varchar2) return LNS_DISTRIBUTIONS_PUB.default_distributions_tbl

1872: ,p_loan_type_id in number
1873: ,p_account_type in varchar2
1874: ,p_account_name in varchar2
1875: ,p_line_type in varchar2
1876: ,p_distribution_type in varchar2) return LNS_DISTRIBUTIONS_PUB.default_distributions_tbl
1877: is
1878: x_distribution_tbl LNS_DISTRIBUTIONS_PUB.default_distributions_tbl;
1879: l_index number := 1;
1880: l_loan_id number;

Line 1878: x_distribution_tbl LNS_DISTRIBUTIONS_PUB.default_distributions_tbl;

1874: ,p_account_name in varchar2
1875: ,p_line_type in varchar2
1876: ,p_distribution_type in varchar2) return LNS_DISTRIBUTIONS_PUB.default_distributions_tbl
1877: is
1878: x_distribution_tbl LNS_DISTRIBUTIONS_PUB.default_distributions_tbl;
1879: l_index number := 1;
1880: l_loan_id number;
1881: l_loan_class varchar2(30);
1882: l_loan_type_id number;

Line 2062: ,p_distribution_type in varchar2) return LNS_DISTRIBUTIONS_PUB.distribution_tbl

2058: function getDistributions(p_loan_id in number
2059: ,p_account_type in varchar2
2060: ,p_account_name in varchar2
2061: ,p_line_type in varchar2
2062: ,p_distribution_type in varchar2) return LNS_DISTRIBUTIONS_PUB.distribution_tbl
2063:
2064: is
2065:
2066: l_api_name varchar2(30);

Line 2067: x_distribution_tbl lns_distributions_pub.distribution_tbl;

2063:
2064: is
2065:
2066: l_api_name varchar2(30);
2067: x_distribution_tbl lns_distributions_pub.distribution_tbl;
2068: l_index number;
2069: l_loan_id number;
2070: l_distribution_id number;
2071: l_line_type varchar2(30);

Line 2207: function getDistributions(p_distribution_id in number) return LNS_DISTRIBUTIONS_PUB.distribution_rec

2203: return x_distribution_tbl;
2204:
2205: end getDistributions;
2206:
2207: function getDistributions(p_distribution_id in number) return LNS_DISTRIBUTIONS_PUB.distribution_rec
2208:
2209: is
2210:
2211: x_distribution_rec lns_distributions_pub.distribution_rec;

Line 2211: x_distribution_rec lns_distributions_pub.distribution_rec;

2207: function getDistributions(p_distribution_id in number) return LNS_DISTRIBUTIONS_PUB.distribution_rec
2208:
2209: is
2210:
2211: x_distribution_rec lns_distributions_pub.distribution_rec;
2212: l_api_name varchar2(30);
2213:
2214: cursor c_get_distribution(x_distribution_id number) is
2215: select distribution_id

Line 2320: ,p_distribution_type in varchar2) return LNS_DISTRIBUTIONS_PUB.distribution_tbl

2316: ,p_loan_line_id in number
2317: ,p_account_type in varchar2
2318: ,p_account_name in varchar2
2319: ,p_line_type in varchar2
2320: ,p_distribution_type in varchar2) return LNS_DISTRIBUTIONS_PUB.distribution_tbl
2321:
2322: is
2323:
2324: l_api_name varchar2(30);

Line 2325: x_distribution_tbl lns_distributions_pub.distribution_tbl;

2321:
2322: is
2323:
2324: l_api_name varchar2(30);
2325: x_distribution_tbl lns_distributions_pub.distribution_tbl;
2326: l_index number;
2327: l_loan_id number;
2328: l_distribution_id number;
2329: l_line_type varchar2(30);

Line 2511: function getLedgerDetails return lns_distributions_pub.gl_ledger_details

2507: || Date Author Description of Changes
2508: || 02-18-2004 raverma Created
2509: ||
2510: *=======================================================================*/
2511: function getLedgerDetails return lns_distributions_pub.gl_ledger_details
2512: is
2513: cursor c_ledger
2514: is
2515: SELECT so.set_of_books_id

Line 2528: l_ledger_details lns_distributions_pub.gl_ledger_details;

2524: fnd_currencies fndc
2525: WHERE sb.ledger_id = so.set_of_books_id
2526: and sb.currency_code = fndc.currency_code;
2527:
2528: l_ledger_details lns_distributions_pub.gl_ledger_details;
2529:
2530: begin
2531:
2532: begin

Line 2599: l_ledger_details lns_distributions_pub.gl_ledger_details;

2595:
2596: is
2597: l_api_name varchar2(50);
2598: l_distribution_amount number;
2599: l_ledger_details lns_distributions_pub.gl_ledger_details;
2600: l_distribution_rec lns_distributions_pub.distribution_rec;
2601: l_distribution_tbl lns_distributions_pub.distribution_tbl;
2602: l_loan_id number;
2603: l_max_distribution_id number;

Line 2600: l_distribution_rec lns_distributions_pub.distribution_rec;

2596: is
2597: l_api_name varchar2(50);
2598: l_distribution_amount number;
2599: l_ledger_details lns_distributions_pub.gl_ledger_details;
2600: l_distribution_rec lns_distributions_pub.distribution_rec;
2601: l_distribution_tbl lns_distributions_pub.distribution_tbl;
2602: l_loan_id number;
2603: l_max_distribution_id number;
2604:

Line 2601: l_distribution_tbl lns_distributions_pub.distribution_tbl;

2597: l_api_name varchar2(50);
2598: l_distribution_amount number;
2599: l_ledger_details lns_distributions_pub.gl_ledger_details;
2600: l_distribution_rec lns_distributions_pub.distribution_rec;
2601: l_distribution_tbl lns_distributions_pub.distribution_tbl;
2602: l_loan_id number;
2603: l_max_distribution_id number;
2604:
2605: cursor c_get_distribution(p_distribution_id number) is

Line 2650: l_ledger_details := lns_distributions_pub.getLedgerDetails;

2646: begin
2647:
2648: l_api_name := 'calculateDistributionAmount';
2649: --logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
2650: l_ledger_details := lns_distributions_pub.getLedgerDetails;
2651: l_distribution_rec := lns_distributions_pub.getDistributions(p_distribution_id);
2652:
2653: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loanID = ' || l_distribution_rec.loan_id);
2654: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'DIST_ID = ' || p_distribution_id);

Line 2651: l_distribution_rec := lns_distributions_pub.getDistributions(p_distribution_id);

2647:
2648: l_api_name := 'calculateDistributionAmount';
2649: --logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
2650: l_ledger_details := lns_distributions_pub.getLedgerDetails;
2651: l_distribution_rec := lns_distributions_pub.getDistributions(p_distribution_id);
2652:
2653: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loanID = ' || l_distribution_rec.loan_id);
2654: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'DIST_ID = ' || p_distribution_id);
2655: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'disttype = ' || l_distribution_rec.distribution_type);

Line 2659: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling lns_distributions_pub.getDistributions...');

2655: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'disttype = ' || l_distribution_rec.distribution_type);
2656: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'accounttype = ' || l_distribution_rec.account_type);
2657:
2658: if l_distribution_rec.distribution_amount is null then
2659: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling lns_distributions_pub.getDistributions...');
2660: l_distribution_tbl := lns_distributions_pub.getDistributions(p_loan_id => l_distribution_rec.loan_id
2661: ,p_account_type => l_distribution_rec.account_type
2662: ,p_account_name => l_distribution_rec.account_name
2663: ,p_line_type => l_distribution_rec.line_type

Line 2660: l_distribution_tbl := lns_distributions_pub.getDistributions(p_loan_id => l_distribution_rec.loan_id

2656: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'accounttype = ' || l_distribution_rec.account_type);
2657:
2658: if l_distribution_rec.distribution_amount is null then
2659: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling lns_distributions_pub.getDistributions...');
2660: l_distribution_tbl := lns_distributions_pub.getDistributions(p_loan_id => l_distribution_rec.loan_id
2661: ,p_account_type => l_distribution_rec.account_type
2662: ,p_account_name => l_distribution_rec.account_name
2663: ,p_line_type => l_distribution_rec.line_type
2664: ,p_distribution_type => l_distribution_rec.distribution_type);

Line 2738: l_ledger_details lns_distributions_pub.gl_ledger_details;

2734: is
2735: l_api_name varchar2(50);
2736: l_distribution_amount number;
2737: l_return number;
2738: l_ledger_details lns_distributions_pub.gl_ledger_details;
2739: l_distribution_rec lns_distributions_pub.distribution_rec;
2740: l_distribution_tbl lns_distributions_pub.distribution_tbl;
2741: l_loan_id number;
2742: l_max_distribution_id number;

Line 2739: l_distribution_rec lns_distributions_pub.distribution_rec;

2735: l_api_name varchar2(50);
2736: l_distribution_amount number;
2737: l_return number;
2738: l_ledger_details lns_distributions_pub.gl_ledger_details;
2739: l_distribution_rec lns_distributions_pub.distribution_rec;
2740: l_distribution_tbl lns_distributions_pub.distribution_tbl;
2741: l_loan_id number;
2742: l_max_distribution_id number;
2743: l_currency_code varchar2(10);

Line 2740: l_distribution_tbl lns_distributions_pub.distribution_tbl;

2736: l_distribution_amount number;
2737: l_return number;
2738: l_ledger_details lns_distributions_pub.gl_ledger_details;
2739: l_distribution_rec lns_distributions_pub.distribution_rec;
2740: l_distribution_tbl lns_distributions_pub.distribution_tbl;
2741: l_loan_id number;
2742: l_max_distribution_id number;
2743: l_currency_code varchar2(10);
2744: l_exchange_rate_type varchar2(30);

Line 2790: l_ledger_details := lns_distributions_pub.getLedgerDetails;

2786:
2787: l_api_name := 'calculateDistributionAmount';
2788:
2789: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
2790: l_ledger_details := lns_distributions_pub.getLedgerDetails;
2791: l_distribution_rec := lns_distributions_pub.getDistributions(p_distribution_id);
2792:
2793: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loanID = ' || l_distribution_rec.loan_id);
2794: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'DIST_ID = ' || p_distribution_id);

Line 2791: l_distribution_rec := lns_distributions_pub.getDistributions(p_distribution_id);

2787: l_api_name := 'calculateDistributionAmount';
2788:
2789: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
2790: l_ledger_details := lns_distributions_pub.getLedgerDetails;
2791: l_distribution_rec := lns_distributions_pub.getDistributions(p_distribution_id);
2792:
2793: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'loanID = ' || l_distribution_rec.loan_id);
2794: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'DIST_ID = ' || p_distribution_id);
2795: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'disttype = ' || l_distribution_rec.distribution_type);

Line 2873: l_amount := lns_distributions_pub.calculateDistributionAmount(p_distribution_id => p_distribution_id

2869: fetch c_currency1 into l_currency;
2870: close c_currency1;
2871: end if;
2872:
2873: l_amount := lns_distributions_pub.calculateDistributionAmount(p_distribution_id => p_distribution_id
2874: ,p_accounted_flag => p_accounted_flag);
2875: l_char := to_char(l_amount, fnd_currency.safe_get_format_mask(l_currency,25));
2876:
2877: l_return := l_char || ' ' || l_currency;

Line 3058: --l_loan_liability_fund LNS_DISTRIBUTIONS_PUB.distribution_tbl;

3054: ,x_msg_count OUT NOCOPY NUMBER
3055: ,x_msg_data OUT NOCOPY VARCHAR2)
3056: is
3057:
3058: --l_loan_liability_fund LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3059: l_loan_clearing_fund LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3060: l_loan_receivables_orig LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3061: l_loan_clearing_orig LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3062: l_loan_receivables_bill LNS_DISTRIBUTIONS_PUB.distribution_tbl;

Line 3059: l_loan_clearing_fund LNS_DISTRIBUTIONS_PUB.distribution_tbl;

3055: ,x_msg_data OUT NOCOPY VARCHAR2)
3056: is
3057:
3058: --l_loan_liability_fund LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3059: l_loan_clearing_fund LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3060: l_loan_receivables_orig LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3061: l_loan_clearing_orig LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3062: l_loan_receivables_bill LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3063: l_prin_receivables_bill LNS_DISTRIBUTIONS_PUB.distribution_tbl;

Line 3060: l_loan_receivables_orig LNS_DISTRIBUTIONS_PUB.distribution_tbl;

3056: is
3057:
3058: --l_loan_liability_fund LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3059: l_loan_clearing_fund LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3060: l_loan_receivables_orig LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3061: l_loan_clearing_orig LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3062: l_loan_receivables_bill LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3063: l_prin_receivables_bill LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3064: l_int_receivables_bill LNS_DISTRIBUTIONS_PUB.distribution_tbl;

Line 3061: l_loan_clearing_orig LNS_DISTRIBUTIONS_PUB.distribution_tbl;

3057:
3058: --l_loan_liability_fund LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3059: l_loan_clearing_fund LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3060: l_loan_receivables_orig LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3061: l_loan_clearing_orig LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3062: l_loan_receivables_bill LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3063: l_prin_receivables_bill LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3064: l_int_receivables_bill LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3065: l_int_income_bill LNS_DISTRIBUTIONS_PUB.distribution_tbl;

Line 3062: l_loan_receivables_bill LNS_DISTRIBUTIONS_PUB.distribution_tbl;

3058: --l_loan_liability_fund LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3059: l_loan_clearing_fund LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3060: l_loan_receivables_orig LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3061: l_loan_clearing_orig LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3062: l_loan_receivables_bill LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3063: l_prin_receivables_bill LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3064: l_int_receivables_bill LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3065: l_int_income_bill LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3066:

Line 3063: l_prin_receivables_bill LNS_DISTRIBUTIONS_PUB.distribution_tbl;

3059: l_loan_clearing_fund LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3060: l_loan_receivables_orig LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3061: l_loan_clearing_orig LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3062: l_loan_receivables_bill LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3063: l_prin_receivables_bill LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3064: l_int_receivables_bill LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3065: l_int_income_bill LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3066:
3067: l_dist_percent_rec_orig number;

Line 3064: l_int_receivables_bill LNS_DISTRIBUTIONS_PUB.distribution_tbl;

3060: l_loan_receivables_orig LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3061: l_loan_clearing_orig LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3062: l_loan_receivables_bill LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3063: l_prin_receivables_bill LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3064: l_int_receivables_bill LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3065: l_int_income_bill LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3066:
3067: l_dist_percent_rec_orig number;
3068: l_dist_percent_rec_bill number;

Line 3065: l_int_income_bill LNS_DISTRIBUTIONS_PUB.distribution_tbl;

3061: l_loan_clearing_orig LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3062: l_loan_receivables_bill LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3063: l_prin_receivables_bill LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3064: l_int_receivables_bill LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3065: l_int_income_bill LNS_DISTRIBUTIONS_PUB.distribution_tbl;
3066:
3067: l_dist_percent_rec_orig number;
3068: l_dist_percent_rec_bill number;
3069: l_dist_percent_clear_orig number;

Line 3148: l_loan_liability_fund := LNS_DISTRIBUTIONS_PUB.getDistributions(p_loan_id => p_loan_id

3144: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_class = ' || l_loan_class);
3145: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_status = ' || l_loan_status);
3146: -- get the distributions details
3147: /*
3148: l_loan_liability_fund := LNS_DISTRIBUTIONS_PUB.getDistributions(p_loan_id => p_loan_id
3149: ,p_account_type => 'DR'
3150: ,p_account_name => 'LOAN_LIABILITY'
3151: ,p_line_type => 'ORIG'
3152: ,p_distribution_type => 'FUNDING');

Line 3156: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_DISTRIBUTIONS_PUB.getDistributions 1...');

3152: ,p_distribution_type => 'FUNDING');
3153: */
3154: if l_loan_class = 'ERS' then
3155:
3156: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_DISTRIBUTIONS_PUB.getDistributions 1...');
3157: l_loan_clearing_orig := LNS_DISTRIBUTIONS_PUB.getDistributions(p_loan_id => p_loan_id
3158: ,p_account_type => 'CR'
3159: ,p_account_name => 'LOAN_CLEARING'
3160: ,p_line_type => 'CLEAR'

Line 3157: l_loan_clearing_orig := LNS_DISTRIBUTIONS_PUB.getDistributions(p_loan_id => p_loan_id

3153: */
3154: if l_loan_class = 'ERS' then
3155:
3156: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_DISTRIBUTIONS_PUB.getDistributions 1...');
3157: l_loan_clearing_orig := LNS_DISTRIBUTIONS_PUB.getDistributions(p_loan_id => p_loan_id
3158: ,p_account_type => 'CR'
3159: ,p_account_name => 'LOAN_CLEARING'
3160: ,p_line_type => 'CLEAR'
3161: ,p_distribution_type => 'ORIGINATION');

Line 3164: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_DISTRIBUTIONS_PUB.getDistributions 2...');

3160: ,p_line_type => 'CLEAR'
3161: ,p_distribution_type => 'ORIGINATION');
3162: elsif l_loan_class = 'DIRECT' then
3163:
3164: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_DISTRIBUTIONS_PUB.getDistributions 2...');
3165: l_loan_clearing_orig := LNS_DISTRIBUTIONS_PUB.getDistributions(p_loan_id => p_loan_id
3166: ,p_account_type => 'CR'
3167: ,p_account_name => 'LOAN_PAYABLE'
3168: ,p_line_type => 'CLEAR'

Line 3165: l_loan_clearing_orig := LNS_DISTRIBUTIONS_PUB.getDistributions(p_loan_id => p_loan_id

3161: ,p_distribution_type => 'ORIGINATION');
3162: elsif l_loan_class = 'DIRECT' then
3163:
3164: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_DISTRIBUTIONS_PUB.getDistributions 2...');
3165: l_loan_clearing_orig := LNS_DISTRIBUTIONS_PUB.getDistributions(p_loan_id => p_loan_id
3166: ,p_account_type => 'CR'
3167: ,p_account_name => 'LOAN_PAYABLE'
3168: ,p_line_type => 'CLEAR'
3169: ,p_distribution_type => 'ORIGINATION');

Line 3172: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_DISTRIBUTIONS_PUB.getDistributions 3...');

3168: ,p_line_type => 'CLEAR'
3169: ,p_distribution_type => 'ORIGINATION');
3170: end if;
3171:
3172: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_DISTRIBUTIONS_PUB.getDistributions 3...');
3173: l_loan_receivables_orig := LNS_DISTRIBUTIONS_PUB.getDistributions(p_loan_id => p_loan_id
3174: ,p_account_type => 'DR'
3175: ,p_account_name => 'LOAN_RECEIVABLE'
3176: ,p_line_type => 'ORIG'

Line 3173: l_loan_receivables_orig := LNS_DISTRIBUTIONS_PUB.getDistributions(p_loan_id => p_loan_id

3169: ,p_distribution_type => 'ORIGINATION');
3170: end if;
3171:
3172: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_DISTRIBUTIONS_PUB.getDistributions 3...');
3173: l_loan_receivables_orig := LNS_DISTRIBUTIONS_PUB.getDistributions(p_loan_id => p_loan_id
3174: ,p_account_type => 'DR'
3175: ,p_account_name => 'LOAN_RECEIVABLE'
3176: ,p_line_type => 'ORIG'
3177: ,p_distribution_type => 'ORIGINATION');

Line 3179: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_DISTRIBUTIONS_PUB.getDistributions 4...');

3175: ,p_account_name => 'LOAN_RECEIVABLE'
3176: ,p_line_type => 'ORIG'
3177: ,p_distribution_type => 'ORIGINATION');
3178:
3179: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_DISTRIBUTIONS_PUB.getDistributions 4...');
3180: IF ((l_loan_class = 'ERS') AND (l_loan_status NOT IN ('INCOMPLETE', 'PENDING', 'APPROVED')) ) THEN
3181: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'FETCH ERS ACTIVE distributions');
3182: l_index := 0;
3183: OPEN c_get_prin_distr(p_loan_id);

Line 3215: l_loan_receivables_bill := LNS_DISTRIBUTIONS_PUB.getDistributions(p_loan_id => p_loan_id

3211:
3212: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'Fetched ' || l_loan_receivables_bill.count || ' records');
3213:
3214: ELSE
3215: l_loan_receivables_bill := LNS_DISTRIBUTIONS_PUB.getDistributions(p_loan_id => p_loan_id
3216: ,p_account_type => 'CR'
3217: ,p_account_name => 'LOAN_RECEIVABLE'
3218: ,p_line_type => 'PRIN'
3219: ,p_distribution_type => 'BILLING');

Line 3222: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_DISTRIBUTIONS_PUB.getDistributions 5...');

3218: ,p_line_type => 'PRIN'
3219: ,p_distribution_type => 'BILLING');
3220: END IF;
3221:
3222: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_DISTRIBUTIONS_PUB.getDistributions 5...');
3223: l_prin_receivables_bill := LNS_DISTRIBUTIONS_PUB.getDistributions(p_loan_id => p_loan_id
3224: ,p_account_type => 'DR'
3225: ,p_account_name => 'PRINCIPAL_RECEIVABLE'
3226: ,p_line_type => 'PRIN'

Line 3223: l_prin_receivables_bill := LNS_DISTRIBUTIONS_PUB.getDistributions(p_loan_id => p_loan_id

3219: ,p_distribution_type => 'BILLING');
3220: END IF;
3221:
3222: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_DISTRIBUTIONS_PUB.getDistributions 5...');
3223: l_prin_receivables_bill := LNS_DISTRIBUTIONS_PUB.getDistributions(p_loan_id => p_loan_id
3224: ,p_account_type => 'DR'
3225: ,p_account_name => 'PRINCIPAL_RECEIVABLE'
3226: ,p_line_type => 'PRIN'
3227: ,p_distribution_type => 'BILLING');

Line 3229: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_DISTRIBUTIONS_PUB.getDistributions 6...');

3225: ,p_account_name => 'PRINCIPAL_RECEIVABLE'
3226: ,p_line_type => 'PRIN'
3227: ,p_distribution_type => 'BILLING');
3228:
3229: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_DISTRIBUTIONS_PUB.getDistributions 6...');
3230: l_int_receivables_bill := LNS_DISTRIBUTIONS_PUB.getDistributions(p_loan_id => p_loan_id
3231: ,p_account_type => 'DR'
3232: ,p_account_name => 'INTEREST_RECEIVABLE'
3233: ,p_line_type => 'INT'

Line 3230: l_int_receivables_bill := LNS_DISTRIBUTIONS_PUB.getDistributions(p_loan_id => p_loan_id

3226: ,p_line_type => 'PRIN'
3227: ,p_distribution_type => 'BILLING');
3228:
3229: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_DISTRIBUTIONS_PUB.getDistributions 6...');
3230: l_int_receivables_bill := LNS_DISTRIBUTIONS_PUB.getDistributions(p_loan_id => p_loan_id
3231: ,p_account_type => 'DR'
3232: ,p_account_name => 'INTEREST_RECEIVABLE'
3233: ,p_line_type => 'INT'
3234: ,p_distribution_type => 'BILLING');

Line 3236: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_DISTRIBUTIONS_PUB.getDistributions 7...');

3232: ,p_account_name => 'INTEREST_RECEIVABLE'
3233: ,p_line_type => 'INT'
3234: ,p_distribution_type => 'BILLING');
3235:
3236: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_DISTRIBUTIONS_PUB.getDistributions 7...');
3237: l_int_income_bill := LNS_DISTRIBUTIONS_PUB.getDistributions(p_loan_id => p_loan_id
3238: ,p_account_type => 'CR'
3239: ,p_account_name => 'INTEREST_INCOME'
3240: ,p_line_type => 'INT'

Line 3237: l_int_income_bill := LNS_DISTRIBUTIONS_PUB.getDistributions(p_loan_id => p_loan_id

3233: ,p_line_type => 'INT'
3234: ,p_distribution_type => 'BILLING');
3235:
3236: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_DISTRIBUTIONS_PUB.getDistributions 7...');
3237: l_int_income_bill := LNS_DISTRIBUTIONS_PUB.getDistributions(p_loan_id => p_loan_id
3238: ,p_account_type => 'CR'
3239: ,p_account_name => 'INTEREST_INCOME'
3240: ,p_line_type => 'INT'
3241: ,p_distribution_type => 'BILLING');

Line 3775: l_distributions lns_distributions_pub.distribution_tbl;

3771: l_api_name varchar2(30);
3772: l_msg_count NUMBER;
3773: l_msg_data VARCHAR2(2000);
3774: l_return_Status VARCHAR2(1);
3775: l_distributions lns_distributions_pub.distribution_tbl;
3776: l_exists number;
3777: l_disb_header_id number;
3778: l_loan_amount_adj_id number;
3779: l_distributions_count number;

Line 4090: l_distributions lns_distributions_pub.distribution_tbl;

4086: i number;
4087: n number;
4088: l_code_combination_id number;
4089: l_code_combination_id_new_rec number;
4090: l_distributions lns_distributions_pub.distribution_tbl;
4091: l_distributionsCLEAR_ORIG lns_distributions_pub.distribution_tbl;
4092: l_distributionsREC_ORIG lns_distributions_pub.distribution_tbl;
4093: l_distributionsREC_BILL lns_distributions_pub.distribution_tbl;
4094: l_distributionsCatch lns_distributions_pub.distribution_tbl;

Line 4091: l_distributionsCLEAR_ORIG lns_distributions_pub.distribution_tbl;

4087: n number;
4088: l_code_combination_id number;
4089: l_code_combination_id_new_rec number;
4090: l_distributions lns_distributions_pub.distribution_tbl;
4091: l_distributionsCLEAR_ORIG lns_distributions_pub.distribution_tbl;
4092: l_distributionsREC_ORIG lns_distributions_pub.distribution_tbl;
4093: l_distributionsREC_BILL lns_distributions_pub.distribution_tbl;
4094: l_distributionsCatch lns_distributions_pub.distribution_tbl;
4095: l_distributionsALL lns_distributions_pub.distribution_tbl;

Line 4092: l_distributionsREC_ORIG lns_distributions_pub.distribution_tbl;

4088: l_code_combination_id number;
4089: l_code_combination_id_new_rec number;
4090: l_distributions lns_distributions_pub.distribution_tbl;
4091: l_distributionsCLEAR_ORIG lns_distributions_pub.distribution_tbl;
4092: l_distributionsREC_ORIG lns_distributions_pub.distribution_tbl;
4093: l_distributionsREC_BILL lns_distributions_pub.distribution_tbl;
4094: l_distributionsCatch lns_distributions_pub.distribution_tbl;
4095: l_distributionsALL lns_distributions_pub.distribution_tbl;
4096: l_distributions_count number;

Line 4093: l_distributionsREC_BILL lns_distributions_pub.distribution_tbl;

4089: l_code_combination_id_new_rec number;
4090: l_distributions lns_distributions_pub.distribution_tbl;
4091: l_distributionsCLEAR_ORIG lns_distributions_pub.distribution_tbl;
4092: l_distributionsREC_ORIG lns_distributions_pub.distribution_tbl;
4093: l_distributionsREC_BILL lns_distributions_pub.distribution_tbl;
4094: l_distributionsCatch lns_distributions_pub.distribution_tbl;
4095: l_distributionsALL lns_distributions_pub.distribution_tbl;
4096: l_distributions_count number;
4097: l_distributionsCatch_count number;

Line 4094: l_distributionsCatch lns_distributions_pub.distribution_tbl;

4090: l_distributions lns_distributions_pub.distribution_tbl;
4091: l_distributionsCLEAR_ORIG lns_distributions_pub.distribution_tbl;
4092: l_distributionsREC_ORIG lns_distributions_pub.distribution_tbl;
4093: l_distributionsREC_BILL lns_distributions_pub.distribution_tbl;
4094: l_distributionsCatch lns_distributions_pub.distribution_tbl;
4095: l_distributionsALL lns_distributions_pub.distribution_tbl;
4096: l_distributions_count number;
4097: l_distributionsCatch_count number;
4098: l_total_distributions number;

Line 4095: l_distributionsALL lns_distributions_pub.distribution_tbl;

4091: l_distributionsCLEAR_ORIG lns_distributions_pub.distribution_tbl;
4092: l_distributionsREC_ORIG lns_distributions_pub.distribution_tbl;
4093: l_distributionsREC_BILL lns_distributions_pub.distribution_tbl;
4094: l_distributionsCatch lns_distributions_pub.distribution_tbl;
4095: l_distributionsALL lns_distributions_pub.distribution_tbl;
4096: l_distributions_count number;
4097: l_distributionsCatch_count number;
4098: l_total_distributions number;
4099: l_ers_distribution_amount number;

Line 4101: l_ledger_details lns_distributions_pub.gl_ledger_details;

4097: l_distributionsCatch_count number;
4098: l_total_distributions number;
4099: l_ers_distribution_amount number;
4100: l_orig_distribution_amount number;
4101: l_ledger_details lns_distributions_pub.gl_ledger_details;
4102: l_include_receivables varchar2(1);
4103: l_sum number;
4104: l_multifund number;
4105: l_multifund_exists number;

Line 4381: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'Calling lns_distributions_pub.validateDefaultAccounting...');

4377: IF (p_loan_class_code = 'ERS'AND l_loan_status = 'INCOMPLETE') THEN
4378: return;
4379: END IF;
4380: */
4381: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'Calling lns_distributions_pub.validateDefaultAccounting...');
4382: lns_distributions_pub.validateDefaultAccounting(p_loan_class => l_loan_class
4383: ,p_loan_type_id => l_loan_type_id
4384: ,p_init_msg_list => p_init_msg_list
4385: ,x_return_status => l_return_status

Line 4382: lns_distributions_pub.validateDefaultAccounting(p_loan_class => l_loan_class

4378: return;
4379: END IF;
4380: */
4381: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'Calling lns_distributions_pub.validateDefaultAccounting...');
4382: lns_distributions_pub.validateDefaultAccounting(p_loan_class => l_loan_class
4383: ,p_loan_type_id => l_loan_type_id
4384: ,p_init_msg_list => p_init_msg_list
4385: ,x_return_status => l_return_status
4386: ,x_msg_count => l_msg_count

Line 4505: l_ledger_details := lns_distributions_pub.getLedgerDetails;

4501: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'Deleted '||SQL%ROWCOUNT||' rows');
4502:
4503: -- this switch is for the CatchAll Procedure
4504: l_include_receivables := 'N';
4505: l_ledger_details := lns_distributions_pub.getLedgerDetails;
4506: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'chart_of_accounts_id = ' || l_ledger_details.chart_of_accounts_id);
4507:
4508: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'Fetching documents to account...');
4509: open c_get_loan_documents(p_loan_id);

Line 4992: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'Calling lns_distributions_pub.validateAccounting...');

4988: do_insert_distributions(p_distributions_tbl => l_distributionsALL
4989: ,p_loan_id => p_loan_id);
4990:
4991: -- validate the accounting rows here
4992: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'Calling lns_distributions_pub.validateAccounting...');
4993: lns_distributions_pub.validateAccounting(p_loan_id => p_loan_id
4994: ,p_init_msg_list => p_init_msg_list
4995: ,x_return_status => l_return_status
4996: ,x_msg_count => l_msg_count

Line 4993: lns_distributions_pub.validateAccounting(p_loan_id => p_loan_id

4989: ,p_loan_id => p_loan_id);
4990:
4991: -- validate the accounting rows here
4992: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'Calling lns_distributions_pub.validateAccounting...');
4993: lns_distributions_pub.validateAccounting(p_loan_id => p_loan_id
4994: ,p_init_msg_list => p_init_msg_list
4995: ,x_return_status => l_return_status
4996: ,x_msg_count => l_msg_count
4997: ,x_msg_data => l_msg_data);

Line 5438: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling Lns_distributions_pub.defaultDistributions...');

5434:
5435:
5436:
5437: -- we should do online accounting in batch mode here
5438: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling Lns_distributions_pub.defaultDistributions...');
5439: Lns_distributions_pub.defaultDistributions(p_api_version => 1.0
5440: ,p_init_msg_list => FND_API.G_TRUE
5441: ,p_commit => FND_API.G_FALSE
5442: ,p_loan_id => P_LOAN_ID

Line 5439: Lns_distributions_pub.defaultDistributions(p_api_version => 1.0

5435:
5436:
5437: -- we should do online accounting in batch mode here
5438: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling Lns_distributions_pub.defaultDistributions...');
5439: Lns_distributions_pub.defaultDistributions(p_api_version => 1.0
5440: ,p_init_msg_list => FND_API.G_TRUE
5441: ,p_commit => FND_API.G_FALSE
5442: ,p_loan_id => P_LOAN_ID
5443: ,p_loan_class_code => l_loan_class_code

Line 5450: -- logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Call to Lns_distributions_pub.defaultDistributions failed with status ' || l_return_status);

5446: ,x_msg_data => l_msg_data);
5447: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status = ' || l_return_status);
5448:
5449: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5450: -- logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Call to Lns_distributions_pub.defaultDistributions failed with status ' || l_return_status);
5451: -- fnd_file.put_line(FND_FILE.LOG, 'FAILED TO INHERIT DISTRIBUTIONS');
5452: --l_last_api_called := 'Lns_distributions_pub.defaultDistributions';
5453: RAISE FND_API.G_EXC_ERROR;
5454: ELSE

Line 5452: --l_last_api_called := 'Lns_distributions_pub.defaultDistributions';

5448:
5449: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5450: -- logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Call to Lns_distributions_pub.defaultDistributions failed with status ' || l_return_status);
5451: -- fnd_file.put_line(FND_FILE.LOG, 'FAILED TO INHERIT DISTRIBUTIONS');
5452: --l_last_api_called := 'Lns_distributions_pub.defaultDistributions';
5453: RAISE FND_API.G_EXC_ERROR;
5454: ELSE
5455:
5456: if x_event_id is not null then

Line 5568: ,x_distribution_tbl IN OUT NOCOPY lns_distributions_pub.distribution_tbl

5564: procedure createDistrForImport(p_api_version IN NUMBER
5565: ,p_init_msg_list IN VARCHAR2
5566: ,p_commit IN VARCHAR2
5567: ,p_loan_id IN NUMBER
5568: ,x_distribution_tbl IN OUT NOCOPY lns_distributions_pub.distribution_tbl
5569: ,x_return_status OUT NOCOPY VARCHAR2
5570: ,x_msg_count OUT NOCOPY NUMBER
5571: ,x_msg_data OUT NOCOPY VARCHAR2)
5572:

Line 5617: lns_distributions_pub.validateAccounting(p_loan_id => p_loan_id

5613: ,p_loan_id => p_loan_id);
5614:
5615: -- validate the accounting rows here
5616: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' validating Accounting');
5617: lns_distributions_pub.validateAccounting(p_loan_id => p_loan_id
5618: ,p_init_msg_list => p_init_msg_list
5619: ,x_return_status => l_return_status
5620: ,x_msg_count => l_msg_count
5621: ,x_msg_data => l_msg_data);

Line 5876: LNS_DISTRIBUTIONS_PUB.create_DisbursementDistribs(p_api_version => 1

5872:
5873: END IF;
5874:
5875: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' Calling create_DisbursementDistribs');
5876: LNS_DISTRIBUTIONS_PUB.create_DisbursementDistribs(p_api_version => 1
5877: ,p_init_msg_list => 'F'
5878: ,p_commit => 'T'
5879: ,p_loan_id => l_loan_id
5880: ,p_disb_header_id => NULL

Line 6373: l_loan_receivables_orig LNS_DISTRIBUTIONS_PUB.distribution_tbl;

6369: ,x_msg_count OUT NOCOPY NUMBER
6370: ,x_msg_data OUT NOCOPY VARCHAR2)
6371: is
6372:
6373: l_loan_receivables_orig LNS_DISTRIBUTIONS_PUB.distribution_tbl;
6374: l_loan_clearing_orig LNS_DISTRIBUTIONS_PUB.distribution_tbl;
6375: l_loan_receivables_bill LNS_DISTRIBUTIONS_PUB.distribution_tbl;
6376: l_dist_percent_rec_bill number;
6377: l_api_name varchar2(30);

Line 6374: l_loan_clearing_orig LNS_DISTRIBUTIONS_PUB.distribution_tbl;

6370: ,x_msg_data OUT NOCOPY VARCHAR2)
6371: is
6372:
6373: l_loan_receivables_orig LNS_DISTRIBUTIONS_PUB.distribution_tbl;
6374: l_loan_clearing_orig LNS_DISTRIBUTIONS_PUB.distribution_tbl;
6375: l_loan_receivables_bill LNS_DISTRIBUTIONS_PUB.distribution_tbl;
6376: l_dist_percent_rec_bill number;
6377: l_api_name varchar2(30);
6378:

Line 6375: l_loan_receivables_bill LNS_DISTRIBUTIONS_PUB.distribution_tbl;

6371: is
6372:
6373: l_loan_receivables_orig LNS_DISTRIBUTIONS_PUB.distribution_tbl;
6374: l_loan_clearing_orig LNS_DISTRIBUTIONS_PUB.distribution_tbl;
6375: l_loan_receivables_bill LNS_DISTRIBUTIONS_PUB.distribution_tbl;
6376: l_dist_percent_rec_bill number;
6377: l_api_name varchar2(30);
6378:
6379: begin

Line 6394: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_DISTRIBUTIONS_PUB.getDistributions 1...');

6390: x_return_status := FND_API.G_RET_STS_SUCCESS;
6391:
6392: l_dist_percent_rec_bill := 0;
6393:
6394: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_DISTRIBUTIONS_PUB.getDistributions 1...');
6395: l_loan_clearing_orig := LNS_DISTRIBUTIONS_PUB.getDistributions(p_loan_id => p_loan_id
6396: ,p_loan_line_id => p_loan_line_id
6397: ,p_account_type => 'CR'
6398: ,p_account_name => 'LOAN_CLEARING'

Line 6395: l_loan_clearing_orig := LNS_DISTRIBUTIONS_PUB.getDistributions(p_loan_id => p_loan_id

6391:
6392: l_dist_percent_rec_bill := 0;
6393:
6394: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_DISTRIBUTIONS_PUB.getDistributions 1...');
6395: l_loan_clearing_orig := LNS_DISTRIBUTIONS_PUB.getDistributions(p_loan_id => p_loan_id
6396: ,p_loan_line_id => p_loan_line_id
6397: ,p_account_type => 'CR'
6398: ,p_account_name => 'LOAN_CLEARING'
6399: ,p_line_type => 'CLEAR'

Line 6403: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_DISTRIBUTIONS_PUB.getDistributions 2...');

6399: ,p_line_type => 'CLEAR'
6400: ,p_distribution_type => 'ORIGINATION');
6401: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_clearing_orig count = ' || l_loan_clearing_orig.count);
6402:
6403: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_DISTRIBUTIONS_PUB.getDistributions 2...');
6404: l_loan_receivables_orig := LNS_DISTRIBUTIONS_PUB.getDistributions(p_loan_id => p_loan_id
6405: ,p_loan_line_id => p_loan_line_id
6406: ,p_account_type => 'DR'
6407: ,p_account_name => 'LOAN_RECEIVABLE'

Line 6404: l_loan_receivables_orig := LNS_DISTRIBUTIONS_PUB.getDistributions(p_loan_id => p_loan_id

6400: ,p_distribution_type => 'ORIGINATION');
6401: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_clearing_orig count = ' || l_loan_clearing_orig.count);
6402:
6403: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_DISTRIBUTIONS_PUB.getDistributions 2...');
6404: l_loan_receivables_orig := LNS_DISTRIBUTIONS_PUB.getDistributions(p_loan_id => p_loan_id
6405: ,p_loan_line_id => p_loan_line_id
6406: ,p_account_type => 'DR'
6407: ,p_account_name => 'LOAN_RECEIVABLE'
6408: ,p_line_type => 'ORIG'

Line 6412: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_DISTRIBUTIONS_PUB.getDistributions 3...');

6408: ,p_line_type => 'ORIG'
6409: ,p_distribution_type => 'ORIGINATION');
6410: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_receivables_orig count = ' || l_loan_receivables_orig.count);
6411:
6412: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_DISTRIBUTIONS_PUB.getDistributions 3...');
6413: l_loan_receivables_bill := LNS_DISTRIBUTIONS_PUB.getDistributions(p_loan_id => p_loan_id
6414: ,p_loan_line_id => p_loan_line_id
6415: ,p_account_type => 'CR'
6416: ,p_account_name => 'LOAN_RECEIVABLE'

Line 6413: l_loan_receivables_bill := LNS_DISTRIBUTIONS_PUB.getDistributions(p_loan_id => p_loan_id

6409: ,p_distribution_type => 'ORIGINATION');
6410: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_receivables_orig count = ' || l_loan_receivables_orig.count);
6411:
6412: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_DISTRIBUTIONS_PUB.getDistributions 3...');
6413: l_loan_receivables_bill := LNS_DISTRIBUTIONS_PUB.getDistributions(p_loan_id => p_loan_id
6414: ,p_loan_line_id => p_loan_line_id
6415: ,p_account_type => 'CR'
6416: ,p_account_name => 'LOAN_RECEIVABLE'
6417: ,p_line_type => 'PRIN'

Line 6511: l_distributionsCLEAR_ORIG lns_distributions_pub.distribution_tbl;

6507: n number;
6508: y number;
6509: l_code_combination_id number;
6510: l_code_combination_id_new_rec number;
6511: l_distributionsCLEAR_ORIG lns_distributions_pub.distribution_tbl;
6512: l_distributionsREC_ORIG lns_distributions_pub.distribution_tbl;
6513: l_distributionsREC_BILL lns_distributions_pub.distribution_tbl;
6514: l_distributionsALL lns_distributions_pub.distribution_tbl;
6515: l_ers_distribution_amount number;

Line 6512: l_distributionsREC_ORIG lns_distributions_pub.distribution_tbl;

6508: y number;
6509: l_code_combination_id number;
6510: l_code_combination_id_new_rec number;
6511: l_distributionsCLEAR_ORIG lns_distributions_pub.distribution_tbl;
6512: l_distributionsREC_ORIG lns_distributions_pub.distribution_tbl;
6513: l_distributionsREC_BILL lns_distributions_pub.distribution_tbl;
6514: l_distributionsALL lns_distributions_pub.distribution_tbl;
6515: l_ers_distribution_amount number;
6516: l_ledger_details lns_distributions_pub.gl_ledger_details;

Line 6513: l_distributionsREC_BILL lns_distributions_pub.distribution_tbl;

6509: l_code_combination_id number;
6510: l_code_combination_id_new_rec number;
6511: l_distributionsCLEAR_ORIG lns_distributions_pub.distribution_tbl;
6512: l_distributionsREC_ORIG lns_distributions_pub.distribution_tbl;
6513: l_distributionsREC_BILL lns_distributions_pub.distribution_tbl;
6514: l_distributionsALL lns_distributions_pub.distribution_tbl;
6515: l_ers_distribution_amount number;
6516: l_ledger_details lns_distributions_pub.gl_ledger_details;
6517: l_sum number;

Line 6514: l_distributionsALL lns_distributions_pub.distribution_tbl;

6510: l_code_combination_id_new_rec number;
6511: l_distributionsCLEAR_ORIG lns_distributions_pub.distribution_tbl;
6512: l_distributionsREC_ORIG lns_distributions_pub.distribution_tbl;
6513: l_distributionsREC_BILL lns_distributions_pub.distribution_tbl;
6514: l_distributionsALL lns_distributions_pub.distribution_tbl;
6515: l_ers_distribution_amount number;
6516: l_ledger_details lns_distributions_pub.gl_ledger_details;
6517: l_sum number;
6518: l_natural_account_rec varchar2(25); -- the lns_def_distribs replacement for Loans Receivable

Line 6516: l_ledger_details lns_distributions_pub.gl_ledger_details;

6512: l_distributionsREC_ORIG lns_distributions_pub.distribution_tbl;
6513: l_distributionsREC_BILL lns_distributions_pub.distribution_tbl;
6514: l_distributionsALL lns_distributions_pub.distribution_tbl;
6515: l_ers_distribution_amount number;
6516: l_ledger_details lns_distributions_pub.gl_ledger_details;
6517: l_sum number;
6518: l_natural_account_rec varchar2(25); -- the lns_def_distribs replacement for Loans Receivable
6519: l_nat_acct_seg_number number;
6520: l_adjustment_exists boolean;

Line 6757: l_ledger_details := lns_distributions_pub.getLedgerDetails;

6753: end if;
6754:
6755: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'Starting ERS INHERITANCE');
6756:
6757: l_ledger_details := lns_distributions_pub.getLedgerDetails;
6758: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'chart_of_accounts_id = ' || l_ledger_details.chart_of_accounts_id);
6759:
6760: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'Fetching documents to account...');
6761: open c_get_line_documents(p_loan_line_id);

Line 7187: lns_distributions_pub.validateAddRecAccounting(p_loan_id => p_loan_id

7183: ,p_loan_id => p_loan_id);
7184:
7185: -- validate the accounting rows here
7186: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' validating Accounting');
7187: lns_distributions_pub.validateAddRecAccounting(p_loan_id => p_loan_id
7188: ,p_loan_line_id => p_loan_line_id
7189: ,p_init_msg_list => p_init_msg_list
7190: ,x_return_status => l_return_status
7191: ,x_msg_count => l_msg_count

Line 7325: l_distributions lns_distributions_pub.distribution_tbl;

7321: l_requested_amount NUMBER;
7322: l_funded_amount NUMBER;
7323: l_cancel_amount NUMBER;
7324:
7325: l_distributions lns_distributions_pub.distribution_tbl;
7326: l_line_type VARCHAR2(30);
7327: l_account_name VARCHAR2(30);
7328: l_code_combination_id NUMBER;
7329: l_account_type VARCHAR2(30);

Line 7338: l_ledger_details lns_distributions_pub.gl_ledger_details;

7334: l_receivSubsidyCnt NUMBER;
7335: l_clearOrigCnt NUMBER;
7336: l_clearSubsidyCnt NUMBER;
7337: l_loan_receivables_count NUMBER;
7338: l_ledger_details lns_distributions_pub.gl_ledger_details;
7339:
7340: l_run_rec_org_amt NUMBER;
7341: l_run_rec_sub_amt NUMBER;
7342: l_run_clear_org_amt NUMBER;

Line 7424: l_ledger_details := lns_distributions_pub.getLedgerDetails;

7420: l_run_rec_org_amt := 0;
7421: l_run_rec_sub_amt := 0;
7422: l_run_clear_org_amt:= 0;
7423: l_run_clear_sub_amt:= 0;
7424: l_ledger_details := lns_distributions_pub.getLedgerDetails;
7425:
7426: lns_utility_pub.validate_any_id(p_api_version => 1.0
7427: ,p_init_msg_list => p_init_msg_list
7428: ,x_msg_count => l_msg_count

Line 7699: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling lns_distributions_pub.onlineAccounting...');

7695:
7696:
7697: IF p_activity = 'LNS_SUBMITTED_DISB_CANCEL' THEN
7698: -- first complete accounting for any unprocessed events / documents for the loan transaction
7699: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling lns_distributions_pub.onlineAccounting...');
7700: lns_distributions_pub.onlineAccounting(p_loan_id => p_loan_id
7701: ,p_init_msg_list => fnd_api.g_false
7702: ,p_accounting_mode => 'F'
7703: ,p_transfer_flag => 'Y'

Line 7700: lns_distributions_pub.onlineAccounting(p_loan_id => p_loan_id

7696:
7697: IF p_activity = 'LNS_SUBMITTED_DISB_CANCEL' THEN
7698: -- first complete accounting for any unprocessed events / documents for the loan transaction
7699: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling lns_distributions_pub.onlineAccounting...');
7700: lns_distributions_pub.onlineAccounting(p_loan_id => p_loan_id
7701: ,p_init_msg_list => fnd_api.g_false
7702: ,p_accounting_mode => 'F'
7703: ,p_transfer_flag => 'Y'
7704: ,p_offline_flag => 'N'

Line 7727: LNS_DISTRIBUTIONS_PUB.create_DisbursementDistribs(

7723: if (lns_utility_pub.IS_FED_FIN_ENABLED = 'Y') then
7724:
7725: -- create disbursement distribution records in lns_distributions for Disbursement Submission
7726: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling create_DisbursementDistribs...');
7727: LNS_DISTRIBUTIONS_PUB.create_DisbursementDistribs(
7728: p_api_version => 1.0,
7729: p_init_msg_list => FND_API.G_FALSE,
7730: p_commit => FND_API.G_FALSE,
7731: p_loan_id => p_loan_id,

Line 7740: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Call to LNS_DISTRIBUTIONS_PUB.create_DisbursementDistribs for Disb Submit failed');

7736: x_msg_data => l_msg_data);
7737:
7738: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Return status: ' || l_return_status);
7739: IF l_return_status <> 'S' THEN
7740: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Call to LNS_DISTRIBUTIONS_PUB.create_DisbursementDistribs for Disb Submit failed');
7741: RAISE FND_API.G_EXC_ERROR;
7742: END IF;
7743:
7744: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'federal enabled');

Line 8424: l_distributions lns_distributions_pub.distribution_tbl;

8420: l_api_name varchar2(30);
8421: l_msg_count NUMBER;
8422: l_msg_data VARCHAR2(2000);
8423: l_return_Status VARCHAR2(1);
8424: l_distributions lns_distributions_pub.distribution_tbl;
8425: l_distributions_count NUMBER;
8426: l_activity VARCHAR2(30);
8427: l_exists NUMBER;
8428: l_accrued_amt NUMBER;

Line 8444: l_ledger_details lns_distributions_pub.gl_ledger_details;

8440: l_int_rec_line_cnt NUMBER;
8441: l_int_income_line_cnt NUMBER;
8442: l_int_rec_running_amt NUMBER;
8443: l_int_income_running_amt NUMBER;
8444: l_ledger_details lns_distributions_pub.gl_ledger_details;
8445: l_loan_num VARCHAR2(30);
8446:
8447:
8448:

Line 8544: l_ledger_details := lns_distributions_pub.getLedgerDetails;

8540: l_int_rec_line_cnt := 0;
8541: l_int_income_line_cnt := 0;
8542: l_int_rec_running_amt := 0;
8543: l_int_income_running_amt := 0;
8544: l_ledger_details := lns_distributions_pub.getLedgerDetails;
8545: ------------------------------
8546: l_accrued_amount := p_accrued_amount;
8547: -------------------------------
8548:

Line 9851: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Invoking LNS_DISTRIBUTIONS_PUB.do_int_accrual_reversal..');

9847: FOR l_Count1 IN 1..l_loans_to_accrue_tbl.COUNT LOOP
9848:
9849: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Processing loan #' || l_Count1||' - '||l_loans_to_accrue_tbl(l_Count1));
9850:
9851: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Invoking LNS_DISTRIBUTIONS_PUB.do_int_accrual_reversal..');
9852:
9853: l_start := sysdate;
9854: LNS_DISTRIBUTIONS_PUB.do_int_accrual_reversal(p_api_version => 1
9855: ,p_init_msg_list => 'T'

Line 9854: LNS_DISTRIBUTIONS_PUB.do_int_accrual_reversal(p_api_version => 1

9850:
9851: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Invoking LNS_DISTRIBUTIONS_PUB.do_int_accrual_reversal..');
9852:
9853: l_start := sysdate;
9854: LNS_DISTRIBUTIONS_PUB.do_int_accrual_reversal(p_api_version => 1
9855: ,p_init_msg_list => 'T'
9856: ,p_commit => 'F'
9857: ,p_loan_id => l_loans_to_accrue_tbl(l_Count1)
9858: ,p_period_name => p_period_name

Line 10109: ,x_distribution_tbl OUT NOCOPY lns_distributions_pub.distribution_tbl

10105: ,p_loan_id IN NUMBER
10106: ,p_disb_header_id IN NUMBER DEFAULT NULL
10107: ,p_loan_amount_adj_id IN NUMBER DEFAULT NULL
10108: ,p_activity IN VARCHAR2
10109: ,x_distribution_tbl OUT NOCOPY lns_distributions_pub.distribution_tbl
10110: ,x_return_status OUT NOCOPY VARCHAR2
10111: ,x_msg_count OUT NOCOPY NUMBER
10112: ,x_msg_data OUT NOCOPY VARCHAR2)
10113:

Line 10138: l_distributions lns_distributions_pub.distribution_tbl;

10134: l_funded_amount number;
10135: l_adj_reversal varchar2(1);
10136: l_loan_receivables_count number;
10137: l_loan_payables_count number;
10138: l_distributions lns_distributions_pub.distribution_tbl;
10139: l_dr_run_amount number;
10140: l_cr_run_amount number;
10141: drIndex number;
10142: crIndex number;

Line 10143: l_ledger_details lns_distributions_pub.gl_ledger_details;

10139: l_dr_run_amount number;
10140: l_cr_run_amount number;
10141: drIndex number;
10142: crIndex number;
10143: l_ledger_details lns_distributions_pub.gl_ledger_details;
10144: Type refCur is ref cursor;
10145: sql_Cur refCur;
10146: vSqlCur varchar2(1000);
10147: vPLSQL VARCHAR2(1000);

Line 10223: l_ledger_details := lns_distributions_pub.getLedgerDetails;

10219: drIndex := 0;
10220: crIndex := 0;
10221: l_dr_run_amount := 0;
10222: l_cr_run_amount := 0;
10223: l_ledger_details := lns_distributions_pub.getLedgerDetails;
10224:
10225: -- get fund amount
10226: l_adj_reversal := 'N';
10227: if p_activity = 'LOAN_AMOUNT_ADJUSTMENT' then

Line 10747: END LNS_DISTRIBUTIONS_PUB;

10743: END GENERATE_CCID_FOR_PROJECTS;
10744:
10745:
10746:
10747: END LNS_DISTRIBUTIONS_PUB;