APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on PER_ALL_PEOPLE_F

Line 169: FUNCTION learner_is_notSelected(p_person_id IN per_all_people_f.person_id%type

165:
166:
167:
168:
169: FUNCTION learner_is_notSelected(p_person_id IN per_all_people_f.person_id%type
170: ,p_assignment_id per_all_assignments_f.assignment_id%type
171: ,p_event_id IN ota_events.event_id%type)
172: RETURN Boolean IS
173:

Line 183: l_person_name per_all_people_f.full_name%type;

179: AND event_id = p_event_id
180: AND create_enrollment = 'Y';
181:
182: l_lrnr_assignment_id per_all_assignments_f.assignment_id%type;
183: l_person_name per_all_people_f.full_name%type;
184: l_proc varchar2(72) := g_package||'learner_is_notSelected';
185:
186: BEGIN
187:

Line 287: per_all_people_f perp,

283: paf.assignment_id
284: FROM
285: per_all_assignments_f paf,
286: per_person_types ppt,
287: per_all_people_f perp,
288: per_person_type_usages_f ptu
289: WHERE
290: paf.person_id = l_person_id
291: AND perp.person_id =paf.person_id

Line 374: person_id per_all_people_f.person_id%type,

370: TYPE learners_in_usergroup IS REF CURSOR;
371: csr_get_lrnr_in_ug learners_in_usergroup;
372:
373: TYPE learner_rec IS RECORD(
374: person_id per_all_people_f.person_id%type,
375: job_id per_jobs_tl.job_id%type,
376: position_id per_all_positions.position_id%type,
377: completed_crs_prereq varchar2(1),
378: completed_comp_prereq varchar2(1),

Line 401: FROM per_all_people_f ppf

397: ,ota_cpr_utility.is_mand_crs_prereqs_comp_evt(ppf.person_id,NULL, ppf.person_id,'E',p_event_id ) completed_crs_prereq
398: ,ota_cpr_utility.is_mand_comp_prereqs_comp_evt(ppf.person_id,p_event_id) completed_comp_prereq
399: , paf.organization_id
400: , paf.assignment_id
401: FROM per_all_people_f ppf
402: ,per_all_assignments_f paf
403: ,per_jobs_tl pjt
404: ,per_all_positions pps
405: ,per_person_type_usages_f ptu

Line 459: l_person_name per_all_people_f.full_name%type;

455: l_numberof_records_processed NUMBER:= 0;
456: l_create_enrollment varchar2(1);
457: l_completed_crs_prereq varchar2(1);
458: l_completed_comp_prereq varchar2(1);
459: l_person_name per_all_people_f.full_name%type;
460: l_event_start_date date;
461:
462:
463: sql_stmnt varchar2(4000);

Line 489: FROM per_all_people_f ppf

485: ,ota_cpr_utility.is_mand_crs_prereqs_comp_evt(ppf.person_id,NULL, ppf.person_id,''E'',:1 ) completed_crs_prereq
486: ,ota_cpr_utility.is_mand_comp_prereqs_comp_evt(ppf.person_id,:2) completed_comp_prereq
487: , paf.organization_id organization_id
488: , paf.assignment_id assignment_id
489: FROM per_all_people_f ppf
490: ,per_all_assignments_f paf
491: ,per_jobs_tl pjt
492: ,per_all_positions pps
493: ,per_person_type_usages_f ptu

Line 653: l_person_name per_all_people_f.full_name%type;

649:
650:
651: l_cost_center_info csr_get_cost_center_info%rowtype;
652:
653: l_person_name per_all_people_f.full_name%type;
654: l_class_name ota_events_tl.title%type;
655: l_proc varchar2(72) := g_package||'create_enrollments';
656:
657: BEGIN

Line 768: l_person_full_name per_all_people_f.FULL_NAME%TYPE;

764: l_item_type wf_items.item_type%type := 'OTWF';
765: l_item_key wf_items.item_key%type;
766:
767: l_user_name varchar2(80);
768: l_person_full_name per_all_people_f.FULL_NAME%TYPE;
769: l_role_name wf_roles.name%type;
770: l_role_display_name wf_roles.display_name%type;
771:
772: l_process_display_name varchar2(240);

Line 780: SELECT ppf.full_name FROM per_all_people_f ppf WHERE person_id = p_person_id;

776: and trunc(sysdate) between trunc(start_date) and trunc(nvl(end_date, sysdate+1));
777:
778:
779: CURSOR csr_get_person_name(p_person_id IN number) IS
780: SELECT ppf.full_name FROM per_all_people_f ppf WHERE person_id = p_person_id;
781:
782: BEGIN
783: hr_utility.set_location('Entering:'||l_proc, 5);
784: