1 PACKAGE WMS_RESTRICTIONS_PKG AS
2 /* $Header: WMSHPRES.pls 120.1 2005/06/21 02:19:00 appldev ship $ */
3
4 PROCEDURE INSERT_ROW (
5 x_rowid IN OUT NOCOPY VARCHAR2
6 ,x_rule_id IN NUMBER
7 ,x_sequence_number IN NUMBER
8 ,x_last_updated_by IN NUMBER
9 ,x_last_update_date IN DATE
10 ,x_created_by IN NUMBER
11 ,x_creation_date IN DATE
12 ,x_last_update_login IN NUMBER
13 ,x_parameter_id IN NUMBER
14 ,x_operator_code IN NUMBER
15 ,x_operand_type_code IN NUMBER
16 ,x_operand_constant_number IN NUMBER
17 ,x_operand_constant_character IN VARCHAR2
18 ,x_operand_constant_date IN DATE
19 ,x_operand_parameter_id IN NUMBER
20 ,x_operand_expression IN VARCHAR2
21 ,x_operand_flex_value_set_id IN NUMBER
22 ,x_logical_operator_code IN NUMBER
23 ,x_bracket_open IN VARCHAR2
24 ,x_bracket_close IN VARCHAR2
25 ,x_attribute_category IN VARCHAR2
26 ,x_attribute1 IN VARCHAR2
27 ,x_attribute2 IN VARCHAR2
28 ,x_attribute3 IN VARCHAR2
29 ,x_attribute4 IN VARCHAR2
30 ,x_attribute5 IN VARCHAR2
31 ,x_attribute6 IN VARCHAR2
32 ,x_attribute7 IN VARCHAR2
33 ,x_attribute8 IN VARCHAR2
34 ,x_attribute9 IN VARCHAR2
35 ,x_attribute10 IN VARCHAR2
36 ,x_attribute11 IN VARCHAR2
37 ,x_attribute12 IN VARCHAR2
38 ,x_attribute13 IN VARCHAR2
39 ,x_attribute14 IN VARCHAR2
40 ,x_attribute15 IN VARCHAR2
41 );
42
43 PROCEDURE LOCK_ROW (
44 x_rowid IN VARCHAR2
45 ,x_rule_id IN NUMBER
46 ,x_sequence_number IN NUMBER
47 ,x_parameter_id IN NUMBER
48 ,x_operator_code IN NUMBER
49 ,x_operand_type_code IN NUMBER
50 ,x_operand_constant_number IN NUMBER
51 ,x_operand_constant_character IN VARCHAR2
52 ,x_operand_constant_date IN DATE
53 ,x_operand_parameter_id IN NUMBER
54 ,x_operand_expression IN VARCHAR2
55 ,x_operand_flex_value_set_id IN NUMBER
56 ,x_logical_operator_code IN NUMBER
57 ,x_bracket_open IN VARCHAR2
58 ,x_bracket_close IN VARCHAR2
59 ,x_attribute_category IN VARCHAR2
60 ,x_attribute1 IN VARCHAR2
61 ,x_attribute2 IN VARCHAR2
62 ,x_attribute3 IN VARCHAR2
63 ,x_attribute4 IN VARCHAR2
64 ,x_attribute5 IN VARCHAR2
65 ,x_attribute6 IN VARCHAR2
66 ,x_attribute7 IN VARCHAR2
67 ,x_attribute8 IN VARCHAR2
68 ,x_attribute9 IN VARCHAR2
69 ,x_attribute10 IN VARCHAR2
70 ,x_attribute11 IN VARCHAR2
71 ,x_attribute12 IN VARCHAR2
72 ,x_attribute13 IN VARCHAR2
73 ,x_attribute14 IN VARCHAR2
74 ,x_attribute15 IN VARCHAR2
75 );
76
77 PROCEDURE UPDATE_ROW (
78 x_rowid IN VARCHAR2
79 ,x_rule_id IN NUMBER
80 ,x_sequence_number IN NUMBER
81 ,x_last_updated_by IN NUMBER
82 ,x_last_update_date IN DATE
83 ,x_last_update_login IN NUMBER
84 ,x_parameter_id IN NUMBER
85 ,x_operator_code IN NUMBER
86 ,x_operand_type_code IN NUMBER
87 ,x_operand_constant_number IN NUMBER
88 ,x_operand_constant_character IN VARCHAR2
89 ,x_operand_constant_date IN DATE
90 ,x_operand_parameter_id IN NUMBER
91 ,x_operand_expression IN VARCHAR2
92 ,x_operand_flex_value_set_id IN NUMBER
93 ,x_logical_operator_code IN NUMBER
94 ,x_bracket_open IN VARCHAR2
95 ,x_bracket_close IN VARCHAR2
96 ,x_attribute_category 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 );
113
114 PROCEDURE DELETE_ROW (
115 x_rowid IN VARCHAR2
116 );
117
118 PROCEDURE LOAD_ROW (
119 X_RULE_ID IN VARCHAR2
120 ,x_OWNER IN VARCHAR2
121 ,X_SEQUENCE_NUMBER IN VARCHAR2
122 ,X_PARAMETER_ID IN VARCHAR2
123 ,X_OPERATOR_CODE IN VARCHAR2
124 ,X_OPERAND_TYPE_CODE IN VARCHAR2
125 ,X_OPERAND_CONSTANT_NUMBER IN VARCHAR2
126 ,X_OPERAND_CONSTANT_CHARACTER IN VARCHAR2
127 ,X_OPERAND_CONSTANT_DATE IN VARCHAR2
128 ,X_OPERAND_PARAMETER_ID IN VARCHAR2
129 ,X_OPERAND_EXPRESSION IN VARCHAR2
130 ,X_OPERAND_FLEX_VALUE_SET_ID IN VARCHAR2
131 ,X_LOGICAL_OPERATOR_CODE IN VARCHAR2
132 ,X_BRACKET_OPEN IN VARCHAR2
133 ,X_BRACKET_CLOSE IN VARCHAR2
134 ,X_ATTRIBUTE_CATEGORY IN VARCHAR2
135 ,X_ATTRIBUTE1 IN VARCHAR2
136 ,X_ATTRIBUTE2 IN VARCHAR2
137 ,X_ATTRIBUTE3 IN VARCHAR2
138 ,X_ATTRIBUTE4 IN VARCHAR2
139 ,X_ATTRIBUTE5 IN VARCHAR2
140 ,X_ATTRIBUTE6 IN VARCHAR2
141 ,X_ATTRIBUTE7 IN VARCHAR2
142 ,X_ATTRIBUTE8 IN VARCHAR2
143 ,X_ATTRIBUTE9 IN VARCHAR2
144 ,X_ATTRIBUTE10 IN VARCHAR2
145 ,X_ATTRIBUTE11 IN VARCHAR2
146 ,X_ATTRIBUTE12 IN VARCHAR2
147 ,X_ATTRIBUTE13 IN VARCHAR2
148 ,X_ATTRIBUTE14 IN VARCHAR2
149 ,X_ATTRIBUTE15 IN VARCHAR2
150 );
151 END WMS_RESTRICTIONS_PKG;