[Home] [Help]
62: INTO dummy
63: FROM dual
64: WHERE NOT EXISTS
65: (SELECT 1
66: FROM rg_dss_hierarchy_details
67: WHERE hierarchy_id = X_Hierarchy_Id);
68: RETURN(FALSE);
69: EXCEPTION
70: WHEN NO_DATA_FOUND THEN
78: NumRecords := 0;
79:
80: SELECT COUNT(hierarchy_id)
81: INTO NumRecords
82: FROM rg_dss_hierarchy_details
83: WHERE hierarchy_id = X_Hierarchy_Id;
84:
85: RETURN(NumRecords);
86: