APPS.HZ_MERGE_PKG dependencies on HZ_CUST_ACCOUNT_ROLES

Line 1057: 'HZ_CUST_ACCOUNT_ROLES','HZ_PARTIES',

1053:
1054: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
1055: p_to_fk_id, p_par_entity_name,
1056: 'HZ_MERGE_PKG.cust_account_role_merge',
1057: 'HZ_CUST_ACCOUNT_ROLES','HZ_PARTIES',
1058: 'CUST_ACCOUNT_ROLE_ID', 'PARTY_ID',x_return_status);
1059: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
1060: l_dup_exists := HZ_MERGE_DUP_CHECK.check_cust_account_role_dup(
1061: p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,

Line 2821: FROM HZ_CUST_ACCOUNT_ROLES

2817: --Start of Bug No : 3373079
2818: l_g_miss_num NUMBER;
2819: CURSOR c_from_acct_role_det IS
2820: SELECT cust_account_id,cust_acct_site_id
2821: FROM HZ_CUST_ACCOUNT_ROLES
2822: WHERE cust_account_role_id = p_from_id
2823: --AND party_id = p_from_fk_id
2824: AND NVL(STATUS,'A') = 'A';
2825:

Line 2828: FROM HZ_CUST_ACCOUNT_ROLES

2824: AND NVL(STATUS,'A') = 'A';
2825:
2826: CURSOR c_to_acct_role_det(p_acct_id NUMBER,p_acct_site_id NUMBER) IS
2827: SELECT count(1)
2828: FROM HZ_CUST_ACCOUNT_ROLES
2829: WHERE party_id = p_to_fk_id
2830: AND cust_account_id = p_acct_id
2831: AND NVL(cust_acct_site_id,l_g_miss_num) = NVL(p_acct_site_id,l_g_miss_num)
2832: AND NVL(STATUS,'A') = 'A';

Line 2844: UPDATE HZ_CUST_ACCOUNT_ROLES

2840: l_g_miss_num := FND_API.G_MISS_NUM;
2841:
2842: IF (x_to_id <> FND_API.G_MISS_NUM AND
2843: x_to_id <> p_from_id) THEN
2844: UPDATE HZ_CUST_ACCOUNT_ROLES
2845: SET
2846: STATUS = 'M',
2847: last_update_date = hz_utility_pub.last_update_date,
2848: last_updated_by = hz_utility_pub.user_id,

Line 2861: p_owner_table_name =>'HZ_CUST_ACCOUNT_ROLES',

2857: p_init_msg_list => FND_API.G_FALSE,
2858: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
2859: p_old_owner_table_id => p_from_id,
2860: p_new_owner_table_id => x_to_id,
2861: p_owner_table_name =>'HZ_CUST_ACCOUNT_ROLES',
2862: p_orig_system => null,
2863: p_orig_system_reference => null,
2864: p_reason_code => 'MERGED',
2865: x_return_status => x_return_status,

Line 2896: UPDATE HZ_CUST_ACCOUNT_ROLES

2892: END IF;
2893: END IF;
2894: --End of Bug No : 3373079
2895: -- Update and set party_id = p_to_fk_id where pk = from_id
2896: UPDATE HZ_CUST_ACCOUNT_ROLES
2897: SET
2898: party_id = p_to_fk_id,
2899: status = l_status,
2900: last_update_date = hz_utility_pub.last_update_date,