APPS.HR_LONG2LOB SQL Statements

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

Line: 33

       SELECT 'X'
       INTO dummy
       FROM
	   all_tab_columns
       WHERE owner = l_schema_owner
       AND table_name = p_table_name
       AND column_name = p_col_name
       AND data_type  = p_col_data_type;

Line: 156

               ' SELECT schema_name, table_name, old_column_name,'
            || ' new_column_name, new_data_type, status, '
            || ' action, ROWID '
            || ' FROM ad_long_column_conversions '
            || ' WHERE status = '''
            || ad_longtolob_pkg.g_initialized_status
            || ''''
            || ' AND upper(table_name) = upper('''
            || lp_table_name
            || ''')'
            || ' AND upper(old_column_name) = upper('''
            || lp_old_column_name
            || ''')';

Line: 221

               ' SELECT schema_name, table_name, old_column_name,'
            || ' new_column_name, new_data_type, status, '
            || ' action, ROWID '
            || ' FROM ad_long_column_conversions '
            || ' WHERE status = '''
            || ad_longtolob_pkg.g_add_new_column_status
            || ''''
            || ' and upper(table_name) = upper('''
            || lp_table_name
            || ''')'
            || ' AND upper(old_column_name) = upper('''
            || lp_old_column_name
            || ''')';

Line: 286

               ' SELECT schema_name, table_name, old_column_name,'
            || ' old_data_type, new_column_name, new_data_type, status, '
            || ' action, ROWID '
            || ' FROM ad_long_column_conversions '
            || ' WHERE status IN ('''
            || ad_longtolob_pkg.g_add_trigger_status
            || ''','''|| ad_longtolob_pkg.g_add_new_column_status || ''''
            || ') AND upper(table_name) = upper('''
            || lp_table_name
            || ''')'
            || ' AND upper(old_column_name) = upper('''
            || lp_old_column_name
            || ''')';

Line: 313

                  ad_longtolob_pkg.update_new_data (l_schema,
                                                    l_table_name,
                                                    l_old_column_name,
                                                    l_old_data_type,
                                                    l_new_column_name
                                                   );

Line: 340

            SELECT schema_name, table_name, old_column_name, new_column_name
              FROM ad_long_column_conversions
             WHERE status IN
                      (ad_longtolob_pkg.g_update_rows_status,
                       ad_longtolob_pkg.g_drop_old_column_status
                      )
               AND table_name = cur_p_table_name
               AND old_column_name = cur_old_column_name;

Line: 372

               SELECT LTRIM (rec.new_column_name, 'R118_')
                 INTO l_column_name
                 FROM DUAL;

Line: 395

            UPDATE ad_long_column_conversions
               SET status = ad_longtolob_pkg.g_col_renamed_status
             WHERE schema_name = rec.schema_name
               AND table_name = rec.table_name
               AND old_column_name = rec.old_column_name;

Line: 410

            SELECT schema_name, table_name, old_column_name
              FROM ad_long_column_conversions
             WHERE status IN (ad_longtolob_pkg.g_col_renamed_status)
               AND table_name = cur_table_name
               AND old_column_name = cur_old_column_name;

Line: 432

            UPDATE ad_long_column_conversions
               SET status = ad_longtolob_pkg.g_drop_trigger_status
             WHERE schema_name = rec.schema_name
               AND table_name = rec.table_name
               AND old_column_name = rec.old_column_name;

Line: 447

            SELECT schema_name, table_name, old_column_name
              FROM ad_long_column_conversions
             WHERE status IN (ad_longtolob_pkg.g_drop_trigger_status,ad_longtolob_pkg.g_col_renamed_status)
               AND table_name = cur_table_name
               AND old_column_name = cur_old_column_name;

Line: 469

            UPDATE ad_long_column_conversions
	                   SET status = ad_longtolob_pkg.g_complete_status
	                   WHERE schema_name = rec.schema_name
	                   AND table_name = rec.table_name
                           AND old_column_name = rec.old_column_name;

Line: 484

            SELECT schema_name, table_name, old_column_name
              FROM ad_long_column_conversions
             WHERE status IN (
               ad_longtolob_pkg.g_drop_trigger_status,ad_longtolob_pkg.g_col_renamed_status)
               AND table_name = cur_table_name
               AND old_column_name = cur_old_column_name;

Line: 507

            UPDATE ad_long_column_conversions
               SET status = ad_longtolob_pkg.g_complete_status
             WHERE schema_name = rec.schema_name
               AND table_name = rec.table_name
               AND old_column_name = rec.old_column_name;