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 714: l_event_id ota_events.event_id%TYPE;

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

Line 715: l_course_start_date ota_events.course_start_date%TYPE;

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

Line 716: l_course_start_time ota_events.course_start_time%TYPE;

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

Line 717: l_course_end_date ota_events.course_start_date%TYPE;

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

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

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

Line 756: FROM ota_events_vl e,

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

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

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

Line 1452: from ota_events

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

Line 1464: l_evt_organization_id OTA_EVENTS.ORGANIZATION_ID%TYPE;

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

Line 1515: , p_event_id IN OTA_EVENTS.EVENT_ID%TYPE

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

Line 1516: , p_event_start_date IN OTA_EVENTS.COURSE_START_DATE%TYPE

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

Line 1530: FROM ota_events

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

Line 1607: p_event_id IN OTA_EVENTS.EVENT_ID%TYPE,

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

Line 1613: from ota_events EVT

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

Line 1618: from ota_events EVT, ota_event_associations EVA

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

Line 1623: l_public_event_flag OTA_EVENTS.PUBLIC_EVENT_FLAG%TYPE;

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

Line 1624: l_maximum_internal_attendees OTA_EVENTS.MAXIMUM_INTERNAL_ATTENDEES%TYPE;

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

Line 1805: l_event_title ota_events.title%TYPE;

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

Line 1806: l_event_status ota_events.event_status%TYPE;

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

Line 1807: l_course_start_date ota_events.course_start_date%TYPE;

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

Line 1808: l_course_start_time ota_events.course_start_time%TYPE;

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

Line 1809: l_course_end_date ota_events.course_start_date%TYPE;

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

Line 1810: l_owner_id ota_events.owner_id%TYPE;

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

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

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

Line 1861: FROM ota_events_vl e,

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

Line 2291: SELECT 1 from ota_events

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

Line 2346: p_event_id IN OTA_EVENTS.EVENT_ID%TYPE

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

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

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

Line 2353: SELECT event_id from ota_events

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

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

2352: is
2353: SELECT event_id from ota_events
2354: where event_id = l_event_id;
2355:
2356: CURSOR C_GET_EVT_DET(l_event_id OTA_EVENTS.EVENT_ID%TYPE)
2357: is
2358: SELECT event_id,event_status,course_start_date,course_end_date,enrolment_start_date, enrolment_end_date, course_end_time
2359: from ota_events
2360: where event_id = l_event_id

Line 2359: from ota_events

2355:
2356: CURSOR C_GET_EVT_DET(l_event_id OTA_EVENTS.EVENT_ID%TYPE)
2357: is
2358: SELECT event_id,event_status,course_start_date,course_end_date,enrolment_start_date, enrolment_end_date, course_end_time
2359: from ota_events
2360: where event_id = l_event_id
2361: and event_type in ('SCHEDULED','SELFPACED')
2362: and business_group_id = ota_general.get_business_group_id ;
2363:

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

2418:
2419: END CHK_VALID_EVENT;
2420:
2421: PROCEDURE get_wf_attr_for_cancel_ntf
2422: (p_event_id IN ota_events.event_id%TYPE,
2423: p_person_id IN number,
2424: p_supervisor_username OUT NOCOPY fnd_user.user_name%TYPE,
2425: p_supervisor_full_name OUT NOCOPY per_all_people_f.full_name%TYPE,
2426: p_supervisor_id OUT NOCOPY per_all_people_f.person_id%Type,