APPS.FA_XADJ_ITF_PKG dependencies on FA_WORKER_JOBS

Line 145: from fa_worker_jobs

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

Line 178: update fa_worker_jobs

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

Line 213: from fa_worker_jobs

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

Line 450: update fa_worker_jobs

446: if (p_total_requests > 1) then
447:
448: if (x_failure_count <> 0) then
449:
450: update fa_worker_jobs
451: set status = 'FAILED'
452: where request_id = p_parent_request_id
453: and worker_num = p_request_number
454: and status = 'IN PROCESS';

Line 458: update fa_worker_jobs

454: and status = 'IN PROCESS';
455:
456: commit;
457: else
458: update fa_worker_jobs
459: set status = 'COMPLETED'
460: where request_id = p_parent_request_id
461: and worker_num = p_request_number
462: and status = 'IN PROCESS';

Line 482: update fa_worker_jobs

478: when done_exc then
479:
480: if (p_total_requests > 1) then
481:
482: update fa_worker_jobs
483: set status = 'COMPLETED'
484: where request_id = p_parent_request_id
485: and worker_num = p_request_number
486: and status = 'IN PROCESS';

Line 500: update fa_worker_jobs

496: when fapadj_err then
497:
498: if (p_total_requests > 1) then
499:
500: update fa_worker_jobs
501: set status = 'FAILED'
502: where request_id = p_parent_request_id
503: and worker_num = p_request_number
504: and status = 'IN PROCESS';

Line 526: update fa_worker_jobs

522: when others then
523:
524: if (p_total_requests > 1) then
525:
526: update fa_worker_jobs
527: set status = 'FAILED'
528: where request_id = p_parent_request_id
529: and worker_num = p_request_number
530: and status = 'IN PROCESS';

Line 608: insert into fa_worker_jobs

604: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 1000);
605:
606: if (p_total_requests > 1) then
607:
608: insert into fa_worker_jobs
609: (start_range, end_range, worker_num, status,request_id)
610: select min(aid), max(aid), 0,
611: 'UNASSIGNED', p_parent_request_id from ( select /*+ parallel(dh) */
612: fab.asset_id aid, floor(rank()