DBA Data[Home] [Help]

PACKAGE: APPS.PER_INC_INS

Source


1 Package per_inc_ins AUTHID CURRENT_USER as
2 /* $Header: peincrhi.pkh 120.1 2010/06/15 08:24:24 sudsahu ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |---------------------------------< ins >----------------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 --   This procedure is the record interface for the insert process
11 --   for the specified entity. The role of this process is to insert a fully
12 --   validated row, into the HR schema passing back to  the calling process,
13 --   any system generated values (e.g. primary and object version number
14 --   attributes). This process is the main backbone of the ins
15 --   process. The processing of this procedure is as follows:
16 --   1) The controlling validation process insert_validate is executed
17 --      which will execute all private and public validation business rule
18 --      processes.
19 --   2) The pre_insert business process is then executed which enables any
20 --      logic to be processed before the insert dml process is executed.
21 --   3) The insert_dml process will physical perform the insert dml into the
22 --      specified entity.
23 --   4) The post_insert business process is then executed which enables any
24 --      logic to be processed after the insert dml process.
25 --
26 -- Prerequisites:
27 --   The main parameters to the this process have to be in the record
28 --   format.
29 --
30 -- In Parameters:
31 --
32 -- Post Success:
33 --   A fully validated row will be inserted into the specified entity
34 --   without being committed.
35 --
36 -- Post Failure:
37 --   If an error has occurred, an error message will be raised.
38 --
39 -- Developer Implementation Notes:
40 --   None.
41 --
42 -- Access Status:
43 --   Internal Development Use Only.
44 --
45 -- {End Of Comments}
46 -- ----------------------------------------------------------------------------
47 Procedure ins
48   (p_effective_date               in date
49   ,p_rec                          in out nocopy per_inc_shd.g_rec_type
50   );
51 --
52 -- ----------------------------------------------------------------------------
53 -- |---------------------------------< ins >----------------------------------|
54 -- ----------------------------------------------------------------------------
55 -- {Start Of Comments}
56 --
57 -- Description:
58 --   This procedure is the attribute interface for the insert
59 --   process for the specified entity and is the outermost layer. The role
60 --   of this process is to insert a fully validated row into the HR schema
61 --   passing back to the calling process, any system generated values
62 --   (e.g. object version number attributes).The processing of this
63 --   procedure is as follows:
64 --   1) The attributes are converted into a local record structure by
65 --      calling the convert_args function.
66 --   2) After the conversion has taken place, the corresponding record ins
67 --      interface process is executed.
68 --   3) OUT parameters are then set to their corresponding record attributes.
69 --
70 -- Prerequisites:
71 --
72 -- In Parameters:
73 --
74 -- Post Success:
75 --   A fully validated row will be inserted for the specified entity
76 --   without being committed.
77 --
78 -- Post Failure:
79 --   If an error has occurred, an error message will be raised.
80 --
81 -- Developer Implementation Notes:
82 --   None.
83 --
84 -- Access Status:
85 --   Internal Development Use Only.
86 --
87 -- {End Of Comments}
88 -- ----------------------------------------------------------------------------
89 Procedure ins
90   (p_effective_date               in     date
91   ,p_person_id                      in     number
92   ,p_incident_reference             in     varchar2
93   ,p_incident_type                  in     varchar2
94   ,p_incident_date                  in     date
95   ,p_at_work_flag                   in     varchar2
96   ,p_related_incident_id            in     number   default null
97   ,p_incident_time                  in     varchar2 default null
98   ,p_org_notified_date              in     date     default null
99   ,p_assignment_id                  in     number   default null
100   ,p_location                       in     varchar2 default null
101   ,p_report_date                    in     date     default null
102   ,p_report_time                    in     varchar2 default null
103   ,p_report_method                  in     varchar2 default null
104   ,p_person_reported_by             in     number   default null
105   ,p_person_reported_to             in     varchar2 default null
106   ,p_witness_details                in     varchar2 default null
107   ,p_description                    in     varchar2 default null
108   ,p_injury_type                    in     varchar2 default null
109   ,p_disease_type                   in     varchar2 default null
110   ,p_hazard_type                    in     varchar2 default null
111   ,p_body_part                      in     varchar2 default null
112   ,p_treatment_received_flag        in     varchar2 default null
113   ,p_hospital_details               in     varchar2 default null
114     ,p_emergency_code                 in     varchar2 default null
115     ,p_hospitalized_flag              in     varchar2 default null
116     ,p_hospital_address               in     varchar2 default null
117     ,p_activity_at_time_of_work       in     varchar2 default null
118     ,p_objects_involved               in     varchar2 default null
119     ,p_privacy_issue                  in     varchar2 default null
120     ,p_work_start_time                in     varchar2 default null
121     ,p_date_of_death                  in     date     default null
122     ,p_report_completed_by            in     varchar2 default null
123     ,p_reporting_person_title         in     varchar2 default null
124     ,p_reporting_person_phone         in     varchar2 default null
125     ,p_days_restricted_work           in     number   default null
126     ,p_days_away_from_work            in     number   default null
127   ,p_doctor_name                    in     varchar2 default null
128   ,p_compensation_date              in     date     default null
129   ,p_compensation_currency          in     varchar2 default null
130   ,p_compensation_amount            in     number   default null
131   ,p_remedial_hs_action             in     varchar2 default null
132   ,p_notified_hsrep_id              in     number   default null
133   ,p_notified_hsrep_date            in     date     default null
134   ,p_notified_rep_id                in     number   default null
135   ,p_notified_rep_date              in     date     default null
136   ,p_notified_rep_org_id            in     number   default null
137   ,p_over_time_flag                 in     varchar2 default null
138   ,p_absence_exists_flag            in     varchar2 default null
139   ,p_attribute_category             in     varchar2 default null
140   ,p_attribute1                     in     varchar2 default null
141   ,p_attribute2                     in     varchar2 default null
142   ,p_attribute3                     in     varchar2 default null
143   ,p_attribute4                     in     varchar2 default null
144   ,p_attribute5                     in     varchar2 default null
145   ,p_attribute6                     in     varchar2 default null
146   ,p_attribute7                     in     varchar2 default null
147   ,p_attribute8                     in     varchar2 default null
148   ,p_attribute9                     in     varchar2 default null
149   ,p_attribute10                    in     varchar2 default null
150   ,p_attribute11                    in     varchar2 default null
151   ,p_attribute12                    in     varchar2 default null
152   ,p_attribute13                    in     varchar2 default null
153   ,p_attribute14                    in     varchar2 default null
154   ,p_attribute15                    in     varchar2 default null
155   ,p_attribute16                    in     varchar2 default null
156   ,p_attribute17                    in     varchar2 default null
157   ,p_attribute18                    in     varchar2 default null
158   ,p_attribute19                    in     varchar2 default null
159   ,p_attribute20                    in     varchar2 default null
160   ,p_attribute21                    in     varchar2 default null
161   ,p_attribute22                    in     varchar2 default null
162   ,p_attribute23                    in     varchar2 default null
163   ,p_attribute24                    in     varchar2 default null
164   ,p_attribute25                    in     varchar2 default null
165   ,p_attribute26                    in     varchar2 default null
166   ,p_attribute27                    in     varchar2 default null
167   ,p_attribute28                    in     varchar2 default null
168   ,p_attribute29                    in     varchar2 default null
169   ,p_attribute30                    in     varchar2 default null
170   ,p_inc_information_category       in     varchar2 default null
171   ,p_inc_information1               in     varchar2 default null
172   ,p_inc_information2               in     varchar2 default null
173   ,p_inc_information3               in     varchar2 default null
174   ,p_inc_information4               in     varchar2 default null
175   ,p_inc_information5               in     varchar2 default null
176   ,p_inc_information6               in     varchar2 default null
177   ,p_inc_information7               in     varchar2 default null
178   ,p_inc_information8               in     varchar2 default null
179   ,p_inc_information9               in     varchar2 default null
180   ,p_inc_information10              in     varchar2 default null
181   ,p_inc_information11              in     varchar2 default null
182   ,p_inc_information12              in     varchar2 default null
183   ,p_inc_information13              in     varchar2 default null
184   ,p_inc_information14              in     varchar2 default null
185   ,p_inc_information15              in     varchar2 default null
186   ,p_inc_information16              in     varchar2 default null
187   ,p_inc_information17              in     varchar2 default null
188   ,p_inc_information18              in     varchar2 default null
189   ,p_inc_information19              in     varchar2 default null
190   ,p_inc_information20              in     varchar2 default null
191   ,p_inc_information21              in     varchar2 default null
192   ,p_inc_information22              in     varchar2 default null
193   ,p_inc_information23              in     varchar2 default null
194   ,p_inc_information24              in     varchar2 default null
195   ,p_inc_information25              in     varchar2 default null
196   ,p_inc_information26              in     varchar2 default null
197   ,p_inc_information27              in     varchar2 default null
198   ,p_inc_information28              in     varchar2 default null
199   ,p_inc_information29              in     varchar2 default null
200   ,p_inc_information30              in     varchar2 default null
201   ,p_incident_id                       out nocopy number
202   ,p_object_version_number             out nocopy number
203   );
204 --
205 end per_inc_ins;