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_UPDATE_BASE_V2 dependencies on DBMS_SQL

Line 37: h_list dbms_sql.varchar2_table;

33:
34: h_return_status VARCHAR2(50);
35: h_error_message VARCHAR2(4000);
36:
37: h_list dbms_sql.varchar2_table;
38: h_values dbms_sql.varchar2_table;
39:
40: h_proj_tbl_name VARCHAR2(30);
41: h_rowid_tbl_name VARCHAR2(30);

Line 38: h_values dbms_sql.varchar2_table;

34: h_return_status VARCHAR2(50);
35: h_error_message VARCHAR2(4000);
36:
37: h_list dbms_sql.varchar2_table;
38: h_values dbms_sql.varchar2_table;
39:
40: h_proj_tbl_name VARCHAR2(30);
41: h_rowid_tbl_name VARCHAR2(30);
42:

Line 45: h_partition_names dbms_sql.varchar2_table;

41: h_rowid_tbl_name VARCHAR2(30);
42:
43: h_partition_info BSC_DBGEN_STD_METADATA.clsTablePartition;
44: h_num_partitions NUMBER;
45: h_partition_names dbms_sql.varchar2_table;
46: h_batch_values dbms_sql.number_table;
47:
48: h_parallel_jobs VARCHAR2(1);
49: h_job_name VARCHAR2(100);

Line 46: h_batch_values dbms_sql.number_table;

42:
43: h_partition_info BSC_DBGEN_STD_METADATA.clsTablePartition;
44: h_num_partitions NUMBER;
45: h_partition_names dbms_sql.varchar2_table;
46: h_batch_values dbms_sql.number_table;
47:
48: h_parallel_jobs VARCHAR2(1);
49: h_job_name VARCHAR2(100);
50: h_process VARCHAR2(32000);

Line 627: h_sql dbms_sql.varchar2A;

623: x_error_message OUT NOCOPY VARCHAR2
624: ) IS
625:
626: --h_sql clob;
627: h_sql dbms_sql.varchar2A;
628: --h_bind_vars_values BSC_UPDATE_UTIL.t_array_of_varchar2;
629: h_bind_vars_values dbms_sql.varchar2_table;
630: h_num_bind_vars NUMBER;
631: h_i NUMBER;

Line 629: h_bind_vars_values dbms_sql.varchar2_table;

625:
626: --h_sql clob;
627: h_sql dbms_sql.varchar2A;
628: --h_bind_vars_values BSC_UPDATE_UTIL.t_array_of_varchar2;
629: h_bind_vars_values dbms_sql.varchar2_table;
630: h_num_bind_vars NUMBER;
631: h_i NUMBER;
632: h_j NUMBER;
633: h_many_methods BOOLEAN;

Line 1534: h_sql dbms_sql.varchar2A;

1530: x_return_status OUT NOCOPY VARCHAR2,
1531: x_error_message OUT NOCOPY VARCHAR2
1532: ) IS
1533: --h_sql CLOB;
1534: h_sql dbms_sql.varchar2A;
1535: h_i NUMBER;
1536: h_calendar_source VARCHAR2(20);
1537: h_yearly_flag NUMBER;
1538: h_periodicity_type NUMBER;

Line 1794: bsc_dbgen_utils.add_string(h_sql, ' u_data'||h_i||' dbms_sql.number_table;'||l_newline);

1790: END LOOP;
1791: bsc_dbgen_utils.add_string(h_sql, x_base_table||'.YEAR, '||x_base_table||'.TYPE,'||
1792: ' bsc_db_calendar_temp.upper_PERIOD, bsc_db_calendar_temp.periodicity_id, tt.row_id;');
1793: FOR h_i IN 1..x_num_data_columns LOOP
1794: bsc_dbgen_utils.add_string(h_sql, ' u_data'||h_i||' dbms_sql.number_table;'||l_newline);
1795: END LOOP;
1796: bsc_dbgen_utils.add_string(h_sql, ' u_rowid t_rowid_table;');
1797: FOR h_i IN 1..x_num_key_columns LOOP
1798: -- Fix bug#4880895 user varchar2 to support bis dimensions

Line 1799: bsc_dbgen_utils.add_string(h_sql, ' i_'||x_key_columns(h_i)||' dbms_sql.varchar2_table;'||l_newline);

1795: END LOOP;
1796: bsc_dbgen_utils.add_string(h_sql, ' u_rowid t_rowid_table;');
1797: FOR h_i IN 1..x_num_key_columns LOOP
1798: -- Fix bug#4880895 user varchar2 to support bis dimensions
1799: bsc_dbgen_utils.add_string(h_sql, ' i_'||x_key_columns(h_i)||' dbms_sql.varchar2_table;'||l_newline);
1800: END LOOP;
1801: bsc_dbgen_utils.add_string(h_sql,
1802: ' i_year dbms_sql.number_table;'||l_newline||
1803: ' i_type dbms_sql.number_table;'||l_newline||

Line 1802: ' i_year dbms_sql.number_table;'||l_newline||

1798: -- Fix bug#4880895 user varchar2 to support bis dimensions
1799: bsc_dbgen_utils.add_string(h_sql, ' i_'||x_key_columns(h_i)||' dbms_sql.varchar2_table;'||l_newline);
1800: END LOOP;
1801: bsc_dbgen_utils.add_string(h_sql,
1802: ' i_year dbms_sql.number_table;'||l_newline||
1803: ' i_type dbms_sql.number_table;'||l_newline||
1804: ' i_period dbms_sql.number_table;'||l_newline||
1805: ' i_periodicity_id dbms_sql.number_table;'||l_newline);
1806: FOR h_i IN 1..x_num_data_columns LOOP

Line 1803: ' i_type dbms_sql.number_table;'||l_newline||

1799: bsc_dbgen_utils.add_string(h_sql, ' i_'||x_key_columns(h_i)||' dbms_sql.varchar2_table;'||l_newline);
1800: END LOOP;
1801: bsc_dbgen_utils.add_string(h_sql,
1802: ' i_year dbms_sql.number_table;'||l_newline||
1803: ' i_type dbms_sql.number_table;'||l_newline||
1804: ' i_period dbms_sql.number_table;'||l_newline||
1805: ' i_periodicity_id dbms_sql.number_table;'||l_newline);
1806: FOR h_i IN 1..x_num_data_columns LOOP
1807: bsc_dbgen_utils.add_string(h_sql, ' i_data'||h_i||' dbms_sql.number_table;'||l_newline);

Line 1804: ' i_period dbms_sql.number_table;'||l_newline||

1800: END LOOP;
1801: bsc_dbgen_utils.add_string(h_sql,
1802: ' i_year dbms_sql.number_table;'||l_newline||
1803: ' i_type dbms_sql.number_table;'||l_newline||
1804: ' i_period dbms_sql.number_table;'||l_newline||
1805: ' i_periodicity_id dbms_sql.number_table;'||l_newline);
1806: FOR h_i IN 1..x_num_data_columns LOOP
1807: bsc_dbgen_utils.add_string(h_sql, ' i_data'||h_i||' dbms_sql.number_table;'||l_newline);
1808: END LOOP;

Line 1805: ' i_periodicity_id dbms_sql.number_table;'||l_newline);

