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

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

69: ,p_tdb_information20 in varchar2
70: ,p_booking_justification_id in varchar2)
71: IS
72:
73: CURSOR bg_to (pp_event_id ota_events.event_id%TYPE) IS
74: SELECT hao.business_group_id,
75: evt.organization_id,
76: evt.currency_code,
77: evt.course_start_date,

Line 83: FROM OTA_EVENTS_VL evt,

79: evt.Title,
80: evt.owner_id,
81: off.activity_version_id,
82: evt.offering_id
83: FROM OTA_EVENTS_VL evt,
84: OTA_OFFERINGS off,
85: HR_ALL_ORGANIZATION_UNITS hao
86: WHERE evt.event_id = pp_event_id
87: AND off.offering_id = evt.parent_offering_id

Line 93: from OTA_EVENTS

89:
90:
91: Cursor Get_Event_status is
92: Select event_status, maximum_internal_attendees, maximum_attendees
93: from OTA_EVENTS
94: WHERE EVENT_ID = TO_NUMBER(p_event_id);
95:
96: CURSOR get_existing_internal IS
97: SELECT count(booking_id)

Line 116: FROM ota_events

112:
113:
114: CURSOR c_get_price_basis is
115: SELECT nvl(price_basis,NULL)
116: FROM ota_events
117: where event_id = p_event_id;
118:
119: CURSOR csr_user(p_owner_id in number) IS
120: SELECT

Line 140: l_price_basis OTA_EVENTS.price_basis%TYPE;

136: FROM ota_bkng_justifications_b BJS
137: WHERE bjs.booking_justification_id = p_booking_justification_id;
138:
139:
140: l_price_basis OTA_EVENTS.price_basis%TYPE;
141:
142: l_person_details OTA_LEARNER_ENROLL_SS.csr_person_to_enroll_details%ROWTYPE;
143: --
144: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;

Line 185: l_event_currency_code ota_events.currency_code%type;

181:
182: l_called_from varchar2(80);
183: l_business_group_id_to hr_all_organization_units.organization_id%type;
184: l_sponsor_organization_id hr_all_organization_units.organization_id%type;
185: l_event_currency_code ota_events.currency_code%type;
186: l_event_title ota_events.title%type;
187: l_course_start_date ota_events.course_start_date%type;
188: l_course_end_date ota_events.course_end_date%type;
189: l_owner_id ota_events.owner_id%type;

Line 186: l_event_title ota_events.title%type;

182: l_called_from varchar2(80);
183: l_business_group_id_to hr_all_organization_units.organization_id%type;
184: l_sponsor_organization_id hr_all_organization_units.organization_id%type;
185: l_event_currency_code ota_events.currency_code%type;
186: l_event_title ota_events.title%type;
187: l_course_start_date ota_events.course_start_date%type;
188: l_course_end_date ota_events.course_end_date%type;
189: l_owner_id ota_events.owner_id%type;
190: l_activity_version_id ota_activity_versions.activity_version_id%type;

Line 187: l_course_start_date ota_events.course_start_date%type;

183: l_business_group_id_to hr_all_organization_units.organization_id%type;
184: l_sponsor_organization_id hr_all_organization_units.organization_id%type;
185: l_event_currency_code ota_events.currency_code%type;
186: l_event_title ota_events.title%type;
187: l_course_start_date ota_events.course_start_date%type;
188: l_course_end_date ota_events.course_end_date%type;
189: l_owner_id ota_events.owner_id%type;
190: l_activity_version_id ota_activity_versions.activity_version_id%type;
191: l_version_name ota_activity_versions.version_name%type;

Line 188: l_course_end_date ota_events.course_end_date%type;

184: l_sponsor_organization_id hr_all_organization_units.organization_id%type;
185: l_event_currency_code ota_events.currency_code%type;
186: l_event_title ota_events.title%type;
187: l_course_start_date ota_events.course_start_date%type;
188: l_course_end_date ota_events.course_end_date%type;
189: l_owner_id ota_events.owner_id%type;
190: l_activity_version_id ota_activity_versions.activity_version_id%type;
191: l_version_name ota_activity_versions.version_name%type;
192: l_owner_username fnd_user.user_name%type;

Line 189: l_owner_id ota_events.owner_id%type;

