97: END get_app_id;
98:
99: FUNCTION get_tc_id ( p_time_category_name VARCHAR2 ) RETURN NUMBER IS
100:
101: l_tc_id hxc_time_categories.time_category_id%TYPE;
102:
103: CURSOR csr_get_tc_id IS
104: SELECT htc.time_category_id
105: FROM hxc_time_categories htc
101: l_tc_id hxc_time_categories.time_category_id%TYPE;
102:
103: CURSOR csr_get_tc_id IS
104: SELECT htc.time_category_id
105: FROM hxc_time_categories htc
106: WHERE htc.time_category_name = p_time_category_name;
107:
108: BEGIN
109: