APPS.PSB_ATTRIBUTE_VALUES_PVT SQL Statements

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

Line: 7

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_ROWID                       in OUT  NOCOPY  VARCHAR2,
  --
  P_ATTRIBUTE_VALUE_ID          in      NUMBER,
  P_ATTRIBUTE_ID                in      NUMBER,
  P_ATTRIBUTE_VALUE             in      VARCHAR2,
  P_HR_VALUE_ID                 in      VARCHAR2,
  P_DESCRIPTION                 in      VARCHAR2,
  P_DATA_EXTRACT_ID             in      NUMBER,
  P_CONTEXT                     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_ATTRIBUTE11                 in      VARCHAR2,
  P_ATTRIBUTE12                 in      VARCHAR2,
  P_ATTRIBUTE13                 in      VARCHAR2,
  P_ATTRIBUTE14                 in      VARCHAR2,
  P_ATTRIBUTE15                 in      VARCHAR2,
  P_ATTRIBUTE16                 in      VARCHAR2,
  P_ATTRIBUTE17                 in      VARCHAR2,
  P_ATTRIBUTE18                 in      VARCHAR2,
  P_ATTRIBUTE19                 in      VARCHAR2,
  P_ATTRIBUTE20                 in      VARCHAR2,
  P_ATTRIBUTE21                 in      VARCHAR2,
  P_ATTRIBUTE22                 in      VARCHAR2,
  P_ATTRIBUTE23                 in      VARCHAR2,
  P_ATTRIBUTE24                 in      VARCHAR2,
  P_ATTRIBUTE25                 in      VARCHAR2,
  P_ATTRIBUTE26                 in      VARCHAR2,
  P_ATTRIBUTE27                 in      VARCHAR2,
  P_ATTRIBUTE28                 in      VARCHAR2,
  P_ATTRIBUTE29                 in      VARCHAR2,
  P_ATTRIBUTE30                 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
) as
  --
  l_api_name            CONSTANT VARCHAR2(30)   := 'Insert_Row';

Line: 65

    cursor C is select ROWID from PSB_ATTRIBUTE_VALUES
      where ATTRIBUTE_VALUE_ID = P_ATTRIBUTE_VALUE_ID;

Line: 70

  SAVEPOINT Insert_Row_Pvt ;

Line: 88

  insert into PSB_ATTRIBUTE_VALUES (
  ATTRIBUTE_VALUE_ID        ,
  ATTRIBUTE_ID              ,
  ATTRIBUTE_VALUE           ,
  HR_VALUE_ID               ,
  DESCRIPTION               ,
  DATA_EXTRACT_ID           ,
  CONTEXT                   ,
  ATTRIBUTE1                ,
  ATTRIBUTE2                ,
  ATTRIBUTE3                ,
  ATTRIBUTE4                ,
  ATTRIBUTE5                ,
  ATTRIBUTE6                ,
  ATTRIBUTE7                ,
  ATTRIBUTE8                ,
  ATTRIBUTE9                ,
  ATTRIBUTE10               ,
  ATTRIBUTE11               ,
  ATTRIBUTE12               ,
  ATTRIBUTE13               ,
  ATTRIBUTE14               ,
  ATTRIBUTE15               ,
  ATTRIBUTE16               ,
  ATTRIBUTE17               ,
  ATTRIBUTE18               ,
  ATTRIBUTE19               ,
  ATTRIBUTE20               ,
  ATTRIBUTE21               ,
  ATTRIBUTE22               ,
  ATTRIBUTE23               ,
  ATTRIBUTE24               ,
  ATTRIBUTE25               ,
  ATTRIBUTE26               ,
  ATTRIBUTE27               ,
  ATTRIBUTE28               ,
  ATTRIBUTE29               ,
  ATTRIBUTE30               ,
  LAST_UPDATE_DATE          ,
  LAST_UPDATED_BY           ,
  LAST_UPDATE_LOGIN         ,
  CREATED_BY                ,
  CREATION_DATE
  ) values (
  P_ATTRIBUTE_VALUE_ID        ,
  P_ATTRIBUTE_ID              ,
  P_ATTRIBUTE_VALUE           ,
  P_HR_VALUE_ID               ,
  P_DESCRIPTION               ,
  P_DATA_EXTRACT_ID           ,
  P_CONTEXT                   ,
  P_ATTRIBUTE1                ,
  P_ATTRIBUTE2                ,
  P_ATTRIBUTE3                ,
  P_ATTRIBUTE4                ,
  P_ATTRIBUTE5                ,
  P_ATTRIBUTE6                ,
  P_ATTRIBUTE7                ,
  P_ATTRIBUTE8                ,
  P_ATTRIBUTE9                ,
  P_ATTRIBUTE10               ,
  P_ATTRIBUTE11               ,
  P_ATTRIBUTE12               ,
  P_ATTRIBUTE13               ,
  P_ATTRIBUTE14               ,
  P_ATTRIBUTE15               ,
  P_ATTRIBUTE16               ,
  P_ATTRIBUTE17               ,
  P_ATTRIBUTE18               ,
  P_ATTRIBUTE19               ,
  P_ATTRIBUTE20               ,
  P_ATTRIBUTE21               ,
  P_ATTRIBUTE22               ,
  P_ATTRIBUTE23               ,
  P_ATTRIBUTE24               ,
  P_ATTRIBUTE25               ,
  P_ATTRIBUTE26               ,
  P_ATTRIBUTE27               ,
  P_ATTRIBUTE28               ,
  P_ATTRIBUTE29               ,
  P_ATTRIBUTE30               ,
  P_LAST_UPDATE_DATE          ,
  P_LAST_UPDATED_BY           ,
  P_LAST_UPDATE_LOGIN         ,
  P_CREATED_BY                ,
  P_CREATION_DATE
  );

