APPS.HZ_MERGE_PKG dependencies on HZ_ORG_CONTACT_ROLES

Line 2173: 'HZ_ORG_CONTACT_ROLES','HZ_ORG_CONTACTS',

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
2177: l_dup_exists := HZ_MERGE_DUP_CHECK.check_org_contact_role_dup(

Line 3986: l_role_type HZ_ORG_CONTACT_ROLES.ROLE_TYPE%TYPE;

3982: l_primary_flag VARCHAR2(1) := 'N';
3983: l_fp_primary_flag VARCHAR2(1) ;
3984: l_fp_primary_role_flag VARCHAR2(1) ;
3985: l_primary_role_flag VARCHAR2(1) := 'N';
3986: l_role_type HZ_ORG_CONTACT_ROLES.ROLE_TYPE%TYPE;
3987: l_exists VARCHAR2(10);
3988: CURSOR from_contact_role IS
3989: SELECT role_type,primary_flag,primary_contact_per_role_type
3990: FROM HZ_ORG_CONTACT_ROLES

Line 3990: FROM HZ_ORG_CONTACT_ROLES

3986: l_role_type HZ_ORG_CONTACT_ROLES.ROLE_TYPE%TYPE;
3987: l_exists VARCHAR2(10);
3988: CURSOR from_contact_role IS
3989: SELECT role_type,primary_flag,primary_contact_per_role_type
3990: FROM HZ_ORG_CONTACT_ROLES
3991: WHERE ORG_CONTACT_ROLE_ID = p_from_id;
3992: BEGIN
3993:
3994: IF (x_to_id <> FND_API.G_MISS_NUM AND

Line 3996: UPDATE HZ_ORG_CONTACT_ROLES

3992: BEGIN
3993:
3994: IF (x_to_id <> FND_API.G_MISS_NUM AND
3995: x_to_id <> p_from_id) THEN
3996: UPDATE HZ_ORG_CONTACT_ROLES
3997: SET
3998: STATUS = 'M',
3999: last_update_date = hz_utility_pub.last_update_date,
4000: last_updated_by = hz_utility_pub.user_id,

Line 4013: p_owner_table_name =>'HZ_ORG_CONTACT_ROLES',

4009: p_init_msg_list => FND_API.G_FALSE,
4010: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
4011: p_old_owner_table_id => p_from_id,
4012: p_new_owner_table_id => x_to_id,
4013: p_owner_table_name =>'HZ_ORG_CONTACT_ROLES',
4014: p_orig_system => null,
4015: p_orig_system_reference => null,
4016: p_reason_code => 'MERGED',
4017: x_return_status => x_return_status,

Line 4039: FROM HZ_ORG_CONTACT_ROLES

4035: IF l_fp_primary_flag = 'Y' THEN
4036: BEGIN
4037: SELECT 'Exists'
4038: INTO l_exists
4039: FROM HZ_ORG_CONTACT_ROLES
4040: WHERE PRIMARY_FLAG = 'Y'
4041: AND ORG_CONTACT_ID = p_to_fk_id
4042: AND ROWNUM = 1;
4043: EXCEPTION

Line 4055: HZ_ORG_CONTACT_ROLES OCR,

4051: SELECT 'Exists'
4052: INTO l_exists
4053: FROM HZ_RELATIONSHIPS PR,
4054: HZ_ORG_CONTACTS OC,
4055: HZ_ORG_CONTACT_ROLES OCR,
4056: HZ_RELATIONSHIPS PR2,
4057: HZ_ORG_CONTACTS OC2
4058: WHERE OCR.PRIMARY_CONTACT_PER_ROLE_TYPE = 'Y'
4059: AND OCR.ROLE_TYPE = l_role_type

Line 4079: UPDATE HZ_ORG_CONTACT_ROLES

4075: END;
4076: END IF;
4077:
4078: -- Update and set party_id = p_to_fk_id where pk = from_id
4079: UPDATE HZ_ORG_CONTACT_ROLES
4080: SET
4081: org_contact_id = p_to_fk_id,
4082: primary_flag = l_primary_flag,
4083: primary_contact_per_role_type = l_primary_role_flag,