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 98: -- Gets the next person number from the per_number_generation_controls

94: END IS_UNIQUE_PERSON_NUMBER;
95: -- --------------------------------------------------------------------- +
96: -- #2660279 Get_Person_Number +
97: -- --------------------------------------------------------------------- +
98: -- Gets the next person number from the per_number_generation_controls
99: -- table/global sequence. It will check that the number is unique within the
100: -- Business Group. In case this number already exists, it will check the next
101: -- value (maximum 25 times) until an unassigned number is found.
102: -- If after 25 times, a number could not be found, then an error message

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

102: -- If after 25 times, a number could not be found, then an error message
103: -- will be raised.
104: --
105: --
106: PROCEDURE GET_PERSON_NUMBER (p_person_type IN per_number_generation_controls.type%TYPE
107: ,p_person_number IN OUT NOCOPY varchar2
108: ,p_business_group_id IN number
109: ,p_person_id IN number
110: ,p_effective_date IN date

Line 201: FROM per_number_generation_controls

197: SELECT next_value
198: , rowid
199: INTO l_person_number
200: , l_rowid
201: FROM per_number_generation_controls
202: WHERE business_group_id = p_business_group_id
203: AND type = p_person_type
204: FOR UPDATE OF next_value ;
205: end if;

Line 236: UPDATE per_number_generation_controls

232: end if;
233: hr_utility.raise_error;
234: else
235: if NOT l_use_sequence then
236: UPDATE per_number_generation_controls
237: SET next_value = l_person_number + 1
238: WHERE rowid = l_rowid ;
239: end if;
240: --

Line 422: -- FROM per_number_generation_controls

418: -- SELECT next_value
419: -- , rowid
420: -- INTO p_applicant_number
421: -- , l_rowid
422: -- FROM per_number_generation_controls
423: -- WHERE business_group_id +0 = p_business_group_id
424: -- AND type = 'APL'
425: -- FOR UPDATE OF next_value ;
426: --

Line 427: -- UPDATE per_number_generation_controls

423: -- WHERE business_group_id +0 = p_business_group_id
424: -- AND type = 'APL'
425: -- FOR UPDATE OF next_value ;
426: --
427: -- UPDATE per_number_generation_controls
428: -- SET next_value = next_value + 1
429: -- WHERE rowid = l_rowid ;
430: -- ------------------------------------------------------------+
431:

Line 550: -- FROM per_number_generation_controls

546: -- SELECT next_value
547: -- , rowid
548: -- INTO p_employee_number
549: -- , l_rowid
550: -- FROM per_number_generation_controls
551: -- WHERE business_group_id +0 = p_business_group_id
552: -- AND type = 'EMP'
553: -- FOR UPDATE OF next_value ;
554: --

Line 555: -- UPDATE per_number_generation_controls

551: -- WHERE business_group_id +0 = p_business_group_id
552: -- AND type = 'EMP'
553: -- FOR UPDATE OF next_value ;
554: --
555: -- UPDATE per_number_generation_controls
556: -- SET next_value = next_value + 1
557: -- WHERE rowid = l_rowid ;
558: -- ------------------------------------------------------------+
559:

Line 686: -- FROM per_number_generation_controls

682: -- SELECT next_value
683: -- , rowid
684: -- INTO p_npw_number
685: -- , l_rowid
686: -- FROM per_number_generation_controls
687: -- WHERE business_group_id = p_business_group_id
688: -- AND type = 'CWK'
689: -- FOR UPDATE OF next_value ;
690: --

Line 691: -- UPDATE per_number_generation_controls

687: -- WHERE business_group_id = p_business_group_id
688: -- AND type = 'CWK'
689: -- FOR UPDATE OF next_value ;
690: --
691: -- UPDATE per_number_generation_controls
692: -- SET next_value = next_value + 1
693: -- WHERE rowid = l_rowid ;
694: -- ------------------------------------------------------------+
695: --

Line 725: -- FROM per_number_generation_controls

721: -- SELECT next_value
722: -- , rowid
723: -- INTO p_npw_number
724: -- , l_rowid
725: -- FROM per_number_generation_controls
726: -- WHERE business_group_id = p_business_group_id
727: -- AND type = 'EMP'
728: -- FOR UPDATE OF next_value ;
729: --

Line 730: -- UPDATE per_number_generation_controls

726: -- WHERE business_group_id = p_business_group_id
727: -- AND type = 'EMP'
728: -- FOR UPDATE OF next_value ;
729: --
730: -- UPDATE per_number_generation_controls
731: -- SET next_value = next_value + 1
732: -- WHERE rowid = l_rowid ;
733: -- ------------------------------------------------------------+
734: