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.

[Home] [Help]

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 821: OTA_EVENTS

817: CURSOR C_event
818: IS
819: Select null
820: FROM
821: OTA_EVENTS
822: WHERE
823: Line_id = p_line_id;
824:
825:

Line 1055: ota_events ev,

1051: cursor c_other_person_bookings is
1052: select bst.type
1053: from ota_delegate_bookings db,
1054: ota_booking_status_types bst,
1055: ota_events ev,
1056: ota_events evt
1057: where db.delegate_person_id = p_delegate_person_id
1058: and db.booking_status_type_id = bst.booking_status_type_id
1059: and bst.type <> g_cancelled_booking

Line 1056: ota_events evt

1052: select bst.type
1053: from ota_delegate_bookings db,
1054: ota_booking_status_types bst,
1055: ota_events ev,
1056: ota_events evt
1057: where db.delegate_person_id = p_delegate_person_id
1058: and db.booking_status_type_id = bst.booking_status_type_id
1059: and bst.type <> g_cancelled_booking
1060: and db.event_id = ev.event_id

Line 1082: ota_events ev,

1078: cursor c_other_contact_bookings is
1079: select bst.type
1080: from ota_delegate_bookings db,
1081: ota_booking_status_types bst,
1082: ota_events ev,
1083: ota_events evt
1084: where db.delegate_contact_id = p_delegate_contact_id
1085: and db.booking_status_type_id = bst.booking_status_type_id
1086: and bst.type <> g_cancelled_booking

Line 1083: ota_events evt

1079: select bst.type
1080: from ota_delegate_bookings db,
1081: ota_booking_status_types bst,
1082: ota_events ev,
1083: ota_events evt
1084: where db.delegate_contact_id = p_delegate_contact_id
1085: and db.booking_status_type_id = bst.booking_status_type_id
1086: and bst.type <> g_cancelled_booking
1087: and db.event_id = ev.event_id

Line 1607: FROM ota_events e

1603: CURSOR evt_loc_cr
1604: IS
1605: SELECT e.location_id,
1606: e.training_center_id
1607: FROM ota_events e
1608: WHERE e.event_id = p_event_id;
1609:
1610: l_training_center_id ota_events.training_center_id%TYPE;
1611: l_location_id hr_locations_all.location_id%TYPE;

Line 1610: l_training_center_id ota_events.training_center_id%TYPE;

1606: e.training_center_id
1607: FROM ota_events e
1608: WHERE e.event_id = p_event_id;
1609:
1610: l_training_center_id ota_events.training_center_id%TYPE;
1611: l_location_id hr_locations_all.location_id%TYPE;
1612:
1613: CURSOR tc_loc_cr(p_training_center_id ota_events.training_center_id%TYPE)
1614: IS

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

1609:
1610: l_training_center_id ota_events.training_center_id%TYPE;
1611: l_location_id hr_locations_all.location_id%TYPE;
1612:
1613: CURSOR tc_loc_cr(p_training_center_id ota_events.training_center_id%TYPE)
1614: IS
1615: SELECT o.location_id
1616: FROM hr_all_organization_units o
1617: WHERE o.organization_id = p_training_center_id;

Line 2139: FROM ota_events

2135: l_event_count number;
2136:
2137: CURSOR c_get_iln_event_count IS
2138: SELECT count(event_id)
2139: FROM ota_events
2140: WHERE parent_offering_id = p_offering_id and
2141: offering_id is not null;
2142:
2143: CURSOR c_get_event_count IS

Line 2145: FROM ota_events

2141: offering_id is not null;
2142:
2143: CURSOR c_get_event_count IS
2144: SELECT count(event_id)
2145: FROM ota_events
2146: WHERE parent_offering_id = p_offering_id and
2147: event_type in ('SELFPACED','SCHEDULED') and
2148: book_independent_flag = 'N';
2149:

Line 2207: p_event_id IN ota_events.event_id%TYPE,

2203:
2204: -- Author: sbhullar
2205: FUNCTION get_enrollment_status(p_delegate_person_id IN ota_delegate_bookings.delegate_person_id%TYPE,
2206: p_delegate_contact_id IN NUMBER,
2207: p_event_id IN ota_events.event_id%TYPE,
2208: p_code IN number)
2209: RETURN VARCHAR2 IS
2210:
2211: CURSOR enroll_status IS

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

2643: -- Access Status
2644: -- Public
2645: -- {End of Comments}
2646: ------------------------------------------------------------------
2647: Function get_event_status_code (p_event_id in ota_events.event_id%TYPE)
2648: return varchar2
2649: IS
2650: l_event_status_code ota_events.event_status%TYPE;
2651:

Line 2650: l_event_status_code ota_events.event_status%TYPE;

2646: ------------------------------------------------------------------
2647: Function get_event_status_code (p_event_id in ota_events.event_id%TYPE)
2648: return varchar2
2649: IS
2650: l_event_status_code ota_events.event_status%TYPE;
2651:
2652: CURSOR c_get_event_status_code
2653: IS
2654: SELECT event_status from ota_events

Line 2654: SELECT event_status from ota_events

2650: l_event_status_code ota_events.event_status%TYPE;
2651:
2652: CURSOR c_get_event_status_code
2653: IS
2654: SELECT event_status from ota_events
2655: where
2656: event_id = p_event_id;
2657:
2658: Begin

Line 2781: p_class_id ota_events.event_id%TYPE)

2777: hr_utility.set_location(' Step:'|| l_proc, 20);
2778: End get_ext_lrnr_party_id;
2779:
2780: FUNCTION is_class_enrollable(
2781: p_class_id ota_events.event_id%TYPE)
2782: RETURN VARCHAR2
2783: IS
2784: --6762989 Added nvl check on enrolment_start_date to avoid java.sql.SQLException: ORA-01843: not a valid month on some dbs.
2785: CURSOR csr_get_class_details IS

Line 2787: FROM ota_events

2783: IS
2784: --6762989 Added nvl check on enrolment_start_date to avoid java.sql.SQLException: ORA-01843: not a valid month on some dbs.
2785: CURSOR csr_get_class_details IS
2786: SELECT null
2787: FROM ota_events
2788: WHERE event_id = p_class_id
2789: --AND trunc(sysdate) between enrolment_start_date and nvl(enrolment_end_date, trunc(sysdate))
2790: AND ota_timezone_util.convert_date(sysdate, to_char(sysdate,'HH24:MI'), ota_timezone_util.get_server_timezone_code, timezone)
2791: BETWEEN to_date(to_char(nvl(enrolment_start_date,trunc(sysdate)),'YYYY/MM/DD') || ' ' || '00:00' , 'YYYY/MM/DD HH24:MI')

Line 3463: function get_class_available_seats(p_event_id ota_events.event_id%type) return varchar2 is

3459: return v_name;
3460: --
3461: end get_lang_name;
3462:
3463: function get_class_available_seats(p_event_id ota_events.event_id%type) return varchar2 is
3464: l_vacancies varchar2(30);
3465: begin
3466: l_vacancies := ota_evt_bus2.get_vacancies(p_event_id);
3467: if(l_vacancies is null) then

Line 3477: p_event_id in ota_events.event_id%TYPE,

3473:
3474: function get_cls_enroll_image(p_manager_flag in varchar2,
3475: p_person_id in number,
3476: p_contact_id in number,
3477: p_event_id in ota_events.event_id%TYPE,
3478: p_mandatory_flag in ota_delegate_bookings.is_mandatory_enrollment%TYPE,
3479: p_booking_status_type in ota_booking_status_types.type%TYPE) return varchar2 is
3480:
3481: CURSOR lp_cls_enroll_p IS

Line 3534: function get_learners_email_addresses(p_event_id ota_events.event_id%type) return clob is

3530: return l_enroll_image;
3531: end get_cls_enroll_image;
3532:
3533:
3534: function get_learners_email_addresses(p_event_id ota_events.event_id%type) return clob is
3535: cursor get_internal_email_addresses is
3536: select paf.email_address
3537: from ota_delegate_bookings odb,
3538: ota_booking_status_types obst,

Line 3613: p_class_id ota_events.event_id%TYPE)

3609: --function to determine switcher action for bulk and single on list of classes page
3610: --p_enr_type is 'B' for bulk enroll switcher and 'S' for Single enroll switcher
3611: FUNCTION is_class_enrollable(
3612: p_enr_type varchar2,
3613: p_class_id ota_events.event_id%TYPE)
3614: RETURN VARCHAR2
3615: IS
3616:
3617: CURSOR csr_get_class_details IS

Line 3619: FROM ota_events

3615: IS
3616:
3617: CURSOR csr_get_class_details IS
3618: SELECT null
3619: FROM ota_events
3620: WHERE event_id = p_class_id
3621:
3622: AND ota_timezone_util.convert_date(sysdate, to_char(sysdate,'HH24:MI'), ota_timezone_util.get_server_timezone_code, timezone)
3623: BETWEEN to_date(to_char(nvl(enrolment_start_date,trunc(sysdate)),'YYYY/MM/DD') || ' ' || '00:00' , 'YYYY/MM/DD HH24:MI')