277: fnd_file.put_line(fnd_file.log, 'No of Rows Updated : '||l_count);
278: arp_message.set_name('AR','AR_ROWS_UPDATED');
279: arp_message.set_token('NUM_ROWS',to_char(l_count));
280:
281: fnd_file.put_line(fnd_file.log, 'Deleting Table OKC_K_PARTY_ROLES_TL');
282: -- Delete party_roles_tl table to handle related party merge Bug # 4529376
283:
284: FORALL i IN l_from_cpl_id.FIRST .. l_from_cpl_id.LAST
285: DELETE from okc_k_party_roles_tl rtl
281: fnd_file.put_line(fnd_file.log, 'Deleting Table OKC_K_PARTY_ROLES_TL');
282: -- Delete party_roles_tl table to handle related party merge Bug # 4529376
283:
284: FORALL i IN l_from_cpl_id.FIRST .. l_from_cpl_id.LAST
285: DELETE from okc_k_party_roles_tl rtl
286: WHERE rtl.id = l_from_cpl_id(i);
287:
288: l_count := sql%rowcount;
289: fnd_file.put_line(fnd_file.log, 'No of Rows Deleted : '||l_count);