DBA Data[Home] [Help]

PACKAGE: APPS.ZX_PROCESS_RESULTS_PKG

Source


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;