APPS.HR_ASSIGNMENT_SET_CRITERIA_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_line_no               in number,
                       p_assignment_set_id     in number,
                       p_left_operand          in varchar2,
                       p_operator              in varchar2,
                       p_right_operand         in varchar2,
                       p_logical               in varchar2) is

  --
  begin
  --
    insert into HR_ASSIGNMENT_SET_CRITERIA
         ( LINE_NO,
           ASSIGNMENT_SET_ID,
           LEFT_OPERAND,
           OPERATOR,
           RIGHT_OPERAND,
           LOGICAL)
    values
        (  p_line_no,
           p_assignment_set_id,
           p_left_operand,
           p_operator,
           p_right_operand,
           p_logical);

Line: 31

    select rowid
    into   p_rowid
    from   HR_ASSIGNMENT_SET_CRITERIA
    where  ASSIGNMENT_SET_ID = p_assignment_set_id
    and    LINE_NO           = p_line_no;

Line: 37

  end insert_row;

Line: 39

  procedure update_row(p_rowid                 in varchar2,
                       p_line_no               in number,
                       p_assignment_set_id     in number,
                       p_left_operand          in varchar2,
                       p_operator              in varchar2,
                       p_right_operand         in varchar2,
                       p_logical               in varchar2) is

  begin
  --
    update HR_ASSIGNMENT_SET_CRITERIA
    set    LINE_NO                   = p_line_no,
           ASSIGNMENT_SET_ID         = p_assignment_set_id,
           LEFT_OPERAND              = p_left_operand,
           OPERATOR                  = p_operator,
           RIGHT_OPERAND             = p_right_operand,
           LOGICAL                   = p_logical
    where  ROWID = p_rowid;

Line: 58

  end update_row;

Line: 60

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

Line: 67

  end delete_row;

Line: 78

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