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 235: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE

231: ,DISABLE_INT_ACCRUAL_FLAG
232: ,BILL_ON_APPR_AMOUNT_FLAG
233: ) VALUES (
234: DECODE( X_LOAN_ID, FND_API.G_MISS_NUM, LNS_LOAN_HEADERS_S.NEXTVAL, NULL, LNS_LOAN_HEADERS_S.NEXTVAL, X_LOAN_ID )
235: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
236: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
237: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
238: ,LNS_UTILITY_PUB.CREATION_DATE
239: ,LNS_UTILITY_PUB.CREATED_BY

Line 236: ,LNS_UTILITY_PUB.LAST_UPDATED_BY

232: ,BILL_ON_APPR_AMOUNT_FLAG
233: ) VALUES (
234: DECODE( X_LOAN_ID, FND_API.G_MISS_NUM, LNS_LOAN_HEADERS_S.NEXTVAL, NULL, LNS_LOAN_HEADERS_S.NEXTVAL, X_LOAN_ID )
235: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
236: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
237: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
238: ,LNS_UTILITY_PUB.CREATION_DATE
239: ,LNS_UTILITY_PUB.CREATED_BY
240: ,LNS_UTILITY_PUB.PROGRAM_ID

Line 237: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

233: ) VALUES (
234: DECODE( X_LOAN_ID, FND_API.G_MISS_NUM, LNS_LOAN_HEADERS_S.NEXTVAL, NULL, LNS_LOAN_HEADERS_S.NEXTVAL, X_LOAN_ID )
235: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
236: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
237: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
238: ,LNS_UTILITY_PUB.CREATION_DATE
239: ,LNS_UTILITY_PUB.CREATED_BY
240: ,LNS_UTILITY_PUB.PROGRAM_ID
241: ,DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER )

Line 238: ,LNS_UTILITY_PUB.CREATION_DATE

234: DECODE( X_LOAN_ID, FND_API.G_MISS_NUM, LNS_LOAN_HEADERS_S.NEXTVAL, NULL, LNS_LOAN_HEADERS_S.NEXTVAL, X_LOAN_ID )
235: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
236: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
237: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
238: ,LNS_UTILITY_PUB.CREATION_DATE
239: ,LNS_UTILITY_PUB.CREATED_BY
240: ,LNS_UTILITY_PUB.PROGRAM_ID
241: ,DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER )
242: ,LNS_UTILITY_PUB.REQUEST_ID

Line 239: ,LNS_UTILITY_PUB.CREATED_BY

235: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
236: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
237: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
238: ,LNS_UTILITY_PUB.CREATION_DATE
239: ,LNS_UTILITY_PUB.CREATED_BY
240: ,LNS_UTILITY_PUB.PROGRAM_ID
241: ,DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER )
242: ,LNS_UTILITY_PUB.REQUEST_ID
243: ,DECODE( X_ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID )

Line 240: ,LNS_UTILITY_PUB.PROGRAM_ID

236: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
237: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
238: ,LNS_UTILITY_PUB.CREATION_DATE
239: ,LNS_UTILITY_PUB.CREATED_BY
240: ,LNS_UTILITY_PUB.PROGRAM_ID
241: ,DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER )
242: ,LNS_UTILITY_PUB.REQUEST_ID
243: ,DECODE( X_ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID )
244: ,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 242: ,LNS_UTILITY_PUB.REQUEST_ID

238: ,LNS_UTILITY_PUB.CREATION_DATE
239: ,LNS_UTILITY_PUB.CREATED_BY
240: ,LNS_UTILITY_PUB.PROGRAM_ID
241: ,DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER )
242: ,LNS_UTILITY_PUB.REQUEST_ID
243: ,DECODE( X_ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID )
244: ,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 )
245: ,DECODE( X_LOAN_APPLICATION_DATE, FND_API.G_MISS_DATE, NULL, X_LOAN_APPLICATION_DATE )
246: ,DECODE( X_END_DATE, FND_API.G_MISS_DATE, NULL, X_END_DATE )

Line 514: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE

510: );
511:
512: UPDATE LNS_LOAN_HEADERS_ALL SET
513: LOAN_ID = DECODE( X_LOAN_ID, NULL, LOAN_ID, FND_API.G_MISS_NUM, NULL, X_LOAN_ID )
514: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE
515: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
516: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
517: ,PROGRAM_ID = LNS_UTILITY_PUB.PROGRAM_ID
518: ,OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER )

Line 515: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY

511:
512: UPDATE LNS_LOAN_HEADERS_ALL SET
513: LOAN_ID = DECODE( X_LOAN_ID, NULL, LOAN_ID, FND_API.G_MISS_NUM, NULL, X_LOAN_ID )
514: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE
515: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
516: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
517: ,PROGRAM_ID = LNS_UTILITY_PUB.PROGRAM_ID
518: ,OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER )
519: ,REQUEST_ID = LNS_UTILITY_PUB.REQUEST_ID

Line 516: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

512: UPDATE LNS_LOAN_HEADERS_ALL SET
513: LOAN_ID = DECODE( X_LOAN_ID, NULL, LOAN_ID, FND_API.G_MISS_NUM, NULL, X_LOAN_ID )
514: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE
515: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
516: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
517: ,PROGRAM_ID = LNS_UTILITY_PUB.PROGRAM_ID
518: ,OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER )
519: ,REQUEST_ID = LNS_UTILITY_PUB.REQUEST_ID
520: ,ORG_ID = DECODE( X_ORG_ID, NULL, ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID )

Line 517: ,PROGRAM_ID = LNS_UTILITY_PUB.PROGRAM_ID

513: LOAN_ID = DECODE( X_LOAN_ID, NULL, LOAN_ID, FND_API.G_MISS_NUM, NULL, X_LOAN_ID )
514: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE
515: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
516: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
517: ,PROGRAM_ID = LNS_UTILITY_PUB.PROGRAM_ID
518: ,OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER )
519: ,REQUEST_ID = LNS_UTILITY_PUB.REQUEST_ID
520: ,ORG_ID = DECODE( X_ORG_ID, NULL, ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID )
521: ,LOAN_NUMBER = DECODE( X_LOAN_NUMBER, NULL, LOAN_NUMBER, FND_API.G_MISS_CHAR, NULL, X_LOAN_NUMBER )

Line 519: ,REQUEST_ID = LNS_UTILITY_PUB.REQUEST_ID

515: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
516: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
517: ,PROGRAM_ID = LNS_UTILITY_PUB.PROGRAM_ID
518: ,OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER )
519: ,REQUEST_ID = LNS_UTILITY_PUB.REQUEST_ID
520: ,ORG_ID = DECODE( X_ORG_ID, NULL, ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID )
521: ,LOAN_NUMBER = DECODE( X_LOAN_NUMBER, NULL, LOAN_NUMBER, FND_API.G_MISS_CHAR, NULL, X_LOAN_NUMBER )
522: ,LOAN_APPLICATION_DATE = DECODE( X_LOAN_APPLICATION_DATE, NULL, LOAN_APPLICATION_DATE, FND_API.G_MISS_DATE, NULL, X_LOAN_APPLICATION_DATE )
523: ,END_DATE = DECODE( X_END_DATE, NULL, END_DATE, FND_API.G_MISS_DATE, NULL, X_END_DATE )