APPS.OTA_LEARNER_ACCESS_UTIL dependencies on OTA_USER_GROUPS_B

Line 365: p_user_group_id in ota_user_groups_b.user_group_id%type,

361: showLPOnlyClasses in varchar2 default 'N') return varchar2;
362:
363: function is_learner_in_user_group(
364: p_person_id in per_people_f.person_id%type,
365: p_user_group_id in ota_user_groups_b.user_group_id%type,
366: p_business_group_id number,
367: p_ignore_ug_date_check varchar2 default 'N') return varchar2;
368:
369: function is_learner_matches_user_group(

Line 371: p_user_group_id in ota_user_groups_b.user_group_id%type,

367: p_ignore_ug_date_check varchar2 default 'N') return varchar2;
368:
369: function is_learner_matches_user_group(
370: p_person_id in per_people_f.person_id%type,
371: p_user_group_id in ota_user_groups_b.user_group_id%type,
372: p_business_group_id number,
373: p_ignore_ug_date_check varchar2 default 'N') return boolean;
374:
375: function build_ug_whereclause(

Line 376: p_user_group_id in ota_user_groups_b.user_group_id%type,

372: p_business_group_id number,
373: p_ignore_ug_date_check varchar2 default 'N') return boolean;
374:
375: function build_ug_whereclause(
376: p_user_group_id in ota_user_groups_b.user_group_id%type,
377: p_business_group_id number) return clob;
378:
379: function get_ug_whereclause(
380: p_user_group_id in ota_user_groups_b.user_group_id%type,

Line 380: p_user_group_id in ota_user_groups_b.user_group_id%type,

376: p_user_group_id in ota_user_groups_b.user_group_id%type,
377: p_business_group_id number) return clob;
378:
379: function get_ug_whereclause(
380: p_user_group_id in ota_user_groups_b.user_group_id%type,
381: p_business_group_id number) return clob;
382:
383: function is_full_access_learner_group(p_user_group_id in ota_user_groups_b.user_group_id%type,
384: p_business_group_id number) return varchar2;

Line 383: function is_full_access_learner_group(p_user_group_id in ota_user_groups_b.user_group_id%type,

379: function get_ug_whereclause(
380: p_user_group_id in ota_user_groups_b.user_group_id%type,
381: p_business_group_id number) return clob;
382:
383: function is_full_access_learner_group(p_user_group_id in ota_user_groups_b.user_group_id%type,
384: p_business_group_id number) return varchar2;
385:
386: end ota_learner_access_util;