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_PARTIES

Line 342: ----BugNo:1695595.Added private procedure to update denormalized columns in hz_parties.

338: p_source_party_id IN NUMBER,
339: p_destination_party_id IN NUMBER
340: );
341:
342: ----BugNo:1695595.Added private procedure to update denormalized columns in hz_parties.
343:
344: PROCEDURE do_denormalize_contact_point (
345: p_party_id IN NUMBER,
346: p_contact_point_type IN VARCHAR2,

Line 416: 'HZ_PARTIES',NULL,

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
420: do_party_merge(p_from_id, l_to_id,p_from_fk_id, p_to_fk_id,

Line 458: 'HZ_ORGANIZATION_PROFILES','HZ_PARTIES',

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
462: do_org_profile_merge(p_from_id, l_to_id,p_from_fk_id, p_to_fk_id,

Line 500: 'HZ_PARTY_RELATIONSHIPS','HZ_PARTIES',

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
504: do_party_relationship_merge(p_from_id, l_to_id,p_from_fk_id,p_to_fk_id,

Line 542: 'HZ_PERSON_PROFILES','HZ_PARTIES',

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
546: do_per_profile_merge(p_from_id, l_to_id,p_from_fk_id,p_to_fk_id,

Line 586: 'HZ_PARTY_USG_ASSIGNMENTS','HZ_PARTIES',

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
590: do_party_usage_merge(p_from_id,l_to_id, p_from_fk_id,

Line 629: 'HZ_PARTY_RELATIONSHIPS','HZ_PARTIES',

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
633: do_party_reln_subj_merge(p_from_id,l_to_id, p_from_fk_id,

Line 688: 'HZ_PARTY_RELATIONSHIPS','HZ_PARTIES',

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
692: do_party_reln_obj_merge(p_from_id,l_to_id, p_from_fk_id,

Line 878: 'HZ_PARTY_SITES','HZ_PARTIES',

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,
882: p_to_fk_id, p_par_entity_name,

Line 957: 'HZ_CUST_ACCOUNTS','HZ_PARTIES',

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(
961: p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,

Line 1005: 'HZ_CUST_ACCOUNTS','HZ_PARTIES',

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
1009: UPDATE HZ_CUST_ACCOUNTS

Line 1057: 'HZ_CUST_ACCOUNT_ROLES','HZ_PARTIES',

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(
1061: p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,

Line 1182: 'HZ_FINANCIAL_PROFILE','HZ_PARTIES',

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
1186: l_dup_exists := HZ_MERGE_DUP_CHECK.check_financial_profile_dup(

Line 1261: 'HZ_CONTACT_POINTS','HZ_PARTIES',

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
1265: l_dup_exists := HZ_MERGE_DUP_CHECK.check_contact_point_dup(

Line 1267: 'HZ_PARTIES',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
1265: l_dup_exists := HZ_MERGE_DUP_CHECK.check_contact_point_dup(
1266: p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,
1267: 'HZ_PARTIES',x_return_status);
1268: END IF;
1269:
1270: IF (x_return_status =FND_API.G_RET_STS_SUCCESS) THEN
1271: do_contact_point_transfer(p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,

Line 1354: 'HZ_REFERENCES','HZ_PARTIES',

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
1358: l_dup_exists := HZ_MERGE_DUP_CHECK.check_references_dup(

Line 1434: 'HZ_CERTIFICATIONS','HZ_PARTIES',

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
1438: l_dup_exists := HZ_MERGE_DUP_CHECK.check_certification_dup(

Line 1483: 'HZ_CREDIT_RATINGS','HZ_PARTIES',

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
1487: l_dup_exists := HZ_MERGE_DUP_CHECK.check_credit_ratings_dup(

Line 1533: 'HZ_SECURITY_ISSUED','HZ_PARTIES',

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
1537:

Line 1583: 'HZ_FINANCIAL_REPORTS','HZ_PARTIES',

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
1587: l_dup_exists := HZ_MERGE_DUP_CHECK.check_financial_reports_dup(

Line 1633: 'HZ_ORGANIZATION_INDICATORS','HZ_PARTIES',

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
1637: l_dup_exists := HZ_MERGE_DUP_CHECK.check_org_indicators_dup(

Line 1682: 'HZ_INDUSTRIAL_REFERENCE','HZ_PARTIES',

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
1686: l_dup_exists := HZ_MERGE_DUP_CHECK.check_ind_reference_dup(

Line 1732: 'HZ_PERSON_INTEREST','HZ_PARTIES',

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
1736: l_dup_exists := HZ_MERGE_DUP_CHECK.check_per_interest_dup(

Line 1781: 'HZ_CITIZENSHIP','HZ_PARTIES',

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
1785: l_dup_exists := HZ_MERGE_DUP_CHECK.check_citizenship_dup(

Line 1830: 'HZ_EDUCATION','HZ_PARTIES',

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
1834: l_dup_exists := HZ_MERGE_DUP_CHECK.check_education_dup(

Line 1879: 'HZ_EDUCATION','HZ_PARTIES',

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
1883: l_dup_exists := HZ_MERGE_DUP_CHECK.check_education_dup(

Line 1928: 'HZ_EMPLOYMENT_HISTORY','HZ_PARTIES',

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
1932: l_dup_exists := HZ_MERGE_DUP_CHECK.check_emp_history_dup(

Line 1977: 'HZ_EMPLOYMENT_HISTORY','HZ_PARTIES',

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
1981: l_dup_exists := HZ_MERGE_DUP_CHECK.check_emp_history_dup(

Line 2075: 'HZ_CODE_ASSIGNMENTS','HZ_PARTIES',

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
2079: l_dup_exists := HZ_MERGE_DUP_CHECK.check_code_assignment_dup(

Line 2081: 'HZ_PARTIES', 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
2079: l_dup_exists := HZ_MERGE_DUP_CHECK.check_code_assignment_dup(
2080: p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,
2081: 'HZ_PARTIES', x_return_status);
2082: END IF;
2083:
2084: IF (x_return_status =FND_API.G_RET_STS_SUCCESS) THEN
2085: do_code_assignment_transfer(p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,

Line 2271: 'HZ_PERSON_LANGUAGE','HZ_PARTIES',

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
2275: l_dup_exists := HZ_MERGE_DUP_CHECK.check_languages_dup(

Line 2463: 'HZ_CONTACT_PREFERENCES','HZ_PARTIES',

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
2467: l_dup_exists := HZ_MERGE_DUP_CHECK.check_contact_preference_dup(

Line 2469: 'HZ_PARTIES',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
2467: l_dup_exists := HZ_MERGE_DUP_CHECK.check_contact_preference_dup(
2468: p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,
2469: 'HZ_PARTIES',x_return_status);
2470: END IF;
2471:
2472: IF (x_return_status =FND_API.G_RET_STS_SUCCESS) THEN
2473: do_contact_pref_transfer(p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,

Line 2670: 'HZ_ORGANIZATION_PROFILES','HZ_PARTIES',

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,
2674: x_return_status);

Line 3001: WHERE owner_table_name = 'HZ_PARTIES'

2997: SELECT contact_point_type,primary_flag, url, email_address,
2998: contact_point_purpose,phone_line_type, phone_country_code,
2999: phone_area_code,phone_number,phone_extension ,primary_by_purpose
3000: FROM HZ_CONTACT_POINTS
3001: WHERE owner_table_name = 'HZ_PARTIES'
3002: AND contact_point_id = p_from_id
3003: AND rownum=1;
3004:
3005: ----------------

Line 3067: AND OWNER_TABLE_NAME = 'HZ_PARTIES'

3063: INTO l_exists
3064: FROM HZ_CONTACT_POINTS
3065: WHERE PRIMARY_BY_PURPOSE = 'Y'
3066: AND CONTACT_POINT_PURPOSE = l_contact_point_purpose
3067: AND OWNER_TABLE_NAME = 'HZ_PARTIES'
3068: AND CONTACT_POINT_TYPE = l_contact_point_type
3069: AND OWNER_TABLE_ID = p_to_fk_id
3070: AND ROWNUM = 1;
3071: EXCEPTION

Line 3083: AND OWNER_TABLE_NAME = 'HZ_PARTIES'

3079: SELECT 'Exists'
3080: INTO l_exists
3081: FROM HZ_CONTACT_POINTS
3082: WHERE primary_flag = 'Y'
3083: AND OWNER_TABLE_NAME = 'HZ_PARTIES'
3084: AND CONTACT_POINT_TYPE= l_contact_point_type
3085: AND OWNER_TABLE_ID = p_to_fk_id
3086: AND ROWNUM = 1;
3087: EXCEPTION

Line 4067: AND PR.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

4063: AND OC.PARTY_RELATIONSHIP_ID = PR.RELATIONSHIP_ID
4064: AND PR.OBJECT_ID = PR2.OBJECT_ID
4065: AND PR2.RELATIONSHIP_ID = OC2.PARTY_RELATIONSHIP_ID
4066: AND OC2.ORG_CONTACT_ID = p_to_fk_id
4067: AND PR.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4068: AND PR.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4069: AND PR.DIRECTIONAL_FLAG = 'F'
4070: AND PR2.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4071: AND PR2.OBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 4068: AND PR.OBJECT_TABLE_NAME = 'HZ_PARTIES'

4064: AND PR.OBJECT_ID = PR2.OBJECT_ID
4065: AND PR2.RELATIONSHIP_ID = OC2.PARTY_RELATIONSHIP_ID
4066: AND OC2.ORG_CONTACT_ID = p_to_fk_id
4067: AND PR.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4068: AND PR.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4069: AND PR.DIRECTIONAL_FLAG = 'F'
4070: AND PR2.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4071: AND PR2.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4072: AND PR2.DIRECTIONAL_FLAG = 'F'

Line 4070: AND PR2.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

4066: AND OC2.ORG_CONTACT_ID = p_to_fk_id
4067: AND PR.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4068: AND PR.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4069: AND PR.DIRECTIONAL_FLAG = 'F'
4070: AND PR2.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4071: AND PR2.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4072: AND PR2.DIRECTIONAL_FLAG = 'F'
4073: AND ROWNUM = 1;
4074: EXCEPTION

Line 4071: AND PR2.OBJECT_TABLE_NAME = 'HZ_PARTIES'

4067: AND PR.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4068: AND PR.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4069: AND PR.DIRECTIONAL_FLAG = 'F'
4070: AND PR2.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4071: AND PR2.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4072: AND PR2.DIRECTIONAL_FLAG = 'F'
4073: AND ROWNUM = 1;
4074: EXCEPTION
4075: WHEN NO_DATA_FOUND THEN

Line 4217: AND OWNER_TABLE_NAME = 'HZ_PARTIES'

4213: SELECT 'Exists'
4214: INTO l_exists
4215: FROM HZ_CODE_ASSIGNMENTS
4216: WHERE primary_flag = 'Y'
4217: AND OWNER_TABLE_NAME = 'HZ_PARTIES'
4218: AND OWNER_TABLE_ID = p_to_fk_id
4219: AND CLASS_CATEGORY = l_class_category
4220: AND CONTENT_SOURCE_TYPE = l_cont_src
4221: AND ROWNUM = 1;

Line 4245: UPDATE hz_parties

4241:
4242: --bug 4582789
4243:
4244: IF l_primary_flag = 'Y' AND l_class_category = 'CUSTOMER_CATEGORY' THEN
4245: UPDATE hz_parties
4246: SET category_code = l_class_code,
4247: last_update_date = hz_utility_pub.last_update_date,
4248: last_updated_by = hz_utility_pub.user_id,
4249: last_update_login = hz_utility_pub.last_update_login

Line 5117: l_new_obj_party_name HZ_PARTIES.PARTY_NAME%TYPE;

5113: l_object_type HZ_RELATIONSHIPS.OBJECT_TYPE%TYPE;
5114: l_self_rel_flag VARCHAR2(1);
5115:
5116: l_rel_party_id HZ_RELATIONSHIPS.PARTY_ID%TYPE;
5117: l_new_obj_party_name HZ_PARTIES.PARTY_NAME%TYPE;
5118: l_subject_name HZ_PARTIES.PARTY_NAME%TYPE;
5119: l_rel_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;
5120: from_cont_source HZ_RELATIONSHIPS.ACTUAL_CONTENT_SOURCE%TYPE; --5404244
5121: from_cont_source_type HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM_TYPE%TYPE;

Line 5118: l_subject_name HZ_PARTIES.PARTY_NAME%TYPE;

5114: l_self_rel_flag VARCHAR2(1);
5115:
5116: l_rel_party_id HZ_RELATIONSHIPS.PARTY_ID%TYPE;
5117: l_new_obj_party_name HZ_PARTIES.PARTY_NAME%TYPE;
5118: l_subject_name HZ_PARTIES.PARTY_NAME%TYPE;
5119: l_rel_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;
5120: from_cont_source HZ_RELATIONSHIPS.ACTUAL_CONTENT_SOURCE%TYPE; --5404244
5121: from_cont_source_type HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM_TYPE%TYPE;
5122:

Line 5119: l_rel_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;

5115:
5116: l_rel_party_id HZ_RELATIONSHIPS.PARTY_ID%TYPE;
5117: l_new_obj_party_name HZ_PARTIES.PARTY_NAME%TYPE;
5118: l_subject_name HZ_PARTIES.PARTY_NAME%TYPE;
5119: l_rel_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;
5120: from_cont_source HZ_RELATIONSHIPS.ACTUAL_CONTENT_SOURCE%TYPE; --5404244
5121: from_cont_source_type HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM_TYPE%TYPE;
5122:
5123: --6696774 Start

Line 5283: from hz_parties sub , hz_parties obj , hz_parties rel

5279: if l_rel_party_id is not null then
5280:
5281: select sub.party_name , obj.party_name , rel.party_number
5282: into l_subject_name , l_new_obj_party_name , l_rel_party_number
5283: from hz_parties sub , hz_parties obj , hz_parties rel
5284: where sub.party_id = l_subject_id
5285: and obj.party_id = p_to_fk_id
5286: and rel.party_id = l_rel_party_id;
5287:

Line 5288: UPDATE HZ_PARTIES

5284: where sub.party_id = l_subject_id
5285: and obj.party_id = p_to_fk_id
5286: and rel.party_id = l_rel_party_id;
5287:
5288: UPDATE HZ_PARTIES
5289: SET PARTY_NAME = SUBSTRB(l_subject_name || '-' ||
5290: l_new_obj_party_name || '-' ||
5291: l_rel_party_number, 1, 360)
5292: WHERE party_id = l_rel_party_id;

Line 5383: from hz_parties sub , hz_parties obj , hz_parties rel

5379: if l_rel_party_id is not null then
5380:
5381: select sub.party_name , obj.party_name , rel.party_number
5382: into l_subject_name , l_new_obj_party_name , l_rel_party_number
5383: from hz_parties sub , hz_parties obj , hz_parties rel
5384: where sub.party_id = l_subject_id
5385: and obj.party_id = p_to_fk_id
5386: and rel.party_id = l_rel_party_id;
5387:

Line 5388: UPDATE HZ_PARTIES

5384: where sub.party_id = l_subject_id
5385: and obj.party_id = p_to_fk_id
5386: and rel.party_id = l_rel_party_id;
5387:
5388: UPDATE HZ_PARTIES
5389: SET PARTY_NAME = SUBSTRB(l_subject_name || '-' ||
5390: l_new_obj_party_name || '-' ||
5391: l_rel_party_number, 1, 360)
5392: WHERE party_id = l_rel_party_id;

Line 5415: UPDATE HZ_PARTIES

5411: program_update_date = sysdate
5412: WHERE relationship_id = p_from_id;
5413: ---Start of Bug:3880218----
5414: IF l_rel_party_id is not null THEN
5415: UPDATE HZ_PARTIES
5416: SET STATUS = 'I',
5417: last_update_date = hz_utility_pub.last_update_date,
5418: last_updated_by = hz_utility_pub.user_id,
5419: last_update_login = hz_utility_pub.last_update_login,

Line 5439: UPDATE HZ_PARTIES

5435: ----End of DlProject Phase2--------------------
5436: ELSE
5437: --bug 4867151--start
5438: IF l_rel_party_id is not null THEN
5439: UPDATE HZ_PARTIES
5440: SET STATUS = 'M',
5441: last_update_date = hz_utility_pub.last_update_date,
5442: last_updated_by = hz_utility_pub.user_id,
5443: last_update_login = hz_utility_pub.last_update_login,

Line 5574: l_new_subj_party_name HZ_PARTIES.PARTY_NAME%TYPE;

5570: l_object_type HZ_RELATIONSHIPS.OBJECT_TYPE%TYPE;
5571: l_self_rel_flag VARCHAR2(1);
5572:
5573: l_rel_party_id HZ_RELATIONSHIPS.PARTY_ID%TYPE;
5574: l_new_subj_party_name HZ_PARTIES.PARTY_NAME%TYPE;
5575: l_object_name HZ_PARTIES.PARTY_NAME%TYPE;
5576: l_rel_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;
5577: from_cont_source HZ_RELATIONSHIPS.ACTUAL_CONTENT_SOURCE%TYPE; --5404244
5578: from_cont_source_type HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM_TYPE%TYPE;

Line 5575: l_object_name HZ_PARTIES.PARTY_NAME%TYPE;

5571: l_self_rel_flag VARCHAR2(1);
5572:
5573: l_rel_party_id HZ_RELATIONSHIPS.PARTY_ID%TYPE;
5574: l_new_subj_party_name HZ_PARTIES.PARTY_NAME%TYPE;
5575: l_object_name HZ_PARTIES.PARTY_NAME%TYPE;
5576: l_rel_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;
5577: from_cont_source HZ_RELATIONSHIPS.ACTUAL_CONTENT_SOURCE%TYPE; --5404244
5578: from_cont_source_type HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM_TYPE%TYPE;
5579:

Line 5576: l_rel_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;

5572:
5573: l_rel_party_id HZ_RELATIONSHIPS.PARTY_ID%TYPE;
5574: l_new_subj_party_name HZ_PARTIES.PARTY_NAME%TYPE;
5575: l_object_name HZ_PARTIES.PARTY_NAME%TYPE;
5576: l_rel_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;
5577: from_cont_source HZ_RELATIONSHIPS.ACTUAL_CONTENT_SOURCE%TYPE; --5404244
5578: from_cont_source_type HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM_TYPE%TYPE;
5579:
5580: --6696774 start

Line 5745: from hz_parties sub , hz_parties obj , hz_parties rel

5741: if l_rel_party_id is not null then
5742:
5743: select sub.party_name , obj.party_name , rel.party_number
5744: into l_new_subj_party_name , l_object_name , l_rel_party_number
5745: from hz_parties sub , hz_parties obj , hz_parties rel
5746: where sub.party_id = p_to_fk_id
5747: and obj.party_id = l_object_id
5748: and rel.party_id = l_rel_party_id;
5749:

Line 5750: UPDATE HZ_PARTIES

5746: where sub.party_id = p_to_fk_id
5747: and obj.party_id = l_object_id
5748: and rel.party_id = l_rel_party_id;
5749:
5750: UPDATE HZ_PARTIES
5751: SET PARTY_NAME = SUBSTRB(l_new_subj_party_name || '-' ||
5752: l_object_name || '-' ||
5753: l_rel_party_number, 1, 360)
5754: WHERE party_id = l_rel_party_id;

Line 5842: from hz_parties sub , hz_parties obj , hz_parties rel

5838: if l_rel_party_id is not null then
5839:
5840: select sub.party_name , obj.party_name , rel.party_number
5841: into l_new_subj_party_name , l_object_name , l_rel_party_number
5842: from hz_parties sub , hz_parties obj , hz_parties rel
5843: where sub.party_id = p_to_fk_id
5844: and obj.party_id = l_object_id
5845: and rel.party_id = l_rel_party_id;
5846:

Line 5847: UPDATE HZ_PARTIES

5843: where sub.party_id = p_to_fk_id
5844: and obj.party_id = l_object_id
5845: and rel.party_id = l_rel_party_id;
5846:
5847: UPDATE HZ_PARTIES
5848: SET PARTY_NAME = SUBSTRB(l_new_subj_party_name || '-' ||
5849: l_object_name || '-' ||
5850: l_rel_party_number, 1, 360)
5851: WHERE party_id = l_rel_party_id;

Line 5875: UPDATE HZ_PARTIES

5871: WHERE relationship_id = p_from_id;
5872:
5873: ---Start of Bug:3880218----
5874: IF l_rel_party_id is not null THEN
5875: UPDATE HZ_PARTIES
5876: SET STATUS = 'I',
5877: last_update_date = hz_utility_pub.last_update_date,
5878: last_updated_by = hz_utility_pub.user_id,
5879: last_update_login = hz_utility_pub.last_update_login,

Line 5899: UPDATE HZ_PARTIES

5895: ----End of DlProject Phase2--------------------
5896: ---bug 4867151 start
5897: ELSE
5898: IF l_rel_party_id is not null THEN
5899: UPDATE HZ_PARTIES
5900: SET STATUS = 'M',
5901: last_update_date = hz_utility_pub.last_update_date,
5902: last_updated_by = hz_utility_pub.user_id,
5903: last_update_login = hz_utility_pub.last_update_login,

Line 5965: AND subject_table_name = 'HZ_PARTIES'

5961: CURSOR c_merge_to_party_reln IS
5962: SELECT relationship_id
5963: FROM HZ_RELATIONSHIPS --4500011
5964: WHERE party_id = p_to_fk_id
5965: AND subject_table_name = 'HZ_PARTIES'
5966: AND object_table_name = 'HZ_PARTIES'
5967: AND directional_flag = 'F';
5968:
5969: l_to_preln_id NUMBER;

Line 5966: AND object_table_name = 'HZ_PARTIES'

5962: SELECT relationship_id
5963: FROM HZ_RELATIONSHIPS --4500011
5964: WHERE party_id = p_to_fk_id
5965: AND subject_table_name = 'HZ_PARTIES'
5966: AND object_table_name = 'HZ_PARTIES'
5967: AND directional_flag = 'F';
5968:
5969: l_to_preln_id NUMBER;
5970:

Line 6281: HZ_PARTIES p

6277:
6278: CURSOR c_from_party_type IS
6279: SELECT party_type
6280: FROM HZ_PARTY_SITES ps,
6281: HZ_PARTIES p
6282: WHERE ps.party_id = p.party_id
6283: AND ps.party_site_id = p_from_id;
6284:
6285: l_from_last_upd_date DATE;

Line 6325: l_from_party_type HZ_PARTIES.PARTY_TYPE%TYPE;

6321: --l_loc_id HZ_LOC_ASSIGNMENTS.LOC_ID%TYPE; bug 4569674
6322: --l_org_id HZ_LOC_ASSIGNMENTS.ORG_ID%TYPE;
6323: l_from_location_id HZ_LOCATIONS.LOCATION_ID%TYPE;
6324: l_to_location_id HZ_LOCATIONS.LOCATION_ID%TYPE;
6325: l_from_party_type HZ_PARTIES.PARTY_TYPE%TYPE;
6326: to_party_loc_id HZ_LOCATIONS.LOCATION_ID%TYPE;
6327: map_ps_id HZ_PARTY_SITES.PARTY_SITE_ID%TYPE;
6328: BEGIN
6329:

Line 6422: FROM hz_parties p,

6418: UPDATE HZ_PARTY_SITES
6419: SET location_id = l_to_location_id
6420: WHERE party_site_id IN (
6421: SELECT psr.party_site_id
6422: FROM hz_parties p,
6423: hz_party_sites psr,
6424: hz_party_sites pso,
6425: hz_relationships r
6426: WHERE pso.party_site_id = p_from_id

Line 6446: UPDATE hz_parties

6442:
6443: IF (l_from_party_id = l_to_party_id )THEN
6444: IF(l_ident_flag = 'Y') THEN
6445: IF l_cont_source_to = 'USER_ENTERED' THEN
6446: UPDATE hz_parties
6447: SET country = l_country,
6448: address1 = l_address1,
6449: address2 = l_address2,
6450: address3 = l_address3,

Line 6472: UPDATE hz_parties

6468: identifying_address_flag = 'N'
6469: WHERE party_site_id = p_from_id;
6470:
6471: END IF;
6472: UPDATE hz_parties
6473: SET country = l_country,
6474: address1 = l_address1,
6475: address2 = l_address2,
6476: address3 = l_address3,

Line 6726: FROM HZ_PARTIES

6722: ) IS
6723:
6724: CURSOR c_party_type(cp_party_id NUMBER) IS
6725: SELECT party_type
6726: FROM HZ_PARTIES
6727: WHERE party_id = cp_party_id;
6728:
6729: CURSOR c_duns IS
6730: SELECT duns_number_c, last_update_date, organization_profile_id

Line 6752: AND subject_table_name = 'HZ_PARTIES'

6748: WHERE content_source_type = 'DNB'
6749: AND subject_id = p_from_id
6750: AND object_id = x_to_id
6751: AND RELATIONSHIP_CODE = 'HEADQUARTERS_OF'
6752: AND subject_table_name = 'HZ_PARTIES'
6753: AND object_table_name = 'HZ_PARTIES'
6754: AND directional_flag = 'F';
6755:
6756: l_from_party_type HZ_PARTIES.PARTY_TYPE%TYPE;

Line 6753: AND object_table_name = 'HZ_PARTIES'

6749: AND subject_id = p_from_id
6750: AND object_id = x_to_id
6751: AND RELATIONSHIP_CODE = 'HEADQUARTERS_OF'
6752: AND subject_table_name = 'HZ_PARTIES'
6753: AND object_table_name = 'HZ_PARTIES'
6754: AND directional_flag = 'F';
6755:
6756: l_from_party_type HZ_PARTIES.PARTY_TYPE%TYPE;
6757: l_to_party_type HZ_PARTIES.PARTY_TYPE%TYPE;

Line 6756: l_from_party_type HZ_PARTIES.PARTY_TYPE%TYPE;

6752: AND subject_table_name = 'HZ_PARTIES'
6753: AND object_table_name = 'HZ_PARTIES'
6754: AND directional_flag = 'F';
6755:
6756: l_from_party_type HZ_PARTIES.PARTY_TYPE%TYPE;
6757: l_to_party_type HZ_PARTIES.PARTY_TYPE%TYPE;
6758: l_from_duns_number VARCHAR2(255);
6759: l_to_duns_number VARCHAR2(255);
6760: l_temp NUMBER;

Line 6757: l_to_party_type HZ_PARTIES.PARTY_TYPE%TYPE;

6753: AND object_table_name = 'HZ_PARTIES'
6754: AND directional_flag = 'F';
6755:
6756: l_from_party_type HZ_PARTIES.PARTY_TYPE%TYPE;
6757: l_to_party_type HZ_PARTIES.PARTY_TYPE%TYPE;
6758: l_from_duns_number VARCHAR2(255);
6759: l_to_duns_number VARCHAR2(255);
6760: l_temp NUMBER;
6761:

Line 6806: UPDATE HZ_PARTIES

6802: RETURN;
6803: END IF;
6804:
6805: -- Update and set status to merged
6806: UPDATE HZ_PARTIES
6807: SET
6808: STATUS = 'M',
6809: last_update_date = hz_utility_pub.last_update_date,
6810: last_updated_by = hz_utility_pub.user_id,

Line 6827: p_owner_table_name =>'HZ_PARTIES',

6823: p_init_msg_list => FND_API.G_FALSE,
6824: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
6825: p_old_owner_table_id => p_from_id,
6826: p_new_owner_table_id => x_to_id,
6827: p_owner_table_name =>'HZ_PARTIES',
6828: p_orig_system => null,
6829: p_orig_system_reference => null,
6830: p_reason_code => 'MERGED',
6831: x_return_status => x_return_status,

Line 6937: -- Private procedure to denormalize some type of contact point to hz_parties.

6933: --
6934: -- PRIVATE PROCEDURE do_denormalize_contact_point
6935: --
6936: -- DESCRIPTION
6937: -- Private procedure to denormalize some type of contact point to hz_parties.
6938: --
6939: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
6940: --
6941: -- ARGUMENTS

Line 6978: UPDATE hz_parties

6974: ) IS
6975: BEGIN
6976:
6977: IF p_contact_point_type = 'WEB' THEN
6978: UPDATE hz_parties
6979: SET url = p_url,
6980: last_update_date = hz_utility_v2pub.last_update_date,
6981: last_updated_by = hz_utility_v2pub.last_updated_by,
6982: last_update_login = hz_utility_v2pub.last_update_login,

Line 6989: UPDATE hz_parties

6985: program_id = hz_utility_v2pub.program_id,
6986: program_update_date = sysdate
6987: WHERE party_id = p_party_id;
6988: ELSIF p_contact_point_type = 'EMAIL' THEN
6989: UPDATE hz_parties
6990: SET email_address = p_email_address,
6991: last_update_date = hz_utility_v2pub.last_update_date,
6992: last_updated_by = hz_utility_v2pub.last_updated_by,
6993: last_update_login = hz_utility_v2pub.last_update_login,

Line 7000: UPDATE hz_parties

6996: program_id = hz_utility_v2pub.program_id,
6997: program_update_date = sysdate
6998: WHERE party_id = p_party_id;
6999: ELSIF p_contact_point_type = 'PHONE' THEN
7000: UPDATE hz_parties
7001: SET primary_phone_contact_pt_id = p_phone_contact_pt_id,
7002: primary_phone_purpose = p_phone_purpose,
7003: primary_phone_line_type = p_phone_line_type,
7004: primary_phone_country_code = p_phone_country_code,