DBA Data[Home] [Help]

APPS.LNS_COND_ASSIGNMENTS_PKG dependencies on FND_GLOBAL

Line 90: ,fnd_global.user_id

86: X_COND_ASSIGNMENT_ID
87: ,DECODE(P_CONDITION_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, P_CONDITION_DESCRIPTION)
88: ,L.LANGUAGE_CODE
89: ,userenv('LANG')
90: ,fnd_global.user_id
91: ,sysdate
92: ,sysdate
93: ,fnd_global.user_id
94: ,fnd_global.user_id

Line 93: ,fnd_global.user_id

89: ,userenv('LANG')
90: ,fnd_global.user_id
91: ,sysdate
92: ,sysdate
93: ,fnd_global.user_id
94: ,fnd_global.user_id
95: FROM FND_LANGUAGES L
96: where L.INSTALLED_FLAG in ('I', 'B')
97: AND L.LANGUAGE_CODE = userenv('LANG')

Line 94: ,fnd_global.user_id

90: ,fnd_global.user_id
91: ,sysdate
92: ,sysdate
93: ,fnd_global.user_id
94: ,fnd_global.user_id
95: FROM FND_LANGUAGES L
96: where L.INSTALLED_FLAG in ('I', 'B')
97: AND L.LANGUAGE_CODE = userenv('LANG')
98: AND not exists

Line 121: ,fnd_global.user_id

117: X_COND_ASSIGNMENT_ID
118: ,SourceTL.CONDITION_DESCRIPTION
119: ,SourceTL.LANGUAGE
120: ,SourceTL.SOURCE_LANG
121: ,fnd_global.user_id
122: ,sysdate
123: ,sysdate
124: ,fnd_global.user_id
125: ,fnd_global.user_id

Line 124: ,fnd_global.user_id

120: ,SourceTL.SOURCE_LANG
121: ,fnd_global.user_id
122: ,sysdate
123: ,sysdate
124: ,fnd_global.user_id
125: ,fnd_global.user_id
126: FROM FND_LANGUAGES L, LNS_CONDITIONS_TL SourceTL
127: where L.INSTALLED_FLAG in ('I', 'B')
128: and L.LANGUAGE_CODE <> userenv('LANG')

Line 125: ,fnd_global.user_id

121: ,fnd_global.user_id
122: ,sysdate
123: ,sysdate
124: ,fnd_global.user_id
125: ,fnd_global.user_id
126: FROM FND_LANGUAGES L, LNS_CONDITIONS_TL SourceTL
127: where L.INSTALLED_FLAG in ('I', 'B')
128: and L.LANGUAGE_CODE <> userenv('LANG')
129: AND SourceTL.language = L.LANGUAGE_CODE

Line 196: ,LAST_UPDATED_BY = fnd_global.user_id

192:
193: UPDATE LNS_COND_ASSIGNMENTS_TL SET
194: CONDITION_DESCRIPTION = DECODE(P_CONDITION_DESCRIPTION, NULL, CONDITION_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, P_CONDITION_DESCRIPTION)
195: ,LAST_UPDATE_DATE = sysdate
196: ,LAST_UPDATED_BY = fnd_global.user_id
197: ,LAST_UPDATE_LOGIN = fnd_global.user_id
198: ,SOURCE_LANG = userenv('LANG')
199: WHERE COND_ASSIGNMENT_ID = P_COND_ASSIGNMENT_ID
200: AND userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line 197: ,LAST_UPDATE_LOGIN = fnd_global.user_id

193: UPDATE LNS_COND_ASSIGNMENTS_TL SET
194: CONDITION_DESCRIPTION = DECODE(P_CONDITION_DESCRIPTION, NULL, CONDITION_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, P_CONDITION_DESCRIPTION)
195: ,LAST_UPDATE_DATE = sysdate
196: ,LAST_UPDATED_BY = fnd_global.user_id
197: ,LAST_UPDATE_LOGIN = fnd_global.user_id
198: ,SOURCE_LANG = userenv('LANG')
199: WHERE COND_ASSIGNMENT_ID = P_COND_ASSIGNMENT_ID
200: AND userenv('LANG') in (LANGUAGE, SOURCE_LANG);
201: