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 1452: p_forum_id in ota_forums_b.forum_id%type,

1448: --functions for forum(open) enrollments
1449:
1450: function emp_has_access_to_forum(
1451: p_person_id in per_people_f.person_id%type,
1452: p_forum_id in ota_forums_b.forum_id%type,
1453: p_self_enroll_only in varchar2) return varchar2 is
1454:
1455: l_now date := sysdate;
1456: l_object_id ota_frm_obj_inclusions.object_id%type;

Line 1504: p_forum_id in ota_forums_b.forum_id%type,

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

Line 1539: p_forum_id in ota_forums_b.forum_id%type,

1535:
1536:
1537: function emp_can_enroll_in_forum(
1538: p_person_id in per_people_f.person_id%type,
1539: p_forum_id in ota_forums_b.forum_id%type,
1540: p_public_flag ota_forums_b.public_flag%type,
1541: p_start_date_active in ota_forums_b.start_date_active%type,
1542: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1543: begin

Line 1540: p_public_flag ota_forums_b.public_flag%type,

1536:
1537: function emp_can_enroll_in_forum(
1538: p_person_id in per_people_f.person_id%type,
1539: p_forum_id in ota_forums_b.forum_id%type,
1540: p_public_flag ota_forums_b.public_flag%type,
1541: p_start_date_active in ota_forums_b.start_date_active%type,
1542: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1543: begin
1544: if p_public_flag = 'Y' then

Line 1541: p_start_date_active in ota_forums_b.start_date_active%type,

1537: function emp_can_enroll_in_forum(
1538: p_person_id in per_people_f.person_id%type,
1539: p_forum_id in ota_forums_b.forum_id%type,
1540: p_public_flag ota_forums_b.public_flag%type,
1541: p_start_date_active in ota_forums_b.start_date_active%type,
1542: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1543: begin
1544: if p_public_flag = 'Y' then
1545: return 'Y';

Line 1554: p_forum_id in ota_forums_b.forum_id%type,

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

Line 1555: p_public_flag ota_forums_b.public_flag%type,

1551:
1552: function emp_can_self_enroll_in_forum(
1553: p_person_id in per_people_f.person_id%type,
1554: p_forum_id in ota_forums_b.forum_id%type,
1555: p_public_flag ota_forums_b.public_flag%type,
1556: p_start_date_active in ota_forums_b.start_date_active%type,
1557: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1558: begin
1559: -- A public forum disregards its learner access records. Learner access records

Line 1556: p_start_date_active in ota_forums_b.start_date_active%type,

1552: function emp_can_self_enroll_in_forum(
1553: p_person_id in per_people_f.person_id%type,
1554: p_forum_id in ota_forums_b.forum_id%type,
1555: p_public_flag ota_forums_b.public_flag%type,
1556: p_start_date_active in ota_forums_b.start_date_active%type,
1557: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1558: begin
1559: -- A public forum disregards its learner access records. Learner access records
1560: -- are the only way an event can be made self-enrollable. Therefore, the employee cannot

Line 1572: p_forum_id in ota_forums_b.forum_id%type,

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

Line 1573: p_public_flag ota_forums_b.public_flag%type,

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

Line 1574: p_start_date_active in ota_forums_b.start_date_active%type,

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
1576: begin
1577: if p_public_flag = 'Y' then
1578: return 'Y';

Line 1587: p_forum_id in ota_forums_b.forum_id%type,

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

Line 1588: p_public_flag ota_forums_b.public_flag%type,

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

Line 1589: p_start_date_active in ota_forums_b.start_date_active%type,

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

Line 1606: p_forum_id in ota_forums_b.forum_id%type,

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

Line 1607: p_public_flag ota_forums_b.public_flag%type,

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

Line 1608: p_start_date_active in ota_forums_b.start_date_active%type,

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

Line 1621: p_forum_id in ota_forums_b.forum_id%type,

1617:
1618:
1619: function learner_can_enroll_in_forum(
1620: p_user_id in fnd_user.user_id%type,
1621: p_forum_id in ota_forums_b.forum_id%type,
1622: p_public_flag ota_forums_b.public_flag%type,
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:

Line 1622: p_public_flag ota_forums_b.public_flag%type,

1618:
1619: function learner_can_enroll_in_forum(
1620: p_user_id in fnd_user.user_id%type,
1621: p_forum_id in ota_forums_b.forum_id%type,
1622: p_public_flag ota_forums_b.public_flag%type,
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;

Line 1623: p_start_date_active in ota_forums_b.start_date_active%type,

1619: function learner_can_enroll_in_forum(
1620: p_user_id in fnd_user.user_id%type,
1621: p_forum_id in ota_forums_b.forum_id%type,
1622: p_public_flag ota_forums_b.public_flag%type,
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;

Line 1641: p_forum_id in ota_forums_b.forum_id%type,

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

Line 1642: p_public_flag ota_forums_b.public_flag%type,

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

Line 1643: p_start_date_active in ota_forums_b.start_date_active%type,

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
1645: begin
1646: if p_person_id is not null then
1647: 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 1656: p_forum_id in ota_forums_b.forum_id%type,

1652:
1653:
1654: function lrn_can_self_enroll_in_forum(
1655: p_user_id in fnd_user.user_id%type,
1656: p_forum_id in ota_forums_b.forum_id%type,
1657: p_public_flag ota_forums_b.public_flag%type,
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:

Line 1657: p_public_flag ota_forums_b.public_flag%type,

1653:
1654: function lrn_can_self_enroll_in_forum(
1655: p_user_id in fnd_user.user_id%type,
1656: p_forum_id in ota_forums_b.forum_id%type,
1657: p_public_flag ota_forums_b.public_flag%type,
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;

Line 1658: p_start_date_active in ota_forums_b.start_date_active%type,

1654: function lrn_can_self_enroll_in_forum(
1655: p_user_id in fnd_user.user_id%type,
1656: p_forum_id in ota_forums_b.forum_id%type,
1657: p_public_flag ota_forums_b.public_flag%type,
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;