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

Line 10: l_time_zone ota_events.timezone%TYPE;

6: log_type_n constant VARCHAR2(30) := 'N';
7: -- log type is Internal
8: log_type_e constant VARCHAR2(30) := 'E';
9: -- log type is Error
10: l_time_zone ota_events.timezone%TYPE;
11: l_primary_venue ota_events.location_id%TYPE;
12: l_loc_id ota_suppliable_resources.location_id%TYPE;
13: l_trng_center_id ota_suppliable_resources.training_center_id%TYPE;
14: l_err_msg VARCHAR2(2000);

Line 11: l_primary_venue ota_events.location_id%TYPE;

7: -- log type is Internal
8: log_type_e constant VARCHAR2(30) := 'E';
9: -- log type is Error
10: l_time_zone ota_events.timezone%TYPE;
11: l_primary_venue ota_events.location_id%TYPE;
12: l_loc_id ota_suppliable_resources.location_id%TYPE;
13: l_trng_center_id ota_suppliable_resources.training_center_id%TYPE;
14: l_err_msg VARCHAR2(2000);
15: l_err VARCHAR2(2000);

Line 25: l_time_zone ota_events.timezone%TYPE;

21: FUNCTION get_location_tz(l_location_id IN ota_suppliable_resources.location_id%TYPE)
22: RETURN VARCHAR2
23: IS
24:
25: l_time_zone ota_events.timezone%TYPE;
26:
27: CURSOR csr_loc_tz(loc_id NUMBER) IS
28: SELECT timezone_code
29: FROM hr_locations

Line 106: PROCEDURE upd_classic_data(p_event_id ota_events.event_id%TYPE,

102: BEGIN
103: fnd_file.PUT_LINE(fnd_file.LOG, msg);
104: END write_log;
105:
106: PROCEDURE upd_classic_data(p_event_id ota_events.event_id%TYPE,
107: p_event_type ota_events.event_type%TYPE,
108: p_public_event_flag ota_events.public_event_flag%TYPE,
109: l_upgrade_id NUMBER)
110: IS

Line 107: p_event_type ota_events.event_type%TYPE,

103: fnd_file.PUT_LINE(fnd_file.LOG, msg);
104: END write_log;
105:
106: PROCEDURE upd_classic_data(p_event_id ota_events.event_id%TYPE,
107: p_event_type ota_events.event_type%TYPE,
108: p_public_event_flag ota_events.public_event_flag%TYPE,
109: l_upgrade_id NUMBER)
110: IS
111: --bug 5157917

Line 108: p_public_event_flag ota_events.public_event_flag%TYPE,

104: END write_log;
105:
106: PROCEDURE upd_classic_data(p_event_id ota_events.event_id%TYPE,
107: p_event_type ota_events.event_type%TYPE,
108: p_public_event_flag ota_events.public_event_flag%TYPE,
109: l_upgrade_id NUMBER)
110: IS
111: --bug 5157917
112:

Line 131: UPDATE ota_events

127: -- 2) Maximum_internal_attendees to 0 for price basis in 'C' or 'O'
128: -- Update TIMEZONE for iLearning imported events to
129: -- the corresponding APPS (FND_TIMEZONES_VL) timezone code.
130:
131: UPDATE ota_events
132: SET book_independent_flag = nvl(book_independent_flag, 'N'),
133: secure_event_flag = nvl(secure_event_flag, 'N'),
134: maximum_internal_attendees = decode(price_basis, 'C', 0, 'O', 0, maximum_internal_attendees),
135: timezone = decode(offering_id, NULL, timezone, ota_classic_upgrade.get_apps_timezone(timezone))

Line 155: UPDATE ota_events

151: END IF;
152:
153: CLOSE csr_lrnr_acc;
154:
155: UPDATE ota_events
156: SET public_event_flag = v_pblc_evt_flg
157: WHERE event_id = p_event_id;
158: END IF;
159:

Line 165: ota_classic_upgrade.add_log_entry(p_table_name => 'OTA_EVENTS',

161:
162: EXCEPTION
163: WHEN others THEN
164: l_err_msg := nvl(SUBSTR(sqlerrm, 1, 2000), l_msg);
165: ota_classic_upgrade.add_log_entry(p_table_name => 'OTA_EVENTS',
166: p_business_group_id => NULL,
167: p_source_primary_key => p_event_id,
168: p_object_value => l_upgrade_name,
169: p_message_text => l_err_msg,

Line 232: l_time_zone ota_events.timezone%TYPE;

228:
229: FUNCTION get_primary_venue_tz(l_primary_venue IN ota_suppliable_resources.supplied_resource_id%TYPE)
230: RETURN VARCHAR2
231: IS
232: l_time_zone ota_events.timezone%TYPE;
233:
234: CURSOR csr_pri_ven_tz(p_pri_ven NUMBER) IS
235: SELECT loc.timezone_code
236: FROM ota_suppliable_resources res,

Line 259: l_time_zone ota_events.timezone%TYPE;

255:
256: FUNCTION get_trngcenter_tz(l_trainning_center IN ota_suppliable_resources.training_center_id%TYPE)
257: RETURN VARCHAR2
258: IS
259: l_time_zone ota_events.timezone%TYPE;
260:
261: CURSOR csr_trgctr_tz(trg_cen_id NUMBER) IS
262: SELECT loc.timezone_code
263:

Line 347: FROM ota_events

343: PROCEDURE upd_event_bkng(p_event_id NUMBER, p_time_zone VARCHAR2, l_upgrade_id NUMBER)
344: AS
345: CURSOR csr_event_sess IS
346: SELECT event_id
347: FROM ota_events
348: WHERE event_id = p_event_id OR parent_event_id = p_event_id
349: AND timezone IS NULL;
350:
351: CURSOR csr_event_res_bkng(p_event_id NUMBER) IS

Line 364: UPDATE ota_events

360: -- * FOR event_sess_row IN csr_event_sess
361: -- * LOOP
362: BEGIN
363:
364: UPDATE ota_events
365: SET timezone = p_time_zone -- * WHERE event_id = event_sess_row.event_id
366: WHERE(event_id = p_event_id OR parent_event_id = p_event_id)
367: AND timezone IS NULL -- Added for bug#5110735
368: AND event_type IN('SCHEDULED', 'SESSION', 'SELFPACED','DEVELOPMENT','PROGRAMME');

Line 373: ota_classic_upgrade.add_log_entry(p_table_name => 'OTA_events',

369:
370: EXCEPTION
371: WHEN others THEN
372: l_err_msg := nvl(SUBSTR(sqlerrm, 1, 2000), l_msg);
373: ota_classic_upgrade.add_log_entry(p_table_name => 'OTA_events',
374: p_business_group_id => NULL,
375: p_source_primary_key => p_event_id, -- * event_sess_row.event_id,
376: p_object_value => l_upgrade_name,
377: p_message_text => l_err_msg,

Line 397: FROM ota_events

393: END LOOP;*/
394: UPDATE ota_resource_bookings
395: SET timezone_code = p_time_zone
396: WHERE event_id in (SELECT event_id
397: FROM ota_events
398: WHERE event_id = p_event_id OR parent_event_id = p_event_id)
399: AND timezone_code IS NULL;
400: -- * event_sess_row.event_id and timezone_code IS NULL;
401: -- * END LOOP;

Line 665: FROM ota_events;

661: training_center_id,
662: timezone,
663: event_type,
664: public_event_flag
665: FROM ota_events;
666: BEGIN
667: FOR class_ses_res_bkng_row IN csr_class_ses_res_bkng
668: LOOP
669: l_time_zone := NULL;

Line 701: ota_classic_upgrade.add_log_entry(p_table_name => 'OTA_EVENTS',

697:
698: IF(l_time_zone IS NULL) THEN
699:
700: IF p_default_timezone IS NULL THEN
701: ota_classic_upgrade.add_log_entry(p_table_name => 'OTA_EVENTS',
702: p_business_group_id => NULL,
703: p_source_primary_key => class_ses_res_bkng_row.event_id,
704: p_object_value => 'Timezone',
705: p_message_text => l_default_msg,