APPS.PER_US_EMPLOYEE_LEG_HOOK dependencies on PER_ALL_PEOPLE_F

Line 23: PROCEDURE CHECK_NEW_HIRE( p_person_id per_all_people_f.person_id%type

19: --------------------------------------------------------------------------
20: -- 1.0 05-Jan-06 SSattini Created this procedure --
21: --------------------------------------------------------------------------
22:
23: PROCEDURE CHECK_NEW_HIRE( p_person_id per_all_people_f.person_id%type
24: ,p_per_information7 per_all_people_f.per_information7%type
25: ) IS
26:
27: l_per_information7 varchar2(240);

Line 24: ,p_per_information7 per_all_people_f.per_information7%type

20: -- 1.0 05-Jan-06 SSattini Created this procedure --
21: --------------------------------------------------------------------------
22:
23: PROCEDURE CHECK_NEW_HIRE( p_person_id per_all_people_f.person_id%type
24: ,p_per_information7 per_all_people_f.per_information7%type
25: ) IS
26:
27: l_per_information7 varchar2(240);
28:

Line 39: update per_all_people_f

35:
36: hr_utility.trace('p_per_information7 = hr_api.g_varchar2 Satisfied ');
37: hr_utility.trace('New Hire Status before default value: '||p_per_information7 );
38:
39: update per_all_people_f
40: set per_information7 = 'INCL'
41: where person_id = p_person_id;
42:
43: hr_utility.trace('New Hire Status is Set to default value: INCL ');