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.FII_AP_INV_B_C dependencies on FII_AP_SUM_WORK_JOBS

Line 180: FII_UTIL.put_line('Truncate table FII_AP_SUM_WORK_JOBS');

176: if g_debug_flag = 'Y' then
177: FII_UTIL.put_line('Calling procedure CLEAN_UP');
178: FII_UTIL.put_line('');
179:
180: FII_UTIL.put_line('Truncate table FII_AP_SUM_WORK_JOBS');
181: end if;
182: truncate_table('FII_AP_SUM_WORK_JOBS');
183:
184: IF (g_truncate_id = 'Y') THEN

Line 182: truncate_table('FII_AP_SUM_WORK_JOBS');

178: FII_UTIL.put_line('');
179:
180: FII_UTIL.put_line('Truncate table FII_AP_SUM_WORK_JOBS');
181: end if;
182: truncate_table('FII_AP_SUM_WORK_JOBS');
183:
184: IF (g_truncate_id = 'Y') THEN
185: if g_debug_flag = 'Y' then
186: FII_UTIL.put_line('Truncate table FII_AP_Unpost_Headers_T');

Line 672: INSERT INTO FII_AP_SUM_WORK_JOBS (start_range, end_range, worker_number, status, phase_id)

668:
669: WHILE (l_start_number1 < (l_max_number1 + 1)) LOOP
670: l_end_number:= l_start_number1 + INTERVAL_SIZE;
671:
672: INSERT INTO FII_AP_SUM_WORK_JOBS (start_range, end_range, worker_number, status, phase_id)
673: VALUES (l_start_number1, least(l_end_number, l_max_number1), 0, 'UNASSIGNED', 1);
674:
675: l_count := l_count + 1;
676: l_start_number1 := least(l_end_number, l_max_number1) + 1;

Line 680: FII_UTIL.put_line('Inserted ' || l_count || ' jobs into FII_AP_SUM_WORK_JOBS table');

676: l_start_number1 := least(l_end_number, l_max_number1) + 1;
677: END LOOP;
678:
679: if g_debug_flag = 'Y' then
680: FII_UTIL.put_line('Inserted ' || l_count || ' jobs into FII_AP_SUM_WORK_JOBS table');
681: end if;
682:
683:
684: g_phase := 'Register phase 2 jobs for workers';

Line 698: INSERT INTO FII_AP_SUM_WORK_JOBS (start_range, end_range, worker_number, status, phase_id)

694:
695: WHILE (l_start_number2 < (l_max_number2 + 1)) LOOP
696: l_end_number:= l_start_number2 + INTERVAL_SIZE;
697:
698: INSERT INTO FII_AP_SUM_WORK_JOBS (start_range, end_range, worker_number, status, phase_id)
699: VALUES (l_start_number2, least(l_end_number, l_max_number2), 0, 'UNASSIGNED', 2);
700:
701: l_count := l_count + 1;
702: l_start_number2 := least(l_end_number, l_max_number2) + 1;

Line 706: FII_UTIL.put_line('Inserted ' || l_count || ' jobs into FII_AP_SUM_WORK_JOBS table');

702: l_start_number2 := least(l_end_number, l_max_number2) + 1;
703: END LOOP;
704:
705: if g_debug_flag = 'Y' then
706: FII_UTIL.put_line('Inserted ' || l_count || ' jobs into FII_AP_SUM_WORK_JOBS table');
707: end if;
708:
709: RETURN 1;
710:

Line 2183: FROM FII_AP_SUM_WORK_JOBS;

2179: l_completed_cnt,
2180: l_wip_cnt,
2181: l_failed_cnt,
2182: l_tot_cnt
2183: FROM FII_AP_SUM_WORK_JOBS;
2184:
2185: if g_debug_flag = 'Y' then
2186: FII_UTIL.put_line('Job status - Unassigned:'||l_unassigned_cnt||
2187: ' In Process:'||l_wip_cnt||

Line 2470: Truncate_table('FII_AP_SUM_WORK_JOBS');

2466: -- of the program.
2467: ---------------------------------------------------------------
2468: Truncate_table('FII_AP_INV_STG');
2469:
2470: Truncate_table('FII_AP_SUM_WORK_JOBS');
2471:
2472: ----------------------------------------------------------------
2473: -- When exception occurs, we need to restore the AP_DBI_LOG table
2474: -- to its original state by setting those records back to 'N'.

Line 2569: FROM FII_AP_SUM_WORK_JOBS;

2565: l_failed_cnt,
2566: l_curr_unasgn_cnt,
2567: l_curr_comp_cnt,
2568: l_curr_tot_cnt
2569: FROM FII_AP_SUM_WORK_JOBS;
2570:
2571: IF (l_failed_cnt > 0) THEN
2572: if g_debug_flag = 'Y' then
2573: FII_UTIL.put_line('');

Line 2590: UPDATE FII_AP_SUM_WORK_JOBS

2586: FII_UTIL.put_line('All jobs completed, no more job. Terminating');
2587: end if;
2588: EXIT;
2589: ELSIF (l_curr_unasgn_cnt > 0) THEN
2590: UPDATE FII_AP_SUM_WORK_JOBS
2591: SET status = 'IN PROCESS',
2592: worker_number = p_worker_no
2593: WHERE status = 'UNASSIGNED'
2594: AND rownum < 2;

Line 2611: FROM FII_AP_SUM_WORK_JOBS jobs

2607: IF (l_count > 0) THEN
2608: BEGIN
2609: SELECT start_range, end_range, phase_id
2610: INTO l_start_range, l_end_range, l_phase
2611: FROM FII_AP_SUM_WORK_JOBS jobs
2612: WHERE jobs.worker_number = p_worker_no
2613: AND jobs.status = 'IN PROCESS';
2614:
2615: g_phase := 'Bypassing SLA security.';

Line 2634: UPDATE FII_AP_SUM_WORK_JOBS jobs

2630: FII_UTIL.stop_timer;
2631: FII_UTIL.print_timer('Duration');
2632: end if;
2633:
2634: UPDATE FII_AP_SUM_WORK_JOBS jobs
2635: SET jobs.status = 'COMPLETED'
2636: WHERE jobs.status = 'IN PROCESS'
2637: AND jobs.worker_number = p_worker_no;
2638:

Line 2645: UPDATE FII_AP_SUM_WORK_JOBS

2641: EXCEPTION
2642: WHEN OTHERS THEN
2643: g_retcode := -1;
2644:
2645: UPDATE FII_AP_SUM_WORK_JOBS
2646: SET status = 'FAILED'
2647: WHERE worker_number = p_worker_no
2648: AND status = 'IN PROCESS';
2649:

Line 2669: UPDATE FII_AP_SUM_WORK_JOBS

2665: -------------------------------------------
2666: -- Update the WORKER_JOBS table to indicate
2667: -- this job has failed
2668: -------------------------------------------
2669: UPDATE FII_AP_SUM_WORK_JOBS
2670: SET status = 'FAILED'
2671: WHERE worker_number = p_worker_no
2672: AND status = 'IN PROCESS';
2673: