DBA Data[Home] [Help]

PACKAGE: APPS.PQH_COPY_ENTITY_ATTRIBS_API

Source


1 Package pqh_copy_entity_attribs_api AUTHID CURRENT_USER as
2 /* $Header: pqceaapi.pkh 120.0 2005/05/29 01:37:22 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_copy_entity_attrib >------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 --
11 -- Prerequisites:
12 --
13 --
14 -- In Parameters:
15 --   Name                           Reqd Type     Description
16 --   p_validate                     Yes  boolean  Commit or Rollback.
17 --   p_copy_entity_txn_id           Yes  number
18 --   p_row_type_cd                  No   varchar2
19 --   p_information_category         No   varchar2
20 --   p_information1                 No   varchar2
21 --   p_information2                 No   varchar2
22 --   p_information3                 No   varchar2
23 --   p_information4                 No   varchar2
24 --   p_information5                 No   varchar2
25 --   p_information6                 No   varchar2
26 --   p_information7                 No   varchar2
27 --   p_information8                 No   varchar2
28 --   p_information9                 No   varchar2
29 --   p_information10                No   varchar2
30 --   p_information11                No   varchar2
31 --   p_information12                No   varchar2
32 --   p_information13                No   varchar2
33 --   p_information14                No   varchar2
34 --   p_information15                No   varchar2
35 --   p_information16                No   varchar2
36 --   p_information17                No   varchar2
37 --   p_information18                No   varchar2
38 --   p_information19                No   varchar2
39 --   p_information20                No   varchar2
40 --   p_information21                No   varchar2
41 --   p_information22                No   varchar2
42 --   p_information23                No   varchar2
43 --   p_information24                No   varchar2
44 --   p_information25                No   varchar2
45 --   p_information26                No   varchar2
46 --   p_information27                No   varchar2
47 --   p_information28                No   varchar2
48 --   p_information29                No   varchar2
49 --   p_information30                No   varchar2
50 --   p_check_information1           No   varchar2
51 --   p_check_information2           No   varchar2
52 --   p_check_information3           No   varchar2
53 --   p_effective_date           Yes  date      Session Date.
54 --
55 -- Post Success:
56 --
57 -- Out Parameters:
58 --   Name                                Type     Description
59 --   p_copy_entity_attrib_id        Yes  number    PK of record
60 --   p_object_version_number        Yes  number    OVN of record
61 --
62 -- Post Failure:
63 --
64 -- Access Status:
65 --   Public.
66 --
67 -- {End Of Comments}
68 --
69 procedure create_copy_entity_attrib
70 (
71    p_validate                       in boolean    default false
72   ,p_copy_entity_attrib_id          out nocopy number
73   ,p_copy_entity_txn_id             in  number    default null
74   ,p_row_type_cd                    in  varchar2  default null
75   ,p_information_category           in  varchar2  default null
76   ,p_information1                   in  varchar2  default null
77   ,p_information2                   in  varchar2  default null
78   ,p_information3                   in  varchar2  default null
79   ,p_information4                   in  varchar2  default null
80   ,p_information5                   in  varchar2  default null
81   ,p_information6                   in  varchar2  default null
82   ,p_information7                   in  varchar2  default null
83   ,p_information8                   in  varchar2  default null
84   ,p_information9                   in  varchar2  default null
85   ,p_information10                  in  varchar2  default null
86   ,p_information11                  in  varchar2  default null
87   ,p_information12                  in  varchar2  default null
88   ,p_information13                  in  varchar2  default null
89   ,p_information14                  in  varchar2  default null
90   ,p_information15                  in  varchar2  default null
91   ,p_information16                  in  varchar2  default null
92   ,p_information17                  in  varchar2  default null
93   ,p_information18                  in  varchar2  default null
94   ,p_information19                  in  varchar2  default null
95   ,p_information20                  in  varchar2  default null
96   ,p_information21                  in  varchar2  default null
97   ,p_information22                  in  varchar2  default null
98   ,p_information23                  in  varchar2  default null
99   ,p_information24                  in  varchar2  default null
100   ,p_information25                  in  varchar2  default null
101   ,p_information26                  in  varchar2  default null
102   ,p_information27                  in  varchar2  default null
103   ,p_information28                  in  varchar2  default null
104   ,p_information29                  in  varchar2  default null
105   ,p_information30                  in  varchar2  default null
106   ,p_check_information1             in  varchar2  default null
107   ,p_check_information2             in  varchar2  default null
108   ,p_check_information3             in  varchar2  default null
109   ,p_object_version_number          out nocopy number
110   ,p_effective_date            in  date
111  );
112 -- ----------------------------------------------------------------------------
113 -- |------------------------< update_copy_entity_attrib >------------------------|
117 -- Description:
114 -- ----------------------------------------------------------------------------
115 -- {Start Of Comments}
116 --
118 --
119 -- Prerequisites:
120 --
121 --
122 -- In Parameters:
123 --   Name                           Reqd Type     Description
124 --   p_validate                     Yes  boolean  Commit or Rollback.
125 --   p_copy_entity_attrib_id        Yes  number    PK of record
126 --   p_copy_entity_txn_id           Yes  number
127 --   p_row_type_cd                  No   varchar2
128 --   p_information_category         No   varchar2
129 --   p_information1                 No   varchar2
130 --   p_information2                 No   varchar2
131 --   p_information3                 No   varchar2
132 --   p_information4                 No   varchar2
133 --   p_information5                 No   varchar2
134 --   p_information6                 No   varchar2
135 --   p_information7                 No   varchar2
136 --   p_information8                 No   varchar2
137 --   p_information9                 No   varchar2
138 --   p_information10                No   varchar2
139 --   p_information11                No   varchar2
140 --   p_information12                No   varchar2
141 --   p_information13                No   varchar2
142 --   p_information14                No   varchar2
143 --   p_information15                No   varchar2
144 --   p_information16                No   varchar2
145 --   p_information17                No   varchar2
146 --   p_information18                No   varchar2
147 --   p_information19                No   varchar2
148 --   p_information20                No   varchar2
149 --   p_information21                No   varchar2
150 --   p_information22                No   varchar2
151 --   p_information23                No   varchar2
152 --   p_information24                No   varchar2
153 --   p_information25                No   varchar2
154 --   p_information26                No   varchar2
155 --   p_information27                No   varchar2
156 --   p_information28                No   varchar2
157 --   p_information29                No   varchar2
158 --   p_information30                No   varchar2
159 --   p_check_information1           No   varchar2
160 --   p_check_information2           No   varchar2
161 --   p_check_information3           No   varchar2
162 --   p_effective_date          Yes  date       Session Date.
163 --
164 -- Post Success:
165 --
166 --   Name                           Type     Description
167 --   p_object_version_number        Yes  number    OVN of record
168 --
169 -- Post Failure:
170 --
171 -- Access Status:
172 --   Public.
173 --
174 -- {End Of Comments}
175 --
176 procedure update_copy_entity_attrib
177   (
178    p_validate                       in boolean    default false
179   ,p_copy_entity_attrib_id          in  number
180   ,p_copy_entity_txn_id             in  number    default hr_api.g_number
181   ,p_row_type_cd                    in  varchar2  default hr_api.g_varchar2
182   ,p_information_category           in  varchar2  default hr_api.g_varchar2
183   ,p_information1                   in  varchar2  default hr_api.g_varchar2
184   ,p_information2                   in  varchar2  default hr_api.g_varchar2
185   ,p_information3                   in  varchar2  default hr_api.g_varchar2
186   ,p_information4                   in  varchar2  default hr_api.g_varchar2
187   ,p_information5                   in  varchar2  default hr_api.g_varchar2
188   ,p_information6                   in  varchar2  default hr_api.g_varchar2
189   ,p_information7                   in  varchar2  default hr_api.g_varchar2
190   ,p_information8                   in  varchar2  default hr_api.g_varchar2
191   ,p_information9                   in  varchar2  default hr_api.g_varchar2
192   ,p_information10                  in  varchar2  default hr_api.g_varchar2
193   ,p_information11                  in  varchar2  default hr_api.g_varchar2
194   ,p_information12                  in  varchar2  default hr_api.g_varchar2
195   ,p_information13                  in  varchar2  default hr_api.g_varchar2
196   ,p_information14                  in  varchar2  default hr_api.g_varchar2
197   ,p_information15                  in  varchar2  default hr_api.g_varchar2
198   ,p_information16                  in  varchar2  default hr_api.g_varchar2
199   ,p_information17                  in  varchar2  default hr_api.g_varchar2
200   ,p_information18                  in  varchar2  default hr_api.g_varchar2
201   ,p_information19                  in  varchar2  default hr_api.g_varchar2
202   ,p_information20                  in  varchar2  default hr_api.g_varchar2
203   ,p_information21                  in  varchar2  default hr_api.g_varchar2
204   ,p_information22                  in  varchar2  default hr_api.g_varchar2
205   ,p_information23                  in  varchar2  default hr_api.g_varchar2
206   ,p_information24                  in  varchar2  default hr_api.g_varchar2
207   ,p_information25                  in  varchar2  default hr_api.g_varchar2
208   ,p_information26                  in  varchar2  default hr_api.g_varchar2
209   ,p_information27                  in  varchar2  default hr_api.g_varchar2
210   ,p_information28                  in  varchar2  default hr_api.g_varchar2
211   ,p_information29                  in  varchar2  default hr_api.g_varchar2
212   ,p_information30                  in  varchar2  default hr_api.g_varchar2
213   ,p_check_information1             in  varchar2  default hr_api.g_varchar2
214   ,p_check_information2             in  varchar2  default hr_api.g_varchar2
215   ,p_check_information3             in  varchar2  default hr_api.g_varchar2
216   ,p_object_version_number          in out nocopy number
217   ,p_effective_date            in  date
218   );
219 --
220 -- ----------------------------------------------------------------------------
221 -- |------------------------< delete_copy_entity_attrib >------------------------|
222 -- ----------------------------------------------------------------------------
223 -- {Start Of Comments}
224 --
225 -- Description:
226 --
227 -- Prerequisites:
228 --
229 --
230 -- In Parameters:
231 --   Name                           Reqd Type     Description
232 --   p_validate                     Yes  boolean  Commit or Rollback.
233 --   p_copy_entity_attrib_id        Yes  number    PK of record
234 --   p_effective_date          Yes  date     Session Date.
235 --
236 -- Post Success:
237 --
238 --   Name                           Type     Description
239 --   p_object_version_number        Yes  number    OVN of record
240 --
241 -- Post Failure:
242 --
243 -- Access Status:
244 --   Public.
245 --
246 -- {End Of Comments}
247 --
248 procedure delete_copy_entity_attrib
249   (
250    p_validate                       in boolean        default false
251   ,p_copy_entity_attrib_id          in  number
252   ,p_object_version_number          in  number
253   ,p_effective_date            in date
254   );
255 --
256 end pqh_copy_entity_attribs_api;