[Home] [Help]
269: IF L_RECORD_ID.COUNT=0 AND l_last_fetch THEN
270: EXIT;
271: END IF;
272: FORALL I in L_RECORD_ID.FIRST..L_RECORD_ID.LAST
273: update hz_staged_contacts a set concat_col = concat_col
274: where a.org_contact_id = L_RECORD_ID(I);
275: FORALL I in L_RECORD_ID.FIRST..L_RECORD_ID.LAST
276: delete from hz_dqm_sync_interface
277: where rowid = L_ROWID(I);
418: IF L_RECORD_ID.COUNT=0 AND l_last_fetch THEN
419: EXIT;
420: END IF;
421: FORALL I in L_RECORD_ID.FIRST..L_RECORD_ID.LAST
422: update hz_staged_contacts a set concat_col = concat_col
423: where a.org_contact_id = L_RECORD_ID(I);
424: FORALL I in L_RECORD_ID.FIRST..L_RECORD_ID.LAST
425: delete from hz_dqm_sync_interface
426: where rowid = L_ROWID(I);
1560:
1561: x_return_status := FND_API.G_RET_STS_SUCCESS;
1562:
1563: BEGIN
1564: DELETE FROM HZ_STAGED_CONTACTS
1565: WHERE org_contact_id = p_from_id;
1566: EXCEPTION
1567: WHEN NO_DATA_FOUND THEN
1568: NULL;
2044: and record_id in (select /*+ parallel_index(s) index_ffs(s) */ party_site_id from hz_staged_party_sites s );
2045: log (' After delete duplicate party site entity records '||TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS') );
2046:
2047: delete /*+ parallel(i) */ from hz_dqm_sync_interface i where entity='CONTACTS' and operation='C'
2048: and record_id in (select /*+ parallel_index(s) index_ffs(s) */ org_contact_id from hz_staged_contacts s );
2049: log (' After delete duplicate contact entity records = '||TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS') );
2050:
2051: delete /*+ parallel(i) */ from hz_dqm_sync_interface i where entity='CONTACT_POINTS' and operation='C'
2052: and record_id in (select /*+ parallel_index(s) index_ffs(s) */ contact_point_id from hz_staged_contact_points s );