APPS.HR_PERSON dependencies on PER_NUMBER_GENERATION_CONTROLS

Line 20: ,p_person_type IN per_number_generation_controls.type%TYPE

16: -- Returns 'Y' if number is unique within Business Group
17: -- otherwise returns 'N'
18: --
19: FUNCTION IS_UNIQUE_PERSON_NUMBER (p_person_id IN number
20: ,p_person_type IN per_number_generation_controls.type%TYPE
21: ,p_person_number IN varchar2
22: ,p_business_group_id IN number
23: )
24: RETURN varchar2 IS

Line 149: -- Gets the next person number from the per_number_generation_controls

145: END IS_UNIQUE_PERSON_NUMBER;
146: -- --------------------------------------------------------------------- +
147: -- #2660279 Get_Person_Number +
148: -- --------------------------------------------------------------------- +
149: -- Gets the next person number from the per_number_generation_controls
150: -- table/global sequence. It will check that the number is unique within the
151: -- Business Group. In case this number already exists, it will check the next
152: -- value (maximum 25 times) until an unassigned number is found.
153: -- If after 25 times, a number could not be found, then an error message

Line 157: PROCEDURE GET_PERSON_NUMBER (p_person_type IN per_number_generation_controls.type%TYPE

153: -- If after 25 times, a number could not be found, then an error message
154: -- will be raised.
155: --
156: --
157: PROCEDURE GET_PERSON_NUMBER (p_person_type IN per_number_generation_controls.type%TYPE
158: ,p_person_number IN OUT NOCOPY varchar2
159: ,p_business_group_id IN number
160: ,p_person_id IN number
161: ,p_effective_date IN date

Line 252: FROM per_number_generation_controls

248: SELECT next_value
249: , rowid
250: INTO l_person_number
251: , l_rowid
252: FROM per_number_generation_controls
253: WHERE business_group_id = p_business_group_id
254: AND type = p_person_type
255: FOR UPDATE OF next_value ;
256: end if;

Line 287: UPDATE per_number_generation_controls

283: end if;
284: hr_utility.raise_error;
285: else
286: if NOT l_use_sequence then
287: UPDATE per_number_generation_controls
288: SET next_value = l_person_number + 1
289: WHERE rowid = l_rowid ;
290: end if;
291: --

Line 473: -- FROM per_number_generation_controls

469: -- SELECT next_value
470: -- , rowid
471: -- INTO p_applicant_number
472: -- , l_rowid
473: -- FROM per_number_generation_controls
474: -- WHERE business_group_id +0 = p_business_group_id
475: -- AND type = 'APL'
476: -- FOR UPDATE OF next_value ;
477: --

Line 478: -- UPDATE per_number_generation_controls

474: -- WHERE business_group_id +0 = p_business_group_id
475: -- AND type = 'APL'
476: -- FOR UPDATE OF next_value ;
477: --
478: -- UPDATE per_number_generation_controls
479: -- SET next_value = next_value + 1
480: -- WHERE rowid = l_rowid ;
481: -- ------------------------------------------------------------+
482:

Line 601: -- FROM per_number_generation_controls

597: -- SELECT next_value
598: -- , rowid
599: -- INTO p_employee_number
600: -- , l_rowid
601: -- FROM per_number_generation_controls
602: -- WHERE business_group_id +0 = p_business_group_id
603: -- AND type = 'EMP'
604: -- FOR UPDATE OF next_value ;
605: --

Line 606: -- UPDATE per_number_generation_controls

602: -- WHERE business_group_id +0 = p_business_group_id
603: -- AND type = 'EMP'
604: -- FOR UPDATE OF next_value ;
605: --
606: -- UPDATE per_number_generation_controls
607: -- SET next_value = next_value + 1
608: -- WHERE rowid = l_rowid ;
609: -- ------------------------------------------------------------+
610:

Line 737: -- FROM per_number_generation_controls

733: -- SELECT next_value
734: -- , rowid
735: -- INTO p_npw_number
736: -- , l_rowid
737: -- FROM per_number_generation_controls
738: -- WHERE business_group_id = p_business_group_id
739: -- AND type = 'CWK'
740: -- FOR UPDATE OF next_value ;
741: --

Line 742: -- UPDATE per_number_generation_controls

738: -- WHERE business_group_id = p_business_group_id
739: -- AND type = 'CWK'
740: -- FOR UPDATE OF next_value ;
741: --
742: -- UPDATE per_number_generation_controls
743: -- SET next_value = next_value + 1
744: -- WHERE rowid = l_rowid ;
745: -- ------------------------------------------------------------+
746: --

Line 776: -- FROM per_number_generation_controls

772: -- SELECT next_value
773: -- , rowid
774: -- INTO p_npw_number
775: -- , l_rowid
776: -- FROM per_number_generation_controls
777: -- WHERE business_group_id = p_business_group_id
778: -- AND type = 'EMP'
779: -- FOR UPDATE OF next_value ;
780: --

Line 781: -- UPDATE per_number_generation_controls

777: -- WHERE business_group_id = p_business_group_id
778: -- AND type = 'EMP'
779: -- FOR UPDATE OF next_value ;
780: --
781: -- UPDATE per_number_generation_controls
782: -- SET next_value = next_value + 1
783: -- WHERE rowid = l_rowid ;
784: -- ------------------------------------------------------------+
785: