1 package ZX_PROCESS_RESULTS_PKG as
2 /* $Header: zxdprocessrsltss.pls 120.3 2003/12/19 03:51:43 ssekuri ship $ */
3
4 TYPE T_CONTENT_OWNER_ID is TABLE of zx_process_results.content_owner_id%type
5 index by binary_integer;
6 TYPE T_CONDITION_GROUP_ID is TABLE of zx_process_results.condition_group_id%type
7 index by binary_integer;
8 TYPE T_CONDITION_GROUP_CODE
9 is TABLE of zx_process_results.condition_group_code%type
10 index by binary_integer;
11 TYPE T_TAX_RULE_ID is TABLE of zx_process_results.tax_rule_id%type
12 index by binary_integer;
13 TYPE T_PRIORITY is TABLE of zx_process_results.priority%type
14 index by binary_integer;
15 TYPE T_RESULT_TYPE is TABLE of zx_process_results.Result_Type_Code%type
16 index by binary_integer;
17 TYPE T_TAX_STATUS_CODE is TABLE of zx_process_results.tax_status_code%type
18 index by binary_integer;
19 TYPE T_NUMERIC_RESULT is TABLE of zx_process_results.numeric_result%type
20 index by binary_integer;
21 TYPE T_ALPHANUMERIC_RESULT
22 is TABLE of zx_process_results.alphanumeric_result%type
23 index by binary_integer;
24 TYPE T_RESULT_API is TABLE of zx_process_results.result_api%type
25 index by binary_integer;
26 TYPE T_STATUS_RESULT is TABLE of zx_process_results.status_result%type
27 index by binary_integer;
28 TYPE T_RATE_RESULT is TABLE of zx_process_results.rate_result%type
29 index by binary_integer;
30 TYPE T_LEGAL_MESSAGE_CODE is TABLE of zx_process_results.legal_message_code%type
31 index by binary_integer;
32 TYPE T_MIN_TAX_AMT is TABLE of zx_process_results.min_tax_amt%type
33 index by binary_integer;
34 TYPE T_MAX_TAX_AMT is TABLE of zx_process_results.max_tax_amt%type
35 index by binary_integer;
36 TYPE T_MIN_TAXABLE_BASIS is TABLE of zx_process_results.min_taxable_basis%type
37 index by binary_integer;
38 TYPE T_MAX_TAXABLE_BASIS is TABLE of zx_process_results.max_taxable_basis%type
39 index by binary_integer;
40 TYPE T_MIN_TAX_RATE is TABLE of zx_process_results.min_tax_rate%type
41 index by binary_integer;
42 TYPE T_MAX_TAX_RATE is TABLE of zx_process_results.max_tax_rate%type
43 index by binary_integer;
44 TYPE T_ENABLED_FLG is TABLE of zx_process_results.Enabled_Flag%type
45 index by binary_integer;
46 TYPE T_ALLOW_EXEMPTIONS is TABLE of zx_process_results.Allow_Exemptions_Flag%type
47 index by binary_integer;
48 TYPE T_ALLOW_EXCEPTIONS is TABLE of zx_process_results.Allow_Exceptions_Flag%type
49 index by binary_integer;
50 TYPE T_RECORD_TYPE is TABLE of zx_process_results.Record_Type_Code%type
51 index by binary_integer;
52
53 PROCEDURE bulk_insert_process_results (
54 X_CONTENT_OWNER_ID IN t_content_owner_id,
55 X_CONDITION_GROUP_ID IN t_condition_group_id,
56 X_CONDITION_GROUP_CODE IN t_condition_group_code,
57 X_TAX_RULE_ID IN t_tax_rule_id,
58 X_PRIORITY IN t_priority,
59 X_Result_Type_Code IN t_result_type,
60 X_TAX_STATUS_CODE IN t_tax_status_code,
61 X_NUMERIC_RESULT IN t_numeric_result,
62 X_ALPHANUMERIC_RESULT IN t_alphanumeric_result,
63 X_RESULT_API IN t_result_api,
64 X_STATUS_RESULT IN t_status_result,
65 X_RATE_RESULT IN t_rate_result,
66 X_LEGAL_MESSAGE_CODE IN t_legal_message_code,
67 X_MIN_TAX_AMT IN t_min_tax_amt,
68 X_MAX_TAX_AMT IN t_max_tax_amt,
69 X_MIN_TAXABLE_BASIS IN t_min_taxable_basis,
70 X_MAX_TAXABLE_BASIS IN t_max_taxable_basis,
71 X_MIN_TAX_RATE IN t_min_tax_rate,
72 X_MAX_TAX_RATE IN t_max_tax_rate,
73 X_Enabled_Flag IN t_enabled_flg,
74 X_Allow_Exemptions_Flag IN t_allow_exemptions,
75 X_Allow_Exceptions_Flag IN t_allow_exceptions,
76 X_Record_Type_Code IN t_record_type) ;
77
78 end ZX_PROCESS_RESULTS_PKG;