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

Line 11825: l_relationship_type HZ_RELATIONSHIP_TYPES.RELATIONSHIP_TYPE%TYPE;

11821:
11822: l_dummy VARCHAR2(1);
11823: l_count NUMBER;
11824: l_code VARCHAR2(30);
11825: l_relationship_type HZ_RELATIONSHIP_TYPES.RELATIONSHIP_TYPE%TYPE;
11826: l_forward_rel_code HZ_RELATIONSHIP_TYPES.FORWARD_REL_CODE%TYPE;
11827: l_backward_rel_code HZ_RELATIONSHIP_TYPES.BACKWARD_REL_CODE%TYPE;
11828: l_direction_code HZ_RELATIONSHIP_TYPES.DIRECTION_CODE%TYPE;
11829: l_create_party_flag HZ_RELATIONSHIP_TYPES.CREATE_PARTY_FLAG%TYPE;

Line 11826: l_forward_rel_code HZ_RELATIONSHIP_TYPES.FORWARD_REL_CODE%TYPE;

11822: l_dummy VARCHAR2(1);
11823: l_count NUMBER;
11824: l_code VARCHAR2(30);
11825: l_relationship_type HZ_RELATIONSHIP_TYPES.RELATIONSHIP_TYPE%TYPE;
11826: l_forward_rel_code HZ_RELATIONSHIP_TYPES.FORWARD_REL_CODE%TYPE;
11827: l_backward_rel_code HZ_RELATIONSHIP_TYPES.BACKWARD_REL_CODE%TYPE;
11828: l_direction_code HZ_RELATIONSHIP_TYPES.DIRECTION_CODE%TYPE;
11829: l_create_party_flag HZ_RELATIONSHIP_TYPES.CREATE_PARTY_FLAG%TYPE;
11830: l_allow_relate_to_self_flag HZ_RELATIONSHIP_TYPES.ALLOW_RELATE_TO_SELF_FLAG%TYPE;

Line 11827: l_backward_rel_code HZ_RELATIONSHIP_TYPES.BACKWARD_REL_CODE%TYPE;

11823: l_count NUMBER;
11824: l_code VARCHAR2(30);
11825: l_relationship_type HZ_RELATIONSHIP_TYPES.RELATIONSHIP_TYPE%TYPE;
11826: l_forward_rel_code HZ_RELATIONSHIP_TYPES.FORWARD_REL_CODE%TYPE;
11827: l_backward_rel_code HZ_RELATIONSHIP_TYPES.BACKWARD_REL_CODE%TYPE;
11828: l_direction_code HZ_RELATIONSHIP_TYPES.DIRECTION_CODE%TYPE;
11829: l_create_party_flag HZ_RELATIONSHIP_TYPES.CREATE_PARTY_FLAG%TYPE;
11830: l_allow_relate_to_self_flag HZ_RELATIONSHIP_TYPES.ALLOW_RELATE_TO_SELF_FLAG%TYPE;
11831: l_allow_circular_relationships HZ_RELATIONSHIP_TYPES.ALLOW_CIRCULAR_RELATIONSHIPS%TYPE;

Line 11828: l_direction_code HZ_RELATIONSHIP_TYPES.DIRECTION_CODE%TYPE;

11824: l_code VARCHAR2(30);
11825: l_relationship_type HZ_RELATIONSHIP_TYPES.RELATIONSHIP_TYPE%TYPE;
11826: l_forward_rel_code HZ_RELATIONSHIP_TYPES.FORWARD_REL_CODE%TYPE;
11827: l_backward_rel_code HZ_RELATIONSHIP_TYPES.BACKWARD_REL_CODE%TYPE;
11828: l_direction_code HZ_RELATIONSHIP_TYPES.DIRECTION_CODE%TYPE;
11829: l_create_party_flag HZ_RELATIONSHIP_TYPES.CREATE_PARTY_FLAG%TYPE;
11830: l_allow_relate_to_self_flag HZ_RELATIONSHIP_TYPES.ALLOW_RELATE_TO_SELF_FLAG%TYPE;
11831: l_allow_circular_relationships HZ_RELATIONSHIP_TYPES.ALLOW_CIRCULAR_RELATIONSHIPS%TYPE;
11832: l_hierarchical_flag HZ_RELATIONSHIP_TYPES.HIERARCHICAL_FLAG%TYPE;

