DBA Data[Home] [Help]

APPS.BENUTILS dependencies on HR_GENERAL

Line 700: if hr_security.view_all = 'Y' and hr_general.get_xbg_profile = 'Y'

696: begin
697: --
698: hr_utility.set_location('Entering:'||l_proc, 5);
699: -- Perf changes
700: if hr_security.view_all = 'Y' and hr_general.get_xbg_profile = 'Y'
701: then
702: open c_all_assignment;
703: --
704: fetch c_all_assignment into l_assignment_id;

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

4095: -- for addresses.
4096: -- allows US business group to be used for a Global instance
4097: --
4098: if l_legislation_code = 'US' then
4099: if hr_general.chk_maintain_tax_records = 'Y' then
4100: --
4101: open c_asg;
4102: fetch c_asg into l_asg;
4103: close c_asg;

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

5358: end if ;
5359: --
5360: if l_mode not in ('P','Y','N') then
5361: --
5362: hr_general.g_data_migrator_mode := 'N';
5363: --
5364: else
5365: hr_general.g_data_migrator_mode := l_mode ;
5366: end if;

Line 5365: hr_general.g_data_migrator_mode := l_mode ;

5361: --
5362: hr_general.g_data_migrator_mode := 'N';
5363: --
5364: else
5365: hr_general.g_data_migrator_mode := l_mode ;
5366: end if;
5367: --
5368: hr_utility.set_location('successful '||hr_general.g_data_migrator_mode, 999);
5369: hr_utility.set_location('Leaving '||l_proc, 999);

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

5364: else
5365: hr_general.g_data_migrator_mode := l_mode ;
5366: end if;
5367: --
5368: hr_utility.set_location('successful '||hr_general.g_data_migrator_mode, 999);
5369: hr_utility.set_location('Leaving '||l_proc, 999);
5370: exception
5371: --
5372: when others then

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

5370: exception
5371: --
5372: when others then
5373: --
5374: hr_general.g_data_migrator_mode := 'N';
5375: --
5376: hr_utility.set_location('when others value '||hr_general.g_data_migrator_mode, 999);
5377: end set_data_migrator_mode;
5378: --

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

5372: when others then
5373: --
5374: hr_general.g_data_migrator_mode := 'N';
5375: --
5376: hr_utility.set_location('when others value '||hr_general.g_data_migrator_mode, 999);
5377: end set_data_migrator_mode;
5378: --
5379: -- Bug 2016857
5380: --

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

5408: From
5409: (Select plip.pgm_id pgm_id, abr.acty_base_rt_id acty_base_rt_id,
5410: abr.business_group_id business_group_id,
5411: pl.name pl_name, Null opt_name, abr.name abr_name,
5412: substr(hr_general.decode_lookup('BEN_TX_TYP',abr.tx_typ_cd),1,60) meaning
5413: From ben_acty_base_rt_f abr,
5414: ben_plip_f plip,
5415: ben_pl_f pl,
5416: fnd_sessions se

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

5431: Union
5432: Select plip.pgm_id pgm_id, abr.acty_base_rt_id acty_base_rt_id,
5433: abr.business_group_id,
5434: pl.name pl_name, Null opt_name, abr.name abr_name,
5435: substr(hr_general.decode_lookup('BEN_TX_TYP',abr.tx_typ_cd),1,60) meaning
5436: From ben_acty_base_rt_f abr,
5437: ben_plip_f plip,
5438: ben_pl_f pl,
5439: fnd_sessions se

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

5454: Union
5455: Select plip.pgm_id pgm_id, abr.acty_base_rt_id acty_base_rt_id,
5456: abr.business_group_id,
5457: pl.name pl_name, opt.name opt_name, abr.name abr_name,
5458: substr(hr_general.decode_lookup('BEN_TX_TYP',abr.tx_typ_cd),1,60) meaning
5459: From ben_acty_base_rt_f abr,
5460: ben_plip_f plip,
5461: ben_pl_f pl,
5462: ben_oipl_f oipl,

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

5483: Union
5484: Select plip.pgm_id pgm_id, abr.acty_base_rt_id acty_base_rt_id,
5485: abr.business_group_id,
5486: pl.name pl_name, opt.name opt_name, abr.name abr_name,
5487: substr(hr_general.decode_lookup('BEN_TX_TYP',abr.tx_typ_cd),1,60) meaning
5488: From ben_acty_base_rt_f abr,
5489: ben_plip_f plip,
5490: ben_pl_f pl,
5491: ben_oipl_f oipl,