880: l_api_name CONSTANT VARCHAR2(40) := 'check_lgl_ctnt_id_exists';
881:
882: CURSOR lgl_ctnt_cur( p_lgl_ctnt_id IN NUMBER ) IS
883: SELECT 1 from dual where exists (
884: SELECT obj_lgl_ctnt_id FROM JTF_DSP_OBJ_LGL_CTNT
885: WHERE obj_lgl_ctnt_id = p_lgl_ctnt_id);
886:
887: CURSOR lgl_ctnt_version_cur( p_lgl_ctnt_id IN NUMBER,
888: p_object_version_number IN NUMBER ) IS
886:
887: CURSOR lgl_ctnt_version_cur( p_lgl_ctnt_id IN NUMBER,
888: p_object_version_number IN NUMBER ) IS
889: SELECT 1 from dual where exists (
890: select obj_lgl_ctnt_id FROM JTF_DSP_OBJ_LGL_CTNT
891: WHERE obj_lgl_ctnt_id = p_lgl_ctnt_id and
892: object_version_number = p_object_version_number);
893:
894: l_exists NUMBER;