APPS.OTA_ILEARNING dependencies on FND_LANGUAGES

Line 74: l2_language_id FND_LANGUAGES.LANGUAGE_ID%TYPE;

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:
77: cursor cur_get_activity_version_id is
78: select

Line 124: fnd_languages

120: cursor cur_get_language_id is
121: select
122: language_id
123: from
124: fnd_languages
125: where
126: language_code = p_language_code;
127:
128:

Line 1578: l_language_id FND_LANGUAGES.LANGUAGE_ID%TYPE;

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);
1582: l_offering_message varchar2(100);

Line 1755: l_language_id FND_LANGUAGES.LANGUAGE_ID%TYPE;

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);
1759: l_activity_success number(10) := 0;