APPS.PSB_ENTITY_ASSIGNMENT_PVT SQL Statements

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

Line: 6

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_ENTITY_SET_ID in NUMBER,
  P_ENTITY_ID in NUMBER,
  P_PRIORITY in NUMBER,
  P_SEVERITY_LEVEL in NUMBER,
  P_EFFECTIVE_START_DATE in DATE,
  P_EFFECTIVE_END_DATE in DATE,
  p_Last_Update_Date                   DATE,
  p_Last_Updated_By                    NUMBER,
  p_Last_Update_Login                  NUMBER,
  p_Created_By                         NUMBER,
  p_Creation_Date                      DATE
) is
  --
  l_api_name            CONSTANT VARCHAR2(30)   := 'Insert_Row';

Line: 32

    cursor C is select ROWID from PSB_ENTITY_ASSIGNMENT
      where ENTITY_SET_ID = P_ENTITY_SET_ID
      and ENTITY_ID = P_ENTITY_ID;

Line: 37

  SAVEPOINT Insert_Row_Pvt ;

Line: 55

  insert into PSB_ENTITY_ASSIGNMENT (
    ENTITY_SET_ID,
    ENTITY_ID,
    PRIORITY,
    SEVERITY_LEVEL,
    EFFECTIVE_START_DATE,
    EFFECTIVE_END_DATE,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    P_ENTITY_SET_ID,
    P_ENTITY_ID,
    P_PRIORITY,
    P_SEVERITY_LEVEL,
    P_EFFECTIVE_START_DATE,
    P_EFFECTIVE_END_DATE,
    P_LAST_UPDATE_DATE,
    P_LAST_UPDATED_BY,
    P_LAST_UPDATE_DATE,
    P_LAST_UPDATED_BY,
    P_LAST_UPDATE_LOGIN
  );

Line: 103

    ROLLBACK TO Insert_Row_Pvt ;

Line: 110

    ROLLBACK TO Insert_Row_Pvt ;

Line: 117

    ROLLBACK TO Insert_Row_Pvt ;

Line: 128

END Insert_Row;

Line: 152

  cursor c1 is select
      PRIORITY,
      SEVERITY_LEVEL,
      EFFECTIVE_START_DATE,
      EFFECTIVE_END_DATE
    from PSB_ENTITY_ASSIGNMENT
    where ENTITY_SET_ID = P_ENTITY_SET_ID
    and ENTITY_ID = P_ENTITY_ID
    for update of ENTITY_SET_ID nowait;

Line: 260

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_ENTITY_SET_ID in NUMBER,
  P_ENTITY_ID in NUMBER,
  P_PRIORITY in NUMBER,
  P_SEVERITY_LEVEL in NUMBER,
  P_EFFECTIVE_START_DATE in DATE,
  P_EFFECTIVE_END_DATE in DATE,
  p_Last_Update_Date                   DATE,
  p_Last_Updated_By                    NUMBER,
  p_Last_Update_Login                  NUMBER
) is
  --
  l_api_name            CONSTANT VARCHAR2(30)   := 'Update_Row';

Line: 285

  SAVEPOINT Update_Row_Pvt ;

Line: 302

  update PSB_ENTITY_ASSIGNMENT set
    PRIORITY = P_PRIORITY,
    SEVERITY_LEVEL = P_SEVERITY_LEVEL,
    EFFECTIVE_START_DATE = P_EFFECTIVE_START_DATE,
    EFFECTIVE_END_DATE = P_EFFECTIVE_END_DATE,
    LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = P_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN
  where ENTITY_SET_ID = P_ENTITY_SET_ID
  and ENTITY_ID = P_ENTITY_ID
  ;

Line: 329

    ROLLBACK TO Update_Row_Pvt ;

Line: 336

    ROLLBACK TO Update_Row_Pvt ;

Line: 343

    ROLLBACK TO Update_Row_Pvt ;

Line: 354

END Update_Row;

Line: 357

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_ENTITY_SET_ID in NUMBER,
  P_ENTITY_ID in NUMBER
) is
  --
  l_api_name            CONSTANT VARCHAR2(30)   := 'Delete_Row';

Line: 375

  SAVEPOINT Delete_Row_Pvt ;

Line: 392

  delete from PSB_ENTITY_ASSIGNMENT
  where ENTITY_SET_ID = P_ENTITY_SET_ID
    and ENTITY_ID = P_ENTITY_ID;

Line: 412

    ROLLBACK TO Delete_Row_Pvt ;

Line: 419

    ROLLBACK TO Delete_Row_Pvt ;

Line: 426

    ROLLBACK TO Delete_Row_Pvt ;

Line: 437

END Delete_Row;