DBA Data[Home] [Help]

APPS.PER_BG_NUMBERING_METHOD_PKG dependencies on PER_GLOBAL_EMP_NUM_S

Line 16: g_emp_sequence_name varchar2(30) := 'PER_GLOBAL_EMP_NUM_S';

12: g_max_person_number number := 999999999999999999999999999999;
13: g_max_global_person_num number := 999999999999999999999999999;
14: --
15: -- Enh 2931775
16: g_emp_sequence_name varchar2(30) := 'PER_GLOBAL_EMP_NUM_S';
17: g_apl_sequence_name varchar2(30) := 'PER_GLOBAL_APL_NUM_S';
18: g_cwk_sequence_name varchar2(30) := 'PER_GLOBAL_CWK_NUM_S';
19: --
20: g_xbg_EMPNum_profile varchar2(30) := 'PER_GLOBAL_EMP_NUM';

Line 845: select PER_GLOBAL_EMP_NUM_S.NEXTVAL

841: c_proc_name varchar2(100) := g_pkg_name||'.GetGlobalPersonNum';
842: BEGIN
843: l_next_value := null;
844: if p_person_type = 'EMP' then
845: select PER_GLOBAL_EMP_NUM_S.NEXTVAL
846: into l_next_value
847: from dual;
848: elsif p_person_type = 'APL' then
849: select PER_GLOBAL_APL_NUM_S.NEXTVAL