APPS.PSB_PAY_ELEMENT_OPTIONS_PVT SQL Statements

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

Line: 8

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_PAY_ELEMENT_OPTION_ID            in      NUMBER,
  P_PAY_ELEMENT_ID                   in      NUMBER,
  P_NAME                             in      VARCHAR2,
  P_GRADE_STEP                       in      NUMBER,
  P_SEQUENCE_NUMBER                  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
) IS

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

Line: 34

     select ROWID from psb_pay_element_options
     where pay_element_option_id = p_pay_element_option_id
     and  pay_element_id = p_pay_element_id;

Line: 42

  SAVEPOINT     INSERT_ROW_PVT;

Line: 66

  INSERT INTO psb_pay_element_options
  (
 PAY_ELEMENT_OPTION_ID          ,
 PAY_ELEMENT_ID                 ,
 NAME                           ,
 GRADE_STEP                     ,
 SEQUENCE_NUMBER                ,
 LAST_UPDATE_DATE               ,
 LAST_UPDATED_BY                ,
 LAST_UPDATE_LOGIN              ,
 CREATED_BY                     ,
 CREATION_DATE
  )
  VALUES
  (
 P_PAY_ELEMENT_OPTION_ID          ,
 P_PAY_ELEMENT_ID                 ,
 P_NAME                           ,
 P_GRADE_STEP                     ,
 P_SEQUENCE_NUMBER                ,
 P_LAST_UPDATE_DATE               ,
 P_LAST_UPDATED_BY                ,
 P_LAST_UPDATE_LOGIN              ,
 P_CREATED_BY                     ,
 P_CREATION_DATE
  );

Line: 116

     rollback to INSERT_ROW_PVT;

Line: 126

     rollback to INSERT_ROW_PVT;

Line: 136

     rollback to INSERT_ROW_PVT;

Line: 149

END INSERT_ROW;

Line: 151

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_PAY_ELEMENT_OPTION_ID            in      NUMBER,
  P_PAY_ELEMENT_ID                   in      NUMBER,
  P_NAME                             in      VARCHAR2,
  P_GRADE_STEP                       in      NUMBER,
  P_SEQUENCE_NUMBER                  in      NUMBER,
  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: 177

  SAVEPOINT     UPDATE_ROW_PVT;

Line: 200

  UPDATE psb_pay_element_options SET
  NAME                   =  P_NAME                     ,
  GRADE_STEP             =  P_GRADE_STEP               ,
  SEQUENCE_NUMBER        =  P_SEQUENCE_NUMBER          ,
  LAST_UPDATE_DATE       =  P_LAST_UPDATE_DATE         ,
  LAST_UPDATED_BY        =  P_LAST_UPDATED_BY          ,
  LAST_UPDATE_LOGIN      =  P_LAST_UPDATE_LOGIN
  WHERE pay_element_option_id = p_pay_element_option_id
  AND pay_element_id = p_pay_element_id;

Line: 231

     rollback to UPDATE_ROW_PVT;

Line: 241

     rollback to UPDATE_ROW_PVT;

Line: 251

     rollback to UPDATE_ROW_PVT;

Line: 264

END UPDATE_ROW;

Line: 267

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_PAY_ELEMENT_OPTION_ID              IN      NUMBER,
  P_PAY_ELEMENT_ID                     IN      NUMBER
) IS

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

Line: 287

  SAVEPOINT     DELETE_ROW_PVT;

Line: 309

 DELETE FROM psb_pay_element_rates
 WHERE pay_element_option_id = p_pay_element_option_id
 AND pay_element_id = p_pay_element_id;

Line: 314

 DELETE FROM psb_pay_element_options
 WHERE pay_element_option_id = p_pay_element_option_id
 AND pay_element_id = p_pay_element_id;

Line: 339

     rollback to DELETE_ROW_PVT;

Line: 349

     rollback to DELETE_ROW_PVT;

Line: 359

     rollback to DELETE_ROW_PVT;

Line: 371

END DELETE_ROW;

Line: 397

  CURSOR C IS SELECT * FROM PSB_PAY_ELEMENT_OPTIONS
  WHERE pay_element_option_id = p_pay_element_option_id
  AND pay_element_id = p_pay_element_id
  FOR UPDATE of PAY_ELEMENT_OPTION_Id NOWAIT;

Line: 428

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

Line: 530

    SELECT '1'
    FROM psb_pay_element_options
    WHERE name = p_name
    AND   ( (p_pay_element_option_id IS NULL)
	     OR ( pay_element_option_id <> p_pay_element_option_id) )
    AND   ( (pay_element_id = p_pay_element_id) );

Line: 538

    SELECT '1'
    FROM psb_pay_element_options
    WHERE name       = p_name
    AND   grade_step = p_grade_step
    AND   ( (p_pay_element_option_id IS NULL)
	     OR ( pay_element_option_id <> p_pay_element_option_id) )
    AND   ( ( pay_element_id = p_pay_element_id) );

Line: 644

    SELECT '1'
    FROM psb_position_assignments
    WHERE pay_element_id = p_pay_element_Id
    OR pay_element_option_id = p_pay_element_option_id;

Line: 650

    SELECT '1'
    FROM psb_default_assignments
    WHERE pay_element_id = p_pay_element_Id
    OR pay_element_option_id = p_pay_element_option_id;