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_BULK_ENROLL_UTIL dependencies on OTA_EVENTS

Line 131: l_event_status ota_events.event_status%TYPE;

127: l_enrolled_places number;
128: l_max_enroll number;
129: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
130: l_max_internal number;
131: l_event_status ota_events.event_status%TYPE;
132: l_maximum_internal_allowed number;
133:
134: BEGIN
135: OPEN get_enrolled_places;

Line 141: FROM ota_events

137: CLOSE get_enrolled_places;
138:
139: select MAXIMUM_INTERNAL_ATTENDEES, MAXIMUM_ATTENDEES, event_status
140: INTO l_max_internal, l_max_enroll, l_event_status
141: FROM ota_events
142: WHERE event_id = p_class_id;
143:
144: l_maximum_internal_allowed := nvl(l_max_internal,l_max_enroll) - nvl(l_enrolled_places,0);
145:

Line 223: ota_events evt

219: CURSOR get_unfulfil_crs_prereq IS
220: SELECT count(person_id)
221: FROM ota_bulk_enr_req_members brm,
222: ota_bulk_enr_requests ber,
223: ota_events evt
224: WHERE ber.bulk_enr_request_id = brm.bulk_enr_request_id
225: AND ber.bulk_enr_request_id = p_bulk_enr_request_id
226: AND evt.event_id = ber.object_id
227: AND ber.object_type = 'CL'

Line 238: ota_events evt

234: CURSOR get_unfulfil_comp_prereqs IS
235: SELECT count(person_id)
236: FROM ota_bulk_enr_req_members brm,
237: ota_bulk_enr_requests ber,
238: ota_events evt
239: WHERE ber.bulk_enr_request_id = brm.bulk_enr_request_id
240: AND ber.bulk_enr_request_id = p_bulk_enr_request_id
241: AND evt.event_id = ber.object_id
242: AND ber.object_type = 'CL'

Line 417: CURSOR bg_to (pp_event_id ota_events.event_id%TYPE) IS

413: ,p_override_learner_access IN VARCHAR2
414: ,p_is_mandatory_enrollment IN VARCHAR2 default 'N')
415: IS
416:
417: CURSOR bg_to (pp_event_id ota_events.event_id%TYPE) IS
418: SELECT hao.business_group_id,
419: evt.organization_id,
420: evt.currency_code,
421: evt.course_start_date,

Line 427: FROM OTA_EVENTS_VL evt,

423: evt.Title,
424: evt.owner_id,
425: off.activity_version_id,
426: evt.offering_id
427: FROM OTA_EVENTS_VL evt,
428: OTA_OFFERINGS off,
429: HR_ALL_ORGANIZATION_UNITS hao
430: WHERE evt.event_id = pp_event_id
431: AND off.offering_id = evt.parent_offering_id

Line 437: from OTA_EVENTS

433:
434:
435: Cursor Get_Event_status is
436: Select event_status, maximum_internal_attendees, maximum_attendees
437: from OTA_EVENTS
438: WHERE EVENT_ID = TO_NUMBER(p_event_id);
439:
440: CURSOR get_existing_internal IS
441: SELECT sum(nvl(dbt.number_of_places, 0))

Line 460: FROM ota_events

456:
457:
458: CURSOR c_get_price_basis is
459: SELECT nvl(price_basis,NULL)
460: FROM ota_events
461: where event_id = p_event_id;
462:
463: CURSOR csr_user(p_owner_id in number) IS
464: SELECT

Line 548: l_price_basis OTA_EVENTS.price_basis%TYPE;

544: AND pfax.PHONE_TYPE(+) = 'WF'
545: AND trunc(sysdate) BETWEEN NVL(pfax.DATE_FROM(+), SYSDATE) AND NVL(pfax.DATE_TO(+), SYSDATE);
546:
547:
548: l_price_basis OTA_EVENTS.price_basis%TYPE;
549:
550: l_person_details csr_get_assignment_details%ROWTYPE;
551: --
552: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;

Line 594: l_event_currency_code ota_events.currency_code%type;

590:
591: l_called_from VARCHAR2(80);
592: l_business_group_id_to hr_all_organization_units.organization_id%type;
593: l_sponsor_organization_id hr_all_organization_units.organization_id%type;
594: l_event_currency_code ota_events.currency_code%type;
595: l_event_title ota_events.title%type;
596: l_course_start_date ota_events.course_start_date%type;
597: l_course_end_date ota_events.course_end_date%type;
598: l_owner_id ota_events.owner_id%type;

Line 595: l_event_title ota_events.title%type;

591: l_called_from VARCHAR2(80);
592: l_business_group_id_to hr_all_organization_units.organization_id%type;
593: l_sponsor_organization_id hr_all_organization_units.organization_id%type;
594: l_event_currency_code ota_events.currency_code%type;
595: l_event_title ota_events.title%type;
596: l_course_start_date ota_events.course_start_date%type;
597: l_course_end_date ota_events.course_end_date%type;
598: l_owner_id ota_events.owner_id%type;
599: l_activity_version_id ota_activity_versions.activity_version_id%type;

Line 596: l_course_start_date ota_events.course_start_date%type;

592: l_business_group_id_to hr_all_organization_units.organization_id%type;
593: l_sponsor_organization_id hr_all_organization_units.organization_id%type;
594: l_event_currency_code ota_events.currency_code%type;
595: l_event_title ota_events.title%type;
596: l_course_start_date ota_events.course_start_date%type;
597: l_course_end_date ota_events.course_end_date%type;
598: l_owner_id ota_events.owner_id%type;
599: l_activity_version_id ota_activity_versions.activity_version_id%type;
600: l_version_name ota_activity_versions.version_name%type;

Line 597: l_course_end_date ota_events.course_end_date%type;

593: l_sponsor_organization_id hr_all_organization_units.organization_id%type;
594: l_event_currency_code ota_events.currency_code%type;
595: l_event_title ota_events.title%type;
596: l_course_start_date ota_events.course_start_date%type;
597: l_course_end_date ota_events.course_end_date%type;
598: l_owner_id ota_events.owner_id%type;
599: l_activity_version_id ota_activity_versions.activity_version_id%type;
600: l_version_name ota_activity_versions.version_name%type;
601: l_owner_username fnd_user.user_name%type;

Line 598: l_owner_id ota_events.owner_id%type;

594: l_event_currency_code ota_events.currency_code%type;
595: l_event_title ota_events.title%type;
596: l_course_start_date ota_events.course_start_date%type;
597: l_course_end_date ota_events.course_end_date%type;
598: l_owner_id ota_events.owner_id%type;
599: l_activity_version_id ota_activity_versions.activity_version_id%type;
600: l_version_name ota_activity_versions.version_name%type;
601: l_owner_username fnd_user.user_name%type;
602: l_offering_id ota_events.offering_id%type;

Line 602: l_offering_id ota_events.offering_id%type;

598: l_owner_id ota_events.owner_id%type;
599: l_activity_version_id ota_activity_versions.activity_version_id%type;
600: l_version_name ota_activity_versions.version_name%type;
601: l_owner_username fnd_user.user_name%type;
602: l_offering_id ota_events.offering_id%type;
603: l_booking_status_used VARCHAR2(20);
604:
605: l_existing_bookings NUMBER;
606: l_maximum_external_allowed NUMBER;

Line 1154: FROM ota_events_tl

1150: AND language = USERENV('LANG');
1151:
1152: CURSOR csr_get_class_name IS
1153: SELECT title
1154: FROM ota_events_tl
1155: WHERE event_id = p_object_id
1156: AND language = USERENV('LANG');
1157:
1158: l_class_name OTA_EVENTS_TL.TITLE%TYPE := NULL;

Line 1158: l_class_name OTA_EVENTS_TL.TITLE%TYPE := NULL;

1154: FROM ota_events_tl
1155: WHERE event_id = p_object_id
1156: AND language = USERENV('LANG');
1157:
1158: l_class_name OTA_EVENTS_TL.TITLE%TYPE := NULL;
1159: l_lp_name OTA_LEARNING_PATHS_TL.NAME%TYPE := NULL;
1160: l_cert_name OTA_CERTIFICATIONS_TL.NAME%TYPE := NULL;
1161: BEGIN
1162: IF p_object_type = 'CL' THEN