269: p_rule_id IN NUMBER DEFAULT NULL
270: );
271: --
272: TYPE rule_rec IS RECORD
273: (rule_id wms_rules_vl.rule_id%TYPE DEFAULT NULL ,
274: organization_id wms_rules_vl.organization_id%TYPE DEFAULT NULL ,
275: type_code wms_rules_vl.type_code%TYPE DEFAULT NULL ,
276: name wms_rules_vl.name%TYPE DEFAULT NULL ,
277: description wms_rules_vl.description%TYPE DEFAULT NULL ,
270: );
271: --
272: TYPE rule_rec IS RECORD
273: (rule_id wms_rules_vl.rule_id%TYPE DEFAULT NULL ,
274: organization_id wms_rules_vl.organization_id%TYPE DEFAULT NULL ,
275: type_code wms_rules_vl.type_code%TYPE DEFAULT NULL ,
276: name wms_rules_vl.name%TYPE DEFAULT NULL ,
277: description wms_rules_vl.description%TYPE DEFAULT NULL ,
278: qty_function_parameter_id
271: --
272: TYPE rule_rec IS RECORD
273: (rule_id wms_rules_vl.rule_id%TYPE DEFAULT NULL ,
274: organization_id wms_rules_vl.organization_id%TYPE DEFAULT NULL ,
275: type_code wms_rules_vl.type_code%TYPE DEFAULT NULL ,
276: name wms_rules_vl.name%TYPE DEFAULT NULL ,
277: description wms_rules_vl.description%TYPE DEFAULT NULL ,
278: qty_function_parameter_id
279: wms_rules_vl.qty_function_parameter_id%TYPE DEFAULT NULL,
272: TYPE rule_rec IS RECORD
273: (rule_id wms_rules_vl.rule_id%TYPE DEFAULT NULL ,
274: organization_id wms_rules_vl.organization_id%TYPE DEFAULT NULL ,
275: type_code wms_rules_vl.type_code%TYPE DEFAULT NULL ,
276: name wms_rules_vl.name%TYPE DEFAULT NULL ,
277: description wms_rules_vl.description%TYPE DEFAULT NULL ,
278: qty_function_parameter_id
279: wms_rules_vl.qty_function_parameter_id%TYPE DEFAULT NULL,
280: enabled_flag wms_rules_vl.enabled_flag%TYPE DEFAULT NULL ,
273: (rule_id wms_rules_vl.rule_id%TYPE DEFAULT NULL ,
274: organization_id wms_rules_vl.organization_id%TYPE DEFAULT NULL ,
275: type_code wms_rules_vl.type_code%TYPE DEFAULT NULL ,
276: name wms_rules_vl.name%TYPE DEFAULT NULL ,
277: description wms_rules_vl.description%TYPE DEFAULT NULL ,
278: qty_function_parameter_id
279: wms_rules_vl.qty_function_parameter_id%TYPE DEFAULT NULL,
280: enabled_flag wms_rules_vl.enabled_flag%TYPE DEFAULT NULL ,
281: user_defined_flag
275: type_code wms_rules_vl.type_code%TYPE DEFAULT NULL ,
276: name wms_rules_vl.name%TYPE DEFAULT NULL ,
277: description wms_rules_vl.description%TYPE DEFAULT NULL ,
278: qty_function_parameter_id
279: wms_rules_vl.qty_function_parameter_id%TYPE DEFAULT NULL,
280: enabled_flag wms_rules_vl.enabled_flag%TYPE DEFAULT NULL ,
281: user_defined_flag
282: wms_rules_vl.user_defined_flag%TYPE DEFAULT NULL ,
283: attribute_category
276: name wms_rules_vl.name%TYPE DEFAULT NULL ,
277: description wms_rules_vl.description%TYPE DEFAULT NULL ,
278: qty_function_parameter_id
279: wms_rules_vl.qty_function_parameter_id%TYPE DEFAULT NULL,
280: enabled_flag wms_rules_vl.enabled_flag%TYPE DEFAULT NULL ,
281: user_defined_flag
282: wms_rules_vl.user_defined_flag%TYPE DEFAULT NULL ,
283: attribute_category
284: wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
278: qty_function_parameter_id
279: wms_rules_vl.qty_function_parameter_id%TYPE DEFAULT NULL,
280: enabled_flag wms_rules_vl.enabled_flag%TYPE DEFAULT NULL ,
281: user_defined_flag
282: wms_rules_vl.user_defined_flag%TYPE DEFAULT NULL ,
283: attribute_category
284: wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
285: attribute1 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
286: attribute2 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
280: enabled_flag wms_rules_vl.enabled_flag%TYPE DEFAULT NULL ,
281: user_defined_flag
282: wms_rules_vl.user_defined_flag%TYPE DEFAULT NULL ,
283: attribute_category
284: wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
285: attribute1 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
286: attribute2 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
287: attribute3 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
288: attribute4 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
281: user_defined_flag
282: wms_rules_vl.user_defined_flag%TYPE DEFAULT NULL ,
283: attribute_category
284: wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
285: attribute1 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
286: attribute2 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
287: attribute3 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
288: attribute4 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
289: attribute5 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
282: wms_rules_vl.user_defined_flag%TYPE DEFAULT NULL ,
283: attribute_category
284: wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
285: attribute1 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
286: attribute2 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
287: attribute3 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
288: attribute4 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
289: attribute5 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
290: attribute6 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
283: attribute_category
284: wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
285: attribute1 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
286: attribute2 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
287: attribute3 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
288: attribute4 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
289: attribute5 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
290: attribute6 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
291: attribute7 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
284: wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
285: attribute1 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
286: attribute2 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
287: attribute3 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
288: attribute4 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
289: attribute5 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
290: attribute6 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
291: attribute7 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
292: attribute8 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
285: attribute1 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
286: attribute2 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
287: attribute3 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
288: attribute4 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
289: attribute5 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
290: attribute6 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
291: attribute7 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
292: attribute8 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
293: attribute9 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
286: attribute2 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
287: attribute3 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
288: attribute4 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
289: attribute5 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
290: attribute6 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
291: attribute7 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
292: attribute8 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
293: attribute9 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
294: attribute10 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
287: attribute3 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
288: attribute4 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
289: attribute5 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
290: attribute6 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
291: attribute7 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
292: attribute8 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
293: attribute9 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
294: attribute10 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
295: attribute11 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
288: attribute4 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
289: attribute5 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
290: attribute6 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
291: attribute7 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
292: attribute8 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
293: attribute9 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
294: attribute10 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
295: attribute11 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
296: attribute12 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
289: attribute5 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
290: attribute6 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
291: attribute7 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
292: attribute8 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
293: attribute9 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
294: attribute10 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
295: attribute11 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
296: attribute12 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
297: attribute13 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
290: attribute6 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
291: attribute7 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
292: attribute8 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
293: attribute9 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
294: attribute10 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
295: attribute11 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
296: attribute12 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
297: attribute13 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
298: attribute14 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
291: attribute7 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
292: attribute8 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
293: attribute9 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
294: attribute10 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
295: attribute11 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
296: attribute12 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
297: attribute13 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
298: attribute14 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
299: attribute15 wms_rules_vl.attribute_category%TYPE DEFAULT NULL
292: attribute8 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
293: attribute9 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
294: attribute10 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
295: attribute11 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
296: attribute12 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
297: attribute13 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
298: attribute14 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
299: attribute15 wms_rules_vl.attribute_category%TYPE DEFAULT NULL
300: );
293: attribute9 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
294: attribute10 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
295: attribute11 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
296: attribute12 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
297: attribute13 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
298: attribute14 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
299: attribute15 wms_rules_vl.attribute_category%TYPE DEFAULT NULL
300: );
301: --
294: attribute10 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
295: attribute11 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
296: attribute12 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
297: attribute13 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
298: attribute14 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
299: attribute15 wms_rules_vl.attribute_category%TYPE DEFAULT NULL
300: );
301: --
302: -- API name : Find_Rule
295: attribute11 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
296: attribute12 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
297: attribute13 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
298: attribute14 wms_rules_vl.attribute_category%TYPE DEFAULT NULL,
299: attribute15 wms_rules_vl.attribute_category%TYPE DEFAULT NULL
300: );
301: --
302: -- API name : Find_Rule
303: -- Type : Private