[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;