1 package HR_ASSIGNMENT_BUSINESS_EVENT AUTHID CURRENT_USER as
2 /* $Header: peasgbev.pkh 120.0.12020000.4 2012/07/05 01:14:36 amnaraya ship $ */
3 --
4 -- -----------------------------------------------------------------------------------
5 -- |--------------------------< assignment_business_event >--------------------------|
6 -- -----------------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- This package raises a business event when an assignment is updated.
11 --
12 -- Prerequisites:
13 -- None
14 -- In Parameters:
15 --
16 -- Name Reqd Type Description
17 -- p_event Y varchar2
18 -- p_assignment_type Y varchar2
19 -- p_primary_flag Y varchar2
20 -- p_effective_date Y date
21 -- p_datetrack_update_mode N varchar2
22 -- p_assignment_id Y number
23 -- p_object_version_number N number
24 -- p_grade_id N number
25 -- p_position_id N number
26 -- p_job_id N number
27 -- p_payroll_id N number
28 -- p_location_id N number
29 -- p_special_ceiling_step_id N number
30 -- p_organization_id N number
31 -- p_pay_basis_id N number
32 -- p_segment1 N varchar2
33 -- p_segment2 N varchar2
34 -- p_segment3 N varchar2
35 -- p_segment4 N varchar2
36 -- p_segment5 N varchar2
37 -- p_segment6 N varchar2
38 -- p_segment7 N varchar2
39 -- p_segment8 N varchar2
40 -- p_segment9 N varchar2
41 -- p_segment10 N varchar2
42 -- p_segment11 N varchar2
43 -- p_segment12 N varchar2
44 -- p_segment13 N varchar2
45 -- p_segment14 N varchar2
46 -- p_segment15 N varchar2
47 -- p_segment16 N varchar2
48 -- p_segment17 N varchar2
49 -- p_segment18 N varchar2
50 -- p_segment19 N varchar2
51 -- p_segment20 N varchar2
52 -- p_segment21 N varchar2
53 -- p_segment22 N varchar2
54 -- p_segment23 N varchar2
55 -- p_segment24 N varchar2
56 -- p_segment25 N varchar2
57 -- p_segment26 N varchar2
58 -- p_segment27 N varchar2
59 -- p_segment28 N varchar2
60 -- p_segment29 N varchar2
61 -- p_segment30 N varchar2
62 -- p_people_group_name N varchar2
63 -- p_group_name N varchar2
64 -- p_employment_category N varchar2
65 -- p_effective_start_date N date
66 -- p_effective_end_date N date
67 -- p_people_group_id N number
68 -- p_org_now_no_manager_warning N boolean
69 -- p_other_manager_warning N boolean
70 -- p_spp_delete_warning N boolean
71 -- p_entries_changed_warning N varchar2
72 -- p_tax_district_changed_warning N boolean
73 -- p_concat_segments N varchar2
74 -- p_contract_id N number
75 -- p_establishment_id N number
76 -- p_concatenated_segments N varchar2
77 -- p_soft_coding_keyflex_id N number
78 -- p_scl_segment1 N varchar2
79 --
80 -- Post Success:
81 -- A Business Event will be raised on update of Assignment.
82 --
83 --
84 -- Post Failure:
85 -- Business Event will not be raised and an error will be raised.
86 --
87 -- Access Status:
88 -- Public.
89 --
90 -- {End Of Comments}
91
92
93 procedure assignment_business_event(
94 p_event in varchar2,
95 p_assignment_type in varchar2,
96 p_primary_flag in varchar2,
97 p_effective_date in date,
98 p_datetrack_update_mode in varchar2 default hr_api.g_update,
99 p_assignment_id in number,
100 p_object_version_number in number,
101 p_grade_id in number default hr_api.g_number,
102 p_position_id in number default hr_api.g_number,
103 p_job_id in number default hr_api.g_number,
104 p_payroll_id in number default hr_api.g_number,
105 p_location_id in number default hr_api.g_number,
106 p_special_ceiling_step_id in number default hr_api.g_number,
107 p_organization_id in number default hr_api.g_number,
108 p_pay_basis_id in number default hr_api.g_number,
109 p_segment1 in varchar2 default hr_api.g_varchar2,
110 p_segment2 in varchar2 default hr_api.g_varchar2,
111 p_segment3 in varchar2 default hr_api.g_varchar2,
112 p_segment4 in varchar2 default hr_api.g_varchar2,
113 p_segment5 in varchar2 default hr_api.g_varchar2,
114 p_segment6 in varchar2 default hr_api.g_varchar2,
115 p_segment7 in varchar2 default hr_api.g_varchar2,
116 p_segment8 in varchar2 default hr_api.g_varchar2,
117 p_segment9 in varchar2 default hr_api.g_varchar2,
118 p_segment10 in varchar2 default hr_api.g_varchar2,
119 p_segment11 in varchar2 default hr_api.g_varchar2,
120 p_segment12 in varchar2 default hr_api.g_varchar2,
121 p_segment13 in varchar2 default hr_api.g_varchar2,
122 p_segment14 in varchar2 default hr_api.g_varchar2,
123 p_segment15 in varchar2 default hr_api.g_varchar2,
124 p_segment16 in varchar2 default hr_api.g_varchar2,
125 p_segment17 in varchar2 default hr_api.g_varchar2,
126 p_segment18 in varchar2 default hr_api.g_varchar2,
127 p_segment19 in varchar2 default hr_api.g_varchar2,
128 p_segment20 in varchar2 default hr_api.g_varchar2,
129 p_segment21 in varchar2 default hr_api.g_varchar2,
130 p_segment22 in varchar2 default hr_api.g_varchar2,
131 p_segment23 in varchar2 default hr_api.g_varchar2,
132 p_segment24 in varchar2 default hr_api.g_varchar2,
133 p_segment25 in varchar2 default hr_api.g_varchar2,
134 p_segment26 in varchar2 default hr_api.g_varchar2,
135 p_segment27 in varchar2 default hr_api.g_varchar2,
136 p_segment28 in varchar2 default hr_api.g_varchar2,
137 p_segment29 in varchar2 default hr_api.g_varchar2,
138 p_segment30 in varchar2 default hr_api.g_varchar2,
139 p_people_group_name in varchar2 default hr_api.g_varchar2,
140 p_group_name in varchar2 default hr_api.g_varchar2,
141 p_employment_category in varchar2 default hr_api.g_varchar2,
142 p_effective_start_date in date default hr_api.g_date,
143 p_effective_end_date in date default hr_api.g_date,
144 p_people_group_id in number default hr_api.g_number,
145 p_org_now_no_manager_warning in boolean default false,
146 p_other_manager_warning in boolean default false,
147 p_spp_delete_warning in boolean default false,
148 p_entries_changed_warning in varchar2 default hr_api.g_varchar2,
149 p_tax_district_changed_warning in boolean default false,
150 p_concat_segments in varchar2 default hr_api.g_varchar2,
151 p_contract_id in number default hr_api.g_number,
152 p_establishment_id in number default hr_api.g_number,
153 p_concatenated_segments in varchar2 default hr_api.g_varchar2,
154 p_soft_coding_keyflex_id in number default hr_api.g_number,
155 p_scl_segment1 in varchar2 default hr_api.g_varchar2,
156 p_supervisor_id in number default hr_api.g_number,
157 p_assignment_number in varchar2 default hr_api.g_varchar2,
158 p_change_reason in varchar2 default hr_api.g_varchar2,
159 p_assignment_status_type_id in number default hr_api.g_varchar2,
160 p_comments in varchar2 default hr_api.g_varchar2,
161 p_date_probation_end in date default hr_api.g_date,
162 p_default_code_comb_id in number default hr_api.g_number,
163 p_frequency in varchar2 default hr_api.g_varchar2,
164 p_internal_address_line in varchar2 default hr_api.g_varchar2,
165 p_manager_flag in varchar2 default hr_api.g_varchar2,
166 p_normal_hours in number default hr_api.g_number,
167 p_perf_review_period in number default hr_api.g_number,
168 p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2,
169 p_probation_period in number default hr_api.g_number,
170 p_probation_unit in varchar2 default hr_api.g_varchar2,
171 p_projected_assignment_end in varchar2 default hr_api.g_varchar2,
172 p_sal_review_period in number default hr_api.g_number,
173 p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2,
174 p_set_of_books_id in number default hr_api.g_number,
175 p_source_type in varchar2 default hr_api.g_varchar2,
176 p_time_normal_finish in varchar2 default hr_api.g_varchar2,
177 p_time_normal_start in varchar2 default hr_api.g_varchar2,
178 p_bargaining_unit_code in varchar2 default hr_api.g_varchar2,
179 p_labour_union_member_flag in varchar2 default hr_api.g_varchar2,
180 p_hourly_salaried_code in varchar2 default hr_api.g_varchar2,
181 p_ass_attribute_category in varchar2 default hr_api.g_varchar2,
182 p_ass_attribute1 in varchar2 default hr_api.g_varchar2,
183 p_ass_attribute2 in varchar2 default hr_api.g_varchar2,
184 p_ass_attribute3 in varchar2 default hr_api.g_varchar2,
185 p_ass_attribute4 in varchar2 default hr_api.g_varchar2,
186 p_ass_attribute5 in varchar2 default hr_api.g_varchar2,
187 p_ass_attribute6 in varchar2 default hr_api.g_varchar2,
188 p_ass_attribute7 in varchar2 default hr_api.g_varchar2,
189 p_ass_attribute8 in varchar2 default hr_api.g_varchar2,
190 p_ass_attribute9 in varchar2 default hr_api.g_varchar2,
191 p_ass_attribute10 in varchar2 default hr_api.g_varchar2,
192 p_ass_attribute11 in varchar2 default hr_api.g_varchar2,
193 p_ass_attribute12 in varchar2 default hr_api.g_varchar2,
194 p_ass_attribute13 in varchar2 default hr_api.g_varchar2,
195 p_ass_attribute14 in varchar2 default hr_api.g_varchar2,
196 p_ass_attribute15 in varchar2 default hr_api.g_varchar2,
197 p_ass_attribute16 in varchar2 default hr_api.g_varchar2,
198 p_ass_attribute17 in varchar2 default hr_api.g_varchar2,
199 p_ass_attribute18 in varchar2 default hr_api.g_varchar2,
200 p_ass_attribute19 in varchar2 default hr_api.g_varchar2,
201 p_ass_attribute20 in varchar2 default hr_api.g_varchar2,
202 p_ass_attribute21 in varchar2 default hr_api.g_varchar2,
203 p_ass_attribute22 in varchar2 default hr_api.g_varchar2,
204 p_ass_attribute23 in varchar2 default hr_api.g_varchar2,
205 p_ass_attribute24 in varchar2 default hr_api.g_varchar2,
206 p_ass_attribute25 in varchar2 default hr_api.g_varchar2,
207 p_ass_attribute26 in varchar2 default hr_api.g_varchar2,
208 p_ass_attribute27 in varchar2 default hr_api.g_varchar2,
209 p_ass_attribute28 in varchar2 default hr_api.g_varchar2,
210 p_ass_attribute29 in varchar2 default hr_api.g_varchar2,
211 p_ass_attribute30 in varchar2 default hr_api.g_varchar2,
212 p_title in varchar2 default hr_api.g_varchar2,
213 p_comment_id in number default hr_api.g_number,
214 p_no_managers_warning in boolean default false,
215 p_hourly_salaried_warning in boolean default false,
216 p_collective_agreement_id in number default hr_api.g_number,
217 p_cagr_id_flex_num in number default hr_api.g_number,
218 p_cag_segment1 in varchar2 default hr_api.g_varchar2,
219 p_cag_segment2 in varchar2 default hr_api.g_varchar2,
220 p_cag_segment3 in varchar2 default hr_api.g_varchar2,
221 p_cag_segment4 in varchar2 default hr_api.g_varchar2,
222 p_cag_segment5 in varchar2 default hr_api.g_varchar2,
223 p_cag_segment6 in varchar2 default hr_api.g_varchar2,
224 p_cag_segment7 in varchar2 default hr_api.g_varchar2,
225 p_cag_segment8 in varchar2 default hr_api.g_varchar2,
226 p_cag_segment9 in varchar2 default hr_api.g_varchar2,
227 p_cag_segment10 in varchar2 default hr_api.g_varchar2,
228 p_cag_segment11 in varchar2 default hr_api.g_varchar2,
229 p_cag_segment12 in varchar2 default hr_api.g_varchar2,
230 p_cag_segment13 in varchar2 default hr_api.g_varchar2,
231 p_cag_segment14 in varchar2 default hr_api.g_varchar2,
232 p_cag_segment15 in varchar2 default hr_api.g_varchar2,
233 p_cag_segment16 in varchar2 default hr_api.g_varchar2,
234 p_cag_segment17 in varchar2 default hr_api.g_varchar2,
235 p_cag_segment18 in varchar2 default hr_api.g_varchar2,
236 p_cag_segment19 in varchar2 default hr_api.g_varchar2,
237 p_cag_segment20 in varchar2 default hr_api.g_varchar2,
238 p_notice_period in number default hr_api.g_number,
239 p_notice_period_uom in varchar2 default hr_api.g_varchar2,
240 p_employee_category in varchar2 default hr_api.g_varchar2,
241 p_work_at_home in varchar2 default hr_api.g_varchar2,
242 p_job_post_source_name in varchar2 default hr_api.g_varchar2,
243 p_cagr_grade_def_id in number default hr_api.g_number,
244 p_cagr_concatenated_segments in varchar2 default hr_api.g_varchar2,
245 p_supervisor_assignment_id in number default hr_api.g_number);
246
247 end HR_ASSIGNMENT_BUSINESS_EVENT;
[Home] [Help]