APPS.HZ_PROFILE_MERGE_PKG dependencies on HZ_CUSTOMER_PROFILES

Line 47: p_entity_name => 'HZ_CUSTOMER_PROFILES',

43:
44: x_return_status := FND_API.G_RET_STS_SUCCESS;
45:
46: hz_merge_pkg.check_params(
47: p_entity_name => 'HZ_CUSTOMER_PROFILES',
48: p_from_id => p_from_id,
49: p_to_id => x_to_id,
50: p_from_fk_id => p_from_fk_id,
51: p_to_fk_id => p_to_fk_id,

Line 54: p_exp_ent_name => 'HZ_CUSTOMER_PROFILES',

50: p_from_fk_id => p_from_fk_id,
51: p_to_fk_id => p_to_fk_id,
52: p_par_entity_name => 'HZ_PARTIES',
53: p_proc_name => 'HZ_MERGE_PKG.party_profile_merge',
54: p_exp_ent_name => 'HZ_CUSTOMER_PROFILES',
55: p_exp_par_ent_name => 'HZ_PARTIES',
56: p_pk_column => 'CUST_ACCOUNT_PROFILE_ID',
57: p_par_pk_column => 'PARTY_ID',
58: x_return_status => x_return_status );

Line 179: FROM hz_customer_profiles

175: cust_account_id,
176: party_id,
177: site_use_id,
178: status
179: FROM hz_customer_profiles
180: WHERE cust_account_profile_id = p_from_id;
181:
182: CURSOR c_to_party_profile
183: IS

Line 188: FROM hz_customer_profiles

184: SELECT cust_account_profile_id,
185: cust_account_id,
186: party_id,
187: site_use_id
188: FROM hz_customer_profiles
189: WHERE party_id = p_to_fk_id
190: AND cust_account_id = -1;
191:
192: l_from_rec c_from_profile%ROWTYPE;

Line 206: UPDATE hz_customer_profiles

202: IF l_from_rec.site_use_id IS NOT NULL THEN
203:
204: -- Site Use Level Stuff
205: -- Transfert
206: UPDATE hz_customer_profiles
207: SET party_id = p_to_fk_id,
208: last_update_date = hz_utility_pub.last_update_date,
209: last_updated_by = hz_utility_pub.user_id,
210: last_update_login = hz_utility_pub.last_update_login,

Line 222: UPDATE hz_customer_profiles

218: ELSIF l_from_rec.cust_account_id <> -1 THEN
219:
220: -- Account Level Stuff
221: -- Transfert
222: UPDATE hz_customer_profiles
223: SET party_id = p_to_fk_id,
224: last_update_date = hz_utility_pub.last_update_date,
225: last_updated_by = hz_utility_pub.user_id,
226: last_update_login = hz_utility_pub.last_update_login,

Line 242: UPDATE hz_customer_profiles

238: FETCH c_to_party_profile INTO l_to_party_rec;
239: IF c_to_party_profile%NOTFOUND THEN
240:
241: -- Transfert Party Profile
242: UPDATE hz_customer_profiles
243: SET party_id = p_to_fk_id,
244: last_update_date = hz_utility_pub.last_update_date,
245: last_updated_by = hz_utility_pub.user_id,
246: last_update_login = hz_utility_pub.last_update_login,

Line 261: UPDATE hz_customer_profiles

257: IF l_from_rec.status = 'A' OR l_from_rec.status IS NULL THEN
258: do_profile_amt_transf(p_from_id, x_to_id, x_return_status );
259: END IF;
260:
261: UPDATE hz_customer_profiles
262: SET status = 'M',
263: last_update_date = hz_utility_pub.last_update_date,
264: last_updated_by = hz_utility_pub.user_id,
265: last_update_login = hz_utility_pub.last_update_login,