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.

APPS.CN_HEAD_HIERARCHIES_ALL_PKG dependencies on CN_HEAD_HIERARCHIES

Line 1: package body CN_HEAD_HIERARCHIES_ALL_PKG as

1: package body CN_HEAD_HIERARCHIES_ALL_PKG as
2: /* $Header: cnmlhhb.pls 120.5 2006/01/11 05:07:00 hanaraya noship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out nocopy VARCHAR2,

Line 21: insert into CN_HEAD_HIERARCHIES_ALL_B (

17: --R12 MOAC Changes--End
18: ) is
19:
20: begin
21: insert into CN_HEAD_HIERARCHIES_ALL_B (
22: HEAD_HIERARCHY_ID,
23: DIMENSION_ID,
24: DESCRIPTION,
25: CREATION_DATE,

Line 47: insert into CN_HEAD_HIERARCHIES_ALL_TL (

43: X_ORG_ID
44: --R12 MOAC Changes--End
45: );
46:
47: insert into CN_HEAD_HIERARCHIES_ALL_TL (
48: HEAD_HIERARCHY_ID,
49: DIMENSION_ID,
50: NAME,
51: CREATION_DATE,

Line 79: from CN_HEAD_HIERARCHIES_ALL_TL T

75: from FND_LANGUAGES L
76: where L.INSTALLED_FLAG in ('I', 'B')
77: and not exists
78: (select NULL
79: from CN_HEAD_HIERARCHIES_ALL_TL T
80: where T.HEAD_HIERARCHY_ID = X_HEAD_HIERARCHY_ID
81: and T.LANGUAGE = L.language_code AND
82: --R12 MOAC Changes--Start
83: ORG_ID = X_ORG_ID

Line 101: X_OBJECT_VERSION_NUMBER in out NOCOPY CN_HEAD_HIERARCHIES.OBJECT_VERSION_NUMBER%TYPE

97: X_LAST_UPDATE_LOGIN in NUMBER,
98: --R12 MOAC Changes--Start
99: X_ORG_ID in NUMBER,
100: --R12 MOAC Changes--End
101: X_OBJECT_VERSION_NUMBER in out NOCOPY CN_HEAD_HIERARCHIES.OBJECT_VERSION_NUMBER%TYPE
102: ) is
103: begin
104: X_OBJECT_VERSION_NUMBER := X_OBJECT_VERSION_NUMBER + 1; --Increment Obj Ver Num
105: update CN_HEAD_HIERARCHIES_ALL_B set

Line 105: update CN_HEAD_HIERARCHIES_ALL_B set

101: X_OBJECT_VERSION_NUMBER in out NOCOPY CN_HEAD_HIERARCHIES.OBJECT_VERSION_NUMBER%TYPE
102: ) is
103: begin
104: X_OBJECT_VERSION_NUMBER := X_OBJECT_VERSION_NUMBER + 1; --Increment Obj Ver Num
105: update CN_HEAD_HIERARCHIES_ALL_B set
106: DESCRIPTION = X_DESCRIPTION,
107: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
108: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
109: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 120: update CN_HEAD_HIERARCHIES_ALL_TL set

116: if (sql%notfound) then
117: raise no_data_found;
118: end if;
119:
120: update CN_HEAD_HIERARCHIES_ALL_TL set
121: NAME = X_NAME,
122: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
123: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
124: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 170: delete from CN_HEAD_HIERARCHIES_ALL_TL

166: AND org_id = X_ORG_ID;
167: --R12 MOAC Changes--End
168:
169: -- finally delete head hierarchy - handle MLS delete
170: delete from CN_HEAD_HIERARCHIES_ALL_TL
171: where HEAD_HIERARCHY_ID = X_HEAD_HIERARCHY_ID
172: and org_id = X_ORG_ID;
173:
174: delete from CN_HEAD_HIERARCHIES_ALL_B

Line 174: delete from CN_HEAD_HIERARCHIES_ALL_B

170: delete from CN_HEAD_HIERARCHIES_ALL_TL
171: where HEAD_HIERARCHY_ID = X_HEAD_HIERARCHY_ID
172: and org_id = X_ORG_ID;
173:
174: delete from CN_HEAD_HIERARCHIES_ALL_B
175: where HEAD_HIERARCHY_ID = X_HEAD_HIERARCHY_ID
176: and org_id = X_ORG_ID;
177:
178: if (sql%notfound) then

Line 188: delete from CN_HEAD_HIERARCHIES_ALL_TL T

184:
185: procedure ADD_LANGUAGE
186: is
187: begin
188: delete from CN_HEAD_HIERARCHIES_ALL_TL T
189: where not exists
190: (select NULL
191: from CN_HEAD_HIERARCHIES_ALL_B B
192: where B.HEAD_HIERARCHY_ID = T.head_hierarchy_id

Line 191: from CN_HEAD_HIERARCHIES_ALL_B B

187: begin
188: delete from CN_HEAD_HIERARCHIES_ALL_TL T
189: where not exists
190: (select NULL
191: from CN_HEAD_HIERARCHIES_ALL_B B
192: where B.HEAD_HIERARCHY_ID = T.head_hierarchy_id
193: and B.ORG_ID = T.ORG_ID
194: );
195:

Line 196: update CN_HEAD_HIERARCHIES_ALL_TL T set (

192: where B.HEAD_HIERARCHY_ID = T.head_hierarchy_id
193: and B.ORG_ID = T.ORG_ID
194: );
195:
196: update CN_HEAD_HIERARCHIES_ALL_TL T set (
197: NAME
198: ) = (select
199: B.NAME
200: from CN_HEAD_HIERARCHIES_ALL_TL B

Line 200: from CN_HEAD_HIERARCHIES_ALL_TL B

196: update CN_HEAD_HIERARCHIES_ALL_TL T set (
197: NAME
198: ) = (select
199: B.NAME
200: from CN_HEAD_HIERARCHIES_ALL_TL B
201: where B.HEAD_HIERARCHY_ID = T.HEAD_HIERARCHY_ID
202: and B.LANGUAGE = T.source_lang
203: and B.ORG_ID = T.ORG_ID )
204: where (

Line 210: from CN_HEAD_HIERARCHIES_ALL_TL SUBB, CN_HEAD_HIERARCHIES_ALL_TL SUBT

206: T.LANGUAGE
207: ) in (select
208: SUBT.HEAD_HIERARCHY_ID,
209: SUBT.LANGUAGE
210: from CN_HEAD_HIERARCHIES_ALL_TL SUBB, CN_HEAD_HIERARCHIES_ALL_TL SUBT
211: where SUBB.HEAD_HIERARCHY_ID = SUBT.HEAD_HIERARCHY_ID
212: and SUBB.LANGUAGE = SUBT.source_lang
213: and SUBB.ORG_ID = SUBT.ORG_ID
214: and (SUBB.NAME <> SUBT.NAME

Line 219: insert into CN_HEAD_HIERARCHIES_ALL_TL (

215: or (SUBB.NAME is null and SUBT.NAME is not null)
216: or (SUBB.NAME is not null and SUBT.NAME is null)
217: ));
218:
219: insert into CN_HEAD_HIERARCHIES_ALL_TL (
220: ORG_ID,
221: HEAD_HIERARCHY_ID,
222: DIMENSION_ID,
223: NAME,

Line 243: from CN_HEAD_HIERARCHIES_ALL_TL B, FND_LANGUAGES L

239: B.LAST_UPDATED_BY,
240: B.LAST_UPDATE_LOGIN,
241: L.LANGUAGE_CODE,
242: B.SOURCE_LANG
243: from CN_HEAD_HIERARCHIES_ALL_TL B, FND_LANGUAGES L
244: where L.INSTALLED_FLAG in ('I', 'B')
245: and B.LANGUAGE = userenv('LANG')
246: and not exists
247: (select NULL

Line 248: from CN_HEAD_HIERARCHIES_ALL_TL T

244: where L.INSTALLED_FLAG in ('I', 'B')
245: and B.LANGUAGE = userenv('LANG')
246: and not exists
247: (select NULL
248: from CN_HEAD_HIERARCHIES_ALL_TL T
249: where T.HEAD_HIERARCHY_ID = B.HEAD_HIERARCHY_ID
250: and T.LANGUAGE = L.language_code
251: and T.ORG_ID = B.ORG_ID );
252: end ADD_LANGUAGE;

Line 281: UPDATE cn_head_hierarchies_all_b SET

277: ELSE
278: user_id := 0;
279: END IF;
280: -- Load The record to _B table
281: UPDATE cn_head_hierarchies_all_b SET
282: dimension_id = x_dimension_id,
283: description = x_description,
284: last_update_date = sysdate,
285: last_updated_by = user_id,

Line 292: INSERT INTO cn_head_hierarchies_all_b

288: AND org_id = x_org_id; -- R12 change
289:
290: IF (SQL%NOTFOUND) THEN
291: -- Insert new record to _B table
292: INSERT INTO cn_head_hierarchies_all_b
293: (head_hierarchy_id,
294: dimension_id,
295: org_id, --R12 Change
296: description,

Line 315: UPDATE cn_head_hierarchies_all_tl SET

311: 0
312: );
313: END IF;
314: -- Load The record to _TL table
315: UPDATE cn_head_hierarchies_all_tl SET
316: dimension_id = x_dimension_id,
317: name = x_name,
318: last_update_date = sysdate,
319: last_updated_by = user_id,

Line 328: INSERT INTO cn_head_hierarchies_all_tl

324: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
325:
326: IF (SQL%NOTFOUND) THEN
327: -- Insert new record to _TL table
328: INSERT INTO cn_head_hierarchies_all_tl
329: (head_hierarchy_id,
330: dimension_id,
331: org_id, --R12 change
332: name,

Line 356: FROM cn_head_hierarchies_all_tl t

352: FROM fnd_languages l
353: WHERE l.installed_flag IN ('I', 'B')
354: AND NOT EXISTS
355: (SELECT NULL
356: FROM cn_head_hierarchies_all_tl t
357: WHERE t.head_hierarchy_id = x_head_hierarchy_id
358: AND t.org_id = x_org_id -- R12 change
359: AND t.language = l.language_code);
360: END IF;

Line 389: UPDATE cn_head_hierarchies_all_tl SET

385: ELSE
386: user_id := 0;
387: END IF;
388: -- Update the translation
389: UPDATE cn_head_hierarchies_all_tl SET
390: name = x_name,
391: last_update_date = sysdate,
392: last_updated_by = user_id,
393: last_update_login = 0,

Line 407: SELECT cn_head_hierarchies_s.nextval INTO Ret_Val FROM dual;

403: FUNCTION Default_Header RETURN NUMBER IS
404: Ret_Val NUMBER(15);
405: BEGIN
406:
407: SELECT cn_head_hierarchies_s.nextval INTO Ret_Val FROM dual;
408:
409: RETURN Ret_Val;
410:
411: END Default_Header;

Line 414: end CN_HEAD_HIERARCHIES_ALL_PKG;

410:
411: END Default_Header;
412:
413:
414: end CN_HEAD_HIERARCHIES_ALL_PKG;