SYS.DBMS_FEATURE_JOB_SCHEDULER dependencies on DBA_SCHEDULER_PROGRAM_ARGS

Line 274: dba_scheduler_program_args) group by an order by 1)

270:
271: for it in (
272: select an t, count(*) n
273: from (select decode(argument_name, null, 'PA_', 'PAN') an from
274: dba_scheduler_program_args) group by an order by 1)
275: loop
276: sum1 := sum1 || ',' || it.t || ':' || it.n;
277: end loop;
278:

Line 281: select metadata_attribute t, count(*) n from dba_scheduler_program_args where

277: end loop;
278:
279: -- Split across count of metadata arguments, varchar based args, anydata based arguments
280: for it in (
281: select metadata_attribute t, count(*) n from dba_scheduler_program_args where
282: metadata_attribute is not null group by metadata_attribute order by 1)
283: loop
284: sum1 := sum1 || ',PM' ||
285: substr(replace(replace(it.t,'JOB_','J'),'WINDOW_','W'),1,3)