APPS.OTA_LEARNER_ACCESS_UTIL dependencies on OTA_GENERAL

Line 181: )OR(ea.user_group_id is not null AND is_learner_in_user_group(p_person_id,ea.user_group_id, ota_general.get_business_group_id)= 'Y')

177: AND nvl(ea.position_id,-1) = decode(ea.position_id, null, -1,paf.position_id)
178: AND nvl(ea.person_id,-1) = decode(ea.person_id,null,-1,p_person_id)
179: AND(( nvl(ea.organization_id, -1) = decode(ea.organization_id, null, -1, paf.organization_id)) OR
180: ( ea.org_structure_version_id IS NOT NULL AND learner_belongs_to_child_org(ea.org_structure_version_id,ea.organization_id,paf.person_id)='Y'))
181: )OR(ea.user_group_id is not null AND is_learner_in_user_group(p_person_id,ea.user_group_id, ota_general.get_business_group_id)= 'Y')
182: );
183:
184:
185: cursor csr_evt_assoc_ext(

Line 870: if(is_learner_in_user_group(p_person_id,assoc.user_group_id,ota_general.get_business_group_id) = 'Y' ) then

866: close csr_evt_tree;
867:
868: for assoc in csr_evt_assoc(p_self_enroll_only, p_event_id, l_offering_id, l_activity_version_id, l_category_usage_id, l_parent_cat_usage_id_1, l_parent_cat_usage_id_2, l_parent_cat_usage_id_3, l_parent_cat_usage_id_4) loop
869: if (assoc.user_group_id is not null) then
870: if(is_learner_in_user_group(p_person_id,assoc.user_group_id,ota_general.get_business_group_id) = 'Y' ) then
871: return 'Y';
872: end if;
873: else
874: if person_matches_assoc(p_person_id, l_event_start_date, assoc.person_id, assoc.organization_id, assoc.org_structure_version_id, assoc.job_id, assoc.position_id, assoc.match_type) = true then

Line 885: if(is_learner_in_user_group(p_person_id,assoc.user_group_id,ota_general.get_business_group_id) = 'Y' ) then

881: -- categories above. Use a CONNECT BY cursor.
882: if l_parent_cat_usage_id_4 is not null then
883: for assoc in csr_category_assoc(p_self_enroll_only, l_parent_cat_usage_id_4) loop
884: if (assoc.user_group_id is not null) then
885: if(is_learner_in_user_group(p_person_id,assoc.user_group_id,ota_general.get_business_group_id) = 'Y' ) then
886: return 'Y';
887: end if;
888: else
889: if person_matches_assoc(p_person_id, l_event_start_date, assoc.person_id, assoc.organization_id, assoc.org_structure_version_id, assoc.job_id, assoc.position_id, assoc.match_type) = true then

Line 1261: if(is_learner_in_user_group(p_person_id,assoc.user_group_id,ota_general.get_business_group_id) = 'Y' ) then

1257: close csr_lp_tree;
1258:
1259: for assoc in csr_lp_assoc(p_self_enroll_only, p_learning_path_id, l_category_usage_id, l_parent_cat_usage_id_1, l_parent_cat_usage_id_2, l_parent_cat_usage_id_3, l_parent_cat_usage_id_4) loop
1260: if (assoc.user_group_id is not null) then
1261: if(is_learner_in_user_group(p_person_id,assoc.user_group_id,ota_general.get_business_group_id) = 'Y' ) then
1262: return 'Y';
1263: end if;
1264: else
1265: if person_matches_assoc(p_person_id, l_now, assoc.person_id, assoc.organization_id, assoc.org_structure_version_id, assoc.job_id, assoc.position_id, assoc.match_type) = true then

Line 1276: if(is_learner_in_user_group(p_person_id,assoc.user_group_id,ota_general.get_business_group_id) = 'Y' ) then

1272: -- categories above. Use a CONNECT BY cursor.
1273: if l_parent_cat_usage_id_4 is not null then
1274: for assoc in csr_category_assoc(p_self_enroll_only, l_parent_cat_usage_id_4) loop
1275: if (assoc.user_group_id is not null) then
1276: if(is_learner_in_user_group(p_person_id,assoc.user_group_id,ota_general.get_business_group_id) = 'Y' ) then
1277: return 'Y';
1278: end if;
1279: else
1280: if person_matches_assoc(p_person_id, l_now, assoc.person_id, assoc.organization_id, assoc.org_structure_version_id, assoc.job_id, assoc.position_id, assoc.match_type) = true then

Line 1485: if(is_learner_in_user_group(p_person_id,assoc.user_group_id,ota_general.get_business_group_id) = 'Y' ) then

1481: close csr_forum_tree;
1482:
1483: for assoc in csr_forum_assoc(p_self_enroll_only, p_forum_id, l_object_id, l_parent_cat_usage_id_1, l_parent_cat_usage_id_2, l_parent_cat_usage_id_3, l_parent_cat_usage_id_4) loop
1484: if (assoc.user_group_id is not null) then
1485: if(is_learner_in_user_group(p_person_id,assoc.user_group_id,ota_general.get_business_group_id) = 'Y' ) then
1486: return 'Y';
1487: end if;
1488: else
1489: if person_matches_assoc(p_person_id, l_now, assoc.person_id, assoc.organization_id, assoc.org_structure_version_id, assoc.job_id, assoc.position_id, assoc.match_type) = true then

Line 1500: if(is_learner_in_user_group(p_person_id,assoc.user_group_id,ota_general.get_business_group_id) = 'Y' ) then

1496: -- categories above. Use a CONNECT BY cursor.
1497: if l_parent_cat_usage_id_4 is not null then
1498: for assoc in csr_category_assoc(p_self_enroll_only, l_parent_cat_usage_id_4) loop
1499: if (assoc.user_group_id is not null) then
1500: if(is_learner_in_user_group(p_person_id,assoc.user_group_id,ota_general.get_business_group_id) = 'Y' ) then
1501: return 'Y';
1502: end if;
1503: else
1504: if person_matches_assoc(p_person_id, l_now, assoc.person_id, assoc.organization_id, assoc.org_structure_version_id, assoc.job_id, assoc.position_id, assoc.match_type) = true then

Line 1710: if(is_learner_in_user_group(p_person_id,assoc.user_group_id,ota_general.get_business_group_id) = 'Y' ) then

1706: close csr_chat_tree;
1707:
1708: for assoc in csr_chat_assoc(p_self_enroll_only, p_chat_id, l_object_id, l_parent_cat_usage_id_1, l_parent_cat_usage_id_2, l_parent_cat_usage_id_3, l_parent_cat_usage_id_4) loop
1709: if (assoc.user_group_id is not null) then
1710: if(is_learner_in_user_group(p_person_id,assoc.user_group_id,ota_general.get_business_group_id) = 'Y' ) then
1711: return 'Y';
1712: end if;
1713: else
1714: if person_matches_assoc(p_person_id, l_now, assoc.person_id, assoc.organization_id, assoc.org_structure_version_id, assoc.job_id, assoc.position_id, assoc.match_type) = true then

Line 1725: if(is_learner_in_user_group(p_person_id,assoc.user_group_id,ota_general.get_business_group_id) = 'Y' ) then

1721: -- categories above. Use a CONNECT BY cursor.
1722: if l_parent_cat_usage_id_4 is not null then
1723: for assoc in csr_category_assoc(p_self_enroll_only, l_parent_cat_usage_id_4) loop
1724: if (assoc.user_group_id is not null) then
1725: if(is_learner_in_user_group(p_person_id,assoc.user_group_id,ota_general.get_business_group_id) = 'Y' ) then
1726: return 'Y';
1727: end if;
1728: else
1729: if person_matches_assoc(p_person_id, l_now, assoc.person_id, assoc.organization_id, assoc.org_structure_version_id, assoc.job_id, assoc.position_id, assoc.match_type) = true then

Line 1934: if(is_learner_in_user_group(p_person_id,assoc.user_group_id,ota_general.get_business_group_id) = 'Y' ) then

1930: close csr_cert_tree;
1931:
1932: for assoc in csr_cert_assoc(p_self_enroll_only, p_certification_id, l_category_usage_id, l_parent_cat_usage_id_1, l_parent_cat_usage_id_2, l_parent_cat_usage_id_3, l_parent_cat_usage_id_4) loop
1933: if (assoc.user_group_id is not null) then
1934: if(is_learner_in_user_group(p_person_id,assoc.user_group_id,ota_general.get_business_group_id) = 'Y' ) then
1935: return 'Y';
1936: end if;
1937: else
1938: if person_matches_assoc(p_person_id, l_now, assoc.person_id, assoc.organization_id, assoc.org_structure_version_id, assoc.job_id, assoc.position_id, assoc.match_type) = true then

Line 1949: if(is_learner_in_user_group(p_person_id,assoc.user_group_id,ota_general.get_business_group_id) = 'Y' ) then

1945: -- categories above. Use a CONNECT BY cursor.
1946: if l_parent_cat_usage_id_4 is not null then
1947: for assoc in csr_category_assoc(p_self_enroll_only, l_parent_cat_usage_id_4) loop
1948: if (assoc.user_group_id is not null) then
1949: if(is_learner_in_user_group(p_person_id,assoc.user_group_id,ota_general.get_business_group_id) = 'Y' ) then
1950: return 'Y';
1951: end if;
1952: else
1953: if person_matches_assoc(p_person_id, l_now, assoc.person_id, assoc.organization_id, assoc.org_structure_version_id, assoc.job_id, assoc.position_id, assoc.match_type) = true then

Line 2256: l_business_group_id := ota_general.get_business_group_id;

2252: l_business_group_id ota_events.business_group_id%type;
2253: l_server_timezone_code fnd_timezones_b.timezone_code%type;
2254: begin
2255:
2256: l_business_group_id := ota_general.get_business_group_id;
2257: l_server_timezone_code := ota_timezone_util.get_server_timezone_code;
2258:
2259: if(showLPOnlyClasses = 'Y') then
2260: for assoc in csr_classes_in_course(p_activity_version_id, l_business_group_id, l_server_timezone_code) loop