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_RELATIONSHIPS

Line 7692: FROM HZ_RELATIONSHIPS PR,

7688: IF p_org_contact_role_rec.primary_contact_per_role_type = 'Y' THEN
7689: BEGIN
7690: SELECT 'Y'
7691: INTO l_dummy
7692: FROM HZ_RELATIONSHIPS PR,
7693: HZ_ORG_CONTACTS OC,
7694: HZ_ORG_CONTACT_ROLES OCR,
7695: HZ_RELATIONSHIPS PR2,
7696: HZ_ORG_CONTACTS OC2

Line 7695: HZ_RELATIONSHIPS PR2,

7691: INTO l_dummy
7692: FROM HZ_RELATIONSHIPS PR,
7693: HZ_ORG_CONTACTS OC,
7694: HZ_ORG_CONTACT_ROLES OCR,
7695: HZ_RELATIONSHIPS PR2,
7696: HZ_ORG_CONTACTS OC2
7697: WHERE OCR.PRIMARY_CONTACT_PER_ROLE_TYPE = 'Y'
7698: AND OCR.ROLE_TYPE = p_org_contact_role_rec.role_type
7699: AND OCR.ORG_CONTACT_ID = OC.ORG_CONTACT_ID

Line 12110: FROM HZ_RELATIONSHIPS

12106: -- check if there is any relationship with this relationship type having a party.
12107: -- if there is, do not allow the update
12108: BEGIN
12109: SELECT 1 INTO l_count
12110: FROM HZ_RELATIONSHIPS
12111: WHERE RELATIONSHIP_TYPE = l_relationship_type
12112: AND SUBJECT_TYPE = l_subject_type
12113: AND OBJECT_TYPE = l_object_type
12114: AND RELATIONSHIP_CODE = l_forward_rel_code

Line 12136: FROM HZ_RELATIONSHIPS

12132: -- check if there is any relationship with this relationship type not having a party.
12133: -- if there is, do not allow the update.
12134: BEGIN
12135: SELECT 1 INTO l_count
12136: FROM HZ_RELATIONSHIPS
12137: WHERE RELATIONSHIP_TYPE = l_relationship_type
12138: AND SUBJECT_TYPE = l_subject_type
12139: AND OBJECT_TYPE = l_object_type
12140: AND RELATIONSHIP_CODE = l_forward_rel_code

Line 13362: l_relationship_type hz_relationships.relationship_type%TYPE := p_relationship_rec.relationship_type;

13358: ) IS
13359: l_count NUMBER;
13360: l_subject_id NUMBER := p_relationship_rec.subject_id;
13361: l_object_id NUMBER := p_relationship_rec.object_id;
13362: l_relationship_type hz_relationships.relationship_type%TYPE := p_relationship_rec.relationship_type;
13363: l_relationship_code hz_relationships.relationship_code%TYPE := p_relationship_rec.relationship_code;
13364: l_subject_type hz_relationships.subject_type%TYPE := p_relationship_rec.subject_type;
13365: l_object_type hz_relationships.object_type%TYPE := p_relationship_rec.object_type;
13366: l_subject_table_name hz_relationships.subject_table_name%TYPE := p_relationship_rec.subject_table_name;

Line 13363: l_relationship_code hz_relationships.relationship_code%TYPE := p_relationship_rec.relationship_code;

13359: l_count NUMBER;
13360: l_subject_id NUMBER := p_relationship_rec.subject_id;
13361: l_object_id NUMBER := p_relationship_rec.object_id;
13362: l_relationship_type hz_relationships.relationship_type%TYPE := p_relationship_rec.relationship_type;
13363: l_relationship_code hz_relationships.relationship_code%TYPE := p_relationship_rec.relationship_code;
13364: l_subject_type hz_relationships.subject_type%TYPE := p_relationship_rec.subject_type;
13365: l_object_type hz_relationships.object_type%TYPE := p_relationship_rec.object_type;
13366: l_subject_table_name hz_relationships.subject_table_name%TYPE := p_relationship_rec.subject_table_name;
13367: l_object_table_name hz_relationships.object_table_name%TYPE := p_relationship_rec.object_table_name;

Line 13364: l_subject_type hz_relationships.subject_type%TYPE := p_relationship_rec.subject_type;

13360: l_subject_id NUMBER := p_relationship_rec.subject_id;
13361: l_object_id NUMBER := p_relationship_rec.object_id;
13362: l_relationship_type hz_relationships.relationship_type%TYPE := p_relationship_rec.relationship_type;
13363: l_relationship_code hz_relationships.relationship_code%TYPE := p_relationship_rec.relationship_code;
13364: l_subject_type hz_relationships.subject_type%TYPE := p_relationship_rec.subject_type;
13365: l_object_type hz_relationships.object_type%TYPE := p_relationship_rec.object_type;
13366: l_subject_table_name hz_relationships.subject_table_name%TYPE := p_relationship_rec.subject_table_name;
13367: l_object_table_name hz_relationships.object_table_name%TYPE := p_relationship_rec.object_table_name;
13368: l_party_id NUMBER;

Line 13365: l_object_type hz_relationships.object_type%TYPE := p_relationship_rec.object_type;

