APPS.OTA_ILEARNING dependencies on OTA_ILEARNING

Line 1: package body OTA_ILEARNING as

1: package body OTA_ILEARNING as
2: /* $Header: otilncnt.pkb 120.2 2008/01/17 11:50:07 smahanka noship $ */
3: /*
4: ===========================================================================
5: | Copyright (c) 1996 Oracle Corporation |

Line 39: g_package varchar2(33) := ' ota_ilearning.'; -- Global package name

35: 28-jun-04 115.17 ssur 3725560 Restricted import of newly created RCO and Offerings.
36: 07-Jan-08 120.1 aabalakr 6683076, modified to include the new enrollment status, 'E'(Pending Evaluation)
37: */
38: --------------------------------------------------------------------------------
39: g_package varchar2(33) := ' ota_ilearning.'; -- Global package name
40: --
41:
42: --
43: -- ----------------------------------------------------------------------------

Line 141: l_activity_id := FND_PROFILE.VALUE('OTA_ILEARNING_DEFAULT_ACTIVITY');

137:
138: if cur_get_activity_version_id%NOTFOUND then --if activity_version_id
139: close cur_get_activity_version_id;
140:
141: l_activity_id := FND_PROFILE.VALUE('OTA_ILEARNING_DEFAULT_ACTIVITY');
142: /*
143: open cur_get_activity_id;
144: fetch cur_get_activity_id into l_activity_id;
145: if cur_get_activity_id%NOTFOUND then --if activity_id

Line 2036: end OTA_ILEARNING;

2032:
2033: end upd_xml_prcs_tbl;
2034:
2035:
2036: end OTA_ILEARNING;