DBA Data[Home] [Help]

APPS.BEN_MAINTAIN_BENEFIT_ACTIONS dependencies on FND_GLOBAL

Line 248: and bft.request_id = fnd_global.conc_request_id;

244: cursor c_master is
245: select 'Y'
246: from ben_benefit_actions bft
247: where bft.benefit_action_id = p_benefit_action_id
248: and bft.request_id = fnd_global.conc_request_id;
249: --
250: cursor c_person_actions(p_status_cd varchar2) is
251: select count(*)
252: from ben_person_actions pac

Line 313: if fnd_global.conc_request_id <> -1

309: --
310: -- Don't do this code if we are running from SQL Plus
311: --
312: -- GLOBALCWB
313: if fnd_global.conc_request_id <> -1
314: then
315: --
316: if l_param_rec.mode_cd<>'W' then
317: hr_utility.set_location (l_package||' Fire Reports ',40);

Line 319: (p_concurrent_request_id => fnd_global.conc_request_id,

315: --
316: if l_param_rec.mode_cd<>'W' then
317: hr_utility.set_location (l_package||' Fire Reports ',40);
318: ben_batch_reporting.batch_reports
319: (p_concurrent_request_id => fnd_global.conc_request_id,
320: p_report_type => 'GENERIC_LOG');
321: if l_param_rec.mode_cd<>'R' then
322: ben_batch_reporting.batch_reports
323: (p_concurrent_request_id => fnd_global.conc_request_id,

Line 323: (p_concurrent_request_id => fnd_global.conc_request_id,

319: (p_concurrent_request_id => fnd_global.conc_request_id,
320: p_report_type => 'GENERIC_LOG');
321: if l_param_rec.mode_cd<>'R' then
322: ben_batch_reporting.batch_reports
323: (p_concurrent_request_id => fnd_global.conc_request_id,
324: p_mode => l_param_rec.mode_cd,
325: p_report_type => 'ACTIVITY_SUMMARY');
326: end if;
327: ben_batch_reporting.batch_reports

Line 328: (p_concurrent_request_id => fnd_global.conc_request_id,

324: p_mode => l_param_rec.mode_cd,
325: p_report_type => 'ACTIVITY_SUMMARY');
326: end if;
327: ben_batch_reporting.batch_reports
328: (p_concurrent_request_id => fnd_global.conc_request_id,
329: p_report_type => 'ERROR_BY_ERROR_TYPE');
330: ben_batch_reporting.batch_reports
331: (p_concurrent_request_id => fnd_global.conc_request_id,
332: p_report_type => 'ERROR_BY_PERSON');

Line 331: (p_concurrent_request_id => fnd_global.conc_request_id,

327: ben_batch_reporting.batch_reports
328: (p_concurrent_request_id => fnd_global.conc_request_id,
329: p_report_type => 'ERROR_BY_ERROR_TYPE');
330: ben_batch_reporting.batch_reports
331: (p_concurrent_request_id => fnd_global.conc_request_id,
332: p_report_type => 'ERROR_BY_PERSON');
333: hr_utility.set_location (l_package||' Dn Fire Reports ',40);
334: --
335: end if;