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_MERGE_PKG dependencies on HZ_RELATIONSHIPS

Line 4055: FROM HZ_RELATIONSHIPS PR,

4051: IF l_fp_primary_role_flag = 'Y' THEN
4052: BEGIN
4053: SELECT 'Exists'
4054: INTO l_exists
4055: FROM HZ_RELATIONSHIPS PR,
4056: HZ_ORG_CONTACTS OC,
4057: HZ_ORG_CONTACT_ROLES OCR,
4058: HZ_RELATIONSHIPS PR2,
4059: HZ_ORG_CONTACTS OC2

Line 4058: HZ_RELATIONSHIPS PR2,

4054: INTO l_exists
4055: FROM HZ_RELATIONSHIPS PR,
4056: HZ_ORG_CONTACTS OC,
4057: HZ_ORG_CONTACT_ROLES OCR,
4058: HZ_RELATIONSHIPS PR2,
4059: HZ_ORG_CONTACTS OC2
4060: WHERE OCR.PRIMARY_CONTACT_PER_ROLE_TYPE = 'Y'
4061: AND OCR.ROLE_TYPE = l_role_type
4062: AND OCR.ORG_CONTACT_ID = OC.ORG_CONTACT_ID

Line 5049: FROM HZ_RELATIONSHIPS

5045: ) IS
5046:
5047: CURSOR c_party(cp_party_reln_id NUMBER) IS
5048: SELECT party_id
5049: FROM HZ_RELATIONSHIPS
5050: WHERE relationship_id = cp_party_reln_id
5051: AND DIRECTIONAL_FLAG = 'F'
5052: and status in ('A','I'); -- bug 5094383
5053:

Line 5056: FROM HZ_RELATIONSHIPS

5052: and status in ('A','I'); -- bug 5094383
5053:
5054: CURSOR c_to_party_reln IS
5055: SELECT relationship_id
5056: FROM HZ_RELATIONSHIPS
5057: WHERE relationship_id = x_to_id
5058: FOR UPDATE NOWAIT;
5059:
5060: cursor c_start_end_date is

Line 5063: FROM HZ_RELATIONSHIPS

5059:
5060: cursor c_start_end_date is
5061: SELECT start_date, nvl(end_date,to_date('12/31/4712','MM/DD/YYYY')), actual_content_source, --5404244
5062: nvl(request_id , -1), NVL(status, 'A')
5063: FROM HZ_RELATIONSHIPS
5064: WHERE relationship_id = p_from_id
5065: AND DIRECTIONAL_FLAG='F';
5066:
5067: CURSOR c_check_valid_merge(from_start_date date, from_end_date date, from_cont_source_type VARCHAR2, from_cont_source VARCHAR2) IS

Line 5069: FROM HZ_RELATIONSHIPS

5065: AND DIRECTIONAL_FLAG='F';
5066:
5067: CURSOR c_check_valid_merge(from_start_date date, from_end_date date, from_cont_source_type VARCHAR2, from_cont_source VARCHAR2) IS
5068: SELECT relationship_id, nvl(request_id,-1), NVL(status, 'A')
5069: FROM HZ_RELATIONSHIPS
5070: WHERE object_id = p_to_fk_id
5071: AND actual_content_source = DECODE(from_cont_source_type, 'PURCHASED', from_cont_source, actual_content_source) --5404244
5072: AND actual_content_source <> 'DNB'
5073: AND subject_id = (

Line 5075: FROM HZ_RELATIONSHIPS

5071: AND actual_content_source = DECODE(from_cont_source_type, 'PURCHASED', from_cont_source, actual_content_source) --5404244
5072: AND actual_content_source <> 'DNB'
5073: AND subject_id = (
5074: SELECT SUBJECT_ID
5075: FROM HZ_RELATIONSHIPS
5076: WHERE relationship_id = p_from_id
5077: AND DIRECTIONAL_FLAG='F')
5078: AND subject_id NOT IN
5079: ((SELECT from_party_id FROM hz_merge_parties WHERE to_party_id = p_to_fk_id AND merge_status='PENDING' )) --bug 4867151

Line 5084: FROM HZ_RELATIONSHIPS

5080: AND subject_id NOT IN
5081: ((SELECT to_party_id FROM hz_merge_parties WHERE to_party_id = p_to_fk_id AND merge_status='PENDING' )) --bug 4867151
5082: AND relationship_type||relationship_code = (
5083: SELECT relationship_type||relationship_code -- Bug No: 4571969
5084: FROM HZ_RELATIONSHIPS
5085: WHERE relationship_id = p_from_id
5086: AND DIRECTIONAL_FLAG='F')
5087: AND DIRECTIONAL_FLAG = 'F'
5088: AND ((start_date between from_start_date and from_end_date)

Line 5110: l_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_TYPE%TYPE;

5106: --Bug 2619913 Do not allow self relationships creation unless
5107: --defined in the relationship type table
5108:
5109: l_subject_id NUMBER;
5110: l_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_TYPE%TYPE;
5111: l_rel_code HZ_RELATIONSHIPS.RELATIONSHIP_CODE%TYPE;
5112: l_subject_type HZ_RELATIONSHIPS.SUBJECT_TYPE%TYPE;
5113: l_object_type HZ_RELATIONSHIPS.OBJECT_TYPE%TYPE;
5114: l_self_rel_flag VARCHAR2(1);

Line 5111: l_rel_code HZ_RELATIONSHIPS.RELATIONSHIP_CODE%TYPE;

5107: --defined in the relationship type table
5108:
5109: l_subject_id NUMBER;
5110: l_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_TYPE%TYPE;
5111: l_rel_code HZ_RELATIONSHIPS.RELATIONSHIP_CODE%TYPE;
5112: l_subject_type HZ_RELATIONSHIPS.SUBJECT_TYPE%TYPE;
5113: l_object_type HZ_RELATIONSHIPS.OBJECT_TYPE%TYPE;
5114: l_self_rel_flag VARCHAR2(1);
5115:

Line 5112: l_subject_type HZ_RELATIONSHIPS.SUBJECT_TYPE%TYPE;

5108:
5109: l_subject_id NUMBER;
5110: l_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_TYPE%TYPE;
5111: l_rel_code HZ_RELATIONSHIPS.RELATIONSHIP_CODE%TYPE;
5112: l_subject_type HZ_RELATIONSHIPS.SUBJECT_TYPE%TYPE;
5113: l_object_type HZ_RELATIONSHIPS.OBJECT_TYPE%TYPE;
5114: l_self_rel_flag VARCHAR2(1);
5115:
5116: l_rel_party_id HZ_RELATIONSHIPS.PARTY_ID%TYPE;

Line 5113: l_object_type HZ_RELATIONSHIPS.OBJECT_TYPE%TYPE;

5109: l_subject_id NUMBER;
5110: l_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_TYPE%TYPE;
5111: l_rel_code HZ_RELATIONSHIPS.RELATIONSHIP_CODE%TYPE;
5112: l_subject_type HZ_RELATIONSHIPS.SUBJECT_TYPE%TYPE;
5113: l_object_type HZ_RELATIONSHIPS.OBJECT_TYPE%TYPE;
5114: l_self_rel_flag VARCHAR2(1);
5115:
5116: l_rel_party_id HZ_RELATIONSHIPS.PARTY_ID%TYPE;
5117: l_new_obj_party_name HZ_PARTIES.PARTY_NAME%TYPE;

Line 5116: l_rel_party_id HZ_RELATIONSHIPS.PARTY_ID%TYPE;

5112: l_subject_type HZ_RELATIONSHIPS.SUBJECT_TYPE%TYPE;
5113: l_object_type HZ_RELATIONSHIPS.OBJECT_TYPE%TYPE;
5114: l_self_rel_flag VARCHAR2(1);
5115:
5116: l_rel_party_id HZ_RELATIONSHIPS.PARTY_ID%TYPE;
5117: l_new_obj_party_name HZ_PARTIES.PARTY_NAME%TYPE;
5118: l_subject_name HZ_PARTIES.PARTY_NAME%TYPE;
5119: l_rel_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;
5120: from_cont_source HZ_RELATIONSHIPS.ACTUAL_CONTENT_SOURCE%TYPE; --5404244

Line 5120: from_cont_source HZ_RELATIONSHIPS.ACTUAL_CONTENT_SOURCE%TYPE; --5404244

5116: l_rel_party_id HZ_RELATIONSHIPS.PARTY_ID%TYPE;
5117: l_new_obj_party_name HZ_PARTIES.PARTY_NAME%TYPE;
5118: l_subject_name HZ_PARTIES.PARTY_NAME%TYPE;
5119: l_rel_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;
5120: from_cont_source HZ_RELATIONSHIPS.ACTUAL_CONTENT_SOURCE%TYPE; --5404244
5121: from_cont_source_type HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM_TYPE%TYPE;
5122:
5123: --6696774 Start
5124: l_par_exists VARCHAR2(1);

Line 5125: l_direction_code HZ_RELATIONSHIPS.DIRECTION_CODE%TYPE;

5121: from_cont_source_type HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM_TYPE%TYPE;
5122:
5123: --6696774 Start
5124: l_par_exists VARCHAR2(1);
5125: l_direction_code HZ_RELATIONSHIPS.DIRECTION_CODE%TYPE;
5126: --6696774 end
5127: l_from_request_id NUMBER;
5128: l_to_rel_status VARCHAR2(1);
5129: l_from_rel_status VARCHAR2(1);

Line 5160: UPDATE HZ_RELATIONSHIPS

5156: END IF;
5157:
5158: IF l_from_party_id IS NOT NULL THEN
5159: OPEN c_to_party_reln;
5160: UPDATE HZ_RELATIONSHIPS
5161: SET
5162: party_id = l_from_party_id,
5163: last_update_date = hz_utility_pub.last_update_date,
5164: last_updated_by = hz_utility_pub.user_id,

Line 5174: UPDATE HZ_RELATIONSHIPS

5170: WHERE relationship_id = x_to_id;
5171: CLOSE c_to_party_reln;
5172: END IF;
5173:
5174: UPDATE HZ_RELATIONSHIPS
5175: SET
5176: STATUS = 'M',
5177: end_date = sysdate,
5178: last_update_date = hz_utility_pub.last_update_date,

Line 5187: --4307667 merge usages with owner_table_name 'HZ_RELATIONSHIPS'

5183: program_id = hz_utility_pub.program_id,
5184: program_update_date = sysdate
5185: WHERE relationship_id = p_from_id;
5186:
5187: --4307667 merge usages with owner_table_name 'HZ_RELATIONSHIPS'
5188: UPDATE hz_party_usg_assignments
5189: SET status_flag = 'M',
5190: effective_end_date = trunc(sysdate)
5191: WHERE owner_table_id = p_from_id

Line 5192: AND owner_table_name = 'HZ_RELATIONSHIPS'

5188: UPDATE hz_party_usg_assignments
5189: SET status_flag = 'M',
5190: effective_end_date = trunc(sysdate)
5191: WHERE owner_table_id = p_from_id
5192: AND owner_table_name = 'HZ_RELATIONSHIPS'
5193: AND party_id = p_from_fk_id;
5194:
5195: ----Start of DlProject Phase2--------------------
5196: do_hierarchy_nodes_merge(p_from_id => p_from_id,

Line 5242: UPDATE HZ_RELATIONSHIPS

5238: p_sub_obj_merge =>'OBJ'
5239: );
5240: ----End of DlProject Phase2--------------------
5241:
5242: UPDATE HZ_RELATIONSHIPS
5243: SET
5244: object_id = p_to_fk_id,
5245: status = 'I',
5246: end_date = sysdate,

Line 5261: UPDATE HZ_RELATIONSHIPS

5257: subject_type, object_type, party_id
5258: into l_subject_id, l_rel_type, l_rel_code,
5259: l_subject_type , l_object_type , l_rel_party_id;
5260:
5261: UPDATE HZ_RELATIONSHIPS
5262: SET
5263: subject_id = p_to_fk_id,
5264: status = 'I',
5265: end_date = sysdate,

Line 5306: FROM HZ_RELATIONSHIPS

5302:
5303: --6696774 Start
5304: SELECT subject_id, relationship_type, relationship_code,subject_type,object_type,direction_code into l_subject_id, l_rel_type, l_rel_code,
5305: l_subject_type, l_object_type, l_direction_code
5306: FROM HZ_RELATIONSHIPS
5307: WHERE relationship_id = p_from_id
5308: AND directional_flag = 'F';
5309:
5310: SELECT allow_relate_to_self_flag

Line 5346: UPDATE HZ_RELATIONSHIPS

5342: p_action => 'T',
5343: p_sub_obj_merge =>'OBJ'
5344: );
5345: ----End of DlProject Phase2--------------------
5346: UPDATE HZ_RELATIONSHIPS
5347: SET
5348: object_id = p_to_fk_id,
5349: last_update_date = hz_utility_pub.last_update_date,
5350: last_updated_by = hz_utility_pub.user_id,

Line 5363: UPDATE HZ_RELATIONSHIPS

5359: subject_type, object_type, party_id
5360: into l_subject_id, l_rel_type, l_rel_code,
5361: l_subject_type , l_object_type , l_rel_party_id;
5362:
5363: UPDATE HZ_RELATIONSHIPS
5364: SET
5365: subject_id = p_to_fk_id,
5366: last_update_date = hz_utility_pub.last_update_date,
5367: last_updated_by = hz_utility_pub.user_id,

Line 5401: UPDATE HZ_RELATIONSHIPS

5397: ELSIF (l_subject_id = p_to_fk_id AND l_self_rel_flag = 'N') OR l_par_exists = 'Y' THEN --bug 6696774
5398:
5399: IF l_self_rel_flag = 'N' THEN
5400: --Inactivate the relationships BOTH FORWARD AND BACKWARD
5401: UPDATE HZ_RELATIONSHIPS
5402: SET
5403: STATUS = 'I',
5404: END_DATE = sysdate,
5405: last_update_date = hz_utility_pub.last_update_date,

Line 5448: WHERE PARTY_ID in (select party_id from hz_relationships where subject_id=p_to_fk_id

5444: request_id = hz_utility_pub.request_id,
5445: program_application_id = hz_utility_pub.program_application_id,
5446: program_id = hz_utility_pub.program_id,
5447: program_update_date = sysdate
5448: WHERE PARTY_ID in (select party_id from hz_relationships where subject_id=p_to_fk_id
5449: and object_id=p_to_fk_id and relationship_id <>p_from_id and status='A'
5450: AND ((start_date between from_start_date and from_end_date)
5451: or (nvl(end_date,to_date('12/31/4712','MM/DD/YYYY')) between from_start_date and from_end_date)
5452: or(start_datefrom_end_date)));

Line 5455: UPDATE HZ_RELATIONSHIPS

5451: or (nvl(end_date,to_date('12/31/4712','MM/DD/YYYY')) between from_start_date and from_end_date)
5452: or(start_datefrom_end_date)));
5453: END IF;
5454:
5455: UPDATE HZ_RELATIONSHIPS
5456: SET
5457: STATUS = 'M',
5458: END_DATE = sysdate,
5459: last_update_date = hz_utility_pub.last_update_date,

