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_SQL

Line 19: g_ddl_bucket_id DBMS_SQL.NUMBER_TABLE;

15: g_bucket_size number := 100000;
16: g_sleep_time NUMBER;
17:
18: g_max_buckets NUMBER;
19: g_ddl_bucket_id DBMS_SQL.NUMBER_TABLE;
20: g_ddl_object DBMS_SQL.VARCHAR2_TABLE;
21: g_ddl_object_ddl DBMS_SQL.VARCHAR2_TABLE;
22: g_ddl_object_type DBMS_SQL.VARCHAR2_TABLE;
23:

Line 20: g_ddl_object DBMS_SQL.VARCHAR2_TABLE;

16: g_sleep_time NUMBER;
17:
18: g_max_buckets NUMBER;
19: g_ddl_bucket_id DBMS_SQL.NUMBER_TABLE;
20: g_ddl_object DBMS_SQL.VARCHAR2_TABLE;
21: g_ddl_object_ddl DBMS_SQL.VARCHAR2_TABLE;
22: g_ddl_object_type DBMS_SQL.VARCHAR2_TABLE;
23:
24:

Line 21: g_ddl_object_ddl DBMS_SQL.VARCHAR2_TABLE;

17:
18: g_max_buckets NUMBER;
19: g_ddl_bucket_id DBMS_SQL.NUMBER_TABLE;
20: g_ddl_object DBMS_SQL.VARCHAR2_TABLE;
21: g_ddl_object_ddl DBMS_SQL.VARCHAR2_TABLE;
22: g_ddl_object_type DBMS_SQL.VARCHAR2_TABLE;
23:
24:
25: TYPE rec_update_tables is record(

Line 22: g_ddl_object_type DBMS_SQL.VARCHAR2_TABLE;

18: g_max_buckets NUMBER;
19: g_ddl_bucket_id DBMS_SQL.NUMBER_TABLE;
20: g_ddl_object DBMS_SQL.VARCHAR2_TABLE;
21: g_ddl_object_ddl DBMS_SQL.VARCHAR2_TABLE;
22: g_ddl_object_type DBMS_SQL.VARCHAR2_TABLE;
23:
24:
25: TYPE rec_update_tables is record(
26: table_name varchar2(100),

Line 1094: l_origin_tables DBMS_SQL.VARCHAR2_TABLE;

1090: END;
1091:
1092:
1093: PROCEDURE add_columns_to_tables(p_Table BSC_METADATA_OPTIMIZER_PKG.clsTable)IS
1094: l_origin_tables DBMS_SQL.VARCHAR2_TABLE;
1095: l_stmt VARCHAR2(1000);
1096: l_table_type varchar2(10);
1097: l_prj_table varchar2(100);
1098: BEGIN

Line 1350: arrProjTables DBMS_SQL.VARCHAR2_TABLE;

1346: --****************************************************************************
1347: PROCEDURE CreateAllTables IS
1348: l_table_rec BSC_METADATA_OPTIMIZER_PKG.clsTable;
1349: l_index NUMBER;
1350: arrProjTables DBMS_SQL.VARCHAR2_TABLE;
1351: numProjTables NUMBER := 0;
1352: lTablesCount NUMBER := 0;
1353: l_counter NUMBER := 0;
1354:

Line 1355: l_varchar_table1 dbms_sql.varchar2_table;

1351: numProjTables NUMBER := 0;
1352: lTablesCount NUMBER := 0;
1353: l_counter NUMBER := 0;
1354:
1355: l_varchar_table1 dbms_sql.varchar2_table;
1356: l_varchar_table2 dbms_sql.varchar2_table;
1357: BEGIN
1358: lTablesCount := BSC_METADATA_OPTIMIZER_PKG.gTables.count;
1359: IF (lTablesCount = 0 ) THEN

Line 1356: l_varchar_table2 dbms_sql.varchar2_table;

1352: lTablesCount NUMBER := 0;
1353: l_counter NUMBER := 0;
1354:
1355: l_varchar_table1 dbms_sql.varchar2_table;
1356: l_varchar_table2 dbms_sql.varchar2_table;
1357: BEGIN
1358: lTablesCount := BSC_METADATA_OPTIMIZER_PKG.gTables.count;
1359: IF (lTablesCount = 0 ) THEN
1360: RETURN;

Line 1479: p_id out nocopy dbms_sql.number_table,

1475:
1476: function get_child_job_status(
1477: p_job_status_table varchar2,
1478: p_object_name varchar2,
1479: p_id out nocopy dbms_sql.number_table,
1480: p_job_id out nocopy dbms_sql.number_table,
1481: p_status out nocopy dbms_sql.varchar2_table,
1482: p_message out nocopy dbms_sql.varchar2_table,
1483: p_number_jobs out nocopy number

Line 1480: p_job_id out nocopy dbms_sql.number_table,

1476: function get_child_job_status(
1477: p_job_status_table varchar2,
1478: p_object_name varchar2,
1479: p_id out nocopy dbms_sql.number_table,
1480: p_job_id out nocopy dbms_sql.number_table,
1481: p_status out nocopy dbms_sql.varchar2_table,
1482: p_message out nocopy dbms_sql.varchar2_table,
1483: p_number_jobs out nocopy number
1484: )return boolean is

Line 1481: p_status out nocopy dbms_sql.varchar2_table,

1477: p_job_status_table varchar2,
1478: p_object_name varchar2,
1479: p_id out nocopy dbms_sql.number_table,
1480: p_job_id out nocopy dbms_sql.number_table,
1481: p_status out nocopy dbms_sql.varchar2_table,
1482: p_message out nocopy dbms_sql.varchar2_table,
1483: p_number_jobs out nocopy number
1484: )return boolean is
1485: TYPE CurTyp IS REF CURSOR;

Line 1482: p_message out nocopy dbms_sql.varchar2_table,

1478: p_object_name varchar2,
1479: p_id out nocopy dbms_sql.number_table,
1480: p_job_id out nocopy dbms_sql.number_table,
1481: p_status out nocopy dbms_sql.varchar2_table,
1482: p_message out nocopy dbms_sql.varchar2_table,
1483: p_number_jobs out nocopy number
1484: )return boolean is
1485: TYPE CurTyp IS REF CURSOR;
1486: cv CurTyp;

Line 1533: p_job_id dbms_sql.number_table,

1529:
1530:
1531: function check_all_child_jobs(
1532: p_job_status_table varchar2,
1533: p_job_id dbms_sql.number_table,
1534: p_number_jobs number,
1535: p_object_name varchar2
1536: ) return boolean is
1537: l_id dbms_sql.number_table;

Line 1537: l_id dbms_sql.number_table;

1533: p_job_id dbms_sql.number_table,
1534: p_number_jobs number,
1535: p_object_name varchar2
1536: ) return boolean is
1537: l_id dbms_sql.number_table;
1538: l_job_id dbms_sql.number_table;
1539: l_status dbms_sql.varchar2_table;
1540: l_message dbms_sql.varchar2_table;
1541: l_number_jobs number;

