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