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 DUAL

Line 1688: select l_prefix || to_char(AMW_PROCESS_CODE_S.nextval) into l_code from dual;

1684: p_param_name => 'PROCESS_CODE_PREFIX');
1685:
1686:
1687: while (true) loop
1688: select l_prefix || to_char(AMW_PROCESS_CODE_S.nextval) into l_code from dual;
1689:
1690: select 1 into l_dummy from amw_process
1691: where process_code = l_code
1692: and end_date is null;

Line 2571: SELECT AMW_CHILD_ORDER_S.nextval INTO L_CHILD_ORDER FROM DUAL;

2567: --update the latest hierarchy table
2568: ---IF p_child_order_number IS -100, THIS MEANS THAT NO SEQ NUM WAS DEFINED BY USER
2569: --SO GENERATED VIA SEQUENCE
2570: IF(P_CHILD_ORDER_NUMBER = -100) THEN
2571: SELECT AMW_CHILD_ORDER_S.nextval INTO L_CHILD_ORDER FROM DUAL;
2572: ELSE
2573: L_CHILD_ORDER := P_CHILD_ORDER_NUMBER;
2574: END IF;
2575:

Line 2754: (select p_process_id from dual)));

2750: and up_down_ind = 'U'
2751: and hierarchy_type = 'A'
2752: )
2753: union all
2754: (select p_process_id from dual)));
2755: type t_n is table of number;
2756: x t_n;
2757: begin
2758: open c;

Line 2771: and hierarchy_type = 'A') union all (select x(ctr) from dual) )

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
2773: and deletion_approval_date is null
2774: and object_type = 'PROCESS'
2775: ) ),

Line 2819: (select p_process_id from dual)));

2815: and up_down_ind = 'U'
2816: and hierarchy_type = 'A'
2817: )
2818: union all
2819: (select p_process_id from dual)));
2820:
2821: type t_n is table of number;
2822: x t_n;
2823: begin

Line 2837: and hierarchy_type = 'A') union all (select x(ctr) from dual) )

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
2839: and deletion_approval_date is null
2840: and object_type = 'RISK'
2841: ) ),

Line 2890: and hierarchy_type = 'A') union all (select x(ctr) from dual) )

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
2892: and deletion_approval_date is null
2893: and object_type = 'PROCESS'
2894: ) ),

Line 2939: and hierarchy_type = 'A') union all (select x(ctr) from dual) )

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
2941: and deletion_approval_date is null
2942: and object_type = 'RISK'
2943: ) )

Line 2981: (select p_process_id from dual));

2977: where process_id = p_process_id
2978: and up_down_ind = 'U'
2979: and hierarchy_type = 'L'
2980: ) union all
2981: (select p_process_id from dual));
2982: type t_n is table of number;
2983: x t_n;
2984: begin
2985: open c;

Line 2998: and hierarchy_type = 'L') union all (select x(ctr) from dual) )

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
3000: and object_type = 'RISK'
3001: ) )
3002: --unsure whether FWK validation may throw error if ovn is incremented here

Line 3033: (select p_process_id from dual));

3029: where process_id = p_process_id
3030: and up_down_ind = 'U'
3031: and hierarchy_type = 'L'
3032: ) union all
3033: (select p_process_id from dual));
3034: type t_n is table of number;
3035: x t_n;
3036:
3037: begin

Line 3052: and hierarchy_type = 'L') union all (select x(ctr) from dual) )

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
3054: and object_type = 'PROCESS'
3055: ) )
3056: --,object_version_number = object_version_number + 1

Line 3142: and hierarchy_type = 'L') union all (select x(ctr) from dual) )

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
3144: and object_type = 'PROCESS'
3145: )),
3146: object_version_number = object_version_number + 1

Line 3164: and hierarchy_type = 'L') union all (select x(ctr) from dual) )

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
3166: and object_type = 'RISK'
3167: )),
3168: object_version_number = object_version_number + 1

Line 3185: and hierarchy_type = 'L') union all (select x(ctr) from dual) )

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
3187: and object_type = 'PROCESS'
3188: )),
3189:

Line 3197: and hierarchy_type = 'L') union all (select x(ctr) from dual) )

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
3199: and object_type = 'RISK')),
3200: object_version_number = object_version_number + 1
3201: ,last_update_date = sysdate

Line 3377: select amw_process_name_s.nextval into l_name from dual;

3373: l_name number;
3374:
3375: begin
3376:
3377: select amw_process_name_s.nextval into l_name from dual;
3378:
3379: l_pid := create_new_icm_process(
3380: p_name => to_char(l_name),
3381: p_item_type => p_item_type,

Line 3608: from dual

3604: if p_process_id = -1 then
3605: return 1;
3606: else
3607: select 1 into ret_val
3608: from dual
3609: where (exists
3610: (select parent_id from amw_latest_hierarchies
3611: where parent_id = p_process_id
3612: and (organization_id = -1 or organization_id is null)))

Line 3857: select 1 into l_dummy from dual

3853: where process_id = p_process_id;
3854:
3855: if l_flag = 'Y' then
3856: begin
3857: select 1 into l_dummy from dual
3858: where exists
3859: (select 1 from amw_process
3860: where standard_variation = previd
3861: and end_date is null);

Line 4134: select LTRIM(l_child_string, '1234567890') into str from dual;

4130: END IF;
4131:
4132: l_child_string := p_child_id_string;
4133: while LENGTH(l_child_string) <> 0 loop
4134: select LTRIM(l_child_string, '1234567890') into str from dual;
4135: diff := LENGTH(l_child_string) - LENGTH(str);
4136: if LENGTH(str) is null then
4137: diff := LENGTH(l_child_string);
4138: end if;

Line 4139: select SUBSTR(l_child_string, 1, diff) into childstr from dual;

4135: diff := LENGTH(l_child_string) - LENGTH(str);
4136: if LENGTH(str) is null then
4137: diff := LENGTH(l_child_string);
4138: end if;
4139: select SUBSTR(l_child_string, 1, diff) into childstr from dual;
4140: l_child_id := to_number(childstr);
4141: delete from amw_latest_hierarchies where parent_id = p_parent_process_id
4142: and child_id = l_child_id and organization_id = -1;
4143: select LTRIM(str, 'x') into l_child_string from dual;

Line 4143: select LTRIM(str, 'x') into l_child_string from dual;

4139: select SUBSTR(l_child_string, 1, diff) into childstr from dual;
4140: l_child_id := to_number(childstr);
4141: delete from amw_latest_hierarchies where parent_id = p_parent_process_id
4142: and child_id = l_child_id and organization_id = -1;
4143: select LTRIM(str, 'x') into l_child_string from dual;
4144: end loop;
4145: exception
4146: WHEN FND_API.G_EXC_ERROR THEN
4147: ROLLBACK;

Line 4210: select LTRIM(l_child_string, '1234567890') into str from dual;

4206: end if;
4207:
4208: l_child_string := p_child_id_string;
4209: while LENGTH(l_child_string) <> 0 loop
4210: select LTRIM(l_child_string, '1234567890') into str from dual;
4211: diff := LENGTH(l_child_string) - LENGTH(str);
4212: if LENGTH(str) is null then
4213: diff := LENGTH(l_child_string);
4214: end if;

Line 4215: select SUBSTR(l_child_string, 1, diff) into childstr from dual;

4211: diff := LENGTH(l_child_string) - LENGTH(str);
4212: if LENGTH(str) is null then
4213: diff := LENGTH(l_child_string);
4214: end if;
4215: select SUBSTR(l_child_string, 1, diff) into childstr from dual;
4216: l_child_id := to_number(childstr);
4217: /* check if the child is an ancestor of parent already
4218: * so that a circular hierarchy cannot be created
4219: */

Line 4267: select LTRIM(str, 'x') into l_child_string from dual;

4263: update_appr_ch_ord_num_if_reqd(-1, p_parent_process_id, l_child_id,
4264: l_child_order_number);
4265:
4266:
4267: select LTRIM(str, 'x') into l_child_string from dual;
4268: end loop;
4269:
4270: exception
4271: when FND_API.G_EXC_ERROR then