APPS.CN_COLUMN_MAPS_PVT SQL Statements

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

Line: 5

G_LAST_UPDATE_DATE          	DATE    := sysdate;

Line: 6

G_LAST_UPDATED_BY           	NUMBER  := fnd_global.user_id;

Line: 9

G_LAST_UPDATE_LOGIN        	NUMBER  := fnd_global.login_id;

Line: 14

PROCEDURE insert_row
  (
   p_api_version            IN NUMBER,
   p_init_msg_list          IN VARCHAR2 := FND_API.G_FALSE,
   p_commit                 IN VARCHAR2 := FND_API.G_FALSE,
   p_validation_level       IN NUMBER   := FND_API.G_VALID_LEVEL_FULL,
   x_return_status         OUT NOCOPY VARCHAR2,
   x_msg_count             OUT NOCOPY NUMBER,
   x_msg_data              OUT NOCOPY VARCHAR2,
   p_destination_column_id  IN NUMBER,
   p_table_map_id           IN NUMBER,
   p_expression             IN VARCHAR2,
   p_editable               IN VARCHAR2,
   p_modified               IN VARCHAR2,
   p_update_clause          IN VARCHAR2,
   p_calc_ext_table_id      IN NUMBER,
   p_org_id                 IN NUMBER,
   x_col_map_id          IN OUT NOCOPY NUMBER) IS

     l_api_name              CONSTANT VARCHAR2(30) := 'insert_row';

Line: 40

   SAVEPOINT insert_row_sv;

Line: 57

   cn_column_maps_pkg.Insert_Row
     (x_rowid                 => l_rowid,
      x_column_map_id         => l_column_map_id,
      x_destination_column_id => p_destination_column_id,
      x_table_map_id          => p_table_map_id,
      x_expression            => p_expression,
      x_editable              => p_editable,
      x_modified              => p_modified,
      x_update_clause         => p_update_clause,
      x_calc_ext_table_id     => p_calc_ext_table_id,
      x_creation_date         => G_CREATION_DATE,
      x_created_by            => G_CREATED_BY,
      X_org_id                => p_org_id);

Line: 86

      ROLLBACK TO insert_row_sv;

Line: 93

      ROLLBACK TO insert_row_sv;

Line: 100

      ROLLBACK TO insert_row_sv;

Line: 110

END insert_row;

Line: 115

PROCEDURE update_row
  (
   p_api_version   	    IN NUMBER,
   p_init_msg_list          IN VARCHAR2  := FND_API.G_FALSE,
   p_commit                 IN VARCHAR2  := FND_API.G_FALSE,
   p_validation_level       IN NUMBER    := FND_API.G_VALID_LEVEL_FULL,
   x_return_status         OUT NOCOPY VARCHAR2,
   x_msg_count             OUT NOCOPY NUMBER,
   x_msg_data              OUT NOCOPY VARCHAR2,
   p_column_map_id          IN NUMBER,
   p_destination_column_id  IN NUMBER,
   p_table_map_id           IN NUMBER,
   p_expression             IN VARCHAR2,
   p_editable               IN VARCHAR2,
   p_modified               IN VARCHAR2,
   p_update_clause          IN VARCHAR2,
   p_calc_ext_table_id      IN NUMBER,
   p_object_version_number  IN OUT NOCOPY NUMBER,
   p_org_id IN NUMBER) IS

      l_api_name               CONSTANT VARCHAR2(30) := 'update_row';

Line: 140

	 SELECT object_version_number
	   FROM cn_column_maps
	   WHERE column_map_id = p_column_map_id
       and org_id = p_org_id;

Line: 147

   SAVEPOINT update_row_sv;

Line: 182

   cn_column_maps_pkg.Update_Row
     (x_column_map_id         => p_column_map_id,
      x_destination_column_id => p_destination_column_id,
      x_table_map_id          => p_table_map_id,
      x_expression            => p_expression,
      x_editable              => p_editable,
      x_modified              => p_modified,
      x_update_clause         => p_update_clause,
      x_calc_ext_table_id     => p_calc_ext_table_id,
      x_last_update_date      => G_LAST_UPDATE_DATE,
      x_last_updated_by       => G_LAST_UPDATED_BY,
      x_last_update_login     => g_last_update_login,
      x_object_version_number => p_object_version_number,
      x_org_id => p_org_id);

Line: 211

      ROLLBACK TO update_row_sv;

Line: 218

      ROLLBACK TO update_row_sv;

Line: 225

      ROLLBACK TO update_row_sv;

Line: 235

END update_row;

Line: 240

PROCEDURE delete_row
  (
   p_api_version       IN NUMBER,
   p_init_msg_list     IN VARCHAR2 := FND_API.G_FALSE,
   p_commit            IN VARCHAR2 := FND_API.G_FALSE,
   p_validation_level  IN NUMBER  := FND_API.G_VALID_LEVEL_FULL,
   x_return_status    OUT NOCOPY VARCHAR2,
   x_msg_count        OUT NOCOPY NUMBER,
   x_msg_data         OUT NOCOPY VARCHAR2,
   p_column_map_id     IN NUMBER,
   p_org_id            IN NUMBER) IS

      l_api_name                  CONSTANT VARCHAR2(30) := 'delete_row';

Line: 257

   SAVEPOINT delete_row_sv;

Line: 273

   cn_column_maps_pkg.Delete_Row
     (x_column_map_id => p_column_map_id, x_org_id => p_org_id);

Line: 288

      ROLLBACK TO delete_row_sv;

Line: 295

      ROLLBACK TO delete_row_sv;

Line: 302

      ROLLBACK TO delete_row_sv;

Line: 313

END delete_row;