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 179: v_booking_status_row ota_booking_status_types%rowtype;

175: p_failed varchar2) is
176:
177: v_result_object_version_number ota_finance_lines.object_version_number%type;
178: v_finance_line_id ota_finance_lines.finance_line_id%type;
179: v_booking_status_row ota_booking_status_types%rowtype;
180: v_object_version_number ota_delegate_bookings.object_version_number%type;
181: l_successful_attendance_flag varchar2(1):='N';
182: l_failure_reason varchar2(20);
183: begin

Line 235: ota_booking_status_types stype

231: book.date_booking_placed,
232: book.object_version_number
233: from ota_events ev,
234: ota_delegate_bookings book,
235: ota_booking_status_types stype
236: where nvl(ev.course_start_date, sysdate) <= sysdate and
237: book.event_id = ev.event_id and
238: book.delegate_person_id = p_person_id and
239: ev.event_id = p_event_id and

Line 254: ota_booking_status_types stype,

250: book.date_booking_placed,
251: book.object_version_number
252: from ota_events ev,
253: ota_delegate_bookings book,
254: ota_booking_status_types stype,
255: hz_cust_account_roles acct_role,
256: hz_relationships rel,
257: hz_cust_accounts role_acct
258: where nvl(ev.course_start_date, sysdate) <= sysdate and

Line 375: ota_booking_status_types stype

371: from ota_events ev,
372: ota_offerings offr,
373: ota_learning_objects lo,
374: ota_delegate_bookings book,
375: ota_booking_status_types stype
376: where lo.source_learning_object_id = p_lo_id and
377: lo.learning_object_id = offr.learning_object_id and
378: offr.offering_id = ev.parent_offering_id and
379: nvl(ev.course_start_date, sysdate) <= sysdate and

Line 405: ota_booking_status_types stype,

401: from ota_events ev,
402: ota_offerings offr,
403: ota_learning_objects lo,
404: ota_delegate_bookings book,
405: ota_booking_status_types stype,
406: hz_cust_account_roles acct_role,
407: hz_relationships rel,
408: hz_cust_accounts role_acct
409: where lo.source_learning_object_id = p_lo_id and

Line 1354: ota_booking_status_types stype

1350: p_event_id ota_events.event_id%type,
1351: p_person_id per_all_people.person_id%type) is
1352: select 1
1353: from ota_delegate_bookings book,
1354: ota_booking_status_types stype
1355: where book.delegate_person_id = p_person_id and
1356: book.event_id = p_event_id and
1357: book.booking_status_type_id = stype.booking_status_type_id and
1358: stype.type in ('P', 'A' ,'E');

Line 1365: ota_booking_status_types stype

1361: p_event_id ota_events.event_id%type,
1362: p_contact_id per_all_people.person_id%type) is
1363: select 1
1364: from ota_delegate_bookings book,
1365: ota_booking_status_types stype
1366: where book.delegate_contact_id = p_contact_id and
1367: book.event_id = p_event_id and
1368: book.booking_status_type_id = stype.booking_status_type_id and
1369: stype.type in ('P', 'A');

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

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

Line 2351: l_booking_status_type OTA_BOOKING_STATUS_TYPES.TYPE%TYPE;

2347:
2348: l_is_mandatory boolean:= true;
2349: l_is_attempted boolean:= false;
2350: l_act_mandatory OTA_EVALUATIONS.EVAL_MANDATORY_FLAG%TYPE;
2351: l_booking_status_type OTA_BOOKING_STATUS_TYPES.TYPE%TYPE;
2352: l_attempt_id number;
2353: l_act_eval_id OTA_EVALUATIONS.evaluation_id%TYPE;
2354:
2355: CURSOR c_attempts_info is

Line 2400: from ota_booking_status_types

2396: * disable the evaluation, or mark as 'Done' .
2397: *===============================================*/
2398:
2399: select type into l_booking_status_type
2400: from ota_booking_status_types
2401: where booking_status_type_id in (p_booking_status_type_id);
2402:
2403: if l_is_mandatory then
2404: if l_booking_status_type = 'E' then

Line 2455: l_booking_status_type OTA_BOOKING_STATUS_TYPES.TYPE%TYPE;

2451:
2452: l_is_mandatory boolean:= true;
2453: l_is_attempted boolean:= false;
2454: l_act_mandatory OTA_EVALUATIONS.EVAL_MANDATORY_FLAG%TYPE;
2455: l_booking_status_type OTA_BOOKING_STATUS_TYPES.TYPE%TYPE;
2456: l_attempt_id number;
2457: l_act_eval_id OTA_EVALUATIONS.evaluation_id%TYPE;
2458:
2459: CURSOR c_attempts_info is

Line 2503: from ota_booking_status_types

2499: * disable the evaluation, or mark as 'Done' .
2500: *===============================================*/
2501:
2502: select type into l_booking_status_type
2503: from ota_booking_status_types
2504: where booking_status_type_id in (p_booking_status_type_id);
2505:
2506: if l_is_mandatory then
2507: if l_booking_status_type = 'E' then

Line 3007: p_booking_status_type_id IN ota_booking_status_types.booking_status_type_id%TYPE,

3003: --
3004: FUNCTION get_enroll_lo_status(p_user_id IN NUMBER,
3005: p_user_type IN ota_attempts.user_type%type,
3006: p_event_id IN ota_events.event_id%TYPE,
3007: p_booking_status_type_id IN ota_booking_status_types.booking_status_type_id%TYPE,
3008: p_booking_id IN ota_delegate_bookings.booking_id%TYPE,
3009: p_mode IN number default null,
3010: p_chk_active_cert_flag varchar2 default 'N')
3011: RETURN VARCHAR2 IS

Line 3026: FROM ota_booking_status_types_vl BST

3022: AND oev.event_id = p_event_id;
3023:
3024: CURSOR c_booking_status IS
3025: SELECT BST.type, BST.name
3026: FROM ota_booking_status_types_vl BST
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,

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

3076: l_course_end_date ota_events.course_end_date%TYPE;
3077: l_sysdate ota_events.course_end_date%TYPE;
3078:
3079: l_status VARCHAR2(30) := null;
3080: l_status_name ota_booking_status_types_tl.name%TYPE := null;
3081:
3082: --Bug 4665032
3083: l_enrollment_status_code ota_booking_status_types.type%TYPE;
3084: l_enrollment_status_name ota_booking_status_types_tl.name%TYPE;

Line 3083: l_enrollment_status_code ota_booking_status_types.type%TYPE;

3079: l_status VARCHAR2(30) := null;
3080: l_status_name ota_booking_status_types_tl.name%TYPE := null;
3081:
3082: --Bug 4665032
3083: l_enrollment_status_code ota_booking_status_types.type%TYPE;
3084: l_enrollment_status_name ota_booking_status_types_tl.name%TYPE;
3085: l_decode_lesson_status VARCHAR2(1);
3086:
3087: -- Bug 3725560

Line 3084: l_enrollment_status_name ota_booking_status_types_tl.name%TYPE;

3080: l_status_name ota_booking_status_types_tl.name%TYPE := null;
3081:
3082: --Bug 4665032
3083: l_enrollment_status_code ota_booking_status_types.type%TYPE;
3084: l_enrollment_status_name ota_booking_status_types_tl.name%TYPE;
3085: l_decode_lesson_status VARCHAR2(1);
3086:
3087: -- Bug 3725560
3088: l_imported_offering ota_events.offering_id%TYPE := null;

Line 3241: l_booking_status_type ota_booking_status_types.type%TYPE;

3237: l_type varchar2(1);
3238: l_proc VARCHAR2(72) := g_package||'get_history_button';
3239:
3240: l_imported_offering ota_events.offering_id%TYPE;
3241: l_booking_status_type ota_booking_status_types.type%TYPE;
3242:
3243: CURSOR c_imported_offering IS
3244: SELECT offering_id
3245: FROM ota_events

Line 3258: ota_booking_status_types bst

3254:
3255: CURSOR c_booking_status_type IS
3256: SELECT type
3257: FROM ota_delegate_bookings odb,
3258: ota_booking_status_types bst
3259: WHERE booking_id = p_booking_id
3260: and odb.booking_status_type_id = bst.booking_status_type_id;
3261:
3262: CURSOR c_history_enabled_odb IS

Line 3553: p_booking_status_type_id IN ota_booking_status_types.booking_status_type_id%TYPE,

3549:
3550: FUNCTION get_cert_lo_status(p_user_id IN NUMBER,
3551: p_user_type IN ota_attempts.user_type%type,
3552: p_event_id IN ota_events.event_id%TYPE,
3553: p_booking_status_type_id IN ota_booking_status_types.booking_status_type_id%TYPE,
3554: p_booking_id IN ota_delegate_bookings.booking_id%TYPE,
3555: p_cert_prd_enrollment_id in ota_cert_prd_enrollments.cert_prd_enrollment_id%type,
3556: p_mode IN number default null)
3557: RETURN VARCHAR2 IS

Line 3569: FROM ota_booking_status_types_vl BST

3565: AND oev.event_id = p_event_id;
3566:
3567: CURSOR c_booking_status IS
3568: SELECT BST.type, BST.name
3569: FROM ota_booking_status_types_vl BST
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,

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

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;
3588: l_status_name ota_booking_status_types_tl.name%TYPE := null;
3589:
3590: BEGIN
3591: hr_utility.set_location(' Step:'|| l_proc, 10);
3592: open c_delivery_mode;

Line 3851: ota_booking_status_types bst,

3847: ocu.online_flag,
3848: bst.type
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

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

4144:
4145: l_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type;
4146:
4147: l_status VARCHAR2(30) := null;
4148: l_status_name ota_booking_status_types_tl.name%TYPE := null;
4149:
4150: l_return_lo_status VARCHAR2(30);
4151: l_online_evt_count number;
4152:

Line 4267: ota_booking_status_types bst,

4263: ocu.online_flag,
4264: bst.type
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

Line 4463: ota_booking_status_types bst,

4459: ocu.online_flag,
4460: bst.type
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

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

4695:
4696: l_online_event_id ota_events.event_id%type;
4697:
4698: l_status VARCHAR2(30) := null;
4699: l_status_name ota_booking_status_types_tl.name%TYPE := null;
4700:
4701: l_return_lo_status VARCHAR2(30);
4702: l_online_evt_count number;
4703: BEGIN

Line 4783: ota_booking_status_types bst,

4779: ocu.online_flag,
4780: bst.type
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