[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: );
857: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
858: )
859: then
860: --
861: hr_api.mandatory_arg_error
862: (p_api_name => l_proc
863: ,p_argument => 'VACANCY_ID'
864: ,p_argument_value => p_vacancy_id
865: );
958: --
959: hr_utility.set_location(l_proc,20);
960:
961: if ((l_api_updating
962: and nvl(irc_iof_shd.g_old_rec.respondent_id, hr_api.g_number) <>
963: nvl(p_respondent_id, hr_api.g_number))
964: or
965: (NOT l_api_updating)) then
966: --
959: hr_utility.set_location(l_proc,20);
960:
961: if ((l_api_updating
962: and nvl(irc_iof_shd.g_old_rec.respondent_id, hr_api.g_number) <>
963: nvl(p_respondent_id, hr_api.g_number))
964: or
965: (NOT l_api_updating)) then
966: --
967: -- Check if respondent id is not null.
1076: else -- p_expiry_date is null or is the previous expiry date
1077: --
1078: -- Check if the intend of this update is to indeed update the expiry date.
1079: --
1080: 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
1081: 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
1082: 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
1083: )
1084: then
1077: --
1078: -- Check if the intend of this update is to indeed update the expiry date.
1079: --
1080: 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
1081: 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
1082: 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
1083: )
1084: then
1085: --
1078: -- Check if the intend of this update is to indeed update the expiry date.
1079: --
1080: 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
1081: 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
1082: 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
1083: )
1084: then
1085: --
1086: -- No value has been entered for the expiry date.
1315: --
1316: hr_utility.set_location(l_proc,20);
1317:
1318: if ((l_api_updating
1319: and nvl(irc_iof_shd.g_old_rec.address_id, hr_api.g_number) <>
1320: nvl(p_address_id, hr_api.g_number))
1321: or
1322: (NOT l_api_updating)) then
1323: --
1316: hr_utility.set_location(l_proc,20);
1317:
1318: if ((l_api_updating
1319: and nvl(irc_iof_shd.g_old_rec.address_id, hr_api.g_number) <>
1320: nvl(p_address_id, hr_api.g_number))
1321: or
1322: (NOT l_api_updating)) then
1323: --
1324: -- Check if address id is not null.
1449: --
1450: hr_utility.set_location(l_proc,20);
1451:
1452: if ((l_api_updating
1453: and nvl(irc_iof_shd.g_old_rec.template_id, hr_api.g_number) <>
1454: nvl(p_template_id, hr_api.g_number)) or
1455: (NOT l_api_updating)) then
1456: --
1457: -- Check if template id is not null and if it is active
1450: hr_utility.set_location(l_proc,20);
1451:
1452: if ((l_api_updating
1453: and nvl(irc_iof_shd.g_old_rec.template_id, hr_api.g_number) <>
1454: nvl(p_template_id, hr_api.g_number)) or
1455: (NOT l_api_updating)) then
1456: --
1457: -- Check if template id is not null and if it is active
1458: --
1574: --
1575: Begin
1576: hr_utility.set_location('Entering:'||l_proc,10);
1577: --
1578: hr_api.mandatory_arg_error
1579: (p_api_name => l_proc
1580: ,p_argument => 'APPLICANT_ASSIGNMENT_ID'
1581: ,p_argument_value => p_applicant_assignment_id
1582: );
1625: -- other latest offers for this applicant assignment.
1626: --
1627: -- 3) The value entered should be validated against HR_LOOKUPS.LOOKUP_CODE
1628: -- where the LOOKUP_TYPE is 'YES_NO'. (I, U)
1629: -- Process: hr_api.not_exists_in_hr_lookups
1630: --
1631: -- Pre Conditions:
1632: -- None
1633: --
1719: --
1720: end if;
1721: --
1722: elsif (l_api_updating
1723: and nvl(irc_iof_shd.g_old_rec.latest_offer, hr_api.g_varchar2) <>
1724: nvl(p_latest_offer, hr_api.g_varchar2))
1725: then
1726: if ( p_offer_status <> 'SAVED')
1727: then
1720: end if;
1721: --
1722: elsif (l_api_updating
1723: and nvl(irc_iof_shd.g_old_rec.latest_offer, hr_api.g_varchar2) <>
1724: nvl(p_latest_offer, hr_api.g_varchar2))
1725: then
1726: if ( p_offer_status <> 'SAVED')
1727: then
1728: --
1742: --
1743: end if;
1744: --
1745: if ((l_api_updating
1746: and nvl(irc_iof_shd.g_old_rec.latest_offer, hr_api.g_varchar2) <>
1747: nvl(p_latest_offer, hr_api.g_varchar2))
1748: or (NOT l_api_updating)) then
1749: --
1750: hr_utility.set_location(l_proc,40);
1743: end if;
1744: --
1745: if ((l_api_updating
1746: and nvl(irc_iof_shd.g_old_rec.latest_offer, hr_api.g_varchar2) <>
1747: nvl(p_latest_offer, hr_api.g_varchar2))
1748: or (NOT l_api_updating)) then
1749: --
1750: hr_utility.set_location(l_proc,40);
1751: --
1751: --
1752: -- Checks that the value for latest_offer is
1753: -- valid and exists on YES_NO lookup
1754: --
1755: if hr_api.not_exists_in_hr_lookups
1756: (p_effective_date => p_effective_date
1757: ,p_lookup_type => 'YES_NO'
1758: ,p_lookup_code => p_latest_offer
1759: ) then
1843: (p_offer_id => p_offer_id
1844: ,p_object_version_number => p_object_version_number);
1845: --
1846: if ((l_api_updating and
1847: ((nvl(irc_iof_shd.g_old_rec.offer_version, hr_api.g_number) <>
1848: nvl(p_offer_version, hr_api.g_number))
1849: or
1850: (nvl(irc_iof_shd.g_old_rec.applicant_assignment_id, hr_api.g_number) <>
1851: nvl(p_applicant_assignment_id, hr_api.g_number))
1844: ,p_object_version_number => p_object_version_number);
1845: --
1846: if ((l_api_updating and
1847: ((nvl(irc_iof_shd.g_old_rec.offer_version, hr_api.g_number) <>
1848: nvl(p_offer_version, hr_api.g_number))
1849: or
1850: (nvl(irc_iof_shd.g_old_rec.applicant_assignment_id, hr_api.g_number) <>
1851: nvl(p_applicant_assignment_id, hr_api.g_number))
1852: ))
1846: if ((l_api_updating and
1847: ((nvl(irc_iof_shd.g_old_rec.offer_version, hr_api.g_number) <>
1848: nvl(p_offer_version, hr_api.g_number))
1849: or
1850: (nvl(irc_iof_shd.g_old_rec.applicant_assignment_id, hr_api.g_number) <>
1851: nvl(p_applicant_assignment_id, hr_api.g_number))
1852: ))
1853: or
1854: (NOT l_api_updating)) then
1847: ((nvl(irc_iof_shd.g_old_rec.offer_version, hr_api.g_number) <>
1848: nvl(p_offer_version, hr_api.g_number))
1849: or
1850: (nvl(irc_iof_shd.g_old_rec.applicant_assignment_id, hr_api.g_number) <>
1851: nvl(p_applicant_assignment_id, hr_api.g_number))
1852: ))
1853: or
1854: (NOT l_api_updating)) then
1855: --
1926: --
1927: --
1928: -- Check mandatory parameters have been set
1929: --
1930: hr_api.mandatory_arg_error
1931: (p_api_name => l_proc
1932: ,p_argument => 'effective_date'
1933: ,p_argument_value => p_effective_date
1934: );
1941: (p_offer_id => p_offer_id
1942: ,p_object_version_number => p_object_version_number);
1943: --
1944: if ((l_api_updating
1945: and nvl(irc_iof_shd.g_old_rec.offer_status, hr_api.g_varchar2) <>
1946: nvl(p_offer_status, hr_api.g_varchar2))
1947: or
1948: (NOT l_api_updating)) then
1949: --
1942: ,p_object_version_number => p_object_version_number);
1943: --
1944: if ((l_api_updating
1945: and nvl(irc_iof_shd.g_old_rec.offer_status, hr_api.g_varchar2) <>
1946: nvl(p_offer_status, hr_api.g_varchar2))
1947: or
1948: (NOT l_api_updating)) then
1949: --
1950: hr_utility.set_location(l_proc, 20);
1952: -- Checks that the value for offer_status is
1953: -- valid and exists on irc_offer_statuses within
1954: -- the specified date range
1955: --
1956: if hr_api.not_exists_in_hr_lookups
1957: (p_effective_date => p_effective_date
1958: ,p_lookup_type => 'IRC_OFFER_STATUSES'
1959: ,p_lookup_code => p_offer_status
1960: ) then
2348: Close C_Sel1;
2349: --
2350: -- If any field has changed, increment l_update_count.
2351: --
2352: if( p_offer_id <> hr_api.g_number) then
2353: if
2354: nvl(l_offer_old_rec.offer_id, hr_api.g_number) <>
2355: nvl(p_offer_id, hr_api.g_number)
2356: then
2350: -- If any field has changed, increment l_update_count.
2351: --
2352: if( p_offer_id <> hr_api.g_number) then
2353: if
2354: nvl(l_offer_old_rec.offer_id, hr_api.g_number) <>
2355: nvl(p_offer_id, hr_api.g_number)
2356: then
2357: --
2358: hr_utility.set_location(l_proc,20);
2351: --
2352: if( p_offer_id <> hr_api.g_number) then
2353: if
2354: nvl(l_offer_old_rec.offer_id, hr_api.g_number) <>
2355: nvl(p_offer_id, hr_api.g_number)
2356: then
2357: --
2358: hr_utility.set_location(l_proc,20);
2359: --
2360: l_update_count := l_update_count + 1;
2361: end if;
2362: end if;
2363:
2364: if(p_offer_status <> hr_api.g_varchar2) then
2365: --
2366: hr_utility.set_location(l_proc,30);
2367: --
2368: if
2365: --
2366: hr_utility.set_location(l_proc,30);
2367: --
2368: if
2369: nvl(l_offer_old_rec.offer_status, hr_api.g_varchar2) <>
2370: nvl(p_offer_status, hr_api.g_varchar2)
2371: then
2372: --
2373: hr_utility.set_location(l_proc,50);
2366: hr_utility.set_location(l_proc,30);
2367: --
2368: if
2369: nvl(l_offer_old_rec.offer_status, hr_api.g_varchar2) <>
2370: nvl(p_offer_status, hr_api.g_varchar2)
2371: then
2372: --
2373: hr_utility.set_location(l_proc,50);
2374: --
2375: l_update_count := l_update_count + 1;
2376: end if;
2377: end if;
2378:
2379: if(p_discretionary_job_title <> hr_api.g_varchar2)
2380: or p_discretionary_job_title is null
2381: then
2382: if
2383: nvl(l_offer_old_rec.discretionary_job_title, hr_api.g_varchar2) <>
2379: if(p_discretionary_job_title <> hr_api.g_varchar2)
2380: or p_discretionary_job_title is null
2381: then
2382: if
2383: nvl(l_offer_old_rec.discretionary_job_title, hr_api.g_varchar2) <>
2384: nvl(p_discretionary_job_title, hr_api.g_varchar2)
2385: then
2386: --
2387: hr_utility.set_location(l_proc,60);
2380: or p_discretionary_job_title is null
2381: then
2382: if
2383: nvl(l_offer_old_rec.discretionary_job_title, hr_api.g_varchar2) <>
2384: nvl(p_discretionary_job_title, hr_api.g_varchar2)
2385: then
2386: --
2387: hr_utility.set_location(l_proc,60);
2388: --
2389: l_update_count := l_update_count + 1;
2390: end if;
2391: end if;
2392:
2393: if(p_offer_extended_method <> hr_api.g_varchar2)
2394: or p_offer_extended_method is null
2395: then
2396: if
2397: nvl(l_offer_old_rec.offer_extended_method, hr_api.g_varchar2) <>
2393: if(p_offer_extended_method <> hr_api.g_varchar2)
2394: or p_offer_extended_method is null
2395: then
2396: if
2397: nvl(l_offer_old_rec.offer_extended_method, hr_api.g_varchar2) <>
2398: nvl(p_offer_extended_method, hr_api.g_varchar2)
2399: then
2400: --
2401: hr_utility.set_location(l_proc,70);
2394: or p_offer_extended_method is null
2395: then
2396: if
2397: nvl(l_offer_old_rec.offer_extended_method, hr_api.g_varchar2) <>
2398: nvl(p_offer_extended_method, hr_api.g_varchar2)
2399: then
2400: --
2401: hr_utility.set_location(l_proc,70);
2402: --
2403: l_update_count := l_update_count + 1;
2404: end if;
2405: end if;
2406:
2407: if(p_expiry_date <> hr_api.g_date)
2408: or p_expiry_date is null
2409: then
2410: if
2411: nvl(l_offer_old_rec.expiry_date, hr_api.g_date) <>
2407: if(p_expiry_date <> hr_api.g_date)
2408: or p_expiry_date is null
2409: then
2410: if
2411: nvl(l_offer_old_rec.expiry_date, hr_api.g_date) <>
2412: nvl(p_expiry_date, hr_api.g_date)
2413: then
2414: --
2415: hr_utility.set_location(l_proc,90);
2408: or p_expiry_date is null
2409: then
2410: if
2411: nvl(l_offer_old_rec.expiry_date, hr_api.g_date) <>
2412: nvl(p_expiry_date, hr_api.g_date)
2413: then
2414: --
2415: hr_utility.set_location(l_proc,90);
2416: --
2417: l_update_count := l_update_count + 1;
2418: end if;
2419: end if;
2420:
2421: if(p_proposed_start_date <> hr_api.g_date)
2422: or p_proposed_start_date is null
2423: then
2424: if
2425: nvl(l_offer_old_rec.proposed_start_date, hr_api.g_date) <>
2421: if(p_proposed_start_date <> hr_api.g_date)
2422: or p_proposed_start_date is null
2423: then
2424: if
2425: nvl(l_offer_old_rec.proposed_start_date, hr_api.g_date) <>
2426: nvl(p_proposed_start_date, hr_api.g_date)
2427: then
2428: --
2429: hr_utility.set_location(l_proc,100);
2422: or p_proposed_start_date is null
2423: then
2424: if
2425: nvl(l_offer_old_rec.proposed_start_date, hr_api.g_date) <>
2426: nvl(p_proposed_start_date, hr_api.g_date)
2427: then
2428: --
2429: hr_utility.set_location(l_proc,100);
2430: --
2431: l_update_count := l_update_count + 1;
2432: end if;
2433: end if;
2434: --
2435: if(p_offer_letter_tracking_code <> hr_api.g_varchar2)
2436: or p_offer_letter_tracking_code is null
2437: then
2438: if
2439: nvl(l_offer_old_rec.offer_letter_tracking_code, hr_api.g_varchar2) <>
2435: if(p_offer_letter_tracking_code <> hr_api.g_varchar2)
2436: or p_offer_letter_tracking_code is null
2437: then
2438: if
2439: nvl(l_offer_old_rec.offer_letter_tracking_code, hr_api.g_varchar2) <>
2440: nvl(p_offer_letter_tracking_code, hr_api.g_varchar2)
2441: then
2442: --
2443: hr_utility.set_location(l_proc,110);
2436: or p_offer_letter_tracking_code is null
2437: then
2438: if
2439: nvl(l_offer_old_rec.offer_letter_tracking_code, hr_api.g_varchar2) <>
2440: nvl(p_offer_letter_tracking_code, hr_api.g_varchar2)
2441: then
2442: --
2443: hr_utility.set_location(l_proc,110);
2444: --
2445: l_update_count := l_update_count + 1;
2446: end if;
2447: end if;
2448:
2449: if(p_offer_postal_service <> hr_api.g_varchar2)
2450: or p_offer_postal_service is null
2451: then
2452: if
2453: nvl(l_offer_old_rec.offer_postal_service, hr_api.g_varchar2) <>
2449: if(p_offer_postal_service <> hr_api.g_varchar2)
2450: or p_offer_postal_service is null
2451: then
2452: if
2453: nvl(l_offer_old_rec.offer_postal_service, hr_api.g_varchar2) <>
2454: nvl(p_offer_postal_service, hr_api.g_varchar2)
2455: then
2456: --
2457: hr_utility.set_location(l_proc,120);
2450: or p_offer_postal_service is null
2451: then
2452: if
2453: nvl(l_offer_old_rec.offer_postal_service, hr_api.g_varchar2) <>
2454: nvl(p_offer_postal_service, hr_api.g_varchar2)
2455: then
2456: --
2457: hr_utility.set_location(l_proc,120);
2458: --
2459: l_update_count := l_update_count + 1;
2460: end if;
2461: end if;
2462:
2463: if(p_offer_shipping_date <> hr_api.g_date)
2464: or p_offer_shipping_date is null
2465: then
2466: if
2467: nvl(l_offer_old_rec.offer_shipping_date, hr_api.g_date) <>
2463: if(p_offer_shipping_date <> hr_api.g_date)
2464: or p_offer_shipping_date is null
2465: then
2466: if
2467: nvl(l_offer_old_rec.offer_shipping_date, hr_api.g_date) <>
2468: nvl(p_offer_shipping_date, hr_api.g_date)
2469: then
2470: --
2471: hr_utility.set_location(l_proc,130);
2464: or p_offer_shipping_date is null
2465: then
2466: if
2467: nvl(l_offer_old_rec.offer_shipping_date, hr_api.g_date) <>
2468: nvl(p_offer_shipping_date, hr_api.g_date)
2469: then
2470: --
2471: hr_utility.set_location(l_proc,130);
2472: --
2474: end if;
2475: end if;
2476: --
2477:
2478: if(p_applicant_assignment_id <> hr_api.g_number) then
2479: if
2480: nvl(l_offer_old_rec.applicant_assignment_id, hr_api.g_number) <>
2481: nvl(p_applicant_assignment_id, hr_api.g_number)
2482: then
2476: --
2477:
2478: if(p_applicant_assignment_id <> hr_api.g_number) then
2479: if
2480: nvl(l_offer_old_rec.applicant_assignment_id, hr_api.g_number) <>
2481: nvl(p_applicant_assignment_id, hr_api.g_number)
2482: then
2483: --
2484: hr_utility.set_location(l_proc,150);
2477:
2478: if(p_applicant_assignment_id <> hr_api.g_number) then
2479: if
2480: nvl(l_offer_old_rec.applicant_assignment_id, hr_api.g_number) <>
2481: nvl(p_applicant_assignment_id, hr_api.g_number)
2482: then
2483: --
2484: hr_utility.set_location(l_proc,150);
2485: --
2486: l_update_count := l_update_count + 1;
2487: end if;
2488: end if;
2489:
2490: if(p_offer_assignment_id <> hr_api.g_number) then
2491: if
2492: nvl(l_offer_old_rec.offer_assignment_id, hr_api.g_number) <>
2493: nvl(p_offer_assignment_id, hr_api.g_number)
2494: then
2488: end if;
2489:
2490: if(p_offer_assignment_id <> hr_api.g_number) then
2491: if
2492: nvl(l_offer_old_rec.offer_assignment_id, hr_api.g_number) <>
2493: nvl(p_offer_assignment_id, hr_api.g_number)
2494: then
2495: --
2496: hr_utility.set_location(l_proc,160);
2489:
2490: if(p_offer_assignment_id <> hr_api.g_number) then
2491: if
2492: nvl(l_offer_old_rec.offer_assignment_id, hr_api.g_number) <>
2493: nvl(p_offer_assignment_id, hr_api.g_number)
2494: then
2495: --
2496: hr_utility.set_location(l_proc,160);
2497: --
2498: l_update_count := l_update_count + 1;
2499: end if;
2500: end if;
2501:
2502: if(p_address_id <> hr_api.g_number)
2503: or p_address_id is null
2504: then
2505: if
2506: nvl(l_offer_old_rec.address_id, hr_api.g_number) <>
2502: if(p_address_id <> hr_api.g_number)
2503: or p_address_id is null
2504: then
2505: if
2506: nvl(l_offer_old_rec.address_id, hr_api.g_number) <>
2507: nvl(p_address_id, hr_api.g_number)
2508: then
2509: --
2510: hr_utility.set_location(l_proc,170);
2503: or p_address_id is null
2504: then
2505: if
2506: nvl(l_offer_old_rec.address_id, hr_api.g_number) <>
2507: nvl(p_address_id, hr_api.g_number)
2508: then
2509: --
2510: hr_utility.set_location(l_proc,170);
2511: --
2512: l_update_count := l_update_count + 1;
2513: end if;
2514: end if;
2515:
2516: if(p_template_id <> hr_api.g_number)
2517: or p_template_id is null
2518: then
2519: if
2520: nvl(l_offer_old_rec.template_id, hr_api.g_number) <>
2516: if(p_template_id <> hr_api.g_number)
2517: or p_template_id is null
2518: then
2519: if
2520: nvl(l_offer_old_rec.template_id, hr_api.g_number) <>
2521: nvl(p_template_id, hr_api.g_number)
2522: then
2523: --
2524: hr_utility.set_location(l_proc,180);
2517: or p_template_id is null
2518: then
2519: if
2520: nvl(l_offer_old_rec.template_id, hr_api.g_number) <>
2521: nvl(p_template_id, hr_api.g_number)
2522: then
2523: --
2524: hr_utility.set_location(l_proc,180);
2525: --
2526: l_update_count := l_update_count + 1;
2527: end if;
2528: end if;
2529:
2530: if(p_offer_letter_file_type <> hr_api.g_varchar2)
2531: or p_offer_letter_file_type is null
2532: then
2533: if
2534: nvl(l_offer_old_rec.offer_letter_file_type, hr_api.g_varchar2) <>
2530: if(p_offer_letter_file_type <> hr_api.g_varchar2)
2531: or p_offer_letter_file_type is null
2532: then
2533: if
2534: nvl(l_offer_old_rec.offer_letter_file_type, hr_api.g_varchar2) <>
2535: nvl(p_offer_letter_file_type, hr_api.g_varchar2)
2536: then
2537: --
2538: hr_utility.set_location(l_proc,190);
2531: or p_offer_letter_file_type is null
2532: then
2533: if
2534: nvl(l_offer_old_rec.offer_letter_file_type, hr_api.g_varchar2) <>
2535: nvl(p_offer_letter_file_type, hr_api.g_varchar2)
2536: then
2537: --
2538: hr_utility.set_location(l_proc,190);
2539: --
2540: l_update_count := l_update_count + 1;
2541: end if;
2542: end if;
2543:
2544: if(p_offer_letter_file_name <> hr_api.g_varchar2)
2545: or p_offer_letter_file_name is null
2546: then
2547: if
2548: nvl(l_offer_old_rec.offer_letter_file_name, hr_api.g_varchar2) <>
2544: if(p_offer_letter_file_name <> hr_api.g_varchar2)
2545: or p_offer_letter_file_name is null
2546: then
2547: if
2548: nvl(l_offer_old_rec.offer_letter_file_name, hr_api.g_varchar2) <>
2549: nvl(p_offer_letter_file_name, hr_api.g_varchar2)
2550: then
2551: --
2552: hr_utility.set_location(l_proc,200);
2545: or p_offer_letter_file_name is null
2546: then
2547: if
2548: nvl(l_offer_old_rec.offer_letter_file_name, hr_api.g_varchar2) <>
2549: nvl(p_offer_letter_file_name, hr_api.g_varchar2)
2550: then
2551: --
2552: hr_utility.set_location(l_proc,200);
2553: --
2554: l_update_count := l_update_count + 1;
2555: end if;
2556: end if;
2557:
2558: if(p_attribute_category <> hr_api.g_varchar2)
2559: or p_attribute_category is null
2560: then
2561: if
2562: nvl(l_offer_old_rec.attribute_category, hr_api.g_varchar2) <>
2558: if(p_attribute_category <> hr_api.g_varchar2)
2559: or p_attribute_category is null
2560: then
2561: if
2562: nvl(l_offer_old_rec.attribute_category, hr_api.g_varchar2) <>
2563: nvl(p_attribute_category, hr_api.g_varchar2)
2564: then
2565: --
2566: hr_utility.set_location(l_proc,210);
2559: or p_attribute_category is null
2560: then
2561: if
2562: nvl(l_offer_old_rec.attribute_category, hr_api.g_varchar2) <>
2563: nvl(p_attribute_category, hr_api.g_varchar2)
2564: then
2565: --
2566: hr_utility.set_location(l_proc,210);
2567: --
2568: l_update_count := l_update_count + 1;
2569: end if;
2570: end if;
2571:
2572: if(p_attribute1 <> hr_api.g_varchar2)
2573: or p_attribute1 is null
2574: then
2575: if
2576: nvl(l_offer_old_rec.attribute1, hr_api.g_varchar2) <>
2572: if(p_attribute1 <> hr_api.g_varchar2)
2573: or p_attribute1 is null
2574: then
2575: if
2576: nvl(l_offer_old_rec.attribute1, hr_api.g_varchar2) <>
2577: nvl(p_attribute1, hr_api.g_varchar2)
2578: then
2579: --
2580: hr_utility.set_location(l_proc,220);
2573: or p_attribute1 is null
2574: then
2575: if
2576: nvl(l_offer_old_rec.attribute1, hr_api.g_varchar2) <>
2577: nvl(p_attribute1, hr_api.g_varchar2)
2578: then
2579: --
2580: hr_utility.set_location(l_proc,220);
2581: --
2582: l_update_count := l_update_count + 1;
2583: end if;
2584: end if;
2585:
2586: if(p_attribute2 <> hr_api.g_varchar2)
2587: or p_attribute2 is null
2588: then
2589: if
2590: nvl(l_offer_old_rec.attribute2, hr_api.g_varchar2) <>
2586: if(p_attribute2 <> hr_api.g_varchar2)
2587: or p_attribute2 is null
2588: then
2589: if
2590: nvl(l_offer_old_rec.attribute2, hr_api.g_varchar2) <>
2591: nvl(p_attribute2, hr_api.g_varchar2)
2592: then
2593: --
2594: hr_utility.set_location(l_proc,230);
2587: or p_attribute2 is null
2588: then
2589: if
2590: nvl(l_offer_old_rec.attribute2, hr_api.g_varchar2) <>
2591: nvl(p_attribute2, hr_api.g_varchar2)
2592: then
2593: --
2594: hr_utility.set_location(l_proc,230);
2595: --
2596: l_update_count := l_update_count + 1;
2597: end if;
2598: end if;
2599:
2600: if(p_attribute3 <> hr_api.g_varchar2)
2601: or p_attribute3 is null
2602: then
2603: if
2604: nvl(l_offer_old_rec.attribute3, hr_api.g_varchar2) <>
2600: if(p_attribute3 <> hr_api.g_varchar2)
2601: or p_attribute3 is null
2602: then
2603: if
2604: nvl(l_offer_old_rec.attribute3, hr_api.g_varchar2) <>
2605: nvl(p_attribute3, hr_api.g_varchar2)
2606: then
2607: --
2608: hr_utility.set_location(l_proc,240);
2601: or p_attribute3 is null
2602: then
2603: if
2604: nvl(l_offer_old_rec.attribute3, hr_api.g_varchar2) <>
2605: nvl(p_attribute3, hr_api.g_varchar2)
2606: then
2607: --
2608: hr_utility.set_location(l_proc,240);
2609: --
2610: l_update_count := l_update_count + 1;
2611: end if;
2612: end if;
2613:
2614: if(p_attribute4 <> hr_api.g_varchar2)
2615: or p_attribute4 is null
2616: then
2617: if
2618: nvl(l_offer_old_rec.attribute4, hr_api.g_varchar2) <>
2614: if(p_attribute4 <> hr_api.g_varchar2)
2615: or p_attribute4 is null
2616: then
2617: if
2618: nvl(l_offer_old_rec.attribute4, hr_api.g_varchar2) <>
2619: nvl(p_attribute4, hr_api.g_varchar2)
2620: then
2621: --
2622: hr_utility.set_location(l_proc,250);
2615: or p_attribute4 is null
2616: then
2617: if
2618: nvl(l_offer_old_rec.attribute4, hr_api.g_varchar2) <>
2619: nvl(p_attribute4, hr_api.g_varchar2)
2620: then
2621: --
2622: hr_utility.set_location(l_proc,250);
2623: --
2624: l_update_count := l_update_count + 1;
2625: end if;
2626: end if;
2627:
2628: if(p_attribute5 <> hr_api.g_varchar2)
2629: or p_attribute5 is null
2630: then
2631: if
2632: nvl(l_offer_old_rec.attribute5, hr_api.g_varchar2) <>
2628: if(p_attribute5 <> hr_api.g_varchar2)
2629: or p_attribute5 is null
2630: then
2631: if
2632: nvl(l_offer_old_rec.attribute5, hr_api.g_varchar2) <>
2633: nvl(p_attribute5, hr_api.g_varchar2)
2634: then
2635: --
2636: hr_utility.set_location(l_proc,260);
2629: or p_attribute5 is null
2630: then
2631: if
2632: nvl(l_offer_old_rec.attribute5, hr_api.g_varchar2) <>
2633: nvl(p_attribute5, hr_api.g_varchar2)
2634: then
2635: --
2636: hr_utility.set_location(l_proc,260);
2637: --
2638: l_update_count := l_update_count + 1;
2639: end if;
2640: end if;
2641:
2642: if(p_attribute6 <> hr_api.g_varchar2)
2643: or p_attribute6 is null
2644: then
2645: if
2646: nvl(l_offer_old_rec.attribute6, hr_api.g_varchar2) <>
2642: if(p_attribute6 <> hr_api.g_varchar2)
2643: or p_attribute6 is null
2644: then
2645: if
2646: nvl(l_offer_old_rec.attribute6, hr_api.g_varchar2) <>
2647: nvl(p_attribute6, hr_api.g_varchar2)
2648: then
2649: --
2650: hr_utility.set_location(l_proc,270);
2643: or p_attribute6 is null
2644: then
2645: if
2646: nvl(l_offer_old_rec.attribute6, hr_api.g_varchar2) <>
2647: nvl(p_attribute6, hr_api.g_varchar2)
2648: then
2649: --
2650: hr_utility.set_location(l_proc,270);
2651: --
2652: l_update_count := l_update_count + 1;
2653: end if;
2654: end if;
2655:
2656: if(p_attribute7 <> hr_api.g_varchar2)
2657: or p_attribute7 is null
2658: then
2659: if
2660: nvl(l_offer_old_rec.attribute7, hr_api.g_varchar2) <>
2656: if(p_attribute7 <> hr_api.g_varchar2)
2657: or p_attribute7 is null
2658: then
2659: if
2660: nvl(l_offer_old_rec.attribute7, hr_api.g_varchar2) <>
2661: nvl(p_attribute7, hr_api.g_varchar2)
2662: then
2663: --
2664: hr_utility.set_location(l_proc,280);
2657: or p_attribute7 is null
2658: then
2659: if
2660: nvl(l_offer_old_rec.attribute7, hr_api.g_varchar2) <>
2661: nvl(p_attribute7, hr_api.g_varchar2)
2662: then
2663: --
2664: hr_utility.set_location(l_proc,280);
2665: --
2666: l_update_count := l_update_count + 1;
2667: end if;
2668: end if;
2669:
2670: if(p_attribute8 <> hr_api.g_varchar2)
2671: or p_attribute8 is null
2672: then
2673: if
2674: nvl(l_offer_old_rec.attribute8, hr_api.g_varchar2) <>
2670: if(p_attribute8 <> hr_api.g_varchar2)
2671: or p_attribute8 is null
2672: then
2673: if
2674: nvl(l_offer_old_rec.attribute8, hr_api.g_varchar2) <>
2675: nvl(p_attribute8, hr_api.g_varchar2)
2676: then
2677: --
2678: hr_utility.set_location(l_proc,290);
2671: or p_attribute8 is null
2672: then
2673: if
2674: nvl(l_offer_old_rec.attribute8, hr_api.g_varchar2) <>
2675: nvl(p_attribute8, hr_api.g_varchar2)
2676: then
2677: --
2678: hr_utility.set_location(l_proc,290);
2679: --
2680: l_update_count := l_update_count + 1;
2681: end if;
2682: end if;
2683:
2684: if(p_attribute9 <> hr_api.g_varchar2)
2685: or p_attribute9 is null
2686: then
2687: if
2688: nvl(l_offer_old_rec.attribute9, hr_api.g_varchar2) <>
2684: if(p_attribute9 <> hr_api.g_varchar2)
2685: or p_attribute9 is null
2686: then
2687: if
2688: nvl(l_offer_old_rec.attribute9, hr_api.g_varchar2) <>
2689: nvl(p_attribute9, hr_api.g_varchar2)
2690: then
2691: --
2692: hr_utility.set_location(l_proc,300);
2685: or p_attribute9 is null
2686: then
2687: if
2688: nvl(l_offer_old_rec.attribute9, hr_api.g_varchar2) <>
2689: nvl(p_attribute9, hr_api.g_varchar2)
2690: then
2691: --
2692: hr_utility.set_location(l_proc,300);
2693: --
2694: l_update_count := l_update_count + 1;
2695: end if;
2696: end if;
2697:
2698: if(p_attribute10 <> hr_api.g_varchar2)
2699: or p_attribute10 is null
2700: then
2701: if
2702: nvl(l_offer_old_rec.attribute10, hr_api.g_varchar2) <>
2698: if(p_attribute10 <> hr_api.g_varchar2)
2699: or p_attribute10 is null
2700: then
2701: if
2702: nvl(l_offer_old_rec.attribute10, hr_api.g_varchar2) <>
2703: nvl(p_attribute10, hr_api.g_varchar2)
2704: then
2705: --
2706: hr_utility.set_location(l_proc,310);
2699: or p_attribute10 is null
2700: then
2701: if
2702: nvl(l_offer_old_rec.attribute10, hr_api.g_varchar2) <>
2703: nvl(p_attribute10, hr_api.g_varchar2)
2704: then
2705: --
2706: hr_utility.set_location(l_proc,310);
2707: --
2708: l_update_count := l_update_count + 1;
2709: end if;
2710: end if;
2711:
2712: if(p_attribute11 <> hr_api.g_varchar2)
2713: or p_attribute11 is null
2714: then
2715: if
2716: nvl(l_offer_old_rec.attribute11, hr_api.g_varchar2) <>
2712: if(p_attribute11 <> hr_api.g_varchar2)
2713: or p_attribute11 is null
2714: then
2715: if
2716: nvl(l_offer_old_rec.attribute11, hr_api.g_varchar2) <>
2717: nvl(p_attribute11, hr_api.g_varchar2)
2718: then
2719: --
2720: hr_utility.set_location(l_proc,320);
2713: or p_attribute11 is null
2714: then
2715: if
2716: nvl(l_offer_old_rec.attribute11, hr_api.g_varchar2) <>
2717: nvl(p_attribute11, hr_api.g_varchar2)
2718: then
2719: --
2720: hr_utility.set_location(l_proc,320);
2721: --
2722: l_update_count := l_update_count + 1;
2723: end if;
2724: end if;
2725:
2726: if(p_attribute12 <> hr_api.g_varchar2)
2727: or p_attribute12 is null
2728: then
2729: if
2730: nvl(l_offer_old_rec.attribute12, hr_api.g_varchar2) <>
2726: if(p_attribute12 <> hr_api.g_varchar2)
2727: or p_attribute12 is null
2728: then
2729: if
2730: nvl(l_offer_old_rec.attribute12, hr_api.g_varchar2) <>
2731: nvl(p_attribute12, hr_api.g_varchar2)
2732: then
2733: --
2734: hr_utility.set_location(l_proc,330);
2727: or p_attribute12 is null
2728: then
2729: if
2730: nvl(l_offer_old_rec.attribute12, hr_api.g_varchar2) <>
2731: nvl(p_attribute12, hr_api.g_varchar2)
2732: then
2733: --
2734: hr_utility.set_location(l_proc,330);
2735: --
2736: l_update_count := l_update_count + 1;
2737: end if;
2738: end if;
2739:
2740: if(p_attribute13 <> hr_api.g_varchar2)
2741: or p_attribute13 is null
2742: then
2743: if
2744: nvl(l_offer_old_rec.attribute13, hr_api.g_varchar2) <>
2740: if(p_attribute13 <> hr_api.g_varchar2)
2741: or p_attribute13 is null
2742: then
2743: if
2744: nvl(l_offer_old_rec.attribute13, hr_api.g_varchar2) <>
2745: nvl(p_attribute13, hr_api.g_varchar2)
2746: then
2747: --
2748: hr_utility.set_location(l_proc,340);
2741: or p_attribute13 is null
2742: then
2743: if
2744: nvl(l_offer_old_rec.attribute13, hr_api.g_varchar2) <>
2745: nvl(p_attribute13, hr_api.g_varchar2)
2746: then
2747: --
2748: hr_utility.set_location(l_proc,340);
2749: --
2750: l_update_count := l_update_count + 1;
2751: end if;
2752: end if;
2753:
2754: if(p_attribute14 <> hr_api.g_varchar2)
2755: or p_attribute14 is null
2756: then
2757: if
2758: nvl(l_offer_old_rec.attribute14, hr_api.g_varchar2) <>
2754: if(p_attribute14 <> hr_api.g_varchar2)
2755: or p_attribute14 is null
2756: then
2757: if
2758: nvl(l_offer_old_rec.attribute14, hr_api.g_varchar2) <>
2759: nvl(p_attribute14, hr_api.g_varchar2)
2760: then
2761: --
2762: hr_utility.set_location(l_proc,350);
2755: or p_attribute14 is null
2756: then
2757: if
2758: nvl(l_offer_old_rec.attribute14, hr_api.g_varchar2) <>
2759: nvl(p_attribute14, hr_api.g_varchar2)
2760: then
2761: --
2762: hr_utility.set_location(l_proc,350);
2763: --
2764: l_update_count := l_update_count + 1;
2765: end if;
2766: end if;
2767:
2768: if(p_attribute15 <> hr_api.g_varchar2)
2769: or p_attribute15 is null
2770: then
2771: if
2772: nvl(l_offer_old_rec.attribute15, hr_api.g_varchar2) <>
2768: if(p_attribute15 <> hr_api.g_varchar2)
2769: or p_attribute15 is null
2770: then
2771: if
2772: nvl(l_offer_old_rec.attribute15, hr_api.g_varchar2) <>
2773: nvl(p_attribute15, hr_api.g_varchar2)
2774: then
2775: --
2776: hr_utility.set_location(l_proc,360);
2769: or p_attribute15 is null
2770: then
2771: if
2772: nvl(l_offer_old_rec.attribute15, hr_api.g_varchar2) <>
2773: nvl(p_attribute15, hr_api.g_varchar2)
2774: then
2775: --
2776: hr_utility.set_location(l_proc,360);
2777: --
2778: l_update_count := l_update_count + 1;
2779: end if;
2780: end if;
2781:
2782: if(p_attribute16 <> hr_api.g_varchar2)
2783: or p_attribute16 is null
2784: then
2785: if
2786: nvl(l_offer_old_rec.attribute16, hr_api.g_varchar2) <>
2782: if(p_attribute16 <> hr_api.g_varchar2)
2783: or p_attribute16 is null
2784: then
2785: if
2786: nvl(l_offer_old_rec.attribute16, hr_api.g_varchar2) <>
2787: nvl(p_attribute16, hr_api.g_varchar2)
2788: then
2789: --
2790: hr_utility.set_location(l_proc,370);
2783: or p_attribute16 is null
2784: then
2785: if
2786: nvl(l_offer_old_rec.attribute16, hr_api.g_varchar2) <>
2787: nvl(p_attribute16, hr_api.g_varchar2)
2788: then
2789: --
2790: hr_utility.set_location(l_proc,370);
2791: --
2792: l_update_count := l_update_count + 1;
2793: end if;
2794: end if;
2795:
2796: if(p_attribute17 <> hr_api.g_varchar2)
2797: or p_attribute17 is null
2798: then
2799: if
2800: nvl(l_offer_old_rec.attribute17, hr_api.g_varchar2) <>
2796: if(p_attribute17 <> hr_api.g_varchar2)
2797: or p_attribute17 is null
2798: then
2799: if
2800: nvl(l_offer_old_rec.attribute17, hr_api.g_varchar2) <>
2801: nvl(p_attribute17, hr_api.g_varchar2)
2802: then
2803: --
2804: hr_utility.set_location(l_proc,380);
2797: or p_attribute17 is null
2798: then
2799: if
2800: nvl(l_offer_old_rec.attribute17, hr_api.g_varchar2) <>
2801: nvl(p_attribute17, hr_api.g_varchar2)
2802: then
2803: --
2804: hr_utility.set_location(l_proc,380);
2805: --
2806: l_update_count := l_update_count + 1;
2807: end if;
2808: end if;
2809:
2810: if(p_attribute18 <> hr_api.g_varchar2)
2811: or p_attribute18 is null
2812: then
2813: if
2814: nvl(l_offer_old_rec.attribute18, hr_api.g_varchar2) <>
2810: if(p_attribute18 <> hr_api.g_varchar2)
2811: or p_attribute18 is null
2812: then
2813: if
2814: nvl(l_offer_old_rec.attribute18, hr_api.g_varchar2) <>
2815: nvl(p_attribute18, hr_api.g_varchar2)
2816: then
2817: --
2818: hr_utility.set_location(l_proc,390);
2811: or p_attribute18 is null
2812: then
2813: if
2814: nvl(l_offer_old_rec.attribute18, hr_api.g_varchar2) <>
2815: nvl(p_attribute18, hr_api.g_varchar2)
2816: then
2817: --
2818: hr_utility.set_location(l_proc,390);
2819: --
2820: l_update_count := l_update_count + 1;
2821: end if;
2822: end if;
2823:
2824: if(p_attribute19 <> hr_api.g_varchar2)
2825: or p_attribute19 is null
2826: then
2827: if
2828: nvl(l_offer_old_rec.attribute19, hr_api.g_varchar2) <>
2824: if(p_attribute19 <> hr_api.g_varchar2)
2825: or p_attribute19 is null
2826: then
2827: if
2828: nvl(l_offer_old_rec.attribute19, hr_api.g_varchar2) <>
2829: nvl(p_attribute19, hr_api.g_varchar2)
2830: then
2831: --
2832: hr_utility.set_location(l_proc,400);
2825: or p_attribute19 is null
2826: then
2827: if
2828: nvl(l_offer_old_rec.attribute19, hr_api.g_varchar2) <>
2829: nvl(p_attribute19, hr_api.g_varchar2)
2830: then
2831: --
2832: hr_utility.set_location(l_proc,400);
2833: --
2834: l_update_count := l_update_count + 1;
2835: end if;
2836: end if;
2837:
2838: if(p_attribute20 <> hr_api.g_varchar2)
2839: or p_attribute20 is null
2840: then
2841: if
2842: nvl(l_offer_old_rec.attribute20, hr_api.g_varchar2) <>
2838: if(p_attribute20 <> hr_api.g_varchar2)
2839: or p_attribute20 is null
2840: then
2841: if
2842: nvl(l_offer_old_rec.attribute20, hr_api.g_varchar2) <>
2843: nvl(p_attribute20, hr_api.g_varchar2)
2844: then
2845: --
2846: hr_utility.set_location(l_proc,410);
2839: or p_attribute20 is null
2840: then
2841: if
2842: nvl(l_offer_old_rec.attribute20, hr_api.g_varchar2) <>
2843: nvl(p_attribute20, hr_api.g_varchar2)
2844: then
2845: --
2846: hr_utility.set_location(l_proc,410);
2847: --
2848: l_update_count := l_update_count + 1;
2849: end if;
2850: end if;
2851:
2852: if(p_attribute21 <> hr_api.g_varchar2)
2853: or p_attribute21 is null
2854: then
2855: if
2856: nvl(l_offer_old_rec.attribute21, hr_api.g_varchar2) <>
2852: if(p_attribute21 <> hr_api.g_varchar2)
2853: or p_attribute21 is null
2854: then
2855: if
2856: nvl(l_offer_old_rec.attribute21, hr_api.g_varchar2) <>
2857: nvl(p_attribute21, hr_api.g_varchar2)
2858: then
2859: --
2860: hr_utility.set_location(l_proc,420);
2853: or p_attribute21 is null
2854: then
2855: if
2856: nvl(l_offer_old_rec.attribute21, hr_api.g_varchar2) <>
2857: nvl(p_attribute21, hr_api.g_varchar2)
2858: then
2859: --
2860: hr_utility.set_location(l_proc,420);
2861: --
2862: l_update_count := l_update_count + 1;
2863: end if;
2864: end if;
2865:
2866: if(p_attribute22 <> hr_api.g_varchar2)
2867: or p_attribute22 is null
2868: then
2869: if
2870: nvl(l_offer_old_rec.attribute22, hr_api.g_varchar2) <>
2866: if(p_attribute22 <> hr_api.g_varchar2)
2867: or p_attribute22 is null
2868: then
2869: if
2870: nvl(l_offer_old_rec.attribute22, hr_api.g_varchar2) <>
2871: nvl(p_attribute22, hr_api.g_varchar2)
2872: then
2873: --
2874: hr_utility.set_location(l_proc,430);
2867: or p_attribute22 is null
2868: then
2869: if
2870: nvl(l_offer_old_rec.attribute22, hr_api.g_varchar2) <>
2871: nvl(p_attribute22, hr_api.g_varchar2)
2872: then
2873: --
2874: hr_utility.set_location(l_proc,430);
2875: --
2876: l_update_count := l_update_count + 1;
2877: end if;
2878: end if;
2879:
2880: if(p_attribute23 <> hr_api.g_varchar2)
2881: or p_attribute23 is null
2882: then
2883: if
2884: nvl(l_offer_old_rec.attribute23, hr_api.g_varchar2) <>
2880: if(p_attribute23 <> hr_api.g_varchar2)
2881: or p_attribute23 is null
2882: then
2883: if
2884: nvl(l_offer_old_rec.attribute23, hr_api.g_varchar2) <>
2885: nvl(p_attribute23, hr_api.g_varchar2)
2886: then
2887: --
2888: hr_utility.set_location(l_proc,440);
2881: or p_attribute23 is null
2882: then
2883: if
2884: nvl(l_offer_old_rec.attribute23, hr_api.g_varchar2) <>
2885: nvl(p_attribute23, hr_api.g_varchar2)
2886: then
2887: --
2888: hr_utility.set_location(l_proc,440);
2889: --
2890: l_update_count := l_update_count + 1;
2891: end if;
2892: end if;
2893:
2894: if(p_attribute24 <> hr_api.g_varchar2)
2895: or p_attribute24 is null
2896: then
2897: if
2898: nvl(l_offer_old_rec.attribute24, hr_api.g_varchar2) <>
2894: if(p_attribute24 <> hr_api.g_varchar2)
2895: or p_attribute24 is null
2896: then
2897: if
2898: nvl(l_offer_old_rec.attribute24, hr_api.g_varchar2) <>
2899: nvl(p_attribute24, hr_api.g_varchar2)
2900: then
2901: --
2902: hr_utility.set_location(l_proc,450);
2895: or p_attribute24 is null
2896: then
2897: if
2898: nvl(l_offer_old_rec.attribute24, hr_api.g_varchar2) <>
2899: nvl(p_attribute24, hr_api.g_varchar2)
2900: then
2901: --
2902: hr_utility.set_location(l_proc,450);
2903: --
2904: l_update_count := l_update_count + 1;
2905: end if;
2906: end if;
2907:
2908: if(p_attribute25 <> hr_api.g_varchar2)
2909: or p_attribute25 is null
2910: then
2911: if
2912: nvl(l_offer_old_rec.attribute25, hr_api.g_varchar2) <>
2908: if(p_attribute25 <> hr_api.g_varchar2)
2909: or p_attribute25 is null
2910: then
2911: if
2912: nvl(l_offer_old_rec.attribute25, hr_api.g_varchar2) <>
2913: nvl(p_attribute25, hr_api.g_varchar2)
2914: then
2915: --
2916: hr_utility.set_location(l_proc,460);
2909: or p_attribute25 is null
2910: then
2911: if
2912: nvl(l_offer_old_rec.attribute25, hr_api.g_varchar2) <>
2913: nvl(p_attribute25, hr_api.g_varchar2)
2914: then
2915: --
2916: hr_utility.set_location(l_proc,460);
2917: --
2918: l_update_count := l_update_count + 1;
2919: end if;
2920: end if;
2921:
2922: if(p_attribute26 <> hr_api.g_varchar2)
2923: or p_attribute26 is null
2924: then
2925: if
2926: nvl(l_offer_old_rec.attribute26, hr_api.g_varchar2) <>
2922: if(p_attribute26 <> hr_api.g_varchar2)
2923: or p_attribute26 is null
2924: then
2925: if
2926: nvl(l_offer_old_rec.attribute26, hr_api.g_varchar2) <>
2927: nvl(p_attribute26, hr_api.g_varchar2)
2928: then
2929: --
2930: hr_utility.set_location(l_proc,470);
2923: or p_attribute26 is null
2924: then
2925: if
2926: nvl(l_offer_old_rec.attribute26, hr_api.g_varchar2) <>
2927: nvl(p_attribute26, hr_api.g_varchar2)
2928: then
2929: --
2930: hr_utility.set_location(l_proc,470);
2931: --
2932: l_update_count := l_update_count + 1;
2933: end if;
2934: end if;
2935:
2936: if(p_attribute27 <> hr_api.g_varchar2)
2937: or p_attribute27 is null
2938: then
2939: if
2940: nvl(l_offer_old_rec.attribute27, hr_api.g_varchar2) <>
2936: if(p_attribute27 <> hr_api.g_varchar2)
2937: or p_attribute27 is null
2938: then
2939: if
2940: nvl(l_offer_old_rec.attribute27, hr_api.g_varchar2) <>
2941: nvl(p_attribute27, hr_api.g_varchar2)
2942: then
2943: --
2944: hr_utility.set_location(l_proc,480);
2937: or p_attribute27 is null
2938: then
2939: if
2940: nvl(l_offer_old_rec.attribute27, hr_api.g_varchar2) <>
2941: nvl(p_attribute27, hr_api.g_varchar2)
2942: then
2943: --
2944: hr_utility.set_location(l_proc,480);
2945: --
2946: l_update_count := l_update_count + 1;
2947: end if;
2948: end if;
2949:
2950: if(p_attribute28 <> hr_api.g_varchar2)
2951: or p_attribute28 is null
2952: then
2953: if
2954: nvl(l_offer_old_rec.attribute28, hr_api.g_varchar2) <>
2950: if(p_attribute28 <> hr_api.g_varchar2)
2951: or p_attribute28 is null
2952: then
2953: if
2954: nvl(l_offer_old_rec.attribute28, hr_api.g_varchar2) <>
2955: nvl(p_attribute28, hr_api.g_varchar2)
2956: then
2957: --
2958: hr_utility.set_location(l_proc,490);
2951: or p_attribute28 is null
2952: then
2953: if
2954: nvl(l_offer_old_rec.attribute28, hr_api.g_varchar2) <>
2955: nvl(p_attribute28, hr_api.g_varchar2)
2956: then
2957: --
2958: hr_utility.set_location(l_proc,490);
2959: --
2960: l_update_count := l_update_count + 1;
2961: end if;
2962: end if;
2963:
2964: if(p_attribute29 <> hr_api.g_varchar2)
2965: or p_attribute29 is null
2966: then
2967: if
2968: nvl(l_offer_old_rec.attribute29, hr_api.g_varchar2) <>
2964: if(p_attribute29 <> hr_api.g_varchar2)
2965: or p_attribute29 is null
2966: then
2967: if
2968: nvl(l_offer_old_rec.attribute29, hr_api.g_varchar2) <>
2969: nvl(p_attribute29, hr_api.g_varchar2)
2970: then
2971: --
2972: hr_utility.set_location(l_proc,500);
2965: or p_attribute29 is null
2966: then
2967: if
2968: nvl(l_offer_old_rec.attribute29, hr_api.g_varchar2) <>
2969: nvl(p_attribute29, hr_api.g_varchar2)
2970: then
2971: --
2972: hr_utility.set_location(l_proc,500);
2973: --
2974: l_update_count := l_update_count + 1;
2975: end if;
2976: end if;
2977:
2978: if(p_attribute30 <> hr_api.g_varchar2)
2979: or p_attribute30 is null
2980: then
2981: if
2982: nvl(l_offer_old_rec.attribute30, hr_api.g_varchar2) <>
2978: if(p_attribute30 <> hr_api.g_varchar2)
2979: or p_attribute30 is null
2980: then
2981: if
2982: nvl(l_offer_old_rec.attribute30, hr_api.g_varchar2) <>
2983: nvl(p_attribute30, hr_api.g_varchar2)
2984: then
2985: --
2986: hr_utility.set_location(l_proc,510);
2979: or p_attribute30 is null
2980: then
2981: if
2982: nvl(l_offer_old_rec.attribute30, hr_api.g_varchar2) <>
2983: nvl(p_attribute30, hr_api.g_varchar2)
2984: then
2985: --
2986: hr_utility.set_location(l_proc,510);
2987: --
3060: ) then
3061: --
3062: -- Check mandatory parameters have been set
3063: --
3064: hr_api.mandatory_arg_error
3065: (p_api_name => l_proc
3066: ,p_argument => 'effective_date'
3067: ,p_argument_value => p_effective_date
3068: );
3075: (p_offer_id => p_offer_id
3076: ,p_object_version_number => p_object_version_number);
3077: --
3078: if ((l_api_updating
3079: and nvl(irc_iof_shd.g_old_rec.offer_extended_method, hr_api.g_varchar2) <>
3080: nvl(p_offer_extended_method, hr_api.g_varchar2))
3081: or
3082: (NOT l_api_updating)) then
3083: --
3076: ,p_object_version_number => p_object_version_number);
3077: --
3078: if ((l_api_updating
3079: and nvl(irc_iof_shd.g_old_rec.offer_extended_method, hr_api.g_varchar2) <>
3080: nvl(p_offer_extended_method, hr_api.g_varchar2))
3081: or
3082: (NOT l_api_updating)) then
3083: --
3084: -- Check if offer_extended_method is not null.
3090: -- Checks that the value for offer_extended_method is
3091: -- valid and exists on irc_offer_extended_method lookup
3092: -- within the specified date range
3093: --
3094: if hr_api.not_exists_in_hr_lookups
3095: (p_effective_date => p_effective_date
3096: ,p_lookup_type => 'IRC_OFFER_EXTENDED_METHOD'
3097: ,p_lookup_code => p_offer_extended_method
3098: ) then
3164: ) then
3165: --
3166: -- Check mandatory parameters have been set
3167: --
3168: hr_api.mandatory_arg_error
3169: (p_api_name => l_proc
3170: ,p_argument => 'effective_date'
3171: ,p_argument_value => p_effective_date
3172: );
3179: (p_offer_id => p_offer_id
3180: ,p_object_version_number => p_object_version_number);
3181: --
3182: if ((l_api_updating
3183: and nvl(irc_iof_shd.g_old_rec.offer_postal_service, hr_api.g_varchar2) <>
3184: nvl(p_offer_postal_service, hr_api.g_varchar2))
3185: or
3186: (NOT l_api_updating)) then
3187: --
3180: ,p_object_version_number => p_object_version_number);
3181: --
3182: if ((l_api_updating
3183: and nvl(irc_iof_shd.g_old_rec.offer_postal_service, hr_api.g_varchar2) <>
3184: nvl(p_offer_postal_service, hr_api.g_varchar2))
3185: or
3186: (NOT l_api_updating)) then
3187: --
3188: -- Check if offer_postal_service is not null.
3194: -- Checks that the value for offer_postal_service is
3195: -- valid and exists on IRC_OFFER_POSTAL_SERVICE lookup
3196: -- within the specified date range
3197: --
3198: if hr_api.not_exists_in_hr_lookups
3199: (p_effective_date => p_effective_date
3200: ,p_lookup_type => 'IRC_OFFER_POSTAL_SERVICE'
3201: ,p_lookup_code => p_offer_postal_service
3202: ) then
3268: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
3269: ) then
3270: --
3271: if p_offer_status = 'APPROVED'
3272: and nvl(irc_iof_shd.g_old_rec.offer_status, hr_api.g_varchar2) <>
3273: nvl(p_offer_status, hr_api.g_varchar2)
3274: then
3275: --
3276: hr_utility.set_location(l_proc, 20);
3269: ) then
3270: --
3271: if p_offer_status = 'APPROVED'
3272: and nvl(irc_iof_shd.g_old_rec.offer_status, hr_api.g_varchar2) <>
3273: nvl(p_offer_status, hr_api.g_varchar2)
3274: then
3275: --
3276: hr_utility.set_location(l_proc, 20);
3277: --
3365: ) then
3366: --
3367: -- Check mandatory parameters have been set
3368: --
3369: hr_api.mandatory_arg_error
3370: (p_api_name => l_proc
3371: ,p_argument => 'effective_date'
3372: ,p_argument_value => p_effective_date
3373: );
3380: (p_offer_id => p_offer_id
3381: ,p_object_version_number => p_object_version_number);
3382: --
3383: if ((l_api_updating
3384: and nvl(irc_iof_shd.g_old_rec.offer_letter_file_type, hr_api.g_varchar2) <>
3385: nvl(p_offer_letter_file_type, hr_api.g_varchar2))
3386: or
3387: (NOT l_api_updating)) then
3388: --
3381: ,p_object_version_number => p_object_version_number);
3382: --
3383: if ((l_api_updating
3384: and nvl(irc_iof_shd.g_old_rec.offer_letter_file_type, hr_api.g_varchar2) <>
3385: nvl(p_offer_letter_file_type, hr_api.g_varchar2))
3386: or
3387: (NOT l_api_updating)) then
3388: --
3389: -- Check if offer_postal_service is not null.
3395: -- Checks that the value for offer_postal_service is
3396: -- valid and exists on IRC_OFFER_POSTAL_SERVICE lookup
3397: -- within the specified date range
3398: --
3399: if hr_api.not_exists_in_fnd_lookups
3400: (p_effective_date => p_effective_date
3401: ,p_lookup_type => 'XDO_OUTPUT_TYPE'
3402: ,p_lookup_code => p_offer_letter_file_type
3403: ) then