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_CATEGORY_USAGES

Line 2470: p_synchronous_flag ota_category_usages.synchronous_flag%type,

2466: p_user_type ota_attempts.user_type%type,
2467: p_is_manager varchar2,
2468: p_event_id ota_events.event_id%type,
2469: p_event_type ota_events.event_type%type,
2470: p_synchronous_flag ota_category_usages.synchronous_flag%type,
2471: p_online_flag ota_category_usages.online_flag%type,
2472: p_course_start_date ota_events.course_start_date%type,
2473: p_course_end_date ota_events.course_end_date%type,
2474: p_enrollment_status_type ota_booking_status_types.type%TYPE DEFAULT NULL,

Line 2471: p_online_flag ota_category_usages.online_flag%type,

2467: p_is_manager varchar2,
2468: p_event_id ota_events.event_id%type,
2469: p_event_type ota_events.event_type%type,
2470: p_synchronous_flag ota_category_usages.synchronous_flag%type,
2471: p_online_flag ota_category_usages.online_flag%type,
2472: p_course_start_date ota_events.course_start_date%type,
2473: p_course_end_date ota_events.course_end_date%type,
2474: p_enrollment_status_type ota_booking_status_types.type%TYPE DEFAULT NULL,
2475: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null,

Line 3384: FROM ota_events oev, ota_offerings ofr, ota_category_usages ocu

3380: CURSOR c_delivery_mode IS
3381: SELECT ocu.online_flag, ofr.learning_object_id,
3382: to_date(to_char(nvl(oev.course_end_date, to_date('4712/12/31','YYYY/MM/DD')),'YYYY/MM/DD') || ' ' || nvl(oev.course_end_time, '23:59'), 'YYYY/MM/DD HH24:MI'),
3383: ota_timezone_util.convert_date(sysdate, to_char(sysdate,'HH24:MI'), ota_timezone_util.get_server_timezone_code, oev.timezone)
3384: FROM ota_events oev, ota_offerings ofr, ota_category_usages ocu
3385: WHERE oev.parent_offering_id = ofr.offering_id
3386: AND ofr.delivery_mode_id = ocu.category_usage_id
3387: AND oev.event_id = p_event_id;
3388:

Line 3473: l_online_flag ota_category_usages.online_flag%TYPE;

3469:
3470:
3471: l_proc VARCHAR2(72) := g_package|| 'get_enroll_lo_status';
3472:
3473: l_online_flag ota_category_usages.online_flag%TYPE;
3474: l_learning_object_id ota_offerings.learning_object_id%TYPE;
3475: l_course_end_date ota_events.course_end_date%TYPE;
3476: l_sysdate ota_events.course_end_date%TYPE;
3477:

Line 3821: l_sync_flag ota_category_usages.synchronous_flag%type;

3817: l_lo_completed_date DATE;
3818: l_lo_completed_time VARCHAR2(10);
3819: l_lo_completed_date_tz VARCHAR2(100);
3820: l_lo_lesson_status ota_performances.lesson_status%type;
3821: l_sync_flag ota_category_usages.synchronous_flag%type;
3822: l_online_flag ota_category_usages.online_flag%type;
3823: l_return_completion_date varchar(50) := '';
3824: l_decode_lesson_status VARCHAR2(1);
3825:

Line 3822: l_online_flag ota_category_usages.online_flag%type;

3818: l_lo_completed_time VARCHAR2(10);
3819: l_lo_completed_date_tz VARCHAR2(100);
3820: l_lo_lesson_status ota_performances.lesson_status%type;
3821: l_sync_flag ota_category_usages.synchronous_flag%type;
3822: l_online_flag ota_category_usages.online_flag%type;
3823: l_return_completion_date varchar(50) := '';
3824: l_decode_lesson_status VARCHAR2(1);
3825:
3826: CURSOR c_get_lo_completion_date is

Line 3842: From OTA_EVENTS oev, OTA_OFFERINGS ofr, OTA_PERFORMANCES opf, ota_category_usages ocu

3838: 'N', '6') decode_lesson_status,
3839: ocu.Synchronous_Flag Sync_Flag,
3840: ocu.Online_Flag Online_Flag,
3841: ota_timezone_util.get_date_time(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), 'Y', ota_timezone_util.get_server_timezone_code, 'HH24:MI:SS') Comp_Date_Tz
3842: From OTA_EVENTS oev, OTA_OFFERINGS ofr, OTA_PERFORMANCES opf, ota_category_usages ocu
3843: Where
3844: oev.parent_offering_id = ofr.offering_id
3845: And ofr.learning_object_id = opf.learning_object_id(+)
3846: And oev.event_id = p_event_id

Line 3862: From OTA_EVENTS oev, OTA_OFFERINGS ofr, OTA_PERFORMANCES opf, ota_category_usages ocu

3858: opf.lesson_status,
3859: ocu.Synchronous_Flag Sync_Flag,
3860: ocu.Online_Flag Online_Flag,
3861: ota_timezone_util.get_date_time(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), 'Y', ota_timezone_util.get_server_timezone_code, 'HH24:MI:SS') Comp_Date_Tz
3862: From OTA_EVENTS oev, OTA_OFFERINGS ofr, OTA_PERFORMANCES opf, ota_category_usages ocu
3863: Where
3864: oev.parent_offering_id = ofr.offering_id
3865: And ofr.learning_object_id = opf.learning_object_id(+)
3866: And oev.event_id = p_event_id

Line 3928: l_sync_flag ota_category_usages.synchronous_flag%type;

3924: l_lo_comp_date DATE;
3925: l_lo_completed_time VARCHAR2(10);
3926: l_lo_completed_date_tz VARCHAR2(100);
3927: l_lo_lesson_status ota_performances.lesson_status%type;
3928: l_sync_flag ota_category_usages.synchronous_flag%type;
3929: l_online_flag ota_category_usages.online_flag%type;
3930: l_return_completion_date date:= null;
3931: l_decode_lesson_status VARCHAR2(1);
3932:

Line 3929: l_online_flag ota_category_usages.online_flag%type;

3925: l_lo_completed_time VARCHAR2(10);
3926: l_lo_completed_date_tz VARCHAR2(100);
3927: l_lo_lesson_status ota_performances.lesson_status%type;
3928: l_sync_flag ota_category_usages.synchronous_flag%type;
3929: l_online_flag ota_category_usages.online_flag%type;
3930: l_return_completion_date date:= null;
3931: l_decode_lesson_status VARCHAR2(1);
3932:
3933: CURSOR c_get_lo_completion_date is

Line 3950: From OTA_EVENTS oev, OTA_OFFERINGS ofr, OTA_PERFORMANCES opf, ota_category_usages ocu

3946: ocu.Synchronous_Flag Sync_Flag,
3947: ocu.Online_Flag Online_Flag,
3948: ota_timezone_util.get_date_time(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), 'Y', ota_timezone_util.get_server_timezone_code, 'HH24:MI:SS') Comp_Date_Tz,
3949: ota_timezone_util.get_dateDT(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), ocu.Online_Flag, ota_timezone_util.get_server_timezone_code) Comp_Date
3950: From OTA_EVENTS oev, OTA_OFFERINGS ofr, OTA_PERFORMANCES opf, ota_category_usages ocu
3951: Where
3952: oev.parent_offering_id = ofr.offering_id
3953: And ofr.learning_object_id = opf.learning_object_id(+)
3954: And oev.event_id = p_event_id

Line 3971: From OTA_EVENTS oev, OTA_OFFERINGS ofr, OTA_PERFORMANCES opf, ota_category_usages ocu

3967: ocu.Synchronous_Flag Sync_Flag,
3968: ocu.Online_Flag Online_Flag,
3969: ota_timezone_util.get_date_time(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), 'Y', ota_timezone_util.get_server_timezone_code, 'HH24:MI:SS') Comp_Date_Tz,
3970: ota_timezone_util.get_dateDT(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), ocu.Online_Flag, ota_timezone_util.get_server_timezone_code) Comp_Date
3971: From OTA_EVENTS oev, OTA_OFFERINGS ofr, OTA_PERFORMANCES opf, ota_category_usages ocu
3972: Where
3973: oev.parent_offering_id = ofr.offering_id
3974: And ofr.learning_object_id = opf.learning_object_id(+)
3975: And oev.event_id = p_event_id

Line 4058: FROM ota_events oev, ota_offerings ofr, ota_category_usages ocu

4054:
4055:
4056: CURSOR c_delivery_mode IS
4057: SELECT ocu.online_flag, ofr.learning_object_id, nvl(oev.course_end_date, trunc(sysdate))
4058: FROM ota_events oev, ota_offerings ofr, ota_category_usages ocu
4059: WHERE oev.parent_offering_id = ofr.offering_id
4060: AND ofr.delivery_mode_id = ocu.category_usage_id
4061: AND oev.event_id = p_event_id;
4062:

Line 4084: l_online_flag ota_category_usages.online_flag%TYPE;

4080: WHERE odb.booking_id = p_booking_id;
4081:
4082: l_proc VARCHAR2(72) := g_package|| 'get_cert_lo_status';
4083:
4084: l_online_flag ota_category_usages.online_flag%TYPE;
4085: l_learning_object_id ota_offerings.learning_object_id%TYPE;
4086: l_course_end_date ota_events.course_end_date%TYPE;
4087:
4088: l_status VARCHAR2(30) := null;

Line 4429: ota_category_usages ocu

4425: FROM ota_events evt,
4426: ota_delegate_bookings tdb,
4427: ota_booking_status_types bst,
4428: ota_offerings ofr,
4429: ota_category_usages ocu
4430: WHERE evt.event_id = tdb.event_id
4431: AND bst.booking_status_type_id = tdb.booking_status_type_id
4432: /* AND (
4433: evt.course_start_date >= csr_cert_period_start_date

Line 4543: ota_category_usages ocu

4539: evt.course_start_date,
4540: evt.course_end_date
4541: FROM ota_events evt,
4542: ota_offerings ofr,
4543: ota_category_usages ocu
4544: WHERE evt.event_id = csr_event_id
4545: AND evt.parent_offering_id = ofr.offering_id
4546: AND OFR.DELIVERY_MODE_ID = ocu.CATEGORY_USAGE_ID;
4547:

Line 4662: ota_category_usages ocu

4658: evt.course_end_date,
4659: ofr.learning_object_id
4660: FROM ota_events evt,
4661: ota_offerings ofr,
4662: ota_category_usages ocu
4663: WHERE evt.event_id = csr_event_id
4664: AND evt.parent_offering_id = ofr.offering_id
4665: AND OFR.DELIVERY_MODE_ID = ocu.CATEGORY_USAGE_ID;
4666:

Line 4845: ota_category_usages ocu

4841: FROM ota_events evt,
4842: ota_delegate_bookings tdb,
4843: ota_booking_status_types bst,
4844: ota_offerings ofr,
4845: ota_category_usages ocu
4846: WHERE evt.event_id = tdb.event_id
4847: AND bst.booking_status_type_id = tdb.booking_status_type_id
4848: /* AND (
4849: evt.course_start_date >= csr_cert_period_start_date

Line 5041: ota_category_usages ocu

5037: FROM ota_events evt,
5038: ota_delegate_bookings tdb,
5039: ota_booking_status_types bst,
5040: ota_offerings ofr,
5041: ota_category_usages ocu
5042: WHERE evt.event_id = tdb.event_id
5043: AND bst.booking_status_type_id = tdb.booking_status_type_id
5044: AND evt.activity_version_id = csr_activity_version_id
5045: --AND tdb.delegate_person_id = p_person_id

Line 5122: ota_category_usages ocu

5118: evt.course_start_date,
5119: evt.course_end_date
5120: FROM ota_events evt,
5121: ota_offerings ofr,
5122: ota_category_usages ocu
5123: WHERE evt.event_id = csr_event_id
5124: AND evt.parent_offering_id = ofr.offering_id
5125: AND OFR.DELIVERY_MODE_ID = ocu.CATEGORY_USAGE_ID;
5126:

Line 5229: ota_category_usages ocu

5225: evt.course_end_date,
5226: ofr.learning_object_id
5227: FROM ota_events evt,
5228: ota_offerings ofr,
5229: ota_category_usages ocu
5230: WHERE evt.event_id = csr_event_id
5231: AND evt.parent_offering_id = ofr.offering_id
5232: AND OFR.DELIVERY_MODE_ID = ocu.CATEGORY_USAGE_ID;
5233:

Line 5361: ota_category_usages ocu

5357: FROM ota_events evt,
5358: ota_delegate_bookings tdb,
5359: ota_booking_status_types bst,
5360: ota_offerings ofr,
5361: ota_category_usages ocu
5362: WHERE evt.event_id = tdb.event_id
5363: AND bst.booking_status_type_id = tdb.booking_status_type_id
5364: AND evt.activity_version_id = csr_activity_version_id
5365: --AND tdb.delegate_person_id = p_person_id

Line 5676: l_online_flag ota_category_usages.online_flag%TYPE;

5672:
5673:
5674: l_proc VARCHAR2(72) := g_package|| 'get_num_of_online_records';
5675:
5676: l_online_flag ota_category_usages.online_flag%TYPE;
5677: l_learning_object_id ota_offerings.learning_object_id%TYPE;
5678: l_course_end_date ota_events.course_end_date%TYPE;
5679: l_sysdate ota_events.course_end_date%TYPE;
5680: