DBA Data[Home] [Help]

APPS.PER_US_EMPLOYEE_LEG_HOOK dependencies on HR_UTILITY

Line 30: /* hr_utility.trace_on(null,'TESTNEWHIRE'); */

26:
27: l_per_information7 varchar2(240);
28:
29: BEGIN
30: /* hr_utility.trace_on(null,'TESTNEWHIRE'); */
31: hr_utility.trace('p_person_id value: '||to_char(p_person_id));
32: hr_utility.trace('New Hire Status before default value: '||p_per_information7 );
33:
34: IF ((p_per_information7 = hr_api.g_varchar2) OR (p_per_information7 is null)) THEN

Line 31: hr_utility.trace('p_person_id value: '||to_char(p_person_id));

27: l_per_information7 varchar2(240);
28:
29: BEGIN
30: /* hr_utility.trace_on(null,'TESTNEWHIRE'); */
31: hr_utility.trace('p_person_id value: '||to_char(p_person_id));
32: hr_utility.trace('New Hire Status before default value: '||p_per_information7 );
33:
34: IF ((p_per_information7 = hr_api.g_varchar2) OR (p_per_information7 is null)) THEN
35:

Line 32: hr_utility.trace('New Hire Status before default value: '||p_per_information7 );

28:
29: BEGIN
30: /* hr_utility.trace_on(null,'TESTNEWHIRE'); */
31: hr_utility.trace('p_person_id value: '||to_char(p_person_id));
32: hr_utility.trace('New Hire Status before default value: '||p_per_information7 );
33:
34: IF ((p_per_information7 = hr_api.g_varchar2) OR (p_per_information7 is null)) THEN
35:
36: hr_utility.trace('p_per_information7 = hr_api.g_varchar2 Satisfied ');

Line 36: hr_utility.trace('p_per_information7 = hr_api.g_varchar2 Satisfied ');

32: hr_utility.trace('New Hire Status before default value: '||p_per_information7 );
33:
34: IF ((p_per_information7 = hr_api.g_varchar2) OR (p_per_information7 is null)) THEN
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'

Line 37: hr_utility.trace('New Hire Status before default value: '||p_per_information7 );

33:
34: IF ((p_per_information7 = hr_api.g_varchar2) OR (p_per_information7 is null)) THEN
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;

Line 43: hr_utility.trace('New Hire Status is Set to default value: INCL ');

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 ');
44: END IF;
45:
46: /* hr_utility.trace_off; */
47: return;

Line 46: /* hr_utility.trace_off; */

42:
43: hr_utility.trace('New Hire Status is Set to default value: INCL ');
44: END IF;
45:
46: /* hr_utility.trace_off; */
47: return;
48:
49: END CHECK_NEW_HIRE;
50: