DBA Data[Home] [Help]

APPS.AMW_WF_HIERARCHY_PKG dependencies on AMW_EXCEPTIONS_TL

Line 3180: delete from amw_exceptions_tl where exception_id = l_ex_id;

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;
3183:
3184: -- delete those process rows from amw_process which have been deleted from wf

Line 3433: delete from amw_exceptions_tl where exception_id = l_ex_id;

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;
3436:
3437: -- delete those process rows from amw_process which have been deleted from wf