APPS.OTA_PLE_BUS SQL Statements

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

Line: 118

	select 1 from ota_price_lists
	where price_list_id = p_tpl_id;

Line: 172

	select 1 from ota_activity_versions
	where activity_version_id = p_tav_id;

Line: 324

  select activity_version_id from ota_vendor_supplies
  where vendor_supply_id = p_vsp_id;

Line: 366

   select start_date
   from ota_price_lists
   where price_list_id = p_tpl_id;

Line: 416

   select start_date
   from ota_activity_versions
   where activity_version_id = p_tav_id;

Line: 470

   select end_date
   from ota_price_lists
   where price_list_id = p_tpl_id;

Line: 524

   select end_date
   from ota_activity_versions
   where activity_version_id = p_tav_id;

Line: 640

   select 1
   from ota_price_list_entries
   where price_list_id = p_tpl_id
     and nvl(activity_version_id,0) = nvl(p_tav_id,0)
     and nvl(vendor_supply_id,0) = nvl(p_vsp_id,0)
     and price_basis = p_price_basis
     and p_start_date <= nvl(end_date,g_end_of_time)
     and nvl(p_end_date,g_end_of_time) >= start_date
     and (p_ple_id is null or price_list_entry_id <> p_ple_id);

Line: 651

   select 1
   from ota_price_list_entries
   where price_list_id = p_tpl_id
     and nvl(activity_version_id,0) = nvl(p_tav_id,0)
     and nvl(vendor_supply_id,0) = nvl(p_vsp_id,0)
     and price_basis = p_price_basis
     and p_start_date <= nvl(end_date,g_end_of_time)
     and nvl(p_end_date,g_end_of_time) >= start_date
     and p_minattendees <= maximum_attendees
     and p_maxattendees >= minimum_attendees
     and (p_ple_id is null or price_list_entry_id <> p_ple_id);

Line: 702

procedure insert_and_update_validate
(
p_rec in OTA_PLE_SHD.g_rec_type
)
is
---------------------
l_tav_id	ota_activity_versions.activity_version_id%type;

Line: 733

end insert_and_update_validate;

Line: 736

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

Line: 746

end insert_validate2;

Line: 749

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

Line: 759

end update_validate2;

Line: 761

procedure delete_validate2
(
p_rec in OTA_PLE_SHD.g_rec_type
)
is
---------------------
begin
--
return;

Line: 771

end delete_validate2;

Line: 855

select
  ple.price_list_entry_id,
  ple.vendor_supply_id,
  ple.activity_version_id,
  ple.price_list_id,
  ple.object_version_number,
  ple.price,
  ple.price_basis,
  ple.start_date,
  ple.comments,
  ple.end_date,
  ple.maximum_attendees,
  ple.minimum_attendees,
  ple.ple_information_category,
  ple.ple_information1,
  ple.ple_information2,
  ple.ple_information3,
  ple.ple_information4,
  ple.ple_information5,
  ple.ple_information6,
  ple.ple_information7,
  ple.ple_information8,
  ple.ple_information9,
  ple.ple_information10,
  ple.ple_information11,
  ple.ple_information12,
  ple.ple_information13,
  ple.ple_information14,
  ple.ple_information15,
  ple.ple_information16,
  ple.ple_information17,
  ple.ple_information18,
  ple.ple_information19,
  ple.ple_information20
	from ota_price_list_entries ple
	where ple.price_list_id = p_old_tpl_id
	and ((p_proc_use = 2
             and ple.start_date >= nvl(p_starting_from,hr_api.g_sot)
             and not (ple.start_date > nvl(p_enddate,hr_api.g_eot)
                   or nvl(ple.end_date,hr_api.g_eot)
                    < nvl(p_increase_date,hr_api.g_sot)
                     )
            )
	or p_proc_use <>2);

Line: 901

select start_date,end_date
from ota_activity_versions
where activity_version_id = l_activity_version_id;

Line: 1007

hr_utility.trace('Inserting Entry');

Line: 1050

hr_utility.trace('Inserting the remainder of the entry with old price');

Line: 1069

hr_utility.trace('Inserting new entry with updated price');

Line: 1088

hr_utility.trace('Inserting entry with new price');

Line: 1100

hr_utility.trace('Inserting the remainder of the entry with old price');

Line: 1213

	p_select_entries	char,
	p_starting_from		date
)
is
---------------
l_enddate	date;

Line: 1224

if not ( (p_select_entries='S' and p_starting_from is not null)
        or (p_select_entries='A' and p_starting_from is null) ) then
            constraint_error2('Copy_entries_wrong_parameters');

Line: 1347

    select *
      from ota_price_list_entries      ple
     where ple.activity_version_id     =  p_activity_version_from;

Line: 1413

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

Line: 1421

	insert_validate2(p_rec);

Line: 1426

End insert_validate;

Line: 1488

    select start_date
    from ota_price_lists
    where price_list_id = p_old_tpl_id;

Line: 1521

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

Line: 1529

	update_validate2(p_rec);

Line: 1534

End update_validate;

Line: 1539

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

Line: 1547

	delete_validate2(p_rec);

Line: 1550

End delete_validate;