eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_EFC_VALIDATION dependencies on HR_EFC_INFO

Line 174: hr_efc_info.insert_line('-- ');

170: -- Running in standalone mode with no actions
171: --
172: if p_business_group_id is not null then
173: --
174: hr_efc_info.insert_line('-- ');
175: hr_efc_info.insert_line
176: ('-- Re-calculating/adjusting in validate mode with no actions ');
177: hr_efc_info.insert_line('-- ');
178: --

Line 175: hr_efc_info.insert_line

171: --
172: if p_business_group_id is not null then
173: --
174: hr_efc_info.insert_line('-- ');
175: hr_efc_info.insert_line
176: ('-- Re-calculating/adjusting in validate mode with no actions ');
177: hr_efc_info.insert_line('-- ');
178: --
179: l_action_id := null;

Line 177: hr_efc_info.insert_line('-- ');

173: --
174: hr_efc_info.insert_line('-- ');
175: hr_efc_info.insert_line
176: ('-- Re-calculating/adjusting in validate mode with no actions ');
177: hr_efc_info.insert_line('-- ');
178: --
179: l_action_id := null;
180: l_pk1 := null;
181: l_chunk := null;

Line 195: hr_efc_info.get_action_details

191: elsif p_worker_id is null
192: and p_total_workers is null
193: then
194: --
195: hr_efc_info.get_action_details
196: (l_action_id
197: ,l_bgp_id
198: ,l_chunk
199: );

Line 215: hr_efc_info.insert_line('-- ');

211: else
212: --
213: if p_multithread_substep is not null then
214: --
215: hr_efc_info.insert_line('-- ');
216: hr_efc_info.insert_line
217: ('-- Re-calculating/adjusting converted monetary values phase '||p_multithread_substep);
218: hr_efc_info.insert_line('-- ');
219: --

Line 216: hr_efc_info.insert_line

212: --
213: if p_multithread_substep is not null then
214: --
215: hr_efc_info.insert_line('-- ');
216: hr_efc_info.insert_line
217: ('-- Re-calculating/adjusting converted monetary values phase '||p_multithread_substep);
218: hr_efc_info.insert_line('-- ');
219: --
220: if p_multithread_substep = 10 then

Line 218: hr_efc_info.insert_line('-- ');

214: --
215: hr_efc_info.insert_line('-- ');
216: hr_efc_info.insert_line
217: ('-- Re-calculating/adjusting converted monetary values phase '||p_multithread_substep);
218: hr_efc_info.insert_line('-- ');
219: --
220: if p_multithread_substep = 10 then
221: --
222: l_table := 'ben_elig_per_f';

Line 253: hr_efc_info.insert_line('-- ');

249: end if;
250: --
251: else
252: --
253: hr_efc_info.insert_line('-- ');
254: hr_efc_info.insert_line
255: ('-- Re-calculating/adjusting converted monetary values for all phases ');
256: hr_efc_info.insert_line('-- ');
257: --

Line 254: hr_efc_info.insert_line

250: --
251: else
252: --
253: hr_efc_info.insert_line('-- ');
254: hr_efc_info.insert_line
255: ('-- Re-calculating/adjusting converted monetary values for all phases ');
256: hr_efc_info.insert_line('-- ');
257: --
258: l_table := 'ALLTABS';

Line 256: hr_efc_info.insert_line('-- ');

252: --
253: hr_efc_info.insert_line('-- ');
254: hr_efc_info.insert_line
255: ('-- Re-calculating/adjusting converted monetary values for all phases ');
256: hr_efc_info.insert_line('-- ');
257: --
258: l_table := 'ALLTABS';
259: l_proccomp_name := 'beadjust';
260:

Line 268: hr_efc_info.get_action_details

264: l_worker_id := p_worker_id;
265: l_total_workers := p_total_workers;
266: -- l_proccomp_name := 'beadjust';
267: --
268: hr_efc_info.get_action_details
269: (l_action_id
270: ,l_bgp_id
271: ,l_chunk
272: );

Line 277: hr_efc_info.insert_or_select_comp_row

