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

Line 570: h_dim_level_list dbms_sql.varchar2_table;

566: h_code1 NUMBER;
567: h_code2 NUMBER;
568:
569: -- AW_INTEGRATION: new varaibles
570: h_dim_level_list dbms_sql.varchar2_table;
571:
572: BEGIN
573: h_num_deleted_codes := 0;
574:

Line 3380: h_dim_level_list dbms_sql.varchar2_table;

3376: PROCEDURE Load_Dim_Into_AW_AT (
3377: x_dim_table IN VARCHAR2
3378: ) IS
3379: PRAGMA AUTONOMOUS_TRANSACTION;
3380: h_dim_level_list dbms_sql.varchar2_table;
3381: BEGIN
3382: h_dim_level_list.delete;
3383: h_dim_level_list(1) := x_dim_table;
3384: bsc_aw_load.load_dim(

Line 3452: h_dim_level_list dbms_sql.varchar2_table;

3448:
3449: h_safe_user_code VARCHAR2(1000);
3450:
3451: --AW_INTEGRATION: new variables
3452: h_dim_level_list dbms_sql.varchar2_table;
3453:
3454: h_userenv_lang VARCHAR2(10);
3455:
3456: BEGIN

Line 3813: h_dim_level_list dbms_sql.varchar2_table;

3809: | PROCEDURE Load_Type_Into_AW_AT
3810: +============================================================================*/
3811: PROCEDURE Load_Type_Into_AW_AT IS
3812: PRAGMA AUTONOMOUS_TRANSACTION;
3813: h_dim_level_list dbms_sql.varchar2_table;
3814: BEGIN
3815: h_dim_level_list.delete;
3816: h_dim_level_list(1) := 'TYPE';
3817: bsc_aw_load.load_dim(

Line 3942: l_dim_level_list dbms_sql.varchar2_table;

3938: l_dim_obj_type VARCHAR2(80);
3939:
3940: -- AW_INTEGRATION: new variables
3941: l_level_table_name VARCHAR2(30);
3942: l_dim_level_list dbms_sql.varchar2_table;
3943: l_dim_for_aw_kpi BOOLEAN;
3944:
3945: -- RECURSIVE_DIMS: new variables
3946: l_dim_for_mv_kpi BOOLEAN;

Line 4360: norm_child dbms_sql.varchar2_table;

4356:
4357: l_level_view_name VARCHAR2(30);
4358: l_level_pk_col VARCHAR2(30);
4359:
4360: norm_child dbms_sql.varchar2_table;
4361: norm_parent dbms_sql.varchar2_table;
4362: levels dbms_sql.number_table;
4363: parents dbms_sql.varchar2_table;
4364: --

Line 4361: norm_parent dbms_sql.varchar2_table;

4357: l_level_view_name VARCHAR2(30);
4358: l_level_pk_col VARCHAR2(30);
4359:
4360: norm_child dbms_sql.varchar2_table;
4361: norm_parent dbms_sql.varchar2_table;
4362: levels dbms_sql.number_table;
4363: parents dbms_sql.varchar2_table;
4364: --
4365: denorm_child dbms_sql.varchar2_table;

Line 4362: levels dbms_sql.number_table;

4358: l_level_pk_col VARCHAR2(30);
4359:
4360: norm_child dbms_sql.varchar2_table;
4361: norm_parent dbms_sql.varchar2_table;
4362: levels dbms_sql.number_table;
4363: parents dbms_sql.varchar2_table;
4364: --
4365: denorm_child dbms_sql.varchar2_table;
4366: denorm_parent dbms_sql.varchar2_table;

Line 4363: parents dbms_sql.varchar2_table;

4359:
4360: norm_child dbms_sql.varchar2_table;
4361: norm_parent dbms_sql.varchar2_table;
4362: levels dbms_sql.number_table;
4363: parents dbms_sql.varchar2_table;
4364: --
4365: denorm_child dbms_sql.varchar2_table;
4366: denorm_parent dbms_sql.varchar2_table;
4367: dp_level dbms_sql.number_table;

Line 4365: denorm_child dbms_sql.varchar2_table;

4361: norm_parent dbms_sql.varchar2_table;
4362: levels dbms_sql.number_table;
4363: parents dbms_sql.varchar2_table;
4364: --
4365: denorm_child dbms_sql.varchar2_table;
4366: denorm_parent dbms_sql.varchar2_table;
4367: dp_level dbms_sql.number_table;
4368: dc_level dbms_sql.number_table;
4369: --

Line 4366: denorm_parent dbms_sql.varchar2_table;

4362: levels dbms_sql.number_table;
4363: parents dbms_sql.varchar2_table;
4364: --
4365: denorm_child dbms_sql.varchar2_table;
4366: denorm_parent dbms_sql.varchar2_table;
4367: dp_level dbms_sql.number_table;
4368: dc_level dbms_sql.number_table;
4369: --
4370: prev_p dbms_sql.varchar2_table;

Line 4367: dp_level dbms_sql.number_table;

4363: parents dbms_sql.varchar2_table;
4364: --
4365: denorm_child dbms_sql.varchar2_table;
4366: denorm_parent dbms_sql.varchar2_table;
4367: dp_level dbms_sql.number_table;
4368: dc_level dbms_sql.number_table;
4369: --
4370: prev_p dbms_sql.varchar2_table;
4371: prev_p_level dbms_sql.number_table;

Line 4368: dc_level dbms_sql.number_table;

4364: --
4365: denorm_child dbms_sql.varchar2_table;
4366: denorm_parent dbms_sql.varchar2_table;
4367: dp_level dbms_sql.number_table;
4368: dc_level dbms_sql.number_table;
4369: --
4370: prev_p dbms_sql.varchar2_table;
4371: prev_p_level dbms_sql.number_table;
4372: last_p varchar2(400);

Line 4370: prev_p dbms_sql.varchar2_table;

4366: denorm_parent dbms_sql.varchar2_table;
4367: dp_level dbms_sql.number_table;
4368: dc_level dbms_sql.number_table;
4369: --
4370: prev_p dbms_sql.varchar2_table;
4371: prev_p_level dbms_sql.number_table;
4372: last_p varchar2(400);
4373: last_level number;
4374: child_level number;

Line 4371: prev_p_level dbms_sql.number_table;

4367: dp_level dbms_sql.number_table;
4368: dc_level dbms_sql.number_table;
4369: --
4370: prev_p dbms_sql.varchar2_table;
4371: prev_p_level dbms_sql.number_table;
4372: last_p varchar2(400);
4373: last_level number;
4374: child_level number;
4375: