APPS.HR_PERSON dependencies on PER_BG_NUMBERING_METHOD_PKG

Line 137: l_formula_id := PER_BG_NUMBERING_METHOD_PKG.Get_PersonNumber_Formula

133: l_legislation_code varchar2(150);
134:
135: BEGIN
136: l_is_unique := 'N';
137: l_formula_id := PER_BG_NUMBERING_METHOD_PKG.Get_PersonNumber_Formula
138: (p_person_type, p_effective_date);
139: IF l_formula_id is not null THEN
140: -- ------------------------------------------------------------------------+
141: -- Process number generation using Fast Formula +

Line 151: l_person_number := PER_BG_NUMBERING_METHOD_PKG.Execute_Get_Person_Number_FF(

147: (p_business_group_id => p_business_group_id);
148: --
149: -- Execute formula
150: --
151: l_person_number := PER_BG_NUMBERING_METHOD_PKG.Execute_Get_Person_Number_FF(
152: p_formula_id => l_formula_id
153: ,p_effective_date => p_effective_date
154: ,p_business_group_id => p_business_group_id
155: ,p_person_type => p_person_type

Line 191: l_use_sequence := PER_BG_NUMBERING_METHOD_PKG.Global_person_numbering(p_person_type);

187: -- ------------------------------------------------------------------------+
188: -- Process number generation using existing mechanism +
189: -- ------------------------------------------------------------------------+
190: BEGIN
191: l_use_sequence := PER_BG_NUMBERING_METHOD_PKG.Global_person_numbering(p_person_type);
192: if l_use_sequence then
193: -- retrieve number from sequence
194: l_person_number := PER_BG_NUMBERING_METHOD_PKG.GetGlobalPersonNum(p_person_type);
195: else

Line 194: l_person_number := PER_BG_NUMBERING_METHOD_PKG.GetGlobalPersonNum(p_person_type);

190: BEGIN
191: l_use_sequence := PER_BG_NUMBERING_METHOD_PKG.Global_person_numbering(p_person_type);
192: if l_use_sequence then
193: -- retrieve number from sequence
194: l_person_number := PER_BG_NUMBERING_METHOD_PKG.GetGlobalPersonNum(p_person_type);
195: else
196: -- Table-based method is used
197: SELECT next_value
198: , rowid

Line 217: l_person_number := PER_BG_NUMBERING_METHOD_PKG.GetGlobalPersonNum(p_person_type);

213: );
214: if l_is_unique = 'N' then
215: if l_use_sequence then
216: -- get number from sequence
217: l_person_number := PER_BG_NUMBERING_METHOD_PKG.GetGlobalPersonNum(p_person_type);
218: else
219: l_counter := l_counter + 1;
220: l_person_number := l_person_number + 1;
221: end if;