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

Line 32: ota_events evt

28: select decode(nvl(evt_eval.eval_mandatory_flag,'N'), 'Y', 'Y',
29: decode(act_eval.evaluation_id,null,'N',decode(nvl(act_eval.eval_mandatory_flag,'N'),'Y','Y','N'))) flag --bug 7184369
30: from ota_evaluations evt_eval,
31: ota_evaluations act_eval,
32: ota_events evt
33: where evt_eval.object_id(+) = evt.event_id
34: and evt_eval.object_type(+) = 'E' --Bug10637605
35: and act_eval.object_id(+) = evt.activity_version_id
36: and act_eval.object_type(+) = 'A' --Bug10637605

Line 44: from ota_activity_versions act,ota_Events evt

40: l_eval_mand varchar2(1);
41:
42: Cursor c_sign_info is
43: select act.eres_enabled
44: from ota_activity_versions act,ota_Events evt
45: where act.activity_version_id = evt.activity_version_id
46: and evt.event_id = p_event_id;
47: --
48: l_proc varchar2(72) := g_package||'check_new_status';

Line 153: l_price_basis ota_events.price_basis%type;

149: p_booking_status_type_id in number
150: ) is
151:
152: l_auto_create_finance varchar2(40);
153: l_price_basis ota_events.price_basis%type;
154: l_business_group_id_to hr_all_organization_units.organization_id%type;
155: l_sponsor_organization_id hr_all_organization_units.organization_id%type;
156: l_event_currency_code ota_events.currency_code%type;
157: l_event_title ota_events.title%type;

Line 156: l_event_currency_code ota_events.currency_code%type;

152: l_auto_create_finance varchar2(40);
153: l_price_basis ota_events.price_basis%type;
154: l_business_group_id_to hr_all_organization_units.organization_id%type;
155: l_sponsor_organization_id hr_all_organization_units.organization_id%type;
156: l_event_currency_code ota_events.currency_code%type;
157: l_event_title ota_events.title%type;
158: l_course_start_date ota_events.course_start_date%type;
159: l_course_end_date ota_events.course_end_date%type;
160: l_owner_id ota_events.owner_id%type;

Line 157: l_event_title ota_events.title%type;

153: l_price_basis ota_events.price_basis%type;
154: l_business_group_id_to hr_all_organization_units.organization_id%type;
155: l_sponsor_organization_id hr_all_organization_units.organization_id%type;
156: l_event_currency_code ota_events.currency_code%type;
157: l_event_title ota_events.title%type;
158: l_course_start_date ota_events.course_start_date%type;
159: l_course_end_date ota_events.course_end_date%type;
160: l_owner_id ota_events.owner_id%type;
161: l_activity_version_id ota_activity_versions.activity_version_id%type;

Line 158: l_course_start_date ota_events.course_start_date%type;

154: l_business_group_id_to hr_all_organization_units.organization_id%type;
155: l_sponsor_organization_id hr_all_organization_units.organization_id%type;
156: l_event_currency_code ota_events.currency_code%type;
157: l_event_title ota_events.title%type;
158: l_course_start_date ota_events.course_start_date%type;
159: l_course_end_date ota_events.course_end_date%type;
160: l_owner_id ota_events.owner_id%type;
161: l_activity_version_id ota_activity_versions.activity_version_id%type;
162: l_offering_id ota_events.offering_id%type;

Line 159: l_course_end_date ota_events.course_end_date%type;

155: l_sponsor_organization_id hr_all_organization_units.organization_id%type;
156: l_event_currency_code ota_events.currency_code%type;
157: l_event_title ota_events.title%type;
158: l_course_start_date ota_events.course_start_date%type;
159: l_course_end_date ota_events.course_end_date%type;
160: l_owner_id ota_events.owner_id%type;
161: l_activity_version_id ota_activity_versions.activity_version_id%type;
162: l_offering_id ota_events.offering_id%type;
163: l_user number;

Line 160: l_owner_id ota_events.owner_id%type;

156: l_event_currency_code ota_events.currency_code%type;
157: l_event_title ota_events.title%type;
158: l_course_start_date ota_events.course_start_date%type;
159: l_course_end_date ota_events.course_end_date%type;
160: l_owner_id ota_events.owner_id%type;
161: l_activity_version_id ota_activity_versions.activity_version_id%type;
162: l_offering_id ota_events.offering_id%type;
163: l_user number;
164: l_cost_allocation_keyflex_id VARCHAR2(1000);

Line 162: l_offering_id ota_events.offering_id%type;

158: l_course_start_date ota_events.course_start_date%type;
159: l_course_end_date ota_events.course_end_date%type;
160: l_owner_id ota_events.owner_id%type;
161: l_activity_version_id ota_activity_versions.activity_version_id%type;
162: l_offering_id ota_events.offering_id%type;
163: l_user number;
164: l_cost_allocation_keyflex_id VARCHAR2(1000);
165: l_business_group_id_from PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE;
166: l_organization_id PER_ALL_ASSIGNMENTS_F.organization_id%TYPE;

Line 186: FROM OTA_EVENTS_VL evt,

182: evt.owner_id,
183: off.activity_version_id,
184: evt.offering_id,
185: nvl(evt.price_basis,NULL)
186: FROM OTA_EVENTS_VL evt,
187: OTA_OFFERINGS off,
188: HR_ALL_ORGANIZATION_UNITS hao
189: WHERE evt.event_id = p_event_id
190: AND off.offering_id = evt.parent_offering_id

Line 292: ota_events evt

288: select decode(nvl(evt_eval.eval_mandatory_flag,'N'), 'Y', 'Y',
289: decode(act_eval.evaluation_id,null,'N',decode(nvl(act_eval.eval_mandatory_flag,'N'),'Y','Y','N'))) flag --bug 7184369,6935364,7174996
290: from ota_evaluations evt_eval,
291: ota_evaluations act_eval,
292: ota_events evt
293: where evt_eval.object_id(+) = evt.event_id
294: and evt_eval.object_type(+) = 'E' --Bug 10637605
295: and act_eval.object_id(+) = evt.activity_version_id
296: and act_eval.object_type(+) = 'A' --Bug 10637605

Line 306: from ota_events evt, ota_activity_versions act

302:
303:
304: Cursor csr_sign_info is
305: select act.eres_enabled
306: from ota_events evt, ota_activity_versions act
307: where evt.activity_version_id = act.activity_version_id
308: and evt.event_id=p_event_id;
309:
310: Cursor csr_booking_info is

Line 546: ota_offerings off , ota_events oev

542: l_automatic_transfer_gl varchar2(40);
543:
544: Cursor chk_for_comp_upd is
545: select ocu.online_flag , off.Learning_object_id from ota_category_usages ocu,
546: ota_offerings off , ota_events oev
547: where ocu.category_usage_id = off.delivery_mode_id
548: and off.offering_id = oev.parent_offering_id
549: and oev.event_id = p_event_id;
550:

Line 565: Select title from ota_events_vl

561: l_LO_id ota_offerings.Learning_object_id%type;
562:
563: --Bug 5386501
564: Cursor csr_class_data is
565: Select title from ota_events_vl
566: where event_id = p_event_id;
567: l_class_name ota_events_tl.title%type;
568: l_incoming_status_type varchar2(30);
569:

Line 567: l_class_name ota_events_tl.title%type;

563: --Bug 5386501
564: Cursor csr_class_data is
565: Select title from ota_events_vl
566: where event_id = p_event_id;
567: l_class_name ota_events_tl.title%type;
568: l_incoming_status_type varchar2(30);
569:
570: --Bug 6683076
571: Cursor c_eval_info is

Line 576: ota_events evt

572: select decode(nvl(evt_eval.eval_mandatory_flag,'N'), 'Y', 'Y',
573: decode(act_eval.evaluation_id,null,'N',decode(nvl(act_eval.eval_mandatory_flag,'N'),'Y','Y','N'))) flag --bug 7184369,6935364,7174996
574: from ota_evaluations evt_eval,
575: ota_evaluations act_eval,
576: ota_events evt
577: where evt_eval.object_id(+) = evt.event_id
578: and evt_eval.object_type(+) = 'E' --Bug10637605
579: and act_eval.object_id(+) = evt.activity_version_id
580: and act_eval.object_type(+) = 'A' --Bug10637605

Line 587: select currency_code from ota_events

583:
584: l_eval_mand varchar2(1);
585:
586: cursor csr_get_currency_code is
587: select currency_code from ota_events
588: where event_id = p_event_id;
589:
590: l_currency_code varchar2(40);
591: l_new_sign_eval_status ota_delegate_bookings.sign_eval_status%type;

Line 1298: ota_events evt

1294: select decode(nvl(evt_eval.eval_mandatory_flag,'N'), 'Y', 'Y',
1295: decode(act_eval.evaluation_id,null,'N',decode(nvl(act_eval.eval_mandatory_flag,'N'),'Y','Y','N'))) flag --bug 7184369
1296: from ota_evaluations evt_eval,
1297: ota_evaluations act_eval,
1298: ota_events evt
1299: where evt_eval.object_id(+) = evt.event_id
1300: and evt_eval.object_type(+) = 'E' --Bug10637605
1301: and act_eval.object_id(+) = evt.activity_version_id
1302: and act_eval.object_type(+) = 'A' --Bug10637605

Line 1308: from ota_activity_versions act,ota_Events evt

1304: and (evt_eval.evaluation_id is not null or act_eval.evaluation_id is not null); --Bug7174996
1305:
1306: Cursor c_sign_info is
1307: select act.eres_enabled
1308: from ota_activity_versions act,ota_Events evt
1309: where act.activity_version_id = evt.activity_version_id
1310: and evt.event_id = p_event_id;
1311:
1312: l_eval_mand varchar2(1);

Line 1597: FROM ota_events evt,

1593: CURSOR csr_get_class_details IS
1594: SELECT evt.course_start_time
1595: ,evt.course_start_date
1596: ,evt.event_id
1597: FROM ota_events evt,
1598: ota_delegate_bookings tdb
1599: WHERE tdb.event_id = evt.event_id
1600: AND tdb.booking_id = p_booking_id;
1601:

Line 1610: l_course_start_time OTA_EVENTS.course_start_time%TYPE;

1606: WHERE tdb.booking_status_type_id = bst.booking_status_type_id
1607: AND bst.type = 'W'
1608: AND tdb.event_id = p_event_id;
1609:
1610: l_course_start_time OTA_EVENTS.course_start_time%TYPE;
1611: l_course_start_date OTA_EVENTS.course_start_date%TYPE;
1612: l_event_id OTA_EVENTS.event_id%TYPE;
1613: l_waitlist_count NUMBER;
1614:

Line 1611: l_course_start_date OTA_EVENTS.course_start_date%TYPE;

1607: AND bst.type = 'W'
1608: AND tdb.event_id = p_event_id;
1609:
1610: l_course_start_time OTA_EVENTS.course_start_time%TYPE;
1611: l_course_start_date OTA_EVENTS.course_start_date%TYPE;
1612: l_event_id OTA_EVENTS.event_id%TYPE;
1613: l_waitlist_count NUMBER;
1614:
1615: BEGIN

Line 1612: l_event_id OTA_EVENTS.event_id%TYPE;

1608: AND tdb.event_id = p_event_id;
1609:
1610: l_course_start_time OTA_EVENTS.course_start_time%TYPE;
1611: l_course_start_date OTA_EVENTS.course_start_date%TYPE;
1612: l_event_id OTA_EVENTS.event_id%TYPE;
1613: l_waitlist_count NUMBER;
1614:
1615: BEGIN
1616: OPEN csr_get_class_details;

Line 1777: l_course_start_date ota_events.course_start_date%TYPE;

1773:
1774: --bug 603768 changes starts
1775: l_hours_until_class_starts NUMBER := 0;
1776: l_sysdate VARCHAR2(30);
1777: l_course_start_date ota_events.course_start_date%TYPE;
1778: l_course_start_time ota_events.course_start_time%TYPE;
1779: l_event_title ota_events.title%TYPE;
1780: l_old_event_id ota_delegate_bookings.event_id%TYPE;
1781: l_owner_id ota_events.owner_id%TYPE;

Line 1778: l_course_start_time ota_events.course_start_time%TYPE;

1774: --bug 603768 changes starts
1775: l_hours_until_class_starts NUMBER := 0;
1776: l_sysdate VARCHAR2(30);
1777: l_course_start_date ota_events.course_start_date%TYPE;
1778: l_course_start_time ota_events.course_start_time%TYPE;
1779: l_event_title ota_events.title%TYPE;
1780: l_old_event_id ota_delegate_bookings.event_id%TYPE;
1781: l_owner_id ota_events.owner_id%TYPE;
1782: l_username fnd_user.user_name%TYPE;

Line 1779: l_event_title ota_events.title%TYPE;

1775: l_hours_until_class_starts NUMBER := 0;
1776: l_sysdate VARCHAR2(30);
1777: l_course_start_date ota_events.course_start_date%TYPE;
1778: l_course_start_time ota_events.course_start_time%TYPE;
1779: l_event_title ota_events.title%TYPE;
1780: l_old_event_id ota_delegate_bookings.event_id%TYPE;
1781: l_owner_id ota_events.owner_id%TYPE;
1782: l_username fnd_user.user_name%TYPE;
1783: l_auto_waitlist_days NUMBER;

Line 1781: l_owner_id ota_events.owner_id%TYPE;

1777: l_course_start_date ota_events.course_start_date%TYPE;
1778: l_course_start_time ota_events.course_start_time%TYPE;
1779: l_event_title ota_events.title%TYPE;
1780: l_old_event_id ota_delegate_bookings.event_id%TYPE;
1781: l_owner_id ota_events.owner_id%TYPE;
1782: l_username fnd_user.user_name%TYPE;
1783: l_auto_waitlist_days NUMBER;
1784: l_auto_waitlist varchar2(1) := 'N';
1785: l_waitlist_size NUMBER := 0;

Line 1788: CURSOR event_csr(p_old_event_id ota_events.event_id%TYPE) IS

1784: l_auto_waitlist varchar2(1) := 'N';
1785: l_waitlist_size NUMBER := 0;
1786:
1787:
1788: CURSOR event_csr(p_old_event_id ota_events.event_id%TYPE) IS
1789: SELECT oet.title,oe.course_start_date,oe.course_start_time,oe.owner_id
1790: FROM ota_events_tl oet, ota_events oe
1791: WHERE oet.event_id = oe.event_id
1792: AND oe.event_id = p_old_event_id

Line 1790: FROM ota_events_tl oet, ota_events oe

1786:
1787:
1788: CURSOR event_csr(p_old_event_id ota_events.event_id%TYPE) IS
1789: SELECT oet.title,oe.course_start_date,oe.course_start_time,oe.owner_id
1790: FROM ota_events_tl oet, ota_events oe
1791: WHERE oet.event_id = oe.event_id
1792: AND oe.event_id = p_old_event_id
1793: AND oet.language = userenv('LANG');
1794:

Line 1800: CURSOR fnduser_csr(l_owner_id ota_events.owner_id%TYPE) IS

1796: CURSOR sys_date_csr IS
1797: SELECT to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS')
1798: FROM dual;
1799:
1800: CURSOR fnduser_csr(l_owner_id ota_events.owner_id%TYPE) IS
1801: SELECT user_name
1802: FROM fnd_user
1803: WHERE employee_id = l_owner_id
1804: AND trunc(sysdate) BETWEEN trunc(start_date) AND nvl(trunc(end_date),trunc(sysdate)+1);

Line 1832: ota_offerings off , ota_events oev

1828:
1829: Cursor chk_for_comp_upd
1830: is
1831: select ocu.online_flag , off.Learning_object_id from ota_category_usages ocu,
1832: ota_offerings off , ota_events oev
1833: where ocu.category_usage_id = off.delivery_mode_id
1834: and off.offering_id = oev.parent_offering_id
1835: and oev.event_id = p_event_id;
1836:

Line 1889: ota_events evt

1885: decode(act_eval.evaluation_id,null,'N',decode(nvl(act_eval.eval_mandatory_flag,'N'),'Y','Y','N'))) flag, --bug 7184369,6935364,7174996
1886: act_eval.evaluation_id act_eval_id
1887: from ota_evaluations evt_eval,
1888: ota_evaluations act_eval,
1889: ota_events evt
1890: where evt_eval.object_id(+) = evt.event_id
1891: and evt_eval.object_type(+) = 'E' --Bug10637605
1892: and act_eval.object_id(+) = evt.activity_version_id
1893: and act_eval.object_type(+) = 'A' --Bug10637605

Line 3152: l_course_start_date ota_events.course_start_date%TYPE;

