APPS.FA_GENACCTS_PKG dependencies on FA_WORKER_JOBS

Line 331: FROM FA_WORKER_JOBS

327: l_failed_cnt,
328: l_wip_cnt,
329: l_completed_cnt,
330: l_total_cnt
331: FROM FA_WORKER_JOBS
332: WHERE request_id = p_parent_request_id;
333:
334: if g_log_level_rec.statement_level then
335: fa_debug_pkg.add(l_calling_fn, 'Job status - Unassigned: ', l_unassigned_cnt, p_log_level_rec => g_log_level_rec);

Line 358: UPDATE FA_WORKER_JOBS

354: fa_debug_pkg.add(l_calling_fn, 'All jobs completed, no more jobs. ', 'Terminating', p_log_level_rec => g_log_level_rec);
355: end if;
356: raise done_exc;
357: ELSIF (l_unassigned_cnt > 0) THEN
358: UPDATE FA_WORKER_JOBS
359: SET status = 'IN PROCESS',
360: worker_num = p_request_number
361: WHERE status = 'UNASSIGNED'
362: AND request_id = p_parent_request_id

Line 398: FROM FA_WORKER_JOBS

394: SELECT start_range,
395: end_range
396: INTO l_start_range,
397: l_end_range
398: FROM FA_WORKER_JOBS
399: WHERE request_id = p_parent_request_id
400: AND worker_num = p_request_number
401: AND status = 'IN PROCESS';
402:

Line 620: UPDATE FA_WORKER_JOBS

616: if g_log_level_rec.statement_level then
617: fa_debug_pkg.add(l_calling_fn, 'updating', 'worker jobs', p_log_level_rec => g_log_level_rec);
618: end if;
619:
620: UPDATE FA_WORKER_JOBS
621: SET status = 'COMPLETED'
622: WHERE request_id = p_parent_request_id
623: AND worker_num = p_request_number
624: AND status = 'IN PROCESS';

Line 637: UPDATE FA_WORKER_JOBS

633:
634: FA_SRVR_MSG.ADD_SQL_ERROR(
635: CALLING_FN => 'FA_GENACCTS_PKG.gen_accts', p_log_level_rec => g_log_level_rec);
636:
637: UPDATE FA_WORKER_JOBS
638: SET status = 'FAILED'
639: WHERE request_id = p_parent_request_id
640: AND worker_num = p_request_number
641: AND status = 'IN PROCESS';

Line 2088: INSERT INTO FA_WORKER_JOBS

2084:
2085: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 1000);
2086: l_dist_source_book := fa_cache_pkg.fazcbc_record.distribution_source_book;
2087:
2088: INSERT INTO FA_WORKER_JOBS
2089: (START_RANGE, END_RANGE, WORKER_NUM, STATUS,REQUEST_ID)
2090: SELECT MIN(DISTRIBUTION_ID), MAX(DISTRIBUTION_ID), 0,
2091: 'UNASSIGNED', p_parent_request_id FROM ( SELECT /*+ parallel(DH) */
2092: DISTRIBUTION_ID, FLOOR(RANK()