DBA Data[Home] [Help]

APPS.HZ_MERGE_PKG dependencies on HZ_CUST_ACCT_SITES_ALL

Line 1104: 'HZ_CUST_ACCT_SITES_ALL','HZ_PARTY_SITES',

1100:
1101: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
1102: p_to_fk_id, p_par_entity_name,
1103: 'HZ_MERGE_PKG.cust_account_site_merge',
1104: 'HZ_CUST_ACCT_SITES_ALL','HZ_PARTY_SITES',
1105: 'CUST_ACCT_SITE_ID', 'PARTY_SITE_ID',x_return_status);
1106:
1107: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
1108: l_dup_exists := HZ_MERGE_DUP_CHECK.check_cust_account_site_dup(

Line 4613: UPDATE HZ_CUST_ACCT_SITES_ALL

4609: BEGIN
4610:
4611: IF (x_to_id <> FND_API.G_MISS_NUM AND
4612: x_to_id <> p_from_id) THEN
4613: UPDATE HZ_CUST_ACCT_SITES_ALL
4614: SET
4615: STATUS = 'M',
4616: last_update_date = hz_utility_pub.last_update_date,
4617: last_updated_by = hz_utility_pub.user_id,

Line 4630: p_owner_table_name =>'HZ_CUST_ACCT_SITES_ALL',

4626: p_init_msg_list => FND_API.G_FALSE,
4627: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
4628: p_old_owner_table_id => p_from_id,
4629: p_new_owner_table_id => x_to_id,
4630: p_owner_table_name =>'HZ_CUST_ACCT_SITES_ALL',
4631: p_orig_system => null,
4632: p_orig_system_reference => null,
4633: p_reason_code => 'MERGED',
4634: x_return_status => x_return_status,

Line 4646: UPDATE HZ_CUST_ACCT_SITES_ALL

4642: RETURN;
4643: END IF;
4644:
4645: ELSE
4646: UPDATE HZ_CUST_ACCT_SITES_ALL
4647: SET
4648: party_site_id = p_to_fk_id,
4649: last_update_date = hz_utility_pub.last_update_date,
4650: last_updated_by = hz_utility_pub.user_id,