APPS.IGI_SLS_IMP_EXP SQL Statements

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

Line: 21

          SELECT  owner,
                  table_name,
                  sls_table_name,
                  date_enabled,
                  date_disabled,
                  date_removed,
                  date_security_applied,
                  update_allowed
          FROM    igi_sls_secure_tables
          WHERE   date_removed IS NULL
          AND     date_object_created IS NOT NULL;

Line: 47

              l_count_rec :=('select count(*) from '||rt_c_get_enab_sectab.sls_table_name);

Line: 64

                 l_sql_str :=('UPDATE '||
                        rt_c_get_enab_sectab.owner||'.'||rt_c_get_enab_sectab.table_name||' a '
                        ||'SET a.igi_sls_sec_group =' ||
                        '(SELECT b.sls_sec_grp from '|| rt_c_get_enab_sectab.sls_table_name||' b '||
                        'WHERE a.rowid = b.sls_rowid) WHERE EXISTS (SELECT '||'''x''' ||' from '
                       || rt_c_get_enab_sectab.sls_table_name||' c where c.sls_rowid = a.rowid)');

Line: 85

                IGI_SLS_IMP_EXP.insert_sls_data(rt_c_get_enab_sectab.sls_table_name,
                                              rt_c_get_enab_sectab.owner,
                                              rt_c_get_enab_sectab.table_name);

Line: 126

PROCEDURE insert_sls_data(sls_tab IN VARCHAR2,schema_name IN VARCHAR2,core_tab in varchar2)IS
l_sql_ins varchar2(300);

Line: 132

     l_sql_ins :=('Insert into '||sls_tab||'(SLS_ROWID,SLS_SEC_GRP) '||
                '(select a.rowid,a.IGI_SLS_SEC_GROUP from '||schema_name||'.'||core_tab||' a'||' where a.IGI_SLS_SEC_GROUP is not null)');

Line: 139

END insert_sls_data;