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

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

Line 4056: HZ_RELATIONSHIPS PR2,

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

Line 5043: FROM HZ_RELATIONSHIPS

5039: ) IS
5040:
5041: CURSOR c_party(cp_party_reln_id NUMBER) IS
5042: SELECT party_id
5043: FROM HZ_RELATIONSHIPS
5044: WHERE relationship_id = cp_party_reln_id
5045: AND DIRECTIONAL_FLAG = 'F'
5046: and status in ('A','I'); -- bug 5094383
5047:

Line 5050: FROM HZ_RELATIONSHIPS

5046: and status in ('A','I'); -- bug 5094383
5047:
5048: CURSOR c_to_party_reln IS
5049: SELECT relationship_id
5050: FROM HZ_RELATIONSHIPS
5051: WHERE relationship_id = x_to_id
5052: FOR UPDATE NOWAIT;
5053:
5054: cursor c_start_end_date is

Line 5056: FROM HZ_RELATIONSHIPS

5052: FOR UPDATE NOWAIT;
5053:
5054: cursor c_start_end_date is
5055: SELECT start_date, nvl(end_date,to_date('12/31/4712','MM/DD/YYYY')), actual_content_source --5404244
5056: FROM HZ_RELATIONSHIPS
5057: WHERE relationship_id = p_from_id
5058: AND DIRECTIONAL_FLAG='F';
5059:
5060: CURSOR c_check_valid_merge(from_start_date date, from_end_date date, from_cont_source_type VARCHAR2, from_cont_source VARCHAR2) IS

Line 5062: FROM HZ_RELATIONSHIPS

5058: AND DIRECTIONAL_FLAG='F';
5059:
5060: CURSOR c_check_valid_merge(from_start_date date, from_end_date date, from_cont_source_type VARCHAR2, from_cont_source VARCHAR2) IS
5061: SELECT relationship_id, nvl(request_id,-1)
5062: FROM HZ_RELATIONSHIPS
5063: WHERE object_id = p_to_fk_id
5064: AND actual_content_source = DECODE(from_cont_source_type, 'PURCHASED', from_cont_source, actual_content_source) --5404244
5065: AND subject_id = (
5066: SELECT SUBJECT_ID

Line 5067: FROM HZ_RELATIONSHIPS

5063: WHERE object_id = p_to_fk_id
5064: AND actual_content_source = DECODE(from_cont_source_type, 'PURCHASED', from_cont_source, actual_content_source) --5404244
5065: AND subject_id = (
5066: SELECT SUBJECT_ID
5067: FROM HZ_RELATIONSHIPS
5068: WHERE relationship_id = p_from_id
5069: AND DIRECTIONAL_FLAG='F')
5070: AND subject_id NOT IN
5071: ((SELECT from_party_id FROM hz_merge_parties WHERE to_party_id = p_to_fk_id AND merge_status='PENDING' )) --bug 4867151

Line 5076: FROM HZ_RELATIONSHIPS

5072: AND subject_id NOT IN
5073: ((SELECT to_party_id FROM hz_merge_parties WHERE to_party_id = p_to_fk_id AND merge_status='PENDING' )) --bug 4867151
5074: AND relationship_code = (
5075: SELECT relationship_code -- Bug No: 4571969
5076: FROM HZ_RELATIONSHIPS
5077: WHERE relationship_id = p_from_id
5078: AND DIRECTIONAL_FLAG='F')
5079: AND DIRECTIONAL_FLAG = 'F'
5080: AND ((start_date between from_start_date and from_end_date)

Line 5102: l_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_TYPE%TYPE;

5098: --Bug 2619913 Do not allow self relationships creation unless
5099: --defined in the relationship type table
5100:
5101: l_subject_id NUMBER;
5102: l_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_TYPE%TYPE;
5103: l_rel_code HZ_RELATIONSHIPS.RELATIONSHIP_CODE%TYPE;
5104: l_subject_type HZ_RELATIONSHIPS.SUBJECT_TYPE%TYPE;
5105: l_object_type HZ_RELATIONSHIPS.OBJECT_TYPE%TYPE;
5106: l_self_rel_flag VARCHAR2(1);

Line 5103: l_rel_code HZ_RELATIONSHIPS.RELATIONSHIP_CODE%TYPE;

5099: --defined in the relationship type table
5100:
5101: l_subject_id NUMBER;
5102: l_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_TYPE%TYPE;
5103: l_rel_code HZ_RELATIONSHIPS.RELATIONSHIP_CODE%TYPE;
5104: l_subject_type HZ_RELATIONSHIPS.SUBJECT_TYPE%TYPE;
5105: l_object_type HZ_RELATIONSHIPS.OBJECT_TYPE%TYPE;
5106: l_self_rel_flag VARCHAR2(1);
5107:

Line 5104: l_subject_type HZ_RELATIONSHIPS.SUBJECT_TYPE%TYPE;

5100:
5101: l_subject_id NUMBER;
5102: l_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_TYPE%TYPE;
5103: l_rel_code HZ_RELATIONSHIPS.RELATIONSHIP_CODE%TYPE;
5104: l_subject_type HZ_RELATIONSHIPS.SUBJECT_TYPE%TYPE;
5105: l_object_type HZ_RELATIONSHIPS.OBJECT_TYPE%TYPE;
5106: l_self_rel_flag VARCHAR2(1);
5107:
5108: l_rel_party_id HZ_RELATIONSHIPS.PARTY_ID%TYPE;

Line 5105: l_object_type HZ_RELATIONSHIPS.OBJECT_TYPE%TYPE;

5101: l_subject_id NUMBER;
5102: l_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_TYPE%TYPE;
5103: l_rel_code HZ_RELATIONSHIPS.RELATIONSHIP_CODE%TYPE;
5104: l_subject_type HZ_RELATIONSHIPS.SUBJECT_TYPE%TYPE;
5105: l_object_type HZ_RELATIONSHIPS.OBJECT_TYPE%TYPE;
5106: l_self_rel_flag VARCHAR2(1);
5107:
5108: l_rel_party_id HZ_RELATIONSHIPS.PARTY_ID%TYPE;
5109: l_new_obj_party_name HZ_PARTIES.PARTY_NAME%TYPE;

Line 5108: l_rel_party_id HZ_RELATIONSHIPS.PARTY_ID%TYPE;

5104: l_subject_type HZ_RELATIONSHIPS.SUBJECT_TYPE%TYPE;
5105: l_object_type HZ_RELATIONSHIPS.OBJECT_TYPE%TYPE;
5106: l_self_rel_flag VARCHAR2(1);
5107:
5108: l_rel_party_id HZ_RELATIONSHIPS.PARTY_ID%TYPE;
5109: l_new_obj_party_name HZ_PARTIES.PARTY_NAME%TYPE;
5110: l_subject_name HZ_PARTIES.PARTY_NAME%TYPE;
5111: l_rel_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;
5112: from_cont_source HZ_RELATIONSHIPS.ACTUAL_CONTENT_SOURCE%TYPE; --5404244

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

5108: l_rel_party_id HZ_RELATIONSHIPS.PARTY_ID%TYPE;
5109: l_new_obj_party_name HZ_PARTIES.PARTY_NAME%TYPE;
5110: l_subject_name HZ_PARTIES.PARTY_NAME%TYPE;
5111: l_rel_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;
5112: from_cont_source HZ_RELATIONSHIPS.ACTUAL_CONTENT_SOURCE%TYPE; --5404244
5113: from_cont_source_type HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM_TYPE%TYPE;
5114:
5115: --6696774 Start
5116: l_par_exists VARCHAR2(1);

Line 5117: l_direction_code HZ_RELATIONSHIPS.DIRECTION_CODE%TYPE;

5113: from_cont_source_type HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM_TYPE%TYPE;
5114:
5115: --6696774 Start
5116: l_par_exists VARCHAR2(1);
5117: l_direction_code HZ_RELATIONSHIPS.DIRECTION_CODE%TYPE;
5118: --6696774 end
5119: BEGIN
5120:
5121: IF (x_to_id <> FND_API.G_MISS_NUM AND x_to_id <> p_from_id) THEN

Line 5148: UPDATE HZ_RELATIONSHIPS

5144: END IF;
5145:
5146: IF l_from_party_id IS NOT NULL THEN
5147: OPEN c_to_party_reln;
5148: UPDATE HZ_RELATIONSHIPS
5149: SET
5150: party_id = l_from_party_id,
5151: last_update_date = hz_utility_pub.last_update_date,
5152: last_updated_by = hz_utility_pub.user_id,

Line 5162: UPDATE HZ_RELATIONSHIPS

5158: WHERE relationship_id = x_to_id;
5159: CLOSE c_to_party_reln;
5160: END IF;
5161:
5162: UPDATE HZ_RELATIONSHIPS
5163: SET
5164: STATUS = 'M',
5165: last_update_date = hz_utility_pub.last_update_date,
5166: last_updated_by = hz_utility_pub.user_id,

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

5170: program_id = hz_utility_pub.program_id,
5171: program_update_date = sysdate
5172: WHERE relationship_id = p_from_id;
5173:
5174: --4307667 merge usages with owner_table_name 'HZ_RELATIONSHIPS'
5175: UPDATE hz_party_usg_assignments
5176: SET status_flag = 'M',
5177: effective_end_date = trunc(sysdate)
5178: WHERE owner_table_id = p_from_id

Line 5179: AND owner_table_name = 'HZ_RELATIONSHIPS'

5175: UPDATE hz_party_usg_assignments
5176: SET status_flag = 'M',
5177: effective_end_date = trunc(sysdate)
5178: WHERE owner_table_id = p_from_id
5179: AND owner_table_name = 'HZ_RELATIONSHIPS'
5180: AND party_id = p_from_fk_id;
5181:
5182: ----Start of DlProject Phase2--------------------
5183: do_hierarchy_nodes_merge(p_from_id => p_from_id,

Line 5216: FROM HZ_RELATIONSHIPS

5212:
5213: --6696774 Start
5214: SELECT subject_id, relationship_type, relationship_code,subject_type,object_type,direction_code into l_subject_id, l_rel_type, l_rel_code,
5215: l_subject_type, l_object_type, l_direction_code
5216: FROM HZ_RELATIONSHIPS
5217: WHERE relationship_id = p_from_id
5218: AND directional_flag = 'F';
5219:
5220: SELECT allow_relate_to_self_flag

Line 5256: UPDATE HZ_RELATIONSHIPS

5252: p_action => 'T',
5253: p_sub_obj_merge =>'OBJ'
5254: );
5255: ----End of DlProject Phase2--------------------
5256: UPDATE HZ_RELATIONSHIPS
5257: SET
5258: object_id = p_to_fk_id,
5259: last_update_date = hz_utility_pub.last_update_date,
5260: last_updated_by = hz_utility_pub.user_id,

Line 5273: UPDATE HZ_RELATIONSHIPS

5269: subject_type, object_type, party_id
5270: into l_subject_id, l_rel_type, l_rel_code,
5271: l_subject_type , l_object_type , l_rel_party_id;
5272:
5273: UPDATE HZ_RELATIONSHIPS
5274: SET
5275: subject_id = p_to_fk_id,
5276: last_update_date = hz_utility_pub.last_update_date,
5277: last_updated_by = hz_utility_pub.user_id,

Line 5322: UPDATE HZ_RELATIONSHIPS

5318: AND OBJECT_TYPE = l_object_type;
5319:
5320: IF l_self_rel_flag = 'N' THEN
5321: --Inactivate the relationships BOTH FORWARD AND BACKWARD
5322: UPDATE HZ_RELATIONSHIPS
5323: SET
5324: STATUS = 'I',
5325: END_DATE = sysdate,
5326: last_update_date = hz_utility_pub.last_update_date,

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

5364: request_id = hz_utility_pub.request_id,
5365: program_application_id = hz_utility_pub.program_application_id,
5366: program_id = hz_utility_pub.program_id,
5367: program_update_date = sysdate
5368: WHERE PARTY_ID in (select party_id from hz_relationships where subject_id=p_to_fk_id
5369: and object_id=p_to_fk_id and relationship_id <>p_from_id and status='A'
5370: AND ((start_date between from_start_date and from_end_date)
5371: or (nvl(end_date,to_date('12/31/4712','MM/DD/YYYY')) between from_start_date and from_end_date)
5372: or(start_datefrom_end_date)));

Line 5375: UPDATE HZ_RELATIONSHIPS

5371: or (nvl(end_date,to_date('12/31/4712','MM/DD/YYYY')) between from_start_date and from_end_date)
5372: or(start_datefrom_end_date)));
5373: END IF;
5374:
5375: UPDATE HZ_RELATIONSHIPS
5376: SET
5377: STATUS = 'M',
5378: END_DATE = sysdate,
5379: last_update_date = hz_utility_pub.last_update_date,

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

5382: request_id = hz_utility_pub.request_id,
5383: program_application_id = hz_utility_pub.program_application_id,
5384: program_id = hz_utility_pub.program_id,
5385: program_update_date = sysdate
5386: WHERE relationship_id in (select relationship_id from hz_relationships where subject_id=p_to_fk_id
5387: and object_id=p_to_fk_id and relationship_id <>p_from_id and status='A'
5388: AND ((start_date between from_start_date and from_end_date)
5389: or (nvl(end_date,to_date('12/31/4712','MM/DD/YYYY')) between from_start_date and from_end_date)
5390: or(start_datefrom_end_date)));

Line 5436: FROM HZ_RELATIONSHIPS

5432: ) IS
5433:
5434: CURSOR c_party(cp_party_reln_id NUMBER) IS
5435: SELECT party_id
5436: FROM HZ_RELATIONSHIPS
5437: WHERE relationship_id = cp_party_reln_id
5438: AND DIRECTIONAL_FLAG = 'F'
5439: and status in ('A','I'); -- bug 5094383
5440:

Line 5443: FROM HZ_RELATIONSHIPS

5439: and status in ('A','I'); -- bug 5094383
5440:
5441: CURSOR c_to_party_reln IS
5442: SELECT relationship_id
5443: FROM HZ_RELATIONSHIPS
5444: WHERE relationship_id = x_to_id
5445: FOR UPDATE NOWAIT;
5446:
5447: cursor c_start_end_date is

Line 5449: FROM HZ_RELATIONSHIPS

5445: FOR UPDATE NOWAIT;
5446:
5447: cursor c_start_end_date is
5448: SELECT start_date, nvl(end_date,to_date('12/31/4712','MM/DD/YYYY')), actual_content_source --5404244
5449: FROM HZ_RELATIONSHIPS
5450: WHERE relationship_id = p_from_id
5451: AND DIRECTIONAL_FLAG='F';
5452:
5453: CURSOR c_check_valid_merge(from_start_date date, from_end_date date, from_cont_source_type VARCHAR2, from_cont_source VARCHAR2) IS

Line 5455: FROM HZ_RELATIONSHIPS

5451: AND DIRECTIONAL_FLAG='F';
5452:
5453: CURSOR c_check_valid_merge(from_start_date date, from_end_date date, from_cont_source_type VARCHAR2, from_cont_source VARCHAR2) IS
5454: SELECT relationship_id, nvl(request_id,-1)
5455: FROM HZ_RELATIONSHIPS
5456: WHERE subject_id = p_to_fk_id
5457: AND actual_content_source = DECODE(from_cont_source_type, 'PURCHASED', from_cont_source, actual_content_source) --5404244
5458: AND object_id = (
5459: SELECT OBJECT_ID

Line 5460: FROM HZ_RELATIONSHIPS

5456: WHERE subject_id = p_to_fk_id
5457: AND actual_content_source = DECODE(from_cont_source_type, 'PURCHASED', from_cont_source, actual_content_source) --5404244
5458: AND object_id = (
5459: SELECT OBJECT_ID
5460: FROM HZ_RELATIONSHIPS
5461: WHERE relationship_id = p_from_id
5462: AND DIRECTIONAL_FLAG='F')
5463: AND object_id NOT IN
5464: ((SELECT from_party_id FROM hz_merge_parties WHERE to_party_id = p_to_fk_id AND merge_status='PENDING' )) --bug 4867151

Line 5469: FROM HZ_RELATIONSHIPS

5465: AND object_id NOT IN
5466: ((SELECT to_party_id FROM hz_merge_parties WHERE to_party_id = p_to_fk_id AND merge_status='PENDING' )) --bug 4867151
5467: AND relationship_code = (
5468: SELECT relationship_code -- Bug No: 4571969
5469: FROM HZ_RELATIONSHIPS
5470: WHERE relationship_id = p_from_id
5471: AND DIRECTIONAL_FLAG='F')
5472: AND DIRECTIONAL_FLAG = 'F'
5473: AND ((start_date between from_start_date and from_end_date)

Line 5494: l_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_TYPE%TYPE;

5490: --Bug 2619913 Do not allow self relationships creation unless
5491: --defined in the relationship type table
5492:
5493: l_object_id NUMBER;
5494: l_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_TYPE%TYPE;
5495: l_rel_code HZ_RELATIONSHIPS.RELATIONSHIP_CODE%TYPE;
5496: l_subject_type HZ_RELATIONSHIPS.SUBJECT_TYPE%TYPE;
5497: l_object_type HZ_RELATIONSHIPS.OBJECT_TYPE%TYPE;
5498: l_self_rel_flag VARCHAR2(1);

Line 5495: l_rel_code HZ_RELATIONSHIPS.RELATIONSHIP_CODE%TYPE;

5491: --defined in the relationship type table
5492:
5493: l_object_id NUMBER;
5494: l_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_TYPE%TYPE;
5495: l_rel_code HZ_RELATIONSHIPS.RELATIONSHIP_CODE%TYPE;
5496: l_subject_type HZ_RELATIONSHIPS.SUBJECT_TYPE%TYPE;
5497: l_object_type HZ_RELATIONSHIPS.OBJECT_TYPE%TYPE;
5498: l_self_rel_flag VARCHAR2(1);
5499:

Line 5496: l_subject_type HZ_RELATIONSHIPS.SUBJECT_TYPE%TYPE;

5492:
5493: l_object_id NUMBER;
5494: l_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_TYPE%TYPE;
5495: l_rel_code HZ_RELATIONSHIPS.RELATIONSHIP_CODE%TYPE;
5496: l_subject_type HZ_RELATIONSHIPS.SUBJECT_TYPE%TYPE;
5497: l_object_type HZ_RELATIONSHIPS.OBJECT_TYPE%TYPE;
5498: l_self_rel_flag VARCHAR2(1);
5499:
5500: l_rel_party_id HZ_RELATIONSHIPS.PARTY_ID%TYPE;

Line 5497: l_object_type HZ_RELATIONSHIPS.OBJECT_TYPE%TYPE;

5493: l_object_id NUMBER;
5494: l_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_TYPE%TYPE;
5495: l_rel_code HZ_RELATIONSHIPS.RELATIONSHIP_CODE%TYPE;
5496: l_subject_type HZ_RELATIONSHIPS.SUBJECT_TYPE%TYPE;
5497: l_object_type HZ_RELATIONSHIPS.OBJECT_TYPE%TYPE;
5498: l_self_rel_flag VARCHAR2(1);
5499:
5500: l_rel_party_id HZ_RELATIONSHIPS.PARTY_ID%TYPE;
5501: l_new_subj_party_name HZ_PARTIES.PARTY_NAME%TYPE;

Line 5500: l_rel_party_id HZ_RELATIONSHIPS.PARTY_ID%TYPE;

5496: l_subject_type HZ_RELATIONSHIPS.SUBJECT_TYPE%TYPE;
5497: l_object_type HZ_RELATIONSHIPS.OBJECT_TYPE%TYPE;
5498: l_self_rel_flag VARCHAR2(1);
5499:
5500: l_rel_party_id HZ_RELATIONSHIPS.PARTY_ID%TYPE;
5501: l_new_subj_party_name HZ_PARTIES.PARTY_NAME%TYPE;
5502: l_object_name HZ_PARTIES.PARTY_NAME%TYPE;
5503: l_rel_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;
5504: from_cont_source HZ_RELATIONSHIPS.ACTUAL_CONTENT_SOURCE%TYPE; --5404244

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

5500: l_rel_party_id HZ_RELATIONSHIPS.PARTY_ID%TYPE;
5501: l_new_subj_party_name HZ_PARTIES.PARTY_NAME%TYPE;
5502: l_object_name HZ_PARTIES.PARTY_NAME%TYPE;
5503: l_rel_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;
5504: from_cont_source HZ_RELATIONSHIPS.ACTUAL_CONTENT_SOURCE%TYPE; --5404244
5505: from_cont_source_type HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM_TYPE%TYPE;
5506:
5507: --6696774 start
5508: l_par_exists VARCHAR2(1);

Line 5509: l_direction_code HZ_RELATIONSHIPS.DIRECTION_CODE%TYPE;

5505: from_cont_source_type HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM_TYPE%TYPE;
5506:
5507: --6696774 start
5508: l_par_exists VARCHAR2(1);
5509: l_direction_code HZ_RELATIONSHIPS.DIRECTION_CODE%TYPE;
5510: --6696774 start END
5511: BEGIN
5512:
5513: IF (x_to_id <> FND_API.G_MISS_NUM AND x_to_id <> p_from_id) THEN

Line 5542: UPDATE HZ_RELATIONSHIPS

5538: END IF;
5539:
5540: IF l_from_party_id IS NOT NULL THEN
5541: OPEN c_to_party_reln;
5542: UPDATE HZ_RELATIONSHIPS
5543: SET
5544: party_id = l_from_party_id,
5545: last_update_date = hz_utility_pub.last_update_date,
5546: last_updated_by = hz_utility_pub.user_id,

Line 5556: UPDATE HZ_RELATIONSHIPS

5552: WHERE relationship_id = x_to_id;
5553: CLOSE c_to_party_reln;
5554: END IF;
5555:
5556: UPDATE HZ_RELATIONSHIPS
5557: SET
5558: STATUS = 'M',
5559: last_update_date = hz_utility_pub.last_update_date,
5560: last_updated_by = hz_utility_pub.user_id,

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

5565: program_update_date = sysdate
5566: WHERE relationship_id = p_from_id;
5567:
5568:
5569: --4307667 merge usages with owner_table_name 'HZ_RELATIONSHIPS'
5570: UPDATE hz_party_usg_assignments
5571: SET status_flag = 'M',
5572: effective_end_date = trunc(sysdate)
5573: WHERE owner_table_id = p_from_id

Line 5574: AND owner_table_name = 'HZ_RELATIONSHIPS'

5570: UPDATE hz_party_usg_assignments
5571: SET status_flag = 'M',
5572: effective_end_date = trunc(sysdate)
5573: WHERE owner_table_id = p_from_id
5574: AND owner_table_name = 'HZ_RELATIONSHIPS'
5575: AND party_id = p_from_fk_id;
5576:
5577: ----Start of DlProject Phase2--------------------
5578: do_hierarchy_nodes_merge(p_from_id => p_from_id,

Line 5615: FROM HZ_RELATIONSHIPS

5611: CLOSE c_check_valid_merge;
5612: --6696774 Start
5613: SELECT object_id, relationship_type, relationship_code,subject_type,object_type,direction_code into l_object_id, l_rel_type, l_rel_code,
5614: l_subject_type, l_object_type, l_direction_code
5615: FROM HZ_RELATIONSHIPS
5616: WHERE relationship_id = p_from_id
5617: AND directional_flag = 'F';
5618:
5619: l_par_exists := 'N';

Line 5653: UPDATE HZ_RELATIONSHIPS

5649: p_sub_obj_merge =>'SUB'
5650: );
5651: ----End of DlProject Phase2--------------------
5652:
5653: UPDATE HZ_RELATIONSHIPS
5654: SET
5655: subject_id = p_to_fk_id,
5656: last_update_date = hz_utility_pub.last_update_date,
5657: last_updated_by = hz_utility_pub.user_id,

Line 5670: UPDATE HZ_RELATIONSHIPS

5666: subject_type, object_type, party_id
5667: into l_object_id, l_rel_type, l_rel_code,
5668: l_subject_type , l_object_type, l_rel_party_id;
5669:
5670: UPDATE HZ_RELATIONSHIPS
5671: SET
5672: object_id = p_to_fk_id,
5673: last_update_date = hz_utility_pub.last_update_date,
5674: last_updated_by = hz_utility_pub.user_id,

Line 5721: UPDATE HZ_RELATIONSHIPS

5717: AND OBJECT_TYPE = l_object_type;
5718:
5719: IF l_self_rel_flag = 'N' THEN
5720: --Inactivate the relationships both forward and backward
5721: UPDATE HZ_RELATIONSHIPS
5722: SET
5723: STATUS = 'I',
5724: END_DATE = sysdate,
5725: last_update_date = hz_utility_pub.last_update_date,

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

5764: request_id = hz_utility_pub.request_id,
5765: program_application_id = hz_utility_pub.program_application_id,
5766: program_id = hz_utility_pub.program_id,
5767: program_update_date = sysdate
5768: WHERE PARTY_ID IN (select party_id from hz_relationships where subject_id=p_to_fk_id
5769: and object_id=p_to_fk_id and relationship_id <>p_from_id and status='A'
5770: AND ((start_date between from_start_date and from_end_date)
5771: or (nvl(end_date,to_date('12/31/4712','MM/DD/YYYY')) between from_start_date and from_end_date)
5772: or(start_datefrom_end_date)));

Line 5774: UPDATE HZ_RELATIONSHIPS

5770: AND ((start_date between from_start_date and from_end_date)
5771: or (nvl(end_date,to_date('12/31/4712','MM/DD/YYYY')) between from_start_date and from_end_date)
5772: or(start_datefrom_end_date)));
5773:
5774: UPDATE HZ_RELATIONSHIPS
5775: SET
5776: STATUS = 'M',
5777: END_DATE = sysdate,
5778: last_update_date = hz_utility_pub.last_update_date,

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

5781: request_id = hz_utility_pub.request_id,
5782: program_application_id = hz_utility_pub.program_application_id,
5783: program_id = hz_utility_pub.program_id,
5784: program_update_date = sysdate
5785: WHERE relationship_id in (select relationship_id from hz_relationships where subject_id=p_to_fk_id
5786: and object_id=p_to_fk_id and relationship_id <>p_from_id and status='A'
5787: AND ((start_date between from_start_date and from_end_date)
5788: or (nvl(end_date,to_date('12/31/4712','MM/DD/YYYY')) between from_start_date and from_end_date)
5789: or(start_datefrom_end_date)));

Line 5834: FROM HZ_RELATIONSHIPS --4500011

5830: ) IS
5831:
5832: CURSOR c_merge_to_party_reln IS
5833: SELECT relationship_id
5834: FROM HZ_RELATIONSHIPS --4500011
5835: WHERE party_id = p_to_fk_id
5836: AND subject_table_name = 'HZ_PARTIES'
5837: AND object_table_name = 'HZ_PARTIES'
5838: AND directional_flag = 'F';

Line 5856: UPDATE HZ_RELATIONSHIPS

5852: x_return_status := FND_API.G_RET_STS_ERROR;
5853: ELSE
5854: CLOSE c_merge_to_party_reln;
5855:
5856: UPDATE HZ_RELATIONSHIPS
5857: SET
5858: STATUS = 'M',
5859: last_update_date = hz_utility_pub.last_update_date,
5860: last_updated_by = hz_utility_pub.user_id,

Line 6233: hz_relationships r

6229: AND ps1.location_id = l_from_location_id
6230: AND merge_from_entity_id <> p_from_id
6231: AND mpd.batch_party_id IN ( SELECT batch_party_id
6232: FROM hz_merge_parties mp,
6233: hz_relationships r
6234: WHERE r.party_id = p_from_fk_id
6235: AND mp.from_party_id = r.object_id
6236: AND mp.batch_id = p_batch_id)
6237: AND rownum = 1;

Line 6295: hz_relationships r

6291: SELECT psr.party_site_id
6292: FROM hz_parties p,
6293: hz_party_sites psr,
6294: hz_party_sites pso,
6295: hz_relationships r
6296: WHERE pso.party_site_id = p_from_id
6297: AND r.object_id = pso.party_id
6298: AND r.party_id = p.party_id
6299: AND p.party_id = psr.party_id

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

6350: state = l_state,
6351: province = l_province,
6352: county = l_county
6353: WHERE party_id in
6354: (select ps.party_id from hz_party_sites ps,hz_relationships pr
6355: where ps.location_id = l_to_location_id
6356: and ps.identifying_address_flag(+)='Y'
6357: and ps.party_id = pr.party_id
6358: and pr.object_id=l_to_party_id);

Line 6619: FROM HZ_RELATIONSHIPS --4500011

6615: AND nvl(status, 'A') = 'A';
6616:
6617: CURSOR c_branch IS
6618: SELECT 1
6619: FROM HZ_RELATIONSHIPS --4500011
6620: WHERE content_source_type = 'DNB'
6621: AND subject_id = p_from_id
6622: AND object_id = x_to_id
6623: AND RELATIONSHIP_CODE = 'HEADQUARTERS_OF'

Line 6911: FROM HZ_RELATIONSHIPS

6907: CURSOR c_relship_det(cp_relship_id NUMBER) IS
6908: SELECT relationship_type,subject_id,subject_table_name,subject_type,
6909: object_id,object_table_name,object_type,start_date,
6910: direction_code,status,end_date
6911: FROM HZ_RELATIONSHIPS
6912: WHERE relationship_id = cp_relship_id
6913: AND DIRECTIONAL_FLAG = 'F';
6914:
6915: --5547536

Line 6939: l_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_TYPE%TYPE;

6935: l_msg_count NUMBER;
6936: l_msg_data VARCHAR2(2000);
6937: l_return_status VARCHAR2(10);
6938: l_status VARCHAR2(1);
6939: l_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_TYPE%TYPE;
6940: l_rel_code HZ_RELATIONSHIPS.RELATIONSHIP_CODE%TYPE;
6941: l_subject_type HZ_RELATIONSHIPS.SUBJECT_TYPE%TYPE;
6942: l_object_type HZ_RELATIONSHIPS.OBJECT_TYPE%TYPE;
6943: from_end_date date;

Line 6940: l_rel_code HZ_RELATIONSHIPS.RELATIONSHIP_CODE%TYPE;

6936: l_msg_data VARCHAR2(2000);
6937: l_return_status VARCHAR2(10);
6938: l_status VARCHAR2(1);
6939: l_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_TYPE%TYPE;
6940: l_rel_code HZ_RELATIONSHIPS.RELATIONSHIP_CODE%TYPE;
6941: l_subject_type HZ_RELATIONSHIPS.SUBJECT_TYPE%TYPE;
6942: l_object_type HZ_RELATIONSHIPS.OBJECT_TYPE%TYPE;
6943: from_end_date date;
6944: --5547536

Line 6941: l_subject_type HZ_RELATIONSHIPS.SUBJECT_TYPE%TYPE;

6937: l_return_status VARCHAR2(10);
6938: l_status VARCHAR2(1);
6939: l_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_TYPE%TYPE;
6940: l_rel_code HZ_RELATIONSHIPS.RELATIONSHIP_CODE%TYPE;
6941: l_subject_type HZ_RELATIONSHIPS.SUBJECT_TYPE%TYPE;
6942: l_object_type HZ_RELATIONSHIPS.OBJECT_TYPE%TYPE;
6943: from_end_date date;
6944: --5547536
6945: l_multiple_parent_flag VARCHAR2(1);

Line 6942: l_object_type HZ_RELATIONSHIPS.OBJECT_TYPE%TYPE;

6938: l_status VARCHAR2(1);
6939: l_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_TYPE%TYPE;
6940: l_rel_code HZ_RELATIONSHIPS.RELATIONSHIP_CODE%TYPE;
6941: l_subject_type HZ_RELATIONSHIPS.SUBJECT_TYPE%TYPE;
6942: l_object_type HZ_RELATIONSHIPS.OBJECT_TYPE%TYPE;
6943: from_end_date date;
6944: --5547536
6945: l_multiple_parent_flag VARCHAR2(1);
6946: l_from_par_id NUMBER;