APPS.HZ_DQM_SYNC dependencies on HZ_STAGED_CONTACT_POINTS

Line 300: update hz_staged_contact_points a set concat_col = concat_col

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

Line 449: update hz_staged_contact_points a set concat_col = concat_col

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

Line 1544: DELETE FROM HZ_STAGED_CONTACT_POINTS

1540: L_REALTIME_SYNC_VALUE := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');
1541:
1542: IF ( L_REALTIME_SYNC_VALUE = 'Y') THEN
1543: BEGIN
1544: DELETE FROM HZ_STAGED_CONTACT_POINTS
1545: WHERE contact_point_id = p_from_id;
1546: EXCEPTION
1547: WHEN NO_DATA_FOUND THEN
1548: NULL;

Line 1685: UPDATE HZ_STAGED_CONTACT_POINTS

1681: FROM HZ_PARTY_SITES
1682: WHERE party_id = l_rel_party_id
1683: AND (nvl(STATUS,'A') = 'A' OR nvl(STATUS,'A')='I'));
1684:
1685: UPDATE HZ_STAGED_CONTACT_POINTS
1686: SET party_id = l_party_id
1687: WHERE contact_point_id in (
1688: SELECT contact_point_id
1689: FROM HZ_CONTACT_POINTS

Line 2200: DELETE FROM HZ_STAGED_CONTACT_POINTS

2196:
2197: IF (I.ENTITY='CONTACT_POINTS')
2198: THEN
2199: BEGIN
2200: DELETE FROM HZ_STAGED_CONTACT_POINTS
2201: WHERE contact_point_id = I.RECORD_ID;
2202: EXCEPTION
2203: WHEN NO_DATA_FOUND THEN
2204: NULL;

Line 2229: and record_id in (select /*+ parallel_index(s) index_ffs(s) */ contact_point_id from hz_staged_contact_points s );

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 );
2230: log (' After delete duplicate contact point entity records = '||TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS') );
2231: log('End Time for delete statements = ' || TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));
2232:
2233: