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

6024: ) IS
6025:
6026: CURSOR c_merge_to_org_prof(cp_cont_source VARCHAR2) IS
6027: SELECT organization_profile_id, last_update_date, duns_number_c
6028: FROM HZ_ORGANIZATION_PROFILES
6029: WHERE party_id = p_to_fk_id
6030: AND effective_end_date is null
6031: AND ACTUAL_CONTENT_SOURCE = cp_cont_source;
6032:

Line 6035: FROM HZ_ORGANIZATION_PROFILES

6031: AND ACTUAL_CONTENT_SOURCE = cp_cont_source;
6032:
6033: CURSOR c_cont_source IS
6034: SELECT ACTUAL_CONTENT_SOURCE, last_update_date, duns_number_c
6035: FROM HZ_ORGANIZATION_PROFILES
6036: WHERE organization_profile_id = p_from_id;
6037:
6038: l_cont_source VARCHAR2(50);
6039: l_to_orgpro_id NUMBER;

Line 6136: UPDATE HZ_ORGANIZATION_PROFILES

6132: END IF;
6133: END IF;
6134: END IF;
6135:
6136: UPDATE HZ_ORGANIZATION_PROFILES
6137: SET
6138: STATUS = 'M',
6139: effective_end_date = trunc(SYSDATE-1),
6140: last_update_date = hz_utility_pub.last_update_date,

Line 6731: FROM HZ_ORGANIZATION_PROFILES

6727: WHERE party_id = cp_party_id;
6728:
6729: CURSOR c_duns IS
6730: SELECT duns_number_c, last_update_date, organization_profile_id
6731: FROM HZ_ORGANIZATION_PROFILES
6732: WHERE party_id = p_from_id
6733: AND EFFECTIVE_END_DATE IS NULL
6734: AND actual_content_source = 'DNB'
6735: AND nvl(status, 'A') = 'A';

Line 6739: FROM HZ_ORGANIZATION_PROFILES

6735: AND nvl(status, 'A') = 'A';
6736:
6737: CURSOR c_duns1 IS
6738: SELECT duns_number_c , last_update_date, organization_profile_id
6739: FROM HZ_ORGANIZATION_PROFILES
6740: WHERE party_id = x_to_id
6741: AND EFFECTIVE_END_DATE IS NULL
6742: AND actual_content_source = 'DNB'
6743: AND nvl(status, 'A') = 'A';

Line 6861: UPDATE HZ_ORGANIZATION_PROFILES

6857: ) IS
6858:
6859: BEGIN
6860:
6861: UPDATE HZ_ORGANIZATION_PROFILES
6862: SET
6863: displayed_duns_party_id = p_to_fk_id,
6864: last_update_date = hz_utility_pub.last_update_date,
6865: last_updated_by = hz_utility_pub.user_id,