[Home] [Help]
1: package body ota_lo_utility as
2: /* $Header: otloutil.pkb 120.68.12010000.8 2008/12/10 11:24:25 smahanka ship $ */
3:
4: g_package varchar2(33) := ' ota_lo_utility.'; -- Global package name
5:
1: package body ota_lo_utility as
2: /* $Header: otloutil.pkb 120.68.12010000.8 2008/12/10 11:24:25 smahanka ship $ */
3:
4: g_package varchar2(33) := ' ota_lo_utility.'; -- Global package name
5:
6: function compute_default_lesson_status(
7: p_lo_id ota_learning_objects.learning_object_id%type,
8: p_user_id fnd_user.user_id%type,
1949: ,'F','player_status_f.gif'
1950: ,'I','player_status_i.gif'
1951: ,'P','player_status_p.gif'
1952: ,'N','player_status_n.gif'
1953: ,null,DECODE(OTA_LO_UTILITY.user_can_attempt_lo(olo.learning_object_id,p_user_id,p_user_type),
1954: 'N','player_status_no_prereq.gif',
1955: 'Y','player_status_n.gif')
1956: ,'player_status_n.gif') STATUS_ICON
1957: , tst.grade_flag
3694: ,'F','player_status_f.gif'
3695: ,'I','player_status_i.gif'
3696: ,'P','player_status_p.gif'
3697: ,'N','player_status_n.gif'
3698: ,null,DECODE(OTA_LO_UTILITY.user_can_attempt_lo(olo.learning_object_id,p_user_id,p_user_type,'', p_cert_prd_enrollment_id),
3699: 'N','player_status_no_prereq.gif',
3700: 'Y','player_status_n.gif')
3701: ,'player_status_n.gif') STATUS_ICON
3702: , tst.grade_flag
4002: fetch csr_event into rec;
4003: close csr_event;
4004:
4005: if (l_online_event_id is not null) then
4006: l_return_play_btn := OTA_LO_UTILITY.GET_PLAY_BUTTON(p_user_id,p_user_type, p_is_manager, rec.EVENT_ID, rec.EVENT_TYPE
4007: ,rec.SYNCHRONOUS_FLAG, rec.ONLINE_FLAG
4008: ,rec.COURSE_START_DATE ,rec.COURSE_END_DATE, null,rec_cme.cert_prd_enrollment_id);
4009: end if;
4010: hr_utility.set_location('Leaving :'||l_proc,10);
4954: RETURN l_return;
4955: --
4956: End Lo_has_cld_and_no_strt_url;
4957:
4958: end ota_lo_utility;