DBA Data[Home] [Help]

APPS.FND_RESUB_PRIVATE dependencies on FND_CONCURRENT_REQUESTS

Line 160: from fnd_concurrent_requests r,

156: p_args(21), p_args(22), p_args(23), p_args(24), p_args(25),
157: P_increment_flag, P_sch_app_id, P_sch_id,
158: prog_name, prog_app_name,
159: P_sch_name,P_sch_type,P_inc_proc
160: from fnd_concurrent_requests r,
161: fnd_concurrent_programs p,
162: fnd_application a,
163: fnd_conc_release_classes c
164: where r.request_id = req_id

Line 259: UPDATE FND_CONCURRENT_REQUESTS

255: end loop;
256:
257: argtxt2 := substrb (argtxt, 1, 240);
258:
259: UPDATE FND_CONCURRENT_REQUESTS
260: SET Argument_Text = argtxt2, NUMBER_OF_ARGUMENTS = P_nargs,
261: ARGUMENT1 = p_args(1), ARGUMENT2 = p_args(2), ARGUMENT3 = p_args(3), ARGUMENT4 = p_args(4),
262: ARGUMENT5 = p_args(5), ARGUMENT6 = p_args(6), ARGUMENT7 = p_args(7), ARGUMENT8 = p_args(8),
263: ARGUMENT9 = p_args(9), ARGUMENT10 = p_args(10), ARGUMENT11 = p_args(11),

Line 310: from fnd_concurrent_requests

306: typ varchar2(1);
307: begin
308: select request_type
309: into typ
310: from fnd_concurrent_requests
311: where request_id = req_id;
312:
313: /* Bug 2351842: 'M' - Request set parent, 'B' - FNDMLSUB */
314: if typ in ('M', 'B') then

Line 395: from fnd_concurrent_requests r,

391: into P_count, old_req_start,
392: P_rsub_int, P_rsub_int_unit_code,
393: P_increment_flag, P_sch_app_id, P_sch_id,
394: P_sch_name, P_sch_type
395: from fnd_concurrent_requests r,
396: fnd_conc_release_classes c
397: where r.request_id = req_id
398: and c.RELEASE_CLASS_ID = r.RELEASE_CLASS_ID
399: and r.RELEASE_CLASS_APP_ID = c.APPLICATION_ID;

Line 753: from fnd_concurrent_requests

749:
750: -- don't go any further if the increment flag is not set
751: select nvl(increment_dates, 'N')
752: into P_increment_flag
753: from fnd_concurrent_requests
754: where request_id = req_id;
755:
756: if P_increment_flag <> 'Y' then
757: errnum := 0;