APPS.HZ_BATCH_DUPLICATE dependencies on HZ_DUP_BATCH

Line 154: select count(*) into batch_count from hz_dup_batch where dup_batch_id=l_batch_id

150: retcode := 0;
151:
152: /* Changes for scheduling of SDIB concurrent program. Bug: 4631257*/
153: l_batch_id := to_number(p_batch_name);
154: select count(*) into batch_count from hz_dup_batch where dup_batch_id=l_batch_id
155: and request_id is not null;
156:
157:
158: if(batch_count>0) then

Line 165: from hz_dup_batch

161: outandlog('batch count= '||batch_count);
162: outandlog('l_batch_name= '||l_batch_name);
163:
164: select nvl(automerge_flag,'N') into l_automerge_flag
165: from hz_dup_batch
166: where dup_batch_id = l_batch_id;
167:
168: select HZ_DUP_BATCH_S.NEXTVAL into l_new_batch_id from dual;
169:

Line 168: select HZ_DUP_BATCH_S.NEXTVAL into l_new_batch_id from dual;

164: select nvl(automerge_flag,'N') into l_automerge_flag
165: from hz_dup_batch
166: where dup_batch_id = l_batch_id;
167:
168: select HZ_DUP_BATCH_S.NEXTVAL into l_new_batch_id from dual;
169:
170: insert into hz_dl_selected_criteria
171: (select hz_dl_selected_criteria_s.NEXTVAL, 'SDIB', l_new_batch_id, attribute_name,operation,value,fnd_global.user_id,
172: sysdate,fnd_global.login_id,fnd_global.user_id,sysdate from hz_dl_selected_criteria

Line 175: select dup_batch_name into l_batch_name from hz_dup_batch where dup_batch_id = l_batch_id;

171: (select hz_dl_selected_criteria_s.NEXTVAL, 'SDIB', l_new_batch_id, attribute_name,operation,value,fnd_global.user_id,
172: sysdate,fnd_global.login_id,fnd_global.user_id,sysdate from hz_dl_selected_criteria
173: where batch_id=l_batch_id and batch_type='SDIB');
174:
175: select dup_batch_name into l_batch_name from hz_dup_batch where dup_batch_id = l_batch_id;
176:
177: IF substr(l_batch_name,0,3) = 'AM:' THEN --SDIB scheduling bug 12315458
178: l_batch_name := substr(l_batch_name,4);
179: l_batch_name := substr(l_batch_name,0,(instr(l_batch_name,'-')-1));

Line 186: HZ_DUP_BATCH_PKG.Insert_Row(l_batch_id,l_batch_name,p_rule_id,fnd_global.resp_appl_id,

182: END IF;
183:
184: l_batch_id := l_new_batch_id;
185:
186: HZ_DUP_BATCH_PKG.Insert_Row(l_batch_id,l_batch_name,p_rule_id,fnd_global.resp_appl_id,
187: 'SYSTEM_GENERATED',fnd_global.user_id,sysdate,fnd_global.login_id,
188: sysdate,fnd_global.user_id);
189:
190:

Line 191: UPDATE HZ_DUP_BATCH set automerge_flag = l_automerge_flag, last_update_date = SYSDATE,

187: 'SYSTEM_GENERATED',fnd_global.user_id,sysdate,fnd_global.login_id,
188: sysdate,fnd_global.user_id);
189:
190:
191: UPDATE HZ_DUP_BATCH set automerge_flag = l_automerge_flag, last_update_date = SYSDATE,
192: last_update_login = FND_GLOBAL.LOGIN_ID,last_updated_by = FND_GLOBAL.USER_ID
193: Where dup_batch_id = l_batch_id;
194: outandlog('new batch id = '||l_batch_id);
195: end if;

Line 197: UPDATE HZ_DUP_BATCH

193: Where dup_batch_id = l_batch_id;
194: outandlog('new batch id = '||l_batch_id);
195: end if;
196:
197: UPDATE HZ_DUP_BATCH
198: SET REQUEST_ID = hz_utility_v2pub.request_id
199: WHERE dup_batch_id = l_batch_id;
200:
201:

Line 315: FROM hz_dup_batch

311: log('Post processing Data cleanup for SDIB');
312: -- l_batch_id := to_number(p_batch_name); bug 6067226
313:
314: SELECT dup_batch_id INTO l_batch_id
315: FROM hz_dup_batch
316: where request_id = FND_GLOBAL.conc_request_id;
317:
318: OPEN dup_dup_parties(l_batch_id);
319: LOOP

Line 415: from hz_dup_batch

411:
412: END IF;
413:
414: select automerge_flag into l_automerge_flag
415: from hz_dup_batch
416: where dup_batch_id = l_batch_id;
417:
418: if nvl(l_automerge_flag,'N') = 'Y'
419: then

Line 438: update hz_dup_batch

434: -- start bug 4773387
435: else
436: log('No automerge candidates, therefore only one reviewable batch has been created.');
437:
438: update hz_dup_batch
439: set automerge_flag = 'N',
440: request_type = 'SYSTEM_AUTOMERGE'
441: where dup_batch_id = l_batch_id;
442: end if;