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

Line 345: fnd_message.set_token ('TABLE_NAME', 'OTA_EVENTS');

341: --
342: if not l_event_exists then
343: --
344: fnd_message.set_name ('OTA', 'OTA_13202_GEN_INVALID_KEY');
345: fnd_message.set_token ('TABLE_NAME', 'OTA_EVENTS');
346: fnd_message.set_token ('COLUMN_NAME', 'EVENT_ID');
347: fnd_message.raise_error;
348: --
349: end if;

Line 633: FROM per_all_assignments_f paf, ota_events evt

629:
630: --
631: CURSOR c_student IS
632: SELECT paf.ROWID
633: FROM per_all_assignments_f paf, ota_events evt
634: WHERE paf.assignment_id = p_assignment_id
635: AND evt.event_id = p_event_id
636: AND (
637: evt.event_status = 'P'

Line 654: FROM per_all_assignments_f paf, ota_events evt ,

650: /* Changed the following query to support PTU. Added the table Per_Person_type_Usages_F. */
651: /* Added the person type 'CWK' and removed 'EMP_APL' -- Enh No 2530860 */
652: CURSOR c_student_rehire IS
653: SELECT paf.ROWID
654: FROM per_all_assignments_f paf, ota_events evt ,
655: per_all_people_f ppf,
656: per_person_type_usages_f ptu,
657: per_person_types ppt
658: WHERE paf.person_id = l_person_id

Line 953: from ota_events

949: -- Check if a maximum for internal students exists.
950: --
951: cursor c_max_internal is
952: select maximum_internal_attendees
953: from ota_events
954: where event_id = p_event_id;
955: --
956: -- Only placed or attended places take an internal place
957: --

Line 1375: from ota_events

1371: l_dummy varchar2(30);
1372: --
1373: cursor c1 is
1374: select event_type
1375: from ota_events
1376: where event_id = p_event_id;
1377: --
1378: Begin
1379: open c1;

Line 1663: FROM ota_events e

1659: --
1660: CURSOR csr_course_not_in_future -- bug 3677661
1661: IS
1662: SELECT 1
1663: FROM ota_events e
1664: WHERE
1665: -- Added for bug#5169098
1666: ota_timezone_util.convert_date(trunc(sysdate), to_char(sysdate,'HH24:MI'), ota_timezone_util.get_server_timezone_code, e.timezone)
1667: >= ota_timezone_util.convert_date(nvl(e.course_start_date,to_date('0001/01/01','YYYY/MM/DD')), course_start_time, e.timezone, e.timezone)

Line 1733: l_price_basis ota_events.price_basis%type;

1729: p_delegate_person_id in number,
1730: p_delegate_assignment_id in number) is
1731: --
1732: l_proc varchar2(72) := g_package||'check_delegate_eligible';
1733: l_price_basis ota_events.price_basis%type;
1734: l_start_date ota_events.course_start_date%type;
1735: l_dummy varchar2(1);
1736: l_organization_id number;
1737: l_job_id number;

Line 1734: l_start_date ota_events.course_start_date%type;

1730: p_delegate_assignment_id in number) is
1731: --
1732: l_proc varchar2(72) := g_package||'check_delegate_eligible';
1733: l_price_basis ota_events.price_basis%type;
1734: l_start_date ota_events.course_start_date%type;
1735: l_dummy varchar2(1);
1736: l_organization_id number;
1737: l_job_id number;
1738: l_position_id number;

Line 1743: l_public_event_flag OTA_EVENTS.public_event_flag%TYPE;

1739: l_count number;
1740: l_found boolean := false;
1741: /* bug 3463908 */
1742: l_party_id number := null;
1743: l_public_event_flag OTA_EVENTS.public_event_flag%TYPE;
1744: l_max_internal OTA_EVENTS.maximum_internal_attendees%TYPE;
1745: l_event_start_date OTA_EVENTS.course_start_date%TYPE;
1746: l_parent_offering_id OTA_EVENTS.parent_offering_id%TYPE;
1747: -- l_employee_can_enroll VArchar2(9);

Line 1744: l_max_internal OTA_EVENTS.maximum_internal_attendees%TYPE;

