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

Line 81: from ota_events

77: -- cursor to check if event is PLANNED
78: --
79: cursor chk_pland is
80: select event_status
81: from ota_events
82: where event_id = l_event_id;
83: --
84: -- cursor to check if resource booking is for a SESSION
85: --

Line 88: from ota_events

84: -- cursor to check if resource booking is for a SESSION
85: --
86: cursor chk_sess is
87: select event_type,parent_event_id
88: from ota_events
89: where event_id = l_event_id;
90: --
91: -- cursor to check numbers of delegates per unit
92: --

Line 96: ota_events e,

92: --
93: cursor chk_number is
94: select 1
95: from ota_suppliable_resources sr,
96: ota_events e,
97: ota_offerings off
98: where sr.supplied_resource_id = p_supplied_resource_id
99: and e.event_id = l_event_id
100: and off.offering_id = e.parent_offering_id --bug 3494404

Line 209: l_business_group_id ota_events.business_group_id%type; -- bug 4304067

205: --
206: l_proc varchar2(72) := g_package||'get_total_cost';
207: l_exists number;
208: l_tot number;
209: l_business_group_id ota_events.business_group_id%type; -- bug 4304067
210: --
211: -- cursor to perform check on currency codes
212: --
213: cursor chk_curr (p_business_group_id in number) is -- bug 4304067

Line 215: from ota_events e

