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

Line 6: g_commands dbms_sql.varchar2_table;

2: /*$Header: BSCAWCAS.pls 120.8 2006/01/30 15:54 vsurendr noship $*/
3: --program runtime parameters
4: g_debug boolean;
5: g_stmt varchar2(10000);
6: g_commands dbms_sql.varchar2_table;
7: g_init boolean;
8: ---types-----------------------------------------------------------
9: type periodicity_r is record(
10: db_column_name varchar2(40),

Line 94: procedure create_calendar(p_calendar number,p_options varchar2,p_affected_kpi out nocopy dbms_sql.varchar2_table);

90: );
91: type calendar_tb is table of calendar_r index by pls_integer;
92: ---variables--------------------------------------------------------
93: --procedures-------------------------------------------------------
94: procedure create_calendar(p_calendar number,p_options varchar2,p_affected_kpi out nocopy dbms_sql.varchar2_table);
95: procedure create_calendar_objects(
96: p_calendar in out nocopy calendar_r);
97: procedure create_calendar_program(
98: p_calendar in out nocopy calendar_r

Line 126: p_affected_kpi out nocopy dbms_sql.varchar2_table);

122: ) return periodicity_r;
123: procedure check_calendar_create(
124: p_calendar calendar_r,
125: p_recreate out nocopy varchar2,
126: p_affected_kpi out nocopy dbms_sql.varchar2_table);
127: procedure drop_calendar_objects(p_calendar_name varchar2,p_object_type varchar2,p_affected_kpi out nocopy dbms_sql.varchar2_table);
128: function get_calendar_name(p_calendar number) return varchar2 ;
129: procedure purge_calendar(p_calendar number,p_options varchar2) ;
130: procedure create_calendar(p_calendar number,p_affected_kpi out nocopy dbms_sql.varchar2_table);

Line 127: procedure drop_calendar_objects(p_calendar_name varchar2,p_object_type varchar2,p_affected_kpi out nocopy dbms_sql.varchar2_table);

123: procedure check_calendar_create(
124: p_calendar calendar_r,
125: p_recreate out nocopy varchar2,
126: p_affected_kpi out nocopy dbms_sql.varchar2_table);
127: procedure drop_calendar_objects(p_calendar_name varchar2,p_object_type varchar2,p_affected_kpi out nocopy dbms_sql.varchar2_table);
128: function get_calendar_name(p_calendar number) return varchar2 ;
129: procedure purge_calendar(p_calendar number,p_options varchar2) ;
130: procedure create_calendar(p_calendar number,p_affected_kpi out nocopy dbms_sql.varchar2_table);
131: function check_calendar_loaded(p_calendar number) return varchar2;

Line 130: procedure create_calendar(p_calendar number,p_affected_kpi out nocopy dbms_sql.varchar2_table);

