184: END exist_in_dss_groups_vl ;
185:
186:
187: --------------------------------------------
188: -- exist_in_hz_class_categories
189: --------------------------------------------
190:
191: FUNCTION exist_in_hz_class_categories
192: -- Return Y if the class code exists in hz_class_categories
187: --------------------------------------------
188: -- exist_in_hz_class_categories
189: --------------------------------------------
190:
191: FUNCTION exist_in_hz_class_categories
192: -- Return Y if the class code exists in hz_class_categories
193: -- N otherwise
194: (p_class_category VARCHAR2 )
195: RETURN VARCHAR2
188: -- exist_in_hz_class_categories
189: --------------------------------------------
190:
191: FUNCTION exist_in_hz_class_categories
192: -- Return Y if the class code exists in hz_class_categories
193: -- N otherwise
194: (p_class_category VARCHAR2 )
195: RETURN VARCHAR2
196: IS
196: IS
197: CURSOR c0
198: IS
199: SELECT 'Y'
200: FROM hz_class_categories
201: WHERE class_category = p_class_category ;
202: l_yn VARCHAR2(1);
203: result VARCHAR2(1);
204: BEGIN
210: result := 'Y';
211: END IF;
212: CLOSE c0;
213: RETURN result;
214: END exist_in_hz_class_categories ;
215:
216: --------------------------------------------
217: -- exist_in_hz_relationship_types
218: --------------------------------------------