APPS.OTA_LO_UTILITY dependencies on OTA_CERT_ENROLLMENTS

Line 237: p_contact_id ota_cert_enrollments.contact_id%type default null,

233: p_course_start_date ota_events.course_start_date%type,
234: p_course_end_date ota_events.course_end_date%type,
235: p_enrollment_status_type ota_booking_status_types.type%TYPE DEFAULT NULL,
236: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null,
237: p_contact_id ota_cert_enrollments.contact_id%type default null,
238: p_chk_active_cert_flag varchar2 default 'N') return varchar2;
239:
240:
241: function get_play_button_for_test(

Line 747: p_person_id ota_cert_enrollments.contact_id%type,

743: return varchar2;
744:
745: procedure get_active_cert_prds(
746: p_event_id ota_events.event_id%type,
747: p_person_id ota_cert_enrollments.contact_id%type,
748: p_contact_id ota_cert_enrollments.contact_id%type,
749: p_cert_prd_enrollment_ids OUT NOCOPY varchar2);
750:
751: -- ----------------------------------------------------------------------------

Line 748: p_contact_id ota_cert_enrollments.contact_id%type,

744:
745: procedure get_active_cert_prds(
746: p_event_id ota_events.event_id%type,
747: p_person_id ota_cert_enrollments.contact_id%type,
748: p_contact_id ota_cert_enrollments.contact_id%type,
749: p_cert_prd_enrollment_ids OUT NOCOPY varchar2);
750:
751: -- ----------------------------------------------------------------------------
752: -- |--------------------< LO_has_cld_and_no_strt_url>-------------------------|

Line 929: p_person_id ota_cert_enrollments.person_id%type,

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,
930: p_contact_id ota_cert_enrollments.contact_id%type) RETURN VARCHAR2;
931:
932: -- Enchancement 13496386 Added for Learner Performance Details page
933: FUNCTION get_num_of_online_records(p_user_id IN NUMBER,

Line 930: p_contact_id ota_cert_enrollments.contact_id%type) RETURN VARCHAR2;

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,
930: p_contact_id ota_cert_enrollments.contact_id%type) RETURN VARCHAR2;
931:
932: -- Enchancement 13496386 Added for Learner Performance Details page
933: FUNCTION get_num_of_online_records(p_user_id IN NUMBER,
934: p_user_type IN ota_attempts.user_type%type,