211: -- cursor to perform check on currency codes
212: --
213: cursor chk_curr (p_business_group_id in number) is -- bug 4304067
214: select 1
215: from ota_events e
216: where business_group_id = p_business_group_id
217: and exists
218: (select 1
219: from ota_suppliable_resources sr,

Line 231: from ota_events e

227: -- cursor to get business_group_id bug 4304067
228: --
229: cursor csr_business_group_id is
230: select e.business_group_id
231: from ota_events e
232: where e.event_id = p_event_id;
233:
234: --
235: -- cursor to perform calculations

Line 240: ota_events e,

236: --
237: cursor get_rescost is
238: select sr.cost
239: from ota_suppliable_resources sr,
240: ota_events e,
241: ota_resource_bookings rb
242: where rb.event_id = p_event_id
243: and rb.status = 'C'
244: and sr.supplied_resource_id = rb.supplied_resource_id

Line 455: from ota_events

451: --cursor to get dates of object
452:
453: cursor get_event_dates is
454: select course_start_date,course_end_date,event_type,timezone,course_start_time,course_end_time
455: from ota_events
456: where event_id = p_event_id;
457:
458: cursor get_forum_dates is
459: select start_date_active,end_date_active

Line 617: from ota_events e,

613: -- cursor to check business group id's
614: --
615: cursor chk_bgroup is
616: select 1
617: from ota_events e,
618: ota_suppliable_resources sr
619: where sr.supplied_resource_id = p_supplied_resource_id
620: and e.event_id = p_event_id
621: and sr.business_group_id = e.business_group_id;

Line 848: ota_events e,

844: --
845: cursor chk_primven is
846: select 1
847: from ota_resource_bookings rb,
848: ota_events e,
849: ota_offerings off
850: where e.event_id = rb.event_id
851: and off.offering_id = e.parent_offering_id --bug 3494404
852: and ((rb.required_date_from between

Line 1793: from ota_events

1789: -- cursor to perform check on event type
1790: --
1791: cursor chk_type is
1792: select 1
1793: from ota_events
1794: where event_id = p_event_id
1795: and event_type in
1796: ('SCHEDULED','SESSION','PROGRAMME MEMBER','DEVELOPMENT','SELFPACED');
1797: --

Line 1889: Where rud.offering_id = (select evt.parent_offering_id from ota_events evt -- bug 3494404

1885: rud.supplied_resource_id,
1886: rud.quantity
1887: From
1888: ota_resource_usages rud
1889: Where rud.offering_id = (select evt.parent_offering_id from ota_events evt -- bug 3494404
1890: where evt.event_id = p_event_id) -- bug 3494404
1891: and p_event_start_date between
1892: nvl(rud.start_date, hr_api.g_sot) and nvl(rud.end_date, hr_api.g_eot)
1893: and rud.supplied_resource_id is not null

Line 1905: from ota_events

1901: --
1902:
1903: Cursor get_event_timezone is --Bug#5126185
1904: select timezone
1905: from ota_events
1906: where event_id=p_event_id;
1907:
1908: --
1909: Begin

Line 1978: from ota_events_vl evt, -- MLS change _vl added

1974: evt.course_start_time,
1975: evt.course_end_time,
1976: evt.currency_code,
1977: fnd.name
1978: from ota_events_vl evt, -- MLS change _vl added
1979: fnd_currencies_vl fnd
1980: where evt.event_id = p_event_id
1981: and fnd.currency_code = evt.currency_code;
1982: --

Line 2052: l_event_type ota_events.event_type%type;

2048: l_resource_type varchar2(1);
2049: l_trainer_id number;
2050: l_competence varchar2(3000);
2051: l_person_id number;
2052: l_event_type ota_events.event_type%type;
2053: l_parent_event ota_events.event_id%type;
2054: l_event_id ota_events.event_id%type;
2055: --l_language_id ota_events.language_id%type; -- 2733966
2056: l_competence_id per_competence_elements.competence_id%type;

Line 2053: l_parent_event ota_events.event_id%type;

2049: l_trainer_id number;
2050: l_competence varchar2(3000);
2051: l_person_id number;
2052: l_event_type ota_events.event_type%type;
2053: l_parent_event ota_events.event_id%type;
2054: l_event_id ota_events.event_id%type;
2055: --l_language_id ota_events.language_id%type; -- 2733966
2056: l_competence_id per_competence_elements.competence_id%type;
2057: l_proficiency_level_id per_competence_elements.proficiency_level_id%type;

Line 2054: l_event_id ota_events.event_id%type;

2050: l_competence varchar2(3000);
2051: l_person_id number;
2052: l_event_type ota_events.event_type%type;
2053: l_parent_event ota_events.event_id%type;
2054: l_event_id ota_events.event_id%type;
2055: --l_language_id ota_events.language_id%type; -- 2733966
2056: l_competence_id per_competence_elements.competence_id%type;
2057: l_proficiency_level_id per_competence_elements.proficiency_level_id%type;
2058: l_step_value number := null;

Line 2055: --l_language_id ota_events.language_id%type; -- 2733966

2051: l_person_id number;
2052: l_event_type ota_events.event_type%type;
2053: l_parent_event ota_events.event_id%type;
2054: l_event_id ota_events.event_id%type;
2055: --l_language_id ota_events.language_id%type; -- 2733966
2056: l_competence_id per_competence_elements.competence_id%type;
2057: l_proficiency_level_id per_competence_elements.proficiency_level_id%type;
2058: l_step_value number := null;
2059: l_language_code ota_offerings.language_code%type;

Line 2080: FROM ota_events

2076: AND rat.rating_level_id = pce.proficiency_level_id
2077: AND pce.type = 'OTA_OFFERING' --bug 3494404
2078: AND pce.Object_id in (
2079: SELECT parent_offering_id --bug 3494404
2080: FROM ota_events
2081: WHERE event_id = p_event_id);
2082:
2083: Cursor
2084: c_event_type

Line 2088: OTA_EVENTS ev,

2084: c_event_type
2085: IS
2086: SELECT ev.event_type,ev.parent_event_id ,off.language_code
2087: FROM
2088: OTA_EVENTS ev,
2089: OTA_OFFERINGS_VL off
2090: WHERE ev.EVENT_ID = p_event_id
2091: AND ev.parent_offering_id = off.offering_id;
2092:

Line 2097: From OTA_EVENTS ev,

2093: Cursor
2094: c_event_lang (p_event_id number)
2095: IS
2096: select off.language_code
2097: From OTA_EVENTS ev,
2098: OTA_OFFERINGS_VL off
2099: WHERE EVENT_ID = p_event_id
2100: AND ev.parent_offering_id = off.offering_id;
2101: