eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_TRB_RKU SQL Statements

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

Line: 5


procedure AFTER_UPDATE
(P_EFFECTIVE_DATE in DATE
,P_RESOURCE_BOOKING_ID in NUMBER
,P_SUPPLIED_RESOURCE_ID in NUMBER
,P_EVENT_ID in NUMBER
,P_DATE_BOOKING_PLACED in DATE
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_STATUS in VARCHAR2
,P_ABSOLUTE_PRICE in NUMBER
,P_BOOKING_PERSON_ID in NUMBER
,P_COMMENTS in VARCHAR2
,P_CONTACT_NAME in VARCHAR2
,P_CONTACT_PHONE_NUMBER in VARCHAR2
,P_DELEGATES_PER_UNIT in NUMBER
,P_QUANTITY in NUMBER
,P_REQUIRED_DATE_FROM in DATE
,P_REQUIRED_DATE_TO in DATE
,P_REQUIRED_END_TIME in VARCHAR2
,P_REQUIRED_START_TIME in VARCHAR2
,P_DELIVER_TO in VARCHAR2
,P_PRIMARY_VENUE_FLAG in VARCHAR2
,P_ROLE_TO_PLAY in VARCHAR2
,P_TRB_INFORMATION_CATEGORY in VARCHAR2
,P_TRB_INFORMATION1 in VARCHAR2
,P_TRB_INFORMATION2 in VARCHAR2
,P_TRB_INFORMATION3 in VARCHAR2
,P_TRB_INFORMATION4 in VARCHAR2
,P_TRB_INFORMATION5 in VARCHAR2
,P_TRB_INFORMATION6 in VARCHAR2
,P_TRB_INFORMATION7 in VARCHAR2
,P_TRB_INFORMATION8 in VARCHAR2
,P_TRB_INFORMATION9 in VARCHAR2
,P_TRB_INFORMATION10 in VARCHAR2
,P_TRB_INFORMATION11 in VARCHAR2
,P_TRB_INFORMATION12 in VARCHAR2
,P_TRB_INFORMATION13 in VARCHAR2
,P_TRB_INFORMATION14 in VARCHAR2
,P_TRB_INFORMATION15 in VARCHAR2
,P_TRB_INFORMATION16 in VARCHAR2
,P_TRB_INFORMATION17 in VARCHAR2
,P_TRB_INFORMATION18 in VARCHAR2
,P_TRB_INFORMATION19 in VARCHAR2
,P_TRB_INFORMATION20 in VARCHAR2
,P_DISPLAY_TO_LEARNER_FLAG in VARCHAR2
,P_BOOK_ENTIRE_PERIOD_FLAG in VARCHAR2
,P_CHAT_ID in NUMBER
,P_FORUM_ID in NUMBER
,P_TIMEZONE_CODE in VARCHAR2
,P_SUPPLIED_RESOURCE_ID_O in NUMBER
,P_EVENT_ID_O in NUMBER
,P_DATE_BOOKING_PLACED_O in DATE
,P_OBJECT_VERSION_NUMBER_O in NUMBER
,P_STATUS_O in VARCHAR2
,P_ABSOLUTE_PRICE_O in NUMBER
,P_BOOKING_PERSON_ID_O in NUMBER
,P_COMMENTS_O in VARCHAR2
,P_CONTACT_NAME_O in VARCHAR2
,P_CONTACT_PHONE_NUMBER_O in VARCHAR2
,P_DELEGATES_PER_UNIT_O in NUMBER
,P_QUANTITY_O in NUMBER
,P_REQUIRED_DATE_FROM_O in DATE
,P_REQUIRED_DATE_TO_O in DATE
,P_REQUIRED_END_TIME_O in VARCHAR2
,P_REQUIRED_START_TIME_O in VARCHAR2
,P_DELIVER_TO_O in VARCHAR2
,P_PRIMARY_VENUE_FLAG_O in VARCHAR2
,P_ROLE_TO_PLAY_O in VARCHAR2
,P_TRB_INFORMATION_CATEGORY_O in VARCHAR2
,P_TRB_INFORMATION1_O in VARCHAR2
,P_TRB_INFORMATION2_O in VARCHAR2
,P_TRB_INFORMATION3_O in VARCHAR2
,P_TRB_INFORMATION4_O in VARCHAR2
,P_TRB_INFORMATION5_O in VARCHAR2
,P_TRB_INFORMATION6_O in VARCHAR2
,P_TRB_INFORMATION7_O in VARCHAR2
,P_TRB_INFORMATION8_O in VARCHAR2
,P_TRB_INFORMATION9_O in VARCHAR2
,P_TRB_INFORMATION10_O in VARCHAR2
,P_TRB_INFORMATION11_O in VARCHAR2
,P_TRB_INFORMATION12_O in VARCHAR2
,P_TRB_INFORMATION13_O in VARCHAR2
,P_TRB_INFORMATION14_O in VARCHAR2
,P_TRB_INFORMATION15_O in VARCHAR2
,P_TRB_INFORMATION16_O in VARCHAR2
,P_TRB_INFORMATION17_O in VARCHAR2
,P_TRB_INFORMATION18_O in VARCHAR2
,P_TRB_INFORMATION19_O in VARCHAR2
,P_TRB_INFORMATION20_O in VARCHAR2
,P_DISPLAY_TO_LEARNER_FLAG_O in VARCHAR2
,P_BOOK_ENTIRE_PERIOD_FLAG_O in VARCHAR2
,P_CHAT_ID_O in NUMBER
,P_FORUM_ID_O in NUMBER
,P_TIMEZONE_CODE_O in VARCHAR2
)is
begin
hr_utility.set_location('Entering: OTA_TRB_RKU.AFTER_UPDATE', 10);

Line: 101


hr_utility.set_location(' Leaving: OTA_TRB_RKU.AFTER_UPDATE', 20);

Line: 102


end AFTER_UPDATE;