DBA Data[Home] [Help]

APPS.HR_NL_EXTRA_PERSON_RULES dependencies on PER_ALL_PEOPLE_F

Line 14: ( P_PERSON_ID per_all_people_f.person_id%TYPE

10:
11: /* First Day Report */
12:
13: procedure fdr_update_check
14: ( P_PERSON_ID per_all_people_f.person_id%TYPE
15: , P_DATE_OF_BIRTH date
16: , P_PER_INFORMATION1 varchar2
17: , P_PRE_NAME_ADJUNCT per_all_people_f.PRE_NAME_ADJUNCT%TYPE default ' '
18: , P_LAST_NAME per_all_people_f.LAST_NAME%TYPE

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

13: procedure fdr_update_check
14: ( P_PERSON_ID per_all_people_f.person_id%TYPE
15: , P_DATE_OF_BIRTH date
16: , P_PER_INFORMATION1 varchar2
17: , P_PRE_NAME_ADJUNCT per_all_people_f.PRE_NAME_ADJUNCT%TYPE default ' '
18: , P_LAST_NAME per_all_people_f.LAST_NAME%TYPE
19: , P_EFFECTIVE_DATE date default to_date('01/01/4712','DD/MM/YYYY')
20: , P_NATIONAL_IDENTIFIER per_all_people_f.NATIONAL_IDENTIFIER%TYPE
21: , P_EMPLOYEE_NUMBER per_all_people_f.EMPLOYEE_NUMBER%TYPE);

Line 18: , P_LAST_NAME per_all_people_f.LAST_NAME%TYPE

14: ( P_PERSON_ID per_all_people_f.person_id%TYPE
15: , P_DATE_OF_BIRTH date
16: , P_PER_INFORMATION1 varchar2
17: , P_PRE_NAME_ADJUNCT per_all_people_f.PRE_NAME_ADJUNCT%TYPE default ' '
18: , P_LAST_NAME per_all_people_f.LAST_NAME%TYPE
19: , P_EFFECTIVE_DATE date default to_date('01/01/4712','DD/MM/YYYY')
20: , P_NATIONAL_IDENTIFIER per_all_people_f.NATIONAL_IDENTIFIER%TYPE
21: , P_EMPLOYEE_NUMBER per_all_people_f.EMPLOYEE_NUMBER%TYPE);
22:

Line 20: , P_NATIONAL_IDENTIFIER per_all_people_f.NATIONAL_IDENTIFIER%TYPE

16: , P_PER_INFORMATION1 varchar2
17: , P_PRE_NAME_ADJUNCT per_all_people_f.PRE_NAME_ADJUNCT%TYPE default ' '
18: , P_LAST_NAME per_all_people_f.LAST_NAME%TYPE
19: , P_EFFECTIVE_DATE date default to_date('01/01/4712','DD/MM/YYYY')
20: , P_NATIONAL_IDENTIFIER per_all_people_f.NATIONAL_IDENTIFIER%TYPE
21: , P_EMPLOYEE_NUMBER per_all_people_f.EMPLOYEE_NUMBER%TYPE);
22:
23: procedure fdr_rehire_check
24: ( P_PERSON_ID per_all_people_f.person_id%TYPE);

Line 21: , P_EMPLOYEE_NUMBER per_all_people_f.EMPLOYEE_NUMBER%TYPE);

17: , P_PRE_NAME_ADJUNCT per_all_people_f.PRE_NAME_ADJUNCT%TYPE default ' '
18: , P_LAST_NAME per_all_people_f.LAST_NAME%TYPE
19: , P_EFFECTIVE_DATE date default to_date('01/01/4712','DD/MM/YYYY')
20: , P_NATIONAL_IDENTIFIER per_all_people_f.NATIONAL_IDENTIFIER%TYPE
21: , P_EMPLOYEE_NUMBER per_all_people_f.EMPLOYEE_NUMBER%TYPE);
22:
23: procedure fdr_rehire_check
24: ( P_PERSON_ID per_all_people_f.person_id%TYPE);
25:

Line 24: ( P_PERSON_ID per_all_people_f.person_id%TYPE);

20: , P_NATIONAL_IDENTIFIER per_all_people_f.NATIONAL_IDENTIFIER%TYPE
21: , P_EMPLOYEE_NUMBER per_all_people_f.EMPLOYEE_NUMBER%TYPE);
22:
23: procedure fdr_rehire_check
24: ( P_PERSON_ID per_all_people_f.person_id%TYPE);
25:
26: --
27: END HR_NL_EXTRA_PERSON_RULES;
28: