APPS.OKE_OBJECT_ATTRIBUTES_PKG dependencies on OKE_OBJECT_ATTRIBUTES_TL

Line 59: insert into OKE_OBJECT_ATTRIBUTES_TL (

55: X_LAST_UPDATED_BY,
56: X_LAST_UPDATE_LOGIN
57: );
58:
59: insert into OKE_OBJECT_ATTRIBUTES_TL (
60: DATABASE_OBJECT_NAME,
61: ATTRIBUTE_CODE,
62: CREATION_DATE,
63: CREATED_BY,

Line 87: from OKE_OBJECT_ATTRIBUTES_TL T

83: from FND_LANGUAGES L
84: where L.INSTALLED_FLAG in ('I', 'B')
85: and not exists
86: (select NULL
87: from OKE_OBJECT_ATTRIBUTES_TL T
88: where T.DATABASE_OBJECT_NAME = X_DATABASE_OBJECT_NAME
89: and T.ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
90: and T.LANGUAGE = L.LANGUAGE_CODE);
91:

Line 133: from OKE_OBJECT_ATTRIBUTES_TL

129: cursor c1 is select
130: ATTRIBUTE_NAME,
131: DESCRIPTION,
132: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
133: from OKE_OBJECT_ATTRIBUTES_TL
134: where DATABASE_OBJECT_NAME = X_DATABASE_OBJECT_NAME
135: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
136: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
137: for update of DATABASE_OBJECT_NAME nowait;

Line 218: update OKE_OBJECT_ATTRIBUTES_TL set

214: if (sql%notfound) then
215: raise no_data_found;
216: end if;
217:
218: update OKE_OBJECT_ATTRIBUTES_TL set
219: ATTRIBUTE_NAME = X_ATTRIBUTE_NAME,
220: DESCRIPTION = X_DESCRIPTION,
221: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
222: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 239: delete from OKE_OBJECT_ATTRIBUTES_TL

235: X_DATABASE_OBJECT_NAME in VARCHAR2,
236: X_ATTRIBUTE_CODE in VARCHAR2
237: ) is
238: begin
239: delete from OKE_OBJECT_ATTRIBUTES_TL
240: where DATABASE_OBJECT_NAME = X_DATABASE_OBJECT_NAME
241: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
242:
243: if (sql%notfound) then

Line 259: delete from OKE_OBJECT_ATTRIBUTES_TL T

255:
256: procedure ADD_LANGUAGE
257: is
258: begin
259: delete from OKE_OBJECT_ATTRIBUTES_TL T
260: where not exists
261: (select NULL
262: from OKE_OBJECT_ATTRIBUTES_B B
263: where B.DATABASE_OBJECT_NAME = T.DATABASE_OBJECT_NAME

Line 267: update OKE_OBJECT_ATTRIBUTES_TL T set (

263: where B.DATABASE_OBJECT_NAME = T.DATABASE_OBJECT_NAME
264: and B.ATTRIBUTE_CODE = T.ATTRIBUTE_CODE
265: );
266:
267: update OKE_OBJECT_ATTRIBUTES_TL T set (
268: ATTRIBUTE_NAME,
269: DESCRIPTION
270: ) = (select
271: B.ATTRIBUTE_NAME,

Line 273: from OKE_OBJECT_ATTRIBUTES_TL B

269: DESCRIPTION
270: ) = (select
271: B.ATTRIBUTE_NAME,
272: B.DESCRIPTION
273: from OKE_OBJECT_ATTRIBUTES_TL B
274: where B.DATABASE_OBJECT_NAME = T.DATABASE_OBJECT_NAME
275: and B.ATTRIBUTE_CODE = T.ATTRIBUTE_CODE
276: and B.LANGUAGE = T.SOURCE_LANG)
277: where (

Line 285: from OKE_OBJECT_ATTRIBUTES_TL SUBB, OKE_OBJECT_ATTRIBUTES_TL SUBT

281: ) in (select
282: SUBT.DATABASE_OBJECT_NAME,
283: SUBT.ATTRIBUTE_CODE,
284: SUBT.LANGUAGE
285: from OKE_OBJECT_ATTRIBUTES_TL SUBB, OKE_OBJECT_ATTRIBUTES_TL SUBT
286: where SUBB.DATABASE_OBJECT_NAME = SUBT.DATABASE_OBJECT_NAME
287: and SUBB.ATTRIBUTE_CODE = SUBT.ATTRIBUTE_CODE
288: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
289: and (SUBB.ATTRIBUTE_NAME <> SUBT.ATTRIBUTE_NAME

Line 297: insert into OKE_OBJECT_ATTRIBUTES_TL (

293: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
294: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
295: ));
296:
297: insert into OKE_OBJECT_ATTRIBUTES_TL (
298: DATABASE_OBJECT_NAME,
299: ATTRIBUTE_CODE,
300: CREATION_DATE,
301: CREATED_BY,

Line 321: from OKE_OBJECT_ATTRIBUTES_TL B, FND_LANGUAGES L

317: B.ATTRIBUTE_NAME,
318: B.DESCRIPTION,
319: L.LANGUAGE_CODE,
320: B.SOURCE_LANG
321: from OKE_OBJECT_ATTRIBUTES_TL B, FND_LANGUAGES L
322: where L.INSTALLED_FLAG in ('I', 'B')
323: and B.LANGUAGE = userenv('LANG')
324: and not exists
325: (select NULL

Line 326: from OKE_OBJECT_ATTRIBUTES_TL T

322: where L.INSTALLED_FLAG in ('I', 'B')
323: and B.LANGUAGE = userenv('LANG')
324: and not exists
325: (select NULL
326: from OKE_OBJECT_ATTRIBUTES_TL T
327: where T.DATABASE_OBJECT_NAME = B.DATABASE_OBJECT_NAME
328: and T.ATTRIBUTE_CODE = B.ATTRIBUTE_CODE
329: and T.LANGUAGE = L.LANGUAGE_CODE);
330: end ADD_LANGUAGE;