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

Line 389: from ota_events evt

385:
386: cursor c_online_events(p_act_ver_id number) is
387: select count(decode(evt.event_type,'SELFPACED',1,null)) selfpaced_c
388: ,count(decode(evt.event_type,'SCHEDULED',1,null)) scheduled_c
389: from ota_events evt
390: where evt.activity_version_id = p_act_ver_id;
391:
392: l_found number;
393: l_online_flag ota_category_usages.online_flag%type;

Line 487: from ota_events evt

483:
484: cursor c_online_events(p_act_ver_id number) is
485: select count(decode(evt.event_type,'SELFPACED',1,null)) selfpaced_c
486: ,count(decode(evt.event_type,'SCHEDULED',1,null)) scheduled_c
487: from ota_events evt
488: where evt.activity_version_id = p_act_ver_id;
489:
490: l_found number;
491: l_online_flag ota_category_usages.online_flag%type;

Line 1415: -- This procedure creates the Offering based on the records exists in ota_events

1411:
1412: -- ----------------------------------------------------------------------------
1413: -- |--------------------------< Create_Offering >-----------------------------|
1414: -- ----------------------------------------------------------------------------
1415: -- This procedure creates the Offering based on the records exists in ota_events
1416: -- and ota_activity_versions table.
1417: PROCEDURE Create_Offering(
1418: p_process_control IN varchar2,
1419: p_start_pkid IN number,

Line 1489: FROM ota_events

1485:
1486:
1487: CURSOR c_get_lang(p_act_ver_id number) is
1488: SELECT language_id, decode(event_type,'SELFPACED','SELFPACED','SCHEDULED') event_type
1489: FROM ota_events
1490: WHERE activity_version_id = p_act_ver_id
1491: AND parent_offering_id is NULL
1492: Group by Language_id , decode(event_type,'SELFPACED','SELFPACED','SCHEDULED');
1493:

Line 1542: Type Event_tab is Table of Ota_Events.Language_id%Type INDEX BY BINARY_INTEGER;

1538:
1539:
1540: -- Changed Table type declaration for 3389869 as multidimesion table declaration is not supported in 8.1.7
1541: -- Type Event_tab is Table of c_get_lang%RowType INDEX BY BINARY_INTEGER;
1542: Type Event_tab is Table of Ota_Events.Language_id%Type INDEX BY BINARY_INTEGER;
1543: Offering_RecSet Event_tab;
1544: Type Event_type_tab is Table of Ota_Events.event_type%Type INDEX BY BINARY_INTEGER;
1545: Offering_evt_set Event_type_tab;
1546:

Line 1544: Type Event_type_tab is Table of Ota_Events.event_type%Type INDEX BY BINARY_INTEGER;

1540: -- Changed Table type declaration for 3389869 as multidimesion table declaration is not supported in 8.1.7
1541: -- Type Event_tab is Table of c_get_lang%RowType INDEX BY BINARY_INTEGER;
1542: Type Event_tab is Table of Ota_Events.Language_id%Type INDEX BY BINARY_INTEGER;
1543: Offering_RecSet Event_tab;
1544: Type Event_type_tab is Table of Ota_Events.event_type%Type INDEX BY BINARY_INTEGER;
1545: Offering_evt_set Event_type_tab;
1546:
1547: l_event_exists Varchar2(1) ;
1548: l_res_usg_cnt Number(5) ;

Line 1550: l_evt_language_id Ota_Events.Language_id%Type ;

1546:
1547: l_event_exists Varchar2(1) ;
1548: l_res_usg_cnt Number(5) ;
1549: l_cmp_cnt Number(5) ;
1550: l_evt_language_id Ota_Events.Language_id%Type ;
1551: l_learning_object_id ota_offerings.learning_object_id%type;
1552: l_iteration Number(5) ;
1553:
1554: l_err_code varchar2(72);

Line 1883: Update Ota_events Evt

1879: ,p_upgrade_name => UPGRADE_NAME);
1880: end;
1881: -- Sets the Parent offering id .
1882:
1883: Update Ota_events Evt
1884: Set Evt.Parent_Offering_id = l_offering_id
1885: Where Evt.activity_Version_id = Ids.Activity_Version_id
1886: -- and Nvl(Evt.language_id,0) = Decode(Offering_RecSet(Evt_lang).language_id,NULL,0,l_Language_id)
1887: and (

Line 1915: Update Ota_events Evt

1911:
1912: end;
1913: else
1914:
1915: Update Ota_events Evt
1916: Set Evt.Parent_Offering_id = l_parent_offering_id
1917: Where Evt.activity_Version_id = Ids.Activity_Version_id
1918: -- and Nvl(Evt.language_id,0) = Decode(l_evt_language_id,NULL,Nvl(Evt.language_id,0),l_evt_language_id) Commented for bug# 4139874
1919: and (

Line 1990: type ila_timezone_type is table of ota_events.timezone%TYPE ;

1986: function get_apps_timezone(ila_tzone in varchar2) return varchar2 is
1987:
1988: NOT_MAPPED constant varchar2(20) := 'NOT_MAPPED';
1989: TZ_DEFAULT constant varchar2(20) := null;
1990: type ila_timezone_type is table of ota_events.timezone%TYPE ;
1991: type fnd_timezone_type is table of ota_events.timezone%TYPE ;
1992: ila_timezones ila_timezone_type
1993: := ila_timezone_type( 'GMT' -- 'Pacific/Kwajalein'
1994: ,'SST' -- 'Pacific/Midway'

Line 1991: type fnd_timezone_type is table of ota_events.timezone%TYPE ;

1987:
1988: NOT_MAPPED constant varchar2(20) := 'NOT_MAPPED';
1989: TZ_DEFAULT constant varchar2(20) := null;
1990: type ila_timezone_type is table of ota_events.timezone%TYPE ;
1991: type fnd_timezone_type is table of ota_events.timezone%TYPE ;
1992: ila_timezones ila_timezone_type
1993: := ila_timezone_type( 'GMT' -- 'Pacific/Kwajalein'
1994: ,'SST' -- 'Pacific/Midway'
1995: ,'HST' -- NOT_MAPPED

Line 2121: retval ota_events.timezone%TYPE := TZ_DEFAULT;

2117:
2118: ila_i BINARY_INTEGER;
2119: fnd_i BINARY_INTEGER;
2120:
2121: retval ota_events.timezone%TYPE := TZ_DEFAULT;
2122:
2123: begin
2124:
2125: if ( ila_tzone is null ) then

Line 2207: update OTA_EVENTS

2203: begin
2204: -- Upgrade OM Events
2205: -- 1) set book_independent_flag to N iff null
2206: -- 2) Maximum_internal_attendees to 0 for price basis in 'C' or 'O'
2207: update OTA_EVENTS
2208: set book_independent_flag = nvl(book_independent_flag,'N'),
2209: Maximum_internal_attendees = Decode(Price_basis,'C',0,'O',0,Maximum_internal_attendees)
2210: where event_id between p_start_pkid and p_end_pkid;
2211:

Line 2215: update OTA_EVENTS

2211:
2212:
2213: -- Update TIMEZONE for iLearning imported events to
2214: -- the corresponding APPS (FND_TIMEZONES_VL) timezone code.
2215: update OTA_EVENTS
2216: set TIMEZONE = get_apps_timezone(timezone)
2217: where offering_id is not null --iLearning imported events.
2218: and event_id between p_start_pkid and p_end_pkid
2219: and TIMEZONE is NOT NULL;

Line 2223: from ota_events

2219: and TIMEZONE is NOT NULL;
2220:
2221: select nvl(count(event_id),0)
2222: into l_rows_processed
2223: from ota_events
2224: where event_id between p_start_pkid and p_end_pkid ;
2225:
2226: p_rows_processed := l_rows_processed;
2227: end Upgrade_Events;

Line 2886: FROM ota_events evt, ota_offerings off

2882: AND RowID Between p_start_rowid and p_end_rowid ;
2883:
2884: CURSOR c_learning_object_id IS
2885: SELECT off.learning_object_id
2886: FROM ota_events evt, ota_offerings off
2887: WHERE evt.event_id = l_event_id
2888: and evt.parent_offering_id = off.offering_id;
2889:
2890: CURSOR c_less_status(p_user_id in number,p_lo_id in number) IS