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 7695: FROM HZ_RELATIONSHIPS PR,

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

Line 7698: HZ_RELATIONSHIPS PR2,

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

Line 12120: FROM HZ_RELATIONSHIPS

12116: -- check if there is any relationship with this relationship type having a party.
12117: -- if there is, do not allow the update
12118: BEGIN
12119: SELECT 1 INTO l_count
12120: FROM HZ_RELATIONSHIPS
12121: WHERE RELATIONSHIP_TYPE = l_relationship_type
12122: AND SUBJECT_TYPE = l_subject_type
12123: AND OBJECT_TYPE = l_object_type
12124: AND RELATIONSHIP_CODE = l_forward_rel_code

Line 12146: FROM HZ_RELATIONSHIPS

12142: -- check if there is any relationship with this relationship type not having a party.
12143: -- if there is, do not allow the update.
12144: BEGIN
12145: SELECT 1 INTO l_count
12146: FROM HZ_RELATIONSHIPS
12147: WHERE RELATIONSHIP_TYPE = l_relationship_type
12148: AND SUBJECT_TYPE = l_subject_type
12149: AND OBJECT_TYPE = l_object_type
12150: AND RELATIONSHIP_CODE = l_forward_rel_code

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

13368: ) IS
13369: l_count NUMBER;
13370: l_subject_id NUMBER := p_relationship_rec.subject_id;
13371: l_object_id NUMBER := p_relationship_rec.object_id;
13372: l_relationship_type hz_relationships.relationship_type%TYPE := p_relationship_rec.relationship_type;
13373: l_relationship_code hz_relationships.relationship_code%TYPE := p_relationship_rec.relationship_code;
13374: l_subject_type hz_relationships.subject_type%TYPE := p_relationship_rec.subject_type;
13375: l_object_type hz_relationships.object_type%TYPE := p_relationship_rec.object_type;
13376: l_subject_table_name hz_relationships.subject_table_name%TYPE := p_relationship_rec.subject_table_name;

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

13369: l_count NUMBER;
13370: l_subject_id NUMBER := p_relationship_rec.subject_id;
13371: l_object_id NUMBER := p_relationship_rec.object_id;
13372: l_relationship_type hz_relationships.relationship_type%TYPE := p_relationship_rec.relationship_type;
13373: l_relationship_code hz_relationships.relationship_code%TYPE := p_relationship_rec.relationship_code;
13374: l_subject_type hz_relationships.subject_type%TYPE := p_relationship_rec.subject_type;
13375: l_object_type hz_relationships.object_type%TYPE := p_relationship_rec.object_type;
13376: l_subject_table_name hz_relationships.subject_table_name%TYPE := p_relationship_rec.subject_table_name;
13377: l_object_table_name hz_relationships.object_table_name%TYPE := p_relationship_rec.object_table_name;

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

13370: l_subject_id NUMBER := p_relationship_rec.subject_id;
13371: l_object_id NUMBER := p_relationship_rec.object_id;
13372: l_relationship_type hz_relationships.relationship_type%TYPE := p_relationship_rec.relationship_type;
13373: l_relationship_code hz_relationships.relationship_code%TYPE := p_relationship_rec.relationship_code;
13374: l_subject_type hz_relationships.subject_type%TYPE := p_relationship_rec.subject_type;
13375: l_object_type hz_relationships.object_type%TYPE := p_relationship_rec.object_type;
13376: l_subject_table_name hz_relationships.subject_table_name%TYPE := p_relationship_rec.subject_table_name;
13377: l_object_table_name hz_relationships.object_table_name%TYPE := p_relationship_rec.object_table_name;
13378: l_party_id NUMBER;

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

13371: l_object_id NUMBER := p_relationship_rec.object_id;
13372: l_relationship_type hz_relationships.relationship_type%TYPE := p_relationship_rec.relationship_type;
13373: l_relationship_code hz_relationships.relationship_code%TYPE := p_relationship_rec.relationship_code;
13374: l_subject_type hz_relationships.subject_type%TYPE := p_relationship_rec.subject_type;
13375: l_object_type hz_relationships.object_type%TYPE := p_relationship_rec.object_type;
13376: l_subject_table_name hz_relationships.subject_table_name%TYPE := p_relationship_rec.subject_table_name;
13377: l_object_table_name hz_relationships.object_table_name%TYPE := p_relationship_rec.object_table_name;
13378: l_party_id NUMBER;
13379: l_content_source_type hz_relationships.content_source_type%TYPE;

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

