APPS.FND_AMP_PRIVATE dependencies on FND_CONC

Line 45: alive := FND_CONC.process_alive(pid);

41: alive boolean;
42:
43: begin
44:
45: alive := FND_CONC.process_alive(pid);
46: return alive;
47:
48: end process_alive;
49:

Line 69: if (fnd_conc_request_pkg.lock_parent (parent_request_id)) then

65: if (is_sub_request = 'Y') then
66: -- Lock the parent so that no other process can
67: -- perform the same actions to follow (including CM).
68: -- If parent status is W (Paused), no need to update.
69: if (fnd_conc_request_pkg.lock_parent (parent_request_id)) then
70: -- If request to delete is the last pending child,
71: -- set paused parent request to pending for restart
72: -- Need to maintain the parent-child order of
73: -- request locking, so update parent first before

Line 79: if (fnd_conc_request_pkg.restart_parent (

75: -- Status codes between 'I' and 'T' are pending or
76: -- running. They include 'I' Pending Normal,
77: -- 'Q' Pending Standby, 'R' Running Normal, and
78: -- 'T' Running Terminating.
79: if (fnd_conc_request_pkg.restart_parent (
80: request_id,
81: parent_request_id,
82: fnd_global.user_id)) then
83: fnd_message.set_name (

Line 94: fnd_conc_request_pkg.delete_children (

90: if (has_sub_request = 'Y') then
91: -- Update status of children to terminating,
92: -- terminated or cancelled unless they are already
93: -- complete or terminating.
94: fnd_conc_request_pkg.delete_children (
95: request_id,
96: fnd_global.user_id);
97: end if;
98: end cancel_subrequests;

Line 155: from fnd_concurrent_program_serial

151: end if;
152:
153: /* Are they incompatible? */
154: select count(*) into c
155: from fnd_concurrent_program_serial
156: where running_application_id = program_appl2
157: and running_concurrent_program_id = program_id2
158: and to_run_application_id = program_appl1
159: and to_run_concurrent_program_id = program_id1;

Line 235: from fnd_concurrent_worker_requests

231: into upcode,
232: uscode
233: from sys.dual
234: where not exists (select null
235: from fnd_concurrent_worker_requests
236: where request_id = rid
237: and running_processes > 0
238: and (not (queue_application_id = 0
239: and concurrent_queue_id in (1,4))

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;