51: hr_utility.set_location('Entering:'|| l_proc, 10);
52: --
53: -- Ensure that all the mandatory parameter are not null
54: --
55: hr_api.mandatory_arg_error
56: (p_api_name => l_proc
57: ,p_argument => 'effort_report_detail_id'
58: ,p_argument_value => p_effort_report_detail_id
59: );
78: close csr_sec_grp;
79: --
80: -- Set the security_group_id in CLIENT_INFO
81: --
82: hr_api.set_security_group_id
83: (p_security_group_id => l_security_group_id
84: );
85: --
86: -- Set the sessions legislation context in HR_SESSION_DATA
84: );
85: --
86: -- Set the sessions legislation context in HR_SESSION_DATA
87: --
88: hr_api.set_legislation_context(l_legislation_code);
89: end if;
90: --
91: hr_utility.set_location(' Leaving:'|| l_proc, 20);
92: --
127: hr_utility.set_location('Entering:'|| l_proc, 10);
128: --
129: -- Ensure that all the mandatory parameter are not null
130: --
131: hr_api.mandatory_arg_error
132: (p_api_name => l_proc
133: ,p_argument => 'effort_report_detail_id'
134: ,p_argument_value => p_effort_report_detail_id
135: );
133: ,p_argument => 'effort_report_detail_id'
134: ,p_argument_value => p_effort_report_detail_id
135: );
136: --
137: if ( nvl(psp_erd_bus.g_effort_report_detail_id, hr_api.g_number)
138: = p_effort_report_detail_id) then
139: --
140: -- The legislation code has already been found with a previous
141: -- call to this function. Just return the value in the global
209: begin
210: hr_utility.set_location('Entering:'||l_proc,10);
211: --
212: if ((p_rec.effort_report_detail_id is not null) and (
213: nvl(psp_erd_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute1, hr_api.g_varchar2) or
215: nvl(psp_erd_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute2, hr_api.g_varchar2) or
217: nvl(psp_erd_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
210: hr_utility.set_location('Entering:'||l_proc,10);
211: --
212: if ((p_rec.effort_report_detail_id is not null) and (
213: nvl(psp_erd_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute1, hr_api.g_varchar2) or
215: nvl(psp_erd_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute2, hr_api.g_varchar2) or
217: nvl(psp_erd_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute3, hr_api.g_varchar2) or
211: --
212: if ((p_rec.effort_report_detail_id is not null) and (
213: nvl(psp_erd_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute1, hr_api.g_varchar2) or
215: nvl(psp_erd_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute2, hr_api.g_varchar2) or
217: nvl(psp_erd_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute3, hr_api.g_varchar2) or
219: nvl(psp_erd_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
212: if ((p_rec.effort_report_detail_id is not null) and (
213: nvl(psp_erd_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute1, hr_api.g_varchar2) or
215: nvl(psp_erd_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute2, hr_api.g_varchar2) or
217: nvl(psp_erd_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute3, hr_api.g_varchar2) or
219: nvl(psp_erd_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute4, hr_api.g_varchar2) or
213: nvl(psp_erd_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute1, hr_api.g_varchar2) or
215: nvl(psp_erd_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute2, hr_api.g_varchar2) or
217: nvl(psp_erd_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute3, hr_api.g_varchar2) or
219: nvl(psp_erd_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute4, hr_api.g_varchar2) or
221: nvl(psp_erd_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute1, hr_api.g_varchar2) or
215: nvl(psp_erd_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute2, hr_api.g_varchar2) or
217: nvl(psp_erd_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute3, hr_api.g_varchar2) or
219: nvl(psp_erd_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute4, hr_api.g_varchar2) or
221: nvl(psp_erd_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute5, hr_api.g_varchar2) or
215: nvl(psp_erd_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute2, hr_api.g_varchar2) or
217: nvl(psp_erd_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute3, hr_api.g_varchar2) or
219: nvl(psp_erd_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute4, hr_api.g_varchar2) or
221: nvl(psp_erd_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute5, hr_api.g_varchar2) or
223: nvl(psp_erd_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute2, hr_api.g_varchar2) or
217: nvl(psp_erd_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute3, hr_api.g_varchar2) or
219: nvl(psp_erd_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute4, hr_api.g_varchar2) or
221: nvl(psp_erd_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute5, hr_api.g_varchar2) or
223: nvl(psp_erd_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute6, hr_api.g_varchar2) or
217: nvl(psp_erd_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute3, hr_api.g_varchar2) or
219: nvl(psp_erd_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute4, hr_api.g_varchar2) or
221: nvl(psp_erd_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute5, hr_api.g_varchar2) or
223: nvl(psp_erd_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute6, hr_api.g_varchar2) or
225: nvl(psp_erd_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute3, hr_api.g_varchar2) or
219: nvl(psp_erd_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute4, hr_api.g_varchar2) or
221: nvl(psp_erd_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute5, hr_api.g_varchar2) or
223: nvl(psp_erd_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute6, hr_api.g_varchar2) or
225: nvl(psp_erd_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute7, hr_api.g_varchar2) or
219: nvl(psp_erd_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute4, hr_api.g_varchar2) or
221: nvl(psp_erd_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute5, hr_api.g_varchar2) or
223: nvl(psp_erd_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute6, hr_api.g_varchar2) or
225: nvl(psp_erd_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute7, hr_api.g_varchar2) or
227: nvl(psp_erd_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute4, hr_api.g_varchar2) or
221: nvl(psp_erd_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute5, hr_api.g_varchar2) or
223: nvl(psp_erd_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute6, hr_api.g_varchar2) or
225: nvl(psp_erd_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute7, hr_api.g_varchar2) or
227: nvl(psp_erd_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute8, hr_api.g_varchar2) or
221: nvl(psp_erd_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute5, hr_api.g_varchar2) or
223: nvl(psp_erd_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute6, hr_api.g_varchar2) or
225: nvl(psp_erd_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute7, hr_api.g_varchar2) or
227: nvl(psp_erd_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute8, hr_api.g_varchar2) or
229: nvl(psp_erd_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute5, hr_api.g_varchar2) or
223: nvl(psp_erd_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute6, hr_api.g_varchar2) or
225: nvl(psp_erd_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute7, hr_api.g_varchar2) or
227: nvl(psp_erd_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute8, hr_api.g_varchar2) or
229: nvl(psp_erd_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute9, hr_api.g_varchar2) or
223: nvl(psp_erd_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute6, hr_api.g_varchar2) or
225: nvl(psp_erd_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute7, hr_api.g_varchar2) or
227: nvl(psp_erd_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute8, hr_api.g_varchar2) or
229: nvl(psp_erd_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute9, hr_api.g_varchar2) or
231: nvl(psp_erd_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute6, hr_api.g_varchar2) or
225: nvl(psp_erd_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute7, hr_api.g_varchar2) or
227: nvl(psp_erd_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute8, hr_api.g_varchar2) or
229: nvl(psp_erd_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute9, hr_api.g_varchar2) or
231: nvl(psp_erd_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute10, hr_api.g_varchar2) ))
225: nvl(psp_erd_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute7, hr_api.g_varchar2) or
227: nvl(psp_erd_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute8, hr_api.g_varchar2) or
229: nvl(psp_erd_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute9, hr_api.g_varchar2) or
231: nvl(psp_erd_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute10, hr_api.g_varchar2) ))
233: or (p_rec.effort_report_detail_id is null) then
226: nvl(p_rec.attribute7, hr_api.g_varchar2) or
227: nvl(psp_erd_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute8, hr_api.g_varchar2) or
229: nvl(psp_erd_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute9, hr_api.g_varchar2) or
231: nvl(psp_erd_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute10, hr_api.g_varchar2) ))
233: or (p_rec.effort_report_detail_id is null) then
234: --
227: nvl(psp_erd_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute8, hr_api.g_varchar2) or
229: nvl(psp_erd_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute9, hr_api.g_varchar2) or
231: nvl(psp_erd_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute10, hr_api.g_varchar2) ))
233: or (p_rec.effort_report_detail_id is null) then
234: --
235: -- Only execute the validation if absolutely necessary:
228: nvl(p_rec.attribute8, hr_api.g_varchar2) or
229: nvl(psp_erd_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute9, hr_api.g_varchar2) or
231: nvl(psp_erd_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute10, hr_api.g_varchar2) ))
233: or (p_rec.effort_report_detail_id is null) then
234: --
235: -- Only execute the validation if absolutely necessary:
236: -- a) During update, the structure column value or any