PACKAGE BODY: APPS.CSC_UTILS

Source

1 PACKAGE BODY CSC_UTILS AS
2 /* $Header: cscutilb.pls 120.1 2005/08/24 01:51 tpalaniv noship $ */
3 
4 FUNCTION Isvalid_dashboard_group_id(p_group_id IN csc_prof_groups_b.group_id%TYPE)
5 RETURN BOOLEAN IS
6 
7 l_dbgroup_flag VARCHAR2(1) := 'N';
8 
9 BEGIN
10        SELECT use_in_customer_dashboard
11          INTO l_dbgroup_flag
12 	 FROM csc_prof_groups_b
13         WHERE group_id = p_group_id;
14 
15 	IF l_dbgroup_flag = 'Y' THEN
16 	RETURN TRUE;
17 	ELSE
18 	RETURN FALSE;
19 	END IF;
20 
21 EXCEPTION
22 WHEN OTHERS THEN
23 RETURN FALSE;
24 
25 END Isvalid_dashboard_group_id;
26 
27 
28 END CSC_UTILS;