APPS.PSB_POS_SET_LINE_VALUES_PVT SQL Statements

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

Line: 8

 |                       PROCEDURE Insert_Row                            |
 +=======================================================================*/

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_Value_Sequence_Id         IN OUT  NOCOPY   NUMBER,
  p_Line_Sequence_Id          IN       NUMBER,
  p_Attribute_Value_Id        IN       NUMBER,
  p_Attribute_Value           IN       VARCHAR2,
  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
)
IS
  --
  l_api_name            CONSTANT VARCHAR2(30)   := 'Insert_Row';

Line: 38

    SELECT rowid
    FROM   psb_position_set_line_values
    WHERE  value_sequence_id = p_value_sequence_id ;

Line: 43

    SELECT psb_position_set_line_values_s.nextval
    FROM   dual;

Line: 47

  SAVEPOINT Insert_Row_Pvt ;

Line: 72

  INSERT INTO psb_position_set_line_values(
	      value_sequence_id,
	      line_sequence_id,
	      attribute_value_id,
	      attribute_value,
	      last_update_date,
	      last_updated_by,
	      last_update_login,
	      created_by,
	      creation_date)
	    VALUES
	      (
	      p_value_sequence_id,
	      p_line_sequence_id,
	      p_attribute_value_id,
	      p_attribute_value,
	      p_last_update_date,
	      p_last_updated_by,
	      p_last_update_login,
	      p_created_by,
	      p_creation_date
	    );

Line: 115

    ROLLBACK TO Insert_Row_Pvt ;

Line: 122

    ROLLBACK TO Insert_Row_Pvt ;

Line: 129

    ROLLBACK TO Insert_Row_Pvt ;

Line: 140

END Insert_Row;

Line: 174

       SELECT *
       FROM   psb_position_set_line_values
       WHERE  rowid = p_Row_Id
       FOR UPDATE of value_sequence_id NOWAIT;

Line: 205

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

Line: 287

 |                       PROCEDURE Update_Row                               |
 +==========================================================================*/

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_Value_Sequence_Id         IN       NUMBER,
  p_Line_Sequence_Id          IN       NUMBER,
  p_Attribute_Value_Id        IN       NUMBER,
  p_Attribute_Value           IN       VARCHAR2,
  p_Last_Update_Date          IN       DATE,
  p_Last_Updated_By           IN       NUMBER,
  p_Last_Update_Login         IN       NUMBER
)
IS
  --
  l_api_name            CONSTANT VARCHAR2(30)   := 'Update_Row';

Line: 316

  SAVEPOINT Update_Row_Pvt ;

Line: 334

  UPDATE psb_position_set_line_values
  SET
       value_sequence_id         =     p_value_sequence_id,
       line_sequence_id          =     p_line_sequence_id,
       attribute_value_id        =     p_attribute_value_id,
       attribute_value           =     p_attribute_value,
       last_update_date          =     p_last_update_date,
       last_updated_by           =     p_last_updated_by,
       last_update_login         =     p_last_update_login
  WHERE rowid = p_Row_Id;

Line: 361

    ROLLBACK TO Update_Row_Pvt ;

Line: 368

    ROLLBACK TO Update_Row_Pvt ;

Line: 375

    ROLLBACK TO Update_Row_Pvt ;

Line: 386

END Update_Row;

Line: 393

 |                       PROCEDURE Delete_Row                               |
 +==========================================================================*/

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: 415

  SAVEPOINT Delete_Row_Pvt ;

Line: 436

  DELETE FROM psb_position_set_line_values
  WHERE rowid = p_Row_Id;

Line: 455

    ROLLBACK TO Delete_Row_Pvt ;

Line: 462

    ROLLBACK TO Delete_Row_Pvt ;

Line: 469

    ROLLBACK TO Delete_Row_Pvt ;

Line: 480

END Delete_Row;

Line: 514

    SELECT '1'
    FROM   psb_position_set_line_values
    WHERE  attribute_value = p_attribute_value
    AND    ( (p_Row_Id IS NULL)
	     OR
	     (RowId <> p_Row_Id)
	   );

Line: 524

    SELECT '1'
    FROM   psb_position_set_line_values
    WHERE  line_sequence_id = p_line_sequence_id
    AND    ( p_attribute_value_id IS NULL
	     OR
	     attribute_value_id = p_attribute_value_id )
    AND   (  p_attribute_value IS NULL
	     OR
	     attribute_value = p_attribute_value )
    AND    ( p_Row_Id IS NULL
	     OR
	     RowId <> p_Row_Id
	   );

Line: 637

    SELECT '1'
    FROM psb_set_relations
    WHERE account_position_set_id = p_Account_Position_Set_Id;