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_LO_UTILITY dependencies on OTA_LO_UTILITY

Line 1: package body ota_lo_utility as

1: package body ota_lo_utility as
2: /* $Header: otloutil.pkb 120.106.12020000.10 2013/03/29 12:58:08 jaysridh ship $ */
3:
4: g_package varchar2(33) := ' ota_lo_utility.'; -- Global package name
5: cursor csr_active_cert_prd_person(p_event_id ota_events.event_id%type,

Line 4: g_package varchar2(33) := ' ota_lo_utility.'; -- Global package name

1: package body ota_lo_utility as
2: /* $Header: otloutil.pkb 120.106.12020000.10 2013/03/29 12:58:08 jaysridh ship $ */
3:
4: g_package varchar2(33) := ' ota_lo_utility.'; -- Global package name
5: cursor csr_active_cert_prd_person(p_event_id ota_events.event_id%type,
6: p_person_id ota_cert_enrollments.contact_id%type) is
7: SELECT cpe.cert_prd_enrollment_id
8: FROM OTA_CERTIFICATIONS_B crt,

Line 2279: ,null,DECODE(OTA_LO_UTILITY.user_can_attempt_lo(olo.learning_object_id,p_user_id,p_user_type),

2275: ,'F','player_status_f.gif'
2276: ,'I','player_status_i.gif'
2277: ,'P','player_status_p.gif'
2278: ,'N','player_status_n.gif'
2279: ,null,DECODE(OTA_LO_UTILITY.user_can_attempt_lo(olo.learning_object_id,p_user_id,p_user_type),
2280: 'N','player_status_no_prereq.gif',
2281: 'Y','player_status_n.gif')
2282: ,'player_status_n.gif') STATUS_ICON
2283: , tst.grade_flag

Line 2314: ,null,DECODE(OTA_LO_UTILITY.user_can_attempt_lo(olo.learning_object_id,p_user_id,p_user_type),

2310: ,'F','player_status_f.gif'
2311: ,'I','player_status_i.gif'
2312: ,'P','player_status_p.gif'
2313: ,'N','player_status_n.gif'
2314: ,null,DECODE(OTA_LO_UTILITY.user_can_attempt_lo(olo.learning_object_id,p_user_id,p_user_type),
2315: 'N','player_status_no_prereq.gif',
2316: 'Y','player_status_n.gif')
2317: ,'player_status_n.gif') STATUS_ICON
2318: , tst.grade_flag

Line 4216: ,null,DECODE(OTA_LO_UTILITY.user_can_attempt_lo(olo.learning_object_id,p_user_id,p_user_type,'', p_cert_prd_enrollment_id),

4212: ,'F','player_status_f.gif'
4213: ,'I','player_status_i.gif'
4214: ,'P','player_status_p.gif'
4215: ,'N','player_status_n.gif'
4216: ,null,DECODE(OTA_LO_UTILITY.user_can_attempt_lo(olo.learning_object_id,p_user_id,p_user_type,'', p_cert_prd_enrollment_id),
4217: 'N','player_status_no_prereq.gif',
4218: 'Y','player_status_n.gif')
4219: ,'player_status_n.gif') STATUS_ICON
4220: , tst.grade_flag

Line 4250: ,null,DECODE(OTA_LO_UTILITY.user_can_attempt_lo(olo.learning_object_id,p_user_id,p_user_type,'', p_cert_prd_enrollment_id),

4246: ,'F','player_status_f.gif'
4247: ,'I','player_status_i.gif'
4248: ,'P','player_status_p.gif'
4249: ,'N','player_status_n.gif'
4250: ,null,DECODE(OTA_LO_UTILITY.user_can_attempt_lo(olo.learning_object_id,p_user_id,p_user_type,'', p_cert_prd_enrollment_id),
4251: 'N','player_status_no_prereq.gif',
4252: 'Y','player_status_n.gif')
4253: ,'player_status_n.gif') STATUS_ICON
4254: , tst.grade_flag

Line 4582: 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

4578: fetch csr_event into rec;
4579: close csr_event;
4580:
4581: if (l_online_event_id is not null) then
4582: 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
4583: ,rec.SYNCHRONOUS_FLAG, rec.ONLINE_FLAG
4584: ,rec.COURSE_START_DATE ,rec.COURSE_END_DATE, null,rec_cme.cert_prd_enrollment_id);
4585: end if;
4586: hr_utility.set_location('Leaving :'||l_proc,10);

Line 5720: end ota_lo_utility;

5716: return l_perf_rec_count;
5717: end get_num_of_online_records;
5718:
5719:
5720: end ota_lo_utility;