[Home] [Help]
44: hr_utility.set_location('Entering:'|| l_proc, 10);
45: --
46: -- Ensure that all the mandatory parameter are not null
47: --
48: hr_api.mandatory_arg_error
49: (p_api_name => l_proc
50: ,p_argument => 'offer_id'
51: ,p_argument_value => p_offer_id
52: );
68: close csr_sec_grp;
69: --
70: -- Set the security_group_id in CLIENT_INFO
71: --
72: hr_api.set_security_group_id
73: (p_security_group_id => l_security_group_id
74: );
75: --
76: end if;
108: hr_utility.set_location('Entering:'|| l_proc, 10);
109: --
110: -- Ensure that all the mandatory parameter are not null
111: --
112: hr_api.mandatory_arg_error
113: (p_api_name => l_proc
114: ,p_argument => 'offer_id'
115: ,p_argument_value => p_offer_id
116: );
114: ,p_argument => 'offer_id'
115: ,p_argument_value => p_offer_id
116: );
117: --
118: if ( nvl(irc_iof_bus.g_offer_id, hr_api.g_number)
119: = p_offer_id) then
120: --
121: -- The legislation code has already been found with a previous
122: -- call to this function. Just return the value in the global
190: begin
191: hr_utility.set_location('Entering:'||l_proc,10);
192: --
193: if ((p_rec.offer_id is not null) and (
194: nvl(irc_iof_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
195: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
196: nvl(irc_iof_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
197: nvl(p_rec.attribute1, hr_api.g_varchar2) or
198: nvl(irc_iof_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
191: hr_utility.set_location('Entering:'||l_proc,10);
192: --
193: if ((p_rec.offer_id is not null) and (
194: nvl(irc_iof_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
195: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
196: nvl(irc_iof_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
197: nvl(p_rec.attribute1, hr_api.g_varchar2) or
198: nvl(irc_iof_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute2, hr_api.g_varchar2) or
192: --
193: if ((p_rec.offer_id is not null) and (
194: nvl(irc_iof_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
195: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
196: nvl(irc_iof_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
197: nvl(p_rec.attribute1, hr_api.g_varchar2) or
198: nvl(irc_iof_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute2, hr_api.g_varchar2) or
200: nvl(irc_iof_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
193: if ((p_rec.offer_id is not null) and (
194: nvl(irc_iof_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
195: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
196: nvl(irc_iof_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
197: nvl(p_rec.attribute1, hr_api.g_varchar2) or
198: nvl(irc_iof_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute2, hr_api.g_varchar2) or
200: nvl(irc_iof_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute3, hr_api.g_varchar2) or
194: nvl(irc_iof_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
195: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
196: nvl(irc_iof_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
197: nvl(p_rec.attribute1, hr_api.g_varchar2) or
198: nvl(irc_iof_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute2, hr_api.g_varchar2) or
200: nvl(irc_iof_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute3, hr_api.g_varchar2) or
202: nvl(irc_iof_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
195: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
196: nvl(irc_iof_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
197: nvl(p_rec.attribute1, hr_api.g_varchar2) or
198: nvl(irc_iof_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute2, hr_api.g_varchar2) or
200: nvl(irc_iof_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute3, hr_api.g_varchar2) or
202: nvl(irc_iof_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute4, hr_api.g_varchar2) or
196: nvl(irc_iof_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
197: nvl(p_rec.attribute1, hr_api.g_varchar2) or
198: nvl(irc_iof_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute2, hr_api.g_varchar2) or
200: nvl(irc_iof_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute3, hr_api.g_varchar2) or
202: nvl(irc_iof_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute4, hr_api.g_varchar2) or
204: nvl(irc_iof_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
197: nvl(p_rec.attribute1, hr_api.g_varchar2) or
198: nvl(irc_iof_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute2, hr_api.g_varchar2) or
200: nvl(irc_iof_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute3, hr_api.g_varchar2) or
202: nvl(irc_iof_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute4, hr_api.g_varchar2) or
204: nvl(irc_iof_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute5, hr_api.g_varchar2) or
198: nvl(irc_iof_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute2, hr_api.g_varchar2) or
200: nvl(irc_iof_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute3, hr_api.g_varchar2) or
202: nvl(irc_iof_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute4, hr_api.g_varchar2) or
204: nvl(irc_iof_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute5, hr_api.g_varchar2) or
206: nvl(irc_iof_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute2, hr_api.g_varchar2) or
200: nvl(irc_iof_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute3, hr_api.g_varchar2) or
202: nvl(irc_iof_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute4, hr_api.g_varchar2) or
204: nvl(irc_iof_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute5, hr_api.g_varchar2) or
206: nvl(irc_iof_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute6, hr_api.g_varchar2) or
200: nvl(irc_iof_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute3, hr_api.g_varchar2) or
202: nvl(irc_iof_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute4, hr_api.g_varchar2) or
204: nvl(irc_iof_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute5, hr_api.g_varchar2) or
206: nvl(irc_iof_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute6, hr_api.g_varchar2) or
208: nvl(irc_iof_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute3, hr_api.g_varchar2) or
202: nvl(irc_iof_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute4, hr_api.g_varchar2) or
204: nvl(irc_iof_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute5, hr_api.g_varchar2) or
206: nvl(irc_iof_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute6, hr_api.g_varchar2) or
208: nvl(irc_iof_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute7, hr_api.g_varchar2) or
202: nvl(irc_iof_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute4, hr_api.g_varchar2) or
204: nvl(irc_iof_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute5, hr_api.g_varchar2) or
206: nvl(irc_iof_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute6, hr_api.g_varchar2) or
208: nvl(irc_iof_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute7, hr_api.g_varchar2) or
210: nvl(irc_iof_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute4, hr_api.g_varchar2) or
204: nvl(irc_iof_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute5, hr_api.g_varchar2) or
206: nvl(irc_iof_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute6, hr_api.g_varchar2) or
208: nvl(irc_iof_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute7, hr_api.g_varchar2) or
210: nvl(irc_iof_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute8, hr_api.g_varchar2) or
204: nvl(irc_iof_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute5, hr_api.g_varchar2) or
206: nvl(irc_iof_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute6, hr_api.g_varchar2) or
208: nvl(irc_iof_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute7, hr_api.g_varchar2) or
210: nvl(irc_iof_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute8, hr_api.g_varchar2) or
212: nvl(irc_iof_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute5, hr_api.g_varchar2) or
206: nvl(irc_iof_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute6, hr_api.g_varchar2) or
208: nvl(irc_iof_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute7, hr_api.g_varchar2) or
210: nvl(irc_iof_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute8, hr_api.g_varchar2) or
212: nvl(irc_iof_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute9, hr_api.g_varchar2) or
206: nvl(irc_iof_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute6, hr_api.g_varchar2) or
208: nvl(irc_iof_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute7, hr_api.g_varchar2) or
210: nvl(irc_iof_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute8, hr_api.g_varchar2) or
212: nvl(irc_iof_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute9, hr_api.g_varchar2) or
214: nvl(irc_iof_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute6, hr_api.g_varchar2) or
208: nvl(irc_iof_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute7, hr_api.g_varchar2) or
210: nvl(irc_iof_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute8, hr_api.g_varchar2) or
212: nvl(irc_iof_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute9, hr_api.g_varchar2) or
214: nvl(irc_iof_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute10, hr_api.g_varchar2) or
208: nvl(irc_iof_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute7, hr_api.g_varchar2) or
210: nvl(irc_iof_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute8, hr_api.g_varchar2) or
212: nvl(irc_iof_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute9, hr_api.g_varchar2) or
214: nvl(irc_iof_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute10, hr_api.g_varchar2) or
216: nvl(irc_iof_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute7, hr_api.g_varchar2) or
210: nvl(irc_iof_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute8, hr_api.g_varchar2) or
212: nvl(irc_iof_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute9, hr_api.g_varchar2) or
214: nvl(irc_iof_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute10, hr_api.g_varchar2) or
216: nvl(irc_iof_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute11, hr_api.g_varchar2) or
210: nvl(irc_iof_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute8, hr_api.g_varchar2) or
212: nvl(irc_iof_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute9, hr_api.g_varchar2) or
214: nvl(irc_iof_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute10, hr_api.g_varchar2) or
216: nvl(irc_iof_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute11, hr_api.g_varchar2) or
218: nvl(irc_iof_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute8, hr_api.g_varchar2) or
212: nvl(irc_iof_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute9, hr_api.g_varchar2) or
214: nvl(irc_iof_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute10, hr_api.g_varchar2) or
216: nvl(irc_iof_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute11, hr_api.g_varchar2) or
218: nvl(irc_iof_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute12, hr_api.g_varchar2) or
212: nvl(irc_iof_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute9, hr_api.g_varchar2) or
214: nvl(irc_iof_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute10, hr_api.g_varchar2) or
216: nvl(irc_iof_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute11, hr_api.g_varchar2) or
218: nvl(irc_iof_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute12, hr_api.g_varchar2) or
220: nvl(irc_iof_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute9, hr_api.g_varchar2) or
214: nvl(irc_iof_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute10, hr_api.g_varchar2) or
216: nvl(irc_iof_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute11, hr_api.g_varchar2) or
218: nvl(irc_iof_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute12, hr_api.g_varchar2) or
220: nvl(irc_iof_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute13, hr_api.g_varchar2) or
214: nvl(irc_iof_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute10, hr_api.g_varchar2) or
216: nvl(irc_iof_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute11, hr_api.g_varchar2) or
218: nvl(irc_iof_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute12, hr_api.g_varchar2) or
220: nvl(irc_iof_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute13, hr_api.g_varchar2) or
222: nvl(irc_iof_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute10, hr_api.g_varchar2) or
216: nvl(irc_iof_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute11, hr_api.g_varchar2) or
218: nvl(irc_iof_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute12, hr_api.g_varchar2) or
220: nvl(irc_iof_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute13, hr_api.g_varchar2) or
222: nvl(irc_iof_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute14, hr_api.g_varchar2) or
216: nvl(irc_iof_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute11, hr_api.g_varchar2) or
218: nvl(irc_iof_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute12, hr_api.g_varchar2) or
220: nvl(irc_iof_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute13, hr_api.g_varchar2) or
222: nvl(irc_iof_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute14, hr_api.g_varchar2) or
224: nvl(irc_iof_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute11, hr_api.g_varchar2) or
218: nvl(irc_iof_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute12, hr_api.g_varchar2) or
220: nvl(irc_iof_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute13, hr_api.g_varchar2) or
222: nvl(irc_iof_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute14, hr_api.g_varchar2) or
224: nvl(irc_iof_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute15, hr_api.g_varchar2) or
218: nvl(irc_iof_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute12, hr_api.g_varchar2) or
220: nvl(irc_iof_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute13, hr_api.g_varchar2) or
222: nvl(irc_iof_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute14, hr_api.g_varchar2) or
224: nvl(irc_iof_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute15, hr_api.g_varchar2) or
226: nvl(irc_iof_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute12, hr_api.g_varchar2) or
220: nvl(irc_iof_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute13, hr_api.g_varchar2) or
222: nvl(irc_iof_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute14, hr_api.g_varchar2) or
224: nvl(irc_iof_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute15, hr_api.g_varchar2) or
226: nvl(irc_iof_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute16, hr_api.g_varchar2) or
220: nvl(irc_iof_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute13, hr_api.g_varchar2) or
222: nvl(irc_iof_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute14, hr_api.g_varchar2) or
224: nvl(irc_iof_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute15, hr_api.g_varchar2) or
226: nvl(irc_iof_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute16, hr_api.g_varchar2) or
228: nvl(irc_iof_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute13, hr_api.g_varchar2) or
222: nvl(irc_iof_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute14, hr_api.g_varchar2) or
224: nvl(irc_iof_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute15, hr_api.g_varchar2) or
226: nvl(irc_iof_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute16, hr_api.g_varchar2) or
228: nvl(irc_iof_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
229: nvl(p_rec.attribute17, hr_api.g_varchar2) or
222: nvl(irc_iof_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute14, hr_api.g_varchar2) or
224: nvl(irc_iof_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute15, hr_api.g_varchar2) or
226: nvl(irc_iof_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute16, hr_api.g_varchar2) or
228: nvl(irc_iof_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
229: nvl(p_rec.attribute17, hr_api.g_varchar2) or
230: nvl(irc_iof_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute14, hr_api.g_varchar2) or
224: nvl(irc_iof_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute15, hr_api.g_varchar2) or
226: nvl(irc_iof_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute16, hr_api.g_varchar2) or
228: nvl(irc_iof_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
229: nvl(p_rec.attribute17, hr_api.g_varchar2) or
230: nvl(irc_iof_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute18, hr_api.g_varchar2) or
224: nvl(irc_iof_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute15, hr_api.g_varchar2) or
226: nvl(irc_iof_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute16, hr_api.g_varchar2) or
228: nvl(irc_iof_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
229: nvl(p_rec.attribute17, hr_api.g_varchar2) or
230: nvl(irc_iof_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute18, hr_api.g_varchar2) or
232: nvl(irc_iof_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute15, hr_api.g_varchar2) or
226: nvl(irc_iof_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute16, hr_api.g_varchar2) or
228: nvl(irc_iof_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
229: nvl(p_rec.attribute17, hr_api.g_varchar2) or
230: nvl(irc_iof_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute18, hr_api.g_varchar2) or
232: nvl(irc_iof_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute19, hr_api.g_varchar2) or
226: nvl(irc_iof_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute16, hr_api.g_varchar2) or
228: nvl(irc_iof_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
229: nvl(p_rec.attribute17, hr_api.g_varchar2) or
230: nvl(irc_iof_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute18, hr_api.g_varchar2) or
232: nvl(irc_iof_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute19, hr_api.g_varchar2) or
234: nvl(irc_iof_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute16, hr_api.g_varchar2) or
228: nvl(irc_iof_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
229: nvl(p_rec.attribute17, hr_api.g_varchar2) or
230: nvl(irc_iof_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute18, hr_api.g_varchar2) or
232: nvl(irc_iof_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute19, hr_api.g_varchar2) or
234: nvl(irc_iof_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute20, hr_api.g_varchar2) or
228: nvl(irc_iof_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
229: nvl(p_rec.attribute17, hr_api.g_varchar2) or
230: nvl(irc_iof_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute18, hr_api.g_varchar2) or
232: nvl(irc_iof_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute19, hr_api.g_varchar2) or
234: nvl(irc_iof_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute20, hr_api.g_varchar2) or
236: nvl(irc_iof_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
229: nvl(p_rec.attribute17, hr_api.g_varchar2) or
230: nvl(irc_iof_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute18, hr_api.g_varchar2) or
232: nvl(irc_iof_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute19, hr_api.g_varchar2) or
234: nvl(irc_iof_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute20, hr_api.g_varchar2) or
236: nvl(irc_iof_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
237: nvl(p_rec.attribute21, hr_api.g_varchar2) or
230: nvl(irc_iof_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute18, hr_api.g_varchar2) or
232: nvl(irc_iof_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute19, hr_api.g_varchar2) or
234: nvl(irc_iof_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute20, hr_api.g_varchar2) or
236: nvl(irc_iof_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
237: nvl(p_rec.attribute21, hr_api.g_varchar2) or
238: nvl(irc_iof_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute18, hr_api.g_varchar2) or
232: nvl(irc_iof_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute19, hr_api.g_varchar2) or
234: nvl(irc_iof_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute20, hr_api.g_varchar2) or
236: nvl(irc_iof_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
237: nvl(p_rec.attribute21, hr_api.g_varchar2) or
238: nvl(irc_iof_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
239: nvl(p_rec.attribute22, hr_api.g_varchar2) or
232: nvl(irc_iof_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute19, hr_api.g_varchar2) or
234: nvl(irc_iof_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute20, hr_api.g_varchar2) or
236: nvl(irc_iof_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
237: nvl(p_rec.attribute21, hr_api.g_varchar2) or
238: nvl(irc_iof_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
239: nvl(p_rec.attribute22, hr_api.g_varchar2) or
240: nvl(irc_iof_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute19, hr_api.g_varchar2) or
234: nvl(irc_iof_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute20, hr_api.g_varchar2) or
236: nvl(irc_iof_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
237: nvl(p_rec.attribute21, hr_api.g_varchar2) or
238: nvl(irc_iof_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
239: nvl(p_rec.attribute22, hr_api.g_varchar2) or
240: nvl(irc_iof_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
241: nvl(p_rec.attribute23, hr_api.g_varchar2) or
234: nvl(irc_iof_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute20, hr_api.g_varchar2) or
236: nvl(irc_iof_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
237: nvl(p_rec.attribute21, hr_api.g_varchar2) or
238: nvl(irc_iof_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
239: nvl(p_rec.attribute22, hr_api.g_varchar2) or
240: nvl(irc_iof_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
241: nvl(p_rec.attribute23, hr_api.g_varchar2) or
242: nvl(irc_iof_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute20, hr_api.g_varchar2) or
236: nvl(irc_iof_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
237: nvl(p_rec.attribute21, hr_api.g_varchar2) or
238: nvl(irc_iof_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
239: nvl(p_rec.attribute22, hr_api.g_varchar2) or
240: nvl(irc_iof_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
241: nvl(p_rec.attribute23, hr_api.g_varchar2) or
242: nvl(irc_iof_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
243: nvl(p_rec.attribute24, hr_api.g_varchar2) or
236: nvl(irc_iof_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
237: nvl(p_rec.attribute21, hr_api.g_varchar2) or
238: nvl(irc_iof_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
239: nvl(p_rec.attribute22, hr_api.g_varchar2) or
240: nvl(irc_iof_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
241: nvl(p_rec.attribute23, hr_api.g_varchar2) or
242: nvl(irc_iof_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
243: nvl(p_rec.attribute24, hr_api.g_varchar2) or
244: nvl(irc_iof_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
237: nvl(p_rec.attribute21, hr_api.g_varchar2) or
238: nvl(irc_iof_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
239: nvl(p_rec.attribute22, hr_api.g_varchar2) or
240: nvl(irc_iof_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
241: nvl(p_rec.attribute23, hr_api.g_varchar2) or
242: nvl(irc_iof_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
243: nvl(p_rec.attribute24, hr_api.g_varchar2) or
244: nvl(irc_iof_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
245: nvl(p_rec.attribute25, hr_api.g_varchar2) or
238: nvl(irc_iof_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
239: nvl(p_rec.attribute22, hr_api.g_varchar2) or
240: nvl(irc_iof_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
241: nvl(p_rec.attribute23, hr_api.g_varchar2) or
242: nvl(irc_iof_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
243: nvl(p_rec.attribute24, hr_api.g_varchar2) or
244: nvl(irc_iof_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
245: nvl(p_rec.attribute25, hr_api.g_varchar2) or
246: nvl(irc_iof_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
239: nvl(p_rec.attribute22, hr_api.g_varchar2) or
240: nvl(irc_iof_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
241: nvl(p_rec.attribute23, hr_api.g_varchar2) or
242: nvl(irc_iof_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
243: nvl(p_rec.attribute24, hr_api.g_varchar2) or
244: nvl(irc_iof_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
245: nvl(p_rec.attribute25, hr_api.g_varchar2) or
246: nvl(irc_iof_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
247: nvl(p_rec.attribute26, hr_api.g_varchar2) or
240: nvl(irc_iof_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
241: nvl(p_rec.attribute23, hr_api.g_varchar2) or
242: nvl(irc_iof_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
243: nvl(p_rec.attribute24, hr_api.g_varchar2) or
244: nvl(irc_iof_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
245: nvl(p_rec.attribute25, hr_api.g_varchar2) or
246: nvl(irc_iof_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
247: nvl(p_rec.attribute26, hr_api.g_varchar2) or
248: nvl(irc_iof_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
241: nvl(p_rec.attribute23, hr_api.g_varchar2) or
242: nvl(irc_iof_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
243: nvl(p_rec.attribute24, hr_api.g_varchar2) or
244: nvl(irc_iof_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
245: nvl(p_rec.attribute25, hr_api.g_varchar2) or
246: nvl(irc_iof_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
247: nvl(p_rec.attribute26, hr_api.g_varchar2) or
248: nvl(irc_iof_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
249: nvl(p_rec.attribute27, hr_api.g_varchar2) or
242: nvl(irc_iof_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
243: nvl(p_rec.attribute24, hr_api.g_varchar2) or
244: nvl(irc_iof_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
245: nvl(p_rec.attribute25, hr_api.g_varchar2) or
246: nvl(irc_iof_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
247: nvl(p_rec.attribute26, hr_api.g_varchar2) or
248: nvl(irc_iof_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
249: nvl(p_rec.attribute27, hr_api.g_varchar2) or
250: nvl(irc_iof_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
243: nvl(p_rec.attribute24, hr_api.g_varchar2) or
244: nvl(irc_iof_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
245: nvl(p_rec.attribute25, hr_api.g_varchar2) or
246: nvl(irc_iof_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
247: nvl(p_rec.attribute26, hr_api.g_varchar2) or
248: nvl(irc_iof_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
249: nvl(p_rec.attribute27, hr_api.g_varchar2) or
250: nvl(irc_iof_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
251: nvl(p_rec.attribute28, hr_api.g_varchar2) or
244: nvl(irc_iof_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
245: nvl(p_rec.attribute25, hr_api.g_varchar2) or
246: nvl(irc_iof_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
247: nvl(p_rec.attribute26, hr_api.g_varchar2) or
248: nvl(irc_iof_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
249: nvl(p_rec.attribute27, hr_api.g_varchar2) or
250: nvl(irc_iof_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
251: nvl(p_rec.attribute28, hr_api.g_varchar2) or
252: nvl(irc_iof_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
245: nvl(p_rec.attribute25, hr_api.g_varchar2) or
246: nvl(irc_iof_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
247: nvl(p_rec.attribute26, hr_api.g_varchar2) or
248: nvl(irc_iof_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
249: nvl(p_rec.attribute27, hr_api.g_varchar2) or
250: nvl(irc_iof_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
251: nvl(p_rec.attribute28, hr_api.g_varchar2) or
252: nvl(irc_iof_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
253: nvl(p_rec.attribute29, hr_api.g_varchar2) or
246: nvl(irc_iof_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
247: nvl(p_rec.attribute26, hr_api.g_varchar2) or
248: nvl(irc_iof_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
249: nvl(p_rec.attribute27, hr_api.g_varchar2) or
250: nvl(irc_iof_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
251: nvl(p_rec.attribute28, hr_api.g_varchar2) or
252: nvl(irc_iof_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
253: nvl(p_rec.attribute29, hr_api.g_varchar2) or
254: nvl(irc_iof_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
247: nvl(p_rec.attribute26, hr_api.g_varchar2) or
248: nvl(irc_iof_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
249: nvl(p_rec.attribute27, hr_api.g_varchar2) or
250: nvl(irc_iof_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
251: nvl(p_rec.attribute28, hr_api.g_varchar2) or
252: nvl(irc_iof_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
253: nvl(p_rec.attribute29, hr_api.g_varchar2) or
254: nvl(irc_iof_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
255: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
248: nvl(irc_iof_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
249: nvl(p_rec.attribute27, hr_api.g_varchar2) or
250: nvl(irc_iof_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
251: nvl(p_rec.attribute28, hr_api.g_varchar2) or
252: nvl(irc_iof_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
253: nvl(p_rec.attribute29, hr_api.g_varchar2) or
254: nvl(irc_iof_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
255: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
256: or (p_rec.offer_id is null) then
249: nvl(p_rec.attribute27, hr_api.g_varchar2) or
250: nvl(irc_iof_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
251: nvl(p_rec.attribute28, hr_api.g_varchar2) or
252: nvl(irc_iof_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
253: nvl(p_rec.attribute29, hr_api.g_varchar2) or
254: nvl(irc_iof_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
255: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
256: or (p_rec.offer_id is null) then
257: --
250: nvl(irc_iof_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
251: nvl(p_rec.attribute28, hr_api.g_varchar2) or
252: nvl(irc_iof_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
253: nvl(p_rec.attribute29, hr_api.g_varchar2) or
254: nvl(irc_iof_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
255: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
256: or (p_rec.offer_id is null) then
257: --
258: -- Only execute the validation if absolutely necessary:
251: nvl(p_rec.attribute28, hr_api.g_varchar2) or
252: nvl(irc_iof_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
253: nvl(p_rec.attribute29, hr_api.g_varchar2) or
254: nvl(irc_iof_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
255: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
256: or (p_rec.offer_id is null) then
257: --
258: -- Only execute the validation if absolutely necessary:
259: -- a) During update, the structure column value or any
381: END IF;
382: --
383: if irc_iof_shd.g_old_rec.offer_id <> p_rec.offer_id
384: then
385: hr_api.argument_changed_error
386: (p_api_name => l_proc
387: ,p_argument => 'offer_id'
388: ,p_base_table => irc_iof_shd.g_tab_name
389: );
390: end if;
391: --
392: if irc_iof_shd.g_old_rec.applicant_assignment_id <> p_rec.applicant_assignment_id
393: then
394: hr_api.argument_changed_error
395: (p_api_name => l_proc
396: ,p_argument => 'applicant_assignment_id'
397: ,p_base_table => irc_iof_shd.g_tab_name
398: );
399: end if;
400: --
401: if irc_iof_shd.g_old_rec.offer_assignment_id <> p_rec.offer_assignment_id
402: then
403: hr_api.argument_changed_error
404: (p_api_name => l_proc
405: ,p_argument => 'offer_assignment_id'
406: ,p_base_table => irc_iof_shd.g_tab_name
407: );
408: end if;
409: --
410: if irc_iof_shd.g_old_rec.vacancy_id <> p_rec.vacancy_id
411: then
412: hr_api.argument_changed_error
413: (p_api_name => l_proc
414: ,p_argument => 'vacancy_id'
415: ,p_base_table => irc_iof_shd.g_tab_name
416: );
417: end if;
418: --
419: if irc_iof_shd.g_old_rec.offer_version <> p_rec.offer_version
420: then
421: hr_api.argument_changed_error
422: (p_api_name => l_proc
423: ,p_argument => 'offer_version'
424: ,p_base_table => irc_iof_shd.g_tab_name
425: );
471: --
472: Begin
473: hr_utility.set_location('Entering:'||l_proc,10);
474: --
475: hr_api.mandatory_arg_error
476: (p_api_name => l_proc
477: ,p_argument => 'effective_date'
478: ,p_argument_value => p_effective_date
479: );
477: ,p_argument => 'effective_date'
478: ,p_argument_value => p_effective_date
479: );
480:
481: hr_api.mandatory_arg_error
482: (p_api_name => l_proc
483: ,p_argument => 'APPLICANT_ASSIGNMENT_ID'
484: ,p_argument_value => p_applicant_assignment_id
485: );
556: if hr_multi_message.no_exclusive_error(
557: p_check_column1 => 'IRC_OFFERS.APPLICANT_ASSIGNMENT_ID'
558: ) then
559: --
560: hr_api.mandatory_arg_error
561: (p_api_name => l_proc
562: ,p_argument => 'OFFER_ASSIGNMENT_ID'
563: ,p_argument_value => p_offer_assignment_id
564: );
830: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
831: )
832: then
833: --
834: hr_api.mandatory_arg_error
835: (p_api_name => l_proc
836: ,p_argument => 'VACANCY_ID'
837: ,p_argument_value => p_vacancy_id
838: );
931: --
932: hr_utility.set_location(l_proc,20);
933:
934: if ((l_api_updating
935: and nvl(irc_iof_shd.g_old_rec.respondent_id, hr_api.g_number) <>
936: nvl(p_respondent_id, hr_api.g_number))
937: or
938: (NOT l_api_updating)) then
939: --
932: hr_utility.set_location(l_proc,20);
933:
934: if ((l_api_updating
935: and nvl(irc_iof_shd.g_old_rec.respondent_id, hr_api.g_number) <>
936: nvl(p_respondent_id, hr_api.g_number))
937: or
938: (NOT l_api_updating)) then
939: --
940: -- Check if respondent id is not null.
1049: else -- p_expiry_date is null or is the previous expiry date
1050: --
1051: -- Check if the intend of this update is to indeed update the expiry date.
1052: --
1053: if( nvl(p_offer_postal_service,hr_api.g_varchar2) = nvl(l_prev_offer_postal_service,hr_api.g_varchar2) -- Postal Service has not changed
1054: and nvl(p_offer_letter_tracking_code,hr_api.g_varchar2) = nvl(l_prev_letter_tracking_code,hr_api.g_varchar2) -- Tracking Code has not changed
1055: and nvl(p_offer_shipping_date,hr_api.g_date) = nvl(l_prev_offer_shipping_date,hr_api.g_date) -- Shipping Date has not changed
1056: )
1057: then
1050: --
1051: -- Check if the intend of this update is to indeed update the expiry date.
1052: --
1053: if( nvl(p_offer_postal_service,hr_api.g_varchar2) = nvl(l_prev_offer_postal_service,hr_api.g_varchar2) -- Postal Service has not changed
1054: and nvl(p_offer_letter_tracking_code,hr_api.g_varchar2) = nvl(l_prev_letter_tracking_code,hr_api.g_varchar2) -- Tracking Code has not changed
1055: and nvl(p_offer_shipping_date,hr_api.g_date) = nvl(l_prev_offer_shipping_date,hr_api.g_date) -- Shipping Date has not changed
1056: )
1057: then
1058: --
1051: -- Check if the intend of this update is to indeed update the expiry date.
1052: --
1053: if( nvl(p_offer_postal_service,hr_api.g_varchar2) = nvl(l_prev_offer_postal_service,hr_api.g_varchar2) -- Postal Service has not changed
1054: and nvl(p_offer_letter_tracking_code,hr_api.g_varchar2) = nvl(l_prev_letter_tracking_code,hr_api.g_varchar2) -- Tracking Code has not changed
1055: and nvl(p_offer_shipping_date,hr_api.g_date) = nvl(l_prev_offer_shipping_date,hr_api.g_date) -- Shipping Date has not changed
1056: )
1057: then
1058: --
1059: -- No value has been entered for the expiry date.
1288: --
1289: hr_utility.set_location(l_proc,20);
1290:
1291: if ((l_api_updating
1292: and nvl(irc_iof_shd.g_old_rec.address_id, hr_api.g_number) <>
1293: nvl(p_address_id, hr_api.g_number))
1294: or
1295: (NOT l_api_updating)) then
1296: --
1289: hr_utility.set_location(l_proc,20);
1290:
1291: if ((l_api_updating
1292: and nvl(irc_iof_shd.g_old_rec.address_id, hr_api.g_number) <>
1293: nvl(p_address_id, hr_api.g_number))
1294: or
1295: (NOT l_api_updating)) then
1296: --
1297: -- Check if address id is not null.
1422: --
1423: hr_utility.set_location(l_proc,20);
1424:
1425: if ((l_api_updating
1426: and nvl(irc_iof_shd.g_old_rec.template_id, hr_api.g_number) <>
1427: nvl(p_template_id, hr_api.g_number)) or
1428: (NOT l_api_updating)) then
1429: --
1430: -- Check if template id is not null and if it is active
1423: hr_utility.set_location(l_proc,20);
1424:
1425: if ((l_api_updating
1426: and nvl(irc_iof_shd.g_old_rec.template_id, hr_api.g_number) <>
1427: nvl(p_template_id, hr_api.g_number)) or
1428: (NOT l_api_updating)) then
1429: --
1430: -- Check if template id is not null and if it is active
1431: --
1537: --
1538: Begin
1539: hr_utility.set_location('Entering:'||l_proc,10);
1540: --
1541: hr_api.mandatory_arg_error
1542: (p_api_name => l_proc
1543: ,p_argument => 'APPLICANT_ASSIGNMENT_ID'
1544: ,p_argument_value => p_applicant_assignment_id
1545: );
1588: -- other latest offers for this applicant assignment.
1589: --
1590: -- 3) The value entered should be validated against HR_LOOKUPS.LOOKUP_CODE
1591: -- where the LOOKUP_TYPE is 'YES_NO'. (I, U)
1592: -- Process: hr_api.not_exists_in_hr_lookups
1593: --
1594: -- Pre Conditions:
1595: -- None
1596: --
1682: --
1683: end if;
1684: --
1685: elsif (l_api_updating
1686: and nvl(irc_iof_shd.g_old_rec.latest_offer, hr_api.g_varchar2) <>
1687: nvl(p_latest_offer, hr_api.g_varchar2))
1688: then
1689: if ( p_offer_status <> 'SAVED')
1690: then
1683: end if;
1684: --
1685: elsif (l_api_updating
1686: and nvl(irc_iof_shd.g_old_rec.latest_offer, hr_api.g_varchar2) <>
1687: nvl(p_latest_offer, hr_api.g_varchar2))
1688: then
1689: if ( p_offer_status <> 'SAVED')
1690: then
1691: --
1705: --
1706: end if;
1707: --
1708: if ((l_api_updating
1709: and nvl(irc_iof_shd.g_old_rec.latest_offer, hr_api.g_varchar2) <>
1710: nvl(p_latest_offer, hr_api.g_varchar2))
1711: or (NOT l_api_updating)) then
1712: --
1713: hr_utility.set_location(l_proc,40);
1706: end if;
1707: --
1708: if ((l_api_updating
1709: and nvl(irc_iof_shd.g_old_rec.latest_offer, hr_api.g_varchar2) <>
1710: nvl(p_latest_offer, hr_api.g_varchar2))
1711: or (NOT l_api_updating)) then
1712: --
1713: hr_utility.set_location(l_proc,40);
1714: --
1714: --
1715: -- Checks that the value for latest_offer is
1716: -- valid and exists on YES_NO lookup
1717: --
1718: if hr_api.not_exists_in_hr_lookups
1719: (p_effective_date => p_effective_date
1720: ,p_lookup_type => 'YES_NO'
1721: ,p_lookup_code => p_latest_offer
1722: ) then
1806: (p_offer_id => p_offer_id
1807: ,p_object_version_number => p_object_version_number);
1808: --
1809: if ((l_api_updating and
1810: ((nvl(irc_iof_shd.g_old_rec.offer_version, hr_api.g_number) <>
1811: nvl(p_offer_version, hr_api.g_number))
1812: or
1813: (nvl(irc_iof_shd.g_old_rec.applicant_assignment_id, hr_api.g_number) <>
1814: nvl(p_applicant_assignment_id, hr_api.g_number))
1807: ,p_object_version_number => p_object_version_number);
1808: --
1809: if ((l_api_updating and
1810: ((nvl(irc_iof_shd.g_old_rec.offer_version, hr_api.g_number) <>
1811: nvl(p_offer_version, hr_api.g_number))
1812: or
1813: (nvl(irc_iof_shd.g_old_rec.applicant_assignment_id, hr_api.g_number) <>
1814: nvl(p_applicant_assignment_id, hr_api.g_number))
1815: ))
1809: if ((l_api_updating and
1810: ((nvl(irc_iof_shd.g_old_rec.offer_version, hr_api.g_number) <>
1811: nvl(p_offer_version, hr_api.g_number))
1812: or
1813: (nvl(irc_iof_shd.g_old_rec.applicant_assignment_id, hr_api.g_number) <>
1814: nvl(p_applicant_assignment_id, hr_api.g_number))
1815: ))
1816: or
1817: (NOT l_api_updating)) then
1810: ((nvl(irc_iof_shd.g_old_rec.offer_version, hr_api.g_number) <>
1811: nvl(p_offer_version, hr_api.g_number))
1812: or
1813: (nvl(irc_iof_shd.g_old_rec.applicant_assignment_id, hr_api.g_number) <>
1814: nvl(p_applicant_assignment_id, hr_api.g_number))
1815: ))
1816: or
1817: (NOT l_api_updating)) then
1818: --
1889: --
1890: --
1891: -- Check mandatory parameters have been set
1892: --
1893: hr_api.mandatory_arg_error
1894: (p_api_name => l_proc
1895: ,p_argument => 'effective_date'
1896: ,p_argument_value => p_effective_date
1897: );
1904: (p_offer_id => p_offer_id
1905: ,p_object_version_number => p_object_version_number);
1906: --
1907: if ((l_api_updating
1908: and nvl(irc_iof_shd.g_old_rec.offer_status, hr_api.g_varchar2) <>
1909: nvl(p_offer_status, hr_api.g_varchar2))
1910: or
1911: (NOT l_api_updating)) then
1912: --
1905: ,p_object_version_number => p_object_version_number);
1906: --
1907: if ((l_api_updating
1908: and nvl(irc_iof_shd.g_old_rec.offer_status, hr_api.g_varchar2) <>
1909: nvl(p_offer_status, hr_api.g_varchar2))
1910: or
1911: (NOT l_api_updating)) then
1912: --
1913: hr_utility.set_location(l_proc, 20);
1915: -- Checks that the value for offer_status is
1916: -- valid and exists on irc_offer_statuses within
1917: -- the specified date range
1918: --
1919: if hr_api.not_exists_in_hr_lookups
1920: (p_effective_date => p_effective_date
1921: ,p_lookup_type => 'IRC_OFFER_STATUSES'
1922: ,p_lookup_code => p_offer_status
1923: ) then
2297: Close C_Sel1;
2298: --
2299: -- If any field has changed, increment l_update_count.
2300: --
2301: if( p_offer_id <> hr_api.g_number) then
2302: if
2303: nvl(l_offer_old_rec.offer_id, hr_api.g_number) <>
2304: nvl(p_offer_id, hr_api.g_number)
2305: then
2299: -- If any field has changed, increment l_update_count.
2300: --
2301: if( p_offer_id <> hr_api.g_number) then
2302: if
2303: nvl(l_offer_old_rec.offer_id, hr_api.g_number) <>
2304: nvl(p_offer_id, hr_api.g_number)
2305: then
2306: --
2307: hr_utility.set_location(l_proc,20);
2300: --
2301: if( p_offer_id <> hr_api.g_number) then
2302: if
2303: nvl(l_offer_old_rec.offer_id, hr_api.g_number) <>
2304: nvl(p_offer_id, hr_api.g_number)
2305: then
2306: --
2307: hr_utility.set_location(l_proc,20);
2308: --
2309: l_update_count := l_update_count + 1;
2310: end if;
2311: end if;
2312:
2313: if(p_offer_status <> hr_api.g_varchar2) then
2314: --
2315: hr_utility.set_location(l_proc,30);
2316: --
2317: if
2314: --
2315: hr_utility.set_location(l_proc,30);
2316: --
2317: if
2318: nvl(l_offer_old_rec.offer_status, hr_api.g_varchar2) <>
2319: nvl(p_offer_status, hr_api.g_varchar2)
2320: then
2321: --
2322: hr_utility.set_location(l_proc,50);
2315: hr_utility.set_location(l_proc,30);
2316: --
2317: if
2318: nvl(l_offer_old_rec.offer_status, hr_api.g_varchar2) <>
2319: nvl(p_offer_status, hr_api.g_varchar2)
2320: then
2321: --
2322: hr_utility.set_location(l_proc,50);
2323: --
2324: l_update_count := l_update_count + 1;
2325: end if;
2326: end if;
2327:
2328: if(p_discretionary_job_title <> hr_api.g_varchar2)
2329: or p_discretionary_job_title is null
2330: then
2331: if
2332: nvl(l_offer_old_rec.discretionary_job_title, hr_api.g_varchar2) <>
2328: if(p_discretionary_job_title <> hr_api.g_varchar2)
2329: or p_discretionary_job_title is null
2330: then
2331: if
2332: nvl(l_offer_old_rec.discretionary_job_title, hr_api.g_varchar2) <>
2333: nvl(p_discretionary_job_title, hr_api.g_varchar2)
2334: then
2335: --
2336: hr_utility.set_location(l_proc,60);
2329: or p_discretionary_job_title is null
2330: then
2331: if
2332: nvl(l_offer_old_rec.discretionary_job_title, hr_api.g_varchar2) <>
2333: nvl(p_discretionary_job_title, hr_api.g_varchar2)
2334: then
2335: --
2336: hr_utility.set_location(l_proc,60);
2337: --
2338: l_update_count := l_update_count + 1;
2339: end if;
2340: end if;
2341:
2342: if(p_offer_extended_method <> hr_api.g_varchar2)
2343: or p_offer_extended_method is null
2344: then
2345: if
2346: nvl(l_offer_old_rec.offer_extended_method, hr_api.g_varchar2) <>
2342: if(p_offer_extended_method <> hr_api.g_varchar2)
2343: or p_offer_extended_method is null
2344: then
2345: if
2346: nvl(l_offer_old_rec.offer_extended_method, hr_api.g_varchar2) <>
2347: nvl(p_offer_extended_method, hr_api.g_varchar2)
2348: then
2349: --
2350: hr_utility.set_location(l_proc,70);
2343: or p_offer_extended_method is null
2344: then
2345: if
2346: nvl(l_offer_old_rec.offer_extended_method, hr_api.g_varchar2) <>
2347: nvl(p_offer_extended_method, hr_api.g_varchar2)
2348: then
2349: --
2350: hr_utility.set_location(l_proc,70);
2351: --
2352: l_update_count := l_update_count + 1;
2353: end if;
2354: end if;
2355:
2356: if(p_expiry_date <> hr_api.g_date)
2357: or p_expiry_date is null
2358: then
2359: if
2360: nvl(l_offer_old_rec.expiry_date, hr_api.g_date) <>
2356: if(p_expiry_date <> hr_api.g_date)
2357: or p_expiry_date is null
2358: then
2359: if
2360: nvl(l_offer_old_rec.expiry_date, hr_api.g_date) <>
2361: nvl(p_expiry_date, hr_api.g_date)
2362: then
2363: --
2364: hr_utility.set_location(l_proc,90);
2357: or p_expiry_date is null
2358: then
2359: if
2360: nvl(l_offer_old_rec.expiry_date, hr_api.g_date) <>
2361: nvl(p_expiry_date, hr_api.g_date)
2362: then
2363: --
2364: hr_utility.set_location(l_proc,90);
2365: --
2366: l_update_count := l_update_count + 1;
2367: end if;
2368: end if;
2369:
2370: if(p_proposed_start_date <> hr_api.g_date)
2371: or p_proposed_start_date is null
2372: then
2373: if
2374: nvl(l_offer_old_rec.proposed_start_date, hr_api.g_date) <>
2370: if(p_proposed_start_date <> hr_api.g_date)
2371: or p_proposed_start_date is null
2372: then
2373: if
2374: nvl(l_offer_old_rec.proposed_start_date, hr_api.g_date) <>
2375: nvl(p_proposed_start_date, hr_api.g_date)
2376: then
2377: --
2378: hr_utility.set_location(l_proc,100);
2371: or p_proposed_start_date is null
2372: then
2373: if
2374: nvl(l_offer_old_rec.proposed_start_date, hr_api.g_date) <>
2375: nvl(p_proposed_start_date, hr_api.g_date)
2376: then
2377: --
2378: hr_utility.set_location(l_proc,100);
2379: --
2380: l_update_count := l_update_count + 1;
2381: end if;
2382: end if;
2383: --
2384: if(p_offer_letter_tracking_code <> hr_api.g_varchar2)
2385: or p_offer_letter_tracking_code is null
2386: then
2387: if
2388: nvl(l_offer_old_rec.offer_letter_tracking_code, hr_api.g_varchar2) <>
2384: if(p_offer_letter_tracking_code <> hr_api.g_varchar2)
2385: or p_offer_letter_tracking_code is null
2386: then
2387: if
2388: nvl(l_offer_old_rec.offer_letter_tracking_code, hr_api.g_varchar2) <>
2389: nvl(p_offer_letter_tracking_code, hr_api.g_varchar2)
2390: then
2391: --
2392: hr_utility.set_location(l_proc,110);
2385: or p_offer_letter_tracking_code is null
2386: then
2387: if
2388: nvl(l_offer_old_rec.offer_letter_tracking_code, hr_api.g_varchar2) <>
2389: nvl(p_offer_letter_tracking_code, hr_api.g_varchar2)
2390: then
2391: --
2392: hr_utility.set_location(l_proc,110);
2393: --
2394: l_update_count := l_update_count + 1;
2395: end if;
2396: end if;
2397:
2398: if(p_offer_postal_service <> hr_api.g_varchar2)
2399: or p_offer_postal_service is null
2400: then
2401: if
2402: nvl(l_offer_old_rec.offer_postal_service, hr_api.g_varchar2) <>
2398: if(p_offer_postal_service <> hr_api.g_varchar2)
2399: or p_offer_postal_service is null
2400: then
2401: if
2402: nvl(l_offer_old_rec.offer_postal_service, hr_api.g_varchar2) <>
2403: nvl(p_offer_postal_service, hr_api.g_varchar2)
2404: then
2405: --
2406: hr_utility.set_location(l_proc,120);
2399: or p_offer_postal_service is null
2400: then
2401: if
2402: nvl(l_offer_old_rec.offer_postal_service, hr_api.g_varchar2) <>
2403: nvl(p_offer_postal_service, hr_api.g_varchar2)
2404: then
2405: --
2406: hr_utility.set_location(l_proc,120);
2407: --
2408: l_update_count := l_update_count + 1;
2409: end if;
2410: end if;
2411:
2412: if(p_offer_shipping_date <> hr_api.g_date)
2413: or p_offer_shipping_date is null
2414: then
2415: if
2416: nvl(l_offer_old_rec.offer_shipping_date, hr_api.g_date) <>
2412: if(p_offer_shipping_date <> hr_api.g_date)
2413: or p_offer_shipping_date is null
2414: then
2415: if
2416: nvl(l_offer_old_rec.offer_shipping_date, hr_api.g_date) <>
2417: nvl(p_offer_shipping_date, hr_api.g_date)
2418: then
2419: --
2420: hr_utility.set_location(l_proc,130);
2413: or p_offer_shipping_date is null
2414: then
2415: if
2416: nvl(l_offer_old_rec.offer_shipping_date, hr_api.g_date) <>
2417: nvl(p_offer_shipping_date, hr_api.g_date)
2418: then
2419: --
2420: hr_utility.set_location(l_proc,130);
2421: --
2423: end if;
2424: end if;
2425: --
2426:
2427: if(p_applicant_assignment_id <> hr_api.g_number) then
2428: if
2429: nvl(l_offer_old_rec.applicant_assignment_id, hr_api.g_number) <>
2430: nvl(p_applicant_assignment_id, hr_api.g_number)
2431: then
2425: --
2426:
2427: if(p_applicant_assignment_id <> hr_api.g_number) then
2428: if
2429: nvl(l_offer_old_rec.applicant_assignment_id, hr_api.g_number) <>
2430: nvl(p_applicant_assignment_id, hr_api.g_number)
2431: then
2432: --
2433: hr_utility.set_location(l_proc,150);
2426:
2427: if(p_applicant_assignment_id <> hr_api.g_number) then
2428: if
2429: nvl(l_offer_old_rec.applicant_assignment_id, hr_api.g_number) <>
2430: nvl(p_applicant_assignment_id, hr_api.g_number)
2431: then
2432: --
2433: hr_utility.set_location(l_proc,150);
2434: --
2435: l_update_count := l_update_count + 1;
2436: end if;
2437: end if;
2438:
2439: if(p_offer_assignment_id <> hr_api.g_number) then
2440: if
2441: nvl(l_offer_old_rec.offer_assignment_id, hr_api.g_number) <>
2442: nvl(p_offer_assignment_id, hr_api.g_number)
2443: then
2437: end if;
2438:
2439: if(p_offer_assignment_id <> hr_api.g_number) then
2440: if
2441: nvl(l_offer_old_rec.offer_assignment_id, hr_api.g_number) <>
2442: nvl(p_offer_assignment_id, hr_api.g_number)
2443: then
2444: --
2445: hr_utility.set_location(l_proc,160);
2438:
2439: if(p_offer_assignment_id <> hr_api.g_number) then
2440: if
2441: nvl(l_offer_old_rec.offer_assignment_id, hr_api.g_number) <>
2442: nvl(p_offer_assignment_id, hr_api.g_number)
2443: then
2444: --
2445: hr_utility.set_location(l_proc,160);
2446: --
2447: l_update_count := l_update_count + 1;
2448: end if;
2449: end if;
2450:
2451: if(p_address_id <> hr_api.g_number)
2452: or p_address_id is null
2453: then
2454: if
2455: nvl(l_offer_old_rec.address_id, hr_api.g_number) <>
2451: if(p_address_id <> hr_api.g_number)
2452: or p_address_id is null
2453: then
2454: if
2455: nvl(l_offer_old_rec.address_id, hr_api.g_number) <>
2456: nvl(p_address_id, hr_api.g_number)
2457: then
2458: --
2459: hr_utility.set_location(l_proc,170);
2452: or p_address_id is null
2453: then
2454: if
2455: nvl(l_offer_old_rec.address_id, hr_api.g_number) <>
2456: nvl(p_address_id, hr_api.g_number)
2457: then
2458: --
2459: hr_utility.set_location(l_proc,170);
2460: --
2461: l_update_count := l_update_count + 1;
2462: end if;
2463: end if;
2464:
2465: if(p_template_id <> hr_api.g_number)
2466: or p_template_id is null
2467: then
2468: if
2469: nvl(l_offer_old_rec.template_id, hr_api.g_number) <>
2465: if(p_template_id <> hr_api.g_number)
2466: or p_template_id is null
2467: then
2468: if
2469: nvl(l_offer_old_rec.template_id, hr_api.g_number) <>
2470: nvl(p_template_id, hr_api.g_number)
2471: then
2472: --
2473: hr_utility.set_location(l_proc,180);
2466: or p_template_id is null
2467: then
2468: if
2469: nvl(l_offer_old_rec.template_id, hr_api.g_number) <>
2470: nvl(p_template_id, hr_api.g_number)
2471: then
2472: --
2473: hr_utility.set_location(l_proc,180);
2474: --
2475: l_update_count := l_update_count + 1;
2476: end if;
2477: end if;
2478:
2479: if(p_offer_letter_file_type <> hr_api.g_varchar2)
2480: or p_offer_letter_file_type is null
2481: then
2482: if
2483: nvl(l_offer_old_rec.offer_letter_file_type, hr_api.g_varchar2) <>
2479: if(p_offer_letter_file_type <> hr_api.g_varchar2)
2480: or p_offer_letter_file_type is null
2481: then
2482: if
2483: nvl(l_offer_old_rec.offer_letter_file_type, hr_api.g_varchar2) <>
2484: nvl(p_offer_letter_file_type, hr_api.g_varchar2)
2485: then
2486: --
2487: hr_utility.set_location(l_proc,190);
2480: or p_offer_letter_file_type is null
2481: then
2482: if
2483: nvl(l_offer_old_rec.offer_letter_file_type, hr_api.g_varchar2) <>
2484: nvl(p_offer_letter_file_type, hr_api.g_varchar2)
2485: then
2486: --
2487: hr_utility.set_location(l_proc,190);
2488: --
2489: l_update_count := l_update_count + 1;
2490: end if;
2491: end if;
2492:
2493: if(p_offer_letter_file_name <> hr_api.g_varchar2)
2494: or p_offer_letter_file_name is null
2495: then
2496: if
2497: nvl(l_offer_old_rec.offer_letter_file_name, hr_api.g_varchar2) <>
2493: if(p_offer_letter_file_name <> hr_api.g_varchar2)
2494: or p_offer_letter_file_name is null
2495: then
2496: if
2497: nvl(l_offer_old_rec.offer_letter_file_name, hr_api.g_varchar2) <>
2498: nvl(p_offer_letter_file_name, hr_api.g_varchar2)
2499: then
2500: --
2501: hr_utility.set_location(l_proc,200);
2494: or p_offer_letter_file_name is null
2495: then
2496: if
2497: nvl(l_offer_old_rec.offer_letter_file_name, hr_api.g_varchar2) <>
2498: nvl(p_offer_letter_file_name, hr_api.g_varchar2)
2499: then
2500: --
2501: hr_utility.set_location(l_proc,200);
2502: --
2503: l_update_count := l_update_count + 1;
2504: end if;
2505: end if;
2506:
2507: if(p_attribute_category <> hr_api.g_varchar2)
2508: or p_attribute_category is null
2509: then
2510: if
2511: nvl(l_offer_old_rec.attribute_category, hr_api.g_varchar2) <>
2507: if(p_attribute_category <> hr_api.g_varchar2)
2508: or p_attribute_category is null
2509: then
2510: if
2511: nvl(l_offer_old_rec.attribute_category, hr_api.g_varchar2) <>
2512: nvl(p_attribute_category, hr_api.g_varchar2)
2513: then
2514: --
2515: hr_utility.set_location(l_proc,210);
2508: or p_attribute_category is null
2509: then
2510: if
2511: nvl(l_offer_old_rec.attribute_category, hr_api.g_varchar2) <>
2512: nvl(p_attribute_category, hr_api.g_varchar2)
2513: then
2514: --
2515: hr_utility.set_location(l_proc,210);
2516: --
2517: l_update_count := l_update_count + 1;
2518: end if;
2519: end if;
2520:
2521: if(p_attribute1 <> hr_api.g_varchar2)
2522: or p_attribute1 is null
2523: then
2524: if
2525: nvl(l_offer_old_rec.attribute1, hr_api.g_varchar2) <>
2521: if(p_attribute1 <> hr_api.g_varchar2)
2522: or p_attribute1 is null
2523: then
2524: if
2525: nvl(l_offer_old_rec.attribute1, hr_api.g_varchar2) <>
2526: nvl(p_attribute1, hr_api.g_varchar2)
2527: then
2528: --
2529: hr_utility.set_location(l_proc,220);
2522: or p_attribute1 is null
2523: then
2524: if
2525: nvl(l_offer_old_rec.attribute1, hr_api.g_varchar2) <>
2526: nvl(p_attribute1, hr_api.g_varchar2)
2527: then
2528: --
2529: hr_utility.set_location(l_proc,220);
2530: --
2531: l_update_count := l_update_count + 1;
2532: end if;
2533: end if;
2534:
2535: if(p_attribute2 <> hr_api.g_varchar2)
2536: or p_attribute2 is null
2537: then
2538: if
2539: nvl(l_offer_old_rec.attribute2, hr_api.g_varchar2) <>
2535: if(p_attribute2 <> hr_api.g_varchar2)
2536: or p_attribute2 is null
2537: then
2538: if
2539: nvl(l_offer_old_rec.attribute2, hr_api.g_varchar2) <>
2540: nvl(p_attribute2, hr_api.g_varchar2)
2541: then
2542: --
2543: hr_utility.set_location(l_proc,230);
2536: or p_attribute2 is null
2537: then
2538: if
2539: nvl(l_offer_old_rec.attribute2, hr_api.g_varchar2) <>
2540: nvl(p_attribute2, hr_api.g_varchar2)
2541: then
2542: --
2543: hr_utility.set_location(l_proc,230);
2544: --
2545: l_update_count := l_update_count + 1;
2546: end if;
2547: end if;
2548:
2549: if(p_attribute3 <> hr_api.g_varchar2)
2550: or p_attribute3 is null
2551: then
2552: if
2553: nvl(l_offer_old_rec.attribute3, hr_api.g_varchar2) <>
2549: if(p_attribute3 <> hr_api.g_varchar2)
2550: or p_attribute3 is null
2551: then
2552: if
2553: nvl(l_offer_old_rec.attribute3, hr_api.g_varchar2) <>
2554: nvl(p_attribute3, hr_api.g_varchar2)
2555: then
2556: --
2557: hr_utility.set_location(l_proc,240);
2550: or p_attribute3 is null
2551: then
2552: if
2553: nvl(l_offer_old_rec.attribute3, hr_api.g_varchar2) <>
2554: nvl(p_attribute3, hr_api.g_varchar2)
2555: then
2556: --
2557: hr_utility.set_location(l_proc,240);
2558: --
2559: l_update_count := l_update_count + 1;
2560: end if;
2561: end if;
2562:
2563: if(p_attribute4 <> hr_api.g_varchar2)
2564: or p_attribute4 is null
2565: then
2566: if
2567: nvl(l_offer_old_rec.attribute4, hr_api.g_varchar2) <>
2563: if(p_attribute4 <> hr_api.g_varchar2)
2564: or p_attribute4 is null
2565: then
2566: if
2567: nvl(l_offer_old_rec.attribute4, hr_api.g_varchar2) <>
2568: nvl(p_attribute4, hr_api.g_varchar2)
2569: then
2570: --
2571: hr_utility.set_location(l_proc,250);
2564: or p_attribute4 is null
2565: then
2566: if
2567: nvl(l_offer_old_rec.attribute4, hr_api.g_varchar2) <>
2568: nvl(p_attribute4, hr_api.g_varchar2)
2569: then
2570: --
2571: hr_utility.set_location(l_proc,250);
2572: --
2573: l_update_count := l_update_count + 1;
2574: end if;
2575: end if;
2576:
2577: if(p_attribute5 <> hr_api.g_varchar2)
2578: or p_attribute5 is null
2579: then
2580: if
2581: nvl(l_offer_old_rec.attribute5, hr_api.g_varchar2) <>
2577: if(p_attribute5 <> hr_api.g_varchar2)
2578: or p_attribute5 is null
2579: then
2580: if
2581: nvl(l_offer_old_rec.attribute5, hr_api.g_varchar2) <>
2582: nvl(p_attribute5, hr_api.g_varchar2)
2583: then
2584: --
2585: hr_utility.set_location(l_proc,260);
2578: or p_attribute5 is null
2579: then
2580: if
2581: nvl(l_offer_old_rec.attribute5, hr_api.g_varchar2) <>
2582: nvl(p_attribute5, hr_api.g_varchar2)
2583: then
2584: --
2585: hr_utility.set_location(l_proc,260);
2586: --
2587: l_update_count := l_update_count + 1;
2588: end if;
2589: end if;
2590:
2591: if(p_attribute6 <> hr_api.g_varchar2)
2592: or p_attribute6 is null
2593: then
2594: if
2595: nvl(l_offer_old_rec.attribute6, hr_api.g_varchar2) <>
2591: if(p_attribute6 <> hr_api.g_varchar2)
2592: or p_attribute6 is null
2593: then
2594: if
2595: nvl(l_offer_old_rec.attribute6, hr_api.g_varchar2) <>
2596: nvl(p_attribute6, hr_api.g_varchar2)
2597: then
2598: --
2599: hr_utility.set_location(l_proc,270);
2592: or p_attribute6 is null
2593: then
2594: if
2595: nvl(l_offer_old_rec.attribute6, hr_api.g_varchar2) <>
2596: nvl(p_attribute6, hr_api.g_varchar2)
2597: then
2598: --
2599: hr_utility.set_location(l_proc,270);
2600: --
2601: l_update_count := l_update_count + 1;
2602: end if;
2603: end if;
2604:
2605: if(p_attribute7 <> hr_api.g_varchar2)
2606: or p_attribute7 is null
2607: then
2608: if
2609: nvl(l_offer_old_rec.attribute7, hr_api.g_varchar2) <>
2605: if(p_attribute7 <> hr_api.g_varchar2)
2606: or p_attribute7 is null
2607: then
2608: if
2609: nvl(l_offer_old_rec.attribute7, hr_api.g_varchar2) <>
2610: nvl(p_attribute7, hr_api.g_varchar2)
2611: then
2612: --
2613: hr_utility.set_location(l_proc,280);
2606: or p_attribute7 is null
2607: then
2608: if
2609: nvl(l_offer_old_rec.attribute7, hr_api.g_varchar2) <>
2610: nvl(p_attribute7, hr_api.g_varchar2)
2611: then
2612: --
2613: hr_utility.set_location(l_proc,280);
2614: --
2615: l_update_count := l_update_count + 1;
2616: end if;
2617: end if;
2618:
2619: if(p_attribute8 <> hr_api.g_varchar2)
2620: or p_attribute8 is null
2621: then
2622: if
2623: nvl(l_offer_old_rec.attribute8, hr_api.g_varchar2) <>
2619: if(p_attribute8 <> hr_api.g_varchar2)
2620: or p_attribute8 is null
2621: then
2622: if
2623: nvl(l_offer_old_rec.attribute8, hr_api.g_varchar2) <>
2624: nvl(p_attribute8, hr_api.g_varchar2)
2625: then
2626: --
2627: hr_utility.set_location(l_proc,290);
2620: or p_attribute8 is null
2621: then
2622: if
2623: nvl(l_offer_old_rec.attribute8, hr_api.g_varchar2) <>
2624: nvl(p_attribute8, hr_api.g_varchar2)
2625: then
2626: --
2627: hr_utility.set_location(l_proc,290);
2628: --
2629: l_update_count := l_update_count + 1;
2630: end if;
2631: end if;
2632:
2633: if(p_attribute9 <> hr_api.g_varchar2)
2634: or p_attribute9 is null
2635: then
2636: if
2637: nvl(l_offer_old_rec.attribute9, hr_api.g_varchar2) <>
2633: if(p_attribute9 <> hr_api.g_varchar2)
2634: or p_attribute9 is null
2635: then
2636: if
2637: nvl(l_offer_old_rec.attribute9, hr_api.g_varchar2) <>
2638: nvl(p_attribute9, hr_api.g_varchar2)
2639: then
2640: --
2641: hr_utility.set_location(l_proc,300);
2634: or p_attribute9 is null
2635: then
2636: if
2637: nvl(l_offer_old_rec.attribute9, hr_api.g_varchar2) <>
2638: nvl(p_attribute9, hr_api.g_varchar2)
2639: then
2640: --
2641: hr_utility.set_location(l_proc,300);
2642: --
2643: l_update_count := l_update_count + 1;
2644: end if;
2645: end if;
2646:
2647: if(p_attribute10 <> hr_api.g_varchar2)
2648: or p_attribute10 is null
2649: then
2650: if
2651: nvl(l_offer_old_rec.attribute10, hr_api.g_varchar2) <>
2647: if(p_attribute10 <> hr_api.g_varchar2)
2648: or p_attribute10 is null
2649: then
2650: if
2651: nvl(l_offer_old_rec.attribute10, hr_api.g_varchar2) <>
2652: nvl(p_attribute10, hr_api.g_varchar2)
2653: then
2654: --
2655: hr_utility.set_location(l_proc,310);
2648: or p_attribute10 is null
2649: then
2650: if
2651: nvl(l_offer_old_rec.attribute10, hr_api.g_varchar2) <>
2652: nvl(p_attribute10, hr_api.g_varchar2)
2653: then
2654: --
2655: hr_utility.set_location(l_proc,310);
2656: --
2657: l_update_count := l_update_count + 1;
2658: end if;
2659: end if;
2660:
2661: if(p_attribute11 <> hr_api.g_varchar2)
2662: or p_attribute11 is null
2663: then
2664: if
2665: nvl(l_offer_old_rec.attribute11, hr_api.g_varchar2) <>
2661: if(p_attribute11 <> hr_api.g_varchar2)
2662: or p_attribute11 is null
2663: then
2664: if
2665: nvl(l_offer_old_rec.attribute11, hr_api.g_varchar2) <>
2666: nvl(p_attribute11, hr_api.g_varchar2)
2667: then
2668: --
2669: hr_utility.set_location(l_proc,320);
2662: or p_attribute11 is null
2663: then
2664: if
2665: nvl(l_offer_old_rec.attribute11, hr_api.g_varchar2) <>
2666: nvl(p_attribute11, hr_api.g_varchar2)
2667: then
2668: --
2669: hr_utility.set_location(l_proc,320);
2670: --
2671: l_update_count := l_update_count + 1;
2672: end if;
2673: end if;
2674:
2675: if(p_attribute12 <> hr_api.g_varchar2)
2676: or p_attribute12 is null
2677: then
2678: if
2679: nvl(l_offer_old_rec.attribute12, hr_api.g_varchar2) <>
2675: if(p_attribute12 <> hr_api.g_varchar2)
2676: or p_attribute12 is null
2677: then
2678: if
2679: nvl(l_offer_old_rec.attribute12, hr_api.g_varchar2) <>
2680: nvl(p_attribute12, hr_api.g_varchar2)
2681: then
2682: --
2683: hr_utility.set_location(l_proc,330);
2676: or p_attribute12 is null
2677: then
2678: if
2679: nvl(l_offer_old_rec.attribute12, hr_api.g_varchar2) <>
2680: nvl(p_attribute12, hr_api.g_varchar2)
2681: then
2682: --
2683: hr_utility.set_location(l_proc,330);
2684: --
2685: l_update_count := l_update_count + 1;
2686: end if;
2687: end if;
2688:
2689: if(p_attribute13 <> hr_api.g_varchar2)
2690: or p_attribute13 is null
2691: then
2692: if
2693: nvl(l_offer_old_rec.attribute13, hr_api.g_varchar2) <>
2689: if(p_attribute13 <> hr_api.g_varchar2)
2690: or p_attribute13 is null
2691: then
2692: if
2693: nvl(l_offer_old_rec.attribute13, hr_api.g_varchar2) <>
2694: nvl(p_attribute13, hr_api.g_varchar2)
2695: then
2696: --
2697: hr_utility.set_location(l_proc,340);
2690: or p_attribute13 is null
2691: then
2692: if
2693: nvl(l_offer_old_rec.attribute13, hr_api.g_varchar2) <>
2694: nvl(p_attribute13, hr_api.g_varchar2)
2695: then
2696: --
2697: hr_utility.set_location(l_proc,340);
2698: --
2699: l_update_count := l_update_count + 1;
2700: end if;
2701: end if;
2702:
2703: if(p_attribute14 <> hr_api.g_varchar2)
2704: or p_attribute14 is null
2705: then
2706: if
2707: nvl(l_offer_old_rec.attribute14, hr_api.g_varchar2) <>
2703: if(p_attribute14 <> hr_api.g_varchar2)
2704: or p_attribute14 is null
2705: then
2706: if
2707: nvl(l_offer_old_rec.attribute14, hr_api.g_varchar2) <>
2708: nvl(p_attribute14, hr_api.g_varchar2)
2709: then
2710: --
2711: hr_utility.set_location(l_proc,350);
2704: or p_attribute14 is null
2705: then
2706: if
2707: nvl(l_offer_old_rec.attribute14, hr_api.g_varchar2) <>
2708: nvl(p_attribute14, hr_api.g_varchar2)
2709: then
2710: --
2711: hr_utility.set_location(l_proc,350);
2712: --
2713: l_update_count := l_update_count + 1;
2714: end if;
2715: end if;
2716:
2717: if(p_attribute15 <> hr_api.g_varchar2)
2718: or p_attribute15 is null
2719: then
2720: if
2721: nvl(l_offer_old_rec.attribute15, hr_api.g_varchar2) <>
2717: if(p_attribute15 <> hr_api.g_varchar2)
2718: or p_attribute15 is null
2719: then
2720: if
2721: nvl(l_offer_old_rec.attribute15, hr_api.g_varchar2) <>
2722: nvl(p_attribute15, hr_api.g_varchar2)
2723: then
2724: --
2725: hr_utility.set_location(l_proc,360);
2718: or p_attribute15 is null
2719: then
2720: if
2721: nvl(l_offer_old_rec.attribute15, hr_api.g_varchar2) <>
2722: nvl(p_attribute15, hr_api.g_varchar2)
2723: then
2724: --
2725: hr_utility.set_location(l_proc,360);
2726: --
2727: l_update_count := l_update_count + 1;
2728: end if;
2729: end if;
2730:
2731: if(p_attribute16 <> hr_api.g_varchar2)
2732: or p_attribute16 is null
2733: then
2734: if
2735: nvl(l_offer_old_rec.attribute16, hr_api.g_varchar2) <>
2731: if(p_attribute16 <> hr_api.g_varchar2)
2732: or p_attribute16 is null
2733: then
2734: if
2735: nvl(l_offer_old_rec.attribute16, hr_api.g_varchar2) <>
2736: nvl(p_attribute16, hr_api.g_varchar2)
2737: then
2738: --
2739: hr_utility.set_location(l_proc,370);
2732: or p_attribute16 is null
2733: then
2734: if
2735: nvl(l_offer_old_rec.attribute16, hr_api.g_varchar2) <>
2736: nvl(p_attribute16, hr_api.g_varchar2)
2737: then
2738: --
2739: hr_utility.set_location(l_proc,370);
2740: --
2741: l_update_count := l_update_count + 1;
2742: end if;
2743: end if;
2744:
2745: if(p_attribute17 <> hr_api.g_varchar2)
2746: or p_attribute17 is null
2747: then
2748: if
2749: nvl(l_offer_old_rec.attribute17, hr_api.g_varchar2) <>
2745: if(p_attribute17 <> hr_api.g_varchar2)
2746: or p_attribute17 is null
2747: then
2748: if
2749: nvl(l_offer_old_rec.attribute17, hr_api.g_varchar2) <>
2750: nvl(p_attribute17, hr_api.g_varchar2)
2751: then
2752: --
2753: hr_utility.set_location(l_proc,380);
2746: or p_attribute17 is null
2747: then
2748: if
2749: nvl(l_offer_old_rec.attribute17, hr_api.g_varchar2) <>
2750: nvl(p_attribute17, hr_api.g_varchar2)
2751: then
2752: --
2753: hr_utility.set_location(l_proc,380);
2754: --
2755: l_update_count := l_update_count + 1;
2756: end if;
2757: end if;
2758:
2759: if(p_attribute18 <> hr_api.g_varchar2)
2760: or p_attribute18 is null
2761: then
2762: if
2763: nvl(l_offer_old_rec.attribute18, hr_api.g_varchar2) <>
2759: if(p_attribute18 <> hr_api.g_varchar2)
2760: or p_attribute18 is null
2761: then
2762: if
2763: nvl(l_offer_old_rec.attribute18, hr_api.g_varchar2) <>
2764: nvl(p_attribute18, hr_api.g_varchar2)
2765: then
2766: --
2767: hr_utility.set_location(l_proc,390);
2760: or p_attribute18 is null
2761: then
2762: if
2763: nvl(l_offer_old_rec.attribute18, hr_api.g_varchar2) <>
2764: nvl(p_attribute18, hr_api.g_varchar2)
2765: then
2766: --
2767: hr_utility.set_location(l_proc,390);
2768: --
2769: l_update_count := l_update_count + 1;
2770: end if;
2771: end if;
2772:
2773: if(p_attribute19 <> hr_api.g_varchar2)
2774: or p_attribute19 is null
2775: then
2776: if
2777: nvl(l_offer_old_rec.attribute19, hr_api.g_varchar2) <>
2773: if(p_attribute19 <> hr_api.g_varchar2)
2774: or p_attribute19 is null
2775: then
2776: if
2777: nvl(l_offer_old_rec.attribute19, hr_api.g_varchar2) <>
2778: nvl(p_attribute19, hr_api.g_varchar2)
2779: then
2780: --
2781: hr_utility.set_location(l_proc,400);
2774: or p_attribute19 is null
2775: then
2776: if
2777: nvl(l_offer_old_rec.attribute19, hr_api.g_varchar2) <>
2778: nvl(p_attribute19, hr_api.g_varchar2)
2779: then
2780: --
2781: hr_utility.set_location(l_proc,400);
2782: --
2783: l_update_count := l_update_count + 1;
2784: end if;
2785: end if;
2786:
2787: if(p_attribute20 <> hr_api.g_varchar2)
2788: or p_attribute20 is null
2789: then
2790: if
2791: nvl(l_offer_old_rec.attribute20, hr_api.g_varchar2) <>
2787: if(p_attribute20 <> hr_api.g_varchar2)
2788: or p_attribute20 is null
2789: then
2790: if
2791: nvl(l_offer_old_rec.attribute20, hr_api.g_varchar2) <>
2792: nvl(p_attribute20, hr_api.g_varchar2)
2793: then
2794: --
2795: hr_utility.set_location(l_proc,410);
2788: or p_attribute20 is null
2789: then
2790: if
2791: nvl(l_offer_old_rec.attribute20, hr_api.g_varchar2) <>
2792: nvl(p_attribute20, hr_api.g_varchar2)
2793: then
2794: --
2795: hr_utility.set_location(l_proc,410);
2796: --
2797: l_update_count := l_update_count + 1;
2798: end if;
2799: end if;
2800:
2801: if(p_attribute21 <> hr_api.g_varchar2)
2802: or p_attribute21 is null
2803: then
2804: if
2805: nvl(l_offer_old_rec.attribute21, hr_api.g_varchar2) <>
2801: if(p_attribute21 <> hr_api.g_varchar2)
2802: or p_attribute21 is null
2803: then
2804: if
2805: nvl(l_offer_old_rec.attribute21, hr_api.g_varchar2) <>
2806: nvl(p_attribute21, hr_api.g_varchar2)
2807: then
2808: --
2809: hr_utility.set_location(l_proc,420);
2802: or p_attribute21 is null
2803: then
2804: if
2805: nvl(l_offer_old_rec.attribute21, hr_api.g_varchar2) <>
2806: nvl(p_attribute21, hr_api.g_varchar2)
2807: then
2808: --
2809: hr_utility.set_location(l_proc,420);
2810: --
2811: l_update_count := l_update_count + 1;
2812: end if;
2813: end if;
2814:
2815: if(p_attribute22 <> hr_api.g_varchar2)
2816: or p_attribute22 is null
2817: then
2818: if
2819: nvl(l_offer_old_rec.attribute22, hr_api.g_varchar2) <>
2815: if(p_attribute22 <> hr_api.g_varchar2)
2816: or p_attribute22 is null
2817: then
2818: if
2819: nvl(l_offer_old_rec.attribute22, hr_api.g_varchar2) <>
2820: nvl(p_attribute22, hr_api.g_varchar2)
2821: then
2822: --
2823: hr_utility.set_location(l_proc,430);
2816: or p_attribute22 is null
2817: then
2818: if
2819: nvl(l_offer_old_rec.attribute22, hr_api.g_varchar2) <>
2820: nvl(p_attribute22, hr_api.g_varchar2)
2821: then
2822: --
2823: hr_utility.set_location(l_proc,430);
2824: --
2825: l_update_count := l_update_count + 1;
2826: end if;
2827: end if;
2828:
2829: if(p_attribute23 <> hr_api.g_varchar2)
2830: or p_attribute23 is null
2831: then
2832: if
2833: nvl(l_offer_old_rec.attribute23, hr_api.g_varchar2) <>
2829: if(p_attribute23 <> hr_api.g_varchar2)
2830: or p_attribute23 is null
2831: then
2832: if
2833: nvl(l_offer_old_rec.attribute23, hr_api.g_varchar2) <>
2834: nvl(p_attribute23, hr_api.g_varchar2)
2835: then
2836: --
2837: hr_utility.set_location(l_proc,440);
2830: or p_attribute23 is null
2831: then
2832: if
2833: nvl(l_offer_old_rec.attribute23, hr_api.g_varchar2) <>
2834: nvl(p_attribute23, hr_api.g_varchar2)
2835: then
2836: --
2837: hr_utility.set_location(l_proc,440);
2838: --
2839: l_update_count := l_update_count + 1;
2840: end if;
2841: end if;
2842:
2843: if(p_attribute24 <> hr_api.g_varchar2)
2844: or p_attribute24 is null
2845: then
2846: if
2847: nvl(l_offer_old_rec.attribute24, hr_api.g_varchar2) <>
2843: if(p_attribute24 <> hr_api.g_varchar2)
2844: or p_attribute24 is null
2845: then
2846: if
2847: nvl(l_offer_old_rec.attribute24, hr_api.g_varchar2) <>
2848: nvl(p_attribute24, hr_api.g_varchar2)
2849: then
2850: --
2851: hr_utility.set_location(l_proc,450);
2844: or p_attribute24 is null
2845: then
2846: if
2847: nvl(l_offer_old_rec.attribute24, hr_api.g_varchar2) <>
2848: nvl(p_attribute24, hr_api.g_varchar2)
2849: then
2850: --
2851: hr_utility.set_location(l_proc,450);
2852: --
2853: l_update_count := l_update_count + 1;
2854: end if;
2855: end if;
2856:
2857: if(p_attribute25 <> hr_api.g_varchar2)
2858: or p_attribute25 is null
2859: then
2860: if
2861: nvl(l_offer_old_rec.attribute25, hr_api.g_varchar2) <>
2857: if(p_attribute25 <> hr_api.g_varchar2)
2858: or p_attribute25 is null
2859: then
2860: if
2861: nvl(l_offer_old_rec.attribute25, hr_api.g_varchar2) <>
2862: nvl(p_attribute25, hr_api.g_varchar2)
2863: then
2864: --
2865: hr_utility.set_location(l_proc,460);
2858: or p_attribute25 is null
2859: then
2860: if
2861: nvl(l_offer_old_rec.attribute25, hr_api.g_varchar2) <>
2862: nvl(p_attribute25, hr_api.g_varchar2)
2863: then
2864: --
2865: hr_utility.set_location(l_proc,460);
2866: --
2867: l_update_count := l_update_count + 1;
2868: end if;
2869: end if;
2870:
2871: if(p_attribute26 <> hr_api.g_varchar2)
2872: or p_attribute26 is null
2873: then
2874: if
2875: nvl(l_offer_old_rec.attribute26, hr_api.g_varchar2) <>
2871: if(p_attribute26 <> hr_api.g_varchar2)
2872: or p_attribute26 is null
2873: then
2874: if
2875: nvl(l_offer_old_rec.attribute26, hr_api.g_varchar2) <>
2876: nvl(p_attribute26, hr_api.g_varchar2)
2877: then
2878: --
2879: hr_utility.set_location(l_proc,470);
2872: or p_attribute26 is null
2873: then
2874: if
2875: nvl(l_offer_old_rec.attribute26, hr_api.g_varchar2) <>
2876: nvl(p_attribute26, hr_api.g_varchar2)
2877: then
2878: --
2879: hr_utility.set_location(l_proc,470);
2880: --
2881: l_update_count := l_update_count + 1;
2882: end if;
2883: end if;
2884:
2885: if(p_attribute27 <> hr_api.g_varchar2)
2886: or p_attribute27 is null
2887: then
2888: if
2889: nvl(l_offer_old_rec.attribute27, hr_api.g_varchar2) <>
2885: if(p_attribute27 <> hr_api.g_varchar2)
2886: or p_attribute27 is null
2887: then
2888: if
2889: nvl(l_offer_old_rec.attribute27, hr_api.g_varchar2) <>
2890: nvl(p_attribute27, hr_api.g_varchar2)
2891: then
2892: --
2893: hr_utility.set_location(l_proc,480);
2886: or p_attribute27 is null
2887: then
2888: if
2889: nvl(l_offer_old_rec.attribute27, hr_api.g_varchar2) <>
2890: nvl(p_attribute27, hr_api.g_varchar2)
2891: then
2892: --
2893: hr_utility.set_location(l_proc,480);
2894: --
2895: l_update_count := l_update_count + 1;
2896: end if;
2897: end if;
2898:
2899: if(p_attribute28 <> hr_api.g_varchar2)
2900: or p_attribute28 is null
2901: then
2902: if
2903: nvl(l_offer_old_rec.attribute28, hr_api.g_varchar2) <>
2899: if(p_attribute28 <> hr_api.g_varchar2)
2900: or p_attribute28 is null
2901: then
2902: if
2903: nvl(l_offer_old_rec.attribute28, hr_api.g_varchar2) <>
2904: nvl(p_attribute28, hr_api.g_varchar2)
2905: then
2906: --
2907: hr_utility.set_location(l_proc,490);
2900: or p_attribute28 is null
2901: then
2902: if
2903: nvl(l_offer_old_rec.attribute28, hr_api.g_varchar2) <>
2904: nvl(p_attribute28, hr_api.g_varchar2)
2905: then
2906: --
2907: hr_utility.set_location(l_proc,490);
2908: --
2909: l_update_count := l_update_count + 1;
2910: end if;
2911: end if;
2912:
2913: if(p_attribute29 <> hr_api.g_varchar2)
2914: or p_attribute29 is null
2915: then
2916: if
2917: nvl(l_offer_old_rec.attribute29, hr_api.g_varchar2) <>
2913: if(p_attribute29 <> hr_api.g_varchar2)
2914: or p_attribute29 is null
2915: then
2916: if
2917: nvl(l_offer_old_rec.attribute29, hr_api.g_varchar2) <>
2918: nvl(p_attribute29, hr_api.g_varchar2)
2919: then
2920: --
2921: hr_utility.set_location(l_proc,500);
2914: or p_attribute29 is null
2915: then
2916: if
2917: nvl(l_offer_old_rec.attribute29, hr_api.g_varchar2) <>
2918: nvl(p_attribute29, hr_api.g_varchar2)
2919: then
2920: --
2921: hr_utility.set_location(l_proc,500);
2922: --
2923: l_update_count := l_update_count + 1;
2924: end if;
2925: end if;
2926:
2927: if(p_attribute30 <> hr_api.g_varchar2)
2928: or p_attribute30 is null
2929: then
2930: if
2931: nvl(l_offer_old_rec.attribute30, hr_api.g_varchar2) <>
2927: if(p_attribute30 <> hr_api.g_varchar2)
2928: or p_attribute30 is null
2929: then
2930: if
2931: nvl(l_offer_old_rec.attribute30, hr_api.g_varchar2) <>
2932: nvl(p_attribute30, hr_api.g_varchar2)
2933: then
2934: --
2935: hr_utility.set_location(l_proc,510);
2928: or p_attribute30 is null
2929: then
2930: if
2931: nvl(l_offer_old_rec.attribute30, hr_api.g_varchar2) <>
2932: nvl(p_attribute30, hr_api.g_varchar2)
2933: then
2934: --
2935: hr_utility.set_location(l_proc,510);
2936: --
3009: ) then
3010: --
3011: -- Check mandatory parameters have been set
3012: --
3013: hr_api.mandatory_arg_error
3014: (p_api_name => l_proc
3015: ,p_argument => 'effective_date'
3016: ,p_argument_value => p_effective_date
3017: );
3024: (p_offer_id => p_offer_id
3025: ,p_object_version_number => p_object_version_number);
3026: --
3027: if ((l_api_updating
3028: and nvl(irc_iof_shd.g_old_rec.offer_extended_method, hr_api.g_varchar2) <>
3029: nvl(p_offer_extended_method, hr_api.g_varchar2))
3030: or
3031: (NOT l_api_updating)) then
3032: --
3025: ,p_object_version_number => p_object_version_number);
3026: --
3027: if ((l_api_updating
3028: and nvl(irc_iof_shd.g_old_rec.offer_extended_method, hr_api.g_varchar2) <>
3029: nvl(p_offer_extended_method, hr_api.g_varchar2))
3030: or
3031: (NOT l_api_updating)) then
3032: --
3033: -- Check if offer_extended_method is not null.
3039: -- Checks that the value for offer_extended_method is
3040: -- valid and exists on irc_offer_extended_method lookup
3041: -- within the specified date range
3042: --
3043: if hr_api.not_exists_in_hr_lookups
3044: (p_effective_date => p_effective_date
3045: ,p_lookup_type => 'IRC_OFFER_EXTENDED_METHOD'
3046: ,p_lookup_code => p_offer_extended_method
3047: ) then
3113: ) then
3114: --
3115: -- Check mandatory parameters have been set
3116: --
3117: hr_api.mandatory_arg_error
3118: (p_api_name => l_proc
3119: ,p_argument => 'effective_date'
3120: ,p_argument_value => p_effective_date
3121: );
3128: (p_offer_id => p_offer_id
3129: ,p_object_version_number => p_object_version_number);
3130: --
3131: if ((l_api_updating
3132: and nvl(irc_iof_shd.g_old_rec.offer_postal_service, hr_api.g_varchar2) <>
3133: nvl(p_offer_postal_service, hr_api.g_varchar2))
3134: or
3135: (NOT l_api_updating)) then
3136: --
3129: ,p_object_version_number => p_object_version_number);
3130: --
3131: if ((l_api_updating
3132: and nvl(irc_iof_shd.g_old_rec.offer_postal_service, hr_api.g_varchar2) <>
3133: nvl(p_offer_postal_service, hr_api.g_varchar2))
3134: or
3135: (NOT l_api_updating)) then
3136: --
3137: -- Check if offer_postal_service is not null.
3143: -- Checks that the value for offer_postal_service is
3144: -- valid and exists on IRC_OFFER_POSTAL_SERVICE lookup
3145: -- within the specified date range
3146: --
3147: if hr_api.not_exists_in_hr_lookups
3148: (p_effective_date => p_effective_date
3149: ,p_lookup_type => 'IRC_OFFER_POSTAL_SERVICE'
3150: ,p_lookup_code => p_offer_postal_service
3151: ) then
3217: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
3218: ) then
3219: --
3220: if p_offer_status = 'APPROVED'
3221: and nvl(irc_iof_shd.g_old_rec.offer_status, hr_api.g_varchar2) <>
3222: nvl(p_offer_status, hr_api.g_varchar2)
3223: then
3224: --
3225: hr_utility.set_location(l_proc, 20);
3218: ) then
3219: --
3220: if p_offer_status = 'APPROVED'
3221: and nvl(irc_iof_shd.g_old_rec.offer_status, hr_api.g_varchar2) <>
3222: nvl(p_offer_status, hr_api.g_varchar2)
3223: then
3224: --
3225: hr_utility.set_location(l_proc, 20);
3226: --
3314: ) then
3315: --
3316: -- Check mandatory parameters have been set
3317: --
3318: hr_api.mandatory_arg_error
3319: (p_api_name => l_proc
3320: ,p_argument => 'effective_date'
3321: ,p_argument_value => p_effective_date
3322: );
3329: (p_offer_id => p_offer_id
3330: ,p_object_version_number => p_object_version_number);
3331: --
3332: if ((l_api_updating
3333: and nvl(irc_iof_shd.g_old_rec.offer_letter_file_type, hr_api.g_varchar2) <>
3334: nvl(p_offer_letter_file_type, hr_api.g_varchar2))
3335: or
3336: (NOT l_api_updating)) then
3337: --
3330: ,p_object_version_number => p_object_version_number);
3331: --
3332: if ((l_api_updating
3333: and nvl(irc_iof_shd.g_old_rec.offer_letter_file_type, hr_api.g_varchar2) <>
3334: nvl(p_offer_letter_file_type, hr_api.g_varchar2))
3335: or
3336: (NOT l_api_updating)) then
3337: --
3338: -- Check if offer_postal_service is not null.
3344: -- Checks that the value for offer_postal_service is
3345: -- valid and exists on IRC_OFFER_POSTAL_SERVICE lookup
3346: -- within the specified date range
3347: --
3348: if hr_api.not_exists_in_fnd_lookups
3349: (p_effective_date => p_effective_date
3350: ,p_lookup_type => 'XDO_OUTPUT_TYPE'
3351: ,p_lookup_code => p_offer_letter_file_type
3352: ) then