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 HR_GENERAL_UTILITIES

Line 1943: nvl(hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS',opf.lesson_status),

1939:
1940: CURSOR c_get_lo_tree_link(p_performance_id in number) is
1941: Select
1942: olo.name Name,
1943: nvl(hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS',opf.lesson_status),
1944: hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','N')) Status,
1945: nvl(opf.time,0) Time,
1946: opf.score Score,
1947: decode(opf.lesson_status

Line 1944: hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','N')) Status,

1940: CURSOR c_get_lo_tree_link(p_performance_id in number) is
1941: Select
1942: olo.name Name,
1943: nvl(hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS',opf.lesson_status),
1944: hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','N')) Status,
1945: nvl(opf.time,0) Time,
1946: opf.score Score,
1947: decode(opf.lesson_status
1948: ,'C','player_status_c.gif'

Line 2052: fnd_message.set_token ('STATUS', hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','D'));

2048:
2049: --if this is part of active cert prd, return status as "Not Applicable"
2050: if p_active_cert_flag = 'Y' then
2051: fnd_message.set_token ('LO_NAME', l_lo_name);
2052: fnd_message.set_token ('STATUS', hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','D'));
2053: else
2054: fnd_message.set_token ('LO_NAME', l_lo_name);
2055: fnd_message.set_token ('STATUS', l_lo_status);
2056: fnd_message.set_token ('TIME', l_formatted_time);

Line 3031: hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS',lesson_status)lesson_status_name

3027: WHERE BST.booking_status_type_id = p_booking_status_type_id;
3028:
3029: CURSOR c_learning_object_status(l_lo_id in ota_offerings.learning_object_id%TYPE) IS
3030: SELECT lesson_status,
3031: hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS',lesson_status)lesson_status_name
3032: FROM ota_performances
3033: WHERE user_id = p_user_id
3034: AND user_type = p_user_type
3035: AND learning_object_id = l_lo_id

Line 3040: hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS',CONTENT_PLAYER_STATUS)lesson_status_name

3036: AND cert_prd_enrollment_id is null;
3037:
3038: CURSOR c_odb_lo_status IS
3039: SELECT CONTENT_PLAYER_STATUS,
3040: hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS',CONTENT_PLAYER_STATUS)lesson_status_name
3041: FROM ota_delegate_bookings
3042: WHERE booking_id = p_booking_id;
3043:
3044: CURSOR c_imported_offering IS

Line 3058: hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS', prf.lesson_status) lesson_status_name

3054: 'I', '4',
3055: 'B', '5',
3056: 'N', '6') decode_lesson_status,
3057: prf.lesson_status lesson_status,
3058: hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS', prf.lesson_status) lesson_status_name
3059: FROM ota_performances prf
3060: WHERE
3061: prf.user_id = p_user_id
3062: and prf.user_type = p_user_type

Line 3140: l_status_name := hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','N');

3136: End If;
3137:
3138: If ( l_status is null ) Then
3139: l_status := 'N';
3140: l_status_name := hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','N');
3141: End If;
3142:
3143: If ( (l_status = 'N') or (l_status = 'I') ) Then
3144: If ( l_course_end_date < l_sysdate --Class is expired --Bug 3554773 --Bug 5222464

Line 3169: l_status_name := hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','D');

3165:
3166: if l_cert_prd_enrollment_ids is not null then
3167: --return status mng as 'Available under certification'
3168: l_status := 'D';
3169: l_status_name := hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','D');
3170: end if;
3171: end if;
3172: --bug 6683076.Added to show 'Pending Evaluation' as player status for
3173: --learners who have to take mandatory evaluation after

Line 3179: l_status_name:= hr_general_utilities.get_lookup_meaning('DELEGATE_BOOKING_STATUS','E');

3175: --bug 7175372.Added condition so that this player status is shown
3176: --only from learner side.
3177: If (l_status = 'C' or l_status = 'P' or l_status = 'F') Then
3178: If (l_enrollment_status_code = 'E' and (p_mode is null or p_mode <>2)) Then
3179: l_status_name:= hr_general_utilities.get_lookup_meaning('DELEGATE_BOOKING_STATUS','E');
3180: End If;
3181: End If;
3182:
3183: Else

Line 3574: hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS',lesson_status)lesson_status_name

3570: WHERE BST.booking_status_type_id = p_booking_status_type_id;
3571:
3572: CURSOR c_prd_lo_status(l_lo_id in ota_offerings.learning_object_id%TYPE) IS
3573: SELECT lesson_status,
3574: hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS',lesson_status)lesson_status_name
3575: FROM ota_performances
3576: WHERE user_id = p_user_id
3577: AND user_type = p_user_type
3578: AND learning_object_id = l_lo_id

Line 3606: l_status_name := hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','N');

3602: close c_prd_lo_status;
3603:
3604: If ( l_status is null ) Then
3605: l_status := 'N';
3606: l_status_name := hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','N');
3607: End If;
3608:
3609: If ( (l_status = 'N') or (l_status = 'I') ) Then
3610: If ( l_course_end_date < trunc(sysdate) --Class is expired --Bug 3554773

Line 3688: nvl(hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS',opf.lesson_status),

3684:
3685: CURSOR c_get_cert_lo_tree_link(p_performance_id in number) is
3686: Select
3687: olo.name Name,
3688: nvl(hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS',opf.lesson_status),
3689: hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','N')) Status,
3690: nvl(opf.time,0) Time,
3691: opf.score Score,
3692: decode(opf.lesson_status

Line 3689: hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','N')) Status,

3685: CURSOR c_get_cert_lo_tree_link(p_performance_id in number) is
3686: Select
3687: olo.name Name,
3688: nvl(hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS',opf.lesson_status),
3689: hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','N')) Status,
3690: nvl(opf.time,0) Time,
3691: opf.score Score,
3692: decode(opf.lesson_status
3693: ,'C','player_status_c.gif'

Line 4100: hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS',lesson_status)lesson_status_name

4096:
4097: CURSOR c_prd_lo_status(l_lo_id in ota_offerings.learning_object_id%TYPE,
4098: csr_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type) IS
4099: SELECT lesson_status,
4100: hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS',lesson_status)lesson_status_name
4101: FROM ota_performances
4102: WHERE user_id = p_user_id
4103: AND user_type = p_user_type
4104: AND learning_object_id = l_lo_id

Line 4169: --l_return_lo_status := hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','N');

4165:
4166: if (l_online_evt_count > 1) then
4167: --Bug 4560354
4168: --return as Not Attempted
4169: --l_return_lo_status := hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','N');
4170: --return l_return_lo_status;
4171: open csr_get_act;
4172: fetch csr_get_act into rec_get_act;
4173: close csr_get_act;

Line 4181: l_return_lo_status := hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS',rec_prf_ord.lesson_status);

4177: fetch csr_prf_ord into rec_prf_ord;
4178: close csr_prf_ord;
4179:
4180: if rec_prf_ord.lesson_status is not null then
4181: l_return_lo_status := hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS',rec_prf_ord.lesson_status);
4182: else
4183: l_return_lo_status := hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','N');
4184: end if;
4185: end if;

Line 4183: l_return_lo_status := hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','N');

4179:
4180: if rec_prf_ord.lesson_status is not null then
4181: l_return_lo_status := hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS',rec_prf_ord.lesson_status);
4182: else
4183: l_return_lo_status := hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','N');
4184: end if;
4185: end if;
4186:
4187: return l_return_lo_status;

Line 4202: l_status_name := hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','N');

4198: close c_prd_lo_status;
4199:
4200: If ( l_status is null ) Then
4201: l_status := 'N';
4202: l_status_name := hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','N');
4203: End If;
4204:
4205: If ( (l_status = 'N') or (l_status = 'I') ) Then
4206: If ( rec.course_end_date < trunc(sysdate) --Class is expired --Bug 3554773

Line 4712: --l_return_lo_status := hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','N');

4708:
4709: if (l_online_evt_count > 1) then
4710: --return as Not Attempted
4711: --Bug 4560354
4712: --l_return_lo_status := hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','N');
4713: open csr_get_act;
4714: fetch csr_get_act into rec_get_act;
4715: close csr_get_act;
4716:

Line 4723: l_return_lo_status := hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS',rec_prf_ord.lesson_status);

4719: fetch csr_prf_ord into rec_prf_ord;
4720: close csr_prf_ord;
4721:
4722: if rec_prf_ord.lesson_status is not null then
4723: l_return_lo_status := hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS',rec_prf_ord.lesson_status);
4724: else
4725: l_return_lo_status := hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','N');
4726: end if;
4727: end if;

Line 4725: l_return_lo_status := hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','N');

4721:
4722: if rec_prf_ord.lesson_status is not null then
4723: l_return_lo_status := hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS',rec_prf_ord.lesson_status);
4724: else
4725: l_return_lo_status := hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','N');
4726: end if;
4727: end if;
4728:
4729: return l_return_lo_status;