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

Line 213: ota_events where

209: l_return_value Varchar2(2000);
210:
211: cursor getcount
212: is select count(event_id) from
213: ota_events where
214: parent_event_id = peventid and
215: parent_event_id is not null;
216:
217: begin

Line 332: l_event_title ota_events_tl.title%type; --MLS Change added _tl

328: x_course_end_date out nocopy date,
329: x_return_status out nocopy varchar2)
330: IS
331:
332: l_event_title ota_events_tl.title%type; --MLS Change added _tl
333: l_start_date date;
334: l_end_date date;
335: l_full_name ota_customer_contacts_v.full_name%type;
336: l_contact_id hz_cust_account_roles.cust_account_role_id%type;

Line 366: ota_Events_vl evt, --MLS change _vl added

362: evt.Course_End_Date,
363: tdb.delegate_contact_id
364: From
365: ota_Delegate_bookings tdb,
366: ota_Events_vl evt, --MLS change _vl added
367: ota_activity_versions_tl tav -- MLS change _tl added
368: Where
369: evt.event_id = tdb.event_id and
370: tdb.line_id = p_line_id and

Line 391: FROM ota_events_vl evt, -- MLS change _vl added

387: evt.title,
388: evt.Course_Start_Date,
389: evt.course_End_Date,
390: evt.Maximum_Attendees
391: FROM ota_events_vl evt, -- MLS change _vl added
392: ota_activity_versions_tl tav --MLS change _tl added
393: WHERE evt.line_id = p_line_id and
394: evt.activity_version_id = tav.activity_version_id;
395:

Line 757: OTA_EVENTS

753: CURSOR C_event
754: IS
755: Select null
756: FROM
757: OTA_EVENTS
758: WHERE
759: Line_id = p_line_id;
760:
761:

Line 991: ota_events ev,

987: cursor c_other_person_bookings is
988: select bst.type
989: from ota_delegate_bookings db,
990: ota_booking_status_types bst,
991: ota_events ev,
992: ota_events evt
993: where db.delegate_person_id = p_delegate_person_id
994: and db.booking_status_type_id = bst.booking_status_type_id
995: and bst.type <> g_cancelled_booking

Line 992: ota_events evt

988: select bst.type
989: from ota_delegate_bookings db,
990: ota_booking_status_types bst,
991: ota_events ev,
992: ota_events evt
993: where db.delegate_person_id = p_delegate_person_id
994: and db.booking_status_type_id = bst.booking_status_type_id
995: and bst.type <> g_cancelled_booking
996: and db.event_id = ev.event_id

Line 1018: ota_events ev,

1014: cursor c_other_contact_bookings is
1015: select bst.type
1016: from ota_delegate_bookings db,
1017: ota_booking_status_types bst,
1018: ota_events ev,
1019: ota_events evt
1020: where db.delegate_contact_id = p_delegate_contact_id
1021: and db.booking_status_type_id = bst.booking_status_type_id
1022: and bst.type <> g_cancelled_booking

Line 1019: ota_events evt

1015: select bst.type
1016: from ota_delegate_bookings db,
1017: ota_booking_status_types bst,
1018: ota_events ev,
1019: ota_events evt
1020: where db.delegate_contact_id = p_delegate_contact_id
1021: and db.booking_status_type_id = bst.booking_status_type_id
1022: and bst.type <> g_cancelled_booking
1023: and db.event_id = ev.event_id

Line 1543: FROM ota_events e

1539: CURSOR evt_loc_cr
1540: IS
1541: SELECT e.location_id,
1542: e.training_center_id
1543: FROM ota_events e
1544: WHERE e.event_id = p_event_id;
1545:
1546: l_training_center_id ota_events.training_center_id%TYPE;
1547: l_location_id hr_locations_all.location_id%TYPE;

Line 1546: l_training_center_id ota_events.training_center_id%TYPE;

1542: e.training_center_id
1543: FROM ota_events e
1544: WHERE e.event_id = p_event_id;
1545:
1546: l_training_center_id ota_events.training_center_id%TYPE;
1547: l_location_id hr_locations_all.location_id%TYPE;
1548:
1549: CURSOR tc_loc_cr(p_training_center_id ota_events.training_center_id%TYPE)
1550: IS

