DBA Data[Home] [Help]

APPS.PA_RP_UTIL dependencies on PA_NUM_TBL_TYPE

Line 213: , x_worker_request_ids OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

209:
210:
211: PROCEDURE Start_Workers (p_request_id NUMBER
212: ,p_rp_id NUMBER
213: , x_worker_request_ids OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
214: , x_return_status IN OUT NOCOPY VARCHAR
215: , x_msg_count IN OUT NOCOPY NUMBER
216: , x_msg_data IN OUT NOCOPY VARCHAR2) IS
217: l_worker_number NUMBER;

Line 232: x_worker_request_ids := SYSTEM.PA_NUM_TBL_TYPE();

228:
229:
230: l_worker_number := TO_NUMBER(FND_PROFILE.VALUE('PA_RP_WORKER_QUANTITY')); -- this should be read from profile option
231:
232: x_worker_request_ids := SYSTEM.PA_NUM_TBL_TYPE();
233: x_worker_request_ids.extend(l_worker_number);
234:
235: FOR l_i IN 1..l_worker_number LOOP
236: x_worker_request_ids(l_i):=Fnd_Request.submit_request(application => 'PA'

Line 255: , p_worker_request_ids SYSTEM.PA_NUM_TBL_TYPE

251: END Start_Workers;
252:
253:
254: PROCEDURE Check_Workers (p_main_request_id NUMBER
255: , p_worker_request_ids SYSTEM.PA_NUM_TBL_TYPE
256: , x_conc_prog_status OUT NOCOPY NUMBER -- 0 normal 1 warning 2 error
257: , x_return_status IN OUT NOCOPY VARCHAR
258: , x_msg_count IN OUT NOCOPY NUMBER
259: , x_msg_data IN OUT NOCOPY VARCHAR2)IS

Line 601: l_plan_version_ids SYSTEM.PA_NUM_TBL_TYPE;

597: , x_msg_data IN OUT NOCOPY VARCHAR2)
598: IS
599: l_temp_id NUMBER;
600: l_i NUMBER;
601: l_plan_version_ids SYSTEM.PA_NUM_TBL_TYPE;
602: BEGIN
603: IF g_debug_mode = 'Y' THEN
604: Pji_Utils.WRITE2LOG( 'PA_RP_UTIL.Derive_Proj_Params: beginning', TRUE , g_proc);
605: END IF;

Line 703: l_plan_version_ids := SYSTEM.PA_NUM_TBL_TYPE(

699: , x_prior_cstforecast_version_id
700: , x_prior_revforecast_version_id
701: , x_return_status, x_msg_count, x_msg_data);
702:
703: l_plan_version_ids := SYSTEM.PA_NUM_TBL_TYPE(
704: -1
705: , x_cstforecast_version_id
706: , x_cstbudget_version_id
707: , x_cstbudget2_version_id