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.AMW_RL_HIERARCHY_PKG dependencies on AMW_PROC_HIERARCHY_DENORM

Line 30: select 1 from amw_proc_hierarchy_denorm

26: return boolean
27: is
28: cursor c_relation_exists (l_ancestor_id number,
29: l_descendant_id number) is
30: select 1 from amw_proc_hierarchy_denorm
31: where process_id = l_ancestor_id and
32: parent_child_id = l_descendant_id and
33: hierarchy_type = 'L' and
34: up_down_ind = 'D';

Line 86: from amw_proc_hierarchy_denorm

82:
83: -- CURSOR TO SELECT ALL THE ANCESTORS OF THE GIVEN PROCESS.
84: cursor c_ancestors(l_process_id number) is
85: select parent_child_id
86: from amw_proc_hierarchy_denorm
87: where process_id = l_process_id and
88: up_down_ind = 'U';
89:
90: type ancestor_tbl is table of c_ancestors%rowtype;

Line 96: from amw_proc_hierarchy_denorm

92:
93: -- CURSOR TO SELECT ALL THE DESCENDANTS OF THE GIVEN PROCESS.
94: cursor c_descendants (l_process_id number) is
95: select parent_child_id
96: from amw_proc_hierarchy_denorm
97: where process_id = l_process_id and
98: up_down_ind = 'D';
99:
100: type descendants_tbl is table of c_descendants%rowtype;

Line 107: select 1 from amw_proc_hierarchy_denorm

103:
104: -- CURSOR TO FIND WHETHER THE A GIVEN RELATION EXISTS OR NOT..
105: cursor c_relation_exists (l_ancestor_id number,
106: l_descendant_id number) is
107: select 1 from amw_proc_hierarchy_denorm
108: where process_id = l_ancestor_id and
109: parent_child_id = l_descendant_id and
110: up_down_ind = 'D';
111:

Line 224: --now insert all the rows found into the amw_proc_hierarchy_denorm table

220: end loop;
221: end if;
222: end if;
223:
224: --now insert all the rows found into the amw_proc_hierarchy_denorm table
225: if(x_process_tbl.exists(1))
226:
227: then
228: forall i in x_process_tbl.first .. x_process_tbl.last

