DBA Data[Home] [Help]

APPS.OTA_BST_API SQL Statements

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

Line: 169

    select BST.BOOKING_STATUS_TYPE_ID
      from OTA_BOOKING_STATUS_TYPES_VL          BST
      where BST.BUSINESS_GROUP_ID             = P_BUSINESS_GROUP_ID
        and BST.NAME                          = P_NAME;
Line: 204

	select BST.NAME
 	  from OTA_BOOKING_STATUS_TYPES_TL		BST
	  where BST.BOOKING_STATUS_TYPE_ID    = P_BOOKING_STATUS_TYPE_ID
            and BST.LANGUAGE = USERENV('LANG');
Line: 250

    select BST.BOOKING_STATUS_TYPE_ID,
           BST.NAME
      from OTA_BOOKING_STATUS_TYPES_VL     BST
      where BST.BUSINESS_GROUP_ID   = P_BUSINESS_GROUP_ID
      and BST.DEFAULT_FLAG          = 'Y'
      and BST.TYPE                 <> 'C'
      and ((P_EVENT_STATUS = 'F' AND    --  Bug #1870097.  For status 'F' use Waitlist as default, for status 'P' use either Waitlisted or Requested
            BST.TYPE = 'W')
           or (P_EVENT_STATUS = 'P' AND
               BST.TYPE IN ('R', 'W'))
           or P_EVENT_STATUS NOT IN ('F', 'P'))
      order by BST.TYPE;
Line: 296

		select 'NO'
		  from OTA_BOOKING_STATUS_TYPES_VL BST
		  where BST.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
		    and upper (BST.NAME)      =	upper (P_NAME)
		    and (    (P_BOOKING_STATUS_TYPE_ID
					     is null)
		         or  (BST.BOOKING_STATUS_TYPE_ID
					     <> P_BOOKING_STATUS_TYPE_ID));
Line: 345

    select BST.NAME
      from OTA_BOOKING_STATUS_TYPES_VL     BST
      where BST.BUSINESS_GROUP_ID   = P_BUSINESS_GROUP_ID
      and BST.TYPE                  = P_TYPE
      and BST.DEFAULT_FLAG          = 'Y';
Line: 428

		select 'NO'
		  from OTA_BOOKING_STATUS_HISTORIES
						BSH
		  where BSH.BOOKING_STATUS_TYPE_ID
					      = P_BOOKING_STATUS_TYPE_ID;
Line: 470

		select 'NO'
		  from OTA_DELEGATE_BOOKINGS	TDB
		  where TDB.BOOKING_STATUS_TYPE_ID
					      = P_BOOKING_STATUS_TYPE_ID;
Line: 509

		select 'NO'
		  from OTA_BOOKING_STATUS_EXCL	BSE
		  where BSE.BOOKING_STATUS_TYPE_ID
					      = P_BOOKING_STATUS_TYPE_ID;
Line: 523

		fnd_message.set_name('OTA','OTA_443877_BST_DELETE_CHK');
Line: 580

    select
		booking_status_type_id,
	business_group_id,
	active_flag,
	default_flag,
	name,
	object_version_number,
	type,
	comments,
	description,
	bst_information_category,
	bst_information1,
	bst_information2,
	bst_information3,
	bst_information4,
	bst_information5,
	bst_information6,
	bst_information7,
	bst_information8,
	bst_information9,
	bst_information10,
	bst_information11,
	bst_information12,
	bst_information13,
	bst_information14,
	bst_information15,
	bst_information16,
	bst_information17,
	bst_information18,
	bst_information19,
	bst_information20
    from	ota_booking_status_types_vl
    where	booking_status_type_id = p_booking_status_type_id;
Line: 681

    select pbg.security_group_id,
           pbg.legislation_code
      from per_business_groups_perf pbg
         , ota_booking_status_types bst
     where bst.booking_status_type_id = p_booking_status_type_id
       and pbg.business_group_id = bst.business_group_id;
Line: 752

    select pbg.legislation_code
      from per_business_groups_perf pbg
         , ota_booking_status_types bst
     where bst.booking_status_type_id = p_booking_status_type_id
       and pbg.business_group_id = bst.business_group_id;
Line: 872

Procedure insert_dml(p_rec in out nocopy g_rec_type) is
--
  W_PROC	varchar2(72) := G_PACKAGE||'insert_dml';
Line: 884

  insert into ota_booking_status_types
  (	booking_status_type_id,
	business_group_id,
	active_flag,
	default_flag,
	name,
	object_version_number,
	type,
	comments,
	description,
	bst_information_category,
	bst_information1,
	bst_information2,
	bst_information3,
	bst_information4,
	bst_information5,
	bst_information6,
	bst_information7,
	bst_information8,
	bst_information9,
	bst_information10,
	bst_information11,
	bst_information12,
	bst_information13,
	bst_information14,
	bst_information15,
	bst_information16,
	bst_information17,
	bst_information18,
	bst_information19,
	bst_information20
  )
  Values
  (	p_rec.booking_status_type_id,
	p_rec.business_group_id,
	p_rec.active_flag,
	p_rec.default_flag,
	p_rec.name,
	p_rec.object_version_number,
	p_rec.type,
	p_rec.comments,
	p_rec.description,
	p_rec.bst_information_category,
	p_rec.bst_information1,
	p_rec.bst_information2,
	p_rec.bst_information3,
	p_rec.bst_information4,
	p_rec.bst_information5,
	p_rec.bst_information6,
	p_rec.bst_information7,
	p_rec.bst_information8,
	p_rec.bst_information9,
	p_rec.bst_information10,
	p_rec.bst_information11,
	p_rec.bst_information12,
	p_rec.bst_information13,
	p_rec.bst_information14,
	p_rec.bst_information15,
	p_rec.bst_information16,
	p_rec.bst_information17,
	p_rec.bst_information18,
	p_rec.bst_information19,
	p_rec.bst_information20
  );
Line: 971

End insert_dml;
Line: 1014

Procedure update_dml(p_rec in out nocopy g_rec_type) is
--
  W_PROC	varchar2(72) := G_PACKAGE||'update_dml';
Line: 1029

  update ota_booking_status_types
  set
  booking_status_type_id            = p_rec.booking_status_type_id,
  business_group_id                 = p_rec.business_group_id,
  active_flag                       = p_rec.active_flag,
  default_flag                      = p_rec.default_flag,
  name                              = p_rec.name,
  object_version_number             = p_rec.object_version_number,
  type                              = p_rec.type,
  comments                          = p_rec.comments,
  description                       = p_rec.description,
  bst_information_category          = p_rec.bst_information_category,
  bst_information1                  = p_rec.bst_information1,
  bst_information2                  = p_rec.bst_information2,
  bst_information3                  = p_rec.bst_information3,
  bst_information4                  = p_rec.bst_information4,
  bst_information5                  = p_rec.bst_information5,
  bst_information6                  = p_rec.bst_information6,
  bst_information7                  = p_rec.bst_information7,
  bst_information8                  = p_rec.bst_information8,
  bst_information9                  = p_rec.bst_information9,
  bst_information10                 = p_rec.bst_information10,
  bst_information11                 = p_rec.bst_information11,
  bst_information12                 = p_rec.bst_information12,
  bst_information13                 = p_rec.bst_information13,
  bst_information14                 = p_rec.bst_information14,
  bst_information15                 = p_rec.bst_information15,
  bst_information16                 = p_rec.bst_information16,
  bst_information17                 = p_rec.bst_information17,
  bst_information18                 = p_rec.bst_information18,
  bst_information19                 = p_rec.bst_information19,
  bst_information20                 = p_rec.bst_information20
  where booking_status_type_id = p_rec.booking_status_type_id;
Line: 1086

End update_dml;
Line: 1126

Procedure delete_dml(p_rec in g_rec_type) is
--
  W_PROC	varchar2(72) := G_PACKAGE||'delete_dml';
Line: 1137

  delete from ota_booking_status_types
  where booking_status_type_id = p_rec.booking_status_type_id;
Line: 1153

End delete_dml;
Line: 1189

Procedure pre_insert(p_rec  in out nocopy g_rec_type) is
--
  W_PROC	varchar2(72) := G_PACKAGE||'pre_insert';
Line: 1193

  Cursor C_Sel1 is select ota_booking_status_types_s.nextval from sys.dual;
Line: 1206

End pre_insert;
Line: 1237

Procedure pre_update(p_rec in g_rec_type) is
--
  W_PROC	varchar2(72) := G_PACKAGE||'pre_update';
Line: 1245

End pre_update;
Line: 1276

Procedure pre_delete(p_rec in g_rec_type) is
--
  W_PROC	varchar2(72) := G_PACKAGE||'pre_delete';
Line: 1284

End pre_delete;
Line: 1315

Procedure post_insert(p_rec in g_rec_type) is
--
  W_PROC	varchar2(72) := G_PACKAGE||'post_insert';
Line: 1323

End post_insert;
Line: 1354

Procedure post_update(p_rec in g_rec_type) is
--
  W_PROC	varchar2(72) := G_PACKAGE||'post_update';
Line: 1362

End post_update;
Line: 1393

Procedure post_delete(p_rec in g_rec_type) is
--
  W_PROC	varchar2(72) := G_PACKAGE||'post_delete';
Line: 1401

End post_delete;
Line: 1415

    select 	booking_status_type_id,
	business_group_id,
	active_flag,
	default_flag,
	name,
	object_version_number,
	type,
	comments,
	description,
	bst_information_category,
	bst_information1,
	bst_information2,
	bst_information3,
	bst_information4,
	bst_information5,
	bst_information6,
	bst_information7,
	bst_information8,
	bst_information9,
	bst_information10,
	bst_information11,
	bst_information12,
	bst_information13,
	bst_information14,
	bst_information15,
	bst_information16,
	bst_information17,
	bst_information18,
	bst_information19,
	bst_information20
    from	ota_booking_status_types
    where	booking_status_type_id = p_booking_status_type_id
    for	update nowait;
Line: 1775

Procedure insert_validate(p_rec in g_rec_type) is
--
  W_PROC	varchar2(72) := G_PACKAGE||'insert_validate';
Line: 1791

End insert_validate;
Line: 1822

Procedure update_validate(p_rec in g_rec_type) is
--
  l_default_flag_changed boolean :=
       ota_general.value_changed(g_old_rec.default_flag,
                                 p_rec.default_flag);
Line: 1828

  W_PROC	varchar2(72) := G_PACKAGE||'update_validate';
Line: 1843

End update_validate;
Line: 1874

Procedure delete_validate(p_rec in g_rec_type) is
--
  W_PROC	varchar2(72) := G_PACKAGE||'delete_validate';
Line: 1894

End delete_validate;
Line: 1921

  insert_validate(p_rec);
Line: 1925

  pre_insert(p_rec);
Line: 1929

  insert_dml(p_rec);
Line: 1933

  post_insert(p_rec);
Line: 2084

  update_validate(convert_defs(p_rec));
Line: 2088

  pre_update(p_rec);
Line: 2092

  update_dml(p_rec);
Line: 2096

  post_update(p_rec);
Line: 2239

  delete_validate(p_rec);
Line: 2243

  pre_delete(p_rec);
Line: 2247

  delete_dml(p_rec);
Line: 2251

  post_delete(p_rec);