2383: -- PUBLIC
2384: -- Description:
2385: -- Delete Validation.
2386: -- This activity version may not be deleted if child rows in
2387: -- ota_notrng_histories exists where this activity version.
2388: --
2389: Procedure check_if_noth_exists
2390: (
2391: p_activity_version_id in number
2396: v_proc varchar2(72) := g_package||'check_if_noth_exists';
2397: --
2398: cursor sel_noth_exists is
2399: select 'Y'
2400: from ota_notrng_histories nth
2401: where nth.activity_version_id = p_activity_version_id;
2402: --
2403: Begin
2404: --