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_LOAN_DOCUMENTS_PKG dependencies on LNS_LOAN_DOCUMENTS_S

Line 45: LNS_LOAN_DOCUMENTS_S.NEXTVAL

41: ,REQUEST_ID
42: ,OBJECT_VERSION_NUMBER
43: ,REASON
44: ) VALUES (
45: LNS_LOAN_DOCUMENTS_S.NEXTVAL
46: ,DECODE(P_SOURCE_ID, FND_API.G_MISS_NUM, NULL, P_SOURCE_ID)
47: ,DECODE(P_SOURCE_TABLE, FND_API.G_MISS_CHAR, NULL, P_SOURCE_TABLE)
48: ,DECODE(P_DOCUMENT_TYPE, FND_API.G_MISS_CHAR, NULL, P_DOCUMENT_TYPE)
49: ,DECODE(P_VERSION, FND_API.G_MISS_NUM, NULL, P_VERSION)

Line 89: UPDATE LNS_LOAN_DOCUMENTS SET

85: ,P_OBJECT_VERSION_NUMBER IN NUMBER
86: ,P_REASON IN VARCHAR2 DEFAULT NULL
87: ) IS
88: BEGIN
89: UPDATE LNS_LOAN_DOCUMENTS SET
90: DOCUMENT_ID = LNS_LOAN_DOCUMENTS_S.NEXTVAL
91: ,SOURCE_ID = DECODE(P_SOURCE_ID, FND_API.G_MISS_NUM, NULL, P_SOURCE_ID)
92: ,SOURCE_TABLE = DECODE(P_SOURCE_TABLE, FND_API.G_MISS_CHAR, NULL, P_SOURCE_TABLE)
93: ,DOCUMENT_TYPE = DECODE(P_DOCUMENT_TYPE, FND_API.G_MISS_CHAR, NULL, P_DOCUMENT_TYPE)

Line 90: DOCUMENT_ID = LNS_LOAN_DOCUMENTS_S.NEXTVAL

86: ,P_REASON IN VARCHAR2 DEFAULT NULL
87: ) IS
88: BEGIN
89: UPDATE LNS_LOAN_DOCUMENTS SET
90: DOCUMENT_ID = LNS_LOAN_DOCUMENTS_S.NEXTVAL
91: ,SOURCE_ID = DECODE(P_SOURCE_ID, FND_API.G_MISS_NUM, NULL, P_SOURCE_ID)
92: ,SOURCE_TABLE = DECODE(P_SOURCE_TABLE, FND_API.G_MISS_CHAR, NULL, P_SOURCE_TABLE)
93: ,DOCUMENT_TYPE = DECODE(P_DOCUMENT_TYPE, FND_API.G_MISS_CHAR, NULL, P_DOCUMENT_TYPE)
94: ,VERSION = DECODE(P_VERSION, FND_API.G_MISS_NUM, NULL, P_VERSION)