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_CERTIFICATIONS_B

Line 282: p_certification_id in ota_certifications_b.certification_id%type,

278:
279: function learner_can_enroll_in_cert(
280: p_person_id in per_people_f.person_id%type,
281: p_party_id in hz_parties.party_id%type,
282: p_certification_id in ota_certifications_b.certification_id%type,
283: p_public_flag ota_certifications_b.public_flag%type,
284: p_start_date_active in ota_certifications_b.start_date_active%type,
285: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
286:

Line 283: p_public_flag ota_certifications_b.public_flag%type,

279: function learner_can_enroll_in_cert(
280: p_person_id in per_people_f.person_id%type,
281: p_party_id in hz_parties.party_id%type,
282: p_certification_id in ota_certifications_b.certification_id%type,
283: p_public_flag ota_certifications_b.public_flag%type,
284: p_start_date_active in ota_certifications_b.start_date_active%type,
285: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
286:
287:

Line 284: p_start_date_active in ota_certifications_b.start_date_active%type,

280: p_person_id in per_people_f.person_id%type,
281: p_party_id in hz_parties.party_id%type,
282: p_certification_id in ota_certifications_b.certification_id%type,
283: p_public_flag ota_certifications_b.public_flag%type,
284: p_start_date_active in ota_certifications_b.start_date_active%type,
285: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
286:
287:
288: function learner_can_enroll_in_cert(

Line 290: p_certification_id in ota_certifications_b.certification_id%type,

286:
287:
288: function learner_can_enroll_in_cert(
289: p_user_id in fnd_user.user_id%type,
290: p_certification_id in ota_certifications_b.certification_id%type,
291: p_public_flag ota_certifications_b.public_flag%type,
292: p_start_date_active in ota_certifications_b.start_date_active%type,
293: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
294:

Line 291: p_public_flag ota_certifications_b.public_flag%type,

287:
288: function learner_can_enroll_in_cert(
289: p_user_id in fnd_user.user_id%type,
290: p_certification_id in ota_certifications_b.certification_id%type,
291: p_public_flag ota_certifications_b.public_flag%type,
292: p_start_date_active in ota_certifications_b.start_date_active%type,
293: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
294:
295:

Line 292: p_start_date_active in ota_certifications_b.start_date_active%type,

288: function learner_can_enroll_in_cert(
289: p_user_id in fnd_user.user_id%type,
290: p_certification_id in ota_certifications_b.certification_id%type,
291: p_public_flag ota_certifications_b.public_flag%type,
292: p_start_date_active in ota_certifications_b.start_date_active%type,
293: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
294:
295:
296: function emp_can_enroll_in_cert(

Line 298: p_certification_id in ota_certifications_b.certification_id%type,

294:
295:
296: function emp_can_enroll_in_cert(
297: p_person_id in per_people_f.person_id%type,
298: p_certification_id in ota_certifications_b.certification_id%type,
299: p_public_flag ota_certifications_b.public_flag%type,
300: p_start_date_active in ota_certifications_b.start_date_active%type,
301: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
302:

Line 299: p_public_flag ota_certifications_b.public_flag%type,

295:
296: function emp_can_enroll_in_cert(
297: p_person_id in per_people_f.person_id%type,
298: p_certification_id in ota_certifications_b.certification_id%type,
299: p_public_flag ota_certifications_b.public_flag%type,
300: p_start_date_active in ota_certifications_b.start_date_active%type,
301: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
302:
303:

Line 300: p_start_date_active in ota_certifications_b.start_date_active%type,

296: function emp_can_enroll_in_cert(
297: p_person_id in per_people_f.person_id%type,
298: p_certification_id in ota_certifications_b.certification_id%type,
299: p_public_flag ota_certifications_b.public_flag%type,
300: p_start_date_active in ota_certifications_b.start_date_active%type,
301: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
302:
303:
304: function ext_can_enroll_in_cert(

Line 306: p_certification_id in ota_certifications_b.certification_id%type,

302:
303:
304: function ext_can_enroll_in_cert(
305: p_party_id in hz_parties.party_id%type,
306: p_certification_id in ota_certifications_b.certification_id%type,
307: p_public_flag ota_certifications_b.public_flag%type,
308: p_start_date_active in ota_certifications_b.start_date_active%type,
309: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
310:

Line 307: p_public_flag ota_certifications_b.public_flag%type,

303:
304: function ext_can_enroll_in_cert(
305: p_party_id in hz_parties.party_id%type,
306: p_certification_id in ota_certifications_b.certification_id%type,
307: p_public_flag ota_certifications_b.public_flag%type,
308: p_start_date_active in ota_certifications_b.start_date_active%type,
309: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
310:
311:

Line 308: p_start_date_active in ota_certifications_b.start_date_active%type,

304: function ext_can_enroll_in_cert(
305: p_party_id in hz_parties.party_id%type,
306: p_certification_id in ota_certifications_b.certification_id%type,
307: p_public_flag ota_certifications_b.public_flag%type,
308: p_start_date_active in ota_certifications_b.start_date_active%type,
309: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
310:
311:
312: function lrn_can_self_enroll_in_cert(

Line 315: p_certification_id in ota_certifications_b.certification_id%type,

311:
312: function lrn_can_self_enroll_in_cert(
313: p_person_id in per_people_f.person_id%type,
314: p_party_id in hz_parties.party_id%type,
315: p_certification_id in ota_certifications_b.certification_id%type,
316: p_public_flag ota_certifications_b.public_flag%type,
317: p_start_date_active in ota_certifications_b.start_date_active%type,
318: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
319:

Line 316: p_public_flag ota_certifications_b.public_flag%type,

312: function lrn_can_self_enroll_in_cert(
313: p_person_id in per_people_f.person_id%type,
314: p_party_id in hz_parties.party_id%type,
315: p_certification_id in ota_certifications_b.certification_id%type,
316: p_public_flag ota_certifications_b.public_flag%type,
317: p_start_date_active in ota_certifications_b.start_date_active%type,
318: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
319:
320:

Line 317: p_start_date_active in ota_certifications_b.start_date_active%type,

313: p_person_id in per_people_f.person_id%type,
314: p_party_id in hz_parties.party_id%type,
315: p_certification_id in ota_certifications_b.certification_id%type,
316: p_public_flag ota_certifications_b.public_flag%type,
317: p_start_date_active in ota_certifications_b.start_date_active%type,
318: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
319:
320:
321: function emp_can_self_enroll_in_cert(

Line 323: p_certification_id in ota_certifications_b.certification_id%type,

319:
320:
321: function emp_can_self_enroll_in_cert(
322: p_person_id in per_people_f.person_id%type,
323: p_certification_id in ota_certifications_b.certification_id%type,
324: p_public_flag ota_certifications_b.public_flag%type,
325: p_start_date_active in ota_certifications_b.start_date_active%type,
326: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
327:

Line 324: p_public_flag ota_certifications_b.public_flag%type,

320:
321: function emp_can_self_enroll_in_cert(
322: p_person_id in per_people_f.person_id%type,
323: p_certification_id in ota_certifications_b.certification_id%type,
324: p_public_flag ota_certifications_b.public_flag%type,
325: p_start_date_active in ota_certifications_b.start_date_active%type,
326: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
327:
328:

Line 325: p_start_date_active in ota_certifications_b.start_date_active%type,

321: function emp_can_self_enroll_in_cert(
322: p_person_id in per_people_f.person_id%type,
323: p_certification_id in ota_certifications_b.certification_id%type,
324: p_public_flag ota_certifications_b.public_flag%type,
325: p_start_date_active in ota_certifications_b.start_date_active%type,
326: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
327:
328:
329: function ext_can_self_enroll_in_cert(

Line 331: p_certification_id in ota_certifications_b.certification_id%type,

327:
328:
329: function ext_can_self_enroll_in_cert(
330: p_party_id in hz_parties.party_id%type,
331: p_certification_id in ota_certifications_b.certification_id%type,
332: p_public_flag ota_certifications_b.public_flag%type,
333: p_start_date_active in ota_certifications_b.start_date_active%type,
334: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
335:

Line 332: p_public_flag ota_certifications_b.public_flag%type,

328:
329: function ext_can_self_enroll_in_cert(
330: p_party_id in hz_parties.party_id%type,
331: p_certification_id in ota_certifications_b.certification_id%type,
332: p_public_flag ota_certifications_b.public_flag%type,
333: p_start_date_active in ota_certifications_b.start_date_active%type,
334: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
335:
336: function learner_can_enroll_in_path(

Line 333: p_start_date_active in ota_certifications_b.start_date_active%type,

329: function ext_can_self_enroll_in_cert(
330: p_party_id in hz_parties.party_id%type,
331: p_certification_id in ota_certifications_b.certification_id%type,
332: p_public_flag ota_certifications_b.public_flag%type,
333: p_start_date_active in ota_certifications_b.start_date_active%type,
334: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
335:
336: function learner_can_enroll_in_path(
337: p_learning_path_id in ota_learning_paths.learning_path_id%TYPE

Line 342: p_certification_id in ota_certifications_b.certification_id%TYPE

338: ,p_person_id in per_all_people_f.person_id%type
339: ,p_party_id in hz_parties.party_id%type) return varchar2;
340:
341: function learner_can_enroll_in_cert(
342: p_certification_id in ota_certifications_b.certification_id%TYPE
343: ,p_person_id in per_all_people_f.person_id%type
344: ,p_party_id in hz_parties.party_id%type) return varchar2;
345:
346: FUNCTION emp_has_valid_dates(p_person_id per_all_people_f.person_id%TYPE