[Home] [Help]
53: function validate_pe_name(p_pe_name varchar2,p_org_id number) RETURN number IS
54: l_pe_id number := 0;
55: CURSOR l_pe_id_csr(p_element_name varchar2) IS
56: SELECT quota_id
57: FROM cn_quotas_v
58: WHERE name = p_element_name and org_id = p_org_id;
59: BEGIN
60: OPEN l_pe_id_csr(p_pe_name);
61: FETCH l_pe_id_csr INTO l_pe_id;