APPS.PA_RP_UTIL dependencies on PA_VARCHAR2_240_TBL_TYPE

Line 10: , x_bursting_values OUT NOCOPY SYSTEM.PA_VARCHAR2_240_TBL_TYPE

6: PROCEDURE Assign_Job(p_main_request_id NUMBER
7: , p_worker_request_id NUMBER
8: , p_previous_succeed VARCHAR
9: , x_job_assigned OUT NOCOPY VARCHAR2
10: , x_bursting_values OUT NOCOPY SYSTEM.PA_VARCHAR2_240_TBL_TYPE
11: , x_return_status IN OUT NOCOPY VARCHAR2
12: , x_msg_count IN OUT NOCOPY NUMBER
13: , x_msg_data IN OUT NOCOPY VARCHAR2) IS
14: BEGIN

Line 31: x_bursting_values := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();

27: WHERE status_flag = 'P'
28: AND main_request_id = p_main_request_id
29: AND worker_request_id = p_worker_request_id;
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

Line 456: , p_param_names SYSTEM.PA_VARCHAR2_240_TBL_TYPE

452: */
453:
454: PROCEDURE Save_Params (p_main_request_id NUMBER
455: , p_rp_id NUMBER
456: , p_param_names SYSTEM.PA_VARCHAR2_240_TBL_TYPE
457: , p_param_values SYSTEM.PA_VARCHAR2_240_TBL_TYPE
458: , x_return_status IN OUT NOCOPY VARCHAR
459: , x_msg_count IN OUT NOCOPY NUMBER
460: , x_msg_data IN OUT NOCOPY VARCHAR2) IS

Line 457: , p_param_values SYSTEM.PA_VARCHAR2_240_TBL_TYPE

453:
454: PROCEDURE Save_Params (p_main_request_id NUMBER
455: , p_rp_id NUMBER
456: , p_param_names SYSTEM.PA_VARCHAR2_240_TBL_TYPE
457: , p_param_values SYSTEM.PA_VARCHAR2_240_TBL_TYPE
458: , x_return_status IN OUT NOCOPY VARCHAR
459: , x_msg_count IN OUT NOCOPY NUMBER
460: , x_msg_data IN OUT NOCOPY VARCHAR2) IS
461: l_i NUMBER;