140:
141: --
142: -- ---------------------------------------------------------------------------------
143: -- FUNCTION: GetChildCount --
144: -- DESCRIPTION: gets a count of the number of child groups in OKC_K_GRPINGS --
145: -- using the recordid passed --
146: -- DEPENDENCIES: none --
147: -- CHANGE HISTORY: --
148: -- --
153: RETURN NUMBER IS
154:
155: CURSOR cg(p_id IN NUMBER) IS
156: select count(*)
157: from okc_k_grpings
158: where cgp_parent_id = p_id;
159: ret NUMBER;
160:
161: BEGIN