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.PER_PER_BUS1 dependencies on HR_API

Line 19: if nvl(per_per_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

15: --
16: begin
17: hr_utility.set_location('Entering:'||l_proc, 10);
18: --
19: if nvl(per_per_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
20: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
21: nvl(per_per_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
22: nvl(p_rec.attribute1, hr_api.g_varchar2) or
23: nvl(per_per_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 20: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

16: begin
17: hr_utility.set_location('Entering:'||l_proc, 10);
18: --
19: if nvl(per_per_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
20: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
21: nvl(per_per_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
22: nvl(p_rec.attribute1, hr_api.g_varchar2) or
23: nvl(per_per_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
24: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 21: nvl(per_per_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

17: hr_utility.set_location('Entering:'||l_proc, 10);
18: --
19: if nvl(per_per_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
20: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
21: nvl(per_per_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
22: nvl(p_rec.attribute1, hr_api.g_varchar2) or
23: nvl(per_per_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
24: nvl(p_rec.attribute2, hr_api.g_varchar2) or
25: nvl(per_per_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 22: nvl(p_rec.attribute1, hr_api.g_varchar2) or

18: --
19: if nvl(per_per_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
20: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
21: nvl(per_per_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
22: nvl(p_rec.attribute1, hr_api.g_varchar2) or
23: nvl(per_per_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
24: nvl(p_rec.attribute2, hr_api.g_varchar2) or
25: nvl(per_per_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
26: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 23: nvl(per_per_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

19: if nvl(per_per_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
20: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
21: nvl(per_per_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
22: nvl(p_rec.attribute1, hr_api.g_varchar2) or
23: nvl(per_per_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
24: nvl(p_rec.attribute2, hr_api.g_varchar2) or
25: nvl(per_per_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
26: nvl(p_rec.attribute3, hr_api.g_varchar2) or
27: nvl(per_per_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 24: nvl(p_rec.attribute2, hr_api.g_varchar2) or

20: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
21: nvl(per_per_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
22: nvl(p_rec.attribute1, hr_api.g_varchar2) or
23: nvl(per_per_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
24: nvl(p_rec.attribute2, hr_api.g_varchar2) or
25: nvl(per_per_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
26: nvl(p_rec.attribute3, hr_api.g_varchar2) or
27: nvl(per_per_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
28: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 25: nvl(per_per_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

21: nvl(per_per_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
22: nvl(p_rec.attribute1, hr_api.g_varchar2) or
23: nvl(per_per_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
24: nvl(p_rec.attribute2, hr_api.g_varchar2) or
25: nvl(per_per_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
26: nvl(p_rec.attribute3, hr_api.g_varchar2) or
27: nvl(per_per_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
28: nvl(p_rec.attribute4, hr_api.g_varchar2) or
29: nvl(per_per_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 26: nvl(p_rec.attribute3, hr_api.g_varchar2) or

22: nvl(p_rec.attribute1, hr_api.g_varchar2) or
23: nvl(per_per_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
24: nvl(p_rec.attribute2, hr_api.g_varchar2) or
25: nvl(per_per_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
26: nvl(p_rec.attribute3, hr_api.g_varchar2) or
27: nvl(per_per_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
28: nvl(p_rec.attribute4, hr_api.g_varchar2) or
29: nvl(per_per_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
30: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 27: nvl(per_per_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

23: nvl(per_per_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
24: nvl(p_rec.attribute2, hr_api.g_varchar2) or
25: nvl(per_per_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
26: nvl(p_rec.attribute3, hr_api.g_varchar2) or
27: nvl(per_per_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
28: nvl(p_rec.attribute4, hr_api.g_varchar2) or
29: nvl(per_per_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
30: nvl(p_rec.attribute5, hr_api.g_varchar2) or
31: nvl(per_per_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 28: nvl(p_rec.attribute4, hr_api.g_varchar2) or

24: nvl(p_rec.attribute2, hr_api.g_varchar2) or
25: nvl(per_per_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
26: nvl(p_rec.attribute3, hr_api.g_varchar2) or
27: nvl(per_per_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
28: nvl(p_rec.attribute4, hr_api.g_varchar2) or
29: nvl(per_per_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
30: nvl(p_rec.attribute5, hr_api.g_varchar2) or
31: nvl(per_per_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
32: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 29: nvl(per_per_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

25: nvl(per_per_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
26: nvl(p_rec.attribute3, hr_api.g_varchar2) or
27: nvl(per_per_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
28: nvl(p_rec.attribute4, hr_api.g_varchar2) or
29: nvl(per_per_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
30: nvl(p_rec.attribute5, hr_api.g_varchar2) or
31: nvl(per_per_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
32: nvl(p_rec.attribute6, hr_api.g_varchar2) or
33: nvl(per_per_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 30: nvl(p_rec.attribute5, hr_api.g_varchar2) or

26: nvl(p_rec.attribute3, hr_api.g_varchar2) or
27: nvl(per_per_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
28: nvl(p_rec.attribute4, hr_api.g_varchar2) or
29: nvl(per_per_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
30: nvl(p_rec.attribute5, hr_api.g_varchar2) or
31: nvl(per_per_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
32: nvl(p_rec.attribute6, hr_api.g_varchar2) or
33: nvl(per_per_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
34: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 31: nvl(per_per_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

27: nvl(per_per_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
28: nvl(p_rec.attribute4, hr_api.g_varchar2) or
29: nvl(per_per_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
30: nvl(p_rec.attribute5, hr_api.g_varchar2) or
31: nvl(per_per_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
32: nvl(p_rec.attribute6, hr_api.g_varchar2) or
33: nvl(per_per_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
34: nvl(p_rec.attribute7, hr_api.g_varchar2) or
35: nvl(per_per_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 32: nvl(p_rec.attribute6, hr_api.g_varchar2) or

28: nvl(p_rec.attribute4, hr_api.g_varchar2) or
29: nvl(per_per_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
30: nvl(p_rec.attribute5, hr_api.g_varchar2) or
31: nvl(per_per_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
32: nvl(p_rec.attribute6, hr_api.g_varchar2) or
33: nvl(per_per_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
34: nvl(p_rec.attribute7, hr_api.g_varchar2) or
35: nvl(per_per_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
36: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 33: nvl(per_per_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

29: nvl(per_per_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
30: nvl(p_rec.attribute5, hr_api.g_varchar2) or
31: nvl(per_per_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
32: nvl(p_rec.attribute6, hr_api.g_varchar2) or
33: nvl(per_per_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
34: nvl(p_rec.attribute7, hr_api.g_varchar2) or
35: nvl(per_per_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
36: nvl(p_rec.attribute8, hr_api.g_varchar2) or
37: nvl(per_per_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 34: nvl(p_rec.attribute7, hr_api.g_varchar2) or

30: nvl(p_rec.attribute5, hr_api.g_varchar2) or
31: nvl(per_per_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
32: nvl(p_rec.attribute6, hr_api.g_varchar2) or
33: nvl(per_per_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
34: nvl(p_rec.attribute7, hr_api.g_varchar2) or
35: nvl(per_per_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
36: nvl(p_rec.attribute8, hr_api.g_varchar2) or
37: nvl(per_per_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
38: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 35: nvl(per_per_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

31: nvl(per_per_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
32: nvl(p_rec.attribute6, hr_api.g_varchar2) or
33: nvl(per_per_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
34: nvl(p_rec.attribute7, hr_api.g_varchar2) or
35: nvl(per_per_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
36: nvl(p_rec.attribute8, hr_api.g_varchar2) or
37: nvl(per_per_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
38: nvl(p_rec.attribute9, hr_api.g_varchar2) or
39: nvl(per_per_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 36: nvl(p_rec.attribute8, hr_api.g_varchar2) or

32: nvl(p_rec.attribute6, hr_api.g_varchar2) or
33: nvl(per_per_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
34: nvl(p_rec.attribute7, hr_api.g_varchar2) or
35: nvl(per_per_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
36: nvl(p_rec.attribute8, hr_api.g_varchar2) or
37: nvl(per_per_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
38: nvl(p_rec.attribute9, hr_api.g_varchar2) or
39: nvl(per_per_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
40: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 37: nvl(per_per_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

33: nvl(per_per_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
34: nvl(p_rec.attribute7, hr_api.g_varchar2) or
35: nvl(per_per_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
36: nvl(p_rec.attribute8, hr_api.g_varchar2) or
37: nvl(per_per_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
38: nvl(p_rec.attribute9, hr_api.g_varchar2) or
39: nvl(per_per_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
40: nvl(p_rec.attribute10, hr_api.g_varchar2) or
41: nvl(per_per_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 38: nvl(p_rec.attribute9, hr_api.g_varchar2) or

34: nvl(p_rec.attribute7, hr_api.g_varchar2) or
35: nvl(per_per_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
36: nvl(p_rec.attribute8, hr_api.g_varchar2) or
37: nvl(per_per_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
38: nvl(p_rec.attribute9, hr_api.g_varchar2) or
39: nvl(per_per_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
40: nvl(p_rec.attribute10, hr_api.g_varchar2) or
41: nvl(per_per_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
42: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 39: nvl(per_per_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

35: nvl(per_per_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
36: nvl(p_rec.attribute8, hr_api.g_varchar2) or
37: nvl(per_per_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
38: nvl(p_rec.attribute9, hr_api.g_varchar2) or
39: nvl(per_per_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
40: nvl(p_rec.attribute10, hr_api.g_varchar2) or
41: nvl(per_per_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
42: nvl(p_rec.attribute11, hr_api.g_varchar2) or
43: nvl(per_per_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 40: nvl(p_rec.attribute10, hr_api.g_varchar2) or

36: nvl(p_rec.attribute8, hr_api.g_varchar2) or
37: nvl(per_per_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
38: nvl(p_rec.attribute9, hr_api.g_varchar2) or
39: nvl(per_per_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
40: nvl(p_rec.attribute10, hr_api.g_varchar2) or
41: nvl(per_per_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
42: nvl(p_rec.attribute11, hr_api.g_varchar2) or
43: nvl(per_per_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
44: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 41: nvl(per_per_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

37: nvl(per_per_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
38: nvl(p_rec.attribute9, hr_api.g_varchar2) or
39: nvl(per_per_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
40: nvl(p_rec.attribute10, hr_api.g_varchar2) or
41: nvl(per_per_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
42: nvl(p_rec.attribute11, hr_api.g_varchar2) or
43: nvl(per_per_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
44: nvl(p_rec.attribute12, hr_api.g_varchar2) or
45: nvl(per_per_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 42: nvl(p_rec.attribute11, hr_api.g_varchar2) or

38: nvl(p_rec.attribute9, hr_api.g_varchar2) or
39: nvl(per_per_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
40: nvl(p_rec.attribute10, hr_api.g_varchar2) or
41: nvl(per_per_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
42: nvl(p_rec.attribute11, hr_api.g_varchar2) or
43: nvl(per_per_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
44: nvl(p_rec.attribute12, hr_api.g_varchar2) or
45: nvl(per_per_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
46: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 43: nvl(per_per_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

39: nvl(per_per_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
40: nvl(p_rec.attribute10, hr_api.g_varchar2) or
41: nvl(per_per_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
42: nvl(p_rec.attribute11, hr_api.g_varchar2) or
43: nvl(per_per_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
44: nvl(p_rec.attribute12, hr_api.g_varchar2) or
45: nvl(per_per_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
46: nvl(p_rec.attribute13, hr_api.g_varchar2) or
47: nvl(per_per_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 44: nvl(p_rec.attribute12, hr_api.g_varchar2) or

40: nvl(p_rec.attribute10, hr_api.g_varchar2) or
41: nvl(per_per_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
42: nvl(p_rec.attribute11, hr_api.g_varchar2) or
43: nvl(per_per_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
44: nvl(p_rec.attribute12, hr_api.g_varchar2) or
45: nvl(per_per_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
46: nvl(p_rec.attribute13, hr_api.g_varchar2) or
47: nvl(per_per_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
48: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 45: nvl(per_per_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

41: nvl(per_per_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
42: nvl(p_rec.attribute11, hr_api.g_varchar2) or
43: nvl(per_per_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
44: nvl(p_rec.attribute12, hr_api.g_varchar2) or
45: nvl(per_per_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
46: nvl(p_rec.attribute13, hr_api.g_varchar2) or
47: nvl(per_per_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
48: nvl(p_rec.attribute14, hr_api.g_varchar2) or
49: nvl(per_per_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 46: nvl(p_rec.attribute13, hr_api.g_varchar2) or

42: nvl(p_rec.attribute11, hr_api.g_varchar2) or
43: nvl(per_per_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
44: nvl(p_rec.attribute12, hr_api.g_varchar2) or
45: nvl(per_per_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
46: nvl(p_rec.attribute13, hr_api.g_varchar2) or
47: nvl(per_per_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
48: nvl(p_rec.attribute14, hr_api.g_varchar2) or
49: nvl(per_per_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
50: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 47: nvl(per_per_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

43: nvl(per_per_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
44: nvl(p_rec.attribute12, hr_api.g_varchar2) or
45: nvl(per_per_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
46: nvl(p_rec.attribute13, hr_api.g_varchar2) or
47: nvl(per_per_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
48: nvl(p_rec.attribute14, hr_api.g_varchar2) or
49: nvl(per_per_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
50: nvl(p_rec.attribute15, hr_api.g_varchar2) or
51: nvl(per_per_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 48: nvl(p_rec.attribute14, hr_api.g_varchar2) or

44: nvl(p_rec.attribute12, hr_api.g_varchar2) or
45: nvl(per_per_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
46: nvl(p_rec.attribute13, hr_api.g_varchar2) or
47: nvl(per_per_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
48: nvl(p_rec.attribute14, hr_api.g_varchar2) or
49: nvl(per_per_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
50: nvl(p_rec.attribute15, hr_api.g_varchar2) or
51: nvl(per_per_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
52: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 49: nvl(per_per_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

45: nvl(per_per_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
46: nvl(p_rec.attribute13, hr_api.g_varchar2) or
47: nvl(per_per_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
48: nvl(p_rec.attribute14, hr_api.g_varchar2) or
49: nvl(per_per_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
50: nvl(p_rec.attribute15, hr_api.g_varchar2) or
51: nvl(per_per_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
52: nvl(p_rec.attribute16, hr_api.g_varchar2) or
53: nvl(per_per_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 50: nvl(p_rec.attribute15, hr_api.g_varchar2) or

46: nvl(p_rec.attribute13, hr_api.g_varchar2) or
47: nvl(per_per_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
48: nvl(p_rec.attribute14, hr_api.g_varchar2) or
49: nvl(per_per_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
50: nvl(p_rec.attribute15, hr_api.g_varchar2) or
51: nvl(per_per_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
52: nvl(p_rec.attribute16, hr_api.g_varchar2) or
53: nvl(per_per_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
54: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 51: nvl(per_per_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

47: nvl(per_per_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
48: nvl(p_rec.attribute14, hr_api.g_varchar2) or
49: nvl(per_per_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
50: nvl(p_rec.attribute15, hr_api.g_varchar2) or
51: nvl(per_per_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
52: nvl(p_rec.attribute16, hr_api.g_varchar2) or
53: nvl(per_per_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
54: nvl(p_rec.attribute17, hr_api.g_varchar2) or
55: nvl(per_per_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 52: nvl(p_rec.attribute16, hr_api.g_varchar2) or

48: nvl(p_rec.attribute14, hr_api.g_varchar2) or
49: nvl(per_per_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
50: nvl(p_rec.attribute15, hr_api.g_varchar2) or
51: nvl(per_per_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
52: nvl(p_rec.attribute16, hr_api.g_varchar2) or
53: nvl(per_per_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
54: nvl(p_rec.attribute17, hr_api.g_varchar2) or
55: nvl(per_per_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
56: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 53: nvl(per_per_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

49: nvl(per_per_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
50: nvl(p_rec.attribute15, hr_api.g_varchar2) or
51: nvl(per_per_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
52: nvl(p_rec.attribute16, hr_api.g_varchar2) or
53: nvl(per_per_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
54: nvl(p_rec.attribute17, hr_api.g_varchar2) or
55: nvl(per_per_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
56: nvl(p_rec.attribute18, hr_api.g_varchar2) or
57: nvl(per_per_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 54: nvl(p_rec.attribute17, hr_api.g_varchar2) or

50: nvl(p_rec.attribute15, hr_api.g_varchar2) or
51: nvl(per_per_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
52: nvl(p_rec.attribute16, hr_api.g_varchar2) or
53: nvl(per_per_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
54: nvl(p_rec.attribute17, hr_api.g_varchar2) or
55: nvl(per_per_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
56: nvl(p_rec.attribute18, hr_api.g_varchar2) or
57: nvl(per_per_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
58: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 55: nvl(per_per_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

51: nvl(per_per_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
52: nvl(p_rec.attribute16, hr_api.g_varchar2) or
53: nvl(per_per_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
54: nvl(p_rec.attribute17, hr_api.g_varchar2) or
55: nvl(per_per_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
56: nvl(p_rec.attribute18, hr_api.g_varchar2) or
57: nvl(per_per_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
58: nvl(p_rec.attribute19, hr_api.g_varchar2) or
59: nvl(per_per_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 56: nvl(p_rec.attribute18, hr_api.g_varchar2) or

52: nvl(p_rec.attribute16, hr_api.g_varchar2) or
53: nvl(per_per_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
54: nvl(p_rec.attribute17, hr_api.g_varchar2) or
55: nvl(per_per_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
56: nvl(p_rec.attribute18, hr_api.g_varchar2) or
57: nvl(per_per_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
58: nvl(p_rec.attribute19, hr_api.g_varchar2) or
59: nvl(per_per_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
60: nvl(p_rec.attribute20, hr_api.g_varchar2) or

Line 57: nvl(per_per_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

53: nvl(per_per_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
54: nvl(p_rec.attribute17, hr_api.g_varchar2) or
55: nvl(per_per_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
56: nvl(p_rec.attribute18, hr_api.g_varchar2) or
57: nvl(per_per_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
58: nvl(p_rec.attribute19, hr_api.g_varchar2) or
59: nvl(per_per_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
60: nvl(p_rec.attribute20, hr_api.g_varchar2) or
61: nvl(per_per_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

Line 58: nvl(p_rec.attribute19, hr_api.g_varchar2) or

54: nvl(p_rec.attribute17, hr_api.g_varchar2) or
55: nvl(per_per_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
56: nvl(p_rec.attribute18, hr_api.g_varchar2) or
57: nvl(per_per_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
58: nvl(p_rec.attribute19, hr_api.g_varchar2) or
59: nvl(per_per_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
60: nvl(p_rec.attribute20, hr_api.g_varchar2) or
61: nvl(per_per_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
62: nvl(p_rec.attribute21, hr_api.g_varchar2) or

Line 59: nvl(per_per_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

55: nvl(per_per_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
56: nvl(p_rec.attribute18, hr_api.g_varchar2) or
57: nvl(per_per_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
58: nvl(p_rec.attribute19, hr_api.g_varchar2) or
59: nvl(per_per_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
60: nvl(p_rec.attribute20, hr_api.g_varchar2) or
61: nvl(per_per_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
62: nvl(p_rec.attribute21, hr_api.g_varchar2) or
63: nvl(per_per_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

Line 60: nvl(p_rec.attribute20, hr_api.g_varchar2) or

56: nvl(p_rec.attribute18, hr_api.g_varchar2) or
57: nvl(per_per_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
58: nvl(p_rec.attribute19, hr_api.g_varchar2) or
59: nvl(per_per_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
60: nvl(p_rec.attribute20, hr_api.g_varchar2) or
61: nvl(per_per_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
62: nvl(p_rec.attribute21, hr_api.g_varchar2) or
63: nvl(per_per_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
64: nvl(p_rec.attribute22, hr_api.g_varchar2) or

Line 61: nvl(per_per_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

57: nvl(per_per_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
58: nvl(p_rec.attribute19, hr_api.g_varchar2) or
59: nvl(per_per_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
60: nvl(p_rec.attribute20, hr_api.g_varchar2) or
61: nvl(per_per_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
62: nvl(p_rec.attribute21, hr_api.g_varchar2) or
63: nvl(per_per_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
64: nvl(p_rec.attribute22, hr_api.g_varchar2) or
65: nvl(per_per_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

Line 62: nvl(p_rec.attribute21, hr_api.g_varchar2) or

58: nvl(p_rec.attribute19, hr_api.g_varchar2) or
59: nvl(per_per_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
60: nvl(p_rec.attribute20, hr_api.g_varchar2) or
61: nvl(per_per_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
62: nvl(p_rec.attribute21, hr_api.g_varchar2) or
63: nvl(per_per_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
64: nvl(p_rec.attribute22, hr_api.g_varchar2) or
65: nvl(per_per_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
66: nvl(p_rec.attribute23, hr_api.g_varchar2) or

Line 63: nvl(per_per_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

59: nvl(per_per_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
60: nvl(p_rec.attribute20, hr_api.g_varchar2) or
61: nvl(per_per_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
62: nvl(p_rec.attribute21, hr_api.g_varchar2) or
63: nvl(per_per_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
64: nvl(p_rec.attribute22, hr_api.g_varchar2) or
65: nvl(per_per_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
66: nvl(p_rec.attribute23, hr_api.g_varchar2) or
67: nvl(per_per_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

Line 64: nvl(p_rec.attribute22, hr_api.g_varchar2) or

60: nvl(p_rec.attribute20, hr_api.g_varchar2) or
61: nvl(per_per_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
62: nvl(p_rec.attribute21, hr_api.g_varchar2) or
63: nvl(per_per_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
64: nvl(p_rec.attribute22, hr_api.g_varchar2) or
65: nvl(per_per_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
66: nvl(p_rec.attribute23, hr_api.g_varchar2) or
67: nvl(per_per_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
68: nvl(p_rec.attribute24, hr_api.g_varchar2) or

Line 65: nvl(per_per_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

61: nvl(per_per_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
62: nvl(p_rec.attribute21, hr_api.g_varchar2) or
63: nvl(per_per_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
64: nvl(p_rec.attribute22, hr_api.g_varchar2) or
65: nvl(per_per_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
66: nvl(p_rec.attribute23, hr_api.g_varchar2) or
67: nvl(per_per_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
68: nvl(p_rec.attribute24, hr_api.g_varchar2) or
69: nvl(per_per_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

Line 66: nvl(p_rec.attribute23, hr_api.g_varchar2) or

62: nvl(p_rec.attribute21, hr_api.g_varchar2) or
63: nvl(per_per_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
64: nvl(p_rec.attribute22, hr_api.g_varchar2) or
65: nvl(per_per_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
66: nvl(p_rec.attribute23, hr_api.g_varchar2) or
67: nvl(per_per_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
68: nvl(p_rec.attribute24, hr_api.g_varchar2) or
69: nvl(per_per_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
70: nvl(p_rec.attribute25, hr_api.g_varchar2) or

Line 67: nvl(per_per_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

63: nvl(per_per_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
64: nvl(p_rec.attribute22, hr_api.g_varchar2) or
65: nvl(per_per_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
66: nvl(p_rec.attribute23, hr_api.g_varchar2) or
67: nvl(per_per_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
68: nvl(p_rec.attribute24, hr_api.g_varchar2) or
69: nvl(per_per_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
70: nvl(p_rec.attribute25, hr_api.g_varchar2) or
71: nvl(per_per_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

Line 68: nvl(p_rec.attribute24, hr_api.g_varchar2) or

64: nvl(p_rec.attribute22, hr_api.g_varchar2) or
65: nvl(per_per_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
66: nvl(p_rec.attribute23, hr_api.g_varchar2) or
67: nvl(per_per_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
68: nvl(p_rec.attribute24, hr_api.g_varchar2) or
69: nvl(per_per_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
70: nvl(p_rec.attribute25, hr_api.g_varchar2) or
71: nvl(per_per_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
72: nvl(p_rec.attribute26, hr_api.g_varchar2) or

Line 69: nvl(per_per_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

65: nvl(per_per_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
66: nvl(p_rec.attribute23, hr_api.g_varchar2) or
67: nvl(per_per_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
68: nvl(p_rec.attribute24, hr_api.g_varchar2) or
69: nvl(per_per_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
70: nvl(p_rec.attribute25, hr_api.g_varchar2) or
71: nvl(per_per_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
72: nvl(p_rec.attribute26, hr_api.g_varchar2) or
73: nvl(per_per_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

Line 70: nvl(p_rec.attribute25, hr_api.g_varchar2) or

66: nvl(p_rec.attribute23, hr_api.g_varchar2) or
67: nvl(per_per_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
68: nvl(p_rec.attribute24, hr_api.g_varchar2) or
69: nvl(per_per_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
70: nvl(p_rec.attribute25, hr_api.g_varchar2) or
71: nvl(per_per_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
72: nvl(p_rec.attribute26, hr_api.g_varchar2) or
73: nvl(per_per_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
74: nvl(p_rec.attribute27, hr_api.g_varchar2) or

Line 71: nvl(per_per_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

67: nvl(per_per_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
68: nvl(p_rec.attribute24, hr_api.g_varchar2) or
69: nvl(per_per_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
70: nvl(p_rec.attribute25, hr_api.g_varchar2) or
71: nvl(per_per_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
72: nvl(p_rec.attribute26, hr_api.g_varchar2) or
73: nvl(per_per_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
74: nvl(p_rec.attribute27, hr_api.g_varchar2) or
75: nvl(per_per_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

Line 72: nvl(p_rec.attribute26, hr_api.g_varchar2) or

68: nvl(p_rec.attribute24, hr_api.g_varchar2) or
69: nvl(per_per_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
70: nvl(p_rec.attribute25, hr_api.g_varchar2) or
71: nvl(per_per_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
72: nvl(p_rec.attribute26, hr_api.g_varchar2) or
73: nvl(per_per_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
74: nvl(p_rec.attribute27, hr_api.g_varchar2) or
75: nvl(per_per_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
76: nvl(p_rec.attribute28, hr_api.g_varchar2) or

Line 73: nvl(per_per_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

69: nvl(per_per_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
70: nvl(p_rec.attribute25, hr_api.g_varchar2) or
71: nvl(per_per_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
72: nvl(p_rec.attribute26, hr_api.g_varchar2) or
73: nvl(per_per_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
74: nvl(p_rec.attribute27, hr_api.g_varchar2) or
75: nvl(per_per_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
76: nvl(p_rec.attribute28, hr_api.g_varchar2) or
77: nvl(per_per_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

Line 74: nvl(p_rec.attribute27, hr_api.g_varchar2) or

70: nvl(p_rec.attribute25, hr_api.g_varchar2) or
71: nvl(per_per_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
72: nvl(p_rec.attribute26, hr_api.g_varchar2) or
73: nvl(per_per_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
74: nvl(p_rec.attribute27, hr_api.g_varchar2) or
75: nvl(per_per_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
76: nvl(p_rec.attribute28, hr_api.g_varchar2) or
77: nvl(per_per_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
78: nvl(p_rec.attribute29, hr_api.g_varchar2) or

Line 75: nvl(per_per_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

71: nvl(per_per_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
72: nvl(p_rec.attribute26, hr_api.g_varchar2) or
73: nvl(per_per_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
74: nvl(p_rec.attribute27, hr_api.g_varchar2) or
75: nvl(per_per_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
76: nvl(p_rec.attribute28, hr_api.g_varchar2) or
77: nvl(per_per_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
78: nvl(p_rec.attribute29, hr_api.g_varchar2) or
79: nvl(per_per_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

Line 76: nvl(p_rec.attribute28, hr_api.g_varchar2) or

72: nvl(p_rec.attribute26, hr_api.g_varchar2) or
73: nvl(per_per_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
74: nvl(p_rec.attribute27, hr_api.g_varchar2) or
75: nvl(per_per_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
76: nvl(p_rec.attribute28, hr_api.g_varchar2) or
77: nvl(per_per_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
78: nvl(p_rec.attribute29, hr_api.g_varchar2) or
79: nvl(per_per_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
80: nvl(p_rec.attribute30, hr_api.g_varchar2) then

Line 77: nvl(per_per_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

73: nvl(per_per_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
74: nvl(p_rec.attribute27, hr_api.g_varchar2) or
75: nvl(per_per_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
76: nvl(p_rec.attribute28, hr_api.g_varchar2) or
77: nvl(per_per_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
78: nvl(p_rec.attribute29, hr_api.g_varchar2) or
79: nvl(per_per_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
80: nvl(p_rec.attribute30, hr_api.g_varchar2) then
81: -- either the attribute_category or attribute1..30 have changed

Line 78: nvl(p_rec.attribute29, hr_api.g_varchar2) or

74: nvl(p_rec.attribute27, hr_api.g_varchar2) or
75: nvl(per_per_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
76: nvl(p_rec.attribute28, hr_api.g_varchar2) or
77: nvl(per_per_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
78: nvl(p_rec.attribute29, hr_api.g_varchar2) or
79: nvl(per_per_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
80: nvl(p_rec.attribute30, hr_api.g_varchar2) then
81: -- either the attribute_category or attribute1..30 have changed
82: -- so we must call the flex stub

Line 79: nvl(per_per_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

75: nvl(per_per_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
76: nvl(p_rec.attribute28, hr_api.g_varchar2) or
77: nvl(per_per_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
78: nvl(p_rec.attribute29, hr_api.g_varchar2) or
79: nvl(per_per_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
80: nvl(p_rec.attribute30, hr_api.g_varchar2) then
81: -- either the attribute_category or attribute1..30 have changed
82: -- so we must call the flex stub
83: per_per_flex.df(p_rec => p_rec);

Line 80: nvl(p_rec.attribute30, hr_api.g_varchar2) then

76: nvl(p_rec.attribute28, hr_api.g_varchar2) or
77: nvl(per_per_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
78: nvl(p_rec.attribute29, hr_api.g_varchar2) or
79: nvl(per_per_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
80: nvl(p_rec.attribute30, hr_api.g_varchar2) then
81: -- either the attribute_category or attribute1..30 have changed
82: -- so we must call the flex stub
83: per_per_flex.df(p_rec => p_rec);
84: end if;

Line 113: hr_api.mandatory_arg_error

109: hr_utility.set_location('Entering:'|| l_proc, 10);
110: --
111: -- Check mandatory parameters have been set
112: --
113: hr_api.mandatory_arg_error
114: (p_api_name => l_proc
115: ,p_argument => 'effective date'
116: ,p_argument_value => p_effective_date
117: );

Line 128: if (l_api_updating and nvl(per_per_shd.g_old_rec.fast_path_employee, hr_api.g_varchar2)

124: ,p_object_version_number => p_object_version_number
125: );
126: hr_utility.set_location('Entering:'|| l_proc, 20);
127: --
128: if (l_api_updating and nvl(per_per_shd.g_old_rec.fast_path_employee, hr_api.g_varchar2)
129: <> nvl(p_fast_path_employee, hr_api.g_varchar2))
130: or
131: (l_api_updating and nvl(per_per_shd.g_old_rec.order_name, hr_api.g_varchar2)
132: <> nvl(p_order_name, hr_api.g_varchar2))

Line 129: <> nvl(p_fast_path_employee, hr_api.g_varchar2))

125: );
126: hr_utility.set_location('Entering:'|| l_proc, 20);
127: --
128: if (l_api_updating and nvl(per_per_shd.g_old_rec.fast_path_employee, hr_api.g_varchar2)
129: <> nvl(p_fast_path_employee, hr_api.g_varchar2))
130: or
131: (l_api_updating and nvl(per_per_shd.g_old_rec.order_name, hr_api.g_varchar2)
132: <> nvl(p_order_name, hr_api.g_varchar2))
133: or

Line 131: (l_api_updating and nvl(per_per_shd.g_old_rec.order_name, hr_api.g_varchar2)

127: --
128: if (l_api_updating and nvl(per_per_shd.g_old_rec.fast_path_employee, hr_api.g_varchar2)
129: <> nvl(p_fast_path_employee, hr_api.g_varchar2))
130: or
131: (l_api_updating and nvl(per_per_shd.g_old_rec.order_name, hr_api.g_varchar2)
132: <> nvl(p_order_name, hr_api.g_varchar2))
133: or
134: (l_api_updating and nvl(per_per_shd.g_old_rec.projected_start_date, hr_api.g_date)
135: <> nvl(p_projected_start_date, hr_api.g_date))

Line 132: <> nvl(p_order_name, hr_api.g_varchar2))

128: if (l_api_updating and nvl(per_per_shd.g_old_rec.fast_path_employee, hr_api.g_varchar2)
129: <> nvl(p_fast_path_employee, hr_api.g_varchar2))
130: or
131: (l_api_updating and nvl(per_per_shd.g_old_rec.order_name, hr_api.g_varchar2)
132: <> nvl(p_order_name, hr_api.g_varchar2))
133: or
134: (l_api_updating and nvl(per_per_shd.g_old_rec.projected_start_date, hr_api.g_date)
135: <> nvl(p_projected_start_date, hr_api.g_date))
136: or

Line 134: (l_api_updating and nvl(per_per_shd.g_old_rec.projected_start_date, hr_api.g_date)

130: or
131: (l_api_updating and nvl(per_per_shd.g_old_rec.order_name, hr_api.g_varchar2)
132: <> nvl(p_order_name, hr_api.g_varchar2))
133: or
134: (l_api_updating and nvl(per_per_shd.g_old_rec.projected_start_date, hr_api.g_date)
135: <> nvl(p_projected_start_date, hr_api.g_date))
136: or
137: (l_api_updating and nvl(per_per_shd.g_old_rec.rehire_authorizor, hr_api.g_varchar2)
138: <> nvl(p_rehire_authorizor, hr_api.g_varchar2))

Line 135: <> nvl(p_projected_start_date, hr_api.g_date))

131: (l_api_updating and nvl(per_per_shd.g_old_rec.order_name, hr_api.g_varchar2)
132: <> nvl(p_order_name, hr_api.g_varchar2))
133: or
134: (l_api_updating and nvl(per_per_shd.g_old_rec.projected_start_date, hr_api.g_date)
135: <> nvl(p_projected_start_date, hr_api.g_date))
136: or
137: (l_api_updating and nvl(per_per_shd.g_old_rec.rehire_authorizor, hr_api.g_varchar2)
138: <> nvl(p_rehire_authorizor, hr_api.g_varchar2))
139: or

Line 137: (l_api_updating and nvl(per_per_shd.g_old_rec.rehire_authorizor, hr_api.g_varchar2)

133: or
134: (l_api_updating and nvl(per_per_shd.g_old_rec.projected_start_date, hr_api.g_date)
135: <> nvl(p_projected_start_date, hr_api.g_date))
136: or
137: (l_api_updating and nvl(per_per_shd.g_old_rec.rehire_authorizor, hr_api.g_varchar2)
138: <> nvl(p_rehire_authorizor, hr_api.g_varchar2))
139: or
140: (NOT l_api_updating)
141: then

Line 138: <> nvl(p_rehire_authorizor, hr_api.g_varchar2))

134: (l_api_updating and nvl(per_per_shd.g_old_rec.projected_start_date, hr_api.g_date)
135: <> nvl(p_projected_start_date, hr_api.g_date))
136: or
137: (l_api_updating and nvl(per_per_shd.g_old_rec.rehire_authorizor, hr_api.g_varchar2)
138: <> nvl(p_rehire_authorizor, hr_api.g_varchar2))
139: or
140: (NOT l_api_updating)
141: then
142: --

Line 214: hr_api.mandatory_arg_error

210: hr_utility.set_location('Entering:'|| l_proc, 10);
211: --
212: -- Check mandatory parameters have been set
213: --
214: hr_api.mandatory_arg_error
215: (p_api_name => l_proc
216: ,p_argument => 'effective date'
217: ,p_argument_value => p_effective_date
218: );

Line 230: nvl(per_per_shd.g_old_rec.correspondence_language, hr_api.g_varchar2)

226: );
227: hr_utility.set_location(l_proc, 20);
228: --
229: if ((l_api_updating and
230: nvl(per_per_shd.g_old_rec.correspondence_language, hr_api.g_varchar2)
231: <> nvl(p_correspondence_language, hr_api.g_varchar2)) or
232: (NOT l_api_updating))
233: then
234: --

Line 231: <> nvl(p_correspondence_language, hr_api.g_varchar2)) or

227: hr_utility.set_location(l_proc, 20);
228: --
229: if ((l_api_updating and
230: nvl(per_per_shd.g_old_rec.correspondence_language, hr_api.g_varchar2)
231: <> nvl(p_correspondence_language, hr_api.g_varchar2)) or
232: (NOT l_api_updating))
233: then
234: --
235: -- Check if correspondence language is set.

Line 292: nvl(p_coord_ben_med_cvg_end_dt,hr_api.g_eot)) then

288: --
289: if (p_coord_ben_med_cvg_strt_dt is null and
290: p_coord_ben_med_cvg_end_dt is not null) or
291: (p_coord_ben_med_cvg_strt_dt >
292: nvl(p_coord_ben_med_cvg_end_dt,hr_api.g_eot)) then
293: --
294: -- Error as end dt can not be set unless strt dt has been set
295: --
296: fnd_message.set_name('PER','HR_289110_MED_CVG_DATES');

Line 344: nvl(p_coord_ben_med_cvg_end_dt,hr_api.g_eot) > p_effective_date) then

340: )
341: then
342: if p_attribute10 = 'Y' or
343: (p_coord_ben_med_insr_crr_name is not null and
344: nvl(p_coord_ben_med_cvg_end_dt,hr_api.g_eot) > p_effective_date) then
345: --
346: if p_coord_ben_no_cvg_flag = 'Y' then
347: --
348: fnd_message.set_name('PER','HR_289111_CVG_FLAG_SET');

Line 390: hr_api.mandatory_arg_error

386: hr_utility.set_location('Entering:'|| l_proc, 10);
387: --
388: -- Check mandatory parameters have been set
389: --
390: hr_api.mandatory_arg_error
391: (p_api_name => l_proc
392: ,p_argument => 'effective date'
393: ,p_argument_value => p_effective_date
394: );

Line 406: nvl(per_per_shd.g_old_rec.fte_capacity, hr_api.g_number)

402: );
403: hr_utility.set_location(l_proc, 20);
404: --
405: if ((l_api_updating and
406: nvl(per_per_shd.g_old_rec.fte_capacity, hr_api.g_number)
407: <> nvl(p_fte_capacity, hr_api.g_number)) or
408: (NOT l_api_updating))
409: then
410: --

Line 407: <> nvl(p_fte_capacity, hr_api.g_number)) or

403: hr_utility.set_location(l_proc, 20);
404: --
405: if ((l_api_updating and
406: nvl(per_per_shd.g_old_rec.fte_capacity, hr_api.g_number)
407: <> nvl(p_fte_capacity, hr_api.g_number)) or
408: (NOT l_api_updating))
409: then
410: --
411: -- Check if fte_capacity is set.

Line 520: hr_api.mandatory_arg_error

516: hr_utility.set_location('Entering:'|| l_proc, 10);
517: --
518: -- Check mandatory parameters have been set
519: --
520: hr_api.mandatory_arg_error
521: (p_api_name => l_proc
522: ,p_argument => 'effective date'
523: ,p_argument_value => p_effective_date
524: );

Line 526: hr_api.mandatory_arg_error

522: ,p_argument => 'effective date'
523: ,p_argument_value => p_effective_date
524: );
525: --
526: hr_api.mandatory_arg_error
527: (p_api_name => l_proc
528: ,p_argument => 'validation_start_date'
529: ,p_argument_value => p_validation_start_date
530: );

Line 532: hr_api.mandatory_arg_error

528: ,p_argument => 'validation_start_date'
529: ,p_argument_value => p_validation_start_date
530: );
531: --
532: hr_api.mandatory_arg_error
533: (p_api_name => l_proc
534: ,p_argument => 'validation_end_date'
535: ,p_argument_value => p_validation_end_date
536: );

Line 548: nvl(per_per_shd.g_old_rec.BACKGROUND_CHECK_STATUS, hr_api.g_varchar2)

544: );
545: hr_utility.set_location('Entering:'|| l_proc, 20);
546: --
547: if ((l_api_updating and
548: nvl(per_per_shd.g_old_rec.BACKGROUND_CHECK_STATUS, hr_api.g_varchar2)
549: <> nvl(p_BACKGROUND_CHECK_STATUS, hr_api.g_varchar2)) or
550: (NOT l_api_updating))
551: then
552: --

Line 549: <> nvl(p_BACKGROUND_CHECK_STATUS, hr_api.g_varchar2)) or

545: hr_utility.set_location('Entering:'|| l_proc, 20);
546: --
547: if ((l_api_updating and
548: nvl(per_per_shd.g_old_rec.BACKGROUND_CHECK_STATUS, hr_api.g_varchar2)
549: <> nvl(p_BACKGROUND_CHECK_STATUS, hr_api.g_varchar2)) or
550: (NOT l_api_updating))
551: then
552: --
553: -- Check if Background Check Status is set.

Line 562: if hr_api.not_exists_in_dt_hr_lookups

558: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that the
559: -- effective start date of the Person is between start date active and
560: -- end date active in hr_lookups.
561: --
562: if hr_api.not_exists_in_dt_hr_lookups
563: (p_effective_date => p_effective_date
564: ,p_validation_start_date => p_validation_start_date
565: ,p_validation_end_date => p_validation_end_date
566: ,p_lookup_type => 'YES_NO'

Line 616: hr_api.mandatory_arg_error

612: hr_utility.set_location('Entering:'|| l_proc, 10);
613: --
614: -- Check mandatory parameters have been set
615: --
616: hr_api.mandatory_arg_error
617: (p_api_name => l_proc
618: ,p_argument => 'effective date'
619: ,p_argument_value => p_effective_date
620: );

Line 622: hr_api.mandatory_arg_error

618: ,p_argument => 'effective date'
619: ,p_argument_value => p_effective_date
620: );
621: --
622: hr_api.mandatory_arg_error
623: (p_api_name => l_proc
624: ,p_argument => 'validation_start_date'
625: ,p_argument_value => p_validation_start_date
626: );

Line 628: hr_api.mandatory_arg_error

624: ,p_argument => 'validation_start_date'
625: ,p_argument_value => p_validation_start_date
626: );
627: --
628: hr_api.mandatory_arg_error
629: (p_api_name => l_proc
630: ,p_argument => 'validation_end_date'
631: ,p_argument_value => p_validation_end_date
632: );

Line 644: nvl(per_per_shd.g_old_rec.blood_type, hr_api.g_varchar2)

640: );
641: hr_utility.set_location('Entering:'|| l_proc, 20);
642: --
643: if ((l_api_updating and
644: nvl(per_per_shd.g_old_rec.blood_type, hr_api.g_varchar2)
645: <> nvl(p_blood_type, hr_api.g_varchar2)) or
646: (NOT l_api_updating))
647: then
648: --

Line 645: <> nvl(p_blood_type, hr_api.g_varchar2)) or

641: hr_utility.set_location('Entering:'|| l_proc, 20);
642: --
643: if ((l_api_updating and
644: nvl(per_per_shd.g_old_rec.blood_type, hr_api.g_varchar2)
645: <> nvl(p_blood_type, hr_api.g_varchar2)) or
646: (NOT l_api_updating))
647: then
648: --
649: -- Check if Blood Type is set.

Line 658: if hr_api.not_exists_in_dt_hr_lookups

654: -- lookup type 'BLOOD_TYPE' with an enabled flag set to 'Y' and that the
655: -- effective start date of the Person is between start date active and
656: -- end date active in hr_lookups.
657: --
658: if hr_api.not_exists_in_dt_hr_lookups
659: (p_effective_date => p_effective_date
660: ,p_validation_start_date => p_validation_start_date
661: ,p_validation_end_date => p_validation_end_date
662: ,p_lookup_type => 'BLOOD_TYPE'

Line 712: hr_api.mandatory_arg_error

708: hr_utility.set_location('Entering:'|| l_proc, 10);
709: --
710: -- Check mandatory parameters have been set
711: --
712: hr_api.mandatory_arg_error
713: (p_api_name => l_proc
714: ,p_argument => 'effective date'
715: ,p_argument_value => p_effective_date
716: );

Line 718: hr_api.mandatory_arg_error

714: ,p_argument => 'effective date'
715: ,p_argument_value => p_effective_date
716: );
717: --
718: hr_api.mandatory_arg_error
719: (p_api_name => l_proc
720: ,p_argument => 'validation_start_date'
721: ,p_argument_value => p_validation_start_date
722: );

Line 724: hr_api.mandatory_arg_error

720: ,p_argument => 'validation_start_date'
721: ,p_argument_value => p_validation_start_date
722: );
723: --
724: hr_api.mandatory_arg_error
725: (p_api_name => l_proc
726: ,p_argument => 'validation_end_date'
727: ,p_argument_value => p_validation_end_date
728: );

Line 740: nvl(per_per_shd.g_old_rec.student_status, hr_api.g_varchar2)

736: );
737: hr_utility.set_location('Entering:'|| l_proc, 20);
738: --
739: if ((l_api_updating and
740: nvl(per_per_shd.g_old_rec.student_status, hr_api.g_varchar2)
741: <> nvl(p_student_status, hr_api.g_varchar2)) or
742: (NOT l_api_updating))
743: then
744: --

Line 741: <> nvl(p_student_status, hr_api.g_varchar2)) or

737: hr_utility.set_location('Entering:'|| l_proc, 20);
738: --
739: if ((l_api_updating and
740: nvl(per_per_shd.g_old_rec.student_status, hr_api.g_varchar2)
741: <> nvl(p_student_status, hr_api.g_varchar2)) or
742: (NOT l_api_updating))
743: then
744: --
745: -- Check if Student Status is set.

Line 754: if hr_api.not_exists_in_dt_hr_lookups

750: -- lookup type 'STUDENT_STATUS' with an enabled flag set to 'Y' and that the
751: -- effective start date of the Person is between start date active and
752: -- end date active in hr_lookups.
753: --
754: if hr_api.not_exists_in_dt_hr_lookups
755: (p_effective_date => p_effective_date
756: ,p_validation_start_date => p_validation_start_date
757: ,p_validation_end_date => p_validation_end_date
758: ,p_lookup_type => 'STUDENT_STATUS'

Line 808: hr_api.mandatory_arg_error

804: hr_utility.set_location('Entering:'|| l_proc, 10);
805: --
806: -- Check mandatory parameters have been set
807: --
808: hr_api.mandatory_arg_error
809: (p_api_name => l_proc
810: ,p_argument => 'effective date'
811: ,p_argument_value => p_effective_date
812: );

Line 814: hr_api.mandatory_arg_error

810: ,p_argument => 'effective date'
811: ,p_argument_value => p_effective_date
812: );
813: --
814: hr_api.mandatory_arg_error
815: (p_api_name => l_proc
816: ,p_argument => 'validation_start_date'
817: ,p_argument_value => p_validation_start_date
818: );

Line 820: hr_api.mandatory_arg_error

816: ,p_argument => 'validation_start_date'
817: ,p_argument_value => p_validation_start_date
818: );
819: --
820: hr_api.mandatory_arg_error
821: (p_api_name => l_proc
822: ,p_argument => 'validation_end_date'
823: ,p_argument_value => p_validation_end_date
824: );

Line 836: nvl(per_per_shd.g_old_rec.work_schedule, hr_api.g_varchar2)

832: );
833: hr_utility.set_location('Entering:'|| l_proc, 20);
834: --
835: if ((l_api_updating and
836: nvl(per_per_shd.g_old_rec.work_schedule, hr_api.g_varchar2)
837: <> nvl(p_work_schedule, hr_api.g_varchar2)) or
838: (NOT l_api_updating))
839: then
840: --

Line 837: <> nvl(p_work_schedule, hr_api.g_varchar2)) or

833: hr_utility.set_location('Entering:'|| l_proc, 20);
834: --
835: if ((l_api_updating and
836: nvl(per_per_shd.g_old_rec.work_schedule, hr_api.g_varchar2)
837: <> nvl(p_work_schedule, hr_api.g_varchar2)) or
838: (NOT l_api_updating))
839: then
840: --
841: -- Check if Work Schedule is set.

Line 850: if hr_api.not_exists_in_dt_hr_lookups

846: -- lookup type 'WORK_SCHEDULE' with an enabled flag set to 'Y' and that the
847: -- effective start date of the Person is between start date active and
848: -- end date active in hr_lookups.
849: --
850: if hr_api.not_exists_in_dt_hr_lookups
851: (p_effective_date => p_effective_date
852: ,p_validation_start_date => p_validation_start_date
853: ,p_validation_end_date => p_validation_end_date
854: ,p_lookup_type => 'WORK_SCHEDULE'

Line 904: hr_api.mandatory_arg_error

900: hr_utility.set_location('Entering:'|| l_proc, 10);
901: --
902: -- Check mandatory parameters have been set
903: --
904: hr_api.mandatory_arg_error
905: (p_api_name => l_proc
906: ,p_argument => 'effective date'
907: ,p_argument_value => p_effective_date
908: );

Line 910: hr_api.mandatory_arg_error

906: ,p_argument => 'effective date'
907: ,p_argument_value => p_effective_date
908: );
909: --
910: hr_api.mandatory_arg_error
911: (p_api_name => l_proc
912: ,p_argument => 'validation_start_date'
913: ,p_argument_value => p_validation_start_date
914: );

Line 916: hr_api.mandatory_arg_error

912: ,p_argument => 'validation_start_date'
913: ,p_argument_value => p_validation_start_date
914: );
915: --
916: hr_api.mandatory_arg_error
917: (p_api_name => l_proc
918: ,p_argument => 'validation_end_date'
919: ,p_argument_value => p_validation_end_date
920: );

Line 932: nvl(per_per_shd.g_old_rec.rehire_recommendation, hr_api.g_varchar2)

928: );
929: hr_utility.set_location('Entering:'|| l_proc, 20);
930: --
931: if ((l_api_updating and
932: nvl(per_per_shd.g_old_rec.rehire_recommendation, hr_api.g_varchar2)
933: <> nvl(p_rehire_recommendation, hr_api.g_varchar2)) or
934: (NOT l_api_updating))
935: then
936: --

Line 933: <> nvl(p_rehire_recommendation, hr_api.g_varchar2)) or

929: hr_utility.set_location('Entering:'|| l_proc, 20);
930: --
931: if ((l_api_updating and
932: nvl(per_per_shd.g_old_rec.rehire_recommendation, hr_api.g_varchar2)
933: <> nvl(p_rehire_recommendation, hr_api.g_varchar2)) or
934: (NOT l_api_updating))
935: then
936: --
937: -- Check if Rehire Recommendation is set.

Line 946: if hr_api.not_exists_in_dt_hr_lookups

942: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that the
943: -- effective start date of the Person is between start date active and
944: -- end date active in hr_lookups.
945: --
946: if hr_api.not_exists_in_dt_hr_lookups
947: (p_effective_date => p_effective_date
948: ,p_validation_start_date => p_validation_start_date
949: ,p_validation_end_date => p_validation_end_date
950: ,p_lookup_type => 'YES_NO'

Line 1028: hr_api.mandatory_arg_error

1024: hr_utility.set_location('Entering:'|| l_proc, 10);
1025: --
1026: -- Check mandatory parameters have been set
1027: --
1028: hr_api.mandatory_arg_error
1029: (p_api_name => l_proc
1030: ,p_argument => 'effective_date'
1031: ,p_argument_value => p_effective_date
1032: );

Line 1114: elsif p_receipt_of_death_cert_date <= nvl(p_date_of_death, hr_api.g_date) then

1110: hr_multi_message.add
1111: (p_associated_column1 => 'PER_ALL_PEOPLE_F.RECEIPT_OF_DEATH_CERT_DATE'
1112: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.DATE_OF_DEATH'
1113: );
1114: elsif p_receipt_of_death_cert_date <= nvl(p_date_of_death, hr_api.g_date) then
1115: hr_utility.set_message(800,'PER_52962_CERT_DTE_LT_DOD');
1116: hr_multi_message.add
1117: (p_associated_column1 => 'PER_ALL_PEOPLE_F.RECEIPT_OF_DEATH_CERT_DATE'
1118: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.DATE_OF_DEATH'

Line 1184: elsif p_dpdnt_adoption_date < nvl(p_date_of_birth, hr_api.g_date) then

1180: );
1181:
1182: -- bug fix : 2164967 begins
1183:
1184: elsif p_dpdnt_adoption_date < nvl(p_date_of_birth, hr_api.g_date) then
1185: hr_utility.set_message(800,'PER_52961_ADOPT_LT_DOB');
1186: hr_multi_message.add
1187: (p_associated_column1 => 'PER_ALL_PEOPLE_F.DPDNT_ADOPTION_DATE'
1188: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.DATE_OF_BIRTH'

Line 1256: if p_date_of_death < nvl(p_date_of_birth, hr_api.g_date) then --fix for bug 4262496.

1252: (p_check_column1 => 'PER_ALL_PEOPLE_F.DATE_OF_BIRTH'
1253: ,p_check_column2 => 'PER_ALL_PEOPLE_F.DATE_OF_DEATH'
1254: ) then
1255: if p_date_of_death is NOT NULL then
1256: if p_date_of_death < nvl(p_date_of_birth, hr_api.g_date) then --fix for bug 4262496.
1257: hr_utility.set_message(800,'PER_52963_DOD_LT_DOB');
1258: hr_utility.raise_error;
1259: end if;
1260: end if;

Line 1346: hr_api.mandatory_arg_error

1342: hr_utility.set_location('Entering:'|| l_proc, 10);
1343: --
1344: -- Check mandatory parameters have been set
1345: --
1346: hr_api.mandatory_arg_error
1347: (p_api_name => l_proc
1348: ,p_argument => 'effective date'
1349: ,p_argument_value => p_effective_date
1350: );

Line 1352: hr_api.mandatory_arg_error

1348: ,p_argument => 'effective date'
1349: ,p_argument_value => p_effective_date
1350: );
1351: --
1352: hr_api.mandatory_arg_error
1353: (p_api_name => l_proc
1354: ,p_argument => 'validation_start_date'
1355: ,p_argument_value => p_validation_start_date
1356: );

Line 1358: hr_api.mandatory_arg_error

1354: ,p_argument => 'validation_start_date'
1355: ,p_argument_value => p_validation_start_date
1356: );
1357: --
1358: hr_api.mandatory_arg_error
1359: (p_api_name => l_proc
1360: ,p_argument => 'validation_end_date'
1361: ,p_argument_value => p_validation_end_date
1362: );

Line 1374: if hr_api.not_exists_in_dt_hr_lookups

1370: -- lookup type 'REGISTERED_DISABLED' with an enabled flag set to 'Y' and that the
1371: -- effective start date of the Person is between start date active and
1372: -- end date active in hr_lookups.
1373: --
1374: if hr_api.not_exists_in_dt_hr_lookups
1375: (p_effective_date => p_effective_date
1376: ,p_validation_start_date => p_validation_start_date
1377: ,p_validation_end_date => p_validation_end_date
1378: ,p_lookup_type => 'REGISTERED_DISABLED'

Line 1460: hr_api.mandatory_arg_error

1456: hr_utility.set_location('Entering:'|| l_proc, 10);
1457: --
1458: -- Check mandatory parameters have been set
1459: --
1460: hr_api.mandatory_arg_error
1461: (p_api_name => l_proc
1462: ,p_argument => 'effective date'
1463: ,p_argument_value => p_effective_date
1464: );

Line 1466: hr_api.mandatory_arg_error

1462: ,p_argument => 'effective date'
1463: ,p_argument_value => p_effective_date
1464: );
1465: --
1466: hr_api.mandatory_arg_error
1467: (p_api_name => l_proc
1468: ,p_argument => 'validation_start_date'
1469: ,p_argument_value => p_validation_start_date
1470: );

Line 1472: hr_api.mandatory_arg_error

1468: ,p_argument => 'validation_start_date'
1469: ,p_argument_value => p_validation_start_date
1470: );
1471: --
1472: hr_api.mandatory_arg_error
1473: (p_api_name => l_proc
1474: ,p_argument => 'validation_end_date'
1475: ,p_argument_value => p_validation_end_date
1476: );

Line 1488: if hr_api.not_exists_in_dt_hr_lookups

1484: -- lookup type 'TOBACCO_USER' with an enabled flag set to 'Y' and that the
1485: -- effective start date of the Person is between start date active and
1486: -- end date active in hr_lookups.
1487: --
1488: if hr_api.not_exists_in_dt_hr_lookups
1489: (p_effective_date => p_effective_date
1490: ,p_validation_start_date => p_validation_start_date
1491: ,p_validation_end_date => p_validation_end_date
1492: ,p_lookup_type => 'TOBACCO_USER'