DBA Data[Home] [Help]

APPS.BENUTILS dependencies on HR_GENERAL

Line 703: if (hr_security.view_all = 'Y' and hr_general.get_xbg_profile = 'Y') or (nvl(l_rec.mode_cd,hr_api.g_varchar2) = 'W')

699: hr_utility.set_location('Entering:'||l_proc, 5);
700: ben_env_object.get(l_rec);
701: -- Perf changes
702: -- bug 8431552: Skip the security profile check for CWB mode
703: if (hr_security.view_all = 'Y' and hr_general.get_xbg_profile = 'Y') or (nvl(l_rec.mode_cd,hr_api.g_varchar2) = 'W')
704: then
705: open c_all_assignment;
706: --
707: fetch c_all_assignment into l_assignment_id;

Line 4195: if hr_general.chk_maintain_tax_records = 'Y' then

4191: -- for addresses.
4192: -- allows US business group to be used for a Global instance
4193: --
4194: if l_legislation_code = 'US' then
4195: if hr_general.chk_maintain_tax_records = 'Y' then
4196: --
4197: open c_asg;
4198: fetch c_asg into l_asg;
4199: close c_asg;

Line 5487: hr_general.g_data_migrator_mode := 'N';

5483: end if ;
5484: --
5485: if l_mode not in ('P','Y','N') then
5486: --
5487: hr_general.g_data_migrator_mode := 'N';
5488: --
5489: else
5490: hr_general.g_data_migrator_mode := l_mode ;
5491: end if;

Line 5490: hr_general.g_data_migrator_mode := l_mode ;

5486: --
5487: hr_general.g_data_migrator_mode := 'N';
5488: --
5489: else
5490: hr_general.g_data_migrator_mode := l_mode ;
5491: end if;
5492: --
5493: hr_utility.set_location('successful '||hr_general.g_data_migrator_mode, 999);
5494: hr_utility.set_location('Leaving '||l_proc, 999);

Line 5493: hr_utility.set_location('successful '||hr_general.g_data_migrator_mode, 999);

5489: else
5490: hr_general.g_data_migrator_mode := l_mode ;
5491: end if;
5492: --
5493: hr_utility.set_location('successful '||hr_general.g_data_migrator_mode, 999);
5494: hr_utility.set_location('Leaving '||l_proc, 999);
5495: exception
5496: --
5497: when others then

Line 5499: hr_general.g_data_migrator_mode := 'N';

5495: exception
5496: --
5497: when others then
5498: --
5499: hr_general.g_data_migrator_mode := 'N';
5500: --
5501: hr_utility.set_location('when others value '||hr_general.g_data_migrator_mode, 999);
5502: end set_data_migrator_mode;
5503: --

Line 5501: hr_utility.set_location('when others value '||hr_general.g_data_migrator_mode, 999);

5497: when others then
5498: --
5499: hr_general.g_data_migrator_mode := 'N';
5500: --
5501: hr_utility.set_location('when others value '||hr_general.g_data_migrator_mode, 999);
5502: end set_data_migrator_mode;
5503: --
5504: -- Bug 2016857
5505: --

Line 5537: substr(hr_general.decode_lookup('BEN_TX_TYP',abr.tx_typ_cd),1,60) meaning

5533: From
5534: (Select plip.pgm_id pgm_id, abr.acty_base_rt_id acty_base_rt_id,
5535: abr.business_group_id business_group_id,
5536: pl.name pl_name, Null opt_name, abr.name abr_name,
5537: substr(hr_general.decode_lookup('BEN_TX_TYP',abr.tx_typ_cd),1,60) meaning
5538: From ben_acty_base_rt_f abr,
5539: ben_plip_f plip,
5540: ben_pl_f pl,
5541: fnd_sessions se

Line 5560: substr(hr_general.decode_lookup('BEN_TX_TYP',abr.tx_typ_cd),1,60) meaning

5556: Union
5557: Select plip.pgm_id pgm_id, abr.acty_base_rt_id acty_base_rt_id,
5558: abr.business_group_id,
5559: pl.name pl_name, Null opt_name, abr.name abr_name,
5560: substr(hr_general.decode_lookup('BEN_TX_TYP',abr.tx_typ_cd),1,60) meaning
5561: From ben_acty_base_rt_f abr,
5562: ben_plip_f plip,
5563: ben_pl_f pl,
5564: fnd_sessions se

Line 5583: substr(hr_general.decode_lookup('BEN_TX_TYP',abr.tx_typ_cd),1,60) meaning

5579: Union
5580: Select plip.pgm_id pgm_id, abr.acty_base_rt_id acty_base_rt_id,
5581: abr.business_group_id,
5582: pl.name pl_name, opt.name opt_name, abr.name abr_name,
5583: substr(hr_general.decode_lookup('BEN_TX_TYP',abr.tx_typ_cd),1,60) meaning
5584: From ben_acty_base_rt_f abr,
5585: ben_plip_f plip,
5586: ben_pl_f pl,
5587: ben_oipl_f oipl,

Line 5612: substr(hr_general.decode_lookup('BEN_TX_TYP',abr.tx_typ_cd),1,60) meaning

5608: Union
5609: Select plip.pgm_id pgm_id, abr.acty_base_rt_id acty_base_rt_id,
5610: abr.business_group_id,
5611: pl.name pl_name, opt.name opt_name, abr.name abr_name,
5612: substr(hr_general.decode_lookup('BEN_TX_TYP',abr.tx_typ_cd),1,60) meaning
5613: From ben_acty_base_rt_f abr,
5614: ben_plip_f plip,
5615: ben_pl_f pl,
5616: ben_oipl_f oipl,