126: p_affected_kpi out nocopy dbms_sql.varchar2_table);
127: procedure drop_calendar_objects(p_calendar_name varchar2,p_object_type varchar2,p_affected_kpi out nocopy dbms_sql.varchar2_table);
128: function get_calendar_name(p_calendar number) return varchar2 ;
129: procedure purge_calendar(p_calendar number,p_options varchar2) ;
130: procedure create_calendar(p_calendar number,p_affected_kpi out nocopy dbms_sql.varchar2_table);
131: function check_calendar_loaded(p_calendar number) return varchar2;
132: procedure load_calendar(p_calendar number);
133: procedure purge_calendar(p_calendar number);
134: procedure get_bsc_calendar_data(

Line 139: p_periodicity_dim in out nocopy dbms_sql.varchar2_table,

135: p_calendar in out nocopy calendar_r);
136: procedure set_aw_object_names(p_calendar in out nocopy calendar_r);
137: procedure get_missing_periodicity(
138: p_calendar_dim varchar2,
139: p_periodicity_dim in out nocopy dbms_sql.varchar2_table,
140: p_lowest_level out nocopy dbms_sql.varchar2_table
141: );
142: function is_child_present(
143: p_parent varchar2,

Line 140: p_lowest_level out nocopy dbms_sql.varchar2_table

136: procedure set_aw_object_names(p_calendar in out nocopy calendar_r);
137: procedure get_missing_periodicity(
138: p_calendar_dim varchar2,
139: p_periodicity_dim in out nocopy dbms_sql.varchar2_table,
140: p_lowest_level out nocopy dbms_sql.varchar2_table
141: );
142: function is_child_present(
143: p_parent varchar2,
144: p_periodicity_dim dbms_sql.varchar2_table,

Line 144: p_periodicity_dim dbms_sql.varchar2_table,

140: p_lowest_level out nocopy dbms_sql.varchar2_table
141: );
142: function is_child_present(
143: p_parent varchar2,
144: p_periodicity_dim dbms_sql.varchar2_table,
145: p_parent_child parent_child_tb) return boolean;
146: procedure get_missing_level_down(
147: p_parent varchar2,
148: p_periodicity_dim dbms_sql.varchar2_table,

Line 148: p_periodicity_dim dbms_sql.varchar2_table,

144: p_periodicity_dim dbms_sql.varchar2_table,
145: p_parent_child parent_child_tb) return boolean;
146: procedure get_missing_level_down(
147: p_parent varchar2,
148: p_periodicity_dim dbms_sql.varchar2_table,
149: p_parent_child parent_child_tb,
150: p_missing_levels_in dbms_sql.varchar2_table,
151: p_missing_levels_out out nocopy dbms_sql.varchar2_table,
152: p_found in out nocopy boolean --indicates if child is found and its time to stop

Line 150: p_missing_levels_in dbms_sql.varchar2_table,

146: procedure get_missing_level_down(
147: p_parent varchar2,
148: p_periodicity_dim dbms_sql.varchar2_table,
149: p_parent_child parent_child_tb,
150: p_missing_levels_in dbms_sql.varchar2_table,
151: p_missing_levels_out out nocopy dbms_sql.varchar2_table,
152: p_found in out nocopy boolean --indicates if child is found and its time to stop
153: );
154: procedure get_calendar_parent_child(p_calendar_dim varchar2,p_parent_child out nocopy parent_child_tb);

Line 151: p_missing_levels_out out nocopy dbms_sql.varchar2_table,

147: p_parent varchar2,
148: p_periodicity_dim dbms_sql.varchar2_table,
149: p_parent_child parent_child_tb,
150: p_missing_levels_in dbms_sql.varchar2_table,
151: p_missing_levels_out out nocopy dbms_sql.varchar2_table,
152: p_found in out nocopy boolean --indicates if child is found and its time to stop
153: );
154: procedure get_calendar_parent_child(p_calendar_dim varchar2,p_parent_child out nocopy parent_child_tb);
155: function is_parent_present(

Line 157: p_periodicity_dim dbms_sql.varchar2_table,

153: );
154: procedure get_calendar_parent_child(p_calendar_dim varchar2,p_parent_child out nocopy parent_child_tb);
155: function is_parent_present(
156: p_child varchar2,
157: p_periodicity_dim dbms_sql.varchar2_table,
158: p_parent_child parent_child_tb) return boolean ;
159: procedure get_missing_level_up(
160: p_child varchar2,
161: p_periodicity_dim dbms_sql.varchar2_table,

Line 161: p_periodicity_dim dbms_sql.varchar2_table,

157: p_periodicity_dim dbms_sql.varchar2_table,
158: p_parent_child parent_child_tb) return boolean ;
159: procedure get_missing_level_up(
160: p_child varchar2,
161: p_periodicity_dim dbms_sql.varchar2_table,
162: p_parent_child parent_child_tb,
163: p_missing_levels_in dbms_sql.varchar2_table,
164: p_missing_levels_out out nocopy dbms_sql.varchar2_table,
165: p_found in out nocopy boolean --indicates if child is found and its time to stop

Line 163: p_missing_levels_in dbms_sql.varchar2_table,

159: procedure get_missing_level_up(
160: p_child varchar2,
161: p_periodicity_dim dbms_sql.varchar2_table,
162: p_parent_child parent_child_tb,
163: p_missing_levels_in dbms_sql.varchar2_table,
164: p_missing_levels_out out nocopy dbms_sql.varchar2_table,
165: p_found in out nocopy boolean --indicates if child is found and its time to stop
166: ) ;
167: procedure lock_calendar_objects(p_calendar number);

Line 164: p_missing_levels_out out nocopy dbms_sql.varchar2_table,

160: p_child varchar2,
161: p_periodicity_dim dbms_sql.varchar2_table,
162: p_parent_child parent_child_tb,
163: p_missing_levels_in dbms_sql.varchar2_table,
164: p_missing_levels_out out nocopy dbms_sql.varchar2_table,
165: p_found in out nocopy boolean --indicates if child is found and its time to stop
166: ) ;
167: procedure lock_calendar_objects(p_calendar number);
168: procedure get_calendar_objects_to_lock(p_calendar number,p_lock_objects out nocopy dbms_sql.varchar2_table);

Line 168: procedure get_calendar_objects_to_lock(p_calendar number,p_lock_objects out nocopy dbms_sql.varchar2_table);

164: p_missing_levels_out out nocopy dbms_sql.varchar2_table,
165: p_found in out nocopy boolean --indicates if child is found and its time to stop
166: ) ;
167: procedure lock_calendar_objects(p_calendar number);
168: procedure get_calendar_objects_to_lock(p_calendar number,p_lock_objects out nocopy dbms_sql.varchar2_table);
169: procedure correct_calendar(p_calendar calendar_r,p_recreate out nocopy varchar2);
170: procedure create_calendar(p_calendar number,p_options varchar2);
171: function compare_pc_relations(p_pc_1 parent_child_tb,p_pc_2 parent_child_tb) return number;
172: procedure get_parent_periodicities(