72:
73: BEGIN
74: l_session_date := HR_GENERAL.Effective_Date;
75:
76: if PER_BG_NUMBERING_METHOD_PKG.Global_person_numbering(p_person_type)
77: or PER_BG_NUMBERING_METHOD_PKG.Get_PersonNumber_Formula
78: (p_person_type,l_session_date) is not null
79: then
80: -- we cannot check current value of the sequence
73: BEGIN
74: l_session_date := HR_GENERAL.Effective_Date;
75:
76: if PER_BG_NUMBERING_METHOD_PKG.Global_person_numbering(p_person_type)
77: or PER_BG_NUMBERING_METHOD_PKG.Get_PersonNumber_Formula
78: (p_person_type,l_session_date) is not null
79: then
80: -- we cannot check current value of the sequence
81: -- since this is not being locked when generating the numbers