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_F

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 125: TYPE l_employee_number_type IS TABLE OF per_all_people_f.employee_number%TYPE

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

Line 133: from per_all_people_f

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

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

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

Line 192: from per_all_people_f

188: l_max_cwk_number NUMBER := 0;
189: --
190: cursor csr_cwk is
191: select npw_number
192: from per_all_people_f
193: where business_group_id = p_business_group_id
194: and npw_number is not null;
195: --
196: BEGIN

Line 264: l_organization_id per_all_people_f.business_group_id%TYPE;

260: l_continue_flag boolean := FALSE;
261: l_use_sequence boolean := FALSE;
262:
263:
264: l_organization_id per_all_people_f.business_group_id%TYPE;
265: l_rec_per_bg_groups t_bgRecord;
266: --
267: -- Returns the current method of number generation
268: --

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

295: hr_utility.trace(' person type = '||p_person_type);
296:
297: --
298: BEGIN
299: -- Lock per_all_people_f to ensure person records are not created/updated/deleted
300: --
301: hr_utility.set_location(c_proc_name,2);
302: l_rows_updated := 0;
303: l_organization_id := p_business_group_id;

Line 306: LOCK TABLE per_all_people_f

302: l_rows_updated := 0;
303: l_organization_id := p_business_group_id;
304: l_use_sequence := Global_person_numbering(p_person_type);
305:
306: LOCK TABLE per_all_people_f
307: IN EXCLUSIVE MODE NOWAIT;
308: --
309: open csr_method(p_business_group_id);
310: fetch csr_method into l_rec_per_bg_groups;

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

680: l_max_number := 1;
681: if g_debug then
682: hr_utility.set_location('Entering: '||c_proc_name,1);
683: end if;
684: -- Lock per_all_people_f to ensure person records are not created/updated/deleted
685: --
686: LOCK TABLE per_all_people_f
687: IN EXCLUSIVE MODE NOWAIT;
688: --

Line 686: LOCK TABLE per_all_people_f

682: hr_utility.set_location('Entering: '||c_proc_name,1);
683: end if;
684: -- Lock per_all_people_f to ensure person records are not created/updated/deleted
685: --
686: LOCK TABLE per_all_people_f
687: IN EXCLUSIVE MODE NOWAIT;
688: --
689: -- altering profile option
690: --

Line 919: ,p_national_id per_all_people_f.national_identifier%TYPE)

915: ,p_person_number varchar2
916: ,p_party_id number
917: ,p_date_of_birth date
918: ,p_start_date date
919: ,p_national_id per_all_people_f.national_identifier%TYPE)
920: RETURN VARCHAR2 IS
921:
922: l_proc varchar2(100) := g_pkg_name||'.execute_get_person_number_ff';
923: l_inputs ff_exec.inputs_t;