Line 1538: l_job_id dbms_sql.number_table;

1534: p_number_jobs number,
1535: p_object_name varchar2
1536: ) return boolean is
1537: l_id dbms_sql.number_table;
1538: l_job_id dbms_sql.number_table;
1539: l_status dbms_sql.varchar2_table;
1540: l_message dbms_sql.varchar2_table;
1541: l_number_jobs number;
1542: Begin

Line 1539: l_status dbms_sql.varchar2_table;

1535: p_object_name varchar2
1536: ) return boolean is
1537: l_id dbms_sql.number_table;
1538: l_job_id dbms_sql.number_table;
1539: l_status dbms_sql.varchar2_table;
1540: l_message dbms_sql.varchar2_table;
1541: l_number_jobs number;
1542: Begin
1543: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN

Line 1540: l_message dbms_sql.varchar2_table;

1536: ) return boolean is
1537: l_id dbms_sql.number_table;
1538: l_job_id dbms_sql.number_table;
1539: l_status dbms_sql.varchar2_table;
1540: l_message dbms_sql.varchar2_table;
1541: l_number_jobs number;
1542: Begin
1543: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
1544: bsc_mo_helper_pkg.writeTmp('Starting check_all_child_jobs');

Line 1684: p_job_id DBMS_SQL.NUMBER_TABLE,

1680: END;
1681:
1682:
1683: FUNCTION wait_on_jobs(
1684: p_job_id DBMS_SQL.NUMBER_TABLE,
1685: p_number_jobs number,
1686: p_sleep_time number,
1687: p_thread_type varchar2
1688: ) RETURN boolean is

Line 1691: l_job_status DBMS_SQL.VARCHAR2_TABLE;

1687: p_thread_type varchar2
1688: ) RETURN boolean is
1689: l_found boolean;
1690: l_status varchar2(2);
1691: l_job_status DBMS_SQL.VARCHAR2_TABLE;
1692: l_error VARCHAR2(1000);
1693:
1694: l_start date := sysdate;
1695: Begin

Line 1802: l_job_id DBMS_SQL.NUMBER_TABLE;

1798:
1799: PROCEDURE spawn_child_processes IS
1800:
1801: l_try_serial boolean := false;
1802: l_job_id DBMS_SQL.NUMBER_TABLE;
1803: L_BSC_SHORT_NAME varchar2(10);
1804: l_sleep_time NUMBER := 90 ; -- 1.5 minutes
1805: errBuf VARCHAR2(100);
1806: retCode VARCHAR2(100);