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_BOOKING_STATUS_TYPES

Line 309: v_booking_status_row ota_booking_status_types%rowtype;

305: p_signed varchar2) is
306:
307: v_result_object_version_number ota_finance_lines.object_version_number%type;
308: v_finance_line_id ota_finance_lines.finance_line_id%type;
309: v_booking_status_row ota_booking_status_types%rowtype;
310: v_object_version_number ota_delegate_bookings.object_version_number%type;
311: v_date_status_changed ota_delegate_bookings.date_status_changed%type:=p_date_status_changed;
312: l_successful_attendance_flag varchar2(1):='N';
313: l_failure_reason varchar2(20);

Line 523: ota_booking_status_types stype

519: book.date_booking_placed,
520: book.object_version_number
521: from ota_events ev,
522: ota_delegate_bookings book,
523: ota_booking_status_types stype
524: where nvl(ev.course_start_date, sysdate) <= sysdate and
525: book.event_id = ev.event_id and
526: book.delegate_person_id = p_person_id and
527: ev.event_id = p_event_id and

Line 543: ota_booking_status_types stype,

539: book.date_booking_placed,
540: book.object_version_number
541: from ota_events ev,
542: ota_delegate_bookings book,
543: ota_booking_status_types stype,
544: hz_cust_account_roles acct_role,
545: hz_relationships rel,
546: hz_cust_accounts role_acct
547: where nvl(ev.course_start_date, sysdate) <= sysdate and

Line 671: ota_booking_status_types stype,

667: from ota_events ev,
668: ota_offerings offr,
669: ota_learning_objects lo,
670: ota_delegate_bookings book,
671: ota_booking_status_types stype,
672: ota_activity_versions act
673: where lo.source_learning_object_id = p_lo_id and
674: lo.learning_object_id = offr.learning_object_id and
675: offr.offering_id = ev.parent_offering_id and

Line 707: ota_booking_status_types stype,

703: from ota_events ev,
704: ota_offerings offr,
705: ota_learning_objects lo,
706: ota_delegate_bookings book,
707: ota_booking_status_types stype,
708: hz_cust_account_roles acct_role,
709: hz_relationships rel,
710: hz_cust_accounts role_acct,
711: ota_activity_versions act

Line 1660: ota_booking_status_types stype

1656: p_event_id ota_events.event_id%type,
1657: p_person_id per_all_people.person_id%type) is
1658: select 1
1659: from ota_delegate_bookings book,
1660: ota_booking_status_types stype
1661: where book.delegate_person_id = p_person_id and
1662: book.event_id = p_event_id and
1663: book.booking_status_type_id = stype.booking_status_type_id and
1664: stype.type in ('P', 'A' ,'E');

Line 1671: ota_booking_status_types stype

1667: p_event_id ota_events.event_id%type,
1668: p_contact_id per_all_people.person_id%type) is
1669: select 1
1670: from ota_delegate_bookings book,
1671: ota_booking_status_types stype
1672: where book.delegate_contact_id = p_contact_id and
1673: book.event_id = p_event_id and
1674: book.booking_status_type_id = stype.booking_status_type_id and
1675: stype.type in ('P', 'A', 'E');

Line 2474: p_enrollment_status_type ota_booking_status_types.type%TYPE DEFAULT NULL,

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,
2476: p_contact_id ota_cert_enrollments.contact_id%type default null,
2477: p_chk_active_cert_flag varchar2 default 'N') return varchar2 is
2478:

Line 2761: l_booking_status_type OTA_BOOKING_STATUS_TYPES.TYPE%TYPE;

2757:
2758: l_is_mandatory boolean:= true;
2759: l_is_attempted boolean:= false;
2760: l_act_mandatory OTA_EVALUATIONS.EVAL_MANDATORY_FLAG%TYPE;
2761: l_booking_status_type OTA_BOOKING_STATUS_TYPES.TYPE%TYPE;
2762: l_attempt_id number;
2763: l_act_eval_id OTA_EVALUATIONS.evaluation_id%TYPE;
2764:
2765: CURSOR c_attempts_info is

Line 2810: from ota_booking_status_types

2806: * disable the evaluation, or mark as 'Done' .
2807: *===============================================*/
2808:
2809: select type into l_booking_status_type
2810: from ota_booking_status_types
2811: where booking_status_type_id in (p_booking_status_type_id);
2812:
2813: if l_is_mandatory then
2814: if l_booking_status_type = 'E' then

Line 3372: p_booking_status_type_id IN ota_booking_status_types.booking_status_type_id%TYPE,

3368: --
3369: FUNCTION get_enroll_lo_status(p_user_id IN NUMBER,
3370: p_user_type IN ota_attempts.user_type%type,
3371: p_event_id IN ota_events.event_id%TYPE,
3372: p_booking_status_type_id IN ota_booking_status_types.booking_status_type_id%TYPE,
3373: p_booking_id IN ota_delegate_bookings.booking_id%TYPE,
3374: p_mode IN number default null,
3375: p_chk_active_cert_flag varchar2 default 'N')
3376: RETURN VARCHAR2 IS

Line 3391: FROM ota_booking_status_types_vl BST

3387: AND oev.event_id = p_event_id;
3388:
3389: CURSOR c_booking_status IS
3390: SELECT BST.type, BST.name
3391: FROM ota_booking_status_types_vl BST
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,

Line 3479: l_status_name ota_booking_status_types_tl.name%TYPE := null;

3475: l_course_end_date ota_events.course_end_date%TYPE;
3476: l_sysdate ota_events.course_end_date%TYPE;
3477:
3478: l_status VARCHAR2(30) := null;
3479: l_status_name ota_booking_status_types_tl.name%TYPE := null;
3480:
3481: --Bug 4665032
3482: l_enrollment_status_code ota_booking_status_types.type%TYPE;
3483: l_enrollment_status_name ota_booking_status_types_tl.name%TYPE;

Line 3482: l_enrollment_status_code ota_booking_status_types.type%TYPE;

3478: l_status VARCHAR2(30) := null;
3479: l_status_name ota_booking_status_types_tl.name%TYPE := null;
3480:
3481: --Bug 4665032
3482: l_enrollment_status_code ota_booking_status_types.type%TYPE;
3483: l_enrollment_status_name ota_booking_status_types_tl.name%TYPE;
3484: l_decode_lesson_status VARCHAR2(1);
3485:
3486: -- Bug 3725560

Line 3483: l_enrollment_status_name ota_booking_status_types_tl.name%TYPE;

3479: l_status_name ota_booking_status_types_tl.name%TYPE := null;
3480:
3481: --Bug 4665032
3482: l_enrollment_status_code ota_booking_status_types.type%TYPE;
3483: l_enrollment_status_name ota_booking_status_types_tl.name%TYPE;
3484: l_decode_lesson_status VARCHAR2(1);
3485:
3486: -- Bug 3725560
3487: l_imported_offering ota_events.offering_id%TYPE := null;

Line 3689: l_booking_status_type ota_booking_status_types.type%TYPE;

3685: l_type varchar2(1);
3686: l_proc VARCHAR2(72) := g_package||'get_history_button';
3687:
3688: l_imported_offering ota_events.offering_id%TYPE;
3689: l_booking_status_type ota_booking_status_types.type%TYPE;
3690:
3691: CURSOR c_imported_offering IS
3692: SELECT offering_id
3693: FROM ota_events

Line 3706: ota_booking_status_types bst

3702:
3703: CURSOR c_booking_status_type IS
3704: SELECT type
3705: FROM ota_delegate_bookings odb,
3706: ota_booking_status_types bst
3707: WHERE booking_id = p_booking_id
3708: and odb.booking_status_type_id = bst.booking_status_type_id;
3709:
3710: CURSOR c_history_enabled_odb IS

Line 4049: p_booking_status_type_id IN ota_booking_status_types.booking_status_type_id%TYPE,

4045:
4046: FUNCTION get_cert_lo_status(p_user_id IN NUMBER,
4047: p_user_type IN ota_attempts.user_type%type,
4048: p_event_id IN ota_events.event_id%TYPE,
4049: p_booking_status_type_id IN ota_booking_status_types.booking_status_type_id%TYPE,
4050: p_booking_id IN ota_delegate_bookings.booking_id%TYPE,
4051: p_cert_prd_enrollment_id in ota_cert_prd_enrollments.cert_prd_enrollment_id%type,
4052: p_mode IN number default null)
4053: RETURN VARCHAR2 IS

Line 4065: FROM ota_booking_status_types_vl BST

4061: AND oev.event_id = p_event_id;
4062:
4063: CURSOR c_booking_status IS
4064: SELECT BST.type, BST.name
4065: FROM ota_booking_status_types_vl BST
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,

Line 4089: l_status_name ota_booking_status_types_tl.name%TYPE := null;

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;
4089: l_status_name ota_booking_status_types_tl.name%TYPE := null;
4090: l_sign_eval_status OTA_DELEGATE_BOOKINGS.sign_eval_status%type;
4091:
4092: BEGIN
4093: hr_utility.set_location(' Step:'|| l_proc, 10);

Line 4427: ota_booking_status_types bst,

4423: ocu.online_flag,
4424: bst.type
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

Line 4724: l_status_name ota_booking_status_types_tl.name%TYPE := null;

4720:
4721: l_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type;
4722:
4723: l_status VARCHAR2(30) := null;
4724: l_status_name ota_booking_status_types_tl.name%TYPE := null;
4725:
4726: l_return_lo_status VARCHAR2(30);
4727: l_online_evt_count number;
4728:

Line 4843: ota_booking_status_types bst,

4839: ocu.online_flag,
4840: bst.type
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

Line 5039: ota_booking_status_types bst,

5035: ocu.online_flag,
5036: bst.type
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

Line 5275: l_status_name ota_booking_status_types_tl.name%TYPE := null;

5271:
5272: l_online_event_id ota_events.event_id%type;
5273:
5274: l_status VARCHAR2(30) := null;
5275: l_status_name ota_booking_status_types_tl.name%TYPE := null;
5276:
5277: l_return_lo_status VARCHAR2(30);
5278: l_online_evt_count number;
5279: BEGIN

Line 5359: ota_booking_status_types bst,

5355: ocu.online_flag,
5356: bst.type
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