APPS.HZ_COPY_REL_PVT dependencies on HZ_RELATIONSHIP_TYPES

Line 264: hz_relationship_types t

260: r.subject_type,
261: r.start_date,
262: r.end_date
263: FROM hz_relationships r,
264: hz_relationship_types t
265: WHERE r.object_id = p_child_id
266: AND r.object_table_name = p_child_table_name
267: AND r.object_type = p_child_type
268: AND r.relationship_type = p_rel_type

Line 501: hz_relationship_types t

497: -- Bug 3651949: take care of copy in the same day as relationships created
498: --
499: select relationship_id
500: FROM hz_relationships r,
501: hz_relationship_types t
502: where r.relationship_type = p_source_rel_type
503: AND r.relationship_type = t.relationship_type
504: AND t.relationship_type = p_source_rel_type
505: AND r.relationship_code = t.forward_rel_code

Line 643: from hz_relationship_types hrt1, hz_relationship_types hrt2

639: hrt1.created_by_module as created_by_module,
640: hrt1.application_id as application_id,
641: hrt1.multiple_parent_allowed as multiple_parent_allowed,
642: hrt1.incl_unrelated_entities as incl_unrelated_entities
643: from hz_relationship_types hrt1, hz_relationship_types hrt2
644: where hrt1.relationship_type = hrt2.relationship_type
645: and hrt1.subject_type = hrt2.object_type
646: and hrt1.object_type = hrt2.subject_type
647: and hrt1.forward_rel_code = hrt2.backward_rel_code

Line 959: -- circular flag etc., as seen in HZ_RELATIONSHIP_TYPES), that are

955: --------------------------------------------------------------------------------------
956: -- copy_rel_type_only ::: This will take a relationship type A and create a relationship
957: -- type B, which is a copy of A in the following sense:
958: -- B will be identical to A in terms of all the properties( phrase pairs,hierarchical type,
959: -- circular flag etc., as seen in HZ_RELATIONSHIP_TYPES), that are
960: -- associated with any relationship type.
961: --
962: -- HOWEVER, THIS PROCEDURE WILL NOT COPY RELATIONSHIPS UNDER A TO B.
963: --------------------------------------------------------------------------------------

Line 1009: from hz_relationship_types hrt1, hz_relationship_types hrt2

1005: hrt1.created_by_module as created_by_module,
1006: hrt1.application_id as application_id,
1007: hrt1.multiple_parent_allowed as multiple_parent_allowed,
1008: hrt1.incl_unrelated_entities as incl_unrelated_entities
1009: from hz_relationship_types hrt1, hz_relationship_types hrt2
1010: where hrt1.relationship_type = hrt2.relationship_type
1011: and hrt1.subject_type = hrt2.object_type
1012: and hrt1.object_type = hrt2.subject_type
1013: and hrt1.forward_rel_code = hrt2.backward_rel_code

Line 1198: -- etc., as seen in HZ_RELATIONSHIP_TYPES), that are

1194: --------------------------------------------------------------------------------------
1195: -- copy_rel_type_and_all_rels ::: This will take a relationship type A and create a relationship
1196: -- type B, which is a copy of A in the following sense:
1197: -- 1. B will be identical to A in terms of all the properties( hierarchical type, circular flag
1198: -- etc., as seen in HZ_RELATIONSHIP_TYPES), that are
1199: -- associated with any relationship type.
1200: -- 2. ALL THE RELATIONSHIPS UNDER A WILL BE CREATED UNDER B.
1201: --------------------------------------------------------------------------------------
1202:

Line 1394: hz_relationship_types

1390: -- GET ALL THE PHRASE PAIRS THAT ARE IN SOURCE BUT NOT IN DESTINATION
1391: cursor c0
1392: is
1393: select * from
1394: hz_relationship_types
1395: where relationship_type = p_source_rel_type
1396: and (direction_code = 'P' or direction_code = 'N')
1397: and (forward_rel_code, backward_rel_code, subject_type, object_type) not in
1398: (select forward_rel_code, backward_rel_code, subject_type, object_type

Line 1399: from hz_relationship_types

1395: where relationship_type = p_source_rel_type
1396: and (direction_code = 'P' or direction_code = 'N')
1397: and (forward_rel_code, backward_rel_code, subject_type, object_type) not in
1398: (select forward_rel_code, backward_rel_code, subject_type, object_type
1399: from hz_relationship_types
1400: where relationship_type = p_dest_rel_type );
1401: BEGIN
1402: -- save and be ready to rollback
1403: savepoint copy_hierarchy ;

Line 1569: hz_relationship_types t

1565: r.end_date,
1566: r.relationship_code,
1567: t.backward_rel_code
1568: FROM hz_relationships r,
1569: hz_relationship_types t
1570: WHERE r.relationship_type = p_rel_type
1571: AND r.relationship_type = t.relationship_type
1572: AND t.relationship_type = p_rel_type
1573: AND r.relationship_code = t.forward_rel_code

Line 1795: UPDATE HZ_RELATIONSHIP_TYPES

1791: Retcode := 2;
1792:
1793: ELSE
1794:
1795: UPDATE HZ_RELATIONSHIP_TYPES
1796: SET HIERARCHICAL_FLAG = 'Y',
1797: MULTIPLE_PARENT_ALLOWED = 'N',
1798: INCL_UNRELATED_ENTITIES = 'N',
1799: ALLOW_CIRCULAR_RELATIONSHIPS = 'N',