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