APPS.OTA_LEARNER_ACCESS_UTIL dependencies on OTA_USER_GROUPS_B

Line 363: p_user_group_id in ota_user_groups_b.user_group_id%type,

359: p_activity_version_id in ota_activity_versions.activity_version_id%type) return varchar2;
360:
361: function is_learner_in_user_group(
362: p_person_id in per_people_f.person_id%type,
363: p_user_group_id in ota_user_groups_b.user_group_id%type,
364: p_business_group_id number) return varchar2;
365:
366: function is_learner_matches_user_group(
367: p_person_id in per_people_f.person_id%type,

Line 368: p_user_group_id in ota_user_groups_b.user_group_id%type,

364: p_business_group_id number) return varchar2;
365:
366: function is_learner_matches_user_group(
367: p_person_id in per_people_f.person_id%type,
368: p_user_group_id in ota_user_groups_b.user_group_id%type,
369: p_business_group_id number) return boolean;
370:
371: function build_ug_whereclause(
372: p_user_group_id in ota_user_groups_b.user_group_id%type,

Line 372: p_user_group_id in ota_user_groups_b.user_group_id%type,

368: p_user_group_id in ota_user_groups_b.user_group_id%type,
369: p_business_group_id number) return boolean;
370:
371: function build_ug_whereclause(
372: p_user_group_id in ota_user_groups_b.user_group_id%type,
373: p_business_group_id number) return clob;
374:
375: function get_ug_whereclause(
376: p_user_group_id in ota_user_groups_b.user_group_id%type,

Line 376: p_user_group_id in ota_user_groups_b.user_group_id%type,

372: p_user_group_id in ota_user_groups_b.user_group_id%type,
373: p_business_group_id number) return clob;
374:
375: function get_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 is_full_access_learner_group(p_user_group_id in ota_user_groups_b.user_group_id%type,
380: p_business_group_id number) return varchar2;

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

375: function get_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 is_full_access_learner_group(p_user_group_id in ota_user_groups_b.user_group_id%type,
380: p_business_group_id number) return varchar2;
381:
382: end ota_learner_access_util;