APPS.CZ_IMP_MGR SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 7

PROCEDURE delete_runs(p_run_id_tbl tRunId) IS
 l_schema_owner dba_tables.owner%TYPE := 'CZ';

Line: 14

    SELECT TO_NUMBER(VALUE) INTO CZ_IMP_MGR.BATCH_SIZE
    FROM cz_db_settings
    WHERE UPPER(setting_id)='BATCHSIZE';

Line: 21

   l_tab_name_tbl.DELETE;

Line: 22

   SELECT table_name BULK COLLECT INTO l_tab_name_tbl
   FROM dba_tables
   WHERE table_name like 'CZ_IMP%' AND owner = UPPER(l_schema_owner);

Line: 28

         l_str := 'DELETE FROM '||l_tab_name_tbl(j) || ' WHERE run_id = :1';

Line: 36

       l_str := 'DELETE FROM cz_xfr_run_results WHERE run_id = :1';

Line: 38

       l_str := 'DELETE FROM cz_xfr_run_infos WHERE run_id = :1';

Line: 43

END delete_runs;

Line: 52

   FOR i IN (SELECT table_name FROM dba_tables WHERE table_name like 'CZ_IMP%' AND owner = UPPER(l_schema_owner)) LOOP
     EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema_owner||'.'|| i.table_name;

Line: 76

   l_run_id_tbl.DELETE;

Line: 77

   SELECT run_id BULK COLLECT INTO l_run_id_tbl
   FROM cz_xfr_run_infos
   WHERE TRUNC(started) < (SELECT TRUNC(SYSDATE) - p_days  FROM DUAL);

Line: 81

     delete_runs(l_run_id_tbl);

Line: 103

   l_run_id_tbl.DELETE;

Line: 104

   SELECT run_id BULK COLLECT INTO l_run_id_tbl
   FROM cz_xfr_run_infos
   WHERE run_id <= p_run_id;

Line: 108

     delete_runs(l_run_id_tbl);