2987: -- |-------------------------< Root_Folder_Exists>----------------------------|
2988: -- ----------------------------------------------------------------------------
2989: --
2990: function Root_Folder_Exists
2991: (p_folder_id in number default hr_api.g_number
2992: ,p_business_group_id in number default ota_general.get_business_group_id
2993: )
2994: return varchar2 is
2995: --
5475: -- |--------------------< LO_has_cld_and_no_strt_url>-------------------------|
5476: -- ----------------------------------------------------------------------------
5477: --
5478: FUNCTION Lo_has_cld_and_no_strt_url
5479: (p_learning_object_id in number default hr_api.g_number)
5480: RETURN varchar2 is
5481: --
5482: -- decalare cursor
5483: Cursor csr_par_with_cld_no_url is