1 PACKAGE WMS_OP_PLANS_PKG AS
2 /* $Header: WMSOPTBS.pls 120.1 2006/06/19 06:55:01 amohamme noship $ */
3 --
4 PROCEDURE INSERT_ROW (
5 x_rowid IN OUT nocopy VARCHAR2
6 ,x_operation_plan_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_operation_plan_name IN VARCHAR2
13 ,x_language IN VARCHAR2
14 ,x_source_lang IN VARCHAR2
15 ,x_description IN VARCHAR2
16 ,x_system_task_type IN NUMBER
17 ,x_organization_id IN NUMBER
18 ,x_user_defined IN VARCHAR2
19 ,x_enabled_flag IN VARCHAR2
20 ,x_effective_date_from IN DATE
21 ,x_effective_date_to IN DATE
22 ,x_activity_type_id IN NUMBER
23 ,x_common_to_all_org IN VARCHAR2
24 ,x_plan_type_id IN NUMBER
25 ,x_attribute_category IN VARCHAR2 DEFAULT NULL
26 ,x_attribute1 IN VARCHAR2 DEFAULT NULL
27 ,x_attribute2 IN VARCHAR2 DEFAULT NULL
28 ,x_attribute3 IN VARCHAR2 DEFAULT NULL
29 ,x_attribute4 IN VARCHAR2 DEFAULT NULL
30 ,x_attribute5 IN VARCHAR2 DEFAULT NULL
31 ,x_attribute6 IN VARCHAR2 DEFAULT NULL
32 ,x_attribute7 IN VARCHAR2 DEFAULT NULL
33 ,x_attribute8 IN VARCHAR2 DEFAULT NULL
34 ,x_attribute9 IN VARCHAR2 DEFAULT NULL
35 ,x_attribute10 IN VARCHAR2 DEFAULT NULL
36 ,x_attribute11 IN VARCHAR2 DEFAULT NULL
37 ,x_attribute12 IN VARCHAR2 DEFAULT NULL
38 ,x_attribute13 IN VARCHAR2 DEFAULT NULL
39 ,x_attribute14 IN VARCHAR2 DEFAULT NULL
40 ,x_attribute15 IN VARCHAR2 DEFAULT NULL
41 ,x_default_flag IN VARCHAR2
42 ,x_template_flag IN VARCHAR2
43 ,x_crossdock_to_wip_flag IN VARCHAR2
44 );
45
46 --
47 PROCEDURE UPDATE_ROW (
48 x_operation_plan_id IN NUMBER
49 ,x_last_updated_by IN NUMBER
50 ,x_last_update_date IN DATE
51 ,x_last_update_login IN NUMBER
52 ,x_operation_plan_name IN VARCHAR2
53 ,x_language IN VARCHAR2
54 ,x_source_lang IN VARCHAR2
55 ,x_description IN VARCHAR2
56 ,x_system_task_type IN NUMBER
57 ,x_organization_id IN NUMBER
58 ,x_user_defined IN VARCHAR2
59 ,x_enabled_flag IN VARCHAR2
60 ,x_effective_date_from IN DATE
61 ,x_effective_date_to IN DATE
62 ,x_activity_type_id IN NUMBER
63 ,x_common_to_all_org IN VARCHAR2
64 ,x_plan_type_id IN NUMBER
65 ,x_attribute_category IN VARCHAR2 DEFAULT NULL
66 ,x_attribute1 IN VARCHAR2 DEFAULT NULL
67 ,x_attribute2 IN VARCHAR2 DEFAULT NULL
68 ,x_attribute3 IN VARCHAR2 DEFAULT NULL
69 ,x_attribute4 IN VARCHAR2 DEFAULT NULL
70 ,x_attribute5 IN VARCHAR2 DEFAULT NULL
71 ,x_attribute6 IN VARCHAR2 DEFAULT NULL
72 ,x_attribute7 IN VARCHAR2 DEFAULT NULL
73 ,x_attribute8 IN VARCHAR2 DEFAULT NULL
74 ,x_attribute9 IN VARCHAR2 DEFAULT NULL
75 ,x_attribute10 IN VARCHAR2 DEFAULT NULL
76 ,x_attribute11 IN VARCHAR2 DEFAULT NULL
77 ,x_attribute12 IN VARCHAR2 DEFAULT NULL
78 ,x_attribute13 IN VARCHAR2 DEFAULT NULL
79 ,x_attribute14 IN VARCHAR2 DEFAULT NULL
80 ,x_attribute15 IN VARCHAR2 DEFAULT NULL
81 ,x_default_flag IN VARCHAR2
82 ,x_template_flag IN VARCHAR2
83 ,x_crossdock_to_wip_flag IN VARCHAR2
84 );
85
86 --
87 PROCEDURE LOAD_ROW (
88 x_operation_plan_id IN NUMBER
89 ,x_owner IN VARCHAR2
90 ,x_last_update_date IN VARCHAR2
91 ,x_system_task_type IN NUMBER
92 ,x_organization_id IN NUMBER
93 ,x_user_defined IN VARCHAR2
94 ,x_enabled_flag IN VARCHAR2
95 ,x_effective_date_from IN DATE
96 ,x_effective_date_to IN DATE
97 ,x_activity_type_id IN NUMBER
98 ,x_common_to_all_org IN VARCHAR2
99 ,x_plan_type_id IN NUMBER
100 ,x_attribute_category IN VARCHAR2 DEFAULT NULL
101 ,x_attribute1 IN VARCHAR2 DEFAULT NULL
102 ,x_attribute2 IN VARCHAR2 DEFAULT NULL
103 ,x_attribute3 IN VARCHAR2 DEFAULT NULL
104 ,x_attribute4 IN VARCHAR2 DEFAULT NULL
105 ,x_attribute5 IN VARCHAR2 DEFAULT NULL
106 ,x_attribute6 IN VARCHAR2 DEFAULT NULL
107 ,x_attribute7 IN VARCHAR2 DEFAULT NULL
108 ,x_attribute8 IN VARCHAR2 DEFAULT NULL
109 ,x_attribute9 IN VARCHAR2 DEFAULT NULL
110 ,x_attribute10 IN VARCHAR2 DEFAULT NULL
111 ,x_attribute11 IN VARCHAR2 DEFAULT NULL
112 ,x_attribute12 IN VARCHAR2 DEFAULT NULL
113 ,x_attribute13 IN VARCHAR2 DEFAULT NULL
114 ,x_attribute14 IN VARCHAR2 DEFAULT NULL
115 ,x_attribute15 IN VARCHAR2 DEFAULT NULL
116 ,x_operation_plan_name IN VARCHAR2
117 ,x_description IN VARCHAR2
118 ,x_default_flag IN VARCHAR2
119 ,x_template_flag IN VARCHAR2
120 ,x_crossdock_to_wip_flag IN VARCHAR2
121 ,x_custom_mode IN VARCHAR2
122 );
123
124
125
126 -- added by Grace Xiao 07/28/03
127 PROCEDURE delete_row (
128 x_operation_plan_id IN NUMBER
129 );
130
131 -- added by Grace Xiao 07/28/03
132 PROCEDURE lock_row (
133 x_operation_plan_id IN NUMBER
134 ,x_operation_plan_name IN VARCHAR2
135 ,x_description IN VARCHAR2
136 ,x_system_task_type IN NUMBER
137 ,x_organization_id IN NUMBER
138 ,x_user_defined IN VARCHAR2
139 ,x_enabled_flag IN VARCHAR2
140 ,x_effective_date_from IN DATE
141 ,x_effective_date_to IN DATE
142 ,x_activity_type_id IN NUMBER
143 ,x_common_to_all_org IN VARCHAR2
144 ,x_plan_type_id IN NUMBER
145 ,x_attribute_category IN VARCHAR2 DEFAULT NULL
146 ,x_attribute1 IN VARCHAR2 DEFAULT NULL
147 ,x_attribute2 IN VARCHAR2 DEFAULT NULL
148 ,x_attribute3 IN VARCHAR2 DEFAULT NULL
149 ,x_attribute4 IN VARCHAR2 DEFAULT NULL
150 ,x_attribute5 IN VARCHAR2 DEFAULT NULL
151 ,x_attribute6 IN VARCHAR2 DEFAULT NULL
152 ,x_attribute7 IN VARCHAR2 DEFAULT NULL
153 ,x_attribute8 IN VARCHAR2 DEFAULT NULL
154 ,x_attribute9 IN VARCHAR2 DEFAULT NULL
155 ,x_attribute10 IN VARCHAR2 DEFAULT NULL
156 ,x_attribute11 IN VARCHAR2 DEFAULT NULL
157 ,x_attribute12 IN VARCHAR2 DEFAULT NULL
158 ,x_attribute13 IN VARCHAR2 DEFAULT NULL
159 ,x_attribute14 IN VARCHAR2 DEFAULT NULL
160 ,x_attribute15 IN VARCHAR2 DEFAULT NULL
161 ,x_default_flag IN VARCHAR2
162 ,x_template_flag IN VARCHAR2
163 ,x_crossdock_to_wip_flag IN VARCHAR2
164 );
165
166 PROCEDURE translate_row
167 (
168 x_operation_plan_id IN VARCHAR2 ,
169 x_owner IN VARCHAR2 ,
170 x_last_update_date IN VARCHAR2 ,
171 x_operation_plan_name IN VARCHAR2 ,
172 x_description IN VARCHAR2 ,
173 x_custom_mode IN VARCHAR2
174 );
175
176 procedure add_language;
177
178 --
179 END WMS_OP_PLANS_PKG;