eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_REQ_BUS dependencies on PER_REQ_SHD

Line 177: (p_rec in per_req_shd.g_rec_type

173: -- Internal Row Handler Use Only.
174: --
175: -- ----------------------------------------------------------------------------
176: procedure chk_df
177: (p_rec in per_req_shd.g_rec_type
178: ) is
179: --
180: l_proc varchar2(72) := g_package || 'chk_df';
181: --

Line 186: nvl(per_req_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

182: begin
183: hr_utility.set_location('Entering:'||l_proc,10);
184: --
185: if ((p_rec.requisition_id is not null) and (
186: nvl(per_req_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
187: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
188: nvl(per_req_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
189: nvl(p_rec.attribute1, hr_api.g_varchar2) or
190: nvl(per_req_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 188: nvl(per_req_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

184: --
185: if ((p_rec.requisition_id is not null) and (
186: nvl(per_req_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
187: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
188: nvl(per_req_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
189: nvl(p_rec.attribute1, hr_api.g_varchar2) or
190: nvl(per_req_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
191: nvl(p_rec.attribute2, hr_api.g_varchar2) or
192: nvl(per_req_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 190: nvl(per_req_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

186: nvl(per_req_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
187: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
188: nvl(per_req_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
189: nvl(p_rec.attribute1, hr_api.g_varchar2) or
190: nvl(per_req_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
191: nvl(p_rec.attribute2, hr_api.g_varchar2) or
192: nvl(per_req_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
193: nvl(p_rec.attribute3, hr_api.g_varchar2) or
194: nvl(per_req_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 192: nvl(per_req_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

188: nvl(per_req_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
189: nvl(p_rec.attribute1, hr_api.g_varchar2) or
190: nvl(per_req_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
191: nvl(p_rec.attribute2, hr_api.g_varchar2) or
192: nvl(per_req_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
193: nvl(p_rec.attribute3, hr_api.g_varchar2) or
194: nvl(per_req_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
195: nvl(p_rec.attribute4, hr_api.g_varchar2) or
196: nvl(per_req_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 194: nvl(per_req_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

190: nvl(per_req_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
191: nvl(p_rec.attribute2, hr_api.g_varchar2) or
192: nvl(per_req_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
193: nvl(p_rec.attribute3, hr_api.g_varchar2) or
194: nvl(per_req_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
195: nvl(p_rec.attribute4, hr_api.g_varchar2) or
196: nvl(per_req_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
197: nvl(p_rec.attribute5, hr_api.g_varchar2) or
198: nvl(per_req_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 196: nvl(per_req_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

192: nvl(per_req_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
193: nvl(p_rec.attribute3, hr_api.g_varchar2) or
194: nvl(per_req_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
195: nvl(p_rec.attribute4, hr_api.g_varchar2) or
196: nvl(per_req_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
197: nvl(p_rec.attribute5, hr_api.g_varchar2) or
198: nvl(per_req_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute6, hr_api.g_varchar2) or
200: nvl(per_req_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 198: nvl(per_req_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

194: nvl(per_req_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
195: nvl(p_rec.attribute4, hr_api.g_varchar2) or
196: nvl(per_req_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
197: nvl(p_rec.attribute5, hr_api.g_varchar2) or
198: nvl(per_req_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute6, hr_api.g_varchar2) or
200: nvl(per_req_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute7, hr_api.g_varchar2) or
202: nvl(per_req_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 200: nvl(per_req_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

196: nvl(per_req_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
197: nvl(p_rec.attribute5, hr_api.g_varchar2) or
198: nvl(per_req_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute6, hr_api.g_varchar2) or
200: nvl(per_req_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute7, hr_api.g_varchar2) or
202: nvl(per_req_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute8, hr_api.g_varchar2) or
204: nvl(per_req_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 202: nvl(per_req_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

198: nvl(per_req_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute6, hr_api.g_varchar2) or
200: nvl(per_req_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute7, hr_api.g_varchar2) or
202: nvl(per_req_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute8, hr_api.g_varchar2) or
204: nvl(per_req_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute9, hr_api.g_varchar2) or
206: nvl(per_req_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 204: nvl(per_req_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

200: nvl(per_req_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute7, hr_api.g_varchar2) or
202: nvl(per_req_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute8, hr_api.g_varchar2) or
204: nvl(per_req_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute9, hr_api.g_varchar2) or
206: nvl(per_req_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute10, hr_api.g_varchar2) or
208: nvl(per_req_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 206: nvl(per_req_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

202: nvl(per_req_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute8, hr_api.g_varchar2) or
204: nvl(per_req_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute9, hr_api.g_varchar2) or
206: nvl(per_req_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute10, hr_api.g_varchar2) or
208: nvl(per_req_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute11, hr_api.g_varchar2) or
210: nvl(per_req_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 208: nvl(per_req_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

204: nvl(per_req_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute9, hr_api.g_varchar2) or
206: nvl(per_req_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute10, hr_api.g_varchar2) or
208: nvl(per_req_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute11, hr_api.g_varchar2) or
210: nvl(per_req_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute12, hr_api.g_varchar2) or
212: nvl(per_req_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 210: nvl(per_req_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

206: nvl(per_req_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute10, hr_api.g_varchar2) or
208: nvl(per_req_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute11, hr_api.g_varchar2) or
210: nvl(per_req_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute12, hr_api.g_varchar2) or
212: nvl(per_req_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute13, hr_api.g_varchar2) or
214: nvl(per_req_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 212: nvl(per_req_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

208: nvl(per_req_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute11, hr_api.g_varchar2) or
210: nvl(per_req_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute12, hr_api.g_varchar2) or
212: nvl(per_req_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute13, hr_api.g_varchar2) or
214: nvl(per_req_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute14, hr_api.g_varchar2) or
216: nvl(per_req_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 214: nvl(per_req_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

210: nvl(per_req_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute12, hr_api.g_varchar2) or
212: nvl(per_req_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute13, hr_api.g_varchar2) or
214: nvl(per_req_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute14, hr_api.g_varchar2) or
216: nvl(per_req_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute15, hr_api.g_varchar2) or
218: nvl(per_req_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 216: nvl(per_req_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

212: nvl(per_req_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute13, hr_api.g_varchar2) or
214: nvl(per_req_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute14, hr_api.g_varchar2) or
216: nvl(per_req_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute15, hr_api.g_varchar2) or
218: nvl(per_req_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute16, hr_api.g_varchar2) or
220: nvl(per_req_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 218: nvl(per_req_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

214: nvl(per_req_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute14, hr_api.g_varchar2) or
216: nvl(per_req_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute15, hr_api.g_varchar2) or
218: nvl(per_req_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute16, hr_api.g_varchar2) or
220: nvl(per_req_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute17, hr_api.g_varchar2) or
222: nvl(per_req_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 220: nvl(per_req_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

216: nvl(per_req_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute15, hr_api.g_varchar2) or
218: nvl(per_req_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute16, hr_api.g_varchar2) or
220: nvl(per_req_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute17, hr_api.g_varchar2) or
222: nvl(per_req_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute18, hr_api.g_varchar2) or
224: nvl(per_req_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 222: nvl(per_req_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

218: nvl(per_req_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute16, hr_api.g_varchar2) or
220: nvl(per_req_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute17, hr_api.g_varchar2) or
222: nvl(per_req_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute18, hr_api.g_varchar2) or
224: nvl(per_req_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute19, hr_api.g_varchar2) or
226: nvl(per_req_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 224: nvl(per_req_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

220: nvl(per_req_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute17, hr_api.g_varchar2) or
222: nvl(per_req_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute18, hr_api.g_varchar2) or
224: nvl(per_req_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute19, hr_api.g_varchar2) or
226: nvl(per_req_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
228: or (p_rec.requisition_id is null) then

Line 226: nvl(per_req_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

222: nvl(per_req_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute18, hr_api.g_varchar2) or
224: nvl(per_req_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute19, hr_api.g_varchar2) or
226: nvl(per_req_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
228: or (p_rec.requisition_id is null) then
229: --
230: -- Only execute the validation if absolutely necessary:

Line 313: (p_rec in per_req_shd.g_rec_type

309: --
310: -- {End Of Comments}
311: -- ----------------------------------------------------------------------------
312: Procedure chk_non_updateable_args
313: (p_rec in per_req_shd.g_rec_type
314: ) IS
315: --
316: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
317: l_error EXCEPTION;

Line 326: IF NOT per_req_shd.api_updating

322: --
323: -- Only proceed with the validation if a row exists for the current
324: -- record in the HR Schema.
325: --
326: IF NOT per_req_shd.api_updating
327: (p_requisition_id => p_rec.requisition_id
328: ,p_object_version_number => p_rec.object_version_number
329: )THEN
330: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 339: if p_rec.business_group_id <> per_req_shd.g_old_rec.business_group_id

335: --
336: -- EDIT_HERE: Add checks to ensure non-updateable args have
337: -- not been updated.
338: --
339: if p_rec.business_group_id <> per_req_shd.g_old_rec.business_group_id
340: then l_argument := 'business_group_id';
341: raise l_error;
342: end if;
343: --

Line 344: if p_rec.requisition_id <> per_req_shd.g_old_rec.requisition_id

340: then l_argument := 'business_group_id';
341: raise l_error;
342: end if;
343: --
344: if p_rec.requisition_id <> per_req_shd.g_old_rec.requisition_id
345: then l_argument := 'requisition_id';
346: raise l_error;
347: end if;
348:

Line 478: l_api_updating := per_req_shd.api_updating(p_requisition_id,p_object_version_number);

474: --
475: Begin
476: hr_utility.set_location('Entering:'||l_proc,10);
477: --
478: l_api_updating := per_req_shd.api_updating(p_requisition_id,p_object_version_number);
479: --
480: -- Check to see if date_from or date_to values have changed.
481: --
482: hr_utility.set_location(l_proc, 20);

Line 484: and ((nvl(per_req_shd.g_old_rec.date_from,hr_api.g_date) <> p_date_from)

480: -- Check to see if date_from or date_to values have changed.
481: --
482: hr_utility.set_location(l_proc, 20);
483: if ((l_api_updating
484: and ((nvl(per_req_shd.g_old_rec.date_from,hr_api.g_date) <> p_date_from)
485: or (nvl(per_req_shd.g_old_rec.date_to,hr_api.g_date) <> p_date_to)))
486: or (NOT l_api_updating)) then
487: --
488: -- Check that the start date has been entered.

Line 485: or (nvl(per_req_shd.g_old_rec.date_to,hr_api.g_date) <> p_date_to)))

481: --
482: hr_utility.set_location(l_proc, 20);
483: if ((l_api_updating
484: and ((nvl(per_req_shd.g_old_rec.date_from,hr_api.g_date) <> p_date_from)
485: or (nvl(per_req_shd.g_old_rec.date_to,hr_api.g_date) <> p_date_to)))
486: or (NOT l_api_updating)) then
487: --
488: -- Check that the start date has been entered.
489: --

Line 566: l_api_updating := per_req_shd.api_updating(p_requisition_id

562: --
563: Begin
564: hr_utility.set_location('Entering:'||l_proc,10);
565: --
566: l_api_updating := per_req_shd.api_updating(p_requisition_id
567: ,p_object_version_number);
568: --
569: -- Check to see if person_id value has changed.
570: --

Line 573: and (nvl(per_req_shd.g_old_rec.person_id,hr_api.g_number) <> p_person_id))

569: -- Check to see if person_id value has changed.
570: --
571: hr_utility.set_location(l_proc, 20);
572: if ((l_api_updating
573: and (nvl(per_req_shd.g_old_rec.person_id,hr_api.g_number) <> p_person_id))
574: or (NOT l_api_updating)) then
575: --
576: if p_person_id is not NULL then
577: --

Line 609: (p_rec in per_req_shd.g_rec_type

605: -- ----------------------------------------------------------------------------
606: -- |---------------------------< insert_validate >----------------------------|
607: -- ----------------------------------------------------------------------------
608: Procedure insert_validate
609: (p_rec in per_req_shd.g_rec_type
610: ) is
611: --
612: l_proc varchar2(72) := g_package||'insert_validate';
613: --

Line 656: (p_rec in per_req_shd.g_rec_type

652: -- ----------------------------------------------------------------------------
653: -- |---------------------------< update_validate >----------------------------|
654: -- ----------------------------------------------------------------------------
655: Procedure update_validate
656: (p_rec in per_req_shd.g_rec_type
657: ) is
658: --
659: l_proc varchar2(72) := g_package||'update_validate';
660: --

Line 703: (p_rec in per_req_shd.g_rec_type

699: -- ----------------------------------------------------------------------------
700: -- |---------------------------< delete_validate >----------------------------|
701: -- ----------------------------------------------------------------------------
702: Procedure delete_validate
703: (p_rec in per_req_shd.g_rec_type
704: ) is
705: --
706: l_proc varchar2(72) := g_package||'delete_validate';
707: --