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_HEADER_ALL_PKG dependencies on LNS_UTILITY_PUB

Line 227: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE

223: ,FORGIVENESS_FLAG
224: ,FORGIVENESS_PERCENT
225: ) VALUES (
226: DECODE( X_LOAN_ID, FND_API.G_MISS_NUM, LNS_LOAN_HEADERS_S.NEXTVAL, NULL, LNS_LOAN_HEADERS_S.NEXTVAL, X_LOAN_ID )
227: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
228: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
229: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
230: ,LNS_UTILITY_PUB.CREATION_DATE
231: ,LNS_UTILITY_PUB.CREATED_BY

Line 228: ,LNS_UTILITY_PUB.LAST_UPDATED_BY

224: ,FORGIVENESS_PERCENT
225: ) VALUES (
226: DECODE( X_LOAN_ID, FND_API.G_MISS_NUM, LNS_LOAN_HEADERS_S.NEXTVAL, NULL, LNS_LOAN_HEADERS_S.NEXTVAL, X_LOAN_ID )
227: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
228: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
229: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
230: ,LNS_UTILITY_PUB.CREATION_DATE
231: ,LNS_UTILITY_PUB.CREATED_BY
232: ,LNS_UTILITY_PUB.PROGRAM_ID

Line 229: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

225: ) VALUES (
226: DECODE( X_LOAN_ID, FND_API.G_MISS_NUM, LNS_LOAN_HEADERS_S.NEXTVAL, NULL, LNS_LOAN_HEADERS_S.NEXTVAL, X_LOAN_ID )
227: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
228: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
229: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
230: ,LNS_UTILITY_PUB.CREATION_DATE
231: ,LNS_UTILITY_PUB.CREATED_BY
232: ,LNS_UTILITY_PUB.PROGRAM_ID
233: ,DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER )

Line 230: ,LNS_UTILITY_PUB.CREATION_DATE

226: DECODE( X_LOAN_ID, FND_API.G_MISS_NUM, LNS_LOAN_HEADERS_S.NEXTVAL, NULL, LNS_LOAN_HEADERS_S.NEXTVAL, X_LOAN_ID )
227: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
228: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
229: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
230: ,LNS_UTILITY_PUB.CREATION_DATE
231: ,LNS_UTILITY_PUB.CREATED_BY
232: ,LNS_UTILITY_PUB.PROGRAM_ID
233: ,DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER )
234: ,LNS_UTILITY_PUB.REQUEST_ID

Line 231: ,LNS_UTILITY_PUB.CREATED_BY

227: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
228: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
229: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
230: ,LNS_UTILITY_PUB.CREATION_DATE
231: ,LNS_UTILITY_PUB.CREATED_BY
232: ,LNS_UTILITY_PUB.PROGRAM_ID
233: ,DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER )
234: ,LNS_UTILITY_PUB.REQUEST_ID
235: ,DECODE( X_ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID )

Line 232: ,LNS_UTILITY_PUB.PROGRAM_ID

228: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
229: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
230: ,LNS_UTILITY_PUB.CREATION_DATE
231: ,LNS_UTILITY_PUB.CREATED_BY
232: ,LNS_UTILITY_PUB.PROGRAM_ID
233: ,DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER )
234: ,LNS_UTILITY_PUB.REQUEST_ID
235: ,DECODE( X_ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID )
236: ,DECODE( X_LOAN_NUMBER, FND_API.G_MISS_CHAR, 'L'||TO_CHAR(LNS_LOAN_NUMBER_S.NEXTVAL), NULL, 'L'||TO_CHAR(LNS_LOAN_NUMBER_S.NEXTVAL), X_LOAN_NUMBER )

Line 234: ,LNS_UTILITY_PUB.REQUEST_ID

230: ,LNS_UTILITY_PUB.CREATION_DATE
231: ,LNS_UTILITY_PUB.CREATED_BY
232: ,LNS_UTILITY_PUB.PROGRAM_ID
233: ,DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER )
234: ,LNS_UTILITY_PUB.REQUEST_ID
235: ,DECODE( X_ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID )
236: ,DECODE( X_LOAN_NUMBER, FND_API.G_MISS_CHAR, 'L'||TO_CHAR(LNS_LOAN_NUMBER_S.NEXTVAL), NULL, 'L'||TO_CHAR(LNS_LOAN_NUMBER_S.NEXTVAL), X_LOAN_NUMBER )
237: ,DECODE( X_LOAN_APPLICATION_DATE, FND_API.G_MISS_DATE, NULL, X_LOAN_APPLICATION_DATE )
238: ,DECODE( X_END_DATE, FND_API.G_MISS_DATE, NULL, X_END_DATE )

Line 497: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE

493: );
494:
495: UPDATE LNS_LOAN_HEADERS_ALL SET
496: LOAN_ID = DECODE( X_LOAN_ID, NULL, LOAN_ID, FND_API.G_MISS_NUM, NULL, X_LOAN_ID )
497: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE
498: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
499: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
500: ,PROGRAM_ID = LNS_UTILITY_PUB.PROGRAM_ID
501: ,OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER )

Line 498: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY

494:
495: UPDATE LNS_LOAN_HEADERS_ALL SET
496: LOAN_ID = DECODE( X_LOAN_ID, NULL, LOAN_ID, FND_API.G_MISS_NUM, NULL, X_LOAN_ID )
497: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE
498: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
499: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
500: ,PROGRAM_ID = LNS_UTILITY_PUB.PROGRAM_ID
501: ,OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER )
502: ,REQUEST_ID = LNS_UTILITY_PUB.REQUEST_ID

Line 499: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

495: UPDATE LNS_LOAN_HEADERS_ALL SET
496: LOAN_ID = DECODE( X_LOAN_ID, NULL, LOAN_ID, FND_API.G_MISS_NUM, NULL, X_LOAN_ID )
497: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE
498: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
499: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
500: ,PROGRAM_ID = LNS_UTILITY_PUB.PROGRAM_ID
501: ,OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER )
502: ,REQUEST_ID = LNS_UTILITY_PUB.REQUEST_ID
503: ,ORG_ID = DECODE( X_ORG_ID, NULL, ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID )

Line 500: ,PROGRAM_ID = LNS_UTILITY_PUB.PROGRAM_ID

496: LOAN_ID = DECODE( X_LOAN_ID, NULL, LOAN_ID, FND_API.G_MISS_NUM, NULL, X_LOAN_ID )
497: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE
498: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
499: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
500: ,PROGRAM_ID = LNS_UTILITY_PUB.PROGRAM_ID
501: ,OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER )
502: ,REQUEST_ID = LNS_UTILITY_PUB.REQUEST_ID
503: ,ORG_ID = DECODE( X_ORG_ID, NULL, ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID )
504: ,LOAN_NUMBER = DECODE( X_LOAN_NUMBER, NULL, LOAN_NUMBER, FND_API.G_MISS_CHAR, NULL, X_LOAN_NUMBER )

Line 502: ,REQUEST_ID = LNS_UTILITY_PUB.REQUEST_ID

498: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
499: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
500: ,PROGRAM_ID = LNS_UTILITY_PUB.PROGRAM_ID
501: ,OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER )
502: ,REQUEST_ID = LNS_UTILITY_PUB.REQUEST_ID
503: ,ORG_ID = DECODE( X_ORG_ID, NULL, ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID )
504: ,LOAN_NUMBER = DECODE( X_LOAN_NUMBER, NULL, LOAN_NUMBER, FND_API.G_MISS_CHAR, NULL, X_LOAN_NUMBER )
505: ,LOAN_APPLICATION_DATE = DECODE( X_LOAN_APPLICATION_DATE, NULL, LOAN_APPLICATION_DATE, FND_API.G_MISS_DATE, NULL, X_LOAN_APPLICATION_DATE )
506: ,END_DATE = DECODE( X_END_DATE, NULL, END_DATE, FND_API.G_MISS_DATE, NULL, X_END_DATE )