1 PACKAGE PER_PEOPLE9_PKG AUTHID CURRENT_USER AS
2 /* $Header: peper09t.pkh 115.2 2003/01/31 11:45:25 pkakar ship $ */
3 --
4 procedure insert_applicant_rows(p_person_id NUMBER
5 ,p_effective_start_date DATE
6 ,p_effective_end_date DATE
7 ,p_business_group_id NUMBER
8 ,p_app_ass_status_type_id NUMBER
9 ,p_request_id NUMBER
10 ,p_program_application_id NUMBER
11 ,p_program_id NUMBER
12 ,p_program_update_date DATE
13 ,p_last_update_date DATE
14 ,p_last_updated_by NUMBER
15 ,p_last_update_login NUMBER
16 ,p_created_by NUMBER
17 ,p_creation_date DATE);
18 --
19 procedure insert_employee_rows(p_person_id NUMBER
20 ,p_effective_start_date DATE
21 ,p_effective_end_date DATE
22 ,p_business_group_id NUMBER
23 ,p_emp_ass_status_type_id NUMBER
24 ,p_employee_number VARCHAR2
25 ,p_request_id NUMBER
26 ,p_program_application_id NUMBER
27 ,p_program_id NUMBER
28 ,p_program_update_date DATE
29 ,p_last_update_date DATE
30 ,p_last_updated_by NUMBER
31 ,p_last_update_login NUMBER
32 ,p_created_by NUMBER
33 ,p_creation_date DATE
34 ,p_adjusted_svc_date DATE);
35 --
36 procedure update_old_person_row(p_person_id NUMBER
37 ,p_session_date DATE
38 ,p_effective_start_date DATE);
39 --
40 END PER_PEOPLE9_PKG;