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_DELEGATE_BOOKINGS

Line 296: p_booking_id ota_delegate_bookings.booking_id%type,

292: end update_cme_status_for_lo;
293:
294:
295: procedure update_enrollment(
296: p_booking_id ota_delegate_bookings.booking_id%type,
297: p_event_id ota_events.event_id%type,
298: p_business_group_id ota_delegate_bookings.business_group_id%type,
299: p_date_booking_placed ota_delegate_bookings.date_booking_placed%type,
300: p_object_version_number ota_delegate_bookings.object_version_number%type,

Line 298: p_business_group_id ota_delegate_bookings.business_group_id%type,

294:
295: procedure update_enrollment(
296: p_booking_id ota_delegate_bookings.booking_id%type,
297: p_event_id ota_events.event_id%type,
298: p_business_group_id ota_delegate_bookings.business_group_id%type,
299: p_date_booking_placed ota_delegate_bookings.date_booking_placed%type,
300: p_object_version_number ota_delegate_bookings.object_version_number%type,
301: p_sign_eval_status ota_delegate_bookings.sign_eval_status%type,
302: p_date_status_changed ota_delegate_bookings.date_status_changed%type,

Line 299: p_date_booking_placed ota_delegate_bookings.date_booking_placed%type,

295: procedure update_enrollment(
296: p_booking_id ota_delegate_bookings.booking_id%type,
297: p_event_id ota_events.event_id%type,
298: p_business_group_id ota_delegate_bookings.business_group_id%type,
299: p_date_booking_placed ota_delegate_bookings.date_booking_placed%type,
300: p_object_version_number ota_delegate_bookings.object_version_number%type,
301: p_sign_eval_status ota_delegate_bookings.sign_eval_status%type,
302: p_date_status_changed ota_delegate_bookings.date_status_changed%type,
303: p_new_status varchar2,

Line 300: p_object_version_number ota_delegate_bookings.object_version_number%type,

296: p_booking_id ota_delegate_bookings.booking_id%type,
297: p_event_id ota_events.event_id%type,
298: p_business_group_id ota_delegate_bookings.business_group_id%type,
299: p_date_booking_placed ota_delegate_bookings.date_booking_placed%type,
300: p_object_version_number ota_delegate_bookings.object_version_number%type,
301: p_sign_eval_status ota_delegate_bookings.sign_eval_status%type,
302: p_date_status_changed ota_delegate_bookings.date_status_changed%type,
303: p_new_status varchar2,
304: p_failed varchar2,

Line 301: p_sign_eval_status ota_delegate_bookings.sign_eval_status%type,

297: p_event_id ota_events.event_id%type,
298: p_business_group_id ota_delegate_bookings.business_group_id%type,
299: p_date_booking_placed ota_delegate_bookings.date_booking_placed%type,
300: p_object_version_number ota_delegate_bookings.object_version_number%type,
301: p_sign_eval_status ota_delegate_bookings.sign_eval_status%type,
302: p_date_status_changed ota_delegate_bookings.date_status_changed%type,
303: p_new_status varchar2,
304: p_failed varchar2,
305: p_signed varchar2) is

Line 302: p_date_status_changed ota_delegate_bookings.date_status_changed%type,

298: p_business_group_id ota_delegate_bookings.business_group_id%type,
299: p_date_booking_placed ota_delegate_bookings.date_booking_placed%type,
300: p_object_version_number ota_delegate_bookings.object_version_number%type,
301: p_sign_eval_status ota_delegate_bookings.sign_eval_status%type,
302: p_date_status_changed ota_delegate_bookings.date_status_changed%type,
303: p_new_status varchar2,
304: p_failed varchar2,
305: p_signed varchar2) is
306:

Line 310: v_object_version_number ota_delegate_bookings.object_version_number%type;

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);
314: l_new_sign_eval_status ota_delegate_bookings.sign_eval_status%type;

Line 311: v_date_status_changed ota_delegate_bookings.date_status_changed%type:=p_date_status_changed;

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);
314: l_new_sign_eval_status ota_delegate_bookings.sign_eval_status%type;
315: l_status varchar2(20):=p_new_status;

Line 314: l_new_sign_eval_status ota_delegate_bookings.sign_eval_status%type;

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);
314: l_new_sign_eval_status ota_delegate_bookings.sign_eval_status%type;
315: l_status varchar2(20):=p_new_status;
316: L_PROC varchar2 (72):= G_PACKAGE || 'UPDATE_ENROLLMENT';
317:
318:

Line 323: from ota_delegate_bookings odb, ota_events evt, ota_offerings offer

319: --Added cursor to check whether update is needed for the enrollment in case of online classes
320: --after learner has signed the course.
321: cursor csr_book_details is
322: select odb.delegate_person_id, odb.delegate_contact_id, offer.learning_object_id
323: from ota_delegate_bookings odb, ota_events evt, ota_offerings offer
324: where odb.event_id = evt.event_id
325: and evt.parent_offering_id = offer.offering_id
326: and booking_id = p_booking_id;
327:

Line 330: from ota_delegate_bookings

326: and booking_id = p_booking_id;
327:
328: cursor csr_succ_att_fail_details is
329: select successful_attendance_flag, failure_reason
330: from ota_delegate_bookings
331: where booking_id = p_booking_id;
332:
333: l_person_id ota_delegate_bookings.delegate_person_id%type;
334: l_contact_id ota_delegate_bookings.delegate_contact_id%type;

Line 333: l_person_id ota_delegate_bookings.delegate_person_id%type;

329: select successful_attendance_flag, failure_reason
330: from ota_delegate_bookings
331: where booking_id = p_booking_id;
332:
333: l_person_id ota_delegate_bookings.delegate_person_id%type;
334: l_contact_id ota_delegate_bookings.delegate_contact_id%type;
335: l_lo_id ota_offerings.learning_object_id%type;
336: l_cert_prd_enr_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type;
337: l_member_in varchar2(10);

Line 334: l_contact_id ota_delegate_bookings.delegate_contact_id%type;

330: from ota_delegate_bookings
331: where booking_id = p_booking_id;
332:
333: l_person_id ota_delegate_bookings.delegate_person_id%type;
334: l_contact_id ota_delegate_bookings.delegate_contact_id%type;
335: l_lo_id ota_offerings.learning_object_id%type;
336: l_cert_prd_enr_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type;
337: l_member_in varchar2(10);
338: l_booking_successful_att_flag ota_delegate_bookings.successful_attendance_flag%TYPE;

Line 338: l_booking_successful_att_flag ota_delegate_bookings.successful_attendance_flag%TYPE;

334: l_contact_id ota_delegate_bookings.delegate_contact_id%type;
335: l_lo_id ota_offerings.learning_object_id%type;
336: l_cert_prd_enr_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type;
337: l_member_in varchar2(10);
338: l_booking_successful_att_flag ota_delegate_bookings.successful_attendance_flag%TYPE;
339: l_booking_failure_reason ota_delegate_bookings.failure_reason%Type;
340: begin
341: HR_UTILITY.SET_LOCATION ('Entering:' || L_PROC, 5);
342: --HR_UTILITY.TRACE ('SIGN_EVAL_STATUS: ' || p_sign_eval_status);

Line 339: l_booking_failure_reason ota_delegate_bookings.failure_reason%Type;

335: l_lo_id ota_offerings.learning_object_id%type;
336: l_cert_prd_enr_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type;
337: l_member_in varchar2(10);
338: l_booking_successful_att_flag ota_delegate_bookings.successful_attendance_flag%TYPE;
339: l_booking_failure_reason ota_delegate_bookings.failure_reason%Type;
340: begin
341: HR_UTILITY.SET_LOCATION ('Entering:' || L_PROC, 5);
342: --HR_UTILITY.TRACE ('SIGN_EVAL_STATUS: ' || p_sign_eval_status);
343: --HR_UTILITY.TRACE ('ENR STATUS: ' || p_new_status);

Line 471: p_booking_id ota_delegate_bookings.booking_id%type,

467: end update_enrollment;
468:
469:
470: procedure update_enrollment(
471: p_booking_id ota_delegate_bookings.booking_id%type,
472: p_event_id ota_events.event_id%type,
473: p_business_group_id ota_delegate_bookings.business_group_id%type,
474: p_date_booking_placed ota_delegate_bookings.date_booking_placed%type,
475: p_object_version_number ota_delegate_bookings.object_version_number%type,

Line 473: p_business_group_id ota_delegate_bookings.business_group_id%type,

469:
470: procedure update_enrollment(
471: p_booking_id ota_delegate_bookings.booking_id%type,
472: p_event_id ota_events.event_id%type,
473: p_business_group_id ota_delegate_bookings.business_group_id%type,
474: p_date_booking_placed ota_delegate_bookings.date_booking_placed%type,
475: p_object_version_number ota_delegate_bookings.object_version_number%type,
476: p_sign_eval_status ota_delegate_bookings.sign_eval_status%type,
477: p_date_status_changed ota_delegate_bookings.date_status_changed%type,

Line 474: p_date_booking_placed ota_delegate_bookings.date_booking_placed%type,

470: procedure update_enrollment(
471: p_booking_id ota_delegate_bookings.booking_id%type,
472: p_event_id ota_events.event_id%type,
473: p_business_group_id ota_delegate_bookings.business_group_id%type,
474: p_date_booking_placed ota_delegate_bookings.date_booking_placed%type,
475: p_object_version_number ota_delegate_bookings.object_version_number%type,
476: p_sign_eval_status ota_delegate_bookings.sign_eval_status%type,
477: p_date_status_changed ota_delegate_bookings.date_status_changed%type,
478: p_new_status varchar2,

Line 475: p_object_version_number ota_delegate_bookings.object_version_number%type,

471: p_booking_id ota_delegate_bookings.booking_id%type,
472: p_event_id ota_events.event_id%type,
473: p_business_group_id ota_delegate_bookings.business_group_id%type,
474: p_date_booking_placed ota_delegate_bookings.date_booking_placed%type,
475: p_object_version_number ota_delegate_bookings.object_version_number%type,
476: p_sign_eval_status ota_delegate_bookings.sign_eval_status%type,
477: p_date_status_changed ota_delegate_bookings.date_status_changed%type,
478: p_new_status varchar2,
479: p_failed varchar2) is

Line 476: p_sign_eval_status ota_delegate_bookings.sign_eval_status%type,

472: p_event_id ota_events.event_id%type,
473: p_business_group_id ota_delegate_bookings.business_group_id%type,
474: p_date_booking_placed ota_delegate_bookings.date_booking_placed%type,
475: p_object_version_number ota_delegate_bookings.object_version_number%type,
476: p_sign_eval_status ota_delegate_bookings.sign_eval_status%type,
477: p_date_status_changed ota_delegate_bookings.date_status_changed%type,
478: p_new_status varchar2,
479: p_failed varchar2) is
480:

Line 477: p_date_status_changed ota_delegate_bookings.date_status_changed%type,

473: p_business_group_id ota_delegate_bookings.business_group_id%type,
474: p_date_booking_placed ota_delegate_bookings.date_booking_placed%type,
475: p_object_version_number ota_delegate_bookings.object_version_number%type,
476: p_sign_eval_status ota_delegate_bookings.sign_eval_status%type,
477: p_date_status_changed ota_delegate_bookings.date_status_changed%type,
478: p_new_status varchar2,
479: p_failed varchar2) is
480:
481: begin

Line 486: p_booking_id ota_delegate_bookings.booking_id%type,

482: update_enrollment(p_booking_id,p_event_id,p_business_group_id,p_date_booking_placed,p_object_version_number,p_sign_eval_status,p_date_status_changed,p_new_status,p_failed,null);
483: end update_enrollment;
484:
485: procedure update_enrollment(
486: p_booking_id ota_delegate_bookings.booking_id%type,
487: p_event_id ota_events.event_id%type,
488: p_business_group_id ota_delegate_bookings.business_group_id%type,
489: p_date_booking_placed ota_delegate_bookings.date_booking_placed%type,
490: p_object_version_number ota_delegate_bookings.object_version_number%type,

Line 488: p_business_group_id ota_delegate_bookings.business_group_id%type,

484:
485: procedure update_enrollment(
486: p_booking_id ota_delegate_bookings.booking_id%type,
487: p_event_id ota_events.event_id%type,
488: p_business_group_id ota_delegate_bookings.business_group_id%type,
489: p_date_booking_placed ota_delegate_bookings.date_booking_placed%type,
490: p_object_version_number ota_delegate_bookings.object_version_number%type,
491: p_date_status_changed ota_delegate_bookings.date_status_changed%type,
492: p_new_status varchar2) is

Line 489: p_date_booking_placed ota_delegate_bookings.date_booking_placed%type,

485: procedure update_enrollment(
486: p_booking_id ota_delegate_bookings.booking_id%type,
487: p_event_id ota_events.event_id%type,
488: p_business_group_id ota_delegate_bookings.business_group_id%type,
489: p_date_booking_placed ota_delegate_bookings.date_booking_placed%type,
490: p_object_version_number ota_delegate_bookings.object_version_number%type,
491: p_date_status_changed ota_delegate_bookings.date_status_changed%type,
492: p_new_status varchar2) is
493:

Line 490: p_object_version_number ota_delegate_bookings.object_version_number%type,

486: p_booking_id ota_delegate_bookings.booking_id%type,
487: p_event_id ota_events.event_id%type,
488: p_business_group_id ota_delegate_bookings.business_group_id%type,
489: p_date_booking_placed ota_delegate_bookings.date_booking_placed%type,
490: p_object_version_number ota_delegate_bookings.object_version_number%type,
491: p_date_status_changed ota_delegate_bookings.date_status_changed%type,
492: p_new_status varchar2) is
493:
494:

Line 491: p_date_status_changed ota_delegate_bookings.date_status_changed%type,

487: p_event_id ota_events.event_id%type,
488: p_business_group_id ota_delegate_bookings.business_group_id%type,
489: p_date_booking_placed ota_delegate_bookings.date_booking_placed%type,
490: p_object_version_number ota_delegate_bookings.object_version_number%type,
491: p_date_status_changed ota_delegate_bookings.date_status_changed%type,
492: p_new_status varchar2) is
493:
494:
495: begin

Line 514: p_person_id ota_delegate_bookings.delegate_person_id%type) is

510:
511:
512: cursor person_bookings(
513: p_event_id ota_events.event_id%type,
514: p_person_id ota_delegate_bookings.delegate_person_id%type) is
515: select book.booking_id,
516: book.sign_eval_status,
517: ev.event_id,
518: book.business_group_id,

Line 522: ota_delegate_bookings book,

518: book.business_group_id,
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

Line 534: p_party_id ota_delegate_bookings.delegate_contact_id%type) is

530:
531: --Added for 6826434.
532: cursor party_bookings(
533: p_event_id ota_events.event_id%type,
534: p_party_id ota_delegate_bookings.delegate_contact_id%type) is
535: select book.booking_id,
536: book.sign_eval_status,
537: ev.event_id,
538: book.business_group_id,

Line 542: ota_delegate_bookings book,

538: book.business_group_id,
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

Line 656: p_person_id ota_delegate_bookings.delegate_person_id%type) is

652: -- use source_learning_object_id here in case reuse by reference is ever
653: -- implemented.
654: cursor person_bookings(
655: p_lo_id ota_learning_objects.learning_object_id%type,
656: p_person_id ota_delegate_bookings.delegate_person_id%type) is
657: select book.booking_id,
658: book.sign_eval_status,
659: ev.event_id,
660: book.business_group_id,

Line 670: ota_delegate_bookings book,

666: book.successful_attendance_flag
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

Line 692: p_party_id ota_delegate_bookings.delegate_contact_id%type) is

688: -- which the party is enrolled. Note that we use source_learning_object_id
689: -- here in case reuse by reference is ever implemented.
690: cursor party_bookings(
691: p_lo_id ota_learning_objects.learning_object_id%type,
692: p_party_id ota_delegate_bookings.delegate_contact_id%type) is
693: select book.booking_id,
694: book.sign_eval_status,
695: ev.event_id,
696: book.business_group_id,

Line 706: ota_delegate_bookings book,

702: book.successful_attendance_flag
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,

Line 1659: from ota_delegate_bookings book,

1655: cursor person_bookings(
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

Line 1670: from ota_delegate_bookings book,

1666: cursor contact_bookings(
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

Line 2714: p_sign_eval_status OTA_DELEGATE_BOOKINGS.SIGN_EVAL_STATUS%TYPE

2710: end get_play_button_for_test;
2711:
2712: --bug8785933.Added for getting the sign/play button
2713: function get_sign_eval_button(
2714: p_sign_eval_status OTA_DELEGATE_BOOKINGS.SIGN_EVAL_STATUS%TYPE
2715: ) return varchar2 is
2716:
2717:
2718: l_symbol varchar2(100):=null;

Line 2752: p_booking_status_type_id OTA_DELEGATE_BOOKINGS.BOOKING_STATUS_TYPE_ID%TYPE,

2748:
2749: function get_play_eval_button(
2750: p_event_id OTA_EVENTS.EVENT_ID%TYPE,
2751: p_user_id fnd_user.user_id%type,
2752: p_booking_status_type_id OTA_DELEGATE_BOOKINGS.BOOKING_STATUS_TYPE_ID%TYPE,
2753: p_object_id OTA_EVALUATIONS.OBJECT_ID%TYPE,
2754: p_object_type OTA_EVALUATIONS.OBJECT_TYPE%TYPE,
2755: p_mand_flag OTA_EVALUATIONS.EVAL_MANDATORY_FLAG%TYPE,
2756: p_test_id OTA_TESTS.TEST_ID%TYPE) return varchar2 is

Line 2858: p_sign_eval_status OTA_DELEGATE_BOOKINGS.SIGN_EVAL_STATUS%TYPE

2854: --Modified for 8855548.
2855:
2856: function get_admin_eval_status(
2857: p_event_id OTA_EVENTS.EVENT_ID%TYPE,
2858: p_sign_eval_status OTA_DELEGATE_BOOKINGS.SIGN_EVAL_STATUS%TYPE
2859: ) return varchar2 is
2860:
2861: l_mand_flag OTA_EVALUATIONS.EVAL_MANDATORY_FLAG%TYPE;
2862: l_symbol varchar2(100);

Line 3066: p_booking_id IN ota_delegate_bookings.booking_id%TYPE)

3062: --
3063: FUNCTION get_player_status(p_user_id IN NUMBER,
3064: p_user_type IN ota_attempts.user_type%type,
3065: p_event_id IN ota_events.event_id%TYPE,
3066: p_booking_id IN ota_delegate_bookings.booking_id%TYPE)
3067: RETURN VARCHAR2 IS
3068:
3069: CURSOR c_learning_object IS
3070: SELECT ofr.learning_object_id

Line 3085: FROM ota_delegate_bookings

3081: AND cert_prd_enrollment_id is null;
3082:
3083: CURSOR c_odb_lo_status IS
3084: SELECT content_player_status
3085: FROM ota_delegate_bookings
3086: WHERE booking_id = p_booking_id;
3087:
3088: CURSOR c_imported_offering IS
3089: SELECT offering_id

Line 3115: -- OTA_DELEGATE_BOOKINGS

3111: close c_imported_offering;
3112:
3113: If (l_imported_offering is not null) Then
3114: -- Imported Offering, Status code should be taken from
3115: -- OTA_DELEGATE_BOOKINGS
3116: open c_odb_lo_status;
3117: fetch c_odb_lo_status into l_status;
3118: close c_odb_lo_status;
3119: Else

Line 3166: p_booking_id IN ota_delegate_bookings.booking_id%TYPE)

3162: --
3163: FUNCTION get_enroll_lo_time(p_user_id IN NUMBER,
3164: p_user_type IN ota_attempts.user_type%type,
3165: p_event_id IN ota_events.event_id%TYPE,
3166: p_booking_id IN ota_delegate_bookings.booking_id%TYPE)
3167: RETURN VARCHAR2 IS
3168:
3169: CURSOR c_learning_object IS
3170: SELECT ofr.learning_object_id

Line 3185: FROM ota_delegate_bookings

3181: AND cert_prd_enrollment_id is null;
3182:
3183: CURSOR c_odb_lo_time IS
3184: SELECT total_training_time
3185: FROM ota_delegate_bookings
3186: WHERE booking_id = p_booking_id;
3187:
3188: CURSOR c_imported_offering IS
3189: SELECT offering_id

Line 3215: -- OTA_DELEGATE_BOOKINGS

3211: close c_imported_offering;
3212:
3213: If (l_imported_offering is not null) Then
3214: -- Imported Offering, Score should be taken from
3215: -- OTA_DELEGATE_BOOKINGS
3216: open c_odb_lo_time;
3217: fetch c_odb_lo_time into l_time;
3218: close c_odb_lo_time;
3219: Else

Line 3266: p_booking_id IN ota_delegate_bookings.booking_id%TYPE)

3262: --
3263: FUNCTION get_enroll_lo_score(p_user_id IN NUMBER,
3264: p_user_type IN ota_attempts.user_type%type,
3265: p_event_id IN ota_events.event_id%TYPE,
3266: p_booking_id IN ota_delegate_bookings.booking_id%TYPE)
3267: RETURN VARCHAR2 IS
3268:
3269: CURSOR c_learning_object IS
3270: SELECT ofr.learning_object_id

Line 3285: FROM ota_delegate_bookings

3281: AND cert_prd_enrollment_id is null;
3282:
3283: CURSOR c_odb_lo_score IS
3284: SELECT score
3285: FROM ota_delegate_bookings
3286: WHERE booking_id = p_booking_id;
3287:
3288: CURSOR c_imported_offering IS
3289: SELECT offering_id

Line 3315: -- OTA_DELEGATE_BOOKINGS

3311: close c_imported_offering;
3312:
3313: If (l_imported_offering is not null) Then
3314: -- Imported Offering, Score should be taken from
3315: -- OTA_DELEGATE_BOOKINGS
3316: open c_odb_lo_score;
3317: fetch c_odb_lo_score into l_score;
3318: close c_odb_lo_score;
3319: Else

Line 3373: p_booking_id IN ota_delegate_bookings.booking_id%TYPE,

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
3377:

Line 3406: FROM ota_delegate_bookings

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
3410: SELECT offering_id

Line 3462: from ota_delegate_bookings

3458: order by decode_lesson_status;
3459:
3460: cursor csr_contact_id is
3461: select delegate_contact_id
3462: from ota_delegate_bookings
3463: where booking_id = p_booking_id;
3464:
3465: cursor csr_enr_sign_info is
3466: select odb.sign_eval_status from

Line 3467: ota_delegate_bookings odb

3463: where booking_id = p_booking_id;
3464:
3465: cursor csr_enr_sign_info is
3466: select odb.sign_eval_status from
3467: ota_delegate_bookings odb
3468: where odb.booking_id = p_booking_id;
3469:
3470:
3471: l_proc VARCHAR2(72) := g_package|| 'get_enroll_lo_status';

