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

Line 64: ( P_PERSON_ID per_all_people_f.person_id%TYPE

60: First Day Report Information EIT is set to
61: YES.
62: */
63: PROCEDURE fdr_update_check
64: ( P_PERSON_ID per_all_people_f.person_id%TYPE
65: , P_DATE_OF_BIRTH date
66: , P_PER_INFORMATION1 varchar2
67: , P_PRE_NAME_ADJUNCT per_all_people_f.PRE_NAME_ADJUNCT%TYPE default ' '
68: , P_LAST_NAME per_all_people_f.LAST_NAME%TYPE

Line 67: , P_PRE_NAME_ADJUNCT per_all_people_f.PRE_NAME_ADJUNCT%TYPE default ' '

63: PROCEDURE fdr_update_check
64: ( P_PERSON_ID per_all_people_f.person_id%TYPE
65: , P_DATE_OF_BIRTH date
66: , P_PER_INFORMATION1 varchar2
67: , P_PRE_NAME_ADJUNCT per_all_people_f.PRE_NAME_ADJUNCT%TYPE default ' '
68: , P_LAST_NAME per_all_people_f.LAST_NAME%TYPE
69: , P_EFFECTIVE_DATE date default to_date('01/01/4712','DD/MM/YYYY')
70: , P_NATIONAL_IDENTIFIER per_all_people_f.NATIONAL_IDENTIFIER%TYPE
71: , P_EMPLOYEE_NUMBER per_all_people_f.EMPLOYEE_NUMBER%TYPE) IS

Line 68: , P_LAST_NAME per_all_people_f.LAST_NAME%TYPE

64: ( P_PERSON_ID per_all_people_f.person_id%TYPE
65: , P_DATE_OF_BIRTH date
66: , P_PER_INFORMATION1 varchar2
67: , P_PRE_NAME_ADJUNCT per_all_people_f.PRE_NAME_ADJUNCT%TYPE default ' '
68: , P_LAST_NAME per_all_people_f.LAST_NAME%TYPE
69: , P_EFFECTIVE_DATE date default to_date('01/01/4712','DD/MM/YYYY')
70: , P_NATIONAL_IDENTIFIER per_all_people_f.NATIONAL_IDENTIFIER%TYPE
71: , P_EMPLOYEE_NUMBER per_all_people_f.EMPLOYEE_NUMBER%TYPE) IS
72:

Line 70: , P_NATIONAL_IDENTIFIER per_all_people_f.NATIONAL_IDENTIFIER%TYPE

66: , P_PER_INFORMATION1 varchar2
67: , P_PRE_NAME_ADJUNCT per_all_people_f.PRE_NAME_ADJUNCT%TYPE default ' '
68: , P_LAST_NAME per_all_people_f.LAST_NAME%TYPE
69: , P_EFFECTIVE_DATE date default to_date('01/01/4712','DD/MM/YYYY')
70: , P_NATIONAL_IDENTIFIER per_all_people_f.NATIONAL_IDENTIFIER%TYPE
71: , P_EMPLOYEE_NUMBER per_all_people_f.EMPLOYEE_NUMBER%TYPE) IS
72:
73: l_hiredate date;
74: l_initial varchar2(20);

Line 71: , P_EMPLOYEE_NUMBER per_all_people_f.EMPLOYEE_NUMBER%TYPE) IS

67: , P_PRE_NAME_ADJUNCT per_all_people_f.PRE_NAME_ADJUNCT%TYPE default ' '
68: , P_LAST_NAME per_all_people_f.LAST_NAME%TYPE
69: , P_EFFECTIVE_DATE date default to_date('01/01/4712','DD/MM/YYYY')
70: , P_NATIONAL_IDENTIFIER per_all_people_f.NATIONAL_IDENTIFIER%TYPE
71: , P_EMPLOYEE_NUMBER per_all_people_f.EMPLOYEE_NUMBER%TYPE) IS
72:
73: l_hiredate date;
74: l_initial varchar2(20);
75: l_sofi per_all_people_f.national_identifier%TYPE;

Line 75: l_sofi per_all_people_f.national_identifier%TYPE;

71: , P_EMPLOYEE_NUMBER per_all_people_f.EMPLOYEE_NUMBER%TYPE) IS
72:
73: l_hiredate date;
74: l_initial varchar2(20);
75: l_sofi per_all_people_f.national_identifier%TYPE;
76: l_dob per_all_people_f.DATE_OF_BIRTH%TYPE;
77: l_prefix per_all_people_f.PRE_NAME_ADJUNCT%TYPE;
78: l_last_name per_all_people_f.LAST_NAME%TYPE;
79: l_employee_num per_all_people_f.EMPLOYEE_NUMBER%TYPE;

Line 76: l_dob per_all_people_f.DATE_OF_BIRTH%TYPE;

72:
73: l_hiredate date;
74: l_initial varchar2(20);
75: l_sofi per_all_people_f.national_identifier%TYPE;
76: l_dob per_all_people_f.DATE_OF_BIRTH%TYPE;
77: l_prefix per_all_people_f.PRE_NAME_ADJUNCT%TYPE;
78: l_last_name per_all_people_f.LAST_NAME%TYPE;
79: l_employee_num per_all_people_f.EMPLOYEE_NUMBER%TYPE;
80:

Line 77: l_prefix per_all_people_f.PRE_NAME_ADJUNCT%TYPE;

73: l_hiredate date;
74: l_initial varchar2(20);
75: l_sofi per_all_people_f.national_identifier%TYPE;
76: l_dob per_all_people_f.DATE_OF_BIRTH%TYPE;
77: l_prefix per_all_people_f.PRE_NAME_ADJUNCT%TYPE;
78: l_last_name per_all_people_f.LAST_NAME%TYPE;
79: l_employee_num per_all_people_f.EMPLOYEE_NUMBER%TYPE;
80:
81: l_resend_enabled number := 0;

Line 78: l_last_name per_all_people_f.LAST_NAME%TYPE;

74: l_initial varchar2(20);
75: l_sofi per_all_people_f.national_identifier%TYPE;
76: l_dob per_all_people_f.DATE_OF_BIRTH%TYPE;
77: l_prefix per_all_people_f.PRE_NAME_ADJUNCT%TYPE;
78: l_last_name per_all_people_f.LAST_NAME%TYPE;
79: l_employee_num per_all_people_f.EMPLOYEE_NUMBER%TYPE;
80:
81: l_resend_enabled number := 0;
82: l_ext_info_id per_people_extra_info.PERSON_EXTRA_INFO_ID%type;

Line 79: l_employee_num per_all_people_f.EMPLOYEE_NUMBER%TYPE;

75: l_sofi per_all_people_f.national_identifier%TYPE;
76: l_dob per_all_people_f.DATE_OF_BIRTH%TYPE;
77: l_prefix per_all_people_f.PRE_NAME_ADJUNCT%TYPE;
78: l_last_name per_all_people_f.LAST_NAME%TYPE;
79: l_employee_num per_all_people_f.EMPLOYEE_NUMBER%TYPE;
80:
81: l_resend_enabled number := 0;
82: l_ext_info_id per_people_extra_info.PERSON_EXTRA_INFO_ID%type;
83: l_ovn per_people_extra_info.OBJECT_VERSION_NUMBER%TYPE;

Line 101: FROM per_all_people_f

97: ,PRE_NAME_ADJUNCT
98: ,LAST_NAME
99: ,NATIONAL_IDENTIFIER
100: ,EMPLOYEE_NUMBER
101: FROM per_all_people_f
102: WHERE person_id = p_csr_person_id
103: AND P_EFFECTIVE_DATE BETWEEN EFFECTIVE_START_DATE
104: AND EFFECTIVE_END_DATE
105: AND business_group_id in (SELECT business_group_id

Line 176: ( P_PERSON_ID per_all_people_f.person_id%TYPE) IS

172:
173: END fdr_update_check;
174:
175: procedure fdr_rehire_check
176: ( P_PERSON_ID per_all_people_f.person_id%TYPE) IS
177:
178: l_resend_enabled number := 0;
179: l_ext_info_id per_people_extra_info.PERSON_EXTRA_INFO_ID%type;
180: l_ovn per_people_extra_info.OBJECT_VERSION_NUMBER%TYPE;