40: hr_utility.set_location('Entering:'|| l_proc, 10);
41: --
42: -- Ensure that all the mandatory parameter are not null
43: --
44: hr_api.mandatory_arg_error
45: (p_api_name => l_proc
46: ,p_argument => 'organization_id'
47: ,p_argument_value => p_organization_id
48: );
63: close csr_sec_grp;
64: --
65: -- Set the security_group_id in CLIENT_INFO
66: --
67: hr_api.set_security_group_id
68: (p_security_group_id => l_security_group_id
69: );
70: --
71: hr_utility.set_location(' Leaving:'|| l_proc, 20);
101: hr_utility.set_location('Entering:'|| l_proc, 10);
102: --
103: -- Ensure that all the mandatory parameter are not null
104: --
105: hr_api.mandatory_arg_error
106: (p_api_name => l_proc
107: ,p_argument => 'organization_id'
108: ,p_argument_value => p_organization_id
109: );
107: ,p_argument => 'organization_id'
108: ,p_argument_value => p_organization_id
109: );
110: --
111: if ( nvl(hr_oru_bus.g_organization_id, hr_api.g_number)
112: = p_organization_id) then
113: --
114: -- The legislation code has already been found with a previous
115: -- call to this function. Just return the value in the global
183: begin
184: hr_utility.set_location('Entering:'||l_proc,10);
185: --
186: if ((p_rec.organization_id is not null) and (
187: nvl(hr_oru_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
188: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
189: nvl(hr_oru_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute1, hr_api.g_varchar2) or
191: nvl(hr_oru_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
184: hr_utility.set_location('Entering:'||l_proc,10);
185: --
186: if ((p_rec.organization_id is not null) and (
187: nvl(hr_oru_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
188: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
189: nvl(hr_oru_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute1, hr_api.g_varchar2) or
191: nvl(hr_oru_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute2, hr_api.g_varchar2) or
185: --
186: if ((p_rec.organization_id is not null) and (
187: nvl(hr_oru_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
188: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
189: nvl(hr_oru_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute1, hr_api.g_varchar2) or
191: nvl(hr_oru_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute2, hr_api.g_varchar2) or
193: nvl(hr_oru_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
186: if ((p_rec.organization_id is not null) and (
187: nvl(hr_oru_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
188: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
189: nvl(hr_oru_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute1, hr_api.g_varchar2) or
191: nvl(hr_oru_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute2, hr_api.g_varchar2) or
193: nvl(hr_oru_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute3, hr_api.g_varchar2) or
187: nvl(hr_oru_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
188: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
189: nvl(hr_oru_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute1, hr_api.g_varchar2) or
191: nvl(hr_oru_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute2, hr_api.g_varchar2) or
193: nvl(hr_oru_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute3, hr_api.g_varchar2) or
195: nvl(hr_oru_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
188: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
189: nvl(hr_oru_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute1, hr_api.g_varchar2) or
191: nvl(hr_oru_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute2, hr_api.g_varchar2) or
193: nvl(hr_oru_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute3, hr_api.g_varchar2) or
195: nvl(hr_oru_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute4, hr_api.g_varchar2) or
189: nvl(hr_oru_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute1, hr_api.g_varchar2) or
191: nvl(hr_oru_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute2, hr_api.g_varchar2) or
193: nvl(hr_oru_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute3, hr_api.g_varchar2) or
195: nvl(hr_oru_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute4, hr_api.g_varchar2) or
197: nvl(hr_oru_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute1, hr_api.g_varchar2) or
191: nvl(hr_oru_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute2, hr_api.g_varchar2) or
193: nvl(hr_oru_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute3, hr_api.g_varchar2) or
195: nvl(hr_oru_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute4, hr_api.g_varchar2) or
197: nvl(hr_oru_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute5, hr_api.g_varchar2) or
191: nvl(hr_oru_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute2, hr_api.g_varchar2) or
193: nvl(hr_oru_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute3, hr_api.g_varchar2) or
195: nvl(hr_oru_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute4, hr_api.g_varchar2) or
197: nvl(hr_oru_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute5, hr_api.g_varchar2) or
199: nvl(hr_oru_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute2, hr_api.g_varchar2) or
193: nvl(hr_oru_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute3, hr_api.g_varchar2) or
195: nvl(hr_oru_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute4, hr_api.g_varchar2) or
197: nvl(hr_oru_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute5, hr_api.g_varchar2) or
199: nvl(hr_oru_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute6, hr_api.g_varchar2) or
193: nvl(hr_oru_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute3, hr_api.g_varchar2) or
195: nvl(hr_oru_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute4, hr_api.g_varchar2) or
197: nvl(hr_oru_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute5, hr_api.g_varchar2) or
199: nvl(hr_oru_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute6, hr_api.g_varchar2) or
201: nvl(hr_oru_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute3, hr_api.g_varchar2) or
195: nvl(hr_oru_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute4, hr_api.g_varchar2) or
197: nvl(hr_oru_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute5, hr_api.g_varchar2) or
199: nvl(hr_oru_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute6, hr_api.g_varchar2) or
201: nvl(hr_oru_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute7, hr_api.g_varchar2) or
195: nvl(hr_oru_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute4, hr_api.g_varchar2) or
197: nvl(hr_oru_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute5, hr_api.g_varchar2) or
199: nvl(hr_oru_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute6, hr_api.g_varchar2) or
201: nvl(hr_oru_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute7, hr_api.g_varchar2) or
203: nvl(hr_oru_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute4, hr_api.g_varchar2) or
197: nvl(hr_oru_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute5, hr_api.g_varchar2) or
199: nvl(hr_oru_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute6, hr_api.g_varchar2) or
201: nvl(hr_oru_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute7, hr_api.g_varchar2) or
203: nvl(hr_oru_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute8, hr_api.g_varchar2) or
197: nvl(hr_oru_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute5, hr_api.g_varchar2) or
199: nvl(hr_oru_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute6, hr_api.g_varchar2) or
201: nvl(hr_oru_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute7, hr_api.g_varchar2) or
203: nvl(hr_oru_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute8, hr_api.g_varchar2) or
205: nvl(hr_oru_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute5, hr_api.g_varchar2) or
199: nvl(hr_oru_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute6, hr_api.g_varchar2) or
201: nvl(hr_oru_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute7, hr_api.g_varchar2) or
203: nvl(hr_oru_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute8, hr_api.g_varchar2) or
205: nvl(hr_oru_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute9, hr_api.g_varchar2) or
199: nvl(hr_oru_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute6, hr_api.g_varchar2) or
201: nvl(hr_oru_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute7, hr_api.g_varchar2) or
203: nvl(hr_oru_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute8, hr_api.g_varchar2) or
205: nvl(hr_oru_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute9, hr_api.g_varchar2) or
207: nvl(hr_oru_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute6, hr_api.g_varchar2) or
201: nvl(hr_oru_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute7, hr_api.g_varchar2) or
203: nvl(hr_oru_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute8, hr_api.g_varchar2) or
205: nvl(hr_oru_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute9, hr_api.g_varchar2) or
207: nvl(hr_oru_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute10, hr_api.g_varchar2) or
201: nvl(hr_oru_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute7, hr_api.g_varchar2) or
203: nvl(hr_oru_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute8, hr_api.g_varchar2) or
205: nvl(hr_oru_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute9, hr_api.g_varchar2) or
207: nvl(hr_oru_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute10, hr_api.g_varchar2) or
209: nvl(hr_oru_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute7, hr_api.g_varchar2) or
203: nvl(hr_oru_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute8, hr_api.g_varchar2) or
205: nvl(hr_oru_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute9, hr_api.g_varchar2) or
207: nvl(hr_oru_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute10, hr_api.g_varchar2) or
209: nvl(hr_oru_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute11, hr_api.g_varchar2) or
203: nvl(hr_oru_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute8, hr_api.g_varchar2) or
205: nvl(hr_oru_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute9, hr_api.g_varchar2) or
207: nvl(hr_oru_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute10, hr_api.g_varchar2) or
209: nvl(hr_oru_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute11, hr_api.g_varchar2) or
211: nvl(hr_oru_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute8, hr_api.g_varchar2) or
205: nvl(hr_oru_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute9, hr_api.g_varchar2) or
207: nvl(hr_oru_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute10, hr_api.g_varchar2) or
209: nvl(hr_oru_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute11, hr_api.g_varchar2) or
211: nvl(hr_oru_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute12, hr_api.g_varchar2) or
205: nvl(hr_oru_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute9, hr_api.g_varchar2) or
207: nvl(hr_oru_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute10, hr_api.g_varchar2) or
209: nvl(hr_oru_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute11, hr_api.g_varchar2) or
211: nvl(hr_oru_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute12, hr_api.g_varchar2) or
213: nvl(hr_oru_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute9, hr_api.g_varchar2) or
207: nvl(hr_oru_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute10, hr_api.g_varchar2) or
209: nvl(hr_oru_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute11, hr_api.g_varchar2) or
211: nvl(hr_oru_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute12, hr_api.g_varchar2) or
213: nvl(hr_oru_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute13, hr_api.g_varchar2) or
207: nvl(hr_oru_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute10, hr_api.g_varchar2) or
209: nvl(hr_oru_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute11, hr_api.g_varchar2) or
211: nvl(hr_oru_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute12, hr_api.g_varchar2) or
213: nvl(hr_oru_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute13, hr_api.g_varchar2) or
215: nvl(hr_oru_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute10, hr_api.g_varchar2) or
209: nvl(hr_oru_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute11, hr_api.g_varchar2) or
211: nvl(hr_oru_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute12, hr_api.g_varchar2) or
213: nvl(hr_oru_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute13, hr_api.g_varchar2) or
215: nvl(hr_oru_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute14, hr_api.g_varchar2) or
209: nvl(hr_oru_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute11, hr_api.g_varchar2) or
211: nvl(hr_oru_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute12, hr_api.g_varchar2) or
213: nvl(hr_oru_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute13, hr_api.g_varchar2) or
215: nvl(hr_oru_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute14, hr_api.g_varchar2) or
217: nvl(hr_oru_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute11, hr_api.g_varchar2) or
211: nvl(hr_oru_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute12, hr_api.g_varchar2) or
213: nvl(hr_oru_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute13, hr_api.g_varchar2) or
215: nvl(hr_oru_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute14, hr_api.g_varchar2) or
217: nvl(hr_oru_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute15, hr_api.g_varchar2) or
211: nvl(hr_oru_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute12, hr_api.g_varchar2) or
213: nvl(hr_oru_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute13, hr_api.g_varchar2) or
215: nvl(hr_oru_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute14, hr_api.g_varchar2) or
217: nvl(hr_oru_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute15, hr_api.g_varchar2) or
219: nvl(hr_oru_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute12, hr_api.g_varchar2) or
213: nvl(hr_oru_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute13, hr_api.g_varchar2) or
215: nvl(hr_oru_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute14, hr_api.g_varchar2) or
217: nvl(hr_oru_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute15, hr_api.g_varchar2) or
219: nvl(hr_oru_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute16, hr_api.g_varchar2) or
213: nvl(hr_oru_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute13, hr_api.g_varchar2) or
215: nvl(hr_oru_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute14, hr_api.g_varchar2) or
217: nvl(hr_oru_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute15, hr_api.g_varchar2) or
219: nvl(hr_oru_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute16, hr_api.g_varchar2) or
221: nvl(hr_oru_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute13, hr_api.g_varchar2) or
215: nvl(hr_oru_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute14, hr_api.g_varchar2) or
217: nvl(hr_oru_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute15, hr_api.g_varchar2) or
219: nvl(hr_oru_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute16, hr_api.g_varchar2) or
221: nvl(hr_oru_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute17, hr_api.g_varchar2) or
215: nvl(hr_oru_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute14, hr_api.g_varchar2) or
217: nvl(hr_oru_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute15, hr_api.g_varchar2) or
219: nvl(hr_oru_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute16, hr_api.g_varchar2) or
221: nvl(hr_oru_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute17, hr_api.g_varchar2) or
223: nvl(hr_oru_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute14, hr_api.g_varchar2) or
217: nvl(hr_oru_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute15, hr_api.g_varchar2) or
219: nvl(hr_oru_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute16, hr_api.g_varchar2) or
221: nvl(hr_oru_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute17, hr_api.g_varchar2) or
223: nvl(hr_oru_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute18, hr_api.g_varchar2) or
217: nvl(hr_oru_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute15, hr_api.g_varchar2) or
219: nvl(hr_oru_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute16, hr_api.g_varchar2) or
221: nvl(hr_oru_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute17, hr_api.g_varchar2) or
223: nvl(hr_oru_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute18, hr_api.g_varchar2) or
225: nvl(hr_oru_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute15, hr_api.g_varchar2) or
219: nvl(hr_oru_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute16, hr_api.g_varchar2) or
221: nvl(hr_oru_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute17, hr_api.g_varchar2) or
223: nvl(hr_oru_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute18, hr_api.g_varchar2) or
225: nvl(hr_oru_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute19, hr_api.g_varchar2) or
219: nvl(hr_oru_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute16, hr_api.g_varchar2) or
221: nvl(hr_oru_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute17, hr_api.g_varchar2) or
223: nvl(hr_oru_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute18, hr_api.g_varchar2) or
225: nvl(hr_oru_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute19, hr_api.g_varchar2) or
227: nvl(hr_oru_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute16, hr_api.g_varchar2) or
221: nvl(hr_oru_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute17, hr_api.g_varchar2) or
223: nvl(hr_oru_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute18, hr_api.g_varchar2) or
225: nvl(hr_oru_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute19, hr_api.g_varchar2) or
227: nvl(hr_oru_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute20, hr_api.g_varchar2) or
221: nvl(hr_oru_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute17, hr_api.g_varchar2) or
223: nvl(hr_oru_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute18, hr_api.g_varchar2) or
225: nvl(hr_oru_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute19, hr_api.g_varchar2) or
227: nvl(hr_oru_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute20, hr_api.g_varchar2) or
229: -- Enhancement 4040086
222: nvl(p_rec.attribute17, hr_api.g_varchar2) or
223: nvl(hr_oru_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute18, hr_api.g_varchar2) or
225: nvl(hr_oru_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute19, hr_api.g_varchar2) or
227: nvl(hr_oru_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute20, hr_api.g_varchar2) or
229: -- Enhancement 4040086
230: nvl(hr_oru_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
223: nvl(hr_oru_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute18, hr_api.g_varchar2) or
225: nvl(hr_oru_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute19, hr_api.g_varchar2) or
227: nvl(hr_oru_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute20, hr_api.g_varchar2) or
229: -- Enhancement 4040086
230: nvl(hr_oru_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute21, hr_api.g_varchar2) or
224: nvl(p_rec.attribute18, hr_api.g_varchar2) or
225: nvl(hr_oru_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute19, hr_api.g_varchar2) or
227: nvl(hr_oru_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute20, hr_api.g_varchar2) or
229: -- Enhancement 4040086
230: nvl(hr_oru_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute21, hr_api.g_varchar2) or
232: nvl(hr_oru_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute19, hr_api.g_varchar2) or
227: nvl(hr_oru_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute20, hr_api.g_varchar2) or
229: -- Enhancement 4040086
230: nvl(hr_oru_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute21, hr_api.g_varchar2) or
232: nvl(hr_oru_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute22, hr_api.g_varchar2) or
234: nvl(hr_oru_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
227: nvl(hr_oru_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute20, hr_api.g_varchar2) or
229: -- Enhancement 4040086
230: nvl(hr_oru_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute21, hr_api.g_varchar2) or
232: nvl(hr_oru_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute22, hr_api.g_varchar2) or
234: nvl(hr_oru_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute23, hr_api.g_varchar2) or
228: nvl(p_rec.attribute20, hr_api.g_varchar2) or
229: -- Enhancement 4040086
230: nvl(hr_oru_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute21, hr_api.g_varchar2) or
232: nvl(hr_oru_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute22, hr_api.g_varchar2) or
234: nvl(hr_oru_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute23, hr_api.g_varchar2) or
236: nvl(hr_oru_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
229: -- Enhancement 4040086
230: nvl(hr_oru_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute21, hr_api.g_varchar2) or
232: nvl(hr_oru_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute22, hr_api.g_varchar2) or
234: nvl(hr_oru_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute23, hr_api.g_varchar2) or
236: nvl(hr_oru_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
237: nvl(p_rec.attribute24, hr_api.g_varchar2) or
230: nvl(hr_oru_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute21, hr_api.g_varchar2) or
232: nvl(hr_oru_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute22, hr_api.g_varchar2) or
234: nvl(hr_oru_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute23, hr_api.g_varchar2) or
236: nvl(hr_oru_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
237: nvl(p_rec.attribute24, hr_api.g_varchar2) or
238: nvl(hr_oru_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute21, hr_api.g_varchar2) or
232: nvl(hr_oru_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute22, hr_api.g_varchar2) or
234: nvl(hr_oru_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute23, hr_api.g_varchar2) or
236: nvl(hr_oru_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
237: nvl(p_rec.attribute24, hr_api.g_varchar2) or
238: nvl(hr_oru_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
239: nvl(p_rec.attribute25, hr_api.g_varchar2) or
232: nvl(hr_oru_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute22, hr_api.g_varchar2) or
234: nvl(hr_oru_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute23, hr_api.g_varchar2) or
236: nvl(hr_oru_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
237: nvl(p_rec.attribute24, hr_api.g_varchar2) or
238: nvl(hr_oru_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
239: nvl(p_rec.attribute25, hr_api.g_varchar2) or
240: nvl(hr_oru_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute22, hr_api.g_varchar2) or
234: nvl(hr_oru_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute23, hr_api.g_varchar2) or
236: nvl(hr_oru_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
237: nvl(p_rec.attribute24, hr_api.g_varchar2) or
238: nvl(hr_oru_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
239: nvl(p_rec.attribute25, hr_api.g_varchar2) or
240: nvl(hr_oru_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
241: nvl(p_rec.attribute26, hr_api.g_varchar2) or
234: nvl(hr_oru_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute23, hr_api.g_varchar2) or
236: nvl(hr_oru_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
237: nvl(p_rec.attribute24, hr_api.g_varchar2) or
238: nvl(hr_oru_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
239: nvl(p_rec.attribute25, hr_api.g_varchar2) or
240: nvl(hr_oru_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
241: nvl(p_rec.attribute26, hr_api.g_varchar2) or
242: nvl(hr_oru_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute23, hr_api.g_varchar2) or
236: nvl(hr_oru_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
237: nvl(p_rec.attribute24, hr_api.g_varchar2) or
238: nvl(hr_oru_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
239: nvl(p_rec.attribute25, hr_api.g_varchar2) or
240: nvl(hr_oru_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
241: nvl(p_rec.attribute26, hr_api.g_varchar2) or
242: nvl(hr_oru_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
243: nvl(p_rec.attribute27, hr_api.g_varchar2) or
236: nvl(hr_oru_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
237: nvl(p_rec.attribute24, hr_api.g_varchar2) or
238: nvl(hr_oru_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
239: nvl(p_rec.attribute25, hr_api.g_varchar2) or
240: nvl(hr_oru_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
241: nvl(p_rec.attribute26, hr_api.g_varchar2) or
242: nvl(hr_oru_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
243: nvl(p_rec.attribute27, hr_api.g_varchar2) or
244: nvl(hr_oru_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
237: nvl(p_rec.attribute24, hr_api.g_varchar2) or
238: nvl(hr_oru_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
239: nvl(p_rec.attribute25, hr_api.g_varchar2) or
240: nvl(hr_oru_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
241: nvl(p_rec.attribute26, hr_api.g_varchar2) or
242: nvl(hr_oru_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
243: nvl(p_rec.attribute27, hr_api.g_varchar2) or
244: nvl(hr_oru_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
245: nvl(p_rec.attribute28, hr_api.g_varchar2) or
238: nvl(hr_oru_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
239: nvl(p_rec.attribute25, hr_api.g_varchar2) or
240: nvl(hr_oru_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
241: nvl(p_rec.attribute26, hr_api.g_varchar2) or
242: nvl(hr_oru_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
243: nvl(p_rec.attribute27, hr_api.g_varchar2) or
244: nvl(hr_oru_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
245: nvl(p_rec.attribute28, hr_api.g_varchar2) or
246: nvl(hr_oru_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
239: nvl(p_rec.attribute25, hr_api.g_varchar2) or
240: nvl(hr_oru_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
241: nvl(p_rec.attribute26, hr_api.g_varchar2) or
242: nvl(hr_oru_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
243: nvl(p_rec.attribute27, hr_api.g_varchar2) or
244: nvl(hr_oru_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
245: nvl(p_rec.attribute28, hr_api.g_varchar2) or
246: nvl(hr_oru_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
247: nvl(p_rec.attribute29, hr_api.g_varchar2) or
240: nvl(hr_oru_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
241: nvl(p_rec.attribute26, hr_api.g_varchar2) or
242: nvl(hr_oru_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
243: nvl(p_rec.attribute27, hr_api.g_varchar2) or
244: nvl(hr_oru_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
245: nvl(p_rec.attribute28, hr_api.g_varchar2) or
246: nvl(hr_oru_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
247: nvl(p_rec.attribute29, hr_api.g_varchar2) or
248: nvl(hr_oru_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
241: nvl(p_rec.attribute26, hr_api.g_varchar2) or
242: nvl(hr_oru_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
243: nvl(p_rec.attribute27, hr_api.g_varchar2) or
244: nvl(hr_oru_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
245: nvl(p_rec.attribute28, hr_api.g_varchar2) or
246: nvl(hr_oru_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
247: nvl(p_rec.attribute29, hr_api.g_varchar2) or
248: nvl(hr_oru_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
249: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
242: nvl(hr_oru_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
243: nvl(p_rec.attribute27, hr_api.g_varchar2) or
244: nvl(hr_oru_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
245: nvl(p_rec.attribute28, hr_api.g_varchar2) or
246: nvl(hr_oru_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
247: nvl(p_rec.attribute29, hr_api.g_varchar2) or
248: nvl(hr_oru_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
249: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
250: -- End Enhancement 4040086
243: nvl(p_rec.attribute27, hr_api.g_varchar2) or
244: nvl(hr_oru_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
245: nvl(p_rec.attribute28, hr_api.g_varchar2) or
246: nvl(hr_oru_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
247: nvl(p_rec.attribute29, hr_api.g_varchar2) or
248: nvl(hr_oru_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
249: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
250: -- End Enhancement 4040086
251: or (p_rec.organization_id is null) then
244: nvl(hr_oru_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
245: nvl(p_rec.attribute28, hr_api.g_varchar2) or
246: nvl(hr_oru_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
247: nvl(p_rec.attribute29, hr_api.g_varchar2) or
248: nvl(hr_oru_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
249: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
250: -- End Enhancement 4040086
251: or (p_rec.organization_id is null) then
252: --
245: nvl(p_rec.attribute28, hr_api.g_varchar2) or
246: nvl(hr_oru_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
247: nvl(p_rec.attribute29, hr_api.g_varchar2) or
248: nvl(hr_oru_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
249: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
250: -- End Enhancement 4040086
251: or (p_rec.organization_id is null) then
252: --
253: -- Only execute the validation if absolutely necessary:
383: -- EDIT_HERE: Add checks to ensure non-updateable args have
384: -- not been updated.
385: --
386: /* bug fix for 2999489
387: IF nvl(p_rec.name, hr_api.g_varchar2) <>
388: nvl(hr_oru_shd.g_old_rec.name, hr_api.g_varchar2) THEN
389: l_argument := 'NAME';
390: RAISE l_error;
391: END IF;
384: -- not been updated.
385: --
386: /* bug fix for 2999489
387: IF nvl(p_rec.name, hr_api.g_varchar2) <>
388: nvl(hr_oru_shd.g_old_rec.name, hr_api.g_varchar2) THEN
389: l_argument := 'NAME';
390: RAISE l_error;
391: END IF;
392: --
391: END IF;
392: --
393: EXCEPTION
394: WHEN l_error THEN
395: hr_api.argument_changed_error
396: (p_api_name => l_proc
397: ,p_argument => l_argument);
398: WHEN OTHERS THEN
399: RAISE;
454: --
455: --BEGIN
456: -- hr_utility.set_location('Entering:'|| l_proc, 10);
457: --
458: -- hr_api.mandatory_arg_error
459: -- (p_api_name => l_proc
460: -- ,p_argument => 'DATE_FROM'
461: -- ,p_argument_value => p_date_from
462: -- );
522: p_duplicate_org_warning := false;
523: l_is_business_group := false;
524: l_duplicate_bg := false;
525: --
526: hr_api.mandatory_arg_error
527: (p_api_name => l_proc
528: ,p_argument => 'NAME'
529: ,p_argument_value => p_name
530: );
712: -- operation or the value has actually changed during an UPDATE operation
713: --
714: IF p_organization_id IS NULL OR
715: p_cost_allocation_keyflex_id <>
716: NVL(hr_oru_shd.g_old_rec.cost_allocation_keyflex_id, hr_api.g_number) THEN
717: --
718: OPEN csr_cost_allocation_keyflex_id;
719: FETCH csr_cost_allocation_keyflex_id INTO l_exists;
720: --
1084: hr_utility.set_location('Entering:'||l_proc, 5);
1085: --
1086: -- Call all supporting business operations
1087: --
1088: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1089: --
1090: --
1091: hr_utility.set_location('Entering:'||l_proc, 10);
1092: --
1172: hr_utility.set_location('Entering:'||l_proc, 5);
1173: --
1174: -- Call all supporting business operations
1175: --
1176: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1177: --
1178: chk_non_updateable_args
1179: (p_effective_date => p_effective_date
1180: ,p_rec => p_rec