APPS.OKE_K_TYPES_PKG dependencies on OKE_K_TYPES_TL

Line 100: insert into OKE_K_TYPES_TL (

96: , X_ATTRIBUTE14
97: , X_ATTRIBUTE15
98: );
99:
100: insert into OKE_K_TYPES_TL (
101: K_TYPE_CODE
102: , LANGUAGE
103: , CREATION_DATE
104: , CREATED_BY

Line 126: from OKE_K_TYPES_TL T

122: from FND_LANGUAGES L
123: where L.INSTALLED_FLAG in ('I', 'B')
124: and not exists
125: (select NULL
126: from OKE_K_TYPES_TL T
127: where T.K_TYPE_CODE = X_K_TYPE_CODE
128: and T.LANGUAGE = L.LANGUAGE_CODE)
129: ;
130:

Line 299: from OKE_K_TYPES_TL

295: cursor c1 is select
296: K_TYPE_NAME
297: ,DESCRIPTION
298: ,decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
299: from OKE_K_TYPES_TL
300: where K_TYPE_CODE= X_K_TYPE_CODE
301: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
302: for update of K_TYPE_CODE nowait;
303: tlinfo c1%rowtype;

Line 447: update OKE_K_TYPES_TL set

443: if (sql%notfound) then
444: raise no_data_found;
445: end if;
446:
447: update OKE_K_TYPES_TL set
448: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE
449: , LAST_UPDATED_BY = X_LAST_UPDATED_BY
450: , LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
451: , K_TYPE_NAME = X_K_TYPE_NAME

Line 684: delete from OKE_K_TYPES_TL T

680:
681: procedure ADD_LANGUAGE
682: is
683: begin
684: delete from OKE_K_TYPES_TL T
685: where not exists
686: (select NULL
687: from OKE_K_TYPES_B B
688: where B.K_TYPE_CODE = T.K_TYPE_CODE

Line 691: update OKE_K_TYPES_TL T set (

687: from OKE_K_TYPES_B B
688: where B.K_TYPE_CODE = T.K_TYPE_CODE
689: );
690:
691: update OKE_K_TYPES_TL T set (
692: K_TYPE_NAME,
693: DESCRIPTION
694: ) = (select
695: B.K_TYPE_NAME,

Line 697: from OKE_K_TYPES_TL B

693: DESCRIPTION
694: ) = (select
695: B.K_TYPE_NAME,
696: B.DESCRIPTION
697: from OKE_K_TYPES_TL B
698: where B.K_TYPE_CODE = T.K_TYPE_CODE
699: and B.LANGUAGE = T.SOURCE_LANG)
700: where (
701: T.K_TYPE_CODE,

Line 706: from OKE_K_TYPES_TL SUBB, OKE_K_TYPES_TL SUBT

702: T.LANGUAGE
703: ) in (select
704: SUBT.K_TYPE_CODE,
705: SUBT.LANGUAGE
706: from OKE_K_TYPES_TL SUBB, OKE_K_TYPES_TL SUBT
707: where SUBB.K_TYPE_CODE = SUBT.K_TYPE_CODE
708: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
709: and (SUBB.K_TYPE_NAME <> SUBT.K_TYPE_NAME
710: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 715: insert into OKE_K_TYPES_TL (

711: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
712: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
713: ));
714:
715: insert into OKE_K_TYPES_TL (
716: K_TYPE_CODE,
717: CREATION_DATE,
718: CREATED_BY,
719: LAST_UPDATE_DATE,

Line 737: from OKE_K_TYPES_TL B, FND_LANGUAGES L

733: B.K_TYPE_NAME,
734: B.DESCRIPTION,
735: L.LANGUAGE_CODE,
736: B.SOURCE_LANG
737: from OKE_K_TYPES_TL B, FND_LANGUAGES L
738: where L.INSTALLED_FLAG in ('I', 'B')
739: and B.LANGUAGE = userenv('LANG')
740: and not exists
741: (select NULL

Line 742: from OKE_K_TYPES_TL T

738: where L.INSTALLED_FLAG in ('I', 'B')
739: and B.LANGUAGE = userenv('LANG')
740: and not exists
741: (select NULL
742: from OKE_K_TYPES_TL T
743: where T.K_TYPE_CODE = B.K_TYPE_CODE
744: and T.LANGUAGE = L.LANGUAGE_CODE);
745: end ADD_LANGUAGE;
746: