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.AS_CLASSIFICATION_HOOKS dependencies on AS_HZ_CLASS_CODE_DENORM

Line 8: update as_hz_class_code_denorm denorm

4:
5: procedure update_selectable_flag(p_class_category in varchar2) is
6: begin
7:
8: update as_hz_class_code_denorm denorm
9: set selectable_flag = 'N'
10: where denorm.class_category = p_class_category
11: and selectable_flag = 'Y'
12: and exists (select 'x'

Line 36: update as_hz_class_code_denorm

32:
33: begin
34: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Update Category Post Start');
35:
36: update as_hz_class_code_denorm
37: set class_category_meaning = p_category_meaning
38: where class_category = p_class_category
39: and language = userenv('LANG')
40: and class_category_meaning <> p_category_meaning;

Line 46: update as_hz_class_code_denorm denorm

42: if p_allow_leaf_node_only_flag ='Y'
43: then
44: update_selectable_flag(p_class_category);
45: else
46: update as_hz_class_code_denorm denorm
47: set selectable_flag = 'Y'
48: where denorm.class_category = p_class_category
49: and selectable_flag = 'N';
50: end if;

Line 72: INSERT INTO AS_HZ_CLASS_CODE_DENORM(

68: p_start_date_active in date,
69: p_end_date_active in date) is
70: begin
71:
72: INSERT INTO AS_HZ_CLASS_CODE_DENORM(
73: CLASS_CATEGORY,
74: CLASS_CATEGORY_MEANING,
75: CLASS_CODE,
76: CLASS_CODE_MEANING,

Line 177: from as_hz_class_code_denorm

173: function get_class_code_level(p_class_category in varchar2, p_class_code in varchar2) return
174: varchar2 is
175: cursor get_code_level_csr is
176: select code_level
177: from as_hz_class_code_denorm
178: where class_category = p_class_category
179: and class_code = p_class_code
180: and ancestor_code = p_class_code
181: and language = userenv('LANG');

Line 290: update as_hz_class_code_denorm

286: open get_language_csr;
287: loop
288: fetch get_language_csr into l_language;
289: l_concat_meaning := get_concat_meaning(p_class_category,p_curr_code,l_language);
290: update as_hz_class_code_denorm
291: set concat_class_code_meaning = l_concat_meaning
292: where class_category = p_class_category
293: and class_code = p_curr_code
294: and language = l_language;

Line 311: from as_hz_class_code_denorm

307: p_end_date_active in date) is
308:
309: cursor get_code_meaning_csr is
310: select class_code_meaning
311: from as_hz_class_code_denorm
312: where class_category = p_lookup_type
313: and class_code = p_lookup_code
314: and ancestor_code = p_lookup_code
315: and language = userenv('LANG');

Line 323: update as_hz_class_code_denorm

319: open get_code_meaning_csr;
320: fetch get_code_meaning_csr into l_old_meaning;
321: close get_code_meaning_csr;
322:
323: update as_hz_class_code_denorm
324: set enabled_flag = p_enabled_flag,
325: start_date_active = p_start_date_active,
326: end_date_active = p_end_date_active
327: where class_category = p_lookup_type

Line 330: update as_hz_class_code_denorm

326: end_date_active = p_end_date_active
327: where class_category = p_lookup_type
328: and class_code = p_lookup_code;
329:
330: update as_hz_class_code_denorm
331: set ancestor_meaning = p_meaning
332: where class_category = p_lookup_type
333: and ancestor_code = p_lookup_code
334: and language = userenv('LANG');

Line 341: update as_hz_class_code_denorm

337: -- Therefore, need to be handled seperately
338: -- segment1 to 4 only used in total mode, not online mode,data change
339: -- will not be maintained.
340:
341: update as_hz_class_code_denorm
342: set
343: class_code_meaning = p_meaning,
344: class_code_description = p_description,
345: segment1_meaning = 'not used',

Line 355: update as_hz_class_code_denorm

351: and language = userenv('LANG')
352: and (class_code_meaning <> p_meaning
353: or nvl(class_code_description, '#@#') <> nvl(p_description, '#@#'));
354:
355: update as_hz_class_code_denorm
356: set
357: concat_class_code_meaning = replace(concat_class_code_meaning,l_old_meaning, p_meaning)
358: where class_category = p_lookup_type
359: and instr(concat_class_code_meaning,l_old_meaning)>0

Line 393: update as_hz_class_code_denorm ccd

389: -- update those rows inserted in register_lookup_code_post with code relations
390: -- Due to language concern and func can't be called in the update,
391: -- concat meaning will be handled seperately.
392:
393: update as_hz_class_code_denorm ccd
394: set code_level = 2,
395: concat_class_code = l_concat_code
396: where class_category = p_class_category
397: and class_code = p_sub_class_code;

Line 399: insert into as_hz_class_code_denorm (

395: concat_class_code = l_concat_code
396: where class_category = p_class_category
397: and class_code = p_sub_class_code;
398:
399: insert into as_hz_class_code_denorm (
400: class_category,
401: class_category_meaning,
402: class_code,
403: class_code_meaning,

Line 491: as_hz_class_code_denorm denorm,

487: fnd_global.conc_program_id,
488: fnd_global.prog_appl_id,
489: sysdate
490: from
491: as_hz_class_code_denorm denorm,
492: fnd_lookup_values lv
493: where
494: denorm.class_category = lv.lookup_type
495: and denorm.language = lv.language

Line 505: update as_hz_class_code_denorm ccd

501: elsif l_code_level =2
502: then
503:
504: -- update those rows inserted in register_lookup_code_post with code relations
505: update as_hz_class_code_denorm ccd
506: set code_level = 3,
507: concat_class_code = l_concat_code
508: where class_code = p_sub_class_code
509: and class_category = p_class_category;

Line 511: insert into as_hz_class_code_denorm (

507: concat_class_code = l_concat_code
508: where class_code = p_sub_class_code
509: and class_category = p_class_category;
510:
511: insert into as_hz_class_code_denorm (
512: class_category,
513: class_category_meaning,
514: class_code,
515: class_code_meaning,

Line 603: as_hz_class_code_denorm denorm,

599: fnd_global.conc_program_id,
600: fnd_global.prog_appl_id,
601: sysdate
602: from
603: as_hz_class_code_denorm denorm,
604: fnd_lookup_values lv
605: where
606: denorm.class_category = lv.lookup_type
607: and denorm.language = lv.language

Line 617: update as_hz_class_code_denorm ccd

613: elsif l_code_level =3
614: then
615:
616: -- update those rows inserted in register_lookup_code_post with code relations
617: update as_hz_class_code_denorm ccd
618: set code_level = 4,
619: concat_class_code = l_concat_code
620: where class_code = p_sub_class_code
621: and class_category = p_class_category;

Line 623: insert into as_hz_class_code_denorm (

619: concat_class_code = l_concat_code
620: where class_code = p_sub_class_code
621: and class_category = p_class_category;
622:
623: insert into as_hz_class_code_denorm (
624: class_category,
625: class_category_meaning,
626: class_code,
627: class_code_meaning,

Line 715: as_hz_class_code_denorm denorm,

711: fnd_global.conc_program_id,
712: fnd_global.prog_appl_id,
713: sysdate
714: from
715: as_hz_class_code_denorm denorm,
716: fnd_lookup_values lv
717: where
718: denorm.class_category = lv.lookup_type
719: and denorm.language = lv.language

Line 758: from as_hz_class_code_denorm

754: if l_code_level = 4
755: then
756: -- delete extra data entered from register_lookup_code_post where level > 4 for sub code.
757: delete
758: from as_hz_class_code_denorm
759: where class_category = p_class_category
760: and class_code = p_sub_class_code
761: and code_level = 1;
762: end if;

Line 794: from as_hz_class_code_denorm

790: where lookup_type = p_class_category;
791:
792: cursor code_relation_exist_csr is
793: select 'x'
794: from as_hz_class_code_denorm
795: where class_category = p_class_category
796: and class_code = p_sub_class_code
797: and ancestor_code = p_class_code
798: and language = userenv('LANG');

Line 813: update as_hz_class_code_denorm

809: open get_concat_code_csr;
810: loop
811: fetch get_concat_code_csr into l_class_code,l_concat_code;
812: exit when get_concat_code_csr%NOTFOUND;
813: update as_hz_class_code_denorm
814: set concat_class_code = l_concat_code
815: where class_category = p_class_category
816: and class_code = l_class_code;
817:

Line 824: update as_hz_class_code_denorm

820: open get_concat_meaning_csr;
821: loop
822: fetch get_concat_meaning_csr into l_class_code,l_language,l_concat_meaning;
823: exit when get_concat_meaning_csr%NOTFOUND;
824: update as_hz_class_code_denorm
825: set concat_class_code_meaning = l_concat_meaning
826: where class_category = p_class_category
827: and class_code = l_class_code
828: and language = l_language;

Line 845: from as_hz_class_code_denorm

841: -- if end date relation between 1 and 2, the hierarchy will look like 1, 2->3->4
842: -- code relation 1->2, 1->3, 1->4 need to be deleted
843:
844: delete
845: from as_hz_class_code_denorm
846: where class_category = p_class_category
847: and ancestor_code = p_class_code
848: and class_code <> p_class_code;
849:

Line 850: update as_hz_class_code_denorm

846: where class_category = p_class_category
847: and ancestor_code = p_class_code
848: and class_code <> p_class_code;
849:
850: update as_hz_class_code_denorm
851: set code_level = code_level-1
852: where class_category = p_class_category
853: and code_level <> 1;
854:

Line 865: from as_hz_class_code_denorm

861: fetch get_sub_sub_class_code into l_sub_sub_code;
862: close get_sub_sub_class_code;
863:
864: delete
865: from as_hz_class_code_denorm
866: where class_category = p_class_category
867: and ancestor_code <> p_sub_class_code
868: and class_code = p_sub_class_code
869: or (class_code = l_sub_sub_code and ancestor_code not in (l_sub_sub_code,p_sub_class_code));

Line 871: update as_hz_class_code_denorm

867: and ancestor_code <> p_sub_class_code
868: and class_code = p_sub_class_code
869: or (class_code = l_sub_sub_code and ancestor_code not in (l_sub_sub_code,p_sub_class_code));
870:
871: update as_hz_class_code_denorm
872: set code_level = 1
873: where class_category = p_class_category
874: and class_code = p_sub_class_code;
875:

Line 876: update as_hz_class_code_denorm

872: set code_level = 1
873: where class_category = p_class_category
874: and class_code = p_sub_class_code;
875:
876: update as_hz_class_code_denorm
877: set code_level = 2
878: where class_category = p_class_category
879: and class_code = l_sub_sub_code;
880:

Line 887: from as_hz_class_code_denorm

883:
884: elsif l_code_level = 4
885: then
886: delete
887: from as_hz_class_code_denorm
888: where class_category = p_class_category
889: and class_code = p_sub_class_code
890: and ancestor_code<>p_sub_class_code;
891:

Line 892: update as_hz_class_code_denorm

888: where class_category = p_class_category
889: and class_code = p_sub_class_code
890: and ancestor_code<>p_sub_class_code;
891:
892: update as_hz_class_code_denorm
893: set code_level = 1
894: where class_category = p_class_category
895: and class_code = p_sub_class_code
896: and ancestor_code = p_sub_class_code;