APPS.OTA_TPL_BUS SQL Statements

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

Line: 25

g_update 	boolean;

Line: 117

	select 1
	from ota_price_lists
	where name = p_name
	   and business_group_id = p_business_group_id
	   and (p_price_list_id is null or price_list_id <> p_price_list_id);

Line: 303

    select 1
    from ota_price_list_entries
    where price_list_id = p_tpl_id;

Line: 353

    select 1
    from ota_booking_deals
    where price_list_id = p_tpl_id;

Line: 410

   select 1
   from ota_price_lists
   where business_group_id = p_business_group_id
         and default_flag = 'Y'
	 and currency_code = p_currency_code
	 and p_start_date <= nvl(end_date,p_start_date)
	 and nvl(p_end_date,start_date) >= start_date
         and (p_tpl_id is null or (p_tpl_id is not null
                                 and price_list_id <> p_tpl_id));

Line: 461

   select min(start_date)
   from ota_price_list_entries
   where price_list_id = p_tpl_id;

Line: 486

	if g_update then
	   return TRUE;

Line: 509

   select min(start_date)
   from ota_booking_deals
   where price_list_id = p_tpl_id;

Line: 553

   select max(nvl(end_date,g_end_of_time))
   from ota_price_list_entries
   where price_list_id = p_tpl_id;

Line: 582

	if g_update then
	   return TRUE;

Line: 607

   select max(nvl(end_date,g_end_of_time))
   from ota_booking_deals
   where price_list_id = p_tpl_id;

Line: 707

procedure insert_and_update_validate
(
p_rec in ota_tpl_shd.g_rec_type
)
is
---------------------
begin
--
check_table_constraints(p_rec);

Line: 726

end insert_and_update_validate;

Line: 729

procedure insert_validate2
(
p_rec in ota_tpl_shd.g_rec_type
)
is
---------------------
begin
--
insert_and_update_validate(p_rec);

Line: 739

end insert_validate2;

Line: 742

procedure update_validate2
(
p_rec in ota_tpl_shd.g_rec_type
)
is
---------------------
begin
--
insert_and_update_validate(p_rec);

Line: 757

end update_validate2;

Line: 760

procedure delete_validate2
(
p_rec in ota_tpl_shd.g_rec_type
)
is
---------------------
begin
--
--Check no child booking deals exist for price list.
--
  del_check_no_child_tbd (p_tpl_id => p_rec.price_list_id);

Line: 777

end delete_validate2;

Line: 819

select
   price_list_id,
   business_group_id,
   currency_code,
   default_flag,
   name,
   object_version_number,
   price_list_type,
   start_date,
   comments,
   description,
   end_date,
   single_unit_price,
   training_unit_type,
   tpl_information_category,tpl_information1,tpl_information2,
   tpl_information3,tpl_information4,tpl_information5,tpl_information6,
   tpl_information7,tpl_information8,tpl_information9,tpl_information10,
   tpl_information11,tpl_information12,tpl_information13,tpl_information14,
   tpl_information15,tpl_information16,tpl_information17,tpl_information18,
   tpl_information19,tpl_information20
	from ota_price_lists
	where price_list_id = p_old_tpl_id;

Line: 994

   g_update := TRUE;

Line: 996

   g_update := FALSE;

Line: 1009

g_update := FALSE;

Line: 1015

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

Line: 1023

	insert_validate2(p_rec);

Line: 1028

End insert_validate;

Line: 1033

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

Line: 1041

	update_validate2(p_rec);

Line: 1046

End update_validate;

Line: 1051

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

Line: 1059

	delete_validate2(p_rec);

Line: 1062

End delete_validate;