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 PER_PER_SHD

Line 12: (p_rec in per_per_shd.g_rec_type) is

8: g_package varchar2(33) := ' per_per_bus1.'; -- Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: --
11: procedure df_update_validate
12: (p_rec in per_per_shd.g_rec_type) is
13: --
14: l_proc varchar2(72) := g_package||'df_update_validate';
15: --
16: begin

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 121: l_api_updating := per_per_shd.api_updating

117: );
118: --
119: -- Check if the person is being updated
120: --
121: l_api_updating := per_per_shd.api_updating
122: (p_person_id => p_person_id
123: ,p_effective_date => p_effective_date
124: ,p_object_version_number => p_object_version_number
125: );

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 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 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 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 222: l_api_updating := per_per_shd.api_updating

218: );
219: --
220: -- Check if the person is being updated
221: --
222: l_api_updating := per_per_shd.api_updating
223: (p_person_id => p_person_id
224: ,p_effective_date => p_effective_date
225: ,p_object_version_number => p_object_version_number
226: );

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 398: l_api_updating := per_per_shd.api_updating

394: );
395: --
396: -- Check if the person is being updated
397: --
398: l_api_updating := per_per_shd.api_updating
399: (p_person_id => p_person_id
400: ,p_effective_date => p_effective_date
401: ,p_object_version_number => p_object_version_number
402: );

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 540: l_api_updating := per_per_shd.api_updating

536: );
537: --
538: -- Check if the person is being updated
539: --
540: l_api_updating := per_per_shd.api_updating
541: (p_person_id => p_person_id
542: ,p_effective_date => p_effective_date
543: ,p_object_version_number => p_object_version_number
544: );

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 636: l_api_updating := per_per_shd.api_updating

632: );
633: --
634: -- Check if the person is being updated
635: --
636: l_api_updating := per_per_shd.api_updating
637: (p_person_id => p_person_id
638: ,p_effective_date => p_effective_date
639: ,p_object_version_number => p_object_version_number
640: );

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 732: l_api_updating := per_per_shd.api_updating

728: );
729: --
730: -- Check if the person is being updated
731: --
732: l_api_updating := per_per_shd.api_updating
733: (p_person_id => p_person_id
734: ,p_effective_date => p_effective_date
735: ,p_object_version_number => p_object_version_number
736: );

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 828: l_api_updating := per_per_shd.api_updating

824: );
825: --
826: -- Check if the person is being updated
827: --
828: l_api_updating := per_per_shd.api_updating
829: (p_person_id => p_person_id
830: ,p_effective_date => p_effective_date
831: ,p_object_version_number => p_object_version_number
832: );

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 924: l_api_updating := per_per_shd.api_updating

920: );
921: --
922: -- Check if the person is being updated
923: --
924: l_api_updating := per_per_shd.api_updating
925: (p_person_id => p_person_id
926: ,p_effective_date => p_effective_date
927: ,p_object_version_number => p_object_version_number
928: );

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