DBA Data[Home] [Help]

PACKAGE: APPS.HR_DOCUMENT_EXTRA_INFO_SWI

Source


1 Package hr_document_extra_info_swi As
2 /* $Header: hrdeiswi.pkh 120.0 2005/05/30 23:35 appldev noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |-------------------------< create_doc_extra_info >------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 --  This procedure is the self-service wrapper procedure to the following
10 --  API: hr_document_extra_info_api.create_doc_extra_info
11 --
12 -- Pre-requisites
13 --  All 'IN' parameters to this procedure have been appropriately derived.
14 --
15 -- Post Success:
16 --  p_return_status will return value indicating success.
17 --
18 -- Post Failure:
19 --  p_return_status will return value indication failure.
20 --
21 -- Access Status:
22 --  Internal Development use only.
23 --
24 -- {End of comments}
25 -- ----------------------------------------------------------------------------
26 PROCEDURE create_doc_extra_info
27   (p_validate                     in     number    default hr_api.g_false_num
28   ,p_person_id                    in     number
29   ,p_document_type_id             in     number
30   ,p_date_from                    in     date
31   ,p_date_to                      in     date
32   ,p_document_number              in     varchar2  default null
33   ,p_issued_by                    in     varchar2  default null
34   ,p_issued_at                    in     varchar2  default null
35   ,p_issued_date                  in     date      default null
36   ,p_issuing_authority            in     varchar2  default null
37   ,p_verified_by                  in     number    default null
38   ,p_verified_date                in     date      default null
39   ,p_related_object_name          in     varchar2  default null
40   ,p_related_object_id_col        in     varchar2  default null
41   ,p_related_object_id            in     number    default null
42   ,p_dei_attribute_category       in     varchar2  default null
43   ,p_dei_attribute1               in     varchar2  default null
44   ,p_dei_attribute2               in     varchar2  default null
45   ,p_dei_attribute3               in     varchar2  default null
46   ,p_dei_attribute4               in     varchar2  default null
47   ,p_dei_attribute5               in     varchar2  default null
48   ,p_dei_attribute6               in     varchar2  default null
49   ,p_dei_attribute7               in     varchar2  default null
50   ,p_dei_attribute8               in     varchar2  default null
51   ,p_dei_attribute9               in     varchar2  default null
52   ,p_dei_attribute10              in     varchar2  default null
53   ,p_dei_attribute11              in     varchar2  default null
54   ,p_dei_attribute12              in     varchar2  default null
55   ,p_dei_attribute13              in     varchar2  default null
56   ,p_dei_attribute14              in     varchar2  default null
57   ,p_dei_attribute15              in     varchar2  default null
58   ,p_dei_attribute16              in     varchar2  default null
59   ,p_dei_attribute17              in     varchar2  default null
60   ,p_dei_attribute18              in     varchar2  default null
61   ,p_dei_attribute19              in     varchar2  default null
62   ,p_dei_attribute20              in     varchar2  default null
63   ,p_dei_attribute21              in     varchar2  default null
64   ,p_dei_attribute22              in     varchar2  default null
65   ,p_dei_attribute23              in     varchar2  default null
66   ,p_dei_attribute24              in     varchar2  default null
67   ,p_dei_attribute25              in     varchar2  default null
68   ,p_dei_attribute26              in     varchar2  default null
69   ,p_dei_attribute27              in     varchar2  default null
70   ,p_dei_attribute28              in     varchar2  default null
71   ,p_dei_attribute29              in     varchar2  default null
72   ,p_dei_attribute30              in     varchar2  default null
73   ,p_dei_information_category     in     varchar2  default null
74   ,p_dei_information1             in     varchar2  default null
75   ,p_dei_information2             in     varchar2  default null
76   ,p_dei_information3             in     varchar2  default null
77   ,p_dei_information4             in     varchar2  default null
78   ,p_dei_information5             in     varchar2  default null
79   ,p_dei_information6             in     varchar2  default null
80   ,p_dei_information7             in     varchar2  default null
81   ,p_dei_information8             in     varchar2  default null
82   ,p_dei_information9             in     varchar2  default null
83   ,p_dei_information10            in     varchar2  default null
84   ,p_dei_information11            in     varchar2  default null
85   ,p_dei_information12            in     varchar2  default null
86   ,p_dei_information13            in     varchar2  default null
87   ,p_dei_information14            in     varchar2  default null
88   ,p_dei_information15            in     varchar2  default null
89   ,p_dei_information16            in     varchar2  default null
90   ,p_dei_information17            in     varchar2  default null
91   ,p_dei_information18            in     varchar2  default null
92   ,p_dei_information19            in     varchar2  default null
93   ,p_dei_information20            in     varchar2  default null
94   ,p_dei_information21            in     varchar2  default null
95   ,p_dei_information22            in     varchar2  default null
96   ,p_dei_information23            in     varchar2  default null
97   ,p_dei_information24            in     varchar2  default null
98   ,p_dei_information25            in     varchar2  default null
99   ,p_dei_information26            in     varchar2  default null
100   ,p_dei_information27            in     varchar2  default null
101   ,p_dei_information28            in     varchar2  default null
102   ,p_dei_information29            in     varchar2  default null
103   ,p_dei_information30            in     varchar2  default null
104   ,p_request_id                   in     number    default null
105   ,p_program_application_id       in     number    default null
106   ,p_program_id                   in     number    default null
107   ,p_program_update_date          in     date      default null
108   ,p_document_extra_info_id       in     number
109   ,p_object_version_number           out nocopy number
110   ,p_return_status                   out nocopy varchar2
111   );
112 -- ----------------------------------------------------------------------------
113 -- |-------------------------< update_doc_extra_info >------------------------|
114 -- ----------------------------------------------------------------------------
115 -- {Start of comments}
116 --
117 -- Description:
118 --  This procedure is the self-service wrapper procedure to the following
119 --  API: hr_document_extra_info_api.update_doc_extra_info
120 --
121 -- Pre-requisites
122 --  All 'IN' parameters to this procedure have been appropriately derived.
123 --
124 -- Post Success:
125 --  p_return_status will return value indicating success.
126 --
127 -- Post Failure:
128 --  p_return_status will return value indication failure.
129 --
130 -- Access Status:
131 --  Internal Development use only.
132 --
133 -- {End of comments}
134 -- ----------------------------------------------------------------------------
135 PROCEDURE update_doc_extra_info
136   (p_validate                     in     number    default hr_api.g_false_num
137   ,p_document_extra_info_id       in     number
138   ,p_person_id                    in     number
139   ,p_document_type_id             in     number
140   ,p_date_from                    in     date
141   ,p_date_to                      in     date
142   ,p_document_number              in     varchar2  default hr_api.g_varchar2
143   ,p_issued_by                    in     varchar2  default hr_api.g_varchar2
144   ,p_issued_at                    in     varchar2  default hr_api.g_varchar2
145   ,p_issued_date                  in     date      default hr_api.g_date
146   ,p_issuing_authority            in     varchar2  default hr_api.g_varchar2
147   ,p_verified_by                  in     number    default hr_api.g_number
148   ,p_verified_date                in     date      default hr_api.g_date
149   ,p_related_object_name          in     varchar2  default hr_api.g_varchar2
150   ,p_related_object_id_col        in     varchar2  default hr_api.g_varchar2
151   ,p_related_object_id            in     number    default hr_api.g_number
152   ,p_dei_attribute_category       in     varchar2  default hr_api.g_varchar2
153   ,p_dei_attribute1               in     varchar2  default hr_api.g_varchar2
154   ,p_dei_attribute2               in     varchar2  default hr_api.g_varchar2
155   ,p_dei_attribute3               in     varchar2  default hr_api.g_varchar2
156   ,p_dei_attribute4               in     varchar2  default hr_api.g_varchar2
157   ,p_dei_attribute5               in     varchar2  default hr_api.g_varchar2
158   ,p_dei_attribute6               in     varchar2  default hr_api.g_varchar2
159   ,p_dei_attribute7               in     varchar2  default hr_api.g_varchar2
160   ,p_dei_attribute8               in     varchar2  default hr_api.g_varchar2
161   ,p_dei_attribute9               in     varchar2  default hr_api.g_varchar2
162   ,p_dei_attribute10              in     varchar2  default hr_api.g_varchar2
163   ,p_dei_attribute11              in     varchar2  default hr_api.g_varchar2
164   ,p_dei_attribute12              in     varchar2  default hr_api.g_varchar2
165   ,p_dei_attribute13              in     varchar2  default hr_api.g_varchar2
166   ,p_dei_attribute14              in     varchar2  default hr_api.g_varchar2
167   ,p_dei_attribute15              in     varchar2  default hr_api.g_varchar2
168   ,p_dei_attribute16              in     varchar2  default hr_api.g_varchar2
169   ,p_dei_attribute17              in     varchar2  default hr_api.g_varchar2
170   ,p_dei_attribute18              in     varchar2  default hr_api.g_varchar2
171   ,p_dei_attribute19              in     varchar2  default hr_api.g_varchar2
172   ,p_dei_attribute20              in     varchar2  default hr_api.g_varchar2
173   ,p_dei_attribute21              in     varchar2  default hr_api.g_varchar2
174   ,p_dei_attribute22              in     varchar2  default hr_api.g_varchar2
175   ,p_dei_attribute23              in     varchar2  default hr_api.g_varchar2
176   ,p_dei_attribute24              in     varchar2  default hr_api.g_varchar2
177   ,p_dei_attribute25              in     varchar2  default hr_api.g_varchar2
178   ,p_dei_attribute26              in     varchar2  default hr_api.g_varchar2
179   ,p_dei_attribute27              in     varchar2  default hr_api.g_varchar2
180   ,p_dei_attribute28              in     varchar2  default hr_api.g_varchar2
181   ,p_dei_attribute29              in     varchar2  default hr_api.g_varchar2
182   ,p_dei_attribute30              in     varchar2  default hr_api.g_varchar2
183   ,p_dei_information_category     in     varchar2  default hr_api.g_varchar2
184   ,p_dei_information1             in     varchar2  default hr_api.g_varchar2
185   ,p_dei_information2             in     varchar2  default hr_api.g_varchar2
186   ,p_dei_information3             in     varchar2  default hr_api.g_varchar2
187   ,p_dei_information4             in     varchar2  default hr_api.g_varchar2
188   ,p_dei_information5             in     varchar2  default hr_api.g_varchar2
189   ,p_dei_information6             in     varchar2  default hr_api.g_varchar2
190   ,p_dei_information7             in     varchar2  default hr_api.g_varchar2
191   ,p_dei_information8             in     varchar2  default hr_api.g_varchar2
192   ,p_dei_information9             in     varchar2  default hr_api.g_varchar2
193   ,p_dei_information10            in     varchar2  default hr_api.g_varchar2
194   ,p_dei_information11            in     varchar2  default hr_api.g_varchar2
195   ,p_dei_information12            in     varchar2  default hr_api.g_varchar2
196   ,p_dei_information13            in     varchar2  default hr_api.g_varchar2
197   ,p_dei_information14            in     varchar2  default hr_api.g_varchar2
198   ,p_dei_information15            in     varchar2  default hr_api.g_varchar2
199   ,p_dei_information16            in     varchar2  default hr_api.g_varchar2
200   ,p_dei_information17            in     varchar2  default hr_api.g_varchar2
201   ,p_dei_information18            in     varchar2  default hr_api.g_varchar2
202   ,p_dei_information19            in     varchar2  default hr_api.g_varchar2
203   ,p_dei_information20            in     varchar2  default hr_api.g_varchar2
204   ,p_dei_information21            in     varchar2  default hr_api.g_varchar2
205   ,p_dei_information22            in     varchar2  default hr_api.g_varchar2
206   ,p_dei_information23            in     varchar2  default hr_api.g_varchar2
207   ,p_dei_information24            in     varchar2  default hr_api.g_varchar2
208   ,p_dei_information25            in     varchar2  default hr_api.g_varchar2
209   ,p_dei_information26            in     varchar2  default hr_api.g_varchar2
210   ,p_dei_information27            in     varchar2  default hr_api.g_varchar2
211   ,p_dei_information28            in     varchar2  default hr_api.g_varchar2
212   ,p_dei_information29            in     varchar2  default hr_api.g_varchar2
213   ,p_dei_information30            in     varchar2  default hr_api.g_varchar2
214   ,p_request_id                   in     number    default hr_api.g_number
215   ,p_program_application_id       in     number    default hr_api.g_number
216   ,p_program_id                   in     number    default hr_api.g_number
217   ,p_program_update_date          in     date      default hr_api.g_date
218   ,p_object_version_number        in out nocopy number
219   ,p_return_status                   out nocopy varchar2
220   );
221 -- ----------------------------------------------------------------------------
222 -- |-------------------------< delete_doc_extra_info >------------------------|
223 -- ----------------------------------------------------------------------------
224 -- {Start of comments}
225 --
226 -- Description:
227 --  This procedure is the self-service wrapper procedure to the following
228 --  API: hr_document_extra_info_api.delete_doc_extra_info
229 --
230 -- Pre-requisites
231 --  All 'IN' parameters to this procedure have been appropriately derived.
232 --
233 -- Post Success:
234 --  p_return_status will return value indicating success.
235 --
236 -- Post Failure:
237 --  p_return_status will return value indication failure.
238 --
239 -- Access Status:
240 --  Internal Development use only.
241 --
242 -- {End of comments}
243 -- ----------------------------------------------------------------------------
244 PROCEDURE delete_doc_extra_info
245   (p_validate                     in     number    default hr_api.g_false_num
246   ,p_document_extra_info_id       in     number
247   ,p_object_version_number        in     number
248   ,p_return_status                   out nocopy varchar2
249   );
250  end hr_document_extra_info_swi;