1 PACKAGE EGO_TRANSACTION_ATTRS_PVT AUTHID CURRENT_USER AS
2 /* $Header: EGOVITAS.pls 120.7 2011/04/19 20:05:46 sreharih ship $ */
3
4 --
5 -- Bug 9980051. Added version number parameter.
6 -- For MIB we need to validate the attributes
7 -- and its other properties against the version
8 -- created and not against the default version.
9 -- sreharih. Tue Apr 19 11:06:55 PDT 2011
10 --
11
12 -- ============================================================================
13 -- Name : Check_TA_IS_INVALID
14 -- Description : This function will be used to validate if any transaction
15 -- atrribute exist with same internal name/display name or sequence
16 -- while creating/updating a transaction attribute.
17 -- Parameters:
18 -- IN :
19 -- p_item_cat_group_id IN NUMBER
20 -- Item catalog group id value for that transaction attribute
21 --
22 -- p_attr_id IN VARCHAR2
23 -- attr_id of a transaction attribute to be created.
24 --
25 -- p_attr_name IN VARCHAR2
26 -- Internal Name of transaction attribute to be created.
27 --
28 -- p_attr_disp_name IN VARCHAR2
29 -- Display Name of transaction attribute to be created.
30 --
31 -- p_attr_sequence IN NUMBER
32 -- Sequence value for transaction attribute to be created,
33 -- corresponding to ICC p_item_cat_group_id.
34 --
35 -- p_icc_version_number IN NUMBER
36 -- Version number of the ICC.
37 --
38 -- ============================================================================
39
40 FUNCTION Check_TA_IS_INVALID (
41 p_item_cat_group_id IN NUMBER,
42 p_attr_id IN NUMBER,
43 p_attr_name IN VARCHAR2 DEFAULT NULL ,
44 p_attr_disp_name IN VARCHAR2 DEFAULT NULL ,
45 p_attr_sequence IN NUMBER DEFAULT NULL,
46 p_icc_version_number IN NUMBER DEFAULT 0 -- bug 9980051
47 )
48 RETURN BOOLEAN;
49
50
51 -- ============================================================================
52 -- Name : IS_METADATA_CHANGE
53 -- Description : This function will be used to validate if any transaction
54 -- atrribute exist with same internal name/display name or sequence
55 -- while creating/updating a transaction attribute.
56 -- Parameters:
57 -- IN :
58 -- p_item_cat_group_id IN NUMBER
59 -- Item catalog group id value for that transaction attribute
60 --
61 -- p_attr_id IN VARCHAR2
62 -- attr_id of a transaction attribute to be created.
63 --
64 -- p_attr_name IN VARCHAR2
65 -- Internal Name of transaction attribute to be created.
66 --
67 -- p_attr_disp_name IN VARCHAR2
68 -- Display Name of transaction attribute to be created.
69 --
70 -- p_attr_sequence IN NUMBER
71 -- Sequence value for transaction attribute to be created,
72 -- corresponding to ICC p_item_cat_group_id.
73 -- ============================================================================
74 PROCEDURE IS_METADATA_CHANGE (
75 p_tran_attrs_tbl IN EGO_TRAN_ATTR_TBL,
76 p_ta_metadata_tbl OUT NOCOPY EGO_TRAN_ATTR_TBL,
77 x_return_status OUT NOCOPY VARCHAR2,
78 x_msg_count OUT NOCOPY NUMBER,
79 x_msg_data OUT NOCOPY VARCHAR2);
80
81
82 -- ============================================================================
83 -- Name : Check_Ta_Int_Name_Exist
84 -- Description : This function will be used to validate if any transaction
85 -- atrribute exist with same internal name while creating/ updating
86 -- a transaction attribute.
87 -- Parameters:
88 -- IN :
89 -- p_item_cat_group_id IN NUMBER
90 -- Item catalog group id value for that transaction attribute
91 --
92 -- p_attr_name IN VARCHAR2
93 -- Internal Name of transaction attribute to be created.
94 -- ============================================================================
95 /*
96 FUNCTION Check_Ta_Int_Name_Exist (
97 p_item_cat_group_id IN NUMBER,
98 p_attr_id IN NUMBER,
99 p_attr_name IN VARCHAR2
100 )
101 RETURN BOOLEAN; */
102
103 -- ============================================================================
104 -- Name : Check_Ta_Disp_Name_Exist
105 -- Description : This function will be used to validate if any transaction
106 -- atrribute exist with same display name while creating/ updating
107 -- a transaction attribute.
108 -- Parameters:
109 -- IN :
110 -- p_item_cat_group_id IN NUMBER
111 -- Item catalog group id value for that transaction attribute
112 --
113 -- p_attr_disp_name IN VARCHAR2
114 -- Display Name of transaction attribute to be created.
115 -- ============================================================================
116 /*
117 FUNCTION Check_Ta_Disp_Name_Exist (
118 p_item_cat_group_id IN NUMBER,
119 p_attr_id IN NUMBER,
120 p_attr_disp_name IN VARCHAR2
121 )
122 RETURN BOOLEAN;
123
124 */
125 -- ============================================================================
126 -- Name : Check_Ta_Sequence_Exist
127 -- Description : This function will be used to validate if any transaction
128 -- atrribute exist with same sequence while creating/ updating
129 -- a transaction attribute.
130 -- Parameters:
131 -- IN :
132 -- p_item_cat_group_id IN NUMBER
133 -- Item catalog group id value for that transaction attribute
134 --
135 -- p_attr_sequence IN NUMBER
136 -- Sequence value for transaction attribute to be created,
137 -- corresponding to ICC p_item_cat_group_id.
138 -- ============================================================================
139 /*
140 FUNCTION Check_Ta_Sequence_Exist (
141 p_item_cat_group_id IN NUMBER,
142 p_attr_id IN NUMBER,
143 p_attr_sequence IN NUMBER
144 )
145 RETURN BOOLEAN;
146 */
147 -- ============================================================================
148 -- Name : Check_Ta_Default_Value_Null
149 -- Description : This function will be used to validate if default value is NULL
150 -- for a transaction attribute whose requiredflag and readonlyflag
151 -- both are checked
152 -- Parameters:
153 -- IN :
154 -- p_item_cat_group_id IN NUMBER
155 -- Item catalog group id value for that transaction attribute.
156 -- ============================================================================
157 /*
158 FUNCTION Check_Ta_Default_Value_Null (
159 p_item_cat_group_id IN NUMBER
160 )
161 RETURN BOOLEAN;
162
163 */
164 -- ============================================================================
165 -- Name : Create_Transaction_Attribute
166 -- Description : This procedure will be used to create a transaction
167 -- atrribute.
168 -- Parameters:
169 -- IN :
170 -- p_api_version IN NUMBER
171 -- Active API version number
172 --
173 -- p_tran_attrs_tbl IN EGO_TRAN_ATTR_TBL
174 -- Nested table instance having information of metadata of a
175 -- transaction attribute.
176 --
177 --
178 -- OUT :
179 -- x_return_status OUT NOCOPY VARCHAR2
180 -- Used to get status of a procedure, whether it executed
181 -- Successfully or not.
182 --
183 -- x_msg_count OUT NOCOPY NUMBER
184 --
185 -- x_msg_data OUT NOCOPY VARCHAR2
186 --
187 -- ============================================================================
188
189 PROCEDURE Create_Transaction_Attribute (
190 p_api_version IN NUMBER,
191 p_tran_attrs_tbl IN EGO_TRAN_ATTR_TBL,
192 x_return_status OUT NOCOPY VARCHAR2,
193 x_msg_count OUT NOCOPY NUMBER,
194 x_msg_data OUT NOCOPY VARCHAR2) ;
195
196
197 -- ============================================================================
198 -- Name : Update_Transaction_Attribute
199 -- Description : This procedure will be used to update a transaction
200 -- atrribute.
201 -- IN :
202 -- p_api_version IN NUMBER
203 -- Active API version number
204 --
205 -- p_tran_attrs_tbl IN EGO_TRAN_ATTR_TBL
206 -- Nested table instance having information of metadata of a
207 -- transaction attribute.
208 --
209 --
210 -- OUT :
211 -- x_return_status OUT NOCOPY VARCHAR2
212 -- Used to get status of a procedure, whether it executed
213 -- Successfully or not.
214 --
215 -- x_msg_count OUT NOCOPY NUMBER
216 --
217 -- x_msg_data OUT NOCOPY VARCHAR2
218 --
219 -- ============================================================================
220
221
222 PROCEDURE Update_Transaction_Attribute (
223 p_api_version IN NUMBER,
224 p_tran_attrs_tbl IN EGO_TRAN_ATTR_TBL,
225 x_return_status OUT NOCOPY VARCHAR2,
226 x_msg_count OUT NOCOPY NUMBER,
227 x_msg_data OUT NOCOPY VARCHAR2) ;
228
229 -- ============================================================================
230 -- Name : Delete_Transaction_Attribute
231 -- Description : This procedure will be used to update a transaction
232 -- atrribute.
233 -- IN :
234 -- p_api_version IN NUMBER
235 -- Active API version number
236 --
237 -- p_association_id IN NUMBER
238 -- Association Id corresponding to a attribute group of a
239 -- transaction attribute.
240 --
241 -- p_attr_id IN NUMBER
242 -- Attribute Id corresponding to a transaction attribute.
243 --
244 -- OUT :
245 -- x_return_status OUT NOCOPY VARCHAR2
246 -- Used to get status of a procedure, whether it executed
247 -- Successfully or not.
248 --
249 -- x_msg_count OUT NOCOPY NUMBER
250 --
251 -- x_msg_data OUT NOCOPY VARCHAR2
252 --
253 -- ============================================================================
254
255 PROCEDURE Delete_Transaction_Attribute (
256 p_api_version IN NUMBER,
257 p_association_id IN NUMBER,
258 p_attr_id IN NUMBER,
259 x_return_status OUT NOCOPY VARCHAR2,
260 x_msg_count OUT NOCOPY NUMBER,
261 x_msg_data OUT NOCOPY VARCHAR2) ;
262
263
264 /**Override procedure */
265 -- ============================================================================
266 -- Name : Delete_Transaction_Attribute
267 -- Description : This procedure will be used to update a transaction
268 -- atrribute.
269 -- IN :
270 -- p_api_version IN NUMBER
271 -- Active API version number
272 --
273 -- p_tran_attrs_tbl IN EGO_TRAN_ATTR_TBL
274 -- Nested table instance having information of metadata of a
275 -- transaction attribute.
276 --
277 --
278 -- OUT :
279 -- x_return_status OUT NOCOPY VARCHAR2
280 -- Used to get status of a procedure, whether it executed
281 -- Successfully or not.
282 --
283 -- x_msg_count OUT NOCOPY NUMBER
284 --
285 -- x_msg_data OUT NOCOPY VARCHAR2
286 --
287 -- ============================================================================
288
289 PROCEDURE Delete_Transaction_Attribute (
290 p_api_version IN NUMBER,
291 p_tran_attrs_tbl IN EGO_TRAN_ATTR_TBL,
292 x_return_status OUT NOCOPY VARCHAR2,
293 x_msg_count OUT NOCOPY NUMBER,
294 x_msg_data OUT NOCOPY VARCHAR2) ;
295
296 -- ============================================================================
297 -- Name : Release_Transaction_Attribute
298 -- Description : This procedure will be used to release transaction
299 -- atrribute for a ICC version.
300 -- IN :
301 -- p_api_version IN NUMBER
302 -- Active API version number
303 --
304 -- /*p_tran_attrs_tbl IN EGO_TRAN_ATTR_TBL
305 -- Nested table instance having information of metadata of a
306 -- transaction attribute.*/
307 --
308 -- p_icc_id IN NUMBER
309 -- Passed in ICC id.
310 --
311 -- p_version_number IN NUMBER
312 -- Version Id corresponding to passed in ICC id.
313 --
314 --
315 -- OUT :
316 -- x_return_status OUT NOCOPY VARCHAR2
317 -- Used to get status of a procedure, whether it executed
318 -- Successfully or not.
319 --
320 -- x_msg_count OUT NOCOPY NUMBER
321 --
322 -- x_msg_data OUT NOCOPY VARCHAR2
323 --
324 -- ============================================================================
325
326
327 PROCEDURE Release_Transaction_Attribute (
328 p_api_version IN NUMBER,
329 p_icc_id IN NUMBER,
330 p_version_number IN NUMBER,
331 --p_tran_attrs_tbl IN EGO_TRAN_ATTR_TBL,
332 x_return_status OUT NOCOPY VARCHAR2,
333 x_msg_count OUT NOCOPY NUMBER,
334 x_msg_data OUT NOCOPY VARCHAR2) ;
335
336
337 -- ============================================================================
338 -- Name : Copy_Transaction_Attribute
339 -- Description : This procedure will create copy of a transaction attribute with
340 -- new released icc_version_number.
341 -- IN :
342 -- p_icc_id IN NUMBER
343 -- Passed in ICC id.
344 --
345 -- p_version_number IN NUMBER
346 -- Version Id corresponding to passed in ICC id.
347 --
348 -- OUT :
349 -- x_return_status OUT NOCOPY VARCHAR2
350 -- Used to get status of a procedure, whether it executed
351 -- Successfully or not.
352 --
353 -- x_msg_count OUT NOCOPY NUMBER
354 --
355 -- x_msg_data OUT NOCOPY VARCHAR2
356 --
357 -- ============================================================================
358
359 PROCEDURE Copy_Transaction_Attribute (
360 p_item_cat_group_id IN NUMBER,
361 p_version_number IN NUMBER,
362 x_return_status OUT NOCOPY VARCHAR2,
363 x_msg_count OUT NOCOPY NUMBER,
364 x_msg_data OUT NOCOPY VARCHAR2);
365
366 -- ============================================================================
367 -- Name : Copy_Transaction_Attribute
371 -- p_source_icc_id IN NUMBER
368 -- Description : This procedure will create copy of a transaction attribute for
369 -- passed in source and destination parameter.
370 -- IN :
372 -- Passed in ICC id from where TA need to copy.
373 --
374 -- p_source_ver_no IN NUMBER
375 -- Version Id corresponding to passed in ICC id to be copy.
376 --
377 -- p_sorce_item_id IN NUMBER
378 -- passed in inventory_item_id.
379 --
380 -- p_source_rev_id IN NUMBER
381 -- revision Id for passed in inventory_item_id.
382 --
383 -- p_source_org_id IN NUMBER
384 -- org Id of inventory_item_id.
385 --
386 -- p_dest_icc_id IN NUMBER
387 -- Destination ICC id for which TA need to be copy.
388 --
389 -- p_dest_ver_no IN NUMBER
390 -- Destination Id corresponding to passed in destination ICC id.
391 --
392 -- p_dest_item_id IN NUMBER
393 -- passed in inventory_item_id.
394 --
395 -- p_dest_rev_id IN NUMBER
396 -- revision Id for passed in inventory_item_id.
397 --
398 -- p_dest_org_id IN NUMBER
399 -- org Id of inventory_item_id.
400 --
401 --
402 -- OUT :
403 -- x_return_status OUT NOCOPY VARCHAR2
404 -- Used to get status of a procedure, whether it executed
405 -- Successfully or not.
406 --
407 -- x_msg_count OUT NOCOPY NUMBER
408 --
409 -- x_msg_data OUT NOCOPY VARCHAR2
410 --
411 -- ============================================================================
412
413 PROCEDURE Copy_Transaction_Attribute (
414 p_source_icc_id IN NUMBER,
415 p_source_ver_no IN NUMBER,
416 p_sorce_item_id IN NUMBER,
417 p_source_rev_id IN NUMBER,
418 p_source_org_id IN NUMBER,
419 p_dest_icc_id IN NUMBER,
420 p_dest_ver_no IN NUMBER,
421 p_dest_item_id IN NUMBER,
422 p_dest_rev_id IN NUMBER,
423 p_dest_org_id IN NUMBER,
424 p_init_msg_list IN BOOLEAN DEFAULT TRUE, --- Bug 9791391, made default true to maintain existing TA code
425 x_return_status OUT NOCOPY VARCHAR2, --- , generally default is FALSE
426 x_msg_count OUT NOCOPY NUMBER,
427 x_msg_data OUT NOCOPY VARCHAR2);
428
429 -- ============================================================================
430 -- Name : Revert_Transaction_Attribute
431 -- Description : This procedure will revert to a earlier version.
432 -- IN :
433 -- p_source_icc_id IN NUMBER
434 -- Passed in ICC id from where TA need to copy.
435 --
436 -- p_source_ver_no IN NUMBER
437 -- Version Id corresponding to passed in ICC id to be copy.
438 --
439 -- p_sorce_item_id IN NUMBER
440 -- passed in inventory_item_id.
441 --
442 -- p_source_rev_id IN NUMBER
443 -- revision Id for passed in inventory_item_id.
444 --
445 -- p_source_org_id IN NUMBER
446 -- org Id of inventory_item_id.
447 --
448 -- p_dest_icc_id IN NUMBER
449 -- Destination ICC id for which TA need to be copy.
450 --
451 -- p_dest_ver_no IN NUMBER
452 -- Destination Id corresponding to passed in destination ICC id.
453 --
454 -- p_dest_item_id IN NUMBER
455 -- passed in inventory_item_id.
456 --
457 -- p_dest_rev_id IN NUMBER
458 -- revision Id for passed in inventory_item_id.
459 --
460 -- p_dest_org_id IN NUMBER
461 -- org Id of inventory_item_id.
462 --
463 --
464 -- OUT :
465 -- x_return_status OUT NOCOPY VARCHAR2
466 -- Used to get status of a procedure, whether it executed
467 -- Successfully or not.
468 --
469 -- x_msg_count OUT NOCOPY NUMBER
470 --
471 -- x_msg_data OUT NOCOPY VARCHAR2
472 --
473 -- ============================================================================
474 PROCEDURE Revert_Transaction_Attribute (
475 p_source_icc_id IN NUMBER,
476 p_source_ver_no IN NUMBER,
477 p_init_msg_list IN BOOLEAN DEFAULT TRUE, --- Bug 9791391, made default true to maintain existing TA code,
478 x_return_status OUT NOCOPY VARCHAR2, --- generally default is FALSE
479 x_msg_count OUT NOCOPY NUMBER,
480 x_msg_data OUT NOCOPY VARCHAR2);
481 --=================================================================================
482
483 -- Name : Get_Trans_Attr_Metadata
484 -- Description : This procedure will be used to retreive transaction attribute metadata based on given parameter
485 -- Parameters:
486 -- IN :
487 -- p_item_catalog_category_id
488 -- p_icc_version
489 -- p_attribute_id
490 -- p_inventory_item_id
491 -- p_organization_id
492 -- p_revision_id
493 --
494 -- OUT :
495 -- x_ta_metadata_tbl OUT NOCOPY VARCHAR2
496 -- Out parameter contain the record of transaction attribute metadata.
497 -- return null if given input is not valid
498
499 PROCEDURE Get_Trans_Attr_Metadata(
500 x_ta_metadata_tbl OUT NOCOPY EGO_TRAN_ATTR_TBL,
501 p_item_catalog_category_id IN number,
502 p_icc_version IN number,
503 p_attribute_id IN NUMBER,
504 p_inventory_item_id IN NUMBER ,
505 p_organization_id IN NUMBER,
506 p_revision_id IN NUMBER,
507 x_return_status OUT NOCOPY VARCHAR2 ,
508 x_is_inherited OUT NOCOPY varchar2,
509 x_is_modified OUT NOCOPY varchar2
510 ) ;
511
512
513 -- ============================================================================
514 -- Name : Create_Transaction_Attribute
515 -- Description : This procedure will be used to create a transaction
516 -- atrribute.
517 -- Parameters:
518 -- IN :
519 -- p_api_version IN NUMBER
520 -- Active API version number
521 --
522 -- p_tran_attrs_tbl IN EGO_TRAN_ATTR_TBL
523 -- Nested table instance having information of metadata of a
524 -- transaction attribute.
525 --
526 --
527 -- OUT :
528 -- x_return_status OUT NOCOPY VARCHAR2
529 -- Used to get status of a procedure, whether it executed
530 -- Successfully or not.
531 --
532 -- x_msg_count OUT NOCOPY NUMBER
533 --
534 -- x_msg_data OUT NOCOPY VARCHAR2
535 --
536 -- ============================================================================
537
538 PROCEDURE Create_Inherited_Trans_Attr(
539 p_api_version IN NUMBER,
540 p_tran_attrs_tbl IN EGO_TRAN_ATTR_TBL,
541 x_return_status OUT NOCOPY VARCHAR2,
542 x_msg_count OUT NOCOPY NUMBER,
543 x_msg_data OUT NOCOPY VARCHAR2) ;
544
545 -- ============================================================================
546 -- Name : Check_VS_Data_Type
547 -- Description : This function will check if data type of value set is valid
548 -- or not and will return true or false based on validation.
549 --
550 -- IN :
551 -- p_value_set_id IN NUMBER
552 -- Passed in Value Set Id associate to TA.
553 --
554 -- p_data_type IN NUMBER
555 -- Data type of value set.
556 --
557 -- OUT :
558 -- Boolean value returning true or false.
559 -- ============================================================================
560 FUNCTION Check_VS_Data_Type (
561 p_value_set_id IN NUMBER,
562 p_data_type IN VARCHAR2
563 )
564 RETURN BOOLEAN;
565
566 -- ============================================================================
567 -- Name : GET_ATTR_DISP_NAME
568 --
569 -- Description : This function will be used to get transaction atrribute display
570 -- name down the hierarchy at Item/ICC and will return first not null
571 -- attribute display name.
572 -- Parameters:
573 -- IN :
574 -- P_ITEM_CAT_GROUP_ID IN NUMBER
575 -- Item catalog group id value.
576 --
577 -- P_ICC_VERSION_NUMBER IN NUMBER
578 -- Version Id corresponding to passed in ICC id.
579 --
580 -- P_INVENTORY_ITEM_ID IN NUMBER
581 -- passed in inventory_item_id.
582 --
583 -- P_ORGANIZATION_ID IN NUMBER
584 -- org Id of inventory_item_id.
585 --
586 -- P_REVISION_ID IN NUMBER
587 -- revision Id for passed in inventory_item_id.
588 --
589 -- P_CREATION_DATE IN VARCHAR2
590 -- creation date of effective version of ICC or that of Item.
591 --
592 -- P_START_DATE IN VARCHAR2
593 -- Start Effective date of effective version of ICC or that of Item.
594 --
595 -- P_ATTR_ID IN VARCHAR2
596 -- attr_id of a transaction attribute to get corresponding
597 -- attribute display name.
598 -- OUT :
599 -- Varchar value returning Display Name of transaction attribute.
600 --
601 -- ============================================================================
602
603 FUNCTION GET_ATTR_DISP_NAME (
604 P_ITEM_CAT_GROUP_ID IN NUMBER,
605 P_ICC_VERSION_NUMBER IN NUMBER,
606 P_INVENTORY_ITEM_ID IN NUMBER DEFAULT NULL,
610 P_START_DATE IN DATE DEFAULT NULL,
607 P_ORGANIZATION_ID IN NUMBER DEFAULT NULL,
608 P_REVISION_ID IN NUMBER DEFAULT NULL,
609 P_CREATION_DATE IN DATE DEFAULT NULL,
611 P_ATTR_ID IN NUMBER
612 )
613 RETURN VARCHAR2;
614
615 -- ============================================================================
616 -- Name : GET_VS_ID
617 --
618 -- Description : This function will be used to get value set Id down the hierarchy
619 -- at Item/ICC and will return first not null that is associated to
620 -- transaction atrribute.
621 -- Parameters:
622 -- IN :
623 -- P_ITEM_CAT_GROUP_ID IN NUMBER
624 -- Item catalog group id value.
625 --
626 -- P_ICC_VERSION_NUMBER IN NUMBER
627 -- Version Id corresponding to passed in ICC id.
628 --
629 -- P_INVENTORY_ITEM_ID IN NUMBER
630 -- passed in inventory_item_id.
631 --
632 -- P_ORGANIZATION_ID IN NUMBER
633 -- org Id of inventory_item_id.
634 --
635 -- P_REVISION_ID IN NUMBER
636 -- revision Id for passed in inventory_item_id.
637 --
638 -- P_CREATION_DATE IN VARCHAR2
639 -- creation date of effective version of ICC or that of Item.
640 --
641 -- P_START_DATE IN VARCHAR2
642 -- Start Effective date of effective version of ICC or that of Item.
643 --
644 -- P_ATTR_ID IN VARCHAR2
645 -- attr_id of a transaction attribute to get corresponding
646 -- attribute display name.
647 -- OUT :
648 -- Number value returning value set id corresponding to transaction attribute.
649 --
650 -- ============================================================================
651 FUNCTION GET_VS_ID (
652 P_ITEM_CAT_GROUP_ID IN NUMBER,
653 P_ICC_VERSION_NUMBER IN NUMBER,
654 P_INVENTORY_ITEM_ID IN NUMBER DEFAULT NULL,
655 P_ORGANIZATION_ID IN NUMBER DEFAULT NULL,
656 P_REVISION_ID IN NUMBER DEFAULT NULL,
657 P_CREATION_DATE IN DATE DEFAULT NULL,
658 P_START_DATE IN DATE DEFAULT NULL,
659 P_ATTR_ID IN NUMBER
660 )
661 RETURN NUMBER;
662
663 PROCEDURE has_invalid_char (
664 p_internal_name IN VARCHAR2,
665 x_has_invalid_chars OUT NOCOPY VARCHAR2
666 );
667
668 END EGO_TRANSACTION_ATTRS_PVT ;