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 11835: l_relationship_type HZ_RELATIONSHIP_TYPES.RELATIONSHIP_TYPE%TYPE;

11831:
11832: l_dummy VARCHAR2(1);
11833: l_count NUMBER;
11834: l_code VARCHAR2(30);
11835: l_relationship_type HZ_RELATIONSHIP_TYPES.RELATIONSHIP_TYPE%TYPE;
11836: l_forward_rel_code HZ_RELATIONSHIP_TYPES.FORWARD_REL_CODE%TYPE;
11837: l_backward_rel_code HZ_RELATIONSHIP_TYPES.BACKWARD_REL_CODE%TYPE;
11838: l_direction_code HZ_RELATIONSHIP_TYPES.DIRECTION_CODE%TYPE;
11839: l_create_party_flag HZ_RELATIONSHIP_TYPES.CREATE_PARTY_FLAG%TYPE;

Line 11836: l_forward_rel_code HZ_RELATIONSHIP_TYPES.FORWARD_REL_CODE%TYPE;

11832: l_dummy VARCHAR2(1);
11833: l_count NUMBER;
11834: l_code VARCHAR2(30);
11835: l_relationship_type HZ_RELATIONSHIP_TYPES.RELATIONSHIP_TYPE%TYPE;
11836: l_forward_rel_code HZ_RELATIONSHIP_TYPES.FORWARD_REL_CODE%TYPE;
11837: l_backward_rel_code HZ_RELATIONSHIP_TYPES.BACKWARD_REL_CODE%TYPE;
11838: l_direction_code HZ_RELATIONSHIP_TYPES.DIRECTION_CODE%TYPE;
11839: l_create_party_flag HZ_RELATIONSHIP_TYPES.CREATE_PARTY_FLAG%TYPE;
11840: l_allow_relate_to_self_flag HZ_RELATIONSHIP_TYPES.ALLOW_RELATE_TO_SELF_FLAG%TYPE;

Line 11837: l_backward_rel_code HZ_RELATIONSHIP_TYPES.BACKWARD_REL_CODE%TYPE;

11833: l_count NUMBER;
11834: l_code VARCHAR2(30);
11835: l_relationship_type HZ_RELATIONSHIP_TYPES.RELATIONSHIP_TYPE%TYPE;
11836: l_forward_rel_code HZ_RELATIONSHIP_TYPES.FORWARD_REL_CODE%TYPE;
11837: l_backward_rel_code HZ_RELATIONSHIP_TYPES.BACKWARD_REL_CODE%TYPE;
11838: l_direction_code HZ_RELATIONSHIP_TYPES.DIRECTION_CODE%TYPE;
11839: l_create_party_flag HZ_RELATIONSHIP_TYPES.CREATE_PARTY_FLAG%TYPE;
11840: l_allow_relate_to_self_flag HZ_RELATIONSHIP_TYPES.ALLOW_RELATE_TO_SELF_FLAG%TYPE;
11841: l_allow_circular_relationships HZ_RELATIONSHIP_TYPES.ALLOW_CIRCULAR_RELATIONSHIPS%TYPE;

Line 11838: l_direction_code HZ_RELATIONSHIP_TYPES.DIRECTION_CODE%TYPE;

11834: l_code VARCHAR2(30);
11835: l_relationship_type HZ_RELATIONSHIP_TYPES.RELATIONSHIP_TYPE%TYPE;
11836: l_forward_rel_code HZ_RELATIONSHIP_TYPES.FORWARD_REL_CODE%TYPE;
11837: l_backward_rel_code HZ_RELATIONSHIP_TYPES.BACKWARD_REL_CODE%TYPE;
11838: l_direction_code HZ_RELATIONSHIP_TYPES.DIRECTION_CODE%TYPE;
11839: l_create_party_flag HZ_RELATIONSHIP_TYPES.CREATE_PARTY_FLAG%TYPE;
11840: l_allow_relate_to_self_flag HZ_RELATIONSHIP_TYPES.ALLOW_RELATE_TO_SELF_FLAG%TYPE;
11841: l_allow_circular_relationships HZ_RELATIONSHIP_TYPES.ALLOW_CIRCULAR_RELATIONSHIPS%TYPE;
11842: l_hierarchical_flag HZ_RELATIONSHIP_TYPES.HIERARCHICAL_FLAG%TYPE;

