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_MANDATORY_ENROLL_UTIL dependencies on PER_ALL_ASSIGNMENTS_F

Line 378: ,p_assignment_id per_all_assignments_f.assignment_id%type

374:
375:
376:
377: FUNCTION learner_is_notSelected_inClass(p_person_id IN per_all_people_f.person_id%type
378: ,p_assignment_id per_all_assignments_f.assignment_id%type
379: ,p_event_id IN ota_events.event_id%type)
380: RETURN Boolean IS
381:
382: CURSOR lrnr_already_selected IS

Line 390: l_lrnr_assignment_id per_all_assignments_f.assignment_id%type;

386: person_id = p_person_id
387: AND event_id = p_event_id
388: AND create_enrollment = 'Y';
389:
390: l_lrnr_assignment_id per_all_assignments_f.assignment_id%type;
391: l_person_name per_all_people_f.full_name%type;
392: l_proc varchar2(72) := g_package||'learner_is_notSelected_inClass';
393:
394: BEGIN

Line 429: ,p_assignment_id per_all_assignments_f.assignment_id%type

425:
426: END learner_is_notSelected_inClass;
427:
428: FUNCTION lrn_is_notSelected_inClass_mul(p_person_id IN per_all_people_f.person_id%type
429: ,p_assignment_id per_all_assignments_f.assignment_id%type
430: ,p_event_id IN ota_events.event_id%type)
431: RETURN Boolean IS
432:
433: CURSOR lrnr_already_selected IS

Line 441: l_lrnr_assignment_id per_all_assignments_f.assignment_id%type;

437: person_id = p_person_id
438: AND event_id = p_event_id
439: AND create_enrollment = 'Y';
440:
441: l_lrnr_assignment_id per_all_assignments_f.assignment_id%type;
442: l_person_name per_all_people_f.full_name%type;
443: l_proc varchar2(72) := g_package||'lrn_is_notSelected_inClass_mul';
444:
445: BEGIN

Line 481: ,p_assignment_id per_all_assignments_f.assignment_id%type

477: END lrn_is_notSelected_inClass_mul;
478:
479:
480: FUNCTION learner_is_notSelected_inCert(p_person_id IN per_all_people_f.person_id%type
481: ,p_assignment_id per_all_assignments_f.assignment_id%type
482: ,p_certification_id IN ota_certifications_b.certification_id%type default NULL)
483: RETURN Boolean IS
484:
485: CURSOR lrnr_already_selected IS

Line 494: l_lrnr_assignment_id per_all_assignments_f.assignment_id%type;

490: AND certification_id = p_certification_id
491: AND create_enrollment = 'Y';
492:
493:
494: l_lrnr_assignment_id per_all_assignments_f.assignment_id%type;
495: l_person_name per_all_people_f.full_name%type;
496: l_proc varchar2(72) := g_package||'learner_is_notSelected_inCert';
497:
498: BEGIN

Line 546: FROM per_all_assignments_f asg,

542: RETURN VARCHAR2 IS
543:
544: /* CURSOR csr_lrnr_belongs_to_org IS
545: SELECT asg.assignment_id
546: FROM per_all_assignments_f asg,
547: (
548: SELECT p_organization_id AS organization_id
549: FROM dual
550: UNION ALL

Line 571: FROM per_all_assignments_f asg,

567:
568:
569: CURSOR csr_lrnr_belongs_to_org IS
570: SELECT asg.assignment_id
571: FROM per_all_assignments_f asg,
572: (
573: SELECT o.organization_id_child as organization_id
574: FROM (SELECT o.organization_id_child
575: FROM per_org_structure_elements o

Line 590: l_assignment_id per_all_assignments_f.assignment_id%type;

586: asg.organization_id = orgs.organization_id AND
587: asg.assignment_type in ('E','A','C');
588:
589:
590: l_assignment_id per_all_assignments_f.assignment_id%type;
591: l_proc varchar2(72) := g_package||'learner_belongs_to_child_org';
592: BEGIN
593:
594: hr_utility.set_location(' Entering:'||l_proc, 5);

Line 625: per_all_assignments_f paf,

621: SELECT paf.organization_id,
622: paf.business_group_id,
623: paf.assignment_id
624: FROM
625: per_all_assignments_f paf,
626: per_person_types ppt,
627: per_all_people_f perp,
628: per_person_type_usages_f ptu
629: WHERE

Line 718: per_all_assignments_f paf,

714: SELECT paf.organization_id,
715: paf.business_group_id,
716: paf.assignment_id
717: FROM
718: per_all_assignments_f paf,
719: per_person_types ppt,
720: per_all_people_f perp,
721: per_person_type_usages_f ptu
722: WHERE

Line 821: organization_id per_all_assignments_f.organization_id%type,

817: job_id per_jobs_tl.job_id%type,
818: position_id per_all_positions.position_id%type,
819: completed_crs_prereq varchar2(1),
820: completed_comp_prereq varchar2(1),
821: organization_id per_all_assignments_f.organization_id%type,
822: assignment_id per_all_assignments_f.assignment_id%type
823: );
824: lrnr_rec learner_rec;
825:

Line 822: assignment_id per_all_assignments_f.assignment_id%type

818: position_id per_all_positions.position_id%type,
819: completed_crs_prereq varchar2(1),
820: completed_comp_prereq varchar2(1),
821: organization_id per_all_assignments_f.organization_id%type,
822: assignment_id per_all_assignments_f.assignment_id%type
823: );
824: lrnr_rec learner_rec;
825:
826: CURSOR csr_get_learner(

Line 841: ,per_all_assignments_f paf

837: ,ota_cpr_utility.is_mand_comp_prereqs_comp_evt(ppf.person_id,p_event_id) completed_comp_prereq
838: , paf.organization_id
839: , paf.assignment_id
840: FROM per_all_people_f ppf
841: ,per_all_assignments_f paf
842: ,per_person_type_usages_f ptu
843: ,per_person_types pts
844: ,per_business_groups pbg
845: WHERE

Line 898: ,per_all_assignments_f paf

894: ,ota_cpr_utility.is_mand_comp_prereqs_comp_evt(ppf.person_id,p_event_id) completed_comp_prereq
895: , paf.organization_id
896: , paf.assignment_id
897: FROM per_all_people_f ppf
898: ,per_all_assignments_f paf
899: ,per_jobs_tl pjt
900: ,per_all_positions pps
901: ,per_person_type_usages_f ptu
902: ,per_person_types pts

Line 1021: ,per_all_assignments_f paf

1017: ,ota_cpr_utility.is_mand_comp_prereqs_comp_evt(ppf.person_id,:2) completed_comp_prereq
1018: , paf.organization_id organization_id
1019: , paf.assignment_id assignment_id
1020: FROM per_all_people_f ppf
1021: ,per_all_assignments_f paf
1022: ,per_jobs_tl pjt
1023: ,per_all_positions pps
1024: ,per_person_type_usages_f ptu
1025: ,per_person_types pts

Line 1204: organization_id per_all_assignments_f.organization_id%type,

1200: job_id per_jobs_tl.job_id%type,
1201: position_id per_all_positions.position_id%type,
1202: completed_crs_prereq varchar2(1),
1203: completed_comp_prereq varchar2(1),
1204: organization_id per_all_assignments_f.organization_id%type,
1205: assignment_id per_all_assignments_f.assignment_id%type
1206: );
1207: lrnr_rec learner_rec;
1208:

Line 1205: assignment_id per_all_assignments_f.assignment_id%type

1201: position_id per_all_positions.position_id%type,
1202: completed_crs_prereq varchar2(1),
1203: completed_comp_prereq varchar2(1),
1204: organization_id per_all_assignments_f.organization_id%type,
1205: assignment_id per_all_assignments_f.assignment_id%type
1206: );
1207: lrnr_rec learner_rec;
1208:
1209: CURSOR csr_get_learner(

Line 1224: ,per_all_assignments_f paf

1220: ,ota_cpr_utility.is_mand_comp_prereqs_comp_evt(ppf.person_id,p_event_id) completed_comp_prereq
1221: , paf.organization_id
1222: , paf.assignment_id
1223: FROM per_all_people_f ppf
1224: ,per_all_assignments_f paf
1225: ,per_person_type_usages_f ptu
1226: ,per_person_types pts
1227: ,per_business_groups pbg
1228: WHERE

Line 1281: ,per_all_assignments_f paf

1277: ,ota_cpr_utility.is_mand_comp_prereqs_comp_evt(ppf.person_id,p_event_id) completed_comp_prereq
1278: , paf.organization_id
1279: , paf.assignment_id
1280: FROM per_all_people_f ppf
1281: ,per_all_assignments_f paf
1282: ,per_jobs_tl pjt
1283: ,per_all_positions pps
1284: ,per_person_type_usages_f ptu
1285: ,per_person_types pts

Line 1476: ,per_all_assignments_f paf

1472: ,ota_cpr_utility.is_mand_comp_prereqs_comp_evt(ppf.person_id,:2) completed_comp_prereq
1473: , paf.organization_id organization_id
1474: , paf.assignment_id assignment_id
1475: FROM per_all_people_f ppf
1476: ,per_all_assignments_f paf
1477: ,per_jobs_tl pjt
1478: ,per_all_positions pps
1479: ,per_person_type_usages_f ptu
1480: ,per_person_types pts

Line 1744: FROM per_all_assignments_f assg,

1740:
1741:
1742: CURSOR csr_get_cost_center_info(l_assignment_id NUMBER) IS
1743: SELECT pcak.cost_allocation_keyflex_id
1744: FROM per_all_assignments_f assg,
1745: pay_cost_allocations_f pcaf,
1746: pay_cost_allocation_keyflex pcak
1747: WHERE assg.assignment_id = pcaf.assignment_id
1748: AND assg.assignment_id = l_assignment_id

Line 1893: FROM per_all_assignments_f assg,

1889: ORDER BY certification_id;
1890:
1891: CURSOR csr_get_cost_center_info(l_assignment_id NUMBER) IS
1892: SELECT pcak.cost_allocation_keyflex_id
1893: FROM per_all_assignments_f assg,
1894: pay_cost_allocations_f pcaf,
1895: pay_cost_allocation_keyflex pcak
1896: WHERE assg.assignment_id = pcaf.assignment_id
1897: AND assg.assignment_id = l_assignment_id

Line 2402: organization_id per_all_assignments_f.organization_id%type,

2398: TYPE learner_rec IS RECORD(
2399: person_id per_all_people_f.person_id%type,
2400: job_id per_jobs_tl.job_id%type,
2401: position_id per_all_positions.position_id%type,
2402: organization_id per_all_assignments_f.organization_id%type,
2403: assignment_id per_all_assignments_f.assignment_id%type
2404: );
2405: lrnr_rec learner_rec;
2406:

Line 2403: assignment_id per_all_assignments_f.assignment_id%type

2399: person_id per_all_people_f.person_id%type,
2400: job_id per_jobs_tl.job_id%type,
2401: position_id per_all_positions.position_id%type,
2402: organization_id per_all_assignments_f.organization_id%type,
2403: assignment_id per_all_assignments_f.assignment_id%type
2404: );
2405: lrnr_rec learner_rec;
2406:
2407: CURSOR csr_get_learner(

Line 2416: ,per_all_assignments_f paf

2412: SELECT ppf.person_id
2413: , paf.organization_id
2414: , paf.assignment_id
2415: FROM per_all_people_f ppf
2416: ,per_all_assignments_f paf
2417: ,per_person_type_usages_f ptu
2418: ,per_person_types pts
2419: ,per_business_groups pbg
2420: WHERE

Line 2459: ,per_all_assignments_f paf

2455: , pps.position_id
2456: , paf.organization_id
2457: , paf.assignment_id
2458: FROM per_all_people_f ppf
2459: ,per_all_assignments_f paf
2460: ,per_jobs_tl pjt
2461: ,per_all_positions pps
2462: ,per_person_type_usages_f ptu
2463: ,per_person_types pts

Line 2683: ,per_all_assignments_f paf

2679: , pps.position_id position_id
2680: , paf.organization_id organization_id
2681: , paf.assignment_id assignment_id
2682: FROM per_all_people_f ppf
2683: ,per_all_assignments_f paf
2684: ,per_jobs_tl pjt
2685: ,per_all_positions pps
2686: ,per_person_type_usages_f ptu
2687: ,per_person_types pts

Line 3027: per_all_assignments_f paf,

3023: SELECT paf.organization_id,
3024: paf.business_group_id,
3025: paf.assignment_id
3026: FROM
3027: per_all_assignments_f paf,
3028: per_person_types ppt,
3029: per_all_people_f perp,
3030: per_person_type_usages_f ptu
3031: WHERE