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_LEARNING_PATHS

Line 32: p_learning_path_id ota_learning_paths.learning_path_id%type) is

28: c3.parent_cat_usage_id = c4.category_usage_id(+);
29:
30:
31: cursor csr_lp_tree(
32: p_learning_path_id ota_learning_paths.learning_path_id%type) is
33: select i.category_usage_id,
34: c1.parent_cat_usage_id as parent_cat_usage_id_1,
35: c2.parent_cat_usage_id as parent_cat_usage_id_2,
36: c3.parent_cat_usage_id as parent_cat_usage_id_3,

Line 245: p_learning_path_id in ota_learning_paths.learning_path_id%type,

241:
242:
243: cursor csr_lp_assoc(
244: p_self_enroll_only varchar2,
245: p_learning_path_id in ota_learning_paths.learning_path_id%type,
246: p_category_usage_id ota_category_usages.category_usage_id%type,
247: p_parent_cat_usage_id_1 ota_category_usages.category_usage_id%type,
248: p_parent_cat_usage_id_2 ota_category_usages.category_usage_id%type,
249: p_parent_cat_usage_id_3 ota_category_usages.category_usage_id%type,

Line 264: p_learning_path_id in ota_learning_paths.learning_path_id%type,

260:
261: cursor csr_lp_assoc_ext(
262: p_self_enroll_only varchar2,
263: p_party_id hz_parties.party_id%type,
264: p_learning_path_id in ota_learning_paths.learning_path_id%type,
265: p_category_usage_id ota_category_usages.category_usage_id%type,
266: p_parent_cat_usage_id_1 ota_category_usages.category_usage_id%type,
267: p_parent_cat_usage_id_2 ota_category_usages.category_usage_id%type,
268: p_parent_cat_usage_id_3 ota_category_usages.category_usage_id%type,

Line 1228: p_learning_path_id in ota_learning_paths.learning_path_id%type,

1224:
1225:
1226: function emp_has_access_to_path(
1227: p_person_id in per_people_f.person_id%type,
1228: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1229: p_self_enroll_only in varchar2) return varchar2 is
1230:
1231: l_now date := sysdate;
1232: l_category_usage_id ota_category_usages.category_usage_id%type;

Line 1280: p_learning_path_id in ota_learning_paths.learning_path_id%type,

1276:
1277:
1278: function ext_has_access_to_path(
1279: p_party_id in hz_parties.party_id%type,
1280: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1281: p_self_enroll_only in varchar2) return varchar2 is
1282:
1283: l_category_usage_id ota_category_usages.category_usage_id%type;
1284: l_parent_cat_usage_id_1 ota_category_usages.category_usage_id%type;

Line 1315: p_learning_path_id in ota_learning_paths.learning_path_id%type,

1311:
1312:
1313: function emp_can_enroll_in_path(
1314: p_person_id in per_people_f.person_id%type,
1315: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1316: p_public_flag ota_learning_paths.public_flag%type,
1317: p_start_date_active in ota_learning_paths.start_date_active%type,
1318: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1319: begin

Line 1316: p_public_flag ota_learning_paths.public_flag%type,

1312:
1313: function emp_can_enroll_in_path(
1314: p_person_id in per_people_f.person_id%type,
1315: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1316: p_public_flag ota_learning_paths.public_flag%type,
1317: p_start_date_active in ota_learning_paths.start_date_active%type,
1318: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1319: begin
1320: if p_public_flag = 'Y' then

Line 1317: p_start_date_active in ota_learning_paths.start_date_active%type,

1313: function emp_can_enroll_in_path(
1314: p_person_id in per_people_f.person_id%type,
1315: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1316: p_public_flag ota_learning_paths.public_flag%type,
1317: p_start_date_active in ota_learning_paths.start_date_active%type,
1318: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1319: begin
1320: if p_public_flag = 'Y' then
1321: return 'Y';

Line 1330: p_learning_path_id in ota_learning_paths.learning_path_id%type,

1326:
1327:
1328: function emp_can_self_enroll_in_path(
1329: p_person_id in per_people_f.person_id%type,
1330: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1331: p_public_flag ota_learning_paths.public_flag%type,
1332: p_start_date_active in ota_learning_paths.start_date_active%type,
1333: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1334: begin

Line 1331: p_public_flag ota_learning_paths.public_flag%type,

1327:
1328: function emp_can_self_enroll_in_path(
1329: p_person_id in per_people_f.person_id%type,
1330: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1331: p_public_flag ota_learning_paths.public_flag%type,
1332: p_start_date_active in ota_learning_paths.start_date_active%type,
1333: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1334: begin
1335: -- A public learning path disregards its learner access records. Learner access records

Line 1332: p_start_date_active in ota_learning_paths.start_date_active%type,

1328: function emp_can_self_enroll_in_path(
1329: p_person_id in per_people_f.person_id%type,
1330: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1331: p_public_flag ota_learning_paths.public_flag%type,
1332: p_start_date_active in ota_learning_paths.start_date_active%type,
1333: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1334: begin
1335: -- A public learning path disregards its learner access records. Learner access records
1336: -- are the only way an event can be made self-enrollable. Therefore, the employee cannot

Line 1348: p_learning_path_id in ota_learning_paths.learning_path_id%type,

1344:
1345:
1346: function ext_can_enroll_in_path(
1347: p_party_id in hz_parties.party_id%type,
1348: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1349: p_public_flag ota_learning_paths.public_flag%type,
1350: p_start_date_active in ota_learning_paths.start_date_active%type,
1351: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1352: begin

Line 1349: p_public_flag ota_learning_paths.public_flag%type,

1345:
1346: function ext_can_enroll_in_path(
1347: p_party_id in hz_parties.party_id%type,
1348: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1349: p_public_flag ota_learning_paths.public_flag%type,
1350: p_start_date_active in ota_learning_paths.start_date_active%type,
1351: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1352: begin
1353: if p_public_flag = 'Y' then

Line 1350: p_start_date_active in ota_learning_paths.start_date_active%type,

1346: function ext_can_enroll_in_path(
1347: p_party_id in hz_parties.party_id%type,
1348: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1349: p_public_flag ota_learning_paths.public_flag%type,
1350: p_start_date_active in ota_learning_paths.start_date_active%type,
1351: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1352: begin
1353: if p_public_flag = 'Y' then
1354: return 'Y';

Line 1363: p_learning_path_id in ota_learning_paths.learning_path_id%type,

1359:
1360:
1361: function ext_can_self_enroll_in_path(
1362: p_party_id in hz_parties.party_id%type,
1363: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1364: p_public_flag ota_learning_paths.public_flag%type,
1365: p_start_date_active in ota_learning_paths.start_date_active%type,
1366: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1367: begin

Line 1364: p_public_flag ota_learning_paths.public_flag%type,

1360:
1361: function ext_can_self_enroll_in_path(
1362: p_party_id in hz_parties.party_id%type,
1363: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1364: p_public_flag ota_learning_paths.public_flag%type,
1365: p_start_date_active in ota_learning_paths.start_date_active%type,
1366: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1367: begin
1368: -- A public learning path disregards its learner access records. Learner access records

Line 1365: p_start_date_active in ota_learning_paths.start_date_active%type,

1361: function ext_can_self_enroll_in_path(
1362: p_party_id in hz_parties.party_id%type,
1363: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1364: p_public_flag ota_learning_paths.public_flag%type,
1365: p_start_date_active in ota_learning_paths.start_date_active%type,
1366: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1367: begin
1368: -- A public learning path disregards its learner access records. Learner access records
1369: -- are the only way an event can be made self-enrollable. Therefore, the ext learner cannot

Line 1382: p_learning_path_id in ota_learning_paths.learning_path_id%type,

1378:
1379: function learner_can_enroll_in_path(
1380: p_person_id in per_people_f.person_id%type,
1381: p_party_id in hz_parties.party_id%type,
1382: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1383: p_public_flag ota_learning_paths.public_flag%type,
1384: p_start_date_active in ota_learning_paths.start_date_active%type,
1385: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1386: begin

Line 1383: p_public_flag ota_learning_paths.public_flag%type,

1379: function learner_can_enroll_in_path(
1380: p_person_id in per_people_f.person_id%type,
1381: p_party_id in hz_parties.party_id%type,
1382: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1383: p_public_flag ota_learning_paths.public_flag%type,
1384: p_start_date_active in ota_learning_paths.start_date_active%type,
1385: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1386: begin
1387: if p_person_id is not null then

Line 1384: p_start_date_active in ota_learning_paths.start_date_active%type,

1380: p_person_id in per_people_f.person_id%type,
1381: p_party_id in hz_parties.party_id%type,
1382: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1383: p_public_flag ota_learning_paths.public_flag%type,
1384: p_start_date_active in ota_learning_paths.start_date_active%type,
1385: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1386: begin
1387: if p_person_id is not null then
1388: return emp_can_enroll_in_path(p_person_id, p_learning_path_id, p_public_flag, p_start_date_active, p_category_usage_id);

Line 1397: p_learning_path_id in ota_learning_paths.learning_path_id%type,

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
1401:

Line 1398: p_public_flag ota_learning_paths.public_flag%type,

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
1401:
1402: v_employee_id fnd_user.employee_id%type;

Line 1399: p_start_date_active in ota_learning_paths.start_date_active%type,

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
1401:
1402: v_employee_id fnd_user.employee_id%type;
1403: v_party_id hz_parties.party_id%type;

Line 1417: p_learning_path_id in ota_learning_paths.learning_path_id%type,

1413:
1414: function lrn_can_self_enroll_in_path(
1415: p_person_id in per_people_f.person_id%type,
1416: p_party_id in hz_parties.party_id%type,
1417: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1418: p_public_flag ota_learning_paths.public_flag%type,
1419: p_start_date_active in ota_learning_paths.start_date_active%type,
1420: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1421: begin

Line 1418: p_public_flag ota_learning_paths.public_flag%type,

1414: function lrn_can_self_enroll_in_path(
1415: p_person_id in per_people_f.person_id%type,
1416: p_party_id in hz_parties.party_id%type,
1417: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1418: p_public_flag ota_learning_paths.public_flag%type,
1419: p_start_date_active in ota_learning_paths.start_date_active%type,
1420: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1421: begin
1422: if p_person_id is not null then

Line 1419: p_start_date_active in ota_learning_paths.start_date_active%type,

1415: p_person_id in per_people_f.person_id%type,
1416: p_party_id in hz_parties.party_id%type,
1417: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1418: p_public_flag ota_learning_paths.public_flag%type,
1419: p_start_date_active in ota_learning_paths.start_date_active%type,
1420: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1421: begin
1422: if p_person_id is not null then
1423: return emp_can_self_enroll_in_path(p_person_id, p_learning_path_id, p_public_flag, p_start_date_active, p_category_usage_id);

Line 1432: p_learning_path_id in ota_learning_paths.learning_path_id%type,

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
1436:

Line 1433: p_public_flag ota_learning_paths.public_flag%type,

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
1436:
1437: v_employee_id fnd_user.employee_id%type;

Line 1434: p_start_date_active in ota_learning_paths.start_date_active%type,

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
1436:
1437: v_employee_id fnd_user.employee_id%type;
1438: v_party_id hz_parties.party_id%type;

Line 2122: p_learning_path_id in ota_learning_paths.learning_path_id%TYPE

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;
2120:
2121: function learner_can_enroll_in_path(
2122: p_learning_path_id in ota_learning_paths.learning_path_id%TYPE
2123: ,p_person_id in per_all_people_f.person_id%type
2124: ,p_party_id in hz_parties.party_id%type) return varchar2
2125: IS
2126: CURSOR csr_get_lp_details IS

Line 2128: FROM ota_learning_paths

2124: ,p_party_id in hz_parties.party_id%type) return varchar2
2125: IS
2126: CURSOR csr_get_lp_details IS
2127: SELECT public_flag, start_date_active
2128: FROM ota_learning_paths
2129: WHERE learning_path_id = p_learning_path_id;
2130:
2131: l_start_date_active ota_learning_paths.start_date_active%TYPE;
2132: l_public_flag ota_learning_paths.public_flag%TYPE;

Line 2131: l_start_date_active ota_learning_paths.start_date_active%TYPE;

2127: SELECT public_flag, start_date_active
2128: FROM ota_learning_paths
2129: WHERE learning_path_id = p_learning_path_id;
2130:
2131: l_start_date_active ota_learning_paths.start_date_active%TYPE;
2132: l_public_flag ota_learning_paths.public_flag%TYPE;
2133: BEGIN
2134: OPEN csr_get_lp_details;
2135: FETCH csr_get_lp_details INTO l_public_flag, l_start_date_active ;

Line 2132: l_public_flag ota_learning_paths.public_flag%TYPE;

2128: FROM ota_learning_paths
2129: WHERE learning_path_id = p_learning_path_id;
2130:
2131: l_start_date_active ota_learning_paths.start_date_active%TYPE;
2132: l_public_flag ota_learning_paths.public_flag%TYPE;
2133: BEGIN
2134: OPEN csr_get_lp_details;
2135: FETCH csr_get_lp_details INTO l_public_flag, l_start_date_active ;
2136: IF csr_get_lp_details%NOTFOUND THEN