Line 11839: l_create_party_flag HZ_RELATIONSHIP_TYPES.CREATE_PARTY_FLAG%TYPE;

11835: l_relationship_type HZ_RELATIONSHIP_TYPES.RELATIONSHIP_TYPE%TYPE;
11836: l_forward_rel_code HZ_RELATIONSHIP_TYPES.FORWARD_REL_CODE%TYPE;
11837: l_backward_rel_code HZ_RELATIONSHIP_TYPES.BACKWARD_REL_CODE%TYPE;
11838: l_direction_code HZ_RELATIONSHIP_TYPES.DIRECTION_CODE%TYPE;
11839: l_create_party_flag HZ_RELATIONSHIP_TYPES.CREATE_PARTY_FLAG%TYPE;
11840: l_allow_relate_to_self_flag HZ_RELATIONSHIP_TYPES.ALLOW_RELATE_TO_SELF_FLAG%TYPE;
11841: l_allow_circular_relationships HZ_RELATIONSHIP_TYPES.ALLOW_CIRCULAR_RELATIONSHIPS%TYPE;
11842: l_hierarchical_flag HZ_RELATIONSHIP_TYPES.HIERARCHICAL_FLAG%TYPE;
11843: l_multiple_parent_allowed HZ_RELATIONSHIP_TYPES.MULTIPLE_PARENT_ALLOWED%TYPE;

Line 11840: l_allow_relate_to_self_flag HZ_RELATIONSHIP_TYPES.ALLOW_RELATE_TO_SELF_FLAG%TYPE;

11836: l_forward_rel_code HZ_RELATIONSHIP_TYPES.FORWARD_REL_CODE%TYPE;
11837: l_backward_rel_code HZ_RELATIONSHIP_TYPES.BACKWARD_REL_CODE%TYPE;
11838: l_direction_code HZ_RELATIONSHIP_TYPES.DIRECTION_CODE%TYPE;
11839: l_create_party_flag HZ_RELATIONSHIP_TYPES.CREATE_PARTY_FLAG%TYPE;
11840: l_allow_relate_to_self_flag HZ_RELATIONSHIP_TYPES.ALLOW_RELATE_TO_SELF_FLAG%TYPE;
11841: l_allow_circular_relationships HZ_RELATIONSHIP_TYPES.ALLOW_CIRCULAR_RELATIONSHIPS%TYPE;
11842: l_hierarchical_flag HZ_RELATIONSHIP_TYPES.HIERARCHICAL_FLAG%TYPE;
11843: l_multiple_parent_allowed HZ_RELATIONSHIP_TYPES.MULTIPLE_PARENT_ALLOWED%TYPE;
11844: l_incl_unrelated_entities HZ_RELATIONSHIP_TYPES.INCL_UNRELATED_ENTITIES%TYPE;

Line 11841: l_allow_circular_relationships HZ_RELATIONSHIP_TYPES.ALLOW_CIRCULAR_RELATIONSHIPS%TYPE;

11837: l_backward_rel_code HZ_RELATIONSHIP_TYPES.BACKWARD_REL_CODE%TYPE;
11838: l_direction_code HZ_RELATIONSHIP_TYPES.DIRECTION_CODE%TYPE;
11839: l_create_party_flag HZ_RELATIONSHIP_TYPES.CREATE_PARTY_FLAG%TYPE;
11840: l_allow_relate_to_self_flag HZ_RELATIONSHIP_TYPES.ALLOW_RELATE_TO_SELF_FLAG%TYPE;
11841: l_allow_circular_relationships HZ_RELATIONSHIP_TYPES.ALLOW_CIRCULAR_RELATIONSHIPS%TYPE;
11842: l_hierarchical_flag HZ_RELATIONSHIP_TYPES.HIERARCHICAL_FLAG%TYPE;
11843: l_multiple_parent_allowed HZ_RELATIONSHIP_TYPES.MULTIPLE_PARENT_ALLOWED%TYPE;
11844: l_incl_unrelated_entities HZ_RELATIONSHIP_TYPES.INCL_UNRELATED_ENTITIES%TYPE;
11845: l_subject_type HZ_RELATIONSHIP_TYPES.SUBJECT_TYPE%TYPE;

Line 11842: l_hierarchical_flag HZ_RELATIONSHIP_TYPES.HIERARCHICAL_FLAG%TYPE;

11838: l_direction_code HZ_RELATIONSHIP_TYPES.DIRECTION_CODE%TYPE;
11839: l_create_party_flag HZ_RELATIONSHIP_TYPES.CREATE_PARTY_FLAG%TYPE;
11840: l_allow_relate_to_self_flag HZ_RELATIONSHIP_TYPES.ALLOW_RELATE_TO_SELF_FLAG%TYPE;
11841: l_allow_circular_relationships HZ_RELATIONSHIP_TYPES.ALLOW_CIRCULAR_RELATIONSHIPS%TYPE;
11842: l_hierarchical_flag HZ_RELATIONSHIP_TYPES.HIERARCHICAL_FLAG%TYPE;
11843: l_multiple_parent_allowed HZ_RELATIONSHIP_TYPES.MULTIPLE_PARENT_ALLOWED%TYPE;
11844: l_incl_unrelated_entities HZ_RELATIONSHIP_TYPES.INCL_UNRELATED_ENTITIES%TYPE;
11845: l_subject_type HZ_RELATIONSHIP_TYPES.SUBJECT_TYPE%TYPE;
11846: l_object_type HZ_RELATIONSHIP_TYPES.OBJECT_TYPE%TYPE;

Line 11843: l_multiple_parent_allowed HZ_RELATIONSHIP_TYPES.MULTIPLE_PARENT_ALLOWED%TYPE;

11839: l_create_party_flag HZ_RELATIONSHIP_TYPES.CREATE_PARTY_FLAG%TYPE;
11840: l_allow_relate_to_self_flag HZ_RELATIONSHIP_TYPES.ALLOW_RELATE_TO_SELF_FLAG%TYPE;
11841: l_allow_circular_relationships HZ_RELATIONSHIP_TYPES.ALLOW_CIRCULAR_RELATIONSHIPS%TYPE;
11842: l_hierarchical_flag HZ_RELATIONSHIP_TYPES.HIERARCHICAL_FLAG%TYPE;
11843: l_multiple_parent_allowed HZ_RELATIONSHIP_TYPES.MULTIPLE_PARENT_ALLOWED%TYPE;
11844: l_incl_unrelated_entities HZ_RELATIONSHIP_TYPES.INCL_UNRELATED_ENTITIES%TYPE;
11845: l_subject_type HZ_RELATIONSHIP_TYPES.SUBJECT_TYPE%TYPE;
11846: l_object_type HZ_RELATIONSHIP_TYPES.OBJECT_TYPE%TYPE;
11847: l_created_by_module VARCHAR2(150);

Line 11844: l_incl_unrelated_entities HZ_RELATIONSHIP_TYPES.INCL_UNRELATED_ENTITIES%TYPE;

11840: l_allow_relate_to_self_flag HZ_RELATIONSHIP_TYPES.ALLOW_RELATE_TO_SELF_FLAG%TYPE;
11841: l_allow_circular_relationships HZ_RELATIONSHIP_TYPES.ALLOW_CIRCULAR_RELATIONSHIPS%TYPE;
11842: l_hierarchical_flag HZ_RELATIONSHIP_TYPES.HIERARCHICAL_FLAG%TYPE;
11843: l_multiple_parent_allowed HZ_RELATIONSHIP_TYPES.MULTIPLE_PARENT_ALLOWED%TYPE;
11844: l_incl_unrelated_entities HZ_RELATIONSHIP_TYPES.INCL_UNRELATED_ENTITIES%TYPE;
11845: l_subject_type HZ_RELATIONSHIP_TYPES.SUBJECT_TYPE%TYPE;
11846: l_object_type HZ_RELATIONSHIP_TYPES.OBJECT_TYPE%TYPE;
11847: l_created_by_module VARCHAR2(150);
11848: l_application_id NUMBER;

Line 11845: l_subject_type HZ_RELATIONSHIP_TYPES.SUBJECT_TYPE%TYPE;

11841: l_allow_circular_relationships HZ_RELATIONSHIP_TYPES.ALLOW_CIRCULAR_RELATIONSHIPS%TYPE;
11842: l_hierarchical_flag HZ_RELATIONSHIP_TYPES.HIERARCHICAL_FLAG%TYPE;
11843: l_multiple_parent_allowed HZ_RELATIONSHIP_TYPES.MULTIPLE_PARENT_ALLOWED%TYPE;
11844: l_incl_unrelated_entities HZ_RELATIONSHIP_TYPES.INCL_UNRELATED_ENTITIES%TYPE;
11845: l_subject_type HZ_RELATIONSHIP_TYPES.SUBJECT_TYPE%TYPE;
11846: l_object_type HZ_RELATIONSHIP_TYPES.OBJECT_TYPE%TYPE;
11847: l_created_by_module VARCHAR2(150);
11848: l_application_id NUMBER;
11849: l_status VARCHAR2(1);

Line 11846: l_object_type HZ_RELATIONSHIP_TYPES.OBJECT_TYPE%TYPE;

11842: l_hierarchical_flag HZ_RELATIONSHIP_TYPES.HIERARCHICAL_FLAG%TYPE;
11843: l_multiple_parent_allowed HZ_RELATIONSHIP_TYPES.MULTIPLE_PARENT_ALLOWED%TYPE;
11844: l_incl_unrelated_entities HZ_RELATIONSHIP_TYPES.INCL_UNRELATED_ENTITIES%TYPE;
11845: l_subject_type HZ_RELATIONSHIP_TYPES.SUBJECT_TYPE%TYPE;
11846: l_object_type HZ_RELATIONSHIP_TYPES.OBJECT_TYPE%TYPE;
11847: l_created_by_module VARCHAR2(150);
11848: l_application_id NUMBER;
11849: l_status VARCHAR2(1);
11850: l_debug_prefix VARCHAR2(30) := '';

Line 11899: FROM HZ_RELATIONSHIP_TYPES

11895: l_object_type,
11896: l_role,
11897: l_created_by_module,
11898: l_application_id
11899: FROM HZ_RELATIONSHIP_TYPES
11900: WHERE ROWID = p_rowid;
11901: END IF;
11902:
11903:

Line 11916: FROM HZ_RELATIONSHIP_TYPES

11912: );
11913: --------Bug no: 3564107 ---------------------------------
11914: BEGIN
11915: SELECT ROLE INTO l_role
11916: FROM HZ_RELATIONSHIP_TYPES
11917: WHERE RELATIONSHIP_TYPE = l_relationship_type
11918: AND FORWARD_REL_CODE = l_backward_rel_code
11919: AND BACKWARD_REL_CODE = l_forward_rel_code
11920: AND SUBJECT_TYPE = l_object_type

Line 12640: | FROM HZ_RELATIONSHIP_TYPES

12636: -- Bug 2751613.This validation should work for all the different combinations.
12637: /* Bug 2751613.
12638: | SELECT COUNT(*)
12639: | INTO l_count
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 12650: | FROM HZ_RELATIONSHIP_TYPES

12646: | IF l_count > 0 THEN
12647: | --since there is one or more such records, we need to get the backward_rel_code
12648: | SELECT BACKWARD_REL_CODE
12649: | INTO l_code
12650: | FROM HZ_RELATIONSHIP_TYPES
12651: | WHERE RELATIONSHIP_TYPE = p_relationship_type_rec.relationship_type
12652: | AND FORWARD_REL_CODE = p_relationship_type_rec.forward_rel_code
12653: | AND SUBJECT_TYPE = p_relationship_type_rec.subject_type
12654: | AND OBJECT_TYPE = p_relationship_type_rec.object_type

Line 12669: FROM HZ_RELATIONSHIP_TYPES

12665:
12666: -- Bug 2751613.
12667: SELECT COUNT(*)
12668: INTO l_count
12669: FROM HZ_RELATIONSHIP_TYPES
12670: WHERE
12671: (
12672: RELATIONSHIP_TYPE = p_relationship_type_rec.relationship_type
12673: )

Line 12738: FROM HZ_RELATIONSHIP_TYPES

12734: -- check for duplicate record
12735: BEGIN
12736: SELECT 1
12737: INTO l_count
12738: FROM HZ_RELATIONSHIP_TYPES
12739: WHERE RELATIONSHIP_TYPE = p_relationship_type_rec.relationship_type
12740: AND FORWARD_REL_CODE = p_relationship_type_rec.forward_rel_code
12741: AND BACKWARD_REL_CODE = p_relationship_type_rec.backward_rel_code
12742: AND SUBJECT_TYPE = p_relationship_type_rec.subject_type

Line 12924: FROM HZ_RELATIONSHIP_TYPES

12920: IF p_create_update_flag = 'C' THEN
12921: BEGIN
12922: SELECT count(*)
12923: INTO l_count
12924: FROM HZ_RELATIONSHIP_TYPES
12925: WHERE ROLE = p_relationship_type_rec.forward_role
12926: OR ROLE = p_relationship_type_rec.backward_role;
12927: IF l_count > 0 THEN
12928: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');

Line 13084: FROM HZ_RELATIONSHIP_TYPES

13080: IF p_create_update_flag = 'C' THEN
13081: BEGIN
13082: SELECT HIERARCHICAL_FLAG
13083: INTO l_hierarchical_flag
13084: FROM HZ_RELATIONSHIP_TYPES
13085: WHERE RELATIONSHIP_TYPE = p_relationship_type_rec.relationship_type
13086: AND ROWNUM = 1;
13087:
13088: IF NVL(p_relationship_type_rec.hierarchical_flag, 'N')

Line 13131: FROM HZ_RELATIONSHIP_TYPES

13127: IF p_create_update_flag = 'C' THEN
13128: BEGIN
13129: SELECT ALLOW_CIRCULAR_RELATIONSHIPS
13130: INTO l_allow_circular_relationships
13131: FROM HZ_RELATIONSHIP_TYPES
13132: WHERE RELATIONSHIP_TYPE = p_relationship_type_rec.relationship_type
13133: AND ROWNUM = 1;
13134:
13135: IF NVL(p_relationship_type_rec.allow_circular_relationships, 'N') <> NVL(l_allow_circular_relationships, 'N')

Line 13173: FROM HZ_RELATIONSHIP_TYPES

13169: IF p_create_update_flag = 'C' THEN
13170: BEGIN
13171: SELECT MULTIPLE_PARENT_ALLOWED
13172: INTO l_multiple_parent_allowed
13173: FROM HZ_RELATIONSHIP_TYPES
13174: WHERE RELATIONSHIP_TYPE = p_relationship_type_rec.relationship_type
13175: AND ROWNUM = 1;
13176:
13177: IF NVL(p_relationship_type_rec.multiple_parent_allowed, 'N') <>