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

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

Line 182: sysdate,fnd_global.user_id);

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

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

Line 310: where request_id = FND_GLOBAL.conc_request_id;

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

Line 371: Where Parent_Request_Id = FND_GLOBAL.conc_request_id

367: dup_workers_completed := TRUE;
368:
369: Select request_id BULK COLLECT into l_sub_requests
370: from Fnd_Concurrent_Requests R
371: Where Parent_Request_Id = FND_GLOBAL.conc_request_id
372: and (phase_code<>'C' or status_code<>'C');
373:
374: IF l_sub_requests.count>0 THEN
375: dup_workers_completed:=FALSE;