DBA Data[Home] [Help]

PACKAGE: APPS.WMS_DB_OBJ_REF_MEMBERS_PKG

Source


1 PACKAGE WMS_DB_OBJ_REF_MEMBERS_PKG AS
2 /* $Header: WMSPPRMS.pls 120.1 2005/06/20 03:04:59 appldev ship $ */
3 --
4 PROCEDURE INSERT_ROW (
5    x_rowid                          IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
6   ,x_db_object_reference_id         IN     NUMBER
7   ,x_sequence_number                IN     NUMBER
8   ,x_db_object_id                   IN     NUMBER
9   ,x_table_alias                    IN     VARCHAR2
10   ,x_user_defined_flag              IN     VARCHAR2
11   ,x_created_by                     IN     NUMBER
12   ,x_creation_date                  IN     DATE
13   ,x_last_updated_by                IN     NUMBER
14   ,x_last_update_date               IN     DATE
15   ,x_last_update_login              IN     NUMBER
16   ,x_attribute1                     IN     VARCHAR2
17   ,x_attribute2                     IN     VARCHAR2
18   ,x_attribute3                     IN     VARCHAR2
19   ,x_attribute4                     IN     VARCHAR2
20   ,x_attribute5                     IN     VARCHAR2
21   ,x_attribute6                     IN     VARCHAR2
22   ,x_attribute7                     IN     VARCHAR2
23   ,x_attribute8                     IN     VARCHAR2
24   ,x_attribute9                     IN     VARCHAR2
25   ,x_attribute10                    IN     VARCHAR2
26   ,x_attribute11                    IN     VARCHAR2
27   ,x_attribute12                    IN     VARCHAR2
28   ,x_attribute13                    IN     VARCHAR2
29   ,x_attribute14                    IN     VARCHAR2
30   ,x_attribute15                    IN     VARCHAR2
31   ,x_attribute_category             IN     VARCHAR2
32   );
33 --
34 PROCEDURE LOCK_ROW (
35    x_rowid                          IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
36   ,x_db_object_reference_id         IN     NUMBER
37   ,x_sequence_number                IN     NUMBER
38   ,x_db_object_id                   IN     NUMBER
39   ,x_table_alias                    IN     VARCHAR2
40   ,x_user_defined_flag              IN     VARCHAR2
41   ,x_attribute1                     IN     VARCHAR2
42   ,x_attribute2                     IN     VARCHAR2
43   ,x_attribute3                     IN     VARCHAR2
44   ,x_attribute4                     IN     VARCHAR2
45   ,x_attribute5                     IN     VARCHAR2
46   ,x_attribute6                     IN     VARCHAR2
47   ,x_attribute7                     IN     VARCHAR2
48   ,x_attribute8                     IN     VARCHAR2
49   ,x_attribute9                     IN     VARCHAR2
50   ,x_attribute10                    IN     VARCHAR2
51   ,x_attribute11                    IN     VARCHAR2
52   ,x_attribute12                    IN     VARCHAR2
53   ,x_attribute13                    IN     VARCHAR2
54   ,x_attribute14                    IN     VARCHAR2
55   ,x_attribute15                    IN     VARCHAR2
56   ,x_attribute_category             IN     VARCHAR2
57   );
58 --
59 PROCEDURE UPDATE_ROW (
60    x_db_object_reference_id         IN     NUMBER
61   ,x_sequence_number                IN     NUMBER
62   ,x_db_object_id                   IN     NUMBER
63   ,x_table_alias                    IN     VARCHAR2
64   ,x_user_defined_flag              IN     VARCHAR2
65   ,x_last_updated_by                IN     NUMBER
66   ,x_last_update_date               IN     DATE
67   ,x_last_update_login              IN     NUMBER
68   ,x_attribute1                     IN     VARCHAR2
69   ,x_attribute2                     IN     VARCHAR2
70   ,x_attribute3                     IN     VARCHAR2
71   ,x_attribute4                     IN     VARCHAR2
72   ,x_attribute5                     IN     VARCHAR2
73   ,x_attribute6                     IN     VARCHAR2
74   ,x_attribute7                     IN     VARCHAR2
75   ,x_attribute8                     IN     VARCHAR2
76   ,x_attribute9                     IN     VARCHAR2
77   ,x_attribute10                    IN     VARCHAR2
78   ,x_attribute11                    IN     VARCHAR2
79   ,x_attribute12                    IN     VARCHAR2
80   ,x_attribute13                    IN     VARCHAR2
81   ,x_attribute14                    IN     VARCHAR2
82   ,x_attribute15                    IN     VARCHAR2
83   ,x_attribute_category             IN     VARCHAR2
84   );
85 --
86 PROCEDURE DELETE_ROW (
87    x_rowid IN VARCHAR2
88   );
89 PROCEDURE load_row
90   (
91     x_db_object_reference_id         IN    VARCHAR2
92    ,x_sequence_number                IN    VARCHAR2
93    ,x_owner                          IN    VARCHAR2
94    ,x_db_object_id                   IN    VARCHAR2
95    ,x_table_alias                    IN    VARCHAR2
96    ,x_user_defined_flag              IN    VARCHAR2
97    ,x_attribute1                     IN    VARCHAR2
98    ,x_attribute2                     IN    VARCHAR2
99    ,x_attribute3                     IN    VARCHAR2
100    ,x_attribute4                     IN    VARCHAR2
101    ,x_attribute5                     IN    VARCHAR2
102    ,x_attribute6                     IN    VARCHAR2
103    ,x_attribute7                     IN    VARCHAR2
104    ,x_attribute8                     IN    VARCHAR2
105    ,x_attribute9                     IN    VARCHAR2
106    ,x_attribute10                    IN    VARCHAR2
107    ,x_attribute11                    IN    VARCHAR2
108    ,x_attribute12                    IN    VARCHAR2
109    ,x_attribute13                    IN    VARCHAR2
110    ,x_attribute14                    IN    VARCHAR2
111    ,x_attribute15                    IN    VARCHAR2
112    ,x_attribute_category             IN    VARCHAR2
113    );
114 END WMS_DB_OBJ_REF_MEMBERS_PKG;