1 PACKAGE PA_PROJECT_ASSETS_PUB as
2 /*$Header: PAPMPAPS.pls 120.5 2006/07/29 11:39:40 skannoji noship $*/
3 /*#
4 * This package contains the public APIs that provide an open interface for external systems to insert, update, assign, and delete assets.
5 * @rep:scope public
6 * @rep:product PA
7 * @rep:lifecycle active
8 * @rep:displayname Asset APIs
9 * @rep:compatibility S
10 * @rep:category BUSINESS_ENTITY PA_PROJECT
11 * @rep:doccd 120pjapi.pdf See the Oracle Projects API's, Client Extensions, and Open Interfaces Reference
12 */
13
14 --Package constant used for package version validation
15
16 G_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
17
18
19 --Locking exception
20 ROW_ALREADY_LOCKED EXCEPTION;
21 PRAGMA EXCEPTION_INIT(ROW_ALREADY_LOCKED, -54);
22
23
24 --JPULTORAK Project Asset Creation
25
26 TYPE asset_in_rec_type IS RECORD
27 (pm_asset_reference VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
28 pa_project_asset_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
29 asset_number VARCHAR2(15) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
30 pa_asset_name VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
31 asset_description VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
32 project_asset_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
33 location_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
34 assigned_to_person_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
35 date_placed_in_service DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
36 asset_category_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
37 book_type_code VARCHAR2(15) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
38 asset_units NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
39 estimated_asset_units NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
40 estimated_cost NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
41 depreciate_flag VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
42 depreciation_expense_ccid NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
43 amortize_flag VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
44 estimated_in_service_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
45 asset_key_ccid NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
46 attribute_category VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
47 attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
48 attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
49 attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
50 attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
51 attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
52 attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
53 attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
54 attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
55 attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
56 attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
57 attribute11 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
58 attribute12 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
59 attribute13 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
60 attribute14 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
61 attribute15 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
62 parent_asset_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
63 manufacturer_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
64 model_number VARCHAR2(40) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
65 serial_number VARCHAR2(35) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
66 tag_number VARCHAR2(15) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
67 ret_target_asset_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
68 );
69
70 TYPE asset_in_tbl_type IS TABLE OF asset_in_rec_type
71 INDEX BY BINARY_INTEGER;
72
73
74 TYPE asset_out_rec_type IS RECORD
75 (pm_asset_reference VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
76 pa_project_asset_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
77 return_status VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
78 );
79
80 TYPE asset_out_tbl_type IS TABLE OF asset_out_rec_type
81 INDEX BY BINARY_INTEGER;
82
83
84 TYPE asset_assignment_in_rec_type IS RECORD
85 (pa_task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
86 pm_task_reference VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
87 pa_project_asset_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
88 pm_asset_reference VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
89 attribute_category VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
90 attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
91 attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
92 attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
93 attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
94 attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
95 attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
96 attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
97 attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
98 attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
99 attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
100 attribute11 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
101 attribute12 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
102 attribute13 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
103 attribute14 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
104 attribute15 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
105 );
106
107 TYPE asset_assignment_in_tbl_type IS TABLE OF asset_assignment_in_rec_type
108 INDEX BY BINARY_INTEGER;
109
110
111 TYPE asset_assignment_out_rec_type IS RECORD
112 (pa_task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
113 pa_task_number VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
114 pm_task_reference VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
115 pa_project_asset_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
116 pa_asset_name VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
117 pm_asset_reference VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
118 return_status VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
119
120 TYPE asset_assignment_out_tbl_type IS TABLE OF asset_assignment_out_rec_type
121 INDEX BY BINARY_INTEGER;
122
123
124
125 --Globals to be used by the LOAD/EXECUTE/FETCH process
126
127 --IN Types
128 G_assets_in_tbl asset_in_tbl_type;
129 G_asset_assignments_in_tbl asset_assignment_in_tbl_type;
130
131 --Counters
132 G_assets_tbl_count NUMBER:=0;
133 G_asset_assignments_tbl_count NUMBER:=0;
134
135 --OUT Types
136 G_assets_out_tbl asset_out_tbl_type;
137 G_asset_assignments_out_tbl asset_assignment_out_tbl_type;
138
139 --JPULTORAK Project Asset Creation
140
141
142
143
144
145 --JPULTORAK Project Asset Creation
146
147 /*#
148 * This API adds a project asset to the specified project. If the validations complete successfully, a new row
149 * is created in the table PA_PROJECT_ASSETS_ALL.
150 * @param p_api_version_number API standard: version number
151 * @param p_commit API standard (default = F): indicates if transaction will be commited
152 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
153 * @param p_msg_count API standard: number of error messages
154 * @rep:paraminfo {@rep:required}
155 * @param p_msg_data API standard: error message
156 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
157 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
158 * @rep:paraminfo {@rep:precision 1} {@rep:required}
159 * @param p_pm_product_code The identifier of the external project management system from which the project was imported
160 * @rep:paraminfo {@rep:precision 30} {@rep:required}
161 * @param p_pm_project_reference The reference code that uniquely identifies the project in the external system
162 * @rep:paraminfo {@rep:precision 25} {@rep:required}
163 * @param p_pa_project_id The reference code that uniquely identifies the project in Oracle Projects
164 * @rep:paraminfo {@rep:precision 15} {@rep:required}
165 * @param p_pm_asset_reference The reference code that uniquely identifies the asset in the external system
166 * @rep:paraminfo {@rep:precision 240} {@rep:required}
167 * @param p_pa_asset_name The name that uniquely defines the asset in Oracle Projects
168 * @rep:paraminfo {@rep:precision 240} {@rep:required}
169 * @param p_asset_number Unique asset number
170 * @rep:paraminfo {@rep:precision 15} {@rep:required}
171 * @param p_asset_description Asset description
172 * @rep:paraminfo {@rep:precision 80} {@rep:required}
173 * @param p_project_asset_type Asset type
174 * @rep:paraminfo {@rep:precision 30} {@rep:required}
175 * @param p_location_id The identifier of the location to which the asset is assigned
176 * @param p_assigned_to_person_id The identifier of the person to whom the asset is assigned
177 * @param p_date_placed_in_service Date placed in service of the asset
178 * @param p_asset_category_id The identifier of the asset category to which the asset is assigned
179 * @param p_book_type_code The corporate book to which the asset is assigned
180 * @rep:paraminfo {@rep:precision 15}
181 * @param p_asset_units The number of asset units
182 * @param p_estimated_asset_units The estimated number of asset units
183 * @param p_estimated_cost The estimated cost
184 * @param p_depreciate_flag Indicator whether the asset should be depreciated in Oracle Assets
185 * @rep:paraminfo {@rep:precision 1}
186 * @param p_depreciation_expense_ccid The depreciation expense account for the asset
187 * @param p_amortize_flag Indicator whether cost adjustments should be ammortised in Oracle Assets
188 * @rep:paraminfo {@rep:precision 1}
189 * @param p_estimated_in_service_date The estimated date placed in service for the asset
190 * @param p_asset_key_ccid Key flexfield code combination identifier for asset key flexfield
191 * @param p_attribute_category Descriptive flexfield category
192 * @rep:paraminfo {@rep:precision 30}
193 * @param p_attribute1 through p_attribute15 Descriptive flexfield attribute
194 * @rep:paraminfo {@rep:precision 150}
195 * @param p_parent_asset_id The identifier of the parent asset
196 * @param p_manufacturer_name The name of the manufacturer of the asset
197 * @rep:paraminfo {@rep:precision 30}
198 * @param p_model_number The model number of the asset
199 * @rep:paraminfo {@rep:precision 40}
200 * @param p_serial_number The serial number of the asset
201 * @rep:paraminfo {@rep:precision 35}
202 * @param p_tag_number The tag number of the asset
203 * @rep:paraminfo {@rep:precision 15}
204 * @param p_ret_target_asset_id The identifier of the target asset
205 * @param p_pa_project_id_out API standard
206 * @rep:paraminfo {@rep:precision 15} {@rep:required}
207 * @param p_pa_project_number_out API standard
208 * @rep:paraminfo {@rep:precision 25} {@rep:required}
209 * @param p_pa_project_asset_id_out The reference code that uniquely identifies the asset within a project in Oracle Projects
210 * @rep:paraminfo {@rep:precision 15} {@rep:required}
211 * @param p_pm_asset_reference_out The reference code that uniquely dentifies the asset in the external system
212 * @rep:paraminfo {@rep:precision 25} {@rep:required}
213 * @rep:scope public
214 * @rep:lifecycle active
215 * @rep:displayname Create Project Asset
216 * @rep:category BUSINESS_ENTITY PA_PROJECT
217 * @rep:compatibility S
218 */
219 PROCEDURE add_project_asset
220 ( p_api_version_number IN NUMBER
221 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
222 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
223 ,p_msg_count OUT NOCOPY NUMBER
224 ,p_msg_data OUT NOCOPY VARCHAR2
225 ,p_return_status OUT NOCOPY VARCHAR2
226 ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
227 ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
228 ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
229 ,p_pm_asset_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
230 ,p_pa_asset_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
231 ,p_asset_number IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
232 ,p_asset_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
233 ,p_project_asset_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
234 ,p_location_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
235 ,p_assigned_to_person_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
236 ,p_date_placed_in_service IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
237 ,p_asset_category_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
238 ,p_book_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
239 ,p_asset_units IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
240 ,p_estimated_asset_units IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
241 ,p_estimated_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
242 ,p_depreciate_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
243 ,p_depreciation_expense_ccid IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
244 ,p_amortize_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
245 ,p_estimated_in_service_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
246 ,p_asset_key_ccid IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
247 ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
248 ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
249 ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
250 ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
251 ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
252 ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
253 ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
254 ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
255 ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
256 ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
257 ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
258 ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
259 ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
260 ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
261 ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
262 ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
263 ,p_parent_asset_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
264 ,p_manufacturer_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
268 ,p_ret_target_asset_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
265 ,p_model_number IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
266 ,p_serial_number IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
267 ,p_tag_number IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
269 ,p_pa_project_id_out OUT NOCOPY NUMBER
270 ,p_pa_project_number_out OUT NOCOPY VARCHAR2
271 ,p_pa_project_asset_id_out OUT NOCOPY NUMBER
272 ,p_pm_asset_reference_out OUT NOCOPY VARCHAR2);
273
274
275
276 /*#
277 * This procedure adds an asset assignment to the specified project.
278 * @param p_api_version_number API standard: version number
279 * @param p_commit API standard (default = F): indicates if transaction will be commited
280 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
281 * @param p_msg_count API standard: number of error messages
282 * @rep:paraminfo {@rep:required}
283 * @param p_msg_data API standard: error message
284 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
285 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
286 * @rep:paraminfo {@rep:precision 1} {@rep:required}
287 * @param p_pm_product_code The identifier of the external project management system from which the project was imported
288 * @rep:paraminfo {@rep:precision 30} {@rep:required}
289 * @param p_pm_project_reference The reference code that uniquely identifies the project in the external system
290 * @rep:paraminfo {@rep:precision 25} {@rep:required}
291 * @param p_pa_project_id The reference code that uniquely identifies the project in Oracle Projects
292 * @rep:paraminfo {@rep:precision 15} {@rep:required}
293 * @param p_pm_task_reference The reference code that identifies a project's task in the external system
294 * @rep:paraminfo {@rep:precision 25} {@rep:required}
295 * @param p_pa_task_id The reference code that uniquely identifies the task within a project in Oracle Projects
296 * @rep:paraminfo {@rep:precision 15}
297 * @param p_pm_asset_reference The reference code that uniquely identifies the asset in the external system
298 * @rep:paraminfo {@rep:precision 25}
299 * @param p_pa_project_asset_id The reference code that uniquely identifies the asset within a project in Oracle Projects
300 * @rep:paraminfo {@rep:precision 15}
301 * @param p_attribute_category Descriptive flexfield category
302 * @rep:paraminfo {@rep:precision 30}
303 * @param p_attribute1 through p_attribute15 Descriptive flexfield attribute
304 * @rep:paraminfo {@rep:precision 150}
305 * @param p_pa_task_id_out The reference code that uniquely identifies the task within a project in Oracle Projects
306 * @rep:paraminfo {@rep:precision 15} {@rep:required}
307 * @param p_pa_project_asset_id_out The reference code that uniquely identifies the asset within a project in Oracle Projects
308 * @rep:paraminfo {@rep:precision 15} {@rep:required}
309 * @rep:scope public
310 * @rep:lifecycle active
311 * @rep:displayname Create Asset Assignment
312 * @rep:category BUSINESS_ENTITY PA_PROJECT
313 * @rep:compatibility S
314 */
315 PROCEDURE add_asset_assignment
316 ( p_api_version_number IN NUMBER
317 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
318 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
319 ,p_msg_count OUT NOCOPY NUMBER
320 ,p_msg_data OUT NOCOPY VARCHAR2
321 ,p_return_status OUT NOCOPY VARCHAR2
322 ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
323 ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
324 ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
325 ,p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
326 ,p_pa_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
327 ,p_pm_asset_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
328 ,p_pa_project_asset_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
329 ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
330 ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
331 ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
332 ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
333 ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
334 ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
335 ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
336 ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
337 ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
338 ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
339 ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
340 ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
341 ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
342 ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
343 ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
344 ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
345 ,p_pa_task_id_out OUT NOCOPY NUMBER
346 ,p_pa_project_asset_id_out OUT NOCOPY NUMBER );
347
348
349
350 /*#
351 * This procedure updates a project asset on the specified project.
352 * @param p_api_version_number API standard: version number
353 * @param p_commit API standard (default = F): indicates if transaction will be commited
354 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
358 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
355 * @param p_msg_count API standard: number of error messages
356 * @rep:paraminfo {@rep:required}
357 * @param p_msg_data API standard: error message
359 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
360 * @rep:paraminfo {@rep:precision 1} {@rep:required}
361 * @param p_pm_product_code The identifier of the external project management system from which the project was imported
362 * @rep:paraminfo {@rep:precision 30} {@rep:required}
363 * @param p_pm_project_reference The reference code that uniquely identifies the project in the external system
364 * @rep:paraminfo {@rep:precision 25} {@rep:required}
365 * @param p_pa_project_id The reference code that uniquely identifies the project in Oracle Projects
366 * @rep:paraminfo {@rep:precision 15} {@rep:required}
367 * @param p_pm_asset_reference The reference code that uniquely identifies the asset in the external system
368 * @rep:paraminfo {@rep:precision 25} {@rep:required}
369 * @param p_pa_project_asset_id The reference code that uniquely identifies the asset within a project in Oracle Projects
370 * @rep:paraminfo {@rep:precision 15} {@rep:required}
371 * @param p_pa_asset_name The name that uniquely defines the asset in Oracle Projects
372 * @rep:paraminfo {@rep:precision 240} {@rep:required}
373 * @param p_asset_number Unique asset number
374 * @rep:paraminfo {@rep:precision 15} {@rep:required}
375 * @param p_asset_description Asset description
376 * @rep:paraminfo {@rep:precision 80} {@rep:required}
377 * @param p_project_asset_type Asset type
378 * @rep:paraminfo {@rep:precision 30} {@rep:required}
379 * @param p_location_id The identifier of the location to which the asset is assigned
380 * @param p_assigned_to_person_id The identifier of the person to whom the asset is assigned
381 * @param p_date_placed_in_service Date placed in service of the asset
382 * @param p_asset_category_id The identifier of the asset category to which the asset is assigned
383 * @param p_book_type_code The corporate book to which the asset is assigned
384 * @rep:paraminfo {@rep:precision 15}
385 * @param p_asset_units The number of asset units
386 * @param p_estimated_asset_units The estimated number of asset units
387 * @param p_estimated_cost The estimated cost
388 * @param p_depreciate_flag Indicator whether the asset should be depreciated in Oracle Assets
389 * @rep:paraminfo {@rep:precision 1}
390 * @param p_depreciation_expense_ccid The depreciation expense account for the asset
391 * @param p_amortize_flag Indicator whether cost adjustments should be ammortised in Oracle Assets
392 * @rep:paraminfo {@rep:precision 1}
393 * @param p_estimated_in_service_date The estimated date placed in service for the asset
394 * @param p_asset_key_ccid Key flexfield code combination identifier for asset key flexfield
395 * @param p_attribute_category Descriptive flexfield category
396 * @rep:paraminfo {@rep:precision 30}
397 * @param p_attribute1 through p_attribute15 Descriptive flexfield attribute
398 * @rep:paraminfo {@rep:precision 150}
399 * @param p_parent_asset_id The identifier of the parent asset
400 * @param p_manufacturer_name The name of the manufacturer of the asset
401 * @rep:paraminfo {@rep:precision 30}
402 * @param p_model_number The model number of the asset
403 * @rep:paraminfo {@rep:precision 40}
404 * @param p_serial_number The serial number of the asset
405 * @rep:paraminfo {@rep:precision 35}
406 * @param p_tag_number The tag number of the asset
407 * @rep:paraminfo {@rep:precision 15}
408 * @param p_ret_target_asset_id The identifier of the target asset
409 * @param p_pa_project_id_out API standard
410 * @rep:paraminfo {@rep:precision 15} {@rep:required}
411 * @param p_pa_project_number_out API standard
412 * @rep:paraminfo {@rep:precision 25} {@rep:required}
413 * @param p_pa_project_asset_id_out The reference code that uniquely identifies the asset within a project in Oracle Projects
414 * @rep:paraminfo {@rep:precision 15} {@rep:required}
415 * @param p_pm_asset_reference_out The reference code that uniquely dentifies the asset in the external system
416 * @rep:paraminfo {@rep:precision 25} {@rep:required}
417 * @rep:scope public
418 * @rep:lifecycle active
419 * @rep:displayname Update Project Asset
420 * @rep:category BUSINESS_ENTITY PA_PROJECT
421 * @rep:compatibility S
422 */
423 PROCEDURE update_project_asset
424 ( p_api_version_number IN NUMBER
425 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
426 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
427 ,p_msg_count OUT NOCOPY NUMBER
428 ,p_msg_data OUT NOCOPY VARCHAR2
429 ,p_return_status OUT NOCOPY VARCHAR2
430 ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
431 ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
432 ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
433 ,p_pm_asset_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
434 ,p_pa_project_asset_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
435 ,p_pa_asset_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
436 ,p_asset_number IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
437 ,p_asset_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
438 ,p_project_asset_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
439 ,p_location_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
440 ,p_assigned_to_person_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
441 ,p_date_placed_in_service IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
442 ,p_asset_category_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
443 ,p_book_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
444 ,p_asset_units IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
445 ,p_estimated_asset_units IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
446 ,p_estimated_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
447 ,p_depreciate_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
448 ,p_depreciation_expense_ccid IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
449 ,p_amortize_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
450 ,p_estimated_in_service_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
451 ,p_asset_key_ccid IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
452 ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
453 ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
454 ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
455 ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
456 ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
457 ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
458 ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
459 ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
460 ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
461 ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
462 ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
463 ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
464 ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
465 ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
466 ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
467 ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
468 ,p_parent_asset_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
469 ,p_manufacturer_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
470 ,p_model_number IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
471 ,p_serial_number IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
472 ,p_tag_number IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
473 ,p_ret_target_asset_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
474 ,p_pa_project_id_out OUT NOCOPY NUMBER
475 ,p_pa_project_number_out OUT NOCOPY VARCHAR2
476 ,p_pa_project_asset_id_out OUT NOCOPY NUMBER
477 ,p_pm_asset_reference_out OUT NOCOPY VARCHAR2 );
478
479
480
481 /*#
482 * This procedure converts an incoming asset reference to a project asset ID.
483 * @param p_pa_project_id The reference code that uniquely identifies the project in Oracle Projects
484 * @rep:paraminfo {@rep:precision 15} {@rep:required}
485 * @param p_pa_project_asset_id The reference code that uniquely identifies the asset within a project in Oracle Projects
486 * @rep:paraminfo {@rep:precision 15} {@rep:required}
487 * @param p_pm_asset_reference The reference code that uniquely identifies the asset in the external system
488 * @rep:paraminfo {@rep:precision 25} {@rep:required}
489 * @param p_out_project_asset_id The reference code that uniquely identifies the asset within a project in Oracle Projects
490 * @rep:paraminfo {@rep:precision 15} {@rep:required}
491 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
492 * @rep:paraminfo {@rep:precision 1} {@rep:required}
493 * @rep:scope public
494 * @rep:lifecycle active
495 * @rep:displayname Convert Asset Reference to Asset ID
496 * @rep:category BUSINESS_ENTITY PA_PROJECT
497 * @rep:compatibility S
498 */
499 --Put this in PA_PROJECT_PVT if desired
500 PROCEDURE convert_pm_assetref_to_id
501 ( p_pa_project_id IN NUMBER
502 ,p_pa_project_asset_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
503 ,p_pm_asset_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
504 ,p_out_project_asset_id OUT NOCOPY NUMBER
505 ,p_return_status OUT NOCOPY VARCHAR2 );
506
507
508 /*#
509 * This function returns the PROJECT_ASSET_ID based on the ASSET_REFERENCE and PROJECT_ID.
510 * @param p_pa_project_id The reference code that uniquely identifies the project in Oracle Projects
511 * @rep:paraminfo {@rep:precision 15} {@rep:required}
512 * @param p_pm_asset_reference The reference code that uniquely identifies the asset in the external system
513 * @rep:paraminfo {@rep:precision 25} {@rep:required}
514 * @rep:scope public
515 * @rep:lifecycle active
516 * @rep:displayname Fetch Project Asset Id
517 * @rep:category BUSINESS_ENTITY PA_PROJECT
518 * @rep:compatibility S
519 */
520 --Put this in PA_PROJECT_PVT if desired
521 FUNCTION fetch_project_asset_id
522 ( p_pa_project_id IN NUMBER
523 ,p_pm_asset_reference IN VARCHAR2 ) RETURN NUMBER;
524
525
526 /*#
527 * This procedure adds a project asset row to the global PL/SQL table G_ASSETS_IN_TBL.
528 * @param p_api_version_number API standard: version number
529 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
530 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
531 * @rep:paraminfo {@rep:precision 1} {@rep:required}
532 * @param p_pm_asset_reference The reference code that uniquely identifies the asset in the external system
533 * @rep:paraminfo {@rep:precision 240} {@rep:required}
534 * @param p_pa_asset_name The name that uniquely defines the asset in Oracle Projects
535 * @rep:paraminfo {@rep:precision 240} {@rep:required}
536 * @param p_asset_number Unique asset number
537 * @rep:paraminfo {@rep:precision 15} {@rep:required}
538 * @param p_asset_description Asset description
539 * @rep:paraminfo {@rep:precision 80} {@rep:required}
543 * @param p_assigned_to_person_id The identifier of the person to whom the asset is assigned
540 * @param p_project_asset_type Asset type
541 * @rep:paraminfo {@rep:precision 30} {@rep:required}
542 * @param p_location_id The identifier of the location to which the asset is assigned
544 * @param p_date_placed_in_service Date placed in service of the asset
545 * @param p_asset_category_id The identifier of the asset category to which the asset is assigned
546 * @param p_book_type_code The corporate book to which the asset is assigned
547 * @rep:paraminfo {@rep:precision 15}
548 * @param p_asset_units The number of asset units
549 * @param p_estimated_asset_units The estimated number of asset units
550 * @param p_estimated_cost The estimated cost
551 * @param p_depreciate_flag Indicator whether the asset should be depreciated in Oracle Assets
552 * @rep:paraminfo {@rep:precision 1}
553 * @param p_depreciation_expense_ccid The depreciation expense account for the asset
554 * @param p_amortize_flag Indicator whether cost adjustments should be ammortised in Oracle Assets
555 * @rep:paraminfo {@rep:precision 1}
556 * @param p_estimated_in_service_date The estimated date placed in service for the asset
557 * @param p_asset_key_ccid Key flexfield code combination identifier for asset key flexfield
558 * @param p_attribute_category Descriptive flexfield category
559 * @rep:paraminfo {@rep:precision 30}
560 * @param p_attribute1 through p_attribute15 Descriptive flexfield attribute
561 * @rep:paraminfo {@rep:precision 150}
562 * @param p_parent_asset_id The identifier of the parent asset
563 * @param p_manufacturer_name The name of the manufacturer of the asset
564 * @rep:paraminfo {@rep:precision 30}
565 * @param p_model_number The model number of the asset
566 * @rep:paraminfo {@rep:precision 40}
567 * @param p_serial_number The serial number of the asset
568 * @rep:paraminfo {@rep:precision 35}
569 * @param p_tag_number The tag number of the asset
570 * @rep:paraminfo {@rep:precision 15}
571 * @param p_ret_target_asset_id The identifier of the target asset
572 * @rep:scope public
573 * @rep:lifecycle active
574 * @rep:displayname Create Multiple Projects: Load Project Asset
575 * @rep:category BUSINESS_ENTITY PA_PROJECT
576 * @rep:compatibility S
577 */
578
579 PROCEDURE load_project_asset
580 ( p_api_version_number IN NUMBER
581 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
582 ,p_return_status OUT NOCOPY VARCHAR2
583 ,p_pm_asset_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
584 ,p_pa_asset_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
585 ,p_asset_number IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
586 ,p_asset_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
587 ,p_project_asset_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
588 ,p_location_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
589 ,p_assigned_to_person_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
590 ,p_date_placed_in_service IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
591 ,p_asset_category_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
592 ,p_book_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
593 ,p_asset_units IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
594 ,p_estimated_asset_units IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
595 ,p_estimated_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
596 ,p_depreciate_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
597 ,p_depreciation_expense_ccid IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
598 ,p_amortize_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
599 ,p_estimated_in_service_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
600 ,p_asset_key_ccid IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
601 ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
602 ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
603 ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
604 ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
605 ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
606 ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
607 ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
608 ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
609 ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
610 ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
611 ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
612 ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
613 ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
614 ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
615 ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
616 ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
617 ,p_parent_asset_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
618 ,p_manufacturer_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
619 ,p_model_number IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
620 ,p_serial_number IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
621 ,p_tag_number IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
622 ,p_ret_target_asset_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM );
623
624
625
626 /*#
627 * This procedure adds an asset assignment row to the global PL/SQL table G_ASSET_ASSIGNMENTS_IN_TBL.
628 * @param p_api_version_number API standard: version number
629 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
633 * @rep:paraminfo {@rep:precision 25} {@rep:required}
630 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
631 * @rep:paraminfo {@rep:precision 1} {@rep:required}
632 * @param p_pm_task_reference The reference code that identifies a project's task in the external system
634 * @param p_pa_task_id The reference code that uniquely identifies the task within a project in Oracle Projects
635 * @rep:paraminfo {@rep:precision 15}
636 * @param p_pm_asset_reference The reference code that uniquely identifies the asset in the external system
637 * @rep:paraminfo {@rep:precision 25} {@rep:required}
638 * @param p_pa_project_asset_id The reference code that uniquely identifies the asset within a project in Oracle Projects
639 * @rep:paraminfo {@rep:precision 15}
640 * @param p_attribute_category Descriptive flexfield category
641 * @rep:paraminfo {@rep:precision 30}
642 * @param p_attribute1 through p_attribute15 Descriptive flexfield attribute
643 * @rep:paraminfo {@rep:precision 150}
644 * @rep:scope public
645 * @rep:lifecycle active
646 * @rep:displayname Create Multiple Asset Assignmentss: Load Asset Assignment
647 * @rep:category BUSINESS_ENTITY PA_PROJECT
648 * @rep:compatibility S
649 */
650 PROCEDURE load_asset_assignment
651 ( p_api_version_number IN NUMBER
652 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
653 ,p_return_status OUT NOCOPY VARCHAR2
654 ,p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
655 ,p_pa_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
656 ,p_pm_asset_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
657 ,p_pa_project_asset_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
658 ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
659 ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
660 ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
661 ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
662 ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
663 ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
664 ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
665 ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
666 ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
667 ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
668 ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
669 ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
670 ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
671 ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
672 ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
673 ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
674
675
676 /*#
677 * This procedure, which is called from the CREATE_PROJECT procedure, processes project assets and project asset assignments sent to
678 * the procedure in PL/SQL table input parameters.
679 * @param p_api_version_number API standard: version number
680 * @param p_commit API standard (default = F): indicates if transaction will be commited
681 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
682 * @param p_msg_count API standard: number of error messages
683 * @rep:paraminfo {@rep:required}
684 * @param p_msg_data API standard: error message
685 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
686 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
687 * @rep:paraminfo {@rep:precision 1} {@rep:required}
688 * @param p_pm_product_code The identifier of the external project management system from which the project was imported
689 * @rep:paraminfo {@rep:precision 30} {@rep:required}
690 * @param p_pm_project_reference The reference code that uniquely identifies the project in the external system
691 * @rep:paraminfo {@rep:precision 25} {@rep:required}
692 * @param p_pa_project_id The reference code that uniquely identifies the project in Oracle Projects
693 * @rep:paraminfo {@rep:precision 15} {@rep:required}
694 * @param p_assets_in The PL/SQL datatype
695 * @rep:paraminfo {@rep:required}
696 * @param p_assets_out The PL/SQL datatype
697 * @rep:paraminfo {@rep:required}
698 * @param p_asset_assignments_in The PL/SQL datatype of asset assignment
699 * @param p_asset_assignments_out The PL/SQL datatype of asset assignment
700 * @rep:paraminfo {@rep:required}
701 * @rep:scope public
702 * @rep:lifecycle active
703 * @rep:displayname Create Multiple Projects: Execute Create Project Asset
704 * @rep:category BUSINESS_ENTITY PA_PROJECT
705 * @rep:compatibility S
706 */
707 PROCEDURE execute_add_project_asset
708 ( p_api_version_number IN NUMBER
709 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
710 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
711 ,p_msg_count OUT NOCOPY NUMBER
712 ,p_msg_data OUT NOCOPY VARCHAR2
713 ,p_return_status OUT NOCOPY VARCHAR2
714 ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
715 ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
716 ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
717 ,p_assets_in IN asset_in_tbl_type
718 ,p_assets_out OUT NOCOPY asset_out_tbl_type
719 ,p_asset_assignments_in IN asset_assignment_in_tbl_type
720 ,p_asset_assignments_out OUT NOCOPY asset_assignment_out_tbl_type );
721
722
723 /*#
724 * This procedure deletes a project asset and any associated asset assignments from a project.
725 * @param p_api_version_number API standard: version number
726 * @param p_commit API standard (default = F): indicates if transaction will be commited
727 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
728 * @param p_msg_count API standard: number of error messages
729 * @rep:paraminfo {@rep:required}
730 * @param p_msg_data API standard: error message
731 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
732 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
733 * @rep:paraminfo {@rep:precision 1} {@rep:required}
734 * @param p_pm_product_code The identifier of the external project management system from which the project was imported
735 * @rep:paraminfo {@rep:precision 30} {@rep:required}
736 * @param p_pm_project_reference The reference code that uniquely identifies the project in the external system
737 * @rep:paraminfo {@rep:precision 30} {@rep:required}
738 * @param p_pa_project_id The reference code that uniquely identifies the project in Oracle Projects
739 * @rep:paraminfo {@rep:precision 15} {@rep:required}
740 * @param p_pm_asset_reference The reference code that uniquely identifies the asset in the external system
741 * @rep:paraminfo {@rep:precision 25} {@rep:required}
742 * @param p_pa_project_asset_id The reference code that uniquely identifies the asset within a project in Oracle Projects
743 * @rep:paraminfo {@rep:precision 15} {@rep:required}
744 * @rep:scope public
745 * @rep:lifecycle active
746 * @rep:displayname Delete Project Asset
747 * @rep:category BUSINESS_ENTITY PA_PROJECT
748 * @rep:compatibility S
749 */
750 PROCEDURE delete_project_asset
751 ( p_api_version_number IN NUMBER
752 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
753 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
754 ,p_msg_count OUT NOCOPY NUMBER
755 ,p_msg_data OUT NOCOPY VARCHAR2
756 ,p_return_status OUT NOCOPY VARCHAR2
757 ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
758 ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
759 ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
760 ,p_pm_asset_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
761 ,p_pa_project_asset_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM );
762
763
764 /*#
765 * This procedure deletes an asset assignment from a project.
766 * @param p_api_version_number API standard: version number
767 * @param p_commit API standard (default = F): indicates if transaction will be commited
768 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
769 * @param p_msg_count API standard: number of error messages
770 * @rep:paraminfo {@rep:required}
771 * @param p_msg_data API standard: error message
772 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
773 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
774 * @rep:paraminfo {@rep:precision 1} {@rep:required}
775 * @param p_pm_product_code The identifier of the external project management system from which the project was imported
776 * @rep:paraminfo {@rep:precision 30} {@rep:required}
777 * @param p_pm_project_reference The reference code that uniquely identifies the project in the external system
778 * @rep:paraminfo {@rep:precision 25} {@rep:required}
779 * @param p_pa_project_id The reference code that uniquely identifies the project in Oracle Projects
780 * @rep:paraminfo {@rep:precision 15} {@rep:required}
781 * @param p_pm_task_reference The reference code that identifies a project's task in the external system
782 * @rep:paraminfo {@rep:precision 25} {@rep:required}
783 * @param p_pa_task_id The reference code that uniquely identifies the task within a project in Oracle Projects
784 * @rep:paraminfo {@rep:precision 15}
785 * @param p_pm_asset_reference The reference code that uniquely identifies the asset in the external system
786 * @rep:paraminfo {@rep:precision 25} {@rep:required}
787 * @param p_pa_project_asset_id The reference code that uniquely identifies the asset within a project in Oracle Projects
788 * @rep:paraminfo {@rep:precision 15} {@rep:required}
789 * @rep:scope public
790 * @rep:lifecycle active
791 * @rep:displayname Delete Asset Assignment
792 * @rep:category BUSINESS_ENTITY PA_PROJECT
793 * @rep:compatibility S
794 */
795
796 PROCEDURE delete_asset_assignment
797 ( p_api_version_number IN NUMBER
798 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
799 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
800 ,p_msg_count OUT NOCOPY NUMBER
801 ,p_msg_data OUT NOCOPY VARCHAR2
802 ,p_return_status OUT NOCOPY VARCHAR2
803 ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
804 ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
805 ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
806 ,p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
807 ,p_pa_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
808 ,p_pm_asset_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
809 ,p_pa_project_asset_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM );
810
811
812 --JPULTORAK Project Asset Creation
813
814 END PA_PROJECT_ASSETS_PUB;