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 1241: p_learning_path_id in ota_learning_paths.learning_path_id%type,

1237:
1238:
1239: function emp_has_access_to_path(
1240: p_person_id in per_people_f.person_id%type,
1241: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1242: p_self_enroll_only in varchar2) return varchar2 is
1243:
1244: l_now date := sysdate;
1245: l_category_usage_id ota_category_usages.category_usage_id%type;

Line 1293: p_learning_path_id in ota_learning_paths.learning_path_id%type,

1289:
1290:
1291: function ext_has_access_to_path(
1292: p_party_id in hz_parties.party_id%type,
1293: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1294: p_self_enroll_only in varchar2) return varchar2 is
1295:
1296: l_category_usage_id ota_category_usages.category_usage_id%type;
1297: l_parent_cat_usage_id_1 ota_category_usages.category_usage_id%type;

Line 1328: p_learning_path_id in ota_learning_paths.learning_path_id%type,

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

Line 1329: p_public_flag ota_learning_paths.public_flag%type,

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

Line 1330: p_start_date_active in ota_learning_paths.start_date_active%type,

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

Line 1343: p_learning_path_id in ota_learning_paths.learning_path_id%type,

1339:
1340:
1341: function emp_can_self_enroll_in_path(
1342: p_person_id in per_people_f.person_id%type,
1343: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1344: p_public_flag ota_learning_paths.public_flag%type,
1345: p_start_date_active in ota_learning_paths.start_date_active%type,
1346: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1347: begin

Line 1344: p_public_flag ota_learning_paths.public_flag%type,

1340:
1341: function emp_can_self_enroll_in_path(
1342: p_person_id in per_people_f.person_id%type,
1343: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1344: p_public_flag ota_learning_paths.public_flag%type,
1345: p_start_date_active in ota_learning_paths.start_date_active%type,
1346: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1347: begin
1348: -- A public learning path disregards its learner access records. Learner access records

Line 1345: p_start_date_active in ota_learning_paths.start_date_active%type,

1341: function emp_can_self_enroll_in_path(
1342: p_person_id in per_people_f.person_id%type,
1343: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1344: p_public_flag ota_learning_paths.public_flag%type,
1345: p_start_date_active in ota_learning_paths.start_date_active%type,
1346: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1347: begin
1348: -- A public learning path disregards its learner access records. Learner access records
1349: -- are the only way an event can be made self-enrollable. Therefore, the employee cannot

Line 1361: p_learning_path_id in ota_learning_paths.learning_path_id%type,

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

Line 1362: p_public_flag ota_learning_paths.public_flag%type,

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

Line 1363: p_start_date_active in ota_learning_paths.start_date_active%type,

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

Line 1376: p_learning_path_id in ota_learning_paths.learning_path_id%type,

1372:
1373:
1374: function ext_can_self_enroll_in_path(
1375: p_party_id in hz_parties.party_id%type,
1376: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1377: p_public_flag ota_learning_paths.public_flag%type,
1378: p_start_date_active in ota_learning_paths.start_date_active%type,
1379: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1380: begin

Line 1377: p_public_flag ota_learning_paths.public_flag%type,

1373:
1374: function ext_can_self_enroll_in_path(
1375: p_party_id in hz_parties.party_id%type,
1376: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1377: p_public_flag ota_learning_paths.public_flag%type,
1378: p_start_date_active in ota_learning_paths.start_date_active%type,
1379: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1380: begin
1381: -- A public learning path disregards its learner access records. Learner access records

Line 1378: p_start_date_active in ota_learning_paths.start_date_active%type,

1374: function ext_can_self_enroll_in_path(
1375: p_party_id in hz_parties.party_id%type,
1376: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1377: p_public_flag ota_learning_paths.public_flag%type,
1378: p_start_date_active in ota_learning_paths.start_date_active%type,
1379: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1380: begin
1381: -- A public learning path disregards its learner access records. Learner access records
1382: -- are the only way an event can be made self-enrollable. Therefore, the ext learner cannot

Line 1395: p_learning_path_id in ota_learning_paths.learning_path_id%type,

1391:
1392: function learner_can_enroll_in_path(
1393: p_person_id in per_people_f.person_id%type,
1394: p_party_id in hz_parties.party_id%type,
1395: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1396: p_public_flag ota_learning_paths.public_flag%type,
1397: p_start_date_active in ota_learning_paths.start_date_active%type,
1398: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1399: begin

Line 1396: p_public_flag ota_learning_paths.public_flag%type,

1392: function learner_can_enroll_in_path(
1393: p_person_id in per_people_f.person_id%type,
1394: p_party_id in hz_parties.party_id%type,
1395: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1396: p_public_flag ota_learning_paths.public_flag%type,
1397: p_start_date_active in ota_learning_paths.start_date_active%type,
1398: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1399: begin
1400: if p_person_id is not null then

Line 1397: p_start_date_active in ota_learning_paths.start_date_active%type,

1393: p_person_id in per_people_f.person_id%type,
1394: p_party_id in hz_parties.party_id%type,
1395: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1396: p_public_flag ota_learning_paths.public_flag%type,
1397: p_start_date_active in ota_learning_paths.start_date_active%type,
1398: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1399: begin
1400: if p_person_id is not null then
1401: 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 1410: p_learning_path_id in ota_learning_paths.learning_path_id%type,

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

Line 1411: p_public_flag ota_learning_paths.public_flag%type,

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

Line 1412: p_start_date_active in ota_learning_paths.start_date_active%type,

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
1414:
1415: v_employee_id fnd_user.employee_id%type;
1416: v_party_id hz_parties.party_id%type;

Line 1430: p_learning_path_id in ota_learning_paths.learning_path_id%type,

1426:
1427: function lrn_can_self_enroll_in_path(
1428: p_person_id in per_people_f.person_id%type,
1429: p_party_id in hz_parties.party_id%type,
1430: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1431: p_public_flag ota_learning_paths.public_flag%type,
1432: p_start_date_active in ota_learning_paths.start_date_active%type,
1433: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1434: begin

Line 1431: p_public_flag ota_learning_paths.public_flag%type,

1427: function lrn_can_self_enroll_in_path(
1428: p_person_id in per_people_f.person_id%type,
1429: p_party_id in hz_parties.party_id%type,
1430: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1431: p_public_flag ota_learning_paths.public_flag%type,
1432: p_start_date_active in ota_learning_paths.start_date_active%type,
1433: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1434: begin
1435: if p_person_id is not null then

Line 1432: p_start_date_active in ota_learning_paths.start_date_active%type,

1428: p_person_id in per_people_f.person_id%type,
1429: p_party_id in hz_parties.party_id%type,
1430: p_learning_path_id in ota_learning_paths.learning_path_id%type,
1431: p_public_flag ota_learning_paths.public_flag%type,
1432: p_start_date_active in ota_learning_paths.start_date_active%type,
1433: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1434: begin
1435: if p_person_id is not null then
1436: 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 1445: p_learning_path_id in ota_learning_paths.learning_path_id%type,

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

Line 1446: p_public_flag ota_learning_paths.public_flag%type,

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

Line 1447: p_start_date_active in ota_learning_paths.start_date_active%type,

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
1449:
1450: v_employee_id fnd_user.employee_id%type;
1451: v_party_id hz_parties.party_id%type;

Line 2135: p_learning_path_id in ota_learning_paths.learning_path_id%TYPE

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;
2133:
2134: function learner_can_enroll_in_path(
2135: p_learning_path_id in ota_learning_paths.learning_path_id%TYPE
2136: ,p_person_id in per_all_people_f.person_id%type
2137: ,p_party_id in hz_parties.party_id%type) return varchar2
2138: IS
2139: CURSOR csr_get_lp_details IS

Line 2141: FROM ota_learning_paths

2137: ,p_party_id in hz_parties.party_id%type) return varchar2
2138: IS
2139: CURSOR csr_get_lp_details IS
2140: SELECT public_flag, start_date_active
2141: FROM ota_learning_paths
2142: WHERE learning_path_id = p_learning_path_id;
2143:
2144: l_start_date_active ota_learning_paths.start_date_active%TYPE;
2145: l_public_flag ota_learning_paths.public_flag%TYPE;

Line 2144: l_start_date_active ota_learning_paths.start_date_active%TYPE;

2140: SELECT public_flag, start_date_active
2141: FROM ota_learning_paths
2142: WHERE learning_path_id = p_learning_path_id;
2143:
2144: l_start_date_active ota_learning_paths.start_date_active%TYPE;
2145: l_public_flag ota_learning_paths.public_flag%TYPE;
2146: BEGIN
2147: OPEN csr_get_lp_details;
2148: FETCH csr_get_lp_details INTO l_public_flag, l_start_date_active ;

Line 2145: l_public_flag ota_learning_paths.public_flag%TYPE;

2141: FROM ota_learning_paths
2142: WHERE learning_path_id = p_learning_path_id;
2143:
2144: l_start_date_active ota_learning_paths.start_date_active%TYPE;
2145: l_public_flag ota_learning_paths.public_flag%TYPE;
2146: BEGIN
2147: OPEN csr_get_lp_details;
2148: FETCH csr_get_lp_details INTO l_public_flag, l_start_date_active ;
2149: IF csr_get_lp_details%NOTFOUND THEN