APPS.OTA_TFL_API_INS SQL Statements

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

Line: 75

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

Line: 87

  insert into ota_finance_lines
  (	finance_line_id,
	finance_header_id,
	cancelled_flag,
	date_raised,
	line_type,
	object_version_number,
	sequence_number,
	transfer_status,
	comments,
	currency_code,
	money_amount,
	standard_amount,
	trans_information_category,
	trans_information1,
	trans_information10,
	trans_information11,
	trans_information12,
	trans_information13,
	trans_information14,
	trans_information15,
	trans_information16,
	trans_information17,
	trans_information18,
	trans_information19,
	trans_information2,
	trans_information20,
	trans_information3,
	trans_information4,
	trans_information5,
	trans_information6,
	trans_information7,
	trans_information8,
	trans_information9,
	transfer_date,
	transfer_message,
	unitary_amount,
	booking_deal_id,
	booking_id,
	resource_allocation_id,
	resource_booking_id,
	tfl_information_category,
	tfl_information1,
	tfl_information2,
	tfl_information3,
	tfl_information4,
	tfl_information5,
	tfl_information6,
	tfl_information7,
	tfl_information8,
	tfl_information9,
	tfl_information10,
	tfl_information11,
	tfl_information12,
	tfl_information13,
	tfl_information14,
	tfl_information15,
	tfl_information16,
	tfl_information17,
	tfl_information18,
	tfl_information19,
	tfl_information20
  )
  Values
  (	p_rec.finance_line_id,
	p_rec.finance_header_id,
	p_rec.cancelled_flag,
	p_rec.date_raised,
	p_rec.line_type,
	p_rec.object_version_number,
	p_rec.sequence_number,
	p_rec.transfer_status,
	p_rec.comments,
	p_rec.currency_code,
	p_rec.money_amount,
	p_rec.standard_amount,
	p_rec.trans_information_category,
	p_rec.trans_information1,
	p_rec.trans_information10,
	p_rec.trans_information11,
	p_rec.trans_information12,
	p_rec.trans_information13,
	p_rec.trans_information14,
	p_rec.trans_information15,
	p_rec.trans_information16,
	p_rec.trans_information17,
	p_rec.trans_information18,
	p_rec.trans_information19,
	p_rec.trans_information2,
	p_rec.trans_information20,
	p_rec.trans_information3,
	p_rec.trans_information4,
	p_rec.trans_information5,
	p_rec.trans_information6,
	p_rec.trans_information7,
	p_rec.trans_information8,
	p_rec.trans_information9,
	p_rec.transfer_date,
	p_rec.transfer_message,
	p_rec.unitary_amount,
	p_rec.booking_deal_id,
	p_rec.booking_id,
	p_rec.resource_allocation_id,
	p_rec.resource_booking_id,
	p_rec.tfl_information_category,
	p_rec.tfl_information1,
	p_rec.tfl_information2,
	p_rec.tfl_information3,
	p_rec.tfl_information4,
	p_rec.tfl_information5,
	p_rec.tfl_information6,
	p_rec.tfl_information7,
	p_rec.tfl_information8,
	p_rec.tfl_information9,
	p_rec.tfl_information10,
	p_rec.tfl_information11,
	p_rec.tfl_information12,
	p_rec.tfl_information13,
	p_rec.tfl_information14,
	p_rec.tfl_information15,
	p_rec.tfl_information16,
	p_rec.tfl_information17,
	p_rec.tfl_information18,
	p_rec.tfl_information19,
	p_rec.tfl_information20
  );

Line: 236

End insert_dml;

Line: 275

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

Line: 279

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

Line: 284

    Select null
      from ota_finance_lines
     where finance_line_id =
             ota_tfl_api_ins.g_finance_line_id_i;

Line: 331

End pre_insert;

Line: 365

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

Line: 373

End post_insert;

Line: 401

  ota_tfl_api_bus.insert_validate( p_rec, p_transaction_type);

Line: 405

  pre_insert(p_rec);

Line: 409

  insert_dml(p_rec);

Line: 413

  post_insert(p_rec);