213: RETURN result;
214: END exist_in_hz_class_categories ;
215:
216: --------------------------------------------
217: -- exist_in_hz_relationship_types
218: --------------------------------------------
219:
220: FUNCTION exist_in_hz_relationship_types
221: -- Return Y if the class code exists in hz_relationship_types
216: --------------------------------------------
217: -- exist_in_hz_relationship_types
218: --------------------------------------------
219:
220: FUNCTION exist_in_hz_relationship_types
221: -- Return Y if the class code exists in hz_relationship_types
222: -- N otherwise
223: (p_relationship_type_id NUMBER )
224: RETURN VARCHAR2
217: -- exist_in_hz_relationship_types
218: --------------------------------------------
219:
220: FUNCTION exist_in_hz_relationship_types
221: -- Return Y if the class code exists in hz_relationship_types
222: -- N otherwise
223: (p_relationship_type_id NUMBER )
224: RETURN VARCHAR2
225: IS
225: IS
226: CURSOR c0
227: IS
228: SELECT 'Y'
229: FROM hz_relationship_types
230: WHERE relationship_type_id = p_relationship_type_id ;
231: l_yn VARCHAR2(1);
232: result VARCHAR2(1);
233: BEGIN
239: result := 'Y';
240: END IF;
241: CLOSE c0;
242: RETURN result;
243: END exist_in_hz_relationship_types ;
244:
245:
246: --------------------------------------------
247: -- exist_in_dss_entities