APPS.OTA_TEA_INS SQL Statements

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

Line: 53

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

Line: 65

  insert into ota_event_associations
  (	event_association_id,
	event_id,
	customer_id,
        organization_id,
        job_id,
        position_id,
	comments,
	tea_information_category,
	tea_information1,
	tea_information2,
	tea_information3,
	tea_information4,
	tea_information5,
	tea_information6,
	tea_information7,
	tea_information8,
	tea_information9,
	tea_information10,
	tea_information11,
	tea_information12,
	tea_information13,
	tea_information14,
	tea_information15,
	tea_information16,
	tea_information17,
	tea_information18,
	tea_information19,
	tea_information20
  )
  Values
  (	p_rec.event_association_id,
	p_rec.event_id,
	p_rec.customer_id,
        p_rec.organization_id,
        p_rec.job_id,
        p_rec.position_id,
	p_rec.comments,
	p_rec.tea_information_category,
	p_rec.tea_information1,
	p_rec.tea_information2,
	p_rec.tea_information3,
	p_rec.tea_information4,
	p_rec.tea_information5,
	p_rec.tea_information6,
	p_rec.tea_information7,
	p_rec.tea_information8,
	p_rec.tea_information9,
	p_rec.tea_information10,
	p_rec.tea_information11,
	p_rec.tea_information12,
	p_rec.tea_information13,
	p_rec.tea_information14,
	p_rec.tea_information15,
	p_rec.tea_information16,
	p_rec.tea_information17,
	p_rec.tea_information18,
	p_rec.tea_information19,
	p_rec.tea_information20
  );

Line: 148

End insert_dml;

Line: 187

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

Line: 191

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

Line: 204

End pre_insert;

Line: 238

Procedure post_insert (	 p_business_group_id            in number
			,p_validate			in boolean
                        ,p_price_basis                  in varchar2
                        ,p_event_id                     in number
                        ,p_customer_id                  in number
			,p_booking_id			out nocopy number
			,p_tdb_object_version_number 	out nocopy number
			,p_booking_status_type_id	in number
			,p_booking_contact_id		in number
        		,p_contact_address_id           in number
        		,p_delegate_contact_phone       in varchar2
        		,p_delegate_contact_fax         in varchar2
			,p_internal_booking_flag	in varchar2
			,p_source_of_booking		in varchar2
			,p_number_of_places		in number
			,p_date_booking_placed		in date
			,p_finance_header_id		in number
                        ,p_currency_code                in varchar2
			,p_standard_amount		in number
			,p_unitary_amount		in number
			,p_money_amount			in number
			,p_booking_deal_id		in number
			,p_booking_deal_type		in varchar2
			,p_finance_line_id		in out nocopy number
                  ,p_delegate_contact_email     in varchar2
	) is
l_proc varchar2(30) := g_package||'post_insert';

Line: 291

        ,p_update_finance_line          => null
        ,p_tfl_object_version_number    => l_tfl_ovn
	,p_finance_header_id		=> p_finance_header_id
	,p_currency_code		=> p_currency_code
	,p_standard_amount		=> p_standard_amount
	,p_unitary_amount		=> p_unitary_amount
	,p_money_amount			=> p_money_amount
	,p_booking_deal_id		=> p_booking_deal_id
	,p_booking_deal_type		=> p_booking_deal_type
	,p_finance_line_id		=> p_finance_line_id
	,p_delegate_contact_email     => p_delegate_contact_email
	);

Line: 308

end post_insert;

Line: 359

  ota_tea_bus.insert_validate(p_rec
                             ,p_association_type);

Line: 364

  pre_insert(p_rec);

Line: 368

  insert_dml(p_rec);

Line: 372

  post_insert(
         p_business_group_id
	,p_validate
        ,p_price_basis
        ,p_rec.event_id
        ,p_rec.customer_id
	,p_booking_id
	,p_tdb_object_version_number
        ,p_booking_status_type_id
        ,p_booking_contact_id
        ,p_contact_address_id
        ,p_delegate_contact_phone
        ,p_delegate_contact_fax
        ,p_internal_booking_flag
	,p_source_of_booking
	,p_number_of_places
	,p_date_booking_placed
        ,p_finance_header_id
        ,p_currency_code
        ,p_standard_amount
        ,p_unitary_amount
        ,p_money_amount
        ,p_booking_deal_id
        ,p_booking_deal_type
        ,p_finance_line_id
        ,p_delegate_contact_email
);