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 205: l_start_date_from lns_loan_headers_all.loan_start_date%TYPE;

201: l_org_name hr_operating_units.NAME%TYPE;
202: l_borrower_name hz_parties.party_name%TYPE;
203: l_account_number hz_cust_accounts.account_number%TYPE;
204: l_cust_account_id hz_cust_accounts.cust_account_id%TYPE;
205: l_start_date_from lns_loan_headers_all.loan_start_date%TYPE;
206: l_start_date_to lns_loan_headers_all.loan_start_date%TYPE;
207: l_loan_type_desc lns_loan_types.loan_type_desc%TYPE;
208: l_loan_type_id lns_loan_types.loan_type_id%TYPE;
209: l_legal_entity_id xle_entity_profiles.legal_entity_id%TYPE;

Line 206: l_start_date_to lns_loan_headers_all.loan_start_date%TYPE;

202: l_borrower_name hz_parties.party_name%TYPE;
203: l_account_number hz_cust_accounts.account_number%TYPE;
204: l_cust_account_id hz_cust_accounts.cust_account_id%TYPE;
205: l_start_date_from lns_loan_headers_all.loan_start_date%TYPE;
206: l_start_date_to lns_loan_headers_all.loan_start_date%TYPE;
207: l_loan_type_desc lns_loan_types.loan_type_desc%TYPE;
208: l_loan_type_id lns_loan_types.loan_type_id%TYPE;
209: l_legal_entity_id xle_entity_profiles.legal_entity_id%TYPE;
210: l_legal_entity_name xle_entity_profiles.name%TYPE;

Line 275: 'lns_loan_headers_all lh, ' ||

271: 'from LNS_LOAN_LINES ' ||
272: 'where loan_id = lh.LOAN_ID ' ||
273: 'and end_date is null ) AS ORIGINAL_RECEIVABLES ' ||
274: 'from ' ||
275: 'lns_loan_headers_all lh, ' ||
276: 'hz_parties hp, ' ||
277: 'lns_terms t, ' ||
278: 'lns_lookups llk, ' ||
279: 'LNS_PAY_SUM_V pay, ' ||

Line 571: l_start_date_from lns_loan_headers_all.loan_start_date%TYPE;

567: l_org_name hr_operating_units.NAME%TYPE;
568: l_borrower_name hz_parties.party_name%TYPE;
569: l_account_number hz_cust_accounts.account_number%TYPE;
570: l_cust_account_id hz_cust_accounts.cust_account_id%TYPE;
571: l_start_date_from lns_loan_headers_all.loan_start_date%TYPE;
572: l_start_date_to lns_loan_headers_all.loan_start_date%TYPE;
573: l_loan_type_desc lns_loan_types.loan_type_desc%TYPE;
574: l_loan_type_id lns_loan_types.loan_type_id%TYPE;
575: l_legal_entity_id xle_entity_profiles.legal_entity_id%TYPE;

Line 572: l_start_date_to lns_loan_headers_all.loan_start_date%TYPE;

568: l_borrower_name hz_parties.party_name%TYPE;
569: l_account_number hz_cust_accounts.account_number%TYPE;
570: l_cust_account_id hz_cust_accounts.cust_account_id%TYPE;
571: l_start_date_from lns_loan_headers_all.loan_start_date%TYPE;
572: l_start_date_to lns_loan_headers_all.loan_start_date%TYPE;
573: l_loan_type_desc lns_loan_types.loan_type_desc%TYPE;
574: l_loan_type_id lns_loan_types.loan_type_id%TYPE;
575: l_legal_entity_id xle_entity_profiles.legal_entity_id%TYPE;
576: l_legal_entity_name xle_entity_profiles.name%TYPE;

Line 777: 'lns_loan_headers_all lh, ' ||

773: ' fund_act.lookup_type(+) = ''DISB_ACTIVITY'' and ' ||
774: ' fund_act.lookup_code(+) = head.ACTIVITY_CODE) ' ||
775: 'AS Disbursement_Schedule ' ||
776: 'from ' ||
777: 'lns_loan_headers_all lh, ' ||
778: '(select lns_rep_utils.get_bill_due_date_from() from_dt, ' ||
779: ' lns_rep_utils.get_bill_due_date_to() to_dt ' ||
780: ' from dual) dateparameters, ' ||
781: 'hz_parties hp, ' ||

Line 1529: lns_loan_headers_all lh,

1525: where agt.loan_id = lh.loan_id
1526: ) -- end of AMORTIZATION
1527: ), XMLFormat.createformat('ROWSET')).getClobVal()
1528: from
1529: lns_loan_headers_all lh,
1530: hz_parties hp,
1531: lns_terms t,
1532: lns_int_rate_headers intrt,
1533: lns_rate_schedules ratesch,

Line 1837: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;

1833: ) IS
1834: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_AGREEMENT_REPORT';
1835: l_api_version CONSTANT NUMBER := 1.0;
1836: l_result_xml CLOB;
1837: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;
1838: l_loan_status LNS_LOAN_HEADERS_ALL.LOAN_STATUS%TYPE;
1839: l_document_id LNS_LOAN_DOCUMENTS.DOCUMENT_ID%TYPE;
1840: l_version LNS_LOAN_DOCUMENTS.VERSION%TYPE := -1;
1841: l_agreement_exist_flag VARCHAR2(1) := 'Y';

Line 1838: l_loan_status LNS_LOAN_HEADERS_ALL.LOAN_STATUS%TYPE;

1834: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_AGREEMENT_REPORT';
1835: l_api_version CONSTANT NUMBER := 1.0;
1836: l_result_xml CLOB;
1837: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;
1838: l_loan_status LNS_LOAN_HEADERS_ALL.LOAN_STATUS%TYPE;
1839: l_document_id LNS_LOAN_DOCUMENTS.DOCUMENT_ID%TYPE;
1840: l_version LNS_LOAN_DOCUMENTS.VERSION%TYPE := -1;
1841: l_agreement_exist_flag VARCHAR2(1) := 'Y';
1842:

Line 1846: where ld.source_table = 'LNS_LOAN_HEADERS_ALL'

1842:
1843: cursor csr_loan_agreement IS
1844: select document_id, document_xml, version
1845: from lns_loan_documents ld
1846: where ld.source_table = 'LNS_LOAN_HEADERS_ALL'
1847: and ld.source_id = l_loan_id
1848: and ld.document_type = 'LOAN_AGREEMENT'
1849: ORDER BY ld.version DESC;
1850: cursor csr_loan_status IS

Line 1852: from lns_loan_headers_all lh

1848: and ld.document_type = 'LOAN_AGREEMENT'
1849: ORDER BY ld.version DESC;
1850: cursor csr_loan_status IS
1851: select loan_status
1852: from lns_loan_headers_all lh
1853: where lh.loan_id = l_loan_id;
1854: BEGIN
1855: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
1856: l_loan_id := loan_id;

Line 1898: ,P_SOURCE_TABLE =>'LNS_LOAN_HEADERS_ALL'

1894:
1895: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'Inserting agreement in lns_loan_documents');
1896: LNS_LOAN_DOCUMENTS_PKG.Insert_Row(X_DOCUMENT_ID => l_document_id
1897: ,P_SOURCE_ID => loan_id
1898: ,P_SOURCE_TABLE =>'LNS_LOAN_HEADERS_ALL'
1899: ,P_DOCUMENT_TYPE => 'LOAN_AGREEMENT'
1900: ,P_VERSION => l_version
1901: ,P_DOCUMENT_XML => l_result_xml
1902: ,P_OBJECT_VERSION_NUMBER => 1);

Line 1933: where source_table = 'LNS_LOAN_HEADERS_ALL'

1929: l_document_id LNS_LOAN_DOCUMENTS.DOCUMENT_ID%TYPE;
1930: cursor csr_loan_agreement IS
1931: select document_xml
1932: from lns_loan_documents
1933: where source_table = 'LNS_LOAN_HEADERS_ALL'
1934: and source_id = p_loan_id
1935: and version = 1
1936: and document_type = 'LOAN_AGREEMENT';
1937: BEGIN

Line 1947: ,P_SOURCE_TABLE =>'LNS_LOAN_HEADERS_ALL'

1943: GEN_AGREEMENT_XML(p_AgreementXML=> l_result_xml,
1944: p_loan_id => p_loan_id);
1945: LNS_LOAN_DOCUMENTS_PKG.Insert_Row(X_DOCUMENT_ID => l_document_id
1946: ,P_SOURCE_ID => p_loan_id
1947: ,P_SOURCE_TABLE =>'LNS_LOAN_HEADERS_ALL'
1948: ,P_DOCUMENT_TYPE => 'LOAN_AGREEMENT'
1949: ,P_VERSION => 1
1950: ,P_DOCUMENT_XML => l_result_xml
1951: ,P_OBJECT_VERSION_NUMBER => 1);