1 package wms_restriction_form_pkg AS
2 /* $Header: WMSFPRES.pls 120.1 2005/06/20 05:09:40 appldev ship $ */
3
4 procedure insert_restriction
5 (
6 p_api_version IN NUMBER
7 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
8 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
9 ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
10 ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
11 ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
12 ,p_rowid IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
13 ,p_rule_id IN NUMBER
14 ,p_sequence_number IN NUMBER
15 ,p_parameter_id IN NUMBER
16 ,p_operator_code IN NUMBER
17 ,p_operand_type_code IN NUMBER
18 ,p_operand_constant_number IN NUMBER
19 ,p_operand_constant_character IN VARCHAR2
20 ,p_operand_constant_date IN DATE
21 ,p_operand_parameter_id IN NUMBER
22 ,p_operand_expression IN VARCHAR2
23 ,p_operand_flex_value_set_id IN NUMBER
24 ,p_logical_operator_code IN NUMBER
25 ,p_bracket_open IN VARCHAR2
26 ,p_bracket_close IN VARCHAR2
27 ,p_attribute_category IN VARCHAR2
28 ,p_attribute1 IN VARCHAR2
29 ,p_attribute2 IN VARCHAR2
30 ,p_attribute3 IN VARCHAR2
31 ,p_attribute4 IN VARCHAR2
32 ,p_attribute5 IN VARCHAR2
33 ,p_attribute6 IN VARCHAR2
34 ,p_attribute7 IN VARCHAR2
35 ,p_attribute8 IN VARCHAR2
36 ,p_attribute9 IN VARCHAR2
37 ,p_attribute10 IN VARCHAR2
38 ,p_attribute11 IN VARCHAR2
39 ,p_attribute12 IN VARCHAR2
40 ,p_attribute13 IN VARCHAR2
41 ,p_attribute14 IN VARCHAR2
42 ,p_attribute15 IN VARCHAR2
43 );
44
45 procedure lock_restriction (
46 p_api_version IN NUMBER
47 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
48 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
49 ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
50 ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
51 ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
52 ,p_rowid IN VARCHAR2
53 ,p_rule_id IN NUMBER
54 ,p_sequence_number IN NUMBER
55 ,p_parameter_id IN NUMBER
56 ,p_operator_code IN NUMBER
57 ,p_operand_type_code IN NUMBER
58 ,p_operand_constant_number IN NUMBER
59 ,p_operand_constant_character IN VARCHAR2
60 ,p_operand_constant_date IN DATE
61 ,p_operand_parameter_id IN NUMBER
62 ,p_operand_expression IN VARCHAR2
63 ,p_operand_flex_value_set_id IN NUMBER
64 ,p_logical_operator_code IN NUMBER
65 ,p_bracket_open IN VARCHAR2
66 ,p_bracket_close IN VARCHAR2
67 ,p_attribute_category IN VARCHAR2
68 ,p_attribute1 IN VARCHAR2
69 ,p_attribute2 IN VARCHAR2
70 ,p_attribute3 IN VARCHAR2
71 ,p_attribute4 IN VARCHAR2
72 ,p_attribute5 IN VARCHAR2
73 ,p_attribute6 IN VARCHAR2
74 ,p_attribute7 IN VARCHAR2
75 ,p_attribute8 IN VARCHAR2
76 ,p_attribute9 IN VARCHAR2
77 ,p_attribute10 IN VARCHAR2
78 ,p_attribute11 IN VARCHAR2
79 ,p_attribute12 IN VARCHAR2
80 ,p_attribute13 IN VARCHAR2
81 ,p_attribute14 IN VARCHAR2
82 ,p_attribute15 IN VARCHAR2
83 );
84
85 procedure update_restriction (
86 p_api_version IN NUMBER
87 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
88 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
89 ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
90 ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
91 ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
92 ,p_rowid IN VARCHAR2
93 ,p_rule_id IN NUMBER
94 ,p_sequence_number IN NUMBER
95 ,p_parameter_id IN NUMBER
96 ,p_operator_code IN NUMBER
97 ,p_operand_type_code IN NUMBER
98 ,p_operand_constant_number IN NUMBER
99 ,p_operand_constant_character IN VARCHAR2
100 ,p_operand_constant_date IN DATE
101 ,p_operand_parameter_id IN NUMBER
102 ,p_operand_expression IN VARCHAR2
103 ,p_operand_flex_value_set_id IN NUMBER
104 ,p_logical_operator_code IN NUMBER
105 ,p_bracket_open IN VARCHAR2
106 ,p_bracket_close IN VARCHAR2
107 ,p_attribute_category IN VARCHAR2
108 ,p_attribute1 IN VARCHAR2
109 ,p_attribute2 IN VARCHAR2
110 ,p_attribute3 IN VARCHAR2
111 ,p_attribute4 IN VARCHAR2
112 ,p_attribute5 IN VARCHAR2
113 ,p_attribute6 IN VARCHAR2
114 ,p_attribute7 IN VARCHAR2
115 ,p_attribute8 IN VARCHAR2
116 ,p_attribute9 IN VARCHAR2
117 ,p_attribute10 IN VARCHAR2
118 ,p_attribute11 IN VARCHAR2
119 ,p_attribute12 IN VARCHAR2
120 ,p_attribute13 IN VARCHAR2
121 ,p_attribute14 IN VARCHAR2
122 ,p_attribute15 IN VARCHAR2
123 ) ;
124
125 procedure delete_restriction (
126 p_api_version in NUMBER,
127 p_init_msg_list in varchar2 := fnd_api.g_false,
128 p_validation_level in number := fnd_api.g_valid_level_full,
129 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
130 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
131 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
132 p_rowid IN VARCHAR2,
133 p_rule_id IN NUMBER,
134 p_sequence_number IN NUMBER
135 );
136
137 -- this private procedure should be used only by the wms_rule_form_pkg.delete_rule
138 -- no validation is done whatsoever
139 procedure delete_restrictions (
140 p_rule_id IN NUMBER
141 );
142
143 end WMS_RESTRICTION_FORM_PKG;