2: /* $Header: GMDPRVRS.pls 120.3.12000000.1 2007/01/16 18:21:33 appldev ship $ */
3:
4:
5: TYPE gmd_val_rules_out IS RECORD
6: ( recipe_validity_rule_id gmd_recipe_validity_rules.recipe_validity_rule_id%type ,
7: recipe_id gmd_recipe_validity_rules.recipe_id%type ,
8: orgn_code gmd_recipe_validity_rules.orgn_code%type ,
9: -- NPD Conv. Added organization_id, revision. Modified item_id to inventory_item_id.
10: organization_id gmd_recipe_validity_rules.organization_id%type ,
3:
4:
5: TYPE gmd_val_rules_out IS RECORD
6: ( recipe_validity_rule_id gmd_recipe_validity_rules.recipe_validity_rule_id%type ,
7: recipe_id gmd_recipe_validity_rules.recipe_id%type ,
8: orgn_code gmd_recipe_validity_rules.orgn_code%type ,
9: -- NPD Conv. Added organization_id, revision. Modified item_id to inventory_item_id.
10: organization_id gmd_recipe_validity_rules.organization_id%type ,
11: revision gmd_recipe_validity_rules.revision%type ,
4:
5: TYPE gmd_val_rules_out IS RECORD
6: ( recipe_validity_rule_id gmd_recipe_validity_rules.recipe_validity_rule_id%type ,
7: recipe_id gmd_recipe_validity_rules.recipe_id%type ,
8: orgn_code gmd_recipe_validity_rules.orgn_code%type ,
9: -- NPD Conv. Added organization_id, revision. Modified item_id to inventory_item_id.
10: organization_id gmd_recipe_validity_rules.organization_id%type ,
11: revision gmd_recipe_validity_rules.revision%type ,
12: inventory_item_id gmd_recipe_validity_rules.inventory_item_id%type ,
6: ( recipe_validity_rule_id gmd_recipe_validity_rules.recipe_validity_rule_id%type ,
7: recipe_id gmd_recipe_validity_rules.recipe_id%type ,
8: orgn_code gmd_recipe_validity_rules.orgn_code%type ,
9: -- NPD Conv. Added organization_id, revision. Modified item_id to inventory_item_id.
10: organization_id gmd_recipe_validity_rules.organization_id%type ,
11: revision gmd_recipe_validity_rules.revision%type ,
12: inventory_item_id gmd_recipe_validity_rules.inventory_item_id%type ,
13: -- End NPD Conv.
14: recipe_use gmd_recipe_validity_rules.recipe_use%type ,
7: recipe_id gmd_recipe_validity_rules.recipe_id%type ,
8: orgn_code gmd_recipe_validity_rules.orgn_code%type ,
9: -- NPD Conv. Added organization_id, revision. Modified item_id to inventory_item_id.
10: organization_id gmd_recipe_validity_rules.organization_id%type ,
11: revision gmd_recipe_validity_rules.revision%type ,
12: inventory_item_id gmd_recipe_validity_rules.inventory_item_id%type ,
13: -- End NPD Conv.
14: recipe_use gmd_recipe_validity_rules.recipe_use%type ,
15: preference gmd_recipe_validity_rules.preference%type ,
8: orgn_code gmd_recipe_validity_rules.orgn_code%type ,
9: -- NPD Conv. Added organization_id, revision. Modified item_id to inventory_item_id.
10: organization_id gmd_recipe_validity_rules.organization_id%type ,
11: revision gmd_recipe_validity_rules.revision%type ,
12: inventory_item_id gmd_recipe_validity_rules.inventory_item_id%type ,
13: -- End NPD Conv.
14: recipe_use gmd_recipe_validity_rules.recipe_use%type ,
15: preference gmd_recipe_validity_rules.preference%type ,
16: start_date gmd_recipe_validity_rules.start_date%type ,
10: organization_id gmd_recipe_validity_rules.organization_id%type ,
11: revision gmd_recipe_validity_rules.revision%type ,
12: inventory_item_id gmd_recipe_validity_rules.inventory_item_id%type ,
13: -- End NPD Conv.
14: recipe_use gmd_recipe_validity_rules.recipe_use%type ,
15: preference gmd_recipe_validity_rules.preference%type ,
16: start_date gmd_recipe_validity_rules.start_date%type ,
17: end_date gmd_recipe_validity_rules.end_date%type ,
18: min_qty gmd_recipe_validity_rules.min_qty%type ,
11: revision gmd_recipe_validity_rules.revision%type ,
12: inventory_item_id gmd_recipe_validity_rules.inventory_item_id%type ,
13: -- End NPD Conv.
14: recipe_use gmd_recipe_validity_rules.recipe_use%type ,
15: preference gmd_recipe_validity_rules.preference%type ,
16: start_date gmd_recipe_validity_rules.start_date%type ,
17: end_date gmd_recipe_validity_rules.end_date%type ,
18: min_qty gmd_recipe_validity_rules.min_qty%type ,
19: max_qty gmd_recipe_validity_rules.max_qty%type ,
12: inventory_item_id gmd_recipe_validity_rules.inventory_item_id%type ,
13: -- End NPD Conv.
14: recipe_use gmd_recipe_validity_rules.recipe_use%type ,
15: preference gmd_recipe_validity_rules.preference%type ,
16: start_date gmd_recipe_validity_rules.start_date%type ,
17: end_date gmd_recipe_validity_rules.end_date%type ,
18: min_qty gmd_recipe_validity_rules.min_qty%type ,
19: max_qty gmd_recipe_validity_rules.max_qty%type ,
20: std_qty gmd_recipe_validity_rules.std_qty%type ,
13: -- End NPD Conv.
14: recipe_use gmd_recipe_validity_rules.recipe_use%type ,
15: preference gmd_recipe_validity_rules.preference%type ,
16: start_date gmd_recipe_validity_rules.start_date%type ,
17: end_date gmd_recipe_validity_rules.end_date%type ,
18: min_qty gmd_recipe_validity_rules.min_qty%type ,
19: max_qty gmd_recipe_validity_rules.max_qty%type ,
20: std_qty gmd_recipe_validity_rules.std_qty%type ,
21: -- NPD Conv. Changed item_um to detail_uom
14: recipe_use gmd_recipe_validity_rules.recipe_use%type ,
15: preference gmd_recipe_validity_rules.preference%type ,
16: start_date gmd_recipe_validity_rules.start_date%type ,
17: end_date gmd_recipe_validity_rules.end_date%type ,
18: min_qty gmd_recipe_validity_rules.min_qty%type ,
19: max_qty gmd_recipe_validity_rules.max_qty%type ,
20: std_qty gmd_recipe_validity_rules.std_qty%type ,
21: -- NPD Conv. Changed item_um to detail_uom
22: detail_uom gmd_recipe_validity_rules.detail_uom%type ,
15: preference gmd_recipe_validity_rules.preference%type ,
16: start_date gmd_recipe_validity_rules.start_date%type ,
17: end_date gmd_recipe_validity_rules.end_date%type ,
18: min_qty gmd_recipe_validity_rules.min_qty%type ,
19: max_qty gmd_recipe_validity_rules.max_qty%type ,
20: std_qty gmd_recipe_validity_rules.std_qty%type ,
21: -- NPD Conv. Changed item_um to detail_uom
22: detail_uom gmd_recipe_validity_rules.detail_uom%type ,
23: -- End NPD Conv.
16: start_date gmd_recipe_validity_rules.start_date%type ,
17: end_date gmd_recipe_validity_rules.end_date%type ,
18: min_qty gmd_recipe_validity_rules.min_qty%type ,
19: max_qty gmd_recipe_validity_rules.max_qty%type ,
20: std_qty gmd_recipe_validity_rules.std_qty%type ,
21: -- NPD Conv. Changed item_um to detail_uom
22: detail_uom gmd_recipe_validity_rules.detail_uom%type ,
23: -- End NPD Conv.
24: inv_min_qty gmd_recipe_validity_rules.inv_min_qty%type ,
18: min_qty gmd_recipe_validity_rules.min_qty%type ,
19: max_qty gmd_recipe_validity_rules.max_qty%type ,
20: std_qty gmd_recipe_validity_rules.std_qty%type ,
21: -- NPD Conv. Changed item_um to detail_uom
22: detail_uom gmd_recipe_validity_rules.detail_uom%type ,
23: -- End NPD Conv.
24: inv_min_qty gmd_recipe_validity_rules.inv_min_qty%type ,
25: inv_max_qty gmd_recipe_validity_rules.inv_max_qty%type ,
26: planned_process_loss gmd_recipe_validity_rules.planned_process_loss%type ,
20: std_qty gmd_recipe_validity_rules.std_qty%type ,
21: -- NPD Conv. Changed item_um to detail_uom
22: detail_uom gmd_recipe_validity_rules.detail_uom%type ,
23: -- End NPD Conv.
24: inv_min_qty gmd_recipe_validity_rules.inv_min_qty%type ,
25: inv_max_qty gmd_recipe_validity_rules.inv_max_qty%type ,
26: planned_process_loss gmd_recipe_validity_rules.planned_process_loss%type ,
27: validity_rule_status gmd_recipe_validity_rules.validity_rule_status%type ,
28: --lab_type gmd_recipe_validity_rules.lab_type%type ,
21: -- NPD Conv. Changed item_um to detail_uom
22: detail_uom gmd_recipe_validity_rules.detail_uom%type ,
23: -- End NPD Conv.
24: inv_min_qty gmd_recipe_validity_rules.inv_min_qty%type ,
25: inv_max_qty gmd_recipe_validity_rules.inv_max_qty%type ,
26: planned_process_loss gmd_recipe_validity_rules.planned_process_loss%type ,
27: validity_rule_status gmd_recipe_validity_rules.validity_rule_status%type ,
28: --lab_type gmd_recipe_validity_rules.lab_type%type ,
29: formula_id NUMBER ,
22: detail_uom gmd_recipe_validity_rules.detail_uom%type ,
23: -- End NPD Conv.
24: inv_min_qty gmd_recipe_validity_rules.inv_min_qty%type ,
25: inv_max_qty gmd_recipe_validity_rules.inv_max_qty%type ,
26: planned_process_loss gmd_recipe_validity_rules.planned_process_loss%type ,
27: validity_rule_status gmd_recipe_validity_rules.validity_rule_status%type ,
28: --lab_type gmd_recipe_validity_rules.lab_type%type ,
29: formula_id NUMBER ,
30: routing_id NUMBER ,
23: -- End NPD Conv.
24: inv_min_qty gmd_recipe_validity_rules.inv_min_qty%type ,
25: inv_max_qty gmd_recipe_validity_rules.inv_max_qty%type ,
26: planned_process_loss gmd_recipe_validity_rules.planned_process_loss%type ,
27: validity_rule_status gmd_recipe_validity_rules.validity_rule_status%type ,
28: --lab_type gmd_recipe_validity_rules.lab_type%type ,
29: formula_id NUMBER ,
30: routing_id NUMBER ,
31: unit_cost NUMBER ,
24: inv_min_qty gmd_recipe_validity_rules.inv_min_qty%type ,
25: inv_max_qty gmd_recipe_validity_rules.inv_max_qty%type ,
26: planned_process_loss gmd_recipe_validity_rules.planned_process_loss%type ,
27: validity_rule_status gmd_recipe_validity_rules.validity_rule_status%type ,
28: --lab_type gmd_recipe_validity_rules.lab_type%type ,
29: formula_id NUMBER ,
30: routing_id NUMBER ,
31: unit_cost NUMBER ,
32: total_cost NUMBER ,
29: formula_id NUMBER ,
30: routing_id NUMBER ,
31: unit_cost NUMBER ,
32: total_cost NUMBER ,
33: text_code gmd_recipe_validity_rules.text_code%type ,
34: created_by gmd_recipe_validity_rules.created_by%type ,
35: last_updated_by gmd_recipe_validity_rules.last_updated_by%type ,
36: last_update_date gmd_recipe_validity_rules.last_update_date%type ,
37: creation_date gmd_recipe_validity_rules.creation_date%type ,
30: routing_id NUMBER ,
31: unit_cost NUMBER ,
32: total_cost NUMBER ,
33: text_code gmd_recipe_validity_rules.text_code%type ,
34: created_by gmd_recipe_validity_rules.created_by%type ,
35: last_updated_by gmd_recipe_validity_rules.last_updated_by%type ,
36: last_update_date gmd_recipe_validity_rules.last_update_date%type ,
37: creation_date gmd_recipe_validity_rules.creation_date%type ,
38: last_update_login gmd_recipe_validity_rules.last_update_login%type ,
31: unit_cost NUMBER ,
32: total_cost NUMBER ,
33: text_code gmd_recipe_validity_rules.text_code%type ,
34: created_by gmd_recipe_validity_rules.created_by%type ,
35: last_updated_by gmd_recipe_validity_rules.last_updated_by%type ,
36: last_update_date gmd_recipe_validity_rules.last_update_date%type ,
37: creation_date gmd_recipe_validity_rules.creation_date%type ,
38: last_update_login gmd_recipe_validity_rules.last_update_login%type ,
39: attribute_category gmd_recipe_validity_rules.attribute_category%type ,
32: total_cost NUMBER ,
33: text_code gmd_recipe_validity_rules.text_code%type ,
34: created_by gmd_recipe_validity_rules.created_by%type ,
35: last_updated_by gmd_recipe_validity_rules.last_updated_by%type ,
36: last_update_date gmd_recipe_validity_rules.last_update_date%type ,
37: creation_date gmd_recipe_validity_rules.creation_date%type ,
38: last_update_login gmd_recipe_validity_rules.last_update_login%type ,
39: attribute_category gmd_recipe_validity_rules.attribute_category%type ,
40: attribute1 gmd_recipe_validity_rules.attribute1%type ,
33: text_code gmd_recipe_validity_rules.text_code%type ,
34: created_by gmd_recipe_validity_rules.created_by%type ,
35: last_updated_by gmd_recipe_validity_rules.last_updated_by%type ,
36: last_update_date gmd_recipe_validity_rules.last_update_date%type ,
37: creation_date gmd_recipe_validity_rules.creation_date%type ,
38: last_update_login gmd_recipe_validity_rules.last_update_login%type ,
39: attribute_category gmd_recipe_validity_rules.attribute_category%type ,
40: attribute1 gmd_recipe_validity_rules.attribute1%type ,
41: attribute2 gmd_recipe_validity_rules.attribute2%type ,
34: created_by gmd_recipe_validity_rules.created_by%type ,
35: last_updated_by gmd_recipe_validity_rules.last_updated_by%type ,
36: last_update_date gmd_recipe_validity_rules.last_update_date%type ,
37: creation_date gmd_recipe_validity_rules.creation_date%type ,
38: last_update_login gmd_recipe_validity_rules.last_update_login%type ,
39: attribute_category gmd_recipe_validity_rules.attribute_category%type ,
40: attribute1 gmd_recipe_validity_rules.attribute1%type ,
41: attribute2 gmd_recipe_validity_rules.attribute2%type ,
42: attribute3 gmd_recipe_validity_rules.attribute3%type ,
35: last_updated_by gmd_recipe_validity_rules.last_updated_by%type ,
36: last_update_date gmd_recipe_validity_rules.last_update_date%type ,
37: creation_date gmd_recipe_validity_rules.creation_date%type ,
38: last_update_login gmd_recipe_validity_rules.last_update_login%type ,
39: attribute_category gmd_recipe_validity_rules.attribute_category%type ,
40: attribute1 gmd_recipe_validity_rules.attribute1%type ,
41: attribute2 gmd_recipe_validity_rules.attribute2%type ,
42: attribute3 gmd_recipe_validity_rules.attribute3%type ,
43: attribute4 gmd_recipe_validity_rules.attribute4%type ,
36: last_update_date gmd_recipe_validity_rules.last_update_date%type ,
37: creation_date gmd_recipe_validity_rules.creation_date%type ,
38: last_update_login gmd_recipe_validity_rules.last_update_login%type ,
39: attribute_category gmd_recipe_validity_rules.attribute_category%type ,
40: attribute1 gmd_recipe_validity_rules.attribute1%type ,
41: attribute2 gmd_recipe_validity_rules.attribute2%type ,
42: attribute3 gmd_recipe_validity_rules.attribute3%type ,
43: attribute4 gmd_recipe_validity_rules.attribute4%type ,
44: attribute5 gmd_recipe_validity_rules.attribute5%type ,
37: creation_date gmd_recipe_validity_rules.creation_date%type ,
38: last_update_login gmd_recipe_validity_rules.last_update_login%type ,
39: attribute_category gmd_recipe_validity_rules.attribute_category%type ,
40: attribute1 gmd_recipe_validity_rules.attribute1%type ,
41: attribute2 gmd_recipe_validity_rules.attribute2%type ,
42: attribute3 gmd_recipe_validity_rules.attribute3%type ,
43: attribute4 gmd_recipe_validity_rules.attribute4%type ,
44: attribute5 gmd_recipe_validity_rules.attribute5%type ,
45: attribute6 gmd_recipe_validity_rules.attribute6%type ,
38: last_update_login gmd_recipe_validity_rules.last_update_login%type ,
39: attribute_category gmd_recipe_validity_rules.attribute_category%type ,
40: attribute1 gmd_recipe_validity_rules.attribute1%type ,
41: attribute2 gmd_recipe_validity_rules.attribute2%type ,
42: attribute3 gmd_recipe_validity_rules.attribute3%type ,
43: attribute4 gmd_recipe_validity_rules.attribute4%type ,
44: attribute5 gmd_recipe_validity_rules.attribute5%type ,
45: attribute6 gmd_recipe_validity_rules.attribute6%type ,
46: attribute7 gmd_recipe_validity_rules.attribute7%type ,
39: attribute_category gmd_recipe_validity_rules.attribute_category%type ,
40: attribute1 gmd_recipe_validity_rules.attribute1%type ,
41: attribute2 gmd_recipe_validity_rules.attribute2%type ,
42: attribute3 gmd_recipe_validity_rules.attribute3%type ,
43: attribute4 gmd_recipe_validity_rules.attribute4%type ,
44: attribute5 gmd_recipe_validity_rules.attribute5%type ,
45: attribute6 gmd_recipe_validity_rules.attribute6%type ,
46: attribute7 gmd_recipe_validity_rules.attribute7%type ,
47: attribute8 gmd_recipe_validity_rules.attribute8%type ,
40: attribute1 gmd_recipe_validity_rules.attribute1%type ,
41: attribute2 gmd_recipe_validity_rules.attribute2%type ,
42: attribute3 gmd_recipe_validity_rules.attribute3%type ,
43: attribute4 gmd_recipe_validity_rules.attribute4%type ,
44: attribute5 gmd_recipe_validity_rules.attribute5%type ,
45: attribute6 gmd_recipe_validity_rules.attribute6%type ,
46: attribute7 gmd_recipe_validity_rules.attribute7%type ,
47: attribute8 gmd_recipe_validity_rules.attribute8%type ,
48: attribute9 gmd_recipe_validity_rules.attribute9%type ,
41: attribute2 gmd_recipe_validity_rules.attribute2%type ,
42: attribute3 gmd_recipe_validity_rules.attribute3%type ,
43: attribute4 gmd_recipe_validity_rules.attribute4%type ,
44: attribute5 gmd_recipe_validity_rules.attribute5%type ,
45: attribute6 gmd_recipe_validity_rules.attribute6%type ,
46: attribute7 gmd_recipe_validity_rules.attribute7%type ,
47: attribute8 gmd_recipe_validity_rules.attribute8%type ,
48: attribute9 gmd_recipe_validity_rules.attribute9%type ,
49: attribute10 gmd_recipe_validity_rules.attribute10%type ,
42: attribute3 gmd_recipe_validity_rules.attribute3%type ,
43: attribute4 gmd_recipe_validity_rules.attribute4%type ,
44: attribute5 gmd_recipe_validity_rules.attribute5%type ,
45: attribute6 gmd_recipe_validity_rules.attribute6%type ,
46: attribute7 gmd_recipe_validity_rules.attribute7%type ,
47: attribute8 gmd_recipe_validity_rules.attribute8%type ,
48: attribute9 gmd_recipe_validity_rules.attribute9%type ,
49: attribute10 gmd_recipe_validity_rules.attribute10%type ,
50: attribute11 gmd_recipe_validity_rules.attribute11%type ,
43: attribute4 gmd_recipe_validity_rules.attribute4%type ,
44: attribute5 gmd_recipe_validity_rules.attribute5%type ,
45: attribute6 gmd_recipe_validity_rules.attribute6%type ,
46: attribute7 gmd_recipe_validity_rules.attribute7%type ,
47: attribute8 gmd_recipe_validity_rules.attribute8%type ,
48: attribute9 gmd_recipe_validity_rules.attribute9%type ,
49: attribute10 gmd_recipe_validity_rules.attribute10%type ,
50: attribute11 gmd_recipe_validity_rules.attribute11%type ,
51: attribute12 gmd_recipe_validity_rules.attribute12%type ,
44: attribute5 gmd_recipe_validity_rules.attribute5%type ,
45: attribute6 gmd_recipe_validity_rules.attribute6%type ,
46: attribute7 gmd_recipe_validity_rules.attribute7%type ,
47: attribute8 gmd_recipe_validity_rules.attribute8%type ,
48: attribute9 gmd_recipe_validity_rules.attribute9%type ,
49: attribute10 gmd_recipe_validity_rules.attribute10%type ,
50: attribute11 gmd_recipe_validity_rules.attribute11%type ,
51: attribute12 gmd_recipe_validity_rules.attribute12%type ,
52: attribute13 gmd_recipe_validity_rules.attribute13%type ,
45: attribute6 gmd_recipe_validity_rules.attribute6%type ,
46: attribute7 gmd_recipe_validity_rules.attribute7%type ,
47: attribute8 gmd_recipe_validity_rules.attribute8%type ,
48: attribute9 gmd_recipe_validity_rules.attribute9%type ,
49: attribute10 gmd_recipe_validity_rules.attribute10%type ,
50: attribute11 gmd_recipe_validity_rules.attribute11%type ,
51: attribute12 gmd_recipe_validity_rules.attribute12%type ,
52: attribute13 gmd_recipe_validity_rules.attribute13%type ,
53: attribute14 gmd_recipe_validity_rules.attribute14%type ,
46: attribute7 gmd_recipe_validity_rules.attribute7%type ,
47: attribute8 gmd_recipe_validity_rules.attribute8%type ,
48: attribute9 gmd_recipe_validity_rules.attribute9%type ,
49: attribute10 gmd_recipe_validity_rules.attribute10%type ,
50: attribute11 gmd_recipe_validity_rules.attribute11%type ,
51: attribute12 gmd_recipe_validity_rules.attribute12%type ,
52: attribute13 gmd_recipe_validity_rules.attribute13%type ,
53: attribute14 gmd_recipe_validity_rules.attribute14%type ,
54: attribute15 gmd_recipe_validity_rules.attribute15%type ,
47: attribute8 gmd_recipe_validity_rules.attribute8%type ,
48: attribute9 gmd_recipe_validity_rules.attribute9%type ,
49: attribute10 gmd_recipe_validity_rules.attribute10%type ,
50: attribute11 gmd_recipe_validity_rules.attribute11%type ,
51: attribute12 gmd_recipe_validity_rules.attribute12%type ,
52: attribute13 gmd_recipe_validity_rules.attribute13%type ,
53: attribute14 gmd_recipe_validity_rules.attribute14%type ,
54: attribute15 gmd_recipe_validity_rules.attribute15%type ,
55: attribute16 gmd_recipe_validity_rules.attribute16%type ,
48: attribute9 gmd_recipe_validity_rules.attribute9%type ,
49: attribute10 gmd_recipe_validity_rules.attribute10%type ,
50: attribute11 gmd_recipe_validity_rules.attribute11%type ,
51: attribute12 gmd_recipe_validity_rules.attribute12%type ,
52: attribute13 gmd_recipe_validity_rules.attribute13%type ,
53: attribute14 gmd_recipe_validity_rules.attribute14%type ,
54: attribute15 gmd_recipe_validity_rules.attribute15%type ,
55: attribute16 gmd_recipe_validity_rules.attribute16%type ,
56: attribute17 gmd_recipe_validity_rules.attribute17%type ,
49: attribute10 gmd_recipe_validity_rules.attribute10%type ,
50: attribute11 gmd_recipe_validity_rules.attribute11%type ,
51: attribute12 gmd_recipe_validity_rules.attribute12%type ,
52: attribute13 gmd_recipe_validity_rules.attribute13%type ,
53: attribute14 gmd_recipe_validity_rules.attribute14%type ,
54: attribute15 gmd_recipe_validity_rules.attribute15%type ,
55: attribute16 gmd_recipe_validity_rules.attribute16%type ,
56: attribute17 gmd_recipe_validity_rules.attribute17%type ,
57: attribute18 gmd_recipe_validity_rules.attribute18%type ,
50: attribute11 gmd_recipe_validity_rules.attribute11%type ,
51: attribute12 gmd_recipe_validity_rules.attribute12%type ,
52: attribute13 gmd_recipe_validity_rules.attribute13%type ,
53: attribute14 gmd_recipe_validity_rules.attribute14%type ,
54: attribute15 gmd_recipe_validity_rules.attribute15%type ,
55: attribute16 gmd_recipe_validity_rules.attribute16%type ,
56: attribute17 gmd_recipe_validity_rules.attribute17%type ,
57: attribute18 gmd_recipe_validity_rules.attribute18%type ,
58: attribute19 gmd_recipe_validity_rules.attribute19%type ,
51: attribute12 gmd_recipe_validity_rules.attribute12%type ,
52: attribute13 gmd_recipe_validity_rules.attribute13%type ,
53: attribute14 gmd_recipe_validity_rules.attribute14%type ,
54: attribute15 gmd_recipe_validity_rules.attribute15%type ,
55: attribute16 gmd_recipe_validity_rules.attribute16%type ,
56: attribute17 gmd_recipe_validity_rules.attribute17%type ,
57: attribute18 gmd_recipe_validity_rules.attribute18%type ,
58: attribute19 gmd_recipe_validity_rules.attribute19%type ,
59: attribute20 gmd_recipe_validity_rules.attribute20%type ,
52: attribute13 gmd_recipe_validity_rules.attribute13%type ,
53: attribute14 gmd_recipe_validity_rules.attribute14%type ,
54: attribute15 gmd_recipe_validity_rules.attribute15%type ,
55: attribute16 gmd_recipe_validity_rules.attribute16%type ,
56: attribute17 gmd_recipe_validity_rules.attribute17%type ,
57: attribute18 gmd_recipe_validity_rules.attribute18%type ,
58: attribute19 gmd_recipe_validity_rules.attribute19%type ,
59: attribute20 gmd_recipe_validity_rules.attribute20%type ,
60: attribute21 gmd_recipe_validity_rules.attribute21%type ,
53: attribute14 gmd_recipe_validity_rules.attribute14%type ,
54: attribute15 gmd_recipe_validity_rules.attribute15%type ,
55: attribute16 gmd_recipe_validity_rules.attribute16%type ,
56: attribute17 gmd_recipe_validity_rules.attribute17%type ,
57: attribute18 gmd_recipe_validity_rules.attribute18%type ,
58: attribute19 gmd_recipe_validity_rules.attribute19%type ,
59: attribute20 gmd_recipe_validity_rules.attribute20%type ,
60: attribute21 gmd_recipe_validity_rules.attribute21%type ,
61: attribute22 gmd_recipe_validity_rules.attribute22%type ,
54: attribute15 gmd_recipe_validity_rules.attribute15%type ,
55: attribute16 gmd_recipe_validity_rules.attribute16%type ,
56: attribute17 gmd_recipe_validity_rules.attribute17%type ,
57: attribute18 gmd_recipe_validity_rules.attribute18%type ,
58: attribute19 gmd_recipe_validity_rules.attribute19%type ,
59: attribute20 gmd_recipe_validity_rules.attribute20%type ,
60: attribute21 gmd_recipe_validity_rules.attribute21%type ,
61: attribute22 gmd_recipe_validity_rules.attribute22%type ,
62: attribute23 gmd_recipe_validity_rules.attribute23%type ,
55: attribute16 gmd_recipe_validity_rules.attribute16%type ,
56: attribute17 gmd_recipe_validity_rules.attribute17%type ,
57: attribute18 gmd_recipe_validity_rules.attribute18%type ,
58: attribute19 gmd_recipe_validity_rules.attribute19%type ,
59: attribute20 gmd_recipe_validity_rules.attribute20%type ,
60: attribute21 gmd_recipe_validity_rules.attribute21%type ,
61: attribute22 gmd_recipe_validity_rules.attribute22%type ,
62: attribute23 gmd_recipe_validity_rules.attribute23%type ,
63: attribute24 gmd_recipe_validity_rules.attribute24%type ,
56: attribute17 gmd_recipe_validity_rules.attribute17%type ,
57: attribute18 gmd_recipe_validity_rules.attribute18%type ,
58: attribute19 gmd_recipe_validity_rules.attribute19%type ,
59: attribute20 gmd_recipe_validity_rules.attribute20%type ,
60: attribute21 gmd_recipe_validity_rules.attribute21%type ,
61: attribute22 gmd_recipe_validity_rules.attribute22%type ,
62: attribute23 gmd_recipe_validity_rules.attribute23%type ,
63: attribute24 gmd_recipe_validity_rules.attribute24%type ,
64: attribute25 gmd_recipe_validity_rules.attribute25%type ,
57: attribute18 gmd_recipe_validity_rules.attribute18%type ,
58: attribute19 gmd_recipe_validity_rules.attribute19%type ,
59: attribute20 gmd_recipe_validity_rules.attribute20%type ,
60: attribute21 gmd_recipe_validity_rules.attribute21%type ,
61: attribute22 gmd_recipe_validity_rules.attribute22%type ,
62: attribute23 gmd_recipe_validity_rules.attribute23%type ,
63: attribute24 gmd_recipe_validity_rules.attribute24%type ,
64: attribute25 gmd_recipe_validity_rules.attribute25%type ,
65: attribute26 gmd_recipe_validity_rules.attribute26%type ,
58: attribute19 gmd_recipe_validity_rules.attribute19%type ,
59: attribute20 gmd_recipe_validity_rules.attribute20%type ,
60: attribute21 gmd_recipe_validity_rules.attribute21%type ,
61: attribute22 gmd_recipe_validity_rules.attribute22%type ,
62: attribute23 gmd_recipe_validity_rules.attribute23%type ,
63: attribute24 gmd_recipe_validity_rules.attribute24%type ,
64: attribute25 gmd_recipe_validity_rules.attribute25%type ,
65: attribute26 gmd_recipe_validity_rules.attribute26%type ,
66: attribute27 gmd_recipe_validity_rules.attribute27%type ,
59: attribute20 gmd_recipe_validity_rules.attribute20%type ,
60: attribute21 gmd_recipe_validity_rules.attribute21%type ,
61: attribute22 gmd_recipe_validity_rules.attribute22%type ,
62: attribute23 gmd_recipe_validity_rules.attribute23%type ,
63: attribute24 gmd_recipe_validity_rules.attribute24%type ,
64: attribute25 gmd_recipe_validity_rules.attribute25%type ,
65: attribute26 gmd_recipe_validity_rules.attribute26%type ,
66: attribute27 gmd_recipe_validity_rules.attribute27%type ,
67: attribute28 gmd_recipe_validity_rules.attribute28%type ,
60: attribute21 gmd_recipe_validity_rules.attribute21%type ,
61: attribute22 gmd_recipe_validity_rules.attribute22%type ,
62: attribute23 gmd_recipe_validity_rules.attribute23%type ,
63: attribute24 gmd_recipe_validity_rules.attribute24%type ,
64: attribute25 gmd_recipe_validity_rules.attribute25%type ,
65: attribute26 gmd_recipe_validity_rules.attribute26%type ,
66: attribute27 gmd_recipe_validity_rules.attribute27%type ,
67: attribute28 gmd_recipe_validity_rules.attribute28%type ,
68: attribute29 gmd_recipe_validity_rules.attribute29%type ,
61: attribute22 gmd_recipe_validity_rules.attribute22%type ,
62: attribute23 gmd_recipe_validity_rules.attribute23%type ,
63: attribute24 gmd_recipe_validity_rules.attribute24%type ,
64: attribute25 gmd_recipe_validity_rules.attribute25%type ,
65: attribute26 gmd_recipe_validity_rules.attribute26%type ,
66: attribute27 gmd_recipe_validity_rules.attribute27%type ,
67: attribute28 gmd_recipe_validity_rules.attribute28%type ,
68: attribute29 gmd_recipe_validity_rules.attribute29%type ,
69: attribute30 gmd_recipe_validity_rules.attribute30%type
62: attribute23 gmd_recipe_validity_rules.attribute23%type ,
63: attribute24 gmd_recipe_validity_rules.attribute24%type ,
64: attribute25 gmd_recipe_validity_rules.attribute25%type ,
65: attribute26 gmd_recipe_validity_rules.attribute26%type ,
66: attribute27 gmd_recipe_validity_rules.attribute27%type ,
67: attribute28 gmd_recipe_validity_rules.attribute28%type ,
68: attribute29 gmd_recipe_validity_rules.attribute29%type ,
69: attribute30 gmd_recipe_validity_rules.attribute30%type
70:
63: attribute24 gmd_recipe_validity_rules.attribute24%type ,
64: attribute25 gmd_recipe_validity_rules.attribute25%type ,
65: attribute26 gmd_recipe_validity_rules.attribute26%type ,
66: attribute27 gmd_recipe_validity_rules.attribute27%type ,
67: attribute28 gmd_recipe_validity_rules.attribute28%type ,
68: attribute29 gmd_recipe_validity_rules.attribute29%type ,
69: attribute30 gmd_recipe_validity_rules.attribute30%type
70:
71: );
64: attribute25 gmd_recipe_validity_rules.attribute25%type ,
65: attribute26 gmd_recipe_validity_rules.attribute26%type ,
66: attribute27 gmd_recipe_validity_rules.attribute27%type ,
67: attribute28 gmd_recipe_validity_rules.attribute28%type ,
68: attribute29 gmd_recipe_validity_rules.attribute29%type ,
69: attribute30 gmd_recipe_validity_rules.attribute30%type
70:
71: );
72:
65: attribute26 gmd_recipe_validity_rules.attribute26%type ,
66: attribute27 gmd_recipe_validity_rules.attribute27%type ,
67: attribute28 gmd_recipe_validity_rules.attribute28%type ,
68: attribute29 gmd_recipe_validity_rules.attribute29%type ,
69: attribute30 gmd_recipe_validity_rules.attribute30%type
70:
71: );
72:
73: -- Record for finding Least Cost VR
72:
73: -- Record for finding Least Cost VR
74: TYPE least_cost_rec IS RECORD
75: (
76: recipe_validity_rule_id gmd_recipe_validity_rules.recipe_validity_rule_id%TYPE,
77: unit_cost NUMBER,
78: total_cost NUMBER,
79: index_no NUMBER);
80:
175: p_std_um IN VARCHAR2 ,
176: x_scale_factor OUT NOCOPY NUMBER,
177: x_return_status OUT NOCOPY VARCHAR2);
178:
179: PROCEDURE insert_val_temp_tbl (p_val_rec IN GMD_RECIPE_VALIDITY_RULES%ROWTYPE
180: ,p_unit_cost IN NUMBER
181: ,p_total_cost IN NUMBER);
182:
183: PROCEDURE Get_Formula_Cost (