1 PACKAGE PER_PEOPLE3_PKG AS
2 /* $Header: peper03t.pkh 120.0.12000000.2 2007/05/02 12:04:11 pdkundu noship $ */
3 --
4 procedure get_number_generation_property(
5 p_business_group_id NUMBER
6 ,p_property_on NUMBER
7 ,p_property_off NUMBER
8 ,p_employee_property in out nocopy NUMBER
9 ,p_applicant_property in out nocopy NUMBER);
10 --
11 procedure get_legislative_ages(p_business_group_id NUMBER
12 ,p_minimum_age IN OUT NOCOPY NUMBER
13 ,p_maximum_age IN OUT NOCOPY NUMBER);
14 --
15 procedure get_default_person_type(p_required_type VARCHAR2
16 ,p_business_group_id NUMBER
17 ,p_legislation_code VARCHAR2
18 ,p_person_type IN OUT NOCOPY NUMBER);
19 procedure get_ddf_exists(p_legislation_code VARCHAR2
20 ,p_ddf_exists IN OUT NOCOPY VARCHAR2);
21 --
22 -- #1799586
23 procedure get_people_ddf_exists(p_legislation_code VARCHAR2
24 ,p_people_ddf_exists IN OUT NOCOPY VARCHAR2);
25 --
26 procedure initialize(p_business_group_id NUMBER
27 ,p_legislation_code VARCHAR2
28 ,p_ddf_exists IN OUT NOCOPY VARCHAR2
29 ,p_property_on NUMBER
30 ,p_property_off NUMBER
31 ,p_employee_property in out nocopy NUMBER
32 ,p_applicant_property in out nocopy NUMBER
33 ,p_required_emp_type VARCHAR2
34 ,p_required_app_type VARCHAR2
35 ,p_emp_person_type IN OUT NOCOPY NUMBER
36 ,p_app_person_type IN OUT NOCOPY NUMBER);
37 --
38 procedure initialize(p_business_group_id NUMBER
39 ,p_legislation_code VARCHAR2
40 ,p_ddf_exists IN OUT NOCOPY VARCHAR2
41 ,p_property_on NUMBER
42 ,p_property_off NUMBER
43 ,p_employee_property in out nocopy NUMBER
44 ,p_applicant_property in out nocopy NUMBER
45 ,p_required_emp_type VARCHAR2
46 ,p_required_app_type VARCHAR2
47 ,p_emp_person_type IN OUT NOCOPY NUMBER
48 ,p_app_person_type IN OUT NOCOPY NUMBER
49 ,p_minimum_age IN OUT NOCOPY NUMBER
50 ,p_maximum_age IN OUT NOCOPY NUMBER);
51 --
52 procedure initialize(p_business_group_id NUMBER
53 ,p_legislation_code VARCHAR2
54 ,p_ddf_exists IN OUT NOCOPY VARCHAR2
55 ,p_property_on NUMBER
56 ,p_property_off NUMBER
57 ,p_employee_property in out nocopy NUMBER
58 ,p_applicant_property in out nocopy NUMBER
59 ,p_required_emp_type VARCHAR2
60 ,p_required_app_type VARCHAR2
61 ,p_emp_person_type IN OUT NOCOPY NUMBER
62 ,p_app_person_type IN OUT NOCOPY NUMBER
63 ,p_minimum_age IN OUT NOCOPY NUMBER
64 ,p_maximum_age IN OUT NOCOPY NUMBER
65 ,p_people_ddf_exists IN OUT NOCOPY VARCHAR2);
66 --
67 procedure check_future_apl(p_person_id NUMBER
68 ,p_hire_date DATE);
69 --added for bug 5403222
70 procedure check_future_apl(p_person_id NUMBER
71 ,p_hire_date DATE
72 ,p_table HR_EMPLOYEE_APPLICANT_API.t_ApplTable );
73 --
74 --
75 procedure update_period(p_person_id number
76 ,p_hire_date date
77 ,p_new_hire_date date
78 ,p_adjusted_svc_date in date default hr_api.g_date);
79 --
80 procedure run_alu_ee(p_alu_mode VARCHAR2
81 ,p_business_group_id NUMBER
82 ,p_person_id NUMBER
83 ,p_old_start DATE
84 ,p_start_date date);
85 --
86 procedure vacancy_chk (p_person_id NUMBER
87 ,p_fire_warning in out nocopy VARCHAR2
88 ,p_vacancy_id in out nocopy NUMBER
89 -- #2381925
90 ,p_table IN HR_EMPLOYEE_APPLICANT_API.t_ApplTable
91 default HR_EMPLOYEE_APPLICANT_API.T_EmptyAPPL
92 --
93 );
94 --
95 procedure get_accepted_appls(p_person_id NUMBER
96 ,p_num_accepted_appls in out nocopy NUMBER
97 ,p_new_primary_id in out nocopy NUMBER);
98 --
99 procedure get_all_current_appls(p_person_id NUMBER
100 ,p_num_appls in out nocopy NUMBER);
101 --
102 procedure get_date_range(p_person_id in number
103 ,p_min_start in out nocopy date
104 ,p_max_end in out nocopy date);
105 --
106 procedure get_asg_date_range(p_assignment_id in number
107 ,p_min_start in out nocopy date
108 ,p_max_end in out nocopy date);
109 --
110 procedure form_post_query(p_ethnic_code IN VARCHAR2
111 ,p_ethnic_meaning IN OUT NOCOPY VARCHAR2
112 ,p_visa_code IN VARCHAR2
113 ,p_visa_meaning IN OUT NOCOPY VARCHAR2
114 ,p_veteran_code IN VARCHAR2
115 ,p_veteran_meaning IN OUT NOCOPY VARCHAR2
116 ,p_i9_code IN VARCHAR2
117 ,p_i9_meaning IN OUT NOCOPY VARCHAR2
118 ,p_legislation_code IN VARCHAR2);
119 --
120 procedure form_post_query(p_ethnic_code IN VARCHAR2
121 ,p_ethnic_meaning IN OUT NOCOPY VARCHAR2
122 ,p_visa_code IN VARCHAR2
123 ,p_visa_meaning IN OUT NOCOPY VARCHAR2
124 ,p_veteran_code IN VARCHAR2
125 ,p_veteran_meaning IN OUT NOCOPY VARCHAR2
126 ,p_i9_code IN VARCHAR2
127 ,p_i9_meaning IN OUT NOCOPY VARCHAR2
128 ,p_new_hire_code IN VARCHAR2
129 ,p_new_hire_meaning IN OUT NOCOPY VARCHAR2
130 ,p_reason_for_code IN VARCHAR2
131 ,p_reason_for_meaning IN OUT NOCOPY VARCHAR2
132 ,p_legislation_code IN VARCHAR2);
133 --
134 procedure form_post_query(p_ethnic_code IN VARCHAR2
135 ,p_ethnic_meaning IN OUT NOCOPY VARCHAR2
136 ,p_visa_code IN VARCHAR2
137 ,p_visa_meaning IN OUT NOCOPY VARCHAR2
138 ,p_veteran_code IN VARCHAR2
139 ,p_veteran_meaning IN OUT NOCOPY VARCHAR2
140 ,p_i9_code IN VARCHAR2
141 ,p_i9_meaning IN OUT NOCOPY VARCHAR2
142 ,p_new_hire_code IN VARCHAR2
143 ,p_new_hire_meaning IN OUT NOCOPY VARCHAR2
144 ,p_reason_for_code IN VARCHAR2
145 ,p_reason_for_meaning IN OUT NOCOPY VARCHAR2
146 ,p_ethnic_disc_code IN VARCHAR2
147 ,p_ethnic_disc_meaning IN OUT NOCOPY VARCHAR2
148 ,p_legislation_code IN VARCHAR2);
149 --
150 function chk_events_exist(p_person_id number
151 ,p_business_group_id number
152 ,p_hire_date date )return boolean;
153 --
154 END PER_PEOPLE3_PKG;