APPS.DDR_FACT_WEBSERVICES_PUB dependencies on DBMS_SCHEDULER

Line 865: --triggere the DBMS_SCHEDULER to run the job which writes data to xml file

861: INSERT INTO ddr_ws_job(job_id, status, SRC_SYS_IDNT,SRC_SYS_DT, CRTD_BY_DSR, LAST_UPDT_BY_DSR, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)
862: VALUES (l_job_id, ddr_webservices_constants.g_ret_sts_initialize,'-1', sysdate, '-1', '-1', -1,sysdate, -1, sysdate,-1);
863:
864:
865: --triggere the DBMS_SCHEDULER to run the job which writes data to xml file
866: l_proc_str := 'BEGIN ddr_webservices_pub.ddr_fact_aggr_prc(';
867: l_proc_str := l_proc_str || p_api_version || ', ';
868: l_proc_str := l_proc_str || '''' || l_job_id || ''', ';
869: l_proc_str := l_proc_str || '''' || p_mfg_org_cd || ''', ';

Line 891: dbms_scheduler.create_job (job_name => 'DDR_AGGR_WS_JOB_' || l_job_id,

887: l_proc_str := l_proc_str || '''' || p_attribute4 || ''', ';
888: l_proc_str := l_proc_str || '''' || p_attribute5 || ''' ); END;';
889:
890:
891: dbms_scheduler.create_job (job_name => 'DDR_AGGR_WS_JOB_' || l_job_id,
892: job_type => 'PLSQL_BLOCK',
893: job_action => l_proc_str,
894: start_date => NULL,
895: repeat_interval => NULL,

Line 942: --triggere the DBMS_SCHEDULER to run the job which writes data to xml file

938:
939: INSERT INTO ddr_ws_job(job_id, status, SRC_SYS_IDNT,SRC_SYS_DT, CRTD_BY_DSR, LAST_UPDT_BY_DSR, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)
940: VALUES (l_job_id, ddr_webservices_constants.g_ret_sts_initialize,'-1', sysdate, '-1', '-1', -1,sysdate, -1, sysdate,-1);
941:
942: --triggere the DBMS_SCHEDULER to run the job which writes data to xml file
943: l_proc_str := 'BEGIN ddr_webservices_pub.ddr_fact_details_prc (';
944: l_proc_str := l_proc_str || p_api_version|| ', ';
945: l_proc_str := l_proc_str || '''' || l_job_id || ''', ';
946: l_proc_str := l_proc_str || '''' || p_mfg_org_cd || ''', ';

Line 964: dbms_scheduler.create_job (job_name => 'DDR_DETAIL_WS_JOB_' || l_job_id,

960: l_proc_str := l_proc_str || '''' || p_attribute4 || ''', ';
961: l_proc_str := l_proc_str || '''' || p_attribute5 || ''' ); END;';
962:
963:
964: dbms_scheduler.create_job (job_name => 'DDR_DETAIL_WS_JOB_' || l_job_id,
965: job_type => 'PLSQL_BLOCK',
966: job_action => l_proc_str,
967: start_date => NULL,
968: repeat_interval => NULL,