APPS.LNS_REP_UTILS dependencies on LNS_LOAN_DOCUMENTS_PKG

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