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 FND_USER

Line 1396: p_user_id in fnd_user.user_id%type,

1392: end learner_can_enroll_in_path;
1393:
1394:
1395: function learner_can_enroll_in_path(
1396: p_user_id in fnd_user.user_id%type,
1397: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1398: p_public_flag ota_learning_paths.public_flag%type,
1399: p_start_date_active in ota_learning_paths.start_date_active%type,
1400: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is

Line 1402: v_employee_id fnd_user.employee_id%type;

1398: p_public_flag ota_learning_paths.public_flag%type,
1399: p_start_date_active in ota_learning_paths.start_date_active%type,
1400: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1401:
1402: v_employee_id fnd_user.employee_id%type;
1403: v_party_id hz_parties.party_id%type;
1404: begin
1405: select employee_id, person_party_id
1406: into v_employee_id, v_party_id

Line 1407: from fnd_user

1403: v_party_id hz_parties.party_id%type;
1404: begin
1405: select employee_id, person_party_id
1406: into v_employee_id, v_party_id
1407: from fnd_user
1408: where user_id = p_user_id;
1409:
1410: 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);
1411: end learner_can_enroll_in_path;

Line 1431: p_user_id in fnd_user.user_id%type,

1427: end lrn_can_self_enroll_in_path;
1428:
1429:
1430: function lrn_can_self_enroll_in_path(
1431: p_user_id in fnd_user.user_id%type,
1432: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1433: p_public_flag ota_learning_paths.public_flag%type,
1434: p_start_date_active in ota_learning_paths.start_date_active%type,
1435: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is

Line 1437: v_employee_id fnd_user.employee_id%type;

1433: p_public_flag ota_learning_paths.public_flag%type,
1434: p_start_date_active in ota_learning_paths.start_date_active%type,
1435: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1436:
1437: v_employee_id fnd_user.employee_id%type;
1438: v_party_id hz_parties.party_id%type;
1439: begin
1440: select employee_id, person_party_id
1441: into v_employee_id, v_party_id

Line 1442: from fnd_user

1438: v_party_id hz_parties.party_id%type;
1439: begin
1440: select employee_id, person_party_id
1441: into v_employee_id, v_party_id
1442: from fnd_user
1443: where user_id = p_user_id;
1444:
1445: 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);
1446: end lrn_can_self_enroll_in_path;

Line 1620: p_user_id in fnd_user.user_id%type,

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

Line 1626: v_employee_id fnd_user.employee_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;
1628: begin
1629: select employee_id, person_party_id
1630: into v_employee_id, v_party_id

Line 1631: from fnd_user

1627: v_party_id hz_parties.party_id%type;
1628: begin
1629: select employee_id, person_party_id
1630: into v_employee_id, v_party_id
1631: from fnd_user
1632: where user_id = p_user_id;
1633:
1634: 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);
1635: end learner_can_enroll_in_forum;

Line 1655: p_user_id in fnd_user.user_id%type,

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

Line 1661: v_employee_id fnd_user.employee_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;
1663: begin
1664: select employee_id, person_party_id
1665: into v_employee_id, v_party_id

Line 1666: from fnd_user

1662: v_party_id hz_parties.party_id%type;
1663: begin
1664: select employee_id, person_party_id
1665: into v_employee_id, v_party_id
1666: from fnd_user
1667: where user_id = p_user_id;
1668:
1669: 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);
1670: end lrn_can_self_enroll_in_forum;

Line 1845: p_user_id in fnd_user.user_id%type,

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

Line 1851: v_employee_id fnd_user.employee_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;
1853: begin
1854: select employee_id, person_party_id
1855: into v_employee_id, v_party_id

Line 1856: from fnd_user

1852: v_party_id hz_parties.party_id%type;
1853: begin
1854: select employee_id, person_party_id
1855: into v_employee_id, v_party_id
1856: from fnd_user
1857: where user_id = p_user_id;
1858:
1859: 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);
1860: end learner_can_enroll_in_chat;

Line 1880: p_user_id in fnd_user.user_id%type,

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

Line 1886: v_employee_id fnd_user.employee_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;
1888: begin
1889: select employee_id, person_party_id
1890: into v_employee_id, v_party_id

Line 1891: from fnd_user

1887: v_party_id hz_parties.party_id%type;
1888: begin
1889: select employee_id, person_party_id
1890: into v_employee_id, v_party_id
1891: from fnd_user
1892: where user_id = p_user_id;
1893:
1894: 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);
1895: end lrn_can_self_enroll_in_chat;

Line 2069: p_user_id in fnd_user.user_id%type,

2065: end learner_can_enroll_in_cert;
2066:
2067:
2068: function learner_can_enroll_in_cert(
2069: p_user_id in fnd_user.user_id%type,
2070: p_certification_id in ota_certifications_b.certification_id%type,
2071: p_public_flag ota_certifications_b.public_flag%type,
2072: p_start_date_active in ota_certifications_b.start_date_active%type,
2073: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is

Line 2075: v_employee_id fnd_user.employee_id%type;

2071: p_public_flag ota_certifications_b.public_flag%type,
2072: p_start_date_active in ota_certifications_b.start_date_active%type,
2073: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2074:
2075: v_employee_id fnd_user.employee_id%type;
2076: v_party_id hz_parties.party_id%type;
2077: begin
2078: select employee_id, person_party_id
2079: into v_employee_id, v_party_id

Line 2080: from fnd_user

2076: v_party_id hz_parties.party_id%type;
2077: begin
2078: select employee_id, person_party_id
2079: into v_employee_id, v_party_id
2080: from fnd_user
2081: where user_id = p_user_id;
2082:
2083: 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);
2084: end learner_can_enroll_in_cert;

Line 2104: p_user_id in fnd_user.user_id%type,

2100: end lrn_can_self_enroll_in_cert;
2101:
2102:
2103: function lrn_can_self_enroll_in_cert(
2104: p_user_id in fnd_user.user_id%type,
2105: p_certification_id in ota_certifications_b.certification_id%type,
2106: p_public_flag ota_certifications_b.public_flag%type,
2107: p_start_date_active in ota_certifications_b.start_date_active%type,
2108: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is

Line 2110: v_employee_id fnd_user.employee_id%type;

2106: p_public_flag ota_certifications_b.public_flag%type,
2107: p_start_date_active in ota_certifications_b.start_date_active%type,
2108: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2109:
2110: v_employee_id fnd_user.employee_id%type;
2111: v_party_id hz_parties.party_id%type;
2112: begin
2113: select employee_id, person_party_id
2114: into v_employee_id, v_party_id

Line 2115: from fnd_user

2111: v_party_id hz_parties.party_id%type;
2112: begin
2113: select employee_id, person_party_id
2114: into v_employee_id, v_party_id
2115: from fnd_user
2116: where user_id = p_user_id;
2117:
2118: 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);
2119: end lrn_can_self_enroll_in_cert;