DBA Data[Home] [Help]

APPS.BSC_UPDATE dependencies on DBMS_SQL

Line 1114: h_kpi_list dbms_sql.varchar2_table;

1110: h_num_aw_indicators NUMBER;
1111: h_aw_table_name VARCHAR2(30);
1112: h_aw_flag BOOLEAN;
1113: h_i NUMBER;
1114: h_kpi_list dbms_sql.varchar2_table;
1115: h_aw_base_tables BSC_UPDATE_UTIL.t_array_of_varchar2;
1116: h_num_aw_base_tables NUMBER;
1117:
1118: --LOCKING: new variables

Line 2506: h_dim_level_list dbms_sql.varchar2_table;

2502: h_table_is_valid BOOLEAN;
2503:
2504: --AW_INTEGRATION: new variables
2505: h_dim_table_type NUMBER;
2506: h_dim_level_list dbms_sql.varchar2_table;
2507: h_dim_was_loaded BOOLEAN;
2508:
2509: h_input_tables_err_status BSC_UPDATE_UTIL.t_array_of_varchar2;
2510: h_num_input_tables_err_status NUMBER;

Line 2770: h_dim_level_list dbms_sql.varchar2_table;

2766: h_b BOOLEAN;
2767:
2768: h_dim_table VARCHAR2(30);
2769:
2770: h_dim_level_list dbms_sql.varchar2_table;
2771:
2772: BEGIN
2773: h_num_loaded_tables := 0;
2774:

Line 2916: h_kpi_list dbms_sql.varchar2_table;

2912: h_indicators_aw BSC_UPDATE_UTIL.t_array_of_number;
2913: h_num_indicators_aw NUMBER;
2914: h_aw_flag BOOLEAN;
2915: h_calc_aw_kpi BOOLEAN;
2916: h_kpi_list dbms_sql.varchar2_table;
2917:
2918: -- ENH_B_TABLES_PERF: new variables
2919: h_proj_tbl_name VARCHAR2(30);
2920: