1 package ZX_CONDITIONS_PKG as
2 /* $Header: zxdconditionss.pls 120.3 2003/12/19 20:28:46 ssekuri 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
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;
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
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
36 PROCEDURE bulk_insert_conditions (
37 X_DETERMINING_FACTOR_CODE IN t_determining_factor_code,
38 X_CONDITION_GROUP_CODE IN t_condition_group_code,
39 X_TAX_PARAMETER_CODE IN t_tax_parameter_code,
40 X_DATA_TYPE_CODE IN t_data_type,
41 X_DETERMINING_FACTOR_CLASS_COD IN t_determining_factor_class,
42 X_DETERMINING_FACTOR_CQ_CODE IN t_determining_factor_cq,
43 X_OPERATOR_CODE IN t_operator,
44 X_RECORD_TYPE_CODE IN t_record_type,
45 X_IGNORE_FLAG IN t_ignore_flg,
46 X_NUMERIC_VALUE IN t_numeric_value,
47 X_DATE_VALUE IN t_date_value,
48 X_ALPHANUMERIC_VALUE IN t_alphanumeric_value,
49 X_VALUE_LOW IN t_value_low,
50 X_VALUE_HIGH IN t_value_high);
51
52 end ZX_CONDITIONS_PKG;
[Home] [Help]