APPS.HZ_MERGE_PKG dependencies on HZ_ORGANIZATION_PROFILES

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 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 5898: FROM HZ_ORGANIZATION_PROFILES

5894: ) IS
5895:
5896: CURSOR c_merge_to_org_prof(cp_cont_source VARCHAR2) IS
5897: SELECT organization_profile_id, last_update_date, duns_number_c
5898: FROM HZ_ORGANIZATION_PROFILES
5899: WHERE party_id = p_to_fk_id
5900: AND effective_end_date is null
5901: AND ACTUAL_CONTENT_SOURCE = cp_cont_source;
5902:

Line 5905: FROM HZ_ORGANIZATION_PROFILES

5901: AND ACTUAL_CONTENT_SOURCE = cp_cont_source;
5902:
5903: CURSOR c_cont_source IS
5904: SELECT ACTUAL_CONTENT_SOURCE, last_update_date, duns_number_c
5905: FROM HZ_ORGANIZATION_PROFILES
5906: WHERE organization_profile_id = p_from_id;
5907:
5908: l_cont_source VARCHAR2(50);
5909: l_to_orgpro_id NUMBER;

Line 6006: UPDATE HZ_ORGANIZATION_PROFILES

6002: END IF;
6003: END IF;
6004: END IF;
6005:
6006: UPDATE HZ_ORGANIZATION_PROFILES
6007: SET
6008: STATUS = 'M',
6009: effective_end_date = trunc(SYSDATE-1),
6010: last_update_date = hz_utility_pub.last_update_date,

Line 6603: FROM HZ_ORGANIZATION_PROFILES

6599: WHERE party_id = cp_party_id;
6600:
6601: CURSOR c_duns IS
6602: SELECT duns_number_c, last_update_date, organization_profile_id
6603: FROM HZ_ORGANIZATION_PROFILES
6604: WHERE party_id = p_from_id
6605: AND EFFECTIVE_END_DATE IS NULL
6606: AND actual_content_source = 'DNB'
6607: AND nvl(status, 'A') = 'A';

Line 6611: FROM HZ_ORGANIZATION_PROFILES

6607: AND nvl(status, 'A') = 'A';
6608:
6609: CURSOR c_duns1 IS
6610: SELECT duns_number_c , last_update_date, organization_profile_id
6611: FROM HZ_ORGANIZATION_PROFILES
6612: WHERE party_id = x_to_id
6613: AND EFFECTIVE_END_DATE IS NULL
6614: AND actual_content_source = 'DNB'
6615: AND nvl(status, 'A') = 'A';

Line 6733: UPDATE HZ_ORGANIZATION_PROFILES

6729: ) IS
6730:
6731: BEGIN
6732:
6733: UPDATE HZ_ORGANIZATION_PROFILES
6734: SET
6735: displayed_duns_party_id = p_to_fk_id,
6736: last_update_date = hz_utility_pub.last_update_date,
6737: last_updated_by = hz_utility_pub.user_id,