APPS.OTA_LO_UTILITY dependencies on OTA_LP_MEMBER_ENROLLMENTS

Line 645: function get_lme_online_event_id(p_lp_member_enrollment_id in ota_lp_member_enrollments.lp_member_enrollment_id%type)

641: -- Access Status
642: -- Public
643: -- {End of Comments}
644: ------------------------------------------------------------------
645: function get_lme_online_event_id(p_lp_member_enrollment_id in ota_lp_member_enrollments.lp_member_enrollment_id%type)
646: return varchar2;
647:
648: -- ----------------------------------------------------------------
649: -- --------------------------------------

Line 672: p_lp_member_enrollment_id in ota_lp_member_enrollments.lp_member_enrollment_id%type)

668: ------------------------------------------------------------------
669: function get_lme_play_button(p_user_id in fnd_user.user_id%type,
670: p_user_type in ota_attempts.user_type%type,
671: p_is_manager in varchar2,
672: p_lp_member_enrollment_id in ota_lp_member_enrollments.lp_member_enrollment_id%type)
673: return varchar2;
674:
675: -- ----------------------------------------------------------------
676: -- --------------------------------------

Line 693: function get_lme_player_toolbar_flag(p_lp_member_enrollment_id in ota_lp_member_enrollments.lp_member_enrollment_id%type)

689: -- Access Status
690: -- Public
691: -- {End of Comments}
692: ------------------------------------------------------------------
693: function get_lme_player_toolbar_flag(p_lp_member_enrollment_id in ota_lp_member_enrollments.lp_member_enrollment_id%type)
694: return varchar2;
695:
696: -- ----------------------------------------------------------------
697: -- --------------------------------------

Line 718: p_lp_member_enrollment_id in ota_lp_member_enrollments.lp_member_enrollment_id%type)

714: -- {End of Comments}
715: ------------------------------------------------------------------
716: function get_lpe_lo_status(p_user_id in fnd_user.user_id%type,
717: p_user_type in ota_attempts.user_type%type,
718: p_lp_member_enrollment_id in ota_lp_member_enrollments.lp_member_enrollment_id%type)
719: return varchar2;
720:
721:
722: -- ----------------------------------------------------------------

Line 742: function get_lme_onl_evt_count(p_lp_member_enrollment_id in ota_lp_member_enrollments.lp_member_enrollment_id%type)

738: -- Access Status
739: -- Public
740: -- {End of Comments}
741: ------------------------------------------------------------------
742: function get_lme_onl_evt_count(p_lp_member_enrollment_id in ota_lp_member_enrollments.lp_member_enrollment_id%type)
743: return varchar2;
744:
745: procedure get_active_cert_prds(
746: p_event_id ota_events.event_id%type,