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
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 PROCEDURE check_dup_tax_conditions
53 (p_det_factor_templ_code IN VARCHAR2
54 ,p_condition_group_id IN NUMBER
55 ,p_condition_id IN NUMBER
56 ,p_det_factor_class_code IN VARCHAR2
57 ,p_det_factor_code IN VARCHAR2
58 ,p_det_factor_cq_code IN VARCHAR2
59 ,p_operator_code IN VARCHAR2
60 ,p_alphanumeric_value IN VARCHAR2
61 ,p_numeric_value IN NUMBER
62 ,p_date_value IN DATE
63 ,p_value_low IN VARCHAR2
64 ,p_value_high IN VARCHAR2
65 ,x_return_status OUT NOCOPY VARCHAR2
66 ,x_msg_data OUT NOCOPY VARCHAR2
67 ,x_condition_group_code OUT NOCOPY VARCHAR2
68 );
69
70 end ZX_CONDITIONS_PKG;