DBA Data[Home] [Help]

APPS.JTF_CAL_SHIFTS_PKG dependencies on FND_GLOBAL

Line 187: FND_GLOBAL.USER_ID,

183: X_ATTRIBUTE14,
184: X_ATTRIBUTE15,
185: X_ATTRIBUTE_CATEGORY,
186: SYSDATE,
187: FND_GLOBAL.USER_ID,
188: SYSDATE,
189: FND_GLOBAL.USER_ID,
190: NULL
191: );

Line 189: FND_GLOBAL.USER_ID,

185: X_ATTRIBUTE_CATEGORY,
186: SYSDATE,
187: FND_GLOBAL.USER_ID,
188: SYSDATE,
189: FND_GLOBAL.USER_ID,
190: NULL
191: );
192:
193: insert into JTF_CAL_SHIFTS_TL (

Line 208: FND_GLOBAL.USER_ID,

204: ) select
205: v_shift_id,
206: X_SHIFT_NAME,
207: X_DESCRIPTION,
208: FND_GLOBAL.USER_ID,
209: SYSDATE,
210: FND_GLOBAL.USER_ID,
211: SYSDATE,
212: NULL,

Line 210: FND_GLOBAL.USER_ID,

206: X_SHIFT_NAME,
207: X_DESCRIPTION,
208: FND_GLOBAL.USER_ID,
209: SYSDATE,
210: FND_GLOBAL.USER_ID,
211: SYSDATE,
212: NULL,
213: L.LANGUAGE_CODE,
214: userenv('LANG')

Line 485: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

481: ATTRIBUTE14 = X_ATTRIBUTE14,
482: ATTRIBUTE15 = X_ATTRIBUTE15,
483: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
484: LAST_UPDATE_DATE = SYSDATE,
485: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
486: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
487: where SHIFT_ID = X_SHIFT_ID;
488:
489: if (sql%notfound) then

Line 486: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

482: ATTRIBUTE15 = X_ATTRIBUTE15,
483: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
484: LAST_UPDATE_DATE = SYSDATE,
485: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
486: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
487: where SHIFT_ID = X_SHIFT_ID;
488:
489: if (sql%notfound) then
490: raise no_data_found;

Line 497: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

493: update JTF_CAL_SHIFTS_TL set
494: SHIFT_NAME = X_SHIFT_NAME,
495: DESCRIPTION = X_DESCRIPTION,
496: LAST_UPDATE_DATE = SYSDATE,
497: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
498: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
499: SOURCE_LANG = userenv('LANG')
500: where SHIFT_ID = X_SHIFT_ID
501: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line 498: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

494: SHIFT_NAME = X_SHIFT_NAME,
495: DESCRIPTION = X_DESCRIPTION,
496: LAST_UPDATE_DATE = SYSDATE,
497: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
498: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
499: SOURCE_LANG = userenv('LANG')
500: where SHIFT_ID = X_SHIFT_ID
501: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
502: