1450: -- PUBLIC
1451: -- Description:
1452: -- Delete Validation.
1453: -- This activity version may not be deleted if child rows in
1454: -- ota_skill_provisions.
1455: --
1456: Procedure check_if_tsp_exists
1457: (
1458: p_activity_version_id in number
1462: v_proc varchar2(72) := g_package||'check_if_tsp_exists';
1463: --
1464: cursor sel_tsp_exists is
1465: select 'Y'
1466: from ota_skill_provisions tsp
1467: where tsp.activity_version_id = p_activity_version_id;
1468: --
1469: Begin
1470: --