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: l_batch_name := substr(l_batch_name,0,(instr(l_batch_name,'-')-1));
178: l_batch_id := l_new_batch_id;
179:

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

176:
177: l_batch_name := substr(l_batch_name,0,(instr(l_batch_name,'-')-1));
178: l_batch_id := l_new_batch_id;
179:
180: HZ_DUP_BATCH_PKG.Insert_Row(l_batch_id,l_batch_name,p_rule_id,fnd_global.resp_appl_id,
181: 'SYSTEM_GENERATED',fnd_global.user_id,sysdate,fnd_global.login_id,
182: sysdate,fnd_global.user_id);
183:
184:

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

181: 'SYSTEM_GENERATED',fnd_global.user_id,sysdate,fnd_global.login_id,
182: sysdate,fnd_global.user_id);
183:
184:
185: UPDATE HZ_DUP_BATCH set automerge_flag = l_automerge_flag, last_update_date = SYSDATE,
186: last_update_login = FND_GLOBAL.LOGIN_ID,last_updated_by = FND_GLOBAL.USER_ID
187: Where dup_batch_id = l_batch_id;
188: outandlog('new batch id = '||l_batch_id);
189: end if;

Line 191: UPDATE HZ_DUP_BATCH

187: Where dup_batch_id = l_batch_id;
188: outandlog('new batch id = '||l_batch_id);
189: end if;
190:
191: UPDATE HZ_DUP_BATCH
192: SET REQUEST_ID = hz_utility_v2pub.request_id
193: WHERE dup_batch_id = l_batch_id;
194:
195:

Line 309: FROM hz_dup_batch

305: log('Post processing Data cleanup for SDIB');
306: -- l_batch_id := to_number(p_batch_name); bug 6067226
307:
308: SELECT dup_batch_id INTO l_batch_id
309: FROM hz_dup_batch
310: where request_id = FND_GLOBAL.conc_request_id;
311:
312: OPEN dup_dup_parties(l_batch_id);
313: LOOP

Line 409: from hz_dup_batch

405:
406: END IF;
407:
408: select automerge_flag into l_automerge_flag
409: from hz_dup_batch
410: where dup_batch_id = l_batch_id;
411:
412: if nvl(l_automerge_flag,'N') = 'Y'
413: then

Line 432: update hz_dup_batch

428: -- start bug 4773387
429: else
430: log('No automerge candidates, therefore only one reviewable batch has been created.');
431:
432: update hz_dup_batch
433: set automerge_flag = 'N',
434: request_type = 'SYSTEM_AUTOMERGE'
435: where dup_batch_id = l_batch_id;
436: end if;