[Home] [Help]
PACKAGE BODY: APPS.HR_ASSIGNMENT_BUSINESS_EVENT
Source
1 Package Body HR_ASSIGNMENT_BUSINESS_EVENT as
2 /* $Header: peasgbev.pkb 120.0 2005/10/31 04:39:56 bshukla noship $ */
3
4 procedure assignment_business_event(
5 p_event in varchar2,
6 p_assignment_type in varchar2,
7 p_primary_flag in varchar2,
8 p_effective_date in date,
9 p_datetrack_update_mode in varchar2 default hr_api.g_update,
10 p_assignment_id in number,
11 p_object_version_number in number ,
12 p_grade_id in number default hr_api.g_number,
13 p_position_id in number default hr_api.g_number,
14 p_job_id in number default hr_api.g_number,
15 p_payroll_id in number default hr_api.g_number,
16 p_location_id in number default hr_api.g_number,
17 p_special_ceiling_step_id in number default hr_api.g_number,
18 p_organization_id in number default hr_api.g_number,
19 p_pay_basis_id in number default hr_api.g_number,
20 p_segment1 in varchar2 default hr_api.g_varchar2,
21 p_segment2 in varchar2 default hr_api.g_varchar2,
22 p_segment3 in varchar2 default hr_api.g_varchar2,
23 p_segment4 in varchar2 default hr_api.g_varchar2,
24 p_segment5 in varchar2 default hr_api.g_varchar2,
25 p_segment6 in varchar2 default hr_api.g_varchar2,
26 p_segment7 in varchar2 default hr_api.g_varchar2,
27 p_segment8 in varchar2 default hr_api.g_varchar2,
28 p_segment9 in varchar2 default hr_api.g_varchar2,
29 p_segment10 in varchar2 default hr_api.g_varchar2,
30 p_segment11 in varchar2 default hr_api.g_varchar2,
31 p_segment12 in varchar2 default hr_api.g_varchar2,
32 p_segment13 in varchar2 default hr_api.g_varchar2,
33 p_segment14 in varchar2 default hr_api.g_varchar2,
34 p_segment15 in varchar2 default hr_api.g_varchar2,
35 p_segment16 in varchar2 default hr_api.g_varchar2,
36 p_segment17 in varchar2 default hr_api.g_varchar2,
37 p_segment18 in varchar2 default hr_api.g_varchar2,
38 p_segment19 in varchar2 default hr_api.g_varchar2,
39 p_segment20 in varchar2 default hr_api.g_varchar2,
40 p_segment21 in varchar2 default hr_api.g_varchar2,
41 p_segment22 in varchar2 default hr_api.g_varchar2,
42 p_segment23 in varchar2 default hr_api.g_varchar2,
43 p_segment24 in varchar2 default hr_api.g_varchar2,
44 p_segment25 in varchar2 default hr_api.g_varchar2,
45 p_segment26 in varchar2 default hr_api.g_varchar2,
46 p_segment27 in varchar2 default hr_api.g_varchar2,
47 p_segment28 in varchar2 default hr_api.g_varchar2,
48 p_segment29 in varchar2 default hr_api.g_varchar2,
49 p_segment30 in varchar2 default hr_api.g_varchar2,
50 p_people_group_name in varchar2 default hr_api.g_varchar2,
51 p_group_name in varchar2 default hr_api.g_varchar2,
52 p_employment_category in varchar2 default hr_api.g_varchar2,
53 p_effective_start_date in date default hr_api.g_date,
54 p_effective_end_date in date default hr_api.g_date,
55 p_people_group_id in number default hr_api.g_number,
56 p_org_now_no_manager_warning in boolean default false,
57 p_other_manager_warning in boolean default false,
58 p_spp_delete_warning in boolean default false,
59 p_entries_changed_warning in varchar2 default hr_api.g_varchar2,
60 p_tax_district_changed_warning in boolean default false,
61 p_concat_segments in varchar2 default hr_api.g_varchar2,
62 p_contract_id in number default hr_api.g_number,
63 p_establishment_id in number default hr_api.g_number,
64 p_concatenated_segments in varchar2 default hr_api.g_varchar2,
65 p_soft_coding_keyflex_id in number default hr_api.g_number,
66 p_scl_segment1 in varchar2 default hr_api.g_varchar2)
67 is
68
69 l_proc varchar2(72) := 'raise_assignment_business_event';
70
71 begin
72 hr_utility.set_location('Entering: raise_assignment_business_event'|| l_proc, 10);
73 if p_event = 'UPDATE' then
74 hr_utility.set_location('Entering: UPDATE'|| l_proc, 20);
75 if p_assignment_type = 'E' and p_primary_flag = 'Y' then
76 hr_assignment_be3.update_emp_asg_criteria_a(
77 p_effective_date => p_effective_date,
78 p_datetrack_update_mode => p_datetrack_update_mode,
79 p_assignment_id => p_assignment_id,
80 p_object_version_number => p_object_version_number,
81 p_grade_id => p_grade_id,
82 p_position_id => p_position_id,
83 p_job_id => p_job_id,
84 p_payroll_id => p_payroll_id,
85 p_location_id => p_location_id,
86 p_special_ceiling_step_id => p_special_ceiling_step_id,
87 p_organization_id => p_organization_id,
88 p_pay_basis_id => p_pay_basis_id,
89 p_segment1 => p_segment1,
90 p_segment2 => p_segment2,
91 p_segment3 => p_segment3,
92 p_segment4 => p_segment4,
93 p_segment5 => p_segment5,
94 p_segment6 => p_segment6,
95 p_segment7 => p_segment7,
96 p_segment8 => p_segment8,
97 p_segment9 => p_segment9,
98 p_segment10 => p_segment10,
99 p_segment11 => p_segment11,
100 p_segment12 => p_segment12,
101 p_segment13 => p_segment13,
102 p_segment14 => p_segment14,
103 p_segment15 => p_segment15,
104 p_segment16 => p_segment16,
105 p_segment17 => p_segment17,
106 p_segment18 => p_segment18,
107 p_segment19 => p_segment19,
108 p_segment20 => p_segment20,
109 p_segment21 => p_segment21,
110 p_segment22 => p_segment22,
111 p_segment23 => p_segment23,
112 p_segment24 => p_segment24,
113 p_segment25 => p_segment25,
114 p_segment26 => p_segment26,
115 p_segment27 => p_segment27,
116 p_segment28 => p_segment28,
117 p_segment29 => p_segment29,
118 p_segment30 => p_segment30,
119 p_group_name => p_group_name,
120 p_employment_category => p_employment_category,
121 p_effective_start_date => p_effective_start_date,
122 p_effective_end_date => p_effective_end_date,
123 p_people_group_id => p_people_group_id,
124 p_org_now_no_manager_warning => p_org_now_no_manager_warning,
125 p_other_manager_warning => p_other_manager_warning,
126 p_spp_delete_warning => p_spp_delete_warning,
127 p_entries_changed_warning => p_entries_changed_warning,
128 p_tax_district_changed_warning => p_tax_district_changed_warning,
129 p_concat_segments => p_concat_segments,
130 p_contract_id => p_contract_id,
131 p_establishment_id => p_establishment_id,
132 p_concatenated_segments => p_concatenated_segments,
133 p_soft_coding_keyflex_id => p_soft_coding_keyflex_id,
134 p_scl_segment1 => p_scl_segment1
135 );
136
137 elsif p_assignment_type = 'C' and p_primary_flag = 'Y' then
138 hr_assignment_beO.update_cwk_asg_criteria_a(
139 p_effective_date => p_effective_date,
140 p_datetrack_update_mode => p_datetrack_update_mode,
141 p_assignment_id => p_assignment_id,
142 p_object_version_number => p_object_version_number,
143 p_grade_id => p_grade_id,
144 p_position_id => p_position_id,
145 p_job_id => p_job_id,
146 p_location_id => p_location_id,
147 p_organization_id => p_organization_id,
148 p_pay_basis_id => p_pay_basis_id,
149 p_segment1 => p_segment1,
150 p_segment2 => p_segment2,
151 p_segment3 => p_segment3,
152 p_segment4 => p_segment4,
153 p_segment5 => p_segment5,
154 p_segment6 => p_segment6,
155 p_segment7 => p_segment7,
156 p_segment8 => p_segment8,
157 p_segment9 => p_segment9,
158 p_segment10 => p_segment10,
159 p_segment11 => p_segment11,
160 p_segment12 => p_segment12,
161 p_segment13 => p_segment13,
162 p_segment14 => p_segment14,
163 p_segment15 => p_segment15,
164 p_segment16 => p_segment16,
165 p_segment17 => p_segment17,
166 p_segment18 => p_segment18,
167 p_segment19 => p_segment19,
168 p_segment20 => p_segment20,
169 p_segment21 => p_segment21,
170 p_segment22 => p_segment22,
171 p_segment23 => p_segment23,
172 p_segment24 => p_segment24,
173 p_segment25 => p_segment25,
174 p_segment26 => p_segment26,
175 p_segment27 => p_segment27,
176 p_segment28 => p_segment28,
177 p_segment29 => p_segment29,
178 p_segment30 => p_segment30,
179 p_people_group_name => p_people_group_name,
180 p_effective_start_date => p_effective_start_date,
181 p_effective_end_date => p_effective_end_date,
182 p_people_group_id => p_people_group_id,
183 p_org_now_no_manager_warning => p_org_now_no_manager_warning,
184 p_other_manager_warning => p_other_manager_warning,
185 p_spp_delete_warning => p_spp_delete_warning,
186 p_entries_changed_warning => p_entries_changed_warning,
187 p_tax_district_changed_warning => p_tax_district_changed_warning,
188 p_concat_segments => p_concat_segments
189 );
190 end if;
191 hr_utility.set_location('Leaving: UPDATE'|| l_proc, 30);
192 end if;
193 hr_utility.set_location('Leaving:'|| l_proc, 20);
194 end assignment_business_event;
195
196 end HR_ASSIGNMENT_BUSINESS_EVENT;