APPS.FA_XADJ_ITF_PKG dependencies on FA_WORKER_JOBS

Line 146: from fa_worker_jobs

142: l_failed_cnt,
143: l_wip_cnt,
144: l_completed_cnt,
145: l_total_cnt
146: from fa_worker_jobs
147: where request_id = p_parent_request_id;
148: exception
149: when others then
150: raise fapadj_err;

Line 179: update fa_worker_jobs

175: raise done_exc;
176: elsif (l_unassigned_cnt > 0) then
177: begin
178:
179: update fa_worker_jobs
180: set status = 'IN PROCESS',
181: worker_num = p_request_number
182: where status = 'UNASSIGNED'
183: and request_id = p_parent_request_id

Line 214: from fa_worker_jobs

210: select start_range
211: ,end_range
212: into l_start_range
213: ,l_end_range
214: from fa_worker_jobs
215: where request_id = p_parent_request_id
216: and worker_num = p_request_number
217: and status = 'IN PROCESS';
218:

Line 461: update fa_worker_jobs

457: if (p_total_requests > 1) then
458:
459: if (x_failure_count <> 0) then
460:
461: update fa_worker_jobs
462: set status = 'FAILED'
463: where request_id = p_parent_request_id
464: and worker_num = p_request_number
465: and status = 'IN PROCESS';

Line 469: update fa_worker_jobs

465: and status = 'IN PROCESS';
466:
467: commit;
468: else
469: update fa_worker_jobs
470: set status = 'COMPLETED'
471: where request_id = p_parent_request_id
472: and worker_num = p_request_number
473: and status = 'IN PROCESS';

Line 493: update fa_worker_jobs

489: when done_exc then
490:
491: if (p_total_requests > 1) then
492:
493: update fa_worker_jobs
494: set status = 'COMPLETED'
495: where request_id = p_parent_request_id
496: and worker_num = p_request_number
497: and status = 'IN PROCESS';

Line 511: update fa_worker_jobs

507: when fapadj_err then
508:
509: if (p_total_requests > 1) then
510:
511: update fa_worker_jobs
512: set status = 'FAILED'
513: where request_id = p_parent_request_id
514: and worker_num = p_request_number
515: and status = 'IN PROCESS';

Line 537: update fa_worker_jobs

533: when others then
534:
535: if (p_total_requests > 1) then
536:
537: update fa_worker_jobs
538: set status = 'FAILED'
539: where request_id = p_parent_request_id
540: and worker_num = p_request_number
541: and status = 'IN PROCESS';

Line 627: insert into fa_worker_jobs

623: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 1000);
624:
625: if (p_total_requests > 1) then
626:
627: insert into fa_worker_jobs
628: (start_range, end_range, worker_num, status,request_id)
629: select min(aid), max(aid), 0,
630: 'UNASSIGNED', p_parent_request_id from ( select /*+ parallel(dh) */
631: fab.asset_id aid, floor(rank()