APPS.PSB_WS_POSITION_LINE_O_PVT SQL Statements

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

Line: 8

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_POSITION_LINE_ID          IN       NUMBER,
  P_POSITION_ID               IN       NUMBER,
  P_DESCRIPTION               IN       VARCHAR2,
  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: 38

  SAVEPOINT Update_Row_Pvt ;

Line: 55

  update PSB_WS_POSITION_LINES set
    DESCRIPTION = P_DESCRIPTION,
    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 POSITION_LINE_ID = P_POSITION_LINE_ID
    and POSITION_ID = P_POSITION_ID
  ;

Line: 86

    ROLLBACK TO Update_Row_Pvt ;

Line: 93

    ROLLBACK TO Update_Row_Pvt ;

Line: 100

    ROLLBACK TO Update_Row_Pvt ;

Line: 111

END Update_Row;