APPS.HR_ASSIGNMENT_SET_AMDS_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_id         in number,
                       p_assignment_set_id     in number,
                       p_include_or_exclude    in varchar2) is
  --
  begin
  --
    insert into HR_ASSIGNMENT_SET_AMENDMENTS
         ( ASSIGNMENT_ID,
           ASSIGNMENT_SET_ID,
           INCLUDE_OR_EXCLUDE)
    values
        (  p_assignment_id,
           p_assignment_set_id,
           p_include_or_exclude);

Line: 21

    select rowid
    into   p_rowid
    from   HR_ASSIGNMENT_SET_AMENDMENTS
    where  ASSIGNMENT_SET_ID = p_assignment_set_id
    and    ASSIGNMENT_ID     = p_assignment_id;

Line: 27

  end insert_row;

Line: 29

  procedure update_row(p_rowid                 in varchar2,
                       p_assignment_id         in number,
                       p_assignment_set_id     in number,
                       p_include_or_exclude    in varchar2) is

  begin
  --
    update HR_ASSIGNMENT_SET_AMENDMENTS
    set    ASSIGNMENT_ID             = p_assignment_id,
           ASSIGNMENT_SET_ID         = p_assignment_set_id,
           INCLUDE_OR_EXCLUDE        = p_include_or_exclude
    where  ROWID = p_rowid;

Line: 42

  end update_row;

Line: 44

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

Line: 51

  end delete_row;

Line: 58

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