3148: --bug 6063768 changes starts
3149:
3150: l_hours_until_class_starts NUMBER := 0;
3151: l_sysdate VARCHAR2(30) ;
3152: l_course_start_date ota_events.course_start_date%TYPE;
3153: l_course_start_time ota_events.course_start_time%TYPE;
3154: l_event_title ota_events.title%TYPE;
3155: l_owner_id ota_events.owner_id%TYPE;
3156: l_event_id ota_delegate_bookings.event_id%TYPE;

Line 3153: l_course_start_time ota_events.course_start_time%TYPE;

3149:
3150: l_hours_until_class_starts NUMBER := 0;
3151: l_sysdate VARCHAR2(30) ;
3152: l_course_start_date ota_events.course_start_date%TYPE;
3153: l_course_start_time ota_events.course_start_time%TYPE;
3154: l_event_title ota_events.title%TYPE;
3155: l_owner_id ota_events.owner_id%TYPE;
3156: l_event_id ota_delegate_bookings.event_id%TYPE;
3157: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE;

Line 3154: l_event_title ota_events.title%TYPE;

3150: l_hours_until_class_starts NUMBER := 0;
3151: l_sysdate VARCHAR2(30) ;
3152: l_course_start_date ota_events.course_start_date%TYPE;
3153: l_course_start_time ota_events.course_start_time%TYPE;
3154: l_event_title ota_events.title%TYPE;
3155: l_owner_id ota_events.owner_id%TYPE;
3156: l_event_id ota_delegate_bookings.event_id%TYPE;
3157: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE;
3158: l_booking_status ota_booking_status_types.type%TYPE;

Line 3155: l_owner_id ota_events.owner_id%TYPE;

3151: l_sysdate VARCHAR2(30) ;
3152: l_course_start_date ota_events.course_start_date%TYPE;
3153: l_course_start_time ota_events.course_start_time%TYPE;
3154: l_event_title ota_events.title%TYPE;
3155: l_owner_id ota_events.owner_id%TYPE;
3156: l_event_id ota_delegate_bookings.event_id%TYPE;
3157: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE;
3158: l_booking_status ota_booking_status_types.type%TYPE;
3159: l_username fnd_user.user_name%TYPE;

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

3160: l_auto_waitlist_days NUMBER;
3161: l_auto_waitlist VARCHAR2(2) := 'N';
3162: l_waitlist_size NUMBER := 0;
3163:
3164: CURSOR event_csr(p_event_id ota_events.event_id%TYPE) IS
3165: SELECT oet.title,oe.course_start_date,oe.course_start_time,oe.owner_id
3166: FROM ota_events_tl oet, ota_events oe
3167: WHERE oet.event_id = oe.event_id
3168: AND oe.event_id = p_event_id

Line 3166: FROM ota_events_tl oet, ota_events oe

3162: l_waitlist_size NUMBER := 0;
3163:
3164: CURSOR event_csr(p_event_id ota_events.event_id%TYPE) IS
3165: SELECT oet.title,oe.course_start_date,oe.course_start_time,oe.owner_id
3166: FROM ota_events_tl oet, ota_events oe
3167: WHERE oet.event_id = oe.event_id
3168: AND oe.event_id = p_event_id
3169: AND oet.language = userenv('LANG');
3170:

Line 3175: CURSOR fnduser_csr(l_owner_id ota_events.owner_id%TYPE) IS

3171: CURSOR sys_date_csr IS
3172: SELECT to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS')
3173: FROM dual;
3174:
3175: CURSOR fnduser_csr(l_owner_id ota_events.owner_id%TYPE) IS
3176: SELECT user_name
3177: FROM fnd_user
3178: WHERE employee_id = l_owner_id
3179: AND trunc(sysdate) BETWEEN trunc(start_date) AND nvl(trunc(end_date),trunc(sysdate)+1);

Line 3427: l_event_id ota_events.event_id%TYPE;

3423:
3424: l_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE;
3425: l_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE;
3426: l_customer_id ota_delegate_bookings.customer_id%TYPE;
3427: l_event_id ota_events.event_id%TYPE;
3428: l_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE;
3429: l_check_prereq boolean;
3430: l_old_status_type varchar2(30);
3431: l_new_status_type varchar2(30);