1: package ZX_CONDITIONS_PKG AUTHID CURRENT_USER as
2: /* $Header: zxdconditionss.pls 120.5.12020000.2 2013/01/31 06:40:03 srajapar ship $ */
3:
4: TYPE T_DETERMINING_FACTOR_CODE
5: is TABLE of zx_conditions.determining_factor_code%type
1: package ZX_CONDITIONS_PKG AUTHID CURRENT_USER as
2: /* $Header: zxdconditionss.pls 120.5.12020000.2 2013/01/31 06:40:03 srajapar ship $ */
3:
4: TYPE T_DETERMINING_FACTOR_CODE
5: is TABLE of zx_conditions.determining_factor_code%type
6: index by binary_integer;
1: package ZX_CONDITIONS_PKG AUTHID CURRENT_USER as
2: /* $Header: zxdconditionss.pls 120.5.12020000.2 2013/01/31 06:40:03 srajapar ship $ */
3:
4: TYPE T_DETERMINING_FACTOR_CODE
5: is TABLE of zx_conditions.determining_factor_code%type
6: index by binary_integer;
7: TYPE T_CONDITION_GROUP_CODE is TABLE of zx_conditions.condition_group_code%type
8: index by binary_integer;
9: TYPE T_TAX_PARAMETER_CODE is TABLE of zx_conditions.tax_parameter_code%type
3:
4: TYPE T_DETERMINING_FACTOR_CODE
5: is TABLE of zx_conditions.determining_factor_code%type
6: index by binary_integer;
7: TYPE T_CONDITION_GROUP_CODE is TABLE of zx_conditions.condition_group_code%type
8: index by binary_integer;
9: TYPE T_TAX_PARAMETER_CODE is TABLE of zx_conditions.tax_parameter_code%type
10: index by binary_integer;
11: TYPE T_DATA_TYPE is TABLE of zx_conditions.DATA_TYPE_CODE%type
5: is TABLE of zx_conditions.determining_factor_code%type
6: index by binary_integer;
7: TYPE T_CONDITION_GROUP_CODE is TABLE of zx_conditions.condition_group_code%type
8: index by binary_integer;
9: TYPE T_TAX_PARAMETER_CODE is TABLE of zx_conditions.tax_parameter_code%type
10: index by binary_integer;
11: TYPE T_DATA_TYPE is TABLE of zx_conditions.DATA_TYPE_CODE%type
12: index by binary_integer;
13: TYPE T_DETERMINING_FACTOR_CLASS
7: TYPE T_CONDITION_GROUP_CODE is TABLE of zx_conditions.condition_group_code%type
8: index by binary_integer;
9: TYPE T_TAX_PARAMETER_CODE is TABLE of zx_conditions.tax_parameter_code%type
10: index by binary_integer;
11: TYPE T_DATA_TYPE is TABLE of zx_conditions.DATA_TYPE_CODE%type
12: index by binary_integer;
13: TYPE T_DETERMINING_FACTOR_CLASS
14: is TABLE of zx_conditions.Determining_Factor_Class_Code%type
15: index by binary_integer;
10: index by binary_integer;
11: TYPE T_DATA_TYPE is TABLE of zx_conditions.DATA_TYPE_CODE%type
12: index by binary_integer;
13: TYPE T_DETERMINING_FACTOR_CLASS
14: is TABLE of zx_conditions.Determining_Factor_Class_Code%type
15: index by binary_integer;
16: TYPE T_DETERMINING_FACTOR_CQ
17: is TABLE of zx_conditions.DETERMINING_FACTOR_CQ_CODE%type
18: index by binary_integer;
13: TYPE T_DETERMINING_FACTOR_CLASS
14: is TABLE of zx_conditions.Determining_Factor_Class_Code%type
15: index by binary_integer;
16: TYPE T_DETERMINING_FACTOR_CQ
17: is TABLE of zx_conditions.DETERMINING_FACTOR_CQ_CODE%type
18: index by binary_integer;
19: TYPE T_OPERATOR is TABLE of zx_conditions.OPERATOR_CODE%type
20: index by binary_integer;
21: TYPE T_RECORD_TYPE is TABLE of zx_conditions.Record_Type_Code%type
15: index by binary_integer;
16: TYPE T_DETERMINING_FACTOR_CQ
17: is TABLE of zx_conditions.DETERMINING_FACTOR_CQ_CODE%type
18: index by binary_integer;
19: TYPE T_OPERATOR is TABLE of zx_conditions.OPERATOR_CODE%type
20: index by binary_integer;
21: TYPE T_RECORD_TYPE is TABLE of zx_conditions.Record_Type_Code%type
22: index by binary_integer;
23: TYPE T_IGNORE_FLG is TABLE of zx_conditions.Ignore_Flag%type
17: is TABLE of zx_conditions.DETERMINING_FACTOR_CQ_CODE%type
18: index by binary_integer;
19: TYPE T_OPERATOR is TABLE of zx_conditions.OPERATOR_CODE%type
20: index by binary_integer;
21: TYPE T_RECORD_TYPE is TABLE of zx_conditions.Record_Type_Code%type
22: index by binary_integer;
23: TYPE T_IGNORE_FLG is TABLE of zx_conditions.Ignore_Flag%type
24: index by binary_integer;
25: TYPE T_NUMERIC_VALUE is TABLE of zx_conditions.numeric_value%type
19: TYPE T_OPERATOR is TABLE of zx_conditions.OPERATOR_CODE%type
20: index by binary_integer;
21: TYPE T_RECORD_TYPE is TABLE of zx_conditions.Record_Type_Code%type
22: index by binary_integer;
23: TYPE T_IGNORE_FLG is TABLE of zx_conditions.Ignore_Flag%type
24: index by binary_integer;
25: TYPE T_NUMERIC_VALUE is TABLE of zx_conditions.numeric_value%type
26: index by binary_integer;
27: TYPE T_DATE_VALUE is TABLE of zx_conditions.date_value%type
21: TYPE T_RECORD_TYPE is TABLE of zx_conditions.Record_Type_Code%type
22: index by binary_integer;
23: TYPE T_IGNORE_FLG is TABLE of zx_conditions.Ignore_Flag%type
24: index by binary_integer;
25: TYPE T_NUMERIC_VALUE is TABLE of zx_conditions.numeric_value%type
26: index by binary_integer;
27: TYPE T_DATE_VALUE is TABLE of zx_conditions.date_value%type
28: index by binary_integer;
29: TYPE T_ALPHANUMERIC_VALUE is TABLE of zx_conditions.alphanumeric_value%type
23: TYPE T_IGNORE_FLG is TABLE of zx_conditions.Ignore_Flag%type
24: index by binary_integer;
25: TYPE T_NUMERIC_VALUE is TABLE of zx_conditions.numeric_value%type
26: index by binary_integer;
27: TYPE T_DATE_VALUE is TABLE of zx_conditions.date_value%type
28: index by binary_integer;
29: TYPE T_ALPHANUMERIC_VALUE is TABLE of zx_conditions.alphanumeric_value%type
30: index by binary_integer;
31: TYPE T_VALUE_LOW is TABLE of zx_conditions.value_low%type
25: TYPE T_NUMERIC_VALUE is TABLE of zx_conditions.numeric_value%type
26: index by binary_integer;
27: TYPE T_DATE_VALUE is TABLE of zx_conditions.date_value%type
28: index by binary_integer;
29: TYPE T_ALPHANUMERIC_VALUE is TABLE of zx_conditions.alphanumeric_value%type
30: index by binary_integer;
31: TYPE T_VALUE_LOW is TABLE of zx_conditions.value_low%type
32: index by binary_integer;
33: TYPE T_VALUE_HIGH is TABLE of zx_conditions.value_high%type
27: TYPE T_DATE_VALUE is TABLE of zx_conditions.date_value%type
28: index by binary_integer;
29: TYPE T_ALPHANUMERIC_VALUE is TABLE of zx_conditions.alphanumeric_value%type
30: index by binary_integer;
31: TYPE T_VALUE_LOW is TABLE of zx_conditions.value_low%type
32: index by binary_integer;
33: TYPE T_VALUE_HIGH is TABLE of zx_conditions.value_high%type
34: index by binary_integer;
35:
29: TYPE T_ALPHANUMERIC_VALUE is TABLE of zx_conditions.alphanumeric_value%type
30: index by binary_integer;
31: TYPE T_VALUE_LOW is TABLE of zx_conditions.value_low%type
32: index by binary_integer;
33: TYPE T_VALUE_HIGH is TABLE of zx_conditions.value_high%type
34: index by binary_integer;
35:
36: PROCEDURE bulk_insert_conditions (
37: X_DETERMINING_FACTOR_CODE IN t_determining_factor_code,
66: ,x_msg_data OUT NOCOPY VARCHAR2
67: ,x_condition_group_code OUT NOCOPY VARCHAR2
68: );
69:
70: end ZX_CONDITIONS_PKG;