APPS.CS_KB_ELEMENT_TYPES_PKG dependencies on CS_KB_ELEMENT_TYPES_TL

Line 349: insert into CS_KB_ELEMENT_TYPES_TL (

345: X_START_DATE,
346: X_END_DATE
347: );
348:
349: insert into CS_KB_ELEMENT_TYPES_TL (
350: ELEMENT_TYPE_ID,
351: NAME,
352: DESCRIPTION,
353: CREATION_DATE,

Line 375: from CS_KB_ELEMENT_TYPES_TL T

371: from FND_LANGUAGES L
372: where L.INSTALLED_FLAG in ('I', 'B')
373: and not exists
374: (select NULL
375: from CS_KB_ELEMENT_TYPES_TL T
376: where T.ELEMENT_TYPE_ID = X_ELEMENT_TYPE_ID
377: and T.LANGUAGE = L.LANGUAGE_CODE);
378:
379: open c;

Line 443: from CS_KB_ELEMENT_TYPES_TL

439: cursor c1 is select
440: NAME,
441: DESCRIPTION,
442: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
443: from CS_KB_ELEMENT_TYPES_TL
444: where ELEMENT_TYPE_ID = X_ELEMENT_TYPE_ID
445: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
446: for update of ELEMENT_TYPE_ID nowait;
447: begin

Line 578: update CS_KB_ELEMENT_TYPES_TL set

574: if (sql%notfound) then
575: raise no_data_found;
576: end if;
577:
578: update CS_KB_ELEMENT_TYPES_TL set
579: NAME = X_NAME,
580: DESCRIPTION = X_DESCRIPTION,
581: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
582: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 597: delete from CS_KB_ELEMENT_TYPES_TL

593: procedure DELETE_ROW (
594: X_ELEMENT_TYPE_ID in NUMBER
595: ) is
596: begin
597: delete from CS_KB_ELEMENT_TYPES_TL
598: where ELEMENT_TYPE_ID = X_ELEMENT_TYPE_ID;
599:
600: if (sql%notfound) then
601: raise no_data_found;

Line 615: delete from CS_KB_ELEMENT_TYPES_TL T

611:
612: procedure ADD_LANGUAGE
613: is
614: begin
615: delete from CS_KB_ELEMENT_TYPES_TL T
616: where not exists
617: (select NULL
618: from CS_KB_ELEMENT_TYPES_B B
619: where B.ELEMENT_TYPE_ID = T.ELEMENT_TYPE_ID

Line 622: update CS_KB_ELEMENT_TYPES_TL T set (

618: from CS_KB_ELEMENT_TYPES_B B
619: where B.ELEMENT_TYPE_ID = T.ELEMENT_TYPE_ID
620: );
621:
622: update CS_KB_ELEMENT_TYPES_TL T set (
623: NAME,
624: DESCRIPTION
625: ) = (select
626: B.NAME,

Line 628: from CS_KB_ELEMENT_TYPES_TL B

624: DESCRIPTION
625: ) = (select
626: B.NAME,
627: B.DESCRIPTION
628: from CS_KB_ELEMENT_TYPES_TL B
629: where B.ELEMENT_TYPE_ID = T.ELEMENT_TYPE_ID
630: and B.LANGUAGE = T.SOURCE_LANG)
631: where (
632: T.ELEMENT_TYPE_ID,

Line 637: from CS_KB_ELEMENT_TYPES_TL SUBB, CS_KB_ELEMENT_TYPES_TL SUBT

633: T.LANGUAGE
634: ) in (select
635: SUBT.ELEMENT_TYPE_ID,
636: SUBT.LANGUAGE
637: from CS_KB_ELEMENT_TYPES_TL SUBB, CS_KB_ELEMENT_TYPES_TL SUBT
638: where SUBB.ELEMENT_TYPE_ID = SUBT.ELEMENT_TYPE_ID
639: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
640: and (SUBB.NAME <> SUBT.NAME
641: or (SUBB.NAME is null and SUBT.NAME is not null)

Line 648: insert into CS_KB_ELEMENT_TYPES_TL (

644: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
645: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
646: ));
647:
648: insert into CS_KB_ELEMENT_TYPES_TL (
649: ELEMENT_TYPE_ID,
650: NAME,
651: DESCRIPTION,
652: CREATION_DATE,

Line 670: from CS_KB_ELEMENT_TYPES_TL B, FND_LANGUAGES L

666: B.LAST_UPDATED_BY,
667: B.LAST_UPDATE_LOGIN,
668: L.LANGUAGE_CODE,
669: B.SOURCE_LANG
670: from CS_KB_ELEMENT_TYPES_TL B, FND_LANGUAGES L
671: where L.INSTALLED_FLAG in ('I', 'B')
672: and B.LANGUAGE = userenv('LANG')
673: and not exists
674: (select NULL

Line 675: from CS_KB_ELEMENT_TYPES_TL T

671: where L.INSTALLED_FLAG in ('I', 'B')
672: and B.LANGUAGE = userenv('LANG')
673: and not exists
674: (select NULL
675: from CS_KB_ELEMENT_TYPES_TL T
676: where T.ELEMENT_TYPE_ID = B.ELEMENT_TYPE_ID
677: and T.LANGUAGE = L.LANGUAGE_CODE);
678: end ADD_LANGUAGE;
679:

Line 688: update CS_KB_ELEMENT_TYPES_TL set

684: x_description in varchar2) is
685:
686: begin
687:
688: update CS_KB_ELEMENT_TYPES_TL set
689: NAME = x_name,
690: DESCRIPTION = x_description,
691: LAST_UPDATE_DATE = sysdate,
692: LAST_UPDATED_BY = decode(x_owner, 'SEED',1, 0),