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_REP_UTILS dependencies on LNS_LOAN_HEADERS_ALL

Line 231: l_start_date_from lns_loan_headers_all.loan_start_date%TYPE;

227: l_org_name hr_operating_units.NAME%TYPE;
228: l_borrower_name hz_parties.party_name%TYPE;
229: l_account_number hz_cust_accounts.account_number%TYPE;
230: l_cust_account_id hz_cust_accounts.cust_account_id%TYPE;
231: l_start_date_from lns_loan_headers_all.loan_start_date%TYPE;
232: l_start_date_to lns_loan_headers_all.loan_start_date%TYPE;
233: l_loan_type_desc lns_loan_types.loan_type_desc%TYPE;
234: l_loan_type_id lns_loan_types.loan_type_id%TYPE;
235: l_legal_entity_id xle_entity_profiles.legal_entity_id%TYPE;

Line 232: l_start_date_to lns_loan_headers_all.loan_start_date%TYPE;

228: l_borrower_name hz_parties.party_name%TYPE;
229: l_account_number hz_cust_accounts.account_number%TYPE;
230: l_cust_account_id hz_cust_accounts.cust_account_id%TYPE;
231: l_start_date_from lns_loan_headers_all.loan_start_date%TYPE;
232: l_start_date_to lns_loan_headers_all.loan_start_date%TYPE;
233: l_loan_type_desc lns_loan_types.loan_type_desc%TYPE;
234: l_loan_type_id lns_loan_types.loan_type_id%TYPE;
235: l_legal_entity_id xle_entity_profiles.legal_entity_id%TYPE;
236: l_legal_entity_name xle_entity_profiles.name%TYPE;

Line 301: 'lns_loan_headers_all_vl lh, ' ||

297: 'from LNS_LOAN_LINES ' ||
298: 'where loan_id = lh.LOAN_ID ' ||
299: 'and end_date is null) AS ORIGINAL_RECEIVABLES ' ||
300: 'from ' ||
301: 'lns_loan_headers_all_vl lh, ' ||
302: 'hz_parties hp, ' ||
303: 'lns_terms t, ' ||
304: 'lns_lookups llk, ' ||
305: 'LNS_PAY_SUM_V pay, ' ||

Line 634: l_start_date_from lns_loan_headers_all.loan_start_date%TYPE;

630: l_org_name hr_operating_units.NAME%TYPE;
631: l_borrower_name hz_parties.party_name%TYPE;
632: l_account_number hz_cust_accounts.account_number%TYPE;
633: l_cust_account_id hz_cust_accounts.cust_account_id%TYPE;
634: l_start_date_from lns_loan_headers_all.loan_start_date%TYPE;
635: l_start_date_to lns_loan_headers_all.loan_start_date%TYPE;
636: l_loan_type_desc lns_loan_types.loan_type_desc%TYPE;
637: l_loan_type_id lns_loan_types.loan_type_id%TYPE;
638: l_legal_entity_id xle_entity_profiles.legal_entity_id%TYPE;

Line 635: l_start_date_to lns_loan_headers_all.loan_start_date%TYPE;

631: l_borrower_name hz_parties.party_name%TYPE;
632: l_account_number hz_cust_accounts.account_number%TYPE;
633: l_cust_account_id hz_cust_accounts.cust_account_id%TYPE;
634: l_start_date_from lns_loan_headers_all.loan_start_date%TYPE;
635: l_start_date_to lns_loan_headers_all.loan_start_date%TYPE;
636: l_loan_type_desc lns_loan_types.loan_type_desc%TYPE;
637: l_loan_type_id lns_loan_types.loan_type_id%TYPE;
638: l_legal_entity_id xle_entity_profiles.legal_entity_id%TYPE;
639: l_legal_entity_name xle_entity_profiles.name%TYPE;

Line 840: 'lns_loan_headers_all_vl lh, ' ||

836: ' fund_act.lookup_type(+) = ''DISB_ACTIVITY'' and ' ||
837: ' fund_act.lookup_code(+) = head.ACTIVITY_CODE) ' ||
838: 'AS Disbursement_Schedule ' ||
839: 'from ' ||
840: 'lns_loan_headers_all_vl lh, ' ||
841: '(select lns_rep_utils.get_bill_due_date_from() from_dt, ' ||
842: ' lns_rep_utils.get_bill_due_date_to() to_dt ' ||
843: ' from dual) dateparameters, ' ||
844: 'hz_parties hp, ' ||

Line 1633: lns_loan_headers_all_vl lh,

1629: where agt.loan_id = lh.loan_id
1630: ) -- end of AMORTIZATION
1631: ), XMLFormat.createformat('ROWSET')).getClobVal()
1632: from
1633: lns_loan_headers_all_vl lh,
1634: hz_parties hp,
1635: lns_terms t,
1636: lns_int_rate_headers_vl intrt,
1637: lns_rate_schedules ratesch,

