DBA Data[Home] [Help]

APPS.BSC_MO_DB_PKG dependencies on BSC_MO_DB_PKG

Line 1: Package Body BSC_MO_DB_PKG AS

1: Package Body BSC_MO_DB_PKG AS
2: /* $Header: BSCMODBB.pls 120.22.12000000.2 2007/04/24 05:29:11 amitgupt ship $ */
3:
4:
5: g_conc_short_name VARCHAR2(100):='BSC_METADATA_OPTIMIZER_SPAWNED';

Line 1878: 'BSC_MO_DB_PKG.create_tables_spawned('||bucket_num||');',

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));
1882: bsc_mo_helper_pkg.writeTmp('Job '||l_job_id(bucket_num)||' launched '||

Line 1940: END BSC_MO_DB_PKG;

1936: raise;
1937:
1938: END;
1939:
1940: END BSC_MO_DB_PKG;