DBA Data[Home] [Help]

APPS.LNS_COND_ASSIGNMENTS_PKG dependencies on FND_GLOBAL

Line 96: ,fnd_global.user_id

92: X_COND_ASSIGNMENT_ID
93: ,DECODE(P_CONDITION_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, P_CONDITION_DESCRIPTION)
94: ,L.LANGUAGE_CODE
95: ,userenv('LANG')
96: ,fnd_global.user_id
97: ,sysdate
98: ,sysdate
99: ,fnd_global.user_id
100: ,fnd_global.user_id

Line 99: ,fnd_global.user_id

95: ,userenv('LANG')
96: ,fnd_global.user_id
97: ,sysdate
98: ,sysdate
99: ,fnd_global.user_id
100: ,fnd_global.user_id
101: FROM FND_LANGUAGES L
102: where L.INSTALLED_FLAG in ('I', 'B')
103: AND L.LANGUAGE_CODE = userenv('LANG')

Line 100: ,fnd_global.user_id

96: ,fnd_global.user_id
97: ,sysdate
98: ,sysdate
99: ,fnd_global.user_id
100: ,fnd_global.user_id
101: FROM FND_LANGUAGES L
102: where L.INSTALLED_FLAG in ('I', 'B')
103: AND L.LANGUAGE_CODE = userenv('LANG')
104: AND not exists

Line 127: ,fnd_global.user_id

123: X_COND_ASSIGNMENT_ID
124: ,SourceTL.CONDITION_DESCRIPTION
125: ,SourceTL.LANGUAGE
126: ,SourceTL.SOURCE_LANG
127: ,fnd_global.user_id
128: ,sysdate
129: ,sysdate
130: ,fnd_global.user_id
131: ,fnd_global.user_id

Line 130: ,fnd_global.user_id

126: ,SourceTL.SOURCE_LANG
127: ,fnd_global.user_id
128: ,sysdate
129: ,sysdate
130: ,fnd_global.user_id
131: ,fnd_global.user_id
132: FROM FND_LANGUAGES L, LNS_CONDITIONS_TL SourceTL
133: where L.INSTALLED_FLAG in ('I', 'B')
134: and L.LANGUAGE_CODE <> userenv('LANG')

Line 131: ,fnd_global.user_id

127: ,fnd_global.user_id
128: ,sysdate
129: ,sysdate
130: ,fnd_global.user_id
131: ,fnd_global.user_id
132: FROM FND_LANGUAGES L, LNS_CONDITIONS_TL SourceTL
133: where L.INSTALLED_FLAG in ('I', 'B')
134: and L.LANGUAGE_CODE <> userenv('LANG')
135: AND SourceTL.language = L.LANGUAGE_CODE

Line 214: ,LAST_UPDATED_BY = fnd_global.user_id

210:
211: UPDATE LNS_COND_ASSIGNMENTS_TL SET
212: CONDITION_DESCRIPTION = DECODE(P_CONDITION_DESCRIPTION, NULL, CONDITION_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, P_CONDITION_DESCRIPTION)
213: ,LAST_UPDATE_DATE = sysdate
214: ,LAST_UPDATED_BY = fnd_global.user_id
215: ,LAST_UPDATE_LOGIN = fnd_global.user_id
216: ,SOURCE_LANG = userenv('LANG')
217: WHERE COND_ASSIGNMENT_ID = P_COND_ASSIGNMENT_ID
218: AND userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line 215: ,LAST_UPDATE_LOGIN = fnd_global.user_id

211: UPDATE LNS_COND_ASSIGNMENTS_TL SET
212: CONDITION_DESCRIPTION = DECODE(P_CONDITION_DESCRIPTION, NULL, CONDITION_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, P_CONDITION_DESCRIPTION)
213: ,LAST_UPDATE_DATE = sysdate
214: ,LAST_UPDATED_BY = fnd_global.user_id
215: ,LAST_UPDATE_LOGIN = fnd_global.user_id
216: ,SOURCE_LANG = userenv('LANG')
217: WHERE COND_ASSIGNMENT_ID = P_COND_ASSIGNMENT_ID
218: AND userenv('LANG') in (LANGUAGE, SOURCE_LANG);
219: