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_ILEARNING dependencies on OTA_ACTIVITY_VERSIONS

Line 70: l_activity_version_id OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID%TYPE;

66: ) is
67:
68: no_language_id_found EXCEPTION;
69: l_proc varchar2(72) := g_package||'crt_or_upd_activity';
70: l_activity_version_id OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID%TYPE;
71: l_object_version_number OTA_ACTIVITY_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
72: l_activity_version_name OTA_ACTIVITY_VERSIONS_TL.VERSION_NAME%TYPE; --MLS change _TL added
73: l_activity_id OTA_ACTIVITY_DEFINITIONS.ACTIVITY_ID%TYPE;
74: l2_language_id FND_LANGUAGES.LANGUAGE_ID%TYPE;

Line 71: l_object_version_number OTA_ACTIVITY_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;

67:
68: no_language_id_found EXCEPTION;
69: l_proc varchar2(72) := g_package||'crt_or_upd_activity';
70: l_activity_version_id OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID%TYPE;
71: l_object_version_number OTA_ACTIVITY_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
72: l_activity_version_name OTA_ACTIVITY_VERSIONS_TL.VERSION_NAME%TYPE; --MLS change _TL added
73: l_activity_id OTA_ACTIVITY_DEFINITIONS.ACTIVITY_ID%TYPE;
74: l2_language_id FND_LANGUAGES.LANGUAGE_ID%TYPE;
75: l_sysdate date;

Line 72: l_activity_version_name OTA_ACTIVITY_VERSIONS_TL.VERSION_NAME%TYPE; --MLS change _TL added

68: no_language_id_found EXCEPTION;
69: l_proc varchar2(72) := g_package||'crt_or_upd_activity';
70: l_activity_version_id OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID%TYPE;
71: l_object_version_number OTA_ACTIVITY_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
72: l_activity_version_name OTA_ACTIVITY_VERSIONS_TL.VERSION_NAME%TYPE; --MLS change _TL added
73: l_activity_id OTA_ACTIVITY_DEFINITIONS.ACTIVITY_ID%TYPE;
74: l2_language_id FND_LANGUAGES.LANGUAGE_ID%TYPE;
75: l_sysdate date;
76:

Line 83: ota_activity_versions OAV

79: activity_version_id,
80: language_id,
81: object_version_number
82: from
83: ota_activity_versions OAV
84: where
85: OAV.rco_id = p_rco_id and
86: OAV.developer_organization_id = p_business_group_id;
87:

Line 93: ota_activity_versions_vl OAV -- MLS change _vl added

89: cursor cur_get_activity_version_name is
90: select
91: version_name
92: from
93: ota_activity_versions_vl OAV -- MLS change _vl added
94: where
95: OAV.version_name = p_activity_version_name and
96: OAV.developer_organization_id = p_business_group_id;
97:

Line 545: l_activity_start_date OTA_ACTIVITY_VERSIONS.START_DATE%TYPE;

541: ,p_message out nocopy varchar2
542: ) is
543:
544: l_proc varchar2(72) := g_package||'crt_or_upd_event';
545: l_activity_start_date OTA_ACTIVITY_VERSIONS.START_DATE%TYPE;
546: l_activity_ovn OTA_ACTIVITY_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
547: l_event_type OTA_EVENTS.EVENT_TYPE%TYPE;
548: l2_event_type OTA_EVENTS.EVENT_TYPE%TYPE;
549: l_event_status OTA_EVENTS.EVENT_STATUS%TYPE;

Line 546: l_activity_ovn OTA_ACTIVITY_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;

542: ) is
543:
544: l_proc varchar2(72) := g_package||'crt_or_upd_event';
545: l_activity_start_date OTA_ACTIVITY_VERSIONS.START_DATE%TYPE;
546: l_activity_ovn OTA_ACTIVITY_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
547: l_event_type OTA_EVENTS.EVENT_TYPE%TYPE;
548: l2_event_type OTA_EVENTS.EVENT_TYPE%TYPE;
549: l_event_status OTA_EVENTS.EVENT_STATUS%TYPE;
550: l_event_id OTA_EVENTS.EVENT_ID%TYPE;

Line 658: ota_activity_versions

654: select
655: start_date,
656: object_version_number
657: from
658: ota_activity_versions
659: where
660: activity_version_id = p_activity_version_id;
661:
662:

Line 1577: l_activity_version_id OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID%TYPE;

1573: ,p_status out nocopy varchar2
1574: ) is
1575:
1576: l_proc varchar2(72) := g_package||'offering_rco_import';
1577: l_activity_version_id OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID%TYPE;
1578: l_language_id FND_LANGUAGES.LANGUAGE_ID%TYPE;
1579: l_rco_status varchar2(1);
1580: l_rco_message varchar2(100);
1581: l_offering_status varchar2(1);

Line 1754: l_activity_version_id OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID%TYPE;

1750: ,p_activity_definition_name in varchar2
1751: ) is
1752:
1753: l_proc varchar2(72) := g_package||'rco_import';
1754: l_activity_version_id OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID%TYPE;
1755: l_language_id FND_LANGUAGES.LANGUAGE_ID%TYPE;
1756: l_rco_status varchar2(1);
1757: l_message varchar2(100);
1758: l_update varchar2(10);