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

Line 294: edw_owb_collection_util.get_instance_col (g_lstg_tables (i));

290: --get the instance column
291: FOR i IN 1 .. g_number_lstg_tables
292: LOOP
293: g_lstg_instance_col (i) :=
294: edw_owb_collection_util.get_instance_col (g_lstg_tables (i));
295: END LOOP;
296:
297: IF g_debug
298: THEN

Line 395: l_ltc_child edw_owb_collection_util.varchartabletype;

391:
392: TYPE curtyp IS REF CURSOR;
393:
394: cv curtyp;
395: l_ltc_child edw_owb_collection_util.varchartabletype;
396: l_ltc_parent edw_owb_collection_util.varchartabletype;
397: l_lstg_ltc_parent_pk edw_owb_collection_util.varchartabletype;
398: l_lstg_ltc_parent_pk_long edw_owb_collection_util.varchartabletype;
399: l_found BOOLEAN;

Line 396: l_ltc_parent edw_owb_collection_util.varchartabletype;

392: TYPE curtyp IS REF CURSOR;
393:
394: cv curtyp;
395: l_ltc_child edw_owb_collection_util.varchartabletype;
396: l_ltc_parent edw_owb_collection_util.varchartabletype;
397: l_lstg_ltc_parent_pk edw_owb_collection_util.varchartabletype;
398: l_lstg_ltc_parent_pk_long edw_owb_collection_util.varchartabletype;
399: l_found BOOLEAN;
400:

Line 397: l_lstg_ltc_parent_pk edw_owb_collection_util.varchartabletype;

393:
394: cv curtyp;
395: l_ltc_child edw_owb_collection_util.varchartabletype;
396: l_ltc_parent edw_owb_collection_util.varchartabletype;
397: l_lstg_ltc_parent_pk edw_owb_collection_util.varchartabletype;
398: l_lstg_ltc_parent_pk_long edw_owb_collection_util.varchartabletype;
399: l_found BOOLEAN;
400:
401: /*

Line 398: l_lstg_ltc_parent_pk_long edw_owb_collection_util.varchartabletype;

394: cv curtyp;
395: l_ltc_child edw_owb_collection_util.varchartabletype;
396: l_ltc_parent edw_owb_collection_util.varchartabletype;
397: l_lstg_ltc_parent_pk edw_owb_collection_util.varchartabletype;
398: l_lstg_ltc_parent_pk_long edw_owb_collection_util.varchartabletype;
399: l_found BOOLEAN;
400:
401: /*
402: l_lstg_child

Line 408: l_lstg_child edw_owb_collection_util.varchartabletype;

404: l_lstg_ltc_parent
405: l_number_lstg
406: used for getting the lstg, fk and parent ltcs
407: */
408: l_lstg_child edw_owb_collection_util.varchartabletype;
409: l_lstg_child_fk edw_owb_collection_util.varchartabletype;
410: l_lstg_ltc_parent edw_owb_collection_util.varchartabletype;
411: l_lstg_child_fk_long edw_owb_collection_util.varchartabletype;
412: l_lstg_ltc_parent_long edw_owb_collection_util.varchartabletype;

Line 409: l_lstg_child_fk edw_owb_collection_util.varchartabletype;

405: l_number_lstg
406: used for getting the lstg, fk and parent ltcs
407: */
408: l_lstg_child edw_owb_collection_util.varchartabletype;
409: l_lstg_child_fk edw_owb_collection_util.varchartabletype;
410: l_lstg_ltc_parent edw_owb_collection_util.varchartabletype;
411: l_lstg_child_fk_long edw_owb_collection_util.varchartabletype;
412: l_lstg_ltc_parent_long edw_owb_collection_util.varchartabletype;
413: l_number_lstg NUMBER;

Line 410: l_lstg_ltc_parent edw_owb_collection_util.varchartabletype;

406: used for getting the lstg, fk and parent ltcs
407: */
408: l_lstg_child edw_owb_collection_util.varchartabletype;
409: l_lstg_child_fk edw_owb_collection_util.varchartabletype;
410: l_lstg_ltc_parent edw_owb_collection_util.varchartabletype;
411: l_lstg_child_fk_long edw_owb_collection_util.varchartabletype;
412: l_lstg_ltc_parent_long edw_owb_collection_util.varchartabletype;
413: l_number_lstg NUMBER;
414: BEGIN

Line 411: l_lstg_child_fk_long edw_owb_collection_util.varchartabletype;

407: */
408: l_lstg_child edw_owb_collection_util.varchartabletype;
409: l_lstg_child_fk edw_owb_collection_util.varchartabletype;
410: l_lstg_ltc_parent edw_owb_collection_util.varchartabletype;
411: l_lstg_child_fk_long edw_owb_collection_util.varchartabletype;
412: l_lstg_ltc_parent_long edw_owb_collection_util.varchartabletype;
413: l_number_lstg NUMBER;
414: BEGIN
415: /*

Line 412: l_lstg_ltc_parent_long edw_owb_collection_util.varchartabletype;

408: l_lstg_child edw_owb_collection_util.varchartabletype;
409: l_lstg_child_fk edw_owb_collection_util.varchartabletype;
410: l_lstg_ltc_parent edw_owb_collection_util.varchartabletype;
411: l_lstg_child_fk_long edw_owb_collection_util.varchartabletype;
412: l_lstg_ltc_parent_long edw_owb_collection_util.varchartabletype;
413: l_number_lstg NUMBER;
414: BEGIN
415: /*
416: we nede to reuse the lstg-ltc info we found out earlier

Line 579: g_lstg_fk_table EDW_OWB_COLLECTION_UTIL.varcharTableType;

575: END IF;
576:
577:
578: /*
579: g_lstg_fk_table EDW_OWB_COLLECTION_UTIL.varcharTableType;
580: g_parent_lstg_fk_table EDW_OWB_COLLECTION_UTIL.varcharTableType;
581: g_parent_ltc_fk_table EDW_OWB_COLLECTION_UTIL.varcharTableType;
582: g_lstg_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
583: g_lstg_fk_position EDW_OWB_COLLECTION_UTIL.numberTableType; --??

Line 580: g_parent_lstg_fk_table EDW_OWB_COLLECTION_UTIL.varcharTableType;

576:
577:
578: /*
579: g_lstg_fk_table EDW_OWB_COLLECTION_UTIL.varcharTableType;
580: g_parent_lstg_fk_table EDW_OWB_COLLECTION_UTIL.varcharTableType;
581: g_parent_ltc_fk_table EDW_OWB_COLLECTION_UTIL.varcharTableType;
582: g_lstg_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
583: g_lstg_fk_position EDW_OWB_COLLECTION_UTIL.numberTableType; --??
584: */

Line 581: g_parent_ltc_fk_table EDW_OWB_COLLECTION_UTIL.varcharTableType;

577:
578: /*
579: g_lstg_fk_table EDW_OWB_COLLECTION_UTIL.varcharTableType;
580: g_parent_lstg_fk_table EDW_OWB_COLLECTION_UTIL.varcharTableType;
581: g_parent_ltc_fk_table EDW_OWB_COLLECTION_UTIL.varcharTableType;
582: g_lstg_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
583: g_lstg_fk_position EDW_OWB_COLLECTION_UTIL.numberTableType; --??
584: */
585:

Line 582: g_lstg_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;

578: /*
579: g_lstg_fk_table EDW_OWB_COLLECTION_UTIL.varcharTableType;
580: g_parent_lstg_fk_table EDW_OWB_COLLECTION_UTIL.varcharTableType;
581: g_parent_ltc_fk_table EDW_OWB_COLLECTION_UTIL.varcharTableType;
582: g_lstg_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
583: g_lstg_fk_position EDW_OWB_COLLECTION_UTIL.numberTableType; --??
584: */
585:
586: FOR i IN 1 .. g_lstg_fk_number

Line 583: g_lstg_fk_position EDW_OWB_COLLECTION_UTIL.numberTableType; --??

579: g_lstg_fk_table EDW_OWB_COLLECTION_UTIL.varcharTableType;
580: g_parent_lstg_fk_table EDW_OWB_COLLECTION_UTIL.varcharTableType;
581: g_parent_ltc_fk_table EDW_OWB_COLLECTION_UTIL.varcharTableType;
582: g_lstg_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
583: g_lstg_fk_position EDW_OWB_COLLECTION_UTIL.numberTableType; --??
584: */
585:
586: FOR i IN 1 .. g_lstg_fk_number
587: LOOP

Line 658: edw_owb_collection_util.get_column_id (

654: l_lstg_child_fk_long,
655: l_number_lstg
656: );
657: g_lstg_fk_id (i) :=
658: edw_owb_collection_util.get_column_id (
659: g_lstg_fk (i),
660: g_lstg_fk_table (i)
661: );
662: END LOOP;

Line 669: edw_owb_collection_util.get_object_id (g_lstg_fk_table (i));

665:
666: FOR i IN 1 .. g_lstg_fk_number
667: LOOP
668: g_lstg_fk_table_id (i) :=
669: edw_owb_collection_util.get_object_id (g_lstg_fk_table (i));
670:
671: IF g_parent_lstg_fk_table (i) IS NOT NULL
672: THEN
673: g_parent_lstg_fk_table_id (i) :=