185: l_event_currency_code ota_events.currency_code%type;
186: l_event_title ota_events.title%type;
187: l_course_start_date ota_events.course_start_date%type;
188: l_course_end_date ota_events.course_end_date%type;
189: l_owner_id ota_events.owner_id%type;
190: l_activity_version_id ota_activity_versions.activity_version_id%type;
191: l_version_name ota_activity_versions.version_name%type;
192: l_owner_username fnd_user.user_name%type;
193: l_offering_id ota_events.offering_id%type;

Line 193: l_offering_id ota_events.offering_id%type;

189: l_owner_id ota_events.owner_id%type;
190: l_activity_version_id ota_activity_versions.activity_version_id%type;
191: l_version_name ota_activity_versions.version_name%type;
192: l_owner_username fnd_user.user_name%type;
193: l_offering_id ota_events.offering_id%type;
194: l_booking_status_used varchar2(20);
195:
196: l_existing_bookings NUMBER;
197: l_maximum_external_allowed NUMBER;

Line 715: l_event_id ota_events.event_id%TYPE;

711: lh_object_version_number ota_finance_headers.object_version_number%TYPE;
712:
713: l_hours_until_class_starts NUMBER;
714: l_minimum_advance_notice NUMBER;
715: l_event_id ota_events.event_id%TYPE;
716: l_course_start_date ota_events.course_start_date%TYPE;
717: l_course_start_time ota_events.course_start_time%TYPE;
718: l_course_end_date ota_events.course_start_date%TYPE;
719: l_date_booking_placed ota_delegate_bookings.date_booking_placed%TYPE;

Line 716: l_course_start_date ota_events.course_start_date%TYPE;

712:
713: l_hours_until_class_starts NUMBER;
714: l_minimum_advance_notice NUMBER;
715: l_event_id ota_events.event_id%TYPE;
716: l_course_start_date ota_events.course_start_date%TYPE;
717: l_course_start_time ota_events.course_start_time%TYPE;
718: l_course_end_date ota_events.course_start_date%TYPE;
719: l_date_booking_placed ota_delegate_bookings.date_booking_placed%TYPE;
720: l_content_player_status ota_delegate_bookings.content_player_status%TYPE;

Line 717: l_course_start_time ota_events.course_start_time%TYPE;

713: l_hours_until_class_starts NUMBER;
714: l_minimum_advance_notice NUMBER;
715: l_event_id ota_events.event_id%TYPE;
716: l_course_start_date ota_events.course_start_date%TYPE;
717: l_course_start_time ota_events.course_start_time%TYPE;
718: l_course_end_date ota_events.course_start_date%TYPE;
719: l_date_booking_placed ota_delegate_bookings.date_booking_placed%TYPE;
720: l_content_player_status ota_delegate_bookings.content_player_status%TYPE;
721: l_object_version_number ota_delegate_bookings.object_version_number%TYPE;

Line 718: l_course_end_date ota_events.course_start_date%TYPE;

714: l_minimum_advance_notice NUMBER;
715: l_event_id ota_events.event_id%TYPE;
716: l_course_start_date ota_events.course_start_date%TYPE;
717: l_course_start_time ota_events.course_start_time%TYPE;
718: l_course_end_date ota_events.course_start_date%TYPE;
719: l_date_booking_placed ota_delegate_bookings.date_booking_placed%TYPE;
720: l_content_player_status ota_delegate_bookings.content_player_status%TYPE;
721: l_object_version_number ota_delegate_bookings.object_version_number%TYPE;
722: l_delegate_id ota_delegate_bookings.delegate_person_id%TYPE;

Line 753: CURSOR event_csr (p_event_id ota_events.event_id%TYPE) IS

749: OTA_FINANCE_LINES FLN
750: WHERE FLH.finance_header_id = FLN.finance_header_id
751: AND FLN.booking_id = p_booking_id;
752:
753: CURSOR event_csr (p_event_id ota_events.event_id%TYPE) IS
754: SELECT e.course_start_date,
755: e.course_start_time,
756: e.course_end_date
757: FROM ota_events_vl e,

Line 757: FROM ota_events_vl e,

753: CURSOR event_csr (p_event_id ota_events.event_id%TYPE) IS
754: SELECT e.course_start_date,
755: e.course_start_time,
756: e.course_end_date
757: FROM ota_events_vl e,
758: ota_offerings o,
759: ota_activity_versions_tl a
760: WHERE e.parent_offering_id = o.offering_id
761: AND o.activity_version_id = a.activity_version_id

Line 1447: , p_event_id IN OTA_EVENTS.EVENT_ID%TYPE)

1443:
1444: FUNCTION CHK_FOR_SECURE_EVT (
1445: p_delegate_id IN PER_PEOPLE_F.PERSON_ID%TYPE
1446: ,p_delegate_contact_id IN NUMBER
1447: , p_event_id IN OTA_EVENTS.EVENT_ID%TYPE)
1448: RETURN VARCHAR2
1449: IS
1450:
1451: CURSOR C_GET_SECURE_FLAG is

Line 1453: from ota_events

1449: IS
1450:
1451: CURSOR C_GET_SECURE_FLAG is
1452: SELECT secure_event_flag,organization_id
1453: from ota_events
1454: where event_id = p_event_id;
1455:
1456: CURSOR C_GET_ORG_ID is
1457: SELECT organization_id

Line 1465: l_evt_organization_id OTA_EVENTS.ORGANIZATION_ID%TYPE;

1461: effective_end_date;
1462:
1463:
1464: l_secure_flag varchar2(1);
1465: l_evt_organization_id OTA_EVENTS.ORGANIZATION_ID%TYPE;
1466: l_per_organization_id PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID%TYPE;
1467: l_return_value varchar2(2000);
1468:
1469: BEGIN

Line 1516: , p_event_id IN OTA_EVENTS.EVENT_ID%TYPE

1512: --|--------------------------------------------------------------------------|
1513:
1514: FUNCTION CHK_DELEGATE_OK_FOR_EVENT (
1515: p_delegate_id IN PER_PEOPLE_F.PERSON_ID%TYPE
1516: , p_event_id IN OTA_EVENTS.EVENT_ID%TYPE
1517: , p_event_start_date IN OTA_EVENTS.COURSE_START_DATE%TYPE
1518: )
1519: RETURN VARCHAR2
1520:

Line 1517: , p_event_start_date IN OTA_EVENTS.COURSE_START_DATE%TYPE

1513:
1514: FUNCTION CHK_DELEGATE_OK_FOR_EVENT (
1515: p_delegate_id IN PER_PEOPLE_F.PERSON_ID%TYPE
1516: , p_event_id IN OTA_EVENTS.EVENT_ID%TYPE
1517: , p_event_start_date IN OTA_EVENTS.COURSE_START_DATE%TYPE
1518: )
1519: RETURN VARCHAR2
1520:
1521: IS

Line 1531: FROM ota_events

1527:
1528: CURSOR csr_event_start_date IS
1529: SELECT course_start_date
1530: -- FROM otv_scheduled_events
1531: FROM ota_events
1532: WHERE event_id = p_event_id and
1533: --Bug#2201434 SELFPACED event_type included.
1534: -- event_type='SCHEDULED' and
1535: event_type in ('SCHEDULED','SELFPACED') and

Line 1608: p_event_id IN OTA_EVENTS.EVENT_ID%TYPE,

1604: --|--< CHK_FOR_RESTRICTED_EVT >-------------------------------------------|
1605: --|--------------------------------------------------------------------------|
1606:
1607: FUNCTION CHK_FOR_RESTRICTED_EVT (
1608: p_event_id IN OTA_EVENTS.EVENT_ID%TYPE,
1609: p_delegate_contact_id IN NUMBER)
1610: RETURN VARCHAR2
1611: IS
1612: CURSOR C_GET_EVT_DETAILS is

Line 1614: from ota_events EVT

1610: RETURN VARCHAR2
1611: IS
1612: CURSOR C_GET_EVT_DETAILS is
1613: SELECT EVT.public_event_flag,EVT.maximum_internal_attendees
1614: from ota_events EVT
1615: where EVT.event_id = p_event_id;
1616:
1617: CURSOR C_GET_EVT_ACCESS_DETAILS(l_customer_id NUMBER) is
1618: SELECT EVT.public_event_flag,EVT.maximum_internal_attendees

Line 1619: from ota_events EVT, ota_event_associations EVA

1615: where EVT.event_id = p_event_id;
1616:
1617: CURSOR C_GET_EVT_ACCESS_DETAILS(l_customer_id NUMBER) is
1618: SELECT EVT.public_event_flag,EVT.maximum_internal_attendees
1619: from ota_events EVT, ota_event_associations EVA
1620: where EVT.event_id = p_event_id and
1621: EVT.event_id = EVA.event_id and
1622: EVA.customer_id = l_customer_id;
1623:

Line 1624: l_public_event_flag OTA_EVENTS.PUBLIC_EVENT_FLAG%TYPE;

