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.9 2008/03/19 09:52:12 sathkris 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 429: L_EMPLOYEE_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%type;

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

Line 432: L_TOWN_OF_BIRTH PER_ALL_PEOPLE_F.TOWN_OF_BIRTH%type;

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

Line 433: L_COUNTRY_OF_BIRTH PER_ALL_PEOPLE_F.COUNTRY_OF_BIRTH%type;

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

Line 441: L_FULL_NAME PER_ALL_PEOPLE_F.FULL_NAME%type;

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

Line 442: L_PRE_NAME_ADJUNCT PER_ALL_PEOPLE_F.PRE_NAME_ADJUNCT%type;

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

Line 445: L_LAST_NAME PER_ALL_PEOPLE_F.LAST_NAME%type;

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

Line 446: L_FIRST_NAME PER_ALL_PEOPLE_F.FIRST_NAME%type;

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

Line 447: L_MIDDLE_NAMES PER_ALL_PEOPLE_F.MIDDLE_NAMES%type;

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

Line 463: L_EMAIL_ADDRESS PER_ALL_PEOPLE_F.EMAIL_ADDRESS%type;

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

Line 469: L_NATIONAL_IDENTIFIER PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER%type;

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

Line 509: FROM PER_ALL_PEOPLE_F ppf,

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

Line 527: AND PPN.PARENT_TABLE = 'PER_ALL_PEOPLE_F'

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

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

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

Line 768: FROM per_all_people_f ppf,per_all_assignments_f pas,

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