eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.CN_DIMENSIONS_PKG dependencies on CN_DIMENSIONS

Line 1: PACKAGE BODY CN_DIMENSIONS_PKG as

1: PACKAGE BODY CN_DIMENSIONS_PKG as
2: -- $Header: cndidimb.pls 120.7 2006/01/13 03:58:07 hanaraya noship $
3:
4:
5: -- Procedure Name

Line 25: insert into CN_DIMENSIONS_ALL_B (

21: X_ORG_ID in NUMBER
22: --R12 MOAC Changes--End
23: ) is
24: begin
25: insert into CN_DIMENSIONS_ALL_B (
26: DIMENSION_ID,
27: DESCRIPTION,
28: SOURCE_TABLE_ID,
29: CREATION_DATE,

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 97: -- Update a row in cn_dimensions.

93:
94: -- Procedure Name
95: -- update_row
96: -- Purpose
97: -- Update a row in cn_dimensions.
98: -- History
99: -- 12/28/93 Paul Mitchell Created
100:
101: procedure UPDATE_ROW (

Line 112: X_OBJECT_VERSION_NUMBER in out NOCOPY CN_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE

108: X_LAST_UPDATE_LOGIN in NUMBER,
109: --R12 MOAC Changes--Start
110: X_ORG_ID in NUMBER,
111: --R12 MOAC Changes--End
112: X_OBJECT_VERSION_NUMBER in out NOCOPY CN_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE
113: ) is
114: begin
115:
116: X_OBJECT_VERSION_NUMBER := X_OBJECT_VERSION_NUMBER + 1;

Line 118: update CN_DIMENSIONS_ALL_B set

114: begin
115:
116: X_OBJECT_VERSION_NUMBER := X_OBJECT_VERSION_NUMBER + 1;
117:
118: update CN_DIMENSIONS_ALL_B set
119: DESCRIPTION = X_DESCRIPTION,
120: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
121: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
122: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

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 158: -- Delete a row from cn_dimensions.

154:
155: -- Procedure Name
156: -- delete_row
157: -- Purpose
158: -- Delete a row from cn_dimensions.
159: -- History
160: -- 12/28/93 Paul Mitchell Created
161: -- PROCEDURE delete_row(
162: -- X_rowid varchar2) IS

Line 179: from cn_dimensions where dimension_id = X_DIMENSION_ID

175: into l_env_org_id from dual;
176:
177: -- clean up cn_objects and remove pointers to non-existent dimension ID
178: select source_table_id into l_table_id
179: from cn_dimensions where dimension_id = X_DIMENSION_ID
180: --R12 MOAC Changes--Start
181: and org_id = X_ORG_ID;
182: --R12 MOAC Changes--End
183:

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 230: delete from CN_DIMENSIONS_ALL_B

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
231: where dimension_id = X_DIMENSION_ID
232: and ORG_ID = X_ORG_ID;
233:
234: if (sql%notfound) then

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 251: from CN_DIMENSIONS_ALL_B B

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
253: and B.ORG_ID = T.ORG_ID
254: );
255:

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 342: UPDATE cn_dimensions_all_b SET

338: ELSE
339: user_id := 0;
340: END IF;
341: -- Load The record to _B table
342: UPDATE cn_dimensions_all_b SET
343: description = x_description,
344: source_table_id = x_source_table_id,
345: last_update_date = sysdate,
346: last_updated_by = user_id,

Line 353: INSERT INTO cn_dimensions_all_b

349: AND org_id = x_org_id; --R12 change
350:
351: IF (SQL%NOTFOUND) THEN
352: -- Insert new record to _B table
353: INSERT INTO cn_dimensions_all_b
354: (dimension_id,
355: org_id, -- R12 change
356: description,
357: source_table_id,

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,

Line 462: SELECT cn_dimensions_s.nextval INTO Ret_Val FROM dual;

458: FUNCTION New_Dimension RETURN NUMBER IS
459: Ret_Val NUMBER(15);
460: BEGIN
461:
462: SELECT cn_dimensions_s.nextval INTO Ret_Val FROM dual;
463:
464: RETURN Ret_Val;
465:
466: END New_Dimension;

Line 470: END CN_DIMENSIONS_PKG;

466: END New_Dimension;
467:
468:
469:
470: END CN_DIMENSIONS_PKG;