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 OTA_CHATS_B

Line 71: p_chat_id ota_chats_b.chat_id%type) is

67: c2.parent_cat_usage_id = c3.category_usage_id(+) and
68: c3.parent_cat_usage_id = c4.category_usage_id(+);
69:
70: cursor csr_chat_tree(
71: p_chat_id ota_chats_b.chat_id%type) is
72: select i.object_id,
73: c1.parent_cat_usage_id as parent_cat_usage_id_1,
74: c2.parent_cat_usage_id as parent_cat_usage_id_2,
75: c3.parent_cat_usage_id as parent_cat_usage_id_3,

Line 317: p_chat_id in ota_chats_b.chat_id%type,

313:
314:
315: cursor csr_chat_assoc(
316: p_self_enroll_only varchar2,
317: p_chat_id in ota_chats_b.chat_id%type,
318: p_category_usage_id ota_category_usages.category_usage_id%type,
319: p_parent_cat_usage_id_1 ota_category_usages.category_usage_id%type,
320: p_parent_cat_usage_id_2 ota_category_usages.category_usage_id%type,
321: p_parent_cat_usage_id_3 ota_category_usages.category_usage_id%type,

Line 336: p_chat_id in ota_chats_b.chat_id%type,

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

Line 1677: p_chat_id in ota_chats_b.chat_id%type,

1673: --functions for chats(open) enrollments
1674:
1675: function emp_has_access_to_chat(
1676: p_person_id in per_people_f.person_id%type,
1677: p_chat_id in ota_chats_b.chat_id%type,
1678: p_self_enroll_only in varchar2) return varchar2 is
1679:
1680: l_now date := sysdate;
1681: l_object_id ota_chat_obj_inclusions.object_id%type;

Line 1729: p_chat_id in ota_chats_b.chat_id%type,

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

Line 1764: p_chat_id in ota_chats_b.chat_id%type,

1760:
1761:
1762: function emp_can_enroll_in_chat(
1763: p_person_id in per_people_f.person_id%type,
1764: p_chat_id in ota_chats_b.chat_id%type,
1765: p_public_flag ota_chats_b.public_flag%type,
1766: p_start_date_active in ota_chats_b.start_date_active%type,
1767: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1768: begin

Line 1765: p_public_flag ota_chats_b.public_flag%type,

1761:
1762: function emp_can_enroll_in_chat(
1763: p_person_id in per_people_f.person_id%type,
1764: p_chat_id in ota_chats_b.chat_id%type,
1765: p_public_flag ota_chats_b.public_flag%type,
1766: p_start_date_active in ota_chats_b.start_date_active%type,
1767: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1768: begin
1769: if p_public_flag = 'Y' then

Line 1766: p_start_date_active in ota_chats_b.start_date_active%type,

1762: function emp_can_enroll_in_chat(
1763: p_person_id in per_people_f.person_id%type,
1764: p_chat_id in ota_chats_b.chat_id%type,
1765: p_public_flag ota_chats_b.public_flag%type,
1766: p_start_date_active in ota_chats_b.start_date_active%type,
1767: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1768: begin
1769: if p_public_flag = 'Y' then
1770: return 'Y';

Line 1779: p_chat_id in ota_chats_b.chat_id%type,

1775:
1776:
1777: function emp_can_self_enroll_in_chat(
1778: p_person_id in per_people_f.person_id%type,
1779: p_chat_id in ota_chats_b.chat_id%type,
1780: p_public_flag ota_chats_b.public_flag%type,
1781: p_start_date_active in ota_chats_b.start_date_active%type,
1782: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1783: begin

Line 1780: p_public_flag ota_chats_b.public_flag%type,

1776:
1777: function emp_can_self_enroll_in_chat(
1778: p_person_id in per_people_f.person_id%type,
1779: p_chat_id in ota_chats_b.chat_id%type,
1780: p_public_flag ota_chats_b.public_flag%type,
1781: p_start_date_active in ota_chats_b.start_date_active%type,
1782: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1783: begin
1784: -- A public chat disregards its learner access records. Learner access records

Line 1781: p_start_date_active in ota_chats_b.start_date_active%type,

1777: function emp_can_self_enroll_in_chat(
1778: p_person_id in per_people_f.person_id%type,
1779: p_chat_id in ota_chats_b.chat_id%type,
1780: p_public_flag ota_chats_b.public_flag%type,
1781: p_start_date_active in ota_chats_b.start_date_active%type,
1782: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1783: begin
1784: -- A public chat disregards its learner access records. Learner access records
1785: -- are the only way an event can be made self-enrollable. Therefore, the employee cannot

Line 1797: p_chat_id in ota_chats_b.chat_id%type,

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

Line 1798: p_public_flag ota_chats_b.public_flag%type,

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

Line 1799: p_start_date_active in ota_chats_b.start_date_active%type,

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
1801: begin
1802: if p_public_flag = 'Y' then
1803: return 'Y';

Line 1812: p_chat_id in ota_chats_b.chat_id%type,

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

Line 1813: p_public_flag ota_chats_b.public_flag%type,

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
1816: begin
1817: -- A public chat disregards its learner access records. Learner access records

Line 1814: p_start_date_active in ota_chats_b.start_date_active%type,

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

Line 1831: p_chat_id in ota_chats_b.chat_id%type,

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

Line 1832: p_public_flag ota_chats_b.public_flag%type,

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

Line 1833: p_start_date_active in ota_chats_b.start_date_active%type,

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
1835: begin
1836: if p_person_id is not null then
1837: return emp_can_enroll_in_chat(p_person_id, p_chat_id, p_public_flag, p_start_date_active, p_category_usage_id);

Line 1846: p_chat_id in ota_chats_b.chat_id%type,

1842:
1843:
1844: function learner_can_enroll_in_chat(
1845: p_user_id in fnd_user.user_id%type,
1846: p_chat_id in ota_chats_b.chat_id%type,
1847: p_public_flag ota_chats_b.public_flag%type,
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:

Line 1847: p_public_flag ota_chats_b.public_flag%type,

1843:
1844: function learner_can_enroll_in_chat(
1845: p_user_id in fnd_user.user_id%type,
1846: p_chat_id in ota_chats_b.chat_id%type,
1847: p_public_flag ota_chats_b.public_flag%type,
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;

Line 1848: p_start_date_active in ota_chats_b.start_date_active%type,

1844: function learner_can_enroll_in_chat(
1845: p_user_id in fnd_user.user_id%type,
1846: p_chat_id in ota_chats_b.chat_id%type,
1847: p_public_flag ota_chats_b.public_flag%type,
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;

Line 1866: p_chat_id in ota_chats_b.chat_id%type,

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

Line 1867: p_public_flag ota_chats_b.public_flag%type,

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

Line 1868: p_start_date_active in ota_chats_b.start_date_active%type,

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
1870: begin
1871: if p_person_id is not null then
1872: return emp_can_self_enroll_in_chat(p_person_id, p_chat_id, p_public_flag, p_start_date_active, p_category_usage_id);

Line 1881: p_chat_id in ota_chats_b.chat_id%type,

1877:
1878:
1879: function lrn_can_self_enroll_in_chat(
1880: p_user_id in fnd_user.user_id%type,
1881: p_chat_id in ota_chats_b.chat_id%type,
1882: p_public_flag ota_chats_b.public_flag%type,
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:

Line 1882: p_public_flag ota_chats_b.public_flag%type,

1878:
1879: function lrn_can_self_enroll_in_chat(
1880: p_user_id in fnd_user.user_id%type,
1881: p_chat_id in ota_chats_b.chat_id%type,
1882: p_public_flag ota_chats_b.public_flag%type,
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;

Line 1883: p_start_date_active in ota_chats_b.start_date_active%type,

1879: function lrn_can_self_enroll_in_chat(
1880: p_user_id in fnd_user.user_id%type,
1881: p_chat_id in ota_chats_b.chat_id%type,
1882: p_public_flag ota_chats_b.public_flag%type,
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;