DBA Data[Home] [Help]

APPS.FND_AMP_PRIVATE dependencies on FND_CONCURRENT_REQUESTS

Line 404: from fnd_concurrent_requests

400: controlling_manager, parent_request_id
401: into req_phase, req_status,
402: is_sub_req, has_sub_req,
403: mgr_proc, par_req_id
404: from fnd_concurrent_requests
405: where request_id = req_id
406: for update of phase_code nowait;
407: exception
408: when others then

Line 442: update fnd_concurrent_requests

438: who_cancelled := fnd_message.get;
439: end if;
440:
441:
442: update fnd_concurrent_requests
443: set phase_code = decode(new_status, 'T', phase_code, 'C'),
444: status_code = new_status,
445: completion_text = who_cancelled,
446: last_update_date = sysdate,

Line 503: from fnd_concurrent_requests

499:
500: begin
501: select phase_code, hold_flag, request_type
502: into req_phase, req_hold, req_type
503: from fnd_concurrent_requests
504: where request_id = req_id
505: for update of phase_code nowait;
506: exception
507: when others then

Line 533: update fnd_concurrent_requests

529: retval := 3;
530: end if;
531:
532:
533: update fnd_concurrent_requests
534: set hold_flag = new_hold,
535: last_update_date = sysdate,
536: last_updated_by = fnd_global.user_id
537: where request_id = req_id;

Line 584: from fnd_concurrent_requests

580:
581: begin
582: select phase_code
583: into req_phase
584: from fnd_concurrent_requests
585: where request_id = req_id
586: for update of phase_code nowait;
587: exception
588: when others then

Line 602: update fnd_concurrent_requests

598: return 2;
599: end if;
600:
601:
602: update fnd_concurrent_requests
603: set priority = new_priority,
604: last_update_date = sysdate,
605: last_updated_by = fnd_global.user_id
606: where request_id = req_id;