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 1690: p_chat_id in ota_chats_b.chat_id%type,

1686: --functions for chats(open) enrollments
1687:
1688: function emp_has_access_to_chat(
1689: p_person_id in per_people_f.person_id%type,
1690: p_chat_id in ota_chats_b.chat_id%type,
1691: p_self_enroll_only in varchar2) return varchar2 is
1692:
1693: l_now date := sysdate;
1694: l_object_id ota_chat_obj_inclusions.object_id%type;

Line 1742: p_chat_id in ota_chats_b.chat_id%type,

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

Line 1777: p_chat_id in ota_chats_b.chat_id%type,

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

Line 1778: p_public_flag ota_chats_b.public_flag%type,

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

Line 1779: p_start_date_active in ota_chats_b.start_date_active%type,

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

Line 1792: p_chat_id in ota_chats_b.chat_id%type,

1788:
1789:
1790: function emp_can_self_enroll_in_chat(
1791: p_person_id in per_people_f.person_id%type,
1792: p_chat_id in ota_chats_b.chat_id%type,
1793: p_public_flag ota_chats_b.public_flag%type,
1794: p_start_date_active in ota_chats_b.start_date_active%type,
1795: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1796: begin

Line 1793: p_public_flag ota_chats_b.public_flag%type,

1789:
1790: function emp_can_self_enroll_in_chat(
1791: p_person_id in per_people_f.person_id%type,
1792: p_chat_id in ota_chats_b.chat_id%type,
1793: p_public_flag ota_chats_b.public_flag%type,
1794: p_start_date_active in ota_chats_b.start_date_active%type,
1795: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1796: begin
1797: -- A public chat disregards its learner access records. Learner access records

Line 1794: p_start_date_active in ota_chats_b.start_date_active%type,

1790: function emp_can_self_enroll_in_chat(
1791: p_person_id in per_people_f.person_id%type,
1792: p_chat_id in ota_chats_b.chat_id%type,
1793: p_public_flag ota_chats_b.public_flag%type,
1794: p_start_date_active in ota_chats_b.start_date_active%type,
1795: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1796: begin
1797: -- A public chat disregards its learner access records. Learner access records
1798: -- are the only way an event can be made self-enrollable. Therefore, the employee cannot

Line 1810: p_chat_id in ota_chats_b.chat_id%type,

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

Line 1811: p_public_flag ota_chats_b.public_flag%type,

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

Line 1812: p_start_date_active in ota_chats_b.start_date_active%type,

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
1814: begin
1815: if p_public_flag = 'Y' then
1816: return 'Y';

Line 1825: p_chat_id in ota_chats_b.chat_id%type,

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

Line 1826: p_public_flag ota_chats_b.public_flag%type,

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

Line 1827: p_start_date_active in ota_chats_b.start_date_active%type,

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

Line 1844: p_chat_id in ota_chats_b.chat_id%type,

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

Line 1845: p_public_flag ota_chats_b.public_flag%type,

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

Line 1846: p_start_date_active in ota_chats_b.start_date_active%type,

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

Line 1859: p_chat_id in ota_chats_b.chat_id%type,

1855:
1856:
1857: function learner_can_enroll_in_chat(
1858: p_user_id in fnd_user.user_id%type,
1859: p_chat_id in ota_chats_b.chat_id%type,
1860: p_public_flag ota_chats_b.public_flag%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:

Line 1860: p_public_flag ota_chats_b.public_flag%type,

1856:
1857: function learner_can_enroll_in_chat(
1858: p_user_id in fnd_user.user_id%type,
1859: p_chat_id in ota_chats_b.chat_id%type,
1860: p_public_flag ota_chats_b.public_flag%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;

Line 1861: p_start_date_active in ota_chats_b.start_date_active%type,

1857: function learner_can_enroll_in_chat(
1858: p_user_id in fnd_user.user_id%type,
1859: p_chat_id in ota_chats_b.chat_id%type,
1860: p_public_flag ota_chats_b.public_flag%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;

Line 1879: p_chat_id in ota_chats_b.chat_id%type,

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

Line 1880: p_public_flag ota_chats_b.public_flag%type,

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

Line 1881: p_start_date_active in ota_chats_b.start_date_active%type,

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
1883: begin
1884: if p_person_id is not null then
1885: 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 1894: p_chat_id in ota_chats_b.chat_id%type,

1890:
1891:
1892: function lrn_can_self_enroll_in_chat(
1893: p_user_id in fnd_user.user_id%type,
1894: p_chat_id in ota_chats_b.chat_id%type,
1895: p_public_flag ota_chats_b.public_flag%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:

Line 1895: p_public_flag ota_chats_b.public_flag%type,

1891:
1892: function lrn_can_self_enroll_in_chat(
1893: p_user_id in fnd_user.user_id%type,
1894: p_chat_id in ota_chats_b.chat_id%type,
1895: p_public_flag ota_chats_b.public_flag%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;

Line 1896: p_start_date_active in ota_chats_b.start_date_active%type,

1892: function lrn_can_self_enroll_in_chat(
1893: p_user_id in fnd_user.user_id%type,
1894: p_chat_id in ota_chats_b.chat_id%type,
1895: p_public_flag ota_chats_b.public_flag%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;