1296: -- PUBLIC
1297: -- Description:
1298: -- Delete Validation.
1299: -- This activity version may not be deleted if child rows in
1300: -- per_competence_elements exist.
1301: --
1302: Procedure check_if_comp_exists
1303: (
1304: p_activity_version_id in number
1308: v_proc varchar2(72) := g_package||'check_if_comp_exists';
1309: --
1310: cursor sel_comp_exists is
1311: select 'Y'
1312: from per_competence_elements pce
1313: where pce.activity_version_id = p_activity_version_id;
1314: --
1315: Begin
1316: --