Line 229: insert into amw_proc_hierarchy_denorm (PROCESS_ID,

225: if(x_process_tbl.exists(1))
226:
227: then
228: forall i in x_process_tbl.first .. x_process_tbl.last
229: insert into amw_proc_hierarchy_denorm (PROCESS_ID,
230: PARENT_CHILD_ID,
231: UP_DOWN_IND,
232: LAST_UPDATE_DATE,
233: LAST_UPDATED_BY,

Line 448: delete from amw_proc_hierarchy_denorm where hierarchy_type='A';

444: then
445: --make the pl/sql tables contain the up2date data
446: recursive_construct_denorm(p_process_id => -1);
447: --DML operations
448: delete from amw_proc_hierarchy_denorm where hierarchy_type='A';
449:
450: else
451: recursive_construct_denorm(p_process_id => -2);
452:

Line 466: insert into amw_proc_hierarchy_denorm (PROCESS_ID,

462: if(p_org_id is null or p_org_id = -1)
463:
464: then
465: forall i in x_process_tbl.first .. x_process_tbl.last
466: insert into amw_proc_hierarchy_denorm (PROCESS_ID,
467: PARENT_CHILD_ID,
468: UP_DOWN_IND,
469: LAST_UPDATE_DATE,
470: LAST_UPDATED_BY,

Line 637: delete from amw_proc_hierarchy_denorm where hierarchy_type='L';

633: --delete all rows from the denorm table
634:
635: if(p_org_id is null or p_org_id = -1)
636: then
637: delete from amw_proc_hierarchy_denorm where hierarchy_type='L';
638: else
639: delete from amw_org_hierarchy_denorm
640: where organization_id = p_org_id and
641: hierarchy_type='L';

Line 652: insert into amw_proc_hierarchy_denorm (PROCESS_ID,

648: if(p_org_id is null or p_org_id = -1)
649:
650: then
651: forall i in x_process_tbl.first .. x_process_tbl.last
652: insert into amw_proc_hierarchy_denorm (PROCESS_ID,
653: PARENT_CHILD_ID,
654: UP_DOWN_IND,
655: LAST_UPDATE_DATE,
656: LAST_UPDATED_BY,

Line 2748: from amw_proc_hierarchy_denorm

2744:
2745: cursor c is
2746: (select process_id from amw_process where process_id in
2747: ((select parent_child_id
2748: from amw_proc_hierarchy_denorm
2749: where process_id = p_process_id
2750: and up_down_ind = 'U'
2751: and hierarchy_type = 'A'
2752: )

Line 2768: from amw_proc_hierarchy_denorm

2764: update amw_process
2765: set risk_count = (select count(*) from (
2766: select distinct risk_id from amw_risk_associations
2767: where pk1 in ( ( select parent_child_id
2768: from amw_proc_hierarchy_denorm
2769: where process_id = x(ctr)
2770: and up_down_ind = 'D'
2771: and hierarchy_type = 'A') union all (select x(ctr) from dual) )
2772: and approval_date is not null

Line 2813: from amw_proc_hierarchy_denorm

2809: is
2810: cursor c is
2811: (select process_id from amw_process where process_id in
2812: ((select parent_child_id
2813: from amw_proc_hierarchy_denorm
2814: where process_id = p_process_id
2815: and up_down_ind = 'U'
2816: and hierarchy_type = 'A'
2817: )

Line 2834: from amw_proc_hierarchy_denorm

2830: update amw_process
2831: set control_count = (select count(*) from (
2832: select distinct control_id from amw_control_associations
2833: where pk1 in ( ( select parent_child_id
2834: from amw_proc_hierarchy_denorm
2835: where process_id = x(ctr)
2836: and up_down_ind = 'D'
2837: and hierarchy_type = 'A') union all (select x(ctr) from dual) )
2838: and approval_date is not null

Line 2869: from amw_proc_hierarchy_denorm

2865:
2866: cursor c is
2867: (select process_id from amw_process where process_id in
2868: (select parent_child_id
2869: from amw_proc_hierarchy_denorm
2870: where process_id = -1
2871: and up_down_ind = 'D'
2872: and hierarchy_type = 'A'
2873: ));

Line 2887: from amw_proc_hierarchy_denorm

2883: update amw_process
2884: set risk_count = (select count(*) from (
2885: select distinct risk_id from amw_risk_associations
2886: where pk1 in ( ( select parent_child_id
2887: from amw_proc_hierarchy_denorm
2888: where process_id = x(ctr)
2889: and up_down_ind = 'D'
2890: and hierarchy_type = 'A') union all (select x(ctr) from dual) )
2891: and approval_date is not null

Line 2916: from amw_proc_hierarchy_denorm

2912: procedure update_appr_control_counts is
2913: cursor c is
2914: (select process_id from amw_process where process_id in
2915: (select parent_child_id
2916: from amw_proc_hierarchy_denorm
2917: where process_id = -1
2918: and up_down_ind = 'D'
2919: and hierarchy_type = 'A'
2920: ));

Line 2936: from amw_proc_hierarchy_denorm

2932: update amw_process
2933: set control_count = (select count(*) from (
2934: select distinct control_id from amw_control_associations
2935: where pk1 in ( (select parent_child_id
2936: from amw_proc_hierarchy_denorm
2937: where process_id = x(ctr)
2938: and up_down_ind = 'D'
2939: and hierarchy_type = 'A') union all (select x(ctr) from dual) )
2940: and approval_date is not null

Line 2976: from amw_proc_hierarchy_denorm

2972:
2973: cursor c is
2974: (select process_id from amw_process where process_id in
2975: (select parent_child_id
2976: from amw_proc_hierarchy_denorm
2977: where process_id = p_process_id
2978: and up_down_ind = 'U'
2979: and hierarchy_type = 'L'
2980: ) union all

Line 2995: from amw_proc_hierarchy_denorm

2991: update amw_process
2992: set control_count_latest = (select count(*) from (
2993: select distinct control_id from amw_control_associations
2994: where pk1 in ( ( select parent_child_id
2995: from amw_proc_hierarchy_denorm
2996: where process_id = x(ctr)
2997: and up_down_ind = 'D'
2998: and hierarchy_type = 'L') union all (select x(ctr) from dual) )
2999: and deletion_date is null

Line 3028: from amw_proc_hierarchy_denorm

3024: is
3025: cursor c is
3026: (select process_id from amw_process where process_id in
3027: (select parent_child_id
3028: from amw_proc_hierarchy_denorm
3029: where process_id = p_process_id
3030: and up_down_ind = 'U'
3031: and hierarchy_type = 'L'
3032: ) union all

Line 3049: from amw_proc_hierarchy_denorm

3045: update amw_process
3046: set risk_count_latest = (select count(*) from (
3047: select distinct risk_id from amw_risk_associations
3048: where pk1 in ( (select parent_child_id
3049: from amw_proc_hierarchy_denorm
3050: where process_id = x(ctr)
3051: and up_down_ind = 'D'
3052: and hierarchy_type = 'L') union all (select x(ctr) from dual) )
3053: and deletion_date is null

Line 3139: from amw_proc_hierarchy_denorm

3135: set risk_count_latest = (select count(*) from (
3136: select distinct risk_id
3137: from amw_risk_associations
3138: where pk1 in ((select parent_child_id
3139: from amw_proc_hierarchy_denorm
3140: where process_id = x(ctr)
3141: and up_down_ind = 'D'
3142: and hierarchy_type = 'L') union all (select x(ctr) from dual) )
3143: and deletion_date is null

Line 3161: from amw_proc_hierarchy_denorm

3157: set control_count_latest = (select count(*) from
3158:
3159: (select distinct control_id from amw_control_associations
3160: where pk1 in ((select parent_child_id
3161: from amw_proc_hierarchy_denorm
3162: where process_id = x(ctr)
3163: and up_down_ind = 'D'
3164: and hierarchy_type = 'L') union all (select x(ctr) from dual) )
3165: and deletion_date is null

Line 3182: from amw_proc_hierarchy_denorm

3178: set risk_count_latest = (select count(*) from (
3179: select distinct risk_id
3180: from amw_risk_associations
3181: where pk1 in ((select parent_child_id
3182: from amw_proc_hierarchy_denorm
3183: where process_id = x(ctr)
3184: and up_down_ind = 'D'
3185: and hierarchy_type = 'L') union all (select x(ctr) from dual) )
3186: and deletion_date is null

Line 3194: from amw_proc_hierarchy_denorm

3190: control_count_latest = (select count(*) from
3191:
3192: (select distinct control_id from amw_control_associations
3193: where pk1 in ((select parent_child_id
3194: from amw_proc_hierarchy_denorm
3195: where process_id = x(ctr)
3196: and up_down_ind = 'D'
3197: and hierarchy_type = 'L') union all (select x(ctr) from dual) )
3198: and deletion_date is null