APPS.HZ_DQM_SYNC dependencies on HZ_STAGED_PARTIES

Line 219: update hz_staged_parties a set concat_col = concat_col

215: IF L_PARTY_ID.COUNT=0 AND l_last_fetch THEN
216: EXIT;
217: END IF;
218: FORALL I in L_PARTY_ID.FIRST..L_PARTY_ID.LAST
219: update hz_staged_parties a set concat_col = concat_col
220: where a.party_id = L_PARTY_ID(I);
221: FORALL I in L_PARTY_ID.FIRST..L_PARTY_ID.LAST
222: delete from hz_dqm_sync_interface
223: where rowid = L_ROWID(I);

Line 368: update hz_staged_parties a set concat_col = concat_col

364: IF L_PARTY_ID.COUNT=0 AND l_last_fetch THEN
365: EXIT;
366: END IF;
367: FORALL I in L_PARTY_ID.FIRST..L_PARTY_ID.LAST
368: update hz_staged_parties a set concat_col = concat_col
369: where a.party_id = L_PARTY_ID(I);
370: FORALL I in L_PARTY_ID.FIRST..L_PARTY_ID.LAST
371: delete from hz_dqm_sync_interface
372: where rowid = L_ROWID(I);

Line 1400: UPDATE HZ_STAGED_PARTIES

1396:
1397: IF l_party_type <> 'PARTY_RELATIONSHIP' THEN
1398: IF ( L_REALTIME_SYNC_VALUE = 'Y') THEN
1399: BEGIN
1400: UPDATE HZ_STAGED_PARTIES
1401: SET STATUS = 'M'
1402: WHERE party_id = p_from_id;
1403: EXCEPTION
1404: WHEN NO_DATA_FOUND THEN

Line 2166: UPDATE HZ_STAGED_PARTIES

2162:
2163: IF (I.ENTITY='PARTY')
2164: THEN
2165: BEGIN
2166: UPDATE HZ_STAGED_PARTIES
2167: SET STATUS = 'M'
2168: WHERE party_id = I.PARTY_ID;
2169: EXCEPTION
2170: WHEN NO_DATA_FOUND THEN

Line 2217: and party_id in (select /*+ parallel_index(s) index_ffs(s) */ party_id from hz_staged_parties s );

2213: --Start Bug:5407223---
2214: /* Delete records from HZ_DQM_SYNC_INTERFACE table if that record already exists in staged table*/
2215: log('Start Time for delete statements = ' || TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));
2216: delete /*+ parallel(i) */ from hz_dqm_sync_interface i where entity='PARTY' and operation='C'
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 );