1 PACKAGE GMP_RESOURCE_DTL_PUB AS
2 /* $Header: GMPRSDTS.pls 120.7 2007/12/12 19:13:21 rpatangy ship $ */
3 /*#
4 * This is the public interface for OPM Plant Resources API
5 * These API can be used for creation, updation or deletion of Plant
6 * Resources in OPM
7 * @rep:scope public
8 * @rep:product GMP
9 * @rep:displayname GMP_RESOURCE_DTL_PUB
10 * @rep:lifecycle active
11 * @rep:category BUSINESS_ENTITY GMP_PLANT_RESOURCE
12 */
13
14 m_api_version CONSTANT NUMBER := 1;
15 m_pkg_name CONSTANT VARCHAR2 (30) := 'GMP_RESOURCE_DTL_PUB';
16 v_update_flag varchar2(1) := 'N';
17
18 /* Define record and table type */
19 TYPE update_table_rec_type IS RECORD
20 (
21 p_col_to_update VARCHAR2(30)
22 ,p_value VARCHAR2(30)
23 );
24
25 TYPE update_tbl_type IS TABLE OF update_table_rec_type
26 INDEX BY BINARY_INTEGER;
27
28 TYPE resource_instances_rec IS RECORD
29 (
30 RESOURCE_ID NUMBER,
31 INSTANCE_ID NUMBER,
32 INSTANCE_NUMBER NUMBER,
33 VENDOR_ID NUMBER,
34 MODEL_NUMBER VARCHAR2(30),
35 SERIAL_NUMBER VARCHAR2(30),
36 TRACKING_NUMBER VARCHAR2(30),
37 EFF_START_DATE DATE,
38 EFF_END_DATE DATE,
39 LAST_MAINTENANCE_DATE DATE,
40 MAINTENANCE_INTERVAL NUMBER,
41 INACTIVE_IND NUMBER,
42 CALIBRATION_FREQUENCY NUMBER,
43 CALIBRATION_PERIOD VARCHAR2(4),
44 CALIBRATION_ITEM_ID NUMBER,
45 LAST_CALIBRATION_DATE DATE,
46 NEXT_CALIBRATION_DATE DATE,
47 LAST_CERTIFICATION_DATE DATE,
48 CERTIFIED_BY VARCHAR2(32),
49 CREATION_DATE DATE,
50 CREATED_BY NUMBER,
51 LAST_UPDATE_DATE DATE,
52 LAST_UPDATED_BY NUMBER,
53 LAST_UPDATE_LOGIN NUMBER
54 ) ;
55
56 TYPE resource_instances_tbl IS TABLE OF resource_instances_rec
57 INDEX BY BINARY_INTEGER;
58
59 /*#
60 * API for INSERT_RESOURCE_DTL
61 * This API to craete a new plant resource i.e. to insert a row in the plant
62 * resource table - cr_rsrc_dtl
63 * @param p_api_version Version Number of the API
64 * @param p_init_msg_list Flag for initializing message list BOOLEAN
65 * @param p_commit This is the commmit flag BOOLEAN.
66 * @param p_resources This is the information about the resource to be created
67 * in the prescribed format - row type of cr_rsrc_dtl table.
68 * @param p_rsrc_instances This is the information about the instances of the
69 * resource being created
70 * @param x_message_count Number of messages on message stack
71 * @param x_message_list Actual message data from message stack
72 * @param x_return_status Return status 'S'-Success, 'E'-Error,
73 * 'U'-Unexpected Error
74 * @rep:scope public
75 * @rep:lifecycle active
76 * @rep:displayname INSERT_RESOURCE_DTL
77 */
78 PROCEDURE insert_resource_dtl
79 ( p_api_version IN NUMBER := 1
80 , p_init_msg_list IN BOOLEAN := TRUE
81 , p_commit IN BOOLEAN := FALSE
82 , p_resources IN cr_rsrc_dtl%ROWTYPE
83 , p_rsrc_instances IN resource_instances_tbl
84 , x_message_count OUT NOCOPY NUMBER
85 , x_message_list OUT NOCOPY VARCHAR2
86 , x_return_status IN OUT NOCOPY VARCHAR2
87 ) ;
88
89 /*#
90 * API for CHECK_DATA
91 * This API to validate the resource data before updating or creating a plant
92 * resource.
93 * @param p_organization_id This is the Inventory Organization to which the Resource is Associated
94 * @param p_resources This is the Resource that need to be inserted into the
95 * table.
96 * @param p_resource_id This is the resource id of the resource that will be passed
97 * @param p_group_resource Resource Group - Resource can be grouped by this
98 * type
99 * @param p_assigned_qty How many of the resources are in the plant
100 * @param p_daily_avl_use Number of hours the resource is available in the
101 * plant each day
102 * @param p_usage_um Unit of measure for measuring resource usage
103 * @param p_nominal_cost Cost of the Resource in the Plant
104 * @param p_inactive_ind Inactive indicator. 0=Active, 1=Inactive
105 * @param p_ideal_capacity Ideal Capacity of the Resource
106 * @param p_min_capacity Minimum Capacity of the Resource
107 * @param p_max_capacity Maximum Capacity of the Resource
108 * @param p_capacity_uom Resource Capacity Uom
109 * @param p_capacity_constraint Resource Capacity Constraint
110 * @param p_capacity_tolerance Capacity Tolerance
111 * @param p_schedule_ind Schedule Indicator This Column is used to define
112 * whether a resource is should be Scheduled or Not, the Values are 1=
113 * Scheduling , 2= Schedule to Instance, 0= Do Not Schedule
114 * @param p_utilization Indicates the resource Utilization
115 * @param p_efficiency Indicates the resource Efficiency
116 * @param p_calendar_code Indicates the calendar code
117 * @param p_batchable_flag Indicates the batchable flag
118 * @param p_batch_window Indicates the batch window
119 * @param x_message_count Number of messages on message stack
120 * @param x_message_list Actual message data from message stack
121 * @param x_return_status Return status 'S'-Success, 'E'-Error,
122 * 'U'-Unexpected Error
123 * @rep:scope public
124 * @rep:lifecycle active
125 * @rep:displayname CHECK_DATA
126 */
127 PROCEDURE check_data
128 (
129 p_organization_id IN NUMBER, /* B4724360 - INVCONV */
130 p_resources IN VARCHAR2,
131 p_resource_id IN NUMBER, /* B4724360 - INVCONV */
132 p_group_resource IN VARCHAR2,
133 p_assigned_qty IN integer,
134 p_daily_avl_use IN NUMBER,
135 p_usage_um IN VARCHAR2,
136 p_nominal_cost IN NUMBER,
137 p_inactive_ind IN NUMBER,
138 p_ideal_capacity IN NUMBER,
139 p_min_capacity IN NUMBER,
140 p_max_capacity IN NUMBER,
141 p_capacity_uom IN VARCHAR2,
142 p_capacity_constraint IN NUMBER,
143 p_capacity_tolerance IN NUMBER,
144 p_schedule_ind IN NUMBER,
145 p_utilization IN NUMBER,
146 p_efficiency IN NUMBER,
147 p_calendar_code IN VARCHAR2, /* B4724360 - INVCONV */
148 p_batchable_flag IN NUMBER, /* BUG 4157063 */
149 p_batch_window IN NUMBER, /* BUG 4157063 */
150 x_message_count OUT NOCOPY NUMBER,
151 x_message_list OUT NOCOPY VARCHAR2,
152 x_return_status OUT NOCOPY VARCHAR2
153 );
154
155 /*#
156 * API for INSERT_DETAIL_ROWS
157 * This API inserts a row in Plant Resource table (cr_rsrc_dtl)
158 * @param p_organization_id This is the Inventory Organization to which the Resource is Associated
159 * @param p_resources This is the Resource that needs to be inserted into the
160 * table.
161 * @param p_group_resource Resource Group - Resource can be grouped by this
162 * type
163 * @param p_assigned_qty How many of the resources are in the plant
164 * @param p_daily_avail_use Number of hours the resource is available in the
165 * plant each day
166 * @param p_usage_um Unit of measure for measuring resource usage
167 * @param p_nominal_cost Cost of the Resource in the Plant
168 * @param p_inactive_ind Inactive indicator. 0=Active, 1=Inactive
169 * @param p_creation_date Row Who columns
170 * @param p_created_by Row Who columns
171 * @param p_last_update_date Row Who columns
172 * @param p_last_updated_by Row Who columns
173 * @param p_last_update_login Row Who columns
174 * @param p_trans_cnt Not currently used
175 * @param p_delete_mark Standard: 0=Active record (default); 1=Marked for
176 * (logical) deletion
177 * @param p_text_code ID which joins any rows of text in this table to the
178 * Text Table for this Module
179 * @param p_ideal_capacity Ideal Capacity of the Resource
180 * @param p_min_capacity Minimum Capacity of the Resource
181 * @param p_max_capacity Maximum Capacity of the Resource
182 * @param p_capacity_uom Resource Capacity Uom
183 * @param p_resource_id Unique Identifier of the Resource Surrogate Key
184 * @param p_capacity_constraint Resource Capacity Constraint
185 * @param p_capacity_tolerance Capacity Tolerance
186 * @param p_schedule_ind Schedule Indicator This Column is used to define
187 * whether a resource is should be Scheduled or Not, the Values are 1=
188 * Scheduling , 2= Schedule to Instance, 0= Do Not Schedule
189 * @param p_utilization Indicates the resource Utilization
190 * @param p_efficiency Indicates the resource Efficiency
191 * @param p_calendar_code Indicates the calendar code
192 * @param p_batchable_flag Indicates the batchable flag
193 * @param p_batch_window Indicates the batch window
194 * @rep:scope public
195 * @rep:lifecycle active
196 * @rep:displayname INSERT_DETAIL_ROWS
197 */
198 --Bug#6413873 Need to pass planning_exception_set
199 PROCEDURE insert_detail_rows
200 (
201 p_organization_id IN NUMBER, /* B4724360 - INVCONV */
202 p_resources IN varchar2,
203 p_group_resource IN VARCHAR2,
204 p_assigned_qty IN NUMBER,
205 p_daily_avail_use IN NUMBER,
206 p_usage_um IN VARCHAR2,
207 p_nominal_cost IN NUMBER,
208 p_inactive_ind IN NUMBER,
209 p_creation_date IN DATE,
210 p_created_by IN NUMBER,
211 p_last_update_date IN DATE,
212 p_last_updated_by IN NUMBER,
213 p_last_update_login IN NUMBER,
214 p_trans_cnt IN NUMBER,
215 p_delete_mark IN NUMBER,
216 p_text_code IN NUMBER,
217 p_ideal_capacity IN NUMBER,
218 p_min_capacity IN NUMBER,
219 p_max_capacity IN NUMBER,
220 p_capacity_uom IN VARCHAR2,
221 p_resource_id IN NUMBER,
222 p_capacity_constraint IN NUMBER,
223 p_capacity_tolerance IN NUMBER,
224 p_schedule_ind IN NUMBER,
225 p_utilization IN NUMBER,
226 p_efficiency IN NUMBER,
227 p_planning_exception_set IN VARCHAR2, /*Bug#6413873 KBANDDYO*/
228 p_calendar_code IN VARCHAR2, /* B4724360 - INVCONV */
229 p_batchable_flag IN NUMBER, /* BUG 4157063 */
230 p_batch_window IN NUMBER /* BUG 4157063 */
231 );
232
233 /*#
234 * API for UPDATE_RESOURCE_DTL
235 * This API updates a Plant Resource ie. a row in table cr_rsrc_dtl.
236 * @param p_api_version Version Number of the API
237 * @param p_init_msg_list Flag for initializing message list BOOLEAN
238 * @param p_commit This is the commmit flag BOOLEAN.
239 * @param p_resources This is the resource information that needs to be updated
240 * @param x_message_count Number of messages on message stack
241 * @param x_message_list Actual message data from message stack
242 * @param x_return_status Return status 'S'-Success, 'E'-Error,
243 * 'U'-Unexpected Error
244 * @rep:scope public
245 * @rep:lifecycle active
246 * @rep:displayname UPDATE_RESOURCE_DTL
247 */
248
249 PROCEDURE update_resource_dtl
250 ( p_api_version IN NUMBER := 1
251 , p_init_msg_list IN BOOLEAN := TRUE
252 , p_commit IN BOOLEAN := FALSE
253 , p_resources IN cr_rsrc_dtl%ROWTYPE
254 , x_message_count OUT NOCOPY NUMBER
255 , x_message_list OUT NOCOPY VARCHAR2
256 , x_return_status OUT NOCOPY VARCHAR2
257 ) ;
258
259 /*#
260 * API for UPDATE_DETAIL_ROWS
261 * This API updates a row in Plant Resource table (cr_rsrc_dtl)
262 * @param p_organization_id This is the Inventory Organization to which the Resource is Associated
263 * @param p_resources This is the Resource that is to be updated .
264 * @param p_group_resource Resource Group - Resource can be grouped by this
265 * type
266 * @param p_assigned_qty How many of the resources are in the plant
267 * @param p_daily_avail_use Number of hours the resource is available in the
268 * plant each day
269 * @param p_usage_um Unit of measure in which daily_avail_use is
270 * expressed
271 * @param p_nominal_cost Cost of the Resource in the Plant
272 * @param p_inactive_ind Inactive indicator. 0=Active, 1=Inactive
273 * @param p_creation_date Row Who columns
274 * @param p_created_by Row Who columns
275 * @param p_last_update_date Row Who columns
276 * @param p_last_updated_by Row Who columns
277 * @param p_last_update_login Row Who columns
278 * @param p_trans_cnt Not currently used
279 * @param p_delete_mark Standard: 0=Active record (default); 1=Marked for
280 * (logical) deletion
281 * @param p_text_code ID which joins any rows of text in this table to the
282 * Text Table for this Module
283 * @param p_ideal_capacity Ideal Capacity of the Resource
284 * @param p_min_capacity Minimum Capacity of the Resource
285 * @param p_max_capacity Maximum Capacity of the Resource
286 * @param p_capacity_uom Resource Capacity Uom
287 * @param p_resource_id Unique Identifier of the Resource Surrogate Key
288 * @param p_capacity_constraint Resource Capacity Constraint
289 * @param p_capacity_tolerance Capacity Tolerance
290 * @param p_schedule_ind Schedule Indicator This Column is used to define
291 * whether a resource is should be Scheduled or Not, the Values are 1=
292 * Scheduling , 2= Schedule to Instance, 0= Do Not Schedule
293 * @param p_utilization Indicates the resource Utilization
294 * @param p_efficiency Indicates the resource Efficiency
295 * @param p_calendar_code Indicates the calendar code
296 * @param p_batchable_flag Indicates the batchable flag
297 * @param p_batch_window Indicates the batch window
298 * @param x_return_status Return status 'S'-Success, 'E'-Error,
299 * 'U'-Unexpected Error
300 * @rep:scope public
301 * @rep:lifecycle active
302 * @rep:displayname UPDATE_DETAIL_ROWS
303 */
304 --Bug#6413873 Need to pass planning_exception_set
305 PROCEDURE update_detail_rows
306 (
307 p_organization_id IN NUMBER, /* B4724360 - INVCONV */
308 p_resources IN VARCHAR2,
309 p_group_resource IN VARCHAR2,
310 p_assigned_qty IN NUMBER,
311 p_daily_avail_use IN NUMBER,
312 p_usage_um IN VARCHAR2,
313 p_nominal_cost IN NUMBER,
314 p_inactive_ind IN NUMBER,
315 p_creation_date IN DATE,
316 p_created_by IN NUMBER,
317 p_last_update_date IN DATE,
318 p_last_updated_by IN NUMBER,
319 p_last_update_login IN NUMBER,
320 p_trans_cnt IN NUMBER,
321 p_delete_mark IN NUMBER,
322 p_text_code IN NUMBER,
323 p_ideal_capacity IN NUMBER,
324 p_min_capacity IN NUMBER,
325 p_max_capacity IN NUMBER,
326 p_capacity_uom IN VARCHAR2,
327 p_resource_id IN NUMBER,
328 p_capacity_constraint IN NUMBER,
329 p_capacity_tolerance IN NUMBER,
330 p_schedule_ind IN NUMBER,
331 p_utilization IN NUMBER,
332 p_efficiency IN NUMBER,
333 p_planning_exception_set IN VARCHAR2, /*Bug#6413873 KBANDDYO*/
334 p_calendar_code IN VARCHAR2, /* B4724360 - INVCONV */
335 p_batchable_flag IN NUMBER, /* BUG 4157063 */
339
336 p_batch_window IN NUMBER, /* BUG 4157063 */
337 x_return_status OUT NOCOPY VARCHAR2
338 ) ;
340 /*#
341 * API for DELETE_RESOURCES
342 * This API Deletes a row in Plant Resource table (cr_rsrc_dtl)
343 * @param p_api_version Version Number of the API
344 * @param p_init_msg_list Flag for initializing message list BOOLEAN
345 * @param p_commit This is the commmit flag BOOLEAN.
346 * @param p_organization_id This is the Inventory Organization to which the Resource is Associated
347 * @param p_resources This is the resource information that needs to be Deleted
348 * @param x_message_count Number of messages on message stack
349 * @param x_message_list Actual message data from message stack
350 * @param x_return_status Return status 'S'-Success, 'E'-Error,
351 * 'U'-Unexpected Error
352 * @rep:scope public
353 * @rep:lifecycle active
354 * @rep:displayname DELETE_RESOURCES
355 */
356 PROCEDURE delete_resources
357 ( p_api_version IN NUMBER := 1
358 , p_init_msg_list IN BOOLEAN := TRUE
359 , p_commit IN BOOLEAN := FALSE
360 , p_organization_id IN cr_rsrc_dtl.organization_id%TYPE
361 , p_resources IN cr_rsrc_dtl.resources%TYPE
362 , x_message_count OUT NOCOPY NUMBER
363 , x_message_list OUT NOCOPY VARCHAR2
364 , x_return_status OUT NOCOPY VARCHAR2
365 );
366
367 /*#
368 * API for CHECK_INSTANCE_DATA
369 * This API checks the Instance data before Insertion
370 * @param p_resource_id Unique Identifier of the Resource Surrogate Key
371 * @param p_instance_id Surrogate Key to uniquely identify the Instance
372 * @param p_vendor_id Surrogate Key to uniquely identify the Vendor
373 * @param p_eff_start_date The Start Date for the Resource when it becomes
374 * Active
375 * @param p_eff_end_date The End Date for the Resource till it is Active
376 * @param p_maintenance_interval The number of Days from the last time
377 * maintenance was done where maintenance should occur again
378 * @param p_inactive_ind Inactive indicator. 0=Active, 1=Inactive
379 * @param p_calibration_frequency Resource Calibration Frequency
380 * @param p_calibration_item_id The Item with which the Calibration is done
381 * @param x_message_count Number of messages on message stack
382 * @param x_message_list Actual message data from message stack
383 * @param x_return_status Return status 'S'-Success, 'E'-Error,
384 * 'U'-Unexpected Error
385 * @rep:scope public
386 * @rep:lifecycle active
387 * @rep:displayname CHECK_INSTANCE_DATA
388 */
389 PROCEDURE check_instance_data
390 (
391 p_resource_id IN NUMBER
392 ,p_instance_id IN NUMBER
393 ,p_vendor_id IN NUMBER
394 ,p_eff_start_date IN DATE
395 ,p_eff_end_date IN DATE
396 ,p_maintenance_interval IN NUMBER
397 ,p_inactive_ind IN NUMBER
398 ,p_calibration_frequency IN NUMBER
399 ,p_calibration_item_id IN NUMBER
400 ,x_message_count OUT NOCOPY NUMBER
401 ,x_message_list OUT NOCOPY VARCHAR2
402 ,x_return_status OUT NOCOPY VARCHAR2
403 ) ;
404
405 /*#
406 * API for INSERT_RESOURCE_INSTANCE
407 * This API inserts a row in Plant Resource Instance table
408 * (gmp_resource_instances)
409 * @param p_resource_id Unique Identifier of the Resource Surrogate Key
410 * @param p_instance_id Surrogate Key to uniquely identify the Instance
411 * @param p_instance_number The number identifying the resource uniquely
412 * @param p_vendor_id Surrogate Key to uniquely identify the Vendor
413 * @param p_model_number the Model number from the manufacturer for the
414 * resource
415 * @param p_serial_number the Combination of numbers, Letters and Symbols the
416 * manufacturer uses to identify the resource
417 * @param p_tracking_number the unique combination of numbers, Letters and
418 * symbols to identify the resource for internal tracking
419 * @param p_eff_start_date The Start Date for the Resource when it becomes
420 * Active
421 * @param p_eff_end_date The End Date for the Resource till it is Active
422 * @param p_last_maintenance_date The Date maintenance last occurred for the
423 * resource
424 * @param p_maintenance_interval The number of Days from the last time
425 * maintenance was done where maintenance should occur again
426 * @param p_inactive_ind Inactive indicator. 0=Active, 1=Inactive
427 * @param p_calibration_frequency Resource Calibration Frequency
428 * @param p_calibration_period Resource Calibration Period
429 * @param p_calibration_item_id The Item with which the Calibration is done
430 * @param p_last_calibration_date Standard date validation
431 * @param p_next_calibration_date Standard date validation
432 * @param p_last_certification_date Standard date validation
433 * @param p_certified_by Person Who has done the Calibration Certification
434 * @param p_creation_date Row Who columns
435 * @param p_created_by Row Who columns
436 * @param p_last_update_date Row Who columns
437 * @param p_last_updated_by Row Who columns
438 * @param p_last_update_login Row Who columns
439 * @rep:scope public
440 * @rep:lifecycle active
441 * @rep:displayname INSERT_RESOURCE_INSTANCE
442 */
443 PROCEDURE insert_resource_instance (
444 p_resource_id IN NUMBER
445 ,p_instance_id IN NUMBER
449 ,p_serial_number IN VARCHAR2
446 ,p_instance_number IN NUMBER
447 ,p_vendor_id IN NUMBER
448 ,p_model_number IN VARCHAR2
450 ,p_tracking_number IN VARCHAR2
451 ,p_eff_start_date IN DATE
452 ,p_eff_end_date IN DATE
453 ,p_last_maintenance_date IN DATE
454 ,p_maintenance_interval IN NUMBER
455 ,p_inactive_ind IN NUMBER
456 ,p_calibration_frequency IN NUMBER
457 ,p_calibration_period IN VARCHAR2
458 ,p_calibration_item_id IN NUMBER
459 ,p_last_calibration_date IN DATE
460 ,p_next_calibration_date IN DATE
461 ,p_last_certification_date IN DATE
462 ,p_certified_by IN VARCHAR2
463 ,p_creation_date IN DATE
464 ,p_created_by IN NUMBER
465 ,p_last_update_date IN DATE
466 ,p_last_updated_by IN NUMBER
467 ,p_last_update_login IN NUMBER );
468
469 /*#
470 * API for UPDATE_INSTANCES
471 * This API updates a Resource Instance Table ie. a row in table
472 * gmp_resource_instances.
473 * @param p_api_version Version Number of the API
474 * @param p_init_msg_list Flag for initializing message list BOOLEAN
475 * @param p_commit This is the commmit flag BOOLEAN.
476 * @param p_instances This is the Instances of the Resource that need to be
477 * updated
478 * @param x_message_count Number of messages on message stack
479 * @param x_message_list Actual message data from message stack
480 * @param x_return_status Return status 'S'-Success, 'E'-Error,
481 * 'U'-Unexpected Error
482 * @rep:scope public
483 * @rep:lifecycle active
484 * @rep:displayname UPDATE_INSTANCES
485 */
486 PROCEDURE update_instances
487 ( p_api_version IN NUMBER := 1
488 , p_init_msg_list IN BOOLEAN := TRUE
489 , p_commit IN BOOLEAN := FALSE
490 , p_instances IN gmp_resource_instances%ROWTYPE
491 , x_message_count OUT NOCOPY NUMBER
492 , x_message_list OUT NOCOPY VARCHAR2
493 , x_return_status OUT NOCOPY VARCHAR2
494 ) ;
495
496 /*#
497 * API for UPDATE_INSTANCE_ROW
498 * This API updates a row in Resource Instance Table ie. gmp_resource_instances.
499 * @param p_resource_id Unique Identifier of the Resource Surrogate Key
500 * @param p_instance_id Surrogate Key to uniquely identify the Instance
501 * @param p_instance_number The number identifying the resource uniquely
502 * @param p_vendor_id Surrogate Key to uniquely identify the Vendor
503 * @param p_model_number the Model number from the manufacturer for the
504 * resource
505 * @param p_serial_number the Combination of numbers, Letters and Symbols the
506 * manufacturer uses to identify the resource
507 * @param p_tracking_number the unique combination of numbers, Letters and
508 * symbols to identify the resource for internal tracking
509 * @param p_eff_start_date The Start Date for the Resource when it becomes
510 * Active
511 * @param p_eff_end_date The End Date for the Resource till it is Active
512 * @param p_last_maintenance_date The Date maintenance last occurred for the
513 * resource
514 * @param p_maintenance_interval The number of Days from the last time
515 * maintenance was done where maintenance should occur again
516 * @param p_inactive_ind Inactive indicator. 0=Active, 1=Inactive
517 * @param p_calibration_frequency Resource Calibration Frequency
518 * @param p_calibration_period Resource Calibration Period
519 * @param p_calibration_item_id The Item with which the Calibration is done
520 * @param p_last_calibration_date Standard date validation
521 * @param p_next_calibration_date Standard date validation
525 * @param p_created_by Row Who columns
522 * @param p_last_certification_date Standard date validation
523 * @param p_certified_by Person Who has done the Calibration Certification
524 * @param p_creation_date Row Who columns
526 * @param p_last_update_date Row Who columns
527 * @param p_last_updated_by Row Who columns
528 * @param p_last_update_login Row Who columns
529 * @param x_return_status Return status 'S'-Success, 'E'-Error,
530 * 'U'-Unexpected Error
531 * @rep:scope public
532 * @rep:lifecycle active
533 * @rep:displayname UPDATE_INSTANCE_ROW
534 */
535 PROCEDURE update_instance_row
536 (
537 p_resource_id IN NUMBER
538 ,p_instance_id IN NUMBER
539 ,p_instance_number IN NUMBER
540 ,p_vendor_id IN NUMBER
541 ,p_model_number IN VARCHAR2
542 ,p_serial_number IN VARCHAR2
543 ,p_tracking_number IN VARCHAR2
544 ,p_eff_start_date IN DATE
545 ,p_eff_end_date IN DATE
546 ,p_last_maintenance_date IN DATE
547 ,p_maintenance_interval IN NUMBER
548 ,p_inactive_ind IN NUMBER
549 ,p_calibration_frequency IN NUMBER
550 ,p_calibration_period IN VARCHAR2
551 ,p_calibration_item_id IN NUMBER
552 ,p_last_calibration_date IN DATE
553 ,p_next_calibration_date IN DATE
554 ,p_last_certification_date IN DATE
555 ,p_certified_by IN VARCHAR2
556 ,p_creation_date IN DATE
557 ,p_created_by IN NUMBER
558 ,p_last_update_date IN DATE
559 ,p_last_updated_by IN NUMBER
560 ,p_last_update_login IN NUMBER
561 ,x_return_status OUT NOCOPY VARCHAR2
562 ) ;
563
564 END GMP_RESOURCE_DTL_PUB;