1 package ZX_FORMULA_PKG as
2 /* $Header: zxdformulas.pls 120.5 2005/03/17 12:19:12 shmangal ship $ */
3
4 procedure INSERT_ROW (
5 X_ROWID in out nocopy VARCHAR2,
6 X_FORMULA_ID in NUMBER,
7 X_Formula_Type_Code in VARCHAR2,
8 X_FORMULA_CODE in VARCHAR2,
9 X_TAX_REGIME_CODE in VARCHAR2,
10 X_TAX in VARCHAR2,
11 X_EFFECTIVE_FROM in DATE,
12 X_EFFECTIVE_TO in DATE,
13 X_Taxable_Basis_Type_Code in VARCHAR2,
14 X_Record_Type_Code in VARCHAR2,
15 X_BASE_RATE_MODIFIER in NUMBER,
16 X_Cash_Discount_Appl_Flag in VARCHAR2,
17 X_Volume_Discount_Appl_Flag in VARCHAR2,
18 X_Trading_Discount_Appl_Flag in VARCHAR2,
19 X_Transfer_Charge_Appl_Flag in VARCHAR2,
20 X_TRANSPORT_CHARGE_APPL_FLAG in VARCHAR2,
21 X_Insurance_Charge_Appl_Flag in VARCHAR2,
22 X_Other_Charge_Appl_Flag in VARCHAR2,
23 X_ATTRIBUTE_CATEGORY in VARCHAR2,
24 X_ATTRIBUTE1 in VARCHAR2,
25 X_ATTRIBUTE2 in VARCHAR2,
26 X_ATTRIBUTE3 in VARCHAR2,
27 X_ATTRIBUTE4 in VARCHAR2,
28 X_ATTRIBUTE5 in VARCHAR2,
29 X_ATTRIBUTE6 in VARCHAR2,
30 X_ATTRIBUTE7 in VARCHAR2,
31 X_ATTRIBUTE8 in VARCHAR2,
32 X_ATTRIBUTE9 in VARCHAR2,
33 X_ATTRIBUTE10 in VARCHAR2,
34 X_ATTRIBUTE11 in VARCHAR2,
35 X_ATTRIBUTE12 in VARCHAR2,
36 X_ATTRIBUTE13 in VARCHAR2,
37 X_ATTRIBUTE14 in VARCHAR2,
38 X_ATTRIBUTE15 in VARCHAR2,
39 X_ATTRIBUTE16 in VARCHAR2,
40 X_ATTRIBUTE17 in VARCHAR2,
41 X_ATTRIBUTE18 in VARCHAR2,
42 X_ATTRIBUTE19 in VARCHAR2,
43 X_ATTRIBUTE20 in VARCHAR2,
44 X_REQUEST_ID in NUMBER,
45 X_FORMULA_NAME in VARCHAR2,
46 X_FORMULA_DESCRIPTION in VARCHAR2,
47 X_CREATION_DATE in DATE,
48 X_CREATED_BY in NUMBER,
49 X_LAST_UPDATE_DATE in DATE,
50 X_LAST_UPDATED_BY in NUMBER,
51 X_LAST_UPDATE_LOGIN in NUMBER,
52 X_PROGRAM_APPLICATION_ID in NUMBER,
53 X_PROGRAM_ID in NUMBER,
54 X_PROGRAM_LOGIN_ID in NUMBER,
55 X_Enabled_Flag in VARCHAR2,
56 X_CONTENT_OWNER_ID in NUMBER,
57 X_OBJECT_VERSION_NUMBER in NUMBER);
58
59 procedure LOCK_ROW (
60 X_FORMULA_ID in NUMBER,
61 X_Formula_Type_Code in VARCHAR2,
62 X_FORMULA_CODE in VARCHAR2,
63 X_TAX_REGIME_CODE in VARCHAR2,
64 X_TAX in VARCHAR2,
65 X_EFFECTIVE_FROM in DATE,
66 X_EFFECTIVE_TO in DATE,
67 X_Taxable_Basis_Type_Code in VARCHAR2,
68 X_Record_Type_Code in VARCHAR2,
69 X_BASE_RATE_MODIFIER in NUMBER,
70 X_Cash_Discount_Appl_Flag in VARCHAR2,
71 X_Volume_Discount_Appl_Flag in VARCHAR2,
72 X_Trading_Discount_Appl_Flag in VARCHAR2,
73 X_Transfer_Charge_Appl_Flag in VARCHAR2,
74 X_TRANSPORT_CHARGE_APPL_FLAG in VARCHAR2,
75 X_Insurance_Charge_Appl_Flag in VARCHAR2,
76 X_Other_Charge_Appl_Flag in VARCHAR2,
77 X_ATTRIBUTE_CATEGORY in VARCHAR2,
78 X_ATTRIBUTE1 in VARCHAR2,
79 X_ATTRIBUTE2 in VARCHAR2,
80 X_ATTRIBUTE3 in VARCHAR2,
81 X_ATTRIBUTE4 in VARCHAR2,
82 X_ATTRIBUTE5 in VARCHAR2,
83 X_ATTRIBUTE6 in VARCHAR2,
84 X_ATTRIBUTE7 in VARCHAR2,
85 X_ATTRIBUTE8 in VARCHAR2,
86 X_ATTRIBUTE9 in VARCHAR2,
87 X_ATTRIBUTE10 in VARCHAR2,
88 X_ATTRIBUTE11 in VARCHAR2,
89 X_ATTRIBUTE12 in VARCHAR2,
90 X_ATTRIBUTE13 in VARCHAR2,
91 X_ATTRIBUTE14 in VARCHAR2,
92 X_ATTRIBUTE15 in VARCHAR2,
93 X_ATTRIBUTE16 in VARCHAR2,
94 X_ATTRIBUTE17 in VARCHAR2,
95 X_ATTRIBUTE18 in VARCHAR2,
96 X_ATTRIBUTE19 in VARCHAR2,
97 X_ATTRIBUTE20 in VARCHAR2,
98 X_REQUEST_ID in NUMBER,
99 X_FORMULA_NAME in VARCHAR2,
100 X_FORMULA_DESCRIPTION in VARCHAR2,
101 X_PROGRAM_APPLICATION_ID in NUMBER,
102 X_PROGRAM_ID in NUMBER,
103 X_PROGRAM_LOGIN_ID in NUMBER,
104 X_Enabled_Flag in VARCHAR2,
105 X_CONTENT_OWNER_ID in NUMBER,
106 X_OBJECT_VERSION_NUMBER in NUMBER);
107
108
109 procedure UPDATE_ROW (
110 X_FORMULA_ID in NUMBER,
111 X_Formula_Type_Code in VARCHAR2,
112 X_FORMULA_CODE in VARCHAR2,
113 X_TAX_REGIME_CODE in VARCHAR2,
114 X_TAX in VARCHAR2,
115 X_EFFECTIVE_FROM in DATE,
116 X_EFFECTIVE_TO in DATE,
117 X_Taxable_Basis_Type_Code in VARCHAR2,
118 X_Record_Type_Code in VARCHAR2,
119 X_BASE_RATE_MODIFIER in NUMBER,
120 X_Cash_Discount_Appl_Flag in VARCHAR2,
121 X_Volume_Discount_Appl_Flag in VARCHAR2,
122 X_Trading_Discount_Appl_Flag in VARCHAR2,
123 X_Transfer_Charge_Appl_Flag in VARCHAR2,
124 X_TRANSPORT_CHARGE_APPL_FLAG in VARCHAR2,
125 X_Insurance_Charge_Appl_Flag in VARCHAR2,
126 X_Other_Charge_Appl_Flag in VARCHAR2,
127 X_ATTRIBUTE_CATEGORY in VARCHAR2,
128 X_ATTRIBUTE1 in VARCHAR2,
129 X_ATTRIBUTE2 in VARCHAR2,
130 X_ATTRIBUTE3 in VARCHAR2,
131 X_ATTRIBUTE4 in VARCHAR2,
132 X_ATTRIBUTE5 in VARCHAR2,
133 X_ATTRIBUTE6 in VARCHAR2,
134 X_ATTRIBUTE7 in VARCHAR2,
135 X_ATTRIBUTE8 in VARCHAR2,
136 X_ATTRIBUTE9 in VARCHAR2,
137 X_ATTRIBUTE10 in VARCHAR2,
138 X_ATTRIBUTE11 in VARCHAR2,
139 X_ATTRIBUTE12 in VARCHAR2,
140 X_ATTRIBUTE13 in VARCHAR2,
141 X_ATTRIBUTE14 in VARCHAR2,
142 X_ATTRIBUTE15 in VARCHAR2,
143 X_ATTRIBUTE16 in VARCHAR2,
144 X_ATTRIBUTE17 in VARCHAR2,
145 X_ATTRIBUTE18 in VARCHAR2,
146 X_ATTRIBUTE19 in VARCHAR2,
147 X_ATTRIBUTE20 in VARCHAR2,
148 X_REQUEST_ID in NUMBER,
149 X_FORMULA_NAME in VARCHAR2,
150 X_FORMULA_DESCRIPTION in VARCHAR2,
151 X_LAST_UPDATE_DATE in DATE,
152 X_LAST_UPDATED_BY in NUMBER,
153 X_LAST_UPDATE_LOGIN in NUMBER,
154 X_PROGRAM_APPLICATION_ID in NUMBER,
155 X_PROGRAM_ID in NUMBER,
156 X_PROGRAM_LOGIN_ID in NUMBER,
157 X_Enabled_Flag in VARCHAR2,
158 X_CONTENT_OWNER_ID in NUMBER,
159 X_OBJECT_VERSION_NUMBER in NUMBER);
160
161
162 procedure DELETE_ROW (
163 X_FORMULA_ID in NUMBER);
164
165 procedure ADD_LANGUAGE;
166
167 TYPE T_FORMULA_ID is TABLE of zx_formula_b.formula_id%type
168 index by binary_integer;
169 TYPE T_FORMULA_TYPE is TABLE of zx_formula_b.Formula_Type_Code%type
170 index by binary_integer;
171 TYPE T_FORMULA_CODE is TABLE of zx_formula_b.formula_code%type
172 index by binary_integer;
173 TYPE T_TAX_REGIME_CODE is TABLE of zx_formula_b.tax_regime_code%type
174 index by binary_integer;
175 TYPE T_TAX is TABLE of zx_formula_b.tax%type
176 index by binary_integer;
177 TYPE T_EFFECTIVE_FROM is TABLE of zx_formula_b.effective_from%type
178 index by binary_integer;
179 TYPE T_EFFECTIVE_TO is TABLE of zx_formula_b.effective_to%type
180 index by binary_integer;
181 TYPE T_TAXABLE_BASIS_TYPE is TABLE of zx_formula_b.Taxable_Basis_Type_Code%type
182 index by binary_integer;
183 TYPE T_RECORD_TYPE is TABLE of zx_formula_b.Record_Type_Code%type
184 index by binary_integer;
185 TYPE T_BASE_RATE_MODIFIER is TABLE of zx_formula_b.base_rate_modifier%type
186 index by binary_integer;
187 TYPE T_CASH_DISCOUNT_APPL_FLG
188 is TABLE of zx_formula_b.Cash_Discount_Appl_Flag%type
189 index by binary_integer;
190 TYPE T_VOLUME_DISCOUNT_APPL_FLG
191 is TABLE of zx_formula_b.Volume_Discount_Appl_Flag%type
192 index by binary_integer;
193 TYPE T_TRADING_DISCOUNT_APPL_FLG
194 is TABLE of zx_formula_b.Trading_Discount_Appl_Flag%type
195 index by binary_integer;
196 TYPE T_TRANSFER_CHARGE_APPL_FLG
197 is TABLE of zx_formula_b.Transfer_Charge_Appl_Flag%type
198 index by binary_integer;
199 TYPE T_TRANSPORT_CHARGE_APPL_FLG
200 is TABLE of zx_formula_b.Transport_Charge_Appl_Flag%type
201 index by binary_integer;
202 TYPE T_INSURANCE_CHARGE_APPL_FLG
203 is TABLE of zx_formula_b.Insurance_Charge_Appl_Flag%type
204 index by binary_integer;
205 TYPE T_OTHER_CHARGE_APPL_FLG is TABLE of zx_formula_b.Other_Charge_Appl_Flag%type
206 index by binary_integer;
207 TYPE T_ATTRIBUTE_CATEGORY is TABLE of zx_formula_b.attribute_category%type
208 index by binary_integer;
209 TYPE T_ATTRIBUTE1 is TABLE of zx_formula_b.attribute1%type
210 index by binary_integer;
211 TYPE T_ATTRIBUTE2 is TABLE of zx_formula_b.attribute2%type
212 index by binary_integer;
213 TYPE T_ATTRIBUTE3 is TABLE of zx_formula_b.attribute3%type
214 index by binary_integer;
215 TYPE T_ATTRIBUTE4 is TABLE of zx_formula_b.attribute4%type
216 index by binary_integer;
217 TYPE T_ATTRIBUTE5 is TABLE of zx_formula_b.attribute5%type
218 index by binary_integer;
219 TYPE T_ATTRIBUTE6 is TABLE of zx_formula_b.attribute6%type
220 index by binary_integer;
221 TYPE T_ATTRIBUTE7 is TABLE of zx_formula_b.attribute7%type
222 index by binary_integer;
223 TYPE T_ATTRIBUTE8 is TABLE of zx_formula_b.attribute8%type
224 index by binary_integer;
225 TYPE T_ATTRIBUTE9 is TABLE of zx_formula_b.attribute9%type
226 index by binary_integer;
227 TYPE T_ATTRIBUTE10 is TABLE of zx_formula_b.attribute10%type
228 index by binary_integer;
229 TYPE T_ATTRIBUTE11 is TABLE of zx_formula_b.attribute11%type
230 index by binary_integer;
231 TYPE T_ATTRIBUTE12 is TABLE of zx_formula_b.attribute12%type
232 index by binary_integer;
233 TYPE T_ATTRIBUTE13 is TABLE of zx_formula_b.attribute13%type
234 index by binary_integer;
235 TYPE T_ATTRIBUTE14 is TABLE of zx_formula_b.attribute14%type
236 index by binary_integer;
237 TYPE T_ATTRIBUTE15 is TABLE of zx_formula_b.attribute15%type
238 index by binary_integer;
239 TYPE T_ATTRIBUTE16 is TABLE of zx_formula_b.attribute16%type
240 index by binary_integer;
241 TYPE T_ATTRIBUTE17 is TABLE of zx_formula_b.attribute17%type
242 index by binary_integer;
243 TYPE T_ATTRIBUTE18 is TABLE of zx_formula_b.attribute18%type
244 index by binary_integer;
245 TYPE T_ATTRIBUTE19 is TABLE of zx_formula_b.attribute19%type
246 index by binary_integer;
247 TYPE T_ATTRIBUTE20 is TABLE of zx_formula_b.attribute20%type
248 index by binary_integer;
249 TYPE T_FORMULA_NAME is TABLE of zx_formula_tl.formula_name%type
250 index by binary_integer;
251 TYPE T_FORMULA_DESCRIPTION is TABLE of zx_formula_tl.formula_description%type
252 index by binary_integer;
253 TYPE T_ENABLED_FLG is TABLE of zx_formula_b.Enabled_Flag%type
254 index by binary_integer;
255 TYPE T_CONTENT_OWNER_ID is TABLE of zx_formula_b.content_owner_id%type
256 index by binary_integer;
257
258 procedure bulk_insert_formula (
259 X_FORMULA_ID IN t_formula_id,
260 X_Formula_Type_Code IN t_formula_type,
261 X_FORMULA_CODE IN t_formula_code,
262 X_TAX_REGIME_CODE IN t_tax_regime_code,
263 X_TAX IN t_tax,
264 X_EFFECTIVE_FROM IN t_effective_from,
265 X_EFFECTIVE_TO IN t_effective_to,
266 X_Taxable_Basis_Type_Code IN t_taxable_basis_type,
267 X_Record_Type_Code IN t_record_type,
268 X_BASE_RATE_MODIFIER IN t_base_rate_modifier,
269 X_Cash_Discount_Appl_Flag IN t_cash_discount_appl_flg,
270 X_Volume_Discount_Appl_Flag IN t_volume_discount_appl_flg,
271 X_Trading_Discount_Appl_Flag IN t_trading_discount_appl_flg,
272 X_Transfer_Charge_Appl_Flag IN t_transfer_charge_appl_flg,
273 X_TRANSPORT_CHARGE_APPL_FLG IN t_transport_charge_appl_flg,
274 X_Insurance_Charge_Appl_Flag IN t_insurance_charge_appl_flg,
275 X_Other_Charge_Appl_Flag IN t_other_charge_appl_flg,
276 X_ATTRIBUTE_CATEGORY IN t_attribute_category,
277 X_ATTRIBUTE1 IN t_attribute1,
278 X_ATTRIBUTE2 IN t_attribute2,
279 X_ATTRIBUTE3 IN t_attribute3,
280 X_ATTRIBUTE4 IN t_attribute4,
281 X_ATTRIBUTE5 IN t_attribute5,
282 X_ATTRIBUTE6 IN t_attribute6,
283 X_ATTRIBUTE7 IN t_attribute7,
284 X_ATTRIBUTE8 IN t_attribute8,
285 X_ATTRIBUTE9 IN t_attribute9,
286 X_ATTRIBUTE10 IN t_attribute10,
287 X_ATTRIBUTE11 IN t_attribute11,
288 X_ATTRIBUTE12 IN t_attribute12,
289 X_ATTRIBUTE13 IN t_attribute13,
290 X_ATTRIBUTE14 IN t_attribute14,
291 X_ATTRIBUTE15 IN t_attribute15,
292 X_ATTRIBUTE16 IN t_attribute16,
293 X_ATTRIBUTE17 IN t_attribute17,
294 X_ATTRIBUTE18 IN t_attribute18,
295 X_ATTRIBUTE19 IN t_attribute19,
296 X_ATTRIBUTE20 IN t_attribute20,
297 X_FORMULA_NAME IN t_formula_name,
298 X_FORMULA_DESCRIPTION IN t_formula_description,
299 X_Enabled_Flag IN t_enabled_flg,
300 X_CONTENT_OWNER_ID IN t_content_owner_id);
301
302 end ZX_FORMULA_PKG;