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.HR_FULL_SYNC_MESSAGES dependencies on PER_ALL_PEOPLE_F

Line 4: TYPE EMPLIDTYPE IS TABLE OF per_all_people_f.employee_number%type INDEX BY BINARY_INTEGER;

1: PACKAGE BODY HR_FULL_SYNC_MESSAGES as
2: /* $Header: perhrhdfull.pkb 120.11 2011/05/18 11:54:02 nchinnam noship $ */
3:
4: TYPE EMPLIDTYPE IS TABLE OF per_all_people_f.employee_number%type INDEX BY BINARY_INTEGER;
5: TYPE EMPL_RCDTYPE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
6: TYPE PROBATION_DTTYPE IS TABLE OF per_all_assignments_f.probation_period%type INDEX BY BINARY_INTEGER;
7: TYPE ORIG_HIRE_DTTYPE IS TABLE OF per_all_people_f.original_date_of_hire%type INDEX BY BINARY_INTEGER;
8: TYPE WEFFDTTYPE IS TABLE OF per_all_assignments_f.effective_start_date%type INDEX BY BINARY_INTEGER;

Line 7: TYPE ORIG_HIRE_DTTYPE IS TABLE OF per_all_people_f.original_date_of_hire%type INDEX BY BINARY_INTEGER;

3:
4: TYPE EMPLIDTYPE IS TABLE OF per_all_people_f.employee_number%type INDEX BY BINARY_INTEGER;
5: TYPE EMPL_RCDTYPE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
6: TYPE PROBATION_DTTYPE IS TABLE OF per_all_assignments_f.probation_period%type INDEX BY BINARY_INTEGER;
7: TYPE ORIG_HIRE_DTTYPE IS TABLE OF per_all_people_f.original_date_of_hire%type INDEX BY BINARY_INTEGER;
8: TYPE WEFFDTTYPE IS TABLE OF per_all_assignments_f.effective_start_date%type INDEX BY BINARY_INTEGER;
9: TYPE BUSINESS_UNITTYPE IS TABLE OF per_all_assignments_f.organization_id%type INDEX BY BINARY_INTEGER;
10: TYPE WJOBCODETYPE IS TABLE OF per_all_assignments_f.job_id%type INDEX BY BINARY_INTEGER;
11: TYPE EMPL_STATUSTYPE IS TABLE OF per_all_assignments_f.assignment_status_type_id%type INDEX BY BINARY_INTEGER;

Line 430: L_EMPLOYEE_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%type;

426: procedure hr_person_full_sync(errbuf OUT NOCOPY VARCHAR2
427: ,retcode OUT NOCOPY VARCHAR2)
428: is
429:
430: L_EMPLOYEE_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%type;
431: L_USER_PERSON_TYPE VARCHAR2(60);
432: L_DATE_OF_BIRTH DATE;
433: L_TOWN_OF_BIRTH PER_ALL_PEOPLE_F.TOWN_OF_BIRTH%type;
434: L_COUNTRY_OF_BIRTH PER_ALL_PEOPLE_F.COUNTRY_OF_BIRTH%type;

Line 433: L_TOWN_OF_BIRTH PER_ALL_PEOPLE_F.TOWN_OF_BIRTH%type;

429:
430: L_EMPLOYEE_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%type;
431: L_USER_PERSON_TYPE VARCHAR2(60);
432: L_DATE_OF_BIRTH DATE;
433: L_TOWN_OF_BIRTH PER_ALL_PEOPLE_F.TOWN_OF_BIRTH%type;
434: L_COUNTRY_OF_BIRTH PER_ALL_PEOPLE_F.COUNTRY_OF_BIRTH%type;
435: L_DATE_OF_DEATH DATE;
436: L_ORIGINAL_DATE_OF_HIRE DATE;
437:

Line 434: L_COUNTRY_OF_BIRTH PER_ALL_PEOPLE_F.COUNTRY_OF_BIRTH%type;

430: L_EMPLOYEE_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%type;
431: L_USER_PERSON_TYPE VARCHAR2(60);
432: L_DATE_OF_BIRTH DATE;
433: L_TOWN_OF_BIRTH PER_ALL_PEOPLE_F.TOWN_OF_BIRTH%type;
434: L_COUNTRY_OF_BIRTH PER_ALL_PEOPLE_F.COUNTRY_OF_BIRTH%type;
435: L_DATE_OF_DEATH DATE;
436: L_ORIGINAL_DATE_OF_HIRE DATE;
437:
438: L_EFFECTIVE_START_DATE DATE;

Line 442: L_FULL_NAME PER_ALL_PEOPLE_F.FULL_NAME%type;

438: L_EFFECTIVE_START_DATE DATE;
439:
440: L_SEX VARCHAR2(30);
441: L_MARITAL_STATUS VARCHAR2(30);
442: L_FULL_NAME PER_ALL_PEOPLE_F.FULL_NAME%type;
443: L_PRE_NAME_ADJUNCT PER_ALL_PEOPLE_F.PRE_NAME_ADJUNCT%type;
444: L_SUFFIX VARCHAR2(30);
445: L_TITLE VARCHAR2(30);
446: L_LAST_NAME PER_ALL_PEOPLE_F.LAST_NAME%type;

Line 443: L_PRE_NAME_ADJUNCT PER_ALL_PEOPLE_F.PRE_NAME_ADJUNCT%type;

439:
440: L_SEX VARCHAR2(30);
441: L_MARITAL_STATUS VARCHAR2(30);
442: L_FULL_NAME PER_ALL_PEOPLE_F.FULL_NAME%type;
443: L_PRE_NAME_ADJUNCT PER_ALL_PEOPLE_F.PRE_NAME_ADJUNCT%type;
444: L_SUFFIX VARCHAR2(30);
445: L_TITLE VARCHAR2(30);
446: L_LAST_NAME PER_ALL_PEOPLE_F.LAST_NAME%type;
447: L_FIRST_NAME PER_ALL_PEOPLE_F.FIRST_NAME%type;

