APPS.HZ_RELATIONSHIP_V2PUB dependencies on HZ_RELATIONSHIP_TYPES

Line 352: -- in hz_relationship_types package

348: p_contact_party_usage_code IN VARCHAR2
349: ) IS
350:
351: -- this cursor will uniquely identify a record
352: -- in hz_relationship_types package
353: CURSOR c_rel_type
354: IS
355: SELECT RELATIONSHIP_TYPE,
356: FORWARD_REL_CODE,

Line 365: FROM HZ_RELATIONSHIP_TYPES

361: ALLOW_CIRCULAR_RELATIONSHIPS,
362: DIRECTION_CODE,
363: RELATIONSHIP_TYPE_ID,
364: NVL(MULTIPLE_PARENT_ALLOWED, 'N') MULTIPLE_PARENT_ALLOWED
365: FROM HZ_RELATIONSHIP_TYPES
366: WHERE RELATIONSHIP_TYPE = p_relationship_rec.relationship_type
367: AND FORWARD_REL_CODE = p_relationship_rec.relationship_code
368: AND SUBJECT_TYPE = p_relationship_rec.subject_type
369: AND OBJECT_TYPE = p_relationship_rec.object_type

Line 506: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_relationship_types');

502: IF r_rel_type.relationship_type is null THEN
503: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
504: FND_MESSAGE.SET_TOKEN('FK', 'relationship_code, subject_type, object_type');
505: FND_MESSAGE.SET_TOKEN('COLUMN', 'forward_rel_code, subject_type, object_type');
506: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_relationship_types');
507: FND_MSG_PUB.ADD;
508: RAISE FND_API.G_EXC_ERROR;
509: END IF;
510:

Line 1465: FROM HZ_RELATIONSHIP_TYPES

1461: NVL(MULTIPLE_PARENT_ALLOWED, 'N') MULTIPLE_PARENT_ALLOWED
1462: INTO l_hierarchical_flag,
1463: l_allow_circular_relationships,
1464: l_mult_parent_allowed
1465: FROM HZ_RELATIONSHIP_TYPES
1466: WHERE RELATIONSHIP_TYPE = l_relationship_type
1467: AND ROWNUM = 1;
1468:
1469: -- decide who is parent and who is child in this relationship.