APPS.AR_CMGT_PARTY_MERGE dependencies on AR_CUSTOMER_CALLS_ALL

Line 236: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Party Merge for AR_CUSTOMER_CALLS_ALL(+)');

232:
233:
234: BEGIN
235:
236: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Party Merge for AR_CUSTOMER_CALLS_ALL(+)');
237:
238:
239: x_return_status := FND_API.G_RET_STS_SUCCESS;
240:

Line 272: -- For AR_CUSTOMER_CALLS_ALL table, if party_id 1000 got merged to party_id 2000

268:
269:
270: -- If the parent has changed(ie. Parent is getting merged) then transfer the
271: -- dependent record to the new parent.
272: -- For AR_CUSTOMER_CALLS_ALL table, if party_id 1000 got merged to party_id 2000
273: -- then, we have to update all records with customer_id = 1000 to 2000
274:
275: if p_from_fk_id <> p_to_fk_id then
276:

Line 278: UPDATE AR_CUSTOMER_CALLS_ALL

274:
275: if p_from_fk_id <> p_to_fk_id then
276:
277:
278: UPDATE AR_CUSTOMER_CALLS_ALL
279: SET phone_id = p_to_fk_id,
280: last_update_date = hz_utility_pub.last_update_date,
281: last_updated_by = hz_utility_pub.user_id,
282: last_update_login = hz_utility_pub.last_update_login

Line 288: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Party Merge for AR_CUSTOMER_CALLS_ALL(-)');

284: phone_id = p_from_fk_id;
285:
286: end if;
287:
288: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Party Merge for AR_CUSTOMER_CALLS_ALL(-)');
289:
290: exception
291: when others then
292:

Line 356: -- For AR_CUSTOMER_CALLS_ALL table, if party_id 1000 got merged to party_id 2000

352:
353:
354: -- If the parent has changed(ie. Parent is getting merged) then transfer the
355: -- dependent record to the new parent.
356: -- For AR_CUSTOMER_CALLS_ALL table, if party_id 1000 got merged to party_id 2000
357: -- then, we have to update all records with customer_id = 1000 to 2000
358:
359: if p_from_fk_id <> p_to_fk_id then
360: