APPS.FII_AP_INV_SUM_INIT dependencies on FII_AP_PS_WORK_JOBS

Line 280: INSERT INTO FII_AP_PS_WORK_JOBS

276: WHERE invoice_id >= l_start_number
277: ORDER BY invoice_id)
278: WHERE rownum < l_job_size;
279:
280: INSERT INTO FII_AP_PS_WORK_JOBS
281: (Start_Range,
282: End_Range,
283: Worker_Number,
284: Status)

Line 296: FII_UTIL.put_line('Inserted ' || l_count || ' jobs into FII_AP_PS_WORK_JOBS table');

292: l_start_number := least(l_end_number, l_max_number) + 1;
293: END LOOP;
294:
295: if g_debug_flag = 'Y' then
296: FII_UTIL.put_line('Inserted ' || l_count || ' jobs into FII_AP_PS_WORK_JOBS table');
297: end if;
298:
299: EXCEPTION
300: WHEN OTHERS THEN

Line 405: FROM FII_AP_PS_WORK_JOBS;

401: l_completed_cnt,
402: l_wip_cnt,
403: l_failed_cnt,
404: l_tot_cnt
405: FROM FII_AP_PS_WORK_JOBS;
406:
407: if g_debug_flag = 'Y' then
408: FII_UTIL.put_line('Job status - Unassigned:'||l_unassigned_cnt||
409: ' In Process:'||l_wip_cnt||

Line 6780: FROM FII_AP_PS_WORK_JOBS;

6776: l_failed_cnt,
6777: l_curr_unasgn_cnt,
6778: l_curr_comp_cnt,
6779: l_curr_tot_cnt
6780: FROM FII_AP_PS_WORK_JOBS;
6781: SELECT COUNT(1)
6782: INTO l_unassigned_cnt
6783: FROM FII_AP_PS_WORK_JOBS
6784: WHERE status = 'UNASSIGNED'

Line 6783: FROM FII_AP_PS_WORK_JOBS

6779: l_curr_tot_cnt
6780: FROM FII_AP_PS_WORK_JOBS;
6781: SELECT COUNT(1)
6782: INTO l_unassigned_cnt
6783: FROM FII_AP_PS_WORK_JOBS
6784: WHERE status = 'UNASSIGNED'
6785: AND rownum = 1;
6786: SELECT COUNT(1)
6787: INTO l_failed_cnt

Line 6788: FROM FII_AP_PS_WORK_JOBS

6784: WHERE status = 'UNASSIGNED'
6785: AND rownum = 1;
6786: SELECT COUNT(1)
6787: INTO l_failed_cnt
6788: FROM FII_AP_PS_WORK_JOBS
6789: WHERE status = 'FAILED'
6790: AND rownum = 1;
6791: IF l_failed_cnt > 0 THEN
6792: if g_debug_flag = 'Y' then

Line 6804: UPDATE FII_AP_PS_WORK_JOBS

6800: FII_UTIL.put_line('No more jobs left. Terminating.');
6801: end if;
6802: EXIT;
6803: ELSIF l_unassigned_cnt > 0 THEN
6804: UPDATE FII_AP_PS_WORK_JOBS
6805: SET status = 'IN PROCESS',
6806: worker_number = p_worker_no
6807: WHERE status = 'UNASSIGNED'
6808: AND rownum < 2;

Line 6826: FROM FII_AP_PS_WORK_JOBS jobs

6822: SELECT start_range,
6823: end_range
6824: INTO l_start_range,
6825: l_end_range
6826: FROM FII_AP_PS_WORK_JOBS jobs
6827: WHERE jobs.worker_number = p_worker_no
6828: AND jobs.status = 'IN PROCESS';
6829:
6830: ---------------------------------------------------------

Line 6841: UPDATE FII_AP_PS_WORK_JOBS jobs

6837: if g_debug_flag = 'Y' then
6838: FII_UTIL.stop_timer;
6839: FII_UTIL.print_timer('Duration');
6840: end if;
6841: UPDATE FII_AP_PS_WORK_JOBS jobs
6842: SET jobs.status = 'COMPLETED'
6843: WHERE jobs.status = 'IN PROCESS'
6844: AND jobs.worker_number = p_worker_no;
6845: COMMIT;

Line 6851: UPDATE FII_AP_PS_WORK_JOBS

6847: EXCEPTION
6848: WHEN OTHERS THEN
6849: g_retcode := -1;
6850:
6851: UPDATE FII_AP_PS_WORK_JOBS
6852: SET status = 'FAILED'
6853: WHERE worker_number = p_worker_no
6854: AND status = 'IN PROCESS';
6855:

Line 6875: UPDATE FII_AP_PS_WORK_JOBS

6871: -------------------------------------------
6872: -- Update the WORKER_JOBS table to indicate
6873: -- this job has failed
6874: -------------------------------------------
6875: UPDATE FII_AP_PS_WORK_JOBS
6876: SET status = 'FAILED'
6877: WHERE worker_number = p_worker_no
6878: AND status = 'IN PROCESS';
6879:

Line 7032: TRUNCATE_TABLE('FII_AP_PS_WORK_JOBS');

7028:
7029: g_state := 'Truncating temp tables used to populate base tables';
7030: TRUNCATE_TABLE('FII_AP_PS_RATES_TEMP');
7031: TRUNCATE_TABLE('FII_AP_FUNC_RATES_TEMP');
7032: TRUNCATE_TABLE('FII_AP_PS_WORK_JOBS');
7033: TRUNCATE_TABLE('FII_AP_PAY_SCHED_TEMP');
7034: TRUNCATE_TABLE('FII_AP_WH_TAX_T');
7035: TRUNCATE_TABLE('FII_AP_PREPAY_T');
7036: TRUNCATE_TABLE('FII_AP_PAY_CHK_STG');

Line 7208: TRUNCATE_TABLE('FII_AP_PS_WORK_JOBS');

7204: g_state := 'Truncating temp tables after used to populate base tables';
7205: TRUNCATE_TABLE('FII_AP_PAY_SCHED_TEMP');
7206: TRUNCATE_TABLE('FII_AP_WH_TAX_T');
7207: TRUNCATE_TABLE('FII_AP_PREPAY_T');
7208: TRUNCATE_TABLE('FII_AP_PS_WORK_JOBS');
7209: TRUNCATE_TABLE('FII_AP_PAY_CHK_STG');
7210:
7211: END IF;
7212: