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:
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;