APPS.PER_MM_VALID_GRADES_PKG SQL Statements

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

Line: 5

procedure insert_row
         (p_mass_move_id in number,
          p_position_id in number,
          p_target_grade_id in number,
          p_attribute_category in varchar2,
          p_attribute1 in varchar2,
          p_attribute2 in varchar2,
          p_attribute3 in varchar2,
          p_attribute4 in varchar2,
          p_attribute5 in varchar2,
          p_attribute6 in varchar2,
          p_attribute7 in varchar2,
          p_attribute8 in varchar2,
          p_attribute9 in varchar2,
          p_attribute10 in varchar2,
          p_attribute11 in varchar2,
          p_attribute12 in varchar2,
          p_attribute13 in varchar2,
          p_attribute14 in varchar2,
          p_attribute15 in varchar2,
          p_attribute16 in varchar2,
          p_attribute17 in varchar2,
          p_attribute18 in varchar2,
          p_attribute19 in varchar2,
          p_attribute20 in varchar2)

 is
  cursor c is
    select 'x'
      from
       per_mm_valid_grades
     where mass_move_id = p_mass_move_id;

Line: 40

    insert into per_mm_valid_grades
         (mass_move_id,
          position_id,
          target_grade_id,
          attribute_category,
          attribute1,
          attribute2,
          attribute3,
          attribute4,
          attribute5,
          attribute6,
          attribute7,
          attribute8,
          attribute9,
          attribute10,
          attribute11,
          attribute12,
          attribute13,
          attribute14,
          attribute15,
          attribute16,
          attribute17,
          attribute18,
          attribute19,
          attribute20)
     values
         (p_mass_move_id,
          p_position_id,
          p_target_grade_id,
          p_attribute_category,
          p_attribute1,
          p_attribute2,
          p_attribute3,
          p_attribute4,
          p_attribute5,
          p_attribute6,
          p_attribute7,
          p_attribute8,
          p_attribute9,
          p_attribute10,
          p_attribute11,
          p_attribute12,
          p_attribute13,
          p_attribute14,
          p_attribute15,
          p_attribute16,
          p_attribute17,
          p_attribute18,
          p_attribute19,
          p_attribute20);

Line: 97

end insert_row;

Line: 100

procedure update_row
          (p_target_grade_id in number,
          p_attribute1 in varchar2,
          p_attribute2 in varchar2,
          p_attribute3 in varchar2,
          p_attribute4 in varchar2,
          p_attribute5 in varchar2,
          p_attribute6 in varchar2,
          p_attribute7 in varchar2,
          p_attribute8 in varchar2,
          p_attribute9 in varchar2,
          p_attribute10 in varchar2,
          p_attribute11 in varchar2,
          p_attribute12 in varchar2,
          p_attribute13 in varchar2,
          p_attribute14 in varchar2,
          p_attribute15 in varchar2,
          p_attribute16 in varchar2,
          p_attribute17 in varchar2,
          p_attribute18 in varchar2,
          p_attribute19 in varchar2,
          p_attribute20 in varchar2,
          p_row_id in varchar2)
is
    begin
      update per_mm_valid_grades
       set
         target_grade_id = p_target_grade_id,
         attribute1 = p_attribute1,
         attribute2 = p_attribute2,
          attribute3 = p_attribute3,
          attribute4 = p_attribute4,
          attribute5 = p_attribute5,
          attribute6 = p_attribute6,
          attribute7 = p_attribute7,
          attribute8 = p_attribute8,
          attribute9 = p_attribute9,
          attribute10 = p_attribute10,
          attribute11 = p_attribute11,
          attribute12 = p_attribute12,
          attribute13 = p_attribute13,
          attribute14 = p_attribute14,
          attribute15 = p_attribute15,
          attribute16 = p_attribute16,
          attribute17 = p_attribute17,
          attribute18 = p_attribute18,
          attribute19 = p_attribute19,
          attribute20 = p_attribute20
       where rowid = p_row_id;

Line: 152

end update_row;

Line: 155

procedure delete_row
            (p_row_id in varchar2)

is
    begin
      delete from per_mm_valid_grades
         where rowid = p_row_id;

Line: 165

end delete_row;

Line: 174

hr_utility.set_location('Inside Load_rows. before insert ',10);

Line: 176

select effective_date into l_effective_date
 from per_mass_moves where mass_move_id = p_mass_move_id;

Line: 180

     insert into per_mm_valid_grades
         (MASS_MOVE_ID,
          position_id,
          TARGET_GRADE_ID,
         ATTRIBUTE_CATEGORY,
         ATTRIBUTE1,
         ATTRIBUTE2,
         ATTRIBUTE3,
         ATTRIBUTE4,
         ATTRIBUTE5,
         ATTRIBUTE6,
         ATTRIBUTE7,
         ATTRIBUTE8,
         ATTRIBUTE9,
         ATTRIBUTE10,
         ATTRIBUTE11,
         ATTRIBUTE12,
         ATTRIBUTE13,
         ATTRIBUTE14,
         ATTRIBUTE15,
         ATTRIBUTE16,
         ATTRIBUTE17,
         ATTRIBUTE18,
         ATTRIBUTE19,
         ATTRIBUTE20
          )
     select
         p_mass_move_id,
         mmpos.position_id,
         vgr.GRADE_ID,
         vgr.ATTRIBUTE_CATEGORY,
         vgr.ATTRIBUTE1,
         vgr.ATTRIBUTE2,
         vgr.ATTRIBUTE3,
         vgr.ATTRIBUTE4,
         vgr.ATTRIBUTE5,
         vgr.ATTRIBUTE6,
         vgr.ATTRIBUTE7,
         vgr.ATTRIBUTE8,
         vgr.ATTRIBUTE9,
         vgr.ATTRIBUTE10,
         vgr.ATTRIBUTE11,
         vgr.ATTRIBUTE12,
         vgr.ATTRIBUTE13,
         vgr.ATTRIBUTE14,
         vgr.ATTRIBUTE15,
         vgr.ATTRIBUTE16,
         vgr.ATTRIBUTE17,
         vgr.ATTRIBUTE18,
         vgr.ATTRIBUTE19,
         vgr.ATTRIBUTE20
      from per_valid_grades vgr,
            per_mm_positions mmpos
      where vgr.position_id = mmpos.position_id
        and mmpos.mass_move_id = p_mass_move_id
	and l_effective_date between vgr.date_from and vgr.date_to; -- This condition added for 7214283

Line: 237

	hr_utility.set_location('Load_rows. After insert',20);

Line: 283

      select *
        from per_mm_valid_grades
       where rowid = p_row_id
         for update of target_grade_id nowait;