The following lines contain the word 'select', 'insert', 'update' or 'delete':
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;
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');
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;
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));
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';
select 'NO'
from OTA_BOOKING_STATUS_HISTORIES
BSH
where BSH.BOOKING_STATUS_TYPE_ID
= P_BOOKING_STATUS_TYPE_ID;
select 'NO'
from OTA_DELEGATE_BOOKINGS TDB
where TDB.BOOKING_STATUS_TYPE_ID
= P_BOOKING_STATUS_TYPE_ID;
select 'NO'
from OTA_BOOKING_STATUS_EXCL BSE
where BSE.BOOKING_STATUS_TYPE_ID
= P_BOOKING_STATUS_TYPE_ID;
fnd_message.set_name('OTA','OTA_443877_BST_DELETE_CHK');
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;
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;
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;
Procedure insert_dml(p_rec in out nocopy g_rec_type) is
--
W_PROC varchar2(72) := G_PACKAGE||'insert_dml';
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
);
End insert_dml;
Procedure update_dml(p_rec in out nocopy g_rec_type) is
--
W_PROC varchar2(72) := G_PACKAGE||'update_dml';
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;
End update_dml;
Procedure delete_dml(p_rec in g_rec_type) is
--
W_PROC varchar2(72) := G_PACKAGE||'delete_dml';
delete from ota_booking_status_types
where booking_status_type_id = p_rec.booking_status_type_id;
End delete_dml;
Procedure pre_insert(p_rec in out nocopy g_rec_type) is
--
W_PROC varchar2(72) := G_PACKAGE||'pre_insert';
Cursor C_Sel1 is select ota_booking_status_types_s.nextval from sys.dual;
End pre_insert;
Procedure pre_update(p_rec in g_rec_type) is
--
W_PROC varchar2(72) := G_PACKAGE||'pre_update';
End pre_update;
Procedure pre_delete(p_rec in g_rec_type) is
--
W_PROC varchar2(72) := G_PACKAGE||'pre_delete';
End pre_delete;
Procedure post_insert(p_rec in g_rec_type) is
--
W_PROC varchar2(72) := G_PACKAGE||'post_insert';
End post_insert;
Procedure post_update(p_rec in g_rec_type) is
--
W_PROC varchar2(72) := G_PACKAGE||'post_update';
End post_update;
Procedure post_delete(p_rec in g_rec_type) is
--
W_PROC varchar2(72) := G_PACKAGE||'post_delete';
End post_delete;
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;
Procedure insert_validate(p_rec in g_rec_type) is
--
W_PROC varchar2(72) := G_PACKAGE||'insert_validate';
End insert_validate;
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);
W_PROC varchar2(72) := G_PACKAGE||'update_validate';
End update_validate;
Procedure delete_validate(p_rec in g_rec_type) is
--
W_PROC varchar2(72) := G_PACKAGE||'delete_validate';
End delete_validate;
insert_validate(p_rec);
pre_insert(p_rec);
insert_dml(p_rec);
post_insert(p_rec);
update_validate(convert_defs(p_rec));
pre_update(p_rec);
update_dml(p_rec);
post_update(p_rec);
delete_validate(p_rec);
pre_delete(p_rec);
delete_dml(p_rec);
post_delete(p_rec);