eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_RP_UTIL dependencies on PA_RP_JOB_ASSIGNMENTS

Line 25: UPDATE pa_rp_job_assignments

21: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
22: END IF;
23:
24:
25: UPDATE pa_rp_job_assignments
26: SET status_flag = p_previous_succeed
27: WHERE status_flag = 'P'
28: AND main_request_id = p_main_request_id
29: AND worker_request_id = p_worker_request_id;

Line 34: UPDATE pa_rp_job_assignments

30:
31: x_bursting_values := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
32: x_bursting_values.extend(3);
33:
34: UPDATE pa_rp_job_assignments
35: SET status_flag ='P', worker_request_id = p_worker_request_id
36: WHERE status_flag = 'C' AND ROWNUM=1 AND main_request_id = p_main_request_id
37: RETURN bursting_value_1, bursting_value_2, bursting_value_3
38: INTO x_bursting_values(1), x_bursting_values(2), x_bursting_values(3);

Line 308: FROM pa_rp_job_assignments

304: ,message => l_message);
305:
306: SELECT DECODE(COUNT(*),0,'Y','N')
307: INTO l_finish
308: FROM pa_rp_job_assignments
309: WHERE main_request_id = p_main_request_id
310: AND worker_request_id = l_request_id
311: AND status_flag = 'P';
312:

Line 338: INSERT INTO pa_rp_job_assignments_history

334: END IF;
335: END LOOP;
336:
337: /* Move the job assignment record into history table */
338: INSERT INTO pa_rp_job_assignments_history
339: (ASSIGNMENT_ID, MAIN_REQUEST_ID, WORKER_REQUEST_ID, STATUS_FLAG, RP_ID, BURSTING_VALUE_1, BURSTING_VALUE_2, BURSTING_VALUE_3, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, LAST_UPDATE_LOGIN)
340: SELECT ASSIGNMENT_ID, MAIN_REQUEST_ID, WORKER_REQUEST_ID, STATUS_FLAG, RP_ID, BURSTING_VALUE_1, BURSTING_VALUE_2, BURSTING_VALUE_3, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, LAST_UPDATE_LOGIN FROM pa_rp_job_assignments
341: WHERE main_request_id = p_main_request_id;
342:

Line 340: SELECT ASSIGNMENT_ID, MAIN_REQUEST_ID, WORKER_REQUEST_ID, STATUS_FLAG, RP_ID, BURSTING_VALUE_1, BURSTING_VALUE_2, BURSTING_VALUE_3, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, LAST_UPDATE_LOGIN FROM pa_rp_job_assignments

336:
337: /* Move the job assignment record into history table */
338: INSERT INTO pa_rp_job_assignments_history
339: (ASSIGNMENT_ID, MAIN_REQUEST_ID, WORKER_REQUEST_ID, STATUS_FLAG, RP_ID, BURSTING_VALUE_1, BURSTING_VALUE_2, BURSTING_VALUE_3, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, LAST_UPDATE_LOGIN)
340: SELECT ASSIGNMENT_ID, MAIN_REQUEST_ID, WORKER_REQUEST_ID, STATUS_FLAG, RP_ID, BURSTING_VALUE_1, BURSTING_VALUE_2, BURSTING_VALUE_3, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, LAST_UPDATE_LOGIN FROM pa_rp_job_assignments
341: WHERE main_request_id = p_main_request_id;
342:
343: DELETE FROM pa_rp_job_assignments
344: WHERE main_request_id = p_main_request_id;

Line 343: DELETE FROM pa_rp_job_assignments

339: (ASSIGNMENT_ID, MAIN_REQUEST_ID, WORKER_REQUEST_ID, STATUS_FLAG, RP_ID, BURSTING_VALUE_1, BURSTING_VALUE_2, BURSTING_VALUE_3, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, LAST_UPDATE_LOGIN)
340: SELECT ASSIGNMENT_ID, MAIN_REQUEST_ID, WORKER_REQUEST_ID, STATUS_FLAG, RP_ID, BURSTING_VALUE_1, BURSTING_VALUE_2, BURSTING_VALUE_3, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, LAST_UPDATE_LOGIN FROM pa_rp_job_assignments
341: WHERE main_request_id = p_main_request_id;
342:
343: DELETE FROM pa_rp_job_assignments
344: WHERE main_request_id = p_main_request_id;
345:
346: IF g_debug_mode = 'Y' THEN
347: Pji_Utils.WRITE2LOG( 'PA_RP_UTIL.Check_Workers: finishing', TRUE , g_proc);