APPS.CZ_IMP_MGR dependencies on DBA_TABLES

Line 5: TYPE tName IS TABLE OF dba_tables.table_name%TYPE INDEX BY BINARY_INTEGER;

1: package body CZ_IMP_MGR as
2: /* $Header: czimngrb.pls 120.0 2005/05/25 06:45:39 appldev noship $ */
3:
4: TYPE tRunId IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
5: TYPE tName IS TABLE OF dba_tables.table_name%TYPE INDEX BY BINARY_INTEGER;
6: -------------------------------------------
7: PROCEDURE delete_runs(p_run_id_tbl tRunId) IS
8: l_schema_owner dba_tables.owner%TYPE := 'CZ';
9: l_str VARCHAR2(2000);

Line 8: l_schema_owner dba_tables.owner%TYPE := 'CZ';

4: TYPE tRunId IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
5: TYPE tName IS TABLE OF dba_tables.table_name%TYPE INDEX BY BINARY_INTEGER;
6: -------------------------------------------
7: PROCEDURE delete_runs(p_run_id_tbl tRunId) IS
8: l_schema_owner dba_tables.owner%TYPE := 'CZ';
9: l_str VARCHAR2(2000);
10: l_tab_name_tbl tName;
11: l_count NUMBER:=0;
12: BEGIN

Line 23: FROM dba_tables

19: NULL;
20: END;
21: l_tab_name_tbl.DELETE;
22: SELECT table_name BULK COLLECT INTO l_tab_name_tbl
23: FROM dba_tables
24: WHERE table_name like 'CZ_IMP%' AND owner = UPPER(l_schema_owner);
25: IF p_run_id_tbl.COUNT > 0 THEN
26: FOR i IN p_run_id_tbl.FIRST..p_run_id_tbl.LAST LOOP
27: FOR j IN l_tab_name_tbl.FIRST..l_tab_name_tbl.LAST LOOP

Line 47: l_schema_owner dba_tables.owner%TYPE := 'CZ';

43: END delete_runs;
44: -------------------------------------------
45: PROCEDURE purge
46: IS
47: l_schema_owner dba_tables.owner%TYPE := 'CZ';
48: l_error BOOLEAN;
49: BEGIN
50: CZ_ADMIN.SPX_SYNC_IMPORTSESSIONS;
51: DBMS_APPLICATION_INFO.SET_MODULE('CZIMPORT','');

Line 52: FOR i IN (SELECT table_name FROM dba_tables WHERE table_name like 'CZ_IMP%' AND owner = UPPER(l_schema_owner)) LOOP

48: l_error BOOLEAN;
49: BEGIN
50: CZ_ADMIN.SPX_SYNC_IMPORTSESSIONS;
51: DBMS_APPLICATION_INFO.SET_MODULE('CZIMPORT','');
52: FOR i IN (SELECT table_name FROM dba_tables WHERE table_name like 'CZ_IMP%' AND owner = UPPER(l_schema_owner)) LOOP
53: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema_owner||'.'|| i.table_name;
54: END LOOP;
55: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema_owner||'.'||'CZ_XFR_RUN_INFOS';
56: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema_owner||'.'||'CZ_XFR_RUN_RESULTS';