APPS.SSP_MAT_UPD SQL Statements

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

Line: 54

Procedure update_dml(p_rec in out nocopy ssp_mat_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'update_dml';

Line: 69

  update ssp_maternities
  set
  due_date                          = p_rec.due_date,
  start_date_maternity_allowance    = p_rec.start_date_maternity_allowance,
  notification_of_birth_date        = p_rec.notification_of_birth_date,
  unfit_for_scheduled_return        = p_rec.unfit_for_scheduled_return,
  stated_return_date                = p_rec.stated_return_date,
  intend_to_return_flag             = p_rec.intend_to_return_flag,
  start_date_with_new_employer      = p_rec.start_date_with_new_employer,
  smp_must_be_paid_by_date          = p_rec.smp_must_be_paid_by_date,
  pay_smp_as_lump_sum               = p_rec.pay_smp_as_lump_sum,
  live_birth_flag                   = p_rec.live_birth_flag,
  actual_birth_date                 = p_rec.actual_birth_date,
  mpp_start_date                    = p_rec.mpp_start_date,
  object_version_number             = p_rec.object_version_number,
  attribute_category                = p_rec.attribute_category,
  attribute1                        = p_rec.attribute1,
  attribute2                        = p_rec.attribute2,
  attribute3                        = p_rec.attribute3,
  attribute4                        = p_rec.attribute4,
  attribute5                        = p_rec.attribute5,
  attribute6                        = p_rec.attribute6,
  attribute7                        = p_rec.attribute7,
  attribute8                        = p_rec.attribute8,
  attribute9                        = p_rec.attribute9,
  attribute10                       = p_rec.attribute10,
  attribute11                       = p_rec.attribute11,
  attribute12                       = p_rec.attribute12,
  attribute13                       = p_rec.attribute13,
  attribute14                       = p_rec.attribute14,
  attribute15                       = p_rec.attribute15,
  attribute16                       = p_rec.attribute16,
  attribute17                       = p_rec.attribute17,
  attribute18                       = p_rec.attribute18,
  attribute19                       = p_rec.attribute19,
  attribute20                       = p_rec.attribute20,
  LEAVE_TYPE                        = p_rec.LEAVE_TYPE,
  MATCHING_DATE                     = p_rec.MATCHING_DATE,
  PLACEMENT_DATE                    = p_rec.PLACEMENT_DATE ,
  DISRUPTED_PLACEMENT_DATE          = p_rec.DISRUPTED_PLACEMENT_DATE,
  mat_information_category          = p_rec.mat_information_category,
  mat_information1                  = p_rec.mat_information1,
  mat_information2                  = p_rec.mat_information2,
  mat_information3                  = p_rec.mat_information3,
  mat_information4                  = p_rec.mat_information4,
  mat_information5                  = p_rec.mat_information5,
  mat_information6                  = p_rec.mat_information6,
  mat_information7                  = p_rec.mat_information7,
  mat_information8                  = p_rec.mat_information8,
  mat_information9                  = p_rec.mat_information9,
  mat_information10                 = p_rec.mat_information10,
  mat_information11                 = p_rec.mat_information11,
  mat_information12                 = p_rec.mat_information12,
  mat_information13                 = p_rec.mat_information13,
  mat_information14                 = p_rec.mat_information14,
  mat_information15                 = p_rec.mat_information15,
  mat_information16                 = p_rec.mat_information16,
  mat_information17                 = p_rec.mat_information17,
  mat_information18                 = p_rec.mat_information18,
  mat_information19                 = p_rec.mat_information19,
  mat_information20                 = p_rec.mat_information20,
  mat_information21                 = p_rec.mat_information21,
  mat_information22                 = p_rec.mat_information22,
  mat_information23                 = p_rec.mat_information23,
  mat_information24                 = p_rec.mat_information24,
  mat_information25                 = p_rec.mat_information25,
  mat_information26                 = p_rec.mat_information26,
  mat_information27                 = p_rec.mat_information27,
  mat_information28                 = p_rec.mat_information28,
  mat_information29                 = p_rec.mat_information29,
  mat_information30                 = p_rec.mat_information30
  where maternity_id = p_rec.maternity_id;

Line: 165

End update_dml;

Line: 199

Procedure pre_update(p_rec in ssp_mat_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'pre_update';

Line: 207

End pre_update;

Line: 241

Procedure post_update(p_rec in ssp_mat_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'post_update';

Line: 249

End post_update;

Line: 636

  ssp_mat_bus.update_validate(p_rec);

Line: 640

  pre_update(p_rec);

Line: 644

  update_dml(p_rec);

Line: 648

  post_update(p_rec);