Line: 196

    ROLLBACK TO Insert_Row_Pvt ;

Line: 203

    ROLLBACK TO Insert_Row_Pvt ;

Line: 210

    ROLLBACK TO Insert_Row_Pvt ;

Line: 221

END INSERT_ROW;

Line: 278

  cursor c1 is select
    ATTRIBUTE_VALUE_ID        ,
    ATTRIBUTE_ID              ,
    ATTRIBUTE_VALUE           ,
    HR_VALUE_ID               ,
    DESCRIPTION               ,
    DATA_EXTRACT_ID           ,
    CONTEXT                   ,
    ATTRIBUTE1                ,
    ATTRIBUTE2                ,
    ATTRIBUTE3                ,
    ATTRIBUTE4                ,
    ATTRIBUTE5                ,
    ATTRIBUTE6                ,
    ATTRIBUTE7                ,
    ATTRIBUTE8                ,
    ATTRIBUTE9                ,
    ATTRIBUTE10               ,
    ATTRIBUTE11               ,
    ATTRIBUTE12               ,
    ATTRIBUTE13               ,
    ATTRIBUTE14               ,
    ATTRIBUTE15               ,
    ATTRIBUTE16               ,
    ATTRIBUTE17               ,
    ATTRIBUTE18               ,
    ATTRIBUTE19               ,
    ATTRIBUTE20               ,
    ATTRIBUTE21               ,
    ATTRIBUTE22               ,
    ATTRIBUTE23               ,
    ATTRIBUTE24               ,
    ATTRIBUTE25               ,
    ATTRIBUTE26               ,
    ATTRIBUTE27               ,
    ATTRIBUTE28               ,
    ATTRIBUTE29               ,
    ATTRIBUTE30
    from PSB_ATTRIBUTE_VALUES
    where ROWID = P_ROWID
    for update of ATTRIBUTE_VALUE_ID nowait;

Line: 517

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_ATTRIBUTE_VALUE_ID          in      NUMBER,
  P_ATTRIBUTE_ID                in      NUMBER,
  P_ATTRIBUTE_VALUE             in      VARCHAR2,
  P_HR_VALUE_ID                 in      VARCHAR2,
  P_DESCRIPTION                 in      VARCHAR2,
  P_DATA_EXTRACT_ID             in      NUMBER,
  P_CONTEXT                     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_ATTRIBUTE11                 in      VARCHAR2,
  P_ATTRIBUTE12                 in      VARCHAR2,
  P_ATTRIBUTE13                 in      VARCHAR2,
  P_ATTRIBUTE14                 in      VARCHAR2,
  P_ATTRIBUTE15                 in      VARCHAR2,
  P_ATTRIBUTE16                 in      VARCHAR2,
  P_ATTRIBUTE17                 in      VARCHAR2,
  P_ATTRIBUTE18                 in      VARCHAR2,
  P_ATTRIBUTE19                 in      VARCHAR2,
  P_ATTRIBUTE20                 in      VARCHAR2,
  P_ATTRIBUTE21                 in      VARCHAR2,
  P_ATTRIBUTE22                 in      VARCHAR2,
  P_ATTRIBUTE23                 in      VARCHAR2,
  P_ATTRIBUTE24                 in      VARCHAR2,
  P_ATTRIBUTE25                 in      VARCHAR2,
  P_ATTRIBUTE26                 in      VARCHAR2,
  P_ATTRIBUTE27                 in      VARCHAR2,
  P_ATTRIBUTE28                 in      VARCHAR2,
  P_ATTRIBUTE29                 in      VARCHAR2,
  P_ATTRIBUTE30                 in      VARCHAR2,
  P_LAST_UPDATE_DATE            in      DATE,
  P_LAST_UPDATED_BY             in      NUMBER,
  P_LAST_UPDATE_LOGIN           in      NUMBER
) as
  --
  l_api_name            CONSTANT VARCHAR2(30)   := 'Update_Row';

Line: 573

  SAVEPOINT Update_Row_Pvt ;

Line: 590

  update PSB_ATTRIBUTE_VALUES set
  ATTRIBUTE_VALUE_ID   =    P_ATTRIBUTE_VALUE_ID,
  ATTRIBUTE_ID         =    P_ATTRIBUTE_ID,
  ATTRIBUTE_VALUE      =    P_ATTRIBUTE_VALUE,
  HR_VALUE_ID          =    P_HR_VALUE_ID,
  DESCRIPTION          =    P_DESCRIPTION,
  DATA_EXTRACT_ID      =    P_DATA_EXTRACT_ID,
  CONTEXT              =    P_CONTEXT,
  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,
  ATTRIBUTE11          =    P_ATTRIBUTE11,
  ATTRIBUTE12          =    P_ATTRIBUTE12,
  ATTRIBUTE13          =    P_ATTRIBUTE13,
  ATTRIBUTE14          =    P_ATTRIBUTE14,
  ATTRIBUTE15          =    P_ATTRIBUTE15,
  ATTRIBUTE16          =    P_ATTRIBUTE16,
  ATTRIBUTE17          =    P_ATTRIBUTE17,
  ATTRIBUTE18          =    P_ATTRIBUTE18,
  ATTRIBUTE19          =    P_ATTRIBUTE19,
  ATTRIBUTE20          =    P_ATTRIBUTE20,
  ATTRIBUTE21          =    P_ATTRIBUTE21,
  ATTRIBUTE22          =    P_ATTRIBUTE22,
  ATTRIBUTE23          =    P_ATTRIBUTE23,
  ATTRIBUTE24          =    P_ATTRIBUTE24,
  ATTRIBUTE25          =    P_ATTRIBUTE25,
  ATTRIBUTE26          =    P_ATTRIBUTE26,
  ATTRIBUTE27          =    P_ATTRIBUTE27,
  ATTRIBUTE28          =    P_ATTRIBUTE28,
  ATTRIBUTE29          =    P_ATTRIBUTE29,
  ATTRIBUTE30          =    P_ATTRIBUTE30,
  LAST_UPDATE_DATE     =    P_LAST_UPDATE_DATE,
  LAST_UPDATED_BY      =    P_LAST_UPDATED_BY,
  LAST_UPDATE_LOGIN    =    P_LAST_UPDATE_LOGIN
  where ATTRIBUTE_VALUE_ID = P_ATTRIBUTE_VALUE_ID;

Line: 648

    ROLLBACK TO Update_Row_Pvt ;

Line: 655

    ROLLBACK TO Update_Row_Pvt ;

Line: 662

    ROLLBACK TO Update_Row_Pvt ;

Line: 673

END UPDATE_ROW;

Line: 675

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_ATTRIBUTE_VALUE_ID in NUMBER ) as
  --
  l_api_name            CONSTANT VARCHAR2(30)   := 'Delete_Row';

Line: 691

  SAVEPOINT Delete_Row_Pvt ;

Line: 708

  delete from PSB_ATTRIBUTE_VALUES
  where ATTRIBUTE_VALUE_ID = P_ATTRIBUTE_VALUE_ID;

Line: 725

    ROLLBACK TO Delete_Row_Pvt ;

Line: 732

    ROLLBACK TO Delete_Row_Pvt ;

Line: 739

    ROLLBACK TO Delete_Row_Pvt ;

Line: 750

END DELETE_ROW;

Line: 775

    SELECT '1'
    FROM psb_position_assignments
    WHERE attribute_id = p_attribute_Id
    AND attribute_value_id = p_attribute_value_id;