APPS.CN_DIMENSIONS_PKG dependencies on CN_DIMENSIONS_ALL_TL

Line 51: insert into CN_DIMENSIONS_ALL_TL (

47: X_ORG_ID
48: --R12 MOAC Changes--End
49: );
50:
51: insert into CN_DIMENSIONS_ALL_TL (
52: DIMENSION_ID,
53: NAME,
54: CREATION_DATE,
55: CREATED_BY,

Line 83: from CN_DIMENSIONS_ALL_TL T

79: from FND_LANGUAGES L
80: where L.INSTALLED_FLAG in ('I', 'B')
81: and not exists
82: (select NULL
83: from CN_DIMENSIONS_ALL_TL T
84: where T.DIMENSION_ID = X_DIMENSION_ID
85: and T.LANGUAGE = L.language_code AND
86: ORG_ID = X_ORG_ID
87: );

Line 135: update CN_DIMENSIONS_ALL_TL set

131: if (sql%notfound) then
132: raise no_data_found;
133: end if;
134:
135: update CN_DIMENSIONS_ALL_TL set
136: NAME = X_NAME,
137: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
138: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
139: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 226: delete from CN_DIMENSIONS_ALL_TL

222: delete from CN_HEAD_HIERARCHIES_ALL_B
223: where dimension_id = X_DIMENSION_ID
224: and ORG_ID = X_ORG_ID;
225:
226: delete from CN_DIMENSIONS_ALL_TL
227: where dimension_id = X_DIMENSION_ID
228: and ORG_ID = X_ORG_ID;
229:
230: delete from CN_DIMENSIONS_ALL_B

Line 248: delete from CN_DIMENSIONS_ALL_TL T

244:
245: procedure ADD_LANGUAGE
246: is
247: begin
248: delete from CN_DIMENSIONS_ALL_TL T
249: where not exists
250: (select NULL
251: from CN_DIMENSIONS_ALL_B B
252: where B.DIMENSION_ID = T.dimension_id

Line 256: update CN_DIMENSIONS_ALL_TL T set (

252: where B.DIMENSION_ID = T.dimension_id
253: and B.ORG_ID = T.ORG_ID
254: );
255:
256: update CN_DIMENSIONS_ALL_TL T set (
257: NAME
258: ) = (select
259: B.NAME
260: from CN_DIMENSIONS_ALL_TL B

Line 260: from CN_DIMENSIONS_ALL_TL B

256: update CN_DIMENSIONS_ALL_TL T set (
257: NAME
258: ) = (select
259: B.NAME
260: from CN_DIMENSIONS_ALL_TL B
261: where B.DIMENSION_ID = T.DIMENSION_ID
262: and B.LANGUAGE = T.source_lang
263: and B.ORG_ID = T.ORG_ID
264: )

Line 271: from CN_DIMENSIONS_ALL_TL SUBB, CN_DIMENSIONS_ALL_TL SUBT

267: T.LANGUAGE
268: ) in (select
269: SUBT.DIMENSION_ID,
270: SUBT.LANGUAGE
271: from CN_DIMENSIONS_ALL_TL SUBB, CN_DIMENSIONS_ALL_TL SUBT
272: where SUBB.DIMENSION_ID = SUBT.DIMENSION_ID
273: and SUBB.LANGUAGE = SUBT.source_lang
274: and SUBB.ORG_ID = SUBT.ORG_ID
275: and (SUBB.NAME <> SUBT.NAME

Line 280: insert into CN_DIMENSIONS_ALL_TL (

276: or (SUBB.NAME is null and SUBT.NAME is not null)
277: or (SUBB.NAME is not null and SUBT.NAME is null)
278: ));
279:
280: insert into CN_DIMENSIONS_ALL_TL (
281: ORG_ID,
282: DIMENSION_ID,
283: NAME,
284: CREATION_DATE,

Line 302: from CN_DIMENSIONS_ALL_TL B, FND_LANGUAGES L

298: B.LAST_UPDATED_BY,
299: B.LAST_UPDATE_LOGIN,
300: L.LANGUAGE_CODE,
301: B.SOURCE_LANG
302: from CN_DIMENSIONS_ALL_TL B, FND_LANGUAGES L
303: where L.INSTALLED_FLAG in ('I', 'B')
304: and B.LANGUAGE = userenv('LANG')
305: and not exists
306: (select NULL

Line 307: from CN_DIMENSIONS_ALL_TL T

303: where L.INSTALLED_FLAG in ('I', 'B')
304: and B.LANGUAGE = userenv('LANG')
305: and not exists
306: (select NULL
307: from CN_DIMENSIONS_ALL_TL T
308: where T.DIMENSION_ID = B.DIMENSION_ID
309: and T.LANGUAGE = L.language_code
310: and T.ORG_ID = B.ORG_ID
311: );

Line 376: UPDATE cn_dimensions_all_tl SET

372: 0
373: );
374: END IF;
375: -- Load The record to _TL table
376: UPDATE cn_dimensions_all_tl SET
377: name = x_name,
378: last_update_date = sysdate,
379: last_updated_by = user_id,
380: last_update_login = 0,

Line 388: INSERT INTO cn_dimensions_all_tl

384: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
385:
386: IF (SQL%NOTFOUND) THEN
387: -- Insert new record to _TL table
388: INSERT INTO cn_dimensions_all_tl
389: (dimension_id,
390: org_id, -- R12 change
391: name,
392: creation_date,

Line 414: FROM cn_dimensions_all_tl t

410: FROM fnd_languages l
411: WHERE l.installed_flag IN ('I', 'B')
412: AND NOT EXISTS
413: (SELECT NULL
414: FROM cn_dimensions_all_tl t
415: WHERE t.dimension_id = x_dimension_id
416: AND t.org_id = x_org_id --R12 change
417: AND t.language = l.language_code);
418: END IF;

Line 445: UPDATE cn_dimensions_all_tl SET

441: ELSE
442: user_id := 0;
443: END IF;
444: -- Update the translation
445: UPDATE cn_dimensions_all_tl SET
446: name = x_name,
447: last_update_date = sysdate,
448: last_updated_by = user_id,
449: last_update_login = 0,