1 package ZX_FORMULA_DETAILS_PKG 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
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
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
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
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
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
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
58 procedure bulk_insert_formula_details (
59 X_FORMULA_ID IN t_formula_id,
60 X_COMPOUNDING_TAX IN t_compounding_tax,
61 X_COMPOUNDING_TAX_REGIME_CODE IN t_compounding_tax_regime_code,
62 X_Compounding_Type_Code IN t_compounding_type,
63 X_Record_Type_Code IN t_record_type,
64 X_ATTRIBUTE_CATEGORY IN t_attribute_category,
65 X_ATTRIBUTE1 IN t_attribute1,
66 X_ATTRIBUTE2 IN t_attribute2,
67 X_ATTRIBUTE3 IN t_attribute3,
68 X_ATTRIBUTE4 IN t_attribute4,
69 X_ATTRIBUTE5 IN t_attribute5,
70 X_ATTRIBUTE6 IN t_attribute6,
71 X_ATTRIBUTE7 IN t_attribute7,
72 X_ATTRIBUTE8 IN t_attribute8,
73 X_ATTRIBUTE9 IN t_attribute9,
74 X_ATTRIBUTE10 IN t_attribute10,
75 X_ATTRIBUTE11 IN t_attribute11,
76 X_ATTRIBUTE12 IN t_attribute12,
77 X_ATTRIBUTE13 IN t_attribute13,
78 X_ATTRIBUTE14 IN t_attribute14,
79 X_ATTRIBUTE15 IN t_attribute15,
80 X_ATTRIBUTE16 IN t_attribute16,
81 X_ATTRIBUTE17 IN t_attribute17,
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;