DBA Data[Home] [Help]

APPS.EDW_COLLECTION_UTIL dependencies on USER_TABLES

Line 10: g_staging_table user_tables.table_name%TYPE;

6: g_target_link fnd_profile_option_values.profile_option_value%TYPE;
7: g_source_same_as_target BOOLEAN;
8: g_debug BOOLEAN;
9: g_parallel PLS_INTEGER;
10: g_staging_table user_tables.table_name%TYPE;
11: g_rbs user_segments.segment_name%TYPE;
12: g_op_tablespace user_tablespaces.tablespace_name%TYPE;
13: g_bis_schema user_users.username%TYPE;
14: tab_stglist tablist_type;

Line 12: g_op_tablespace user_tablespaces.tablespace_name%TYPE;

8: g_debug BOOLEAN;
9: g_parallel PLS_INTEGER;
10: g_staging_table user_tables.table_name%TYPE;
11: g_rbs user_segments.segment_name%TYPE;
12: g_op_tablespace user_tablespaces.tablespace_name%TYPE;
13: g_bis_schema user_users.username%TYPE;
14: tab_stglist tablist_type;
15: g_transport_data BOOLEAN;
16:

Line 1432: l_stgtbl_name user_tables.table_name%TYPE;

1428: l_count PLS_INTEGER := 0;
1429: l_num PLS_INTEGER := 0;
1430: l_rowcount PLS_INTEGER := 0;
1431: cv curtyp;
1432: l_stgtbl_name user_tables.table_name%TYPE;
1433: l_total_rows PLS_INTEGER := 0;
1434: BEGIN
1435: put_debug_msg ('********** Start Function : set_status_ready');
1436:

Line 1704: l_tmp_table_name user_tables.table_name%TYPE;

1700:
1701: PROCEDURE clean_up (p_tab_list IN tablist_type, suffix IN VARCHAR2)
1702: IS
1703: dummy PLS_INTEGER;
1704: l_tmp_table_name user_tables.table_name%TYPE;
1705: l_suffix_length VARCHAR2 (20);
1706:
1707: CURSOR c_check_tbl (p_tbl_name IN VARCHAR2)
1708: IS

Line 1871: l_tmptbl_name user_tables.table_name%TYPE;

1867: l_rowcount INTEGER := 0;
1868: l_count INTEGER := 0;
1869: l_colcount PLS_INTEGER := 0;
1870: l_pushcount PLS_INTEGER := 0;
1871: l_tmptbl_name user_tables.table_name%TYPE;
1872: l_stgtbl_name user_tables.table_name%TYPE;
1873: l_optbl_name user_tables.table_name%TYPE;
1874: l_stg_owner user_users.username%TYPE;
1875: l_stg_initial_extent PLS_INTEGER := 0;

Line 1872: l_stgtbl_name user_tables.table_name%TYPE;

1868: l_count INTEGER := 0;
1869: l_colcount PLS_INTEGER := 0;
1870: l_pushcount PLS_INTEGER := 0;
1871: l_tmptbl_name user_tables.table_name%TYPE;
1872: l_stgtbl_name user_tables.table_name%TYPE;
1873: l_optbl_name user_tables.table_name%TYPE;
1874: l_stg_owner user_users.username%TYPE;
1875: l_stg_initial_extent PLS_INTEGER := 0;
1876: l_stg_next_extent PLS_INTEGER := 0;

Line 1873: l_optbl_name user_tables.table_name%TYPE;

1869: l_colcount PLS_INTEGER := 0;
1870: l_pushcount PLS_INTEGER := 0;
1871: l_tmptbl_name user_tables.table_name%TYPE;
1872: l_stgtbl_name user_tables.table_name%TYPE;
1873: l_optbl_name user_tables.table_name%TYPE;
1874: l_stg_owner user_users.username%TYPE;
1875: l_stg_initial_extent PLS_INTEGER := 0;
1876: l_stg_next_extent PLS_INTEGER := 0;
1877: l_partitioned_table user_tables.partitioned%TYPE; -- added for bug 4300166

Line 1877: l_partitioned_table user_tables.partitioned%TYPE; -- added for bug 4300166

1873: l_optbl_name user_tables.table_name%TYPE;
1874: l_stg_owner user_users.username%TYPE;
1875: l_stg_initial_extent PLS_INTEGER := 0;
1876: l_stg_next_extent PLS_INTEGER := 0;
1877: l_partitioned_table user_tables.partitioned%TYPE; -- added for bug 4300166
1878: BEGIN
1879: put_debug_msg ('********** Start Procedure : push_to_target');
1880: put_timestamp;
1881: