eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_DSS_VALIDATE_PKG dependencies on HZ_RELATIONSHIP_TYPES

Line 217: -- exist_in_hz_relationship_types

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

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

Line 221: -- Return Y if the class code exists in hz_relationship_types

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

Line 229: FROM hz_relationship_types

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

Line 243: END exist_in_hz_relationship_types ;

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