APPS.CS_KB_HISTORIES_PKG dependencies on CS_KB_HISTORIES_TL

Line 198: insert into CS_KB_HISTORIES_TL (

194: X_ATTRIBUTE14,
195: X_ATTRIBUTE15
196: );
197:
198: insert into CS_KB_HISTORIES_TL (
199: HISTORY_ID,
200: NAME,
201: DESCRIPTION,
202: CREATION_DATE,

Line 224: from CS_KB_HISTORIES_TL T

220: from FND_LANGUAGES L
221: where L.INSTALLED_FLAG in ('I', 'B')
222: and not exists
223: (select NULL
224: from CS_KB_HISTORIES_TL T
225: where T.HISTORY_ID = X_HISTORY_ID
226: and T.LANGUAGE = L.LANGUAGE_CODE);
227:
228: open c;

Line 292: from CS_KB_HISTORIES_TL

288: cursor c1 is select
289: NAME,
290: DESCRIPTION,
291: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
292: from CS_KB_HISTORIES_TL
293: where HISTORY_ID = X_HISTORY_ID
294: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
295: for update of HISTORY_ID nowait;
296: begin

Line 427: update CS_KB_HISTORIES_TL set

423: if (sql%notfound) then
424: raise no_data_found;
425: end if;
426:
427: update CS_KB_HISTORIES_TL set
428: NAME = X_NAME,
429: DESCRIPTION = X_DESCRIPTION,
430: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
431: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 446: delete from CS_KB_HISTORIES_TL

442: procedure DELETE_ROW (
443: X_HISTORY_ID in NUMBER
444: ) is
445: begin
446: delete from CS_KB_HISTORIES_TL
447: where HISTORY_ID = X_HISTORY_ID;
448:
449: if (sql%notfound) then
450: raise no_data_found;

Line 464: delete from CS_KB_HISTORIES_TL T

460:
461: procedure ADD_LANGUAGE
462: is
463: begin
464: delete from CS_KB_HISTORIES_TL T
465: where not exists
466: (select NULL
467: from CS_KB_HISTORIES_B B
468: where B.HISTORY_ID = T.HISTORY_ID

Line 471: update CS_KB_HISTORIES_TL T set (

467: from CS_KB_HISTORIES_B B
468: where B.HISTORY_ID = T.HISTORY_ID
469: );
470:
471: update CS_KB_HISTORIES_TL T set (
472: NAME,
473: DESCRIPTION
474: ) = (select
475: B.NAME,

Line 477: from CS_KB_HISTORIES_TL B

473: DESCRIPTION
474: ) = (select
475: B.NAME,
476: B.DESCRIPTION
477: from CS_KB_HISTORIES_TL B
478: where B.HISTORY_ID = T.HISTORY_ID
479: and B.LANGUAGE = T.SOURCE_LANG)
480: where (
481: T.HISTORY_ID,

Line 486: from CS_KB_HISTORIES_TL SUBB, CS_KB_HISTORIES_TL SUBT

482: T.LANGUAGE
483: ) in (select
484: SUBT.HISTORY_ID,
485: SUBT.LANGUAGE
486: from CS_KB_HISTORIES_TL SUBB, CS_KB_HISTORIES_TL SUBT
487: where SUBB.HISTORY_ID = SUBT.HISTORY_ID
488: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
489: and (SUBB.NAME <> SUBT.NAME
490: or (SUBB.NAME is null and SUBT.NAME is not null)

Line 497: insert into CS_KB_HISTORIES_TL (

493: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
494: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
495: ));
496:
497: insert into CS_KB_HISTORIES_TL (
498: HISTORY_ID,
499: NAME,
500: DESCRIPTION,
501: CREATION_DATE,

Line 519: from CS_KB_HISTORIES_TL B, FND_LANGUAGES L

515: B.LAST_UPDATED_BY,
516: B.LAST_UPDATE_LOGIN,
517: L.LANGUAGE_CODE,
518: B.SOURCE_LANG
519: from CS_KB_HISTORIES_TL B, FND_LANGUAGES L
520: where L.INSTALLED_FLAG in ('I', 'B')
521: and B.LANGUAGE = userenv('LANG')
522: and not exists
523: (select NULL

Line 524: from CS_KB_HISTORIES_TL T

520: where L.INSTALLED_FLAG in ('I', 'B')
521: and B.LANGUAGE = userenv('LANG')
522: and not exists
523: (select NULL
524: from CS_KB_HISTORIES_TL T
525: where T.HISTORY_ID = B.HISTORY_ID
526: and T.LANGUAGE = L.LANGUAGE_CODE);
527: end ADD_LANGUAGE;
528:

Line 536: update CS_KB_HISTORIES_TL set

532: X_DESCRIPTION in VARCHAR2,
533: X_OWNER in VARCHAR2
534: ) is
535: begin
536: update CS_KB_HISTORIES_TL set
537: NAME = X_NAME,
538: DESCRIPTION=X_DESCRIPTION,
539: last_update_date = sysdate,
540: last_updated_by = decode(X_OWNER, 'SEED', 1, 0),