APPS.SSP_MAT_INS SQL Statements

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

Line: 53

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

Line: 65

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

Line: 234

End insert_dml;

Line: 273

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

Line: 277

  Cursor C_Sel1 is select ssp_maternities_s.nextval from sys.dual;

Line: 290

End pre_insert;

Line: 324

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

Line: 332

End post_insert;

Line: 359

  ssp_mat_bus.insert_validate(p_rec);

Line: 363

  pre_insert(p_rec);

Line: 367

  insert_dml(p_rec);

Line: 371

  post_insert(p_rec);