[Home] [Help]
242: IF L_RECORD_ID.COUNT=0 AND l_last_fetch THEN
243: EXIT;
244: END IF;
245: FORALL I in L_RECORD_ID.FIRST..L_RECORD_ID.LAST
246: update hz_staged_party_sites a set concat_col = concat_col
247: where a.party_site_id = L_RECORD_ID(I);
248: FORALL I in L_RECORD_ID.FIRST..L_RECORD_ID.LAST
249: delete from hz_dqm_sync_interface
250: where rowid = L_ROWID(I);
391: IF L_RECORD_ID.COUNT=0 AND l_last_fetch THEN
392: EXIT;
393: END IF;
394: FORALL I in L_RECORD_ID.FIRST..L_RECORD_ID.LAST
395: update hz_staged_party_sites a set concat_col = concat_col
396: where a.party_site_id = L_RECORD_ID(I);
397: FORALL I in L_RECORD_ID.FIRST..L_RECORD_ID.LAST
398: delete from hz_dqm_sync_interface
399: where rowid = L_ROWID(I);
1375: BEGIN
1376: x_return_status := FND_API.G_RET_STS_SUCCESS;
1377:
1378: BEGIN
1379: DELETE FROM HZ_STAGED_PARTY_SITES
1380: WHERE party_site_id = p_from_id;
1381: EXCEPTION
1382: WHEN NO_DATA_FOUND THEN
1383: NULL;
1582: SAVEPOINT contact_sync;
1583: BEGIN
1584: sync_contact(l_org_contact_id,'C');
1585:
1586: UPDATE HZ_STAGED_PARTY_SITES
1587: SET party_id = l_party_id
1588: WHERE party_site_id in (
1589: SELECT party_site_id
1590: FROM HZ_PARTY_SITES
2040: and party_id in (select /*+ parallel_index(s) index_ffs(s) */ party_id from hz_staged_parties s );
2041: log (' After delete duplicate party entity records, time= '||TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));
2042:
2043: delete /*+ parallel(i) */ from hz_dqm_sync_interface i where entity='PARTY_SITES' and operation='C'
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 );