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_PKG

Line 3560: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(

3556: END IF;
3557:
3558: END IF;
3559:
3560: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
3561: p_batch_party_id,
3562: 'HZ_ORGANIZATION_PROFILES',
3563: l_from_profile_id,
3564: l_to_profile_id,

Line 3614: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(

3610: AND nvl(status,'A')='A';
3611:
3612: IF l_to_loc_id = FROM_PS.location_id THEN
3613: -- Merge to_ps to from_ps
3614: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
3615: p_batch_party_id,
3616: 'HZ_PARTY_SITES',
3617: l_to,
3618: FROM_PS.party_site_id,

Line 3663: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(

3659: NULL;
3660: END;
3661:
3662: IF case_new = 'True' THEN
3663: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
3664: p_batch_party_id,
3665: 'HZ_PARTY_SITES',
3666: l_to,
3667: FROM_PS.party_site_id,

Line 3768: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(

3764:
3765:
3766: IF case_new = 'True' THEN
3767: -- Merge from_ps with to_ps
3768: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
3769: p_batch_party_id,
3770: 'HZ_PARTY_SITES',
3771: FROM_PS.party_site_id,
3772: l_to,

Line 3884: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(

3880:
3881: insert_party_site_details(l_rel_to_party_id,FROM_REL.PARTY_ID,
3882: l_batch_party_id);
3883: ---Bug No. 5349866
3884: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
3885: p_batch_party_id,
3886: 'HZ_PARTY_RELATIONSHIPS',
3887: l_to,
3888: FROM_REL.relationship_id,

Line 3897: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(

3893: hz_utility_pub.last_update_date,
3894: hz_utility_pub.last_updated_by);
3895: --Bug No. 5349866
3896: ELSE
3897: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
3898: p_batch_party_id,
3899: 'HZ_PARTY_RELATIONSHIPS',
3900: l_to,
3901: FROM_REL.relationship_id,

Line 3941: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(

3937: insert_party_site_details(FROM_REL.PARTY_ID,
3938: l_rel_to_party_id,
3939: l_batch_party_id);
3940: --bug 5349866
3941: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
3942: p_batch_party_id,
3943: 'HZ_PARTY_RELATIONSHIPS',
3944: FROM_REL.relationship_id,
3945: l_to,

Line 3955: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(

3951: hz_utility_pub.last_updated_by);
3952: --bug 5349866
3953: ELSE
3954:
3955: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
3956: p_batch_party_id,
3957: 'HZ_PARTY_RELATIONSHIPS',
3958: FROM_REL.relationship_id,
3959: l_to,

Line 4080: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(

4076: insert_party_site_details(FROM_REL.PARTY_ID,
4077: l_rel_to_party_id,
4078: l_batch_party_id);
4079:
4080: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
4081: p_batch_party_id,
4082: 'HZ_PARTY_RELATIONSHIPS',
4083: FROM_REL.relationship_id,
4084: l_to,

Line 4215: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(

4211:
4212: END;
4213:
4214: IF case_new = 'True' THEN
4215: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
4216: p_batch_party_id,
4217: 'HZ_CONTACT_POINTS',
4218: l_to,
4219: FROM_CP.contact_point_id,

Line 4332: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(

4328:
4329: END;
4330:
4331: IF case_new = 'True' THEN --Populate HZ_MERGE_PARTY_DETAILS
4332: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
4333: p_batch_party_id,
4334: 'HZ_CONTACT_POINTS',
4335: FROM_CP.contact_point_id,
4336: l_to,

Line 4401: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(

4397: DELETE FROM HZ_CREDIT_RATINGS
4398: WHERE credit_rating_id = l_to;
4399: -- Bug 3236556 - Since the to party no longer exists we must not insert a row with merge details.
4400: /*-- Merge to into from
4401: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
4402: p_batch_party_id,
4403: 'HZ_CREDIT_RATINGS',
4404: l_to,
4405: FROM_CR.credit_rating_id,

Line 4415: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(

4411: hz_utility_pub.last_updated_by);
4412: */
4413: ELSE -- To Newer
4414: -- Merge from into to
4415: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
4416: p_batch_party_id,
4417: 'HZ_CREDIT_RATINGS',
4418: FROM_CR.credit_rating_id,
4419: l_to,

Line 4458: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(

4454:
4455: -- From Newer
4456: IF case1 OR (case3 and l_to_is_branch = 'Y') THEN
4457: -- Merge to into from
4458: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
4459: p_batch_party_id,
4460: 'HZ_CODE_ASSIGNMENTS',
4461: FROM_CA.code_assignment_id,
4462: l_to,

Line 4471: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(

4467: hz_utility_pub.last_update_date,
4468: hz_utility_pub.last_updated_by);
4469: ELSE -- To Newer
4470: -- Merge from into to
4471: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
4472: p_batch_party_id,
4473: 'HZ_CODE_ASSIGNMENTS',
4474: FROM_CA.code_assignment_id,
4475: l_to,

Line 4633: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(

4629: OPEN c_dup_to_ps(l_loc_id);
4630: FETCH c_dup_to_ps INTO l_dup_ps_id;
4631:
4632: IF c_dup_to_ps%FOUND THEN
4633: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
4634: p_batch_party_id,
4635: 'HZ_PARTY_SITES',
4636: l_ps_id,
4637: l_dup_ps_id,

Line 4645: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(

4641: hz_utility_pub.last_update_login,
4642: hz_utility_pub.last_update_date,
4643: hz_utility_pub.last_updated_by);
4644: ELSE
4645: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
4646: p_batch_party_id,
4647: 'HZ_PARTY_SITES',
4648: l_ps_id,
4649: l_ps_id,