13372: l_relationship_type hz_relationships.relationship_type%TYPE := p_relationship_rec.relationship_type;
13373: l_relationship_code hz_relationships.relationship_code%TYPE := p_relationship_rec.relationship_code;
13374: l_subject_type hz_relationships.subject_type%TYPE := p_relationship_rec.subject_type;
13375: l_object_type hz_relationships.object_type%TYPE := p_relationship_rec.object_type;
13376: l_subject_table_name hz_relationships.subject_table_name%TYPE := p_relationship_rec.subject_table_name;
13377: l_object_table_name hz_relationships.object_table_name%TYPE := p_relationship_rec.object_table_name;
13378: l_party_id NUMBER;
13379: l_content_source_type hz_relationships.content_source_type%TYPE;
13380: l_start_date DATE := p_relationship_rec.start_date;

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

13373: l_relationship_code hz_relationships.relationship_code%TYPE := p_relationship_rec.relationship_code;
13374: l_subject_type hz_relationships.subject_type%TYPE := p_relationship_rec.subject_type;
13375: l_object_type hz_relationships.object_type%TYPE := p_relationship_rec.object_type;
13376: l_subject_table_name hz_relationships.subject_table_name%TYPE := p_relationship_rec.subject_table_name;
13377: l_object_table_name hz_relationships.object_table_name%TYPE := p_relationship_rec.object_table_name;
13378: l_party_id NUMBER;
13379: l_content_source_type hz_relationships.content_source_type%TYPE;
13380: l_start_date DATE := p_relationship_rec.start_date;
13381: l_end_date DATE := p_relationship_rec.end_date;

Line 13379: l_content_source_type hz_relationships.content_source_type%TYPE;

13375: l_object_type hz_relationships.object_type%TYPE := p_relationship_rec.object_type;
13376: l_subject_table_name hz_relationships.subject_table_name%TYPE := p_relationship_rec.subject_table_name;
13377: l_object_table_name hz_relationships.object_table_name%TYPE := p_relationship_rec.object_table_name;
13378: l_party_id NUMBER;
13379: l_content_source_type hz_relationships.content_source_type%TYPE;
13380: l_start_date DATE := p_relationship_rec.start_date;
13381: l_end_date DATE := p_relationship_rec.end_date;
13382: l_in VARCHAR2(1);
13383: l_overlap VARCHAR2(1);

Line 13390: db_actual_content_source hz_relationships.actual_content_source%TYPE;

13386: l_status VARCHAR2(1);
13387: l_debug_prefix VARCHAR2(30) := '';
13388:
13389: -- Bug 2197181: Added for mix-n-match
13390: db_actual_content_source hz_relationships.actual_content_source%TYPE;
13391:
13392:
13393: -- cursor to get all the relationship records...
13394: -- for given subject_id, object_id, relationship_code

Line 13405: FROM hz_relationships hr

13401: SELECT hr.start_date,
13402: hr.end_date,
13403: hr.relationship_id,
13404: hr.status
13405: FROM hz_relationships hr
13406: WHERE hr.subject_id = l_subject_id
13407: AND hr.object_id = l_object_id
13408: AND hr.subject_table_name = l_subject_table_name
13409: AND hr.subject_type = l_subject_type

Line 13480: FROM hz_relationships

13476: l_status,
13477: l_created_by_module,
13478: l_application_id,
13479: db_actual_content_source
13480: FROM hz_relationships
13481: WHERE ROWID = p_rowid;
13482: END IF;
13483:
13484: -----------------------------

Line 14305: p_entity_name => 'HZ_RELATIONSHIPS',

14301: p_content_source_type => p_relationship_rec.content_source_type,
14302: p_old_content_source_type => l_content_source_type,
14303: p_actual_content_source => p_relationship_rec.actual_content_source,
14304: p_old_actual_content_source => db_actual_content_source,
14305: p_entity_name => 'HZ_RELATIONSHIPS',
14306: x_return_status => x_return_status );
14307:
14308: ----------------------------------
14309: -- start_date, end_date validation

Line 14371: FROM hz_relationships

14367: -- between two identical relationships.
14368: IF p_relationship_rec.status IS NULL AND p_create_update_flag = 'U' THEN
14369: SELECT status
14370: INTO l_status
14371: FROM hz_relationships
14372: WHERE relationship_id = p_relationship_rec.relationship_id
14373: AND rownum =1;
14374: END IF;
14375: