APPS.HR_ASSIGNMENT_SETS_PKG SQL Statements

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

Line: 4

  procedure insert_row(p_rowid             in out varchar2,
                       p_assignment_set_id     in number,
                       p_business_group_id     in number,
                       p_payroll_id            in number,
                       p_assignment_set_name   in varchar2,
                       p_formula_id            in number) is

  --
  begin
  --
    insert into HR_ASSIGNMENT_SETS
         ( ASSIGNMENT_SET_ID,
           BUSINESS_GROUP_ID,
           PAYROLL_ID,
           ASSIGNMENT_SET_NAME,
           FORMULA_ID)
    values
         ( p_assignment_set_id,
           p_business_group_id,
           p_payroll_id,
           p_assignment_set_name,
           p_formula_id);

Line: 28

    select rowid
    into   p_rowid
    from   HR_ASSIGNMENT_SETS
    where  ASSIGNMENT_SET_ID = p_assignment_set_id;

Line: 33

  end insert_row;

Line: 35

  procedure update_row(p_rowid                 in varchar2,
                       p_assignment_set_id     in number,
                       p_business_group_id     in number,
                       p_payroll_id            in number,
                       p_assignment_set_name   in varchar2,
                       p_formula_id            in number) is

  begin
  --
    update HR_ASSIGNMENT_SETS
    set    ASSIGNMENT_SET_ID         = p_assignment_set_id,
           BUSINESS_GROUP_ID         = p_business_group_id,
           PAYROLL_ID                = p_payroll_id,
           ASSIGNMENT_SET_NAME       = p_assignment_set_name,
           FORMULA_ID                = p_formula_id
    where  ROWID = p_rowid;

Line: 52

  end update_row;

Line: 54

  procedure delete_row(p_rowid   in varchar2) is
  --
  begin
  --
    delete from HR_ASSIGNMENT_SETS
    where  ROWID = p_rowid;

Line: 61

  end delete_row;

Line: 71

    cursor C is select *
                from   HR_ASSIGNMENT_SETS
                where  rowid = p_rowid
                for update of ASSIGNMENT_SET_ID nowait;