1620: where EVT.event_id = p_event_id and
1621: EVT.event_id = EVA.event_id and
1622: EVA.customer_id = l_customer_id;
1623:
1624: l_public_event_flag OTA_EVENTS.PUBLIC_EVENT_FLAG%TYPE;
1625: l_maximum_internal_attendees OTA_EVENTS.MAXIMUM_INTERNAL_ATTENDEES%TYPE;
1626: l_return_value varchar2(10);
1627:
1628: l_ext_lrnr_details csr_ext_lrnr_Details%ROWTYPE;

Line 1625: l_maximum_internal_attendees OTA_EVENTS.MAXIMUM_INTERNAL_ATTENDEES%TYPE;

1621: EVT.event_id = EVA.event_id and
1622: EVA.customer_id = l_customer_id;
1623:
1624: l_public_event_flag OTA_EVENTS.PUBLIC_EVENT_FLAG%TYPE;
1625: l_maximum_internal_attendees OTA_EVENTS.MAXIMUM_INTERNAL_ATTENDEES%TYPE;
1626: l_return_value varchar2(10);
1627:
1628: l_ext_lrnr_details csr_ext_lrnr_Details%ROWTYPE;
1629: l_customer_id NUMBER := null;

Line 1806: l_event_title ota_events.title%TYPE;

1802: IS
1803: -- ------------------------
1804: -- event_csr variables
1805: -- ------------------------
1806: l_event_title ota_events.title%TYPE;
1807: l_event_status ota_events.event_status%TYPE;
1808: l_course_start_date ota_events.course_start_date%TYPE;
1809: l_course_start_time ota_events.course_start_time%TYPE;
1810: l_course_end_date ota_events.course_start_date%TYPE;

Line 1807: l_event_status ota_events.event_status%TYPE;

1803: -- ------------------------
1804: -- event_csr variables
1805: -- ------------------------
1806: l_event_title ota_events.title%TYPE;
1807: l_event_status ota_events.event_status%TYPE;
1808: l_course_start_date ota_events.course_start_date%TYPE;
1809: l_course_start_time ota_events.course_start_time%TYPE;
1810: l_course_end_date ota_events.course_start_date%TYPE;
1811: l_owner_id ota_events.owner_id%TYPE;

Line 1808: l_course_start_date ota_events.course_start_date%TYPE;

1804: -- event_csr variables
1805: -- ------------------------
1806: l_event_title ota_events.title%TYPE;
1807: l_event_status ota_events.event_status%TYPE;
1808: l_course_start_date ota_events.course_start_date%TYPE;
1809: l_course_start_time ota_events.course_start_time%TYPE;
1810: l_course_end_date ota_events.course_start_date%TYPE;
1811: l_owner_id ota_events.owner_id%TYPE;
1812:

Line 1809: l_course_start_time ota_events.course_start_time%TYPE;

1805: -- ------------------------
1806: l_event_title ota_events.title%TYPE;
1807: l_event_status ota_events.event_status%TYPE;
1808: l_course_start_date ota_events.course_start_date%TYPE;
1809: l_course_start_time ota_events.course_start_time%TYPE;
1810: l_course_end_date ota_events.course_start_date%TYPE;
1811: l_owner_id ota_events.owner_id%TYPE;
1812:
1813: -- ------------------------

Line 1810: l_course_end_date ota_events.course_start_date%TYPE;

1806: l_event_title ota_events.title%TYPE;
1807: l_event_status ota_events.event_status%TYPE;
1808: l_course_start_date ota_events.course_start_date%TYPE;
1809: l_course_start_time ota_events.course_start_time%TYPE;
1810: l_course_end_date ota_events.course_start_date%TYPE;
1811: l_owner_id ota_events.owner_id%TYPE;
1812:
1813: -- ------------------------
1814: -- booking_csr variables

Line 1811: l_owner_id ota_events.owner_id%TYPE;

1807: l_event_status ota_events.event_status%TYPE;
1808: l_course_start_date ota_events.course_start_date%TYPE;
1809: l_course_start_time ota_events.course_start_time%TYPE;
1810: l_course_end_date ota_events.course_start_date%TYPE;
1811: l_owner_id ota_events.owner_id%TYPE;
1812:
1813: -- ------------------------
1814: -- booking_csr variables
1815: -- ------------------------

Line 1853: CURSOR event_csr (p_event_id ota_events.event_id%TYPE)

