DBA Data[Home] [Help]

PACKAGE: APPS.BEN_CPI_UPD

Source


1 Package ben_cpi_upd as
2 /* $Header: becpirhi.pkh 120.0 2005/05/28 01:13 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |----------------------------------< upd >---------------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 --   This procedure is the record interface for the update
11 --   process for the specified entity. The role of this process is
12 --   to update a fully validated row for the HR schema passing back
13 --   to the calling process, any system generated values (e.g.
14 --   object version number attribute). This process is the main
15 --   backbone of the upd business process. The processing of this
16 --   procedure is as follows:
17 --   1) The row to be updated is locked and selected into the record
18 --      structure g_old_rec.
19 --   2) Because on update parameters which are not part of the update do not
20 --      have to be defaulted, we need to build up the updated row by
21 --      converting any system defaulted parameters to their corresponding
22 --      value.
23 --   3) The controlling validation process update_validate is then executed
24 --      which will execute all private and public validation business rule
25 --      processes.
26 --   4) The pre_update process is then executed which enables any
27 --      logic to be processed before the update dml process is executed.
28 --   5) The update_dml process will physical perform the update dml into the
29 --      specified entity.
30 --   6) The post_update process is then executed which enables any
31 --      logic to be processed after the update dml process.
32 --
33 -- Prerequisites:
34 --   The main parameters to the business process have to be in the record
35 --   format.
36 --
37 -- In Parameters:
38 --
39 -- Post Success:
40 --   The specified row will be fully validated and updated for the specified
41 --   entity without being committed.
42 --
43 -- Post Failure:
44 --   If an error has occurred, an error message will be raised.
45 --
46 -- Developer Implementation Notes:
47 --   None.
48 --
49 -- Access Status:
50 --   Internal Development Use Only.
51 --
52 -- {End Of Comments}
53 -- ----------------------------------------------------------------------------
54 Procedure upd
55   (p_rec                          in out nocopy ben_cpi_shd.g_rec_type
56   );
57 --
58 -- ----------------------------------------------------------------------------
59 -- |---------------------------------< upd >----------------------------------|
60 -- ----------------------------------------------------------------------------
61 -- {Start Of Comments}
62 --
63 -- Description:
64 --   This procedure is the attribute interface for the update
65 --   process for the specified entity and is the outermost layer. The role
66 --   of this process is to update a fully validated row into the HR schema
67 --   passing back to the calling process, any system generated values
68 --   (e.g. object version number attributes). The processing of this
69 --   procedure is as follows:
70 --   1) The attributes are converted into a local record structure by
71 --      calling the convert_args function.
72 --   2) After the conversion has taken place, the corresponding record upd
73 --      interface process is executed.
74 --   3) OUT parameters are then set to their corresponding record attributes.
75 --
76 -- Prerequisites:
77 --
78 -- In Parameters:
79 --
80 -- Post Success:
81 --   A fully validated row will be updated for the specified entity
82 --   without being committed.
83 --
84 -- Post Failure:
85 --   If an error has occurred, an error message will be raised.
86 --
87 -- Developer Implementation Notes:
88 --   None.
89 --
90 -- Access Status:
91 --   Internal Development Use Only.
92 --
93 -- {End Of Comments}
94 -- ----------------------------------------------------------------------------
95 Procedure upd
96   (p_group_per_in_ler_id          in     number
97   ,p_object_version_number        in out nocopy number
98   ,p_assignment_id                in     number    default hr_api.g_number
99   ,p_person_id                    in     number    default hr_api.g_number
100   ,p_supervisor_id                in     number    default hr_api.g_number
101   ,p_effective_date               in     date      default hr_api.g_date
102   ,p_full_name                    in     varchar2  default hr_api.g_varchar2
103   ,p_brief_name                   in     varchar2  default hr_api.g_varchar2
104   ,p_custom_name                  in     varchar2  default hr_api.g_varchar2
105   ,p_supervisor_full_name         in     varchar2  default hr_api.g_varchar2
106   ,p_supervisor_brief_name        in     varchar2  default hr_api.g_varchar2
107   ,p_supervisor_custom_name       in     varchar2  default hr_api.g_varchar2
108   ,p_legislation_code             in     varchar2  default hr_api.g_varchar2
109   ,p_years_employed               in     number    default hr_api.g_number
110   ,p_years_in_job                 in     number    default hr_api.g_number
111   ,p_years_in_position            in     number    default hr_api.g_number
112   ,p_years_in_grade               in     number    default hr_api.g_number
113   ,p_employee_number              in     varchar2  default hr_api.g_varchar2
114   ,p_start_date                   in     date      default hr_api.g_date
115   ,p_original_start_date          in     date      default hr_api.g_date
116   ,p_adjusted_svc_date            in     date      default hr_api.g_date
117   ,p_base_salary                  in     number    default hr_api.g_number
118   ,p_base_salary_change_date      in     date      default hr_api.g_date
119   ,p_payroll_name                 in     varchar2  default hr_api.g_varchar2
120   ,p_performance_rating           in     varchar2  default hr_api.g_varchar2
121   ,p_performance_rating_type      in     varchar2  default hr_api.g_varchar2
122   ,p_performance_rating_date      in     date      default hr_api.g_date
123   ,p_business_group_id            in     number    default hr_api.g_number
124   ,p_organization_id              in     number    default hr_api.g_number
125   ,p_job_id                       in     number    default hr_api.g_number
126   ,p_grade_id                     in     number    default hr_api.g_number
127   ,p_position_id                  in     number    default hr_api.g_number
128   ,p_people_group_id              in     number    default hr_api.g_number
129   ,p_soft_coding_keyflex_id       in     number    default hr_api.g_number
130   ,p_location_id                  in     number    default hr_api.g_number
131   ,p_pay_rate_id                  in     number    default hr_api.g_number
132   ,p_assignment_status_type_id    in     number    default hr_api.g_number
133   ,p_frequency                    in     varchar2  default hr_api.g_varchar2
134   ,p_grade_annulization_factor    in     number    default hr_api.g_number
135   ,p_pay_annulization_factor      in     number    default hr_api.g_number
136   ,p_grd_min_val                  in     number    default hr_api.g_number
137   ,p_grd_max_val                  in     number    default hr_api.g_number
138   ,p_grd_mid_point                in     number    default hr_api.g_number
139   ,p_grd_quartile                 in     varchar2  default hr_api.g_varchar2
140   ,p_grd_comparatio               in     number    default hr_api.g_number
141   ,p_emp_category                 in     varchar2  default hr_api.g_varchar2
142   ,p_change_reason                in     varchar2  default hr_api.g_varchar2
143   ,p_normal_hours                 in     number    default hr_api.g_number
144   ,p_email_address                in     varchar2  default hr_api.g_varchar2
145   ,p_base_salary_frequency        in     varchar2  default hr_api.g_varchar2
146   ,p_new_assgn_ovn                in     number    default hr_api.g_number
147   ,p_new_perf_event_id            in     number    default hr_api.g_number
148   ,p_new_perf_review_id           in     number    default hr_api.g_number
149   ,p_post_process_stat_cd         in     varchar2  default hr_api.g_varchar2
150   ,p_feedback_rating              in     varchar2  default hr_api.g_varchar2
151   ,p_feedback_comments            in     varchar2  default hr_api.g_varchar2
152   ,p_custom_segment1              in     varchar2  default hr_api.g_varchar2
153   ,p_custom_segment2              in     varchar2  default hr_api.g_varchar2
154   ,p_custom_segment3              in     varchar2  default hr_api.g_varchar2
155   ,p_custom_segment4              in     varchar2  default hr_api.g_varchar2
156   ,p_custom_segment5              in     varchar2  default hr_api.g_varchar2
157   ,p_custom_segment6              in     varchar2  default hr_api.g_varchar2
158   ,p_custom_segment7              in     varchar2  default hr_api.g_varchar2
159   ,p_custom_segment8              in     varchar2  default hr_api.g_varchar2
160   ,p_custom_segment9              in     varchar2  default hr_api.g_varchar2
161   ,p_custom_segment10             in     varchar2  default hr_api.g_varchar2
162   ,p_custom_segment11             in     number    default hr_api.g_number
163   ,p_custom_segment12             in     number    default hr_api.g_number
164   ,p_custom_segment13             in     number    default hr_api.g_number
165   ,p_custom_segment14             in     number    default hr_api.g_number
166   ,p_custom_segment15             in     number    default hr_api.g_number
167   ,p_custom_segment16             in     number    default hr_api.g_number
168   ,p_custom_segment17             in     number    default hr_api.g_number
169   ,p_custom_segment18             in     number    default hr_api.g_number
170   ,p_custom_segment19             in     number    default hr_api.g_number
171   ,p_custom_segment20             in     number    default hr_api.g_number
172   ,p_people_group_name            in     varchar2  default hr_api.g_varchar2
173   ,p_people_group_segment1        in     varchar2  default hr_api.g_varchar2
174   ,p_people_group_segment2        in     varchar2  default hr_api.g_varchar2
175   ,p_people_group_segment3        in     varchar2  default hr_api.g_varchar2
176   ,p_people_group_segment4        in     varchar2  default hr_api.g_varchar2
177   ,p_people_group_segment5        in     varchar2  default hr_api.g_varchar2
178   ,p_people_group_segment6        in     varchar2  default hr_api.g_varchar2
179   ,p_people_group_segment7        in     varchar2  default hr_api.g_varchar2
180   ,p_people_group_segment8        in     varchar2  default hr_api.g_varchar2
181   ,p_people_group_segment9        in     varchar2  default hr_api.g_varchar2
182   ,p_people_group_segment10       in     varchar2  default hr_api.g_varchar2
183   ,p_people_group_segment11       in     varchar2  default hr_api.g_varchar2
184   ,p_ass_attribute_category       in     varchar2  default hr_api.g_varchar2
185   ,p_ass_attribute1               in     varchar2  default hr_api.g_varchar2
186   ,p_ass_attribute2               in     varchar2  default hr_api.g_varchar2
187   ,p_ass_attribute3               in     varchar2  default hr_api.g_varchar2
188   ,p_ass_attribute4               in     varchar2  default hr_api.g_varchar2
189   ,p_ass_attribute5               in     varchar2  default hr_api.g_varchar2
190   ,p_ass_attribute6               in     varchar2  default hr_api.g_varchar2
191   ,p_ass_attribute7               in     varchar2  default hr_api.g_varchar2
192   ,p_ass_attribute8               in     varchar2  default hr_api.g_varchar2
193   ,p_ass_attribute9               in     varchar2  default hr_api.g_varchar2
194   ,p_ass_attribute10              in     varchar2  default hr_api.g_varchar2
195   ,p_ass_attribute11              in     varchar2  default hr_api.g_varchar2
196   ,p_ass_attribute12              in     varchar2  default hr_api.g_varchar2
197   ,p_ass_attribute13              in     varchar2  default hr_api.g_varchar2
198   ,p_ass_attribute14              in     varchar2  default hr_api.g_varchar2
199   ,p_ass_attribute15              in     varchar2  default hr_api.g_varchar2
200   ,p_ass_attribute16              in     varchar2  default hr_api.g_varchar2
201   ,p_ass_attribute17              in     varchar2  default hr_api.g_varchar2
202   ,p_ass_attribute18              in     varchar2  default hr_api.g_varchar2
203   ,p_ass_attribute19              in     varchar2  default hr_api.g_varchar2
204   ,p_ass_attribute20              in     varchar2  default hr_api.g_varchar2
205   ,p_ass_attribute21              in     varchar2  default hr_api.g_varchar2
206   ,p_ass_attribute22              in     varchar2  default hr_api.g_varchar2
207   ,p_ass_attribute23              in     varchar2  default hr_api.g_varchar2
208   ,p_ass_attribute24              in     varchar2  default hr_api.g_varchar2
209   ,p_ass_attribute25              in     varchar2  default hr_api.g_varchar2
210   ,p_ass_attribute26              in     varchar2  default hr_api.g_varchar2
211   ,p_ass_attribute27              in     varchar2  default hr_api.g_varchar2
212   ,p_ass_attribute28              in     varchar2  default hr_api.g_varchar2
216   ,p_cpi_attribute_category       in     varchar2  default hr_api.g_varchar2
213   ,p_ass_attribute29              in     varchar2  default hr_api.g_varchar2
214   ,p_ass_attribute30              in     varchar2  default hr_api.g_varchar2
215   ,p_ws_comments                  in     varchar2  default hr_api.g_varchar2
217   ,p_cpi_attribute1               in     varchar2  default hr_api.g_varchar2
218   ,p_cpi_attribute2               in     varchar2  default hr_api.g_varchar2
219   ,p_cpi_attribute3               in     varchar2  default hr_api.g_varchar2
220   ,p_cpi_attribute4               in     varchar2  default hr_api.g_varchar2
221   ,p_cpi_attribute5               in     varchar2  default hr_api.g_varchar2
222   ,p_cpi_attribute6               in     varchar2  default hr_api.g_varchar2
223   ,p_cpi_attribute7               in     varchar2  default hr_api.g_varchar2
224   ,p_cpi_attribute8               in     varchar2  default hr_api.g_varchar2
225   ,p_cpi_attribute9               in     varchar2  default hr_api.g_varchar2
226   ,p_cpi_attribute10              in     varchar2  default hr_api.g_varchar2
227   ,p_cpi_attribute11              in     varchar2  default hr_api.g_varchar2
228   ,p_cpi_attribute12              in     varchar2  default hr_api.g_varchar2
229   ,p_cpi_attribute13              in     varchar2  default hr_api.g_varchar2
230   ,p_cpi_attribute14              in     varchar2  default hr_api.g_varchar2
231   ,p_cpi_attribute15              in     varchar2  default hr_api.g_varchar2
232   ,p_cpi_attribute16              in     varchar2  default hr_api.g_varchar2
233   ,p_cpi_attribute17              in     varchar2  default hr_api.g_varchar2
234   ,p_cpi_attribute18              in     varchar2  default hr_api.g_varchar2
235   ,p_cpi_attribute19              in     varchar2  default hr_api.g_varchar2
236   ,p_cpi_attribute20              in     varchar2  default hr_api.g_varchar2
237   ,p_cpi_attribute21              in     varchar2  default hr_api.g_varchar2
238   ,p_cpi_attribute22              in     varchar2  default hr_api.g_varchar2
239   ,p_cpi_attribute23              in     varchar2  default hr_api.g_varchar2
240   ,p_cpi_attribute24              in     varchar2  default hr_api.g_varchar2
241   ,p_cpi_attribute25              in     varchar2  default hr_api.g_varchar2
242   ,p_cpi_attribute26              in     varchar2  default hr_api.g_varchar2
243   ,p_cpi_attribute27              in     varchar2  default hr_api.g_varchar2
244   ,p_cpi_attribute28              in     varchar2  default hr_api.g_varchar2
245   ,p_cpi_attribute29              in     varchar2  default hr_api.g_varchar2
246   ,p_cpi_attribute30              in     varchar2  default hr_api.g_varchar2
247   ,p_feedback_date                in     date      default hr_api.g_date
248   );
249 --
250 end ben_cpi_upd;