Line 674: edw_owb_collection_util.get_object_id (

670:
671: IF g_parent_lstg_fk_table (i) IS NOT NULL
672: THEN
673: g_parent_lstg_fk_table_id (i) :=
674: edw_owb_collection_util.get_object_id (
675: g_parent_lstg_fk_table (i)
676: );
677: ELSE
678: g_parent_lstg_fk_table_id (i) := NULL;

Line 684: edw_owb_collection_util.get_object_id (

680:
681: IF g_parent_ltc_fk_table (i) IS NOT NULL
682: THEN
683: g_parent_ltc_fk_table_id (i) :=
684: edw_owb_collection_util.get_object_id (
685: g_parent_ltc_fk_table (i)
686: );
687: ELSE
688: g_parent_ltc_fk_table_id (i) := NULL;

Line 868: l_lstg_ltc_parent IN edw_owb_collection_util.varchartabletype,

864: END get_pk_for_lstg;
865:
866: FUNCTION get_pk_for_ltc (
867: p_ltc IN VARCHAR2,
868: l_lstg_ltc_parent IN edw_owb_collection_util.varchartabletype,
869: l_lstg_ltc_parent_pk IN edw_owb_collection_util.varchartabletype,
870: l_number_lstg IN NUMBER
871: )
872: RETURN VARCHAR2

Line 869: l_lstg_ltc_parent_pk IN edw_owb_collection_util.varchartabletype,

865:
866: FUNCTION get_pk_for_ltc (
867: p_ltc IN VARCHAR2,
868: l_lstg_ltc_parent IN edw_owb_collection_util.varchartabletype,
869: l_lstg_ltc_parent_pk IN edw_owb_collection_util.varchartabletype,
870: l_number_lstg IN NUMBER
871: )
872: RETURN VARCHAR2
873: IS

Line 926: p_lstg_child IN edw_owb_collection_util.varchartabletype,

922: RETURN NULL;
923: END get_lstg_given_ltc;
924:
925: FUNCTION get_lstg_fk_for_ltc (
926: p_lstg_child IN edw_owb_collection_util.varchartabletype,
927: p_lstg_child_fk IN edw_owb_collection_util.varchartabletype,
928: p_lstg_ltc_parent IN edw_owb_collection_util.varchartabletype,
929: p_lstg_number IN NUMBER,
930: p_lstg_fk_table IN VARCHAR2,

Line 927: p_lstg_child_fk IN edw_owb_collection_util.varchartabletype,

923: END get_lstg_given_ltc;
924:
925: FUNCTION get_lstg_fk_for_ltc (
926: p_lstg_child IN edw_owb_collection_util.varchartabletype,
927: p_lstg_child_fk IN edw_owb_collection_util.varchartabletype,
928: p_lstg_ltc_parent IN edw_owb_collection_util.varchartabletype,
929: p_lstg_number IN NUMBER,
930: p_lstg_fk_table IN VARCHAR2,
931: p_parent_ltc_fk_table IN VARCHAR2,

Line 928: p_lstg_ltc_parent IN edw_owb_collection_util.varchartabletype,

924:
925: FUNCTION get_lstg_fk_for_ltc (
926: p_lstg_child IN edw_owb_collection_util.varchartabletype,
927: p_lstg_child_fk IN edw_owb_collection_util.varchartabletype,
928: p_lstg_ltc_parent IN edw_owb_collection_util.varchartabletype,
929: p_lstg_number IN NUMBER,
930: p_lstg_fk_table IN VARCHAR2,
931: p_parent_ltc_fk_table IN VARCHAR2,
932: p_lstg_fk_table_prev IN VARCHAR2,

Line 1190: l_owner := edw_owb_collection_util.get_table_owner (p_dim_name);

1186: write_to_out (fnd_message.get);
1187: --write_to_out('Total number of records in the interface tables with status of ');
1188: --write_to_out('''READY'',''DANGLING'' or ''DUPLICATE''');
1189: write_to_out (' ');
1190: l_owner := edw_owb_collection_util.get_table_owner (p_dim_name);
1191:
1192: FOR i IN 1 .. g_number_lstg_tables
1193: LOOP
1194: --EDW_OWB_COLLECTION_UTIL.analyze_table_stats(g_lstg_tables(i), l_owner);

Line 1194: --EDW_OWB_COLLECTION_UTIL.analyze_table_stats(g_lstg_tables(i), l_owner);

1190: l_owner := edw_owb_collection_util.get_table_owner (p_dim_name);
1191:
1192: FOR i IN 1 .. g_number_lstg_tables
1193: LOOP
1194: --EDW_OWB_COLLECTION_UTIL.analyze_table_stats(g_lstg_tables(i), l_owner);
1195: g_lstg_total_records (i) := 0;
1196: l_stmt := 'create table '
1197: || g_lstg_pk_table (i)
1198: || ' tablespace '

Line 1229: IF edw_owb_collection_util.drop_table (g_lstg_pk_table (i)) = FALSE

1225: || ' where collection_status in '
1226: || '(''READY'',''DANGLING'',''DUPLICATE'') ';
1227: END IF;
1228:
1229: IF edw_owb_collection_util.drop_table (g_lstg_pk_table (i)) = FALSE
1230: THEN
1231: NULL;
1232: END IF;
1233:

Line 1266: edw_owb_collection_util.analyze_table_stats (

1262: fnd_message.set_token ('TABLE', g_lstg_table_long_name (i));
1263: fnd_message.set_token ('RECORDS', g_lstg_total_records (i));
1264: write_to_out (fnd_message.get);
1265: --write_to_out('Table '||g_lstg_table_long_name(i)||' has '||g_lstg_total_records(i)||' records');
1266: edw_owb_collection_util.analyze_table_stats (
1267: SUBSTR (
1268: g_lstg_pk_table (i),
1269: INSTR (g_lstg_pk_table (i), '.')
1270: + 1,

Line 1302: l_dup_str edw_owb_collection_util.varchartabletype;

1298:
1299: cv curtyp;
1300: l_num_dup NUMBER;
1301: l_num_dup_log NUMBER;
1302: l_dup_str edw_owb_collection_util.varchartabletype;
1303: l_dup_count edw_owb_collection_util.numbertabletype;
1304: l_number_dup_str NUMBER;
1305: BEGIN
1306: write_to_out (' ');

Line 1303: l_dup_count edw_owb_collection_util.numbertabletype;

1299: cv curtyp;
1300: l_num_dup NUMBER;
1301: l_num_dup_log NUMBER;
1302: l_dup_str edw_owb_collection_util.varchartabletype;
1303: l_dup_count edw_owb_collection_util.numbertabletype;
1304: l_number_dup_str NUMBER;
1305: BEGIN
1306: write_to_out (' ');
1307: fnd_message.set_name ('BIS', 'EDW_CDI_DUPLICATE_DATA_CHECK');

Line 1349: IF edw_owb_collection_util.drop_table (g_lstg_dup_pk_table (i)) =

1345: || g_lstg_pk (i)
1346: || ')>1 group by '
1347: || g_lstg_pk (i);
1348:
1349: IF edw_owb_collection_util.drop_table (g_lstg_dup_pk_table (i)) =
1350: FALSE
1351: THEN
1352: NULL;
1353: END IF;

Line 1376: edw_owb_collection_util.analyze_table_stats (

1372: || get_time
1373: );
1374: END IF;
1375:
1376: edw_owb_collection_util.analyze_table_stats (
1377: SUBSTR (
1378: g_lstg_dup_pk_table (i),
1379: INSTR (g_lstg_dup_pk_table (i), '.')
1380: + 1,

Line 1509: IF edw_owb_collection_util.drop_table (g_lstg_dup_pk_table (i)) =

1505: - 1;
1506: write_to_out (' ');
1507: END IF;
1508:
1509: IF edw_owb_collection_util.drop_table (g_lstg_dup_pk_table (i)) =
1510: FALSE
1511: THEN
1512: NULL;
1513: END IF;

Line 1566: l_fk edw_owb_collection_util.varchartabletype;

1562: RETURN BOOLEAN
1563: IS
1564: l_lstg_index NUMBER;
1565: l_stmt VARCHAR2 (20000);
1566: l_fk edw_owb_collection_util.varchartabletype;
1567: l_number_fk NUMBER;
1568: l_table_considered edw_owb_collection_util.varchartabletype;
1569: l_number_table_considered NUMBER;
1570: BEGIN

Line 1568: l_table_considered edw_owb_collection_util.varchartabletype;

1564: l_lstg_index NUMBER;
1565: l_stmt VARCHAR2 (20000);
1566: l_fk edw_owb_collection_util.varchartabletype;
1567: l_number_fk NUMBER;
1568: l_table_considered edw_owb_collection_util.varchartabletype;
1569: l_number_table_considered NUMBER;
1570: BEGIN
1571: IF g_debug
1572: THEN

Line 1586: IF edw_owb_collection_util.value_in_table (

1582: --g_main_lstg_fk_table
1583: --g_number_main_lstg_fk_table
1584: l_number_fk := 0;
1585:
1586: IF edw_owb_collection_util.value_in_table (
1587: l_table_considered,
1588: l_number_table_considered,
1589: g_lstg_fk_table (i)
1590: ) = FALSE

Line 1597: edw_owb_collection_util.index_in_table (

1593: + 1;
1594: l_table_considered (l_number_table_considered) :=
1595: g_lstg_fk_table (i);
1596: l_lstg_index :=
1597: edw_owb_collection_util.index_in_table (
1598: g_lstg_tables,
1599: g_number_lstg_tables,
1600: g_lstg_fk_table (i)
1601: );

Line 1613: IF edw_owb_collection_util.value_in_table (

1609: FOR j IN 1 .. g_lstg_fk_number
1610: LOOP
1611: IF g_lstg_fk_table (j) = g_lstg_fk_table (i)
1612: THEN
1613: IF edw_owb_collection_util.value_in_table (
1614: l_fk,
1615: l_number_fk,
1616: g_lstg_fk (j)
1617: ) = FALSE

Line 1693: IF edw_owb_collection_util.drop_table (

1689: || '.rowid='
1690: || g_lstg_pk_table (l_lstg_index)
1691: || '.row_id';
1692:
1693: IF edw_owb_collection_util.drop_table (
1694: g_main_lstg_fk_table (g_number_main_lstg_fk_table)
1695: ) = FALSE
1696: THEN
1697: NULL;

Line 1732: edw_owb_collection_util.analyze_table_stats (

1728: if g_debug then
1729: write_to_log_n('Created unique index on '||g_main_lstg_fk_table(g_number_main_lstg_fk_table)||get_time);
1730: end if;*/
1731:
1732: edw_owb_collection_util.analyze_table_stats (
1733: SUBSTR (
1734: g_main_lstg_fk_table (g_number_main_lstg_fk_table),
1735: INSTR (
1736: g_main_lstg_fk_table (g_number_main_lstg_fk_table),

Line 1778: edw_owb_collection_util.index_in_table (

1774:
1775: FOR i IN 1 .. g_lstg_fk_number
1776: LOOP
1777: l_lstg_index :=
1778: edw_owb_collection_util.index_in_table (
1779: g_main_lstg_fk_table_lstg,
1780: g_number_main_lstg_fk_table,
1781: g_lstg_fk_table (i)
1782: );

Line 1816: IF edw_owb_collection_util.drop_table (g_lstg_fk_hold_table (i)) =

1812: END IF;
1813:
1814: FOR i IN 1 .. g_lstg_fk_number
1815: LOOP
1816: IF edw_owb_collection_util.drop_table (g_lstg_fk_hold_table (i)) =
1817: FALSE
1818: THEN
1819: NULL;
1820: END IF;

Line 1844: IF edw_owb_collection_util.drop_table (g_lstg_pk_table (i)) = FALSE

1840: END IF;
1841:
1842: FOR i IN 1 .. g_number_lstg_tables
1843: LOOP
1844: IF edw_owb_collection_util.drop_table (g_lstg_pk_table (i)) = FALSE
1845: THEN
1846: NULL;
1847: END IF;
1848: END LOOP;

Line 1870: l_dang_str edw_owb_collection_util.varchartabletype;

1866: cv curtyp;
1867: l_num_dang NUMBER;
1868: l_number_dang_str NUMBER;
1869: l_total_recs NUMBER;
1870: l_dang_str edw_owb_collection_util.varchartabletype;
1871: l_dang_count edw_owb_collection_util.numbertabletype;
1872: l_dang_instance edw_owb_collection_util.varchartabletype;
1873: l_lstg_fk_table_long edw_owb_collection_util.varchartabletype;
1874: l_lstg_index NUMBER;

Line 1871: l_dang_count edw_owb_collection_util.numbertabletype;

1867: l_num_dang NUMBER;
1868: l_number_dang_str NUMBER;
1869: l_total_recs NUMBER;
1870: l_dang_str edw_owb_collection_util.varchartabletype;
1871: l_dang_count edw_owb_collection_util.numbertabletype;
1872: l_dang_instance edw_owb_collection_util.varchartabletype;
1873: l_lstg_fk_table_long edw_owb_collection_util.varchartabletype;
1874: l_lstg_index NUMBER;
1875: l_lstg_parent_index NUMBER;

Line 1872: l_dang_instance edw_owb_collection_util.varchartabletype;

1868: l_number_dang_str NUMBER;
1869: l_total_recs NUMBER;
1870: l_dang_str edw_owb_collection_util.varchartabletype;
1871: l_dang_count edw_owb_collection_util.numbertabletype;
1872: l_dang_instance edw_owb_collection_util.varchartabletype;
1873: l_lstg_fk_table_long edw_owb_collection_util.varchartabletype;
1874: l_lstg_index NUMBER;
1875: l_lstg_parent_index NUMBER;
1876: l_fk_ok_number NUMBER;

Line 1873: l_lstg_fk_table_long edw_owb_collection_util.varchartabletype;

1869: l_total_recs NUMBER;
1870: l_dang_str edw_owb_collection_util.varchartabletype;
1871: l_dang_count edw_owb_collection_util.numbertabletype;
1872: l_dang_instance edw_owb_collection_util.varchartabletype;
1873: l_lstg_fk_table_long edw_owb_collection_util.varchartabletype;
1874: l_lstg_index NUMBER;
1875: l_lstg_parent_index NUMBER;
1876: l_fk_ok_number NUMBER;
1877: BEGIN

Line 1933: edw_owb_collection_util.index_in_table (

1929:
1930: IF l_total_recs > 0
1931: THEN
1932: l_lstg_index :=
1933: edw_owb_collection_util.index_in_table (
1934: g_lstg_tables,
1935: g_number_lstg_tables,
1936: g_lstg_fk_table (j)
1937: );

Line 1940: edw_owb_collection_util.index_in_table (

1936: g_lstg_fk_table (j)
1937: );
1938: --join with the parent lstg pk table and create the ok table
1939: l_lstg_parent_index :=
1940: edw_owb_collection_util.index_in_table (
1941: g_lstg_tables,
1942: g_number_lstg_tables,
1943: g_parent_lstg_fk_table (j)
1944: );

Line 2000: IF edw_owb_collection_util.drop_table (

1996: || '.'
1997: || g_lstg_fk (j)
1998: || '=''NA_EDW''';
1999:
2000: IF edw_owb_collection_util.drop_table (
2001: g_lstg_ok_table (j)
2002: ) = FALSE
2003: THEN
2004: NULL;

Line 2031: edw_owb_collection_util.analyze_table_stats (

2027: || get_time
2028: );
2029: END IF;
2030:
2031: edw_owb_collection_util.analyze_table_stats (
2032: SUBSTR (
2033: g_lstg_ok_table (j),
2034: INSTR (g_lstg_ok_table (j), '.')
2035: + 1,

Line 2297: IF edw_owb_collection_util.drop_table (

2293: || g_lstg_fk_hold_table (j)
2294: || ' MINUS select row_id from '
2295: || g_lstg_ok_table (j);
2296:
2297: IF edw_owb_collection_util.drop_table (
2298: g_lstg_dang_rowid_table (j)
2299: ) = FALSE
2300: THEN
2301: NULL;

Line 2327: edw_owb_collection_util.analyze_table_stats (

2323: || get_time
2324: );
2325: END IF;
2326:
2327: edw_owb_collection_util.analyze_table_stats (
2328: SUBSTR (
2329: g_lstg_dang_rowid_table (j),
2330: INSTR (g_lstg_dang_rowid_table (j), '.')
2331: + 1,

Line 2466: IF edw_owb_collection_util.drop_table (

2462: CLOSE cv;
2463: l_number_dang_str := l_number_dang_str
2464: - 1;
2465:
2466: IF edw_owb_collection_util.drop_table (
2467: g_lstg_dang_rowid_table (j)
2468: ) = FALSE
2469: THEN
2470: NULL;

Line 2500: IF edw_owb_collection_util.drop_table (g_lstg_ok_table (j)) =

2496: END IF;
2497: END IF;
2498: END IF; --if l_fk_number>l_fk_ok_number and g_sample_on then
2499:
2500: IF edw_owb_collection_util.drop_table (g_lstg_ok_table (j)) =
2501: FALSE
2502: THEN
2503: NULL;
2504: END IF;

Line 2539: l_dang_str edw_owb_collection_util.varchartabletype;

2535: l_number_dang_str NUMBER;
2536: l_fk_ok_number NUMBER;
2537: l_lstg_index NUMBER;
2538: l_lstg_parent_index NUMBER;
2539: l_dang_str edw_owb_collection_util.varchartabletype;
2540: l_dang_count edw_owb_collection_util.numbertabletype;
2541: l_dang_instance edw_owb_collection_util.varchartabletype;
2542: l_lstg_fk_table_long edw_owb_collection_util.varchartabletype;
2543: BEGIN

Line 2540: l_dang_count edw_owb_collection_util.numbertabletype;

2536: l_fk_ok_number NUMBER;
2537: l_lstg_index NUMBER;
2538: l_lstg_parent_index NUMBER;
2539: l_dang_str edw_owb_collection_util.varchartabletype;
2540: l_dang_count edw_owb_collection_util.numbertabletype;
2541: l_dang_instance edw_owb_collection_util.varchartabletype;
2542: l_lstg_fk_table_long edw_owb_collection_util.varchartabletype;
2543: BEGIN
2544: FOR i IN 1 .. g_lstg_fk_number

Line 2541: l_dang_instance edw_owb_collection_util.varchartabletype;

2537: l_lstg_index NUMBER;
2538: l_lstg_parent_index NUMBER;
2539: l_dang_str edw_owb_collection_util.varchartabletype;
2540: l_dang_count edw_owb_collection_util.numbertabletype;
2541: l_dang_instance edw_owb_collection_util.varchartabletype;
2542: l_lstg_fk_table_long edw_owb_collection_util.varchartabletype;
2543: BEGIN
2544: FOR i IN 1 .. g_lstg_fk_number
2545: LOOP

Line 2542: l_lstg_fk_table_long edw_owb_collection_util.varchartabletype;

2538: l_lstg_parent_index NUMBER;
2539: l_dang_str edw_owb_collection_util.varchartabletype;
2540: l_dang_count edw_owb_collection_util.numbertabletype;
2541: l_dang_instance edw_owb_collection_util.varchartabletype;
2542: l_lstg_fk_table_long edw_owb_collection_util.varchartabletype;
2543: BEGIN
2544: FOR i IN 1 .. g_lstg_fk_number
2545: LOOP
2546: l_lstg_fk_table_long (i) := get_lstg_long_name (g_lstg_fk_table (i));

Line 2584: edw_owb_collection_util.index_in_table (

2580:
2581: IF l_total_recs > 0
2582: THEN
2583: l_lstg_index :=
2584: edw_owb_collection_util.index_in_table (
2585: g_lstg_tables,
2586: g_number_lstg_tables,
2587: g_lstg_fk_table (j)
2588: );

Line 2591: edw_owb_collection_util.index_in_table (

2587: g_lstg_fk_table (j)
2588: );
2589: --join with the parent lstg pk table and create the ok table
2590: l_lstg_parent_index :=
2591: edw_owb_collection_util.index_in_table (
2592: g_lstg_tables,
2593: g_number_lstg_tables,
2594: g_parent_lstg_fk_table (j)
2595: );

Line 2626: IF edw_owb_collection_util.drop_table (g_lstg_ok_table (j)) =

2622: || g_parent_ltc_fk_table (j)
2623: || '.'
2624: || g_parent_ltc_fk_table_pk (j);
2625:
2626: IF edw_owb_collection_util.drop_table (g_lstg_ok_table (j)) =
2627: FALSE
2628: THEN
2629: NULL;
2630: END IF;

Line 2656: edw_owb_collection_util.analyze_table_stats (

2652: || get_time
2653: );
2654: END IF;
2655:
2656: edw_owb_collection_util.analyze_table_stats (
2657: SUBSTR (
2658: g_lstg_ok_table (j),
2659: INSTR (g_lstg_ok_table (j), '.')
2660: + 1,

Line 2783: IF edw_owb_collection_util.drop_table (

2779: || g_lstg_fk_hold_table (j)
2780: || ' MINUS select row_id from '
2781: || g_lstg_ok_table (j);
2782:
2783: IF edw_owb_collection_util.drop_table (
2784: g_lstg_dang_rowid_table (j)
2785: ) = FALSE
2786: THEN
2787: NULL;

Line 2813: edw_owb_collection_util.analyze_table_stats (

2809: || get_time
2810: );
2811: END IF;
2812:
2813: edw_owb_collection_util.analyze_table_stats (
2814: SUBSTR (
2815: g_lstg_dang_rowid_table (j),
2816: INSTR (g_lstg_dang_rowid_table (j), '.')
2817: + 1,

Line 2952: IF edw_owb_collection_util.drop_table (

2948: write_to_out (' ');
2949: l_number_dang_str := l_number_dang_str
2950: - 1;
2951:
2952: IF edw_owb_collection_util.drop_table (
2953: g_lstg_dang_rowid_table (j)
2954: ) = FALSE
2955: THEN
2956: NULL;

Line 2960: IF edw_owb_collection_util.drop_table (g_lstg_ok_table (j)) =

2956: NULL;
2957: END IF;
2958: END IF; --if l_fk_number>l_fk_ok_number and g_sample_on then
2959:
2960: IF edw_owb_collection_util.drop_table (g_lstg_ok_table (j)) =
2961: FALSE
2962: THEN
2963: NULL;
2964: END IF;

Line 3080: --edw_owb_collection_util.setup_conc_program_log (g_log_name);

3076: g_log_name := 'CHECK_DATA_INT';
3077: g_debug := FALSE; --make this false
3078: g_duplicate_check := TRUE;
3079: l_status := TRUE;
3080: --edw_owb_collection_util.setup_conc_program_log (g_log_name);
3081: edw_owb_collection_util.init_all(g_log_name,null,'bis.edw.check_data_validity');
3082: IF edw_option.get_warehouse_option (
3083: p_object_name,
3084: NULL,

Line 3081: edw_owb_collection_util.init_all(g_log_name,null,'bis.edw.check_data_validity');

3077: g_debug := FALSE; --make this false
3078: g_duplicate_check := TRUE;
3079: l_status := TRUE;
3080: --edw_owb_collection_util.setup_conc_program_log (g_log_name);
3081: edw_owb_collection_util.init_all(g_log_name,null,'bis.edw.check_data_validity');
3082: IF edw_option.get_warehouse_option (
3083: p_object_name,
3084: NULL,
3085: 'TRACE',

Line 3092: edw_owb_collection_util.alter_session ('TRACE');

3088: THEN
3089: IF l_option_value = 'Y'
3090: THEN
3091: write_to_log_n ('Trace turned ON');
3092: edw_owb_collection_util.alter_session ('TRACE');
3093: ELSE
3094: write_to_log_n ('Trace turned OFF');
3095: END IF;
3096: ELSE

Line 3119: edw_owb_collection_util.set_debug(g_debug);

3115: || l_option_value);
3116: ELSE
3117: l_status := FALSE;
3118: END IF;
3119: edw_owb_collection_util.set_debug(g_debug);
3120: IF edw_option.get_warehouse_option (
3121: p_object_name,
3122: NULL,
3123: 'OPTABLESPACE',

Line 3130: edw_owb_collection_util.get_table_space (g_bis_owner)

3126: THEN
3127: g_op_table_space :=
3128: NVL (
3129: l_option_value,
3130: edw_owb_collection_util.get_table_space (g_bis_owner)
3131: );
3132: write_to_log_n (
3133: 'EDW_Operation tablespace is '
3134: || g_op_table_space

Line 3178: edw_owb_collection_util.alter_session ('PARALLEL');

3174: END IF;
3175:
3176: IF g_parallel IS NOT NULL
3177: THEN
3178: edw_owb_collection_util.alter_session ('PARALLEL');
3179: edw_owb_collection_util.set_parallel (g_parallel);
3180: COMMIT;
3181: END IF;
3182: ELSE

Line 3179: edw_owb_collection_util.set_parallel (g_parallel);

3175:
3176: IF g_parallel IS NOT NULL
3177: THEN
3178: edw_owb_collection_util.alter_session ('PARALLEL');
3179: edw_owb_collection_util.set_parallel (g_parallel);
3180: COMMIT;
3181: END IF;
3182: ELSE
3183: l_status := FALSE;

Line 3233: edw_owb_collection_util.set_debug (g_debug);

3229: );
3230: RAISE g_read_object_settings_failure;
3231: END IF;
3232:
3233: edw_owb_collection_util.set_debug (g_debug);
3234:
3235: /********for bug 2966892 *****/
3236: --g_number_sample := 10;
3237: --g_check_against_ltc := FALSE;

Line 3251: g_bis_owner := edw_owb_collection_util.get_db_user ('BIS');

3247: write_to_log_n ('Sample OFF');
3248: END IF;
3249:
3250: g_exec_flag := TRUE;
3251: g_bis_owner := edw_owb_collection_util.get_db_user ('BIS');
3252: g_number_fk_to_check := 0;
3253: g_results_table := 'EDW_CDI_RESULTS';
3254:
3255: IF edw_owb_collection_util.check_table (g_results_table) = TRUE

Line 3255: IF edw_owb_collection_util.check_table (g_results_table) = TRUE

3251: g_bis_owner := edw_owb_collection_util.get_db_user ('BIS');
3252: g_number_fk_to_check := 0;
3253: g_results_table := 'EDW_CDI_RESULTS';
3254:
3255: IF edw_owb_collection_util.check_table (g_results_table) = TRUE
3256: THEN
3257: g_results_table_flag := TRUE;
3258: ELSE
3259: g_results_table_flag := FALSE;

Line 3278: edw_owb_collection_util.write_to_log_file (p_message);

3274:
3275: PROCEDURE write_to_log (p_message IN VARCHAR2)
3276: IS
3277: BEGIN
3278: edw_owb_collection_util.write_to_log_file (p_message);
3279: END write_to_log;
3280:
3281: PROCEDURE write_to_log_n (p_message IN VARCHAR2)
3282: IS

Line 3291: edw_owb_collection_util.write_to_out_file (p_message);

3287:
3288: PROCEDURE write_to_out (p_message IN VARCHAR2)
3289: IS
3290: BEGIN
3291: edw_owb_collection_util.write_to_out_file (p_message);
3292: END write_to_out;
3293:
3294: PROCEDURE write_to_out_n (p_message IN VARCHAR2)
3295: IS

Line 3526: fk_table_long IN edw_owb_collection_util.varchartabletype,

3522: END get_lstg_pk;
3523:
3524: FUNCTION get_fk_long (
3525: p_fk IN VARCHAR2,
3526: fk_table_long IN edw_owb_collection_util.varchartabletype,
3527: fk_table IN edw_owb_collection_util.varchartabletype,
3528: fk_table_number IN NUMBER
3529: )
3530: RETURN VARCHAR2

Line 3527: fk_table IN edw_owb_collection_util.varchartabletype,

3523:
3524: FUNCTION get_fk_long (
3525: p_fk IN VARCHAR2,
3526: fk_table_long IN edw_owb_collection_util.varchartabletype,
3527: fk_table IN edw_owb_collection_util.varchartabletype,
3528: fk_table_number IN NUMBER
3529: )
3530: RETURN VARCHAR2
3531: IS

Line 3557: p_lstg_ltc_parent IN edw_owb_collection_util.varchartabletype,

3553: END get_fk_long;
3554:
3555: FUNCTION get_parent_ltc_long (
3556: p_ltc IN VARCHAR2,
3557: p_lstg_ltc_parent IN edw_owb_collection_util.varchartabletype,
3558: p_lstg_ltc_parent_long IN edw_owb_collection_util.varchartabletype,
3559: p_number_lstg IN NUMBER
3560: )
3561: RETURN VARCHAR2

Line 3558: p_lstg_ltc_parent_long IN edw_owb_collection_util.varchartabletype,

3554:
3555: FUNCTION get_parent_ltc_long (
3556: p_ltc IN VARCHAR2,
3557: p_lstg_ltc_parent IN edw_owb_collection_util.varchartabletype,
3558: p_lstg_ltc_parent_long IN edw_owb_collection_util.varchartabletype,
3559: p_number_lstg IN NUMBER
3560: )
3561: RETURN VARCHAR2
3562: IS

Line 3588: p_lstg_ltc_parent_pk IN edw_owb_collection_util.varchartabletype,

3584: END get_parent_ltc_long;
3585:
3586: FUNCTION get_ltc_pk_long (
3587: p_parent_ltc_fk_table_pk IN VARCHAR2,
3588: p_lstg_ltc_parent_pk IN edw_owb_collection_util.varchartabletype,
3589: p_lstg_ltc_parent_pk_long IN edw_owb_collection_util.varchartabletype,
3590: p_number_lstg IN NUMBER
3591: )
3592: RETURN VARCHAR2

Line 3589: p_lstg_ltc_parent_pk_long IN edw_owb_collection_util.varchartabletype,

3585:
3586: FUNCTION get_ltc_pk_long (
3587: p_parent_ltc_fk_table_pk IN VARCHAR2,
3588: p_lstg_ltc_parent_pk IN edw_owb_collection_util.varchartabletype,
3589: p_lstg_ltc_parent_pk_long IN edw_owb_collection_util.varchartabletype,
3590: p_number_lstg IN NUMBER
3591: )
3592: RETURN VARCHAR2
3593: IS

Line 3840: l_fstg_fk edw_owb_collection_util.varchartabletype;

3836:
3837: TYPE curtyp IS REF CURSOR;
3838:
3839: cv curtyp;
3840: l_fstg_fk edw_owb_collection_util.varchartabletype;
3841: l_fstg_fk_id edw_owb_collection_util.numbertabletype;
3842: l_fstg_fk_long edw_owb_collection_util.varchartabletype;
3843: l_fact_dims_id edw_owb_collection_util.numbertabletype;
3844: l_fact_dims edw_owb_collection_util.varchartabletype;

Line 3841: l_fstg_fk_id edw_owb_collection_util.numbertabletype;

3837: TYPE curtyp IS REF CURSOR;
3838:
3839: cv curtyp;
3840: l_fstg_fk edw_owb_collection_util.varchartabletype;
3841: l_fstg_fk_id edw_owb_collection_util.numbertabletype;
3842: l_fstg_fk_long edw_owb_collection_util.varchartabletype;
3843: l_fact_dims_id edw_owb_collection_util.numbertabletype;
3844: l_fact_dims edw_owb_collection_util.varchartabletype;
3845: l_fact_dims_long edw_owb_collection_util.varchartabletype;

Line 3842: l_fstg_fk_long edw_owb_collection_util.varchartabletype;

3838:
3839: cv curtyp;
3840: l_fstg_fk edw_owb_collection_util.varchartabletype;
3841: l_fstg_fk_id edw_owb_collection_util.numbertabletype;
3842: l_fstg_fk_long edw_owb_collection_util.varchartabletype;
3843: l_fact_dims_id edw_owb_collection_util.numbertabletype;
3844: l_fact_dims edw_owb_collection_util.varchartabletype;
3845: l_fact_dims_long edw_owb_collection_util.varchartabletype;
3846: l_fact_dims_pk edw_owb_collection_util.varchartabletype;

Line 3843: l_fact_dims_id edw_owb_collection_util.numbertabletype;

3839: cv curtyp;
3840: l_fstg_fk edw_owb_collection_util.varchartabletype;
3841: l_fstg_fk_id edw_owb_collection_util.numbertabletype;
3842: l_fstg_fk_long edw_owb_collection_util.varchartabletype;
3843: l_fact_dims_id edw_owb_collection_util.numbertabletype;
3844: l_fact_dims edw_owb_collection_util.varchartabletype;
3845: l_fact_dims_long edw_owb_collection_util.varchartabletype;
3846: l_fact_dims_pk edw_owb_collection_util.varchartabletype;
3847: l_fact_dims_pk_long edw_owb_collection_util.varchartabletype;

Line 3844: l_fact_dims edw_owb_collection_util.varchartabletype;

3840: l_fstg_fk edw_owb_collection_util.varchartabletype;
3841: l_fstg_fk_id edw_owb_collection_util.numbertabletype;
3842: l_fstg_fk_long edw_owb_collection_util.varchartabletype;
3843: l_fact_dims_id edw_owb_collection_util.numbertabletype;
3844: l_fact_dims edw_owb_collection_util.varchartabletype;
3845: l_fact_dims_long edw_owb_collection_util.varchartabletype;
3846: l_fact_dims_pk edw_owb_collection_util.varchartabletype;
3847: l_fact_dims_pk_long edw_owb_collection_util.varchartabletype;
3848: l_number_fstg_fk NUMBER;

Line 3845: l_fact_dims_long edw_owb_collection_util.varchartabletype;

3841: l_fstg_fk_id edw_owb_collection_util.numbertabletype;
3842: l_fstg_fk_long edw_owb_collection_util.varchartabletype;
3843: l_fact_dims_id edw_owb_collection_util.numbertabletype;
3844: l_fact_dims edw_owb_collection_util.varchartabletype;
3845: l_fact_dims_long edw_owb_collection_util.varchartabletype;
3846: l_fact_dims_pk edw_owb_collection_util.varchartabletype;
3847: l_fact_dims_pk_long edw_owb_collection_util.varchartabletype;
3848: l_number_fstg_fk NUMBER;
3849: l_skipped_cols edw_owb_collection_util.varchartabletype;

Line 3846: l_fact_dims_pk edw_owb_collection_util.varchartabletype;

3842: l_fstg_fk_long edw_owb_collection_util.varchartabletype;
3843: l_fact_dims_id edw_owb_collection_util.numbertabletype;
3844: l_fact_dims edw_owb_collection_util.varchartabletype;
3845: l_fact_dims_long edw_owb_collection_util.varchartabletype;
3846: l_fact_dims_pk edw_owb_collection_util.varchartabletype;
3847: l_fact_dims_pk_long edw_owb_collection_util.varchartabletype;
3848: l_number_fstg_fk NUMBER;
3849: l_skipped_cols edw_owb_collection_util.varchartabletype;
3850: l_number_skipped_cols NUMBER;

Line 3847: l_fact_dims_pk_long edw_owb_collection_util.varchartabletype;

3843: l_fact_dims_id edw_owb_collection_util.numbertabletype;
3844: l_fact_dims edw_owb_collection_util.varchartabletype;
3845: l_fact_dims_long edw_owb_collection_util.varchartabletype;
3846: l_fact_dims_pk edw_owb_collection_util.varchartabletype;
3847: l_fact_dims_pk_long edw_owb_collection_util.varchartabletype;
3848: l_number_fstg_fk NUMBER;
3849: l_skipped_cols edw_owb_collection_util.varchartabletype;
3850: l_number_skipped_cols NUMBER;
3851: l_map_src_col edw_owb_collection_util.varchartabletype;

Line 3849: l_skipped_cols edw_owb_collection_util.varchartabletype;

3845: l_fact_dims_long edw_owb_collection_util.varchartabletype;
3846: l_fact_dims_pk edw_owb_collection_util.varchartabletype;
3847: l_fact_dims_pk_long edw_owb_collection_util.varchartabletype;
3848: l_number_fstg_fk NUMBER;
3849: l_skipped_cols edw_owb_collection_util.varchartabletype;
3850: l_number_skipped_cols NUMBER;
3851: l_map_src_col edw_owb_collection_util.varchartabletype;
3852: l_map_tgt_col edw_owb_collection_util.varchartabletype;
3853: l_number_map_cols NUMBER;

Line 3851: l_map_src_col edw_owb_collection_util.varchartabletype;

3847: l_fact_dims_pk_long edw_owb_collection_util.varchartabletype;
3848: l_number_fstg_fk NUMBER;
3849: l_skipped_cols edw_owb_collection_util.varchartabletype;
3850: l_number_skipped_cols NUMBER;
3851: l_map_src_col edw_owb_collection_util.varchartabletype;
3852: l_map_tgt_col edw_owb_collection_util.varchartabletype;
3853: l_number_map_cols NUMBER;
3854: l_index NUMBER;
3855: BEGIN

Line 3852: l_map_tgt_col edw_owb_collection_util.varchartabletype;

3848: l_number_fstg_fk NUMBER;
3849: l_skipped_cols edw_owb_collection_util.varchartabletype;
3850: l_number_skipped_cols NUMBER;
3851: l_map_src_col edw_owb_collection_util.varchartabletype;
3852: l_map_tgt_col edw_owb_collection_util.varchartabletype;
3853: l_number_map_cols NUMBER;
3854: l_index NUMBER;
3855: BEGIN
3856: l_stmt :=

Line 3960: IF edw_owb_collection_util.get_item_set_cols (

3956: RETURN FALSE;
3957: END IF;
3958:
3959: --get the skipped fks
3960: IF edw_owb_collection_util.get_item_set_cols (
3961: l_skipped_cols,
3962: l_number_skipped_cols,
3963: p_fact_name,
3964: 'SKIP_LOAD_SET'

Line 3991: l_dimTableName EDW_OWB_COLLECTION_UTIL.varcharTableType;

3987: l_factTableId number;
3988: l_factTableName varchar2(200);
3989: l_fstgPKName varchar2(200);
3990: l_factPKName varchar2(200);
3991: l_dimTableName EDW_OWB_COLLECTION_UTIL.varcharTableType;
3992: l_dim_row_count EDW_OWB_COLLECTION_UTIL.numberTableType;
3993: l_dimTableId EDW_OWB_COLLECTION_UTIL.numberTableType;
3994: l_dimUserPKName EDW_OWB_COLLECTION_UTIL.varcharTableType;
3995: begin

Line 3992: l_dim_row_count EDW_OWB_COLLECTION_UTIL.numberTableType;

3988: l_factTableName varchar2(200);
3989: l_fstgPKName varchar2(200);
3990: l_factPKName varchar2(200);
3991: l_dimTableName EDW_OWB_COLLECTION_UTIL.varcharTableType;
3992: l_dim_row_count EDW_OWB_COLLECTION_UTIL.numberTableType;
3993: l_dimTableId EDW_OWB_COLLECTION_UTIL.numberTableType;
3994: l_dimUserPKName EDW_OWB_COLLECTION_UTIL.varcharTableType;
3995: begin
3996: --fix for bug 2847694

Line 3993: l_dimTableId EDW_OWB_COLLECTION_UTIL.numberTableType;

3989: l_fstgPKName varchar2(200);
3990: l_factPKName varchar2(200);
3991: l_dimTableName EDW_OWB_COLLECTION_UTIL.varcharTableType;
3992: l_dim_row_count EDW_OWB_COLLECTION_UTIL.numberTableType;
3993: l_dimTableId EDW_OWB_COLLECTION_UTIL.numberTableType;
3994: l_dimUserPKName EDW_OWB_COLLECTION_UTIL.varcharTableType;
3995: begin
3996: --fix for bug 2847694
3997: l_stmt:='select mapping_id '||

Line 3994: l_dimUserPKName EDW_OWB_COLLECTION_UTIL.varcharTableType;

3990: l_factPKName varchar2(200);
3991: l_dimTableName EDW_OWB_COLLECTION_UTIL.varcharTableType;
3992: l_dim_row_count EDW_OWB_COLLECTION_UTIL.numberTableType;
3993: l_dimTableId EDW_OWB_COLLECTION_UTIL.numberTableType;
3994: l_dimUserPKName EDW_OWB_COLLECTION_UTIL.varcharTableType;
3995: begin
3996: --fix for bug 2847694
3997: l_stmt:='select mapping_id '||
3998: 'from edw_pvt_map_properties_md_v,edw_relations_md_v '||

Line 4006: if EDW_OWB_COLLECTION_UTIL.get_stg_map_pk_params(

4002: write_to_log_n(l_stmt||' '||p_fact_name);
4003: end if;
4004: open cv for l_stmt using p_fact_name;
4005: fetch cv into l_mapping_id;
4006: if EDW_OWB_COLLECTION_UTIL.get_stg_map_pk_params(
4007: l_mapping_id,
4008: l_fstgTableUsageId,
4009: l_fstgTableId,
4010: l_fstgTableName,

Line 4020: if EDW_OWB_COLLECTION_UTIL.get_stg_map_fk_details(

4016: )=false then
4017: return false;
4018: end if;
4019: --4063140. we now pass null for job id.
4020: if EDW_OWB_COLLECTION_UTIL.get_stg_map_fk_details(
4021: l_fstgTableUsageId,
4022: l_fstgTableId,
4023: l_mapping_id,
4024: null,

Line 4054: IF edw_owb_collection_util.value_in_table (

4050: g_number_fstg_fk := 0;
4051:
4052: FOR i IN 1 .. l_number_map_cols
4053: LOOP
4054: IF edw_owb_collection_util.value_in_table (
4055: l_skipped_cols,
4056: l_number_skipped_cols,
4057: l_map_tgt_col (i)
4058: ) = FALSE

Line 4061: edw_owb_collection_util.index_in_table (

4057: l_map_tgt_col (i)
4058: ) = FALSE
4059: THEN
4060: l_index :=
4061: edw_owb_collection_util.index_in_table (
4062: l_fstg_fk,
4063: l_number_fstg_fk,
4064: l_map_src_col (i)
4065: );

Line 4082: edw_owb_collection_util.get_instance_col (g_fstg_name);

4078: END LOOP;
4079:
4080: --get the instance column
4081: g_fstg_instance_col :=
4082: edw_owb_collection_util.get_instance_col (g_fstg_name);
4083:
4084: IF edw_owb_collection_util.value_in_table (
4085: g_fstg_fk,
4086: g_number_fstg_fk,

Line 4084: IF edw_owb_collection_util.value_in_table (

4080: --get the instance column
4081: g_fstg_instance_col :=
4082: edw_owb_collection_util.get_instance_col (g_fstg_name);
4083:
4084: IF edw_owb_collection_util.value_in_table (
4085: g_fstg_fk,
4086: g_number_fstg_fk,
4087: g_fstg_instance_col
4088: ) = FALSE

Line 4092: edw_owb_collection_util.index_in_table (

4088: ) = FALSE
4089: THEN
4090: l_index := NULL;
4091: l_index :=
4092: edw_owb_collection_util.index_in_table (
4093: l_fstg_fk,
4094: l_number_fstg_fk,
4095: g_fstg_instance_col
4096: );

Line 4123: IF edw_owb_collection_util.value_in_table (

4119: IF g_number_fk_to_check > 0
4120: THEN
4121: FOR i IN 1 .. g_number_fstg_fk
4122: LOOP
4123: IF edw_owb_collection_util.value_in_table (
4124: g_fk_to_check,
4125: g_number_fk_to_check,
4126: g_fstg_fk (i)
4127: )

Line 4367: IF edw_owb_collection_util.drop_table (g_fact_pk_table) = FALSE

4363: || g_fstg_pk
4364: || ',row_id from '
4365: || g_fk_table;
4366:
4367: IF edw_owb_collection_util.drop_table (g_fact_pk_table) = FALSE
4368: THEN
4369: NULL;
4370: END IF;
4371:

Line 4394: edw_owb_collection_util.analyze_table_stats (

4390: || get_time
4391: );
4392: END IF;
4393:
4394: edw_owb_collection_util.analyze_table_stats (
4395: SUBSTR (
4396: g_fact_pk_table,
4397: INSTR (g_fact_pk_table, '.')
4398: + 1,

Line 4422: l_dup_str edw_owb_collection_util.varchartabletype;

4418: TYPE curtyp IS REF CURSOR;
4419:
4420: cv curtyp;
4421: l_num_dup NUMBER := 0;
4422: l_dup_str edw_owb_collection_util.varchartabletype;
4423: l_dup_count edw_owb_collection_util.numbertabletype;
4424: l_number_dup_str NUMBER;
4425: BEGIN
4426: IF g_debug

Line 4423: l_dup_count edw_owb_collection_util.numbertabletype;

4419:
4420: cv curtyp;
4421: l_num_dup NUMBER := 0;
4422: l_dup_str edw_owb_collection_util.varchartabletype;
4423: l_dup_count edw_owb_collection_util.numbertabletype;
4424: l_number_dup_str NUMBER;
4425: BEGIN
4426: IF g_debug
4427: THEN

Line 4462: IF edw_owb_collection_util.drop_table (g_fact_dup_pk_table) = FALSE

4458: || g_fstg_pk
4459: || ')>1 group by '
4460: || g_fstg_pk;
4461:
4462: IF edw_owb_collection_util.drop_table (g_fact_dup_pk_table) = FALSE
4463: THEN
4464: NULL;
4465: END IF;
4466:

Line 4500: --EDW_OWB_COLLECTION_UTIL.analyze_table_stats(substr(g_fact_dup_pk_table,instr(g_fact_dup_pk_table,'.')+1,

4496: --write_to_out_log_n('No Duplicate records found');
4497: RETURN TRUE;
4498: END IF;
4499:
4500: --EDW_OWB_COLLECTION_UTIL.analyze_table_stats(substr(g_fact_dup_pk_table,instr(g_fact_dup_pk_table,'.')+1,
4501: --length(g_fact_dup_pk_table)),substr(g_fact_dup_pk_table,1,instr(g_fact_dup_pk_table,'.')-1));
4502: --write_to_out_log_n('Number of duplicate records in interface table '||l_num_dup);
4503:
4504: l_stmt := 'select sum(dup_count) from '

Line 4627: IF edw_owb_collection_util.drop_table (g_fact_dup_pk_table) = FALSE

4623:
4624: write_to_out (' ');
4625: END IF;
4626:
4627: IF edw_owb_collection_util.drop_table (g_fact_dup_pk_table) = FALSE
4628: THEN
4629: NULL;
4630: END IF;
4631:

Line 4647: IF edw_owb_collection_util.drop_table (g_fact_fk_table (i)) = FALSE

4643: IS
4644: BEGIN
4645: FOR i IN 1 .. g_number_fstg_fk
4646: LOOP
4647: IF edw_owb_collection_util.drop_table (g_fact_fk_table (i)) = FALSE
4648: THEN
4649: NULL;
4650: END IF;
4651: END LOOP;

Line 4666: IF edw_owb_collection_util.drop_table (g_fact_pk_table) = FALSE

4662: FUNCTION drop_fstg_pk_table (p_fact_name IN VARCHAR2)
4663: RETURN BOOLEAN
4664: IS
4665: BEGIN
4666: IF edw_owb_collection_util.drop_table (g_fact_pk_table) = FALSE
4667: THEN
4668: NULL;
4669: END IF;
4670:

Line 4684: IF edw_owb_collection_util.drop_table (g_fk_table) = FALSE

4680: FUNCTION drop_fk_table (p_fact_name IN VARCHAR2)
4681: RETURN BOOLEAN
4682: IS
4683: BEGIN
4684: IF edw_owb_collection_util.drop_table (g_fk_table) = FALSE
4685: THEN
4686: NULL;
4687: END IF;
4688:

Line 4746: IF edw_owb_collection_util.drop_table (g_fact_fk_table (i)) = FALSE

4742: || '.rowid='
4743: || g_fact_pk_table
4744: || '.row_id';
4745:
4746: IF edw_owb_collection_util.drop_table (g_fact_fk_table (i)) = FALSE
4747: THEN
4748: NULL;
4749: END IF;
4750:

Line 4773: edw_owb_collection_util.analyze_table_stats (

4769: || get_time
4770: );
4771: END IF;
4772:
4773: edw_owb_collection_util.analyze_table_stats (
4774: SUBSTR (
4775: g_fact_fk_table (i),
4776: INSTR (g_fact_fk_table (i), '.')
4777: + 1,

Line 4807: l_dang_str edw_owb_collection_util.varchartabletype;

4803: TYPE curtyp IS REF CURSOR;
4804:
4805: cv curtyp;
4806: l_num_dang NUMBER;
4807: l_dang_str edw_owb_collection_util.varchartabletype;
4808: l_dang_count edw_owb_collection_util.numbertabletype;
4809: l_dang_instance edw_owb_collection_util.varchartabletype;
4810: l_number_dang_str NUMBER;
4811: l_fk_ok_number NUMBER;

Line 4808: l_dang_count edw_owb_collection_util.numbertabletype;

4804:
4805: cv curtyp;
4806: l_num_dang NUMBER;
4807: l_dang_str edw_owb_collection_util.varchartabletype;
4808: l_dang_count edw_owb_collection_util.numbertabletype;
4809: l_dang_instance edw_owb_collection_util.varchartabletype;
4810: l_number_dang_str NUMBER;
4811: l_fk_ok_number NUMBER;
4812: BEGIN

Line 4809: l_dang_instance edw_owb_collection_util.varchartabletype;

4805: cv curtyp;
4806: l_num_dang NUMBER;
4807: l_dang_str edw_owb_collection_util.varchartabletype;
4808: l_dang_count edw_owb_collection_util.numbertabletype;
4809: l_dang_instance edw_owb_collection_util.varchartabletype;
4810: l_number_dang_str NUMBER;
4811: l_fk_ok_number NUMBER;
4812: BEGIN
4813: fnd_message.set_name ('BIS', 'EDW_CDI_DANGLING_CHECK');

Line 4871: IF edw_owb_collection_util.drop_table (g_fact_fk_ok_table (i)) =

4867: || g_fk_table
4868: || '.'
4869: || g_fstg_fk (i);
4870:
4871: IF edw_owb_collection_util.drop_table (g_fact_fk_ok_table (i)) =
4872: FALSE
4873: THEN
4874: NULL;
4875: END IF;

Line 4899: edw_owb_collection_util.analyze_table_stats (

4895: || get_time
4896: );
4897: END IF;
4898:
4899: edw_owb_collection_util.analyze_table_stats (
4900: SUBSTR (
4901: g_fact_fk_ok_table (i),
4902: INSTR (g_fact_fk_ok_table (i), '.')
4903: + 1,

Line 4986: IF edw_owb_collection_util.drop_table (

4982: || g_fact_pk_table
4983: || ' MINUS select row_id from '
4984: || g_fact_fk_ok_table (i);
4985:
4986: IF edw_owb_collection_util.drop_table (
4987: g_fact_fk_dang_rowid_table (i)
4988: ) = FALSE
4989: THEN
4990: NULL;

Line 5016: edw_owb_collection_util.analyze_table_stats (

5012: || get_time
5013: );
5014: END IF;
5015:
5016: edw_owb_collection_util.analyze_table_stats (
5017: SUBSTR (
5018: g_fact_fk_dang_rowid_table (i),
5019: INSTR (g_fact_fk_dang_rowid_table (i), '.')
5020: + 1,

Line 5151: IF edw_owb_collection_util.drop_table (

5147: THEN
5148: write_to_log_n (get_time);
5149: END IF;
5150:
5151: IF edw_owb_collection_util.drop_table (
5152: g_fact_fk_dang_rowid_table (i)
5153: ) = FALSE
5154: THEN
5155: NULL;

Line 5161: IF edw_owb_collection_util.drop_table (g_fact_fk_ok_table (i)) =

5157: END IF; --if g_sample_on
5158: END IF;
5159:
5160: --create the dang rowid table
5161: IF edw_owb_collection_util.drop_table (g_fact_fk_ok_table (i)) =
5162: FALSE
5163: THEN
5164: NULL;
5165: END IF;

Line 5273: l_owner := edw_owb_collection_util.get_table_owner (g_fstg_name);

5269: l_stmt VARCHAR2 (30000);
5270: l_owner VARCHAR2 (400);
5271: l_col VARCHAR2 (400);
5272: BEGIN
5273: l_owner := edw_owb_collection_util.get_table_owner (g_fstg_name);
5274: g_fk_table := g_bis_owner
5275: || '.'
5276: || SUBSTR (p_fact_name, 1, 26)
5277: || 'CS';

Line 5279: IF edw_owb_collection_util.drop_table (g_fk_table) = FALSE

5275: || '.'
5276: || SUBSTR (p_fact_name, 1, 26)
5277: || 'CS';
5278:
5279: IF edw_owb_collection_util.drop_table (g_fk_table) = FALSE
5280: THEN
5281: NULL;
5282: END IF;
5283:

Line 5284: IF edw_owb_collection_util.does_table_have_data (

5280: THEN
5281: NULL;
5282: END IF;
5283:
5284: IF edw_owb_collection_util.does_table_have_data (
5285: g_fstg_name,
5286: 'LAST_UPDATE_DATE IS NOT NULL'
5287: ) = 2
5288: THEN

Line 5376: edw_owb_collection_util.analyze_table_stats (

5372: g_status_message := SQLERRM;
5373: RETURN FALSE;
5374: END;
5375:
5376: edw_owb_collection_util.analyze_table_stats (
5377: SUBSTR (g_fk_table, INSTR (g_fk_table, '.')
5378: + 1, LENGTH (g_fk_table)),
5379: SUBSTR (g_fk_table, 1, INSTR (g_fk_table, '.')
5380: - 1)

Line 5394: IF edw_owb_collection_util.drop_table (g_fk_table) = FALSE

5390:
5391: PROCEDURE clean_up
5392: IS
5393: BEGIN
5394: IF edw_owb_collection_util.drop_table (g_fk_table) = FALSE
5395: THEN
5396: NULL;
5397: END IF;
5398: EXCEPTION

Line 5502: IF edw_owb_collection_util.log_into_cdi_results_table (

5498: )
5499: RETURN BOOLEAN
5500: IS
5501: BEGIN
5502: IF edw_owb_collection_util.log_into_cdi_results_table (
5503: p_object,
5504: p_object_type,
5505: p_object_id,
5506: p_interface_table,

Line 5596: l_table_id := edw_owb_collection_util.get_object_id (p_object_name);

5592: END IF;
5593:
5594: EXECUTE IMMEDIATE l_stmt USING p_object_name;
5595: COMMIT;
5596: l_table_id := edw_owb_collection_util.get_object_id (p_object_name);
5597: l_stmt := 'delete edw_cdi_dim_missing_keys where fact_id=:a';
5598:
5599: IF g_debug
5600: THEN

Line 5632: IF edw_owb_collection_util.log_into_cdi_dang_table (

5628: )
5629: RETURN BOOLEAN
5630: IS
5631: BEGIN
5632: IF edw_owb_collection_util.log_into_cdi_dang_table (
5633: p_key_id,
5634: p_table_id,
5635: p_parent_table_id,
5636: p_key_value,

Line 5713: IF edw_owb_collection_util.drop_table (g_dim_missing_keys_op) = FALSE

5709: || p_object_name
5710: || ''' '
5711: || 'group by A.parent_table_id,B.key_value,B.instance ';
5712:
5713: IF edw_owb_collection_util.drop_table (g_dim_missing_keys_op) = FALSE
5714: THEN
5715: NULL;
5716: END IF;
5717:

Line 5740: edw_owb_collection_util.analyze_table_stats (

5736: || get_time
5737: );
5738: END IF;
5739:
5740: edw_owb_collection_util.analyze_table_stats (
5741: SUBSTR (
5742: g_dim_missing_keys_op,
5743: INSTR (g_dim_missing_keys_op, '.')
5744: + 1,

Line 5771: l_dang_dim edw_owb_collection_util.varchartabletype;

5767:
5768: TYPE curtyp IS REF CURSOR;
5769:
5770: cv curtyp;
5771: l_dang_dim edw_owb_collection_util.varchartabletype;
5772: l_dang_dim_id edw_owb_collection_util.numbertabletype;
5773: l_number_dang_dim NUMBER;
5774: l_fact_id NUMBER;
5775: l_instances edw_owb_collection_util.varchartabletype;

Line 5772: l_dang_dim_id edw_owb_collection_util.numbertabletype;

5768: TYPE curtyp IS REF CURSOR;
5769:
5770: cv curtyp;
5771: l_dang_dim edw_owb_collection_util.varchartabletype;
5772: l_dang_dim_id edw_owb_collection_util.numbertabletype;
5773: l_number_dang_dim NUMBER;
5774: l_fact_id NUMBER;
5775: l_instances edw_owb_collection_util.varchartabletype;
5776: l_instances_name edw_owb_collection_util.l_varchartabletype;

Line 5775: l_instances edw_owb_collection_util.varchartabletype;

5771: l_dang_dim edw_owb_collection_util.varchartabletype;
5772: l_dang_dim_id edw_owb_collection_util.numbertabletype;
5773: l_number_dang_dim NUMBER;
5774: l_fact_id NUMBER;
5775: l_instances edw_owb_collection_util.varchartabletype;
5776: l_instances_name edw_owb_collection_util.l_varchartabletype;
5777: l_wh_apps_links edw_owb_collection_util.varchartabletype;
5778: l_number_instances NUMBER;
5779: l_dang_dim_instance_id edw_owb_collection_util.numbertabletype;

Line 5776: l_instances_name edw_owb_collection_util.l_varchartabletype;

5772: l_dang_dim_id edw_owb_collection_util.numbertabletype;
5773: l_number_dang_dim NUMBER;
5774: l_fact_id NUMBER;
5775: l_instances edw_owb_collection_util.varchartabletype;
5776: l_instances_name edw_owb_collection_util.l_varchartabletype;
5777: l_wh_apps_links edw_owb_collection_util.varchartabletype;
5778: l_number_instances NUMBER;
5779: l_dang_dim_instance_id edw_owb_collection_util.numbertabletype;
5780: --which dims in which instances have dang values

Line 5777: l_wh_apps_links edw_owb_collection_util.varchartabletype;

5773: l_number_dang_dim NUMBER;
5774: l_fact_id NUMBER;
5775: l_instances edw_owb_collection_util.varchartabletype;
5776: l_instances_name edw_owb_collection_util.l_varchartabletype;
5777: l_wh_apps_links edw_owb_collection_util.varchartabletype;
5778: l_number_instances NUMBER;
5779: l_dang_dim_instance_id edw_owb_collection_util.numbertabletype;
5780: --which dims in which instances have dang values
5781: l_dang_instances edw_owb_collection_util.varchartabletype;

Line 5779: l_dang_dim_instance_id edw_owb_collection_util.numbertabletype;

5775: l_instances edw_owb_collection_util.varchartabletype;
5776: l_instances_name edw_owb_collection_util.l_varchartabletype;
5777: l_wh_apps_links edw_owb_collection_util.varchartabletype;
5778: l_number_instances NUMBER;
5779: l_dang_dim_instance_id edw_owb_collection_util.numbertabletype;
5780: --which dims in which instances have dang values
5781: l_dang_instances edw_owb_collection_util.varchartabletype;
5782: --the instances where dims have dang
5783: l_number_dang_instances NUMBER;

Line 5781: l_dang_instances edw_owb_collection_util.varchartabletype;

5777: l_wh_apps_links edw_owb_collection_util.varchartabletype;
5778: l_number_instances NUMBER;
5779: l_dang_dim_instance_id edw_owb_collection_util.numbertabletype;
5780: --which dims in which instances have dang values
5781: l_dang_instances edw_owb_collection_util.varchartabletype;
5782: --the instances where dims have dang
5783: l_number_dang_instances NUMBER;
5784: l_index NUMBER;
5785: l_fact_list VARCHAR2 (1000);

Line 5925: l_fact_id := edw_owb_collection_util.get_object_id (p_fact);

5921: );
5922: END LOOP;
5923: END IF;
5924:
5925: l_fact_id := edw_owb_collection_util.get_object_id (p_fact);
5926:
5927: FOR j IN 1 .. l_number_dang_instances
5928: LOOP
5929: l_index :=

Line 5930: edw_owb_collection_util.index_in_table (

5926:
5927: FOR j IN 1 .. l_number_dang_instances
5928: LOOP
5929: l_index :=
5930: edw_owb_collection_util.index_in_table (
5931: l_instances,
5932: l_number_instances,
5933: l_dang_instances (j)
5934: );

Line 6010: IF edw_owb_collection_util.drop_table (g_dim_missing_keys_op) = FALSE

6006: END IF;
6007: --if l_status=0 then do not pass this dim for checking error tables
6008: END LOOP;
6009:
6010: IF edw_owb_collection_util.drop_table (g_dim_missing_keys_op) = FALSE
6011: THEN
6012: NULL;
6013: END IF;
6014:

Line 6061: l_view := edw_owb_collection_util.get_pk_view (p_dim, p_instance_link);

6057: l_min_date DATE;
6058: l_max_date DATE;
6059: l_long_name VARCHAR2 (400);
6060: BEGIN
6061: l_view := edw_owb_collection_util.get_pk_view (p_dim, p_instance_link);
6062: l_long_name := edw_owb_collection_util.get_logical_name (p_dim_id);
6063:
6064: IF l_view IS NULL
6065: THEN

Line 6062: l_long_name := edw_owb_collection_util.get_logical_name (p_dim_id);

6058: l_max_date DATE;
6059: l_long_name VARCHAR2 (400);
6060: BEGIN
6061: l_view := edw_owb_collection_util.get_pk_view (p_dim, p_instance_link);
6062: l_long_name := edw_owb_collection_util.get_logical_name (p_dim_id);
6063:
6064: IF l_view IS NULL
6065: THEN
6066: --write_to_out_n('Dimension '||l_long_name);

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

6203: || ' and A.instance='''
6204: || p_instance
6205: || ''' and B.dim_pk=A.key_value';
6206:
6207: IF edw_owb_collection_util.drop_table (l_table) = FALSE
6208: THEN
6209: NULL;
6210: END IF;
6211:

Line 6310: p_dang_dim_instance_id IN edw_owb_collection_util.numbertabletype,

6306: p_fact IN VARCHAR2,
6307: p_fact_id IN NUMBER,
6308: p_dang_dim IN VARCHAR2,
6309: p_dang_dim_id IN NUMBER,
6310: p_dang_dim_instance_id IN edw_owb_collection_util.numbertabletype,
6311: p_dang_instances IN edw_owb_collection_util.varchartabletype,
6312: p_number_dang_instances IN NUMBER
6313: )
6314: RETURN NUMBER

Line 6311: p_dang_instances IN edw_owb_collection_util.varchartabletype,

6307: p_fact_id IN NUMBER,
6308: p_dang_dim IN VARCHAR2,
6309: p_dang_dim_id IN NUMBER,
6310: p_dang_dim_instance_id IN edw_owb_collection_util.numbertabletype,
6311: p_dang_instances IN edw_owb_collection_util.varchartabletype,
6312: p_number_dang_instances IN NUMBER
6313: )
6314: RETURN NUMBER
6315: IS

Line 6317: l_tables edw_owb_collection_util.varchartabletype;

6313: )
6314: RETURN NUMBER
6315: IS
6316: l_stmt VARCHAR2 (20000);
6317: l_tables edw_owb_collection_util.varchartabletype;
6318: l_number_tables NUMBER;
6319: l_op_table VARCHAR2 (200);
6320: l_rowid_table VARCHAR2 (200);
6321: l_bad_table VARCHAR2 (200);

Line 6368: IF edw_owb_collection_util.check_table (

6364: || p_fact_id
6365: || '_'
6366: || p_dang_dim_id;
6367:
6368: IF edw_owb_collection_util.check_table (
6369: l_tables (l_number_tables)
6370: ) = FALSE
6371: THEN
6372: l_number_tables := l_number_tables

Line 6418: IF edw_owb_collection_util.drop_table (l_op_table) = FALSE

6414:
6415: l_stmt := SUBSTR (l_stmt, 1, LENGTH (l_stmt)
6416: - 10);
6417:
6418: IF edw_owb_collection_util.drop_table (l_op_table) = FALSE
6419: THEN
6420: NULL;
6421: END IF;
6422:

Line 6466: IF edw_owb_collection_util.drop_table (l_rowid_table) = FALSE

6462: || p_dang_dim_id
6463: || ' MINUS select row_id from '
6464: || l_op_table;
6465:
6466: IF edw_owb_collection_util.drop_table (l_rowid_table) = FALSE
6467: THEN
6468: NULL;
6469: END IF;
6470:

Line 6492: IF edw_owb_collection_util.drop_table (l_op_table) = FALSE

6488: || get_time
6489: );
6490: END IF;
6491:
6492: IF edw_owb_collection_util.drop_table (l_op_table) = FALSE
6493: THEN
6494: NULL;
6495: END IF;
6496:

Line 6526: IF edw_owb_collection_util.drop_table (l_bad_table) = FALSE

6522: || l_stmt
6523: || get_time);
6524: END IF;
6525:
6526: IF edw_owb_collection_util.drop_table (l_bad_table) = FALSE
6527: THEN
6528: NULL;
6529: END IF;
6530:

Line 6545: IF edw_owb_collection_util.drop_table (l_rowid_table) = FALSE

6541: || get_time
6542: );
6543: END IF;
6544:
6545: IF edw_owb_collection_util.drop_table (l_rowid_table) = FALSE
6546: THEN
6547: NULL;
6548: END IF;
6549:

Line 6552: IF edw_owb_collection_util.drop_table (l_tables (i)) = FALSE

6548: END IF;
6549:
6550: FOR i IN 1 .. l_number_tables
6551: LOOP
6552: IF edw_owb_collection_util.drop_table (l_tables (i)) = FALSE
6553: THEN
6554: NULL;
6555: END IF;
6556: END LOOP;