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

Line 9: delete_values dbms_sql.varchar2_table

5: g_stmt varchar2(32000);
6: --
7: type dim_level_delete_r is record( --hold level delete values
8: delete_name varchar2(100),
9: delete_values dbms_sql.varchar2_table
10: );
11: type dim_level_delete_tv is table of dim_level_delete_r index by varchar2(100);
12: -----------------procedures----------------------
13: procedure load_dim(p_dim_level_list dbms_sql.varchar2_table);

Line 13: procedure load_dim(p_dim_level_list dbms_sql.varchar2_table);

9: delete_values dbms_sql.varchar2_table
10: );
11: type dim_level_delete_tv is table of dim_level_delete_r index by varchar2(100);
12: -----------------procedures----------------------
13: procedure load_dim(p_dim_level_list dbms_sql.varchar2_table);
14: procedure load_dim_levels(p_dim_level_list dbms_sql.varchar2_table);
15: procedure load_aw_dim(p_dim varchar2,p_run_id number,p_job_name varchar2,p_options varchar2);
16: function check_initial_load(p_dim varchar2) return boolean;
17: procedure purge_dim(p_dim_level_list dbms_sql.varchar2_table);

Line 14: procedure load_dim_levels(p_dim_level_list dbms_sql.varchar2_table);

10: );
11: type dim_level_delete_tv is table of dim_level_delete_r index by varchar2(100);
12: -----------------procedures----------------------
13: procedure load_dim(p_dim_level_list dbms_sql.varchar2_table);
14: procedure load_dim_levels(p_dim_level_list dbms_sql.varchar2_table);
15: procedure load_aw_dim(p_dim varchar2,p_run_id number,p_job_name varchar2,p_options varchar2);
16: function check_initial_load(p_dim varchar2) return boolean;
17: procedure purge_dim(p_dim_level_list dbms_sql.varchar2_table);
18: procedure purge_dim(p_dim varchar2);

Line 17: procedure purge_dim(p_dim_level_list dbms_sql.varchar2_table);

13: procedure load_dim(p_dim_level_list dbms_sql.varchar2_table);
14: procedure load_dim_levels(p_dim_level_list dbms_sql.varchar2_table);
15: procedure load_aw_dim(p_dim varchar2,p_run_id number,p_job_name varchar2,p_options varchar2);
16: function check_initial_load(p_dim varchar2) return boolean;
17: procedure purge_dim(p_dim_level_list dbms_sql.varchar2_table);
18: procedure purge_dim(p_dim varchar2);
19: procedure load_dim_delete(
20: p_dim varchar2,
21: p_dim_property varchar2,

Line 24: procedure dmp_dim_level_into_table(p_dim_level_list dbms_sql.varchar2_table);

20: p_dim varchar2,
21: p_dim_property varchar2,
22: p_dim_level_delete in out nocopy dim_level_delete_tv,
23: p_delete_flag out nocopy boolean);
24: procedure dmp_dim_level_into_table(p_dim_level_list dbms_sql.varchar2_table);
25: procedure dmp_dim_level_into_table(p_dim_level varchar2);
26: procedure set_kpi_limit_variables(p_dim varchar2);
27: procedure lock_dim_objects(p_dim varchar2,p_dim_delete boolean);
28: procedure get_dim_objects_to_lock(p_dim varchar2,p_lock_objects out nocopy dbms_sql.varchar2_table);

Line 28: procedure get_dim_objects_to_lock(p_dim varchar2,p_lock_objects out nocopy dbms_sql.varchar2_table);

24: procedure dmp_dim_level_into_table(p_dim_level_list dbms_sql.varchar2_table);
25: procedure dmp_dim_level_into_table(p_dim_level varchar2);
26: procedure set_kpi_limit_variables(p_dim varchar2);
27: procedure lock_dim_objects(p_dim varchar2,p_dim_delete boolean);
28: procedure get_dim_objects_to_lock(p_dim varchar2,p_lock_objects out nocopy dbms_sql.varchar2_table);
29: procedure load_aw_dim_jobs(p_dim_list dbms_sql.varchar2_table);
30: procedure delete_dim_level_value(p_dim_level varchar2,p_delete_values dbms_sql.varchar2_table);
31: procedure load_recursive_norm_hier(p_denorm_source varchar2,p_child_col varchar2,p_parent_col varchar2);
32: procedure load_dimensions(p_dim_list dbms_sql.varchar2_table);

Line 29: procedure load_aw_dim_jobs(p_dim_list dbms_sql.varchar2_table);

25: procedure dmp_dim_level_into_table(p_dim_level varchar2);
26: procedure set_kpi_limit_variables(p_dim varchar2);
27: procedure lock_dim_objects(p_dim varchar2,p_dim_delete boolean);
28: procedure get_dim_objects_to_lock(p_dim varchar2,p_lock_objects out nocopy dbms_sql.varchar2_table);
29: procedure load_aw_dim_jobs(p_dim_list dbms_sql.varchar2_table);
30: procedure delete_dim_level_value(p_dim_level varchar2,p_delete_values dbms_sql.varchar2_table);
31: procedure load_recursive_norm_hier(p_denorm_source varchar2,p_child_col varchar2,p_parent_col varchar2);
32: procedure load_dimensions(p_dim_list dbms_sql.varchar2_table);
33: procedure load_dim_if_needed(p_dim dbms_sql.varchar2_table);

Line 30: procedure delete_dim_level_value(p_dim_level varchar2,p_delete_values dbms_sql.varchar2_table);

26: procedure set_kpi_limit_variables(p_dim varchar2);
27: procedure lock_dim_objects(p_dim varchar2,p_dim_delete boolean);
28: procedure get_dim_objects_to_lock(p_dim varchar2,p_lock_objects out nocopy dbms_sql.varchar2_table);
29: procedure load_aw_dim_jobs(p_dim_list dbms_sql.varchar2_table);
30: procedure delete_dim_level_value(p_dim_level varchar2,p_delete_values dbms_sql.varchar2_table);
31: procedure load_recursive_norm_hier(p_denorm_source varchar2,p_child_col varchar2,p_parent_col varchar2);
32: procedure load_dimensions(p_dim_list dbms_sql.varchar2_table);
33: procedure load_dim_if_needed(p_dim dbms_sql.varchar2_table);
34: function check_dim_loaded(p_dim varchar2) return varchar2;

Line 32: procedure load_dimensions(p_dim_list dbms_sql.varchar2_table);

28: procedure get_dim_objects_to_lock(p_dim varchar2,p_lock_objects out nocopy dbms_sql.varchar2_table);
29: procedure load_aw_dim_jobs(p_dim_list dbms_sql.varchar2_table);
30: procedure delete_dim_level_value(p_dim_level varchar2,p_delete_values dbms_sql.varchar2_table);
31: procedure load_recursive_norm_hier(p_denorm_source varchar2,p_child_col varchar2,p_parent_col varchar2);
32: procedure load_dimensions(p_dim_list dbms_sql.varchar2_table);
33: procedure load_dim_if_needed(p_dim dbms_sql.varchar2_table);
34: function check_dim_loaded(p_dim varchar2) return varchar2;
35: procedure mark_dim_loaded(p_dim varchar2);
36: procedure load_delete_dim_level_value(

Line 33: procedure load_dim_if_needed(p_dim dbms_sql.varchar2_table);

29: procedure load_aw_dim_jobs(p_dim_list dbms_sql.varchar2_table);
30: procedure delete_dim_level_value(p_dim_level varchar2,p_delete_values dbms_sql.varchar2_table);
31: procedure load_recursive_norm_hier(p_denorm_source varchar2,p_child_col varchar2,p_parent_col varchar2);
32: procedure load_dimensions(p_dim_list dbms_sql.varchar2_table);
33: procedure load_dim_if_needed(p_dim dbms_sql.varchar2_table);
34: function check_dim_loaded(p_dim varchar2) return varchar2;
35: procedure mark_dim_loaded(p_dim varchar2);
36: procedure load_delete_dim_level_value(
37: p_dim_level varchar2,