APPS.FND_PERFMON dependencies on FND_PERF_VARIABLES

Line 14: update fnd_perf_variables set value = to_char(new_expire)

10: -- Then delete expired samples.
11: --
12: procedure SET_WAIT_SAMPLE_EXPIRATION(new_expire float) is
13: begin
14: update fnd_perf_variables set value = to_char(new_expire)
15: where variable = 'wait_sample_expiration';
16:
17: /* Delete expired samples. */
18: delete from fnd_wait_samples

Line 34: from fnd_perf_variables

30: function GET_WAIT_SAMPLE_EXPIRATION return float is
31: wait_sample_expiration float;
32: begin
33: select to_number(value) into wait_sample_expiration
34: from fnd_perf_variables
35: where variable = 'wait_sample_expiration';
36: return(wait_sample_expiration);
37: end;
38:

Line 183: update fnd_perf_variables set value = to_char(new_expire)

179: -- Then delete expired samples.
180: --
181: procedure SET_SQL_SAMPLE_EXPIRATION(new_expire float) is
182: begin
183: update fnd_perf_variables set value = to_char(new_expire)
184: where variable = 'sql_sample_expiration';
185:
186: /* Delete expired samples. */
187: delete from fnd_sql_samples

Line 203: from fnd_perf_variables

199: function GET_SQL_SAMPLE_EXPIRATION return float is
200: sql_sample_expiration float;
201: begin
202: select to_number(value) into sql_sample_expiration
203: from fnd_perf_variables
204: where variable = 'sql_sample_expiration';
205: return(sql_sample_expiration);
206: end;
207:

Line 253: So, init wait_sample_expiration when fnd_perf_variables

249:
250: we should init wait_sample_expiration here,
251: but a bug in dbms_job (Rel 7.1.6) re-initilizes package
252: each time the job is called.
253: So, init wait_sample_expiration when fnd_perf_variables
254: table is created.
255: set_wait_sample_expiration(7 * 6);
256: */
257: