DBA Data[Home] [Help]

APPS.ZX_FORMULA_DETAILS_PKG dependencies on ZX_FORMULA_DETAILS

Line 1: package ZX_FORMULA_DETAILS_PKG AUTHID CURRENT_USER as

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;

Line 4: TYPE T_FORMULA_ID is TABLE of zx_formula_details.formula_id%type

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

Line 6: TYPE T_COMPOUNDING_TAX is TABLE of zx_formula_details.compounding_tax%type

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;

Line 9: is TABLE of zx_formula_details.compounding_tax_regime_code%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

Line 11: TYPE T_COMPOUNDING_TYPE is TABLE of zx_formula_details.Compounding_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

Line 13: TYPE T_RECORD_TYPE is TABLE of zx_formula_details.Record_Type_Code%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

Line 15: TYPE T_ATTRIBUTE_CATEGORY is TABLE of zx_formula_details.attribute_category%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

Line 17: TYPE T_ATTRIBUTE1 is TABLE of zx_formula_details.attribute1%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

Line 19: TYPE T_ATTRIBUTE2 is TABLE of zx_formula_details.attribute2%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

Line 21: TYPE T_ATTRIBUTE3 is TABLE of zx_formula_details.attribute3%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

Line 23: TYPE T_ATTRIBUTE4 is TABLE of zx_formula_details.attribute4%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

Line 25: TYPE T_ATTRIBUTE5 is TABLE of zx_formula_details.attribute5%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

Line 27: TYPE T_ATTRIBUTE6 is TABLE of zx_formula_details.attribute6%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

Line 29: TYPE T_ATTRIBUTE7 is TABLE of zx_formula_details.attribute7%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

Line 31: TYPE T_ATTRIBUTE8 is TABLE of zx_formula_details.attribute8%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

Line 33: TYPE T_ATTRIBUTE9 is TABLE of zx_formula_details.attribute9%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

Line 35: TYPE T_ATTRIBUTE10 is TABLE of zx_formula_details.attribute10%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

Line 37: TYPE T_ATTRIBUTE11 is TABLE of zx_formula_details.attribute11%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

Line 39: TYPE T_ATTRIBUTE12 is TABLE of zx_formula_details.attribute12%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

Line 41: TYPE T_ATTRIBUTE13 is TABLE of zx_formula_details.attribute13%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

Line 43: TYPE T_ATTRIBUTE14 is TABLE of zx_formula_details.attribute14%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

Line 45: TYPE T_ATTRIBUTE15 is TABLE of zx_formula_details.attribute15%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

Line 47: TYPE T_ATTRIBUTE16 is TABLE of zx_formula_details.attribute16%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

Line 49: TYPE T_ATTRIBUTE17 is TABLE of zx_formula_details.attribute17%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

Line 51: TYPE T_ATTRIBUTE18 is TABLE of zx_formula_details.attribute18%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

Line 53: TYPE T_ATTRIBUTE19 is TABLE of zx_formula_details.attribute19%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:

Line 55: TYPE T_ATTRIBUTE20 is TABLE of zx_formula_details.attribute20%type

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,

Line 86: end ZX_FORMULA_DETAILS_PKG;

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;