DBA Data[Home] [Help]

APPS.WMS_RULE_PVT dependencies on WMS_RULES_VL

Line 264: (rule_id wms_rules_vl.rule_id%TYPE DEFAULT NULL ,

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 ,

Line 265: organization_id wms_rules_vl.organization_id%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

Line 266: type_code wms_rules_vl.type_code%TYPE DEFAULT NULL ,

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,

Line 267: name wms_rules_vl.name%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 ,

Line 268: description wms_rules_vl.description%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

Line 270: wms_rules_vl.qty_function_parameter_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
273: wms_rules_vl.user_defined_flag%TYPE DEFAULT NULL ,
274: attribute_category

Line 271: enabled_flag wms_rules_vl.enabled_flag%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
275: wms_rules_vl.attribute_category%TYPE DEFAULT NULL,

Line 273: wms_rules_vl.user_defined_flag%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,

Line 275: 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,

Line 276: attribute1 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,

Line 277: attribute2 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,

Line 278: attribute3 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,

Line 279: attribute4 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,

Line 280: attribute5 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,

Line 281: attribute6 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,

Line 282: attribute7 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,

Line 283: attribute8 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,

Line 284: attribute9 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,

Line 285: attribute10 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,

Line 286: attribute11 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

Line 287: attribute12 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: );

Line 288: attribute13 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: );
292: --

Line 289: attribute14 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: --
293: -- API name : Find_Rule

Line 290: attribute15 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
294: -- Type : Private