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_MERGE_PKG

Line 1: PACKAGE BODY HZ_MERGE_PKG AS

1: PACKAGE BODY HZ_MERGE_PKG AS
2: /*$Header: ARHMPKGB.pls 120.64.12020000.3 2013/03/27 07:25:38 vsegu ship $ */
3: --4307667
4: PROCEDURE do_party_usage_merge(
5: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,

Line 415: 'HZ_MERGE_PKG.party_merge',

411: x_return_status := FND_API.G_RET_STS_SUCCESS;
412:
413: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
414: p_to_fk_id, p_par_entity_name,
415: 'HZ_MERGE_PKG.party_merge',
416: 'HZ_PARTIES',NULL,
417: 'PARTY_ID',NULL,x_return_status);
418:
419: IF (x_return_status =FND_API.G_RET_STS_SUCCESS) THEN

Line 457: 'HZ_MERGE_PKG.org_profile_merge',

453: x_return_status := FND_API.G_RET_STS_SUCCESS;
454:
455: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
456: p_to_fk_id, p_par_entity_name,
457: 'HZ_MERGE_PKG.org_profile_merge',
458: 'HZ_ORGANIZATION_PROFILES','HZ_PARTIES',
459: 'ORGANIZATION_PROFILE_ID', 'PARTY_ID',x_return_status);
460:
461: IF (x_return_status =FND_API.G_RET_STS_SUCCESS) THEN

Line 499: 'HZ_MERGE_PKG.party_relationship_merge',

495: x_return_status := FND_API.G_RET_STS_SUCCESS;
496:
497: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
498: p_to_fk_id, p_par_entity_name,
499: 'HZ_MERGE_PKG.party_relationship_merge',
500: 'HZ_PARTY_RELATIONSHIPS','HZ_PARTIES',
501: 'PARTY_RELATIONSHIP_ID', 'PARTY_ID',x_return_status);
502:
503: IF (x_return_status =FND_API.G_RET_STS_SUCCESS) THEN

Line 541: 'HZ_MERGE_PKG.per_profile_merge',

537: x_return_status := FND_API.G_RET_STS_SUCCESS;
538:
539: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
540: p_to_fk_id, p_par_entity_name,
541: 'HZ_MERGE_PKG.per_profile_merge',
542: 'HZ_PERSON_PROFILES','HZ_PARTIES',
543: 'PERSON_PROFILE_ID', 'PARTY_ID',x_return_status);
544:
545: IF (x_return_status =FND_API.G_RET_STS_SUCCESS) THEN

Line 585: 'HZ_MERGE_PKG.party_usage_merge',

581: x_return_status := FND_API.G_RET_STS_SUCCESS;
582:
583: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
584: p_to_fk_id, p_par_entity_name,
585: 'HZ_MERGE_PKG.party_usage_merge',
586: 'HZ_PARTY_USG_ASSIGNMENTS','HZ_PARTIES',
587: 'PARTY_USG_ASSIGNMENT_ID', 'PARTY_ID',x_return_status);
588:
589: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 628: 'HZ_MERGE_PKG.party_reln_subject_merge',

624: x_return_status := FND_API.G_RET_STS_SUCCESS;
625:
626: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
627: p_to_fk_id, p_par_entity_name,
628: 'HZ_MERGE_PKG.party_reln_subject_merge',
629: 'HZ_PARTY_RELATIONSHIPS','HZ_PARTIES',
630: 'PARTY_RELATIONSHIP_ID', 'PARTY_ID',x_return_status);
631:
632: IF (x_return_status =FND_API.G_RET_STS_SUCCESS) THEN

Line 687: 'HZ_MERGE_PKG.party_reln_object_merge',

683: x_return_status := FND_API.G_RET_STS_SUCCESS;
684:
685: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
686: p_to_fk_id, p_par_entity_name,
687: 'HZ_MERGE_PKG.party_reln_object_merge',
688: 'HZ_PARTY_RELATIONSHIPS','HZ_PARTIES',
689: 'PARTY_RELATIONSHIP_ID', 'PARTY_ID',x_return_status);
690:
691: IF (x_return_status =FND_API.G_RET_STS_SUCCESS) THEN

Line 744: 'HZ_MERGE_PKG.org_contact_merge',

740: x_return_status := FND_API.G_RET_STS_SUCCESS;
741:
742: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
743: p_to_fk_id, p_par_entity_name,
744: 'HZ_MERGE_PKG.org_contact_merge',
745: 'HZ_ORG_CONTACTS','HZ_PARTY_SITES',
746: 'ORG_CONTACT_ID', 'PARTY_SITE_ID',x_return_status);
747:
748: IF (x_return_status =FND_API.G_RET_STS_SUCCESS) THEN

Line 786: 'HZ_MERGE_PKG.org_contact_merge2',

782: x_return_status := FND_API.G_RET_STS_SUCCESS;
783:
784: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
785: p_to_fk_id, p_par_entity_name,
786: 'HZ_MERGE_PKG.org_contact_merge2',
787: 'HZ_ORG_CONTACTS','HZ_PARTY_RELATIONSHIPS',
788: 'ORG_CONTACT_ID', 'PARTY_RELATIONSHIP_ID',x_return_status);
789:
790: IF (x_return_status =FND_API.G_RET_STS_SUCCESS) THEN

Line 877: 'HZ_MERGE_PKG.party_site_merge',

873:
874: IF p_from_fk_id <> FND_API.G_MISS_NUM THEN
875: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
876: p_to_fk_id, p_par_entity_name,
877: 'HZ_MERGE_PKG.party_site_merge',
878: 'HZ_PARTY_SITES','HZ_PARTIES',
879: 'PARTY_SITE_ID', 'PARTY_ID',x_return_status);
880: ELSE
881: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,

Line 883: 'HZ_MERGE_PKG.party_site_merge',

879: 'PARTY_SITE_ID', 'PARTY_ID',x_return_status);
880: ELSE
881: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
882: p_to_fk_id, p_par_entity_name,
883: 'HZ_MERGE_PKG.party_site_merge',
884: 'HZ_PARTY_SITES',NULL, 'PARTY_SITE_ID',
885: NULL,x_return_status);
886: END IF;
887:

Line 956: 'HZ_MERGE_PKG.cust_account_merge',

952: x_return_status := FND_API.G_RET_STS_SUCCESS;
953:
954: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
955: p_to_fk_id, p_par_entity_name,
956: 'HZ_MERGE_PKG.cust_account_merge',
957: 'HZ_CUST_ACCOUNTS','HZ_PARTIES',
958: 'CUST_ACCOUNT_ID', 'PARTY_ID',x_return_status);
959: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
960: l_dup_exists := HZ_MERGE_DUP_CHECK.check_cust_account_dup(

Line 1004: 'HZ_MERGE_PKG.cust_account_merge',

1000: x_return_status := FND_API.G_RET_STS_SUCCESS;
1001:
1002: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
1003: p_to_fk_id, p_par_entity_name,
1004: 'HZ_MERGE_PKG.cust_account_merge',
1005: 'HZ_CUST_ACCOUNTS','HZ_PARTIES',
1006: 'CUST_ACCOUNT_ID', 'SELLING_PARTY_ID',x_return_status);
1007:
1008: IF (x_return_status =FND_API.G_RET_STS_SUCCESS) THEN

Line 1056: 'HZ_MERGE_PKG.cust_account_role_merge',

1052: x_return_status := FND_API.G_RET_STS_SUCCESS;
1053:
1054: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
1055: p_to_fk_id, p_par_entity_name,
1056: 'HZ_MERGE_PKG.cust_account_role_merge',
1057: 'HZ_CUST_ACCOUNT_ROLES','HZ_PARTIES',
1058: 'CUST_ACCOUNT_ROLE_ID', 'PARTY_ID',x_return_status);
1059: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
1060: l_dup_exists := HZ_MERGE_DUP_CHECK.check_cust_account_role_dup(

Line 1103: 'HZ_MERGE_PKG.cust_account_site_merge',

1099: x_return_status := FND_API.G_RET_STS_SUCCESS;
1100:
1101: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
1102: p_to_fk_id, p_par_entity_name,
1103: 'HZ_MERGE_PKG.cust_account_site_merge',
1104: 'HZ_CUST_ACCT_SITES_ALL','HZ_PARTY_SITES',
1105: 'CUST_ACCT_SITE_ID', 'PARTY_SITE_ID',x_return_status);
1106:
1107: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN

Line 1181: 'HZ_MERGE_PKG.financial_profile_merge',

1177: x_return_status := FND_API.G_RET_STS_SUCCESS;
1178:
1179: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
1180: p_to_fk_id, p_par_entity_name,
1181: 'HZ_MERGE_PKG.financial_profile_merge',
1182: 'HZ_FINANCIAL_PROFILE','HZ_PARTIES',
1183: 'FINANCIAL_PROFILE_ID', 'PARTY_ID',x_return_status);
1184:
1185: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN

Line 1260: 'HZ_MERGE_PKG.contact_point_merge',

1256: x_return_status := FND_API.G_RET_STS_SUCCESS;
1257:
1258: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
1259: p_to_fk_id, p_par_entity_name,
1260: 'HZ_MERGE_PKG.contact_point_merge',
1261: 'HZ_CONTACT_POINTS','HZ_PARTIES',
1262: 'CONTACT_POINT_ID', 'PARTY_ID',x_return_status);
1263:
1264: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN

Line 1353: 'HZ_MERGE_PKG.references_merge',

1349: x_return_status := FND_API.G_RET_STS_SUCCESS;
1350:
1351: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
1352: p_to_fk_id, p_par_entity_name,
1353: 'HZ_MERGE_PKG.references_merge',
1354: 'HZ_REFERENCES','HZ_PARTIES',
1355: 'REFERENCE_ID', 'PARTY_ID',x_return_status);
1356:
1357: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN

Line 1433: 'HZ_MERGE_PKG.certification_merge',

1429: x_return_status := FND_API.G_RET_STS_SUCCESS;
1430:
1431: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
1432: p_to_fk_id, p_par_entity_name,
1433: 'HZ_MERGE_PKG.certification_merge',
1434: 'HZ_CERTIFICATIONS','HZ_PARTIES',
1435: 'CERTIFICATION_ID', 'PARTY_ID',x_return_status);
1436:
1437: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN

Line 1482: 'HZ_MERGE_PKG.credit_ratings_merge',

1478: x_return_status := FND_API.G_RET_STS_SUCCESS;
1479:
1480: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
1481: p_to_fk_id, p_par_entity_name,
1482: 'HZ_MERGE_PKG.credit_ratings_merge',
1483: 'HZ_CREDIT_RATINGS','HZ_PARTIES',
1484: 'CREDIT_RATING_ID', 'PARTY_ID',x_return_status);
1485:
1486: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN

Line 1532: 'HZ_MERGE_PKG.security_issued_merge',

1528: x_return_status := FND_API.G_RET_STS_SUCCESS;
1529:
1530: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
1531: p_to_fk_id, p_par_entity_name,
1532: 'HZ_MERGE_PKG.security_issued_merge',
1533: 'HZ_SECURITY_ISSUED','HZ_PARTIES',
1534: 'SECURITY_ISSUED_ID', 'PARTY_ID',x_return_status);
1535:
1536: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN

Line 1582: 'HZ_MERGE_PKG.financial_reports_merge',

1578: x_return_status := FND_API.G_RET_STS_SUCCESS;
1579:
1580: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
1581: p_to_fk_id, p_par_entity_name,
1582: 'HZ_MERGE_PKG.financial_reports_merge',
1583: 'HZ_FINANCIAL_REPORTS','HZ_PARTIES',
1584: 'FINANCIAL_REPORT_ID', 'PARTY_ID',x_return_status);
1585:
1586: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN

Line 1632: 'HZ_MERGE_PKG.org_indicators_merge',

1628: x_return_status := FND_API.G_RET_STS_SUCCESS;
1629:
1630: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
1631: p_to_fk_id, p_par_entity_name,
1632: 'HZ_MERGE_PKG.org_indicators_merge',
1633: 'HZ_ORGANIZATION_INDICATORS','HZ_PARTIES',
1634: 'ORGANIZATION_INDICATOR_ID', 'PARTY_ID',x_return_status);
1635:
1636: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN

Line 1681: 'HZ_MERGE_PKG.org_ind_reference_merge',

1677: x_return_status := FND_API.G_RET_STS_SUCCESS;
1678:
1679: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
1680: p_to_fk_id, p_par_entity_name,
1681: 'HZ_MERGE_PKG.org_ind_reference_merge',
1682: 'HZ_INDUSTRIAL_REFERENCE','HZ_PARTIES',
1683: 'INDUSTRY_REFERENCE_ID', 'PARTY_ID',x_return_status);
1684:
1685: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN

Line 1731: 'HZ_MERGE_PKG.per_interest_merge',

1727: x_return_status := FND_API.G_RET_STS_SUCCESS;
1728:
1729: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
1730: p_to_fk_id, p_par_entity_name,
1731: 'HZ_MERGE_PKG.per_interest_merge',
1732: 'HZ_PERSON_INTEREST','HZ_PARTIES',
1733: 'PERSON_INTEREST_ID', 'PARTY_ID',x_return_status);
1734:
1735: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN

Line 1780: 'HZ_MERGE_PKG.citizenship_merge',

1776: x_return_status := FND_API.G_RET_STS_SUCCESS;
1777:
1778: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
1779: p_to_fk_id, p_par_entity_name,
1780: 'HZ_MERGE_PKG.citizenship_merge',
1781: 'HZ_CITIZENSHIP','HZ_PARTIES',
1782: 'CITIZENSHIP_ID', 'PARTY_ID',x_return_status);
1783:
1784: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN

Line 1829: 'HZ_MERGE_PKG.education_merge',

1825: x_return_status := FND_API.G_RET_STS_SUCCESS;
1826:
1827: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
1828: p_to_fk_id, p_par_entity_name,
1829: 'HZ_MERGE_PKG.education_merge',
1830: 'HZ_EDUCATION','HZ_PARTIES',
1831: 'EDUCATION_ID', 'PARTY_ID',x_return_status);
1832:
1833: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN

Line 1878: 'HZ_MERGE_PKG.education_school_merge',

1874: x_return_status := FND_API.G_RET_STS_SUCCESS;
1875:
1876: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
1877: p_to_fk_id, p_par_entity_name,
1878: 'HZ_MERGE_PKG.education_school_merge',
1879: 'HZ_EDUCATION','HZ_PARTIES',
1880: 'EDUCATION_ID', 'SCHOOL_PARTY_ID',x_return_status);
1881:
1882: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN

Line 1927: 'HZ_MERGE_PKG.emp_history_merge',

1923: x_return_status := FND_API.G_RET_STS_SUCCESS;
1924:
1925: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
1926: p_to_fk_id, p_par_entity_name,
1927: 'HZ_MERGE_PKG.emp_history_merge',
1928: 'HZ_EMPLOYMENT_HISTORY','HZ_PARTIES',
1929: 'EMPLOYMENT_HISTORY_ID', 'PARTY_ID',x_return_status);
1930:
1931: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN

Line 1976: 'HZ_MERGE_PKG.emp_history_employed_merge',

1972: x_return_status := FND_API.G_RET_STS_SUCCESS;
1973:
1974: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
1975: p_to_fk_id, p_par_entity_name,
1976: 'HZ_MERGE_PKG.emp_history_employed_merge',
1977: 'HZ_EMPLOYMENT_HISTORY','HZ_PARTIES',
1978: 'EMPLOYMENT_HISTORY_ID','EMPLOYED_BY_PARTY_ID',x_return_status);
1979:
1980: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN

Line 2025: 'HZ_MERGE_PKG.work_class_merge',

2021: x_return_status := FND_API.G_RET_STS_SUCCESS;
2022:
2023: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
2024: p_to_fk_id, p_par_entity_name,
2025: 'HZ_MERGE_PKG.work_class_merge',
2026: 'HZ_WORK_CLASS', 'HZ_EMPLOYMENT_HISTORY',
2027: 'WORK_CLASS_ID', 'EMPLOYMENT_HISTORY_ID', x_return_status);
2028:
2029: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN

Line 2074: 'HZ_MERGE_PKG.code_assignment_merge',

2070: x_return_status := FND_API.G_RET_STS_SUCCESS;
2071:
2072: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
2073: p_to_fk_id, p_par_entity_name,
2074: 'HZ_MERGE_PKG.code_assignment_merge',
2075: 'HZ_CODE_ASSIGNMENTS','HZ_PARTIES',
2076: 'CODE_ASSIGNMENT_ID', 'PARTY_ID',x_return_status);
2077:
2078: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN

Line 2123: 'HZ_MERGE_PKG.code_assignment_merge',

2119: x_return_status := FND_API.G_RET_STS_SUCCESS;
2120:
2121: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
2122: p_to_fk_id, p_par_entity_name,
2123: 'HZ_MERGE_PKG.code_assignment_merge',
2124: 'HZ_CODE_ASSIGNMENTS','HZ_PARTY_SITES',
2125: 'CODE_ASSIGNMENT_ID', 'PARTY_SITE_ID',x_return_status);
2126:
2127: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN

Line 2172: 'HZ_MERGE_PKG.org_contact_role_merge',

2168: x_return_status := FND_API.G_RET_STS_SUCCESS;
2169:
2170: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
2171: p_to_fk_id, p_par_entity_name,
2172: 'HZ_MERGE_PKG.org_contact_role_merge',
2173: 'HZ_ORG_CONTACT_ROLES','HZ_ORG_CONTACTS',
2174: 'ORG_CONTACT_ROLE_ID', 'ORG_CONTACT_ID',x_return_status);
2175:
2176: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN

Line 2221: 'HZ_MERGE_PKG.financial_number_merge',

2217: x_return_status := FND_API.G_RET_STS_SUCCESS;
2218:
2219: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
2220: p_to_fk_id, p_par_entity_name,
2221: 'HZ_MERGE_PKG.financial_number_merge',
2222: 'HZ_FINANCIAL_NUMBERS','HZ_FINANCIAL_REPORTS',
2223: 'FINANCIAL_NUMBER_ID', 'FINANCIAL_REPORT_ID',x_return_status);
2224:
2225: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN

Line 2270: 'HZ_MERGE_PKG.per_languages_merge',

2266: x_return_status := FND_API.G_RET_STS_SUCCESS;
2267:
2268: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
2269: p_to_fk_id, p_par_entity_name,
2270: 'HZ_MERGE_PKG.per_languages_merge',
2271: 'HZ_PERSON_LANGUAGE','HZ_PARTIES',
2272: 'LANGUAGE_USE_REFERENCE_ID', 'PARTY_ID',x_return_status);
2273:
2274: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN

Line 2319: 'HZ_MERGE_PKG.party_site_use_merge',

2315: x_return_status := FND_API.G_RET_STS_SUCCESS;
2316:
2317: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
2318: p_to_fk_id, p_par_entity_name,
2319: 'HZ_MERGE_PKG.party_site_use_merge',
2320: 'HZ_PARTY_SITE_USES','HZ_PARTY_SITES',
2321: 'PARTY_SITE_USE_ID', 'PARTY_SITE_ID',x_return_status);
2322:
2323: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN

Line 2370: 'HZ_MERGE_PKG.contact_point_merge2',

2366:
2367:
2368: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
2369: p_to_fk_id, p_par_entity_name,
2370: 'HZ_MERGE_PKG.contact_point_merge2',
2371: 'HZ_CONTACT_POINTS','HZ_PARTY_SITES',
2372: 'CONTACT_POINT_ID', 'PARTY_SITE_ID',x_return_status);
2373:
2374: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN

Line 2462: 'HZ_MERGE_PKG.contact_preference_merge',

2458: x_return_status := FND_API.G_RET_STS_SUCCESS;
2459:
2460: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
2461: p_to_fk_id, p_par_entity_name,
2462: 'HZ_MERGE_PKG.contact_preference_merge',
2463: 'HZ_CONTACT_PREFERENCES','HZ_PARTIES',
2464: 'CONTACT_PREFERENCE_ID', 'PARTY_ID',x_return_status);
2465:
2466: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN

Line 2540: 'HZ_MERGE_PKG.contact_preference_merge2',

2536: x_return_status := FND_API.G_RET_STS_SUCCESS;
2537:
2538: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
2539: p_to_fk_id, p_par_entity_name,
2540: 'HZ_MERGE_PKG.contact_preference_merge2',
2541: 'HZ_CONTACT_PREFERENCES','HZ_PARTY_SITES',
2542: 'CONTACT_PREFERENCE_ID', 'PARTY_SITE_ID',x_return_status);
2543:
2544: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN

Line 2619: 'HZ_MERGE_PKG.contact_preference_merge3',

2615: x_return_status := FND_API.G_RET_STS_SUCCESS;
2616:
2617: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
2618: p_to_fk_id, p_par_entity_name,
2619: 'HZ_MERGE_PKG.contact_preference_merge3',
2620: 'HZ_CONTACT_PREFERENCES','HZ_CONTACT_POINTS',
2621: 'CONTACT_PREFERENCE_ID', 'CONTACT_POINT_ID',x_return_status);
2622:
2623: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN

Line 2669: 'HZ_MERGE_PKG.displayed_duns_merge',

2665: x_return_status := FND_API.G_RET_STS_SUCCESS;
2666:
2667: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
2668: p_to_fk_id, p_par_entity_name,
2669: 'HZ_MERGE_PKG.displayed_duns_merge',
2670: 'HZ_ORGANIZATION_PROFILES','HZ_PARTIES',
2671: 'ORGANIZATION_PROFILE_ID', 'PARTY_ID',x_return_status);
2672:
2673: do_displayed_duns_merge(p_from_id, l_to_id, p_from_fk_id, p_to_fk_id,

Line 7296: END HZ_MERGE_PKG;

7292: END IF;
7293:
7294: END;
7295:
7296: END HZ_MERGE_PKG;