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 3988: l_role_type HZ_ORG_CONTACT_ROLES.ROLE_TYPE%TYPE;

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

Line 3992: FROM HZ_ORG_CONTACT_ROLES

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

Line 3998: UPDATE HZ_ORG_CONTACT_ROLES

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

Line 4015: p_owner_table_name =>'HZ_ORG_CONTACT_ROLES',

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

Line 4041: FROM HZ_ORG_CONTACT_ROLES

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

Line 4057: HZ_ORG_CONTACT_ROLES OCR,

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

Line 4081: UPDATE HZ_ORG_CONTACT_ROLES

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