eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_BG_NUMBERING_METHOD_PKG dependencies on PER_ALL_PEOPLE

Line 64: (p_business_group_id IN per_all_people.business_group_id%TYPE)

60: -- Get_Max_applicant_number: - Applicants -
61: -- Returns the maximum numeric value being used in a business group.
62: -- ---------------------------------------------------------------------------+
63: FUNCTION get_max_applicant_number
64: (p_business_group_id IN per_all_people.business_group_id%TYPE)
65: RETURN NUMBER IS
66: --
67: TYPE l_applicant_number_type IS TABLE OF per_all_people_f.applicant_number%TYPE
68: INDEX BY BINARY_INTEGER;

Line 67: TYPE l_applicant_number_type IS TABLE OF per_all_people_f.applicant_number%TYPE

63: FUNCTION get_max_applicant_number
64: (p_business_group_id IN per_all_people.business_group_id%TYPE)
65: RETURN NUMBER IS
66: --
67: TYPE l_applicant_number_type IS TABLE OF per_all_people_f.applicant_number%TYPE
68: INDEX BY BINARY_INTEGER;
69: --
70: l_applicant_number_tab l_applicant_number_type;
71: l_max_applicant_number NUMBER := 0;

Line 75: from per_all_people_f

71: l_max_applicant_number NUMBER := 0;
72: --
73: cursor csr_applicants is
74: select applicant_number
75: from per_all_people_f
76: where business_group_id = p_business_group_id
77: and applicant_number is not null;
78: --
79: BEGIN

Line 124: (p_business_group_id IN per_all_people.business_group_id%TYPE)

120: -- Returns the maximum numeric value being used in a business group.
121: -- ---------------------------------------------------------------------------+
122: --
123: FUNCTION get_max_employee_number
124: (p_business_group_id IN per_all_people.business_group_id%TYPE)
125: RETURN NUMBER IS
126: --
127: TYPE l_employee_number_type IS TABLE OF per_all_people_f.employee_number%TYPE
128: INDEX BY BINARY_INTEGER;

Line 127: TYPE l_employee_number_type IS TABLE OF per_all_people_f.employee_number%TYPE

123: FUNCTION get_max_employee_number
124: (p_business_group_id IN per_all_people.business_group_id%TYPE)
125: RETURN NUMBER IS
126: --
127: TYPE l_employee_number_type IS TABLE OF per_all_people_f.employee_number%TYPE
128: INDEX BY BINARY_INTEGER;
129: --
130: l_employee_number_tab l_employee_number_type;
131: l_max_employee_number NUMBER := 0;

Line 135: from per_all_people_f

131: l_max_employee_number NUMBER := 0;
132: --
133: cursor csr_employees is
134: select employee_number
135: from per_all_people_f
136: where business_group_id = p_business_group_id
137: and employee_number is not null;
138: --
139: BEGIN

Line 185: (p_business_group_id IN per_all_people.business_group_id%TYPE)

181: -- Returns the maximum numeric value being used in a business group.
182: -- ---------------------------------------------------------------------------+
183: --
184: FUNCTION get_max_cwk_number
185: (p_business_group_id IN per_all_people.business_group_id%TYPE)
186: RETURN NUMBER IS
187: --
188: TYPE l_cwk_number_type IS TABLE OF per_all_people_f.npw_number%TYPE
189: INDEX BY BINARY_INTEGER;

Line 188: TYPE l_cwk_number_type IS TABLE OF per_all_people_f.npw_number%TYPE

184: FUNCTION get_max_cwk_number
185: (p_business_group_id IN per_all_people.business_group_id%TYPE)
186: RETURN NUMBER IS
187: --
188: TYPE l_cwk_number_type IS TABLE OF per_all_people_f.npw_number%TYPE
189: INDEX BY BINARY_INTEGER;
190: --
191: l_cwk_number_tab l_cwk_number_type;
192: l_max_cwk_number NUMBER := 0;

Line 196: from per_all_people_f

192: l_max_cwk_number NUMBER := 0;
193: --
194: cursor csr_cwk is
195: select npw_number
196: from per_all_people_f
197: where business_group_id = p_business_group_id
198: and npw_number is not null;
199: --
200: BEGIN

Line 270: l_organization_id per_all_people_f.business_group_id%TYPE;

266: l_continue_flag boolean := FALSE;
267: l_use_sequence boolean := FALSE;
268:
269:
270: l_organization_id per_all_people_f.business_group_id%TYPE;
271: l_rec_per_bg_groups t_bgRecord;
272: --
273: -- Returns the current method of number generation
274: --

Line 275: cursor csr_method(cp_bg_id per_all_people.business_group_id%TYPE) is

271: l_rec_per_bg_groups t_bgRecord;
272: --
273: -- Returns the current method of number generation
274: --
275: cursor csr_method(cp_bg_id per_all_people.business_group_id%TYPE) is
276: SELECT organization_id, Org_information2, Org_information3, Org_information16
277: from hr_organization_information
278: where organization_id = cp_bg_id
279: and ORG_INFORMATION_CONTEXT = g_bg_context_name

Line 286: cursor csr_next_value(cp_bg_id per_all_people.business_group_id%TYPE

282: , Org_information16 NOWAIT; -- method_of_generation_cwk_num
283: --
284: -- Returns next value stored per person type
285: --
286: cursor csr_next_value(cp_bg_id per_all_people.business_group_id%TYPE
287: ,cp_person_type per_person_types.system_person_type%TYPE) is
288: SELECT business_group_id
289: from per_number_generation_controls
290: where business_group_id = cp_bg_id

Line 305: -- Lock per_all_people_f to ensure person records are not created/updated/deleted

301: hr_utility.trace(' person type = '||p_person_type);
302:
303: --
304: BEGIN
305: -- Lock per_all_people_f to ensure person records are not created/updated/deleted
306: --
307: hr_utility.set_location(c_proc_name,2);
308: l_rows_updated := 0;
309: l_organization_id := p_business_group_id;

Line 312: LOCK TABLE per_all_people_f

308: l_rows_updated := 0;
309: l_organization_id := p_business_group_id;
310: l_use_sequence := Global_person_numbering(p_person_type);
311:
312: LOCK TABLE per_all_people_f
313: IN EXCLUSIVE MODE NOWAIT;
314: --
315: open csr_method(p_business_group_id);
316: fetch csr_method into l_rec_per_bg_groups;

Line 690: -- Lock per_all_people_f to ensure person records are not created/updated/deleted

686: l_max_number := 1;
687: if g_debug then
688: hr_utility.set_location('Entering: '||c_proc_name,1);
689: end if;
690: -- Lock per_all_people_f to ensure person records are not created/updated/deleted
691: --
692: LOCK TABLE per_all_people_f
693: IN EXCLUSIVE MODE NOWAIT;
694: --

Line 692: LOCK TABLE per_all_people_f

688: hr_utility.set_location('Entering: '||c_proc_name,1);
689: end if;
690: -- Lock per_all_people_f to ensure person records are not created/updated/deleted
691: --
692: LOCK TABLE per_all_people_f
693: IN EXCLUSIVE MODE NOWAIT;
694: --
695: -- altering profile option
696: --

Line 925: ,p_national_id per_all_people_f.national_identifier%TYPE)

921: ,p_person_number varchar2
922: ,p_party_id number
923: ,p_date_of_birth date
924: ,p_start_date date
925: ,p_national_id per_all_people_f.national_identifier%TYPE)
926: RETURN VARCHAR2 IS
927:
928: l_proc varchar2(100) := g_pkg_name||'.execute_get_person_number_ff';
929: l_inputs ff_exec.inputs_t;