DBA Data[Home] [Help]

PACKAGE: APPS.HXC_TIME_ATTRIBUTES_API

Source


1 package hxc_time_attributes_api AUTHID CURRENT_USER as
2 /* $Header: hxctatapi.pkh 115.16 2003/11/20 09:11:53 arundell noship $ */
3 
4 type time_attribute is record
5   (attribute_name   varchar2(35)
6   ,attribute_value  varchar2(150)
7   ,information_type varchar2(80)
8   ,column_name	    varchar2(80)
9   ,info_mapping_type varchar2(150)
10   );
11 
12 type timecard is table of time_attribute index by binary_integer;
13 
14 type info_type_table is table of varchar2(80) index by binary_integer;
15 
16 -- ---------------------------------------------------------------------------
17 -- |---------------------< create_attributes >-------------------------------|
18 -- ---------------------------------------------------------------------------
19 -- {Start of Comments}
20 --
21 -- Description:
22 --   Inserts new rows into hxc_time_attributes.  This interface should be
23 -- used when more than one attribute is to be created.
24 --
25 -- Prerequisites:
26 --   The building blocks specified by the time_building_block_id component
27 -- of the timecard structure, must exist in the hxc_time_building_blocks
28 -- table, if this value is not null.
29 --
30 -- In Parameters:
31 --   Name                   Reqd?  Type      Description
32 --   p_validate               y    boolean   if true, leaves database unchanged
33 --   p_timecard               y    timecard  pl/sql table of attributes
34 --   p_process_id             n    number    deposit process id
35 --   p_time_building_block_id n    varchar2  id of parent time building block
36 --   p_tbb_ovn                n    number    ovn of parent time building block
37 --
38 -- Out Parameters:
39 --   Name                          Type      Description
40 --   p_time_attribute_id           number    primary key
41 --   p_object_version_number       number    object version number
42 --
43 -- Post Success:
44 --   The time attributes are created, and the API sets the
45 -- following out parameters:
46 --
47 --   Name                           Type     Description
48 --   p_time_attribute_id            number   Unique ID for the attribute
49 --                                           created.
50 --   p_object_version_number        number   The version of the attribute
51 --                                           record - always 1 using
52 --                                           this interface.
53 --
54 -- Post Failure:
55 --   The API does not create the time attribute, and raises an error.
56 --
57 -- Access Status:
58 --   Internal Development Use Only.
59 --
60 -- {End of Comments}
61 
62 procedure create_attributes
63   (p_validate               in     boolean default false
64   ,p_timecard               in     timecard
65   ,p_process_id             in     number
66   ,p_time_building_block_id in     number
67   ,p_tbb_ovn                in     number
68   ,p_time_attribute_id      in out nocopy number
69   ,p_object_version_number  in out nocopy number
70   );
71 
72 -- ---------------------------------------------------------------------------
73 -- |----------------------< create_attribute >-------------------------------|
74 -- ---------------------------------------------------------------------------
75 -- {Start of Comments}
76 --
77 -- Description:
78 --   Inserts a new row into the hxc_time_attributes table.  This interface
79 -- should be used when only one attribute will be created.
80 --
81 -- Prerequisites:
82 --   If not null, the building block specified by p_time_building_block_id
83 -- and p_tbb_ovn must exist in the hxc_time_building_blocks table.
84 --
85 -- In Parameters:
86 --   Name                   Reqd?  Type      Description
87 --   p_validate               y    boolean   if true, leaves database
88 --                                           unchanged
89 --   p_bld_blk_info_type_id   y    number    id of the building block
90 --                                           information type
91 --   p_attribute_category     n    varchar2  standard flex column
92 --   p_attribute1             n    varchar2  standard flex column
93 --   p_attribute2             n    varchar2  standard flex column
94 --   p_attribute3             n    varchar2  standard flex column
95 --   p_attribute4             n    varchar2  standard flex column
96 --   p_attribute5             n    varchar2  standard flex column
97 --   p_attribute6             n    varchar2  standard flex column
98 --   p_attribute7             n    varchar2  standard flex column
99 --   p_attribute8             n    varchar2  standard flex column
100 --   p_attribute9             n    varchar2  standard flex column
101 --   p_attribute10            n    varchar2  standard flex column
102 --   p_attribute11            n    varchar2  standard flex column
103 --   p_attribute12            n    varchar2  standard flex column
104 --   p_attribute13            n    varchar2  standard flex column
105 --   p_attribute14            n    varchar2  standard flex column
106 --   p_attribute15            n    varchar2  standard flex column
107 --   p_attribute16            n    varchar2  standard flex column
108 --   p_attribute17            n    varchar2  standard flex column
109 --   p_attribute18            n    varchar2  standard flex column
110 --   p_attribute19            n    varchar2  standard flex column
111 --   p_attribute20            n    varchar2  standard flex column
112 --   p_attribute21            n    varchar2  standard flex column
113 --   p_attribute22            n    varchar2  standard flex column
114 --   p_attribute23            n    varchar2  standard flex column
115 --   p_attribute24            n    varchar2  standard flex column
116 --   p_attribute25            n    varchar2  standard flex column
117 --   p_attribute26            n    varchar2  standard flex column
118 --   p_attribute27            n    varchar2  standard flex column
119 --   p_attribute28            n    varchar2  standard flex column
120 --   p_attribute29            n    varchar2  standard flex column
121 --   p_attribute30            n    varchar2  standard flex column
122 --   p_time_building_block_id n    varchar2  id of corresponding time
123 --                                           building block
124 --   p_tbb_ovn                n    number    ovn of coresponding time
125 --                                           building block
126 --
127 -- Out Parameters:
128 --   name                          type      description
129 --   p_time_attribute_id           number    primary key
130 --   p_object_version_number       number    object version number
131 --
132 -- Post Success:
133 --   The time attribute is created, and the API sets the
134 -- following out parameters:
135 --
136 --   Name                           Type     Description
137 --   p_time_attribute_id            number   Unique ID for the attribute
138 --                                           created.
139 --   p_object_version_number        number   The version of the attribute
140 --                                           record - always 1 using
141 --                                           this interface.
142 --
143 -- Post Failure:
144 --   The API does not create the time attribute, and raises an error.
145 --
146 -- Access Status:
147 --   Internal Development Use Only
148 --
149 -- {End of Comments}
150 
151 procedure create_attribute
152   (p_validate               in     boolean default false
153   ,p_bld_blk_info_type_id   in     number
154   ,p_attribute_category     in     varchar2
155   ,p_attribute1             in     varchar2
156   ,p_attribute2             in     varchar2
157   ,p_attribute3             in     varchar2
158   ,p_attribute4             in     varchar2
159   ,p_attribute5             in     varchar2
160   ,p_attribute6             in     varchar2
161   ,p_attribute7             in     varchar2
162   ,p_attribute8             in     varchar2
163   ,p_attribute9             in     varchar2
164   ,p_attribute10            in     varchar2
165   ,p_attribute11            in     varchar2
166   ,p_attribute12            in     varchar2
167   ,p_attribute13            in     varchar2
168   ,p_attribute14            in     varchar2
169   ,p_attribute15            in     varchar2
170   ,p_attribute16            in     varchar2
171   ,p_attribute17            in     varchar2
172   ,p_attribute18            in     varchar2
173   ,p_attribute19            in     varchar2
174   ,p_attribute20            in     varchar2
175   ,p_attribute21            in     varchar2
176   ,p_attribute22            in     varchar2
177   ,p_attribute23            in     varchar2
178   ,p_attribute24            in     varchar2
179   ,p_attribute25            in     varchar2
180   ,p_attribute26            in     varchar2
181   ,p_attribute27            in     varchar2
182   ,p_attribute28            in     varchar2
183   ,p_attribute29            in     varchar2
184   ,p_attribute30            in     varchar2
185   ,p_time_building_block_id in     number
186   ,p_tbb_ovn                in     number
187   ,p_time_attribute_id      in out nocopy number
188   ,p_object_version_number  in out nocopy number
189   );
190 
191 -- ---------------------------------------------------------------------------
192 -- |---------------------< update_attributes >-------------------------------|
193 -- ---------------------------------------------------------------------------
194 -- {Start of Comments}
195 --
196 -- Description:
197 --   updates attribute definitions related to a building_block
198 --
199 -- Prerequisites:
200 --
201 -- In Parameters:
202 --   Name                   Reqd?  Type      Description
203 --   p_validate               y    boolean   if true, leaves database unchanged
204 --   p_timecard               y    timecard  pl/sql table of attributes
205 --   p_process_id             y    number    deposit process id
206 --   p_time_building_block_id y    varchar2  id of parent time building block
207 --
208 -- Out Parameters:
209 --   name                          type      Description
210 --   p_object_version_number       number    object version number
211 --
212 -- Post Success:
213 --   The time attributes are updated, and the API sets the
214 -- following out parameter:
215 --
216 --   Name                           Type     Description
217 --   p_object_version_number        number   The new version number
218 --                                           of the attribute record
219 --
220 -- Post Failure:
221 --   The time attributes are not updated, and the API raises an error.
222 --
223 -- Access Status:
224 --   Internal Development Use Only.
225 --
226 -- {End of Comments}
227 
228 procedure update_attributes
229   (p_validate               in     boolean default false
230   ,p_timecard               in     timecard
231   ,p_process_id             in     number
232   ,p_time_building_block_id in     number
233   ,p_time_attribute_id      in     number
234   ,p_object_version_number  in out nocopy number
235   );
236 
237 
238 -- ---------------------------------------------------------------------------
239 -- |---------------------< delete_attributes >-------------------------------|
240 -- ---------------------------------------------------------------------------
241 -- {Start of Comments}
242 --
243 -- Description:
244 --   deletes attribute definitions related to a building_block
245 --
246 -- Prerequisites:
247 --
248 -- In Parameters:
249 --   Name                   Reqd?  Type      Description
250 --   p_validate               y    boolean   if true, leaves database unchanged
251 --   p_time_attribute_id      y    number    primary key of record
252 --
253 -- Out Parameters:
254 --   Name                          Type      Description
255 --
256 -- Post Success:
257 --   The time attribute specified by p_time_attribute_id is deleted.
258 --
259 -- Post Failure:
260 --   The time attribute is not deleted, and the API raises an error.
261 --
262 -- Access Status:
263 --   Internal Development Use Only
264 --
265 -- {End of Comments}
266 
267 procedure delete_attributes
268   (p_validate              in boolean default false
269   ,p_time_attribute_id     in number
270   ,p_object_version_number in number
271   );
272 
273 
274 end hxc_time_attributes_api;