eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_LEARNER_ACCESS_UTIL dependencies on HZ_PARTIES

Line 187: p_party_id hz_parties.party_id%type,

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,

Line 263: p_party_id hz_parties.party_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,

Line 299: p_party_id hz_parties.party_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,

Line 335: p_party_id hz_parties.party_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,

Line 371: p_party_id hz_parties.party_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,

Line 906: p_party_id in hz_parties.party_id%type,

902: end emp_has_access;
903:
904:
905: function ext_has_access(
906: p_party_id in hz_parties.party_id%type,
907: p_event_id in ota_events.event_id%type,
908: p_self_enroll_only in varchar2) return varchar2 is
909:
910: l_offering_id ota_offerings.offering_id%type;

Line 1050: p_party_id in hz_parties.party_id%type,

1046: end employee_can_self_enroll;
1047:
1048:
1049: function ext_learner_can_enroll(
1050: p_party_id in hz_parties.party_id%type,
1051: p_event_id in ota_events.event_id%type,
1052: p_public_event_flag ota_events.public_event_flag%type,
1053: p_max_internal in ota_events.maximum_internal_attendees%type,
1054: p_event_start_date in otv_scheduled_events.course_start_date%type,

Line 1074: p_party_id in hz_parties.party_id%type,

1070: end ext_learner_can_enroll;
1071:
1072:
1073: function ext_learner_can_self_enroll(
1074: p_party_id in hz_parties.party_id%type,
1075: p_event_id in ota_events.event_id%type,
1076: p_public_event_flag ota_events.public_event_flag%type,
1077: p_max_internal in ota_events.maximum_internal_attendees%type,
1078: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is

Line 1093: p_party_id in hz_parties.party_id%type,

1089:
1090:
1091: function learner_can_enroll(
1092: p_person_id in per_people_f.person_id%type,
1093: p_party_id in hz_parties.party_id%type,
1094: p_event_id in ota_events.event_id%type,
1095: p_public_event_flag in ota_events.public_event_flag%type,
1096: p_max_internal in ota_events.maximum_internal_attendees%type,
1097: p_event_start_date in otv_scheduled_events.course_start_date%type,

Line 1110: p_party_id in hz_parties.party_id%type,

1106:
1107:
1108: function learner_can_enroll(
1109: p_person_id in per_people_f.person_id%type,
1110: p_party_id in hz_parties.party_id%type,
1111: p_event_id in ota_events.event_id%type,
1112: p_event_start_date in otv_scheduled_events.course_start_date%type,
1113: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
1114:

Line 1129: p_party_id in hz_parties.party_id%type,

1125:
1126:
1127: function learner_can_enroll(
1128: p_person_id in per_people_f.person_id%type,
1129: p_party_id in hz_parties.party_id%type,
1130: p_event_id in ota_events.event_id%type) return varchar2 is
1131:
1132: v_event_start_date ota_events.course_start_date%type;
1133: v_parent_offering_id ota_events.parent_offering_id%type;

Line 1148: p_party_id in hz_parties.party_id%type,

1144:
1145:
1146: function learner_can_self_enroll(
1147: p_person_id in per_people_f.person_id%type,
1148: p_party_id in hz_parties.party_id%type,
1149: p_event_id in ota_events.event_id%type,
1150: p_public_event_flag in ota_events.public_event_flag%type,
1151: p_max_internal in ota_events.maximum_internal_attendees%type,
1152: p_event_start_date in otv_scheduled_events.course_start_date%type,

Line 1165: p_party_id in hz_parties.party_id%type,

1161:
1162:
1163: function learner_can_self_enroll(
1164: p_person_id in per_people_f.person_id%type,
1165: p_party_id in hz_parties.party_id%type,
1166: p_event_id in ota_events.event_id%type,
1167: p_event_start_date in otv_scheduled_events.course_start_date%type,
1168: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2 is
1169:

Line 1183: p_party_id in hz_parties.party_id%type,

1179: end learner_can_self_enroll;
1180:
1181: function learner_can_self_enroll(
1182: p_person_id in per_people_f.person_id%type,
1183: p_party_id in hz_parties.party_id%type,
1184: p_event_id in ota_events.event_id%type) return varchar2 is
1185:
1186: v_event_start_date ota_events.course_start_date%type;
1187: v_parent_offering_id ota_events.parent_offering_id%type;

Line 1212: p_party_id in hz_parties.party_id%type,

1208:
1209:
1210: function learner_can_see_category(
1211: p_person_id in per_people_f.person_id%type,
1212: p_party_id in hz_parties.party_id%type,
1213: p_category_usage_id in ota_category_usages.category_usage_id%type) return varchar2 is
1214:
1215: begin
1216: /*

Line 1292: p_party_id in hz_parties.party_id%type,

1288: end emp_has_access_to_path;
1289:
1290:
1291: function ext_has_access_to_path(
1292: p_party_id in hz_parties.party_id%type,
1293: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1294: p_self_enroll_only in varchar2) return varchar2 is
1295:
1296: l_category_usage_id ota_category_usages.category_usage_id%type;

Line 1360: p_party_id in hz_parties.party_id%type,

1356: end emp_can_self_enroll_in_path;
1357:
1358:
1359: function ext_can_enroll_in_path(
1360: p_party_id in hz_parties.party_id%type,
1361: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1362: p_public_flag ota_learning_paths.public_flag%type,
1363: p_start_date_active in ota_learning_paths.start_date_active%type,
1364: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is

Line 1375: p_party_id in hz_parties.party_id%type,

1371: end ext_can_enroll_in_path;
1372:
1373:
1374: function ext_can_self_enroll_in_path(
1375: p_party_id in hz_parties.party_id%type,
1376: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1377: p_public_flag ota_learning_paths.public_flag%type,
1378: p_start_date_active in ota_learning_paths.start_date_active%type,
1379: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is

Line 1394: p_party_id in hz_parties.party_id%type,

1390:
1391:
1392: function learner_can_enroll_in_path(
1393: p_person_id in per_people_f.person_id%type,
1394: p_party_id in hz_parties.party_id%type,
1395: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1396: p_public_flag ota_learning_paths.public_flag%type,
1397: p_start_date_active in ota_learning_paths.start_date_active%type,
1398: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is

Line 1416: v_party_id hz_parties.party_id%type;

1412: p_start_date_active in ota_learning_paths.start_date_active%type,
1413: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1414:
1415: v_employee_id fnd_user.employee_id%type;
1416: v_party_id hz_parties.party_id%type;
1417: begin
1418: select employee_id, person_party_id
1419: into v_employee_id, v_party_id
1420: from fnd_user

Line 1429: p_party_id in hz_parties.party_id%type,

1425:
1426:
1427: function lrn_can_self_enroll_in_path(
1428: p_person_id in per_people_f.person_id%type,
1429: p_party_id in hz_parties.party_id%type,
1430: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1431: p_public_flag ota_learning_paths.public_flag%type,
1432: p_start_date_active in ota_learning_paths.start_date_active%type,
1433: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is

Line 1451: v_party_id hz_parties.party_id%type;

1447: p_start_date_active in ota_learning_paths.start_date_active%type,
1448: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1449:
1450: v_employee_id fnd_user.employee_id%type;
1451: v_party_id hz_parties.party_id%type;
1452: begin
1453: select employee_id, person_party_id
1454: into v_employee_id, v_party_id
1455: from fnd_user

Line 1516: p_party_id in hz_parties.party_id%type,

1512: end emp_has_access_to_forum;
1513:
1514:
1515: function ext_has_access_to_forum(
1516: p_party_id in hz_parties.party_id%type,
1517: p_forum_id in ota_forums_b.forum_id%type,
1518: p_self_enroll_only in varchar2) return varchar2 is
1519:
1520: l_object_id ota_frm_obj_inclusions.object_id%type;

Line 1584: p_party_id in hz_parties.party_id%type,

1580: end emp_can_self_enroll_in_forum;
1581:
1582:
1583: function ext_can_enroll_in_forum(
1584: p_party_id in hz_parties.party_id%type,
1585: p_forum_id in ota_forums_b.forum_id%type,
1586: p_public_flag ota_forums_b.public_flag%type,
1587: p_start_date_active in ota_forums_b.start_date_active%type,
1588: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is

Line 1599: p_party_id in hz_parties.party_id%type,

1595: end ext_can_enroll_in_forum;
1596:
1597:
1598: function ext_can_self_enroll_in_forum(
1599: p_party_id in hz_parties.party_id%type,
1600: p_forum_id in ota_forums_b.forum_id%type,
1601: p_public_flag ota_forums_b.public_flag%type,
1602: p_start_date_active in ota_forums_b.start_date_active%type,
1603: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is

Line 1618: p_party_id in hz_parties.party_id%type,

1614:
1615:
1616: function learner_can_enroll_in_forum(
1617: p_person_id in per_people_f.person_id%type,
1618: p_party_id in hz_parties.party_id%type,
1619: p_forum_id in ota_forums_b.forum_id%type,
1620: p_public_flag ota_forums_b.public_flag%type,
1621: p_start_date_active in ota_forums_b.start_date_active%type,
1622: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is

Line 1640: v_party_id hz_parties.party_id%type;

1636: p_start_date_active in ota_forums_b.start_date_active%type,
1637: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1638:
1639: v_employee_id fnd_user.employee_id%type;
1640: v_party_id hz_parties.party_id%type;
1641: begin
1642: select employee_id, person_party_id
1643: into v_employee_id, v_party_id
1644: from fnd_user

Line 1653: p_party_id in hz_parties.party_id%type,

1649:
1650:
1651: function lrn_can_self_enroll_in_forum(
1652: p_person_id in per_people_f.person_id%type,
1653: p_party_id in hz_parties.party_id%type,
1654: p_forum_id in ota_forums_b.forum_id%type,
1655: p_public_flag ota_forums_b.public_flag%type,
1656: p_start_date_active in ota_forums_b.start_date_active%type,
1657: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is

Line 1675: v_party_id hz_parties.party_id%type;

1671: p_start_date_active in ota_forums_b.start_date_active%type,
1672: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1673:
1674: v_employee_id fnd_user.employee_id%type;
1675: v_party_id hz_parties.party_id%type;
1676: begin
1677: select employee_id, person_party_id
1678: into v_employee_id, v_party_id
1679: from fnd_user

Line 1741: p_party_id in hz_parties.party_id%type,

1737: end emp_has_access_to_chat;
1738:
1739:
1740: function ext_has_access_to_chat(
1741: p_party_id in hz_parties.party_id%type,
1742: p_chat_id in ota_chats_b.chat_id%type,
1743: p_self_enroll_only in varchar2) return varchar2 is
1744:
1745: l_object_id ota_chat_obj_inclusions.object_id%type;

Line 1809: p_party_id in hz_parties.party_id%type,

1805: end emp_can_self_enroll_in_chat;
1806:
1807:
1808: function ext_can_enroll_in_chat(
1809: p_party_id in hz_parties.party_id%type,
1810: p_chat_id in ota_chats_b.chat_id%type,
1811: p_public_flag ota_chats_b.public_flag%type,
1812: p_start_date_active in ota_chats_b.start_date_active%type,
1813: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is

Line 1824: p_party_id in hz_parties.party_id%type,

1820: end ext_can_enroll_in_chat;
1821:
1822:
1823: function ext_can_self_enroll_in_chat(
1824: p_party_id in hz_parties.party_id%type,
1825: p_chat_id in ota_chats_b.chat_id%type,
1826: p_public_flag ota_chats_b.public_flag%type,
1827: p_start_date_active in ota_chats_b.start_date_active%type,
1828: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is

Line 1843: p_party_id in hz_parties.party_id%type,

1839:
1840:
1841: function learner_can_enroll_in_chat(
1842: p_person_id in per_people_f.person_id%type,
1843: p_party_id in hz_parties.party_id%type,
1844: p_chat_id in ota_chats_b.chat_id%type,
1845: p_public_flag ota_chats_b.public_flag%type,
1846: p_start_date_active in ota_chats_b.start_date_active%type,
1847: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is

Line 1865: v_party_id hz_parties.party_id%type;

1861: p_start_date_active in ota_chats_b.start_date_active%type,
1862: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1863:
1864: v_employee_id fnd_user.employee_id%type;
1865: v_party_id hz_parties.party_id%type;
1866: begin
1867: select employee_id, person_party_id
1868: into v_employee_id, v_party_id
1869: from fnd_user

Line 1878: p_party_id in hz_parties.party_id%type,

1874:
1875:
1876: function lrn_can_self_enroll_in_chat(
1877: p_person_id in per_people_f.person_id%type,
1878: p_party_id in hz_parties.party_id%type,
1879: p_chat_id in ota_chats_b.chat_id%type,
1880: p_public_flag ota_chats_b.public_flag%type,
1881: p_start_date_active in ota_chats_b.start_date_active%type,
1882: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is

Line 1900: v_party_id hz_parties.party_id%type;

1896: p_start_date_active in ota_chats_b.start_date_active%type,
1897: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1898:
1899: v_employee_id fnd_user.employee_id%type;
1900: v_party_id hz_parties.party_id%type;
1901: begin
1902: select employee_id, person_party_id
1903: into v_employee_id, v_party_id
1904: from fnd_user

Line 1965: p_party_id in hz_parties.party_id%type,

1961: end emp_has_access_to_cert;
1962:
1963:
1964: function ext_has_access_to_cert(
1965: p_party_id in hz_parties.party_id%type,
1966: p_certification_id in ota_certifications_b.certification_id%type,
1967: p_self_enroll_only in varchar2) return varchar2 is
1968:
1969: l_category_usage_id ota_category_usages.category_usage_id%type;

Line 2033: p_party_id in hz_parties.party_id%type,

2029: end emp_can_self_enroll_in_cert;
2030:
2031:
2032: function ext_can_enroll_in_cert(
2033: p_party_id in hz_parties.party_id%type,
2034: p_certification_id in ota_certifications_b.certification_id%type,
2035: p_public_flag ota_certifications_b.public_flag%type,
2036: p_start_date_active in ota_certifications_b.start_date_active%type,
2037: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is

Line 2048: p_party_id in hz_parties.party_id%type,

2044: end ext_can_enroll_in_cert;
2045:
2046:
2047: function ext_can_self_enroll_in_cert(
2048: p_party_id in hz_parties.party_id%type,
2049: p_certification_id in ota_certifications_b.certification_id%type,
2050: p_public_flag ota_certifications_b.public_flag%type,
2051: p_start_date_active in ota_certifications_b.start_date_active%type,
2052: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is

Line 2067: p_party_id in hz_parties.party_id%type,

2063:
2064:
2065: function learner_can_enroll_in_cert(
2066: p_person_id in per_people_f.person_id%type,
2067: p_party_id in hz_parties.party_id%type,
2068: p_certification_id in ota_certifications_b.certification_id%type,
2069: p_public_flag ota_certifications_b.public_flag%type,
2070: p_start_date_active in ota_certifications_b.start_date_active%type,
2071: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is

Line 2089: v_party_id hz_parties.party_id%type;

2085: p_start_date_active in ota_certifications_b.start_date_active%type,
2086: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2087:
2088: v_employee_id fnd_user.employee_id%type;
2089: v_party_id hz_parties.party_id%type;
2090: begin
2091: select employee_id, person_party_id
2092: into v_employee_id, v_party_id
2093: from fnd_user

Line 2102: p_party_id in hz_parties.party_id%type,

2098:
2099:
2100: function lrn_can_self_enroll_in_cert(
2101: p_person_id in per_people_f.person_id%type,
2102: p_party_id in hz_parties.party_id%type,
2103: p_certification_id in ota_certifications_b.certification_id%type,
2104: p_public_flag ota_certifications_b.public_flag%type,
2105: p_start_date_active in ota_certifications_b.start_date_active%type,
2106: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is

Line 2124: v_party_id hz_parties.party_id%type;

2120: p_start_date_active in ota_certifications_b.start_date_active%type,
2121: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2122:
2123: v_employee_id fnd_user.employee_id%type;
2124: v_party_id hz_parties.party_id%type;
2125: begin
2126: select employee_id, person_party_id
2127: into v_employee_id, v_party_id
2128: from fnd_user

Line 2137: ,p_party_id in hz_parties.party_id%type) return varchar2

2133:
2134: function learner_can_enroll_in_path(
2135: p_learning_path_id in ota_learning_paths.learning_path_id%TYPE
2136: ,p_person_id in per_all_people_f.person_id%type
2137: ,p_party_id in hz_parties.party_id%type) return varchar2
2138: IS
2139: CURSOR csr_get_lp_details IS
2140: SELECT public_flag, start_date_active
2141: FROM ota_learning_paths

Line 2166: ,p_party_id in hz_parties.party_id%type) return varchar2

2162:
2163: function learner_can_enroll_in_cert(
2164: p_certification_id in ota_certifications_b.certification_id%type
2165: ,p_person_id in per_all_people_f.person_id%type
2166: ,p_party_id in hz_parties.party_id%type) return varchar2
2167: IS
2168: CURSOR csr_get_cert_details IS
2169: SELECT public_flag, start_date_active
2170: FROM ota_certifications_b

Line 2193: p_party_id in hz_parties.party_id%type,

2189: END learner_can_enroll_in_cert;
2190:
2191: function learner_has_access_to_course(
2192: p_person_id in per_people_f.person_id%type,
2193: p_party_id in hz_parties.party_id%type,
2194: p_activity_version_id in ota_activity_versions.activity_version_id%type,
2195: showLPOnlyClasses in varchar2 default 'N') return varchar2 is
2196:
2197: CURSOR csr_classes_in_course(