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_RES_BUS dependencies on PER_RES_SHD

Line 177: ,p_rec in per_res_shd.g_rec_type

173: -- {End Of Comments}
174: -- ----------------------------------------------------------------------------
175: Procedure chk_non_updateable_args
176: (p_effective_date in date
177: ,p_rec in per_res_shd.g_rec_type
178: ) IS
179: --
180: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
181: l_error EXCEPTION;

Line 189: IF NOT per_res_shd.api_updating

185: --
186: -- Only proceed with the validation if a row exists for the current
187: -- record in the HR Schema.
188: --
189: IF NOT per_res_shd.api_updating
190: (p_cagr_entitlement_result_id => p_rec.cagr_entitlement_result_id
191: ,p_object_version_number => p_rec.object_version_number
192: ) THEN
193: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 205: nvl(per_res_shd.g_old_rec.assignment_id

201: --
202: hr_utility.set_location(l_proc, 30);
203: --
204: if nvl(p_rec.assignment_id, hr_api.g_number) <>
205: nvl(per_res_shd.g_old_rec.assignment_id
206: ,hr_api.g_number) then
207: l_argument := 'assignment_id';
208: raise l_error;
209: end if;

Line 212: nvl(per_res_shd.g_old_rec.cagr_request_id

208: raise l_error;
209: end if;
210: /*
211: if nvl(p_rec.cagr_request_id, hr_api.g_number) <>
212: nvl(per_res_shd.g_old_rec.cagr_request_id
213: ,hr_api.g_number) then
214: l_argument := 'cagr_request_id';
215: raise l_error;
216: end if;

Line 220: nvl(per_res_shd.g_old_rec.start_date

216: end if;
217: */
218:
219: if nvl(p_rec.start_date, hr_api.g_date) <>
220: nvl(per_res_shd.g_old_rec.start_date
221: ,hr_api.g_date) then
222: l_argument := 'start_date';
223: raise l_error;
224: end if;

Line 227: nvl(per_res_shd.g_old_rec.end_date

223: raise l_error;
224: end if;
225:
226: if nvl(p_rec.end_date, hr_api.g_date) <>
227: nvl(per_res_shd.g_old_rec.end_date
228: ,hr_api.g_date) then
229: l_argument := 'end_date';
230: raise l_error;
231: end if;

Line 234: nvl(per_res_shd.g_old_rec.collective_agreement_id

230: raise l_error;
231: end if;
232:
233: if nvl(p_rec.collective_agreement_id, hr_api.g_number) <>
234: nvl(per_res_shd.g_old_rec.collective_agreement_id
235: ,hr_api.g_number) then
236: l_argument := 'collective_agreement_id';
237: raise l_error;
238: end if;

Line 241: nvl(per_res_shd.g_old_rec.cagr_entitlement_item_id

237: raise l_error;
238: end if;
239:
240: if nvl(p_rec.cagr_entitlement_item_id, hr_api.g_number) <>
241: nvl(per_res_shd.g_old_rec.cagr_entitlement_item_id
242: ,hr_api.g_number) then
243: l_argument := 'cagr_entitlement_item_id';
244: raise l_error;
245: end if;

Line 248: nvl(per_res_shd.g_old_rec.element_type_id

244: raise l_error;
245: end if;
246:
247: if nvl(p_rec.element_type_id, hr_api.g_number) <>
248: nvl(per_res_shd.g_old_rec.element_type_id
249: ,hr_api.g_number) then
250: l_argument := 'element_type_id';
251: raise l_error;
252: end if;

Line 255: nvl(per_res_shd.g_old_rec.input_value_id

251: raise l_error;
252: end if;
253:
254: if nvl(p_rec.input_value_id, hr_api.g_number) <>
255: nvl(per_res_shd.g_old_rec.input_value_id
256: ,hr_api.g_number) then
257: l_argument := 'input_value_id';
258: raise l_error;
259: end if;

Line 262: nvl(per_res_shd.g_old_rec.cagr_api_id

258: raise l_error;
259: end if;
260:
261: if nvl(p_rec.cagr_api_id, hr_api.g_number) <>
262: nvl(per_res_shd.g_old_rec.cagr_api_id
263: ,hr_api.g_number) then
264: l_argument := 'cagr_api_id';
265: raise l_error;
266: end if;

Line 269: nvl(per_res_shd.g_old_rec.cagr_api_param_id

265: raise l_error;
266: end if;
267:
268: if nvl(p_rec.cagr_api_param_id, hr_api.g_number) <>
269: nvl(per_res_shd.g_old_rec.cagr_api_param_id
270: ,hr_api.g_number) then
271: l_argument := 'cagr_api_param_id';
272: raise l_error;
273: end if;

Line 276: nvl(per_res_shd.g_old_rec.category_name

272: raise l_error;
273: end if;
274:
275: if nvl(p_rec.category_name, hr_api.g_varchar2) <>
276: nvl(per_res_shd.g_old_rec.category_name
277: ,hr_api.g_varchar2) then
278: l_argument := 'category_name';
279: raise l_error;
280: end if;

Line 283: nvl(per_res_shd.g_old_rec.cagr_entitlement_id

279: raise l_error;
280: end if;
281:
282: if nvl(p_rec.cagr_entitlement_id, hr_api.g_number) <>
283: nvl(per_res_shd.g_old_rec.cagr_entitlement_id
284: ,hr_api.g_number) then
285: l_argument := 'cagr_entitlement_id';
286: raise l_error;
287: end if;

Line 290: nvl(per_res_shd.g_old_rec.cagr_entitlement_line_id

286: raise l_error;
287: end if;
288:
289: if nvl(p_rec.cagr_entitlement_line_id, hr_api.g_number) <>
290: nvl(per_res_shd.g_old_rec.cagr_entitlement_line_id
291: ,hr_api.g_number) then
292: l_argument := 'cagr_entitlement_line_id';
293: raise l_error;
294: end if;

Line 298: nvl(per_res_shd.g_old_rec.value

294: end if;
295: -- works
296:
297: if nvl(p_rec.value, hr_api.g_varchar2) <>
298: nvl(per_res_shd.g_old_rec.value
299: ,hr_api.g_varchar2) then
300: l_argument := 'value';
301: raise l_error;
302: end if;

Line 305: nvl(per_res_shd.g_old_rec.units_of_measure

301: raise l_error;
302: end if;
303:
304: if nvl(p_rec.units_of_measure, hr_api.g_varchar2) <>
305: nvl(per_res_shd.g_old_rec.units_of_measure
306: ,hr_api.g_varchar2) then
307: l_argument := 'units_of_measure';
308: raise l_error;
309: end if;

Line 312: nvl(per_res_shd.g_old_rec.range_from

308: raise l_error;
309: end if;
310:
311: if nvl(p_rec.range_from, hr_api.g_varchar2) <>
312: nvl(per_res_shd.g_old_rec.range_from
313: ,hr_api.g_varchar2) then
314: l_argument := 'range_from';
315: raise l_error;
316: end if;

Line 319: nvl(per_res_shd.g_old_rec.range_to

315: raise l_error;
316: end if;
317:
318: if nvl(p_rec.range_to, hr_api.g_varchar2) <>
319: nvl(per_res_shd.g_old_rec.range_to
320: ,hr_api.g_varchar2) then
321: l_argument := 'range_to';
322: raise l_error;
323: end if;

Line 326: nvl(per_res_shd.g_old_rec.grade_spine_id

322: raise l_error;
323: end if;
324:
325: if nvl(p_rec.grade_spine_id, hr_api.g_number) <>
326: nvl(per_res_shd.g_old_rec.grade_spine_id
327: ,hr_api.g_number) then
328: l_argument := 'grade_spine_id';
329: raise l_error;
330: end if;

Line 333: nvl(per_res_shd.g_old_rec.parent_spine_id

329: raise l_error;
330: end if;
331:
332: if nvl(p_rec.parent_spine_id, hr_api.g_number) <>
333: nvl(per_res_shd.g_old_rec.parent_spine_id
334: ,hr_api.g_number) then
335: l_argument := 'parent_spine_id';
336: raise l_error;
337: end if;

Line 340: nvl(per_res_shd.g_old_rec.step_id

336: raise l_error;
337: end if;
338:
339: if nvl(p_rec.step_id , hr_api.g_number) <>
340: nvl(per_res_shd.g_old_rec.step_id
341: ,hr_api.g_number) then
342: l_argument := 'step_id ';
343: raise l_error;
344: end if;

Line 347: nvl(per_res_shd.g_old_rec.from_step_id

343: raise l_error;
344: end if;
345:
346: if nvl(p_rec.from_step_id, hr_api.g_number) <>
347: nvl(per_res_shd.g_old_rec.from_step_id
348: ,hr_api.g_number) then
349: l_argument := 'from_step_id';
350: raise l_error;
351: end if;

Line 354: nvl(per_res_shd.g_old_rec.to_step_id

350: raise l_error;
351: end if;
352:
353: if nvl(p_rec.to_step_id, hr_api.g_number) <>
354: nvl(per_res_shd.g_old_rec.to_step_id
355: ,hr_api.g_number) then
356: l_argument := 'to_step_id';
357: raise l_error;
358: end if;

Line 361: nvl(per_res_shd.g_old_rec.oipl_id

357: raise l_error;
358: end if;
359:
360: if nvl(p_rec.oipl_id, hr_api.g_number) <>
361: nvl(per_res_shd.g_old_rec.oipl_id
362: ,hr_api.g_number) then
363: l_argument := 'oipl_id';
364: raise l_error;
365: end if;

Line 368: nvl(per_res_shd.g_old_rec.column_type

364: raise l_error;
365: end if;
366:
367: if nvl(p_rec.column_type, hr_api.g_varchar2) <>
368: nvl(per_res_shd.g_old_rec.column_type
369: ,hr_api.g_varchar2) then
370: l_argument := 'column_type';
371: raise l_error;
372: end if;

Line 375: nvl(per_res_shd.g_old_rec.column_size

371: raise l_error;
372: end if;
373:
374: if nvl(p_rec.column_size, hr_api.g_number) <>
375: nvl(per_res_shd.g_old_rec.column_size
376: ,hr_api.g_number) then
377: l_argument := 'column_size';
378: raise l_error;
379: end if;

Line 382: nvl(per_res_shd.g_old_rec.beneficial_flag ,hr_api.g_varchar2) then

378: raise l_error;
379: end if;
380:
381: if nvl(p_rec.beneficial_flag, hr_api.g_varchar2) <>
382: nvl(per_res_shd.g_old_rec.beneficial_flag ,hr_api.g_varchar2) then
383: l_argument := 'beneficial_flag';
384: raise l_error;
385: end if;
386:

Line 388: nvl(per_res_shd.g_old_rec.business_group_id

384: raise l_error;
385: end if;
386:
387: if nvl(p_rec.business_group_id, hr_api.g_number) <>
388: nvl(per_res_shd.g_old_rec.business_group_id
389: ,hr_api.g_number) then
390: l_argument := 'business_group_id';
391: raise l_error;
392: end if;

Line 395: nvl(per_res_shd.g_old_rec.legislation_code

391: raise l_error;
392: end if;
393:
394: if nvl(p_rec.legislation_code, hr_api.g_varchar2) <>
395: nvl(per_res_shd.g_old_rec.legislation_code
396: ,hr_api.g_varchar2) then
397: l_argument := 'legislation_code';
398: raise l_error;
399: end if;

Line 402: nvl(per_res_shd.g_old_rec.eligy_prfl_id

398: raise l_error;
399: end if;
400:
401: if nvl(p_rec.eligy_prfl_id, hr_api.g_number) <>
402: nvl(per_res_shd.g_old_rec.eligy_prfl_id
403: ,hr_api.g_number) then
404: l_argument := 'eligy_prfl_id';
405: raise l_error;
406: end if;

Line 409: nvl(per_res_shd.g_old_rec.formula_id

405: raise l_error;
406: end if;
407:
408: if nvl(p_rec.formula_id, hr_api.g_number) <>
409: nvl(per_res_shd.g_old_rec.formula_id
410: ,hr_api.g_number) then
411: l_argument := 'formula_id';
412: raise l_error;
413: end if;

Line 479: (per_res_shd.g_old_rec.chosen_flag <> p_chosen_flag)) then

475: -- Only proceed with validation if :
476: -- Updating and the value for chosen_flag has changed
477: --
478: if ((p_cagr_entitlement_result_id is not null) and
479: (per_res_shd.g_old_rec.chosen_flag <> p_chosen_flag)) then
480: --
481: if hr_api.not_exists_in_hr_lookups
482: (p_effective_date => p_effective_date
483: ,p_lookup_type => 'YES_NO'

Line 548: ,p_rec in per_res_shd.g_rec_type

544: -- |---------------------------< insert_validate >----------------------------|
545: -- ----------------------------------------------------------------------------
546: Procedure insert_validate
547: (p_effective_date in date
548: ,p_rec in per_res_shd.g_rec_type
549: ) is
550: --
551: l_proc varchar2(72) := g_package||'insert_validate';
552: --

Line 573: ,p_rec in per_res_shd.g_rec_type

569: -- |---------------------------< update_validate >----------------------------|
570: -- ----------------------------------------------------------------------------
571: Procedure update_validate
572: (p_effective_date in date
573: ,p_rec in per_res_shd.g_rec_type
574: ) is
575: --
576: l_proc varchar2(72) := g_package||'update_validate';
577: --

Line 604: (p_rec in per_res_shd.g_rec_type

600: -- ----------------------------------------------------------------------------
601: -- |---------------------------< delete_validate >----------------------------|
602: -- ----------------------------------------------------------------------------
603: Procedure delete_validate
604: (p_rec in per_res_shd.g_rec_type
605: ) is
606: --
607: l_proc varchar2(72) := g_package||'delete_validate';
608: --

Line 614: ,per_res_shd.g_old_rec.business_group_id

610: hr_utility.set_location('Entering:'||l_proc, 5);
611: --
612: --
613: chk_startup_action(false
614: ,per_res_shd.g_old_rec.business_group_id
615: ,per_res_shd.g_old_rec.legislation_code
616: );
617: IF hr_startup_data_api_support.g_startup_mode
618: NOT IN ('GENERIC','STARTUP') THEN

Line 615: ,per_res_shd.g_old_rec.legislation_code

611: --
612: --
613: chk_startup_action(false
614: ,per_res_shd.g_old_rec.business_group_id
615: ,per_res_shd.g_old_rec.legislation_code
616: );
617: IF hr_startup_data_api_support.g_startup_mode
618: NOT IN ('GENERIC','STARTUP') THEN
619: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp