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
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
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:
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);
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;
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;
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:
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;
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;
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;
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
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;