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.EDW_DERIVED_FACT_COLLECT dependencies on EDW_OWB_COLLECTION_UTIL

Line 15: g_fact_fks EDW_OWB_COLLECTION_UTIL.varcharTableType;

11: g_fact_id number;
12: g_temp_fact_name varchar2(400);
13: g_fact_iv varchar2(400);
14: g_stmt varchar2(32000);
15: g_fact_fks EDW_OWB_COLLECTION_UTIL.varcharTableType;
16: g_higher_level EDW_OWB_COLLECTION_UTIL.booleanTableType;
17: g_parent_dim EDW_OWB_COLLECTION_UTIL.varcharTableType;
18: g_parent_dim_id EDW_OWB_COLLECTION_UTIL.numberTableType;
19: g_parent_level EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 16: g_higher_level EDW_OWB_COLLECTION_UTIL.booleanTableType;

12: g_temp_fact_name varchar2(400);
13: g_fact_iv varchar2(400);
14: g_stmt varchar2(32000);
15: g_fact_fks EDW_OWB_COLLECTION_UTIL.varcharTableType;
16: g_higher_level EDW_OWB_COLLECTION_UTIL.booleanTableType;
17: g_parent_dim EDW_OWB_COLLECTION_UTIL.varcharTableType;
18: g_parent_dim_id EDW_OWB_COLLECTION_UTIL.numberTableType;
19: g_parent_level EDW_OWB_COLLECTION_UTIL.varcharTableType;
20: g_level_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 17: g_parent_dim EDW_OWB_COLLECTION_UTIL.varcharTableType;

13: g_fact_iv varchar2(400);
14: g_stmt varchar2(32000);
15: g_fact_fks EDW_OWB_COLLECTION_UTIL.varcharTableType;
16: g_higher_level EDW_OWB_COLLECTION_UTIL.booleanTableType;
17: g_parent_dim EDW_OWB_COLLECTION_UTIL.varcharTableType;
18: g_parent_dim_id EDW_OWB_COLLECTION_UTIL.numberTableType;
19: g_parent_level EDW_OWB_COLLECTION_UTIL.varcharTableType;
20: g_level_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType;
21: g_level_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 18: g_parent_dim_id EDW_OWB_COLLECTION_UTIL.numberTableType;

14: g_stmt varchar2(32000);
15: g_fact_fks EDW_OWB_COLLECTION_UTIL.varcharTableType;
16: g_higher_level EDW_OWB_COLLECTION_UTIL.booleanTableType;
17: g_parent_dim EDW_OWB_COLLECTION_UTIL.varcharTableType;
18: g_parent_dim_id EDW_OWB_COLLECTION_UTIL.numberTableType;
19: g_parent_level EDW_OWB_COLLECTION_UTIL.varcharTableType;
20: g_level_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType;
21: g_level_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
22: g_level_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 19: g_parent_level EDW_OWB_COLLECTION_UTIL.varcharTableType;

15: g_fact_fks EDW_OWB_COLLECTION_UTIL.varcharTableType;
16: g_higher_level EDW_OWB_COLLECTION_UTIL.booleanTableType;
17: g_parent_dim EDW_OWB_COLLECTION_UTIL.varcharTableType;
18: g_parent_dim_id EDW_OWB_COLLECTION_UTIL.numberTableType;
19: g_parent_level EDW_OWB_COLLECTION_UTIL.varcharTableType;
20: g_level_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType;
21: g_level_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
22: g_level_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
23: g_dim_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 20: g_level_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType;

16: g_higher_level EDW_OWB_COLLECTION_UTIL.booleanTableType;
17: g_parent_dim EDW_OWB_COLLECTION_UTIL.varcharTableType;
18: g_parent_dim_id EDW_OWB_COLLECTION_UTIL.numberTableType;
19: g_parent_level EDW_OWB_COLLECTION_UTIL.varcharTableType;
20: g_level_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType;
21: g_level_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
22: g_level_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
23: g_dim_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
24: g_number_fact_fks number;

Line 21: g_level_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;

17: g_parent_dim EDW_OWB_COLLECTION_UTIL.varcharTableType;
18: g_parent_dim_id EDW_OWB_COLLECTION_UTIL.numberTableType;
19: g_parent_level EDW_OWB_COLLECTION_UTIL.varcharTableType;
20: g_level_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType;
21: g_level_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
22: g_level_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
23: g_dim_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
24: g_number_fact_fks number;
25: g_forall_size number;

Line 22: g_level_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType;

18: g_parent_dim_id EDW_OWB_COLLECTION_UTIL.numberTableType;
19: g_parent_level EDW_OWB_COLLECTION_UTIL.varcharTableType;
20: g_level_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType;
21: g_level_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
22: g_level_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
23: g_dim_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
24: g_number_fact_fks number;
25: g_forall_size number;
26: g_thread_type varchar2(40);

Line 23: g_dim_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType;

19: g_parent_level EDW_OWB_COLLECTION_UTIL.varcharTableType;
20: g_level_prefix EDW_OWB_COLLECTION_UTIL.varcharTableType;
21: g_level_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
22: g_level_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
23: g_dim_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
24: g_number_fact_fks number;
25: g_forall_size number;
26: g_thread_type varchar2(40);
27: g_mapping_ids numberTableType;

Line 68: p_skip_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,

64: p_dlog varchar2,
65: p_forall_size number,
66: p_update_type varchar2,
67: p_fact_dlog varchar2,
68: p_skip_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,
69: p_number_skip_cols number,
70: p_load_fk number,
71: p_fresh_restart boolean,
72: p_op_table_space varchar2,

Line 73: p_bu_tables EDW_OWB_COLLECTION_UTIL.varcharTableType,--before update tables.prop dim change to derv

69: p_number_skip_cols number,
70: p_load_fk number,
71: p_fresh_restart boolean,
72: p_op_table_space varchar2,
73: p_bu_tables EDW_OWB_COLLECTION_UTIL.varcharTableType,--before update tables.prop dim change to derv
74: p_bu_dimensions EDW_OWB_COLLECTION_UTIL.varcharTableType,
75: p_number_bu_tables number,
76: p_bu_src_fact varchar2,--what table to look at as the src fact. if null, scan the actual src fact
77: p_load_mode varchar2,

Line 74: p_bu_dimensions EDW_OWB_COLLECTION_UTIL.varcharTableType,

70: p_load_fk number,
71: p_fresh_restart boolean,
72: p_op_table_space varchar2,
73: p_bu_tables EDW_OWB_COLLECTION_UTIL.varcharTableType,--before update tables.prop dim change to derv
74: p_bu_dimensions EDW_OWB_COLLECTION_UTIL.varcharTableType,
75: p_number_bu_tables number,
76: p_bu_src_fact varchar2,--what table to look at as the src fact. if null, scan the actual src fact
77: p_load_mode varchar2,
78: p_rollback varchar2,

Line 92: p_derived_facts EDW_OWB_COLLECTION_UTIL.varcharTableType,

88: ) return boolean;
89: FUNCTION COLLECT_FACT_INC(
90: p_src_fact_name varchar2,
91: p_src_fact_id number,
92: p_derived_facts EDW_OWB_COLLECTION_UTIL.varcharTableType,
93: p_derived_fact_ids EDW_OWB_COLLECTION_UTIL.numberTableType,
94: p_map_ids EDW_OWB_COLLECTION_UTIL.numberTableType,
95: p_number_derived_facts number,
96: p_conc_id in number,

Line 93: p_derived_fact_ids EDW_OWB_COLLECTION_UTIL.numberTableType,

89: FUNCTION COLLECT_FACT_INC(
90: p_src_fact_name varchar2,
91: p_src_fact_id number,
92: p_derived_facts EDW_OWB_COLLECTION_UTIL.varcharTableType,
93: p_derived_fact_ids EDW_OWB_COLLECTION_UTIL.numberTableType,
94: p_map_ids EDW_OWB_COLLECTION_UTIL.numberTableType,
95: p_number_derived_facts number,
96: p_conc_id in number,
97: p_conc_program_name in varchar2,

Line 94: p_map_ids EDW_OWB_COLLECTION_UTIL.numberTableType,

90: p_src_fact_name varchar2,
91: p_src_fact_id number,
92: p_derived_facts EDW_OWB_COLLECTION_UTIL.varcharTableType,
93: p_derived_fact_ids EDW_OWB_COLLECTION_UTIL.numberTableType,
94: p_map_ids EDW_OWB_COLLECTION_UTIL.numberTableType,
95: p_number_derived_facts number,
96: p_conc_id in number,
97: p_conc_program_name in varchar2,
98: p_debug boolean,

Line 103: p_load_pk out nocopy EDW_OWB_COLLECTION_UTIL.numberTableType,

99: p_collection_size number,
100: p_parallel number,
101: p_bis_owner varchar2,
102: p_table_owner varchar2,--src fact owner
103: p_load_pk out nocopy EDW_OWB_COLLECTION_UTIL.numberTableType,
104: p_ins_rows_processed out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
105: p_status out nocopy EDW_OWB_COLLECTION_UTIL.varcharTableType,
106: p_message out nocopy EDW_OWB_COLLECTION_UTIL.varcharTableType,
107: p_number_derv_facts out nocopy number,

Line 104: p_ins_rows_processed out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,

100: p_parallel number,
101: p_bis_owner varchar2,
102: p_table_owner varchar2,--src fact owner
103: p_load_pk out nocopy EDW_OWB_COLLECTION_UTIL.numberTableType,
104: p_ins_rows_processed out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
105: p_status out nocopy EDW_OWB_COLLECTION_UTIL.varcharTableType,
106: p_message out nocopy EDW_OWB_COLLECTION_UTIL.varcharTableType,
107: p_number_derv_facts out nocopy number,
108: p_forall_size number,

Line 105: p_status out nocopy EDW_OWB_COLLECTION_UTIL.varcharTableType,

101: p_bis_owner varchar2,
102: p_table_owner varchar2,--src fact owner
103: p_load_pk out nocopy EDW_OWB_COLLECTION_UTIL.numberTableType,
104: p_ins_rows_processed out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
105: p_status out nocopy EDW_OWB_COLLECTION_UTIL.varcharTableType,
106: p_message out nocopy EDW_OWB_COLLECTION_UTIL.varcharTableType,
107: p_number_derv_facts out nocopy number,
108: p_forall_size number,
109: p_update_type varchar2,

Line 106: p_message out nocopy EDW_OWB_COLLECTION_UTIL.varcharTableType,

102: p_table_owner varchar2,--src fact owner
103: p_load_pk out nocopy EDW_OWB_COLLECTION_UTIL.numberTableType,
104: p_ins_rows_processed out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
105: p_status out nocopy EDW_OWB_COLLECTION_UTIL.varcharTableType,
106: p_message out nocopy EDW_OWB_COLLECTION_UTIL.varcharTableType,
107: p_number_derv_facts out nocopy number,
108: p_forall_size number,
109: p_update_type varchar2,
110: p_fact_dlog varchar2,

Line 113: p_bu_tables EDW_OWB_COLLECTION_UTIL.varcharTableType,--before update tables.prop dim change to derv

109: p_update_type varchar2,
110: p_fact_dlog varchar2,
111: p_fresh_restart boolean,
112: p_op_table_space varchar2,
113: p_bu_tables EDW_OWB_COLLECTION_UTIL.varcharTableType,--before update tables.prop dim change to derv
114: p_bu_dimensions EDW_OWB_COLLECTION_UTIL.varcharTableType,
115: p_number_bu_tables number,
116: p_bu_src_fact varchar2,--what table to look at as the src fact. if null, scan the actual src fact
117: p_load_mode varchar2,

Line 114: p_bu_dimensions EDW_OWB_COLLECTION_UTIL.varcharTableType,

110: p_fact_dlog varchar2,
111: p_fresh_restart boolean,
112: p_op_table_space varchar2,
113: p_bu_tables EDW_OWB_COLLECTION_UTIL.varcharTableType,--before update tables.prop dim change to derv
114: p_bu_dimensions EDW_OWB_COLLECTION_UTIL.varcharTableType,
115: p_number_bu_tables number,
116: p_bu_src_fact varchar2,--what table to look at as the src fact. if null, scan the actual src fact
117: p_load_mode varchar2,
118: p_rollback varchar2,

Line 142: p_skip_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,

138: p_table_owner varchar2,
139: p_ins_rows_processed out NOCOPY number,
140: p_forall_size number,
141: p_update_type varchar2,
142: p_skip_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,
143: p_number_skip_cols number,
144: p_load_fk number,
145: p_fresh_restart boolean,
146: p_op_table_space varchar2,

Line 168: p_job_id EDW_OWB_COLLECTION_UTIL.numberTableType,

164: procedure write_to_log_file_n(p_message varchar2);
165: function get_status_message return varchar2;
166: function truncate_derived_fact return boolean ;
167: function wait_on_jobs(
168: p_job_id EDW_OWB_COLLECTION_UTIL.numberTableType,
169: p_job_status in out nocopy EDW_OWB_COLLECTION_UTIL.varcharTableType,
170: p_number_jobs number,
171: p_sleep_time number,
172: p_mode varchar2

Line 169: p_job_status in out nocopy EDW_OWB_COLLECTION_UTIL.varcharTableType,

165: function get_status_message return varchar2;
166: function truncate_derived_fact return boolean ;
167: function wait_on_jobs(
168: p_job_id EDW_OWB_COLLECTION_UTIL.numberTableType,
169: p_job_status in out nocopy EDW_OWB_COLLECTION_UTIL.varcharTableType,
170: p_number_jobs number,
171: p_sleep_time number,
172: p_mode varchar2
173: ) return boolean ;

Line 207: p_ilog EDW_OWB_COLLECTION_UTIL.varcharTableType,

203: p_src_fact varchar2,
204: p_table_owner varchar2,
205: p_bis_owner varchar2,
206: p_fact_dlog varchar2,
207: p_ilog EDW_OWB_COLLECTION_UTIL.varcharTableType,
208: p_dlog EDW_OWB_COLLECTION_UTIL.varcharTableType,
209: p_number_derv_fact number
210: )return boolean ;
211: function drop_inp_status_table(

Line 208: p_dlog EDW_OWB_COLLECTION_UTIL.varcharTableType,

204: p_table_owner varchar2,
205: p_bis_owner varchar2,
206: p_fact_dlog varchar2,
207: p_ilog EDW_OWB_COLLECTION_UTIL.varcharTableType,
208: p_dlog EDW_OWB_COLLECTION_UTIL.varcharTableType,
209: p_number_derv_fact number
210: )return boolean ;
211: function drop_inp_status_table(
212: p_input_table varchar2,