APPS.CS_KB_USED_SUM_DEFS_PKG dependencies on CS_KB_USED_SUM_DEFS_TL

Line 284: insert into CS_KB_USED_SUM_DEFS_TL (

280: X_LAST_UPDATED_BY,
281: X_LAST_UPDATE_LOGIN
282: );
283:
284: insert into CS_KB_USED_SUM_DEFS_TL (
285: DEF_ID,
286: NAME,
287: DESCRIPTION,
288: CREATION_DATE,

Line 310: from CS_KB_USED_SUM_DEFS_TL T

306: from FND_LANGUAGES L
307: where L.INSTALLED_FLAG in ('I', 'B')
308: and not exists
309: (select NULL
310: from CS_KB_USED_SUM_DEFS_TL T
311: where T.DEF_ID = X_DEF_ID
312: and T.LANGUAGE = L.LANGUAGE_CODE);
313:
314: open c;

Line 377: from CS_KB_USED_SUM_DEFS_TL

373: cursor c1 is select
374: NAME,
375: DESCRIPTION,
376: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
377: from CS_KB_USED_SUM_DEFS_TL
378: where DEF_ID = X_DEF_ID
379: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
380: for update of DEF_ID nowait;
381: begin

Line 509: update CS_KB_USED_SUM_DEFS_TL set

505: if (sql%notfound) then
506: raise no_data_found;
507: end if;
508:
509: update CS_KB_USED_SUM_DEFS_TL set
510: NAME = X_NAME,
511: DESCRIPTION = X_DESCRIPTION,
512: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
513: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 528: delete from CS_KB_USED_SUM_DEFS_TL

524: procedure DELETE_ROW (
525: X_DEF_ID in NUMBER
526: ) is
527: begin
528: delete from CS_KB_USED_SUM_DEFS_TL
529: where DEF_ID = X_DEF_ID;
530:
531: if (sql%notfound) then
532: raise no_data_found;

Line 546: delete from CS_KB_USED_SUM_DEFS_TL T

542:
543: procedure ADD_LANGUAGE
544: is
545: begin
546: delete from CS_KB_USED_SUM_DEFS_TL T
547: where not exists
548: (select NULL
549: from CS_KB_USED_SUM_DEFS_B B
550: where B.DEF_ID = T.DEF_ID

Line 553: update CS_KB_USED_SUM_DEFS_TL T set (

549: from CS_KB_USED_SUM_DEFS_B B
550: where B.DEF_ID = T.DEF_ID
551: );
552:
553: update CS_KB_USED_SUM_DEFS_TL T set (
554: NAME,
555: DESCRIPTION
556: ) = (select
557: B.NAME,

Line 559: from CS_KB_USED_SUM_DEFS_TL B

555: DESCRIPTION
556: ) = (select
557: B.NAME,
558: B.DESCRIPTION
559: from CS_KB_USED_SUM_DEFS_TL B
560: where B.DEF_ID = T.DEF_ID
561: and B.LANGUAGE = T.SOURCE_LANG)
562: where (
563: T.DEF_ID,

Line 568: from CS_KB_USED_SUM_DEFS_TL SUBB, CS_KB_USED_SUM_DEFS_TL SUBT

564: T.LANGUAGE
565: ) in (select
566: SUBT.DEF_ID,
567: SUBT.LANGUAGE
568: from CS_KB_USED_SUM_DEFS_TL SUBB, CS_KB_USED_SUM_DEFS_TL SUBT
569: where SUBB.DEF_ID = SUBT.DEF_ID
570: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
571: and (SUBB.NAME <> SUBT.NAME
572: or (SUBB.NAME is null and SUBT.NAME is not null)

Line 579: insert into CS_KB_USED_SUM_DEFS_TL (

575: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
576: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
577: ));
578:
579: insert into CS_KB_USED_SUM_DEFS_TL (
580: DEF_ID,
581: NAME,
582: DESCRIPTION,
583: CREATION_DATE,

Line 601: from CS_KB_USED_SUM_DEFS_TL B, FND_LANGUAGES L

597: B.LAST_UPDATED_BY,
598: B.LAST_UPDATE_LOGIN,
599: L.LANGUAGE_CODE,
600: B.SOURCE_LANG
601: from CS_KB_USED_SUM_DEFS_TL B, FND_LANGUAGES L
602: where L.INSTALLED_FLAG in ('I', 'B')
603: and B.LANGUAGE = userenv('LANG')
604: and not exists
605: (select NULL

Line 606: from CS_KB_USED_SUM_DEFS_TL T

602: where L.INSTALLED_FLAG in ('I', 'B')
603: and B.LANGUAGE = userenv('LANG')
604: and not exists
605: (select NULL
606: from CS_KB_USED_SUM_DEFS_TL T
607: where T.DEF_ID = B.DEF_ID
608: and T.LANGUAGE = L.LANGUAGE_CODE);
609: end ADD_LANGUAGE;
610:

Line 622: update CS_KB_USED_SUM_DEFS_TL set

618: x_description in varchar2) is
619:
620: begin
621:
622: update CS_KB_USED_SUM_DEFS_TL set
623: NAME = x_name,
624: DESCRIPTION = x_description,
625: LAST_UPDATE_DATE = sysdate,
626: LAST_UPDATED_BY = decode(x_owner, 'SEED',1, 0),