[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);
1646: L_REALTIME_SYNC_VALUE := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');
1647:
1648: IF ( L_REALTIME_SYNC_VALUE = 'Y') THEN
1649: BEGIN
1650: DELETE FROM HZ_STAGED_CONTACTS
1651: WHERE org_contact_id = p_from_id;
1652: EXCEPTION
1653: WHEN NO_DATA_FOUND THEN
1654: NULL;
2185:
2186: IF (I.ENTITY='CONTACTS')
2187: THEN
2188: BEGIN
2189: DELETE FROM HZ_STAGED_CONTACTS
2190: WHERE org_contact_id = I.RECORD_ID;
2191: EXCEPTION
2192: WHEN NO_DATA_FOUND THEN
2193: NULL;
2221: and record_id in (select /*+ parallel_index(s) index_ffs(s) */ party_site_id from hz_staged_party_sites s );
2222: log (' After delete duplicate party site entity records '||TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS') );
2223:
2224: delete /*+ parallel(i) */ from hz_dqm_sync_interface i where entity='CONTACTS' and operation='C'
2225: and record_id in (select /*+ parallel_index(s) index_ffs(s) */ org_contact_id from hz_staged_contacts s );
2226: log (' After delete duplicate contact entity records = '||TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS') );
2227:
2228: delete /*+ parallel(i) */ from hz_dqm_sync_interface i where entity='CONTACT_POINTS' and operation='C'
2229: and record_id in (select /*+ parallel_index(s) index_ffs(s) */ contact_point_id from hz_staged_contact_points s );