1801: bsc_dbgen_utils.add_string(h_sql,
1802: ' i_year dbms_sql.number_table;'||l_newline||
1803: ' i_type dbms_sql.number_table;'||l_newline||
1804: ' i_period dbms_sql.number_table;'||l_newline||
1805: ' i_periodicity_id dbms_sql.number_table;'||l_newline);
1806: FOR h_i IN 1..x_num_data_columns LOOP
1807: bsc_dbgen_utils.add_string(h_sql, ' i_data'||h_i||' dbms_sql.number_table;'||l_newline);
1808: END LOOP;
1809: bsc_dbgen_utils.add_string(h_sql,

Line 1807: bsc_dbgen_utils.add_string(h_sql, ' i_data'||h_i||' dbms_sql.number_table;'||l_newline);

1803: ' i_type dbms_sql.number_table;'||l_newline||
1804: ' i_period dbms_sql.number_table;'||l_newline||
1805: ' i_periodicity_id dbms_sql.number_table;'||l_newline);
1806: FOR h_i IN 1..x_num_data_columns LOOP
1807: bsc_dbgen_utils.add_string(h_sql, ' i_data'||h_i||' dbms_sql.number_table;'||l_newline);
1808: END LOOP;
1809: bsc_dbgen_utils.add_string(h_sql,
1810: ' i_batch dbms_sql.number_table;'||l_newline||
1811: ' u_count integer := 0;'||l_newline||

Line 1810: ' i_batch dbms_sql.number_table;'||l_newline||

1806: FOR h_i IN 1..x_num_data_columns LOOP
1807: bsc_dbgen_utils.add_string(h_sql, ' i_data'||h_i||' dbms_sql.number_table;'||l_newline);
1808: END LOOP;
1809: bsc_dbgen_utils.add_string(h_sql,
1810: ' i_batch dbms_sql.number_table;'||l_newline||
1811: ' u_count integer := 0;'||l_newline||
1812: ' i_count integer := 0;'||l_newline||
1813: ' begin'||l_newline);
1814: -- Balance correction

Line 1849: bsc_dbgen_utils.add_string(h_sql, ' l_cb_data'||h_i||' dbms_sql.number_table;'||l_newline);

1845: bsc_dbgen_utils.add_string(h_sql, 'b_lower.'||x_key_columns(h_i)||'(+) = b_upper.'||x_key_columns(h_i)||' and '||l_newline);
1846: END LOOP;
1847: bsc_dbgen_utils.add_string(h_sql, ' b_lower.type(+) = b_upper.type;'||l_newline);
1848: FOR h_i IN 1..h_num_bal_columns LOOP
1849: bsc_dbgen_utils.add_string(h_sql, ' l_cb_data'||h_i||' dbms_sql.number_table;'||l_newline);
1850: END LOOP;
1851: bsc_dbgen_utils.add_string(h_sql, l_newline||
1852: ' l_cb_rowid t_rowid_table;'||l_newline||
1853: ' begin'||l_newline||

Line 2121: h_sql dbms_sql.varchar2A;

2117: x_return_status OUT NOCOPY VARCHAR2,
2118: x_error_message OUT NOCOPY VARCHAR2
2119: ) IS
2120: --h_sql CLOB;
2121: h_sql dbms_sql.varchar2A;
2122: h_i NUMBER;
2123: h_calendar_source VARCHAR2(20);
2124: h_yearly_flag NUMBER;
2125: h_periodicity_type NUMBER;

Line 2263: bsc_dbgen_utils.add_string(h_sql, ' u_data'||h_i||'_table dbms_sql.number_table;');

2259: x_input_table||'.TYPE = '||x_base_table||'.TYPE(+) and '||
2260: x_input_table||'.PERIOD = '||x_base_table||'.PERIOD(+);'||
2261: ' v1 bsc_b_t;');
2262: FOR h_i IN 1..x_num_data_columns LOOP
2263: bsc_dbgen_utils.add_string(h_sql, ' u_data'||h_i||'_table dbms_sql.number_table;');
2264: END LOOP;
2265: bsc_dbgen_utils.add_string(h_sql, ' u_rowid_table t_rowid_table;');
2266: FOR h_i IN 1..x_num_key_columns LOOP
2267: -- Fix bug#4880895 use varchar2 to support bis dimensions

Line 2268: bsc_dbgen_utils.add_string(h_sql, ' i_'||x_key_columns(h_i)||' dbms_sql.varchar2_table;');

2264: END LOOP;
2265: bsc_dbgen_utils.add_string(h_sql, ' u_rowid_table t_rowid_table;');
2266: FOR h_i IN 1..x_num_key_columns LOOP
2267: -- Fix bug#4880895 use varchar2 to support bis dimensions
2268: bsc_dbgen_utils.add_string(h_sql, ' i_'||x_key_columns(h_i)||' dbms_sql.varchar2_table;');
2269: END LOOP;
2270: bsc_dbgen_utils.add_string(h_sql,
2271: ' i_YEAR dbms_sql.number_table;'||
2272: ' i_TYPE dbms_sql.number_table;'||

Line 2271: ' i_YEAR dbms_sql.number_table;'||

2267: -- Fix bug#4880895 use varchar2 to support bis dimensions
2268: bsc_dbgen_utils.add_string(h_sql, ' i_'||x_key_columns(h_i)||' dbms_sql.varchar2_table;');
2269: END LOOP;
2270: bsc_dbgen_utils.add_string(h_sql,
2271: ' i_YEAR dbms_sql.number_table;'||
2272: ' i_TYPE dbms_sql.number_table;'||
2273: ' i_PERIOD dbms_sql.number_table;');
2274: FOR h_i IN 1..x_num_data_columns LOOP
2275: bsc_dbgen_utils.add_string(h_sql, ' i_data'||h_i||' dbms_sql.number_table;');

Line 2272: ' i_TYPE dbms_sql.number_table;'||

2268: bsc_dbgen_utils.add_string(h_sql, ' i_'||x_key_columns(h_i)||' dbms_sql.varchar2_table;');
2269: END LOOP;
2270: bsc_dbgen_utils.add_string(h_sql,
2271: ' i_YEAR dbms_sql.number_table;'||
2272: ' i_TYPE dbms_sql.number_table;'||
2273: ' i_PERIOD dbms_sql.number_table;');
2274: FOR h_i IN 1..x_num_data_columns LOOP
2275: bsc_dbgen_utils.add_string(h_sql, ' i_data'||h_i||' dbms_sql.number_table;');
2276: END LOOP;

Line 2273: ' i_PERIOD dbms_sql.number_table;');

2269: END LOOP;
2270: bsc_dbgen_utils.add_string(h_sql,
2271: ' i_YEAR dbms_sql.number_table;'||
2272: ' i_TYPE dbms_sql.number_table;'||
2273: ' i_PERIOD dbms_sql.number_table;');
2274: FOR h_i IN 1..x_num_data_columns LOOP
2275: bsc_dbgen_utils.add_string(h_sql, ' i_data'||h_i||' dbms_sql.number_table;');
2276: END LOOP;
2277: bsc_dbgen_utils.add_string(h_sql,

Line 2275: bsc_dbgen_utils.add_string(h_sql, ' i_data'||h_i||' dbms_sql.number_table;');

2271: ' i_YEAR dbms_sql.number_table;'||
2272: ' i_TYPE dbms_sql.number_table;'||
2273: ' i_PERIOD dbms_sql.number_table;');
2274: FOR h_i IN 1..x_num_data_columns LOOP
2275: bsc_dbgen_utils.add_string(h_sql, ' i_data'||h_i||' dbms_sql.number_table;');
2276: END LOOP;
2277: bsc_dbgen_utils.add_string(h_sql,
2278: ' i_BATCH dbms_sql.number_table;');
2279: IF x_aw_flag THEN

Line 2278: ' i_BATCH dbms_sql.number_table;');

2274: FOR h_i IN 1..x_num_data_columns LOOP
2275: bsc_dbgen_utils.add_string(h_sql, ' i_data'||h_i||' dbms_sql.number_table;');
2276: END LOOP;
2277: bsc_dbgen_utils.add_string(h_sql,
2278: ' i_BATCH dbms_sql.number_table;');
2279: IF x_aw_flag THEN
2280: bsc_dbgen_utils.add_string(h_sql,
2281: ' i_PROJECTION dbms_sql.varchar2_table;');
2282: END IF;

Line 2281: ' i_PROJECTION dbms_sql.varchar2_table;');

2277: bsc_dbgen_utils.add_string(h_sql,
2278: ' i_BATCH dbms_sql.number_table;');
2279: IF x_aw_flag THEN
2280: bsc_dbgen_utils.add_string(h_sql,
2281: ' i_PROJECTION dbms_sql.varchar2_table;');
2282: END IF;
2283: bsc_dbgen_utils.add_string(h_sql,
2284: ' u_count integer := 0;'||
2285: ' i_count integer := 0;'||

Line 2490: h_list dbms_sql.varchar2_table;

2486: +============================================================================*/
2487: FUNCTION Get_Base_Proj_Tbl_Name(
2488: x_base_table IN VARCHAR2
2489: ) RETURN VARCHAR2 IS
2490: h_list dbms_sql.varchar2_table;
2491: h_values dbms_sql.varchar2_table;
2492: BEGIN
2493: h_list.delete;
2494: h_list(1) := BSC_DBGEN_STD_METADATA.BSC_B_PRJ_TABLE;

Line 2491: h_values dbms_sql.varchar2_table;

2487: FUNCTION Get_Base_Proj_Tbl_Name(
2488: x_base_table IN VARCHAR2
2489: ) RETURN VARCHAR2 IS
2490: h_list dbms_sql.varchar2_table;
2491: h_values dbms_sql.varchar2_table;
2492: BEGIN
2493: h_list.delete;
2494: h_list(1) := BSC_DBGEN_STD_METADATA.BSC_B_PRJ_TABLE;
2495: h_values := BSC_DBGEN_METADATA_READER.Get_Table_Properties(x_base_table, h_list);