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 2085: p_synchronous_flag ota_category_usages.synchronous_flag%type,

2081: p_user_type ota_attempts.user_type%type,
2082: p_is_manager varchar2,
2083: p_event_id ota_events.event_id%type,
2084: p_event_type ota_events.event_type%type,
2085: p_synchronous_flag ota_category_usages.synchronous_flag%type,
2086: p_online_flag ota_category_usages.online_flag%type,
2087: p_course_start_date ota_events.course_start_date%type,
2088: p_course_end_date ota_events.course_end_date%type,
2089: p_enrollment_status_type ota_booking_status_types.type%TYPE DEFAULT NULL,

Line 2086: p_online_flag ota_category_usages.online_flag%type,

2082: p_is_manager varchar2,
2083: p_event_id ota_events.event_id%type,
2084: p_event_type ota_events.event_type%type,
2085: p_synchronous_flag ota_category_usages.synchronous_flag%type,
2086: p_online_flag ota_category_usages.online_flag%type,
2087: p_course_start_date ota_events.course_start_date%type,
2088: p_course_end_date ota_events.course_end_date%type,
2089: p_enrollment_status_type ota_booking_status_types.type%TYPE DEFAULT NULL,
2090: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null,

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

3015: CURSOR c_delivery_mode IS
3016: SELECT ocu.online_flag, ofr.learning_object_id,
3017: 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'),
3018: ota_timezone_util.convert_date(sysdate, to_char(sysdate,'HH24:MI'), ota_timezone_util.get_server_timezone_code, oev.timezone)
3019: FROM ota_events oev, ota_offerings ofr, ota_category_usages ocu
3020: WHERE oev.parent_offering_id = ofr.offering_id
3021: AND ofr.delivery_mode_id = ocu.category_usage_id
3022: AND oev.event_id = p_event_id;
3023:

Line 3074: l_online_flag ota_category_usages.online_flag%TYPE;

3070:
3071:
3072: l_proc VARCHAR2(72) := g_package|| 'get_enroll_lo_status';
3073:
3074: l_online_flag ota_category_usages.online_flag%TYPE;
3075: l_learning_object_id ota_offerings.learning_object_id%TYPE;
3076: l_course_end_date ota_events.course_end_date%TYPE;
3077: l_sysdate ota_events.course_end_date%TYPE;
3078:

Line 3373: l_sync_flag ota_category_usages.synchronous_flag%type;

3369: l_lo_completed_date DATE;
3370: l_lo_completed_time VARCHAR2(10);
3371: l_lo_completed_date_tz VARCHAR2(100);
3372: l_lo_lesson_status ota_performances.lesson_status%type;
3373: l_sync_flag ota_category_usages.synchronous_flag%type;
3374: l_online_flag ota_category_usages.online_flag%type;
3375: l_return_completion_date varchar(50) := '';
3376:
3377: CURSOR c_get_lo_completion_date is

Line 3374: l_online_flag ota_category_usages.online_flag%type;

3370: l_lo_completed_time VARCHAR2(10);
3371: l_lo_completed_date_tz VARCHAR2(100);
3372: l_lo_lesson_status ota_performances.lesson_status%type;
3373: l_sync_flag ota_category_usages.synchronous_flag%type;
3374: l_online_flag ota_category_usages.online_flag%type;
3375: l_return_completion_date varchar(50) := '';
3376:
3377: CURSOR c_get_lo_completion_date is
3378: Select

Line 3386: -- (Select Synchronous_Flag from ota_category_usages where Category_Usage_Id = ofr.Delivery_Mode_Id) Sync_Flag,

3382: opf.completed_date,
3383: to_char(opf.completed_date, 'HH24:MI:SS'),
3384: opf.lesson_status,
3385: -- Bug#4582683
3386: -- (Select Synchronous_Flag from ota_category_usages where Category_Usage_Id = ofr.Delivery_Mode_Id) Sync_Flag,
3387: -- (Select Online_Flag from ota_category_usages where Category_Usage_Id = ofr.Delivery_Mode_Id) Online_Flag
3388: ocu.Synchronous_Flag Sync_Flag,
3389: ocu.Online_Flag Online_Flag,
3390: 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

Line 3387: -- (Select Online_Flag from ota_category_usages where Category_Usage_Id = ofr.Delivery_Mode_Id) Online_Flag

3383: to_char(opf.completed_date, 'HH24:MI:SS'),
3384: opf.lesson_status,
3385: -- Bug#4582683
3386: -- (Select Synchronous_Flag from ota_category_usages where Category_Usage_Id = ofr.Delivery_Mode_Id) Sync_Flag,
3387: -- (Select Online_Flag from ota_category_usages where Category_Usage_Id = ofr.Delivery_Mode_Id) Online_Flag
3388: ocu.Synchronous_Flag Sync_Flag,
3389: ocu.Online_Flag Online_Flag,
3390: 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
3391: From OTA_EVENTS oev, OTA_OFFERINGS ofr, OTA_PERFORMANCES opf, ota_category_usages ocu

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

3387: -- (Select Online_Flag from ota_category_usages where Category_Usage_Id = ofr.Delivery_Mode_Id) Online_Flag
3388: ocu.Synchronous_Flag Sync_Flag,
3389: ocu.Online_Flag Online_Flag,
3390: 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
3391: From OTA_EVENTS oev, OTA_OFFERINGS ofr, OTA_PERFORMANCES opf, ota_category_usages ocu
3392: Where
3393: oev.parent_offering_id = ofr.offering_id
3394: And ofr.learning_object_id = opf.learning_object_id(+)
3395: And oev.event_id = p_event_id

Line 3465: l_sync_flag ota_category_usages.synchronous_flag%type;

3461: l_lo_comp_date DATE;
3462: l_lo_completed_time VARCHAR2(10);
3463: l_lo_completed_date_tz VARCHAR2(100);
3464: l_lo_lesson_status ota_performances.lesson_status%type;
3465: l_sync_flag ota_category_usages.synchronous_flag%type;
3466: l_online_flag ota_category_usages.online_flag%type;
3467: l_return_completion_date date:= null;
3468:
3469: CURSOR c_get_lo_completion_date is

Line 3466: l_online_flag ota_category_usages.online_flag%type;

3462: l_lo_completed_time VARCHAR2(10);
3463: l_lo_completed_date_tz VARCHAR2(100);
3464: l_lo_lesson_status ota_performances.lesson_status%type;
3465: l_sync_flag ota_category_usages.synchronous_flag%type;
3466: l_online_flag ota_category_usages.online_flag%type;
3467: l_return_completion_date date:= null;
3468:
3469: CURSOR c_get_lo_completion_date is
3470: Select

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

3476: ocu.Synchronous_Flag Sync_Flag,
3477: ocu.Online_Flag Online_Flag,
3478: 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,
3479: 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
3480: From OTA_EVENTS oev, OTA_OFFERINGS ofr, OTA_PERFORMANCES opf, ota_category_usages ocu
3481: Where
3482: oev.parent_offering_id = ofr.offering_id
3483: And ofr.learning_object_id = opf.learning_object_id(+)
3484: And oev.event_id = p_event_id

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

3558:
3559:
3560: CURSOR c_delivery_mode IS
3561: SELECT ocu.online_flag, ofr.learning_object_id, nvl(oev.course_end_date, trunc(sysdate))
3562: FROM ota_events oev, ota_offerings ofr, ota_category_usages ocu
3563: WHERE oev.parent_offering_id = ofr.offering_id
3564: AND ofr.delivery_mode_id = ocu.category_usage_id
3565: AND oev.event_id = p_event_id;
3566:

Line 3583: l_online_flag ota_category_usages.online_flag%TYPE;

3579: AND cert_prd_enrollment_id = p_cert_prd_enrollment_id;
3580:
3581: l_proc VARCHAR2(72) := g_package|| 'get_cert_lo_status';
3582:
3583: l_online_flag ota_category_usages.online_flag%TYPE;
3584: l_learning_object_id ota_offerings.learning_object_id%TYPE;
3585: l_course_end_date ota_events.course_end_date%TYPE;
3586:
3587: l_status VARCHAR2(30) := null;

Line 3853: ota_category_usages ocu

3849: FROM ota_events evt,
3850: ota_delegate_bookings tdb,
3851: ota_booking_status_types bst,
3852: ota_offerings ofr,
3853: ota_category_usages ocu
3854: WHERE evt.event_id = tdb.event_id
3855: AND bst.booking_status_type_id = tdb.booking_status_type_id
3856: /* AND (
3857: evt.course_start_date >= csr_cert_period_start_date

Line 3967: ota_category_usages ocu

3963: evt.course_start_date,
3964: evt.course_end_date
3965: FROM ota_events evt,
3966: ota_offerings ofr,
3967: ota_category_usages ocu
3968: WHERE evt.event_id = csr_event_id
3969: AND evt.parent_offering_id = ofr.offering_id
3970: AND OFR.DELIVERY_MODE_ID = ocu.CATEGORY_USAGE_ID;
3971:

Line 4086: ota_category_usages ocu

4082: evt.course_end_date,
4083: ofr.learning_object_id
4084: FROM ota_events evt,
4085: ota_offerings ofr,
4086: ota_category_usages ocu
4087: WHERE evt.event_id = csr_event_id
4088: AND evt.parent_offering_id = ofr.offering_id
4089: AND OFR.DELIVERY_MODE_ID = ocu.CATEGORY_USAGE_ID;
4090:

Line 4269: ota_category_usages ocu

4265: FROM ota_events evt,
4266: ota_delegate_bookings tdb,
4267: ota_booking_status_types bst,
4268: ota_offerings ofr,
4269: ota_category_usages ocu
4270: WHERE evt.event_id = tdb.event_id
4271: AND bst.booking_status_type_id = tdb.booking_status_type_id
4272: /* AND (
4273: evt.course_start_date >= csr_cert_period_start_date

Line 4465: ota_category_usages ocu

4461: FROM ota_events evt,
4462: ota_delegate_bookings tdb,
4463: ota_booking_status_types bst,
4464: ota_offerings ofr,
4465: ota_category_usages ocu
4466: WHERE evt.event_id = tdb.event_id
4467: AND bst.booking_status_type_id = tdb.booking_status_type_id
4468: AND evt.activity_version_id = csr_activity_version_id
4469: --AND tdb.delegate_person_id = p_person_id

Line 4546: ota_category_usages ocu

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

Line 4653: ota_category_usages ocu

4649: evt.course_end_date,
4650: ofr.learning_object_id
4651: FROM ota_events evt,
4652: ota_offerings ofr,
4653: ota_category_usages ocu
4654: WHERE evt.event_id = csr_event_id
4655: AND evt.parent_offering_id = ofr.offering_id
4656: AND OFR.DELIVERY_MODE_ID = ocu.CATEGORY_USAGE_ID;
4657:

Line 4785: ota_category_usages ocu

4781: FROM ota_events evt,
4782: ota_delegate_bookings tdb,
4783: ota_booking_status_types bst,
4784: ota_offerings ofr,
4785: ota_category_usages ocu
4786: WHERE evt.event_id = tdb.event_id
4787: AND bst.booking_status_type_id = tdb.booking_status_type_id
4788: AND evt.activity_version_id = csr_activity_version_id
4789: --AND tdb.delegate_person_id = p_person_id