APPS.PER_MASS_MOVES_PKG SQL Statements

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

Line: 5

procedure insert_row
                  (p_business_group_id in number,
                   p_effective_date in date,
                   p_new_organization_id in number,
                   p_source_organization_id in number,
                   p_reason in varchar2,
                   p_status in varchar2,
                   p_mass_move_id out number,
                   p_row_id out varchar2)
  is

  l_mass_move_id number(15);

Line: 20

    select per_mass_moves_s.nextval
       from sys.dual;

Line: 24

     select rowid
     from per_mass_moves
     where mass_move_id = l_mass_move_id;

Line: 34

       hr_utility.set_message_token('PROCEDURE','per_mass_moves_pkg.insert_rows');

Line: 40

    insert into per_mass_moves
      (mass_move_id,
       business_group_id,
       effective_date,
       new_organization_id,
       old_organization_id,
       reason,
       status)
     values
       (l_mass_move_id,
        p_business_group_id,
        p_effective_date,
        p_new_organization_id,
        p_source_organization_id,
        p_reason,
        p_status);

Line: 61

       hr_utility.set_message_token('PROCEDURE','per_mass_moves_pkg.insert_rows');

Line: 71

  end insert_row;

Line: 74

  procedure update_row
                  (p_mass_move_id in number,
                   p_effective_date in date,
                   p_new_organization_id in number,
                   p_source_organization_id in number,
                   p_reason in varchar2,
                   p_row_id in varchar2)
   is

  begin
      update per_mass_moves
       set effective_date = p_effective_date,
       new_organization_id = p_new_organization_id,
       old_organization_id = p_source_organization_id,
       reason = p_reason
       where rowid = p_row_id;

Line: 93

     end update_row;

Line: 96

 procedure delete_row
             (p_mass_move_id in number,
              p_row_id in varchar2)
  is

   begin
     delete from per_mass_moves
      where rowid = p_row_id;

Line: 107

  end delete_row;

Line: 123

      select *
        from per_mass_moves
       where mass_move_id = p_mass_move_id
         for update of status nowait;