APPS.MODIFY_ABM_SEQUENCES SQL Statements

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

Line: 228

    /* This function accepts the ABM table column name , selects it into a temporary variable and increments the value by 5 */

    FUNCTION modify_table_column_by_value ( table_name VARCHAR2, table_column_name VARCHAR2,increment_value NUMBER) RETURN NUMBER IS
    column_holder NUMBER;

Line: 232

    select_statement VARCHAR2(1000);

Line: 235

        select_statement :=  'SELECT NVL(MAX(' || table_column_name || '),0)'
                              ||' FROM ABM.'|| table_name;

Line: 239

 	    EXECUTE IMMEDIATE select_statement INTO column_holder;

Line: 255

    /* This procedure drops the selected sequence and recreates it with
       the input starting value */

    PROCEDURE create_sequence_with_new_value ( sequence_name VARCHAR2, starting_value NUMBER) IS

    sequence_holder VARCHAR2(1000);

Line: 262

    select_statement VARCHAR2(1000);

Line: 270

         	select_statement :=  'SELECT SEQUENCE_NAME '
              ||' FROM ALL_SEQUENCES'
              ||' WHERE SEQUENCE_NAME = '
              ||'''' || sequence_name || ''''
              ||'AND SEQUENCE_OWNER = ' || '''' || 'ABM' || '''';

Line: 277

         	EXECUTE IMMEDIATE select_statement INTO  sequence_holder;