APPS.FA_BALREP_PKG dependencies on FA_WORKER_JOBS

Line 17: SELECT ROWID FROM fa_worker_jobs WHERE request_id = request_id_in;

13: l_rowid_tbl char_tbl_type;
14: l_worker_num_tbl num_tbl_type;
15:
16: CURSOR c_workers(request_id_in NUMBER) IS
17: SELECT ROWID FROM fa_worker_jobs WHERE request_id = request_id_in;
18:
19: BEGIN
20: fnd_profile.get('FA_NUM_PARALLEL_REQUESTS', p_total_requests);
21: fnd_profile.get('FA_BATCH_SIZE', l_batch_size);

Line 28: INSERT INTO FA_WORKER_JOBS

24:
25: IF (NVL (p_total_requests, 0) > 0 and NVL (p_total_requests, 0) < 2)
26: THEN
27: BEGIN
28: INSERT INTO FA_WORKER_JOBS
29: ( START_RANGE
30: , END_RANGE
31: , WORKER_NUM
32: , STATUS

Line 49: INSERT INTO fa_worker_jobs

45: WHEN OTHERS THEN
46: raise;
47: END;
48: else
49: INSERT INTO fa_worker_jobs
50: (start_range, end_range, worker_num, status, request_id)
51: SELECT MIN(asset_id), MAX(asset_id), 0, 'UNASSIGNED', p_request_id
52: FROM (SELECT /*+ parallel(BK) */
53: asset_id,

Line 75: UPDATE fa_worker_jobs

71:
72: END LOOP;
73:
74: FORALL i IN 1 .. l_rowid_tbl.count
75: UPDATE fa_worker_jobs
76: SET worker_num = l_worker_num_tbl(i)
77: WHERE ROWID = l_rowid_tbl(i);
78: END LOOP;
79: CLOSE c_workers;

Line 2660: FROM fa_worker_jobs

2656:
2657: CURSOR c_range(request_id_in NUMBER,
2658: worker_number_in NUMBER) IS
2659: SELECT start_range, end_range
2660: FROM fa_worker_jobs
2661: WHERE request_id = request_id_in
2662: AND worker_num = worker_number_in
2663: AND status = 'IN PROCESS';
2664:

Line 2687: UPDATE fa_worker_jobs

2683: l_worker_number := worker_number;
2684:
2685: l_request_id := request_id;
2686:
2687: UPDATE fa_worker_jobs
2688: SET status = 'IN PROCESS'
2689: WHERE status = 'UNASSIGNED'
2690: AND request_id = l_request_id
2691: AND worker_number = l_worker_number;

Line 2812: UPDATE fa_worker_jobs

2808: --=================================
2809: -- Update the child status as completed
2810: -- after the end of loop
2811: --=================================
2812: UPDATE fa_worker_jobs
2813: SET status = 'COMPLETED'
2814: WHERE status = 'IN PROCESS'
2815: AND request_id = l_request_id
2816: AND start_range = start_asset_id

Line 2822: UPDATE fa_worker_jobs

2818:
2819: COMMIT;
2820: EXCEPTION
2821: WHEN OTHERS THEN
2822: UPDATE fa_worker_jobs
2823: SET status = 'FAILED'
2824: WHERE status IN ('IN PROCESS', 'UNASSIGNED')
2825: AND request_id = l_request_id
2826: AND start_range = start_asset_id