DBA Data[Home] [Help]

PACKAGE BODY: APPS.ZX_PROCESS_RESULTS_PKG

Source


1 package body ZX_PROCESS_RESULTS_PKG as
2 /* $Header: zxdprocessrsltsb.pls 120.3 2003/12/19 03:51:40 ssekuri ship $ */
3 
4 procedure bulk_insert_process_results (
5   X_CONTENT_OWNER_ID          IN t_content_owner_id,
6   X_CONDITION_GROUP_ID        IN t_condition_group_id,
7   X_CONDITION_GROUP_CODE      IN t_condition_group_code,
8   X_TAX_RULE_ID               IN t_tax_rule_id,
9   X_PRIORITY                  IN t_priority,
10   X_Result_Type_Code               IN t_result_type,
11   X_TAX_STATUS_CODE           IN t_tax_status_code,
12   X_NUMERIC_RESULT            IN t_numeric_result,
13   X_ALPHANUMERIC_RESULT       IN t_alphanumeric_result,
14   X_RESULT_API                IN t_result_api,
15   X_STATUS_RESULT             IN t_status_result,
16   X_RATE_RESULT               IN t_rate_result,
17   X_LEGAL_MESSAGE_CODE        IN t_legal_message_code,
18   X_MIN_TAX_AMT               IN t_min_tax_amt,
19   X_MAX_TAX_AMT               IN t_max_tax_amt,
20   X_MIN_TAXABLE_BASIS         IN t_min_taxable_basis,
21   X_MAX_TAXABLE_BASIS         IN t_max_taxable_basis,
22   X_MIN_TAX_RATE              IN t_min_tax_rate,
23   X_MAX_TAX_RATE              IN t_max_tax_rate,
24   X_Enabled_Flag               IN t_enabled_flg,
25   X_Allow_Exemptions_Flag          IN t_allow_exemptions,
26   X_Allow_Exceptions_Flag          IN t_allow_exceptions,
27   X_Record_Type_Code               IN t_record_type) is
28 
29 begin
30   If x_tax_rule_id.count <> 0 then
31      forall i in x_tax_rule_id.first..x_tax_rule_id.last
32        INSERT INTO ZX_PROCESS_RESULTS (RESULT_ID,
33                                        CONTENT_OWNER_ID,
34                                        CONDITION_GROUP_ID,
35                                        CONDITION_GROUP_CODE,
36                                        TAX_RULE_ID,
37                                        PRIORITY,
38                                        Result_Type_Code,
39                                        TAX_STATUS_CODE,
40                                        NUMERIC_RESULT,
41                                        ALPHANUMERIC_RESULT,
42                                        RESULT_API,
43                                        STATUS_RESULT,
44                                        RATE_RESULT,
45                                        LEGAL_MESSAGE_CODE,
46                                        MIN_TAX_AMT,
47                                        MAX_TAX_AMT,
48                                        MIN_TAXABLE_BASIS,
49                                        MAX_TAXABLE_BASIS,
50                                        MIN_TAX_RATE,
51                                        MAX_TAX_RATE,
52                                        Enabled_Flag,
53                                        Allow_Exemptions_Flag,
54                                        Allow_Exceptions_Flag,
55                                        Record_Type_Code,
56                                        CREATED_BY             ,
57                                        CREATION_DATE          ,
58                                        LAST_UPDATED_BY        ,
59                                        LAST_UPDATE_DATE       ,
60                                        LAST_UPDATE_LOGIN      ,
61                                        REQUEST_ID             ,
62                                        PROGRAM_APPLICATION_ID ,
63                                        PROGRAM_ID             ,
64                                        PROGRAM_LOGIN_ID)
65                                values (zx_process_results_s.nextval,
66                                        X_CONTENT_OWNER_ID(i),
67                                        X_CONDITION_GROUP_ID(i),
68                                        X_CONDITION_GROUP_CODE(i),
69                                        X_TAX_RULE_ID(i),
70                                        X_PRIORITY(i),
71                                        X_Result_Type_Code(i),
72                                        X_TAX_STATUS_CODE(i),
73                                        X_NUMERIC_RESULT(i),
74                                        X_ALPHANUMERIC_RESULT(i),
75                                        X_RESULT_API(i),
76                                        X_STATUS_RESULT(i),
77                                        X_RATE_RESULT(i),
78                                        X_LEGAL_MESSAGE_CODE(i),
79                                        X_MIN_TAX_AMT(i),
80                                        X_MAX_TAX_AMT(i),
81                                        X_MIN_TAXABLE_BASIS(i),
82                                        X_MAX_TAXABLE_BASIS(i),
83                                        X_MIN_TAX_RATE(i),
84                                        X_MAX_TAX_RATE(i),
85                                        X_Enabled_Flag(i),
86                                        X_Allow_Exemptions_Flag(i),
87                                        X_Allow_Exceptions_Flag(i),
88                                        X_Record_Type_Code(i),
89                                        fnd_global.user_id         ,
90                                        sysdate                    ,
91                                        fnd_global.user_id         ,
92                                        sysdate                    ,
93                                        fnd_global.conc_login_id   ,
94                                        fnd_global.conc_request_id ,
95                                        fnd_global.prog_appl_id    ,
96                                        fnd_global.conc_program_id ,
97                                        fnd_global.conc_login_id
98                                        );
99 
100   end if;
101 
102  EXCEPTION
103       WHEN OTHERS THEN
104         APP_EXCEPTION.RAISE_EXCEPTION;
105 
106 end bulk_insert_process_results;
107 
108 end ZX_PROCESS_RESULTS_PKG;