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_EVENT_BK2 SQL Statements

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

Line: 5


procedure UPDATE_CLASS_A
(P_EFFECTIVE_DATE in DATE
,P_VENDOR_ID in NUMBER
,P_ACTIVITY_VERSION_ID in NUMBER
,P_BUSINESS_GROUP_ID in NUMBER
,P_ORGANIZATION_ID in NUMBER
,P_EVENT_TYPE in VARCHAR2
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_TITLE in VARCHAR2
,P_BUDGET_COST in NUMBER
,P_ACTUAL_COST in NUMBER
,P_BUDGET_CURRENCY_CODE in VARCHAR2
,P_CENTRE in VARCHAR2
,P_COMMENTS in VARCHAR2
,P_COURSE_END_DATE in DATE
,P_COURSE_END_TIME in VARCHAR2
,P_COURSE_START_DATE in DATE
,P_COURSE_START_TIME in VARCHAR2
,P_DURATION in NUMBER
,P_DURATION_UNITS in VARCHAR2
,P_ENROLMENT_END_DATE in DATE
,P_ENROLMENT_START_DATE in DATE
,P_LANGUAGE_ID in NUMBER
,P_USER_STATUS in VARCHAR2
,P_DEVELOPMENT_EVENT_TYPE in VARCHAR2
,P_EVENT_STATUS in VARCHAR2
,P_PRICE_BASIS in VARCHAR2
,P_CURRENCY_CODE in VARCHAR2
,P_MAXIMUM_ATTENDEES in NUMBER
,P_MAXIMUM_INTERNAL_ATTENDEES in NUMBER
,P_MINIMUM_ATTENDEES in NUMBER
,P_STANDARD_PRICE in NUMBER
,P_CATEGORY_CODE in VARCHAR2
,P_PARENT_EVENT_ID in NUMBER
,P_BOOK_INDEPENDENT_FLAG in VARCHAR2
,P_PUBLIC_EVENT_FLAG in VARCHAR2
,P_SECURE_EVENT_FLAG in VARCHAR2
,P_EVT_INFORMATION_CATEGORY in VARCHAR2
,P_EVT_INFORMATION1 in VARCHAR2
,P_EVT_INFORMATION2 in VARCHAR2
,P_EVT_INFORMATION3 in VARCHAR2
,P_EVT_INFORMATION4 in VARCHAR2
,P_EVT_INFORMATION5 in VARCHAR2
,P_EVT_INFORMATION6 in VARCHAR2
,P_EVT_INFORMATION7 in VARCHAR2
,P_EVT_INFORMATION8 in VARCHAR2
,P_EVT_INFORMATION9 in VARCHAR2
,P_EVT_INFORMATION10 in VARCHAR2
,P_EVT_INFORMATION11 in VARCHAR2
,P_EVT_INFORMATION12 in VARCHAR2
,P_EVT_INFORMATION13 in VARCHAR2
,P_EVT_INFORMATION14 in VARCHAR2
,P_EVT_INFORMATION15 in VARCHAR2
,P_EVT_INFORMATION16 in VARCHAR2
,P_EVT_INFORMATION17 in VARCHAR2
,P_EVT_INFORMATION18 in VARCHAR2
,P_EVT_INFORMATION19 in VARCHAR2
,P_EVT_INFORMATION20 in VARCHAR2
,P_PROJECT_ID in NUMBER
,P_OWNER_ID in NUMBER
,P_LINE_ID in NUMBER
,P_ORG_ID in NUMBER
,P_TRAINING_CENTER_ID in NUMBER
,P_LOCATION_ID in NUMBER
,P_OFFERING_ID in NUMBER
,P_TIMEZONE in VARCHAR2
,P_PARENT_OFFERING_ID in NUMBER
,P_DATA_SOURCE in VARCHAR2
,P_EVENT_ID in NUMBER
)is
begin
hr_utility.set_location('Entering: OTA_EVENT_BK2.UPDATE_CLASS_A', 10);

Line: 77


hr_utility.set_location(' Leaving: OTA_EVENT_BK2.UPDATE_CLASS_A', 20);

Line: 78


end UPDATE_CLASS_A;

Line: 79


procedure UPDATE_CLASS_B
(P_EFFECTIVE_DATE in DATE
,P_VENDOR_ID in NUMBER
,P_ACTIVITY_VERSION_ID in NUMBER
,P_BUSINESS_GROUP_ID in NUMBER
,P_ORGANIZATION_ID in NUMBER
,P_EVENT_TYPE in VARCHAR2
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_TITLE in VARCHAR2
,P_BUDGET_COST in NUMBER
,P_ACTUAL_COST in NUMBER
,P_BUDGET_CURRENCY_CODE in VARCHAR2
,P_CENTRE in VARCHAR2
,P_COMMENTS in VARCHAR2
,P_COURSE_END_DATE in DATE
,P_COURSE_END_TIME in VARCHAR2
,P_COURSE_START_DATE in DATE
,P_COURSE_START_TIME in VARCHAR2
,P_DURATION in NUMBER
,P_DURATION_UNITS in VARCHAR2
,P_ENROLMENT_END_DATE in DATE
,P_ENROLMENT_START_DATE in DATE
,P_LANGUAGE_ID in NUMBER
,P_USER_STATUS in VARCHAR2
,P_DEVELOPMENT_EVENT_TYPE in VARCHAR2
,P_EVENT_STATUS in VARCHAR2
,P_PRICE_BASIS in VARCHAR2
,P_CURRENCY_CODE in VARCHAR2
,P_MAXIMUM_ATTENDEES in NUMBER
,P_MAXIMUM_INTERNAL_ATTENDEES in NUMBER
,P_MINIMUM_ATTENDEES in NUMBER
,P_STANDARD_PRICE in NUMBER
,P_CATEGORY_CODE in VARCHAR2
,P_PARENT_EVENT_ID in NUMBER
,P_BOOK_INDEPENDENT_FLAG in VARCHAR2
,P_PUBLIC_EVENT_FLAG in VARCHAR2
,P_SECURE_EVENT_FLAG in VARCHAR2
,P_EVT_INFORMATION_CATEGORY in VARCHAR2
,P_EVT_INFORMATION1 in VARCHAR2
,P_EVT_INFORMATION2 in VARCHAR2
,P_EVT_INFORMATION3 in VARCHAR2
,P_EVT_INFORMATION4 in VARCHAR2
,P_EVT_INFORMATION5 in VARCHAR2
,P_EVT_INFORMATION6 in VARCHAR2
,P_EVT_INFORMATION7 in VARCHAR2
,P_EVT_INFORMATION8 in VARCHAR2
,P_EVT_INFORMATION9 in VARCHAR2
,P_EVT_INFORMATION10 in VARCHAR2
,P_EVT_INFORMATION11 in VARCHAR2
,P_EVT_INFORMATION12 in VARCHAR2
,P_EVT_INFORMATION13 in VARCHAR2
,P_EVT_INFORMATION14 in VARCHAR2
,P_EVT_INFORMATION15 in VARCHAR2
,P_EVT_INFORMATION16 in VARCHAR2
,P_EVT_INFORMATION17 in VARCHAR2
,P_EVT_INFORMATION18 in VARCHAR2
,P_EVT_INFORMATION19 in VARCHAR2
,P_EVT_INFORMATION20 in VARCHAR2
,P_PROJECT_ID in NUMBER
,P_OWNER_ID in NUMBER
,P_LINE_ID in NUMBER
,P_ORG_ID in NUMBER
,P_TRAINING_CENTER_ID in NUMBER
,P_LOCATION_ID in NUMBER
,P_OFFERING_ID in NUMBER
,P_TIMEZONE in VARCHAR2
,P_PARENT_OFFERING_ID in NUMBER
,P_DATA_SOURCE in VARCHAR2
,P_EVENT_ID in NUMBER
)is
begin
hr_utility.set_location('Entering: OTA_EVENT_BK2.UPDATE_CLASS_B', 10);

Line: 151


hr_utility.set_location(' Leaving: OTA_EVENT_BK2.UPDATE_CLASS_B', 20);

Line: 152


end UPDATE_CLASS_B;