APPS.GMD_VALIDITY_RULES dependencies on GMD_RECIPE_VALIDITY_RULES

Line 6: ( recipe_validity_rule_id gmd_recipe_validity_rules.recipe_validity_rule_id%type ,

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 ,

Line 7: recipe_id gmd_recipe_validity_rules.recipe_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 ,

Line 8: orgn_code gmd_recipe_validity_rules.orgn_code%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 ,

Line 10: organization_id gmd_recipe_validity_rules.organization_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 ,

Line 11: revision gmd_recipe_validity_rules.revision%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 ,

Line 12: inventory_item_id gmd_recipe_validity_rules.inventory_item_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 ,
16: start_date gmd_recipe_validity_rules.start_date%type ,

Line 14: recipe_use gmd_recipe_validity_rules.recipe_use%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 ,

Line 15: preference gmd_recipe_validity_rules.preference%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 ,

Line 16: start_date gmd_recipe_validity_rules.start_date%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 ,

Line 17: end_date gmd_recipe_validity_rules.end_date%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

Line 18: min_qty gmd_recipe_validity_rules.min_qty%type ,

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 ,

Line 19: max_qty gmd_recipe_validity_rules.max_qty%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.

Line 20: std_qty gmd_recipe_validity_rules.std_qty%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.
24: inv_min_qty gmd_recipe_validity_rules.inv_min_qty%type ,

Line 22: detail_uom gmd_recipe_validity_rules.detail_uom%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 ,

Line 24: inv_min_qty gmd_recipe_validity_rules.inv_min_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 ,
27: validity_rule_status gmd_recipe_validity_rules.validity_rule_status%type ,
28: --lab_type gmd_recipe_validity_rules.lab_type%type ,

Line 25: inv_max_qty gmd_recipe_validity_rules.inv_max_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 ,
29: formula_id NUMBER ,

Line 26: planned_process_loss gmd_recipe_validity_rules.planned_process_loss%type ,

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 ,

Line 27: validity_rule_status gmd_recipe_validity_rules.validity_rule_status%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 ,
31: unit_cost NUMBER ,

Line 28: --lab_type gmd_recipe_validity_rules.lab_type%type ,

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 ,

Line 33: text_code gmd_recipe_validity_rules.text_code%type ,

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 ,

Line 34: created_by gmd_recipe_validity_rules.created_by%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 ,

Line 35: last_updated_by gmd_recipe_validity_rules.last_updated_by%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 ,

Line 36: last_update_date gmd_recipe_validity_rules.last_update_date%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 ,

Line 37: creation_date gmd_recipe_validity_rules.creation_date%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 ,

Line 38: last_update_login gmd_recipe_validity_rules.last_update_login%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 ,

Line 39: attribute_category gmd_recipe_validity_rules.attribute_category%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 ,

Line 40: attribute1 gmd_recipe_validity_rules.attribute1%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 ,

Line 41: attribute2 gmd_recipe_validity_rules.attribute2%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 ,

Line 42: attribute3 gmd_recipe_validity_rules.attribute3%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 ,

Line 43: attribute4 gmd_recipe_validity_rules.attribute4%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 ,

Line 44: attribute5 gmd_recipe_validity_rules.attribute5%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 ,

Line 45: attribute6 gmd_recipe_validity_rules.attribute6%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 ,

Line 46: attribute7 gmd_recipe_validity_rules.attribute7%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 ,

Line 47: attribute8 gmd_recipe_validity_rules.attribute8%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 ,

Line 48: attribute9 gmd_recipe_validity_rules.attribute9%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 ,

Line 49: attribute10 gmd_recipe_validity_rules.attribute10%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 ,

Line 50: attribute11 gmd_recipe_validity_rules.attribute11%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 ,

Line 51: attribute12 gmd_recipe_validity_rules.attribute12%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 ,

Line 52: attribute13 gmd_recipe_validity_rules.attribute13%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 ,

Line 53: attribute14 gmd_recipe_validity_rules.attribute14%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 ,

Line 54: attribute15 gmd_recipe_validity_rules.attribute15%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 ,

Line 55: attribute16 gmd_recipe_validity_rules.attribute16%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 ,

Line 56: attribute17 gmd_recipe_validity_rules.attribute17%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 ,

Line 57: attribute18 gmd_recipe_validity_rules.attribute18%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 ,

Line 58: attribute19 gmd_recipe_validity_rules.attribute19%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 ,

Line 59: attribute20 gmd_recipe_validity_rules.attribute20%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 ,

Line 60: attribute21 gmd_recipe_validity_rules.attribute21%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 ,

Line 61: attribute22 gmd_recipe_validity_rules.attribute22%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 ,

Line 62: attribute23 gmd_recipe_validity_rules.attribute23%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 ,

Line 63: attribute24 gmd_recipe_validity_rules.attribute24%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 ,

Line 64: attribute25 gmd_recipe_validity_rules.attribute25%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 ,

Line 65: attribute26 gmd_recipe_validity_rules.attribute26%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

Line 66: attribute27 gmd_recipe_validity_rules.attribute27%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:

Line 67: attribute28 gmd_recipe_validity_rules.attribute28%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:
71: );

Line 68: attribute29 gmd_recipe_validity_rules.attribute29%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: );
72:

Line 69: attribute30 gmd_recipe_validity_rules.attribute30%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:
73: -- Record for finding Least Cost VR

Line 76: recipe_validity_rule_id gmd_recipe_validity_rules.recipe_validity_rule_id%TYPE,

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:

Line 179: PROCEDURE insert_val_temp_tbl (p_val_rec IN GMD_RECIPE_VALIDITY_RULES%ROWTYPE

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 (