44: begin
45: hr_utility.set_location('Entering:'||l_proc,10);
46: --
47: if ((p_rec.activity_version_id is not null) and (
48: nvl(ota_tav_shd.g_old_rec.tav_information_category, hr_api.g_varchar2) <>
49: nvl(p_rec.tav_information_category, hr_api.g_varchar2) or
50: nvl(ota_tav_shd.g_old_rec.tav_information1, hr_api.g_varchar2) <>
51: nvl(p_rec.tav_information1, hr_api.g_varchar2) or
52: nvl(ota_tav_shd.g_old_rec.tav_information2, hr_api.g_varchar2) <>
45: hr_utility.set_location('Entering:'||l_proc,10);
46: --
47: if ((p_rec.activity_version_id is not null) and (
48: nvl(ota_tav_shd.g_old_rec.tav_information_category, hr_api.g_varchar2) <>
49: nvl(p_rec.tav_information_category, hr_api.g_varchar2) or
50: nvl(ota_tav_shd.g_old_rec.tav_information1, hr_api.g_varchar2) <>
51: nvl(p_rec.tav_information1, hr_api.g_varchar2) or
52: nvl(ota_tav_shd.g_old_rec.tav_information2, hr_api.g_varchar2) <>
53: nvl(p_rec.tav_information2, hr_api.g_varchar2) or
46: --
47: if ((p_rec.activity_version_id is not null) and (
48: nvl(ota_tav_shd.g_old_rec.tav_information_category, hr_api.g_varchar2) <>
49: nvl(p_rec.tav_information_category, hr_api.g_varchar2) or
50: nvl(ota_tav_shd.g_old_rec.tav_information1, hr_api.g_varchar2) <>
51: nvl(p_rec.tav_information1, hr_api.g_varchar2) or
52: nvl(ota_tav_shd.g_old_rec.tav_information2, hr_api.g_varchar2) <>
53: nvl(p_rec.tav_information2, hr_api.g_varchar2) or
54: nvl(ota_tav_shd.g_old_rec.tav_information3, hr_api.g_varchar2) <>
47: if ((p_rec.activity_version_id is not null) and (
48: nvl(ota_tav_shd.g_old_rec.tav_information_category, hr_api.g_varchar2) <>
49: nvl(p_rec.tav_information_category, hr_api.g_varchar2) or
50: nvl(ota_tav_shd.g_old_rec.tav_information1, hr_api.g_varchar2) <>
51: nvl(p_rec.tav_information1, hr_api.g_varchar2) or
52: nvl(ota_tav_shd.g_old_rec.tav_information2, hr_api.g_varchar2) <>
53: nvl(p_rec.tav_information2, hr_api.g_varchar2) or
54: nvl(ota_tav_shd.g_old_rec.tav_information3, hr_api.g_varchar2) <>
55: nvl(p_rec.tav_information3, hr_api.g_varchar2) or
48: nvl(ota_tav_shd.g_old_rec.tav_information_category, hr_api.g_varchar2) <>
49: nvl(p_rec.tav_information_category, hr_api.g_varchar2) or
50: nvl(ota_tav_shd.g_old_rec.tav_information1, hr_api.g_varchar2) <>
51: nvl(p_rec.tav_information1, hr_api.g_varchar2) or
52: nvl(ota_tav_shd.g_old_rec.tav_information2, hr_api.g_varchar2) <>
53: nvl(p_rec.tav_information2, hr_api.g_varchar2) or
54: nvl(ota_tav_shd.g_old_rec.tav_information3, hr_api.g_varchar2) <>
55: nvl(p_rec.tav_information3, hr_api.g_varchar2) or
56: nvl(ota_tav_shd.g_old_rec.tav_information4, hr_api.g_varchar2) <>
49: nvl(p_rec.tav_information_category, hr_api.g_varchar2) or
50: nvl(ota_tav_shd.g_old_rec.tav_information1, hr_api.g_varchar2) <>
51: nvl(p_rec.tav_information1, hr_api.g_varchar2) or
52: nvl(ota_tav_shd.g_old_rec.tav_information2, hr_api.g_varchar2) <>
53: nvl(p_rec.tav_information2, hr_api.g_varchar2) or
54: nvl(ota_tav_shd.g_old_rec.tav_information3, hr_api.g_varchar2) <>
55: nvl(p_rec.tav_information3, hr_api.g_varchar2) or
56: nvl(ota_tav_shd.g_old_rec.tav_information4, hr_api.g_varchar2) <>
57: nvl(p_rec.tav_information4, hr_api.g_varchar2) or
50: nvl(ota_tav_shd.g_old_rec.tav_information1, hr_api.g_varchar2) <>
51: nvl(p_rec.tav_information1, hr_api.g_varchar2) or
52: nvl(ota_tav_shd.g_old_rec.tav_information2, hr_api.g_varchar2) <>
53: nvl(p_rec.tav_information2, hr_api.g_varchar2) or
54: nvl(ota_tav_shd.g_old_rec.tav_information3, hr_api.g_varchar2) <>
55: nvl(p_rec.tav_information3, hr_api.g_varchar2) or
56: nvl(ota_tav_shd.g_old_rec.tav_information4, hr_api.g_varchar2) <>
57: nvl(p_rec.tav_information4, hr_api.g_varchar2) or
58: nvl(ota_tav_shd.g_old_rec.tav_information5, hr_api.g_varchar2) <>
51: nvl(p_rec.tav_information1, hr_api.g_varchar2) or
52: nvl(ota_tav_shd.g_old_rec.tav_information2, hr_api.g_varchar2) <>
53: nvl(p_rec.tav_information2, hr_api.g_varchar2) or
54: nvl(ota_tav_shd.g_old_rec.tav_information3, hr_api.g_varchar2) <>
55: nvl(p_rec.tav_information3, hr_api.g_varchar2) or
56: nvl(ota_tav_shd.g_old_rec.tav_information4, hr_api.g_varchar2) <>
57: nvl(p_rec.tav_information4, hr_api.g_varchar2) or
58: nvl(ota_tav_shd.g_old_rec.tav_information5, hr_api.g_varchar2) <>
59: nvl(p_rec.tav_information5, hr_api.g_varchar2) or
52: nvl(ota_tav_shd.g_old_rec.tav_information2, hr_api.g_varchar2) <>
53: nvl(p_rec.tav_information2, hr_api.g_varchar2) or
54: nvl(ota_tav_shd.g_old_rec.tav_information3, hr_api.g_varchar2) <>
55: nvl(p_rec.tav_information3, hr_api.g_varchar2) or
56: nvl(ota_tav_shd.g_old_rec.tav_information4, hr_api.g_varchar2) <>
57: nvl(p_rec.tav_information4, hr_api.g_varchar2) or
58: nvl(ota_tav_shd.g_old_rec.tav_information5, hr_api.g_varchar2) <>
59: nvl(p_rec.tav_information5, hr_api.g_varchar2) or
60: nvl(ota_tav_shd.g_old_rec.tav_information6, hr_api.g_varchar2) <>
53: nvl(p_rec.tav_information2, hr_api.g_varchar2) or
54: nvl(ota_tav_shd.g_old_rec.tav_information3, hr_api.g_varchar2) <>
55: nvl(p_rec.tav_information3, hr_api.g_varchar2) or
56: nvl(ota_tav_shd.g_old_rec.tav_information4, hr_api.g_varchar2) <>
57: nvl(p_rec.tav_information4, hr_api.g_varchar2) or
58: nvl(ota_tav_shd.g_old_rec.tav_information5, hr_api.g_varchar2) <>
59: nvl(p_rec.tav_information5, hr_api.g_varchar2) or
60: nvl(ota_tav_shd.g_old_rec.tav_information6, hr_api.g_varchar2) <>
61: nvl(p_rec.tav_information6, hr_api.g_varchar2) or
54: nvl(ota_tav_shd.g_old_rec.tav_information3, hr_api.g_varchar2) <>
55: nvl(p_rec.tav_information3, hr_api.g_varchar2) or
56: nvl(ota_tav_shd.g_old_rec.tav_information4, hr_api.g_varchar2) <>
57: nvl(p_rec.tav_information4, hr_api.g_varchar2) or
58: nvl(ota_tav_shd.g_old_rec.tav_information5, hr_api.g_varchar2) <>
59: nvl(p_rec.tav_information5, hr_api.g_varchar2) or
60: nvl(ota_tav_shd.g_old_rec.tav_information6, hr_api.g_varchar2) <>
61: nvl(p_rec.tav_information6, hr_api.g_varchar2) or
62: nvl(ota_tav_shd.g_old_rec.tav_information7, hr_api.g_varchar2) <>
55: nvl(p_rec.tav_information3, hr_api.g_varchar2) or
56: nvl(ota_tav_shd.g_old_rec.tav_information4, hr_api.g_varchar2) <>
57: nvl(p_rec.tav_information4, hr_api.g_varchar2) or
58: nvl(ota_tav_shd.g_old_rec.tav_information5, hr_api.g_varchar2) <>
59: nvl(p_rec.tav_information5, hr_api.g_varchar2) or
60: nvl(ota_tav_shd.g_old_rec.tav_information6, hr_api.g_varchar2) <>
61: nvl(p_rec.tav_information6, hr_api.g_varchar2) or
62: nvl(ota_tav_shd.g_old_rec.tav_information7, hr_api.g_varchar2) <>
63: nvl(p_rec.tav_information7, hr_api.g_varchar2) or
56: nvl(ota_tav_shd.g_old_rec.tav_information4, hr_api.g_varchar2) <>
57: nvl(p_rec.tav_information4, hr_api.g_varchar2) or
58: nvl(ota_tav_shd.g_old_rec.tav_information5, hr_api.g_varchar2) <>
59: nvl(p_rec.tav_information5, hr_api.g_varchar2) or
60: nvl(ota_tav_shd.g_old_rec.tav_information6, hr_api.g_varchar2) <>
61: nvl(p_rec.tav_information6, hr_api.g_varchar2) or
62: nvl(ota_tav_shd.g_old_rec.tav_information7, hr_api.g_varchar2) <>
63: nvl(p_rec.tav_information7, hr_api.g_varchar2) or
64: nvl(ota_tav_shd.g_old_rec.tav_information8, hr_api.g_varchar2) <>
57: nvl(p_rec.tav_information4, hr_api.g_varchar2) or
58: nvl(ota_tav_shd.g_old_rec.tav_information5, hr_api.g_varchar2) <>
59: nvl(p_rec.tav_information5, hr_api.g_varchar2) or
60: nvl(ota_tav_shd.g_old_rec.tav_information6, hr_api.g_varchar2) <>
61: nvl(p_rec.tav_information6, hr_api.g_varchar2) or
62: nvl(ota_tav_shd.g_old_rec.tav_information7, hr_api.g_varchar2) <>
63: nvl(p_rec.tav_information7, hr_api.g_varchar2) or
64: nvl(ota_tav_shd.g_old_rec.tav_information8, hr_api.g_varchar2) <>
65: nvl(p_rec.tav_information8, hr_api.g_varchar2) or
58: nvl(ota_tav_shd.g_old_rec.tav_information5, hr_api.g_varchar2) <>
59: nvl(p_rec.tav_information5, hr_api.g_varchar2) or
60: nvl(ota_tav_shd.g_old_rec.tav_information6, hr_api.g_varchar2) <>
61: nvl(p_rec.tav_information6, hr_api.g_varchar2) or
62: nvl(ota_tav_shd.g_old_rec.tav_information7, hr_api.g_varchar2) <>
63: nvl(p_rec.tav_information7, hr_api.g_varchar2) or
64: nvl(ota_tav_shd.g_old_rec.tav_information8, hr_api.g_varchar2) <>
65: nvl(p_rec.tav_information8, hr_api.g_varchar2) or
66: nvl(ota_tav_shd.g_old_rec.tav_information9, hr_api.g_varchar2) <>
59: nvl(p_rec.tav_information5, hr_api.g_varchar2) or
60: nvl(ota_tav_shd.g_old_rec.tav_information6, hr_api.g_varchar2) <>
61: nvl(p_rec.tav_information6, hr_api.g_varchar2) or
62: nvl(ota_tav_shd.g_old_rec.tav_information7, hr_api.g_varchar2) <>
63: nvl(p_rec.tav_information7, hr_api.g_varchar2) or
64: nvl(ota_tav_shd.g_old_rec.tav_information8, hr_api.g_varchar2) <>
65: nvl(p_rec.tav_information8, hr_api.g_varchar2) or
66: nvl(ota_tav_shd.g_old_rec.tav_information9, hr_api.g_varchar2) <>
67: nvl(p_rec.tav_information9, hr_api.g_varchar2) or
60: nvl(ota_tav_shd.g_old_rec.tav_information6, hr_api.g_varchar2) <>
61: nvl(p_rec.tav_information6, hr_api.g_varchar2) or
62: nvl(ota_tav_shd.g_old_rec.tav_information7, hr_api.g_varchar2) <>
63: nvl(p_rec.tav_information7, hr_api.g_varchar2) or
64: nvl(ota_tav_shd.g_old_rec.tav_information8, hr_api.g_varchar2) <>
65: nvl(p_rec.tav_information8, hr_api.g_varchar2) or
66: nvl(ota_tav_shd.g_old_rec.tav_information9, hr_api.g_varchar2) <>
67: nvl(p_rec.tav_information9, hr_api.g_varchar2) or
68: nvl(ota_tav_shd.g_old_rec.tav_information10, hr_api.g_varchar2) <>
61: nvl(p_rec.tav_information6, hr_api.g_varchar2) or
62: nvl(ota_tav_shd.g_old_rec.tav_information7, hr_api.g_varchar2) <>
63: nvl(p_rec.tav_information7, hr_api.g_varchar2) or
64: nvl(ota_tav_shd.g_old_rec.tav_information8, hr_api.g_varchar2) <>
65: nvl(p_rec.tav_information8, hr_api.g_varchar2) or
66: nvl(ota_tav_shd.g_old_rec.tav_information9, hr_api.g_varchar2) <>
67: nvl(p_rec.tav_information9, hr_api.g_varchar2) or
68: nvl(ota_tav_shd.g_old_rec.tav_information10, hr_api.g_varchar2) <>
69: nvl(p_rec.tav_information10, hr_api.g_varchar2) or
62: nvl(ota_tav_shd.g_old_rec.tav_information7, hr_api.g_varchar2) <>
63: nvl(p_rec.tav_information7, hr_api.g_varchar2) or
64: nvl(ota_tav_shd.g_old_rec.tav_information8, hr_api.g_varchar2) <>
65: nvl(p_rec.tav_information8, hr_api.g_varchar2) or
66: nvl(ota_tav_shd.g_old_rec.tav_information9, hr_api.g_varchar2) <>
67: nvl(p_rec.tav_information9, hr_api.g_varchar2) or
68: nvl(ota_tav_shd.g_old_rec.tav_information10, hr_api.g_varchar2) <>
69: nvl(p_rec.tav_information10, hr_api.g_varchar2) or
70: nvl(ota_tav_shd.g_old_rec.tav_information11, hr_api.g_varchar2) <>
63: nvl(p_rec.tav_information7, hr_api.g_varchar2) or
64: nvl(ota_tav_shd.g_old_rec.tav_information8, hr_api.g_varchar2) <>
65: nvl(p_rec.tav_information8, hr_api.g_varchar2) or
66: nvl(ota_tav_shd.g_old_rec.tav_information9, hr_api.g_varchar2) <>
67: nvl(p_rec.tav_information9, hr_api.g_varchar2) or
68: nvl(ota_tav_shd.g_old_rec.tav_information10, hr_api.g_varchar2) <>
69: nvl(p_rec.tav_information10, hr_api.g_varchar2) or
70: nvl(ota_tav_shd.g_old_rec.tav_information11, hr_api.g_varchar2) <>
71: nvl(p_rec.tav_information11, hr_api.g_varchar2) or
64: nvl(ota_tav_shd.g_old_rec.tav_information8, hr_api.g_varchar2) <>
65: nvl(p_rec.tav_information8, hr_api.g_varchar2) or
66: nvl(ota_tav_shd.g_old_rec.tav_information9, hr_api.g_varchar2) <>
67: nvl(p_rec.tav_information9, hr_api.g_varchar2) or
68: nvl(ota_tav_shd.g_old_rec.tav_information10, hr_api.g_varchar2) <>
69: nvl(p_rec.tav_information10, hr_api.g_varchar2) or
70: nvl(ota_tav_shd.g_old_rec.tav_information11, hr_api.g_varchar2) <>
71: nvl(p_rec.tav_information11, hr_api.g_varchar2) or
72: nvl(ota_tav_shd.g_old_rec.tav_information12, hr_api.g_varchar2) <>
65: nvl(p_rec.tav_information8, hr_api.g_varchar2) or
66: nvl(ota_tav_shd.g_old_rec.tav_information9, hr_api.g_varchar2) <>
67: nvl(p_rec.tav_information9, hr_api.g_varchar2) or
68: nvl(ota_tav_shd.g_old_rec.tav_information10, hr_api.g_varchar2) <>
69: nvl(p_rec.tav_information10, hr_api.g_varchar2) or
70: nvl(ota_tav_shd.g_old_rec.tav_information11, hr_api.g_varchar2) <>
71: nvl(p_rec.tav_information11, hr_api.g_varchar2) or
72: nvl(ota_tav_shd.g_old_rec.tav_information12, hr_api.g_varchar2) <>
73: nvl(p_rec.tav_information12, hr_api.g_varchar2) or
66: nvl(ota_tav_shd.g_old_rec.tav_information9, hr_api.g_varchar2) <>
67: nvl(p_rec.tav_information9, hr_api.g_varchar2) or
68: nvl(ota_tav_shd.g_old_rec.tav_information10, hr_api.g_varchar2) <>
69: nvl(p_rec.tav_information10, hr_api.g_varchar2) or
70: nvl(ota_tav_shd.g_old_rec.tav_information11, hr_api.g_varchar2) <>
71: nvl(p_rec.tav_information11, hr_api.g_varchar2) or
72: nvl(ota_tav_shd.g_old_rec.tav_information12, hr_api.g_varchar2) <>
73: nvl(p_rec.tav_information12, hr_api.g_varchar2) or
74: nvl(ota_tav_shd.g_old_rec.tav_information13, hr_api.g_varchar2) <>
67: nvl(p_rec.tav_information9, hr_api.g_varchar2) or
68: nvl(ota_tav_shd.g_old_rec.tav_information10, hr_api.g_varchar2) <>
69: nvl(p_rec.tav_information10, hr_api.g_varchar2) or
70: nvl(ota_tav_shd.g_old_rec.tav_information11, hr_api.g_varchar2) <>
71: nvl(p_rec.tav_information11, hr_api.g_varchar2) or
72: nvl(ota_tav_shd.g_old_rec.tav_information12, hr_api.g_varchar2) <>
73: nvl(p_rec.tav_information12, hr_api.g_varchar2) or
74: nvl(ota_tav_shd.g_old_rec.tav_information13, hr_api.g_varchar2) <>
75: nvl(p_rec.tav_information13, hr_api.g_varchar2) or
68: nvl(ota_tav_shd.g_old_rec.tav_information10, hr_api.g_varchar2) <>
69: nvl(p_rec.tav_information10, hr_api.g_varchar2) or
70: nvl(ota_tav_shd.g_old_rec.tav_information11, hr_api.g_varchar2) <>
71: nvl(p_rec.tav_information11, hr_api.g_varchar2) or
72: nvl(ota_tav_shd.g_old_rec.tav_information12, hr_api.g_varchar2) <>
73: nvl(p_rec.tav_information12, hr_api.g_varchar2) or
74: nvl(ota_tav_shd.g_old_rec.tav_information13, hr_api.g_varchar2) <>
75: nvl(p_rec.tav_information13, hr_api.g_varchar2) or
76: nvl(ota_tav_shd.g_old_rec.tav_information14, hr_api.g_varchar2) <>
69: nvl(p_rec.tav_information10, hr_api.g_varchar2) or
70: nvl(ota_tav_shd.g_old_rec.tav_information11, hr_api.g_varchar2) <>
71: nvl(p_rec.tav_information11, hr_api.g_varchar2) or
72: nvl(ota_tav_shd.g_old_rec.tav_information12, hr_api.g_varchar2) <>
73: nvl(p_rec.tav_information12, hr_api.g_varchar2) or
74: nvl(ota_tav_shd.g_old_rec.tav_information13, hr_api.g_varchar2) <>
75: nvl(p_rec.tav_information13, hr_api.g_varchar2) or
76: nvl(ota_tav_shd.g_old_rec.tav_information14, hr_api.g_varchar2) <>
77: nvl(p_rec.tav_information14, hr_api.g_varchar2) or
70: nvl(ota_tav_shd.g_old_rec.tav_information11, hr_api.g_varchar2) <>
71: nvl(p_rec.tav_information11, hr_api.g_varchar2) or
72: nvl(ota_tav_shd.g_old_rec.tav_information12, hr_api.g_varchar2) <>
73: nvl(p_rec.tav_information12, hr_api.g_varchar2) or
74: nvl(ota_tav_shd.g_old_rec.tav_information13, hr_api.g_varchar2) <>
75: nvl(p_rec.tav_information13, hr_api.g_varchar2) or
76: nvl(ota_tav_shd.g_old_rec.tav_information14, hr_api.g_varchar2) <>
77: nvl(p_rec.tav_information14, hr_api.g_varchar2) or
78: nvl(ota_tav_shd.g_old_rec.tav_information15, hr_api.g_varchar2) <>
71: nvl(p_rec.tav_information11, hr_api.g_varchar2) or
72: nvl(ota_tav_shd.g_old_rec.tav_information12, hr_api.g_varchar2) <>
73: nvl(p_rec.tav_information12, hr_api.g_varchar2) or
74: nvl(ota_tav_shd.g_old_rec.tav_information13, hr_api.g_varchar2) <>
75: nvl(p_rec.tav_information13, hr_api.g_varchar2) or
76: nvl(ota_tav_shd.g_old_rec.tav_information14, hr_api.g_varchar2) <>
77: nvl(p_rec.tav_information14, hr_api.g_varchar2) or
78: nvl(ota_tav_shd.g_old_rec.tav_information15, hr_api.g_varchar2) <>
79: nvl(p_rec.tav_information15, hr_api.g_varchar2) or
72: nvl(ota_tav_shd.g_old_rec.tav_information12, hr_api.g_varchar2) <>
73: nvl(p_rec.tav_information12, hr_api.g_varchar2) or
74: nvl(ota_tav_shd.g_old_rec.tav_information13, hr_api.g_varchar2) <>
75: nvl(p_rec.tav_information13, hr_api.g_varchar2) or
76: nvl(ota_tav_shd.g_old_rec.tav_information14, hr_api.g_varchar2) <>
77: nvl(p_rec.tav_information14, hr_api.g_varchar2) or
78: nvl(ota_tav_shd.g_old_rec.tav_information15, hr_api.g_varchar2) <>
79: nvl(p_rec.tav_information15, hr_api.g_varchar2) or
80: nvl(ota_tav_shd.g_old_rec.tav_information16, hr_api.g_varchar2) <>
73: nvl(p_rec.tav_information12, hr_api.g_varchar2) or
74: nvl(ota_tav_shd.g_old_rec.tav_information13, hr_api.g_varchar2) <>
75: nvl(p_rec.tav_information13, hr_api.g_varchar2) or
76: nvl(ota_tav_shd.g_old_rec.tav_information14, hr_api.g_varchar2) <>
77: nvl(p_rec.tav_information14, hr_api.g_varchar2) or
78: nvl(ota_tav_shd.g_old_rec.tav_information15, hr_api.g_varchar2) <>
79: nvl(p_rec.tav_information15, hr_api.g_varchar2) or
80: nvl(ota_tav_shd.g_old_rec.tav_information16, hr_api.g_varchar2) <>
81: nvl(p_rec.tav_information16, hr_api.g_varchar2) or
74: nvl(ota_tav_shd.g_old_rec.tav_information13, hr_api.g_varchar2) <>
75: nvl(p_rec.tav_information13, hr_api.g_varchar2) or
76: nvl(ota_tav_shd.g_old_rec.tav_information14, hr_api.g_varchar2) <>
77: nvl(p_rec.tav_information14, hr_api.g_varchar2) or
78: nvl(ota_tav_shd.g_old_rec.tav_information15, hr_api.g_varchar2) <>
79: nvl(p_rec.tav_information15, hr_api.g_varchar2) or
80: nvl(ota_tav_shd.g_old_rec.tav_information16, hr_api.g_varchar2) <>
81: nvl(p_rec.tav_information16, hr_api.g_varchar2) or
82: nvl(ota_tav_shd.g_old_rec.tav_information17, hr_api.g_varchar2) <>
75: nvl(p_rec.tav_information13, hr_api.g_varchar2) or
76: nvl(ota_tav_shd.g_old_rec.tav_information14, hr_api.g_varchar2) <>
77: nvl(p_rec.tav_information14, hr_api.g_varchar2) or
78: nvl(ota_tav_shd.g_old_rec.tav_information15, hr_api.g_varchar2) <>
79: nvl(p_rec.tav_information15, hr_api.g_varchar2) or
80: nvl(ota_tav_shd.g_old_rec.tav_information16, hr_api.g_varchar2) <>
81: nvl(p_rec.tav_information16, hr_api.g_varchar2) or
82: nvl(ota_tav_shd.g_old_rec.tav_information17, hr_api.g_varchar2) <>
83: nvl(p_rec.tav_information17, hr_api.g_varchar2) or
76: nvl(ota_tav_shd.g_old_rec.tav_information14, hr_api.g_varchar2) <>
77: nvl(p_rec.tav_information14, hr_api.g_varchar2) or
78: nvl(ota_tav_shd.g_old_rec.tav_information15, hr_api.g_varchar2) <>
79: nvl(p_rec.tav_information15, hr_api.g_varchar2) or
80: nvl(ota_tav_shd.g_old_rec.tav_information16, hr_api.g_varchar2) <>
81: nvl(p_rec.tav_information16, hr_api.g_varchar2) or
82: nvl(ota_tav_shd.g_old_rec.tav_information17, hr_api.g_varchar2) <>
83: nvl(p_rec.tav_information17, hr_api.g_varchar2) or
84: nvl(ota_tav_shd.g_old_rec.tav_information18, hr_api.g_varchar2) <>
77: nvl(p_rec.tav_information14, hr_api.g_varchar2) or
78: nvl(ota_tav_shd.g_old_rec.tav_information15, hr_api.g_varchar2) <>
79: nvl(p_rec.tav_information15, hr_api.g_varchar2) or
80: nvl(ota_tav_shd.g_old_rec.tav_information16, hr_api.g_varchar2) <>
81: nvl(p_rec.tav_information16, hr_api.g_varchar2) or
82: nvl(ota_tav_shd.g_old_rec.tav_information17, hr_api.g_varchar2) <>
83: nvl(p_rec.tav_information17, hr_api.g_varchar2) or
84: nvl(ota_tav_shd.g_old_rec.tav_information18, hr_api.g_varchar2) <>
85: nvl(p_rec.tav_information18, hr_api.g_varchar2) or
78: nvl(ota_tav_shd.g_old_rec.tav_information15, hr_api.g_varchar2) <>
79: nvl(p_rec.tav_information15, hr_api.g_varchar2) or
80: nvl(ota_tav_shd.g_old_rec.tav_information16, hr_api.g_varchar2) <>
81: nvl(p_rec.tav_information16, hr_api.g_varchar2) or
82: nvl(ota_tav_shd.g_old_rec.tav_information17, hr_api.g_varchar2) <>
83: nvl(p_rec.tav_information17, hr_api.g_varchar2) or
84: nvl(ota_tav_shd.g_old_rec.tav_information18, hr_api.g_varchar2) <>
85: nvl(p_rec.tav_information18, hr_api.g_varchar2) or
86: nvl(ota_tav_shd.g_old_rec.tav_information19, hr_api.g_varchar2) <>
79: nvl(p_rec.tav_information15, hr_api.g_varchar2) or
80: nvl(ota_tav_shd.g_old_rec.tav_information16, hr_api.g_varchar2) <>
81: nvl(p_rec.tav_information16, hr_api.g_varchar2) or
82: nvl(ota_tav_shd.g_old_rec.tav_information17, hr_api.g_varchar2) <>
83: nvl(p_rec.tav_information17, hr_api.g_varchar2) or
84: nvl(ota_tav_shd.g_old_rec.tav_information18, hr_api.g_varchar2) <>
85: nvl(p_rec.tav_information18, hr_api.g_varchar2) or
86: nvl(ota_tav_shd.g_old_rec.tav_information19, hr_api.g_varchar2) <>
87: nvl(p_rec.tav_information19, hr_api.g_varchar2) or
80: nvl(ota_tav_shd.g_old_rec.tav_information16, hr_api.g_varchar2) <>
81: nvl(p_rec.tav_information16, hr_api.g_varchar2) or
82: nvl(ota_tav_shd.g_old_rec.tav_information17, hr_api.g_varchar2) <>
83: nvl(p_rec.tav_information17, hr_api.g_varchar2) or
84: nvl(ota_tav_shd.g_old_rec.tav_information18, hr_api.g_varchar2) <>
85: nvl(p_rec.tav_information18, hr_api.g_varchar2) or
86: nvl(ota_tav_shd.g_old_rec.tav_information19, hr_api.g_varchar2) <>
87: nvl(p_rec.tav_information19, hr_api.g_varchar2) or
88: nvl(ota_tav_shd.g_old_rec.tav_information20, hr_api.g_varchar2) <>
81: nvl(p_rec.tav_information16, hr_api.g_varchar2) or
82: nvl(ota_tav_shd.g_old_rec.tav_information17, hr_api.g_varchar2) <>
83: nvl(p_rec.tav_information17, hr_api.g_varchar2) or
84: nvl(ota_tav_shd.g_old_rec.tav_information18, hr_api.g_varchar2) <>
85: nvl(p_rec.tav_information18, hr_api.g_varchar2) or
86: nvl(ota_tav_shd.g_old_rec.tav_information19, hr_api.g_varchar2) <>
87: nvl(p_rec.tav_information19, hr_api.g_varchar2) or
88: nvl(ota_tav_shd.g_old_rec.tav_information20, hr_api.g_varchar2) <>
89: nvl(p_rec.tav_information20, hr_api.g_varchar2) ))
82: nvl(ota_tav_shd.g_old_rec.tav_information17, hr_api.g_varchar2) <>
83: nvl(p_rec.tav_information17, hr_api.g_varchar2) or
84: nvl(ota_tav_shd.g_old_rec.tav_information18, hr_api.g_varchar2) <>
85: nvl(p_rec.tav_information18, hr_api.g_varchar2) or
86: nvl(ota_tav_shd.g_old_rec.tav_information19, hr_api.g_varchar2) <>
87: nvl(p_rec.tav_information19, hr_api.g_varchar2) or
88: nvl(ota_tav_shd.g_old_rec.tav_information20, hr_api.g_varchar2) <>
89: nvl(p_rec.tav_information20, hr_api.g_varchar2) ))
90: or (p_rec.activity_version_id is null) then
83: nvl(p_rec.tav_information17, hr_api.g_varchar2) or
84: nvl(ota_tav_shd.g_old_rec.tav_information18, hr_api.g_varchar2) <>
85: nvl(p_rec.tav_information18, hr_api.g_varchar2) or
86: nvl(ota_tav_shd.g_old_rec.tav_information19, hr_api.g_varchar2) <>
87: nvl(p_rec.tav_information19, hr_api.g_varchar2) or
88: nvl(ota_tav_shd.g_old_rec.tav_information20, hr_api.g_varchar2) <>
89: nvl(p_rec.tav_information20, hr_api.g_varchar2) ))
90: or (p_rec.activity_version_id is null) then
91: --
84: nvl(ota_tav_shd.g_old_rec.tav_information18, hr_api.g_varchar2) <>
85: nvl(p_rec.tav_information18, hr_api.g_varchar2) or
86: nvl(ota_tav_shd.g_old_rec.tav_information19, hr_api.g_varchar2) <>
87: nvl(p_rec.tav_information19, hr_api.g_varchar2) or
88: nvl(ota_tav_shd.g_old_rec.tav_information20, hr_api.g_varchar2) <>
89: nvl(p_rec.tav_information20, hr_api.g_varchar2) ))
90: or (p_rec.activity_version_id is null) then
91: --
92: -- Only execute the validation if absolutely necessary:
85: nvl(p_rec.tav_information18, hr_api.g_varchar2) or
86: nvl(ota_tav_shd.g_old_rec.tav_information19, hr_api.g_varchar2) <>
87: nvl(p_rec.tav_information19, hr_api.g_varchar2) or
88: nvl(ota_tav_shd.g_old_rec.tav_information20, hr_api.g_varchar2) <>
89: nvl(p_rec.tav_information20, hr_api.g_varchar2) ))
90: or (p_rec.activity_version_id is null) then
91: --
92: -- Only execute the validation if absolutely necessary:
93: -- a) During update, the structure column value or any
230: hr_utility.set_location(' Leaving:'||l_proc, 10);
231: --
232: -- check mandatory parameters has been set
233: --
234: hr_api.mandatory_arg_error
235: (p_api_name => l_proc
236: ,p_argument => 'effective_date'
237: ,p_argument_value => p_effective_date);
238:
241: ,p_object_version_number => p_object_version_number);
242:
243:
244: IF ((l_api_updating AND
245: NVL(ota_tav_shd.g_old_rec.competency_update_level,hr_api.g_varchar2) <>
246: NVL(p_competency_update_level, hr_api.g_varchar2))
247: OR NOT l_api_updating AND p_competency_update_level IS NOT NULL) THEN
248:
249: hr_utility.set_location(' Leaving:'||l_proc, 20);
242:
243:
244: IF ((l_api_updating AND
245: NVL(ota_tav_shd.g_old_rec.competency_update_level,hr_api.g_varchar2) <>
246: NVL(p_competency_update_level, hr_api.g_varchar2))
247: OR NOT l_api_updating AND p_competency_update_level IS NOT NULL) THEN
248:
249: hr_utility.set_location(' Leaving:'||l_proc, 20);
250: --
249: hr_utility.set_location(' Leaving:'||l_proc, 20);
250: --
251:
252: IF p_competency_update_level IS NOT NULL THEN
253: IF hr_api.not_exists_in_hr_lookups
254: (p_effective_date => p_effective_date
255: ,p_lookup_type => 'OTA_COMPETENCY_UPDATE_LEVEL'
256: ,p_lookup_code => p_competency_update_level) THEN
257: fnd_message.set_name('OTA','OTA_443411_COMP_UPD_LEV_INVLD');
1431: --
1432: -- Validate Important Attributes
1433: --
1434: if p_rec.business_group_id is not null then
1435: hr_api.validate_bus_grp_id
1436: (p_business_group_id => p_rec.business_group_id
1437: ,p_associated_column1 => ota_tav_shd.g_tab_nam ||
1438: '.BUSINESS_GROUP_ID'
1439: );
1633: --
1634: -- Validate Important Attributes
1635: --
1636: if p_rec.business_group_id is not null then
1637: hr_api.validate_bus_grp_id
1638: (p_business_group_id => p_rec.business_group_id
1639: ,p_associated_column1 => ota_tav_shd.g_tab_nam ||
1640: '.BUSINESS_GROUP_ID'
1641: );
1906: hr_utility.set_location('Entering:'||l_proc, 5);
1907: --
1908: -- Ensure that all the mandatory parameters are not null
1909: --
1910: hr_api.mandatory_arg_error (p_api_name => l_proc,
1911: p_argument => 'activity_version_id',
1912: p_argument_value => p_activity_version_id );
1913: open csr_leg_code;
1914: fetch csr_leg_code into l_legislation_code;