DBA Data[Home] [Help]

APPS.PER_SHA_INS SQL Statements

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

Line: 47

Procedure insert_dml(p_rec in out nocopy per_sha_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'insert_dml';
Line: 58

  insert into per_std_holiday_absences
  (	std_holiday_absences_id,
	date_not_taken,
	person_id,
	standard_holiday_id,
	actual_date_taken,
	reason,
        expired,
	attribute_category,
	attribute1,
	attribute2,
	attribute3,
	attribute4,
	attribute5,
	attribute6,
	attribute7,
	attribute8,
	attribute9,
	attribute10,
	attribute11,
	attribute12,
	attribute13,
	attribute14,
	attribute15,
	attribute16,
	attribute17,
	attribute18,
	attribute19,
	attribute20,
	object_version_number
  )
  Values
  (	p_rec.std_holiday_absences_id,
	p_rec.date_not_taken,
	p_rec.person_id,
	p_rec.standard_holiday_id,
	p_rec.actual_date_taken,
	p_rec.reason,
	p_rec.expired,
	p_rec.attribute_category,
	p_rec.attribute1,
	p_rec.attribute2,
	p_rec.attribute3,
	p_rec.attribute4,
	p_rec.attribute5,
	p_rec.attribute6,
	p_rec.attribute7,
	p_rec.attribute8,
	p_rec.attribute9,
	p_rec.attribute10,
	p_rec.attribute11,
	p_rec.attribute12,
	p_rec.attribute13,
	p_rec.attribute14,
	p_rec.attribute15,
	p_rec.attribute16,
	p_rec.attribute17,
	p_rec.attribute18,
	p_rec.attribute19,
	p_rec.attribute20,
	p_rec.object_version_number
  );
Line: 137

End insert_dml;
Line: 176

Procedure pre_insert(p_rec  in out nocopy per_sha_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'pre_insert';
Line: 180

  Cursor C_Sel1 is select per_std_holiday_absences_s.nextval from sys.dual;
Line: 193

End pre_insert;
Line: 227

Procedure post_insert(p_rec in per_sha_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'post_insert';
Line: 236

    per_sha_rki.after_insert
  (p_std_holiday_absences_id  => p_rec.std_holiday_absences_id
  ,p_date_not_taken           => p_rec.date_not_taken
  ,p_person_id                => p_rec.person_id
  ,p_standard_holiday_id      => p_rec.standard_holiday_id
  ,p_actual_date_taken        => p_rec.actual_date_taken
  ,p_reason                   => p_rec.reason
  ,p_expired                  => p_rec.expired
  ,p_attribute_category       => p_rec.attribute_category
  ,p_attribute1               => p_rec.attribute1
  ,p_attribute2               => p_rec.attribute2
  ,p_attribute3               => p_rec.attribute3
  ,p_attribute4               => p_rec.attribute4
  ,p_attribute5               => p_rec.attribute5
  ,p_attribute6               => p_rec.attribute6
  ,p_attribute7               => p_rec.attribute7
  ,p_attribute8               => p_rec.attribute8
  ,p_attribute9               => p_rec.attribute9
  ,p_attribute10              => p_rec.attribute10
  ,p_attribute11              => p_rec.attribute11
  ,p_attribute12              => p_rec.attribute12
  ,p_attribute13              => p_rec.attribute13
  ,p_attribute14              => p_rec.attribute14
  ,p_attribute15              => p_rec.attribute15
  ,p_attribute16              => p_rec.attribute16
  ,p_attribute17              => p_rec.attribute17
  ,p_attribute18              => p_rec.attribute18
  ,p_attribute19              => p_rec.attribute19
  ,p_attribute20              => p_rec.attribute20
  ,p_object_version_number    => p_rec.object_version_number
   );
Line: 276

End post_insert;
Line: 293

  per_sha_bus.insert_validate(p_rec);
Line: 297

  pre_insert(p_rec);
Line: 301

  insert_dml(p_rec);
Line: 305

  post_insert(p_rec);