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;
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
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;
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
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
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
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
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
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;
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
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
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
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
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
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
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
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
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
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
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
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
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
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:
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,
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;