Line 1549: CURSOR tc_loc_cr(p_training_center_id ota_events.training_center_id%TYPE)

1545:
1546: l_training_center_id ota_events.training_center_id%TYPE;
1547: l_location_id hr_locations_all.location_id%TYPE;
1548:
1549: CURSOR tc_loc_cr(p_training_center_id ota_events.training_center_id%TYPE)
1550: IS
1551: SELECT o.location_id
1552: FROM hr_all_organization_units o
1553: WHERE o.organization_id = p_training_center_id;

Line 2075: FROM ota_events

2071: l_event_count number;
2072:
2073: CURSOR c_get_iln_event_count IS
2074: SELECT count(event_id)
2075: FROM ota_events
2076: WHERE parent_offering_id = p_offering_id and
2077: offering_id is not null;
2078:
2079: CURSOR c_get_event_count IS

Line 2081: FROM ota_events

2077: offering_id is not null;
2078:
2079: CURSOR c_get_event_count IS
2080: SELECT count(event_id)
2081: FROM ota_events
2082: WHERE parent_offering_id = p_offering_id and
2083: event_type in ('SELFPACED','SCHEDULED') and
2084: book_independent_flag = 'N';
2085:

Line 2143: p_event_id IN ota_events.event_id%TYPE,

2139:
2140: -- Author: sbhullar
2141: FUNCTION get_enrollment_status(p_delegate_person_id IN ota_delegate_bookings.delegate_person_id%TYPE,
2142: p_delegate_contact_id IN NUMBER,
2143: p_event_id IN ota_events.event_id%TYPE,
2144: p_code IN number)
2145: RETURN VARCHAR2 IS
2146:
2147: CURSOR enroll_status IS

Line 2583: Function get_event_status_code (p_event_id in ota_events.event_id%TYPE)

2579: -- Access Status
2580: -- Public
2581: -- {End of Comments}
2582: ------------------------------------------------------------------
2583: Function get_event_status_code (p_event_id in ota_events.event_id%TYPE)
2584: return varchar2
2585: IS
2586: l_event_status_code ota_events.event_status%TYPE;
2587:

Line 2586: l_event_status_code ota_events.event_status%TYPE;

2582: ------------------------------------------------------------------
2583: Function get_event_status_code (p_event_id in ota_events.event_id%TYPE)
2584: return varchar2
2585: IS
2586: l_event_status_code ota_events.event_status%TYPE;
2587:
2588: CURSOR c_get_event_status_code
2589: IS
2590: SELECT event_status from ota_events

Line 2590: SELECT event_status from ota_events

2586: l_event_status_code ota_events.event_status%TYPE;
2587:
2588: CURSOR c_get_event_status_code
2589: IS
2590: SELECT event_status from ota_events
2591: where
2592: event_id = p_event_id;
2593:
2594: Begin

Line 2717: p_class_id ota_events.event_id%TYPE)

2713: hr_utility.set_location(' Step:'|| l_proc, 20);
2714: End get_ext_lrnr_party_id;
2715:
2716: FUNCTION is_class_enrollable(
2717: p_class_id ota_events.event_id%TYPE)
2718: RETURN VARCHAR2
2719: IS
2720: --6762989 Added nvl check on enrolment_start_date to avoid java.sql.SQLException: ORA-01843: not a valid month on some dbs.
2721: CURSOR csr_get_class_details IS

Line 2723: FROM ota_events

2719: IS
2720: --6762989 Added nvl check on enrolment_start_date to avoid java.sql.SQLException: ORA-01843: not a valid month on some dbs.
2721: CURSOR csr_get_class_details IS
2722: SELECT null
2723: FROM ota_events
2724: WHERE event_id = p_class_id
2725: --AND trunc(sysdate) between enrolment_start_date and nvl(enrolment_end_date, trunc(sysdate))
2726: AND ota_timezone_util.convert_date(sysdate, to_char(sysdate,'HH24:MI'), ota_timezone_util.get_server_timezone_code, timezone)
2727: BETWEEN to_date(to_char(nvl(enrolment_start_date,trunc(sysdate)),'YYYY/MM/DD') || ' ' || '00:00' , 'YYYY/MM/DD HH24:MI')