APPS.MSC_X_EX5_PKG dependencies on MSC_X_EXCEPTION_DETAILS

Line 1718: update msc_x_exception_details

1714:
1715: --dbms_output.put_line('Update the magic number');
1716: --Reset the records for which the workflows have been
1717: --kicked off, to prevent the create duplicate wf items
1718: update msc_x_exception_details
1719: set last_update_login = null
1720: where plan_id = MSC_X_NETTING_PKG.G_PLAN_ID
1721: and exception_type in (9, 10, 29, 30)
1722: and nvl(last_update_login,-1) = MSC_X_NETTING_PKG.G_MAGIC_NUMBER;