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 352: p_booking_id IN ota_delegate_bookings.booking_id%TYPE,

348: FUNCTION get_enroll_lo_status(p_user_id IN NUMBER,
349: p_user_type IN ota_attempts.user_type%type,
350: p_event_id IN ota_events.event_id%TYPE,
351: p_booking_status_type_id IN ota_booking_status_types.booking_status_type_id%TYPE,
352: p_booking_id IN ota_delegate_bookings.booking_id%TYPE,
353: p_mode IN number default null,
354: p_chk_active_cert_flag varchar2 default 'N')
355: RETURN VARCHAR2;
356: --

Line 392: p_booking_id ota_delegate_bookings.booking_id%TYPE)

388:
389: FUNCTION get_history_button(p_user_id fnd_user.user_id%TYPE,
390: p_lo_id ota_learning_objects.learning_object_id%TYPE,
391: p_event_id ota_events.event_id%TYPE,
392: p_booking_id ota_delegate_bookings.booking_id%TYPE)
393: RETURN VARCHAR2;
394:
395: FUNCTION get_lo_completion_date(p_event_id IN ota_events.event_id%type,
396: p_user_id IN NUMBER,

Line 440: p_booking_id IN ota_delegate_bookings.booking_id%TYPE,

436: FUNCTION get_cert_lo_status(p_user_id IN NUMBER,
437: p_user_type IN ota_attempts.user_type%type,
438: p_event_id IN ota_events.event_id%TYPE,
439: p_booking_status_type_id IN ota_booking_status_types.booking_status_type_id%TYPE,
440: p_booking_id IN ota_delegate_bookings.booking_id%TYPE,
441: p_cert_prd_enrollment_id in ota_cert_prd_enrollments.cert_prd_enrollment_id%type,
442: p_mode IN number default null)
443: RETURN varchar2;
444:

Line 805: p_booking_id IN ota_delegate_bookings.booking_id%TYPE)

801: --
802: FUNCTION get_enroll_lo_score(p_user_id IN NUMBER,
803: p_user_type IN ota_attempts.user_type%type,
804: p_event_id IN ota_events.event_id%TYPE,
805: p_booking_id IN ota_delegate_bookings.booking_id%TYPE)
806: RETURN VARCHAR2;
807: --
808: -- ----------------------------------------------------------------------------
809: -- |-------------------------< get_enroll_lo_time >--------------------------|

Line 842: p_booking_id IN ota_delegate_bookings.booking_id%TYPE)

838: --
839: FUNCTION get_enroll_lo_time(p_user_id IN NUMBER,
840: p_user_type IN ota_attempts.user_type%type,
841: p_event_id IN ota_events.event_id%TYPE,
842: p_booking_id IN ota_delegate_bookings.booking_id%TYPE)
843: RETURN VARCHAR2;
844:
845: -- ----------------------------------------------------------------------------
846: -- |-------------------------< get_player_status >----------------------------|

Line 879: p_booking_id IN ota_delegate_bookings.booking_id%TYPE)

