DBA Data[Home] [Help]

APPS.AMW_WF_HIERARCHY_PKG dependencies on AMW_EXCEPTIONS_REASONS

Line 3179: delete from amw_exceptions_reasons where exception_id = l_ex_id;

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;
3183:

Line 3432: delete from amw_exceptions_reasons where exception_id = l_ex_id;

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;
3436: