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_BG_NUMBERING_METHOD_PKG dependencies on FND_PROFILE

Line 698: if not fnd_profile.save(g_xbg_EMPNum_profile,'Y','SITE') then

694: --
695: -- altering profile option
696: --
697: if p_person_type = 'EMP' then
698: if not fnd_profile.save(g_xbg_EMPNum_profile,'Y','SITE') then
699: RAISE e_ProfileUpdFailed;
700: end if;
701: open csr_max_emp_num(p_person_type);
702: fetch csr_max_emp_num into l_max_number;

Line 706: if not fnd_profile.save(g_xbg_APLNum_profile,'Y','SITE') then

702: fetch csr_max_emp_num into l_max_number;
703: close csr_max_emp_num;
704:
705: elsif p_person_type = 'APL' then
706: if not fnd_profile.save(g_xbg_APLNum_profile,'Y','SITE') then
707: RAISE e_ProfileUpdFailed;
708: end if;
709: open csr_max_apl_num(p_person_type);
710: fetch csr_max_apl_num into l_max_number;

Line 714: if not fnd_profile.save(g_xbg_CWKNum_profile,'Y','SITE') then

710: fetch csr_max_apl_num into l_max_number;
711: close csr_max_apl_num;
712:
713: elsif p_person_type = 'CWK' then
714: if not fnd_profile.save(g_xbg_CWKNum_profile,'Y','SITE') then
715: RAISE e_ProfileUpdFailed;
716: end if;
717: open csr_max_cwk_num(p_person_type);
718: fetch csr_max_cwk_num into l_max_number;

Line 775: -- FND_PROFILE.get_specific is required to read from the database

771: l_value varchar2(100);
772: l_defined boolean;
773: l_result boolean;
774: --
775: -- FND_PROFILE.get_specific is required to read from the database
776: -- in case Conc. Program that changes profile value already ran.
777: -- The value is cached once the profile value is set to 'Y';
778: -- FND_PROFILE.value is not used because it reads from cache thus existing
779: -- forms sessions will get old values.

Line 778: -- FND_PROFILE.value is not used because it reads from cache thus existing

774: --
775: -- FND_PROFILE.get_specific is required to read from the database
776: -- in case Conc. Program that changes profile value already ran.
777: -- The value is cached once the profile value is set to 'Y';
778: -- FND_PROFILE.value is not used because it reads from cache thus existing
779: -- forms sessions will get old values.
780: --
781: BEGIN
782: l_result := FALSE;

Line 786: FND_PROFILE.get_specific(name_z => g_xbg_EMPNum_profile

782: l_result := FALSE;
783: if p_person_type = 'EMP' then
784: if g_X_EMPprofileset is null then
785: --
786: FND_PROFILE.get_specific(name_z => g_xbg_EMPNum_profile
787: ,val_z => l_value
788: ,defined_z => l_defined);
789: if l_defined and nvl(l_value,'N')= 'Y' then
790: g_X_EMPprofileset := TRUE;

Line 802: FND_PROFILE.get_specific(name_z => g_xbg_APLNum_profile

798: --
799: elsif p_person_type = 'APL' then
800: if g_X_APLprofileset is null then
801: --
802: FND_PROFILE.get_specific(name_z => g_xbg_APLNum_profile
803: ,val_z => l_value
804: ,defined_z => l_defined);
805: if l_defined and nvl(l_value,'N')= 'Y' then
806: g_X_APLprofileset := TRUE;

Line 818: FND_PROFILE.get_specific(name_z => g_xbg_CWKNum_profile

814: --
815: elsif p_person_type = 'CWK' then
816: if g_X_CWKprofileset is null then
817: --
818: FND_PROFILE.get_specific(name_z => g_xbg_CWKNum_profile
819: ,val_z => l_value
820: ,defined_z => l_defined);
821: if l_defined and nvl(l_value,'N')= 'Y' then
822: g_X_CWKprofileset := TRUE;