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.BSC_MO_DB_PKG dependencies on DBMS_JOB

Line 1818: DBMS_JOB.SUBMIT(id,'test_pack_2.run_pack;')

1814:
1815: /*
1816: we will go FOR active polling. this main session will sleep FOR g_sleep_time and THEN
1817: wake up and check the status of each of the jobs. IF they are done, we can THEN proceed.
1818: DBMS_JOB.SUBMIT(id,'test_pack_2.run_pack;')
1819: */
1820:
1821: g_sleep_time := 5;-- check every 5 seconds
1822:

Line 1876: bsc_mo_helper_pkg.writeTmp('Not a Concurrent program, trying DBMS JOBS');

1872: IF l_job_id(bucket_num)<=0 THEN
1873: l_try_serial:=TRUE;
1874: END IF;
1875: ELSIF l_try_serial = false THEN --not a concurrent program and job init.ora params ok
1876: bsc_mo_helper_pkg.writeTmp('Not a Concurrent program, trying DBMS JOBS');
1877: DBMS_JOB.SUBMIT(l_job_id(bucket_num),
1878: 'BSC_MO_DB_PKG.create_tables_spawned('||bucket_num||');',
1879: sysdate + (10/86400)); -- next second
1880: commit;--this commit is very imp

Line 1877: DBMS_JOB.SUBMIT(l_job_id(bucket_num),

1873: l_try_serial:=TRUE;
1874: END IF;
1875: ELSIF l_try_serial = false THEN --not a concurrent program and job init.ora params ok
1876: bsc_mo_helper_pkg.writeTmp('Not a Concurrent program, trying DBMS JOBS');
1877: DBMS_JOB.SUBMIT(l_job_id(bucket_num),
1878: 'BSC_MO_DB_PKG.create_tables_spawned('||bucket_num||');',
1879: sysdate + (10/86400)); -- next second
1880: commit;--this commit is very imp
1881: bsc_mo_helper_pkg.writeTmp(' submitted dbms_job : id is '||l_job_id(bucket_num));

Line 1881: bsc_mo_helper_pkg.writeTmp(' submitted dbms_job : id is '||l_job_id(bucket_num));

1877: DBMS_JOB.SUBMIT(l_job_id(bucket_num),
1878: 'BSC_MO_DB_PKG.create_tables_spawned('||bucket_num||');',
1879: sysdate + (10/86400)); -- next second
1880: commit;--this commit is very imp
1881: bsc_mo_helper_pkg.writeTmp(' submitted dbms_job : id is '||l_job_id(bucket_num));
1882: bsc_mo_helper_pkg.writeTmp('Job '||l_job_id(bucket_num)||' launched '||
1883: to_char(sysdate, 'mm/dd/yyyy hh24:mi:ss'));
1884: IF l_job_id(bucket_num)<=0 THEN
1885: l_try_serial:=TRUE;