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_CONTACT_POINTS

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 1284: 'HZ_CONTACT_POINTS',

1280:
1281: HZ_DQM_SYNC.stage_contact_point_merge(
1282: 'HZ_STAGED_CONTACT_POINTS',
1283: p_from_id,l_dummy_id,p_from_id,p_from_id,
1284: 'HZ_CONTACT_POINTS',
1285: p_batch_id,p_batch_party_id,x_return_status);
1286: END LOOP;
1287: END IF;
1288:

Line 2371: 'HZ_CONTACT_POINTS','HZ_PARTY_SITES',

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

Line 2394: 'HZ_CONTACT_POINTS',

2390:
2391: HZ_DQM_SYNC.stage_contact_point_merge(
2392: 'HZ_STAGED_CONTACT_POINTS',
2393: p_from_id,l_dummy_id,p_from_id,p_from_id,
2394: 'HZ_CONTACT_POINTS',
2395: p_batch_id,p_batch_party_id,x_return_status);
2396: END LOOP;
2397: END IF;
2398:

Line 2620: 'HZ_CONTACT_PREFERENCES','HZ_CONTACT_POINTS',

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

Line 2626: 'HZ_CONTACT_POINTS',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
2624: l_dup_exists := HZ_MERGE_DUP_CHECK.check_contact_preference_dup(
2625: p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,
2626: 'HZ_CONTACT_POINTS',x_return_status);
2627: END IF;
2628:
2629: IF (x_return_status =FND_API.G_RET_STS_SUCCESS) THEN
2630: do_contact_pref_transfer(p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,

Line 3000: FROM HZ_CONTACT_POINTS

2996: CURSOR c_fp_cpt_details IS
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:

Line 3010: UPDATE HZ_CONTACT_POINTS

3006: BEGIN
3007:
3008: IF (x_to_id <> FND_API.G_MISS_NUM AND
3009: x_to_id <> p_from_id) THEN
3010: UPDATE HZ_CONTACT_POINTS
3011: SET
3012: STATUS = 'M',
3013: last_update_date = hz_utility_pub.last_update_date,
3014: last_updated_by = hz_utility_pub.user_id,

Line 3030: p_owner_table_name =>'HZ_CONTACT_POINTS',

3026: p_init_msg_list => FND_API.G_FALSE,
3027: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
3028: p_old_owner_table_id => p_from_id,
3029: p_new_owner_table_id => x_to_id,
3030: p_owner_table_name =>'HZ_CONTACT_POINTS',
3031: p_orig_system => null,
3032: p_orig_system_reference => null,
3033: p_reason_code => 'MERGED',
3034: x_return_status => x_return_status,

Line 3063: FROM HZ_CONTACT_POINTS

3059: IF l_fp_pri_pur_flag = 'Y' THEN
3060: BEGIN
3061: SELECT 'Exists'
3062: INTO l_exists
3063: FROM HZ_CONTACT_POINTS
3064: WHERE PRIMARY_BY_PURPOSE = 'Y'
3065: AND CONTACT_POINT_PURPOSE = l_contact_point_purpose
3066: AND OWNER_TABLE_NAME = 'HZ_PARTIES'
3067: AND CONTACT_POINT_TYPE = l_contact_point_type

Line 3080: FROM HZ_CONTACT_POINTS

3076: IF l_fp_primary_flag = 'Y' THEN
3077: BEGIN
3078: SELECT 'Exists'
3079: INTO l_exists
3080: FROM HZ_CONTACT_POINTS
3081: WHERE primary_flag = 'Y'
3082: AND OWNER_TABLE_NAME = 'HZ_PARTIES'
3083: AND CONTACT_POINT_TYPE= l_contact_point_type
3084: AND OWNER_TABLE_ID = p_to_fk_id

Line 3112: UPDATE HZ_CONTACT_POINTS

3108: END IF;
3109:
3110: -----------------------
3111: -- Update and set party_id = p_to_fk_id where pk = from_id
3112: UPDATE HZ_CONTACT_POINTS
3113: SET
3114: owner_table_id = p_to_fk_id,
3115: primary_flag = l_primary_flag,
3116: primary_by_purpose = l_pri_purpose_flag,

Line 3152: l_contact_point_purpose HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%TYPE;

3148: l_fp_pri_purpose_flag VARCHAR2(1);
3149: l_primary_flag VARCHAR2(1):='N';
3150: l_pri_purpose_flag VARCHAR2(1):='N';
3151: l_contact_point_type VARCHAR2(30);
3152: l_contact_point_purpose HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%TYPE;
3153:
3154: CURSOR c_fp_cpt_details IS
3155: SELECT contact_point_type, contact_point_purpose,primary_flag,primary_by_purpose
3156: FROM HZ_CONTACT_POINTS

Line 3156: FROM HZ_CONTACT_POINTS

3152: l_contact_point_purpose HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%TYPE;
3153:
3154: CURSOR c_fp_cpt_details IS
3155: SELECT contact_point_type, contact_point_purpose,primary_flag,primary_by_purpose
3156: FROM HZ_CONTACT_POINTS
3157: WHERE owner_table_name = 'HZ_PARTY_SITES'
3158: AND contact_point_id = p_from_id
3159: AND rownum=1;
3160:

Line 3167: UPDATE HZ_CONTACT_POINTS

3163:
3164: IF (x_to_id <> FND_API.G_MISS_NUM AND
3165: x_to_id <> p_from_id) THEN
3166: -- Update and set status to merged
3167: UPDATE HZ_CONTACT_POINTS
3168: SET
3169: STATUS = 'M',
3170: last_update_date = hz_utility_pub.last_update_date,
3171: last_updated_by = hz_utility_pub.user_id,

Line 3187: p_owner_table_name =>'HZ_CONTACT_POINTS',

3183: p_init_msg_list => FND_API.G_FALSE,
3184: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
3185: p_old_owner_table_id => p_from_id,
3186: p_new_owner_table_id => x_to_id,
3187: p_owner_table_name =>'HZ_CONTACT_POINTS',
3188: p_orig_system => null,
3189: p_orig_system_reference => null,
3190: p_reason_code => 'MERGED',
3191: x_return_status => x_return_status,

Line 3212: FROM HZ_CONTACT_POINTS

3208: IF l_fp_pri_purpose_flag = 'Y' THEN
3209: BEGIN
3210: SELECT 'Exists'
3211: INTO l_exists
3212: FROM HZ_CONTACT_POINTS
3213: WHERE PRIMARY_BY_PURPOSE = 'Y'
3214: AND CONTACT_POINT_PURPOSE = l_contact_point_purpose
3215: AND OWNER_TABLE_NAME = 'HZ_PARTY_SITES'
3216: AND CONTACT_POINT_TYPE = l_contact_point_type

Line 3230: FROM HZ_CONTACT_POINTS

3226: IF l_fp_primary_flag = 'Y' THEN
3227: BEGIN
3228: SELECT 'Exists'
3229: INTO l_exists
3230: FROM HZ_CONTACT_POINTS
3231: WHERE PRIMARY_FLAG = 'Y'
3232: AND OWNER_TABLE_NAME = 'HZ_PARTY_SITES'
3233: AND OWNER_TABLE_ID = p_to_fk_id
3234: AND CONTACT_POINT_TYPE = l_contact_point_type

Line 3243: UPDATE HZ_CONTACT_POINTS

3239: END;
3240: END IF;
3241:
3242: -- Update and set party_id = p_to_fk_id where pk = from_id
3243: UPDATE HZ_CONTACT_POINTS
3244: SET
3245: owner_table_id = p_to_fk_id,
3246: primary_flag = l_primary_flag,
3247: primary_by_purpose = l_pri_purpose_flag,