Line 3493: l_sign_eval_status OTA_DELEGATE_BOOKINGS.sign_eval_status%type;

3489: l_cert_prd_enrollment_ids varchar2(4000) := null;
3490: l_person_id ota_cert_enrollments.person_id%type := null;
3491: l_contact_id ota_cert_enrollments.contact_id%type := null;
3492: l_cert_prd_enrollment_id OTA_CERT_PRD_ENROLLMENTS.cert_prd_enrollment_id%type;
3493: l_sign_eval_status OTA_DELEGATE_BOOKINGS.sign_eval_status%type;
3494: l_trackingtype ota_learning_objects.tracking_type %TYPE;
3495: l_perf_rec_count INTEGER := 0;
3496: l_multiple boolean:=false;
3497:

Line 3526: -- OTA_DELEGATE_BOOKINGS

3522: close c_imported_offering;
3523:
3524: If (l_imported_offering is not null) Then
3525: -- Imported Offering, Status should be taken from
3526: -- OTA_DELEGATE_BOOKINGS
3527: open c_odb_lo_status;
3528: fetch c_odb_lo_status into l_status, l_status_name;
3529: close c_odb_lo_status;
3530: Else

Line 3680: p_booking_id ota_delegate_bookings.booking_id%TYPE)

3676:
3677: FUNCTION get_history_button(p_user_id fnd_user.user_id%TYPE,
3678: p_lo_id ota_learning_objects.learning_object_id%TYPE,
3679: p_event_id ota_events.event_id%TYPE,
3680: p_booking_id ota_delegate_bookings.booking_id%TYPE)
3681: RETURN VARCHAR2 IS
3682:
3683: l_return VARCHAR2(100);
3684: l_enable_move_to_history boolean;

Line 3705: FROM ota_delegate_bookings odb,

3701: AND lesson_status IN ('P', 'C');
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:

Line 3712: FROM ota_delegate_bookings

3708: and odb.booking_status_type_id = bst.booking_status_type_id;
3709:
3710: CURSOR c_history_enabled_odb IS
3711: SELECT content_player_status
3712: FROM ota_delegate_bookings
3713: WHERE booking_id = p_booking_id
3714: AND content_player_status in ('P', 'C');
3715:
3716: BEGIN

Line 3740: -- OTA_DELEGATE_BOOKINGS - Bug 3725560

3736: CLOSE c_imported_offering;
3737:
3738: IF (l_imported_offering is not null) Then
3739: -- Imported Offering, Status should be taken from
3740: -- OTA_DELEGATE_BOOKINGS - Bug 3725560
3741: OPEN c_history_enabled_odb;
3742: FETCH c_history_enabled_odb INTO l_type;
3743: CLOSE c_history_enabled_odb;
3744: ELSE

Line 4050: p_booking_id IN ota_delegate_bookings.booking_id%TYPE,

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
4054:

Line 4079: ota_delegate_bookings odb

4075: AND cert_prd_enrollment_id = p_cert_prd_enrollment_id;
4076:
4077: CURSOR csr_enr_sign_info IS
4078: SELECT odb.sign_eval_status FROM
4079: ota_delegate_bookings odb
4080: WHERE odb.booking_id = p_booking_id;
4081:
4082: l_proc VARCHAR2(72) := g_package|| 'get_cert_lo_status';
4083:

Line 4090: l_sign_eval_status OTA_DELEGATE_BOOKINGS.sign_eval_status%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);
4094: open c_delivery_mode;

Line 4426: ota_delegate_bookings tdb,

4422: ocu.synchronous_flag,
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

Line 4842: ota_delegate_bookings tdb,

4838: ocu.synchronous_flag,
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

Line 5038: ota_delegate_bookings tdb,

5034: ocu.synchronous_flag,
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

Line 5358: ota_delegate_bookings tdb,

5354: ocu.synchronous_flag,
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