APPS.HZ_BATCH_DUPLICATE dependencies on FND_GLOBAL

Line 171: (select hz_dl_selected_criteria_s.NEXTVAL, 'SDIB', l_new_batch_id, attribute_name,operation,value,fnd_global.user_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
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;

Line 172: sysdate,fnd_global.login_id,fnd_global.user_id,sysdate from hz_dl_selected_criteria

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
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:

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 187: 'SYSTEM_GENERATED',fnd_global.user_id,sysdate,fnd_global.login_id,

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:
191: UPDATE HZ_DUP_BATCH set automerge_flag = l_automerge_flag, last_update_date = SYSDATE,

Line 188: sysdate,fnd_global.user_id);

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:
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

Line 192: last_update_login = FND_GLOBAL.LOGIN_ID,last_updated_by = FND_GLOBAL.USER_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;
196:

Line 316: where request_id = FND_GLOBAL.conc_request_id;

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
320: FETCH dup_dup_parties into l_dup_dup_id;

Line 377: Where Parent_Request_Id = FND_GLOBAL.conc_request_id

373: dup_workers_completed := TRUE;
374:
375: Select request_id BULK COLLECT into l_sub_requests
376: from Fnd_Concurrent_Requests R
377: Where Parent_Request_Id = FND_GLOBAL.conc_request_id
378: and (phase_code<>'C' or status_code<>'C');
379:
380: IF l_sub_requests.count>0 THEN
381: dup_workers_completed:=FALSE;