DBA Data[Home] [Help]

APPS.LNS_LOAN_HEADER_ALL_PKG dependencies on FND_GLOBAL

Line 353: ,fnd_global.user_id

349: ,DECODE( X_LOAN_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, X_LOAN_DESCRIPTION )
350: ,DECODE( X_REFERENCE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, X_REFERENCE_DESCRIPTION )
351: ,L.LANGUAGE_CODE
352: ,userenv('LANG')
353: ,fnd_global.user_id
354: ,sysdate
355: ,sysdate
356: ,fnd_global.user_id
357: ,fnd_global.user_id

Line 356: ,fnd_global.user_id

352: ,userenv('LANG')
353: ,fnd_global.user_id
354: ,sysdate
355: ,sysdate
356: ,fnd_global.user_id
357: ,fnd_global.user_id
358: FROM FND_LANGUAGES L
359: where L.INSTALLED_FLAG in ('I', 'B')
360: AND not exists

Line 357: ,fnd_global.user_id

353: ,fnd_global.user_id
354: ,sysdate
355: ,sysdate
356: ,fnd_global.user_id
357: ,fnd_global.user_id
358: FROM FND_LANGUAGES L
359: where L.INSTALLED_FLAG in ('I', 'B')
360: AND not exists
361: (select NULL

Line 607: ,LAST_UPDATED_BY = fnd_global.user_id

603: UPDATE LNS_LOAN_HEADERS_ALL_TL SET
604: LOAN_DESCRIPTION = DECODE( X_LOAN_DESCRIPTION, NULL, LOAN_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, X_LOAN_DESCRIPTION )
605: ,REFERENCE_DESCRIPTION = DECODE( X_REFERENCE_DESCRIPTION, NULL, REFERENCE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, X_REFERENCE_DESCRIPTION )
606: ,LAST_UPDATE_DATE = sysdate
607: ,LAST_UPDATED_BY = fnd_global.user_id
608: ,LAST_UPDATE_LOGIN = fnd_global.user_id
609: ,SOURCE_LANG = userenv('LANG')
610: WHERE LOAN_ID = X_LOAN_ID
611: AND userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line 608: ,LAST_UPDATE_LOGIN = fnd_global.user_id

604: LOAN_DESCRIPTION = DECODE( X_LOAN_DESCRIPTION, NULL, LOAN_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, X_LOAN_DESCRIPTION )
605: ,REFERENCE_DESCRIPTION = DECODE( X_REFERENCE_DESCRIPTION, NULL, REFERENCE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, X_REFERENCE_DESCRIPTION )
606: ,LAST_UPDATE_DATE = sysdate
607: ,LAST_UPDATED_BY = fnd_global.user_id
608: ,LAST_UPDATE_LOGIN = fnd_global.user_id
609: ,SOURCE_LANG = userenv('LANG')
610: WHERE LOAN_ID = X_LOAN_ID
611: AND userenv('LANG') in (LANGUAGE, SOURCE_LANG);
612: