DBA Data[Home] [Help]

APPS.JTF_CALENDARS_PKG dependencies on FND_GLOBAL

Line 156: FND_GLOBAL.USER_ID,

152: X_ATTRIBUTE15,
153: X_ATTRIBUTE_CATEGORY,
154: X_CALENDAR_TYPE,
155: sysdate,
156: FND_GLOBAL.USER_ID,
157: sysdate,
158: FND_GLOBAL.USER_ID,
159: NULL
160: );

Line 158: FND_GLOBAL.USER_ID,

154: X_CALENDAR_TYPE,
155: sysdate,
156: FND_GLOBAL.USER_ID,
157: sysdate,
158: FND_GLOBAL.USER_ID,
159: NULL
160: );
161:
162: insert into JTF_CALENDARS_TL (

Line 177: FND_GLOBAL.USER_ID,

173: ) select
174: v_calendar_id,
175: X_CALENDAR_NAME,
176: X_DESCRIPTION,
177: FND_GLOBAL.USER_ID,
178: sysdate,
179: FND_GLOBAL.USER_ID,
180: sysdate,
181: NULL,

Line 179: FND_GLOBAL.USER_ID,

175: X_CALENDAR_NAME,
176: X_DESCRIPTION,
177: FND_GLOBAL.USER_ID,
178: sysdate,
179: FND_GLOBAL.USER_ID,
180: sysdate,
181: NULL,
182: L.LANGUAGE_CODE,
183: userenv('LANG')

Line 455: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

451: ATTRIBUTE15 = X_ATTRIBUTE15,
452: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
453: CALENDAR_TYPE = X_CALENDAR_TYPE,
454: LAST_UPDATE_DATE = sysdate,
455: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
456: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
457: where CALENDAR_ID = X_CALENDAR_ID;
458:
459: if (sql%notfound) then

Line 456: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

452: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
453: CALENDAR_TYPE = X_CALENDAR_TYPE,
454: LAST_UPDATE_DATE = sysdate,
455: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
456: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
457: where CALENDAR_ID = X_CALENDAR_ID;
458:
459: if (sql%notfound) then
460: raise no_data_found;

Line 467: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

463: update JTF_CALENDARS_TL set
464: CALENDAR_NAME = X_CALENDAR_NAME,
465: DESCRIPTION = X_DESCRIPTION,
466: LAST_UPDATE_DATE = sysdate,
467: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
468: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
469: SOURCE_LANG = userenv('LANG')
470: where CALENDAR_ID = X_CALENDAR_ID
471: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line 468: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

464: CALENDAR_NAME = X_CALENDAR_NAME,
465: DESCRIPTION = X_DESCRIPTION,
466: LAST_UPDATE_DATE = sysdate,
467: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
468: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
469: SOURCE_LANG = userenv('LANG')
470: where CALENDAR_ID = X_CALENDAR_ID
471: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
472: