1: package ZX_FORMULA_DETAILS_PKG AUTHID CURRENT_USER as
2: /* $Header: zxdformuladtls.pls 120.2 2003/12/19 03:51:28 ssekuri ship $ */
3:
4: TYPE T_FORMULA_ID is TABLE of zx_formula_details.formula_id%type
5: index by binary_integer;
1: package ZX_FORMULA_DETAILS_PKG AUTHID CURRENT_USER as
2: /* $Header: zxdformuladtls.pls 120.2 2003/12/19 03:51:28 ssekuri ship $ */
3:
4: TYPE T_FORMULA_ID is TABLE of zx_formula_details.formula_id%type
5: index by binary_integer;
6: TYPE T_COMPOUNDING_TAX is TABLE of zx_formula_details.compounding_tax%type
7: index by binary_integer;
8: TYPE T_COMPOUNDING_TAX_REGIME_CODE
2: /* $Header: zxdformuladtls.pls 120.2 2003/12/19 03:51:28 ssekuri ship $ */
3:
4: TYPE T_FORMULA_ID is TABLE of zx_formula_details.formula_id%type
5: index by binary_integer;
6: TYPE T_COMPOUNDING_TAX is TABLE of zx_formula_details.compounding_tax%type
7: index by binary_integer;
8: TYPE T_COMPOUNDING_TAX_REGIME_CODE
9: is TABLE of zx_formula_details.compounding_tax_regime_code%type
10: index by binary_integer;
5: index by binary_integer;
6: TYPE T_COMPOUNDING_TAX is TABLE of zx_formula_details.compounding_tax%type
7: index by binary_integer;
8: TYPE T_COMPOUNDING_TAX_REGIME_CODE
9: is TABLE of zx_formula_details.compounding_tax_regime_code%type
10: index by binary_integer;
11: TYPE T_COMPOUNDING_TYPE is TABLE of zx_formula_details.Compounding_Type_Code%type
12: index by binary_integer;
13: TYPE T_RECORD_TYPE is TABLE of zx_formula_details.Record_Type_Code%type
7: index by binary_integer;
8: TYPE T_COMPOUNDING_TAX_REGIME_CODE
9: is TABLE of zx_formula_details.compounding_tax_regime_code%type
10: index by binary_integer;
11: TYPE T_COMPOUNDING_TYPE is TABLE of zx_formula_details.Compounding_Type_Code%type
12: index by binary_integer;
13: TYPE T_RECORD_TYPE is TABLE of zx_formula_details.Record_Type_Code%type
14: index by binary_integer;
15: TYPE T_ATTRIBUTE_CATEGORY is TABLE of zx_formula_details.attribute_category%type
9: is TABLE of zx_formula_details.compounding_tax_regime_code%type
10: index by binary_integer;
11: TYPE T_COMPOUNDING_TYPE is TABLE of zx_formula_details.Compounding_Type_Code%type
12: index by binary_integer;
13: TYPE T_RECORD_TYPE is TABLE of zx_formula_details.Record_Type_Code%type
14: index by binary_integer;
15: TYPE T_ATTRIBUTE_CATEGORY is TABLE of zx_formula_details.attribute_category%type
16: index by binary_integer;
17: TYPE T_ATTRIBUTE1 is TABLE of zx_formula_details.attribute1%type
11: TYPE T_COMPOUNDING_TYPE is TABLE of zx_formula_details.Compounding_Type_Code%type
12: index by binary_integer;
13: TYPE T_RECORD_TYPE is TABLE of zx_formula_details.Record_Type_Code%type
14: index by binary_integer;
15: TYPE T_ATTRIBUTE_CATEGORY is TABLE of zx_formula_details.attribute_category%type
16: index by binary_integer;
17: TYPE T_ATTRIBUTE1 is TABLE of zx_formula_details.attribute1%type
18: index by binary_integer;
19: TYPE T_ATTRIBUTE2 is TABLE of zx_formula_details.attribute2%type
13: TYPE T_RECORD_TYPE is TABLE of zx_formula_details.Record_Type_Code%type
14: index by binary_integer;
15: TYPE T_ATTRIBUTE_CATEGORY is TABLE of zx_formula_details.attribute_category%type
16: index by binary_integer;
17: TYPE T_ATTRIBUTE1 is TABLE of zx_formula_details.attribute1%type
18: index by binary_integer;
19: TYPE T_ATTRIBUTE2 is TABLE of zx_formula_details.attribute2%type
20: index by binary_integer;
21: TYPE T_ATTRIBUTE3 is TABLE of zx_formula_details.attribute3%type
15: TYPE T_ATTRIBUTE_CATEGORY is TABLE of zx_formula_details.attribute_category%type
16: index by binary_integer;
17: TYPE T_ATTRIBUTE1 is TABLE of zx_formula_details.attribute1%type
18: index by binary_integer;
19: TYPE T_ATTRIBUTE2 is TABLE of zx_formula_details.attribute2%type
20: index by binary_integer;
21: TYPE T_ATTRIBUTE3 is TABLE of zx_formula_details.attribute3%type
22: index by binary_integer;
23: TYPE T_ATTRIBUTE4 is TABLE of zx_formula_details.attribute4%type
17: TYPE T_ATTRIBUTE1 is TABLE of zx_formula_details.attribute1%type
18: index by binary_integer;
19: TYPE T_ATTRIBUTE2 is TABLE of zx_formula_details.attribute2%type
20: index by binary_integer;
21: TYPE T_ATTRIBUTE3 is TABLE of zx_formula_details.attribute3%type
22: index by binary_integer;
23: TYPE T_ATTRIBUTE4 is TABLE of zx_formula_details.attribute4%type
24: index by binary_integer;
25: TYPE T_ATTRIBUTE5 is TABLE of zx_formula_details.attribute5%type
19: TYPE T_ATTRIBUTE2 is TABLE of zx_formula_details.attribute2%type
20: index by binary_integer;
21: TYPE T_ATTRIBUTE3 is TABLE of zx_formula_details.attribute3%type
22: index by binary_integer;
23: TYPE T_ATTRIBUTE4 is TABLE of zx_formula_details.attribute4%type
24: index by binary_integer;
25: TYPE T_ATTRIBUTE5 is TABLE of zx_formula_details.attribute5%type
26: index by binary_integer;
27: TYPE T_ATTRIBUTE6 is TABLE of zx_formula_details.attribute6%type
21: TYPE T_ATTRIBUTE3 is TABLE of zx_formula_details.attribute3%type
22: index by binary_integer;
23: TYPE T_ATTRIBUTE4 is TABLE of zx_formula_details.attribute4%type
24: index by binary_integer;
25: TYPE T_ATTRIBUTE5 is TABLE of zx_formula_details.attribute5%type
26: index by binary_integer;
27: TYPE T_ATTRIBUTE6 is TABLE of zx_formula_details.attribute6%type
28: index by binary_integer;
29: TYPE T_ATTRIBUTE7 is TABLE of zx_formula_details.attribute7%type
23: TYPE T_ATTRIBUTE4 is TABLE of zx_formula_details.attribute4%type
24: index by binary_integer;
25: TYPE T_ATTRIBUTE5 is TABLE of zx_formula_details.attribute5%type
26: index by binary_integer;
27: TYPE T_ATTRIBUTE6 is TABLE of zx_formula_details.attribute6%type
28: index by binary_integer;
29: TYPE T_ATTRIBUTE7 is TABLE of zx_formula_details.attribute7%type
30: index by binary_integer;
31: TYPE T_ATTRIBUTE8 is TABLE of zx_formula_details.attribute8%type
25: TYPE T_ATTRIBUTE5 is TABLE of zx_formula_details.attribute5%type
26: index by binary_integer;
27: TYPE T_ATTRIBUTE6 is TABLE of zx_formula_details.attribute6%type
28: index by binary_integer;
29: TYPE T_ATTRIBUTE7 is TABLE of zx_formula_details.attribute7%type
30: index by binary_integer;
31: TYPE T_ATTRIBUTE8 is TABLE of zx_formula_details.attribute8%type
32: index by binary_integer;
33: TYPE T_ATTRIBUTE9 is TABLE of zx_formula_details.attribute9%type
27: TYPE T_ATTRIBUTE6 is TABLE of zx_formula_details.attribute6%type
28: index by binary_integer;
29: TYPE T_ATTRIBUTE7 is TABLE of zx_formula_details.attribute7%type
30: index by binary_integer;
31: TYPE T_ATTRIBUTE8 is TABLE of zx_formula_details.attribute8%type
32: index by binary_integer;
33: TYPE T_ATTRIBUTE9 is TABLE of zx_formula_details.attribute9%type
34: index by binary_integer;
35: TYPE T_ATTRIBUTE10 is TABLE of zx_formula_details.attribute10%type
29: TYPE T_ATTRIBUTE7 is TABLE of zx_formula_details.attribute7%type
30: index by binary_integer;
31: TYPE T_ATTRIBUTE8 is TABLE of zx_formula_details.attribute8%type
32: index by binary_integer;
33: TYPE T_ATTRIBUTE9 is TABLE of zx_formula_details.attribute9%type
34: index by binary_integer;
35: TYPE T_ATTRIBUTE10 is TABLE of zx_formula_details.attribute10%type
36: index by binary_integer;
37: TYPE T_ATTRIBUTE11 is TABLE of zx_formula_details.attribute11%type
31: TYPE T_ATTRIBUTE8 is TABLE of zx_formula_details.attribute8%type
32: index by binary_integer;
33: TYPE T_ATTRIBUTE9 is TABLE of zx_formula_details.attribute9%type
34: index by binary_integer;
35: TYPE T_ATTRIBUTE10 is TABLE of zx_formula_details.attribute10%type
36: index by binary_integer;
37: TYPE T_ATTRIBUTE11 is TABLE of zx_formula_details.attribute11%type
38: index by binary_integer;
39: TYPE T_ATTRIBUTE12 is TABLE of zx_formula_details.attribute12%type
33: TYPE T_ATTRIBUTE9 is TABLE of zx_formula_details.attribute9%type
34: index by binary_integer;
35: TYPE T_ATTRIBUTE10 is TABLE of zx_formula_details.attribute10%type
36: index by binary_integer;
37: TYPE T_ATTRIBUTE11 is TABLE of zx_formula_details.attribute11%type
38: index by binary_integer;
39: TYPE T_ATTRIBUTE12 is TABLE of zx_formula_details.attribute12%type
40: index by binary_integer;
41: TYPE T_ATTRIBUTE13 is TABLE of zx_formula_details.attribute13%type
35: TYPE T_ATTRIBUTE10 is TABLE of zx_formula_details.attribute10%type
36: index by binary_integer;
37: TYPE T_ATTRIBUTE11 is TABLE of zx_formula_details.attribute11%type
38: index by binary_integer;
39: TYPE T_ATTRIBUTE12 is TABLE of zx_formula_details.attribute12%type
40: index by binary_integer;
41: TYPE T_ATTRIBUTE13 is TABLE of zx_formula_details.attribute13%type
42: index by binary_integer;
43: TYPE T_ATTRIBUTE14 is TABLE of zx_formula_details.attribute14%type
37: TYPE T_ATTRIBUTE11 is TABLE of zx_formula_details.attribute11%type
38: index by binary_integer;
39: TYPE T_ATTRIBUTE12 is TABLE of zx_formula_details.attribute12%type
40: index by binary_integer;
41: TYPE T_ATTRIBUTE13 is TABLE of zx_formula_details.attribute13%type
42: index by binary_integer;
43: TYPE T_ATTRIBUTE14 is TABLE of zx_formula_details.attribute14%type
44: index by binary_integer;
45: TYPE T_ATTRIBUTE15 is TABLE of zx_formula_details.attribute15%type
39: TYPE T_ATTRIBUTE12 is TABLE of zx_formula_details.attribute12%type
40: index by binary_integer;
41: TYPE T_ATTRIBUTE13 is TABLE of zx_formula_details.attribute13%type
42: index by binary_integer;
43: TYPE T_ATTRIBUTE14 is TABLE of zx_formula_details.attribute14%type
44: index by binary_integer;
45: TYPE T_ATTRIBUTE15 is TABLE of zx_formula_details.attribute15%type
46: index by binary_integer;
47: TYPE T_ATTRIBUTE16 is TABLE of zx_formula_details.attribute16%type
41: TYPE T_ATTRIBUTE13 is TABLE of zx_formula_details.attribute13%type
42: index by binary_integer;
43: TYPE T_ATTRIBUTE14 is TABLE of zx_formula_details.attribute14%type
44: index by binary_integer;
45: TYPE T_ATTRIBUTE15 is TABLE of zx_formula_details.attribute15%type
46: index by binary_integer;
47: TYPE T_ATTRIBUTE16 is TABLE of zx_formula_details.attribute16%type
48: index by binary_integer;
49: TYPE T_ATTRIBUTE17 is TABLE of zx_formula_details.attribute17%type
43: TYPE T_ATTRIBUTE14 is TABLE of zx_formula_details.attribute14%type
44: index by binary_integer;
45: TYPE T_ATTRIBUTE15 is TABLE of zx_formula_details.attribute15%type
46: index by binary_integer;
47: TYPE T_ATTRIBUTE16 is TABLE of zx_formula_details.attribute16%type
48: index by binary_integer;
49: TYPE T_ATTRIBUTE17 is TABLE of zx_formula_details.attribute17%type
50: index by binary_integer;
51: TYPE T_ATTRIBUTE18 is TABLE of zx_formula_details.attribute18%type
45: TYPE T_ATTRIBUTE15 is TABLE of zx_formula_details.attribute15%type
46: index by binary_integer;
47: TYPE T_ATTRIBUTE16 is TABLE of zx_formula_details.attribute16%type
48: index by binary_integer;
49: TYPE T_ATTRIBUTE17 is TABLE of zx_formula_details.attribute17%type
50: index by binary_integer;
51: TYPE T_ATTRIBUTE18 is TABLE of zx_formula_details.attribute18%type
52: index by binary_integer;
53: TYPE T_ATTRIBUTE19 is TABLE of zx_formula_details.attribute19%type
47: TYPE T_ATTRIBUTE16 is TABLE of zx_formula_details.attribute16%type
48: index by binary_integer;
49: TYPE T_ATTRIBUTE17 is TABLE of zx_formula_details.attribute17%type
50: index by binary_integer;
51: TYPE T_ATTRIBUTE18 is TABLE of zx_formula_details.attribute18%type
52: index by binary_integer;
53: TYPE T_ATTRIBUTE19 is TABLE of zx_formula_details.attribute19%type
54: index by binary_integer;
55: TYPE T_ATTRIBUTE20 is TABLE of zx_formula_details.attribute20%type
49: TYPE T_ATTRIBUTE17 is TABLE of zx_formula_details.attribute17%type
50: index by binary_integer;
51: TYPE T_ATTRIBUTE18 is TABLE of zx_formula_details.attribute18%type
52: index by binary_integer;
53: TYPE T_ATTRIBUTE19 is TABLE of zx_formula_details.attribute19%type
54: index by binary_integer;
55: TYPE T_ATTRIBUTE20 is TABLE of zx_formula_details.attribute20%type
56: index by binary_integer;
57:
51: TYPE T_ATTRIBUTE18 is TABLE of zx_formula_details.attribute18%type
52: index by binary_integer;
53: TYPE T_ATTRIBUTE19 is TABLE of zx_formula_details.attribute19%type
54: index by binary_integer;
55: TYPE T_ATTRIBUTE20 is TABLE of zx_formula_details.attribute20%type
56: index by binary_integer;
57:
58: procedure bulk_insert_formula_details (
59: X_FORMULA_ID IN t_formula_id,
82: X_ATTRIBUTE18 IN t_attribute18,
83: X_ATTRIBUTE19 IN t_attribute19,
84: X_ATTRIBUTE20 IN t_attribute20);
85:
86: end ZX_FORMULA_DETAILS_PKG;