APPS.HZ_DSS_VALIDATE_PKG dependencies on HZ_CLASS_CATEGORIES

Line 188: -- exist_in_hz_class_categories

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

Line 191: FUNCTION exist_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

Line 192: -- Return Y if the class code exists in hz_class_categories

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

Line 200: FROM hz_class_categories

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

Line 214: END exist_in_hz_class_categories ;

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