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_RELATIONSHIP_TYPE_V2PUB dependencies on HZ_RELATIONSHIP_TYPES

Line 100: l_relationship_type HZ_RELATIONSHIP_TYPES.RELATIONSHIP_TYPE%TYPE;

96: x_return_status IN OUT NOCOPY VARCHAR2
97: ) IS
98:
99: l_relationship_type_rec RELATIONSHIP_TYPE_REC_TYPE := p_relationship_type_rec;
100: l_relationship_type HZ_RELATIONSHIP_TYPES.RELATIONSHIP_TYPE%TYPE;
101: l_direction_code HZ_RELATIONSHIP_TYPES.DIRECTION_CODE%TYPE;
102: l_relationship_type_id NUMBER := p_relationship_type_rec.relationship_type_id;
103: l_forward_role VARCHAR2(30):=p_relationship_type_rec.forward_role;
104: l_backward_role VARCHAR2(30):=p_relationship_type_rec.backward_role;

Line 101: l_direction_code HZ_RELATIONSHIP_TYPES.DIRECTION_CODE%TYPE;

97: ) IS
98:
99: l_relationship_type_rec RELATIONSHIP_TYPE_REC_TYPE := p_relationship_type_rec;
100: l_relationship_type HZ_RELATIONSHIP_TYPES.RELATIONSHIP_TYPE%TYPE;
101: l_direction_code HZ_RELATIONSHIP_TYPES.DIRECTION_CODE%TYPE;
102: l_relationship_type_id NUMBER := p_relationship_type_rec.relationship_type_id;
103: l_forward_role VARCHAR2(30):=p_relationship_type_rec.forward_role;
104: l_backward_role VARCHAR2(30):=p_relationship_type_rec.backward_role;
105: l_forward_rel_code VARCHAR2(30):=p_relationship_type_rec.forward_rel_code;

Line 133: FROM HZ_RELATIONSHIP_TYPES

129: THEN
130: BEGIN
131: SELECT 'Y'
132: INTO l_dummy
133: FROM HZ_RELATIONSHIP_TYPES
134: WHERE RELATIONSHIP_TYPE_ID = l_relationship_type_id;
135:
136: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
137: FND_MESSAGE.SET_TOKEN('COLUMN', 'relationship_type_id');

Line 200: HZ_RELATIONSHIP_TYPES_PKG.Insert_Row (

196: END IF;
197:
198:
199: -- make call to table handler to create forward record
200: HZ_RELATIONSHIP_TYPES_PKG.Insert_Row (
201: X_RELATIONSHIP_TYPE_ID => l_relationship_type_id,
202: X_RELATIONSHIP_TYPE => l_relationship_type,
203: X_FORWARD_REL_CODE => p_relationship_type_rec.forward_rel_code,
204: X_BACKWARD_REL_CODE => p_relationship_type_rec.backward_rel_code,

Line 231: FROM HZ_RELATIONSHIP_TYPES

227: -- compatibility purposes, we cannot make those mandatory.
228: BEGIN
229: -- get the role value since it might have been created by table handler
230: SELECT ROLE INTO l_role
231: FROM HZ_RELATIONSHIP_TYPES
232: WHERE RELATIONSHIP_TYPE_ID = x_relationship_type_id;
233:
234: -- check if the lookup value is already present for the role
235: -- Bug 3831950 : Use functino validate_fnd_lookup to check available lookup code

Line 295: HZ_RELATIONSHIP_TYPES_PKG.Insert_Row (

291: l_direction_code := 'P';
292: END IF;
293:
294: -- make call to table handler to create backward record
295: HZ_RELATIONSHIP_TYPES_PKG.Insert_Row (
296: X_RELATIONSHIP_TYPE_ID => l_relationship_type_id,
297: X_RELATIONSHIP_TYPE => l_relationship_type,
298: X_FORWARD_REL_CODE => p_relationship_type_rec.backward_rel_code,
299: X_BACKWARD_REL_CODE => p_relationship_type_rec.forward_rel_code,

Line 323: FROM HZ_RELATIONSHIP_TYPES

319: -- compatibility purposes, we cannot make those mandatory.
320: BEGIN
321: -- get the role value since it might have been created by table handler
322: SELECT ROLE INTO l_role
323: FROM HZ_RELATIONSHIP_TYPES
324: WHERE RELATIONSHIP_TYPE_ID = l_relationship_type_id;
325:
326: -- check if the lookup value is already present for the role
327: -- Bug 3831950 : Use functino validate_fnd_lookup to check available lookup code

Line 483: l_relationship_type HZ_RELATIONSHIP_TYPES.RELATIONSHIP_TYPE%TYPE;

479: ) IS
480:
481: l_object_version_number NUMBER;
482: l_rowid ROWID;
483: l_relationship_type HZ_RELATIONSHIP_TYPES.RELATIONSHIP_TYPE%TYPE;
484: l_direction_code HZ_RELATIONSHIP_TYPES.DIRECTION_CODE%TYPE;
485: l_forward_rel_code HZ_RELATIONSHIP_TYPES.FORWARD_REL_CODE%TYPE;
486: l_backward_rel_code HZ_RELATIONSHIP_TYPES.BACKWARD_REL_CODE%TYPE;
487: l_subject_type HZ_RELATIONSHIP_TYPES.SUBJECT_TYPE%TYPE;

Line 484: l_direction_code HZ_RELATIONSHIP_TYPES.DIRECTION_CODE%TYPE;

480:
481: l_object_version_number NUMBER;
482: l_rowid ROWID;
483: l_relationship_type HZ_RELATIONSHIP_TYPES.RELATIONSHIP_TYPE%TYPE;
484: l_direction_code HZ_RELATIONSHIP_TYPES.DIRECTION_CODE%TYPE;
485: l_forward_rel_code HZ_RELATIONSHIP_TYPES.FORWARD_REL_CODE%TYPE;
486: l_backward_rel_code HZ_RELATIONSHIP_TYPES.BACKWARD_REL_CODE%TYPE;
487: l_subject_type HZ_RELATIONSHIP_TYPES.SUBJECT_TYPE%TYPE;
488: l_object_type HZ_RELATIONSHIP_TYPES.OBJECT_TYPE%TYPE;

Line 485: l_forward_rel_code HZ_RELATIONSHIP_TYPES.FORWARD_REL_CODE%TYPE;

481: l_object_version_number NUMBER;
482: l_rowid ROWID;
483: l_relationship_type HZ_RELATIONSHIP_TYPES.RELATIONSHIP_TYPE%TYPE;
484: l_direction_code HZ_RELATIONSHIP_TYPES.DIRECTION_CODE%TYPE;
485: l_forward_rel_code HZ_RELATIONSHIP_TYPES.FORWARD_REL_CODE%TYPE;
486: l_backward_rel_code HZ_RELATIONSHIP_TYPES.BACKWARD_REL_CODE%TYPE;
487: l_subject_type HZ_RELATIONSHIP_TYPES.SUBJECT_TYPE%TYPE;
488: l_object_type HZ_RELATIONSHIP_TYPES.OBJECT_TYPE%TYPE;
489: l_relationship_type_id NUMBER := p_relationship_type_rec.relationship_type_id;

Line 486: l_backward_rel_code HZ_RELATIONSHIP_TYPES.BACKWARD_REL_CODE%TYPE;

482: l_rowid ROWID;
483: l_relationship_type HZ_RELATIONSHIP_TYPES.RELATIONSHIP_TYPE%TYPE;
484: l_direction_code HZ_RELATIONSHIP_TYPES.DIRECTION_CODE%TYPE;
485: l_forward_rel_code HZ_RELATIONSHIP_TYPES.FORWARD_REL_CODE%TYPE;
486: l_backward_rel_code HZ_RELATIONSHIP_TYPES.BACKWARD_REL_CODE%TYPE;
487: l_subject_type HZ_RELATIONSHIP_TYPES.SUBJECT_TYPE%TYPE;
488: l_object_type HZ_RELATIONSHIP_TYPES.OBJECT_TYPE%TYPE;
489: l_relationship_type_id NUMBER := p_relationship_type_rec.relationship_type_id;
490: l_relationship_type_id2 NUMBER;

Line 487: l_subject_type HZ_RELATIONSHIP_TYPES.SUBJECT_TYPE%TYPE;

483: l_relationship_type HZ_RELATIONSHIP_TYPES.RELATIONSHIP_TYPE%TYPE;
484: l_direction_code HZ_RELATIONSHIP_TYPES.DIRECTION_CODE%TYPE;
485: l_forward_rel_code HZ_RELATIONSHIP_TYPES.FORWARD_REL_CODE%TYPE;
486: l_backward_rel_code HZ_RELATIONSHIP_TYPES.BACKWARD_REL_CODE%TYPE;
487: l_subject_type HZ_RELATIONSHIP_TYPES.SUBJECT_TYPE%TYPE;
488: l_object_type HZ_RELATIONSHIP_TYPES.OBJECT_TYPE%TYPE;
489: l_relationship_type_id NUMBER := p_relationship_type_rec.relationship_type_id;
490: l_relationship_type_id2 NUMBER;
491: l_hierarchical_flag VARCHAR2(1) := 'N';

Line 488: l_object_type HZ_RELATIONSHIP_TYPES.OBJECT_TYPE%TYPE;

484: l_direction_code HZ_RELATIONSHIP_TYPES.DIRECTION_CODE%TYPE;
485: l_forward_rel_code HZ_RELATIONSHIP_TYPES.FORWARD_REL_CODE%TYPE;
486: l_backward_rel_code HZ_RELATIONSHIP_TYPES.BACKWARD_REL_CODE%TYPE;
487: l_subject_type HZ_RELATIONSHIP_TYPES.SUBJECT_TYPE%TYPE;
488: l_object_type HZ_RELATIONSHIP_TYPES.OBJECT_TYPE%TYPE;
489: l_relationship_type_id NUMBER := p_relationship_type_rec.relationship_type_id;
490: l_relationship_type_id2 NUMBER;
491: l_hierarchical_flag VARCHAR2(1) := 'N';
492: l_create_party_flag VARCHAR2(1) := p_relationship_type_rec.create_party_flag;

Line 517: FROM HZ_RELATIONSHIP_TYPES

513: l_forward_rel_code,
514: l_backward_rel_code,
515: l_subject_type,
516: l_object_type
517: FROM HZ_RELATIONSHIP_TYPES
518: WHERE RELATIONSHIP_TYPE_ID = p_relationship_type_rec.relationship_type_id
519: FOR UPDATE OF RELATIONSHIP_TYPE_ID NOWAIT;
520:
521: IF NOT

Line 569: HZ_RELATIONSHIP_TYPES_PKG.Update_Row (

565: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
566: RAISE FND_API.G_EXC_ERROR;
567: END IF;
568:
569: HZ_RELATIONSHIP_TYPES_PKG.Update_Row (
570: X_Rowid => l_rowid,
571: X_RELATIONSHIP_TYPE_ID => NULL,
572: X_RELATIONSHIP_TYPE => NULL,
573: X_FORWARD_REL_CODE => NULL,

Line 600: FROM HZ_RELATIONSHIP_TYPES

596: -- however, the logic is same.
597: BEGIN
598: SELECT ROWID
599: INTO l_rowid
600: FROM HZ_RELATIONSHIP_TYPES
601: WHERE RELATIONSHIP_TYPE = l_relationship_type
602: AND FORWARD_REL_CODE = l_backward_rel_code
603: AND BACKWARD_REL_CODE = l_forward_rel_code
604: AND SUBJECT_TYPE = l_object_type

Line 608: HZ_RELATIONSHIP_TYPES_PKG.Update_Row (

604: AND SUBJECT_TYPE = l_object_type
605: AND OBJECT_TYPE = l_subject_type;
606:
607: --now update the backward record
608: HZ_RELATIONSHIP_TYPES_PKG.Update_Row (
609: X_Rowid => l_rowid,
610: X_RELATIONSHIP_TYPE_ID => NULL,
611: X_RELATIONSHIP_TYPE => NULL,
612: X_FORWARD_REL_CODE => NULL,