APPS.OTA_LEARNER_ACCESS_UTIL dependencies on OTA_FORUMS_B

Line 51: p_forum_id ota_forums_b.forum_id%type) is

47: c2.parent_cat_usage_id = c3.category_usage_id(+) and
48: c3.parent_cat_usage_id = c4.category_usage_id(+);
49:
50: cursor csr_forum_tree(
51: p_forum_id ota_forums_b.forum_id%type) is
52: select i.object_id,
53: c1.parent_cat_usage_id as parent_cat_usage_id_1,
54: c2.parent_cat_usage_id as parent_cat_usage_id_2,
55: c3.parent_cat_usage_id as parent_cat_usage_id_3,

Line 281: p_forum_id in ota_forums_b.forum_id%type,

277:
278:
279: cursor csr_forum_assoc(
280: p_self_enroll_only varchar2,
281: p_forum_id in ota_forums_b.forum_id%type,
282: p_category_usage_id ota_category_usages.category_usage_id%type,
283: p_parent_cat_usage_id_1 ota_category_usages.category_usage_id%type,
284: p_parent_cat_usage_id_2 ota_category_usages.category_usage_id%type,
285: p_parent_cat_usage_id_3 ota_category_usages.category_usage_id%type,

Line 300: p_forum_id in ota_forums_b.forum_id%type,

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,
304: p_parent_cat_usage_id_3 ota_category_usages.category_usage_id%type,

Line 1465: p_forum_id in ota_forums_b.forum_id%type,

1461: --functions for forum(open) enrollments
1462:
1463: function emp_has_access_to_forum(
1464: p_person_id in per_people_f.person_id%type,
1465: p_forum_id in ota_forums_b.forum_id%type,
1466: p_self_enroll_only in varchar2) return varchar2 is
1467:
1468: l_now date := sysdate;
1469: l_object_id ota_frm_obj_inclusions.object_id%type;

Line 1517: p_forum_id in ota_forums_b.forum_id%type,

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;
1521: l_parent_cat_usage_id_1 ota_category_usages.category_usage_id%type;

Line 1552: p_forum_id in ota_forums_b.forum_id%type,

1548:
1549:
1550: function emp_can_enroll_in_forum(
1551: p_person_id in per_people_f.person_id%type,
1552: p_forum_id in ota_forums_b.forum_id%type,
1553: p_public_flag ota_forums_b.public_flag%type,
1554: p_start_date_active in ota_forums_b.start_date_active%type,
1555: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1556: begin

Line 1553: p_public_flag ota_forums_b.public_flag%type,

1549:
1550: function emp_can_enroll_in_forum(
1551: p_person_id in per_people_f.person_id%type,
1552: p_forum_id in ota_forums_b.forum_id%type,
1553: p_public_flag ota_forums_b.public_flag%type,
1554: p_start_date_active in ota_forums_b.start_date_active%type,
1555: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1556: begin
1557: if p_public_flag = 'Y' then

Line 1554: p_start_date_active in ota_forums_b.start_date_active%type,

1550: function emp_can_enroll_in_forum(
1551: p_person_id in per_people_f.person_id%type,
1552: p_forum_id in ota_forums_b.forum_id%type,
1553: p_public_flag ota_forums_b.public_flag%type,
1554: p_start_date_active in ota_forums_b.start_date_active%type,
1555: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1556: begin
1557: if p_public_flag = 'Y' then
1558: return 'Y';

Line 1567: p_forum_id in ota_forums_b.forum_id%type,

1563:
1564:
1565: function emp_can_self_enroll_in_forum(
1566: p_person_id in per_people_f.person_id%type,
1567: p_forum_id in ota_forums_b.forum_id%type,
1568: p_public_flag ota_forums_b.public_flag%type,
1569: p_start_date_active in ota_forums_b.start_date_active%type,
1570: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1571: begin

Line 1568: p_public_flag ota_forums_b.public_flag%type,

1564:
1565: function emp_can_self_enroll_in_forum(
1566: p_person_id in per_people_f.person_id%type,
1567: p_forum_id in ota_forums_b.forum_id%type,
1568: p_public_flag ota_forums_b.public_flag%type,
1569: p_start_date_active in ota_forums_b.start_date_active%type,
1570: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1571: begin
1572: -- A public forum disregards its learner access records. Learner access records

Line 1569: p_start_date_active in ota_forums_b.start_date_active%type,

1565: function emp_can_self_enroll_in_forum(
1566: p_person_id in per_people_f.person_id%type,
1567: p_forum_id in ota_forums_b.forum_id%type,
1568: p_public_flag ota_forums_b.public_flag%type,
1569: p_start_date_active in ota_forums_b.start_date_active%type,
1570: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1571: begin
1572: -- A public forum disregards its learner access records. Learner access records
1573: -- are the only way an event can be made self-enrollable. Therefore, the employee cannot

Line 1585: p_forum_id in ota_forums_b.forum_id%type,

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
1589: begin

Line 1586: p_public_flag ota_forums_b.public_flag%type,

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
1589: begin
1590: if p_public_flag = 'Y' then

Line 1587: p_start_date_active in ota_forums_b.start_date_active%type,

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
1589: begin
1590: if p_public_flag = 'Y' then
1591: return 'Y';

Line 1600: p_forum_id in ota_forums_b.forum_id%type,

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
1604: begin

Line 1601: p_public_flag ota_forums_b.public_flag%type,

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
1604: begin
1605: -- A public forum disregards its learner access records. Learner access records

Line 1602: p_start_date_active in ota_forums_b.start_date_active%type,

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
1604: begin
1605: -- A public forum disregards its learner access records. Learner access records
1606: -- are the only way an event can be made self-enrollable. Therefore, the ext learner cannot

Line 1619: p_forum_id in ota_forums_b.forum_id%type,

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
1623: begin

Line 1620: p_public_flag ota_forums_b.public_flag%type,

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
1623: begin
1624: if p_person_id is not null then

Line 1621: p_start_date_active in ota_forums_b.start_date_active%type,

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
1623: begin
1624: if p_person_id is not null then
1625: return emp_can_enroll_in_forum(p_person_id, p_forum_id, p_public_flag, p_start_date_active, p_category_usage_id);

Line 1634: p_forum_id in ota_forums_b.forum_id%type,

1630:
1631:
1632: function learner_can_enroll_in_forum(
1633: p_user_id in fnd_user.user_id%type,
1634: p_forum_id in ota_forums_b.forum_id%type,
1635: p_public_flag ota_forums_b.public_flag%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:

Line 1635: p_public_flag ota_forums_b.public_flag%type,

1631:
1632: function learner_can_enroll_in_forum(
1633: p_user_id in fnd_user.user_id%type,
1634: p_forum_id in ota_forums_b.forum_id%type,
1635: p_public_flag ota_forums_b.public_flag%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;

Line 1636: p_start_date_active in ota_forums_b.start_date_active%type,

1632: function learner_can_enroll_in_forum(
1633: p_user_id in fnd_user.user_id%type,
1634: p_forum_id in ota_forums_b.forum_id%type,
1635: p_public_flag ota_forums_b.public_flag%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;

Line 1654: p_forum_id in ota_forums_b.forum_id%type,

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
1658: begin

Line 1655: p_public_flag ota_forums_b.public_flag%type,

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
1658: begin
1659: if p_person_id is not null then

Line 1656: p_start_date_active in ota_forums_b.start_date_active%type,

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
1658: begin
1659: if p_person_id is not null then
1660: return emp_can_self_enroll_in_forum(p_person_id, p_forum_id, p_public_flag, p_start_date_active, p_category_usage_id);

Line 1669: p_forum_id in ota_forums_b.forum_id%type,

1665:
1666:
1667: function lrn_can_self_enroll_in_forum(
1668: p_user_id in fnd_user.user_id%type,
1669: p_forum_id in ota_forums_b.forum_id%type,
1670: p_public_flag ota_forums_b.public_flag%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:

Line 1670: p_public_flag ota_forums_b.public_flag%type,

1666:
1667: function lrn_can_self_enroll_in_forum(
1668: p_user_id in fnd_user.user_id%type,
1669: p_forum_id in ota_forums_b.forum_id%type,
1670: p_public_flag ota_forums_b.public_flag%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;

Line 1671: p_start_date_active in ota_forums_b.start_date_active%type,

1667: function lrn_can_self_enroll_in_forum(
1668: p_user_id in fnd_user.user_id%type,
1669: p_forum_id in ota_forums_b.forum_id%type,
1670: p_public_flag ota_forums_b.public_flag%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;