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.

[Home] [Help]

APPS.LNS_REP_UTILS dependencies on LNS_LOAN_DOCUMENTS

Line 1985: l_document_id LNS_LOAN_DOCUMENTS.DOCUMENT_ID%TYPE;

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;
1989: l_count NUMBER;

Line 1986: l_version LNS_LOAN_DOCUMENTS.VERSION%TYPE := -1;

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;
1989: l_count NUMBER;
1990: l_agreement_exist_flag VARCHAR2(1) := 'Y';

Line 1987: l_reason LNS_LOAN_DOCUMENTS.REASON%TYPE;

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;
1989: l_count NUMBER;
1990: l_agreement_exist_flag VARCHAR2(1) := 'Y';
1991:

Line 2008: from lns_loan_documents

2004:
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:

Line 2041: from lns_loan_documents

2037: p_loan_id => l_loan_id,
2038: p_based_on_terms => 'ORIGINAL');
2039:
2040: select count(*) into l_count
2041: from lns_loan_documents
2042: where source_id = l_loan_id;
2043:
2044: IF(l_count = 0) THEN
2045: LogMessage(FND_LOG.LEVEL_STATEMENT,'For incomplete loan, inserting loan agreement for first time');

Line 2046: LNS_LOAN_DOCUMENTS_PKG.Insert_Row(X_DOCUMENT_ID => l_document_id

2042: where source_id = l_loan_id;
2043:
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

Line 2056: LNS_LOAN_DOCUMENTS_PKG.Update_Row(X_DOCUMENT_ID => l_document_id

2052: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
2053: ,P_REASON => l_reason);
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

Line 2074: LNS_LOAN_DOCUMENTS_PKG.Insert_Row(X_DOCUMENT_ID => l_document_id

2070: p_loan_id => l_loan_id,
2071: p_based_on_terms => 'CURRENT');
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

Line 2103: l_document_id LNS_LOAN_DOCUMENTS.DOCUMENT_ID%TYPE;

2099: ,P_AGREEMENT_REASON IN VARCHAR2 DEFAULT NULL) IS
2100: l_api_name CONSTANT VARCHAR2(30) := 'STORE_LOAN_AGREEMENT_REPORT';
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;

Line 2104: l_reason LNS_LOAN_DOCUMENTS.REASON%TYPE;

2100: l_api_name CONSTANT VARCHAR2(30) := 'STORE_LOAN_AGREEMENT_REPORT';
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:

Line 2111: from lns_loan_documents

2107: l_object_version_number NUMBER;
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';

Line 2164: LNS_LOAN_DOCUMENTS_PKG.Insert_Row(X_DOCUMENT_ID => l_document_id

2160:
2161: IF csr_loan_agreement%NOTFOUND THEN
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

Line 2176: LNS_LOAN_DOCUMENTS_PKG.Update_Row(X_DOCUMENT_ID => l_document_id

2172:
2173: ELSE
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