APPS.PSP_ERA_BUS dependencies on HR_API

Line 56: hr_api.mandatory_arg_error

52: hr_utility.set_location('Entering:'|| l_proc, 10);
53: --
54: -- Ensure that all the mandatory parameter are not null
55: --
56: hr_api.mandatory_arg_error
57: (p_api_name => l_proc
58: ,p_argument => 'effort_report_approval_id'
59: ,p_argument_value => p_effort_report_approval_id
60: );

Line 83: hr_api.set_security_group_id

79: close csr_sec_grp;
80: --
81: -- Set the security_group_id in CLIENT_INFO
82: --
83: hr_api.set_security_group_id
84: (p_security_group_id => l_security_group_id
85: );
86: --
87: -- Set the sessions legislation context in HR_SESSION_DATA

Line 89: hr_api.set_legislation_context(l_legislation_code);

85: );
86: --
87: -- Set the sessions legislation context in HR_SESSION_DATA
88: --
89: hr_api.set_legislation_context(l_legislation_code);
90: end if;
91: --
92: hr_utility.set_location(' Leaving:'|| l_proc, 20);
93: --

Line 134: hr_api.mandatory_arg_error

130: hr_utility.set_location('Entering:'|| l_proc, 10);
131: --
132: -- Ensure that all the mandatory parameter are not null
133: --
134: hr_api.mandatory_arg_error
135: (p_api_name => l_proc
136: ,p_argument => 'effort_report_approval_id'
137: ,p_argument_value => p_effort_report_approval_id
138: );

Line 140: if ( nvl(psp_era_bus.g_effort_report_approval_id, hr_api.g_number)

136: ,p_argument => 'effort_report_approval_id'
137: ,p_argument_value => p_effort_report_approval_id
138: );
139: --
140: if ( nvl(psp_era_bus.g_effort_report_approval_id, hr_api.g_number)
141: = p_effort_report_approval_id) then
142: --
143: -- The legislation code has already been found with a previous
144: -- call to this function. Just return the value in the global

Line 216: nvl(psp_era_shd.g_old_rec.pera_information_category, hr_api.g_varchar2) <>

212: begin
213: hr_utility.set_location('Entering:'||l_proc,10);
214: --
215: if ((p_rec.effort_report_approval_id is not null) and (
216: nvl(psp_era_shd.g_old_rec.pera_information_category, hr_api.g_varchar2) <>
217: nvl(p_rec.pera_information_category, hr_api.g_varchar2) or
218: nvl(psp_era_shd.g_old_rec.pera_information1, hr_api.g_varchar2) <>
219: nvl(p_rec.pera_information1, hr_api.g_varchar2) or
220: nvl(psp_era_shd.g_old_rec.pera_information2, hr_api.g_varchar2) <>

Line 217: nvl(p_rec.pera_information_category, hr_api.g_varchar2) or

213: hr_utility.set_location('Entering:'||l_proc,10);
214: --
215: if ((p_rec.effort_report_approval_id is not null) and (
216: nvl(psp_era_shd.g_old_rec.pera_information_category, hr_api.g_varchar2) <>
217: nvl(p_rec.pera_information_category, hr_api.g_varchar2) or
218: nvl(psp_era_shd.g_old_rec.pera_information1, hr_api.g_varchar2) <>
219: nvl(p_rec.pera_information1, hr_api.g_varchar2) or
220: nvl(psp_era_shd.g_old_rec.pera_information2, hr_api.g_varchar2) <>
221: nvl(p_rec.pera_information2, hr_api.g_varchar2) or

Line 218: nvl(psp_era_shd.g_old_rec.pera_information1, hr_api.g_varchar2) <>

214: --
215: if ((p_rec.effort_report_approval_id is not null) and (
216: nvl(psp_era_shd.g_old_rec.pera_information_category, hr_api.g_varchar2) <>
217: nvl(p_rec.pera_information_category, hr_api.g_varchar2) or
218: nvl(psp_era_shd.g_old_rec.pera_information1, hr_api.g_varchar2) <>
219: nvl(p_rec.pera_information1, hr_api.g_varchar2) or
220: nvl(psp_era_shd.g_old_rec.pera_information2, hr_api.g_varchar2) <>
221: nvl(p_rec.pera_information2, hr_api.g_varchar2) or
222: nvl(psp_era_shd.g_old_rec.pera_information3, hr_api.g_varchar2) <>

Line 219: nvl(p_rec.pera_information1, hr_api.g_varchar2) or

215: if ((p_rec.effort_report_approval_id is not null) and (
216: nvl(psp_era_shd.g_old_rec.pera_information_category, hr_api.g_varchar2) <>
217: nvl(p_rec.pera_information_category, hr_api.g_varchar2) or
218: nvl(psp_era_shd.g_old_rec.pera_information1, hr_api.g_varchar2) <>
219: nvl(p_rec.pera_information1, hr_api.g_varchar2) or
220: nvl(psp_era_shd.g_old_rec.pera_information2, hr_api.g_varchar2) <>
221: nvl(p_rec.pera_information2, hr_api.g_varchar2) or
222: nvl(psp_era_shd.g_old_rec.pera_information3, hr_api.g_varchar2) <>
223: nvl(p_rec.pera_information3, hr_api.g_varchar2) or

Line 220: nvl(psp_era_shd.g_old_rec.pera_information2, hr_api.g_varchar2) <>

216: nvl(psp_era_shd.g_old_rec.pera_information_category, hr_api.g_varchar2) <>
217: nvl(p_rec.pera_information_category, hr_api.g_varchar2) or
218: nvl(psp_era_shd.g_old_rec.pera_information1, hr_api.g_varchar2) <>
219: nvl(p_rec.pera_information1, hr_api.g_varchar2) or
220: nvl(psp_era_shd.g_old_rec.pera_information2, hr_api.g_varchar2) <>
221: nvl(p_rec.pera_information2, hr_api.g_varchar2) or
222: nvl(psp_era_shd.g_old_rec.pera_information3, hr_api.g_varchar2) <>
223: nvl(p_rec.pera_information3, hr_api.g_varchar2) or
224: nvl(psp_era_shd.g_old_rec.pera_information4, hr_api.g_varchar2) <>

Line 221: nvl(p_rec.pera_information2, hr_api.g_varchar2) or

217: nvl(p_rec.pera_information_category, hr_api.g_varchar2) or
218: nvl(psp_era_shd.g_old_rec.pera_information1, hr_api.g_varchar2) <>
219: nvl(p_rec.pera_information1, hr_api.g_varchar2) or
220: nvl(psp_era_shd.g_old_rec.pera_information2, hr_api.g_varchar2) <>
221: nvl(p_rec.pera_information2, hr_api.g_varchar2) or
222: nvl(psp_era_shd.g_old_rec.pera_information3, hr_api.g_varchar2) <>
223: nvl(p_rec.pera_information3, hr_api.g_varchar2) or
224: nvl(psp_era_shd.g_old_rec.pera_information4, hr_api.g_varchar2) <>
225: nvl(p_rec.pera_information4, hr_api.g_varchar2) or

Line 222: nvl(psp_era_shd.g_old_rec.pera_information3, hr_api.g_varchar2) <>

218: nvl(psp_era_shd.g_old_rec.pera_information1, hr_api.g_varchar2) <>
219: nvl(p_rec.pera_information1, hr_api.g_varchar2) or
220: nvl(psp_era_shd.g_old_rec.pera_information2, hr_api.g_varchar2) <>
221: nvl(p_rec.pera_information2, hr_api.g_varchar2) or
222: nvl(psp_era_shd.g_old_rec.pera_information3, hr_api.g_varchar2) <>
223: nvl(p_rec.pera_information3, hr_api.g_varchar2) or
224: nvl(psp_era_shd.g_old_rec.pera_information4, hr_api.g_varchar2) <>
225: nvl(p_rec.pera_information4, hr_api.g_varchar2) or
226: nvl(psp_era_shd.g_old_rec.pera_information5, hr_api.g_varchar2) <>

Line 223: nvl(p_rec.pera_information3, hr_api.g_varchar2) or

219: nvl(p_rec.pera_information1, hr_api.g_varchar2) or
220: nvl(psp_era_shd.g_old_rec.pera_information2, hr_api.g_varchar2) <>
221: nvl(p_rec.pera_information2, hr_api.g_varchar2) or
222: nvl(psp_era_shd.g_old_rec.pera_information3, hr_api.g_varchar2) <>
223: nvl(p_rec.pera_information3, hr_api.g_varchar2) or
224: nvl(psp_era_shd.g_old_rec.pera_information4, hr_api.g_varchar2) <>
225: nvl(p_rec.pera_information4, hr_api.g_varchar2) or
226: nvl(psp_era_shd.g_old_rec.pera_information5, hr_api.g_varchar2) <>
227: nvl(p_rec.pera_information5, hr_api.g_varchar2) or

Line 224: nvl(psp_era_shd.g_old_rec.pera_information4, hr_api.g_varchar2) <>

220: nvl(psp_era_shd.g_old_rec.pera_information2, hr_api.g_varchar2) <>
221: nvl(p_rec.pera_information2, hr_api.g_varchar2) or
222: nvl(psp_era_shd.g_old_rec.pera_information3, hr_api.g_varchar2) <>
223: nvl(p_rec.pera_information3, hr_api.g_varchar2) or
224: nvl(psp_era_shd.g_old_rec.pera_information4, hr_api.g_varchar2) <>
225: nvl(p_rec.pera_information4, hr_api.g_varchar2) or
226: nvl(psp_era_shd.g_old_rec.pera_information5, hr_api.g_varchar2) <>
227: nvl(p_rec.pera_information5, hr_api.g_varchar2) or
228: nvl(psp_era_shd.g_old_rec.pera_information6, hr_api.g_varchar2) <>

Line 225: nvl(p_rec.pera_information4, hr_api.g_varchar2) or

221: nvl(p_rec.pera_information2, hr_api.g_varchar2) or
222: nvl(psp_era_shd.g_old_rec.pera_information3, hr_api.g_varchar2) <>
223: nvl(p_rec.pera_information3, hr_api.g_varchar2) or
224: nvl(psp_era_shd.g_old_rec.pera_information4, hr_api.g_varchar2) <>
225: nvl(p_rec.pera_information4, hr_api.g_varchar2) or
226: nvl(psp_era_shd.g_old_rec.pera_information5, hr_api.g_varchar2) <>
227: nvl(p_rec.pera_information5, hr_api.g_varchar2) or
228: nvl(psp_era_shd.g_old_rec.pera_information6, hr_api.g_varchar2) <>
229: nvl(p_rec.pera_information6, hr_api.g_varchar2) or

Line 226: nvl(psp_era_shd.g_old_rec.pera_information5, hr_api.g_varchar2) <>

222: nvl(psp_era_shd.g_old_rec.pera_information3, hr_api.g_varchar2) <>
223: nvl(p_rec.pera_information3, hr_api.g_varchar2) or
224: nvl(psp_era_shd.g_old_rec.pera_information4, hr_api.g_varchar2) <>
225: nvl(p_rec.pera_information4, hr_api.g_varchar2) or
226: nvl(psp_era_shd.g_old_rec.pera_information5, hr_api.g_varchar2) <>
227: nvl(p_rec.pera_information5, hr_api.g_varchar2) or
228: nvl(psp_era_shd.g_old_rec.pera_information6, hr_api.g_varchar2) <>
229: nvl(p_rec.pera_information6, hr_api.g_varchar2) or
230: nvl(psp_era_shd.g_old_rec.pera_information7, hr_api.g_varchar2) <>

Line 227: nvl(p_rec.pera_information5, hr_api.g_varchar2) or

223: nvl(p_rec.pera_information3, hr_api.g_varchar2) or
224: nvl(psp_era_shd.g_old_rec.pera_information4, hr_api.g_varchar2) <>
225: nvl(p_rec.pera_information4, hr_api.g_varchar2) or
226: nvl(psp_era_shd.g_old_rec.pera_information5, hr_api.g_varchar2) <>
227: nvl(p_rec.pera_information5, hr_api.g_varchar2) or
228: nvl(psp_era_shd.g_old_rec.pera_information6, hr_api.g_varchar2) <>
229: nvl(p_rec.pera_information6, hr_api.g_varchar2) or
230: nvl(psp_era_shd.g_old_rec.pera_information7, hr_api.g_varchar2) <>
231: nvl(p_rec.pera_information7, hr_api.g_varchar2) or

Line 228: nvl(psp_era_shd.g_old_rec.pera_information6, hr_api.g_varchar2) <>

224: nvl(psp_era_shd.g_old_rec.pera_information4, hr_api.g_varchar2) <>
225: nvl(p_rec.pera_information4, hr_api.g_varchar2) or
226: nvl(psp_era_shd.g_old_rec.pera_information5, hr_api.g_varchar2) <>
227: nvl(p_rec.pera_information5, hr_api.g_varchar2) or
228: nvl(psp_era_shd.g_old_rec.pera_information6, hr_api.g_varchar2) <>
229: nvl(p_rec.pera_information6, hr_api.g_varchar2) or
230: nvl(psp_era_shd.g_old_rec.pera_information7, hr_api.g_varchar2) <>
231: nvl(p_rec.pera_information7, hr_api.g_varchar2) or
232: nvl(psp_era_shd.g_old_rec.pera_information8, hr_api.g_varchar2) <>

Line 229: nvl(p_rec.pera_information6, hr_api.g_varchar2) or

225: nvl(p_rec.pera_information4, hr_api.g_varchar2) or
226: nvl(psp_era_shd.g_old_rec.pera_information5, hr_api.g_varchar2) <>
227: nvl(p_rec.pera_information5, hr_api.g_varchar2) or
228: nvl(psp_era_shd.g_old_rec.pera_information6, hr_api.g_varchar2) <>
229: nvl(p_rec.pera_information6, hr_api.g_varchar2) or
230: nvl(psp_era_shd.g_old_rec.pera_information7, hr_api.g_varchar2) <>
231: nvl(p_rec.pera_information7, hr_api.g_varchar2) or
232: nvl(psp_era_shd.g_old_rec.pera_information8, hr_api.g_varchar2) <>
233: nvl(p_rec.pera_information8, hr_api.g_varchar2) or

Line 230: nvl(psp_era_shd.g_old_rec.pera_information7, hr_api.g_varchar2) <>

226: nvl(psp_era_shd.g_old_rec.pera_information5, hr_api.g_varchar2) <>
227: nvl(p_rec.pera_information5, hr_api.g_varchar2) or
228: nvl(psp_era_shd.g_old_rec.pera_information6, hr_api.g_varchar2) <>
229: nvl(p_rec.pera_information6, hr_api.g_varchar2) or
230: nvl(psp_era_shd.g_old_rec.pera_information7, hr_api.g_varchar2) <>
231: nvl(p_rec.pera_information7, hr_api.g_varchar2) or
232: nvl(psp_era_shd.g_old_rec.pera_information8, hr_api.g_varchar2) <>
233: nvl(p_rec.pera_information8, hr_api.g_varchar2) or
234: nvl(psp_era_shd.g_old_rec.pera_information9, hr_api.g_varchar2) <>

Line 231: nvl(p_rec.pera_information7, hr_api.g_varchar2) or

227: nvl(p_rec.pera_information5, hr_api.g_varchar2) or
228: nvl(psp_era_shd.g_old_rec.pera_information6, hr_api.g_varchar2) <>
229: nvl(p_rec.pera_information6, hr_api.g_varchar2) or
230: nvl(psp_era_shd.g_old_rec.pera_information7, hr_api.g_varchar2) <>
231: nvl(p_rec.pera_information7, hr_api.g_varchar2) or
232: nvl(psp_era_shd.g_old_rec.pera_information8, hr_api.g_varchar2) <>
233: nvl(p_rec.pera_information8, hr_api.g_varchar2) or
234: nvl(psp_era_shd.g_old_rec.pera_information9, hr_api.g_varchar2) <>
235: nvl(p_rec.pera_information9, hr_api.g_varchar2) or

Line 232: nvl(psp_era_shd.g_old_rec.pera_information8, hr_api.g_varchar2) <>

228: nvl(psp_era_shd.g_old_rec.pera_information6, hr_api.g_varchar2) <>
229: nvl(p_rec.pera_information6, hr_api.g_varchar2) or
230: nvl(psp_era_shd.g_old_rec.pera_information7, hr_api.g_varchar2) <>
231: nvl(p_rec.pera_information7, hr_api.g_varchar2) or
232: nvl(psp_era_shd.g_old_rec.pera_information8, hr_api.g_varchar2) <>
233: nvl(p_rec.pera_information8, hr_api.g_varchar2) or
234: nvl(psp_era_shd.g_old_rec.pera_information9, hr_api.g_varchar2) <>
235: nvl(p_rec.pera_information9, hr_api.g_varchar2) or
236: nvl(psp_era_shd.g_old_rec.pera_information10, hr_api.g_varchar2) <>

Line 233: nvl(p_rec.pera_information8, hr_api.g_varchar2) or

229: nvl(p_rec.pera_information6, hr_api.g_varchar2) or
230: nvl(psp_era_shd.g_old_rec.pera_information7, hr_api.g_varchar2) <>
231: nvl(p_rec.pera_information7, hr_api.g_varchar2) or
232: nvl(psp_era_shd.g_old_rec.pera_information8, hr_api.g_varchar2) <>
233: nvl(p_rec.pera_information8, hr_api.g_varchar2) or
234: nvl(psp_era_shd.g_old_rec.pera_information9, hr_api.g_varchar2) <>
235: nvl(p_rec.pera_information9, hr_api.g_varchar2) or
236: nvl(psp_era_shd.g_old_rec.pera_information10, hr_api.g_varchar2) <>
237: nvl(p_rec.pera_information10, hr_api.g_varchar2) or

Line 234: nvl(psp_era_shd.g_old_rec.pera_information9, hr_api.g_varchar2) <>

230: nvl(psp_era_shd.g_old_rec.pera_information7, hr_api.g_varchar2) <>
231: nvl(p_rec.pera_information7, hr_api.g_varchar2) or
232: nvl(psp_era_shd.g_old_rec.pera_information8, hr_api.g_varchar2) <>
233: nvl(p_rec.pera_information8, hr_api.g_varchar2) or
234: nvl(psp_era_shd.g_old_rec.pera_information9, hr_api.g_varchar2) <>
235: nvl(p_rec.pera_information9, hr_api.g_varchar2) or
236: nvl(psp_era_shd.g_old_rec.pera_information10, hr_api.g_varchar2) <>
237: nvl(p_rec.pera_information10, hr_api.g_varchar2) or
238: nvl(psp_era_shd.g_old_rec.pera_information11, hr_api.g_varchar2) <>

Line 235: nvl(p_rec.pera_information9, hr_api.g_varchar2) or

231: nvl(p_rec.pera_information7, hr_api.g_varchar2) or
232: nvl(psp_era_shd.g_old_rec.pera_information8, hr_api.g_varchar2) <>
233: nvl(p_rec.pera_information8, hr_api.g_varchar2) or
234: nvl(psp_era_shd.g_old_rec.pera_information9, hr_api.g_varchar2) <>
235: nvl(p_rec.pera_information9, hr_api.g_varchar2) or
236: nvl(psp_era_shd.g_old_rec.pera_information10, hr_api.g_varchar2) <>
237: nvl(p_rec.pera_information10, hr_api.g_varchar2) or
238: nvl(psp_era_shd.g_old_rec.pera_information11, hr_api.g_varchar2) <>
239: nvl(p_rec.pera_information11, hr_api.g_varchar2) or

Line 236: nvl(psp_era_shd.g_old_rec.pera_information10, hr_api.g_varchar2) <>

232: nvl(psp_era_shd.g_old_rec.pera_information8, hr_api.g_varchar2) <>
233: nvl(p_rec.pera_information8, hr_api.g_varchar2) or
234: nvl(psp_era_shd.g_old_rec.pera_information9, hr_api.g_varchar2) <>
235: nvl(p_rec.pera_information9, hr_api.g_varchar2) or
236: nvl(psp_era_shd.g_old_rec.pera_information10, hr_api.g_varchar2) <>
237: nvl(p_rec.pera_information10, hr_api.g_varchar2) or
238: nvl(psp_era_shd.g_old_rec.pera_information11, hr_api.g_varchar2) <>
239: nvl(p_rec.pera_information11, hr_api.g_varchar2) or
240: nvl(psp_era_shd.g_old_rec.pera_information12, hr_api.g_varchar2) <>

Line 237: nvl(p_rec.pera_information10, hr_api.g_varchar2) or

233: nvl(p_rec.pera_information8, hr_api.g_varchar2) or
234: nvl(psp_era_shd.g_old_rec.pera_information9, hr_api.g_varchar2) <>
235: nvl(p_rec.pera_information9, hr_api.g_varchar2) or
236: nvl(psp_era_shd.g_old_rec.pera_information10, hr_api.g_varchar2) <>
237: nvl(p_rec.pera_information10, hr_api.g_varchar2) or
238: nvl(psp_era_shd.g_old_rec.pera_information11, hr_api.g_varchar2) <>
239: nvl(p_rec.pera_information11, hr_api.g_varchar2) or
240: nvl(psp_era_shd.g_old_rec.pera_information12, hr_api.g_varchar2) <>
241: nvl(p_rec.pera_information12, hr_api.g_varchar2) or

Line 238: nvl(psp_era_shd.g_old_rec.pera_information11, hr_api.g_varchar2) <>

234: nvl(psp_era_shd.g_old_rec.pera_information9, hr_api.g_varchar2) <>
235: nvl(p_rec.pera_information9, hr_api.g_varchar2) or
236: nvl(psp_era_shd.g_old_rec.pera_information10, hr_api.g_varchar2) <>
237: nvl(p_rec.pera_information10, hr_api.g_varchar2) or
238: nvl(psp_era_shd.g_old_rec.pera_information11, hr_api.g_varchar2) <>
239: nvl(p_rec.pera_information11, hr_api.g_varchar2) or
240: nvl(psp_era_shd.g_old_rec.pera_information12, hr_api.g_varchar2) <>
241: nvl(p_rec.pera_information12, hr_api.g_varchar2) or
242: nvl(psp_era_shd.g_old_rec.pera_information13, hr_api.g_varchar2) <>

Line 239: nvl(p_rec.pera_information11, hr_api.g_varchar2) or

235: nvl(p_rec.pera_information9, hr_api.g_varchar2) or
236: nvl(psp_era_shd.g_old_rec.pera_information10, hr_api.g_varchar2) <>
237: nvl(p_rec.pera_information10, hr_api.g_varchar2) or
238: nvl(psp_era_shd.g_old_rec.pera_information11, hr_api.g_varchar2) <>
239: nvl(p_rec.pera_information11, hr_api.g_varchar2) or
240: nvl(psp_era_shd.g_old_rec.pera_information12, hr_api.g_varchar2) <>
241: nvl(p_rec.pera_information12, hr_api.g_varchar2) or
242: nvl(psp_era_shd.g_old_rec.pera_information13, hr_api.g_varchar2) <>
243: nvl(p_rec.pera_information13, hr_api.g_varchar2) or

Line 240: nvl(psp_era_shd.g_old_rec.pera_information12, hr_api.g_varchar2) <>

236: nvl(psp_era_shd.g_old_rec.pera_information10, hr_api.g_varchar2) <>
237: nvl(p_rec.pera_information10, hr_api.g_varchar2) or
238: nvl(psp_era_shd.g_old_rec.pera_information11, hr_api.g_varchar2) <>
239: nvl(p_rec.pera_information11, hr_api.g_varchar2) or
240: nvl(psp_era_shd.g_old_rec.pera_information12, hr_api.g_varchar2) <>
241: nvl(p_rec.pera_information12, hr_api.g_varchar2) or
242: nvl(psp_era_shd.g_old_rec.pera_information13, hr_api.g_varchar2) <>
243: nvl(p_rec.pera_information13, hr_api.g_varchar2) or
244: nvl(psp_era_shd.g_old_rec.pera_information14, hr_api.g_varchar2) <>

Line 241: nvl(p_rec.pera_information12, hr_api.g_varchar2) or

237: nvl(p_rec.pera_information10, hr_api.g_varchar2) or
238: nvl(psp_era_shd.g_old_rec.pera_information11, hr_api.g_varchar2) <>
239: nvl(p_rec.pera_information11, hr_api.g_varchar2) or
240: nvl(psp_era_shd.g_old_rec.pera_information12, hr_api.g_varchar2) <>
241: nvl(p_rec.pera_information12, hr_api.g_varchar2) or
242: nvl(psp_era_shd.g_old_rec.pera_information13, hr_api.g_varchar2) <>
243: nvl(p_rec.pera_information13, hr_api.g_varchar2) or
244: nvl(psp_era_shd.g_old_rec.pera_information14, hr_api.g_varchar2) <>
245: nvl(p_rec.pera_information14, hr_api.g_varchar2) or

Line 242: nvl(psp_era_shd.g_old_rec.pera_information13, hr_api.g_varchar2) <>

238: nvl(psp_era_shd.g_old_rec.pera_information11, hr_api.g_varchar2) <>
239: nvl(p_rec.pera_information11, hr_api.g_varchar2) or
240: nvl(psp_era_shd.g_old_rec.pera_information12, hr_api.g_varchar2) <>
241: nvl(p_rec.pera_information12, hr_api.g_varchar2) or
242: nvl(psp_era_shd.g_old_rec.pera_information13, hr_api.g_varchar2) <>
243: nvl(p_rec.pera_information13, hr_api.g_varchar2) or
244: nvl(psp_era_shd.g_old_rec.pera_information14, hr_api.g_varchar2) <>
245: nvl(p_rec.pera_information14, hr_api.g_varchar2) or
246: nvl(psp_era_shd.g_old_rec.pera_information15, hr_api.g_varchar2) <>

Line 243: nvl(p_rec.pera_information13, hr_api.g_varchar2) or

239: nvl(p_rec.pera_information11, hr_api.g_varchar2) or
240: nvl(psp_era_shd.g_old_rec.pera_information12, hr_api.g_varchar2) <>
241: nvl(p_rec.pera_information12, hr_api.g_varchar2) or
242: nvl(psp_era_shd.g_old_rec.pera_information13, hr_api.g_varchar2) <>
243: nvl(p_rec.pera_information13, hr_api.g_varchar2) or
244: nvl(psp_era_shd.g_old_rec.pera_information14, hr_api.g_varchar2) <>
245: nvl(p_rec.pera_information14, hr_api.g_varchar2) or
246: nvl(psp_era_shd.g_old_rec.pera_information15, hr_api.g_varchar2) <>
247: nvl(p_rec.pera_information15, hr_api.g_varchar2) or

Line 244: nvl(psp_era_shd.g_old_rec.pera_information14, hr_api.g_varchar2) <>

240: nvl(psp_era_shd.g_old_rec.pera_information12, hr_api.g_varchar2) <>
241: nvl(p_rec.pera_information12, hr_api.g_varchar2) or
242: nvl(psp_era_shd.g_old_rec.pera_information13, hr_api.g_varchar2) <>
243: nvl(p_rec.pera_information13, hr_api.g_varchar2) or
244: nvl(psp_era_shd.g_old_rec.pera_information14, hr_api.g_varchar2) <>
245: nvl(p_rec.pera_information14, hr_api.g_varchar2) or
246: nvl(psp_era_shd.g_old_rec.pera_information15, hr_api.g_varchar2) <>
247: nvl(p_rec.pera_information15, hr_api.g_varchar2) or
248: nvl(psp_era_shd.g_old_rec.pera_information16, hr_api.g_varchar2) <>

Line 245: nvl(p_rec.pera_information14, hr_api.g_varchar2) or

241: nvl(p_rec.pera_information12, hr_api.g_varchar2) or
242: nvl(psp_era_shd.g_old_rec.pera_information13, hr_api.g_varchar2) <>
243: nvl(p_rec.pera_information13, hr_api.g_varchar2) or
244: nvl(psp_era_shd.g_old_rec.pera_information14, hr_api.g_varchar2) <>
245: nvl(p_rec.pera_information14, hr_api.g_varchar2) or
246: nvl(psp_era_shd.g_old_rec.pera_information15, hr_api.g_varchar2) <>
247: nvl(p_rec.pera_information15, hr_api.g_varchar2) or
248: nvl(psp_era_shd.g_old_rec.pera_information16, hr_api.g_varchar2) <>
249: nvl(p_rec.pera_information16, hr_api.g_varchar2) or

Line 246: nvl(psp_era_shd.g_old_rec.pera_information15, hr_api.g_varchar2) <>

242: nvl(psp_era_shd.g_old_rec.pera_information13, hr_api.g_varchar2) <>
243: nvl(p_rec.pera_information13, hr_api.g_varchar2) or
244: nvl(psp_era_shd.g_old_rec.pera_information14, hr_api.g_varchar2) <>
245: nvl(p_rec.pera_information14, hr_api.g_varchar2) or
246: nvl(psp_era_shd.g_old_rec.pera_information15, hr_api.g_varchar2) <>
247: nvl(p_rec.pera_information15, hr_api.g_varchar2) or
248: nvl(psp_era_shd.g_old_rec.pera_information16, hr_api.g_varchar2) <>
249: nvl(p_rec.pera_information16, hr_api.g_varchar2) or
250: nvl(psp_era_shd.g_old_rec.pera_information17, hr_api.g_varchar2) <>

Line 247: nvl(p_rec.pera_information15, hr_api.g_varchar2) or

243: nvl(p_rec.pera_information13, hr_api.g_varchar2) or
244: nvl(psp_era_shd.g_old_rec.pera_information14, hr_api.g_varchar2) <>
245: nvl(p_rec.pera_information14, hr_api.g_varchar2) or
246: nvl(psp_era_shd.g_old_rec.pera_information15, hr_api.g_varchar2) <>
247: nvl(p_rec.pera_information15, hr_api.g_varchar2) or
248: nvl(psp_era_shd.g_old_rec.pera_information16, hr_api.g_varchar2) <>
249: nvl(p_rec.pera_information16, hr_api.g_varchar2) or
250: nvl(psp_era_shd.g_old_rec.pera_information17, hr_api.g_varchar2) <>
251: nvl(p_rec.pera_information17, hr_api.g_varchar2) or

Line 248: nvl(psp_era_shd.g_old_rec.pera_information16, hr_api.g_varchar2) <>

244: nvl(psp_era_shd.g_old_rec.pera_information14, hr_api.g_varchar2) <>
245: nvl(p_rec.pera_information14, hr_api.g_varchar2) or
246: nvl(psp_era_shd.g_old_rec.pera_information15, hr_api.g_varchar2) <>
247: nvl(p_rec.pera_information15, hr_api.g_varchar2) or
248: nvl(psp_era_shd.g_old_rec.pera_information16, hr_api.g_varchar2) <>
249: nvl(p_rec.pera_information16, hr_api.g_varchar2) or
250: nvl(psp_era_shd.g_old_rec.pera_information17, hr_api.g_varchar2) <>
251: nvl(p_rec.pera_information17, hr_api.g_varchar2) or
252: nvl(psp_era_shd.g_old_rec.pera_information18, hr_api.g_varchar2) <>

Line 249: nvl(p_rec.pera_information16, hr_api.g_varchar2) or

245: nvl(p_rec.pera_information14, hr_api.g_varchar2) or
246: nvl(psp_era_shd.g_old_rec.pera_information15, hr_api.g_varchar2) <>
247: nvl(p_rec.pera_information15, hr_api.g_varchar2) or
248: nvl(psp_era_shd.g_old_rec.pera_information16, hr_api.g_varchar2) <>
249: nvl(p_rec.pera_information16, hr_api.g_varchar2) or
250: nvl(psp_era_shd.g_old_rec.pera_information17, hr_api.g_varchar2) <>
251: nvl(p_rec.pera_information17, hr_api.g_varchar2) or
252: nvl(psp_era_shd.g_old_rec.pera_information18, hr_api.g_varchar2) <>
253: nvl(p_rec.pera_information18, hr_api.g_varchar2) or

Line 250: nvl(psp_era_shd.g_old_rec.pera_information17, hr_api.g_varchar2) <>

246: nvl(psp_era_shd.g_old_rec.pera_information15, hr_api.g_varchar2) <>
247: nvl(p_rec.pera_information15, hr_api.g_varchar2) or
248: nvl(psp_era_shd.g_old_rec.pera_information16, hr_api.g_varchar2) <>
249: nvl(p_rec.pera_information16, hr_api.g_varchar2) or
250: nvl(psp_era_shd.g_old_rec.pera_information17, hr_api.g_varchar2) <>
251: nvl(p_rec.pera_information17, hr_api.g_varchar2) or
252: nvl(psp_era_shd.g_old_rec.pera_information18, hr_api.g_varchar2) <>
253: nvl(p_rec.pera_information18, hr_api.g_varchar2) or
254: nvl(psp_era_shd.g_old_rec.pera_information19, hr_api.g_varchar2) <>

Line 251: nvl(p_rec.pera_information17, hr_api.g_varchar2) or

247: nvl(p_rec.pera_information15, hr_api.g_varchar2) or
248: nvl(psp_era_shd.g_old_rec.pera_information16, hr_api.g_varchar2) <>
249: nvl(p_rec.pera_information16, hr_api.g_varchar2) or
250: nvl(psp_era_shd.g_old_rec.pera_information17, hr_api.g_varchar2) <>
251: nvl(p_rec.pera_information17, hr_api.g_varchar2) or
252: nvl(psp_era_shd.g_old_rec.pera_information18, hr_api.g_varchar2) <>
253: nvl(p_rec.pera_information18, hr_api.g_varchar2) or
254: nvl(psp_era_shd.g_old_rec.pera_information19, hr_api.g_varchar2) <>
255: nvl(p_rec.pera_information19, hr_api.g_varchar2) or

Line 252: nvl(psp_era_shd.g_old_rec.pera_information18, hr_api.g_varchar2) <>

248: nvl(psp_era_shd.g_old_rec.pera_information16, hr_api.g_varchar2) <>
249: nvl(p_rec.pera_information16, hr_api.g_varchar2) or
250: nvl(psp_era_shd.g_old_rec.pera_information17, hr_api.g_varchar2) <>
251: nvl(p_rec.pera_information17, hr_api.g_varchar2) or
252: nvl(psp_era_shd.g_old_rec.pera_information18, hr_api.g_varchar2) <>
253: nvl(p_rec.pera_information18, hr_api.g_varchar2) or
254: nvl(psp_era_shd.g_old_rec.pera_information19, hr_api.g_varchar2) <>
255: nvl(p_rec.pera_information19, hr_api.g_varchar2) or
256: nvl(psp_era_shd.g_old_rec.pera_information20, hr_api.g_varchar2) <>

Line 253: nvl(p_rec.pera_information18, hr_api.g_varchar2) or

249: nvl(p_rec.pera_information16, hr_api.g_varchar2) or
250: nvl(psp_era_shd.g_old_rec.pera_information17, hr_api.g_varchar2) <>
251: nvl(p_rec.pera_information17, hr_api.g_varchar2) or
252: nvl(psp_era_shd.g_old_rec.pera_information18, hr_api.g_varchar2) <>
253: nvl(p_rec.pera_information18, hr_api.g_varchar2) or
254: nvl(psp_era_shd.g_old_rec.pera_information19, hr_api.g_varchar2) <>
255: nvl(p_rec.pera_information19, hr_api.g_varchar2) or
256: nvl(psp_era_shd.g_old_rec.pera_information20, hr_api.g_varchar2) <>
257: nvl(p_rec.pera_information20, hr_api.g_varchar2)))

Line 254: nvl(psp_era_shd.g_old_rec.pera_information19, hr_api.g_varchar2) <>

250: nvl(psp_era_shd.g_old_rec.pera_information17, hr_api.g_varchar2) <>
251: nvl(p_rec.pera_information17, hr_api.g_varchar2) or
252: nvl(psp_era_shd.g_old_rec.pera_information18, hr_api.g_varchar2) <>
253: nvl(p_rec.pera_information18, hr_api.g_varchar2) or
254: nvl(psp_era_shd.g_old_rec.pera_information19, hr_api.g_varchar2) <>
255: nvl(p_rec.pera_information19, hr_api.g_varchar2) or
256: nvl(psp_era_shd.g_old_rec.pera_information20, hr_api.g_varchar2) <>
257: nvl(p_rec.pera_information20, hr_api.g_varchar2)))
258: or (p_rec.effort_report_approval_id is null) then

Line 255: nvl(p_rec.pera_information19, hr_api.g_varchar2) or

251: nvl(p_rec.pera_information17, hr_api.g_varchar2) or
252: nvl(psp_era_shd.g_old_rec.pera_information18, hr_api.g_varchar2) <>
253: nvl(p_rec.pera_information18, hr_api.g_varchar2) or
254: nvl(psp_era_shd.g_old_rec.pera_information19, hr_api.g_varchar2) <>
255: nvl(p_rec.pera_information19, hr_api.g_varchar2) or
256: nvl(psp_era_shd.g_old_rec.pera_information20, hr_api.g_varchar2) <>
257: nvl(p_rec.pera_information20, hr_api.g_varchar2)))
258: or (p_rec.effort_report_approval_id is null) then
259: --

Line 256: nvl(psp_era_shd.g_old_rec.pera_information20, hr_api.g_varchar2) <>

252: nvl(psp_era_shd.g_old_rec.pera_information18, hr_api.g_varchar2) <>
253: nvl(p_rec.pera_information18, hr_api.g_varchar2) or
254: nvl(psp_era_shd.g_old_rec.pera_information19, hr_api.g_varchar2) <>
255: nvl(p_rec.pera_information19, hr_api.g_varchar2) or
256: nvl(psp_era_shd.g_old_rec.pera_information20, hr_api.g_varchar2) <>
257: nvl(p_rec.pera_information20, hr_api.g_varchar2)))
258: or (p_rec.effort_report_approval_id is null) then
259: --
260: -- Only execute the validation if absolutely necessary:

Line 257: nvl(p_rec.pera_information20, hr_api.g_varchar2)))

253: nvl(p_rec.pera_information18, hr_api.g_varchar2) or
254: nvl(psp_era_shd.g_old_rec.pera_information19, hr_api.g_varchar2) <>
255: nvl(p_rec.pera_information19, hr_api.g_varchar2) or
256: nvl(psp_era_shd.g_old_rec.pera_information20, hr_api.g_varchar2) <>
257: nvl(p_rec.pera_information20, hr_api.g_varchar2)))
258: or (p_rec.effort_report_approval_id is null) then
259: --
260: -- Only execute the validation if absolutely necessary:
261: -- a) During update, the structure column value or any

Line 313: nvl(psp_era_shd.g_old_rec.eff_information_category, hr_api.g_varchar2) <>

309: );
310: end if;
311:
312: if ((p_rec.effort_report_approval_id is not null) and (
313: nvl(psp_era_shd.g_old_rec.eff_information_category, hr_api.g_varchar2) <>
314: nvl(p_rec.eff_information_category, hr_api.g_varchar2) or
315: nvl(psp_era_shd.g_old_rec.eff_information1, hr_api.g_varchar2) <>
316: nvl(p_rec.eff_information1, hr_api.g_varchar2) or
317: nvl(psp_era_shd.g_old_rec.eff_information2, hr_api.g_varchar2) <>

Line 314: nvl(p_rec.eff_information_category, hr_api.g_varchar2) or

310: end if;
311:
312: if ((p_rec.effort_report_approval_id is not null) and (
313: nvl(psp_era_shd.g_old_rec.eff_information_category, hr_api.g_varchar2) <>
314: nvl(p_rec.eff_information_category, hr_api.g_varchar2) or
315: nvl(psp_era_shd.g_old_rec.eff_information1, hr_api.g_varchar2) <>
316: nvl(p_rec.eff_information1, hr_api.g_varchar2) or
317: nvl(psp_era_shd.g_old_rec.eff_information2, hr_api.g_varchar2) <>
318: nvl(p_rec.eff_information2, hr_api.g_varchar2) or

Line 315: nvl(psp_era_shd.g_old_rec.eff_information1, hr_api.g_varchar2) <>

311:
312: if ((p_rec.effort_report_approval_id is not null) and (
313: nvl(psp_era_shd.g_old_rec.eff_information_category, hr_api.g_varchar2) <>
314: nvl(p_rec.eff_information_category, hr_api.g_varchar2) or
315: nvl(psp_era_shd.g_old_rec.eff_information1, hr_api.g_varchar2) <>
316: nvl(p_rec.eff_information1, hr_api.g_varchar2) or
317: nvl(psp_era_shd.g_old_rec.eff_information2, hr_api.g_varchar2) <>
318: nvl(p_rec.eff_information2, hr_api.g_varchar2) or
319: nvl(psp_era_shd.g_old_rec.eff_information3, hr_api.g_varchar2) <>

Line 316: nvl(p_rec.eff_information1, hr_api.g_varchar2) or

312: if ((p_rec.effort_report_approval_id is not null) and (
313: nvl(psp_era_shd.g_old_rec.eff_information_category, hr_api.g_varchar2) <>
314: nvl(p_rec.eff_information_category, hr_api.g_varchar2) or
315: nvl(psp_era_shd.g_old_rec.eff_information1, hr_api.g_varchar2) <>
316: nvl(p_rec.eff_information1, hr_api.g_varchar2) or
317: nvl(psp_era_shd.g_old_rec.eff_information2, hr_api.g_varchar2) <>
318: nvl(p_rec.eff_information2, hr_api.g_varchar2) or
319: nvl(psp_era_shd.g_old_rec.eff_information3, hr_api.g_varchar2) <>
320: nvl(p_rec.eff_information3, hr_api.g_varchar2) or

Line 317: nvl(psp_era_shd.g_old_rec.eff_information2, hr_api.g_varchar2) <>

313: nvl(psp_era_shd.g_old_rec.eff_information_category, hr_api.g_varchar2) <>
314: nvl(p_rec.eff_information_category, hr_api.g_varchar2) or
315: nvl(psp_era_shd.g_old_rec.eff_information1, hr_api.g_varchar2) <>
316: nvl(p_rec.eff_information1, hr_api.g_varchar2) or
317: nvl(psp_era_shd.g_old_rec.eff_information2, hr_api.g_varchar2) <>
318: nvl(p_rec.eff_information2, hr_api.g_varchar2) or
319: nvl(psp_era_shd.g_old_rec.eff_information3, hr_api.g_varchar2) <>
320: nvl(p_rec.eff_information3, hr_api.g_varchar2) or
321: nvl(psp_era_shd.g_old_rec.eff_information4, hr_api.g_varchar2) <>

Line 318: nvl(p_rec.eff_information2, hr_api.g_varchar2) or

314: nvl(p_rec.eff_information_category, hr_api.g_varchar2) or
315: nvl(psp_era_shd.g_old_rec.eff_information1, hr_api.g_varchar2) <>
316: nvl(p_rec.eff_information1, hr_api.g_varchar2) or
317: nvl(psp_era_shd.g_old_rec.eff_information2, hr_api.g_varchar2) <>
318: nvl(p_rec.eff_information2, hr_api.g_varchar2) or
319: nvl(psp_era_shd.g_old_rec.eff_information3, hr_api.g_varchar2) <>
320: nvl(p_rec.eff_information3, hr_api.g_varchar2) or
321: nvl(psp_era_shd.g_old_rec.eff_information4, hr_api.g_varchar2) <>
322: nvl(p_rec.eff_information4, hr_api.g_varchar2) or

Line 319: nvl(psp_era_shd.g_old_rec.eff_information3, hr_api.g_varchar2) <>

315: nvl(psp_era_shd.g_old_rec.eff_information1, hr_api.g_varchar2) <>
316: nvl(p_rec.eff_information1, hr_api.g_varchar2) or
317: nvl(psp_era_shd.g_old_rec.eff_information2, hr_api.g_varchar2) <>
318: nvl(p_rec.eff_information2, hr_api.g_varchar2) or
319: nvl(psp_era_shd.g_old_rec.eff_information3, hr_api.g_varchar2) <>
320: nvl(p_rec.eff_information3, hr_api.g_varchar2) or
321: nvl(psp_era_shd.g_old_rec.eff_information4, hr_api.g_varchar2) <>
322: nvl(p_rec.eff_information4, hr_api.g_varchar2) or
323: nvl(psp_era_shd.g_old_rec.eff_information5, hr_api.g_varchar2) <>

Line 320: nvl(p_rec.eff_information3, hr_api.g_varchar2) or

316: nvl(p_rec.eff_information1, hr_api.g_varchar2) or
317: nvl(psp_era_shd.g_old_rec.eff_information2, hr_api.g_varchar2) <>
318: nvl(p_rec.eff_information2, hr_api.g_varchar2) or
319: nvl(psp_era_shd.g_old_rec.eff_information3, hr_api.g_varchar2) <>
320: nvl(p_rec.eff_information3, hr_api.g_varchar2) or
321: nvl(psp_era_shd.g_old_rec.eff_information4, hr_api.g_varchar2) <>
322: nvl(p_rec.eff_information4, hr_api.g_varchar2) or
323: nvl(psp_era_shd.g_old_rec.eff_information5, hr_api.g_varchar2) <>
324: nvl(p_rec.eff_information5, hr_api.g_varchar2) or

Line 321: nvl(psp_era_shd.g_old_rec.eff_information4, hr_api.g_varchar2) <>

317: nvl(psp_era_shd.g_old_rec.eff_information2, hr_api.g_varchar2) <>
318: nvl(p_rec.eff_information2, hr_api.g_varchar2) or
319: nvl(psp_era_shd.g_old_rec.eff_information3, hr_api.g_varchar2) <>
320: nvl(p_rec.eff_information3, hr_api.g_varchar2) or
321: nvl(psp_era_shd.g_old_rec.eff_information4, hr_api.g_varchar2) <>
322: nvl(p_rec.eff_information4, hr_api.g_varchar2) or
323: nvl(psp_era_shd.g_old_rec.eff_information5, hr_api.g_varchar2) <>
324: nvl(p_rec.eff_information5, hr_api.g_varchar2) or
325: nvl(psp_era_shd.g_old_rec.eff_information6, hr_api.g_varchar2) <>

Line 322: nvl(p_rec.eff_information4, hr_api.g_varchar2) or

318: nvl(p_rec.eff_information2, hr_api.g_varchar2) or
319: nvl(psp_era_shd.g_old_rec.eff_information3, hr_api.g_varchar2) <>
320: nvl(p_rec.eff_information3, hr_api.g_varchar2) or
321: nvl(psp_era_shd.g_old_rec.eff_information4, hr_api.g_varchar2) <>
322: nvl(p_rec.eff_information4, hr_api.g_varchar2) or
323: nvl(psp_era_shd.g_old_rec.eff_information5, hr_api.g_varchar2) <>
324: nvl(p_rec.eff_information5, hr_api.g_varchar2) or
325: nvl(psp_era_shd.g_old_rec.eff_information6, hr_api.g_varchar2) <>
326: nvl(p_rec.eff_information6, hr_api.g_varchar2) or

Line 323: nvl(psp_era_shd.g_old_rec.eff_information5, hr_api.g_varchar2) <>

319: nvl(psp_era_shd.g_old_rec.eff_information3, hr_api.g_varchar2) <>
320: nvl(p_rec.eff_information3, hr_api.g_varchar2) or
321: nvl(psp_era_shd.g_old_rec.eff_information4, hr_api.g_varchar2) <>
322: nvl(p_rec.eff_information4, hr_api.g_varchar2) or
323: nvl(psp_era_shd.g_old_rec.eff_information5, hr_api.g_varchar2) <>
324: nvl(p_rec.eff_information5, hr_api.g_varchar2) or
325: nvl(psp_era_shd.g_old_rec.eff_information6, hr_api.g_varchar2) <>
326: nvl(p_rec.eff_information6, hr_api.g_varchar2) or
327: nvl(psp_era_shd.g_old_rec.eff_information7, hr_api.g_varchar2) <>

Line 324: nvl(p_rec.eff_information5, hr_api.g_varchar2) or

320: nvl(p_rec.eff_information3, hr_api.g_varchar2) or
321: nvl(psp_era_shd.g_old_rec.eff_information4, hr_api.g_varchar2) <>
322: nvl(p_rec.eff_information4, hr_api.g_varchar2) or
323: nvl(psp_era_shd.g_old_rec.eff_information5, hr_api.g_varchar2) <>
324: nvl(p_rec.eff_information5, hr_api.g_varchar2) or
325: nvl(psp_era_shd.g_old_rec.eff_information6, hr_api.g_varchar2) <>
326: nvl(p_rec.eff_information6, hr_api.g_varchar2) or
327: nvl(psp_era_shd.g_old_rec.eff_information7, hr_api.g_varchar2) <>
328: nvl(p_rec.eff_information7, hr_api.g_varchar2) or

Line 325: nvl(psp_era_shd.g_old_rec.eff_information6, hr_api.g_varchar2) <>

321: nvl(psp_era_shd.g_old_rec.eff_information4, hr_api.g_varchar2) <>
322: nvl(p_rec.eff_information4, hr_api.g_varchar2) or
323: nvl(psp_era_shd.g_old_rec.eff_information5, hr_api.g_varchar2) <>
324: nvl(p_rec.eff_information5, hr_api.g_varchar2) or
325: nvl(psp_era_shd.g_old_rec.eff_information6, hr_api.g_varchar2) <>
326: nvl(p_rec.eff_information6, hr_api.g_varchar2) or
327: nvl(psp_era_shd.g_old_rec.eff_information7, hr_api.g_varchar2) <>
328: nvl(p_rec.eff_information7, hr_api.g_varchar2) or
329: nvl(psp_era_shd.g_old_rec.eff_information8, hr_api.g_varchar2) <>

Line 326: nvl(p_rec.eff_information6, hr_api.g_varchar2) or

322: nvl(p_rec.eff_information4, hr_api.g_varchar2) or
323: nvl(psp_era_shd.g_old_rec.eff_information5, hr_api.g_varchar2) <>
324: nvl(p_rec.eff_information5, hr_api.g_varchar2) or
325: nvl(psp_era_shd.g_old_rec.eff_information6, hr_api.g_varchar2) <>
326: nvl(p_rec.eff_information6, hr_api.g_varchar2) or
327: nvl(psp_era_shd.g_old_rec.eff_information7, hr_api.g_varchar2) <>
328: nvl(p_rec.eff_information7, hr_api.g_varchar2) or
329: nvl(psp_era_shd.g_old_rec.eff_information8, hr_api.g_varchar2) <>
330: nvl(p_rec.eff_information8, hr_api.g_varchar2) or

Line 327: nvl(psp_era_shd.g_old_rec.eff_information7, hr_api.g_varchar2) <>

323: nvl(psp_era_shd.g_old_rec.eff_information5, hr_api.g_varchar2) <>
324: nvl(p_rec.eff_information5, hr_api.g_varchar2) or
325: nvl(psp_era_shd.g_old_rec.eff_information6, hr_api.g_varchar2) <>
326: nvl(p_rec.eff_information6, hr_api.g_varchar2) or
327: nvl(psp_era_shd.g_old_rec.eff_information7, hr_api.g_varchar2) <>
328: nvl(p_rec.eff_information7, hr_api.g_varchar2) or
329: nvl(psp_era_shd.g_old_rec.eff_information8, hr_api.g_varchar2) <>
330: nvl(p_rec.eff_information8, hr_api.g_varchar2) or
331: nvl(psp_era_shd.g_old_rec.eff_information9, hr_api.g_varchar2) <>

Line 328: nvl(p_rec.eff_information7, hr_api.g_varchar2) or

324: nvl(p_rec.eff_information5, hr_api.g_varchar2) or
325: nvl(psp_era_shd.g_old_rec.eff_information6, hr_api.g_varchar2) <>
326: nvl(p_rec.eff_information6, hr_api.g_varchar2) or
327: nvl(psp_era_shd.g_old_rec.eff_information7, hr_api.g_varchar2) <>
328: nvl(p_rec.eff_information7, hr_api.g_varchar2) or
329: nvl(psp_era_shd.g_old_rec.eff_information8, hr_api.g_varchar2) <>
330: nvl(p_rec.eff_information8, hr_api.g_varchar2) or
331: nvl(psp_era_shd.g_old_rec.eff_information9, hr_api.g_varchar2) <>
332: nvl(p_rec.eff_information9, hr_api.g_varchar2) or

Line 329: nvl(psp_era_shd.g_old_rec.eff_information8, hr_api.g_varchar2) <>

325: nvl(psp_era_shd.g_old_rec.eff_information6, hr_api.g_varchar2) <>
326: nvl(p_rec.eff_information6, hr_api.g_varchar2) or
327: nvl(psp_era_shd.g_old_rec.eff_information7, hr_api.g_varchar2) <>
328: nvl(p_rec.eff_information7, hr_api.g_varchar2) or
329: nvl(psp_era_shd.g_old_rec.eff_information8, hr_api.g_varchar2) <>
330: nvl(p_rec.eff_information8, hr_api.g_varchar2) or
331: nvl(psp_era_shd.g_old_rec.eff_information9, hr_api.g_varchar2) <>
332: nvl(p_rec.eff_information9, hr_api.g_varchar2) or
333: nvl(psp_era_shd.g_old_rec.eff_information10, hr_api.g_varchar2) <>

Line 330: nvl(p_rec.eff_information8, hr_api.g_varchar2) or

326: nvl(p_rec.eff_information6, hr_api.g_varchar2) or
327: nvl(psp_era_shd.g_old_rec.eff_information7, hr_api.g_varchar2) <>
328: nvl(p_rec.eff_information7, hr_api.g_varchar2) or
329: nvl(psp_era_shd.g_old_rec.eff_information8, hr_api.g_varchar2) <>
330: nvl(p_rec.eff_information8, hr_api.g_varchar2) or
331: nvl(psp_era_shd.g_old_rec.eff_information9, hr_api.g_varchar2) <>
332: nvl(p_rec.eff_information9, hr_api.g_varchar2) or
333: nvl(psp_era_shd.g_old_rec.eff_information10, hr_api.g_varchar2) <>
334: nvl(p_rec.eff_information10, hr_api.g_varchar2) or

Line 331: nvl(psp_era_shd.g_old_rec.eff_information9, hr_api.g_varchar2) <>

327: nvl(psp_era_shd.g_old_rec.eff_information7, hr_api.g_varchar2) <>
328: nvl(p_rec.eff_information7, hr_api.g_varchar2) or
329: nvl(psp_era_shd.g_old_rec.eff_information8, hr_api.g_varchar2) <>
330: nvl(p_rec.eff_information8, hr_api.g_varchar2) or
331: nvl(psp_era_shd.g_old_rec.eff_information9, hr_api.g_varchar2) <>
332: nvl(p_rec.eff_information9, hr_api.g_varchar2) or
333: nvl(psp_era_shd.g_old_rec.eff_information10, hr_api.g_varchar2) <>
334: nvl(p_rec.eff_information10, hr_api.g_varchar2) or
335: nvl(psp_era_shd.g_old_rec.eff_information11, hr_api.g_varchar2) <>

Line 332: nvl(p_rec.eff_information9, hr_api.g_varchar2) or

328: nvl(p_rec.eff_information7, hr_api.g_varchar2) or
329: nvl(psp_era_shd.g_old_rec.eff_information8, hr_api.g_varchar2) <>
330: nvl(p_rec.eff_information8, hr_api.g_varchar2) or
331: nvl(psp_era_shd.g_old_rec.eff_information9, hr_api.g_varchar2) <>
332: nvl(p_rec.eff_information9, hr_api.g_varchar2) or
333: nvl(psp_era_shd.g_old_rec.eff_information10, hr_api.g_varchar2) <>
334: nvl(p_rec.eff_information10, hr_api.g_varchar2) or
335: nvl(psp_era_shd.g_old_rec.eff_information11, hr_api.g_varchar2) <>
336: nvl(p_rec.eff_information11, hr_api.g_varchar2) or

Line 333: nvl(psp_era_shd.g_old_rec.eff_information10, hr_api.g_varchar2) <>

329: nvl(psp_era_shd.g_old_rec.eff_information8, hr_api.g_varchar2) <>
330: nvl(p_rec.eff_information8, hr_api.g_varchar2) or
331: nvl(psp_era_shd.g_old_rec.eff_information9, hr_api.g_varchar2) <>
332: nvl(p_rec.eff_information9, hr_api.g_varchar2) or
333: nvl(psp_era_shd.g_old_rec.eff_information10, hr_api.g_varchar2) <>
334: nvl(p_rec.eff_information10, hr_api.g_varchar2) or
335: nvl(psp_era_shd.g_old_rec.eff_information11, hr_api.g_varchar2) <>
336: nvl(p_rec.eff_information11, hr_api.g_varchar2) or
337: nvl(psp_era_shd.g_old_rec.eff_information12, hr_api.g_varchar2) <>

Line 334: nvl(p_rec.eff_information10, hr_api.g_varchar2) or

330: nvl(p_rec.eff_information8, hr_api.g_varchar2) or
331: nvl(psp_era_shd.g_old_rec.eff_information9, hr_api.g_varchar2) <>
332: nvl(p_rec.eff_information9, hr_api.g_varchar2) or
333: nvl(psp_era_shd.g_old_rec.eff_information10, hr_api.g_varchar2) <>
334: nvl(p_rec.eff_information10, hr_api.g_varchar2) or
335: nvl(psp_era_shd.g_old_rec.eff_information11, hr_api.g_varchar2) <>
336: nvl(p_rec.eff_information11, hr_api.g_varchar2) or
337: nvl(psp_era_shd.g_old_rec.eff_information12, hr_api.g_varchar2) <>
338: nvl(p_rec.eff_information12, hr_api.g_varchar2) or

Line 335: nvl(psp_era_shd.g_old_rec.eff_information11, hr_api.g_varchar2) <>

331: nvl(psp_era_shd.g_old_rec.eff_information9, hr_api.g_varchar2) <>
332: nvl(p_rec.eff_information9, hr_api.g_varchar2) or
333: nvl(psp_era_shd.g_old_rec.eff_information10, hr_api.g_varchar2) <>
334: nvl(p_rec.eff_information10, hr_api.g_varchar2) or
335: nvl(psp_era_shd.g_old_rec.eff_information11, hr_api.g_varchar2) <>
336: nvl(p_rec.eff_information11, hr_api.g_varchar2) or
337: nvl(psp_era_shd.g_old_rec.eff_information12, hr_api.g_varchar2) <>
338: nvl(p_rec.eff_information12, hr_api.g_varchar2) or
339: nvl(psp_era_shd.g_old_rec.eff_information13, hr_api.g_varchar2) <>

Line 336: nvl(p_rec.eff_information11, hr_api.g_varchar2) or

332: nvl(p_rec.eff_information9, hr_api.g_varchar2) or
333: nvl(psp_era_shd.g_old_rec.eff_information10, hr_api.g_varchar2) <>
334: nvl(p_rec.eff_information10, hr_api.g_varchar2) or
335: nvl(psp_era_shd.g_old_rec.eff_information11, hr_api.g_varchar2) <>
336: nvl(p_rec.eff_information11, hr_api.g_varchar2) or
337: nvl(psp_era_shd.g_old_rec.eff_information12, hr_api.g_varchar2) <>
338: nvl(p_rec.eff_information12, hr_api.g_varchar2) or
339: nvl(psp_era_shd.g_old_rec.eff_information13, hr_api.g_varchar2) <>
340: nvl(p_rec.eff_information13, hr_api.g_varchar2) or

Line 337: nvl(psp_era_shd.g_old_rec.eff_information12, hr_api.g_varchar2) <>

333: nvl(psp_era_shd.g_old_rec.eff_information10, hr_api.g_varchar2) <>
334: nvl(p_rec.eff_information10, hr_api.g_varchar2) or
335: nvl(psp_era_shd.g_old_rec.eff_information11, hr_api.g_varchar2) <>
336: nvl(p_rec.eff_information11, hr_api.g_varchar2) or
337: nvl(psp_era_shd.g_old_rec.eff_information12, hr_api.g_varchar2) <>
338: nvl(p_rec.eff_information12, hr_api.g_varchar2) or
339: nvl(psp_era_shd.g_old_rec.eff_information13, hr_api.g_varchar2) <>
340: nvl(p_rec.eff_information13, hr_api.g_varchar2) or
341: nvl(psp_era_shd.g_old_rec.eff_information14, hr_api.g_varchar2) <>

Line 338: nvl(p_rec.eff_information12, hr_api.g_varchar2) or

334: nvl(p_rec.eff_information10, hr_api.g_varchar2) or
335: nvl(psp_era_shd.g_old_rec.eff_information11, hr_api.g_varchar2) <>
336: nvl(p_rec.eff_information11, hr_api.g_varchar2) or
337: nvl(psp_era_shd.g_old_rec.eff_information12, hr_api.g_varchar2) <>
338: nvl(p_rec.eff_information12, hr_api.g_varchar2) or
339: nvl(psp_era_shd.g_old_rec.eff_information13, hr_api.g_varchar2) <>
340: nvl(p_rec.eff_information13, hr_api.g_varchar2) or
341: nvl(psp_era_shd.g_old_rec.eff_information14, hr_api.g_varchar2) <>
342: nvl(p_rec.eff_information14, hr_api.g_varchar2) or

Line 339: nvl(psp_era_shd.g_old_rec.eff_information13, hr_api.g_varchar2) <>

335: nvl(psp_era_shd.g_old_rec.eff_information11, hr_api.g_varchar2) <>
336: nvl(p_rec.eff_information11, hr_api.g_varchar2) or
337: nvl(psp_era_shd.g_old_rec.eff_information12, hr_api.g_varchar2) <>
338: nvl(p_rec.eff_information12, hr_api.g_varchar2) or
339: nvl(psp_era_shd.g_old_rec.eff_information13, hr_api.g_varchar2) <>
340: nvl(p_rec.eff_information13, hr_api.g_varchar2) or
341: nvl(psp_era_shd.g_old_rec.eff_information14, hr_api.g_varchar2) <>
342: nvl(p_rec.eff_information14, hr_api.g_varchar2) or
343: nvl(psp_era_shd.g_old_rec.eff_information15, hr_api.g_varchar2) <>

Line 340: nvl(p_rec.eff_information13, hr_api.g_varchar2) or

336: nvl(p_rec.eff_information11, hr_api.g_varchar2) or
337: nvl(psp_era_shd.g_old_rec.eff_information12, hr_api.g_varchar2) <>
338: nvl(p_rec.eff_information12, hr_api.g_varchar2) or
339: nvl(psp_era_shd.g_old_rec.eff_information13, hr_api.g_varchar2) <>
340: nvl(p_rec.eff_information13, hr_api.g_varchar2) or
341: nvl(psp_era_shd.g_old_rec.eff_information14, hr_api.g_varchar2) <>
342: nvl(p_rec.eff_information14, hr_api.g_varchar2) or
343: nvl(psp_era_shd.g_old_rec.eff_information15, hr_api.g_varchar2) <>
344: nvl(p_rec.eff_information15, hr_api.g_varchar2 )))

Line 341: nvl(psp_era_shd.g_old_rec.eff_information14, hr_api.g_varchar2) <>

337: nvl(psp_era_shd.g_old_rec.eff_information12, hr_api.g_varchar2) <>
338: nvl(p_rec.eff_information12, hr_api.g_varchar2) or
339: nvl(psp_era_shd.g_old_rec.eff_information13, hr_api.g_varchar2) <>
340: nvl(p_rec.eff_information13, hr_api.g_varchar2) or
341: nvl(psp_era_shd.g_old_rec.eff_information14, hr_api.g_varchar2) <>
342: nvl(p_rec.eff_information14, hr_api.g_varchar2) or
343: nvl(psp_era_shd.g_old_rec.eff_information15, hr_api.g_varchar2) <>
344: nvl(p_rec.eff_information15, hr_api.g_varchar2 )))
345: or (p_rec.effort_report_approval_id is null) then

Line 342: nvl(p_rec.eff_information14, hr_api.g_varchar2) or

338: nvl(p_rec.eff_information12, hr_api.g_varchar2) or
339: nvl(psp_era_shd.g_old_rec.eff_information13, hr_api.g_varchar2) <>
340: nvl(p_rec.eff_information13, hr_api.g_varchar2) or
341: nvl(psp_era_shd.g_old_rec.eff_information14, hr_api.g_varchar2) <>
342: nvl(p_rec.eff_information14, hr_api.g_varchar2) or
343: nvl(psp_era_shd.g_old_rec.eff_information15, hr_api.g_varchar2) <>
344: nvl(p_rec.eff_information15, hr_api.g_varchar2 )))
345: or (p_rec.effort_report_approval_id is null) then
346: --

Line 343: nvl(psp_era_shd.g_old_rec.eff_information15, hr_api.g_varchar2) <>

339: nvl(psp_era_shd.g_old_rec.eff_information13, hr_api.g_varchar2) <>
340: nvl(p_rec.eff_information13, hr_api.g_varchar2) or
341: nvl(psp_era_shd.g_old_rec.eff_information14, hr_api.g_varchar2) <>
342: nvl(p_rec.eff_information14, hr_api.g_varchar2) or
343: nvl(psp_era_shd.g_old_rec.eff_information15, hr_api.g_varchar2) <>
344: nvl(p_rec.eff_information15, hr_api.g_varchar2 )))
345: or (p_rec.effort_report_approval_id is null) then
346: --
347: -- Only execute the validation if absolutely necessary:

Line 344: nvl(p_rec.eff_information15, hr_api.g_varchar2 )))

340: nvl(p_rec.eff_information13, hr_api.g_varchar2) or
341: nvl(psp_era_shd.g_old_rec.eff_information14, hr_api.g_varchar2) <>
342: nvl(p_rec.eff_information14, hr_api.g_varchar2) or
343: nvl(psp_era_shd.g_old_rec.eff_information15, hr_api.g_varchar2) <>
344: nvl(p_rec.eff_information15, hr_api.g_varchar2 )))
345: or (p_rec.effort_report_approval_id is null) then
346: --
347: -- Only execute the validation if absolutely necessary:
348: -- a) During update, the structure column value or any