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_PARTY_MERGE dependencies on HZ_MERGE_PARTY_DETAILS

Line 357: FROM HZ_MERGE_PARTY_DETAILS

353:
354: -----Cursor for the merge of party sites within the same party-----
355: CURSOR c_batch_party_sites(cp_batch_party_id NUMBER) IS
356: SELECT merge_from_entity_id, merge_to_entity_id
357: FROM HZ_MERGE_PARTY_DETAILS
358: WHERE batch_party_id = cp_batch_party_id
359: AND ENTITY_NAME = 'HZ_PARTY_SITES'
360: AND merge_from_entity_id <> merge_to_entity_id;
361:

Line 365: FROM HZ_MERGE_PARTY_DETAILS

361:
362: -----Cursor for the merge of Contact Points within the same party-----
363: CURSOR c_batch_contact_points(cp_batch_party_id NUMBER) IS
364: SELECT merge_from_entity_id, merge_to_entity_id
365: FROM HZ_MERGE_PARTY_DETAILS
366: WHERE batch_party_id = cp_batch_party_id
367: AND ENTITY_NAME = 'HZ_CONTACT_POINTS'
368: AND merge_from_entity_id <> merge_to_entity_id;
369:

Line 373: FROM HZ_MERGE_PARTY_DETAILS

369:
370: -----Cursor for the merge of Relationships/Contacts within the same party-----
371: CURSOR c_batch_relationships(cp_batch_party_id NUMBER) IS
372: SELECT merge_from_entity_id, merge_to_entity_id
373: FROM HZ_MERGE_PARTY_DETAILS
374: WHERE batch_party_id = cp_batch_party_id
375: AND ENTITY_NAME = 'HZ_PARTY_RELATIONSHIPS'
376: AND merge_from_entity_id <> merge_to_entity_id;
377:

Line 678: -- Lock HZ_MERGE_BATCH, HZ_MERGE_PARTIES and HZ_MERGE_PARTY_DETAILS records

674: --Bug No: 3267877
675: SAVEPOINT batch_merge;
676: l_batch_merge_spt:=TRUE;
677:
678: -- Lock HZ_MERGE_BATCH, HZ_MERGE_PARTIES and HZ_MERGE_PARTY_DETAILS records
679: log ('.... Locking batch for execution');
680: lock_batch(p_batch_id, l_return_status);
681: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
682: ROLLBACK to batch_merge;

Line 1031: FROM HZ_MERGE_PARTIES mp, HZ_MERGE_PARTY_DETAILS md

1027:
1028: /* Merge all to records that are getting merged into the transferred from records */
1029: FOR TO_RECORDS IN (
1030: SELECT mp.batch_party_id, merge_from_entity_id, merge_to_entity_id, ENTITY_NAME
1031: FROM HZ_MERGE_PARTIES mp, HZ_MERGE_PARTY_DETAILS md
1032: WHERE mp.batch_party_id=md.batch_party_id
1033: AND mp.to_party_id = l_pre_merge_to_party_id
1034: AND mp.batch_id = l_batch_id
1035: AND md.mandatory_merge = 'T') LOOP

Line 1457: FROM hz_merge_party_details

1453:
1454: -- Fecth merge party details from the dictionary
1455: CURSOR c_party_details(cp_ent_name VARCHAR2, cp_pk_value NUMBER) IS
1456: SELECT merge_to_entity_id
1457: FROM hz_merge_party_details
1458: WHERE merge_from_entity_id = cp_pk_value AND
1459: batch_party_id = p_batch_party_id AND
1460: entity_name = cp_ent_name;
1461:

Line 1577: FROM hz_merge_party_details

1573:
1574: IF p_entity_name = 'HZ_PARTY_SITES' AND l_mand <> 'C' THEN
1575: BEGIN
1576: SELECT mandatory_merge INTO l_mand
1577: FROM hz_merge_party_details
1578: WHERE batch_party_id = p_batch_party_id
1579: AND merge_from_entity_id = p_from_id
1580: AND entity_name = p_entity_name;
1581:

Line 2076: | Procedure to lock HZ_MERGE_BATCH, HZ_MERGE_PARTIES and HZ_MERGE_PARTY_DETAILS

2072: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2073: END do_merge;
2074:
2075: /*------------------------------------------------------------------------------
2076: | Procedure to lock HZ_MERGE_BATCH, HZ_MERGE_PARTIES and HZ_MERGE_PARTY_DETAILS
2077: | for a given batch
2078: |-------------------------------------------------------------------------------*/
2079:
2080: PROCEDURE lock_batch(

Line 2086: EXECUTE IMMEDIATE 'SELECT batch_party_id from HZ_MERGE_PARTY_DETAILS ' ||

2082: x_return_status IN OUT NOCOPY VARCHAR2) IS
2083:
2084: BEGIN
2085: -- Lock merge party details
2086: EXECUTE IMMEDIATE 'SELECT batch_party_id from HZ_MERGE_PARTY_DETAILS ' ||
2087: 'WHERE batch_party_id IN ' ||
2088: ' (SELECT batch_party_id from HZ_MERGE_PARTIES '||
2089: ' WHERE batch_id = :batchid ) FOR UPDATE NOWAIT' USING p_batch_id;
2090:

Line 2886: from hz_merge_party_details d1, hz_merge_parties p

2882:
2883:
2884: CURSOR party_sites_for_pre_merge(cp_to_party_id IN NUMBER, cp_batch_id IN NUMBER) IS
2885: select merge_to_entity_id, p.from_party_id, p.batch_party_id
2886: from hz_merge_party_details d1, hz_merge_parties p
2887: where entity_name = 'HZ_PARTY_SITES'
2888: and p.batch_party_id = d1.batch_party_id
2889: and d1.batch_party_id IN ( select batch_party_id
2890: from hz_merge_parties

Line 2897: from hz_merge_party_details d2

2893: and batch_id = cp_batch_id)
2894: and merge_from_entity_id = merge_to_entity_id --transfer operation
2895: and exists ( --it should be a merge-to
2896: select 1 --for another mapping
2897: from hz_merge_party_details d2
2898: where d2.merge_to_entity_id = d1.merge_from_entity_id
2899: and d2.entity_name = 'HZ_PARTY_SITES'
2900: and batch_party_id IN ( select batch_party_id
2901: from hz_merge_parties

Line 2909: from hz_merge_party_details d1, hz_merge_parties p

2905: and d2.merge_from_entity_id <> d1.merge_to_entity_id );
2906:
2907: CURSOR rel_for_pre_merge(cp_to_party_id IN NUMBER, cp_batch_id IN NUMBER) IS
2908: select merge_to_entity_id, p.from_party_id, p.batch_party_id
2909: from hz_merge_party_details d1, hz_merge_parties p
2910: where entity_name = 'HZ_PARTY_RELATIONSHIPS'
2911: and p.batch_party_id = d1.batch_party_id
2912: and d1.batch_party_id IN ( select batch_party_id
2913: from hz_merge_parties

Line 2920: from hz_merge_party_details d2

2916: and batch_id = cp_batch_id)
2917: and merge_from_entity_id = merge_to_entity_id --transfer operation
2918: and exists ( --it should be a merge-to
2919: select 1 --for another mapping
2920: from hz_merge_party_details d2
2921: where d2.merge_to_entity_id = d1.merge_from_entity_id
2922: and d2.entity_name = 'HZ_PARTY_RELATIONSHIPS'
2923: and batch_party_id IN (
2924: select batch_party_id

Line 2941: l_merge_to_entity_id hz_merge_party_details.merge_to_entity_id%TYPE;

2937: l_batch_delete HZ_MERGE_BATCH.BATCH_DELETE%TYPE;
2938:
2939: l_batch_party_id HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE;
2940: l_from_id HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE;
2941: l_merge_to_entity_id hz_merge_party_details.merge_to_entity_id%TYPE;
2942: l_new_party_site_id hz_party_sites.party_site_id%type;
2943: l_proc_name hz_merge_dictionary.procedure_name%type;
2944: l_subject_id HZ_RELATIONSHIPS.SUBJECT_ID%TYPE;
2945: l_object_id HZ_RELATIONSHIPS.OBJECT_ID%TYPE;

Line 3037: UPDATE hz_merge_party_details

3033: program_update_date = sysdate
3034: WHERE party_site_id = l_merge_to_entity_id;
3035:
3036:
3037: UPDATE hz_merge_party_details
3038: set merge_to_entity_id = l_new_party_site_id
3039: where batch_party_id IN (select batch_party_id from hz_merge_parties
3040: where batch_id = p_batch_id)
3041: and merge_to_entity_id = l_merge_to_entity_id

Line 3044: UPDATE hz_merge_party_details

3040: where batch_id = p_batch_id)
3041: and merge_to_entity_id = l_merge_to_entity_id
3042: and entity_name = 'HZ_PARTY_SITES';
3043:
3044: UPDATE hz_merge_party_details
3045: set mandatory_merge = 'C'
3046: where batch_party_id IN (select batch_party_id from hz_merge_parties
3047: where batch_id = p_batch_id)
3048: and merge_from_entity_id = l_merge_to_entity_id

Line 3523: -- IF both parties have DNB data, populate HZ_MERGE_PARTY_DETAILS to

3519: CLOSE c_duns1;
3520: END IF;
3521: CLOSE c_duns;
3522:
3523: -- IF both parties have DNB data, populate HZ_MERGE_PARTY_DETAILS to
3524: -- indicate how the DNB data needs to be handled.
3525: if case1 OR case2 OR case3 THEN
3526:
3527: -- *******************************************

Line 3583: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(

3579: END IF;
3580:
3581: END IF;
3582:
3583: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
3584: p_batch_party_id,
3585: 'HZ_ORGANIZATION_PROFILES',
3586: l_from_profile_id,
3587: l_to_profile_id,

Line 3813: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(

3809:
3810: END;
3811:
3812: IF case_new = 'True' THEN
3813: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
3814: p_batch_party_id,
3815: 'HZ_CONTACT_POINTS',
3816: l_to,
3817: FROM_CP.contact_point_id,

Line 3929: IF case_new = 'True' THEN --Populate HZ_MERGE_PARTY_DETAILS

3925: NULL;
3926:
3927: END;
3928:
3929: IF case_new = 'True' THEN --Populate HZ_MERGE_PARTY_DETAILS
3930: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
3931: p_batch_party_id,
3932: 'HZ_CONTACT_POINTS',
3933: FROM_CP.contact_point_id,

Line 3930: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(

3926:
3927: END;
3928:
3929: IF case_new = 'True' THEN --Populate HZ_MERGE_PARTY_DETAILS
3930: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
3931: p_batch_party_id,
3932: 'HZ_CONTACT_POINTS',
3933: FROM_CP.contact_point_id,
3934: l_to,

Line 3999: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(

3995: DELETE FROM HZ_CREDIT_RATINGS
3996: WHERE credit_rating_id = l_to;
3997: -- Bug 3236556 - Since the to party no longer exists we must not insert a row with merge details.
3998: /*-- Merge to into from
3999: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
4000: p_batch_party_id,
4001: 'HZ_CREDIT_RATINGS',
4002: l_to,
4003: FROM_CR.credit_rating_id,

Line 4013: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(

4009: hz_utility_pub.last_updated_by);
4010: */
4011: ELSE -- To Newer
4012: -- Merge from into to
4013: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
4014: p_batch_party_id,
4015: 'HZ_CREDIT_RATINGS',
4016: FROM_CR.credit_rating_id,
4017: l_to,

Line 4056: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(

4052:
4053: -- From Newer
4054: IF case1 OR (case3 and l_to_is_branch = 'Y') THEN
4055: -- Merge to into from
4056: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
4057: p_batch_party_id,
4058: 'HZ_CODE_ASSIGNMENTS',
4059: FROM_CA.code_assignment_id,
4060: l_to,

Line 4069: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(

4065: hz_utility_pub.last_update_date,
4066: hz_utility_pub.last_updated_by);
4067: ELSE -- To Newer
4068: -- Merge from into to
4069: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
4070: p_batch_party_id,
4071: 'HZ_CODE_ASSIGNMENTS',
4072: FROM_CA.code_assignment_id,
4073: l_to,

Line 4231: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(

4227: OPEN c_dup_to_ps(l_loc_id);
4228: FETCH c_dup_to_ps INTO l_dup_ps_id;
4229:
4230: IF c_dup_to_ps%FOUND THEN
4231: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
4232: p_batch_party_id,
4233: 'HZ_PARTY_SITES',
4234: l_ps_id,
4235: l_dup_ps_id,

Line 4243: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(

4239: hz_utility_pub.last_update_login,
4240: hz_utility_pub.last_update_date,
4241: hz_utility_pub.last_updated_by);
4242: ELSE
4243: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
4244: p_batch_party_id,
4245: 'HZ_PARTY_SITES',
4246: l_ps_id,
4247: l_ps_id,