Line 1841: lns_loan_headers_all loan

1837: SELECT hou.name, gsb.currency_code
1838: INTO l_org_name, l_sob_currency_code
1839: FROM hr_operating_units hou,
1840: gl_sets_of_books gsb,
1841: lns_loan_headers_all loan
1842: WHERE hou.organization_id = loan.org_id
1843: AND gsb.set_of_books_id = hou.set_of_books_id
1844: AND loan.loan_id = p_loan_id;
1845:

Line 1983: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;

1979: ) IS
1980: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_AGREEMENT_REPORT';
1981: l_api_version CONSTANT NUMBER := 1.0;
1982: l_result_xml CLOB;
1983: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;
1984: l_loan_status LNS_LOAN_HEADERS_ALL.LOAN_STATUS%TYPE;
1985: l_document_id LNS_LOAN_DOCUMENTS.DOCUMENT_ID%TYPE;
1986: l_version LNS_LOAN_DOCUMENTS.VERSION%TYPE := -1;
1987: l_reason LNS_LOAN_DOCUMENTS.REASON%TYPE;

Line 1984: l_loan_status LNS_LOAN_HEADERS_ALL.LOAN_STATUS%TYPE;

1980: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_AGREEMENT_REPORT';
1981: l_api_version CONSTANT NUMBER := 1.0;
1982: l_result_xml CLOB;
1983: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;
1984: l_loan_status LNS_LOAN_HEADERS_ALL.LOAN_STATUS%TYPE;
1985: l_document_id LNS_LOAN_DOCUMENTS.DOCUMENT_ID%TYPE;
1986: l_version LNS_LOAN_DOCUMENTS.VERSION%TYPE := -1;
1987: l_reason LNS_LOAN_DOCUMENTS.REASON%TYPE;
1988: l_object_version_number NUMBER;

Line 1998: from lns_loan_headers_all lh

1994:
1995: l_loan_id := LOAN_ID;
1996:
1997: select lh.loan_status into l_loan_status
1998: from lns_loan_headers_all lh
1999: where lh.loan_id = l_loan_id;
2000:
2001: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Loan Id = ' || LOAN_ID);
2002: LogMessage(FND_LOG.LEVEL_STATEMENT, 'REASON = ' || P_REASON);

Line 2009: where source_table = 'LNS_LOAN_HEADERS_ALL'

2005: IF (l_loan_status <> 'DELETED' AND l_loan_status <> 'PAIDOFF' AND l_loan_status <> 'REJECTED') THEN
2006:
2007: select max(version) into l_version
2008: from lns_loan_documents
2009: where source_table = 'LNS_LOAN_HEADERS_ALL'
2010: and source_id = l_loan_id
2011: and document_type = 'LOAN_AGREEMENT';
2012:
2013: IF (l_version is null or l_version = 0 or l_loan_status = 'INCOMPLETE' or l_loan_status = 'PENDING') then

Line 2048: ,P_SOURCE_TABLE =>'LNS_LOAN_HEADERS_ALL'

2044: IF(l_count = 0) THEN
2045: LogMessage(FND_LOG.LEVEL_STATEMENT,'For incomplete loan, inserting loan agreement for first time');
2046: LNS_LOAN_DOCUMENTS_PKG.Insert_Row(X_DOCUMENT_ID => l_document_id
2047: ,P_SOURCE_ID => l_loan_id
2048: ,P_SOURCE_TABLE =>'LNS_LOAN_HEADERS_ALL'
2049: ,P_DOCUMENT_TYPE => 'LOAN_AGREEMENT'
2050: ,P_VERSION => l_version
2051: ,P_DOCUMENT_XML => l_result_xml
2052: ,P_OBJECT_VERSION_NUMBER => l_object_version_number

Line 2058: ,P_SOURCE_TABLE =>'LNS_LOAN_HEADERS_ALL'

2054: ELSE
2055: LogMessage(FND_LOG.LEVEL_STATEMENT,'Updating the existing agreement instead of creating a new record in DB');
2056: LNS_LOAN_DOCUMENTS_PKG.Update_Row(X_DOCUMENT_ID => l_document_id
2057: ,P_SOURCE_ID => l_loan_id
2058: ,P_SOURCE_TABLE =>'LNS_LOAN_HEADERS_ALL'
2059: ,P_DOCUMENT_TYPE => 'LOAN_AGREEMENT'
2060: ,P_VERSION => l_version
2061: ,P_DOCUMENT_XML => l_result_xml
2062: ,P_OBJECT_VERSION_NUMBER => l_object_version_number

Line 2076: ,P_SOURCE_TABLE =>'LNS_LOAN_HEADERS_ALL'

2072:
2073: LogMessage(FND_LOG.LEVEL_STATEMENT,'Creating a new Agreement record in DB');
2074: LNS_LOAN_DOCUMENTS_PKG.Insert_Row(X_DOCUMENT_ID => l_document_id
2075: ,P_SOURCE_ID => l_loan_id
2076: ,P_SOURCE_TABLE =>'LNS_LOAN_HEADERS_ALL'
2077: ,P_DOCUMENT_TYPE => 'LOAN_AGREEMENT'
2078: ,P_VERSION => l_version
2079: ,P_DOCUMENT_XML => l_result_xml
2080: ,P_OBJECT_VERSION_NUMBER => l_object_version_number

Line 2105: l_loan_status LNS_LOAN_HEADERS_ALL.LOAN_STATUS%TYPE;

2101: l_api_version CONSTANT NUMBER := 1.0;
2102: l_result_xml CLOB;
2103: l_document_id LNS_LOAN_DOCUMENTS.DOCUMENT_ID%TYPE;
2104: l_reason LNS_LOAN_DOCUMENTS.REASON%TYPE;
2105: l_loan_status LNS_LOAN_HEADERS_ALL.LOAN_STATUS%TYPE;
2106: l_version NUMBER;
2107: l_object_version_number NUMBER;
2108:
2109: cursor csr_loan_agreement IS

Line 2112: where source_table = 'LNS_LOAN_HEADERS_ALL'

2108:
2109: cursor csr_loan_agreement IS
2110: select document_xml
2111: from lns_loan_documents
2112: where source_table = 'LNS_LOAN_HEADERS_ALL'
2113: and source_id = p_loan_id
2114: and version = 1
2115: and document_type = 'LOAN_AGREEMENT';
2116:

Line 2122: from lns_loan_headers_all lh

2118:
2119: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
2120:
2121: select lh.loan_status into l_loan_status
2122: from lns_loan_headers_all lh
2123: where lh.loan_id = P_LOAN_ID;
2124:
2125: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_LOAN_ID = ' || P_LOAN_ID);
2126: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_AGREEMENT_REASON = ' || P_AGREEMENT_REASON);

Line 2166: ,P_SOURCE_TABLE =>'LNS_LOAN_HEADERS_ALL'

2162:
2163: LogMessage(FND_LOG.LEVEL_STATEMENT,'Inserting loan agreement for first time...');
2164: LNS_LOAN_DOCUMENTS_PKG.Insert_Row(X_DOCUMENT_ID => l_document_id
2165: ,P_SOURCE_ID => p_loan_id
2166: ,P_SOURCE_TABLE =>'LNS_LOAN_HEADERS_ALL'
2167: ,P_DOCUMENT_TYPE => 'LOAN_AGREEMENT'
2168: ,P_VERSION => 1
2169: ,P_DOCUMENT_XML => l_result_xml
2170: ,P_OBJECT_VERSION_NUMBER => 1

Line 2178: ,P_SOURCE_TABLE =>'LNS_LOAN_HEADERS_ALL'

2174:
2175: LogMessage(FND_LOG.LEVEL_STATEMENT,'Updating the existing agreement...');
2176: LNS_LOAN_DOCUMENTS_PKG.Update_Row(X_DOCUMENT_ID => l_document_id
2177: ,P_SOURCE_ID => p_loan_id
2178: ,P_SOURCE_TABLE =>'LNS_LOAN_HEADERS_ALL'
2179: ,P_DOCUMENT_TYPE => 'LOAN_AGREEMENT'
2180: ,P_VERSION => l_version
2181: ,P_DOCUMENT_XML => l_result_xml
2182: ,P_OBJECT_VERSION_NUMBER => l_object_version_number

Line 2210: select org_id from lns_loan_headers_all where loan_id = P_LOAN_ID;

2206: l_request_id number;
2207: l_org_id number;
2208:
2209: CURSOR loan_cur(P_LOAN_ID number) IS
2210: select org_id from lns_loan_headers_all where loan_id = P_LOAN_ID;
2211:
2212: BEGIN
2213:
2214: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');

Line 2360: LNS_LOAN_HEADERS_ALL head

2356: head.OBJECT_VERSION_NUMBER,
2357: head.loan_id,
2358: head.loan_number
2359: from
2360: LNS_LOAN_HEADERS_ALL head
2361: where
2362: head.loan_assigned_to = p_from_loan_officer;
2363: BEGIN
2364:

Line 2953: 'from LNS_LOAN_HEADERS_ALL_VL';

2949: 'LOAN_CURRENCY, ' ||
2950: 'ORG_ID, ' ||
2951: 'LEGAL_ENTITY_ID, ' ||
2952: 'LOAN_STATUS ' ||
2953: 'from LNS_LOAN_HEADERS_ALL_VL';
2954:
2955: if ORG_ID is not null then
2956: if l_where is not null then
2957: l_where := l_where || ' and ';