13361: l_object_id NUMBER := p_relationship_rec.object_id;
13362: l_relationship_type hz_relationships.relationship_type%TYPE := p_relationship_rec.relationship_type;
13363: l_relationship_code hz_relationships.relationship_code%TYPE := p_relationship_rec.relationship_code;
13364: l_subject_type hz_relationships.subject_type%TYPE := p_relationship_rec.subject_type;
13365: l_object_type hz_relationships.object_type%TYPE := p_relationship_rec.object_type;
13366: l_subject_table_name hz_relationships.subject_table_name%TYPE := p_relationship_rec.subject_table_name;
13367: l_object_table_name hz_relationships.object_table_name%TYPE := p_relationship_rec.object_table_name;
13368: l_party_id NUMBER;
13369: l_content_source_type hz_relationships.content_source_type%TYPE;

Line 13366: l_subject_table_name hz_relationships.subject_table_name%TYPE := p_relationship_rec.subject_table_name;

13362: l_relationship_type hz_relationships.relationship_type%TYPE := p_relationship_rec.relationship_type;
13363: l_relationship_code hz_relationships.relationship_code%TYPE := p_relationship_rec.relationship_code;
13364: l_subject_type hz_relationships.subject_type%TYPE := p_relationship_rec.subject_type;
13365: l_object_type hz_relationships.object_type%TYPE := p_relationship_rec.object_type;
13366: l_subject_table_name hz_relationships.subject_table_name%TYPE := p_relationship_rec.subject_table_name;
13367: l_object_table_name hz_relationships.object_table_name%TYPE := p_relationship_rec.object_table_name;
13368: l_party_id NUMBER;
13369: l_content_source_type hz_relationships.content_source_type%TYPE;
13370: l_start_date DATE := p_relationship_rec.start_date;

Line 13367: l_object_table_name hz_relationships.object_table_name%TYPE := p_relationship_rec.object_table_name;

13363: l_relationship_code hz_relationships.relationship_code%TYPE := p_relationship_rec.relationship_code;
13364: l_subject_type hz_relationships.subject_type%TYPE := p_relationship_rec.subject_type;
13365: l_object_type hz_relationships.object_type%TYPE := p_relationship_rec.object_type;
13366: l_subject_table_name hz_relationships.subject_table_name%TYPE := p_relationship_rec.subject_table_name;
13367: l_object_table_name hz_relationships.object_table_name%TYPE := p_relationship_rec.object_table_name;
13368: l_party_id NUMBER;
13369: l_content_source_type hz_relationships.content_source_type%TYPE;
13370: l_start_date DATE := p_relationship_rec.start_date;
13371: l_end_date DATE := p_relationship_rec.end_date;

Line 13369: l_content_source_type hz_relationships.content_source_type%TYPE;

13365: l_object_type hz_relationships.object_type%TYPE := p_relationship_rec.object_type;
13366: l_subject_table_name hz_relationships.subject_table_name%TYPE := p_relationship_rec.subject_table_name;
13367: l_object_table_name hz_relationships.object_table_name%TYPE := p_relationship_rec.object_table_name;
13368: l_party_id NUMBER;
13369: l_content_source_type hz_relationships.content_source_type%TYPE;
13370: l_start_date DATE := p_relationship_rec.start_date;
13371: l_end_date DATE := p_relationship_rec.end_date;
13372: l_in VARCHAR2(1);
13373: l_overlap VARCHAR2(1);

Line 13380: db_actual_content_source hz_relationships.actual_content_source%TYPE;

13376: l_status VARCHAR2(1);
13377: l_debug_prefix VARCHAR2(30) := '';
13378:
13379: -- Bug 2197181: Added for mix-n-match
13380: db_actual_content_source hz_relationships.actual_content_source%TYPE;
13381:
13382:
13383: -- cursor to get all the relationship records...
13384: -- for given subject_id, object_id, relationship_code

Line 13395: FROM hz_relationships hr

13391: SELECT hr.start_date,
13392: hr.end_date,
13393: hr.relationship_id,
13394: hr.status
13395: FROM hz_relationships hr
13396: WHERE hr.subject_id = l_subject_id
13397: AND hr.object_id = l_object_id
13398: AND hr.subject_table_name = l_subject_table_name
13399: AND hr.subject_type = l_subject_type

Line 13470: FROM hz_relationships

13466: l_status,
13467: l_created_by_module,
13468: l_application_id,
13469: db_actual_content_source
13470: FROM hz_relationships
13471: WHERE ROWID = p_rowid;
13472: END IF;
13473:
13474: -----------------------------

Line 14295: p_entity_name => 'HZ_RELATIONSHIPS',

14291: p_content_source_type => p_relationship_rec.content_source_type,
14292: p_old_content_source_type => l_content_source_type,
14293: p_actual_content_source => p_relationship_rec.actual_content_source,
14294: p_old_actual_content_source => db_actual_content_source,
14295: p_entity_name => 'HZ_RELATIONSHIPS',
14296: x_return_status => x_return_status );
14297:
14298: ----------------------------------
14299: -- start_date, end_date validation