APPS.PSB_WORKSHEET_CONSOLIDATE_PVT SQL Statements

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

Line: 172

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,
  p_return_status             OUT NOCOPY      VARCHAR2,
  p_msg_count                 OUT NOCOPY      NUMBER,
  p_msg_data                  OUT NOCOPY      VARCHAR2,

  p_row_id                    IN OUT NOCOPY   VARCHAR2,
  p_global_worksheet_id       IN       NUMBER,
  p_local_worksheet_id        IN       NUMBER,
  p_last_update_date          IN       DATE,
  p_last_updated_by           IN       NUMBER,
  p_last_update_login         IN       NUMBER,
  p_created_by                IN       NUMBER,
  p_creation_date             IN       DATE,
  p_attribute1                IN       VARCHAR2,
  p_attribute2                IN       VARCHAR2,
  p_attribute3                IN       VARCHAR2,
  p_attribute4                IN       VARCHAR2,
  p_attribute5                IN       VARCHAR2,
  p_attribute6                IN       VARCHAR2,
  p_attribute7                IN       VARCHAR2,
  p_attribute8                IN       VARCHAR2,
  p_attribute9                IN       VARCHAR2,
  p_attribute10               IN       VARCHAR2,
  p_context                   IN       VARCHAR2
)
IS

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

Line: 208

    SELECT rowid
    FROM   psb_ws_consolidation_details
    WHERE  global_worksheet_id = p_global_worksheet_id
    AND    local_worksheet_id = p_local_worksheet_id;

Line: 215

  SAVEPOINT Insert_Row_Pvt ;

Line: 232

  INSERT INTO psb_ws_consolidation_details(
	      global_worksheet_id,
	      local_worksheet_id,
	      last_update_date ,
	      last_updated_by,
	      last_update_login,
	      created_by,
	      creation_date,
	      attribute1,
	      attribute2,
	      attribute3,
	      attribute4,
	      attribute5,
	      attribute6,
	      attribute7,
	      attribute8,
	      attribute9,
	      attribute10,
	      context)
  VALUES
	      (
	      p_global_worksheet_id,
	      p_local_worksheet_id,
	      p_last_update_date ,
	      p_last_updated_by,
	      p_last_update_login,
	      p_created_by,
	      p_creation_date,
	      p_attribute1,
	      p_attribute2,
	      p_attribute3,
	      p_attribute4,
	      p_attribute5,
	      p_attribute6,
	      p_attribute7,
	      p_attribute8,
	      p_attribute9,
	      p_attribute10,
	      p_context);

Line: 292

    ROLLBACK TO Insert_Row_Pvt ;

Line: 299

    ROLLBACK TO Insert_Row_Pvt ;

Line: 306

    ROLLBACK TO Insert_Row_Pvt ;

Line: 317

END Insert_Row;

Line: 354

       SELECT *
       FROM   psb_ws_consolidation_details
       WHERE  rowid = p_row_id
       FOR UPDATE NOWAIT;

Line: 385

    FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');

Line: 495

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,
  p_return_status             OUT NOCOPY      VARCHAR2,
  p_msg_count                 OUT NOCOPY      NUMBER,
  p_msg_data                  OUT NOCOPY      VARCHAR2,

  p_row_id                    IN       VARCHAR2,
  p_global_worksheet_id       IN       NUMBER,
  p_local_worksheet_id        IN       NUMBER,
  p_last_update_date          IN       DATE,
  p_last_updated_by           IN       NUMBER,
  p_last_update_login         IN       NUMBER,
  p_attribute1                IN       VARCHAR2,
  p_attribute2                IN       VARCHAR2,
  p_attribute3                IN       VARCHAR2,
  p_attribute4                IN       VARCHAR2,
  p_attribute5                IN       VARCHAR2,
  p_attribute6                IN       VARCHAR2,
  p_attribute7                IN       VARCHAR2,
  p_attribute8                IN       VARCHAR2,
  p_attribute9                IN       VARCHAR2,
  p_attribute10               IN       VARCHAR2,
  p_context                   IN       VARCHAR2
)
IS

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

Line: 530

  SAVEPOINT Update_Row_Pvt ;

Line: 548

  UPDATE psb_ws_consolidation_details
  SET
       global_worksheet_id     =   p_global_worksheet_id ,
       local_worksheet_id      =   p_local_worksheet_id ,
       last_update_date        =   p_last_update_date ,
       last_updated_by         =   p_last_updated_by ,
       last_update_login       =   p_last_update_login ,
       attribute1              =   p_attribute1 ,
       attribute2              =   p_attribute2 ,
       attribute3              =   p_attribute3 ,
       attribute4              =   p_attribute4 ,
       attribute5              =   p_attribute5 ,
       attribute6              =   p_attribute6 ,
       attribute7              =   p_attribute7 ,
       attribute8              =   p_attribute8 ,
       attribute9              =   p_attribute9 ,
       attribute10             =   p_attribute10,
       context                 =   p_context
  WHERE rowid = p_row_id;

Line: 584

    ROLLBACK TO Update_Row_Pvt ;

Line: 591

    ROLLBACK TO Update_Row_Pvt ;

Line: 598

    ROLLBACK TO Update_Row_Pvt ;

Line: 609

END Update_Row;

Line: 612

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,
  p_return_status             OUT NOCOPY      VARCHAR2,
  p_msg_count                 OUT NOCOPY      NUMBER,
  p_msg_data                  OUT NOCOPY      VARCHAR2,

  p_row_id                    IN        VARCHAR2
)
IS

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

Line: 635

  SAVEPOINT Delete_Row_Pvt ;

Line: 653

  DELETE FROM psb_ws_consolidation_details
  WHERE rowid = p_row_id;

Line: 672

    ROLLBACK TO Delete_Row_Pvt ;

Line: 679

    ROLLBACK TO Delete_Row_Pvt ;

Line: 686

    ROLLBACK TO Delete_Row_Pvt ;

Line: 697

END Delete_Row;

Line: 723

    SELECT '1'
    FROM   psb_ws_consolidation_details
    WHERE  global_worksheet_id = p_global_worksheet_id
    AND    local_worksheet_id = p_local_worksheet_id;