Line 5466: WHERE relationship_id in (select relationship_id from hz_relationships where subject_id=p_to_fk_id

5462: request_id = hz_utility_pub.request_id,
5463: program_application_id = hz_utility_pub.program_application_id,
5464: program_id = hz_utility_pub.program_id,
5465: program_update_date = sysdate
5466: WHERE relationship_id in (select relationship_id from hz_relationships where subject_id=p_to_fk_id
5467: and object_id=p_to_fk_id and relationship_id <>p_from_id and status='A'
5468: AND ((start_date between from_start_date and from_end_date)
5469: or (nvl(end_date,to_date('12/31/4712','MM/DD/YYYY')) between from_start_date and from_end_date)
5470: or(start_datefrom_end_date)));

Line 5506: FROM HZ_RELATIONSHIPS

5502: ) IS
5503:
5504: CURSOR c_party(cp_party_reln_id NUMBER) IS
5505: SELECT party_id
5506: FROM HZ_RELATIONSHIPS
5507: WHERE relationship_id = cp_party_reln_id
5508: AND DIRECTIONAL_FLAG = 'F'
5509: and status in ('A','I'); -- bug 5094383
5510:

Line 5513: FROM HZ_RELATIONSHIPS

5509: and status in ('A','I'); -- bug 5094383
5510:
5511: CURSOR c_to_party_reln IS
5512: SELECT relationship_id
5513: FROM HZ_RELATIONSHIPS
5514: WHERE relationship_id = x_to_id
5515: FOR UPDATE NOWAIT;
5516:
5517: cursor c_start_end_date is

