[Home] [Help]
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(
538: ota_offerings_vl OFR,
539: ota_category_usages OCU
540: WHERE OFR.activity_version_id = OAV.activity_version_id
541: AND OEV.parent_offering_id = OFR.offering_id
542: AND OEV.business_group_id = ota_general.get_business_group_id
543: AND OFR.delivery_mode_id = OCU.category_usage_id
544: AND OCU.type ='DM'
545: AND trunc(sysdate) BETWEEN nvl(trunc(OAV.start_date),trunc(sysdate)) AND nvl(trunc(OAV.end_date),trunc(sysdate+1))
546: AND ota_timezone_util.convert_date(sysdate, to_char(sysdate,'HH24:MI'), ota_timezone_util.get_server_timezone_code, OEV.timezone)
857: close csr_evt_tree;
858:
859: 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
860: if (assoc.user_group_id is not null) then
861: if(is_learner_in_user_group(p_person_id,assoc.user_group_id,ota_general.get_business_group_id) = 'Y' ) then
862: return 'Y';
863: end if;
864: else
865: 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
872: -- categories above. Use a CONNECT BY cursor.
873: if l_parent_cat_usage_id_4 is not null then
874: for assoc in csr_category_assoc(p_self_enroll_only, l_parent_cat_usage_id_4) loop
875: if (assoc.user_group_id is not null) then
876: if(is_learner_in_user_group(p_person_id,assoc.user_group_id,ota_general.get_business_group_id) = 'Y' ) then
877: return 'Y';
878: end if;
879: else
880: 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
1244: close csr_lp_tree;
1245:
1246: 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
1247: if (assoc.user_group_id is not null) then
1248: if(is_learner_in_user_group(p_person_id,assoc.user_group_id,ota_general.get_business_group_id) = 'Y' ) then
1249: return 'Y';
1250: end if;
1251: else
1252: 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
1259: -- categories above. Use a CONNECT BY cursor.
1260: if l_parent_cat_usage_id_4 is not null then
1261: for assoc in csr_category_assoc(p_self_enroll_only, l_parent_cat_usage_id_4) loop
1262: if (assoc.user_group_id is not null) then
1263: if(is_learner_in_user_group(p_person_id,assoc.user_group_id,ota_general.get_business_group_id) = 'Y' ) then
1264: return 'Y';
1265: end if;
1266: else
1267: 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
1468: close csr_forum_tree;
1469:
1470: 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
1471: if (assoc.user_group_id is not null) then
1472: if(is_learner_in_user_group(p_person_id,assoc.user_group_id,ota_general.get_business_group_id) = 'Y' ) then
1473: return 'Y';
1474: end if;
1475: else
1476: 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
1483: -- categories above. Use a CONNECT BY cursor.
1484: if l_parent_cat_usage_id_4 is not null then
1485: for assoc in csr_category_assoc(p_self_enroll_only, l_parent_cat_usage_id_4) loop
1486: if (assoc.user_group_id is not null) then
1487: if(is_learner_in_user_group(p_person_id,assoc.user_group_id,ota_general.get_business_group_id) = 'Y' ) then
1488: return 'Y';
1489: end if;
1490: else
1491: 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
1693: close csr_chat_tree;
1694:
1695: 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
1696: if (assoc.user_group_id is not null) then
1697: if(is_learner_in_user_group(p_person_id,assoc.user_group_id,ota_general.get_business_group_id) = 'Y' ) then
1698: return 'Y';
1699: end if;
1700: else
1701: 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
1708: -- categories above. Use a CONNECT BY cursor.
1709: if l_parent_cat_usage_id_4 is not null then
1710: for assoc in csr_category_assoc(p_self_enroll_only, l_parent_cat_usage_id_4) loop
1711: if (assoc.user_group_id is not null) then
1712: if(is_learner_in_user_group(p_person_id,assoc.user_group_id,ota_general.get_business_group_id) = 'Y' ) then
1713: return 'Y';
1714: end if;
1715: else
1716: 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
1917: close csr_cert_tree;
1918:
1919: 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
1920: if (assoc.user_group_id is not null) then
1921: if(is_learner_in_user_group(p_person_id,assoc.user_group_id,ota_general.get_business_group_id) = 'Y' ) then
1922: return 'Y';
1923: end if;
1924: else
1925: 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
1932: -- categories above. Use a CONNECT BY cursor.
1933: if l_parent_cat_usage_id_4 is not null then
1934: for assoc in csr_category_assoc(p_self_enroll_only, l_parent_cat_usage_id_4) loop
1935: if (assoc.user_group_id is not null) then
1936: if(is_learner_in_user_group(p_person_id,assoc.user_group_id,ota_general.get_business_group_id) = 'Y' ) then
1937: return 'Y';
1938: end if;
1939: else
1940: 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