1849: lb_object_version_number ota_delegate_bookings.object_version_number%TYPE;
1850: l_proc VARCHAR2(72) := 'ota_learner_enroll_ss.cancel_enrollment';
1851: l_activity_version_name ota_activity_versions.version_name%TYPE;
1852:
1853: CURSOR event_csr (p_event_id ota_events.event_id%TYPE)
1854: IS
1855: SELECT a.version_name,
1856: e.title,
1857: e.event_status,

Line 1862: FROM ota_events_vl e,

1858: e.course_start_date,
1859: e.course_start_time,
1860: e.course_end_date,
1861: e.owner_id
1862: FROM ota_events_vl e,
1863: ota_offerings o,
1864: ota_activity_versions_tl a
1865: WHERE e.parent_offering_id = o.offering_id
1866: AND o.activity_version_id = a.activity_version_id

Line 2292: SELECT 1 from ota_events

2288:
2289:
2290: CURSOR C_GET_EVT_ATTACHED(l_offering_id OTA_OFFERINGS.offering_id%type)
2291: is
2292: SELECT 1 from ota_events
2293: where parent_offering_id = l_offering_id
2294: and business_group_id = ota_general.get_business_group_id;
2295:
2296:

Line 2347: p_event_id IN OTA_EVENTS.EVENT_ID%TYPE

2343: --|--< CHK_VALID_EVENT >-------------------------------------------|
2344: --|--------------------------------------------------------------------------|
2345:
2346: FUNCTION CHK_VALID_EVENT(
2347: p_event_id IN OTA_EVENTS.EVENT_ID%TYPE
2348: )
2349: RETURN VARCHAR2
2350: IS
2351: -- checking for INVALID Events

Line 2352: CURSOR C_GET_EVT(l_event_id OTA_EVENTS.EVENT_ID%TYPE)

2348: )
2349: RETURN VARCHAR2
2350: IS
2351: -- checking for INVALID Events
2352: CURSOR C_GET_EVT(l_event_id OTA_EVENTS.EVENT_ID%TYPE)
2353: is
2354: SELECT event_id from ota_events
2355: where event_id = l_event_id;
2356:

Line 2354: SELECT event_id from ota_events

2350: IS
2351: -- checking for INVALID Events
2352: CURSOR C_GET_EVT(l_event_id OTA_EVENTS.EVENT_ID%TYPE)
2353: is
2354: SELECT event_id from ota_events
2355: where event_id = l_event_id;
2356:
2357: CURSOR C_GET_EVT_DET(l_event_id OTA_EVENTS.EVENT_ID%TYPE)
2358: is

Line 2357: CURSOR C_GET_EVT_DET(l_event_id OTA_EVENTS.EVENT_ID%TYPE)

2353: is
2354: SELECT event_id from ota_events
2355: where event_id = l_event_id;
2356:
2357: CURSOR C_GET_EVT_DET(l_event_id OTA_EVENTS.EVENT_ID%TYPE)
2358: is
2359: SELECT event_id,
2360: event_status,
2361: ota_timezone_util.convert_date(trunc(nvl(course_start_date,sysdate)), nvl(course_start_time,'00:00'), timezone, fnd_timezones.get_client_timezone_code) course_start_date,

Line 2367: from ota_events

2363: ota_timezone_util.convert_date(trunc(nvl(enrolment_start_date,sysdate)), '00:00', timezone, fnd_timezones.get_client_timezone_code) enrolment_start_date,
2364: ota_timezone_util.convert_date(trunc(nvl(enrolment_end_date,sysdate)), '23:59', timezone, fnd_timezones.get_client_timezone_code) enrolment_end_date,
2365: course_end_time,
2366: ota_timezone_util.convert_date(sysdate, to_char(sysdate,'HH24:MI'), ota_timezone_util.get_server_timezone_code, timezone) sys_date
2367: from ota_events
2368: where event_id = l_event_id
2369: and event_type in ('SCHEDULED','SELFPACED')
2370: and business_group_id=ota_general.get_business_group_id;
2371:

Line 2430: (p_event_id IN ota_events.event_id%TYPE,

2426:
2427: END CHK_VALID_EVENT;
2428:
2429: PROCEDURE get_wf_attr_for_cancel_ntf
2430: (p_event_id IN ota_events.event_id%TYPE,
2431: p_person_id IN number,
2432: p_supervisor_username OUT NOCOPY fnd_user.user_name%TYPE,
2433: p_supervisor_full_name OUT NOCOPY per_all_people_f.full_name%TYPE,
2434: p_supervisor_id OUT NOCOPY per_all_people_f.person_id%Type,