APPS.PSB_ELEMENT_POS_SET_GROUPS_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_POSITION_SET_GROUP_ID            in      NUMBER,
  P_PAY_ELEMENT_ID                   in      NUMBER,
  P_NAME                             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: 32

     select ROWID from psb_element_pos_set_groups
     where position_set_group_id = p_position_set_group_id
     and  pay_element_id = p_pay_element_id;

Line: 40

  SAVEPOINT     INSERT_ROW_PVT;

Line: 64

  INSERT INTO psb_element_pos_set_groups
  (
 POSITION_SET_GROUP_ID          ,
 PAY_ELEMENT_ID                 ,
 NAME                           ,
 LAST_UPDATE_DATE               ,
 LAST_UPDATED_BY                ,
 LAST_UPDATE_LOGIN              ,
 CREATED_BY                     ,
 CREATION_DATE
  )
  VALUES
  (
 P_POSITION_SET_GROUP_ID          ,
 P_PAY_ELEMENT_ID                 ,
 P_NAME                           ,
 P_LAST_UPDATE_DATE               ,
 P_LAST_UPDATED_BY                ,
 P_LAST_UPDATE_LOGIN              ,
 P_CREATED_BY                     ,
 P_CREATION_DATE
  );

Line: 110

     rollback to INSERT_ROW_PVT;

Line: 120

     rollback to INSERT_ROW_PVT;

Line: 130

     rollback to INSERT_ROW_PVT;

Line: 143

END INSERT_ROW;

Line: 145

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_SET_GROUP_ID            in      NUMBER,
  P_PAY_ELEMENT_ID                   in      NUMBER,
  P_NAME                             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: 169

  SAVEPOINT     UPDATE_ROW_PVT;

Line: 192

  UPDATE psb_element_pos_set_groups SET
  NAME                   =  P_NAME                     ,
  LAST_UPDATE_DATE       =  P_LAST_UPDATE_DATE         ,
  LAST_UPDATED_BY        =  P_LAST_UPDATED_BY          ,
  LAST_UPDATE_LOGIN      =  P_LAST_UPDATE_LOGIN
  WHERE position_set_group_id = p_position_set_group_id
  AND pay_element_id = p_pay_element_id;

Line: 221

     rollback to UPDATE_ROW_PVT;

Line: 231

     rollback to UPDATE_ROW_PVT;

Line: 241

     rollback to UPDATE_ROW_PVT;

Line: 254

END UPDATE_ROW;

Line: 257

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

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

Line: 277

  SAVEPOINT     DELETE_ROW_PVT;

Line: 299

 DELETE FROM psb_pay_element_distributions
 WHERE position_set_group_id = p_position_set_group_id;

Line: 303

 DELETE FROM psb_element_pos_set_groups
 WHERE position_set_group_id = p_position_set_group_id
 AND pay_element_id = p_pay_element_id;

Line: 328

     rollback to DELETE_ROW_PVT;

Line: 338

     rollback to DELETE_ROW_PVT;

Line: 348

     rollback to DELETE_ROW_PVT;

Line: 360

END DELETE_ROW;

Line: 384

  CURSOR C IS SELECT * FROM PSB_ELEMENT_POS_SET_GROUPS
  WHERE position_set_group_id = p_position_set_group_id
  AND pay_element_id = p_pay_element_id
  FOR UPDATE of POSITION_SET_GROUP_Id NOWAIT;

Line: 415

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

Line: 513

	 SELECT '1'
	 FROM   psb_element_pos_set_groups
	 WHERE  p_pay_element_id IS NOT NULL
	 AND    name = p_name
	 AND    pay_element_id = p_pay_element_id
	 AND    (
		  p_position_set_group_id IS NULL
		  OR
		  position_set_group_id <> p_position_set_group_id
		);

Line: 621

    SELECT '1'
    FROM psb_set_relations
    WHERE position_set_group_id = p_position_set_group_id;