[Home] [Help]
PACKAGE BODY: APPS.ZX_FORMULA_DETAILS_PKG
Source
1 package body ZX_FORMULA_DETAILS_PKG as
2 /* $Header: zxdformuladtlb.pls 120.2 2003/12/19 03:51:25 ssekuri ship $ */
3
4 procedure bulk_insert_formula_details (
5 X_FORMULA_ID IN t_formula_id,
6 X_COMPOUNDING_TAX IN t_compounding_tax,
7 X_COMPOUNDING_TAX_REGIME_CODE IN t_compounding_tax_regime_code,
8 X_Compounding_Type_Code IN t_compounding_type,
9 X_Record_Type_Code IN t_record_type,
10 X_ATTRIBUTE_CATEGORY IN t_attribute_category,
11 X_ATTRIBUTE1 IN t_attribute1,
12 X_ATTRIBUTE2 IN t_attribute2,
13 X_ATTRIBUTE3 IN t_attribute3,
14 X_ATTRIBUTE4 IN t_attribute4,
15 X_ATTRIBUTE5 IN t_attribute5,
16 X_ATTRIBUTE6 IN t_attribute6,
17 X_ATTRIBUTE7 IN t_attribute7,
18 X_ATTRIBUTE8 IN t_attribute8,
19 X_ATTRIBUTE9 IN t_attribute9,
20 X_ATTRIBUTE10 IN t_attribute10,
21 X_ATTRIBUTE11 IN t_attribute11,
22 X_ATTRIBUTE12 IN t_attribute12,
23 X_ATTRIBUTE13 IN t_attribute13,
24 X_ATTRIBUTE14 IN t_attribute14,
25 X_ATTRIBUTE15 IN t_attribute15,
26 X_ATTRIBUTE16 IN t_attribute16,
27 X_ATTRIBUTE17 IN t_attribute17,
28 X_ATTRIBUTE18 IN t_attribute18,
29 X_ATTRIBUTE19 IN t_attribute19,
30 X_ATTRIBUTE20 IN t_attribute20) is
31
32 begin
33
34 if x_formula_id.count <> 0 then
35 forall i in x_formula_id.first..x_formula_id.last
36 INSERT INTO ZX_FORMULA_DETAILS (FORMULA_DETAIL_ID,
37 FORMULA_ID,
38 COMPOUNDING_TAX,
39 COMPOUNDING_TAX_REGIME_CODE,
40 Compounding_Type_Code,
41 Record_Type_Code,
42 ATTRIBUTE_CATEGORY,
43 ATTRIBUTE1,
44 ATTRIBUTE2,
45 ATTRIBUTE3,
46 ATTRIBUTE4,
47 ATTRIBUTE5,
48 ATTRIBUTE6,
49 ATTRIBUTE7,
50 ATTRIBUTE8,
51 ATTRIBUTE9,
52 ATTRIBUTE10,
53 ATTRIBUTE11,
54 ATTRIBUTE12,
55 ATTRIBUTE13,
56 ATTRIBUTE14,
57 ATTRIBUTE15,
58 ATTRIBUTE16,
59 ATTRIBUTE17,
60 ATTRIBUTE18,
61 ATTRIBUTE19,
62 ATTRIBUTE20,
63 CREATED_BY ,
64 CREATION_DATE ,
65 LAST_UPDATED_BY ,
66 LAST_UPDATE_DATE ,
67 LAST_UPDATE_LOGIN ,
68 REQUEST_ID ,
69 PROGRAM_APPLICATION_ID ,
70 PROGRAM_ID ,
71 PROGRAM_LOGIN_ID)
72 values (zx_formula_details_s.nextval,
73 X_FORMULA_ID(i),
74 X_COMPOUNDING_TAX(i),
75 X_COMPOUNDING_TAX_REGIME_CODE(i),
76 X_Compounding_Type_Code(i),
77 X_Record_Type_Code(i),
78 X_ATTRIBUTE_CATEGORY(i),
79 X_ATTRIBUTE1(i),
80 X_ATTRIBUTE2(i),
81 X_ATTRIBUTE3(i),
82 X_ATTRIBUTE4(i),
83 X_ATTRIBUTE5(i),
84 X_ATTRIBUTE6(i),
85 X_ATTRIBUTE7(i),
86 X_ATTRIBUTE8(i),
87 X_ATTRIBUTE9(i),
88 X_ATTRIBUTE10(i),
89 X_ATTRIBUTE11(i),
90 X_ATTRIBUTE12(i),
91 X_ATTRIBUTE13(i),
92 X_ATTRIBUTE14(i),
93 X_ATTRIBUTE15(i),
94 X_ATTRIBUTE16(i),
95 X_ATTRIBUTE17(i),
96 X_ATTRIBUTE18(i),
97 X_ATTRIBUTE19(i),
98 X_ATTRIBUTE20(i),
99 fnd_global.user_id ,
100 sysdate ,
101 fnd_global.user_id ,
102 sysdate ,
103 fnd_global.conc_login_id ,
104 fnd_global.conc_request_id ,
105 fnd_global.prog_appl_id ,
106 fnd_global.conc_program_id ,
107 fnd_global.conc_login_id
108 );
109
110 end if;
111
112 EXCEPTION
113 WHEN OTHERS THEN
114 APP_EXCEPTION.RAISE_EXCEPTION;
115
116 end bulk_insert_formula_details;
117
118 end ZX_FORMULA_DETAILS_PKG;