APPS.CSD_BULLETINS_PKG dependencies on CSD_BULLETINS_TL

Line 120: insert into CSD_BULLETINS_TL (

116: P_ATTRIBUTE14,
117: P_ATTRIBUTE15
118: );
119:
120: insert into CSD_BULLETINS_TL (
121: BULLETIN_ID,
122: NAME,
123: DESCRIPTION,
124: CREATED_BY,

Line 146: from CSD_BULLETINS_TL T

142: from FND_LANGUAGES L
143: where L.INSTALLED_FLAG in ('I', 'B')
144: and not exists
145: (select NULL
146: from CSD_BULLETINS_TL T
147: where T.BULLETIN_ID = PX_BULLETIN_ID
148: and T.LANGUAGE = L.LANGUAGE_CODE);
149:
150: open c;

Line 285: update CSD_BULLETINS_TL set

281: if (sql%notfound) then
282: raise no_data_found;
283: end if;
284:
285: update CSD_BULLETINS_TL set
286: CREATED_BY = decode( P_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, P_CREATED_BY)
287: ,CREATION_DATE = decode( P_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, P_CREATION_DATE)
288: ,LAST_UPDATED_BY = decode( P_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, P_LAST_UPDATED_BY)
289: ,LAST_UPDATE_DATE = decode( P_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UPDATE_DATE, P_LAST_UPDATE_DATE)

Line 307: delete from CSD_BULLETINS_TL

303: procedure DELETE_ROW (
304: P_BULLETIN_ID in NUMBER
305: ) is
306: begin
307: delete from CSD_BULLETINS_TL
308: where BULLETIN_ID = P_BULLETIN_ID;
309:
310: if (sql%notfound) then
311: raise no_data_found;

Line 325: delete from CSD_BULLETINS_TL T

321:
322: procedure ADD_LANGUAGE
323: is
324: begin
325: delete from CSD_BULLETINS_TL T
326: where not exists
327: (select NULL
328: from CSD_BULLETINS_B B
329: where B.BULLETIN_ID = T.BULLETIN_ID

Line 332: update CSD_BULLETINS_TL T set (

328: from CSD_BULLETINS_B B
329: where B.BULLETIN_ID = T.BULLETIN_ID
330: );
331:
332: update CSD_BULLETINS_TL T set (
333: NAME,
334: DESCRIPTION
335: ) = (select
336: B.NAME,

Line 338: from CSD_BULLETINS_TL B

334: DESCRIPTION
335: ) = (select
336: B.NAME,
337: B.DESCRIPTION
338: from CSD_BULLETINS_TL B
339: where B.BULLETIN_ID = T.BULLETIN_ID
340: and B.LANGUAGE = T.SOURCE_LANG)
341: where (
342: T.BULLETIN_ID,

Line 347: from CSD_BULLETINS_TL SUBB, CSD_BULLETINS_TL SUBT

343: T.LANGUAGE
344: ) in (select
345: SUBT.BULLETIN_ID,
346: SUBT.LANGUAGE
347: from CSD_BULLETINS_TL SUBB, CSD_BULLETINS_TL SUBT
348: where SUBB.BULLETIN_ID = SUBT.BULLETIN_ID
349: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
350: and (SUBB.NAME <> SUBT.NAME
351: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 356: insert into CSD_BULLETINS_TL (

352: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
353: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
354: ));
355:
356: insert into CSD_BULLETINS_TL (
357: BULLETIN_ID,
358: CREATED_BY,
359: CREATION_DATE,
360: LAST_UPDATED_BY,

Line 378: from CSD_BULLETINS_TL B, FND_LANGUAGES L

374: B.NAME,
375: B.DESCRIPTION,
376: L.LANGUAGE_CODE,
377: B.SOURCE_LANG
378: from CSD_BULLETINS_TL B, FND_LANGUAGES L
379: where L.INSTALLED_FLAG in ('I', 'B')
380: and B.LANGUAGE = userenv('LANG')
381: and not exists
382: (select NULL

Line 383: from CSD_BULLETINS_TL T

379: where L.INSTALLED_FLAG in ('I', 'B')
380: and B.LANGUAGE = userenv('LANG')
381: and not exists
382: (select NULL
383: from CSD_BULLETINS_TL T
384: where T.BULLETIN_ID = B.BULLETIN_ID
385: and T.LANGUAGE = L.LANGUAGE_CODE);
386: end ADD_LANGUAGE;
387: