APPS.FA_GENACCTS_PKG dependencies on FA_WORKER_JOBS

Line 309: FROM FA_WORKER_JOBS

305: l_failed_cnt,
306: l_wip_cnt,
307: l_completed_cnt,
308: l_total_cnt
309: FROM FA_WORKER_JOBS
310: WHERE request_id = p_parent_request_id;
311:
312: if g_log_level_rec.statement_level then
313: fa_debug_pkg.add(l_calling_fn, 'Job status - Unassigned: ', l_unassigned_cnt

Line 344: UPDATE FA_WORKER_JOBS

340: ,p_log_level_rec => g_log_level_rec);
341: end if;
342: raise done_exc;
343: ELSIF (l_unassigned_cnt > 0) THEN
344: UPDATE FA_WORKER_JOBS
345: SET status = 'IN PROCESS',
346: worker_num = p_request_number
347: WHERE status = 'UNASSIGNED'
348: AND request_id = p_parent_request_id

Line 405: FROM FA_WORKER_JOBS

401: SELECT start_range,
402: end_range
403: INTO l_start_range,
404: l_end_range
405: FROM FA_WORKER_JOBS
406: WHERE request_id = p_parent_request_id
407: AND worker_num = p_request_number
408: AND status = 'IN PROCESS';
409:

Line 599: UPDATE FA_WORKER_JOBS

595: fa_debug_pkg.add(l_calling_fn, 'updating', 'worker jobs'
596: ,p_log_level_rec => g_log_level_rec);
597: end if;
598:
599: UPDATE FA_WORKER_JOBS
600: SET status = 'COMPLETED'
601: WHERE request_id = p_parent_request_id
602: AND worker_num = p_request_number
603: AND status = 'IN PROCESS';

Line 617: UPDATE FA_WORKER_JOBS

613: FA_SRVR_MSG.ADD_SQL_ERROR(
614: CALLING_FN => 'FA_GENACCTS_PKG.gen_accts'
615: ,p_log_level_rec => g_log_level_rec);
616:
617: UPDATE FA_WORKER_JOBS
618: SET status = 'FAILED'
619: WHERE request_id = p_parent_request_id
620: AND worker_num = p_request_number
621: AND status = 'IN PROCESS';

Line 1893: INSERT INTO FA_WORKER_JOBS

1889:
1890: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 1000);
1891: l_dist_source_book := fa_cache_pkg.fazcbc_record.distribution_source_book;
1892:
1893: INSERT INTO FA_WORKER_JOBS
1894: (START_RANGE, END_RANGE, WORKER_NUM, STATUS,REQUEST_ID)
1895: SELECT MIN(DISTRIBUTION_ID), MAX(DISTRIBUTION_ID), 0,
1896: 'UNASSIGNED', p_parent_request_id FROM ( SELECT /*+ parallel(DH) */
1897: DISTRIBUTION_ID, FLOOR(RANK()