1740: l_found boolean := false;
1741: /* bug 3463908 */
1742: l_party_id number := null;
1743: l_public_event_flag OTA_EVENTS.public_event_flag%TYPE;
1744: l_max_internal OTA_EVENTS.maximum_internal_attendees%TYPE;
1745: l_event_start_date OTA_EVENTS.course_start_date%TYPE;
1746: l_parent_offering_id OTA_EVENTS.parent_offering_id%TYPE;
1747: -- l_employee_can_enroll VArchar2(9);
1748: /* bug 3463908 */

Line 1745: l_event_start_date OTA_EVENTS.course_start_date%TYPE;

1741: /* bug 3463908 */
1742: l_party_id number := null;
1743: l_public_event_flag OTA_EVENTS.public_event_flag%TYPE;
1744: l_max_internal OTA_EVENTS.maximum_internal_attendees%TYPE;
1745: l_event_start_date OTA_EVENTS.course_start_date%TYPE;
1746: l_parent_offering_id OTA_EVENTS.parent_offering_id%TYPE;
1747: -- l_employee_can_enroll VArchar2(9);
1748: /* bug 3463908 */
1749: l_learner_can_enroll Varchar2(9); -- bug no 4201444

Line 1746: l_parent_offering_id OTA_EVENTS.parent_offering_id%TYPE;

1742: l_party_id number := null;
1743: l_public_event_flag OTA_EVENTS.public_event_flag%TYPE;
1744: l_max_internal OTA_EVENTS.maximum_internal_attendees%TYPE;
1745: l_event_start_date OTA_EVENTS.course_start_date%TYPE;
1746: l_parent_offering_id OTA_EVENTS.parent_offering_id%TYPE;
1747: -- l_employee_can_enroll VArchar2(9);
1748: /* bug 3463908 */
1749: l_learner_can_enroll Varchar2(9); -- bug no 4201444
1750: --

Line 1759: from ota_events

1755: --
1756: /* bug 3463908 */
1757: /*Cursor c_event_start_date is
1758: select course_start_date
1759: from ota_events
1760: where event_id = p_event_id;
1761: */
1762: --
1763: Cursor c_not_public_course is

Line 1765: from ota_events b

1761: */
1762: --
1763: Cursor c_not_public_course is
1764: select 'X'
1765: from ota_events b
1766: where b.event_id = p_event_id
1767: and public_event_flag = 'N';
1768: --
1769: Cursor c_event_association (l_party_id in number) is

Line 1806: from ota_events

1802: where evt.event_id = p_event_id);
1803: --
1804: Cursor c_event_price_basis is
1805: select price_basis
1806: from ota_events
1807: where event_id = p_event_id;
1808: */
1809: --
1810: /* bug 3463908 */

Line 1833: From ota_events

1829: /* bug 3463908 */
1830: --Bug No. 4201444
1831: Cursor event_details is
1832: Select public_event_flag, maximum_internal_attendees, course_start_date, parent_offering_id
1833: From ota_events
1834: Where event_id = p_event_id;
1835: --
1836: Begin
1837: hr_utility.set_location('Entering:'||l_proc, 5);

Line 1922: From ota_events

