APPS.AMW_WF_HIERARCHY_PKG dependencies on AMW_EXCEPTIONS_B

Line 2019: (select distinct old_pk1 from amw_exceptions_b where ((old_pk2 = l_pid and object_type in ('PROCESS','RISK','CONTROL'))or (object_type = 'PROCESS' and old_pk3 = l_pid)) and old_pk1 is not null)

2015: from amw_process_organization
2016: where process_id = l_pid
2017: and end_date is null
2018: and organization_id not in
2019: (select distinct old_pk1 from amw_exceptions_b where ((old_pk2 = l_pid and object_type in ('PROCESS','RISK','CONTROL'))or (object_type = 'PROCESS' and old_pk3 = l_pid)) and old_pk1 is not null)
2020: and organization_id not in
2021: (select distinct new_pk1 from amw_exceptions_b where ((new_pk2 = l_pid and object_type in ('PROCESS','RISK','CONTROL'))or (object_type = 'PROCESS' and new_pk3 = l_pid)) and new_pk1 is not null);
2022:
2023:

Line 2021: (select distinct new_pk1 from amw_exceptions_b where ((new_pk2 = l_pid and object_type in ('PROCESS','RISK','CONTROL'))or (object_type = 'PROCESS' and new_pk3 = l_pid)) and new_pk1 is not null);

2017: and end_date is null
2018: and organization_id not in
2019: (select distinct old_pk1 from amw_exceptions_b where ((old_pk2 = l_pid and object_type in ('PROCESS','RISK','CONTROL'))or (object_type = 'PROCESS' and old_pk3 = l_pid)) and old_pk1 is not null)
2020: and organization_id not in
2021: (select distinct new_pk1 from amw_exceptions_b where ((new_pk2 = l_pid and object_type in ('PROCESS','RISK','CONTROL'))or (object_type = 'PROCESS' and new_pk3 = l_pid)) and new_pk1 is not null);
2022:
2023:
2024: begin
2025: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2938: from amw_exceptions_b

2934: where process_id = p_pid;
2935:
2936: cursor exceptions_to_be_del is
2937: select exception_id
2938: from amw_exceptions_b
2939: where object_type = 'PROCESS_VARIANT_ADD'
2940: and new_pk1 not in
2941: (select process_id from amw_process where standard_process_flag = 'Y');
2942:

Line 3178: delete from amw_exceptions_b where exception_id = l_ex_id;

3174: open exceptions_to_be_del;
3175: loop
3176: fetch exceptions_to_be_del into l_ex_id;
3177: exit when exceptions_to_be_del%notfound;
3178: delete from amw_exceptions_b where exception_id = l_ex_id;
3179: delete from amw_exceptions_reasons where exception_id = l_ex_id;
3180: delete from amw_exceptions_tl where exception_id = l_ex_id;
3181: end loop;
3182: close exceptions_to_be_del;

Line 3279: from amw_exceptions_b

3275: where process_id = p_pid;
3276:
3277: cursor exceptions_to_be_del is
3278: select exception_id
3279: from amw_exceptions_b
3280: where object_type = 'PROCESS_VARIANT_ADD'
3281: and new_pk1 not in
3282: (select process_id from amw_process where standard_process_flag = 'Y');
3283:

Line 3431: delete from amw_exceptions_b where exception_id = l_ex_id;

3427: open exceptions_to_be_del;
3428: loop
3429: fetch exceptions_to_be_del into l_ex_id;
3430: exit when exceptions_to_be_del%notfound;
3431: delete from amw_exceptions_b where exception_id = l_ex_id;
3432: delete from amw_exceptions_reasons where exception_id = l_ex_id;
3433: delete from amw_exceptions_tl where exception_id = l_ex_id;
3434: end loop;
3435: close exceptions_to_be_del;