APPS.CS_KB_VISIBILITIES_PKG dependencies on CS_KB_VISIBILITIES_TL

Line 91: insert into CS_KB_VISIBILITIES_TL (

87: X_ATTRIBUTE14,
88: X_ATTRIBUTE15
89: );
90:
91: insert into CS_KB_VISIBILITIES_TL (
92: VISIBILITY_ID,
93: NAME,
94: DESCRIPTION,
95: CREATION_DATE,

Line 117: from CS_KB_VISIBILITIES_TL T

113: from FND_LANGUAGES L
114: where L.INSTALLED_FLAG in ('I', 'B')
115: and not exists
116: (select NULL
117: from CS_KB_VISIBILITIES_TL T
118: where T.VISIBILITY_ID = X_VISIBILITY_ID
119: and T.LANGUAGE = L.LANGUAGE_CODE);
120:
121: open c;

Line 184: from CS_KB_VISIBILITIES_TL

180: cursor c1 is select
181: NAME,
182: DESCRIPTION,
183: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
184: from CS_KB_VISIBILITIES_TL
185: where VISIBILITY_ID = X_VISIBILITY_ID
186: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
187: for update of VISIBILITY_ID nowait;
188: begin

Line 314: update CS_KB_VISIBILITIES_TL set

310: if (sql%notfound) then
311: raise no_data_found;
312: end if;
313:
314: update CS_KB_VISIBILITIES_TL set
315: NAME = X_NAME,
316: DESCRIPTION = X_DESCRIPTION,
317: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
318: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 333: delete from CS_KB_VISIBILITIES_TL

329: procedure DELETE_ROW (
330: X_VISIBILITY_ID in NUMBER
331: ) is
332: begin
333: delete from CS_KB_VISIBILITIES_TL
334: where VISIBILITY_ID = X_VISIBILITY_ID;
335:
336: if (sql%notfound) then
337: raise no_data_found;

Line 351: delete from CS_KB_VISIBILITIES_TL T

347:
348: procedure ADD_LANGUAGE
349: is
350: begin
351: delete from CS_KB_VISIBILITIES_TL T
352: where not exists
353: (select NULL
354: from CS_KB_VISIBILITIES_B B
355: where B.VISIBILITY_ID = T.VISIBILITY_ID

Line 358: update CS_KB_VISIBILITIES_TL T set (

354: from CS_KB_VISIBILITIES_B B
355: where B.VISIBILITY_ID = T.VISIBILITY_ID
356: );
357:
358: update CS_KB_VISIBILITIES_TL T set (
359: NAME,
360: DESCRIPTION
361: ) = (select
362: B.NAME,

Line 364: from CS_KB_VISIBILITIES_TL B

360: DESCRIPTION
361: ) = (select
362: B.NAME,
363: B.DESCRIPTION
364: from CS_KB_VISIBILITIES_TL B
365: where B.VISIBILITY_ID = T.VISIBILITY_ID
366: and B.LANGUAGE = T.SOURCE_LANG)
367: where (
368: T.VISIBILITY_ID,

Line 373: from CS_KB_VISIBILITIES_TL SUBB, CS_KB_VISIBILITIES_TL SUBT

369: T.LANGUAGE
370: ) in (select
371: SUBT.VISIBILITY_ID,
372: SUBT.LANGUAGE
373: from CS_KB_VISIBILITIES_TL SUBB, CS_KB_VISIBILITIES_TL SUBT
374: where SUBB.VISIBILITY_ID = SUBT.VISIBILITY_ID
375: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
376: and (SUBB.NAME <> SUBT.NAME
377: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 382: insert into CS_KB_VISIBILITIES_TL (

378: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
379: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
380: ));
381:
382: insert into CS_KB_VISIBILITIES_TL (
383: VISIBILITY_ID,
384: NAME,
385: DESCRIPTION,
386: CREATION_DATE,

Line 404: from CS_KB_VISIBILITIES_TL B, FND_LANGUAGES L

400: B.LAST_UPDATED_BY,
401: B.LAST_UPDATE_LOGIN,
402: L.LANGUAGE_CODE,
403: B.SOURCE_LANG
404: from CS_KB_VISIBILITIES_TL B, FND_LANGUAGES L
405: where L.INSTALLED_FLAG in ('I', 'B')
406: and B.LANGUAGE = userenv('LANG')
407: and not exists
408: (select NULL

Line 409: from CS_KB_VISIBILITIES_TL T

405: where L.INSTALLED_FLAG in ('I', 'B')
406: and B.LANGUAGE = userenv('LANG')
407: and not exists
408: (select NULL
409: from CS_KB_VISIBILITIES_TL T
410: where T.VISIBILITY_ID = B.VISIBILITY_ID
411: and T.LANGUAGE = L.LANGUAGE_CODE);
412: end ADD_LANGUAGE;
413:

Line 420: UPDATE CS_KB_VISIBILITIES_TL SET

416: x_owner IN VARCHAR2,
417: x_name IN VARCHAR2,
418: x_description IN VARCHAR2 ) IS
419: BEGIN
420: UPDATE CS_KB_VISIBILITIES_TL SET
421: name = x_name,
422: description = x_description,
423: last_update_date = SYSDATE,
424: last_updated_by = decode(x_owner, 'SEED', 1, 0),

Line 466: UPDATE CS_KB_VISIBILITIES_TL SET

462:
463: -- Update_Row is not used as we do not want to update the
464: -- position or Start + End Dates
465:
466: UPDATE CS_KB_VISIBILITIES_TL SET
467: NAME = X_NAME,
468: DESCRIPTION = X_DESCRIPTION,
469: LAST_UPDATE_DATE = sysdate,
470: LAST_UPDATED_BY = l_user_id,