APPS.IGI_SLS_UPG_PKG SQL Statements

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

Line: 31

         INSERT INTO igi_sls_upg_itf(SELECT a.table_name, a.owner , a.sls_table_name, NULL,NULL,NULL,get_sls_grps(a.table_name),NULL,NULL
            FROM igi_sls_secure_tables a
            WHERE a.table_name IN( 'PO_VENDORS','PO_VENDOR_CONTACTS', 'PO_VENDOR_SITES_ALL')
            AND  A.table_name NOT IN (SELECT old_table_name FROM igi_sls_upg_itf)
            AND  a.table_name IN (SELECT sls_allocation FROM igi_sls_allocations));

Line: 44

         SELECT distinct old_table_name  BULK COLLECT INTO l_list
         FROM igi_sls_upg_itf ORDER BY old_table_name;

Line: 56

         SELECT new_table_name  BULK COLLECT INTO l_list FROM igi_sls_upg_itf ORDER BY new_table_name;

Line: 69

         SELECT COUNT(*) INTO l_count FROM igi_sls_allocations WHERE sls_allocation = p_table_name  ;

Line: 72

    	  (SELECT sls_group  FROM igi_sls_allocations WHERE sls_allocation = p_table_name)
    	 LOOP
    		IF l_count=1 THEN
    			l_dummy:= l_dummy || sec_grp_rec.sls_group;

Line: 103

          SELECT sls_groups INTO param2(indx) FROM igi_sls_upg_itf WHERE  old_table_name=param1(indx);

Line: 125

             write_to_log (l_excep_level, 'set_sls_tables_data','Error in insertion... Please note.. :)' );

Line: 152

            SELECT COUNT(*) INTO l_count FROM igi_sls_secure_tables WHERE table_name =l_table_name ;

Line: 158

           /** First select the owner of this table **/
            SELECT owner INTO l_owner FROM all_objects WHERE object_name=UPPER(l_table_name)
                     AND object_type='TABLE' AND owner IN('AP', 'AR', 'PO', 'XLA','ICX','IBY');

Line: 164

            SELECT 'IGI_SLS_' || TO_CHAR(igi_sls_extended_table_s.nextval)
               INTO   l_sls_table_name  FROM   dual;

Line: 170

            SELECT OPTIMISE_SQL    INTO l_optimise_sql FROM igi_sls_secure_tables WHERE table_name =l_old_table_name;

Line: 174

            write_to_log (l_excep_level, 'set_sls_tables_data','Before insert' );

Line: 176

            /* insert statement... core to this procedure..*/
            INSERT INTO igi_sls_secure_tables(owner, table_name, sls_table_name, update_allowed, creation_date, created_by,
            last_update_login,last_update_date, last_updated_by, optimise_sql) VALUES(l_owner, l_table_name,l_sls_table_name, 'N', sysdate,1,1,sysdate,1, l_optimise_sql );

Line: 180

              write_to_log (l_excep_level, 'set_sls_tables_data','After Insert..' ||SQL%ROWCOUNT ||'row inserted');

Line: 182

             UPDATE igi_sls_upg_itf SET new_table_name=l_table_name,new_owner=l_owner, new_allocation=l_sls_table_name WHERE old_table_name = l_old_table_name;

Line: 214

            SELECT ROWID BULK COLLECT INTO l_list FROM igi_sls_allocations WHERE sls_allocation =l_old_table_name;

Line: 219

            SELECT sls_group INTO l_sls_group FROM igi_sls_allocations WHERE ROWID=l_rowid;

Line: 222

            SELECT COUNT(*) INTO l_count  FROM igi_sls_allocations WHERE sls_group=l_sls_group
            AND sls_allocation = l_table_name;

Line: 225

            /** Insert only if the entry is not present.. */
            IF(l_count =0)THEN
            INSERT INTO igi_sls_allocations (SELECT SLS_GROUP ,SLS_GROUP_TYPE ,l_table_name ,SLS_ALLOCATION_TYPE,
            SYSDATE ,null,null,null,SYSDATE ,CREATED_BY,1,sysdate,1 FROM
            igi_sls_allocations WHERE ROWID=l_rowid) ;

Line: 246

        update igi_sls_secure_tables set table_name='PO_VENDORS_OBS'
                                                        where table_name='PO_VENDORS';

Line: 248

        update igi_sls_secure_tables set table_name='PO_VENDOR_CONTACTS_OBS'
                                                        where table_name='PO_VENDOR_CONTACTS';

Line: 250

        update igi_sls_secure_tables set table_name='PO_VENDOR_SITES_OBS'
                                                        where table_name='PO_VENDOR_SITES_ALL';

Line: 252

        update igi_sls_allocations set sls_allocation='PO_VENDORS_OBS'
                                                        where sls_allocation='PO_VENDORS';

Line: 254

        update igi_sls_allocations set sls_allocation='PO_VENDOR_CONTACTS_OBS'
                                                        where sls_allocation='PO_VENDOR_CONTACTS';

Line: 256

        update igi_sls_allocations set sls_allocation='PO_VENDOR_SITES_OBS'
                                                        where sls_allocation='PO_VENDOR_SITES_ALL';

Line: 259

        delete from  IGI_GCC_INST_OPTIONS_ALL where OPTION_NAME='SLS';

Line: 272

        UPDATE igi_sls_upg_itf SET from_clause=param2(indx) , where_clause=param3(indx)
            WHERE old_table_name=param1(indx) AND param3(indx) IS NOT NULL;

Line: 275

         write_to_log (l_excep_level, 'set_query_data',SQL%ROWCOUNT ||' rows updated' );

Line: 293

         l_select VARCHAR2(3000);

Line: 301

               SELECT old_allocation, new_allocation INTO l_sls_tab_old, l_sls_tab_new FROM igi_sls_upg_itf
               WHERE old_table_name=param1(indx);

Line: 326

               l_select := ' SELECT DISTINCT b.ROWID , c.SLS_SEC_GRP , ' ||
               ' c.PREV_SLS_SEC_GRP , c.CHANGE_DATE FROM '|| l_from ||  ' WHERE a.ROWID=c.SLS_ROWID AND '|| param4(indx) ||
                ' AND NOT EXISTS (SELECT ''X''' || ' FROM ' || l_sls_tab_new ||' e '|| ' WHERE  b.rowid = e.sls_rowid )';

Line: 330

               write_to_log (l_excep_level, 'migrate_data','Select Statement Executed'||l_select );

Line: 332

               l_query:= ' INSERT INTO '|| l_sls_tab_new ||'(' || l_select ||')';

Line: 339

               INSERT INTO new_allocation( SELECT DISTINCT b.ROWID , c.sls_sec_group,
               c.PREV_SLS_SEC_GRP , c.CHANGE_DATE FROM
               param1(indx) a ,param2(indx) b , old_allocation c
               WHERE a.ROWID=c.row_id) AND param3(indx));

Line: 345

               write_to_log (l_excep_level, 'migrate_data',SQL%ROWCOUNT ||' rows inserted' );

Line: 352

             write_to_log (l_excep_level, 'migrate_data','Error in insertion... Please note.. :)' );