DBA Data[Home] [Help]

APPS.OKC_PARTY_MERGE_PUB dependencies on OKC_K_PARTY_ROLES_TL

Line 281: fnd_file.put_line(fnd_file.log, 'Deleting Table OKC_K_PARTY_ROLES_TL');

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

Line 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);