273: --
274: -- First processor only - insert a row into the HR_EFC_PROCESS_COMPONENTS
275: -- table (procedure includes locking so that only 1 row is inserted)
276: --
277: hr_efc_info.insert_or_select_comp_row
278: (p_action_id => l_action_id
279: ,p_process_component_name => l_proccomp_name
280: ,p_table_name => l_table
281: ,p_total_workers => l_total_workers

Line 291: hr_efc_info.insert_or_select_worker_row

287: --
288: -- Call procedure to check if this worker has already started (will detect
289: -- if this worker has been restarted).
290: --
291: hr_efc_info.insert_or_select_worker_row
292: (p_process_component_id => l_efc_component_id
293: ,p_process_component_name => l_proccomp_name
294: ,p_action_id => l_action_id
295: ,p_worker_number => l_worker_id

Line 337: hr_efc_info.insert_line('-- ');

333: then
334: --
335: -- Check for unprocessed batch ranges
336: --
337: hr_efc_info.insert_line('-- ');
338: hr_efc_info.insert_line('-- Check for uncomplete benefit actions in BEN_BENEFIT_ACTIONS table...');
339: hr_efc_info.insert_line('-- ');
340: --
341: OPEN csr_find_batch_ranges(l_bgp_id);

Line 338: hr_efc_info.insert_line('-- Check for uncomplete benefit actions in BEN_BENEFIT_ACTIONS table...');

334: --
335: -- Check for unprocessed batch ranges
336: --
337: hr_efc_info.insert_line('-- ');
338: hr_efc_info.insert_line('-- Check for uncomplete benefit actions in BEN_BENEFIT_ACTIONS table...');
339: hr_efc_info.insert_line('-- ');
340: --
341: OPEN csr_find_batch_ranges(l_bgp_id);
342: FETCH csr_find_batch_ranges BULK COLLECT INTO l_bftid_va,

Line 339: hr_efc_info.insert_line('-- ');

335: -- Check for unprocessed batch ranges
336: --
337: hr_efc_info.insert_line('-- ');
338: hr_efc_info.insert_line('-- Check for uncomplete benefit actions in BEN_BENEFIT_ACTIONS table...');
339: hr_efc_info.insert_line('-- ');
340: --
341: OPEN csr_find_batch_ranges(l_bgp_id);
342: FETCH csr_find_batch_ranges BULK COLLECT INTO l_bftid_va,
343: l_bftprdt_va,

Line 412: hr_efc_info.insert_line('-- Uncompleted batch information identified for the following');

408: --
409: if l_bft_cnt = 0
410: then
411: --
412: hr_efc_info.insert_line('-- Uncompleted batch information identified for the following');
413: hr_efc_info.insert_line('-- rows in ben_benefit_actions ');
414: hr_efc_info.insert_line('-- ');
415: hr_efc_info.insert_line('-- Benefit Action ID /Mode Cd /Process date /Person Action Count');
416: hr_efc_info.insert_line('-- ');

Line 413: hr_efc_info.insert_line('-- rows in ben_benefit_actions ');

409: if l_bft_cnt = 0
410: then
411: --
412: hr_efc_info.insert_line('-- Uncompleted batch information identified for the following');
413: hr_efc_info.insert_line('-- rows in ben_benefit_actions ');
414: hr_efc_info.insert_line('-- ');
415: hr_efc_info.insert_line('-- Benefit Action ID /Mode Cd /Process date /Person Action Count');
416: hr_efc_info.insert_line('-- ');
417: --

Line 414: hr_efc_info.insert_line('-- ');

410: then
411: --
412: hr_efc_info.insert_line('-- Uncompleted batch information identified for the following');
413: hr_efc_info.insert_line('-- rows in ben_benefit_actions ');
414: hr_efc_info.insert_line('-- ');
415: hr_efc_info.insert_line('-- Benefit Action ID /Mode Cd /Process date /Person Action Count');
416: hr_efc_info.insert_line('-- ');
417: --
418: end if;

Line 415: hr_efc_info.insert_line('-- Benefit Action ID /Mode Cd /Process date /Person Action Count');

411: --
412: hr_efc_info.insert_line('-- Uncompleted batch information identified for the following');
413: hr_efc_info.insert_line('-- rows in ben_benefit_actions ');
414: hr_efc_info.insert_line('-- ');
415: hr_efc_info.insert_line('-- Benefit Action ID /Mode Cd /Process date /Person Action Count');
416: hr_efc_info.insert_line('-- ');
417: --
418: end if;
419: --

Line 416: hr_efc_info.insert_line('-- ');

412: hr_efc_info.insert_line('-- Uncompleted batch information identified for the following');
413: hr_efc_info.insert_line('-- rows in ben_benefit_actions ');
414: hr_efc_info.insert_line('-- ');
415: hr_efc_info.insert_line('-- Benefit Action ID /Mode Cd /Process date /Person Action Count');
416: hr_efc_info.insert_line('-- ');
417: --
418: end if;
419: --
420: hr_efc_info.insert_line('-- '||l_bftid_va(elenum)

Line 420: hr_efc_info.insert_line('-- '||l_bftid_va(elenum)

416: hr_efc_info.insert_line('-- ');
417: --
418: end if;
419: --
420: hr_efc_info.insert_line('-- '||l_bftid_va(elenum)
421: ||' /'||l_bftmdcd_va(elenum)
422: ||' /'||l_bftprdt_va(elenum)
423: ||' /'||l_cnt_va(elenum)
424: );

Line 436: hr_efc_info.insert_line('-- ');

432: end loop;
433: --
434: if l_bft_cnt > 0 then
435: --
436: hr_efc_info.insert_line('-- ');
437: hr_efc_info.insert_line('-- The uncompleted benefit actions above need to be resolved. Use ');
438: hr_efc_info.insert_line('-- the restart process to complete. ');
439: hr_efc_info.insert_line('-- ');
440: --

Line 437: hr_efc_info.insert_line('-- The uncompleted benefit actions above need to be resolved. Use ');

433: --
434: if l_bft_cnt > 0 then
435: --
436: hr_efc_info.insert_line('-- ');
437: hr_efc_info.insert_line('-- The uncompleted benefit actions above need to be resolved. Use ');
438: hr_efc_info.insert_line('-- the restart process to complete. ');
439: hr_efc_info.insert_line('-- ');
440: --
441: hr_efc_info.g_efc_error_app := 805;

Line 438: hr_efc_info.insert_line('-- the restart process to complete. ');

434: if l_bft_cnt > 0 then
435: --
436: hr_efc_info.insert_line('-- ');
437: hr_efc_info.insert_line('-- The uncompleted benefit actions above need to be resolved. Use ');
438: hr_efc_info.insert_line('-- the restart process to complete. ');
439: hr_efc_info.insert_line('-- ');
440: --
441: hr_efc_info.g_efc_error_app := 805;
442: hr_efc_info.g_efc_error_message := 'BEN_92694_EFC_UNPROC_RANGES';

Line 439: hr_efc_info.insert_line('-- ');

435: --
436: hr_efc_info.insert_line('-- ');
437: hr_efc_info.insert_line('-- The uncompleted benefit actions above need to be resolved. Use ');
438: hr_efc_info.insert_line('-- the restart process to complete. ');
439: hr_efc_info.insert_line('-- ');
440: --
441: hr_efc_info.g_efc_error_app := 805;
442: hr_efc_info.g_efc_error_message := 'BEN_92694_EFC_UNPROC_RANGES';
443: --

Line 441: hr_efc_info.g_efc_error_app := 805;

437: hr_efc_info.insert_line('-- The uncompleted benefit actions above need to be resolved. Use ');
438: hr_efc_info.insert_line('-- the restart process to complete. ');
439: hr_efc_info.insert_line('-- ');
440: --
441: hr_efc_info.g_efc_error_app := 805;
442: hr_efc_info.g_efc_error_message := 'BEN_92694_EFC_UNPROC_RANGES';
443: --
444: else
445: --

Line 442: hr_efc_info.g_efc_error_message := 'BEN_92694_EFC_UNPROC_RANGES';

438: hr_efc_info.insert_line('-- the restart process to complete. ');
439: hr_efc_info.insert_line('-- ');
440: --
441: hr_efc_info.g_efc_error_app := 805;
442: hr_efc_info.g_efc_error_message := 'BEN_92694_EFC_UNPROC_RANGES';
443: --
444: else
445: --
446: hr_efc_info.insert_line('-- ');

Line 446: hr_efc_info.insert_line('-- ');

442: hr_efc_info.g_efc_error_message := 'BEN_92694_EFC_UNPROC_RANGES';
443: --
444: else
445: --
446: hr_efc_info.insert_line('-- ');
447: hr_efc_info.insert_line('-- Detected '||l_bftext_cnt||' Extracts. ');
448: hr_efc_info.insert_line('-- No Actions required ');
449: hr_efc_info.insert_line('-- ');
450: --

Line 447: hr_efc_info.insert_line('-- Detected '||l_bftext_cnt||' Extracts. ');

443: --
444: else
445: --
446: hr_efc_info.insert_line('-- ');
447: hr_efc_info.insert_line('-- Detected '||l_bftext_cnt||' Extracts. ');
448: hr_efc_info.insert_line('-- No Actions required ');
449: hr_efc_info.insert_line('-- ');
450: --
451: end if;

Line 448: hr_efc_info.insert_line('-- No Actions required ');

444: else
445: --
446: hr_efc_info.insert_line('-- ');
447: hr_efc_info.insert_line('-- Detected '||l_bftext_cnt||' Extracts. ');
448: hr_efc_info.insert_line('-- No Actions required ');
449: hr_efc_info.insert_line('-- ');
450: --
451: end if;
452: --

Line 449: hr_efc_info.insert_line('-- ');

445: --
446: hr_efc_info.insert_line('-- ');
447: hr_efc_info.insert_line('-- Detected '||l_bftext_cnt||' Extracts. ');
448: hr_efc_info.insert_line('-- No Actions required ');
449: hr_efc_info.insert_line('-- ');
450: --
451: end if;
452: --
453: END IF;

Line 843: hr_efc_info.complete_worker_row

839: end if;
840:
841:
842:
843: hr_efc_info.complete_worker_row
844: (p_efc_worker_id => l_efc_worker_id
845: ,p_pk1 => l_pk1
846: );
847: