APPS.HZ_PARTY_MERGE dependencies on HZ_MERGE_PARTY_DETAILS_PKG

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 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,