[Home] [Help]
296: IF L_RECORD_ID.COUNT=0 AND l_last_fetch THEN
297: EXIT;
298: END IF;
299: FORALL I in L_RECORD_ID.FIRST..L_RECORD_ID.LAST
300: update hz_staged_contact_points a set concat_col = concat_col
301: where a.contact_point_id = L_RECORD_ID(I);
302: FORALL I in L_RECORD_ID.FIRST..L_RECORD_ID.LAST
303: delete from hz_dqm_sync_interface
304: where rowid = L_ROWID(I);
445: IF L_RECORD_ID.COUNT=0 AND l_last_fetch THEN
446: EXIT;
447: END IF;
448: FORALL I in L_RECORD_ID.FIRST..L_RECORD_ID.LAST
449: update hz_staged_contact_points a set concat_col = concat_col
450: where a.contact_point_id = L_RECORD_ID(I);
451: FORALL I in L_RECORD_ID.FIRST..L_RECORD_ID.LAST
452: delete from hz_dqm_sync_interface
453: where rowid = L_ROWID(I);
1466:
1467: x_return_status := FND_API.G_RET_STS_SUCCESS;
1468:
1469: BEGIN
1470: DELETE FROM HZ_STAGED_CONTACT_POINTS
1471: WHERE contact_point_id = p_from_id;
1472: EXCEPTION
1473: WHEN NO_DATA_FOUND THEN
1474: NULL;
1590: FROM HZ_PARTY_SITES
1591: WHERE party_id = l_rel_party_id
1592: AND (nvl(STATUS,'A') = 'A' OR nvl(STATUS,'A')='I'));
1593:
1594: UPDATE HZ_STAGED_CONTACT_POINTS
1595: SET party_id = l_party_id
1596: WHERE contact_point_id in (
1597: SELECT contact_point_id
1598: FROM HZ_CONTACT_POINTS
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 );
2053: log (' After delete duplicate contact point entity records = '||TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS') );
2054: log('End Time for delete statements = ' || TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));
2055:
2056: --End Bug:5407223---