APPS.EDW_OWB_COLLECTION_UTIL dependencies on DBMS_JOB

Line 7893: DBMS_JOB.REMOVE(p_job_id);

7889: End;
7890:
7891: function remove_job(p_job_id number) return boolean is
7892: Begin
7893: DBMS_JOB.REMOVE(p_job_id);
7894: commit;
7895: return true;
7896: Exception when others then
7897: g_status_message:=sqlerrm;

Line 8695: 'dbms_job_id number '||

8691: 'src_object_dlog varchar2(80),'||
8692: 'src_snplog_has_pk varchar2(2),'||
8693: 'err_rec_flag varchar2(2),'||
8694: 'err_rec_flag_d varchar2(2),'||
8695: 'dbms_job_id number '||
8696: ') tablespace '||p_op_table_space;
8697: if g_debug then
8698: write_to_log_file_n(g_stmt);
8699: end if;

Line 9250: g_stmt:='update '||p_input_table||' set dbms_job_id=:1';

9246: p_input_table varchar2,
9247: p_job_id number
9248: )return boolean is
9249: Begin
9250: g_stmt:='update '||p_input_table||' set dbms_job_id=:1';
9251: if g_debug then
9252: write_to_log_file_n(g_stmt||' '||p_job_id);
9253: end if;
9254: execute immediate g_stmt using p_job_id;

Line 10888: --for dbms jobs g_session_id=0

10884: Begin
10885: if g_session_id is null then
10886: g_session_id:=USERENV('SESSIONID');
10887: end if;
10888: --for dbms jobs g_session_id=0
10889: if g_session_id>0 then
10890: l_stmt:='select ses.sid,sy.name,round(ss.value/1048576,2) from v$sesstat ss,v$sysstat sy,v$session ses '||
10891: 'where sy.statistic#=ss.statistic# and ss.sid = ses.sid and ses.audsid=:1 and '||
10892: 'sy.name in (''session pga memory'',''session pga memory max'',''session uga memory'',''session uga memory max'')';