Line 446: L_LAST_NAME PER_ALL_PEOPLE_F.LAST_NAME%type;

442: L_FULL_NAME PER_ALL_PEOPLE_F.FULL_NAME%type;
443: L_PRE_NAME_ADJUNCT PER_ALL_PEOPLE_F.PRE_NAME_ADJUNCT%type;
444: L_SUFFIX VARCHAR2(30);
445: L_TITLE VARCHAR2(30);
446: L_LAST_NAME PER_ALL_PEOPLE_F.LAST_NAME%type;
447: L_FIRST_NAME PER_ALL_PEOPLE_F.FIRST_NAME%type;
448: L_MIDDLE_NAMES PER_ALL_PEOPLE_F.MIDDLE_NAMES%type;
449:
450:

Line 447: L_FIRST_NAME PER_ALL_PEOPLE_F.FIRST_NAME%type;

443: L_PRE_NAME_ADJUNCT PER_ALL_PEOPLE_F.PRE_NAME_ADJUNCT%type;
444: L_SUFFIX VARCHAR2(30);
445: L_TITLE VARCHAR2(30);
446: L_LAST_NAME PER_ALL_PEOPLE_F.LAST_NAME%type;
447: L_FIRST_NAME PER_ALL_PEOPLE_F.FIRST_NAME%type;
448: L_MIDDLE_NAMES PER_ALL_PEOPLE_F.MIDDLE_NAMES%type;
449:
450:
451:

Line 448: L_MIDDLE_NAMES PER_ALL_PEOPLE_F.MIDDLE_NAMES%type;

444: L_SUFFIX VARCHAR2(30);
445: L_TITLE VARCHAR2(30);
446: L_LAST_NAME PER_ALL_PEOPLE_F.LAST_NAME%type;
447: L_FIRST_NAME PER_ALL_PEOPLE_F.FIRST_NAME%type;
448: L_MIDDLE_NAMES PER_ALL_PEOPLE_F.MIDDLE_NAMES%type;
449:
450:
451:
452: L_ADDRESS_TYPE PER_ADDRESSES.ADDRESS_TYPE%type;

Line 464: L_EMAIL_ADDRESS PER_ALL_PEOPLE_F.EMAIL_ADDRESS%type;

460: L_REGION_1 PER_ADDRESSES.REGION_1%type;
461: L_REGION_2 PER_ADDRESSES.REGION_1%type;
462: L_POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%type;
463:
464: L_EMAIL_ADDRESS PER_ALL_PEOPLE_F.EMAIL_ADDRESS%type;
465:
466: L_PHONE_TYPE PER_PHONES.PHONE_TYPE%type;
467: L_PHONE_NUMBER PER_PHONES.PHONE_NUMBER%type;
468:

Line 470: L_NATIONAL_IDENTIFIER PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER%type;

466: L_PHONE_TYPE PER_PHONES.PHONE_TYPE%type;
467: L_PHONE_NUMBER PER_PHONES.PHONE_NUMBER%type;
468:
469: L_NATIONALITY VARCHAR2(30);
470: L_NATIONAL_IDENTIFIER PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER%type;
471:
472: --
473: /*Select state ment modified for the employee number
474: not getting displayed for Ex-Employee*/

Line 510: FROM PER_ALL_PEOPLE_F ppf,

506: PHONE_NUMBER,
507: HL2.MEANING NATIONALITY,
508: NATIONAL_IDENTIFIER
509:
510: FROM PER_ALL_PEOPLE_F ppf,
511: PER_ADDRESSES padr ,
512: PER_PHONES ppn ,
513: hr_lookups HL1 ,
514: HR_LOOKUPS HL2 ,

Line 528: AND PPN.PARENT_TABLE = 'PER_ALL_PEOPLE_F'

524: AND ppn.PARENT_ID (+) = PPF.PERSON_ID
525: -- Modified for the bug 6895752 starts here
526: /*AND ( ppn.parent_id is null
527: OR ( ppn.parent_id is not null
528: AND PPN.PARENT_TABLE = 'PER_ALL_PEOPLE_F'
529: AND PPN.PHONE_TYPE = 'W1' ))*/
530:
531:
532:

Line 533: AND PPN.PARENT_TABLE (+) = 'PER_ALL_PEOPLE_F'

529: AND PPN.PHONE_TYPE = 'W1' ))*/
530:
531:
532:
533: AND PPN.PARENT_TABLE (+) = 'PER_ALL_PEOPLE_F'
534: AND PPN.PHONE_TYPE (+) = 'W1'
535: -- Modified for the bug 6895752 ends here
536: AND ((ppf.CURRENT_EMPLOYEE_FLAG = 'Y'
537: OR ppf.person_id in -- modified for bug6873563

Line 769: FROM per_all_people_f ppf,per_all_assignments_f pas,

765: pas.frequency,pas.grade_id,pas.supervisor_id,pas.EFFECTIVE_START_DATE,
766: nvl(pas.EFFECTIVE_END_DATE,sysdate) EFFECTIVE_END_DATE,
767: nvl(psf.step_id,0) Step_id
768: ,pos.final_process_date,pos.ACCEPTED_TERMINATION_DATE
769: FROM per_all_people_f ppf,per_all_assignments_f pas,
770: per_periods_of_service pos,PER_SPINAL_POINT_PLACEMENTS_F psf
771: WHERE pas.primary_flag='Y'
772: AND pos.person_id=pas.person_id
773: AND ppf.person_id = pos.person_id