APPS.CN_COLUMN_MAPS_V_PKG SQL Statements

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

Line: 16

  PROCEDURE insert_row (
        x_column_map_id            Number,
        x_source_column_id         Number,
        x_dest_column_id           Number,
        x_table_map_id             Number,
        x_foreign_key_mapping_id   Number,
        x_expression               varchar2,
        x_creation_date            date,
        x_created_by               number) IS

  BEGIN

    INSERT INTO cn_column_maps(
        column_map_id,
        source_column_id,
        destination_column_id,
        table_map_id,
        driving_column_id,
        expression,
        creation_date,
        created_by)
    VALUES(
        x_column_map_id,
        x_source_column_id,
        x_dest_column_id,
        x_table_map_id,
        x_foreign_key_mapping_id,
        x_expression,
        x_creation_date,
        x_created_by);

Line: 47

  END insert_row;

Line: 57

  PROCEDURE update_row(
        x_column_map_id                 Number,
        x_source_column_id              Number,
        x_dest_column_id                Number,
        x_table_map_id                  Number,
        x_foreign_key_mapping_id        Number,
        x_expression                    varchar2,
        x_last_update_date              date,
        x_last_update_login             number,
        x_last_updated_by               number) IS

  BEGIN

    UPDATE cn_column_maps SET
        source_column_id = x_source_column_id,
        destination_column_id = x_dest_column_id,
        table_map_id = x_table_map_id,
        driving_column_id = x_foreign_key_mapping_id,
        expression = x_expression,
        last_update_date  = x_last_update_date,
        last_update_login = x_last_update_login,
        last_updated_by   = x_last_updated_by
    WHERE column_map_id = X_column_map_id;

Line: 81

  END update_row;

Line: 95

        SELECT column_map_id
          INTO temp
          FROM cn_column_maps
         WHERE column_map_id = x_column_map_id
           FOR UPDATE ;

Line: 109

  PROCEDURE delete_row (x_column_map_id  IN   NUMBER) IS
  BEGIN

        DELETE cn_column_maps
         WHERE column_map_id = x_column_map_id ;

Line: 115

  END delete_row;

Line: 127

        SELECT cn_column_maps_s.nextval
          INTO x_column_map_id
          FROM sys.dual ;