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: );
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 (
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,
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')
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
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;
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);
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: