APPS.HZ_DQM_SYNC dependencies on HZ_STAGED_PARTY_SITES

Line 246: update hz_staged_party_sites a set concat_col = concat_col

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

Line 395: update hz_staged_party_sites a set concat_col = concat_col

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

Line 1447: DELETE FROM HZ_STAGED_PARTY_SITES

1443: L_REALTIME_SYNC_VALUE := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');
1444:
1445: IF ( L_REALTIME_SYNC_VALUE = 'Y') THEN
1446: BEGIN
1447: DELETE FROM HZ_STAGED_PARTY_SITES
1448: WHERE party_site_id = p_from_id;
1449: EXCEPTION
1450: WHEN NO_DATA_FOUND THEN
1451: NULL;

Line 1677: UPDATE HZ_STAGED_PARTY_SITES

1673: IF ( L_REALTIME_SYNC_VALUE = 'Y') THEN
1674: BEGIN
1675: sync_contact(l_org_contact_id,'C');
1676:
1677: UPDATE HZ_STAGED_PARTY_SITES
1678: SET party_id = l_party_id
1679: WHERE party_site_id in (
1680: SELECT party_site_id
1681: FROM HZ_PARTY_SITES

Line 2178: DELETE FROM HZ_STAGED_PARTY_SITES

2174:
2175: IF (I.ENTITY='PARTY_SITES')
2176: THEN
2177: BEGIN
2178: DELETE FROM HZ_STAGED_PARTY_SITES
2179: WHERE party_site_id = I.RECORD_ID;
2180: EXCEPTION
2181: WHEN NO_DATA_FOUND THEN
2182: NULL;

Line 2221: and record_id in (select /*+ parallel_index(s) index_ffs(s) */ party_site_id from hz_staged_party_sites s );

2217: and party_id in (select /*+ parallel_index(s) index_ffs(s) */ party_id from hz_staged_parties s );
2218: log (' After delete duplicate party entity records, time= '||TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));
2219:
2220: delete /*+ parallel(i) */ from hz_dqm_sync_interface i where entity='PARTY_SITES' and operation='C'
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 );