875: --
876: FUNCTION get_player_status(p_user_id IN NUMBER,
877: p_user_type IN ota_attempts.user_type%type,
878: p_event_id IN ota_events.event_id%TYPE,
879: p_booking_id IN ota_delegate_bookings.booking_id%TYPE)
880: RETURN VARCHAR2;
881:
882: function get_play_eval_button(
883: p_event_id OTA_EVENTS.EVENT_ID%TYPE,

Line 885: p_booking_status_type_id OTA_DELEGATE_BOOKINGS.BOOKING_STATUS_TYPE_ID%TYPE,

881:
882: function get_play_eval_button(
883: p_event_id OTA_EVENTS.EVENT_ID%TYPE,
884: p_user_id fnd_user.user_id%type,
885: p_booking_status_type_id OTA_DELEGATE_BOOKINGS.BOOKING_STATUS_TYPE_ID%TYPE,
886: p_object_id OTA_EVALUATIONS.OBJECT_ID%TYPE,
887: p_object_type OTA_EVALUATIONS.OBJECT_TYPE%TYPE,
888: p_mand_flag OTA_EVALUATIONS.EVAL_MANDATORY_FLAG%TYPE,
889: p_test_id OTA_TESTS.TEST_ID%TYPE)

Line 905: p_booking_id ota_delegate_bookings.booking_id%type,

901: p_date date,
902: p_failed varchar2);
903:
904: procedure update_enrollment(
905: p_booking_id ota_delegate_bookings.booking_id%type,
906: p_event_id ota_events.event_id%type,
907: p_business_group_id ota_delegate_bookings.business_group_id%type,
908: p_date_booking_placed ota_delegate_bookings.date_booking_placed%type,
909: p_object_version_number ota_delegate_bookings.object_version_number%type,

Line 907: p_business_group_id ota_delegate_bookings.business_group_id%type,

903:
904: procedure update_enrollment(
905: p_booking_id ota_delegate_bookings.booking_id%type,
906: p_event_id ota_events.event_id%type,
907: p_business_group_id ota_delegate_bookings.business_group_id%type,
908: p_date_booking_placed ota_delegate_bookings.date_booking_placed%type,
909: p_object_version_number ota_delegate_bookings.object_version_number%type,
910: p_sign_eval_status ota_delegate_bookings.sign_eval_status%type, --8785933
911: p_date_status_changed ota_delegate_bookings.date_status_changed%type,

Line 908: p_date_booking_placed ota_delegate_bookings.date_booking_placed%type,

904: procedure update_enrollment(
905: p_booking_id ota_delegate_bookings.booking_id%type,
906: p_event_id ota_events.event_id%type,
907: p_business_group_id ota_delegate_bookings.business_group_id%type,
908: p_date_booking_placed ota_delegate_bookings.date_booking_placed%type,
909: p_object_version_number ota_delegate_bookings.object_version_number%type,
910: p_sign_eval_status ota_delegate_bookings.sign_eval_status%type, --8785933
911: p_date_status_changed ota_delegate_bookings.date_status_changed%type,
912: p_new_status varchar2,

Line 909: p_object_version_number ota_delegate_bookings.object_version_number%type,

905: p_booking_id ota_delegate_bookings.booking_id%type,
906: p_event_id ota_events.event_id%type,
907: p_business_group_id ota_delegate_bookings.business_group_id%type,
908: p_date_booking_placed ota_delegate_bookings.date_booking_placed%type,
909: p_object_version_number ota_delegate_bookings.object_version_number%type,
910: p_sign_eval_status ota_delegate_bookings.sign_eval_status%type, --8785933
911: p_date_status_changed ota_delegate_bookings.date_status_changed%type,
912: p_new_status varchar2,
913: p_failed varchar2,

Line 910: p_sign_eval_status ota_delegate_bookings.sign_eval_status%type, --8785933

906: p_event_id ota_events.event_id%type,
907: p_business_group_id ota_delegate_bookings.business_group_id%type,
908: p_date_booking_placed ota_delegate_bookings.date_booking_placed%type,
909: p_object_version_number ota_delegate_bookings.object_version_number%type,
910: p_sign_eval_status ota_delegate_bookings.sign_eval_status%type, --8785933
911: p_date_status_changed ota_delegate_bookings.date_status_changed%type,
912: p_new_status varchar2,
913: p_failed varchar2,
914: p_signed varchar2);

Line 911: p_date_status_changed ota_delegate_bookings.date_status_changed%type,

907: p_business_group_id ota_delegate_bookings.business_group_id%type,
908: p_date_booking_placed ota_delegate_bookings.date_booking_placed%type,
909: p_object_version_number ota_delegate_bookings.object_version_number%type,
910: p_sign_eval_status ota_delegate_bookings.sign_eval_status%type, --8785933
911: p_date_status_changed ota_delegate_bookings.date_status_changed%type,
912: p_new_status varchar2,
913: p_failed varchar2,
914: p_signed varchar2);
915:

Line 920: p_sign_eval_status OTA_DELEGATE_BOOKINGS.SIGN_EVAL_STATUS%TYPE)

916: --Enhancement: 7310093 SIP: A NEW FIELD WHICH CAN GIVE THE STATUS OF THE COURSE / CLASS EVALUATION
917: --Modified for 8855548.
918: function get_admin_eval_status(
919: p_event_id OTA_EVENTS.EVENT_ID%TYPE,
920: p_sign_eval_status OTA_DELEGATE_BOOKINGS.SIGN_EVAL_STATUS%TYPE)
921: return varchar2;
922:
923: --Enhancement: 8785933 Added to show sign or evaluation buttons whichever present.
924: function get_sign_eval_button(

Line 925: p_sign_eval_status OTA_DELEGATE_BOOKINGS.SIGN_EVAL_STATUS%TYPE)

921: return varchar2;
922:
923: --Enhancement: 8785933 Added to show sign or evaluation buttons whichever present.
924: function get_sign_eval_button(
925: p_sign_eval_status OTA_DELEGATE_BOOKINGS.SIGN_EVAL_STATUS%TYPE)
926: return varchar2;
927:
928: FUNCTION get_member_in(p_event_id ota_events.event_id%type,
929: p_person_id ota_cert_enrollments.person_id%type,