15: TYPE update_tbl_type IS TABLE OF update_table_rec_type INDEX BY BINARY_INTEGER;
16:
17: TYPE gmd_substitution_hdr_rec_type IS RECORD
18: (
19: SUBSTITUTION_NAME gmd_item_substitution_hdr_b.substitution_name%TYPE
20: , SUBSTITUTION_DESCRIPTION gmd_item_substitution_hdr_tl.substitution_description%TYPE
21: , SUBSTITUTION_VERSION gmd_item_substitution_hdr_b.substitution_version%TYPE
22: , ORIGINAL_INVENTORY_ITEM_ID gmd_item_substitution_hdr_b.original_inventory_item_id%TYPE
23: , ORIGINAL_ITEM_NO VARCHAR2(1000)
17: TYPE gmd_substitution_hdr_rec_type IS RECORD
18: (
19: SUBSTITUTION_NAME gmd_item_substitution_hdr_b.substitution_name%TYPE
20: , SUBSTITUTION_DESCRIPTION gmd_item_substitution_hdr_tl.substitution_description%TYPE
21: , SUBSTITUTION_VERSION gmd_item_substitution_hdr_b.substitution_version%TYPE
22: , ORIGINAL_INVENTORY_ITEM_ID gmd_item_substitution_hdr_b.original_inventory_item_id%TYPE
23: , ORIGINAL_ITEM_NO VARCHAR2(1000)
24: , ORIGINAL_QTY gmd_item_substitution_hdr_b.original_qty%TYPE
25: , PREFERENCE gmd_item_substitution_hdr_b.preference%TYPE
18: (
19: SUBSTITUTION_NAME gmd_item_substitution_hdr_b.substitution_name%TYPE
20: , SUBSTITUTION_DESCRIPTION gmd_item_substitution_hdr_tl.substitution_description%TYPE
21: , SUBSTITUTION_VERSION gmd_item_substitution_hdr_b.substitution_version%TYPE
22: , ORIGINAL_INVENTORY_ITEM_ID gmd_item_substitution_hdr_b.original_inventory_item_id%TYPE
23: , ORIGINAL_ITEM_NO VARCHAR2(1000)
24: , ORIGINAL_QTY gmd_item_substitution_hdr_b.original_qty%TYPE
25: , PREFERENCE gmd_item_substitution_hdr_b.preference%TYPE
26: , START_DATE DATE := trunc(SYSDATE)
20: , SUBSTITUTION_DESCRIPTION gmd_item_substitution_hdr_tl.substitution_description%TYPE
21: , SUBSTITUTION_VERSION gmd_item_substitution_hdr_b.substitution_version%TYPE
22: , ORIGINAL_INVENTORY_ITEM_ID gmd_item_substitution_hdr_b.original_inventory_item_id%TYPE
23: , ORIGINAL_ITEM_NO VARCHAR2(1000)
24: , ORIGINAL_QTY gmd_item_substitution_hdr_b.original_qty%TYPE
25: , PREFERENCE gmd_item_substitution_hdr_b.preference%TYPE
26: , START_DATE DATE := trunc(SYSDATE)
27: , END_DATE DATE
28: , OWNER_ORGANIZATION_ID gmd_item_substitution_hdr_b.owner_organization_id%TYPE
21: , SUBSTITUTION_VERSION gmd_item_substitution_hdr_b.substitution_version%TYPE
22: , ORIGINAL_INVENTORY_ITEM_ID gmd_item_substitution_hdr_b.original_inventory_item_id%TYPE
23: , ORIGINAL_ITEM_NO VARCHAR2(1000)
24: , ORIGINAL_QTY gmd_item_substitution_hdr_b.original_qty%TYPE
25: , PREFERENCE gmd_item_substitution_hdr_b.preference%TYPE
26: , START_DATE DATE := trunc(SYSDATE)
27: , END_DATE DATE
28: , OWNER_ORGANIZATION_ID gmd_item_substitution_hdr_b.owner_organization_id%TYPE
29: , REPLACEMENT_UOM_TYPE gmd_item_substitution_hdr_b.replacement_uom_type%TYPE
24: , ORIGINAL_QTY gmd_item_substitution_hdr_b.original_qty%TYPE
25: , PREFERENCE gmd_item_substitution_hdr_b.preference%TYPE
26: , START_DATE DATE := trunc(SYSDATE)
27: , END_DATE DATE
28: , OWNER_ORGANIZATION_ID gmd_item_substitution_hdr_b.owner_organization_id%TYPE
29: , REPLACEMENT_UOM_TYPE gmd_item_substitution_hdr_b.replacement_uom_type%TYPE
30: , ATTRIBUTE_CATEGORY gmd_item_substitution_hdr_b.attribute_category%TYPE
31: , ATTRIBUTE1 gmd_item_substitution_hdr_b.attribute1%TYPE
32: , ATTRIBUTE2 gmd_item_substitution_hdr_b.attribute2%TYPE
25: , PREFERENCE gmd_item_substitution_hdr_b.preference%TYPE
26: , START_DATE DATE := trunc(SYSDATE)
27: , END_DATE DATE
28: , OWNER_ORGANIZATION_ID gmd_item_substitution_hdr_b.owner_organization_id%TYPE
29: , REPLACEMENT_UOM_TYPE gmd_item_substitution_hdr_b.replacement_uom_type%TYPE
30: , ATTRIBUTE_CATEGORY gmd_item_substitution_hdr_b.attribute_category%TYPE
31: , ATTRIBUTE1 gmd_item_substitution_hdr_b.attribute1%TYPE
32: , ATTRIBUTE2 gmd_item_substitution_hdr_b.attribute2%TYPE
33: , ATTRIBUTE3 gmd_item_substitution_hdr_b.attribute3%TYPE
26: , START_DATE DATE := trunc(SYSDATE)
27: , END_DATE DATE
28: , OWNER_ORGANIZATION_ID gmd_item_substitution_hdr_b.owner_organization_id%TYPE
29: , REPLACEMENT_UOM_TYPE gmd_item_substitution_hdr_b.replacement_uom_type%TYPE
30: , ATTRIBUTE_CATEGORY gmd_item_substitution_hdr_b.attribute_category%TYPE
31: , ATTRIBUTE1 gmd_item_substitution_hdr_b.attribute1%TYPE
32: , ATTRIBUTE2 gmd_item_substitution_hdr_b.attribute2%TYPE
33: , ATTRIBUTE3 gmd_item_substitution_hdr_b.attribute3%TYPE
34: , ATTRIBUTE4 gmd_item_substitution_hdr_b.attribute4%TYPE
27: , END_DATE DATE
28: , OWNER_ORGANIZATION_ID gmd_item_substitution_hdr_b.owner_organization_id%TYPE
29: , REPLACEMENT_UOM_TYPE gmd_item_substitution_hdr_b.replacement_uom_type%TYPE
30: , ATTRIBUTE_CATEGORY gmd_item_substitution_hdr_b.attribute_category%TYPE
31: , ATTRIBUTE1 gmd_item_substitution_hdr_b.attribute1%TYPE
32: , ATTRIBUTE2 gmd_item_substitution_hdr_b.attribute2%TYPE
33: , ATTRIBUTE3 gmd_item_substitution_hdr_b.attribute3%TYPE
34: , ATTRIBUTE4 gmd_item_substitution_hdr_b.attribute4%TYPE
35: , ATTRIBUTE5 gmd_item_substitution_hdr_b.attribute5%TYPE
28: , OWNER_ORGANIZATION_ID gmd_item_substitution_hdr_b.owner_organization_id%TYPE
29: , REPLACEMENT_UOM_TYPE gmd_item_substitution_hdr_b.replacement_uom_type%TYPE
30: , ATTRIBUTE_CATEGORY gmd_item_substitution_hdr_b.attribute_category%TYPE
31: , ATTRIBUTE1 gmd_item_substitution_hdr_b.attribute1%TYPE
32: , ATTRIBUTE2 gmd_item_substitution_hdr_b.attribute2%TYPE
33: , ATTRIBUTE3 gmd_item_substitution_hdr_b.attribute3%TYPE
34: , ATTRIBUTE4 gmd_item_substitution_hdr_b.attribute4%TYPE
35: , ATTRIBUTE5 gmd_item_substitution_hdr_b.attribute5%TYPE
36: , ATTRIBUTE6 gmd_item_substitution_hdr_b.attribute6%TYPE
29: , REPLACEMENT_UOM_TYPE gmd_item_substitution_hdr_b.replacement_uom_type%TYPE
30: , ATTRIBUTE_CATEGORY gmd_item_substitution_hdr_b.attribute_category%TYPE
31: , ATTRIBUTE1 gmd_item_substitution_hdr_b.attribute1%TYPE
32: , ATTRIBUTE2 gmd_item_substitution_hdr_b.attribute2%TYPE
33: , ATTRIBUTE3 gmd_item_substitution_hdr_b.attribute3%TYPE
34: , ATTRIBUTE4 gmd_item_substitution_hdr_b.attribute4%TYPE
35: , ATTRIBUTE5 gmd_item_substitution_hdr_b.attribute5%TYPE
36: , ATTRIBUTE6 gmd_item_substitution_hdr_b.attribute6%TYPE
37: , ATTRIBUTE7 gmd_item_substitution_hdr_b.attribute7%TYPE
30: , ATTRIBUTE_CATEGORY gmd_item_substitution_hdr_b.attribute_category%TYPE
31: , ATTRIBUTE1 gmd_item_substitution_hdr_b.attribute1%TYPE
32: , ATTRIBUTE2 gmd_item_substitution_hdr_b.attribute2%TYPE
33: , ATTRIBUTE3 gmd_item_substitution_hdr_b.attribute3%TYPE
34: , ATTRIBUTE4 gmd_item_substitution_hdr_b.attribute4%TYPE
35: , ATTRIBUTE5 gmd_item_substitution_hdr_b.attribute5%TYPE
36: , ATTRIBUTE6 gmd_item_substitution_hdr_b.attribute6%TYPE
37: , ATTRIBUTE7 gmd_item_substitution_hdr_b.attribute7%TYPE
38: , ATTRIBUTE8 gmd_item_substitution_hdr_b.attribute8%TYPE
31: , ATTRIBUTE1 gmd_item_substitution_hdr_b.attribute1%TYPE
32: , ATTRIBUTE2 gmd_item_substitution_hdr_b.attribute2%TYPE
33: , ATTRIBUTE3 gmd_item_substitution_hdr_b.attribute3%TYPE
34: , ATTRIBUTE4 gmd_item_substitution_hdr_b.attribute4%TYPE
35: , ATTRIBUTE5 gmd_item_substitution_hdr_b.attribute5%TYPE
36: , ATTRIBUTE6 gmd_item_substitution_hdr_b.attribute6%TYPE
37: , ATTRIBUTE7 gmd_item_substitution_hdr_b.attribute7%TYPE
38: , ATTRIBUTE8 gmd_item_substitution_hdr_b.attribute8%TYPE
39: , ATTRIBUTE9 gmd_item_substitution_hdr_b.attribute9%TYPE
32: , ATTRIBUTE2 gmd_item_substitution_hdr_b.attribute2%TYPE
33: , ATTRIBUTE3 gmd_item_substitution_hdr_b.attribute3%TYPE
34: , ATTRIBUTE4 gmd_item_substitution_hdr_b.attribute4%TYPE
35: , ATTRIBUTE5 gmd_item_substitution_hdr_b.attribute5%TYPE
36: , ATTRIBUTE6 gmd_item_substitution_hdr_b.attribute6%TYPE
37: , ATTRIBUTE7 gmd_item_substitution_hdr_b.attribute7%TYPE
38: , ATTRIBUTE8 gmd_item_substitution_hdr_b.attribute8%TYPE
39: , ATTRIBUTE9 gmd_item_substitution_hdr_b.attribute9%TYPE
40: , ATTRIBUTE10 gmd_item_substitution_hdr_b.attribute10%TYPE
33: , ATTRIBUTE3 gmd_item_substitution_hdr_b.attribute3%TYPE
34: , ATTRIBUTE4 gmd_item_substitution_hdr_b.attribute4%TYPE
35: , ATTRIBUTE5 gmd_item_substitution_hdr_b.attribute5%TYPE
36: , ATTRIBUTE6 gmd_item_substitution_hdr_b.attribute6%TYPE
37: , ATTRIBUTE7 gmd_item_substitution_hdr_b.attribute7%TYPE
38: , ATTRIBUTE8 gmd_item_substitution_hdr_b.attribute8%TYPE
39: , ATTRIBUTE9 gmd_item_substitution_hdr_b.attribute9%TYPE
40: , ATTRIBUTE10 gmd_item_substitution_hdr_b.attribute10%TYPE
41: , ATTRIBUTE11 gmd_item_substitution_hdr_b.attribute11%TYPE
34: , ATTRIBUTE4 gmd_item_substitution_hdr_b.attribute4%TYPE
35: , ATTRIBUTE5 gmd_item_substitution_hdr_b.attribute5%TYPE
36: , ATTRIBUTE6 gmd_item_substitution_hdr_b.attribute6%TYPE
37: , ATTRIBUTE7 gmd_item_substitution_hdr_b.attribute7%TYPE
38: , ATTRIBUTE8 gmd_item_substitution_hdr_b.attribute8%TYPE
39: , ATTRIBUTE9 gmd_item_substitution_hdr_b.attribute9%TYPE
40: , ATTRIBUTE10 gmd_item_substitution_hdr_b.attribute10%TYPE
41: , ATTRIBUTE11 gmd_item_substitution_hdr_b.attribute11%TYPE
42: , ATTRIBUTE12 gmd_item_substitution_hdr_b.attribute12%TYPE
35: , ATTRIBUTE5 gmd_item_substitution_hdr_b.attribute5%TYPE
36: , ATTRIBUTE6 gmd_item_substitution_hdr_b.attribute6%TYPE
37: , ATTRIBUTE7 gmd_item_substitution_hdr_b.attribute7%TYPE
38: , ATTRIBUTE8 gmd_item_substitution_hdr_b.attribute8%TYPE
39: , ATTRIBUTE9 gmd_item_substitution_hdr_b.attribute9%TYPE
40: , ATTRIBUTE10 gmd_item_substitution_hdr_b.attribute10%TYPE
41: , ATTRIBUTE11 gmd_item_substitution_hdr_b.attribute11%TYPE
42: , ATTRIBUTE12 gmd_item_substitution_hdr_b.attribute12%TYPE
43: , ATTRIBUTE13 gmd_item_substitution_hdr_b.attribute13%TYPE
36: , ATTRIBUTE6 gmd_item_substitution_hdr_b.attribute6%TYPE
37: , ATTRIBUTE7 gmd_item_substitution_hdr_b.attribute7%TYPE
38: , ATTRIBUTE8 gmd_item_substitution_hdr_b.attribute8%TYPE
39: , ATTRIBUTE9 gmd_item_substitution_hdr_b.attribute9%TYPE
40: , ATTRIBUTE10 gmd_item_substitution_hdr_b.attribute10%TYPE
41: , ATTRIBUTE11 gmd_item_substitution_hdr_b.attribute11%TYPE
42: , ATTRIBUTE12 gmd_item_substitution_hdr_b.attribute12%TYPE
43: , ATTRIBUTE13 gmd_item_substitution_hdr_b.attribute13%TYPE
44: , ATTRIBUTE14 gmd_item_substitution_hdr_b.attribute14%TYPE
37: , ATTRIBUTE7 gmd_item_substitution_hdr_b.attribute7%TYPE
38: , ATTRIBUTE8 gmd_item_substitution_hdr_b.attribute8%TYPE
39: , ATTRIBUTE9 gmd_item_substitution_hdr_b.attribute9%TYPE
40: , ATTRIBUTE10 gmd_item_substitution_hdr_b.attribute10%TYPE
41: , ATTRIBUTE11 gmd_item_substitution_hdr_b.attribute11%TYPE
42: , ATTRIBUTE12 gmd_item_substitution_hdr_b.attribute12%TYPE
43: , ATTRIBUTE13 gmd_item_substitution_hdr_b.attribute13%TYPE
44: , ATTRIBUTE14 gmd_item_substitution_hdr_b.attribute14%TYPE
45: , ATTRIBUTE15 gmd_item_substitution_hdr_b.attribute15%TYPE
38: , ATTRIBUTE8 gmd_item_substitution_hdr_b.attribute8%TYPE
39: , ATTRIBUTE9 gmd_item_substitution_hdr_b.attribute9%TYPE
40: , ATTRIBUTE10 gmd_item_substitution_hdr_b.attribute10%TYPE
41: , ATTRIBUTE11 gmd_item_substitution_hdr_b.attribute11%TYPE
42: , ATTRIBUTE12 gmd_item_substitution_hdr_b.attribute12%TYPE
43: , ATTRIBUTE13 gmd_item_substitution_hdr_b.attribute13%TYPE
44: , ATTRIBUTE14 gmd_item_substitution_hdr_b.attribute14%TYPE
45: , ATTRIBUTE15 gmd_item_substitution_hdr_b.attribute15%TYPE
46: , ATTRIBUTE16 gmd_item_substitution_hdr_b.attribute16%TYPE
39: , ATTRIBUTE9 gmd_item_substitution_hdr_b.attribute9%TYPE
40: , ATTRIBUTE10 gmd_item_substitution_hdr_b.attribute10%TYPE
41: , ATTRIBUTE11 gmd_item_substitution_hdr_b.attribute11%TYPE
42: , ATTRIBUTE12 gmd_item_substitution_hdr_b.attribute12%TYPE
43: , ATTRIBUTE13 gmd_item_substitution_hdr_b.attribute13%TYPE
44: , ATTRIBUTE14 gmd_item_substitution_hdr_b.attribute14%TYPE
45: , ATTRIBUTE15 gmd_item_substitution_hdr_b.attribute15%TYPE
46: , ATTRIBUTE16 gmd_item_substitution_hdr_b.attribute16%TYPE
47: , ATTRIBUTE17 gmd_item_substitution_hdr_b.attribute17%TYPE
40: , ATTRIBUTE10 gmd_item_substitution_hdr_b.attribute10%TYPE
41: , ATTRIBUTE11 gmd_item_substitution_hdr_b.attribute11%TYPE
42: , ATTRIBUTE12 gmd_item_substitution_hdr_b.attribute12%TYPE
43: , ATTRIBUTE13 gmd_item_substitution_hdr_b.attribute13%TYPE
44: , ATTRIBUTE14 gmd_item_substitution_hdr_b.attribute14%TYPE
45: , ATTRIBUTE15 gmd_item_substitution_hdr_b.attribute15%TYPE
46: , ATTRIBUTE16 gmd_item_substitution_hdr_b.attribute16%TYPE
47: , ATTRIBUTE17 gmd_item_substitution_hdr_b.attribute17%TYPE
48: , ATTRIBUTE18 gmd_item_substitution_hdr_b.attribute18%TYPE
41: , ATTRIBUTE11 gmd_item_substitution_hdr_b.attribute11%TYPE
42: , ATTRIBUTE12 gmd_item_substitution_hdr_b.attribute12%TYPE
43: , ATTRIBUTE13 gmd_item_substitution_hdr_b.attribute13%TYPE
44: , ATTRIBUTE14 gmd_item_substitution_hdr_b.attribute14%TYPE
45: , ATTRIBUTE15 gmd_item_substitution_hdr_b.attribute15%TYPE
46: , ATTRIBUTE16 gmd_item_substitution_hdr_b.attribute16%TYPE
47: , ATTRIBUTE17 gmd_item_substitution_hdr_b.attribute17%TYPE
48: , ATTRIBUTE18 gmd_item_substitution_hdr_b.attribute18%TYPE
49: , ATTRIBUTE19 gmd_item_substitution_hdr_b.attribute19%TYPE
42: , ATTRIBUTE12 gmd_item_substitution_hdr_b.attribute12%TYPE
43: , ATTRIBUTE13 gmd_item_substitution_hdr_b.attribute13%TYPE
44: , ATTRIBUTE14 gmd_item_substitution_hdr_b.attribute14%TYPE
45: , ATTRIBUTE15 gmd_item_substitution_hdr_b.attribute15%TYPE
46: , ATTRIBUTE16 gmd_item_substitution_hdr_b.attribute16%TYPE
47: , ATTRIBUTE17 gmd_item_substitution_hdr_b.attribute17%TYPE
48: , ATTRIBUTE18 gmd_item_substitution_hdr_b.attribute18%TYPE
49: , ATTRIBUTE19 gmd_item_substitution_hdr_b.attribute19%TYPE
50: , ATTRIBUTE20 gmd_item_substitution_hdr_b.attribute20%TYPE
43: , ATTRIBUTE13 gmd_item_substitution_hdr_b.attribute13%TYPE
44: , ATTRIBUTE14 gmd_item_substitution_hdr_b.attribute14%TYPE
45: , ATTRIBUTE15 gmd_item_substitution_hdr_b.attribute15%TYPE
46: , ATTRIBUTE16 gmd_item_substitution_hdr_b.attribute16%TYPE
47: , ATTRIBUTE17 gmd_item_substitution_hdr_b.attribute17%TYPE
48: , ATTRIBUTE18 gmd_item_substitution_hdr_b.attribute18%TYPE
49: , ATTRIBUTE19 gmd_item_substitution_hdr_b.attribute19%TYPE
50: , ATTRIBUTE20 gmd_item_substitution_hdr_b.attribute20%TYPE
51: , ATTRIBUTE21 gmd_item_substitution_hdr_b.attribute21%TYPE
44: , ATTRIBUTE14 gmd_item_substitution_hdr_b.attribute14%TYPE
45: , ATTRIBUTE15 gmd_item_substitution_hdr_b.attribute15%TYPE
46: , ATTRIBUTE16 gmd_item_substitution_hdr_b.attribute16%TYPE
47: , ATTRIBUTE17 gmd_item_substitution_hdr_b.attribute17%TYPE
48: , ATTRIBUTE18 gmd_item_substitution_hdr_b.attribute18%TYPE
49: , ATTRIBUTE19 gmd_item_substitution_hdr_b.attribute19%TYPE
50: , ATTRIBUTE20 gmd_item_substitution_hdr_b.attribute20%TYPE
51: , ATTRIBUTE21 gmd_item_substitution_hdr_b.attribute21%TYPE
52: , ATTRIBUTE22 gmd_item_substitution_hdr_b.attribute22%TYPE
45: , ATTRIBUTE15 gmd_item_substitution_hdr_b.attribute15%TYPE
46: , ATTRIBUTE16 gmd_item_substitution_hdr_b.attribute16%TYPE
47: , ATTRIBUTE17 gmd_item_substitution_hdr_b.attribute17%TYPE
48: , ATTRIBUTE18 gmd_item_substitution_hdr_b.attribute18%TYPE
49: , ATTRIBUTE19 gmd_item_substitution_hdr_b.attribute19%TYPE
50: , ATTRIBUTE20 gmd_item_substitution_hdr_b.attribute20%TYPE
51: , ATTRIBUTE21 gmd_item_substitution_hdr_b.attribute21%TYPE
52: , ATTRIBUTE22 gmd_item_substitution_hdr_b.attribute22%TYPE
53: , ATTRIBUTE23 gmd_item_substitution_hdr_b.attribute23%TYPE
46: , ATTRIBUTE16 gmd_item_substitution_hdr_b.attribute16%TYPE
47: , ATTRIBUTE17 gmd_item_substitution_hdr_b.attribute17%TYPE
48: , ATTRIBUTE18 gmd_item_substitution_hdr_b.attribute18%TYPE
49: , ATTRIBUTE19 gmd_item_substitution_hdr_b.attribute19%TYPE
50: , ATTRIBUTE20 gmd_item_substitution_hdr_b.attribute20%TYPE
51: , ATTRIBUTE21 gmd_item_substitution_hdr_b.attribute21%TYPE
52: , ATTRIBUTE22 gmd_item_substitution_hdr_b.attribute22%TYPE
53: , ATTRIBUTE23 gmd_item_substitution_hdr_b.attribute23%TYPE
54: , ATTRIBUTE24 gmd_item_substitution_hdr_b.attribute24%TYPE
47: , ATTRIBUTE17 gmd_item_substitution_hdr_b.attribute17%TYPE
48: , ATTRIBUTE18 gmd_item_substitution_hdr_b.attribute18%TYPE
49: , ATTRIBUTE19 gmd_item_substitution_hdr_b.attribute19%TYPE
50: , ATTRIBUTE20 gmd_item_substitution_hdr_b.attribute20%TYPE
51: , ATTRIBUTE21 gmd_item_substitution_hdr_b.attribute21%TYPE
52: , ATTRIBUTE22 gmd_item_substitution_hdr_b.attribute22%TYPE
53: , ATTRIBUTE23 gmd_item_substitution_hdr_b.attribute23%TYPE
54: , ATTRIBUTE24 gmd_item_substitution_hdr_b.attribute24%TYPE
55: , ATTRIBUTE25 gmd_item_substitution_hdr_b.attribute25%TYPE
48: , ATTRIBUTE18 gmd_item_substitution_hdr_b.attribute18%TYPE
49: , ATTRIBUTE19 gmd_item_substitution_hdr_b.attribute19%TYPE
50: , ATTRIBUTE20 gmd_item_substitution_hdr_b.attribute20%TYPE
51: , ATTRIBUTE21 gmd_item_substitution_hdr_b.attribute21%TYPE
52: , ATTRIBUTE22 gmd_item_substitution_hdr_b.attribute22%TYPE
53: , ATTRIBUTE23 gmd_item_substitution_hdr_b.attribute23%TYPE
54: , ATTRIBUTE24 gmd_item_substitution_hdr_b.attribute24%TYPE
55: , ATTRIBUTE25 gmd_item_substitution_hdr_b.attribute25%TYPE
56: , ATTRIBUTE26 gmd_item_substitution_hdr_b.attribute26%TYPE
49: , ATTRIBUTE19 gmd_item_substitution_hdr_b.attribute19%TYPE
50: , ATTRIBUTE20 gmd_item_substitution_hdr_b.attribute20%TYPE
51: , ATTRIBUTE21 gmd_item_substitution_hdr_b.attribute21%TYPE
52: , ATTRIBUTE22 gmd_item_substitution_hdr_b.attribute22%TYPE
53: , ATTRIBUTE23 gmd_item_substitution_hdr_b.attribute23%TYPE
54: , ATTRIBUTE24 gmd_item_substitution_hdr_b.attribute24%TYPE
55: , ATTRIBUTE25 gmd_item_substitution_hdr_b.attribute25%TYPE
56: , ATTRIBUTE26 gmd_item_substitution_hdr_b.attribute26%TYPE
57: , ATTRIBUTE27 gmd_item_substitution_hdr_b.attribute27%TYPE
50: , ATTRIBUTE20 gmd_item_substitution_hdr_b.attribute20%TYPE
51: , ATTRIBUTE21 gmd_item_substitution_hdr_b.attribute21%TYPE
52: , ATTRIBUTE22 gmd_item_substitution_hdr_b.attribute22%TYPE
53: , ATTRIBUTE23 gmd_item_substitution_hdr_b.attribute23%TYPE
54: , ATTRIBUTE24 gmd_item_substitution_hdr_b.attribute24%TYPE
55: , ATTRIBUTE25 gmd_item_substitution_hdr_b.attribute25%TYPE
56: , ATTRIBUTE26 gmd_item_substitution_hdr_b.attribute26%TYPE
57: , ATTRIBUTE27 gmd_item_substitution_hdr_b.attribute27%TYPE
58: , ATTRIBUTE28 gmd_item_substitution_hdr_b.attribute28%TYPE
51: , ATTRIBUTE21 gmd_item_substitution_hdr_b.attribute21%TYPE
52: , ATTRIBUTE22 gmd_item_substitution_hdr_b.attribute22%TYPE
53: , ATTRIBUTE23 gmd_item_substitution_hdr_b.attribute23%TYPE
54: , ATTRIBUTE24 gmd_item_substitution_hdr_b.attribute24%TYPE
55: , ATTRIBUTE25 gmd_item_substitution_hdr_b.attribute25%TYPE
56: , ATTRIBUTE26 gmd_item_substitution_hdr_b.attribute26%TYPE
57: , ATTRIBUTE27 gmd_item_substitution_hdr_b.attribute27%TYPE
58: , ATTRIBUTE28 gmd_item_substitution_hdr_b.attribute28%TYPE
59: , ATTRIBUTE29 gmd_item_substitution_hdr_b.attribute29%TYPE
52: , ATTRIBUTE22 gmd_item_substitution_hdr_b.attribute22%TYPE
53: , ATTRIBUTE23 gmd_item_substitution_hdr_b.attribute23%TYPE
54: , ATTRIBUTE24 gmd_item_substitution_hdr_b.attribute24%TYPE
55: , ATTRIBUTE25 gmd_item_substitution_hdr_b.attribute25%TYPE
56: , ATTRIBUTE26 gmd_item_substitution_hdr_b.attribute26%TYPE
57: , ATTRIBUTE27 gmd_item_substitution_hdr_b.attribute27%TYPE
58: , ATTRIBUTE28 gmd_item_substitution_hdr_b.attribute28%TYPE
59: , ATTRIBUTE29 gmd_item_substitution_hdr_b.attribute29%TYPE
60: , ATTRIBUTE30 gmd_item_substitution_hdr_b.attribute30%TYPE
53: , ATTRIBUTE23 gmd_item_substitution_hdr_b.attribute23%TYPE
54: , ATTRIBUTE24 gmd_item_substitution_hdr_b.attribute24%TYPE
55: , ATTRIBUTE25 gmd_item_substitution_hdr_b.attribute25%TYPE
56: , ATTRIBUTE26 gmd_item_substitution_hdr_b.attribute26%TYPE
57: , ATTRIBUTE27 gmd_item_substitution_hdr_b.attribute27%TYPE
58: , ATTRIBUTE28 gmd_item_substitution_hdr_b.attribute28%TYPE
59: , ATTRIBUTE29 gmd_item_substitution_hdr_b.attribute29%TYPE
60: , ATTRIBUTE30 gmd_item_substitution_hdr_b.attribute30%TYPE
61: , CREATION_DATE gmd_item_substitution_hdr_b.creation_date%TYPE
54: , ATTRIBUTE24 gmd_item_substitution_hdr_b.attribute24%TYPE
55: , ATTRIBUTE25 gmd_item_substitution_hdr_b.attribute25%TYPE
56: , ATTRIBUTE26 gmd_item_substitution_hdr_b.attribute26%TYPE
57: , ATTRIBUTE27 gmd_item_substitution_hdr_b.attribute27%TYPE
58: , ATTRIBUTE28 gmd_item_substitution_hdr_b.attribute28%TYPE
59: , ATTRIBUTE29 gmd_item_substitution_hdr_b.attribute29%TYPE
60: , ATTRIBUTE30 gmd_item_substitution_hdr_b.attribute30%TYPE
61: , CREATION_DATE gmd_item_substitution_hdr_b.creation_date%TYPE
62: , CREATED_BY gmd_item_substitution_hdr_b.created_by%TYPE
55: , ATTRIBUTE25 gmd_item_substitution_hdr_b.attribute25%TYPE
56: , ATTRIBUTE26 gmd_item_substitution_hdr_b.attribute26%TYPE
57: , ATTRIBUTE27 gmd_item_substitution_hdr_b.attribute27%TYPE
58: , ATTRIBUTE28 gmd_item_substitution_hdr_b.attribute28%TYPE
59: , ATTRIBUTE29 gmd_item_substitution_hdr_b.attribute29%TYPE
60: , ATTRIBUTE30 gmd_item_substitution_hdr_b.attribute30%TYPE
61: , CREATION_DATE gmd_item_substitution_hdr_b.creation_date%TYPE
62: , CREATED_BY gmd_item_substitution_hdr_b.created_by%TYPE
63: , LAST_UPDATE_DATE gmd_item_substitution_hdr_b.last_update_date%TYPE
56: , ATTRIBUTE26 gmd_item_substitution_hdr_b.attribute26%TYPE
57: , ATTRIBUTE27 gmd_item_substitution_hdr_b.attribute27%TYPE
58: , ATTRIBUTE28 gmd_item_substitution_hdr_b.attribute28%TYPE
59: , ATTRIBUTE29 gmd_item_substitution_hdr_b.attribute29%TYPE
60: , ATTRIBUTE30 gmd_item_substitution_hdr_b.attribute30%TYPE
61: , CREATION_DATE gmd_item_substitution_hdr_b.creation_date%TYPE
62: , CREATED_BY gmd_item_substitution_hdr_b.created_by%TYPE
63: , LAST_UPDATE_DATE gmd_item_substitution_hdr_b.last_update_date%TYPE
64: , LAST_UPDATED_BY gmd_item_substitution_hdr_b.last_updated_by%TYPE
57: , ATTRIBUTE27 gmd_item_substitution_hdr_b.attribute27%TYPE
58: , ATTRIBUTE28 gmd_item_substitution_hdr_b.attribute28%TYPE
59: , ATTRIBUTE29 gmd_item_substitution_hdr_b.attribute29%TYPE
60: , ATTRIBUTE30 gmd_item_substitution_hdr_b.attribute30%TYPE
61: , CREATION_DATE gmd_item_substitution_hdr_b.creation_date%TYPE
62: , CREATED_BY gmd_item_substitution_hdr_b.created_by%TYPE
63: , LAST_UPDATE_DATE gmd_item_substitution_hdr_b.last_update_date%TYPE
64: , LAST_UPDATED_BY gmd_item_substitution_hdr_b.last_updated_by%TYPE
65: , LAST_UPDATE_LOGIN gmd_item_substitution_hdr_b.last_update_login%TYPE
58: , ATTRIBUTE28 gmd_item_substitution_hdr_b.attribute28%TYPE
59: , ATTRIBUTE29 gmd_item_substitution_hdr_b.attribute29%TYPE
60: , ATTRIBUTE30 gmd_item_substitution_hdr_b.attribute30%TYPE
61: , CREATION_DATE gmd_item_substitution_hdr_b.creation_date%TYPE
62: , CREATED_BY gmd_item_substitution_hdr_b.created_by%TYPE
63: , LAST_UPDATE_DATE gmd_item_substitution_hdr_b.last_update_date%TYPE
64: , LAST_UPDATED_BY gmd_item_substitution_hdr_b.last_updated_by%TYPE
65: , LAST_UPDATE_LOGIN gmd_item_substitution_hdr_b.last_update_login%TYPE
66: );
59: , ATTRIBUTE29 gmd_item_substitution_hdr_b.attribute29%TYPE
60: , ATTRIBUTE30 gmd_item_substitution_hdr_b.attribute30%TYPE
61: , CREATION_DATE gmd_item_substitution_hdr_b.creation_date%TYPE
62: , CREATED_BY gmd_item_substitution_hdr_b.created_by%TYPE
63: , LAST_UPDATE_DATE gmd_item_substitution_hdr_b.last_update_date%TYPE
64: , LAST_UPDATED_BY gmd_item_substitution_hdr_b.last_updated_by%TYPE
65: , LAST_UPDATE_LOGIN gmd_item_substitution_hdr_b.last_update_login%TYPE
66: );
67:
60: , ATTRIBUTE30 gmd_item_substitution_hdr_b.attribute30%TYPE
61: , CREATION_DATE gmd_item_substitution_hdr_b.creation_date%TYPE
62: , CREATED_BY gmd_item_substitution_hdr_b.created_by%TYPE
63: , LAST_UPDATE_DATE gmd_item_substitution_hdr_b.last_update_date%TYPE
64: , LAST_UPDATED_BY gmd_item_substitution_hdr_b.last_updated_by%TYPE
65: , LAST_UPDATE_LOGIN gmd_item_substitution_hdr_b.last_update_login%TYPE
66: );
67:
68: TYPE gmd_substitution_dtl_rec_type IS RECORD
61: , CREATION_DATE gmd_item_substitution_hdr_b.creation_date%TYPE
62: , CREATED_BY gmd_item_substitution_hdr_b.created_by%TYPE
63: , LAST_UPDATE_DATE gmd_item_substitution_hdr_b.last_update_date%TYPE
64: , LAST_UPDATED_BY gmd_item_substitution_hdr_b.last_updated_by%TYPE
65: , LAST_UPDATE_LOGIN gmd_item_substitution_hdr_b.last_update_login%TYPE
66: );
67:
68: TYPE gmd_substitution_dtl_rec_type IS RECORD
69: (