Line 5521: FROM HZ_RELATIONSHIPS

5517: cursor c_start_end_date is
5518: SELECT start_date, nvl(end_date,to_date('12/31/4712','MM/DD/YYYY')), actual_content_source, --5404244
5519: nvl(request_id,-1),
5520: NVL(status, 'A')
5521: FROM HZ_RELATIONSHIPS
5522: WHERE relationship_id = p_from_id
5523: AND DIRECTIONAL_FLAG='F';
5524:
5525: CURSOR c_check_valid_merge(from_start_date date, from_end_date date, from_cont_source_type VARCHAR2, from_cont_source VARCHAR2) IS

Line 5527: FROM HZ_RELATIONSHIPS

5523: AND DIRECTIONAL_FLAG='F';
5524:
5525: CURSOR c_check_valid_merge(from_start_date date, from_end_date date, from_cont_source_type VARCHAR2, from_cont_source VARCHAR2) IS
5526: SELECT relationship_id, nvl(request_id,-1), NVL(status, 'A')
5527: FROM HZ_RELATIONSHIPS
5528: WHERE subject_id = p_to_fk_id
5529: AND actual_content_source = DECODE(from_cont_source_type, 'PURCHASED', from_cont_source, actual_content_source) --5404244
5530: AND actual_content_source <> 'DNB'
5531: AND object_id = (

Line 5533: FROM HZ_RELATIONSHIPS

5529: AND actual_content_source = DECODE(from_cont_source_type, 'PURCHASED', from_cont_source, actual_content_source) --5404244
5530: AND actual_content_source <> 'DNB'
5531: AND object_id = (
5532: SELECT OBJECT_ID
5533: FROM HZ_RELATIONSHIPS
5534: WHERE relationship_id = p_from_id
5535: AND DIRECTIONAL_FLAG='F')
5536: AND object_id NOT IN
5537: ((SELECT from_party_id FROM hz_merge_parties WHERE to_party_id = p_to_fk_id AND merge_status='PENDING' )) --bug 4867151

Line 5542: FROM HZ_RELATIONSHIPS

5538: AND object_id NOT IN
5539: ((SELECT to_party_id FROM hz_merge_parties WHERE to_party_id = p_to_fk_id AND merge_status='PENDING' )) --bug 4867151
5540: AND relationship_type||relationship_code = (
5541: SELECT relationship_type||relationship_code -- Bug No: 4571969
5542: FROM HZ_RELATIONSHIPS
5543: WHERE relationship_id = p_from_id
5544: AND DIRECTIONAL_FLAG='F')
5545: AND DIRECTIONAL_FLAG = 'F'
5546: AND ((start_date between from_start_date and from_end_date)

Line 5567: l_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_TYPE%TYPE;

5563: --Bug 2619913 Do not allow self relationships creation unless
5564: --defined in the relationship type table
5565:
5566: l_object_id NUMBER;
5567: l_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_TYPE%TYPE;
5568: l_rel_code HZ_RELATIONSHIPS.RELATIONSHIP_CODE%TYPE;
5569: l_subject_type HZ_RELATIONSHIPS.SUBJECT_TYPE%TYPE;
5570: l_object_type HZ_RELATIONSHIPS.OBJECT_TYPE%TYPE;
5571: l_self_rel_flag VARCHAR2(1);

Line 5568: l_rel_code HZ_RELATIONSHIPS.RELATIONSHIP_CODE%TYPE;

5564: --defined in the relationship type table
5565:
5566: l_object_id NUMBER;
5567: l_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_TYPE%TYPE;
5568: l_rel_code HZ_RELATIONSHIPS.RELATIONSHIP_CODE%TYPE;
5569: l_subject_type HZ_RELATIONSHIPS.SUBJECT_TYPE%TYPE;
5570: l_object_type HZ_RELATIONSHIPS.OBJECT_TYPE%TYPE;
5571: l_self_rel_flag VARCHAR2(1);
5572:

Line 5569: l_subject_type HZ_RELATIONSHIPS.SUBJECT_TYPE%TYPE;

5565:
5566: l_object_id NUMBER;
5567: l_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_TYPE%TYPE;
5568: l_rel_code HZ_RELATIONSHIPS.RELATIONSHIP_CODE%TYPE;
5569: l_subject_type HZ_RELATIONSHIPS.SUBJECT_TYPE%TYPE;
5570: l_object_type HZ_RELATIONSHIPS.OBJECT_TYPE%TYPE;
5571: l_self_rel_flag VARCHAR2(1);
5572:
5573: l_rel_party_id HZ_RELATIONSHIPS.PARTY_ID%TYPE;

Line 5570: l_object_type HZ_RELATIONSHIPS.OBJECT_TYPE%TYPE;

5566: l_object_id NUMBER;
5567: l_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_TYPE%TYPE;
5568: l_rel_code HZ_RELATIONSHIPS.RELATIONSHIP_CODE%TYPE;
5569: l_subject_type HZ_RELATIONSHIPS.SUBJECT_TYPE%TYPE;
5570: l_object_type HZ_RELATIONSHIPS.OBJECT_TYPE%TYPE;
5571: l_self_rel_flag VARCHAR2(1);
5572:
5573: l_rel_party_id HZ_RELATIONSHIPS.PARTY_ID%TYPE;
5574: l_new_subj_party_name HZ_PARTIES.PARTY_NAME%TYPE;

Line 5573: l_rel_party_id HZ_RELATIONSHIPS.PARTY_ID%TYPE;

5569: l_subject_type HZ_RELATIONSHIPS.SUBJECT_TYPE%TYPE;
5570: l_object_type HZ_RELATIONSHIPS.OBJECT_TYPE%TYPE;
5571: l_self_rel_flag VARCHAR2(1);
5572:
5573: l_rel_party_id HZ_RELATIONSHIPS.PARTY_ID%TYPE;
5574: l_new_subj_party_name HZ_PARTIES.PARTY_NAME%TYPE;
5575: l_object_name HZ_PARTIES.PARTY_NAME%TYPE;
5576: l_rel_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;
5577: from_cont_source HZ_RELATIONSHIPS.ACTUAL_CONTENT_SOURCE%TYPE; --5404244

Line 5577: from_cont_source HZ_RELATIONSHIPS.ACTUAL_CONTENT_SOURCE%TYPE; --5404244

5573: l_rel_party_id HZ_RELATIONSHIPS.PARTY_ID%TYPE;
5574: l_new_subj_party_name HZ_PARTIES.PARTY_NAME%TYPE;
5575: l_object_name HZ_PARTIES.PARTY_NAME%TYPE;
5576: l_rel_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;
5577: from_cont_source HZ_RELATIONSHIPS.ACTUAL_CONTENT_SOURCE%TYPE; --5404244
5578: from_cont_source_type HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM_TYPE%TYPE;
5579:
5580: --6696774 start
5581: l_par_exists VARCHAR2(1);

Line 5582: l_direction_code HZ_RELATIONSHIPS.DIRECTION_CODE%TYPE;

5578: from_cont_source_type HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM_TYPE%TYPE;
5579:
5580: --6696774 start
5581: l_par_exists VARCHAR2(1);
5582: l_direction_code HZ_RELATIONSHIPS.DIRECTION_CODE%TYPE;
5583: --6696774 start END
5584: l_from_request_id NUMBER;
5585: l_to_rel_status VARCHAR2(1);
5586: l_from_rel_status VARCHAR2(1);

Line 5619: UPDATE HZ_RELATIONSHIPS

5615: END IF;
5616:
5617: IF l_from_party_id IS NOT NULL THEN
5618: OPEN c_to_party_reln;
5619: UPDATE HZ_RELATIONSHIPS
5620: SET
5621: party_id = l_from_party_id,
5622: last_update_date = hz_utility_pub.last_update_date,
5623: last_updated_by = hz_utility_pub.user_id,

Line 5633: UPDATE HZ_RELATIONSHIPS

5629: WHERE relationship_id = x_to_id;
5630: CLOSE c_to_party_reln;
5631: END IF;
5632:
5633: UPDATE HZ_RELATIONSHIPS
5634: SET
5635: STATUS = 'M',
5636: end_date = sysdate,
5637: last_update_date = hz_utility_pub.last_update_date,

Line 5647: --4307667 merge usages with owner_table_name 'HZ_RELATIONSHIPS'

5643: program_update_date = sysdate
5644: WHERE relationship_id = p_from_id;
5645:
5646:
5647: --4307667 merge usages with owner_table_name 'HZ_RELATIONSHIPS'
5648: UPDATE hz_party_usg_assignments
5649: SET status_flag = 'M',
5650: effective_end_date = trunc(sysdate)
5651: WHERE owner_table_id = p_from_id

Line 5652: AND owner_table_name = 'HZ_RELATIONSHIPS'

5648: UPDATE hz_party_usg_assignments
5649: SET status_flag = 'M',
5650: effective_end_date = trunc(sysdate)
5651: WHERE owner_table_id = p_from_id
5652: AND owner_table_name = 'HZ_RELATIONSHIPS'
5653: AND party_id = p_from_fk_id;
5654:
5655: ----Start of DlProject Phase2--------------------
5656: do_hierarchy_nodes_merge(p_from_id => p_from_id,

Line 5704: UPDATE HZ_RELATIONSHIPS

5700: p_sub_obj_merge =>'SUB'
5701: );
5702: ----End of DlProject Phase2--------------------
5703:
5704: UPDATE HZ_RELATIONSHIPS
5705: SET
5706: subject_id = p_to_fk_id,
5707: status = 'I',
5708: end_date = sysdate,

Line 5723: UPDATE HZ_RELATIONSHIPS

5719: subject_type, object_type, party_id
5720: into l_object_id, l_rel_type, l_rel_code,
5721: l_subject_type , l_object_type, l_rel_party_id;
5722:
5723: UPDATE HZ_RELATIONSHIPS
5724: SET
5725: object_id = p_to_fk_id,
5726: status = 'I',
5727: end_date = sysdate,

Line 5767: FROM HZ_RELATIONSHIPS

5763:
5764: --6696774 Start
5765: SELECT object_id, relationship_type, relationship_code,subject_type,object_type,direction_code into l_object_id, l_rel_type, l_rel_code,
5766: l_subject_type, l_object_type, l_direction_code
5767: FROM HZ_RELATIONSHIPS
5768: WHERE relationship_id = p_from_id
5769: AND directional_flag = 'F';
5770:
5771: l_par_exists := 'N';

Line 5805: UPDATE HZ_RELATIONSHIPS

5801: p_sub_obj_merge =>'SUB'
5802: );
5803: ----End of DlProject Phase2--------------------
5804:
5805: UPDATE HZ_RELATIONSHIPS
5806: SET
5807: subject_id = p_to_fk_id,
5808: last_update_date = hz_utility_pub.last_update_date,
5809: last_updated_by = hz_utility_pub.user_id,

Line 5822: UPDATE HZ_RELATIONSHIPS

5818: subject_type, object_type, party_id
5819: into l_object_id, l_rel_type, l_rel_code,
5820: l_subject_type , l_object_type, l_rel_party_id;
5821:
5822: UPDATE HZ_RELATIONSHIPS
5823: SET
5824: object_id = p_to_fk_id,
5825: last_update_date = hz_utility_pub.last_update_date,
5826: last_updated_by = hz_utility_pub.user_id,

Line 5860: UPDATE HZ_RELATIONSHIPS

5856: ELSIF (l_object_id = p_to_fk_id AND l_self_rel_flag = 'N') OR l_par_exists = 'Y' THEN --5591581
5857:
5858: IF l_self_rel_flag = 'N' THEN
5859: --Inactivate the relationships both forward and backward
5860: UPDATE HZ_RELATIONSHIPS
5861: SET
5862: STATUS = 'I',
5863: END_DATE = sysdate,
5864: last_update_date = hz_utility_pub.last_update_date,

Line 5908: WHERE PARTY_ID IN (select party_id from hz_relationships where subject_id=p_to_fk_id

5904: request_id = hz_utility_pub.request_id,
5905: program_application_id = hz_utility_pub.program_application_id,
5906: program_id = hz_utility_pub.program_id,
5907: program_update_date = sysdate
5908: WHERE PARTY_ID IN (select party_id from hz_relationships where subject_id=p_to_fk_id
5909: and object_id=p_to_fk_id and relationship_id <>p_from_id and status='A'
5910: AND ((start_date between from_start_date and from_end_date)
5911: or (nvl(end_date,to_date('12/31/4712','MM/DD/YYYY')) between from_start_date and from_end_date)
5912: or(start_datefrom_end_date)));

Line 5914: UPDATE HZ_RELATIONSHIPS

5910: AND ((start_date between from_start_date and from_end_date)
5911: or (nvl(end_date,to_date('12/31/4712','MM/DD/YYYY')) between from_start_date and from_end_date)
5912: or(start_datefrom_end_date)));
5913:
5914: UPDATE HZ_RELATIONSHIPS
5915: SET
5916: STATUS = 'M',
5917: END_DATE = sysdate,
5918: last_update_date = hz_utility_pub.last_update_date,

Line 5925: WHERE relationship_id in (select relationship_id from hz_relationships where subject_id=p_to_fk_id

5921: request_id = hz_utility_pub.request_id,
5922: program_application_id = hz_utility_pub.program_application_id,
5923: program_id = hz_utility_pub.program_id,
5924: program_update_date = sysdate
5925: WHERE relationship_id in (select relationship_id from hz_relationships where subject_id=p_to_fk_id
5926: and object_id=p_to_fk_id and relationship_id <>p_from_id and status='A'
5927: AND ((start_date between from_start_date and from_end_date)
5928: or (nvl(end_date,to_date('12/31/4712','MM/DD/YYYY')) between from_start_date and from_end_date)
5929: or(start_datefrom_end_date)));

Line 5963: FROM HZ_RELATIONSHIPS --4500011

5959: ) IS
5960:
5961: CURSOR c_merge_to_party_reln IS
5962: SELECT relationship_id
5963: FROM HZ_RELATIONSHIPS --4500011
5964: WHERE party_id = p_to_fk_id
5965: AND subject_table_name = 'HZ_PARTIES'
5966: AND object_table_name = 'HZ_PARTIES'
5967: AND directional_flag = 'F';

Line 5985: UPDATE HZ_RELATIONSHIPS

5981: x_return_status := FND_API.G_RET_STS_ERROR;
5982: ELSE
5983: CLOSE c_merge_to_party_reln;
5984:
5985: UPDATE HZ_RELATIONSHIPS
5986: SET
5987: STATUS = 'M',
5988: end_date = sysdate,
5989: last_update_date = hz_utility_pub.last_update_date,

Line 6363: hz_relationships r

6359: AND ps1.location_id = l_from_location_id
6360: AND merge_from_entity_id <> p_from_id
6361: AND mpd.batch_party_id IN ( SELECT batch_party_id
6362: FROM hz_merge_parties mp,
6363: hz_relationships r
6364: WHERE r.party_id = p_from_fk_id
6365: AND mp.from_party_id = r.object_id
6366: AND mp.batch_id = p_batch_id)
6367: AND rownum = 1;

Line 6425: hz_relationships r

6421: SELECT psr.party_site_id
6422: FROM hz_parties p,
6423: hz_party_sites psr,
6424: hz_party_sites pso,
6425: hz_relationships r
6426: WHERE pso.party_site_id = p_from_id
6427: AND r.object_id = pso.party_id
6428: AND r.party_id = p.party_id
6429: AND p.party_id = psr.party_id

Line 6484: (select ps.party_id from hz_party_sites ps,hz_relationships pr

6480: state = l_state,
6481: province = l_province,
6482: county = l_county
6483: WHERE party_id in
6484: (select ps.party_id from hz_party_sites ps,hz_relationships pr
6485: where ps.location_id = l_to_location_id
6486: and ps.identifying_address_flag(+)='Y'
6487: and ps.party_id = pr.party_id
6488: and pr.object_id=l_to_party_id);

Line 6747: FROM HZ_RELATIONSHIPS --4500011

6743: AND nvl(status, 'A') = 'A';
6744:
6745: CURSOR c_branch IS
6746: SELECT 1
6747: FROM HZ_RELATIONSHIPS --4500011
6748: WHERE content_source_type = 'DNB'
6749: AND subject_id = p_from_id
6750: AND object_id = x_to_id
6751: AND RELATIONSHIP_CODE = 'HEADQUARTERS_OF'

Line 7039: FROM HZ_RELATIONSHIPS

7035: CURSOR c_relship_det(cp_relship_id NUMBER) IS
7036: SELECT relationship_type,subject_id,subject_table_name,subject_type,
7037: object_id,object_table_name,object_type,start_date,
7038: direction_code,status,end_date
7039: FROM HZ_RELATIONSHIPS
7040: WHERE relationship_id = cp_relship_id
7041: AND DIRECTIONAL_FLAG = 'F';
7042:
7043: --5547536

Line 7067: l_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_TYPE%TYPE;

7063: l_msg_count NUMBER;
7064: l_msg_data VARCHAR2(2000);
7065: l_return_status VARCHAR2(10);
7066: l_status VARCHAR2(1);
7067: l_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_TYPE%TYPE;
7068: l_rel_code HZ_RELATIONSHIPS.RELATIONSHIP_CODE%TYPE;
7069: l_subject_type HZ_RELATIONSHIPS.SUBJECT_TYPE%TYPE;
7070: l_object_type HZ_RELATIONSHIPS.OBJECT_TYPE%TYPE;
7071: from_end_date date;

Line 7068: l_rel_code HZ_RELATIONSHIPS.RELATIONSHIP_CODE%TYPE;

7064: l_msg_data VARCHAR2(2000);
7065: l_return_status VARCHAR2(10);
7066: l_status VARCHAR2(1);
7067: l_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_TYPE%TYPE;
7068: l_rel_code HZ_RELATIONSHIPS.RELATIONSHIP_CODE%TYPE;
7069: l_subject_type HZ_RELATIONSHIPS.SUBJECT_TYPE%TYPE;
7070: l_object_type HZ_RELATIONSHIPS.OBJECT_TYPE%TYPE;
7071: from_end_date date;
7072: --5547536

Line 7069: l_subject_type HZ_RELATIONSHIPS.SUBJECT_TYPE%TYPE;

7065: l_return_status VARCHAR2(10);
7066: l_status VARCHAR2(1);
7067: l_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_TYPE%TYPE;
7068: l_rel_code HZ_RELATIONSHIPS.RELATIONSHIP_CODE%TYPE;
7069: l_subject_type HZ_RELATIONSHIPS.SUBJECT_TYPE%TYPE;
7070: l_object_type HZ_RELATIONSHIPS.OBJECT_TYPE%TYPE;
7071: from_end_date date;
7072: --5547536
7073: l_multiple_parent_flag VARCHAR2(1);

Line 7070: l_object_type HZ_RELATIONSHIPS.OBJECT_TYPE%TYPE;

7066: l_status VARCHAR2(1);
7067: l_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_TYPE%TYPE;
7068: l_rel_code HZ_RELATIONSHIPS.RELATIONSHIP_CODE%TYPE;
7069: l_subject_type HZ_RELATIONSHIPS.SUBJECT_TYPE%TYPE;
7070: l_object_type HZ_RELATIONSHIPS.OBJECT_TYPE%TYPE;
7071: from_end_date date;
7072: --5547536
7073: l_multiple_parent_flag VARCHAR2(1);
7074: l_from_par_id NUMBER;