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 2269: nvl(hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS',opf.lesson_status),

2265:
2266: CURSOR c_get_lo_tree_link(p_performance_id in number) is
2267: Select
2268: olo.name Name,
2269: nvl(hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS',opf.lesson_status),
2270: hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','N')) Status,
2271: nvl(opf.time,0) Time,
2272: opf.score Score,
2273: decode(opf.lesson_status

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

2266: CURSOR c_get_lo_tree_link(p_performance_id in number) is
2267: Select
2268: olo.name Name,
2269: nvl(hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS',opf.lesson_status),
2270: hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','N')) Status,
2271: nvl(opf.time,0) Time,
2272: opf.score Score,
2273: decode(opf.lesson_status
2274: ,'C','player_status_c.gif'

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

2300:
2301: CURSOR c_get_lo_tree_link_null(p_performance_id in number) is
2302: Select
2303: olo.name Name,
2304: nvl(hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS',opf.lesson_status),
2305: hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','N')) Status,
2306: nvl(opf.time,0) Time,
2307: opf.score Score,
2308: decode(opf.lesson_status

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

2301: CURSOR c_get_lo_tree_link_null(p_performance_id in number) is
2302: Select
2303: olo.name Name,
2304: nvl(hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS',opf.lesson_status),
2305: hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','N')) Status,
2306: nvl(opf.time,0) Time,
2307: opf.score Score,
2308: decode(opf.lesson_status
2309: ,'C','player_status_c.gif'

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

2433:
2434: --if this is part of active cert prd, return status as "Not Applicable"
2435: if p_active_cert_flag = 'Y' then
2436: fnd_message.set_token ('LO_NAME', l_lo_name);
2437: fnd_message.set_token ('STATUS', hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','D'));
2438: else
2439: fnd_message.set_token ('LO_NAME', l_lo_name);
2440: fnd_message.set_token ('STATUS', l_lo_status);
2441: fnd_message.set_token ('TIME', l_formatted_time);

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

3392: WHERE BST.booking_status_type_id = p_booking_status_type_id;
3393:
3394: CURSOR c_learning_object_status(l_lo_id in ota_offerings.learning_object_id%TYPE) IS
3395: SELECT lesson_status,
3396: hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS',lesson_status)lesson_status_name
3397: FROM ota_performances
3398: WHERE user_id = p_user_id
3399: AND user_type = p_user_type
3400: AND learning_object_id = l_lo_id

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

3401: AND cert_prd_enrollment_id is null;
3402:
3403: CURSOR c_odb_lo_status IS
3404: SELECT CONTENT_PLAYER_STATUS,
3405: hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS',CONTENT_PLAYER_STATUS)lesson_status_name
3406: FROM ota_delegate_bookings
3407: WHERE booking_id = p_booking_id;
3408:
3409: CURSOR c_imported_offering IS

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

3448: 'I', '4',
3449: 'B', '5',
3450: 'N', '6') decode_lesson_status,
3451: prf.lesson_status lesson_status,
3452: hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS', prf.lesson_status) lesson_status_name
3453: FROM ota_performances prf
3454: WHERE
3455: prf.user_id = p_user_id
3456: and prf.user_type = p_user_type

Line 3557: l_status_name := hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','M');

3553: if(l_trackingtype = 'S') then
3554: open csr_noof_perf_recs(l_learning_object_id);
3555: fetch csr_noof_perf_recs into l_perf_rec_count;
3556: if(l_perf_rec_count > 1) then
3557: l_status_name := hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','M');
3558: End if;
3559: End If;
3560: -- End if;
3561:

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

3564: End If;
3565:
3566: If ( l_status is null ) Then
3567: l_status := 'N';
3568: l_status_name := hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','N');
3569: End If;
3570:
3571: If ( (l_status = 'N') or (l_status = 'I') ) Then
3572: If ( l_course_end_date < l_sysdate --Class is expired --Bug 3554773 --Bug 5222464

Line 3603: l_status_name := hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','M');

3599: l_multiple := true;
3600: End if;
3601: End if;
3602: if l_multiple then
3603: l_status_name := hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','M');
3604: else
3605: l_status := 'D';
3606: l_status_name := get_cert_lo_status(p_user_id,p_user_type,p_event_id,p_booking_status_type_id,p_booking_id,l_cert_prd_enrollment_id,p_mode);
3607: end if;

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

4066: WHERE BST.booking_status_type_id = p_booking_status_type_id;
4067:
4068: CURSOR c_prd_lo_status(l_lo_id in ota_offerings.learning_object_id%TYPE) IS
4069: SELECT lesson_status,
4070: hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS',lesson_status)lesson_status_name
4071: FROM ota_performances
4072: WHERE user_id = p_user_id
4073: AND user_type = p_user_type
4074: AND learning_object_id = l_lo_id

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

4104: close c_prd_lo_status;
4105:
4106: If ( l_status is null ) Then
4107: l_status := 'N';
4108: l_status_name := hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','N');
4109: End If;
4110:
4111: If ( (l_status = 'N') or (l_status = 'I') ) Then
4112: If ( l_course_end_date < trunc(sysdate) --Class is expired --Bug 3554773

Line 4126: l_status_name:= hr_general_utilities.get_lookup_meaning('OTA_CERT_MBR_ENROLL_STATUS','PENDING');

4122: fetch csr_enr_sign_info into l_sign_eval_status;
4123: close csr_enr_sign_info;
4124:
4125: if(l_sign_eval_status in ('UE','VE','CE')) then
4126: l_status_name:= hr_general_utilities.get_lookup_meaning('OTA_CERT_MBR_ENROLL_STATUS','PENDING');
4127: end if;
4128:
4129: End If;
4130: -- end of changes for 12425778

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

4202:
4203: CURSOR c_get_cert_lo_tree_link(p_performance_id in number) is
4204: Select
4205: olo.name Name,
4206: nvl(hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS',opf.lesson_status),
4207: hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','N')) Status,
4208: nvl(opf.time,0) Time,
4209: opf.score Score,
4210: decode(opf.lesson_status

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

4203: CURSOR c_get_cert_lo_tree_link(p_performance_id in number) is
4204: Select
4205: olo.name Name,
4206: nvl(hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS',opf.lesson_status),
4207: hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','N')) Status,
4208: nvl(opf.time,0) Time,
4209: opf.score Score,
4210: decode(opf.lesson_status
4211: ,'C','player_status_c.gif'

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

4236:
4237: CURSOR c_get_cert_lo_tree_link_nn(p_performance_id in number) is
4238: Select
4239: olo.name Name,
4240: nvl(hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS',opf.lesson_status),
4241: hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','N')) Status,
4242: nvl(opf.time,0) Time,
4243: opf.score Score,
4244: decode(opf.lesson_status

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

4237: CURSOR c_get_cert_lo_tree_link_nn(p_performance_id in number) is
4238: Select
4239: olo.name Name,
4240: nvl(hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS',opf.lesson_status),
4241: hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','N')) Status,
4242: nvl(opf.time,0) Time,
4243: opf.score Score,
4244: decode(opf.lesson_status
4245: ,'C','player_status_c.gif'

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

4672:
4673: CURSOR c_prd_lo_status(l_lo_id in ota_offerings.learning_object_id%TYPE,
4674: csr_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type) IS
4675: SELECT lesson_status,
4676: hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS',lesson_status)lesson_status_name
4677: FROM ota_performances
4678: WHERE user_id = p_user_id
4679: AND user_type = p_user_type
4680: AND learning_object_id = l_lo_id

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

4741:
4742: if (l_online_evt_count > 1) then
4743: --Bug 4560354
4744: --return as Not Attempted
4745: --l_return_lo_status := hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','N');
4746: --return l_return_lo_status;
4747: open csr_get_act;
4748: fetch csr_get_act into rec_get_act;
4749: close csr_get_act;

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

4753: fetch csr_prf_ord into rec_prf_ord;
4754: close csr_prf_ord;
4755:
4756: if rec_prf_ord.lesson_status is not null then
4757: l_return_lo_status := hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS',rec_prf_ord.lesson_status);
4758: else
4759: l_return_lo_status := hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','N');
4760: end if;
4761: end if;

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

4755:
4756: if rec_prf_ord.lesson_status is not null then
4757: l_return_lo_status := hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS',rec_prf_ord.lesson_status);
4758: else
4759: l_return_lo_status := hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','N');
4760: end if;
4761: end if;
4762:
4763: return l_return_lo_status;

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

4774: close c_prd_lo_status;
4775:
4776: If ( l_status is null ) Then
4777: l_status := 'N';
4778: l_status_name := hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','N');
4779: End If;
4780:
4781: If ( (l_status = 'N') or (l_status = 'I') ) Then
4782: If ( rec.course_end_date < trunc(sysdate) --Class is expired --Bug 3554773

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

5284:
5285: if (l_online_evt_count > 1) then
5286: --return as Not Attempted
5287: --Bug 4560354
5288: --l_return_lo_status := hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','N');
5289: open csr_get_act;
5290: fetch csr_get_act into rec_get_act;
5291: close csr_get_act;
5292:

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

5295: fetch csr_prf_ord into rec_prf_ord;
5296: close csr_prf_ord;
5297:
5298: if rec_prf_ord.lesson_status is not null then
5299: l_return_lo_status := hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS',rec_prf_ord.lesson_status);
5300: else
5301: l_return_lo_status := hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','N');
5302: end if;
5303: end if;

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

5297:
5298: if rec_prf_ord.lesson_status is not null then
5299: l_return_lo_status := hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS',rec_prf_ord.lesson_status);
5300: else
5301: l_return_lo_status := hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','N');
5302: end if;
5303: end if;
5304:
5305: return l_return_lo_status;