Line 11829: l_create_party_flag HZ_RELATIONSHIP_TYPES.CREATE_PARTY_FLAG%TYPE;

11825: l_relationship_type HZ_RELATIONSHIP_TYPES.RELATIONSHIP_TYPE%TYPE;
11826: l_forward_rel_code HZ_RELATIONSHIP_TYPES.FORWARD_REL_CODE%TYPE;
11827: l_backward_rel_code HZ_RELATIONSHIP_TYPES.BACKWARD_REL_CODE%TYPE;
11828: l_direction_code HZ_RELATIONSHIP_TYPES.DIRECTION_CODE%TYPE;
11829: l_create_party_flag HZ_RELATIONSHIP_TYPES.CREATE_PARTY_FLAG%TYPE;
11830: l_allow_relate_to_self_flag HZ_RELATIONSHIP_TYPES.ALLOW_RELATE_TO_SELF_FLAG%TYPE;
11831: l_allow_circular_relationships HZ_RELATIONSHIP_TYPES.ALLOW_CIRCULAR_RELATIONSHIPS%TYPE;
11832: l_hierarchical_flag HZ_RELATIONSHIP_TYPES.HIERARCHICAL_FLAG%TYPE;
11833: l_multiple_parent_allowed HZ_RELATIONSHIP_TYPES.MULTIPLE_PARENT_ALLOWED%TYPE;

Line 11830: l_allow_relate_to_self_flag HZ_RELATIONSHIP_TYPES.ALLOW_RELATE_TO_SELF_FLAG%TYPE;

11826: l_forward_rel_code HZ_RELATIONSHIP_TYPES.FORWARD_REL_CODE%TYPE;
11827: l_backward_rel_code HZ_RELATIONSHIP_TYPES.BACKWARD_REL_CODE%TYPE;
11828: l_direction_code HZ_RELATIONSHIP_TYPES.DIRECTION_CODE%TYPE;
11829: l_create_party_flag HZ_RELATIONSHIP_TYPES.CREATE_PARTY_FLAG%TYPE;
11830: l_allow_relate_to_self_flag HZ_RELATIONSHIP_TYPES.ALLOW_RELATE_TO_SELF_FLAG%TYPE;
11831: l_allow_circular_relationships HZ_RELATIONSHIP_TYPES.ALLOW_CIRCULAR_RELATIONSHIPS%TYPE;
11832: l_hierarchical_flag HZ_RELATIONSHIP_TYPES.HIERARCHICAL_FLAG%TYPE;
11833: l_multiple_parent_allowed HZ_RELATIONSHIP_TYPES.MULTIPLE_PARENT_ALLOWED%TYPE;
11834: l_incl_unrelated_entities HZ_RELATIONSHIP_TYPES.INCL_UNRELATED_ENTITIES%TYPE;

Line 11831: l_allow_circular_relationships HZ_RELATIONSHIP_TYPES.ALLOW_CIRCULAR_RELATIONSHIPS%TYPE;

11827: l_backward_rel_code HZ_RELATIONSHIP_TYPES.BACKWARD_REL_CODE%TYPE;
11828: l_direction_code HZ_RELATIONSHIP_TYPES.DIRECTION_CODE%TYPE;
11829: l_create_party_flag HZ_RELATIONSHIP_TYPES.CREATE_PARTY_FLAG%TYPE;
11830: l_allow_relate_to_self_flag HZ_RELATIONSHIP_TYPES.ALLOW_RELATE_TO_SELF_FLAG%TYPE;
11831: l_allow_circular_relationships HZ_RELATIONSHIP_TYPES.ALLOW_CIRCULAR_RELATIONSHIPS%TYPE;
11832: l_hierarchical_flag HZ_RELATIONSHIP_TYPES.HIERARCHICAL_FLAG%TYPE;
11833: l_multiple_parent_allowed HZ_RELATIONSHIP_TYPES.MULTIPLE_PARENT_ALLOWED%TYPE;
11834: l_incl_unrelated_entities HZ_RELATIONSHIP_TYPES.INCL_UNRELATED_ENTITIES%TYPE;
11835: l_subject_type HZ_RELATIONSHIP_TYPES.SUBJECT_TYPE%TYPE;

Line 11832: l_hierarchical_flag HZ_RELATIONSHIP_TYPES.HIERARCHICAL_FLAG%TYPE;

11828: l_direction_code HZ_RELATIONSHIP_TYPES.DIRECTION_CODE%TYPE;
11829: l_create_party_flag HZ_RELATIONSHIP_TYPES.CREATE_PARTY_FLAG%TYPE;
11830: l_allow_relate_to_self_flag HZ_RELATIONSHIP_TYPES.ALLOW_RELATE_TO_SELF_FLAG%TYPE;
11831: l_allow_circular_relationships HZ_RELATIONSHIP_TYPES.ALLOW_CIRCULAR_RELATIONSHIPS%TYPE;
11832: l_hierarchical_flag HZ_RELATIONSHIP_TYPES.HIERARCHICAL_FLAG%TYPE;
11833: l_multiple_parent_allowed HZ_RELATIONSHIP_TYPES.MULTIPLE_PARENT_ALLOWED%TYPE;
11834: l_incl_unrelated_entities HZ_RELATIONSHIP_TYPES.INCL_UNRELATED_ENTITIES%TYPE;
11835: l_subject_type HZ_RELATIONSHIP_TYPES.SUBJECT_TYPE%TYPE;
11836: l_object_type HZ_RELATIONSHIP_TYPES.OBJECT_TYPE%TYPE;

Line 11833: l_multiple_parent_allowed HZ_RELATIONSHIP_TYPES.MULTIPLE_PARENT_ALLOWED%TYPE;

11829: l_create_party_flag HZ_RELATIONSHIP_TYPES.CREATE_PARTY_FLAG%TYPE;
11830: l_allow_relate_to_self_flag HZ_RELATIONSHIP_TYPES.ALLOW_RELATE_TO_SELF_FLAG%TYPE;
11831: l_allow_circular_relationships HZ_RELATIONSHIP_TYPES.ALLOW_CIRCULAR_RELATIONSHIPS%TYPE;
11832: l_hierarchical_flag HZ_RELATIONSHIP_TYPES.HIERARCHICAL_FLAG%TYPE;
11833: l_multiple_parent_allowed HZ_RELATIONSHIP_TYPES.MULTIPLE_PARENT_ALLOWED%TYPE;
11834: l_incl_unrelated_entities HZ_RELATIONSHIP_TYPES.INCL_UNRELATED_ENTITIES%TYPE;
11835: l_subject_type HZ_RELATIONSHIP_TYPES.SUBJECT_TYPE%TYPE;
11836: l_object_type HZ_RELATIONSHIP_TYPES.OBJECT_TYPE%TYPE;
11837: l_created_by_module VARCHAR2(150);

Line 11834: l_incl_unrelated_entities HZ_RELATIONSHIP_TYPES.INCL_UNRELATED_ENTITIES%TYPE;

11830: l_allow_relate_to_self_flag HZ_RELATIONSHIP_TYPES.ALLOW_RELATE_TO_SELF_FLAG%TYPE;
11831: l_allow_circular_relationships HZ_RELATIONSHIP_TYPES.ALLOW_CIRCULAR_RELATIONSHIPS%TYPE;
11832: l_hierarchical_flag HZ_RELATIONSHIP_TYPES.HIERARCHICAL_FLAG%TYPE;
11833: l_multiple_parent_allowed HZ_RELATIONSHIP_TYPES.MULTIPLE_PARENT_ALLOWED%TYPE;
11834: l_incl_unrelated_entities HZ_RELATIONSHIP_TYPES.INCL_UNRELATED_ENTITIES%TYPE;
11835: l_subject_type HZ_RELATIONSHIP_TYPES.SUBJECT_TYPE%TYPE;
11836: l_object_type HZ_RELATIONSHIP_TYPES.OBJECT_TYPE%TYPE;
11837: l_created_by_module VARCHAR2(150);
11838: l_application_id NUMBER;

Line 11835: l_subject_type HZ_RELATIONSHIP_TYPES.SUBJECT_TYPE%TYPE;

11831: l_allow_circular_relationships HZ_RELATIONSHIP_TYPES.ALLOW_CIRCULAR_RELATIONSHIPS%TYPE;
11832: l_hierarchical_flag HZ_RELATIONSHIP_TYPES.HIERARCHICAL_FLAG%TYPE;
11833: l_multiple_parent_allowed HZ_RELATIONSHIP_TYPES.MULTIPLE_PARENT_ALLOWED%TYPE;
11834: l_incl_unrelated_entities HZ_RELATIONSHIP_TYPES.INCL_UNRELATED_ENTITIES%TYPE;
11835: l_subject_type HZ_RELATIONSHIP_TYPES.SUBJECT_TYPE%TYPE;
11836: l_object_type HZ_RELATIONSHIP_TYPES.OBJECT_TYPE%TYPE;
11837: l_created_by_module VARCHAR2(150);
11838: l_application_id NUMBER;
11839: l_status VARCHAR2(1);

Line 11836: l_object_type HZ_RELATIONSHIP_TYPES.OBJECT_TYPE%TYPE;

11832: l_hierarchical_flag HZ_RELATIONSHIP_TYPES.HIERARCHICAL_FLAG%TYPE;
11833: l_multiple_parent_allowed HZ_RELATIONSHIP_TYPES.MULTIPLE_PARENT_ALLOWED%TYPE;
11834: l_incl_unrelated_entities HZ_RELATIONSHIP_TYPES.INCL_UNRELATED_ENTITIES%TYPE;
11835: l_subject_type HZ_RELATIONSHIP_TYPES.SUBJECT_TYPE%TYPE;
11836: l_object_type HZ_RELATIONSHIP_TYPES.OBJECT_TYPE%TYPE;
11837: l_created_by_module VARCHAR2(150);
11838: l_application_id NUMBER;
11839: l_status VARCHAR2(1);
11840: l_debug_prefix VARCHAR2(30) := '';

Line 11889: FROM HZ_RELATIONSHIP_TYPES

11885: l_object_type,
11886: l_role,
11887: l_created_by_module,
11888: l_application_id
11889: FROM HZ_RELATIONSHIP_TYPES
11890: WHERE ROWID = p_rowid;
11891: END IF;
11892:
11893:

Line 11906: FROM HZ_RELATIONSHIP_TYPES

11902: );
11903: --------Bug no: 3564107 ---------------------------------
11904: BEGIN
11905: SELECT ROLE INTO l_role
11906: FROM HZ_RELATIONSHIP_TYPES
11907: WHERE RELATIONSHIP_TYPE = l_relationship_type
11908: AND FORWARD_REL_CODE = l_backward_rel_code
11909: AND BACKWARD_REL_CODE = l_forward_rel_code
11910: AND SUBJECT_TYPE = l_object_type

Line 12630: | FROM HZ_RELATIONSHIP_TYPES

12626: -- Bug 2751613.This validation should work for all the different combinations.
12627: /* Bug 2751613.
12628: | SELECT COUNT(*)
12629: | INTO l_count
12630: | FROM HZ_RELATIONSHIP_TYPES
12631: | WHERE RELATIONSHIP_TYPE = p_relationship_type_rec.relationship_type
12632: | AND FORWARD_REL_CODE = p_relationship_type_rec.forward_rel_code
12633: | AND SUBJECT_TYPE = p_relationship_type_rec.subject_type
12634: | AND OBJECT_TYPE = p_relationship_type_rec.object_type;

Line 12640: | FROM HZ_RELATIONSHIP_TYPES

12636: | IF l_count > 0 THEN
12637: | --since there is one or more such records, we need to get the backward_rel_code
12638: | SELECT BACKWARD_REL_CODE
12639: | INTO l_code
12640: | FROM HZ_RELATIONSHIP_TYPES
12641: | WHERE RELATIONSHIP_TYPE = p_relationship_type_rec.relationship_type
12642: | AND FORWARD_REL_CODE = p_relationship_type_rec.forward_rel_code
12643: | AND SUBJECT_TYPE = p_relationship_type_rec.subject_type
12644: | AND OBJECT_TYPE = p_relationship_type_rec.object_type

Line 12659: FROM HZ_RELATIONSHIP_TYPES

12655:
12656: -- Bug 2751613.
12657: SELECT COUNT(*)
12658: INTO l_count
12659: FROM HZ_RELATIONSHIP_TYPES
12660: WHERE
12661: (
12662: RELATIONSHIP_TYPE = p_relationship_type_rec.relationship_type
12663: )

Line 12728: FROM HZ_RELATIONSHIP_TYPES

12724: -- check for duplicate record
12725: BEGIN
12726: SELECT 1
12727: INTO l_count
12728: FROM HZ_RELATIONSHIP_TYPES
12729: WHERE RELATIONSHIP_TYPE = p_relationship_type_rec.relationship_type
12730: AND FORWARD_REL_CODE = p_relationship_type_rec.forward_rel_code
12731: AND BACKWARD_REL_CODE = p_relationship_type_rec.backward_rel_code
12732: AND SUBJECT_TYPE = p_relationship_type_rec.subject_type

Line 12914: FROM HZ_RELATIONSHIP_TYPES

12910: IF p_create_update_flag = 'C' THEN
12911: BEGIN
12912: SELECT count(*)
12913: INTO l_count
12914: FROM HZ_RELATIONSHIP_TYPES
12915: WHERE ROLE = p_relationship_type_rec.forward_role
12916: OR ROLE = p_relationship_type_rec.backward_role;
12917: IF l_count > 0 THEN
12918: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');

Line 13074: FROM HZ_RELATIONSHIP_TYPES

13070: IF p_create_update_flag = 'C' THEN
13071: BEGIN
13072: SELECT HIERARCHICAL_FLAG
13073: INTO l_hierarchical_flag
13074: FROM HZ_RELATIONSHIP_TYPES
13075: WHERE RELATIONSHIP_TYPE = p_relationship_type_rec.relationship_type
13076: AND ROWNUM = 1;
13077:
13078: IF NVL(p_relationship_type_rec.hierarchical_flag, 'N')

Line 13121: FROM HZ_RELATIONSHIP_TYPES

13117: IF p_create_update_flag = 'C' THEN
13118: BEGIN
13119: SELECT ALLOW_CIRCULAR_RELATIONSHIPS
13120: INTO l_allow_circular_relationships
13121: FROM HZ_RELATIONSHIP_TYPES
13122: WHERE RELATIONSHIP_TYPE = p_relationship_type_rec.relationship_type
13123: AND ROWNUM = 1;
13124:
13125: IF NVL(p_relationship_type_rec.allow_circular_relationships, 'N') <> NVL(l_allow_circular_relationships, 'N')

Line 13163: FROM HZ_RELATIONSHIP_TYPES

13159: IF p_create_update_flag = 'C' THEN
13160: BEGIN
13161: SELECT MULTIPLE_PARENT_ALLOWED
13162: INTO l_multiple_parent_allowed
13163: FROM HZ_RELATIONSHIP_TYPES
13164: WHERE RELATIONSHIP_TYPE = p_relationship_type_rec.relationship_type
13165: AND ROWNUM = 1;
13166:
13167: IF NVL(p_relationship_type_rec.multiple_parent_allowed, 'N') <>