[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 2005/07/20 12:59:18 avallabh 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
29 Dependancy:
30 -----------
31 IN60105D2 + 3496408
32 IN60106 + 3940588 + 4245089
33 ----------------------------------------------------------------------------------------------------------------------------*/
34
35 PROCEDURE insert_row(
36 p_shipment_header_id IN JAI_RCV_TRANSACTIONS.SHIPMENT_HEADER_ID%TYPE,
37 p_shipment_line_id IN JAI_RCV_TRANSACTIONS.SHIPMENT_LINE_ID%TYPE,
38 p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,
39 p_transaction_date IN JAI_RCV_TRANSACTIONS.TRANSACTION_DATE%TYPE,
40 p_transaction_type IN JAI_RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE,
41 p_quantity IN JAI_RCV_TRANSACTIONS.QUANTITY%TYPE,
42 p_uom_code IN JAI_RCV_TRANSACTIONS.UOM_CODE%TYPE,
43 p_parent_transaction_id IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_ID%TYPE,
44 p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE,
45 p_destination_type_code IN JAI_RCV_TRANSACTIONS.destination_type_code%TYPE,
46 p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE,
47 p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE,
48 p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE,
49 p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE,
50 p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE,
51 p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE,
52 p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE,
53 p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE,
54 p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE,
55 p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE,
56 p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE,
57 p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE,
58 p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE,
59 p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE,
60 p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE,
61 p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE,
62 p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_ASSET_INVENTORY%TYPE,
63 p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE,
64 p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE,
65 p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE,
66 p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE,
67 p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE,
68 p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE,
69 p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE,
70 p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE,
71 p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE,
72 p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE,
73 p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE,
74 p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE,
75 p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE,
76 p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE,
77 p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE,
78 p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE,
79 p_tax_transaction_id IN JAI_RCV_TRANSACTIONS.tax_transaction_id%TYPE -- Vijay Shankar for Bug#3940588
80 ) IS
81
82 lv_creation_date DATE;
83 lv_created_by NUMBER(15);
84 lv_last_update_date DATE;
85 lv_last_updated_by NUMBER(15);
86 lv_last_update_login NUMBER(15);
87
88 BEGIN
89
90 lv_creation_date := SYSDATE;
91 lv_created_by := FND_GLOBAL.user_id;
92 lv_last_update_date := SYSDATE;
93 lv_last_updated_by := lv_created_by;
94 lv_last_update_login := FND_GLOBAL.login_id;
95
96 INSERT INTO JAI_RCV_TRANSACTIONS(
97 shipment_header_id, shipment_line_id, transaction_id, transaction_type, quantity, uom_code,
98 transaction_date, parent_transaction_id, parent_transaction_type, receipt_num, organization_id,
99 location_id, inventory_item_id, item_class, item_cenvatable, item_excisable, item_trading_flag,
100 inv_item_flag, inv_asset_flag, loc_subinv_type, BASE_ASSET_INVENTORY, organization_type,
101 excise_in_trading, costing_method, boe_applied_flag, third_party_flag, attribute_category, attribute1,
102 attribute2, attribute3, attribute4, attribute5, attribute6,
103 attribute7, attribute8, attribute9, attribute10,
104 creation_date, created_by, last_update_date, last_updated_by, last_update_login,
105 destination_type_code, assessable_value, currency_conversion_rate,
106 excise_invoice_no, excise_invoice_date, tax_amount, cenvat_claimed_ptg, tax_transaction_id
107 ) VALUES (
108 p_shipment_header_id, p_shipment_line_id, p_transaction_id, p_transaction_type, p_quantity, p_uom_code,
109 p_transaction_date, p_parent_transaction_id, p_parent_transaction_type, p_receipt_num, p_organization_id,
110 p_location_id, p_inventory_item_id, p_item_class, p_item_cenvatable, p_item_excisable, p_item_trading_flag,
111 p_inv_item_flag, p_inv_asset_flag, p_loc_subinv_type, p_base_subinv_asset_flag, p_organization_type,
112 p_excise_in_trading, p_costing_method, p_boe_applied_flag, p_third_party_flag, p_attribute_category,
113 p_attribute1, p_attribute2, p_attribute3, p_attribute4, p_attribute5, p_attribute6,
114 p_attribute7, p_attribute8, p_attribute9, p_attribute10,
115 lv_creation_date, lv_created_by, lv_last_update_date, lv_last_updated_by, lv_last_update_login,
116 p_destination_type_code, p_assessable_value, p_currency_conversion_rate,
117 p_excise_invoice_no, p_excise_invoice_date, p_tax_amount, 0, p_tax_transaction_id
118 );
119
120 END insert_row;
121
122 PROCEDURE update_row(
123 p_transaction_id IN JAI_RCV_TRANSACTIONS.TRANSACTION_ID%TYPE,
124 p_parent_transaction_type IN JAI_RCV_TRANSACTIONS.PARENT_TRANSACTION_TYPE%TYPE DEFAULT NULL,
125 p_receipt_num IN JAI_RCV_TRANSACTIONS.RECEIPT_NUM%TYPE DEFAULT NULL,
126 p_organization_id IN JAI_RCV_TRANSACTIONS.ORGANIZATION_ID%TYPE DEFAULT NULL,
127 p_location_id IN JAI_RCV_TRANSACTIONS.LOCATION_ID%TYPE DEFAULT NULL,
128 p_inventory_item_id IN JAI_RCV_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL,
129 p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE DEFAULT NULL,
130 p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE DEFAULT NULL,
131 p_tax_amount IN JAI_RCV_TRANSACTIONS.tax_amount%TYPE DEFAULT NULL,
132 p_assessable_value IN JAI_RCV_TRANSACTIONS.assessable_value%TYPE DEFAULT NULL,
133 p_cenvat_amount IN JAI_RCV_TRANSACTIONS.cenvat_amount%TYPE DEFAULT NULL,
134 p_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE DEFAULT NULL,
135 p_item_class IN JAI_RCV_TRANSACTIONS.ITEM_CLASS%TYPE DEFAULT NULL,
136 p_item_cenvatable IN JAI_RCV_TRANSACTIONS.ITEM_cenvatABLE%TYPE DEFAULT NULL,
137 p_item_excisable IN JAI_RCV_TRANSACTIONS.ITEM_EXCISABLE%TYPE DEFAULT NULL,
138 p_item_trading_flag IN JAI_RCV_TRANSACTIONS.ITEM_TRADING_FLAG%TYPE DEFAULT NULL,
139 p_inv_item_flag IN JAI_RCV_TRANSACTIONS.INV_ITEM_FLAG%TYPE DEFAULT NULL,
140 p_inv_asset_flag IN JAI_RCV_TRANSACTIONS.INV_ASSET_FLAG%TYPE DEFAULT NULL,
141 p_loc_subinv_type IN JAI_RCV_TRANSACTIONS.LOC_SUBINV_TYPE%TYPE DEFAULT NULL,
142 p_base_subinv_asset_flag IN JAI_RCV_TRANSACTIONS.BASE_ASSET_INVENTORY%TYPE DEFAULT NULL,
143 p_organization_type IN JAI_RCV_TRANSACTIONS.ORGANIZATION_TYPE%TYPE DEFAULT NULL,
144 p_excise_in_trading IN JAI_RCV_TRANSACTIONS.EXCISE_IN_TRADING%TYPE DEFAULT NULL,
145 p_costing_method IN JAI_RCV_TRANSACTIONS.COSTING_METHOD%TYPE DEFAULT NULL,
146 p_boe_applied_flag IN JAI_RCV_TRANSACTIONS.BOE_APPLIED_FLAG%TYPE DEFAULT NULL,
147 p_third_party_flag IN JAI_RCV_TRANSACTIONS.THIRD_PARTY_FLAG%TYPE DEFAULT NULL,
148 p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
149 p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
150 p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
151 p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
152 p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
153 p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
154 p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
155 p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
156 p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
157 p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
158 p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE DEFAULT NULL,
159 p_tax_transaction_id IN JAI_RCV_TRANSACTIONS.tax_transaction_id%TYPE DEFAULT NULL, -- Vijay Shankar for Bug#3940588
160 p_tax_apportion_factor IN JAI_RCV_TRANSACTIONS.tax_apportion_factor%TYPE DEFAULT NULL -- Added by Sanjikum for Bug#4495135
161 ) IS
162
163 lv_last_update_date DATE;
164 lv_last_updated_by NUMBER(15);
165 lv_last_update_login NUMBER(15);
166
167 BEGIN
168
169 lv_last_update_date := SYSDATE;
170 lv_last_updated_by := FND_GLOBAL.user_id;
171 lv_last_update_login := FND_GLOBAL.login_id;
172
173 UPDATE JAI_RCV_TRANSACTIONS SET
174 PARENT_TRANSACTION_TYPE = nvl(P_PARENT_TRANSACTION_TYPE, PARENT_TRANSACTION_TYPE),
175 RECEIPT_NUM = nvl(P_RECEIPT_NUM, RECEIPT_NUM),
176 ORGANIZATION_ID = nvl(P_ORGANIZATION_ID, ORGANIZATION_ID),
177 LOCATION_ID = nvl(P_LOCATION_ID, LOCATION_ID),
178 INVENTORY_ITEM_ID = nvl(P_INVENTORY_ITEM_ID, INVENTORY_ITEM_ID),
179 excise_invoice_no = nvl(p_excise_invoice_no, excise_invoice_no),
180 excise_invoice_date = nvl(p_excise_invoice_date, excise_invoice_date),
181 tax_amount = nvl(p_tax_amount, tax_amount),
182 assessable_value = nvl(p_assessable_value, assessable_value),
183 cenvat_amount = nvl(p_cenvat_amount, cenvat_amount),
187 ITEM_EXCISABLE = nvl(P_ITEM_EXCISABLE, ITEM_EXCISABLE),
184 currency_conversion_rate = nvl(p_currency_conversion_rate, currency_conversion_rate),
185 ITEM_CLASS = nvl(P_ITEM_CLASS, ITEM_CLASS),
186 ITEM_cenvatABLE = nvl(P_ITEM_cenvatABLE, ITEM_cenvatABLE),
188 ITEM_TRADING_FLAG = nvl(P_ITEM_TRADING_FLAG, ITEM_TRADING_FLAG),
189 INV_ITEM_FLAG = nvl(P_INV_ITEM_FLAG, INV_ITEM_FLAG),
190 INV_ASSET_FLAG = nvl(P_INV_ASSET_FLAG, INV_ASSET_FLAG),
191 LOC_SUBINV_TYPE = nvl(P_LOC_SUBINV_TYPE, LOC_SUBINV_TYPE),
192 BASE_ASSET_INVENTORY = nvl(P_BASE_SUBINV_ASSET_FLAG, BASE_ASSET_INVENTORY),
193 ORGANIZATION_TYPE = nvl(P_ORGANIZATION_TYPE, ORGANIZATION_TYPE),
194 EXCISE_IN_TRADING = nvl(P_EXCISE_IN_TRADING, EXCISE_IN_TRADING),
195 COSTING_METHOD = nvl(P_COSTING_METHOD, COSTING_METHOD),
196 BOE_APPLIED_FLAG = nvl(P_BOE_APPLIED_FLAG, BOE_APPLIED_FLAG),
197 THIRD_PARTY_FLAG = nvl(P_THIRD_PARTY_FLAG, THIRD_PARTY_FLAG),
198 ATTRIBUTE_CATEGORY = nvl(P_ATTRIBUTE_CATEGORY, ATTRIBUTE_CATEGORY),
199 ATTRIBUTE1 = nvl(P_ATTRIBUTE1, ATTRIBUTE1),
200 ATTRIBUTE2 = nvl(P_ATTRIBUTE2, ATTRIBUTE2),
201 ATTRIBUTE3 = nvl(P_ATTRIBUTE3, ATTRIBUTE3),
202 ATTRIBUTE4 = nvl(P_ATTRIBUTE4, ATTRIBUTE4),
203 ATTRIBUTE5 = nvl(P_ATTRIBUTE5, ATTRIBUTE5),
204 ATTRIBUTE6 = nvl(P_ATTRIBUTE6, ATTRIBUTE6),
205 ATTRIBUTE7 = nvl(P_ATTRIBUTE7, ATTRIBUTE7),
206 ATTRIBUTE8 = nvl(P_ATTRIBUTE8, ATTRIBUTE8),
207 ATTRIBUTE9 = nvl(P_ATTRIBUTE9, ATTRIBUTE9),
208 ATTRIBUTE10 = nvl(P_ATTRIBUTE10, ATTRIBUTE10),
209 LAST_UPDATE_DATE = lv_last_update_date,
210 LAST_UPDATED_BY = lv_last_updated_by,
211 LAST_UPDATE_LOGIN = lv_last_update_login,
212 tax_transaction_id = nvl(p_tax_transaction_id, tax_transaction_id),
213 tax_apportion_factor = NVL(p_tax_apportion_factor, tax_apportion_factor) --Added by Sanjikum for Bug#4495135
214 WHERE transaction_id = p_transaction_id;
215
216 END update_row;
217
218 PROCEDURE update_process_flags(
219 p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
220 p_process_flag IN JAI_RCV_TRANSACTIONS.PROCESS_STATUS%TYPE ,
221 p_process_message IN JAI_RCV_TRANSACTIONS.PROCESS_MESSAGE%TYPE ,
222 p_cenvat_rg_flag IN JAI_RCV_TRANSACTIONS.CENVAT_RG_STATUS%TYPE ,
223 p_cenvat_claimed_ptg IN JAI_RCV_TRANSACTIONS.CENVAT_claimed_ptg%TYPE DEFAULT NULL ,
224 p_cenvat_rg_message IN JAI_RCV_TRANSACTIONS.CENVAT_RG_MESSAGE%TYPE,
225 p_process_date IN JAI_RCV_TRANSACTIONS.PROCESS_DATE%TYPE,
226 /* following two parameters introduced by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
227 p_process_vat_flag IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_STATUS%TYPE ,
228 p_process_vat_message IN JAI_RCV_TRANSACTIONS.PROCESS_VAT_MESSAGE%TYPE
229 ) IS
230
231 BEGIN
232 UPDATE JAI_RCV_TRANSACTIONS
233 SET
234 PROCESS_STATUS = nvl(p_process_flag, PROCESS_STATUS),
235 process_message = nvl(p_process_message, process_message),
236 CENVAT_RG_STATUS = nvl(p_cenvat_rg_flag, CENVAT_RG_STATUS),
237 cenvat_claimed_ptg= nvl(p_cenvat_claimed_ptg, cenvat_claimed_ptg),
238 cenvat_rg_message = nvl(p_cenvat_rg_message, cenvat_rg_message),
239 process_date = nvl(p_process_date, process_date),
240 /* following two parameters introduced by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
241 PROCESS_VAT_STATUS = nvl(p_process_vat_flag, PROCESS_VAT_STATUS),
242 process_vat_message = nvl(p_process_vat_message, process_vat_message),
243 last_updated_by = fnd_global.user_id,
244 last_update_login = fnd_global.login_id,
245 last_update_date = SYSDATE
246 WHERE transaction_id = p_transaction_id;
247
248 END update_process_flags;
249
250 PROCEDURE update_excise_invoice_no(
251 p_transaction_id IN NUMBER,
252 p_excise_invoice_no IN JAI_RCV_TRANSACTIONS.excise_invoice_no%TYPE,
253 p_excise_invoice_date IN JAI_RCV_TRANSACTIONS.excise_invoice_date%TYPE
254 ) IS
255
256 BEGIN
257 UPDATE JAI_RCV_TRANSACTIONS
258 SET excise_invoice_no = p_excise_invoice_no,
259 excise_invoice_date = p_excise_invoice_date,
260 last_updated_by = fnd_global.user_id,
261 last_update_login = fnd_global.login_id,
262 last_update_date = SYSDATE
263 WHERE transaction_id = p_transaction_id;
264
265 END update_excise_invoice_no;
266
267 PROCEDURE update_attributes(
268 p_transaction_id IN JAI_RCV_TRANSACTIONS.transaction_id%TYPE,
269 p_attribute_category IN JAI_RCV_TRANSACTIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
270 p_attribute1 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
271 p_attribute2 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
272 p_attribute3 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
273 p_attribute4 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
274 p_attribute5 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
275 p_attribute6 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
276 p_attribute7 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
277 p_attribute8 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
278 p_attribute9 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
279 p_attribute10 IN JAI_RCV_TRANSACTIONS.ATTRIBUTE10%TYPE DEFAULT NULL
280 ) IS
281
282 BEGIN
283 UPDATE JAI_RCV_TRANSACTIONS SET
284 ATTRIBUTE_CATEGORY = nvl(P_ATTRIBUTE_CATEGORY, ATTRIBUTE_CATEGORY),
285 ATTRIBUTE1 = nvl(P_ATTRIBUTE1, ATTRIBUTE1),
286 ATTRIBUTE2 = nvl(P_ATTRIBUTE2, ATTRIBUTE2),
287 ATTRIBUTE3 = nvl(P_ATTRIBUTE3, ATTRIBUTE3),
288 ATTRIBUTE4 = nvl(P_ATTRIBUTE4, ATTRIBUTE4),
289 ATTRIBUTE5 = nvl(P_ATTRIBUTE5, ATTRIBUTE5),
290 ATTRIBUTE6 = nvl(P_ATTRIBUTE6, ATTRIBUTE6),
291 ATTRIBUTE7 = nvl(P_ATTRIBUTE7, ATTRIBUTE7),
292 ATTRIBUTE8 = nvl(P_ATTRIBUTE8, ATTRIBUTE8),
293 ATTRIBUTE9 = nvl(P_ATTRIBUTE9, ATTRIBUTE9),
294 ATTRIBUTE10 = nvl(P_ATTRIBUTE10, ATTRIBUTE10),
295 LAST_UPDATE_DATE = sysdate,
296 LAST_UPDATED_BY = fnd_global.user_id,
297 LAST_UPDATE_LOGIN = fnd_global.login_id
298 WHERE transaction_id = p_transaction_id;
299
300 END update_attributes;
301
302 END jai_rcv_transactions_pkg;