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.BEN_AVR_BUS dependencies on HR_API

Line 54: and nvl(p_acty_vrbl_rt_id,hr_api.g_number)

50: p_acty_vrbl_rt_id => p_acty_vrbl_rt_id,
51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_acty_vrbl_rt_id,hr_api.g_number)
55: <> ben_avr_shd.g_old_rec.acty_vrbl_rt_id) then
56: --
57: -- raise error as PK has changed
58: --

Line 252: and nvl(p_vrbl_rt_prfl_id ,hr_api.g_number)

248: p_effective_date => p_effective_date,
249: p_object_version_number => p_object_version_number);
250: --
251: if (l_api_updating
252: and nvl(p_vrbl_rt_prfl_id ,hr_api.g_number)
253: <> nvl(ben_avr_shd.g_old_rec.vrbl_rt_prfl_id,hr_api.g_number)
254: or not l_api_updating) and p_vrbl_rt_prfl_id is null
255:
256: then

Line 253: <> nvl(ben_avr_shd.g_old_rec.vrbl_rt_prfl_id,hr_api.g_number)

249: p_object_version_number => p_object_version_number);
250: --
251: if (l_api_updating
252: and nvl(p_vrbl_rt_prfl_id ,hr_api.g_number)
253: <> nvl(ben_avr_shd.g_old_rec.vrbl_rt_prfl_id,hr_api.g_number)
254: or not l_api_updating) and p_vrbl_rt_prfl_id is null
255:
256: then
257: --

Line 445: and avr.acty_vrbl_rt_id <> nvl(p_acty_vrbl_rt_id, hr_api.g_number)

441: select null
442: from ben_acty_vrbl_rt_f avr
443: where avr.acty_base_rt_id = p_acty_base_rt_id
444: and avr.vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
445: and avr.acty_vrbl_rt_id <> nvl(p_acty_vrbl_rt_id, hr_api.g_number)
446: and avr.business_group_id = p_business_group_id
447: and p_effective_date between avr.effective_start_date and avr.effective_end_date;
448: --
449: Begin

Line 505: (p_acty_base_rt_id in number default hr_api.g_number,

501: --
502: -- {End Of Comments}
503: -- ----------------------------------------------------------------------------
504: Procedure dt_update_validate
505: (p_acty_base_rt_id in number default hr_api.g_number,
506: p_vrbl_rt_prfl_id in number default hr_api.g_number,
507: p_datetrack_mode in varchar2,
508: p_validation_start_date in date,
509: p_validation_end_date in date) Is

Line 506: p_vrbl_rt_prfl_id in number default hr_api.g_number,

502: -- {End Of Comments}
503: -- ----------------------------------------------------------------------------
504: Procedure dt_update_validate
505: (p_acty_base_rt_id in number default hr_api.g_number,
506: p_vrbl_rt_prfl_id in number default hr_api.g_number,
507: p_datetrack_mode in varchar2,
508: p_validation_start_date in date,
509: p_validation_end_date in date) Is
510: --

Line 520: hr_api.mandatory_arg_error

516: hr_utility.set_location('Entering:'||l_proc, 5);
517: --
518: -- Ensure that the p_datetrack_mode argument is not null
519: --
520: hr_api.mandatory_arg_error
521: (p_api_name => l_proc,
522: p_argument => 'datetrack_mode',
523: p_argument_value => p_datetrack_mode);
524: --

Line 532: hr_api.mandatory_arg_error

528: --
529: --
530: -- Ensure the arguments are not null
531: --
532: hr_api.mandatory_arg_error
533: (p_api_name => l_proc,
534: p_argument => 'validation_start_date',
535: p_argument_value => p_validation_start_date);
536: --

Line 537: hr_api.mandatory_arg_error

533: (p_api_name => l_proc,
534: p_argument => 'validation_start_date',
535: p_argument_value => p_validation_start_date);
536: --
537: hr_api.mandatory_arg_error
538: (p_api_name => l_proc,
539: p_argument => 'validation_end_date',
540: p_argument_value => p_validation_end_date);
541: --

Line 542: If ((nvl(p_acty_base_rt_id, hr_api.g_number) <> hr_api.g_number) and

538: (p_api_name => l_proc,
539: p_argument => 'validation_end_date',
540: p_argument_value => p_validation_end_date);
541: --
542: If ((nvl(p_acty_base_rt_id, hr_api.g_number) <> hr_api.g_number) and
543: NOT (dt_api.check_min_max_dates
544: (p_base_table_name => 'ben_acty_base_rt_f',
545: p_base_key_column => 'acty_base_rt_id',
546: p_base_key_value => p_acty_base_rt_id,

Line 552: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and

548: p_to_date => p_validation_end_date))) Then
549: l_table_name := 'ben_acty_base_rt_f';
550: Raise l_integrity_error;
551: End If;
552: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
553: NOT (dt_api.check_min_max_dates
554: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
555: p_base_key_column => 'vrbl_rt_prfl_id',
556: p_base_key_value => p_vrbl_rt_prfl_id,

Line 637: hr_api.mandatory_arg_error

633: hr_utility.set_location('Entering:'||l_proc, 5);
634: --
635: -- Ensure that the p_datetrack_mode argument is not null
636: --
637: hr_api.mandatory_arg_error
638: (p_api_name => l_proc,
639: p_argument => 'datetrack_mode',
640: p_argument_value => p_datetrack_mode);
641: --

Line 651: hr_api.mandatory_arg_error

647: --
648: --
649: -- Ensure the arguments are not null
650: --
651: hr_api.mandatory_arg_error
652: (p_api_name => l_proc,
653: p_argument => 'validation_start_date',
654: p_argument_value => p_validation_start_date);
655: --

Line 656: hr_api.mandatory_arg_error

652: (p_api_name => l_proc,
653: p_argument => 'validation_start_date',
654: p_argument_value => p_validation_start_date);
655: --
656: hr_api.mandatory_arg_error
657: (p_api_name => l_proc,
658: p_argument => 'validation_end_date',
659: p_argument_value => p_validation_end_date);
660: --

Line 661: hr_api.mandatory_arg_error

657: (p_api_name => l_proc,
658: p_argument => 'validation_end_date',
659: p_argument_value => p_validation_end_date);
660: --
661: hr_api.mandatory_arg_error
662: (p_api_name => l_proc,
663: p_argument => 'acty_vrbl_rt_id',
664: p_argument_value => p_acty_vrbl_rt_id);
665: --

Line 710: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

706: --
707: -- Call all supporting business operations
708: --
709: --
710: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
711: --
712: chk_acty_vrbl_rt_id
713: (p_acty_vrbl_rt_id => p_rec.acty_vrbl_rt_id,
714: p_effective_date => p_effective_date,

Line 779: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

775: --
776: -- Call all supporting business operations
777: --
778: --
779: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
780: --
781: chk_acty_vrbl_rt_id
782: (p_acty_vrbl_rt_id => p_rec.acty_vrbl_rt_id,
783: p_effective_date => p_effective_date,

Line 888: hr_api.mandatory_arg_error(p_api_name => l_proc,

884: hr_utility.set_location('Entering:'|| l_proc, 10);
885: --
886: -- Ensure that all the mandatory parameter are not null
887: --
888: hr_api.mandatory_arg_error(p_api_name => l_proc,
889: p_argument => 'acty_vrbl_rt_id',
890: p_argument_value => p_acty_vrbl_rt_id);
891: --
892: open csr_leg_code;