DBA Data[Home] [Help]

APPS.FND_AMP_PRIVATE dependencies on FND_CONCURRENT_REQUESTS

Line 451: from fnd_concurrent_requests

447: controlling_manager, parent_request_id
448: into req_phase, req_status,
449: is_sub_req, has_sub_req,
450: mgr_proc, par_req_id
451: from fnd_concurrent_requests
452: where request_id = req_id
453: for update of phase_code nowait;
454: exception
455: when others then

Line 489: update fnd_concurrent_requests

485: who_cancelled := fnd_message.get;
486: end if;
487:
488:
489: update fnd_concurrent_requests
490: set phase_code = decode(new_status, 'T', phase_code, 'C'),
491: status_code = new_status,
492: completion_text = who_cancelled,
493: last_update_date = sysdate,

Line 550: from fnd_concurrent_requests

546:
547: begin
548: select phase_code, hold_flag, request_type
549: into req_phase, req_hold, req_type
550: from fnd_concurrent_requests
551: where request_id = req_id
552: for update of phase_code nowait;
553: exception
554: when others then

Line 580: update fnd_concurrent_requests

576: retval := 3;
577: end if;
578:
579:
580: update fnd_concurrent_requests
581: set hold_flag = new_hold,
582: last_update_date = sysdate,
583: last_updated_by = fnd_global.user_id
584: where request_id = req_id;

Line 631: from fnd_concurrent_requests

627:
628: begin
629: select phase_code
630: into req_phase
631: from fnd_concurrent_requests
632: where request_id = req_id
633: for update of phase_code nowait;
634: exception
635: when others then

Line 649: update fnd_concurrent_requests

645: return 2;
646: end if;
647:
648:
649: update fnd_concurrent_requests
650: set priority = new_priority,
651: last_update_date = sysdate,
652: last_updated_by = fnd_global.user_id
653: where request_id = req_id;