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.

[Home] [Help]

APPS.OTA_LEARNER_ACCESS_UTIL dependencies on FND_USER

Line 798: p_user_id fnd_user.user_id%type,

794:
795:
796: --Checks whether user enrolled for the class or not
797: function is_user_enrolled(
798: p_user_id fnd_user.user_id%type,
799: p_event_id ota_events.event_id%type
800: ) return boolean is
801:
802: cursor person_bookings(

Line 1409: p_user_id in fnd_user.user_id%type,

1405: end learner_can_enroll_in_path;
1406:
1407:
1408: function learner_can_enroll_in_path(
1409: p_user_id in fnd_user.user_id%type,
1410: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1411: p_public_flag ota_learning_paths.public_flag%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

Line 1415: v_employee_id fnd_user.employee_id%type;

1411: p_public_flag ota_learning_paths.public_flag%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

Line 1420: from fnd_user

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
1421: where user_id = p_user_id;
1422:
1423: return learner_can_enroll_in_path(v_employee_id, v_party_id, p_learning_path_id, p_public_flag, p_start_date_active, p_category_usage_id);
1424: end learner_can_enroll_in_path;

Line 1444: p_user_id in fnd_user.user_id%type,

1440: end lrn_can_self_enroll_in_path;
1441:
1442:
1443: function lrn_can_self_enroll_in_path(
1444: p_user_id in fnd_user.user_id%type,
1445: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1446: p_public_flag ota_learning_paths.public_flag%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

Line 1450: v_employee_id fnd_user.employee_id%type;

1446: p_public_flag ota_learning_paths.public_flag%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

Line 1455: from fnd_user

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
1456: where user_id = p_user_id;
1457:
1458: return lrn_can_self_enroll_in_path(v_employee_id, v_party_id, p_learning_path_id, p_public_flag, p_start_date_active, p_category_usage_id);
1459: end lrn_can_self_enroll_in_path;

Line 1633: p_user_id in fnd_user.user_id%type,

1629: end learner_can_enroll_in_forum;
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

Line 1639: v_employee_id fnd_user.employee_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;
1641: begin
1642: select employee_id, person_party_id
1643: into v_employee_id, v_party_id

Line 1644: from fnd_user

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
1645: where user_id = p_user_id;
1646:
1647: return learner_can_enroll_in_forum(v_employee_id, v_party_id, p_forum_id, p_public_flag, p_start_date_active, p_category_usage_id);
1648: end learner_can_enroll_in_forum;

Line 1668: p_user_id in fnd_user.user_id%type,

1664: end lrn_can_self_enroll_in_forum;
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

Line 1674: v_employee_id fnd_user.employee_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;
1676: begin
1677: select employee_id, person_party_id
1678: into v_employee_id, v_party_id

Line 1679: from fnd_user

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
1680: where user_id = p_user_id;
1681:
1682: return lrn_can_self_enroll_in_forum(v_employee_id, v_party_id, p_forum_id, p_public_flag, p_start_date_active, p_category_usage_id);
1683: end lrn_can_self_enroll_in_forum;

Line 1858: p_user_id in fnd_user.user_id%type,

1854: end learner_can_enroll_in_chat;
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

Line 1864: v_employee_id fnd_user.employee_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;
1866: begin
1867: select employee_id, person_party_id
1868: into v_employee_id, v_party_id

Line 1869: from fnd_user

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
1870: where user_id = p_user_id;
1871:
1872: return learner_can_enroll_in_chat(v_employee_id, v_party_id, p_chat_id, p_public_flag, p_start_date_active, p_category_usage_id);
1873: end learner_can_enroll_in_chat;

Line 1893: p_user_id in fnd_user.user_id%type,

1889: end lrn_can_self_enroll_in_chat;
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

Line 1899: v_employee_id fnd_user.employee_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;
1901: begin
1902: select employee_id, person_party_id
1903: into v_employee_id, v_party_id

Line 1904: from fnd_user

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
1905: where user_id = p_user_id;
1906:
1907: return lrn_can_self_enroll_in_chat(v_employee_id, v_party_id, p_chat_id, p_public_flag, p_start_date_active, p_category_usage_id);
1908: end lrn_can_self_enroll_in_chat;

Line 2082: p_user_id in fnd_user.user_id%type,

2078: end learner_can_enroll_in_cert;
2079:
2080:
2081: function learner_can_enroll_in_cert(
2082: p_user_id in fnd_user.user_id%type,
2083: p_certification_id in ota_certifications_b.certification_id%type,
2084: p_public_flag ota_certifications_b.public_flag%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

Line 2088: v_employee_id fnd_user.employee_id%type;

2084: p_public_flag ota_certifications_b.public_flag%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

Line 2093: from fnd_user

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
2094: where user_id = p_user_id;
2095:
2096: return learner_can_enroll_in_cert(v_employee_id, v_party_id, p_certification_id, p_public_flag, p_start_date_active, p_category_usage_id);
2097: end learner_can_enroll_in_cert;

Line 2117: p_user_id in fnd_user.user_id%type,

2113: end lrn_can_self_enroll_in_cert;
2114:
2115:
2116: function lrn_can_self_enroll_in_cert(
2117: p_user_id in fnd_user.user_id%type,
2118: p_certification_id in ota_certifications_b.certification_id%type,
2119: p_public_flag ota_certifications_b.public_flag%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

Line 2123: v_employee_id fnd_user.employee_id%type;

2119: p_public_flag ota_certifications_b.public_flag%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

Line 2128: from fnd_user

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
2129: where user_id = p_user_id;
2130:
2131: return lrn_can_self_enroll_in_cert(v_employee_id, v_party_id, p_certification_id, p_public_flag, p_start_date_active, p_category_usage_id);
2132: end lrn_can_self_enroll_in_cert;