DBA Data[Home] [Help]

APPS.PER_BG_NUMBERING_METHOD_PKG dependencies on PER_GLOBAL_APL_NUM_S

Line 17: g_apl_sequence_name varchar2(30) := 'PER_GLOBAL_APL_NUM_S';

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';
21: g_xbg_APLNum_profile varchar2(30) := 'PER_GLOBAL_APL_NUM';

Line 843: select PER_GLOBAL_APL_NUM_S.NEXTVAL

839: select PER_GLOBAL_EMP_NUM_S.NEXTVAL
840: into l_next_value
841: from dual;
842: elsif p_person_type = 'APL' then
843: select PER_GLOBAL_APL_NUM_S.NEXTVAL
844: into l_next_value
845: from dual;
846:
847: elsif p_person_type = 'CWK' then