APPS.FII_AP_INV_DISTRIBUTIONS_B_C dependencies on FII_AP_SUM_WORK_JOBS

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

126: if g_debug_flag = 'Y' then
127: FII_UTIL.put_line('Calling procedure CLEAN_UP');
128: FII_UTIL.put_line('');
129:
130: FII_UTIL.put_line('Truncate table FII_AP_SUM_WORK_JOBS');
131: end if;
132: truncate_table('FII_AP_SUM_WORK_JOBS');
133:
134: IF (g_truncate_id = 'Y') THEN

Line 132: truncate_table('FII_AP_SUM_WORK_JOBS');

128: FII_UTIL.put_line('');
129:
130: FII_UTIL.put_line('Truncate table FII_AP_SUM_WORK_JOBS');
131: end if;
132: truncate_table('FII_AP_SUM_WORK_JOBS');
133:
134: IF (g_truncate_id = 'Y') THEN
135: if g_debug_flag = 'Y' then
136: FII_UTIL.put_line('Truncate table FII_AP_INV_ID');

Line 441: INSERT INTO FII_AP_SUM_WORK_JOBS (

437: WHILE (l_start_number < (l_max_number + 1))
438: LOOP
439: l_end_number:= l_start_number + INTERVAL_SIZE;
440:
441: INSERT INTO FII_AP_SUM_WORK_JOBS (
442: start_range,
443: end_range,
444: worker_number,
445: status)

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

453: l_start_number := least(l_end_number, l_max_number) + 1;
454: END LOOP;
455:
456: if g_debug_flag = 'Y' then
457: FII_UTIL.put_line('Inserted ' || l_count || ' jobs into FII_AP_SUM_WORK_JOBS table');
458: end if;
459:
460: EXCEPTION
461: WHEN OTHERS THEN

Line 1908: FROM FII_AP_SUM_WORK_JOBS;

1904: l_completed_cnt,
1905: l_wip_cnt,
1906: l_failed_cnt,
1907: l_tot_cnt
1908: FROM FII_AP_SUM_WORK_JOBS;
1909:
1910: if g_debug_flag = 'Y' then
1911: FII_UTIL.put_line('Job status - Unassigned:'||l_unassigned_cnt||
1912: ' In Process:'||l_wip_cnt||

Line 2156: Truncate_table('FII_AP_SUM_WORK_JOBS');

2152: -- of the program.
2153: ---------------------------------------------------------------
2154: Truncate_table('FII_AP_INV_DIST_T');
2155:
2156: Truncate_table('FII_AP_SUM_WORK_JOBS');
2157:
2158: RAISE;
2159: END Collect;
2160:

Line 2235: FROM FII_AP_SUM_WORK_JOBS;

2231: l_failed_cnt,
2232: l_curr_unasgn_cnt,
2233: l_curr_comp_cnt,
2234: l_curr_tot_cnt
2235: FROM FII_AP_SUM_WORK_JOBS;
2236:
2237: IF (l_failed_cnt > 0) THEN
2238: if g_debug_flag = 'Y' then
2239: FII_UTIL.put_line('');

Line 2256: UPDATE FII_AP_SUM_WORK_JOBS

2252: FII_UTIL.put_line('All jobs completed, no more job. Terminating');
2253: end if;
2254: EXIT;
2255: ELSIF (l_curr_unasgn_cnt > 0) THEN
2256: UPDATE FII_AP_SUM_WORK_JOBS
2257: SET status = 'IN PROCESS',
2258: worker_number = p_worker_no
2259: WHERE status = 'UNASSIGNED'
2260: AND rownum < 2;

Line 2279: FROM FII_AP_SUM_WORK_JOBS jobs

2275: SELECT start_range,
2276: end_range
2277: INTO l_start_range,
2278: l_end_range
2279: FROM FII_AP_SUM_WORK_JOBS jobs
2280: WHERE jobs.worker_number = p_worker_no
2281: AND jobs.status = 'IN PROCESS';
2282:
2283: ---------------------------------------------------------

Line 2295: UPDATE FII_AP_SUM_WORK_JOBS jobs

2291: FII_UTIL.stop_timer;
2292: FII_UTIL.print_timer('Duration');
2293: end if;
2294:
2295: UPDATE FII_AP_SUM_WORK_JOBS jobs
2296: SET jobs.status = 'COMPLETED'
2297: WHERE jobs.status = 'IN PROCESS'
2298: AND jobs.worker_number = p_worker_no;
2299:

Line 2306: UPDATE FII_AP_SUM_WORK_JOBS

2302: EXCEPTION
2303: WHEN OTHERS THEN
2304: g_retcode := -1;
2305:
2306: UPDATE FII_AP_SUM_WORK_JOBS
2307: SET status = 'FAILED'
2308: WHERE worker_number = p_worker_no
2309: AND status = 'IN PROCESS';
2310:

Line 2330: UPDATE FII_AP_SUM_WORK_JOBS

2326: -------------------------------------------
2327: -- Update the WORKER_JOBS table to indicate
2328: -- this job has failed
2329: -------------------------------------------
2330: UPDATE FII_AP_SUM_WORK_JOBS
2331: SET status = 'FAILED'
2332: WHERE worker_number = p_worker_no
2333: AND status = 'IN PROCESS';
2334: