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_BULK_ENROLL_UTIL dependencies on PER_ALL_PEOPLE_F

Line 386: ,p_person_id IN PER_ALL_PEOPLE_F.person_id%type

382: ,p_cost_centers IN VARCHAR2
383: ,p_assignment_id IN PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE
384: ,p_business_group_id_from IN PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE
385: ,p_organization_id IN PER_ALL_ASSIGNMENTS_F.organization_id%TYPE
386: ,p_person_id IN PER_ALL_PEOPLE_F.person_id%type
387: ,p_delegate_contact_id IN NUMBER
388: ,p_booking_id OUT NOCOPY OTA_DELEGATE_BOOKINGS.Booking_id%type
389: ,p_message_name OUT NOCOPY varchar2
390: ,p_tdb_information_category IN VARCHAR2

Line 490: per_all_people_f ppf,

486: SELECT ppf.work_telephone,
487: paf.organization_id,
488: ppf.email_address
489: FROM
490: per_all_people_f ppf,
491: per_all_assignments_f paf
492: WHERE
493: ppf.person_id = paf.person_id
494: AND trunc(sysdate) BETWEEN ppf.effective_start_date AND ppf.effective_end_date

Line 506: per_all_people_f ppf,

502: SELECT PPH.PHONE_NUMBER work_telephone,
503: paf.organization_id,
504: ppf.email_address
505: FROM
506: per_all_people_f ppf,
507: per_all_assignments_f paf ,
508: per_phones pph
509: WHERE
510: ppf.person_id = paf.person_id

Line 516: AND pph.PARENT_TABLE(+) = 'PER_ALL_PEOPLE_F'

512: AND trunc(sysdate) BETWEEN paf.effective_start_date AND paf.effective_end_date
513: AND ppf.person_id = p_person_id
514: AND paf.assignment_id = p_assignment_id
515: AND pph.PARENT_ID(+) = ppf.PERSON_ID
516: AND pph.PARENT_TABLE(+) = 'PER_ALL_PEOPLE_F'
517: AND pph.PHONE_TYPE(+) = 'W1'
518: --AND trunc(sysdate) BETWEEN NVL(PPH.DATE_FROM, SYSDATE) AND NVL(PPH.DATE_TO, SYSDATE);For bug6770085
519: AND trunc(sysdate) BETWEEN NVL(PPH.DATE_FROM(+), SYSDATE) AND NVL(PPH.DATE_TO(+), SYSDATE);*/
520:

Line 527: per_all_people_f ppf,

523: paf.organization_id,
524: ppf.email_address,
525: pfax.PHONE_NUMBER fax_number
526: FROM
527: per_all_people_f ppf,
528: per_all_assignments_f paf ,
529: per_phones pph,
530: per_phones pfax
531: WHERE

Line 538: AND pph.PARENT_TABLE(+) = 'PER_ALL_PEOPLE_F'

534: AND trunc(sysdate) BETWEEN paf.effective_start_date AND paf.effective_end_date
535: AND ppf.person_id = p_person_id
536: AND paf.assignment_id = p_assignment_id
537: AND pph.PARENT_ID(+) = ppf.PERSON_ID
538: AND pph.PARENT_TABLE(+) = 'PER_ALL_PEOPLE_F'
539: AND pph.PHONE_TYPE(+) = 'W1'
540: --AND trunc(sysdate) BETWEEN NVL(PPH.DATE_FROM, SYSDATE) AND NVL(PPH.DATE_TO, SYSDATE);For bug6770085
541: AND trunc(sysdate) BETWEEN NVL(PPH.DATE_FROM(+), SYSDATE) AND NVL(PPH.DATE_TO(+), SYSDATE)
542: AND pfax.PARENT_ID(+) = ppf.PERSON_ID

Line 543: AND pfax.PARENT_TABLE(+) = 'PER_ALL_PEOPLE_F'

539: AND pph.PHONE_TYPE(+) = 'W1'
540: --AND trunc(sysdate) BETWEEN NVL(PPH.DATE_FROM, SYSDATE) AND NVL(PPH.DATE_TO, SYSDATE);For bug6770085
541: AND trunc(sysdate) BETWEEN NVL(PPH.DATE_FROM(+), SYSDATE) AND NVL(PPH.DATE_TO(+), SYSDATE)
542: AND pfax.PARENT_ID(+) = ppf.PERSON_ID
543: AND pfax.PARENT_TABLE(+) = 'PER_ALL_PEOPLE_F'
544: AND pfax.PHONE_TYPE(+) = 'WF'
545: AND trunc(sysdate) BETWEEN NVL(pfax.DATE_FROM(+), SYSDATE) AND NVL(pfax.DATE_TO(+), SYSDATE);
546:
547:

Line 1223: l_person_id per_all_people_f.person_id%type;

1219: l_item_type wf_items.item_type%type := 'OTWF';
1220: l_item_key wf_items.item_key%type;
1221:
1222: l_user_name varchar2(80);
1223: l_person_id per_all_people_f.person_id%type;
1224:
1225: l_process_display_name varchar2(240);
1226: l_request_rec csr_get_request_info%ROWTYPE;
1227:

Line 1244: FROM per_all_people_f ppf

1240:
1241:
1242: CURSOR csr_get_person_name(p_person_id IN number) IS
1243: SELECT ppf.full_name
1244: FROM per_all_people_f ppf
1245: WHERE person_id = p_person_id;
1246:
1247: CURSOR csr_get_error_learners IS
1248: SELECT COUNT(person_id)

Line 1265: l_person_full_name per_all_people_f.FULL_NAME%TYPE;

1261: WHERE bulk_enr_request_id = p_enr_request_id
1262: and enrollment_status IS NOT NULL;
1263:
1264: l_object_name VARCHAR2(240);
1265: l_person_full_name per_all_people_f.FULL_NAME%TYPE;
1266: l_error_learners NUMBER := 0;
1267: l_success_learners NUMBER := 0;
1268: l_selected_learners NUMBER := 0;
1269:

Line 1376: l_person_name per_all_people_f.full_name%TYPE;

1372:
1373: l_request_rec csr_get_request_info%ROWTYPE;
1374: l_req_member_rec csr_get_request_members%ROWTYPE;
1375: l_error_message ota_bulk_enr_req_members.error_message%TYPE;
1376: l_person_name per_all_people_f.full_name%TYPE;
1377: l_lp_enrollment_id ota_lp_enrollments.lp_enrollment_id%TYPE;
1378: l_path_status_code ota_lp_enrollments.path_status_code%TYPE;
1379: l_return_status varchar2(30);
1380:

Line 1454: l_person_name per_all_people_f.full_name%TYPE;

1450: l_request_rec csr_get_request_info%ROWTYPE;
1451: l_req_member_rec csr_get_request_members%ROWTYPE;
1452: l_cert_enrollment_id ota_cert_enrollments.cert_enrollment_id%TYPE;
1453: l_error_message ota_bulk_enr_req_members.error_message%TYPE;
1454: l_person_name per_all_people_f.full_name%TYPE;
1455: l_certification_status_code ota_cert_enrollments.CERTIFICATION_STATUS_CODE%TYPE;
1456:
1457:
1458: BEGIN

Line 1563: l_person_name per_all_people_f.full_name%TYPE;

1559:
1560: l_assignment_info csr_get_assignment_info%ROWTYPE;
1561: l_cost_center_info csr_get_cost_center_info%ROWTYPE;
1562:
1563: l_person_name per_all_people_f.full_name%TYPE;
1564:
1565: BEGIN
1566: OPEN csr_get_request_info(p_enr_request_id);
1567: FETCH csr_get_request_info INTO l_request_rec;