PACKAGE BODY: APPS.CS_KB_SEARCH_PVT

Source

1 PACKAGE BODY CS_KB_SEARCH_PVT AS
2 /* $Header: cskbschb.pls 120.0 2005/06/01 15:35:50 appldev noship $ */
3 
4 FUNCTION Get_Set_Usage_Count( p_set_id  IN NUMBER ) RETURN NUMBER
5 IS
6    l_total NUMBER := 0;
7    Cursor Gt_usage_count_csr(p_set_id in NUMBER) IS
8     select nvl(cs_kb_set_used_sums.used_count, 0)
9     from cs_kb_set_used_sums, cs_kb_used_sum_defs_b
10     where cs_kb_set_used_sums.def_id = cs_kb_used_sum_defs_b.def_id
11     and cs_kb_used_sum_defs_b.default_flag = 'Y'
12     and cs_kb_set_used_sums.set_id = p_set_id;
13 BEGIN
14 
15   If p_set_id Is Not Null  Then
16     Open Gt_usage_count_csr(p_set_id);
17     Fetch Gt_usage_count_csr Into l_total;
18     Close Gt_usage_count_csr;
19   End If;
20 
21   Return l_total;
22 EXCEPTION
23   WHEN OTHERS THEN
24    Return 0;
25 END;
26 
27 
28 END CS_KB_SEARCH_PVT;