1 package wms_rule_form_pkg AUTHID CURRENT_USER AS
2 /* $Header: WMSFPPRS.pls 120.1 2005/06/22 08:31:52 appldev ship $ */
3 procedure insert_rule
4 (
5 x_return_status out NOCOPY varchar2
6 ,x_msg_count out NOCOPY number
7 ,x_msg_data out NOCOPY varchar2
8 ,x_rule_id out NOCOPY NUMBER
9 ,p_api_version in number
10 ,p_organization_id in NUMBER
11 ,p_type_code in NUMBER
12 ,p_qty_function_parameter_id in NUMBER
13 ,p_enabled_flag in VARCHAR2
14 ,p_user_defined_flag in VARCHAR2
15 ,p_min_pick_tasks_flag in VARCHAR2
16 ,p_attribute_category in VARCHAR2
17 ,p_attribute1 in VARCHAR2
18 ,p_attribute2 in VARCHAR2
19 ,p_attribute3 in VARCHAR2
20 ,p_attribute4 in VARCHAR2
21 ,p_attribute5 in VARCHAR2
22 ,p_attribute6 in VARCHAR2
23 ,p_attribute7 in VARCHAR2
24 ,p_attribute8 in VARCHAR2
25 ,p_attribute9 in VARCHAR2
26 ,p_attribute10 in VARCHAR2
27 ,p_attribute11 in VARCHAR2
28 ,p_attribute12 in VARCHAR2
29 ,p_attribute13 in VARCHAR2
30 ,p_attribute14 in VARCHAR2
31 ,p_attribute15 in VARCHAR2
32 ,p_name in VARCHAR2
33 ,p_description in VARCHAR2
34 ,p_type_header_id in NUMBER
35 ,p_rule_weight in NUMBER
36 ,p_init_msg_list in varchar2 DEFAULT fnd_api.g_false
37 ,p_validation_level in number DEFAULT fnd_api.g_valid_level_full
38 ,p_allocation_mode_id in number
39 );
40
41 procedure lock_rule (
42 x_return_status out NOCOPY VARCHAR2,
43 x_msg_count out NOCOPY NUMBER,
44 x_msg_data out NOCOPY VARCHAR2,
45 p_rule_id in NUMBER,
46 p_organization_id in NUMBER,
47 p_type_code in NUMBER,
48 p_qty_function_parameter_id in NUMBER,
49 p_enabled_flag in VARCHAR2,
50 p_user_defined_flag in VARCHAR2,
51 p_min_pick_tasks_flag in VARCHAR2,
52 p_attribute_category in VARCHAR2,
53 p_attribute1 in VARCHAR2,
54 p_attribute2 in VARCHAR2,
55 p_attribute3 in VARCHAR2,
56 p_attribute4 in VARCHAR2,
57 p_attribute5 in VARCHAR2,
58 p_attribute6 in VARCHAR2,
59 p_attribute7 in VARCHAR2,
60 p_attribute8 in VARCHAR2,
61 p_attribute9 in VARCHAR2,
62 p_attribute10 in VARCHAR2,
63 p_attribute11 in VARCHAR2,
64 p_attribute12 in VARCHAR2,
65 p_attribute13 in VARCHAR2,
66 p_attribute14 in VARCHAR2,
67 p_attribute15 in VARCHAR2,
68 p_name in VARCHAR2,
69 p_description in VARCHAR2,
70 p_type_header_id in NUMBER,
71 p_rule_weight in NUMBER,
72 p_api_version in NUMBER,
73 p_init_msg_list in varchar2 DEFAULT fnd_api.g_false,
74 p_validation_level in number DEFAULT fnd_api.g_valid_level_full
75 ,p_allocation_mode_id in number
76 );
77
78 procedure update_rule (
79 x_return_status out NOCOPY VARCHAR2,
80 x_msg_count out NOCOPY NUMBER,
81 x_msg_data out NOCOPY VARCHAR2,
82 p_api_version in NUMBER,
83 p_rule_id in NUMBER,
84 p_organization_id in NUMBER,
85 p_type_code in NUMBER,
86 p_qty_function_parameter_id in NUMBER,
87 p_enabled_flag in VARCHAR2,
88 p_user_defined_flag in VARCHAR2,
89 p_min_pick_tasks_flag in VARCHAR2,
90 p_attribute_category in VARCHAR2,
91 p_attribute1 in VARCHAR2,
92 p_attribute2 in VARCHAR2,
93 p_attribute3 in VARCHAR2,
94 p_attribute4 in VARCHAR2,
95 p_attribute5 in VARCHAR2,
96 p_attribute6 in VARCHAR2,
97 p_attribute7 in VARCHAR2,
98 p_attribute8 in VARCHAR2,
99 p_attribute9 in VARCHAR2,
100 p_attribute10 in VARCHAR2,
101 p_attribute11 in VARCHAR2,
102 p_attribute12 in VARCHAR2,
103 p_attribute13 in VARCHAR2,
104 p_attribute14 in VARCHAR2,
105 p_attribute15 in VARCHAR2,
106 p_name in VARCHAR2,
107 p_description in VARCHAR2,
108 p_type_header_id in NUMBER,
109 p_rule_weight in NUMBER,
110 p_last_update_date in DATE,
111 p_last_updated_by in NUMBER,
112 p_last_update_login in NUMBER,
113 p_init_msg_list in varchar2 DEFAULT fnd_api.g_false,
114 p_validation_level in number DEFAULT fnd_api.g_valid_level_full
115 ,p_allocation_mode_id in number
116 );
117
118 procedure find_rule (
119 x_return_status out NOCOPY VARCHAR2,
120 x_msg_count out NOCOPY NUMBER,
121 x_msg_data out NOCOPY VARCHAR2,
122 x_found out NOCOPY BOOLEAN,
123 p_rule_id IN NUMBER,
124 p_api_version in NUMBER,
125 p_init_msg_list in varchar2 DEFAULT fnd_api.g_false,
126 p_validation_level in number DEFAULT fnd_api.g_valid_level_full
127 );
128
129 procedure delete_rule (
130 x_return_status out NOCOPY VARCHAR2,
131 x_msg_count out NOCOPY NUMBER,
132 x_msg_data out NOCOPY VARCHAR2,
133 p_rule_id IN NUMBER,
134 p_api_version in NUMBER,
135 p_init_msg_list in varchar2 DEFAULT fnd_api.g_false,
136 p_validation_level in number DEFAULT fnd_api.g_valid_level_full
137 );
138
139 procedure copy_rule
140 (
141 x_return_status out NOCOPY VARCHAR2
142 ,x_msg_count out NOCOPY NUMBER
143 ,x_msg_data out NOCOPY VARCHAR2
144 ,x_new_rule_id out NOCOPY NUMBER
145 ,p_orig_rule_id IN NUMBER
146 ,p_new_rule_name IN VARCHAR2
147 ,p_new_description IN VARCHAR2
148 ,p_new_organization_id IN NUMBER
149 ,p_new_type_code IN NUMBER
150 ,p_copy_restriction_flag IN VARCHAR2
151 ,p_copy_sort_criteria_flag IN VARCHAR2
152 ,p_api_version in NUMBER
153 ,p_init_msg_list in varchar2 DEFAULT fnd_api.g_false
154 ,p_validation_level in number DEFAULT fnd_api.g_valid_level_full
155 );
156
157 --Added to fix the Bug #3941280
158 FUNCTION check_wms_rule_exists
159 (
160 p_std_operation_id IN NUMBER
161 )
162 RETURN BOOLEAN;
163
164 end WMS_RULE_FORM_PKG;
165