APPS.FARX_C_WD dependencies on FA_WORKER_JOBS

Line 732: from fa_worker_jobs

728: l_failed_cnt,
729: l_wip_cnt,
730: l_completed_cnt,
731: l_total_cnt
732: from fa_worker_jobs
733: where request_id = p_parent_request_id;
734:
735: if g_print_debug then
736: fa_debug_pkg.add(l_calling_fn, 'Job status - Unassigned: ', l_unassigned_cnt);

Line 759: update fa_worker_jobs

755: fa_debug_pkg.add(l_calling_fn, 'all jobs completed, no more jobs. ', 'terminating');
756: end if;
757: raise done_exc;
758: elsif (l_unassigned_cnt > 0) then
759: update fa_worker_jobs
760: set status = 'IN PROCESS',
761: worker_num = p_request_number
762: where status = 'UNASSIGNED'
763: and request_id = p_parent_request_id

Line 786: from fa_worker_jobs

782: select start_range
783: ,end_range
784: into l_start_range
785: ,l_end_range
786: from fa_worker_jobs
787: where request_id = p_parent_request_id
788: and worker_num = p_request_number
789: and status = 'IN PROCESS';
790:

Line 868: update fa_worker_jobs

864: h_mesg_str := fnd_message.get;
865: fa_rx_conc_mesg_pkg.log(h_mesg_str);
866:
867: if (p_total_requests > 1) then
868: update fa_worker_jobs
869: set status = 'COMPLETED'
870: where request_id = p_parent_request_id
871: and worker_num = p_request_number
872: and status = 'IN PROCESS';

Line 916: update fa_worker_jobs

912:
913: if (p_total_requests < 2 ) then
914: raise done_exc;
915: else
916: update fa_worker_jobs
917: set status = 'COMPLETED'
918: where request_id = p_parent_request_id
919: and worker_num = p_request_number
920: and status = 'IN PROCESS';

Line 930: update fa_worker_jobs

926:
927: if (p_total_requests < 2 ) then
928: raise error_found;
929: else
930: update fa_worker_jobs
931: set status = 'FAILED'
932: where request_id = p_parent_request_id
933: and worker_num = p_request_number
934: and status = 'IN PROCESS';

Line 1050: update fa_worker_jobs

1046: if (ret) then
1047: if (p_total_requests < 2 ) then
1048: raise done_exc;
1049: else
1050: update fa_worker_jobs
1051: set status = 'COMPLETED'
1052: where request_id = p_parent_request_id
1053: and worker_num = p_request_number
1054: and status = 'IN PROCESS';

Line 1063: update fa_worker_jobs

1059: else
1060: if (p_total_requests < 2 ) then
1061: raise error_found;
1062: else
1063: update fa_worker_jobs
1064: set status = 'FAILED'
1065: where request_id = p_parent_request_id
1066: and worker_num = p_request_number
1067: and status = 'IN PROCESS';

Line 1083: update fa_worker_jobs

1079: EXCEPTION
1080: WHEN done_exc then
1081: if (p_total_requests > 1) then
1082:
1083: update fa_worker_jobs
1084: set status = 'COMPLETED'
1085: where request_id = p_parent_request_id
1086: and worker_num = p_request_number
1087: and status = 'IN PROCESS';

Line 1104: update fa_worker_jobs

1100: return;
1101:
1102: WHEN error_found then
1103:
1104: update fa_worker_jobs
1105: set status = 'FAILED'
1106: where request_id = p_parent_request_id
1107: and worker_num = p_request_number
1108: and status = 'IN PROCESS';

Line 1122: update fa_worker_jobs

1118: return;
1119:
1120: WHEN OTHERS THEN
1121:
1122: update fa_worker_jobs
1123: set status = 'FAILED'
1124: where request_id = p_parent_request_id
1125: and worker_num = p_request_number
1126: and status = 'IN PROCESS';

Line 1175: insert into fa_worker_jobs

1171: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 1000);
1172:
1173: if (p_total_requests > 1) then
1174:
1175: insert into fa_worker_jobs
1176: (start_range, end_range, worker_num, status,request_id)
1177: select min(asset_id), max(asset_id), 0,
1178: 'UNASSIGNED', p_parent_request_id from ( select /*+ parallel(dh) */
1179: asset_id, floor(rank()