[Home] [Help]
PACKAGE BODY: APPS.JAI_RCV_TRANSACTIONS_PKG
Source
1 PACKAGE BODY jai_rcv_transactions_pkg AS
2 /* $Header: jai_rcv_trx.plb 120.1.12010000.2 2010/04/15 11:03:01 boboli ship $ */
3 /*----------------------------------------------------------------------------------------------------------------------------
4 CHANGE HISTORY for FILENAME: jai_rcv_transactions_pkg.sql
5 S.No dd/mm/yyyy Author and Details
6 ------------------------------------------------------------------------------------------------------------------------------
7 1 16/07/2004 Vijay Shankar for Bug# 3496408, Version:115.0
8 Table handler Package for JAI_RCV_TRANSACTIONS table
9
10 2 03/01/2005 Vijay Shankar for Bug# 3940588, Version:115.1
11 Added tax_transaction_id for JAI_RCV_TRANSACTIONS table. as a result of the change, we added the corresponding
12 parameters in insert_row and update_row procedures
13
14 3 19/03/2005 Vijay Shankar for Bug#4250236(4245089). FileVersion: 115.2
15 added two more parameters in update_process_flags procedure as part of VAT Implementation to update
16 process_vat_flag and related message
17
18 4. 08-Jun-2005 Version 116.1 jai_rcv_trx -Object is Modified to refer to New DB Entity names in place of Old DB Entity Names
19 as required for CASE COMPLAINCE.
20
21 5. 13-Jun-2005 File Version: 116.2
22 Ramananda for bug#4428980. Removal of SQL LITERALs is done
23
24 6. 17-Jul-2005 Sanjikum for Bug#4495135, File Version 117.1
25 1) In the procedure update_row, added parameter - p_tax_apportion_factor.
26 And added the update for jai_rcv_transactions.tax_apportion_factor
27
28 7. 15-Apr-2010 Bug#9305067 Change the parameter of procedure insert_row and update_row
29 and replce the old attributes columns with new meaningful columns parameter
30 Add new procedure to update the new columns to replace the procedure update_attribtues
31
32
33 Dependancy:
34 -----------
35 IN60105D2 + 3496408
36 IN60106 + 3940588 + 4245089
37 ----------------------------------------------------------------------------------------------------------------------------*/
38
39 PROCEDURE insert_row(
40 p_shipment_header_id IN JAI_RCV_TRANSACTIONS.SHIPMENT_HEADER_ID%TYPE,
41 p_shipment_line_id IN JAI_RCV_TRANSACTIONS.SHIPMENT_LINE_ID%TYPE,
42 p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,
43 p_transaction_date IN JAI_RCV_TRANSACTIONS.TRANSACTION_DATE%TYPE,
44 p_transaction_type IN JAI_RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE,
45 p_quantity IN JAI_RCV_TRANSACTIONS.QUANTITY%TYPE,
46 p_uom_code IN JAI_RCV_TRANSACTIONS.UOM_CODE%TYPE,
47 p_parent_transaction_id IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_ID%TYPE,
48 p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE,
49 p_destination_type_code IN JAI_RCV_TRANSACTIONS.destination_type_code%TYPE,
50 p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE,
51 p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE,
52 p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE,
53 p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE,
54 p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE,
55 p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE,
56 p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE,
57 p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE,
58 p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE,
59 p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE,
60 p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE,
61 p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE,
62 p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE,
63 p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE,
64 p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE,
65 p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE,
66 p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_ASSET_INVENTORY%TYPE,
67 p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE,
68 p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE,
69 p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE,
70 p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE,
71 p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE,
72 --Added new parametersby Bo Li for bug9305067
73 --remove the old attribute parameters Begin
74 -----------------------------------------------------------------------------
75 p_trx_information IN JAI_RCV_TRANSACTIONS.TRX_INFORMATION%TYPE,
76 p_excise_inv_gen_status IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_STATUS%TYPE,
77 p_vat_inv_gen_status IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_STATUS%TYPE,
78 p_excise_inv_gen_number IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_NUMBER%TYPE,
79 p_vat_inv_gen_number IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_NUMBER%TYPE,
80 p_cenvat_costed_flag IN JAI_RCV_TRANSACTIONS.CENVAT_COSTED_FLAG%TYPE,
81 -----------------------------------------------------------------------------
82 --Added new parametersby Bo Li for bug9305067
83 --remove the old attribute parameters End
84 p_tax_transaction_id IN JAI_RCV_TRANSACTIONS.tax_transaction_id%TYPE -- Vijay Shankar for Bug#3940588
85 ) IS
86
87 lv_creation_date DATE;
88 lv_created_by NUMBER(15);
89 lv_last_update_date DATE;
90 lv_last_updated_by NUMBER(15);
91 lv_last_update_login NUMBER(15);
92
93 BEGIN
94
95 lv_creation_date := SYSDATE;
96 lv_created_by := FND_GLOBAL.user_id;
97 lv_last_update_date := SYSDATE;
98 lv_last_updated_by := lv_created_by;
99 lv_last_update_login := FND_GLOBAL.login_id;
100
101 INSERT INTO JAI_RCV_TRANSACTIONS(
102 shipment_header_id, shipment_line_id, transaction_id, transaction_type, quantity, uom_code,
103 transaction_date, parent_transaction_id, parent_transaction_type, receipt_num, organization_id,
104 location_id, inventory_item_id, item_class, item_cenvatable, item_excisable, item_trading_flag,
105 inv_item_flag, inv_asset_flag, loc_subinv_type, BASE_ASSET_INVENTORY, organization_type,
106 excise_in_trading, costing_method, boe_applied_flag, third_party_flag,
107 --Added new parametersby Bo Li for bug9305067
108 --remove the old attribute parameters Begin
109 -----------------------------------------------------------------------------
110 trx_information,excise_inv_gen_status,vat_inv_gen_status,excise_inv_gen_number,
111 vat_inv_gen_number, cenvat_costed_flag,
112 -----------------------------------------------------------------------------
113 --Added new parametersby Bo Li for bug9305067
114 --remove the old attribute parameters End
115 creation_date, created_by, last_update_date, last_updated_by, last_update_login,
116 destination_type_code, assessable_value, currency_conversion_rate,
117 excise_invoice_no, excise_invoice_date, tax_amount, cenvat_claimed_ptg, tax_transaction_id
118 ) VALUES (
119 p_shipment_header_id, p_shipment_line_id, p_transaction_id, p_transaction_type, p_quantity, p_uom_code,
120 p_transaction_date, p_parent_transaction_id, p_parent_transaction_type, p_receipt_num, p_organization_id,
121 p_location_id, p_inventory_item_id, p_item_class, p_item_cenvatable, p_item_excisable, p_item_trading_flag,
122 p_inv_item_flag, p_inv_asset_flag, p_loc_subinv_type, p_base_subinv_asset_flag, p_organization_type,
123 p_excise_in_trading, p_costing_method, p_boe_applied_flag, p_third_party_flag,
124 --Added new parametersby Bo Li for bug9305067
125 --remove the old attribute parameters Begin
126 -----------------------------------------------------------------------------
127 p_trx_information,p_excise_inv_gen_status,p_vat_inv_gen_status,p_excise_inv_gen_number,
128 p_vat_inv_gen_number,p_cenvat_costed_flag,
129 -----------------------------------------------------------------------------
130 --Added new parametersby Bo Li for bug9305067
131 --remove the old attribute parameters End
132 lv_creation_date, lv_created_by, lv_last_update_date, lv_last_updated_by, lv_last_update_login,
133 p_destination_type_code, p_assessable_value, p_currency_conversion_rate,
134 p_excise_invoice_no, p_excise_invoice_date, p_tax_amount, 0, p_tax_transaction_id
135 );
136
137 END insert_row;
138
139 PROCEDURE update_row(
140 p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,
141 p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE DEFAULT NULL,
142 p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE DEFAULT NULL,
143 p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE DEFAULT NULL,
144 p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE DEFAULT NULL,
145 p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL,
146 p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE DEFAULT NULL,
147 p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE DEFAULT NULL,
148 p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE DEFAULT NULL,
149 p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE DEFAULT NULL,
150 p_cenvat_amount IN JAI_RCV_TRANSACTIONS.cenvat_amount%TYPE DEFAULT NULL,
151 p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE DEFAULT NULL,
152 p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE DEFAULT NULL,
153 p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE DEFAULT NULL,
154 p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE DEFAULT NULL,
155 p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE DEFAULT NULL,
156 p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE DEFAULT NULL,
157 p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE DEFAULT NULL,
158 p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE DEFAULT NULL,
159 p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_ASSET_INVENTORY%TYPE DEFAULT NULL,
160 p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE DEFAULT NULL,
161 p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE DEFAULT NULL,
162 p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE DEFAULT NULL,
163 p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE DEFAULT NULL,
164 p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE DEFAULT NULL,
165 --Added new parametersby Bo Li for bug9305067
166 --remove the old attribute parameters Begin
167 -----------------------------------------------------------------------------
168 p_trx_information IN JAI_RCV_TRANSACTIONS.TRX_INFORMATION%TYPE,
169 p_excise_inv_gen_status IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_STATUS%TYPE,
170 p_vat_inv_gen_status IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_STATUS%TYPE,
171 p_excise_inv_gen_number IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_NUMBER%TYPE,
172 p_vat_inv_gen_number IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_NUMBER%TYPE,
173 p_cenvat_costed_flag IN JAI_RCV_TRANSACTIONS.CENVAT_COSTED_FLAG%TYPE,
174 -----------------------------------------------------------------------------
175 --Added new parametersby Bo Li for bug9305067
176 --remove the old attribute parameters End
177 p_tax_transaction_id IN JAI_RCV_TRANSACTIONS.tax_transaction_id%TYPE DEFAULT NULL, -- Vijay Shankar for Bug#3940588
178 p_tax_apportion_factor IN JAI_RCV_TRANSACTIONS.tax_apportion_factor%TYPE DEFAULT NULL -- Added by Sanjikum for Bug#4495135
179 ) IS
180
181 lv_last_update_date DATE;
182 lv_last_updated_by NUMBER(15);
183 lv_last_update_login NUMBER(15);
184
185 BEGIN
186
187 lv_last_update_date := SYSDATE;
188 lv_last_updated_by := FND_GLOBAL.user_id;
189 lv_last_update_login := FND_GLOBAL.login_id;
190
191 UPDATE JAI_RCV_TRANSACTIONS SET
195 LOCATION_ID = nvl(P_LOCATION_ID, LOCATION_ID),
192 PARENT_TRANSACTION_TYPE = nvl(P_PARENT_TRANSACTION_TYPE, PARENT_TRANSACTION_TYPE),
193 RECEIPT_NUM = nvl(P_RECEIPT_NUM, RECEIPT_NUM),
194 ORGANIZATION_ID = nvl(P_ORGANIZATION_ID, ORGANIZATION_ID),
196 INVENTORY_ITEM_ID = nvl(P_INVENTORY_ITEM_ID, INVENTORY_ITEM_ID),
197 excise_invoice_no = nvl(p_excise_invoice_no, excise_invoice_no),
198 excise_invoice_date = nvl(p_excise_invoice_date, excise_invoice_date),
199 tax_amount = nvl(p_tax_amount, tax_amount),
200 assessable_value = nvl(p_assessable_value, assessable_value),
201 cenvat_amount = nvl(p_cenvat_amount, cenvat_amount),
202 currency_conversion_rate = nvl(p_currency_conversion_rate, currency_conversion_rate),
203 ITEM_CLASS = nvl(P_ITEM_CLASS, ITEM_CLASS),
204 ITEM_cenvatABLE = nvl(P_ITEM_cenvatABLE, ITEM_cenvatABLE),
205 ITEM_EXCISABLE = nvl(P_ITEM_EXCISABLE, ITEM_EXCISABLE),
206 ITEM_TRADING_FLAG = nvl(P_ITEM_TRADING_FLAG, ITEM_TRADING_FLAG),
207 INV_ITEM_FLAG = nvl(P_INV_ITEM_FLAG, INV_ITEM_FLAG),
208 INV_ASSET_FLAG = nvl(P_INV_ASSET_FLAG, INV_ASSET_FLAG),
209 LOC_SUBINV_TYPE = nvl(P_LOC_SUBINV_TYPE, LOC_SUBINV_TYPE),
210 BASE_ASSET_INVENTORY = nvl(P_BASE_SUBINV_ASSET_FLAG, BASE_ASSET_INVENTORY),
211 ORGANIZATION_TYPE = nvl(P_ORGANIZATION_TYPE, ORGANIZATION_TYPE),
212 EXCISE_IN_TRADING = nvl(P_EXCISE_IN_TRADING, EXCISE_IN_TRADING),
213 COSTING_METHOD = nvl(P_COSTING_METHOD, COSTING_METHOD),
214 BOE_APPLIED_FLAG = nvl(P_BOE_APPLIED_FLAG, BOE_APPLIED_FLAG),
215 THIRD_PARTY_FLAG = nvl(P_THIRD_PARTY_FLAG, THIRD_PARTY_FLAG),
216 --Added new parametersby Bo Li for bug9305067
217 --remove the old attribute parameters Begin
218 -----------------------------------------------------------------------------
219 TRX_INFORMATION = nvl(P_TRX_INFORMATION, TRX_INFORMATION),
220 EXCISE_INV_GEN_STATUS = nvl(P_EXCISE_INV_GEN_STATUS, EXCISE_INV_GEN_STATUS),
221 VAT_INV_GEN_STATUS = nvl(P_VAT_INV_GEN_STATUS, VAT_INV_GEN_STATUS),
222 EXCISE_INV_GEN_NUMBER = nvl(P_EXCISE_INV_GEN_NUMBER, EXCISE_INV_GEN_NUMBER),
223 VAT_INV_GEN_NUMBER = nvl(P_VAT_INV_GEN_NUMBER, VAT_INV_GEN_NUMBER),
224 CENVAT_COSTED_FLAG = nvl(P_CENVAT_COSTED_FLAG, CENVAT_COSTED_FLAG),
225 -----------------------------------------------------------------------------
226 --Added new parametersby Bo Li for bug9305067
227 --remove the old attribute parameters End
228
229 LAST_UPDATE_DATE = lv_last_update_date,
230 LAST_UPDATED_BY = lv_last_updated_by,
231 LAST_UPDATE_LOGIN = lv_last_update_login,
232 tax_transaction_id = nvl(p_tax_transaction_id, tax_transaction_id),
233 tax_apportion_factor = NVL(p_tax_apportion_factor, tax_apportion_factor) --Added by Sanjikum for Bug#4495135
234 WHERE transaction_id = p_transaction_id;
235
236 END update_row;
237
238 PROCEDURE update_process_flags(
239 p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
240 p_process_flag IN JAI_RCV_TRANSACTIONS.PROCESS_STATUS%TYPE ,
241 p_process_message IN JAI_RCV_TRANSACTIONS.PROCESS_MESSAGE%TYPE ,
242 p_cenvat_rg_flag IN JAI_RCV_TRANSACTIONS.CENVAT_RG_STATUS%TYPE ,
243 p_cenvat_claimed_ptg IN JAI_RCV_TRANSACTIONS.CENVAT_claimed_ptg%TYPE DEFAULT NULL ,
244 p_cenvat_rg_message IN JAI_RCV_TRANSACTIONS.CENVAT_RG_MESSAGE%TYPE,
245 p_process_date IN JAI_RCV_TRANSACTIONS.PROCESS_DATE%TYPE,
246 /* following two parameters introduced by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
247 p_process_vat_flag IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_STATUS%TYPE ,
248 p_process_vat_message IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_MESSAGE%TYPE
249 ) IS
250
251 BEGIN
252 UPDATE JAI_RCV_TRANSACTIONS
253 SET
254 PROCESS_STATUS = nvl(p_process_flag, PROCESS_STATUS),
255 process_message = nvl(p_process_message, process_message),
256 CENVAT_RG_STATUS = nvl(p_cenvat_rg_flag, CENVAT_RG_STATUS),
257 cenvat_claimed_ptg= nvl(p_cenvat_claimed_ptg, cenvat_claimed_ptg),
258 cenvat_rg_message = nvl(p_cenvat_rg_message, cenvat_rg_message),
259 process_date = nvl(p_process_date, process_date),
260 /* following two parameters introduced by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
261 PROCESS_VAT_STATUS = nvl(p_process_vat_flag, PROCESS_VAT_STATUS),
262 process_vat_message = nvl(p_process_vat_message, process_vat_message),
263 last_updated_by = fnd_global.user_id,
264 last_update_login = fnd_global.login_id,
265 last_update_date = SYSDATE
266 WHERE transaction_id = p_transaction_id;
267
268 END update_process_flags;
269
270 PROCEDURE update_excise_invoice_no(
271 p_transaction_id IN NUMBER,
272 p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE,
273 p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE
274 ) IS
275
276 BEGIN
277 UPDATE JAI_RCV_TRANSACTIONS
278 SET excise_invoice_no = p_excise_invoice_no,
279 excise_invoice_date = p_excise_invoice_date,
280 last_updated_by = fnd_global.user_id,
281 last_update_login = fnd_global.login_id,
282 last_update_date = SYSDATE
283 WHERE transaction_id = p_transaction_id;
284
285 END update_excise_invoice_no;
286
287 PROCEDURE update_attributes(
288 p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
289 p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
290 p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
294 p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
291 p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
292 p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
293 p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
295 p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
296 p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
297 p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
298 p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
299 p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE DEFAULT NULL
300 ) IS
301
302 BEGIN
303 UPDATE JAI_RCV_TRANSACTIONS SET
304 ATTRIBUTE_CATEGORY = nvl(P_ATTRIBUTE_CATEGORY, ATTRIBUTE_CATEGORY),
305 ATTRIBUTE1 = nvl(P_ATTRIBUTE1, ATTRIBUTE1),
306 ATTRIBUTE2 = nvl(P_ATTRIBUTE2, ATTRIBUTE2),
307 ATTRIBUTE3 = nvl(P_ATTRIBUTE3, ATTRIBUTE3),
308 ATTRIBUTE4 = nvl(P_ATTRIBUTE4, ATTRIBUTE4),
309 ATTRIBUTE5 = nvl(P_ATTRIBUTE5, ATTRIBUTE5),
310 ATTRIBUTE6 = nvl(P_ATTRIBUTE6, ATTRIBUTE6),
311 ATTRIBUTE7 = nvl(P_ATTRIBUTE7, ATTRIBUTE7),
312 ATTRIBUTE8 = nvl(P_ATTRIBUTE8, ATTRIBUTE8),
313 ATTRIBUTE9 = nvl(P_ATTRIBUTE9, ATTRIBUTE9),
314 ATTRIBUTE10 = nvl(P_ATTRIBUTE10, ATTRIBUTE10),
315 LAST_UPDATE_DATE = sysdate,
316 LAST_UPDATED_BY = fnd_global.user_id,
317 LAST_UPDATE_LOGIN = fnd_global.login_id
318 WHERE transaction_id = p_transaction_id;
319
320 END update_attributes;
321
322 --==========================================================================
323 -- PROCEDURE NAME:
324 -- update_inv_stat_and_no Public
325 --
326 -- DESCRIPTION:
327 -- This procedure is written for replace the update_attributes procedure
328 --
329 -- ER NAME/BUG#
330 -- Enable DFF Batch2
331 -- Bug bug9305067
332 --
333 -- PARAMETERS:
334 -- In: p_transaction_id Identifier of transaction
335 -- p_trx_information Trx Information
336 -- p_excise_inv_gen_status Excise invoice generation status
337 -- p_vat_inv_gen_status Vat invoice generation status
338 -- p_excise_inv_gen_number Excise invoice generation number
339 -- p_vat_inv_gen_number Vat invoice generation number
340 --
341 --
342 -- DESIGN REFERENCES:
343 -- TD named "TDD_1213_JAI_Enhanced_DFF.doc"
344 --
345 -- CALL FROM
346 --
347 -- CHANGE HISTORY:
348 -- 15-Apr-2010 Created by Bo Li
349 --==========================================================================
350 PROCEDURE update_inv_stat_and_no (
351 p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
352 p_trx_information IN JAI_RCV_TRANSACTIONS.TRX_INFORMATION%TYPE DEFAULT NULL,
353 p_excise_inv_gen_status IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_STATUS%TYPE DEFAULT NULL,
354 p_vat_inv_gen_status IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_STATUS%TYPE DEFAULT NULL,
355 p_excise_inv_gen_number IN JAI_RCV_TRANSACTIONS.EXCISE_INV_GEN_NUMBER%TYPE DEFAULT NULL,
356 p_vat_inv_gen_number IN JAI_RCV_TRANSACTIONS.VAT_INV_GEN_NUMBER%TYPE DEFAULT NULL
357 ) IS
358
359 BEGIN
360 UPDATE JAI_RCV_TRANSACTIONS
361 SET
362 TRX_INFORMATION = nvl(P_TRX_INFORMATION, TRX_INFORMATION),
363 EXCISE_INV_GEN_STATUS = nvl(P_EXCISE_INV_GEN_STATUS, EXCISE_INV_GEN_STATUS),
364 VAT_INV_GEN_STATUS = nvl(P_VAT_INV_GEN_STATUS, VAT_INV_GEN_STATUS),
365 EXCISE_INV_GEN_NUMBER = nvl(P_EXCISE_INV_GEN_NUMBER, EXCISE_INV_GEN_NUMBER),
366 VAT_INV_GEN_NUMBER = nvl(P_VAT_INV_GEN_NUMBER, VAT_INV_GEN_NUMBER),
367 LAST_UPDATE_DATE = sysdate,
368 LAST_UPDATED_BY = fnd_global.user_id,
369 LAST_UPDATE_LOGIN = fnd_global.login_id
370 WHERE transaction_id = p_transaction_id;
371
372 END update_inv_stat_and_no;
373
374 --==========================================================================
375 -- PROCEDURE NAME:
376 -- update_cenvat_costed_flag Public
377 --
378 -- DESCRIPTION:
379 -- This procedure is written for replace the update_attributes procedure
380 --
381 -- ER NAME/BUG#
382 -- Enable DFF Batch2
383 -- Bug bug9305067
384 --
385 -- PARAMETERS:
386 -- In: p_transaction_id Identifier of transaction
387 -- p_cenvat_costed_flag CENVAT costed Flag
388
389 --
390 --
391 -- DESIGN REFERENCES:
392 -- TD named "TDD_1213_JAI_Enhanced_DFF.doc"
393 --
394 -- CALL FROM
395 --
396 -- CHANGE HISTORY:
397 -- 15-Apr-2010 Created by Bo Li
398 --==========================================================================
399 PROCEDURE update_cenvat_costed_flag (
400 p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
401 p_cenvat_costed_flag IN JAI_RCV_TRANSACTIONS.CENVAT_COSTED_FLAG%TYPE DEFAULT NULL
402 ) IS
403
404 BEGIN
405 UPDATE JAI_RCV_TRANSACTIONS SET
406 CENVAT_COSTED_FLAG = nvl(P_CENVAT_COSTED_FLAG, CENVAT_COSTED_FLAG),
407 LAST_UPDATE_DATE = sysdate,
408 LAST_UPDATED_BY = fnd_global.user_id,
409 LAST_UPDATE_LOGIN = fnd_global.login_id
410 WHERE transaction_id = p_transaction_id;
411
415 END jai_rcv_transactions_pkg;412 END update_cenvat_costed_flag;
413
414