[Home] [Help]
183:
184:
185: cursor csr_evt_assoc_ext(
186: p_self_enroll_only varchar2,
187: p_party_id hz_parties.party_id%type,
188: p_event_id ota_events.event_id%type,
189: p_offering_id ota_offerings.offering_id%type,
190: p_activity_version_id ota_activity_versions.activity_version_id%type,
191: p_category_usage_id ota_category_usages.category_usage_id%type,
259:
260:
261: cursor csr_lp_assoc_ext(
262: p_self_enroll_only varchar2,
263: p_party_id hz_parties.party_id%type,
264: p_learning_path_id in ota_learning_paths.learning_path_id%type,
265: p_category_usage_id ota_category_usages.category_usage_id%type,
266: p_parent_cat_usage_id_1 ota_category_usages.category_usage_id%type,
267: p_parent_cat_usage_id_2 ota_category_usages.category_usage_id%type,
295:
296:
297: cursor csr_forum_assoc_ext(
298: p_self_enroll_only varchar2,
299: p_party_id hz_parties.party_id%type,
300: p_forum_id in ota_forums_b.forum_id%type,
301: p_category_usage_id ota_category_usages.category_usage_id%type,
302: p_parent_cat_usage_id_1 ota_category_usages.category_usage_id%type,
303: p_parent_cat_usage_id_2 ota_category_usages.category_usage_id%type,
331:
332:
333: cursor csr_chat_assoc_ext(
334: p_self_enroll_only varchar2,
335: p_party_id hz_parties.party_id%type,
336: p_chat_id in ota_chats_b.chat_id%type,
337: p_category_usage_id ota_category_usages.category_usage_id%type,
338: p_parent_cat_usage_id_1 ota_category_usages.category_usage_id%type,
339: p_parent_cat_usage_id_2 ota_category_usages.category_usage_id%type,
367:
368:
369: cursor csr_cert_assoc_ext(
370: p_self_enroll_only varchar2,
371: p_party_id hz_parties.party_id%type,
372: p_certification_id in ota_certifications_b.certification_id%type,
373: p_category_usage_id ota_category_usages.category_usage_id%type,
374: p_parent_cat_usage_id_1 ota_category_usages.category_usage_id%type,
375: p_parent_cat_usage_id_2 ota_category_usages.category_usage_id%type,
889: end emp_has_access;
890:
891:
892: function ext_has_access(
893: p_party_id in hz_parties.party_id%type,
894: p_event_id in ota_events.event_id%type,
895: p_self_enroll_only in varchar2) return varchar2 is
896:
897: l_offering_id ota_offerings.offering_id%type;
1033: end employee_can_self_enroll;
1034:
1035:
1036: function ext_learner_can_enroll(
1037: p_party_id in hz_parties.party_id%type,
1038: p_event_id in ota_events.event_id%type,
1039: p_public_event_flag ota_events.public_event_flag%type,
1040: p_max_internal in ota_events.maximum_internal_attendees%type,
1041: p_event_start_date in otv_scheduled_events.course_start_date%type,
1057: end ext_learner_can_enroll;
1058:
1059:
1060: function ext_learner_can_self_enroll(
1061: p_party_id in hz_parties.party_id%type,
1062: p_event_id in ota_events.event_id%type,
1063: p_public_event_flag ota_events.public_event_flag%type,
1064: p_max_internal in ota_events.maximum_internal_attendees%type,
1065: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
1076:
1077:
1078: function learner_can_enroll(
1079: p_person_id in per_people_f.person_id%type,
1080: p_party_id in hz_parties.party_id%type,
1081: p_event_id in ota_events.event_id%type,
1082: p_public_event_flag in ota_events.public_event_flag%type,
1083: p_max_internal in ota_events.maximum_internal_attendees%type,
1084: p_event_start_date in otv_scheduled_events.course_start_date%type,
1093:
1094:
1095: function learner_can_enroll(
1096: p_person_id in per_people_f.person_id%type,
1097: p_party_id in hz_parties.party_id%type,
1098: p_event_id in ota_events.event_id%type,
1099: p_event_start_date in otv_scheduled_events.course_start_date%type,
1100: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
1101:
1112:
1113:
1114: function learner_can_enroll(
1115: p_person_id in per_people_f.person_id%type,
1116: p_party_id in hz_parties.party_id%type,
1117: p_event_id in ota_events.event_id%type) return varchar2 is
1118:
1119: v_event_start_date ota_events.course_start_date%type;
1120: v_parent_offering_id ota_events.parent_offering_id%type;
1131:
1132:
1133: function learner_can_self_enroll(
1134: p_person_id in per_people_f.person_id%type,
1135: p_party_id in hz_parties.party_id%type,
1136: p_event_id in ota_events.event_id%type,
1137: p_public_event_flag in ota_events.public_event_flag%type,
1138: p_max_internal in ota_events.maximum_internal_attendees%type,
1139: p_event_start_date in otv_scheduled_events.course_start_date%type,
1148:
1149:
1150: function learner_can_self_enroll(
1151: p_person_id in per_people_f.person_id%type,
1152: p_party_id in hz_parties.party_id%type,
1153: p_event_id in ota_events.event_id%type,
1154: p_event_start_date in otv_scheduled_events.course_start_date%type,
1155: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
1156:
1166: end learner_can_self_enroll;
1167:
1168: function learner_can_self_enroll(
1169: p_person_id in per_people_f.person_id%type,
1170: p_party_id in hz_parties.party_id%type,
1171: p_event_id in ota_events.event_id%type) return varchar2 is
1172:
1173: v_event_start_date ota_events.course_start_date%type;
1174: v_parent_offering_id ota_events.parent_offering_id%type;
1195:
1196:
1197: function learner_can_see_category(
1198: p_person_id in per_people_f.person_id%type,
1199: p_party_id in hz_parties.party_id%type,
1200: p_category_usage_id in ota_category_usages.category_usage_id%type) return varchar2 is
1201:
1202: begin
1203: /*
1275: end emp_has_access_to_path;
1276:
1277:
1278: function ext_has_access_to_path(
1279: p_party_id in hz_parties.party_id%type,
1280: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1281: p_self_enroll_only in varchar2) return varchar2 is
1282:
1283: l_category_usage_id ota_category_usages.category_usage_id%type;
1343: end emp_can_self_enroll_in_path;
1344:
1345:
1346: function ext_can_enroll_in_path(
1347: p_party_id in hz_parties.party_id%type,
1348: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1349: p_public_flag ota_learning_paths.public_flag%type,
1350: p_start_date_active in ota_learning_paths.start_date_active%type,
1351: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1358: end ext_can_enroll_in_path;
1359:
1360:
1361: function ext_can_self_enroll_in_path(
1362: p_party_id in hz_parties.party_id%type,
1363: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1364: p_public_flag ota_learning_paths.public_flag%type,
1365: p_start_date_active in ota_learning_paths.start_date_active%type,
1366: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1377:
1378:
1379: function learner_can_enroll_in_path(
1380: p_person_id in per_people_f.person_id%type,
1381: p_party_id in hz_parties.party_id%type,
1382: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1383: p_public_flag ota_learning_paths.public_flag%type,
1384: p_start_date_active in ota_learning_paths.start_date_active%type,
1385: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1399: p_start_date_active in ota_learning_paths.start_date_active%type,
1400: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1401:
1402: v_employee_id fnd_user.employee_id%type;
1403: v_party_id hz_parties.party_id%type;
1404: begin
1405: select employee_id, person_party_id
1406: into v_employee_id, v_party_id
1407: from fnd_user
1412:
1413:
1414: function lrn_can_self_enroll_in_path(
1415: p_person_id in per_people_f.person_id%type,
1416: p_party_id in hz_parties.party_id%type,
1417: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1418: p_public_flag ota_learning_paths.public_flag%type,
1419: p_start_date_active in ota_learning_paths.start_date_active%type,
1420: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1434: p_start_date_active in ota_learning_paths.start_date_active%type,
1435: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1436:
1437: v_employee_id fnd_user.employee_id%type;
1438: v_party_id hz_parties.party_id%type;
1439: begin
1440: select employee_id, person_party_id
1441: into v_employee_id, v_party_id
1442: from fnd_user
1499: end emp_has_access_to_forum;
1500:
1501:
1502: function ext_has_access_to_forum(
1503: p_party_id in hz_parties.party_id%type,
1504: p_forum_id in ota_forums_b.forum_id%type,
1505: p_self_enroll_only in varchar2) return varchar2 is
1506:
1507: l_object_id ota_frm_obj_inclusions.object_id%type;
1567: end emp_can_self_enroll_in_forum;
1568:
1569:
1570: function ext_can_enroll_in_forum(
1571: p_party_id in hz_parties.party_id%type,
1572: p_forum_id in ota_forums_b.forum_id%type,
1573: p_public_flag ota_forums_b.public_flag%type,
1574: p_start_date_active in ota_forums_b.start_date_active%type,
1575: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1582: end ext_can_enroll_in_forum;
1583:
1584:
1585: function ext_can_self_enroll_in_forum(
1586: p_party_id in hz_parties.party_id%type,
1587: p_forum_id in ota_forums_b.forum_id%type,
1588: p_public_flag ota_forums_b.public_flag%type,
1589: p_start_date_active in ota_forums_b.start_date_active%type,
1590: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1601:
1602:
1603: function learner_can_enroll_in_forum(
1604: p_person_id in per_people_f.person_id%type,
1605: p_party_id in hz_parties.party_id%type,
1606: p_forum_id in ota_forums_b.forum_id%type,
1607: p_public_flag ota_forums_b.public_flag%type,
1608: p_start_date_active in ota_forums_b.start_date_active%type,
1609: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1623: p_start_date_active in ota_forums_b.start_date_active%type,
1624: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1625:
1626: v_employee_id fnd_user.employee_id%type;
1627: v_party_id hz_parties.party_id%type;
1628: begin
1629: select employee_id, person_party_id
1630: into v_employee_id, v_party_id
1631: from fnd_user
1636:
1637:
1638: function lrn_can_self_enroll_in_forum(
1639: p_person_id in per_people_f.person_id%type,
1640: p_party_id in hz_parties.party_id%type,
1641: p_forum_id in ota_forums_b.forum_id%type,
1642: p_public_flag ota_forums_b.public_flag%type,
1643: p_start_date_active in ota_forums_b.start_date_active%type,
1644: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1658: p_start_date_active in ota_forums_b.start_date_active%type,
1659: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1660:
1661: v_employee_id fnd_user.employee_id%type;
1662: v_party_id hz_parties.party_id%type;
1663: begin
1664: select employee_id, person_party_id
1665: into v_employee_id, v_party_id
1666: from fnd_user
1724: end emp_has_access_to_chat;
1725:
1726:
1727: function ext_has_access_to_chat(
1728: p_party_id in hz_parties.party_id%type,
1729: p_chat_id in ota_chats_b.chat_id%type,
1730: p_self_enroll_only in varchar2) return varchar2 is
1731:
1732: l_object_id ota_chat_obj_inclusions.object_id%type;
1792: end emp_can_self_enroll_in_chat;
1793:
1794:
1795: function ext_can_enroll_in_chat(
1796: p_party_id in hz_parties.party_id%type,
1797: p_chat_id in ota_chats_b.chat_id%type,
1798: p_public_flag ota_chats_b.public_flag%type,
1799: p_start_date_active in ota_chats_b.start_date_active%type,
1800: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1807: end ext_can_enroll_in_chat;
1808:
1809:
1810: function ext_can_self_enroll_in_chat(
1811: p_party_id in hz_parties.party_id%type,
1812: p_chat_id in ota_chats_b.chat_id%type,
1813: p_public_flag ota_chats_b.public_flag%type,
1814: p_start_date_active in ota_chats_b.start_date_active%type,
1815: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1826:
1827:
1828: function learner_can_enroll_in_chat(
1829: p_person_id in per_people_f.person_id%type,
1830: p_party_id in hz_parties.party_id%type,
1831: p_chat_id in ota_chats_b.chat_id%type,
1832: p_public_flag ota_chats_b.public_flag%type,
1833: p_start_date_active in ota_chats_b.start_date_active%type,
1834: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1848: p_start_date_active in ota_chats_b.start_date_active%type,
1849: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1850:
1851: v_employee_id fnd_user.employee_id%type;
1852: v_party_id hz_parties.party_id%type;
1853: begin
1854: select employee_id, person_party_id
1855: into v_employee_id, v_party_id
1856: from fnd_user
1861:
1862:
1863: function lrn_can_self_enroll_in_chat(
1864: p_person_id in per_people_f.person_id%type,
1865: p_party_id in hz_parties.party_id%type,
1866: p_chat_id in ota_chats_b.chat_id%type,
1867: p_public_flag ota_chats_b.public_flag%type,
1868: p_start_date_active in ota_chats_b.start_date_active%type,
1869: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1883: p_start_date_active in ota_chats_b.start_date_active%type,
1884: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1885:
1886: v_employee_id fnd_user.employee_id%type;
1887: v_party_id hz_parties.party_id%type;
1888: begin
1889: select employee_id, person_party_id
1890: into v_employee_id, v_party_id
1891: from fnd_user
1948: end emp_has_access_to_cert;
1949:
1950:
1951: function ext_has_access_to_cert(
1952: p_party_id in hz_parties.party_id%type,
1953: p_certification_id in ota_certifications_b.certification_id%type,
1954: p_self_enroll_only in varchar2) return varchar2 is
1955:
1956: l_category_usage_id ota_category_usages.category_usage_id%type;
2016: end emp_can_self_enroll_in_cert;
2017:
2018:
2019: function ext_can_enroll_in_cert(
2020: p_party_id in hz_parties.party_id%type,
2021: p_certification_id in ota_certifications_b.certification_id%type,
2022: p_public_flag ota_certifications_b.public_flag%type,
2023: p_start_date_active in ota_certifications_b.start_date_active%type,
2024: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2031: end ext_can_enroll_in_cert;
2032:
2033:
2034: function ext_can_self_enroll_in_cert(
2035: p_party_id in hz_parties.party_id%type,
2036: p_certification_id in ota_certifications_b.certification_id%type,
2037: p_public_flag ota_certifications_b.public_flag%type,
2038: p_start_date_active in ota_certifications_b.start_date_active%type,
2039: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2050:
2051:
2052: function learner_can_enroll_in_cert(
2053: p_person_id in per_people_f.person_id%type,
2054: p_party_id in hz_parties.party_id%type,
2055: p_certification_id in ota_certifications_b.certification_id%type,
2056: p_public_flag ota_certifications_b.public_flag%type,
2057: p_start_date_active in ota_certifications_b.start_date_active%type,
2058: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2072: p_start_date_active in ota_certifications_b.start_date_active%type,
2073: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2074:
2075: v_employee_id fnd_user.employee_id%type;
2076: v_party_id hz_parties.party_id%type;
2077: begin
2078: select employee_id, person_party_id
2079: into v_employee_id, v_party_id
2080: from fnd_user
2085:
2086:
2087: function lrn_can_self_enroll_in_cert(
2088: p_person_id in per_people_f.person_id%type,
2089: p_party_id in hz_parties.party_id%type,
2090: p_certification_id in ota_certifications_b.certification_id%type,
2091: p_public_flag ota_certifications_b.public_flag%type,
2092: p_start_date_active in ota_certifications_b.start_date_active%type,
2093: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2107: p_start_date_active in ota_certifications_b.start_date_active%type,
2108: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2109:
2110: v_employee_id fnd_user.employee_id%type;
2111: v_party_id hz_parties.party_id%type;
2112: begin
2113: select employee_id, person_party_id
2114: into v_employee_id, v_party_id
2115: from fnd_user
2120:
2121: function learner_can_enroll_in_path(
2122: p_learning_path_id in ota_learning_paths.learning_path_id%TYPE
2123: ,p_person_id in per_all_people_f.person_id%type
2124: ,p_party_id in hz_parties.party_id%type) return varchar2
2125: IS
2126: CURSOR csr_get_lp_details IS
2127: SELECT public_flag, start_date_active
2128: FROM ota_learning_paths
2149:
2150: function learner_can_enroll_in_cert(
2151: p_certification_id in ota_certifications_b.certification_id%type
2152: ,p_person_id in per_all_people_f.person_id%type
2153: ,p_party_id in hz_parties.party_id%type) return varchar2
2154: IS
2155: CURSOR csr_get_cert_details IS
2156: SELECT public_flag, start_date_active
2157: FROM ota_certifications_b
2176: END learner_can_enroll_in_cert;
2177:
2178: function learner_has_access_to_course(
2179: p_person_id in per_people_f.person_id%type,
2180: p_party_id in hz_parties.party_id%type,
2181: p_activity_version_id in ota_activity_versions.activity_version_id%type) return varchar2 is
2182:
2183: begin
2184: