APPS.BSC_SYS_CALENDARS_PKG dependencies on BSC_SYS_CALENDARS_TL

Line 51: insert into BSC_SYS_CALENDARS_TL (

47: X_LAST_UPDATED_BY ,
48: X_LAST_UPDATE_LOGIN
49: );
50:
51: insert into BSC_SYS_CALENDARS_TL (
52: CALENDAR_ID,
53: NAME,
54: HELP,
55: CREATION_DATE ,

Line 77: from BSC_SYS_CALENDARS_TL T

73: from FND_LANGUAGES L
74: where L.INSTALLED_FLAG in ('I', 'B')
75: and not exists
76: (select NULL
77: from BSC_SYS_CALENDARS_TL T
78: where T.CALENDAR_ID = X_CALENDAR_ID
79: and T.LANGUAGE = L.LANGUAGE_CODE);
80:
81: end INSERT_ROW;

Line 89: update BSC_SYS_CALENDARS_TL set

85: X_NAME in VARCHAR2,
86: X_HELP in VARCHAR2)
87: is
88: begin
89: update BSC_SYS_CALENDARS_TL set
90: NAME = NVL(X_NAME,NAME),
91: HELP = NVL(X_HELP, HELP),
92: SOURCE_LANG = userenv('LANG')
93: where

Line 128: from BSC_SYS_CALENDARS_TL

124: cursor c1 is select
125: NAME,
126: HELP,
127: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
128: from BSC_SYS_CALENDARS_TL
129: where CALENDAR_ID = X_CALENDAR_ID
130: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
131: for update of CALENDAR_ID nowait;
132: begin

Line 207: update BSC_SYS_CALENDARS_TL set

203: if (sql%notfound) then
204: raise no_data_found;
205: end if;
206:
207: update BSC_SYS_CALENDARS_TL set
208: NAME = X_NAME,
209: HELP = X_HELP,
210: SOURCE_LANG = userenv('LANG')
211: where CALENDAR_ID = X_CALENDAR_ID

Line 223: delete from BSC_SYS_CALENDARS_TL

219: procedure DELETE_ROW (
220: X_CALENDAR_ID in NUMBER
221: ) is
222: begin
223: delete from BSC_SYS_CALENDARS_TL
224: where CALENDAR_ID = X_CALENDAR_ID;
225:
226: if (sql%notfound) then
227: raise no_data_found;

Line 241: delete from BSC_SYS_CALENDARS_TL T

237:
238: procedure ADD_LANGUAGE
239: is
240: begin
241: delete from BSC_SYS_CALENDARS_TL T
242: where not exists
243: (select NULL
244: from BSC_SYS_CALENDARS_B B
245: where B.CALENDAR_ID = T.CALENDAR_ID

Line 248: update BSC_SYS_CALENDARS_TL T set (

244: from BSC_SYS_CALENDARS_B B
245: where B.CALENDAR_ID = T.CALENDAR_ID
246: );
247:
248: update BSC_SYS_CALENDARS_TL T set (
249: NAME,
250: HELP
251: ) = (select
252: B.NAME,

Line 254: from BSC_SYS_CALENDARS_TL B

250: HELP
251: ) = (select
252: B.NAME,
253: B.HELP
254: from BSC_SYS_CALENDARS_TL B
255: where B.CALENDAR_ID = T.CALENDAR_ID
256: and B.LANGUAGE = T.SOURCE_LANG)
257: where (
258: T.CALENDAR_ID,

Line 263: from BSC_SYS_CALENDARS_TL SUBB, BSC_SYS_CALENDARS_TL SUBT

259: T.LANGUAGE
260: ) in (select
261: SUBT.CALENDAR_ID,
262: SUBT.LANGUAGE
263: from BSC_SYS_CALENDARS_TL SUBB, BSC_SYS_CALENDARS_TL SUBT
264: where SUBB.CALENDAR_ID = SUBT.CALENDAR_ID
265: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
266: and (SUBB.NAME <> SUBT.NAME
267: or SUBB.HELP <> SUBT.HELP

Line 270: insert into BSC_SYS_CALENDARS_TL (

266: and (SUBB.NAME <> SUBT.NAME
267: or SUBB.HELP <> SUBT.HELP
268: ));
269:
270: insert into BSC_SYS_CALENDARS_TL (
271: CALENDAR_ID,
272: NAME,
273: HELP,
274: LANGUAGE,

Line 290: from BSC_SYS_CALENDARS_TL B, FND_LANGUAGES L

286: B.CREATION_DATE ,
287: B.CREATED_BY,
288: B.LAST_UPDATE_DATE,
289: B.LAST_UPDATED_BY
290: from BSC_SYS_CALENDARS_TL B, FND_LANGUAGES L
291: where L.INSTALLED_FLAG in ('I', 'B')
292: and B.LANGUAGE = userenv('LANG')
293: and not exists
294: (select NULL

Line 295: from BSC_SYS_CALENDARS_TL T

291: where L.INSTALLED_FLAG in ('I', 'B')
292: and B.LANGUAGE = userenv('LANG')
293: and not exists
294: (select NULL
295: from BSC_SYS_CALENDARS_TL T
296: where T.CALENDAR_ID = B.CALENDAR_ID
297: and T.LANGUAGE = L.LANGUAGE_CODE);
298: end ADD_LANGUAGE;
299: