61: hr_utility.set_location('Entering:'|| l_proc, 10);
62: --
63: -- Ensure that all the mandatory parameter are not null
64: --
65: hr_api.mandatory_arg_error
66: (p_api_name => l_proc
67: ,p_argument => 'form_template_id'
68: ,p_argument_value => p_form_template_id
69: );
67: ,p_argument => 'form_template_id'
68: ,p_argument_value => p_form_template_id
69: );
70: --
71: if ( nvl(hr_tmp_bus.g_form_template_id, hr_api.g_number)
72: = p_form_template_id) then
73: --
74: -- The legislation code has already been found with a previous
75: -- call to this function. Just return the value in the global
143: begin
144: hr_utility.set_location('Entering:'||l_proc,10);
145: --
146: if ((p_rec.form_template_id is not null) and (
147: nvl(hr_tmp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
148: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
149: nvl(hr_tmp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
150: nvl(p_rec.attribute1, hr_api.g_varchar2) or
151: nvl(hr_tmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
144: hr_utility.set_location('Entering:'||l_proc,10);
145: --
146: if ((p_rec.form_template_id is not null) and (
147: nvl(hr_tmp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
148: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
149: nvl(hr_tmp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
150: nvl(p_rec.attribute1, hr_api.g_varchar2) or
151: nvl(hr_tmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
152: nvl(p_rec.attribute2, hr_api.g_varchar2) or
145: --
146: if ((p_rec.form_template_id is not null) and (
147: nvl(hr_tmp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
148: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
149: nvl(hr_tmp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
150: nvl(p_rec.attribute1, hr_api.g_varchar2) or
151: nvl(hr_tmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
152: nvl(p_rec.attribute2, hr_api.g_varchar2) or
153: nvl(hr_tmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
146: if ((p_rec.form_template_id is not null) and (
147: nvl(hr_tmp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
148: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
149: nvl(hr_tmp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
150: nvl(p_rec.attribute1, hr_api.g_varchar2) or
151: nvl(hr_tmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
152: nvl(p_rec.attribute2, hr_api.g_varchar2) or
153: nvl(hr_tmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
154: nvl(p_rec.attribute3, hr_api.g_varchar2) or
147: nvl(hr_tmp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
148: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
149: nvl(hr_tmp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
150: nvl(p_rec.attribute1, hr_api.g_varchar2) or
151: nvl(hr_tmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
152: nvl(p_rec.attribute2, hr_api.g_varchar2) or
153: nvl(hr_tmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
154: nvl(p_rec.attribute3, hr_api.g_varchar2) or
155: nvl(hr_tmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
148: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
149: nvl(hr_tmp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
150: nvl(p_rec.attribute1, hr_api.g_varchar2) or
151: nvl(hr_tmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
152: nvl(p_rec.attribute2, hr_api.g_varchar2) or
153: nvl(hr_tmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
154: nvl(p_rec.attribute3, hr_api.g_varchar2) or
155: nvl(hr_tmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
156: nvl(p_rec.attribute4, hr_api.g_varchar2) or
149: nvl(hr_tmp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
150: nvl(p_rec.attribute1, hr_api.g_varchar2) or
151: nvl(hr_tmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
152: nvl(p_rec.attribute2, hr_api.g_varchar2) or
153: nvl(hr_tmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
154: nvl(p_rec.attribute3, hr_api.g_varchar2) or
155: nvl(hr_tmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
156: nvl(p_rec.attribute4, hr_api.g_varchar2) or
157: nvl(hr_tmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
150: nvl(p_rec.attribute1, hr_api.g_varchar2) or
151: nvl(hr_tmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
152: nvl(p_rec.attribute2, hr_api.g_varchar2) or
153: nvl(hr_tmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
154: nvl(p_rec.attribute3, hr_api.g_varchar2) or
155: nvl(hr_tmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
156: nvl(p_rec.attribute4, hr_api.g_varchar2) or
157: nvl(hr_tmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
158: nvl(p_rec.attribute5, hr_api.g_varchar2) or
151: nvl(hr_tmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
152: nvl(p_rec.attribute2, hr_api.g_varchar2) or
153: nvl(hr_tmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
154: nvl(p_rec.attribute3, hr_api.g_varchar2) or
155: nvl(hr_tmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
156: nvl(p_rec.attribute4, hr_api.g_varchar2) or
157: nvl(hr_tmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
158: nvl(p_rec.attribute5, hr_api.g_varchar2) or
159: nvl(hr_tmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
152: nvl(p_rec.attribute2, hr_api.g_varchar2) or
153: nvl(hr_tmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
154: nvl(p_rec.attribute3, hr_api.g_varchar2) or
155: nvl(hr_tmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
156: nvl(p_rec.attribute4, hr_api.g_varchar2) or
157: nvl(hr_tmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
158: nvl(p_rec.attribute5, hr_api.g_varchar2) or
159: nvl(hr_tmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
160: nvl(p_rec.attribute6, hr_api.g_varchar2) or
153: nvl(hr_tmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
154: nvl(p_rec.attribute3, hr_api.g_varchar2) or
155: nvl(hr_tmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
156: nvl(p_rec.attribute4, hr_api.g_varchar2) or
157: nvl(hr_tmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
158: nvl(p_rec.attribute5, hr_api.g_varchar2) or
159: nvl(hr_tmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
160: nvl(p_rec.attribute6, hr_api.g_varchar2) or
161: nvl(hr_tmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
154: nvl(p_rec.attribute3, hr_api.g_varchar2) or
155: nvl(hr_tmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
156: nvl(p_rec.attribute4, hr_api.g_varchar2) or
157: nvl(hr_tmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
158: nvl(p_rec.attribute5, hr_api.g_varchar2) or
159: nvl(hr_tmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
160: nvl(p_rec.attribute6, hr_api.g_varchar2) or
161: nvl(hr_tmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
162: nvl(p_rec.attribute7, hr_api.g_varchar2) or
155: nvl(hr_tmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
156: nvl(p_rec.attribute4, hr_api.g_varchar2) or
157: nvl(hr_tmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
158: nvl(p_rec.attribute5, hr_api.g_varchar2) or
159: nvl(hr_tmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
160: nvl(p_rec.attribute6, hr_api.g_varchar2) or
161: nvl(hr_tmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
162: nvl(p_rec.attribute7, hr_api.g_varchar2) or
163: nvl(hr_tmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
156: nvl(p_rec.attribute4, hr_api.g_varchar2) or
157: nvl(hr_tmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
158: nvl(p_rec.attribute5, hr_api.g_varchar2) or
159: nvl(hr_tmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
160: nvl(p_rec.attribute6, hr_api.g_varchar2) or
161: nvl(hr_tmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
162: nvl(p_rec.attribute7, hr_api.g_varchar2) or
163: nvl(hr_tmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
164: nvl(p_rec.attribute8, hr_api.g_varchar2) or
157: nvl(hr_tmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
158: nvl(p_rec.attribute5, hr_api.g_varchar2) or
159: nvl(hr_tmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
160: nvl(p_rec.attribute6, hr_api.g_varchar2) or
161: nvl(hr_tmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
162: nvl(p_rec.attribute7, hr_api.g_varchar2) or
163: nvl(hr_tmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
164: nvl(p_rec.attribute8, hr_api.g_varchar2) or
165: nvl(hr_tmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
158: nvl(p_rec.attribute5, hr_api.g_varchar2) or
159: nvl(hr_tmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
160: nvl(p_rec.attribute6, hr_api.g_varchar2) or
161: nvl(hr_tmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
162: nvl(p_rec.attribute7, hr_api.g_varchar2) or
163: nvl(hr_tmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
164: nvl(p_rec.attribute8, hr_api.g_varchar2) or
165: nvl(hr_tmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
166: nvl(p_rec.attribute9, hr_api.g_varchar2) or
159: nvl(hr_tmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
160: nvl(p_rec.attribute6, hr_api.g_varchar2) or
161: nvl(hr_tmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
162: nvl(p_rec.attribute7, hr_api.g_varchar2) or
163: nvl(hr_tmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
164: nvl(p_rec.attribute8, hr_api.g_varchar2) or
165: nvl(hr_tmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
166: nvl(p_rec.attribute9, hr_api.g_varchar2) or
167: nvl(hr_tmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
160: nvl(p_rec.attribute6, hr_api.g_varchar2) or
161: nvl(hr_tmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
162: nvl(p_rec.attribute7, hr_api.g_varchar2) or
163: nvl(hr_tmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
164: nvl(p_rec.attribute8, hr_api.g_varchar2) or
165: nvl(hr_tmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
166: nvl(p_rec.attribute9, hr_api.g_varchar2) or
167: nvl(hr_tmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
168: nvl(p_rec.attribute10, hr_api.g_varchar2) or
161: nvl(hr_tmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
162: nvl(p_rec.attribute7, hr_api.g_varchar2) or
163: nvl(hr_tmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
164: nvl(p_rec.attribute8, hr_api.g_varchar2) or
165: nvl(hr_tmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
166: nvl(p_rec.attribute9, hr_api.g_varchar2) or
167: nvl(hr_tmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
168: nvl(p_rec.attribute10, hr_api.g_varchar2) or
169: nvl(hr_tmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
162: nvl(p_rec.attribute7, hr_api.g_varchar2) or
163: nvl(hr_tmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
164: nvl(p_rec.attribute8, hr_api.g_varchar2) or
165: nvl(hr_tmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
166: nvl(p_rec.attribute9, hr_api.g_varchar2) or
167: nvl(hr_tmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
168: nvl(p_rec.attribute10, hr_api.g_varchar2) or
169: nvl(hr_tmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
170: nvl(p_rec.attribute11, hr_api.g_varchar2) or
163: nvl(hr_tmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
164: nvl(p_rec.attribute8, hr_api.g_varchar2) or
165: nvl(hr_tmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
166: nvl(p_rec.attribute9, hr_api.g_varchar2) or
167: nvl(hr_tmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
168: nvl(p_rec.attribute10, hr_api.g_varchar2) or
169: nvl(hr_tmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
170: nvl(p_rec.attribute11, hr_api.g_varchar2) or
171: nvl(hr_tmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
164: nvl(p_rec.attribute8, hr_api.g_varchar2) or
165: nvl(hr_tmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
166: nvl(p_rec.attribute9, hr_api.g_varchar2) or
167: nvl(hr_tmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
168: nvl(p_rec.attribute10, hr_api.g_varchar2) or
169: nvl(hr_tmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
170: nvl(p_rec.attribute11, hr_api.g_varchar2) or
171: nvl(hr_tmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
172: nvl(p_rec.attribute12, hr_api.g_varchar2) or
165: nvl(hr_tmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
166: nvl(p_rec.attribute9, hr_api.g_varchar2) or
167: nvl(hr_tmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
168: nvl(p_rec.attribute10, hr_api.g_varchar2) or
169: nvl(hr_tmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
170: nvl(p_rec.attribute11, hr_api.g_varchar2) or
171: nvl(hr_tmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
172: nvl(p_rec.attribute12, hr_api.g_varchar2) or
173: nvl(hr_tmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
166: nvl(p_rec.attribute9, hr_api.g_varchar2) or
167: nvl(hr_tmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
168: nvl(p_rec.attribute10, hr_api.g_varchar2) or
169: nvl(hr_tmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
170: nvl(p_rec.attribute11, hr_api.g_varchar2) or
171: nvl(hr_tmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
172: nvl(p_rec.attribute12, hr_api.g_varchar2) or
173: nvl(hr_tmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
174: nvl(p_rec.attribute13, hr_api.g_varchar2) or
167: nvl(hr_tmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
168: nvl(p_rec.attribute10, hr_api.g_varchar2) or
169: nvl(hr_tmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
170: nvl(p_rec.attribute11, hr_api.g_varchar2) or
171: nvl(hr_tmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
172: nvl(p_rec.attribute12, hr_api.g_varchar2) or
173: nvl(hr_tmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
174: nvl(p_rec.attribute13, hr_api.g_varchar2) or
175: nvl(hr_tmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
168: nvl(p_rec.attribute10, hr_api.g_varchar2) or
169: nvl(hr_tmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
170: nvl(p_rec.attribute11, hr_api.g_varchar2) or
171: nvl(hr_tmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
172: nvl(p_rec.attribute12, hr_api.g_varchar2) or
173: nvl(hr_tmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
174: nvl(p_rec.attribute13, hr_api.g_varchar2) or
175: nvl(hr_tmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
176: nvl(p_rec.attribute14, hr_api.g_varchar2) or
169: nvl(hr_tmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
170: nvl(p_rec.attribute11, hr_api.g_varchar2) or
171: nvl(hr_tmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
172: nvl(p_rec.attribute12, hr_api.g_varchar2) or
173: nvl(hr_tmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
174: nvl(p_rec.attribute13, hr_api.g_varchar2) or
175: nvl(hr_tmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
176: nvl(p_rec.attribute14, hr_api.g_varchar2) or
177: nvl(hr_tmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
170: nvl(p_rec.attribute11, hr_api.g_varchar2) or
171: nvl(hr_tmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
172: nvl(p_rec.attribute12, hr_api.g_varchar2) or
173: nvl(hr_tmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
174: nvl(p_rec.attribute13, hr_api.g_varchar2) or
175: nvl(hr_tmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
176: nvl(p_rec.attribute14, hr_api.g_varchar2) or
177: nvl(hr_tmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
178: nvl(p_rec.attribute15, hr_api.g_varchar2) or
171: nvl(hr_tmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
172: nvl(p_rec.attribute12, hr_api.g_varchar2) or
173: nvl(hr_tmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
174: nvl(p_rec.attribute13, hr_api.g_varchar2) or
175: nvl(hr_tmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
176: nvl(p_rec.attribute14, hr_api.g_varchar2) or
177: nvl(hr_tmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
178: nvl(p_rec.attribute15, hr_api.g_varchar2) or
179: nvl(hr_tmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
172: nvl(p_rec.attribute12, hr_api.g_varchar2) or
173: nvl(hr_tmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
174: nvl(p_rec.attribute13, hr_api.g_varchar2) or
175: nvl(hr_tmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
176: nvl(p_rec.attribute14, hr_api.g_varchar2) or
177: nvl(hr_tmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
178: nvl(p_rec.attribute15, hr_api.g_varchar2) or
179: nvl(hr_tmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
180: nvl(p_rec.attribute16, hr_api.g_varchar2) or
173: nvl(hr_tmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
174: nvl(p_rec.attribute13, hr_api.g_varchar2) or
175: nvl(hr_tmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
176: nvl(p_rec.attribute14, hr_api.g_varchar2) or
177: nvl(hr_tmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
178: nvl(p_rec.attribute15, hr_api.g_varchar2) or
179: nvl(hr_tmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
180: nvl(p_rec.attribute16, hr_api.g_varchar2) or
181: nvl(hr_tmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
174: nvl(p_rec.attribute13, hr_api.g_varchar2) or
175: nvl(hr_tmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
176: nvl(p_rec.attribute14, hr_api.g_varchar2) or
177: nvl(hr_tmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
178: nvl(p_rec.attribute15, hr_api.g_varchar2) or
179: nvl(hr_tmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
180: nvl(p_rec.attribute16, hr_api.g_varchar2) or
181: nvl(hr_tmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
182: nvl(p_rec.attribute17, hr_api.g_varchar2) or
175: nvl(hr_tmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
176: nvl(p_rec.attribute14, hr_api.g_varchar2) or
177: nvl(hr_tmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
178: nvl(p_rec.attribute15, hr_api.g_varchar2) or
179: nvl(hr_tmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
180: nvl(p_rec.attribute16, hr_api.g_varchar2) or
181: nvl(hr_tmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
182: nvl(p_rec.attribute17, hr_api.g_varchar2) or
183: nvl(hr_tmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
176: nvl(p_rec.attribute14, hr_api.g_varchar2) or
177: nvl(hr_tmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
178: nvl(p_rec.attribute15, hr_api.g_varchar2) or
179: nvl(hr_tmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
180: nvl(p_rec.attribute16, hr_api.g_varchar2) or
181: nvl(hr_tmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
182: nvl(p_rec.attribute17, hr_api.g_varchar2) or
183: nvl(hr_tmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
184: nvl(p_rec.attribute18, hr_api.g_varchar2) or
177: nvl(hr_tmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
178: nvl(p_rec.attribute15, hr_api.g_varchar2) or
179: nvl(hr_tmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
180: nvl(p_rec.attribute16, hr_api.g_varchar2) or
181: nvl(hr_tmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
182: nvl(p_rec.attribute17, hr_api.g_varchar2) or
183: nvl(hr_tmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
184: nvl(p_rec.attribute18, hr_api.g_varchar2) or
185: nvl(hr_tmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
178: nvl(p_rec.attribute15, hr_api.g_varchar2) or
179: nvl(hr_tmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
180: nvl(p_rec.attribute16, hr_api.g_varchar2) or
181: nvl(hr_tmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
182: nvl(p_rec.attribute17, hr_api.g_varchar2) or
183: nvl(hr_tmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
184: nvl(p_rec.attribute18, hr_api.g_varchar2) or
185: nvl(hr_tmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
186: nvl(p_rec.attribute19, hr_api.g_varchar2) or
179: nvl(hr_tmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
180: nvl(p_rec.attribute16, hr_api.g_varchar2) or
181: nvl(hr_tmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
182: nvl(p_rec.attribute17, hr_api.g_varchar2) or
183: nvl(hr_tmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
184: nvl(p_rec.attribute18, hr_api.g_varchar2) or
185: nvl(hr_tmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
186: nvl(p_rec.attribute19, hr_api.g_varchar2) or
187: nvl(hr_tmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
180: nvl(p_rec.attribute16, hr_api.g_varchar2) or
181: nvl(hr_tmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
182: nvl(p_rec.attribute17, hr_api.g_varchar2) or
183: nvl(hr_tmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
184: nvl(p_rec.attribute18, hr_api.g_varchar2) or
185: nvl(hr_tmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
186: nvl(p_rec.attribute19, hr_api.g_varchar2) or
187: nvl(hr_tmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
188: nvl(p_rec.attribute20, hr_api.g_varchar2) or
181: nvl(hr_tmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
182: nvl(p_rec.attribute17, hr_api.g_varchar2) or
183: nvl(hr_tmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
184: nvl(p_rec.attribute18, hr_api.g_varchar2) or
185: nvl(hr_tmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
186: nvl(p_rec.attribute19, hr_api.g_varchar2) or
187: nvl(hr_tmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
188: nvl(p_rec.attribute20, hr_api.g_varchar2) or
189: nvl(hr_tmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
182: nvl(p_rec.attribute17, hr_api.g_varchar2) or
183: nvl(hr_tmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
184: nvl(p_rec.attribute18, hr_api.g_varchar2) or
185: nvl(hr_tmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
186: nvl(p_rec.attribute19, hr_api.g_varchar2) or
187: nvl(hr_tmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
188: nvl(p_rec.attribute20, hr_api.g_varchar2) or
189: nvl(hr_tmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute21, hr_api.g_varchar2) or
183: nvl(hr_tmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
184: nvl(p_rec.attribute18, hr_api.g_varchar2) or
185: nvl(hr_tmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
186: nvl(p_rec.attribute19, hr_api.g_varchar2) or
187: nvl(hr_tmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
188: nvl(p_rec.attribute20, hr_api.g_varchar2) or
189: nvl(hr_tmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute21, hr_api.g_varchar2) or
191: nvl(hr_tmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
184: nvl(p_rec.attribute18, hr_api.g_varchar2) or
185: nvl(hr_tmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
186: nvl(p_rec.attribute19, hr_api.g_varchar2) or
187: nvl(hr_tmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
188: nvl(p_rec.attribute20, hr_api.g_varchar2) or
189: nvl(hr_tmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute21, hr_api.g_varchar2) or
191: nvl(hr_tmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute22, hr_api.g_varchar2) or
185: nvl(hr_tmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
186: nvl(p_rec.attribute19, hr_api.g_varchar2) or
187: nvl(hr_tmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
188: nvl(p_rec.attribute20, hr_api.g_varchar2) or
189: nvl(hr_tmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute21, hr_api.g_varchar2) or
191: nvl(hr_tmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute22, hr_api.g_varchar2) or
193: nvl(hr_tmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
186: nvl(p_rec.attribute19, hr_api.g_varchar2) or
187: nvl(hr_tmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
188: nvl(p_rec.attribute20, hr_api.g_varchar2) or
189: nvl(hr_tmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute21, hr_api.g_varchar2) or
191: nvl(hr_tmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute22, hr_api.g_varchar2) or
193: nvl(hr_tmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute23, hr_api.g_varchar2) or
187: nvl(hr_tmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
188: nvl(p_rec.attribute20, hr_api.g_varchar2) or
189: nvl(hr_tmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute21, hr_api.g_varchar2) or
191: nvl(hr_tmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute22, hr_api.g_varchar2) or
193: nvl(hr_tmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute23, hr_api.g_varchar2) or
195: nvl(hr_tmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
188: nvl(p_rec.attribute20, hr_api.g_varchar2) or
189: nvl(hr_tmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute21, hr_api.g_varchar2) or
191: nvl(hr_tmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute22, hr_api.g_varchar2) or
193: nvl(hr_tmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute23, hr_api.g_varchar2) or
195: nvl(hr_tmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute24, hr_api.g_varchar2) or
189: nvl(hr_tmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute21, hr_api.g_varchar2) or
191: nvl(hr_tmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute22, hr_api.g_varchar2) or
193: nvl(hr_tmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute23, hr_api.g_varchar2) or
195: nvl(hr_tmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute24, hr_api.g_varchar2) or
197: nvl(hr_tmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute21, hr_api.g_varchar2) or
191: nvl(hr_tmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute22, hr_api.g_varchar2) or
193: nvl(hr_tmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute23, hr_api.g_varchar2) or
195: nvl(hr_tmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute24, hr_api.g_varchar2) or
197: nvl(hr_tmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute25, hr_api.g_varchar2) or
191: nvl(hr_tmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute22, hr_api.g_varchar2) or
193: nvl(hr_tmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute23, hr_api.g_varchar2) or
195: nvl(hr_tmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute24, hr_api.g_varchar2) or
197: nvl(hr_tmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute25, hr_api.g_varchar2) or
199: nvl(hr_tmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute22, hr_api.g_varchar2) or
193: nvl(hr_tmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute23, hr_api.g_varchar2) or
195: nvl(hr_tmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute24, hr_api.g_varchar2) or
197: nvl(hr_tmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute25, hr_api.g_varchar2) or
199: nvl(hr_tmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute26, hr_api.g_varchar2) or
193: nvl(hr_tmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute23, hr_api.g_varchar2) or
195: nvl(hr_tmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute24, hr_api.g_varchar2) or
197: nvl(hr_tmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute25, hr_api.g_varchar2) or
199: nvl(hr_tmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute26, hr_api.g_varchar2) or
201: nvl(hr_tmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute23, hr_api.g_varchar2) or
195: nvl(hr_tmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute24, hr_api.g_varchar2) or
197: nvl(hr_tmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute25, hr_api.g_varchar2) or
199: nvl(hr_tmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute26, hr_api.g_varchar2) or
201: nvl(hr_tmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute27, hr_api.g_varchar2) or
195: nvl(hr_tmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute24, hr_api.g_varchar2) or
197: nvl(hr_tmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute25, hr_api.g_varchar2) or
199: nvl(hr_tmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute26, hr_api.g_varchar2) or
201: nvl(hr_tmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute27, hr_api.g_varchar2) or
203: nvl(hr_tmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute24, hr_api.g_varchar2) or
197: nvl(hr_tmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute25, hr_api.g_varchar2) or
199: nvl(hr_tmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute26, hr_api.g_varchar2) or
201: nvl(hr_tmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute27, hr_api.g_varchar2) or
203: nvl(hr_tmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute28, hr_api.g_varchar2) or
197: nvl(hr_tmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute25, hr_api.g_varchar2) or
199: nvl(hr_tmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute26, hr_api.g_varchar2) or
201: nvl(hr_tmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute27, hr_api.g_varchar2) or
203: nvl(hr_tmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute28, hr_api.g_varchar2) or
205: nvl(hr_tmp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute25, hr_api.g_varchar2) or
199: nvl(hr_tmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute26, hr_api.g_varchar2) or
201: nvl(hr_tmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute27, hr_api.g_varchar2) or
203: nvl(hr_tmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute28, hr_api.g_varchar2) or
205: nvl(hr_tmp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute29, hr_api.g_varchar2) or
199: nvl(hr_tmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute26, hr_api.g_varchar2) or
201: nvl(hr_tmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute27, hr_api.g_varchar2) or
203: nvl(hr_tmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute28, hr_api.g_varchar2) or
205: nvl(hr_tmp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute29, hr_api.g_varchar2) or
207: nvl(hr_tmp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute26, hr_api.g_varchar2) or
201: nvl(hr_tmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute27, hr_api.g_varchar2) or
203: nvl(hr_tmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute28, hr_api.g_varchar2) or
205: nvl(hr_tmp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute29, hr_api.g_varchar2) or
207: nvl(hr_tmp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute30, hr_api.g_varchar2) )
201: nvl(hr_tmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute27, hr_api.g_varchar2) or
203: nvl(hr_tmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute28, hr_api.g_varchar2) or
205: nvl(hr_tmp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute29, hr_api.g_varchar2) or
207: nvl(hr_tmp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute30, hr_api.g_varchar2) )
209: or (p_rec.form_template_id is null) ) then
202: nvl(p_rec.attribute27, hr_api.g_varchar2) or
203: nvl(hr_tmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute28, hr_api.g_varchar2) or
205: nvl(hr_tmp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute29, hr_api.g_varchar2) or
207: nvl(hr_tmp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute30, hr_api.g_varchar2) )
209: or (p_rec.form_template_id is null) ) then
210: --
203: nvl(hr_tmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute28, hr_api.g_varchar2) or
205: nvl(hr_tmp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute29, hr_api.g_varchar2) or
207: nvl(hr_tmp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute30, hr_api.g_varchar2) )
209: or (p_rec.form_template_id is null) ) then
210: --
211: -- Only execute the validation if absolutely necessary:
204: nvl(p_rec.attribute28, hr_api.g_varchar2) or
205: nvl(hr_tmp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute29, hr_api.g_varchar2) or
207: nvl(hr_tmp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute30, hr_api.g_varchar2) )
209: or (p_rec.form_template_id is null) ) then
210: --
211: -- Only execute the validation if absolutely necessary:
212: -- a) During update, the structure column value or any
333: fnd_message.set_token('STEP ', '5');
334: fnd_message.raise_error;
335: END IF;
336: --
337: IF (nvl(p_rec.application_id,hr_api.g_number) <>
338: nvl(hr_tmp_shd.g_old_rec.application_id,hr_api.g_number)
339: ) THEN
340: l_argument := 'application_id';
341: RAISE l_error;
334: fnd_message.raise_error;
335: END IF;
336: --
337: IF (nvl(p_rec.application_id,hr_api.g_number) <>
338: nvl(hr_tmp_shd.g_old_rec.application_id,hr_api.g_number)
339: ) THEN
340: l_argument := 'application_id';
341: RAISE l_error;
342: END IF;
340: l_argument := 'application_id';
341: RAISE l_error;
342: END IF;
343: --
344: IF (nvl(p_rec.form_id,hr_api.g_number) <>
345: nvl(hr_tmp_shd.g_old_rec.form_id,hr_api.g_number)
346: ) THEN
347: l_argument := 'form_id';
348: RAISE l_error;
341: RAISE l_error;
342: END IF;
343: --
344: IF (nvl(p_rec.form_id,hr_api.g_number) <>
345: nvl(hr_tmp_shd.g_old_rec.form_id,hr_api.g_number)
346: ) THEN
347: l_argument := 'form_id';
348: RAISE l_error;
349: END IF;
349: END IF;
350: --
351: EXCEPTION
352: WHEN l_error THEN
353: hr_api.argument_changed_error
354: (p_api_name => l_proc
355: ,p_argument => l_argument);
356: WHEN OTHERS THEN
357: RAISE;
381: hr_utility.set_location('Entering:'||l_proc, 10);
382: --
383: -- Check value has been passed
384: --
385: hr_api.mandatory_arg_error
386: (p_api_name => l_proc
387: ,p_argument => 'application_id'
388: ,p_argument_value => p_application_id
389: );
428: hr_utility.set_location('Entering:'||l_proc, 10);
429: --
430: -- Check value has been passed
431: --
432: hr_api.mandatory_arg_error
433: (p_api_name => l_proc
434: ,p_argument => 'form_id'
435: ,p_argument_value => p_form_id
436: );
510: hr_utility.set_location('Entering:'||l_proc, 10);
511: --
512: -- Check value has been passed
513: --
514: hr_api.mandatory_arg_error
515: (p_api_name => l_proc
516: ,p_argument => 'template_name'
517: ,p_argument_value => p_template_name
518: );
546: hr_utility.set_location('Entering:'||l_proc, 10);
547: --
548: -- Check mandatory arguments have been set
549: --
550: hr_api.mandatory_arg_error
551: (p_api_name => l_proc
552: ,p_argument => 'effective_date'
553: ,p_argument_value => p_effective_date
554: );
561: --
562: -- Only proceed with SQL validation if absolutely necessary
563: --
564: if ( ( l_api_updating
565: and nvl(hr_tmp_shd.g_old_rec.enabled_flag,hr_api.g_varchar2) <>
566: nvl(p_enabled_flag,hr_api.g_varchar2))
567: or (NOT l_api_updating)) then
568: --
569: hr_utility.set_location(l_proc,30);
562: -- Only proceed with SQL validation if absolutely necessary
563: --
564: if ( ( l_api_updating
565: and nvl(hr_tmp_shd.g_old_rec.enabled_flag,hr_api.g_varchar2) <>
566: nvl(p_enabled_flag,hr_api.g_varchar2))
567: or (NOT l_api_updating)) then
568: --
569: hr_utility.set_location(l_proc,30);
570: --
569: hr_utility.set_location(l_proc,30);
570: --
571: -- Check value has been passed
572: --
573: hr_api.mandatory_arg_error
574: (p_api_name => l_proc
575: ,p_argument => 'enabled_flag'
576: ,p_argument_value => p_enabled_flag
577: );
577: );
578: --
579: -- Must exist in hr_standard_lookups where lookup_type is YES_NO
580: --
581: if hr_api.not_exists_in_hrstanlookups
582: (p_effective_date => p_effective_date
583: ,p_lookup_type => 'YES_NO'
584: ,p_lookup_code => p_enabled_flag
585: ) then
627: hr_utility.set_location('Entering:'||l_proc, 5);
628: --
629: -- Check mandatory arguments have been set
630: --
631: hr_api.mandatory_arg_error
632: (p_api_name => l_proc
633: ,p_argument => 'effective_date'
634: ,p_argument_value => p_effective_date
635: );
694: hr_utility.set_location('Entering:'||l_proc, 5);
695: --
696: -- Check mandatory arguments have been set
697: --
698: hr_api.mandatory_arg_error
699: (p_api_name => l_proc
700: ,p_argument => 'effective_date'
701: ,p_argument_value => p_effective_date
702: );