eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSD_DEM_SOP dependencies on DBMS_JOB

Line 1696: dbms_job.submit(x_job_number, replace(x_job_proc_name, '$ORG_PARAM$', orgrec.organization_id));

1692: begin
1693: if (p_split_batch_by_org = 1) then
1694: for orgrec in c_get_plan_orgs
1695: loop
1696: dbms_job.submit(x_job_number, replace(x_job_proc_name, '$ORG_PARAM$', orgrec.organization_id));
1697: commit;
1698: log_debug(x_job_proc_name);
1699: log_debug('Info: msd_dem_sop.load_plan_data_wo_pds - Submitted job -> ' || x_job_number);
1700: end loop;

Line 1703: dbms_job.submit(x_job_number, replace(x_job_proc_name, '$ORG_PARAM$', ''));

1699: log_debug('Info: msd_dem_sop.load_plan_data_wo_pds - Submitted job -> ' || x_job_number);
1700: end loop;
1701: else
1702:
1703: dbms_job.submit(x_job_number, replace(x_job_proc_name, '$ORG_PARAM$', ''));
1704: commit;
1705: log_debug(x_job_proc_name);
1706: log_debug('Info: msd_dem_sop.load_plan_data_wo_pds - Submitted job -> ' || x_job_number);
1707: end if;

Line 1822: dbms_job.submit(x_job_number, replace(x_job_proc_name, '$ORG_PARAM$', orgrec.organization_id));

1818:
1819: for orgrec in c_get_plan_orgs
1820: loop
1821:
1822: dbms_job.submit(x_job_number, replace(x_job_proc_name, '$ORG_PARAM$', orgrec.organization_id));
1823: commit;
1824: log_debug(x_job_proc_name);
1825: log_debug('Info: msd_dem_sop.load_plan_data_wo_ods - Submitted job -> ' || x_job_number);
1826: end loop;

Line 1829: dbms_job.submit(x_job_number, replace(x_job_proc_name, '$ORG_PARAM$',''));

1825: log_debug('Info: msd_dem_sop.load_plan_data_wo_ods - Submitted job -> ' || x_job_number);
1826: end loop;
1827: else
1828:
1829: dbms_job.submit(x_job_number, replace(x_job_proc_name, '$ORG_PARAM$',''));
1830: commit;
1831: log_debug(x_job_proc_name);
1832: log_debug('Info: msd_dem_sop.load_plan_data_wo_ods - Submitted job -> ' || x_job_number);
1833: end if;

Line 2027: dbms_job.submit(x_job_number,x_job_proc_name);

2023: else
2024: x_job_proc_name := 'msd_dem_sop.load_plan_data_wo_ods(' || p_plan_id || ', ''' || x_start_date || ''', ''' || x_end_date || ''', ''' || x_aggregation_start_date || ''', ' || x_dm_time_level || ', ' ;
2025: x_job_proc_name :=x_job_proc_name || p_use_jobs || ', ' || p_split_batch_by_org || ', ' || p_job_check_interval || ', ' || p_jobs_timeout || ');';
2026: log_debug(x_job_proc_name);
2027: dbms_job.submit(x_job_number,x_job_proc_name);
2028: commit;
2029: end IF;
2030: commit;
2031: END IF;

Line 2043: dbms_job.submit(x_job_number,x_job_proc_name);

2039: else
2040: x_job_proc_name := 'msd_dem_sop.load_plan_data_wo_pds(' || p_plan_id || ', ''' || x_start_date || ''', ''' || x_end_date || ''', ''' || x_aggregation_start_date || ''', ' || x_dm_time_level || ', ' ;
2041: x_job_proc_name :=x_job_proc_name || p_use_jobs || ', ' || p_split_batch_by_org || ', ' || p_job_check_interval || ', ' || p_jobs_timeout || ');';
2042: log_debug(x_job_proc_name);
2043: dbms_job.submit(x_job_number,x_job_proc_name);
2044: commit;
2045: end IF;
2046: commit;
2047: --check for job completion

Line 2204: dbms_job.submit(x_job_number, replace(x_job_proc_name, '$ORG_PARAM$', ', ' || orgrec.organization_id));

2200: begin
2201: if (p_split_batch_by_org = 1) then
2202: for orgrec in c_get_plan_orgs
2203: loop
2204: dbms_job.submit(x_job_number, replace(x_job_proc_name, '$ORG_PARAM$', ', ' || orgrec.organization_id));
2205: commit;
2206: log_debug('Info: msd_dem_sop.load_plan_data_wo - Submitted job -> ' || x_job_number);
2207: end loop;
2208: else

Line 2209: dbms_job.submit(x_job_number, replace(x_job_proc_name, '$ORG_PARAM$', ''));

2205: commit;
2206: log_debug('Info: msd_dem_sop.load_plan_data_wo - Submitted job -> ' || x_job_number);
2207: end loop;
2208: else
2209: dbms_job.submit(x_job_number, replace(x_job_proc_name, '$ORG_PARAM$', ''));
2210: commit;
2211: log_debug('Info: msd_dem_sop.load_plan_data_wo - Submitted job -> ' || x_job_number);
2212: end if;
2213: exception when others then

Line 3721: dbms_job.remove (rec.job);

3717: END IF;
3718:
3719: FOR rec IN (SELECT job from user_jobs WHERE upper(what) like v_job_name || '%' and upper(broken) = 'N')
3720: LOOP
3721: dbms_job.remove (rec.job);
3722: END LOOP;
3723:
3724: /* Log End */
3725: EXECUTE IMMEDIATE 'BEGIN ' || v_schema_name || '.DBEX(''SOP Kill Jobs - Completed'', ''MSD_DEM_SOP.LOAD_PLAN_DATA''); END;';