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.HZ_CUST_CLASS_DENORM dependencies on HZ_CLASS_CODE_DENORM

Line 14: -- selectable_flag of hz_class_code_denorm in procedure

10: -- 01/22/2004 Rajib R B Bug No:3330144.Modified procedure insert_class_codes.
11: -- Removed the check for ALLOW_MULTI_PARENT_FLAG='N'.
12: -- 01/07/2004 V.Ravichan Bug No:3735880. Modified Main() to comply with GSCC standards.
13: -- 07/27/2004 Rajib R B Bug No:2657352. Modified the sequels which update
14: -- selectable_flag of hz_class_code_denorm in procedure
15: -- insert_class_codes.
16:
17: PROCEDURE Debug_Message(
18: p_msg_level IN NUMBER,

Line 101: EXECUTE IMMEDIATE 'ALTER INDEX ' || l_index_owner ||'.hz_class_code_denorm_t1 REBUILD online parameters (''sync'')';

97: begin
98: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_tmp,l_index_owner);
99: if l_bool then
100: Write_Log(G_DEBUG_CONCURRENT, 1,'Intermedia index being re-built...');
101: EXECUTE IMMEDIATE 'ALTER INDEX ' || l_index_owner ||'.hz_class_code_denorm_t1 REBUILD online parameters (''sync'')';
102: Write_Log(G_DEBUG_CONCURRENT, 1,'Intermedia index rebuilt on column concat_class_code_meaning for table HZ_CLASS_CODE_DENORM.');
103: end if;
104: end rebuild_intermedia_index;
105:

Line 102: Write_Log(G_DEBUG_CONCURRENT, 1,'Intermedia index rebuilt on column concat_class_code_meaning for table HZ_CLASS_CODE_DENORM.');

98: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_tmp,l_index_owner);
99: if l_bool then
100: Write_Log(G_DEBUG_CONCURRENT, 1,'Intermedia index being re-built...');
101: EXECUTE IMMEDIATE 'ALTER INDEX ' || l_index_owner ||'.hz_class_code_denorm_t1 REBUILD online parameters (''sync'')';
102: Write_Log(G_DEBUG_CONCURRENT, 1,'Intermedia index rebuilt on column concat_class_code_meaning for table HZ_CLASS_CODE_DENORM.');
103: end if;
104: end rebuild_intermedia_index;
105:
106:

Line 119: INSERT INTO HZ_CLASS_CODE_DENORM (

115: if p_class_category is null
116: then
117: -- insert first level nodes
118:
119: INSERT INTO HZ_CLASS_CODE_DENORM (
120: CLASS_CATEGORY,
121: CLASS_CODE,
122: CLASS_CODE_MEANING,
123: CLASS_CODE_DESCRIPTION,

Line 188: INSERT INTO HZ_CLASS_CODE_DENORM (

184: --Loop insert nodes in increasing level order starting from level 2 exit when no data found
185: FOR I IN 2 ..HZ_CUST_CLASS_DENORM.G_CODE_LEVEL LOOP
186: BEGIN
187:
188: INSERT INTO HZ_CLASS_CODE_DENORM (
189: CLASS_CATEGORY,
190: CLASS_CODE,
191: CLASS_CODE_MEANING,
192: CLASS_CODE_DESCRIPTION,

Line 239: HZ_CLASS_CODE_DENORM DENORM

235: FND_LOOKUP_VALUES LV,
236: HZ_CLASS_CATEGORIES CC,
237: HZ_CLASS_CATEGORY_USES CCU,
238: HZ_CLASS_CODE_RELATIONS CCR,
239: HZ_CLASS_CODE_DENORM DENORM
240: WHERE LT.LOOKUP_TYPE = CC.CLASS_CATEGORY
241: AND LT.VIEW_APPLICATION_ID = 222
242: AND LV.VIEW_APPLICATION_ID = 222
243: AND CC.CLASS_CATEGORY = CCU.CLASS_CATEGORY

Line 284: HZ_CLASS_CODE_DENORM DENORM

280: FND_LOOKUP_VALUES LV,
281: HZ_CLASS_CATEGORIES CC,
282: HZ_CLASS_CATEGORY_USES CCU,
283: HZ_CLASS_CODE_RELATIONS CCR,
284: HZ_CLASS_CODE_DENORM DENORM
285: WHERE LT.LOOKUP_TYPE = CC.CLASS_CATEGORY
286: AND LT.VIEW_APPLICATION_ID = 222
287: AND LV.VIEW_APPLICATION_ID = 222
288: AND CC.CLASS_CATEGORY = CCU.CLASS_CATEGORY

Line 314: * update hz_class_code_denorm denorm

310: /* Bug 2657352. Removed hz_class_code_relations rel1 and fnd_lookup_values lv from the join.
311: * Furthermore considered the date range of the relationships in
312: * hz_class_code_relations
313: *
314: * update hz_class_code_denorm denorm
315: * set selectable_flag ='N'
316: * where exists (select 'x'
317: * from hz_class_code_relations rel1,
318: * hz_class_code_relations rel2,

Line 332: UPDATE hz_class_code_denorm denorm

328: * and rel2.class_code = denorm.class_code
329: * and cc.allow_leaf_node_only_flag = 'Y');
330: */
331:
332: UPDATE hz_class_code_denorm denorm
333: SET selectable_flag ='N'
334: WHERE EXISTS
335: (SELECT 'X'
336: FROM hz_class_code_relations rel1,

Line 355: INSERT INTO HZ_CLASS_CODE_DENORM (

351: else -- p_class_category is passed in
352:
353: -- insert first level nodes
354:
355: INSERT INTO HZ_CLASS_CODE_DENORM (
356: CLASS_CATEGORY,
357: CLASS_CODE,
358: CLASS_CODE_MEANING,
359: CLASS_CODE_DESCRIPTION,

Line 426: INSERT INTO HZ_CLASS_CODE_DENORM (

422: --Loop insert nodes in increasing level order starting from level 2 exit when no data found
423: FOR I IN 2 ..HZ_CUST_CLASS_DENORM.G_CODE_LEVEL LOOP
424: BEGIN
425:
426: INSERT INTO HZ_CLASS_CODE_DENORM (
427: CLASS_CATEGORY,
428: CLASS_CODE,
429: CLASS_CODE_MEANING,
430: CLASS_CODE_DESCRIPTION,

Line 477: HZ_CLASS_CODE_DENORM DENORM

473: FND_LOOKUP_VALUES LV,
474: HZ_CLASS_CATEGORIES CC,
475: HZ_CLASS_CATEGORY_USES CCU,
476: HZ_CLASS_CODE_RELATIONS CCR,
477: HZ_CLASS_CODE_DENORM DENORM
478: WHERE LT.LOOKUP_TYPE = CC.CLASS_CATEGORY
479: AND LT.VIEW_APPLICATION_ID = 222
480: AND LV.VIEW_APPLICATION_ID = 222
481: AND CC.CLASS_CATEGORY = CCU.CLASS_CATEGORY

Line 523: HZ_CLASS_CODE_DENORM DENORM

519: FND_LOOKUP_VALUES LV,
520: HZ_CLASS_CATEGORIES CC,
521: HZ_CLASS_CATEGORY_USES CCU,
522: HZ_CLASS_CODE_RELATIONS CCR,
523: HZ_CLASS_CODE_DENORM DENORM
524: WHERE LT.LOOKUP_TYPE = CC.CLASS_CATEGORY
525: AND LT.VIEW_APPLICATION_ID = 222
526: AND LV.VIEW_APPLICATION_ID = 222
527: AND CC.CLASS_CATEGORY = CCU.CLASS_CATEGORY

Line 558: * update hz_class_code_denorm denorm

554: * Performed the update only if allow_leaf_node_flag is 'Y'.
555: * Used an anonymous block so that resources for variable
556: * l_allow_leaf_node_only_flag are released after this block.
557: *
558: * update hz_class_code_denorm denorm
559: * set selectable_flag ='N'
560: * where denorm.class_category = p_class_category
561: * and exists (select 'x'
562: * from hz_class_code_relations rel1,

Line 589: UPDATE hz_class_code_denorm denorm

585:
586: IF (l_allow_leaf_node_only_flag = 'Y')
587: THEN
588: -- set selectable_flag based on allow_leaf_node_only_flag
589: UPDATE hz_class_code_denorm denorm
590: SET selectable_flag ='N'
591: WHERE denorm.class_category = p_class_category AND
592: EXISTS
593: (SELECT 'x'

Line 655: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_table_owner||'.HZ_CLASS_CODE_DENORM REUSE STORAGE';

651: -- full refresh
652: -- Code added for Bug 3735880 starts here
653: l_bool := fnd_installation.GET_APP_INFO('AR',l_status_owner,l_tmp,l_table_owner);
654: if l_bool then
655: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_table_owner||'.HZ_CLASS_CODE_DENORM REUSE STORAGE';
656: end if;
657: -- Code added for Bug 3735880 ends here
658: else
659: -- only refresh passing in class_category

Line 660: delete from hz_class_code_denorm where class_category = p_class_category;

656: end if;
657: -- Code added for Bug 3735880 ends here
658: else
659: -- only refresh passing in class_category
660: delete from hz_class_code_denorm where class_category = p_class_category;
661: end if;
662:
663: IF (RETCODE = 0) THEN
664: insert_class_codes(ERRBUF, RETCODE, p_class_category);