DBA Data[Home] [Help]

APPS.WMS_RULE_PVT dependencies on WMS_RULES_VL

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

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 ,

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

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

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,

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

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

Line 279: wms_rules_vl.qty_function_parameter_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
282: wms_rules_vl.user_defined_flag%TYPE DEFAULT NULL ,
283: attribute_category

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 297: attribute13 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: );
301: --

Line 298: attribute14 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: --
302: -- API name : Find_Rule

Line 299: attribute15 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
303: -- Type : Private