1918:
1919: /*
1920: Select public_event_flag, maximum_internal_attendees, course_start_date, parent_offering_id
1921: into l_public_event_flag, l_max_internal, l_event_start_date, l_parent_offering_id
1922: From ota_events
1923: Where event_id = p_event_id;
1924: */
1925: l_learner_can_enroll := ota_learner_access_util.employee_can_enroll(p_person_id => p_delegate_person_id,
1926: p_event_id => p_event_id,

Line 2388: from ota_events

2384: l_parent_enrollment_sd date;
2385:
2386: cursor c_get_parent is
2387: select enrolment_start_date
2388: from ota_events
2389: where event_id = nvl(g_event_rec.parent_event_id, -1);
2390: --
2391: Begin
2392: hr_utility.set_location('Entering:'||l_proc, 5);

Line 2437: l_timezone ota_events.timezone%TYPE;

2433: --
2434: l_proc varchar2(72) := g_package||'enrolling_on_date';
2435: l_enrollment_sd date;
2436: l_enrollment_ed date;
2437: l_timezone ota_events.timezone%TYPE;
2438: l_conv_booking_date date := p_date;
2439:
2440: cursor c_get_parent is
2441: select enrolment_start_date,

Line 2444: from ota_events

2440: cursor c_get_parent is
2441: select enrolment_start_date,
2442: enrolment_end_date,
2443: timezone
2444: from ota_events
2445: where event_id = nvl(g_event_rec.parent_event_id, -1);
2446: --
2447: Begin
2448: hr_utility.set_location('Entering:'||l_proc, 5);

Line 2507: l_timezone ota_events.timezone%TYPE;

2503: --
2504: l_proc varchar2(72) := g_package||'check_enrollment_dates';
2505: l_enrollment_sd date;
2506: l_enrollment_ed date;
2507: l_timezone ota_events.timezone%TYPE;
2508: l_event_type ota_events.event_type%TYPE;
2509: l_conv_booking_date date := p_date;
2510:
2511: cursor c_get_parent is

Line 2508: l_event_type ota_events.event_type%TYPE;

2504: l_proc varchar2(72) := g_package||'check_enrollment_dates';
2505: l_enrollment_sd date;
2506: l_enrollment_ed date;
2507: l_timezone ota_events.timezone%TYPE;
2508: l_event_type ota_events.event_type%TYPE;
2509: l_conv_booking_date date := p_date;
2510:
2511: cursor c_get_parent is
2512: select enrolment_start_date,

Line 2516: from ota_events

2512: select enrolment_start_date,
2513: enrolment_end_date,
2514: timezone,
2515: event_type
2516: from ota_events
2517: where event_id = p_event_id;
2518: --
2519: Begin
2520: hr_utility.set_location('Entering:'||l_proc, 5);

Line 2816: from ota_events

2812:
2813: -- Added for Bug#3007934
2814: cursor csr_get_business_group_id is
2815: select business_group_id
2816: from ota_events
2817: where event_id = p_event_id;
2818: --
2819: BEGIN
2820: --Modified for Bug#3007934

Line 3207: FROM OTA_EVENTS

3203: l_line_id number;
3204:
3205: CURSOR C_RE IS
3206: Select LINE_ID
3207: FROM OTA_EVENTS
3208: WHERE EVENT_ID = p_event_id
3209: AND LINE_ID IS NOT NULL ;
3210: --
3211: Begin

Line 3373: FROM ota_events

3369: ,p_delegate_person_id IN NUMBER)
3370: IS
3371: CURSOR csr_is_secure_event IS
3372: SELECT organization_id
3373: FROM ota_events
3374: WHERE event_id = p_event_id
3375: AND nvl(secure_event_flag,'N') = 'Y';
3376:
3377: l_organization_id OTA_EVENTS.organization_id%TYPE;

Line 3377: l_organization_id OTA_EVENTS.organization_id%TYPE;

3373: FROM ota_events
3374: WHERE event_id = p_event_id
3375: AND nvl(secure_event_flag,'N') = 'Y';
3376:
3377: l_organization_id OTA_EVENTS.organization_id%TYPE;
3378: l_is_match VARCHAR2(1);
3379: BEGIN
3380: OPEN csr_is_secure_event;
3381: FETCH csr_is_secure_event INTO l_organization_id;

Line 3412: , ota_events evt

3408: SELECT oft.learning_object_id
3409: ,ctu.online_flag
3410: ,evt.offering_id
3411: FROM ota_offerings oft
3412: , ota_events evt
3413: , ota_category_usages ctu
3414: WHERE oft.offering_id = evt.parent_offering_id
3415: AND ctu.category_usage_id = oft.delivery_mode_id
3416: AND evt.event_id = p_class_id;

Line 3420: l_imported_off_id ota_events.offering_id%TYPE;

3416: AND evt.event_id = p_class_id;
3417:
3418: l_online_flag VARCHAR2(9) := NULL;
3419: l_lo_id ota_offerings.learning_object_id%TYPE;
3420: l_imported_off_id ota_events.offering_id%TYPE;
3421: l_bkng_status_type VARCHAR2(30);
3422: l_old_bst VARCHAR2(30);
3423:
3424: l_player_status ota_delegate_bookings.content_player_status%TYPE;

Line 4018: FROM ota_events evt, ota_activity_versions avt

4014: l_old_inv_id ota_activity_versions.inventory_item_id%type;
4015:
4016: CURSOR get_inv_id (p_event_id in number) is
4017: SELECT nvl(avt.inventory_item_id,1)
4018: FROM ota_events evt, ota_activity_versions avt
4019: WHERE evt.activity_version_id = avt.activity_version_id
4020: AND evt.event_id = p_event_id ;
4021:
4022: /* bug no 4509873 */