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_WH_DANG_RECOVERY dependencies on EDW_OWB_COLLECTION_UTIL

Line 37: EDW_OWB_COLLECTION_UTIL.init_all('ABC',null,'bis.edw.loader');

33: --if g_instance is null, this call is from check data validity
34: --else its from a source instance
35: IF g_called_from = 'INSTANCE'
36: THEN
37: EDW_OWB_COLLECTION_UTIL.init_all('ABC',null,'bis.edw.loader');
38: END IF;
39:
40: IF p_dim_list IS NULL
41: THEN

Line 44: edw_owb_collection_util.get_message ('EDW_NO_DIM_FOUND');

40: IF p_dim_list IS NULL
41: THEN
42: g_status := FALSE;
43: g_status_message :=
44: edw_owb_collection_util.get_message ('EDW_NO_DIM_FOUND');
45: g_status_varchar := 'ERROR';
46: write_to_log_file_n (g_status_message);
47: RETURN;
48: END IF;

Line 54: edw_owb_collection_util.get_message ('EDW_NO_FACTS_FOUND');

50: IF p_fact_list IS NULL
51: THEN
52: g_status := FALSE;
53: g_status_message :=
54: edw_owb_collection_util.get_message ('EDW_NO_FACTS_FOUND');
55: g_status_varchar := 'ERROR';
56: write_to_log_file_n (g_status_message);
57: RETURN;
58: END IF;

Line 134: IF edw_owb_collection_util.parse_names (

130: FUNCTION parse_facts_dims (p_fact_list IN VARCHAR2, p_dim_list IN VARCHAR2)
131: RETURN BOOLEAN
132: IS
133: BEGIN
134: IF edw_owb_collection_util.parse_names (
135: p_fact_list,
136: g_fact_list,
137: g_number_fact_list
138: ) = FALSE

Line 140: g_status_message := edw_owb_collection_util.g_status_message;

136: g_fact_list,
137: g_number_fact_list
138: ) = FALSE
139: THEN
140: g_status_message := edw_owb_collection_util.g_status_message;
141: RETURN FALSE;
142: END IF;
143:
144: IF edw_owb_collection_util.parse_names (

Line 144: IF edw_owb_collection_util.parse_names (

140: g_status_message := edw_owb_collection_util.g_status_message;
141: RETURN FALSE;
142: END IF;
143:
144: IF edw_owb_collection_util.parse_names (
145: p_dim_list,
146: g_dim_list,
147: g_number_dim_list
148: ) = FALSE

Line 150: g_status_message := edw_owb_collection_util.g_status_message;

146: g_dim_list,
147: g_number_dim_list
148: ) = FALSE
149: THEN
150: g_status_message := edw_owb_collection_util.g_status_message;
151: RETURN FALSE;
152: END IF;
153:
154: RETURN TRUE;

Line 171: edw_owb_collection_util.get_object_id (g_dim_list (i));

167: BEGIN
168: FOR i IN 1 .. g_number_dim_list
169: LOOP
170: g_dim_id_list (i) :=
171: edw_owb_collection_util.get_object_id (g_dim_list (i));
172: END LOOP;
173:
174: RETURN TRUE;
175: EXCEPTION

Line 193: l_fstg_fk edw_owb_collection_util.varchartabletype;

189: TYPE curtyp IS REF CURSOR;
190:
191: cv curtyp;
192: l_dim_list VARCHAR2 (30000);
193: l_fstg_fk edw_owb_collection_util.varchartabletype;
194: l_fstg_fk_id edw_owb_collection_util.numbertabletype;
195: l_fk_dim edw_owb_collection_util.varchartabletype;
196: l_number_fstg_fk NUMBER;
197: l_map_src_col edw_owb_collection_util.varchartabletype;

Line 194: l_fstg_fk_id edw_owb_collection_util.numbertabletype;

190:
191: cv curtyp;
192: l_dim_list VARCHAR2 (30000);
193: l_fstg_fk edw_owb_collection_util.varchartabletype;
194: l_fstg_fk_id edw_owb_collection_util.numbertabletype;
195: l_fk_dim edw_owb_collection_util.varchartabletype;
196: l_number_fstg_fk NUMBER;
197: l_map_src_col edw_owb_collection_util.varchartabletype;
198: l_map_tgt_col edw_owb_collection_util.varchartabletype;

Line 195: l_fk_dim edw_owb_collection_util.varchartabletype;

191: cv curtyp;
192: l_dim_list VARCHAR2 (30000);
193: l_fstg_fk edw_owb_collection_util.varchartabletype;
194: l_fstg_fk_id edw_owb_collection_util.numbertabletype;
195: l_fk_dim edw_owb_collection_util.varchartabletype;
196: l_number_fstg_fk NUMBER;
197: l_map_src_col edw_owb_collection_util.varchartabletype;
198: l_map_tgt_col edw_owb_collection_util.varchartabletype;
199: l_number_map_cols NUMBER;

Line 197: l_map_src_col edw_owb_collection_util.varchartabletype;

193: l_fstg_fk edw_owb_collection_util.varchartabletype;
194: l_fstg_fk_id edw_owb_collection_util.numbertabletype;
195: l_fk_dim edw_owb_collection_util.varchartabletype;
196: l_number_fstg_fk NUMBER;
197: l_map_src_col edw_owb_collection_util.varchartabletype;
198: l_map_tgt_col edw_owb_collection_util.varchartabletype;
199: l_number_map_cols NUMBER;
200: l_skipped_cols edw_owb_collection_util.varchartabletype;
201: l_number_skipped_cols NUMBER;

Line 198: l_map_tgt_col edw_owb_collection_util.varchartabletype;

194: l_fstg_fk_id edw_owb_collection_util.numbertabletype;
195: l_fk_dim edw_owb_collection_util.varchartabletype;
196: l_number_fstg_fk NUMBER;
197: l_map_src_col edw_owb_collection_util.varchartabletype;
198: l_map_tgt_col edw_owb_collection_util.varchartabletype;
199: l_number_map_cols NUMBER;
200: l_skipped_cols edw_owb_collection_util.varchartabletype;
201: l_number_skipped_cols NUMBER;
202: l_index NUMBER;

Line 200: l_skipped_cols edw_owb_collection_util.varchartabletype;

196: l_number_fstg_fk NUMBER;
197: l_map_src_col edw_owb_collection_util.varchartabletype;
198: l_map_tgt_col edw_owb_collection_util.varchartabletype;
199: l_number_map_cols NUMBER;
200: l_skipped_cols edw_owb_collection_util.varchartabletype;
201: l_number_skipped_cols NUMBER;
202: l_index NUMBER;
203: BEGIN
204: IF g_debug

Line 273: edw_owb_collection_util.get_message (

269:
270: IF g_fstg_pk IS NULL
271: THEN
272: g_status_message :=
273: edw_owb_collection_util.get_message (
274: 'EDW_NO_PK_FOR_INTERFACE_TABLE'
275: );
276: RETURN FALSE;
277: END IF;

Line 364: l_dimTableName EDW_OWB_COLLECTION_UTIL.varcharTableType;

360: l_factTableId number;
361: l_factTableName varchar2(200);
362: l_fstgPKName varchar2(200);
363: l_factPKName varchar2(200);
364: l_dimTableName EDW_OWB_COLLECTION_UTIL.varcharTableType;
365: l_dim_row_count EDW_OWB_COLLECTION_UTIL.numberTableType;
366: l_dimTableId EDW_OWB_COLLECTION_UTIL.numberTableType;
367: l_dimUserPKName EDW_OWB_COLLECTION_UTIL.varcharTableType;
368: begin

Line 365: l_dim_row_count EDW_OWB_COLLECTION_UTIL.numberTableType;

361: l_factTableName varchar2(200);
362: l_fstgPKName varchar2(200);
363: l_factPKName varchar2(200);
364: l_dimTableName EDW_OWB_COLLECTION_UTIL.varcharTableType;
365: l_dim_row_count EDW_OWB_COLLECTION_UTIL.numberTableType;
366: l_dimTableId EDW_OWB_COLLECTION_UTIL.numberTableType;
367: l_dimUserPKName EDW_OWB_COLLECTION_UTIL.varcharTableType;
368: begin
369: --fix for bug 2847694

Line 366: l_dimTableId EDW_OWB_COLLECTION_UTIL.numberTableType;

362: l_fstgPKName varchar2(200);
363: l_factPKName varchar2(200);
364: l_dimTableName EDW_OWB_COLLECTION_UTIL.varcharTableType;
365: l_dim_row_count EDW_OWB_COLLECTION_UTIL.numberTableType;
366: l_dimTableId EDW_OWB_COLLECTION_UTIL.numberTableType;
367: l_dimUserPKName EDW_OWB_COLLECTION_UTIL.varcharTableType;
368: begin
369: --fix for bug 2847694
370: l_stmt:='select mapping_id '||

Line 367: l_dimUserPKName EDW_OWB_COLLECTION_UTIL.varcharTableType;

363: l_factPKName varchar2(200);
364: l_dimTableName EDW_OWB_COLLECTION_UTIL.varcharTableType;
365: l_dim_row_count EDW_OWB_COLLECTION_UTIL.numberTableType;
366: l_dimTableId EDW_OWB_COLLECTION_UTIL.numberTableType;
367: l_dimUserPKName EDW_OWB_COLLECTION_UTIL.varcharTableType;
368: begin
369: --fix for bug 2847694
370: l_stmt:='select mapping_id '||
371: 'from edw_pvt_map_properties_md_v,edw_relations_md_v '||

Line 379: if EDW_OWB_COLLECTION_UTIL.get_stg_map_pk_params(

375: write_to_log_file_n(l_stmt||' '||p_fact);
376: end if;
377: open cv for l_stmt using p_fact;
378: fetch cv into l_mapping_id;
379: if EDW_OWB_COLLECTION_UTIL.get_stg_map_pk_params(
380: l_mapping_id,
381: l_fstgTableUsageId,
382: l_fstgTableId,
383: l_fstgTableName,

Line 392: if EDW_OWB_COLLECTION_UTIL.get_stg_map_fk_details(

388: l_factPKName
389: )=false then
390: return false;
391: end if;
392: if EDW_OWB_COLLECTION_UTIL.get_stg_map_fk_details(
393: l_fstgTableUsageId,
394: l_fstgTableId,
395: l_mapping_id,
396: 1000002,

Line 423: IF edw_owb_collection_util.get_item_set_cols (

419: );
420: END LOOP;
421: END IF;
422:
423: IF edw_owb_collection_util.get_item_set_cols (
424: l_skipped_cols,
425: l_number_skipped_cols,
426: p_fact,
427: 'SKIP_LOAD_SET'

Line 448: IF edw_owb_collection_util.value_in_table (

444:
445: --l_fstg_fk(l_number_fstg_fk),l_fstg_fk_id(l_number_fstg_fk),l_fk_dim(l_number_fstg_fk);
446: FOR i IN 1 .. l_number_map_cols
447: LOOP
448: IF edw_owb_collection_util.value_in_table (
449: l_skipped_cols,
450: l_number_skipped_cols,
451: l_map_tgt_col (i)
452: ) = FALSE

Line 455: edw_owb_collection_util.index_in_table (

451: l_map_tgt_col (i)
452: ) = FALSE
453: THEN
454: l_index :=
455: edw_owb_collection_util.index_in_table (
456: l_fstg_fk,
457: l_number_fstg_fk,
458: l_map_src_col (i)
459: );

Line 530: IF edw_owb_collection_util.get_fks_for_table (

526: END IF;
527:
528: g_number_fstg_all_fk := 0;
529:
530: IF edw_owb_collection_util.get_fks_for_table (
531: g_fstg_name,
532: g_fstg_all_fk,
533: g_number_fstg_all_fk
534: ) = FALSE

Line 536: g_status_message := edw_owb_collection_util.g_status_message;

532: g_fstg_all_fk,
533: g_number_fstg_all_fk
534: ) = FALSE
535: THEN
536: g_status_message := edw_owb_collection_util.g_status_message;
537: RETURN FALSE;
538: END IF;
539:
540: IF g_debug

Line 552: IF edw_owb_collection_util.get_columns_for_table (

548: END IF;
549:
550: g_number_fstg_cols := 0;
551:
552: IF edw_owb_collection_util.get_columns_for_table (
553: g_fstg_name,
554: g_fstg_cols,
555: g_number_fstg_cols
556: ) = FALSE

Line 558: g_status_message := edw_owb_collection_util.g_status_message;

554: g_fstg_cols,
555: g_number_fstg_cols
556: ) = FALSE
557: THEN
558: g_status_message := edw_owb_collection_util.g_status_message;
559: RETURN FALSE;
560: END IF;
561:
562: IF g_debug

Line 618: IF edw_owb_collection_util.does_table_have_data (

614: || g_dim_id_list (i);
615: END LOOP;
616: END IF;
617:
618: IF edw_owb_collection_util.does_table_have_data (
619: g_fstg_name,
620: 'LAST_UPDATE_DATE IS NOT NULL'
621: ) = 2
622: THEN

Line 669: IF edw_owb_collection_util.drop_table (g_fstg_op_table) = FALSE

665: || ' col from '
666: || g_fstg_name
667: || ' where collection_status in (''READY'',''DANGLING'')';
668:
669: IF edw_owb_collection_util.drop_table (g_fstg_op_table) = FALSE
670: THEN
671: NULL;
672: END IF;
673:

Line 701: edw_owb_collection_util.analyze_table_stats (

697: THEN
698: g_op_fstg_table_empty := TRUE;
699: END IF;
700:
701: edw_owb_collection_util.analyze_table_stats (
702: SUBSTR (
703: g_fstg_op_table,
704: INSTR (g_fstg_op_table, '.')
705: + 1,

Line 784: IF edw_owb_collection_util.drop_table (g_bad_key_tables (i)) = FALSE

780: END LOOP;
781:
782: FOR i IN 1 .. g_number_dim_list
783: LOOP
784: IF edw_owb_collection_util.drop_table (g_bad_key_tables (i)) = FALSE
785: THEN
786: NULL;
787: END IF;
788: END LOOP;

Line 880: IF edw_owb_collection_util.drop_table (g_bad_fk_tables (i)) =

876: l_stmt
877: || ' and A.collection_status in (''READY'',''DANGLING'')';
878: END IF;
879:
880: IF edw_owb_collection_util.drop_table (g_bad_fk_tables (i)) =
881: FALSE
882: THEN
883: NULL;
884: END IF;

Line 908: --EDW_OWB_COLLECTION_UTIL.analyze_table_stats(substr(g_bad_fk_tables(i),instr(g_bad_fk_tables(i),'.')+1,

904: || ' rows '
905: || get_time
906: );
907: END IF;
908: --EDW_OWB_COLLECTION_UTIL.analyze_table_stats(substr(g_bad_fk_tables(i),instr(g_bad_fk_tables(i),'.')+1,
909: --length(g_bad_fk_tables(i))),substr(g_bad_fk_tables(i),1,instr(g_bad_fk_tables(i),'.')-1));
910: END IF;
911: END LOOP;
912:

Line 958: IF edw_owb_collection_util.drop_table (g_bad_fk_tables (i)) = FALSE

954: END IF;
955:
956: FOR i IN 1 .. g_number_fstg_fk
957: LOOP
958: IF edw_owb_collection_util.drop_table (g_bad_fk_tables (i)) = FALSE
959: THEN
960: NULL;
961: END IF;
962: END LOOP;

Line 964: IF edw_owb_collection_util.drop_table (g_fstg_op_table) = FALSE

960: NULL;
961: END IF;
962: END LOOP;
963:
964: IF edw_owb_collection_util.drop_table (g_fstg_op_table) = FALSE
965: THEN
966: NULL;
967: END IF;
968:

Line 1056: IF edw_owb_collection_util.create_synonym (

1052: END IF;
1053:
1054: EXECUTE IMMEDIATE l_stmt;
1055:
1056: IF edw_owb_collection_util.create_synonym (
1057: l_table,
1058: g_fstg_error_table
1059: ) = FALSE
1060: THEN

Line 1065: IF edw_owb_collection_util.drop_table (g_fstg_error_table) = FALSE

1061: RETURN FALSE;
1062: END IF;
1063: ELSE
1064: --p_table is the merged table
1065: IF edw_owb_collection_util.drop_table (g_fstg_error_table) = FALSE
1066: THEN
1067: NULL;
1068: END IF;
1069:

Line 1096: edw_owb_collection_util.index_in_table (

1092:
1093: FOR i IN 1 .. g_number_fstg_all_fk
1094: LOOP
1095: l_index :=
1096: edw_owb_collection_util.index_in_table (
1097: g_fstg_fk,
1098: g_number_fstg_fk,
1099: g_fstg_all_fk (i)
1100: );

Line 1104: g_status_message := edw_owb_collection_util.g_status_message;

1100: );
1101:
1102: IF l_index = -1
1103: THEN
1104: g_status_message := edw_owb_collection_util.g_status_message;
1105: RETURN FALSE;
1106: END IF;
1107:
1108: IF l_index = 0

Line 1156: IF edw_owb_collection_util.create_synonym (

1152: || get_time
1153: );
1154: END IF;
1155:
1156: IF edw_owb_collection_util.create_synonym (
1157: l_table,
1158: g_fstg_error_table
1159: ) = FALSE
1160: THEN

Line 1164: IF edw_owb_collection_util.drop_table (p_table) = FALSE

1160: THEN
1161: RETURN FALSE;
1162: END IF;
1163:
1164: IF edw_owb_collection_util.drop_table (p_table) = FALSE
1165: THEN
1166: NULL;
1167: END IF;
1168: END IF;

Line 1188: l_index_table edw_owb_collection_util.varchartabletype;

1184: l_start NUMBER;
1185: l_end NUMBER;
1186: l_table_name VARCHAR2 (200);
1187: l_max_count NUMBER;
1188: l_index_table edw_owb_collection_util.varchartabletype;
1189: l_number_index_table NUMBER;
1190: l_index_table_copy edw_owb_collection_util.varchartabletype;
1191: l_number_index_table_copy NUMBER;
1192: l_union_table VARCHAR2 (200);

Line 1190: l_index_table_copy edw_owb_collection_util.varchartabletype;

1186: l_table_name VARCHAR2 (200);
1187: l_max_count NUMBER;
1188: l_index_table edw_owb_collection_util.varchartabletype;
1189: l_number_index_table NUMBER;
1190: l_index_table_copy edw_owb_collection_util.varchartabletype;
1191: l_number_index_table_copy NUMBER;
1192: l_union_table VARCHAR2 (200);
1193: l_table VARCHAR2 (200);
1194: l_columns edw_owb_collection_util.varchartabletype;

Line 1194: l_columns edw_owb_collection_util.varchartabletype;

1190: l_index_table_copy edw_owb_collection_util.varchartabletype;
1191: l_number_index_table_copy NUMBER;
1192: l_union_table VARCHAR2 (200);
1193: l_table VARCHAR2 (200);
1194: l_columns edw_owb_collection_util.varchartabletype;
1195: l_number_columns NUMBER;
1196: BEGIN
1197: IF g_debug
1198: THEN

Line 1269: IF edw_owb_collection_util.drop_table (l_union_table) = FALSE

1265:
1266: l_stmt := SUBSTR (l_stmt, 1, LENGTH (l_stmt)
1267: - 6);
1268:
1269: IF edw_owb_collection_util.drop_table (l_union_table) = FALSE
1270: THEN
1271: NULL;
1272: END IF;
1273:

Line 1327: IF edw_owb_collection_util.get_db_columns_for_table (

1323: || ' as select ';
1324:
1325: FOR i IN l_start .. l_end
1326: LOOP
1327: IF edw_owb_collection_util.get_db_columns_for_table (
1328: SUBSTR (
1329: l_index_table_copy (i),
1330: INSTR (l_index_table_copy (i), '.')
1331: + 1,

Line 1340: edw_owb_collection_util.g_status_message;

1336: g_bis_owner
1337: ) = FALSE
1338: THEN
1339: g_status_message :=
1340: edw_owb_collection_util.g_status_message;
1341: write_to_log_file_n (g_status_message);
1342: g_status := FALSE;
1343: RETURN FALSE;
1344: END IF;

Line 1390: IF edw_owb_collection_util.drop_table (l_table) = FALSE

1386:
1387: l_stmt := SUBSTR (l_stmt, 1, LENGTH (l_stmt)
1388: - 4);
1389:
1390: IF edw_owb_collection_util.drop_table (l_table) = FALSE
1391: THEN
1392: NULL;
1393: END IF;
1394:

Line 1430: IF edw_owb_collection_util.drop_table (l_index_table_copy (i)) =

1426:
1427: --drop the tables
1428: FOR i IN l_start .. l_end
1429: LOOP
1430: IF edw_owb_collection_util.drop_table (l_index_table_copy (i)) =
1431: FALSE
1432: THEN
1433: NULL;
1434: END IF;

Line 1443: IF edw_owb_collection_util.drop_table (l_union_table) = FALSE

1439: EXIT WHEN l_start > l_number_index_table_copy;
1440: END LOOP;
1441: END LOOP;
1442:
1443: IF edw_owb_collection_util.drop_table (l_union_table) = FALSE
1444: THEN
1445: NULL;
1446: END IF;
1447:

Line 1476: edw_owb_collection_util.write_to_log_file (p_message);

1472:
1473: PROCEDURE write_to_log_file (p_message IN VARCHAR2)
1474: IS
1475: BEGIN
1476: edw_owb_collection_util.write_to_log_file (p_message);
1477: EXCEPTION
1478: WHEN OTHERS
1479: THEN
1480: NULL;