137: -- Internal Row Handler Use Only.
138: --
139: -- ----------------------------------------------------------------------------
140: procedure chk_ddf
141: (p_rec in hr_wnp_shd.g_rec_type
142: ) is
143: --
144: l_proc varchar2(72) := g_package || 'chk_ddf';
145: --
146: begin
147: hr_utility.set_location('Entering:'||l_proc,10);
148: --
149: if ((p_rec.window_property_id is not null) and (
150: nvl(hr_wnp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
151: nvl(p_rec.information_category, hr_api.g_varchar2) or
152: nvl(hr_wnp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
153: nvl(p_rec.information1, hr_api.g_varchar2) or
154: nvl(hr_wnp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
148: --
149: if ((p_rec.window_property_id is not null) and (
150: nvl(hr_wnp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
151: nvl(p_rec.information_category, hr_api.g_varchar2) or
152: nvl(hr_wnp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
153: nvl(p_rec.information1, hr_api.g_varchar2) or
154: nvl(hr_wnp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
155: nvl(p_rec.information2, hr_api.g_varchar2) or
156: nvl(hr_wnp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
150: nvl(hr_wnp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
151: nvl(p_rec.information_category, hr_api.g_varchar2) or
152: nvl(hr_wnp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
153: nvl(p_rec.information1, hr_api.g_varchar2) or
154: nvl(hr_wnp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
155: nvl(p_rec.information2, hr_api.g_varchar2) or
156: nvl(hr_wnp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
157: nvl(p_rec.information3, hr_api.g_varchar2) or
158: nvl(hr_wnp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
152: nvl(hr_wnp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
153: nvl(p_rec.information1, hr_api.g_varchar2) or
154: nvl(hr_wnp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
155: nvl(p_rec.information2, hr_api.g_varchar2) or
156: nvl(hr_wnp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
157: nvl(p_rec.information3, hr_api.g_varchar2) or
158: nvl(hr_wnp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
159: nvl(p_rec.information4, hr_api.g_varchar2) or
160: nvl(hr_wnp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
154: nvl(hr_wnp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
155: nvl(p_rec.information2, hr_api.g_varchar2) or
156: nvl(hr_wnp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
157: nvl(p_rec.information3, hr_api.g_varchar2) or
158: nvl(hr_wnp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
159: nvl(p_rec.information4, hr_api.g_varchar2) or
160: nvl(hr_wnp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
161: nvl(p_rec.information5, hr_api.g_varchar2) or
162: nvl(hr_wnp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
156: nvl(hr_wnp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
157: nvl(p_rec.information3, hr_api.g_varchar2) or
158: nvl(hr_wnp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
159: nvl(p_rec.information4, hr_api.g_varchar2) or
160: nvl(hr_wnp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
161: nvl(p_rec.information5, hr_api.g_varchar2) or
162: nvl(hr_wnp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
163: nvl(p_rec.information6, hr_api.g_varchar2) or
164: nvl(hr_wnp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
158: nvl(hr_wnp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
159: nvl(p_rec.information4, hr_api.g_varchar2) or
160: nvl(hr_wnp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
161: nvl(p_rec.information5, hr_api.g_varchar2) or
162: nvl(hr_wnp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
163: nvl(p_rec.information6, hr_api.g_varchar2) or
164: nvl(hr_wnp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
165: nvl(p_rec.information7, hr_api.g_varchar2) or
166: nvl(hr_wnp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
160: nvl(hr_wnp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
161: nvl(p_rec.information5, hr_api.g_varchar2) or
162: nvl(hr_wnp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
163: nvl(p_rec.information6, hr_api.g_varchar2) or
164: nvl(hr_wnp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
165: nvl(p_rec.information7, hr_api.g_varchar2) or
166: nvl(hr_wnp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
167: nvl(p_rec.information8, hr_api.g_varchar2) or
168: nvl(hr_wnp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
162: nvl(hr_wnp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
163: nvl(p_rec.information6, hr_api.g_varchar2) or
164: nvl(hr_wnp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
165: nvl(p_rec.information7, hr_api.g_varchar2) or
166: nvl(hr_wnp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
167: nvl(p_rec.information8, hr_api.g_varchar2) or
168: nvl(hr_wnp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
169: nvl(p_rec.information9, hr_api.g_varchar2) or
170: nvl(hr_wnp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
164: nvl(hr_wnp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
165: nvl(p_rec.information7, hr_api.g_varchar2) or
166: nvl(hr_wnp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
167: nvl(p_rec.information8, hr_api.g_varchar2) or
168: nvl(hr_wnp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
169: nvl(p_rec.information9, hr_api.g_varchar2) or
170: nvl(hr_wnp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
171: nvl(p_rec.information10, hr_api.g_varchar2) or
172: nvl(hr_wnp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
166: nvl(hr_wnp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
167: nvl(p_rec.information8, hr_api.g_varchar2) or
168: nvl(hr_wnp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
169: nvl(p_rec.information9, hr_api.g_varchar2) or
170: nvl(hr_wnp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
171: nvl(p_rec.information10, hr_api.g_varchar2) or
172: nvl(hr_wnp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
173: nvl(p_rec.information11, hr_api.g_varchar2) or
174: nvl(hr_wnp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
168: nvl(hr_wnp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
169: nvl(p_rec.information9, hr_api.g_varchar2) or
170: nvl(hr_wnp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
171: nvl(p_rec.information10, hr_api.g_varchar2) or
172: nvl(hr_wnp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
173: nvl(p_rec.information11, hr_api.g_varchar2) or
174: nvl(hr_wnp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
175: nvl(p_rec.information12, hr_api.g_varchar2) or
176: nvl(hr_wnp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
170: nvl(hr_wnp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
171: nvl(p_rec.information10, hr_api.g_varchar2) or
172: nvl(hr_wnp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
173: nvl(p_rec.information11, hr_api.g_varchar2) or
174: nvl(hr_wnp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
175: nvl(p_rec.information12, hr_api.g_varchar2) or
176: nvl(hr_wnp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
177: nvl(p_rec.information13, hr_api.g_varchar2) or
178: nvl(hr_wnp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
172: nvl(hr_wnp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
173: nvl(p_rec.information11, hr_api.g_varchar2) or
174: nvl(hr_wnp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
175: nvl(p_rec.information12, hr_api.g_varchar2) or
176: nvl(hr_wnp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
177: nvl(p_rec.information13, hr_api.g_varchar2) or
178: nvl(hr_wnp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
179: nvl(p_rec.information14, hr_api.g_varchar2) or
180: nvl(hr_wnp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
174: nvl(hr_wnp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
175: nvl(p_rec.information12, hr_api.g_varchar2) or
176: nvl(hr_wnp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
177: nvl(p_rec.information13, hr_api.g_varchar2) or
178: nvl(hr_wnp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
179: nvl(p_rec.information14, hr_api.g_varchar2) or
180: nvl(hr_wnp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
181: nvl(p_rec.information15, hr_api.g_varchar2) or
182: nvl(hr_wnp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
176: nvl(hr_wnp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
177: nvl(p_rec.information13, hr_api.g_varchar2) or
178: nvl(hr_wnp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
179: nvl(p_rec.information14, hr_api.g_varchar2) or
180: nvl(hr_wnp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
181: nvl(p_rec.information15, hr_api.g_varchar2) or
182: nvl(hr_wnp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
183: nvl(p_rec.information16, hr_api.g_varchar2) or
184: nvl(hr_wnp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
178: nvl(hr_wnp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
179: nvl(p_rec.information14, hr_api.g_varchar2) or
180: nvl(hr_wnp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
181: nvl(p_rec.information15, hr_api.g_varchar2) or
182: nvl(hr_wnp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
183: nvl(p_rec.information16, hr_api.g_varchar2) or
184: nvl(hr_wnp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
185: nvl(p_rec.information17, hr_api.g_varchar2) or
186: nvl(hr_wnp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
180: nvl(hr_wnp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
181: nvl(p_rec.information15, hr_api.g_varchar2) or
182: nvl(hr_wnp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
183: nvl(p_rec.information16, hr_api.g_varchar2) or
184: nvl(hr_wnp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
185: nvl(p_rec.information17, hr_api.g_varchar2) or
186: nvl(hr_wnp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
187: nvl(p_rec.information18, hr_api.g_varchar2) or
188: nvl(hr_wnp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
182: nvl(hr_wnp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
183: nvl(p_rec.information16, hr_api.g_varchar2) or
184: nvl(hr_wnp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
185: nvl(p_rec.information17, hr_api.g_varchar2) or
186: nvl(hr_wnp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
187: nvl(p_rec.information18, hr_api.g_varchar2) or
188: nvl(hr_wnp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
189: nvl(p_rec.information19, hr_api.g_varchar2) or
190: nvl(hr_wnp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
184: nvl(hr_wnp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
185: nvl(p_rec.information17, hr_api.g_varchar2) or
186: nvl(hr_wnp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
187: nvl(p_rec.information18, hr_api.g_varchar2) or
188: nvl(hr_wnp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
189: nvl(p_rec.information19, hr_api.g_varchar2) or
190: nvl(hr_wnp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
191: nvl(p_rec.information20, hr_api.g_varchar2) or
192: nvl(hr_wnp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
186: nvl(hr_wnp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
187: nvl(p_rec.information18, hr_api.g_varchar2) or
188: nvl(hr_wnp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
189: nvl(p_rec.information19, hr_api.g_varchar2) or
190: nvl(hr_wnp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
191: nvl(p_rec.information20, hr_api.g_varchar2) or
192: nvl(hr_wnp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
193: nvl(p_rec.information21, hr_api.g_varchar2) or
194: nvl(hr_wnp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
188: nvl(hr_wnp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
189: nvl(p_rec.information19, hr_api.g_varchar2) or
190: nvl(hr_wnp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
191: nvl(p_rec.information20, hr_api.g_varchar2) or
192: nvl(hr_wnp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
193: nvl(p_rec.information21, hr_api.g_varchar2) or
194: nvl(hr_wnp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
195: nvl(p_rec.information22, hr_api.g_varchar2) or
196: nvl(hr_wnp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
190: nvl(hr_wnp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
191: nvl(p_rec.information20, hr_api.g_varchar2) or
192: nvl(hr_wnp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
193: nvl(p_rec.information21, hr_api.g_varchar2) or
194: nvl(hr_wnp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
195: nvl(p_rec.information22, hr_api.g_varchar2) or
196: nvl(hr_wnp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
197: nvl(p_rec.information23, hr_api.g_varchar2) or
198: nvl(hr_wnp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
192: nvl(hr_wnp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
193: nvl(p_rec.information21, hr_api.g_varchar2) or
194: nvl(hr_wnp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
195: nvl(p_rec.information22, hr_api.g_varchar2) or
196: nvl(hr_wnp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
197: nvl(p_rec.information23, hr_api.g_varchar2) or
198: nvl(hr_wnp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
199: nvl(p_rec.information24, hr_api.g_varchar2) or
200: nvl(hr_wnp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
194: nvl(hr_wnp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
195: nvl(p_rec.information22, hr_api.g_varchar2) or
196: nvl(hr_wnp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
197: nvl(p_rec.information23, hr_api.g_varchar2) or
198: nvl(hr_wnp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
199: nvl(p_rec.information24, hr_api.g_varchar2) or
200: nvl(hr_wnp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
201: nvl(p_rec.information25, hr_api.g_varchar2) or
202: nvl(hr_wnp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
196: nvl(hr_wnp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
197: nvl(p_rec.information23, hr_api.g_varchar2) or
198: nvl(hr_wnp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
199: nvl(p_rec.information24, hr_api.g_varchar2) or
200: nvl(hr_wnp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
201: nvl(p_rec.information25, hr_api.g_varchar2) or
202: nvl(hr_wnp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
203: nvl(p_rec.information26, hr_api.g_varchar2) or
204: nvl(hr_wnp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
198: nvl(hr_wnp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
199: nvl(p_rec.information24, hr_api.g_varchar2) or
200: nvl(hr_wnp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
201: nvl(p_rec.information25, hr_api.g_varchar2) or
202: nvl(hr_wnp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
203: nvl(p_rec.information26, hr_api.g_varchar2) or
204: nvl(hr_wnp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
205: nvl(p_rec.information27, hr_api.g_varchar2) or
206: nvl(hr_wnp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
200: nvl(hr_wnp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
201: nvl(p_rec.information25, hr_api.g_varchar2) or
202: nvl(hr_wnp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
203: nvl(p_rec.information26, hr_api.g_varchar2) or
204: nvl(hr_wnp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
205: nvl(p_rec.information27, hr_api.g_varchar2) or
206: nvl(hr_wnp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
207: nvl(p_rec.information28, hr_api.g_varchar2) or
208: nvl(hr_wnp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
202: nvl(hr_wnp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
203: nvl(p_rec.information26, hr_api.g_varchar2) or
204: nvl(hr_wnp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
205: nvl(p_rec.information27, hr_api.g_varchar2) or
206: nvl(hr_wnp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
207: nvl(p_rec.information28, hr_api.g_varchar2) or
208: nvl(hr_wnp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
209: nvl(p_rec.information29, hr_api.g_varchar2) or
210: nvl(hr_wnp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
204: nvl(hr_wnp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
205: nvl(p_rec.information27, hr_api.g_varchar2) or
206: nvl(hr_wnp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
207: nvl(p_rec.information28, hr_api.g_varchar2) or
208: nvl(hr_wnp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
209: nvl(p_rec.information29, hr_api.g_varchar2) or
210: nvl(hr_wnp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
211: nvl(p_rec.information30, hr_api.g_varchar2) )
212: or (p_rec.window_property_id is null) ) then
206: nvl(hr_wnp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
207: nvl(p_rec.information28, hr_api.g_varchar2) or
208: nvl(hr_wnp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
209: nvl(p_rec.information29, hr_api.g_varchar2) or
210: nvl(hr_wnp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
211: nvl(p_rec.information30, hr_api.g_varchar2) )
212: or (p_rec.window_property_id is null) ) then
213: --
214: -- Only execute the validation if absolutely necessary:
313: --
314: -- {End Of Comments}
315: -- ----------------------------------------------------------------------------
316: Procedure chk_non_updateable_args
317: (p_rec in hr_wnp_shd.g_rec_type
318: ) IS
319: --
320: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
321: l_error EXCEPTION;
325: --
326: -- Only proceed with the validation if a row exists for the current
327: -- record in the HR Schema.
328: --
329: IF NOT hr_wnp_shd.api_updating
330: (p_window_property_id => p_rec.window_property_id
331: ) THEN
332: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
333: fnd_message.set_token('PROCEDURE ', l_proc);
335: fnd_message.raise_error;
336: END IF;
337: --
338: IF (nvl(p_rec.form_window_id,hr_api.g_number) <>
339: nvl(hr_wnp_shd.g_old_rec.form_window_id,hr_api.g_number)
340: ) THEN
341: l_argument := 'form_window_id';
342: RAISE l_error;
343: END IF;
342: RAISE l_error;
343: END IF;
344: --
345: IF (nvl(p_rec.template_window_id,hr_api.g_number) <>
346: nvl(hr_wnp_shd.g_old_rec.template_window_id,hr_api.g_number)
347: ) THEN
348: l_argument := 'template_window_id';
349: RAISE l_error;
350: END IF;
563: -- ----------------------------------------------------------------------------
564: -- |------------------------------< chk_delete >------------------------------|
565: -- ----------------------------------------------------------------------------
566: Procedure chk_delete
567: (p_rec in hr_wnp_shd.g_rec_type
568: ) is
569: --
570: l_proc varchar2(72) := g_package||'chk_delete';
571: --
582: -- ----------------------------------------------------------------------------
583: -- |---------------------------< insert_validate >----------------------------|
584: -- ----------------------------------------------------------------------------
585: Procedure insert_validate
586: (p_rec in hr_wnp_shd.g_rec_type
587: ) is
588: --
589: l_proc varchar2(72) := g_package||'insert_validate';
590: --
640: -- ----------------------------------------------------------------------------
641: -- |---------------------------< update_validate >----------------------------|
642: -- ----------------------------------------------------------------------------
643: Procedure update_validate
644: (p_rec in hr_wnp_shd.g_rec_type
645: ) is
646: --
647: l_proc varchar2(72) := g_package||'update_validate';
648: --
702: -- ----------------------------------------------------------------------------
703: -- |---------------------------< delete_validate >----------------------------|
704: -- ----------------------------------------------------------------------------
705: Procedure delete_validate
706: (p_rec in hr_wnp_shd.g_rec_type
707: ) is
708: --
709: l_proc varchar2(72) := g_package||'delete_validate';
710: --