APPS.FND_OAM dependencies on FND_CONCURRENT_REQUESTS

Line 90: from fnd_concurrent_requests

86: error out nocopy number, terminated out nocopy number) is
87: begin
88: select count(*)
89: into normal
90: from fnd_concurrent_requests
91: where status_code = 'C';
92:
93: select count(*)
94: into warning

Line 95: from fnd_concurrent_requests

91: where status_code = 'C';
92:
93: select count(*)
94: into warning
95: from fnd_concurrent_requests
96: where status_code = 'G';
97:
98: select count(*)
99: into error

Line 100: from fnd_concurrent_requests

96: where status_code = 'G';
97:
98: select count(*)
99: into error
100: from fnd_concurrent_requests
101: where status_code = 'E';
102:
103: select count(*)
104: into terminated

Line 105: from fnd_concurrent_requests

101: where status_code = 'E';
102:
103: select count(*)
104: into terminated
105: from fnd_concurrent_requests
106: where status_code = 'X';
107: end;
108:
109:

Line 128: from fnd_concurrent_requests

124: standby out nocopy number) is
125: begin
126: select count(*)
127: into normal
128: from fnd_concurrent_requests
129: where status_code = 'I'
130: and requested_start_date <= sysdate
131: and hold_flag = 'N';
132:

Line 135: from fnd_concurrent_requests

131: and hold_flag = 'N';
132:
133: select count(*)
134: into standby
135: from fnd_concurrent_requests
136: where status_code = 'Q'
137: and requested_start_date <= sysdate
138: and hold_flag = 'N';
139:

Line 142: from fnd_concurrent_requests

138: and hold_flag = 'N';
139:
140: select count(*)
141: into scheduled
142: from fnd_concurrent_requests
143: where (status_code = 'P' or
144: (status_code in ('I', 'Q') and requested_start_date > sysdate))
145: and hold_flag = 'N';
146: end;

Line 165: from fnd_concurrent_requests

161: procedure CONC_MGR_PROCS (running_reqs out nocopy number, mgr_procs out nocopy number) is
162: begin
163: select count(*)
164: into running_reqs
165: from fnd_concurrent_requests
166: where status_code = 'R'
167: or status_code = 'T';
168:
169: select sum(running_processes)