88: x_created_by NUMBER)
89: IS
90: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Record';
91: l_loading_status VARCHAR2(30) := 'CN_INSERTED';
92: l_return_status VARCHAR2(30) := FND_API.G_RET_STS_SUCCESS;
93: BEGIN
94: --dbms_output.put_line('before get UID ');
95: -- Get Unique ID for posting detail
96: Get_UID( x_posting_detail_id );
169: x_commission_header_id,
170: x_commission_line_id,
171: x_srp_plan_assign_id,
172: x_quota_id,
173: decode(x_status, FND_API.G_MISS_CHAR, 'UNLOADED', x_status),
174: decode(x_loaded_date, FND_API.G_MISS_CHAR, null, x_loaded_date),
175: x_processed_date,
176: x_credited_salesrep_id,
177: x_processed_period_id,
170: x_commission_line_id,
171: x_srp_plan_assign_id,
172: x_quota_id,
173: decode(x_status, FND_API.G_MISS_CHAR, 'UNLOADED', x_status),
174: decode(x_loaded_date, FND_API.G_MISS_CHAR, null, x_loaded_date),
175: x_processed_date,
176: x_credited_salesrep_id,
177: x_processed_period_id,
178: x_quota_rule_id,
185: x_payee_line_id,
186: x_cl_status,
187: x_created_during,
188: x_commission_rate,
189: decode(x_hold_flag, FND_API.G_MISS_CHAR, 'N', x_hold_flag),
190: decode(x_paid_flag, FND_API.G_MISS_CHAR, 'N', x_paid_flag),
191: decode(x_payment_amount, FND_API.G_MISS_NUM, x_amount, x_payment_amount),
192: decode(x_attribute_category, FND_API.G_MISS_CHAR, null, x_attribute_category),
193: decode(x_attribute1, FND_API.G_MISS_CHAR, null, x_attribute1),
186: x_cl_status,
187: x_created_during,
188: x_commission_rate,
189: decode(x_hold_flag, FND_API.G_MISS_CHAR, 'N', x_hold_flag),
190: decode(x_paid_flag, FND_API.G_MISS_CHAR, 'N', x_paid_flag),
191: decode(x_payment_amount, FND_API.G_MISS_NUM, x_amount, x_payment_amount),
192: decode(x_attribute_category, FND_API.G_MISS_CHAR, null, x_attribute_category),
193: decode(x_attribute1, FND_API.G_MISS_CHAR, null, x_attribute1),
194: decode(x_attribute2, FND_API.G_MISS_CHAR, null, x_attribute2),
187: x_created_during,
188: x_commission_rate,
189: decode(x_hold_flag, FND_API.G_MISS_CHAR, 'N', x_hold_flag),
190: decode(x_paid_flag, FND_API.G_MISS_CHAR, 'N', x_paid_flag),
191: decode(x_payment_amount, FND_API.G_MISS_NUM, x_amount, x_payment_amount),
192: decode(x_attribute_category, FND_API.G_MISS_CHAR, null, x_attribute_category),
193: decode(x_attribute1, FND_API.G_MISS_CHAR, null, x_attribute1),
194: decode(x_attribute2, FND_API.G_MISS_CHAR, null, x_attribute2),
195: decode(x_attribute3, FND_API.G_MISS_CHAR, null, x_attribute3),
188: x_commission_rate,
189: decode(x_hold_flag, FND_API.G_MISS_CHAR, 'N', x_hold_flag),
190: decode(x_paid_flag, FND_API.G_MISS_CHAR, 'N', x_paid_flag),
191: decode(x_payment_amount, FND_API.G_MISS_NUM, x_amount, x_payment_amount),
192: decode(x_attribute_category, FND_API.G_MISS_CHAR, null, x_attribute_category),
193: decode(x_attribute1, FND_API.G_MISS_CHAR, null, x_attribute1),
194: decode(x_attribute2, FND_API.G_MISS_CHAR, null, x_attribute2),
195: decode(x_attribute3, FND_API.G_MISS_CHAR, null, x_attribute3),
196: decode(x_attribute4, FND_API.G_MISS_CHAR, null, x_attribute4),
189: decode(x_hold_flag, FND_API.G_MISS_CHAR, 'N', x_hold_flag),
190: decode(x_paid_flag, FND_API.G_MISS_CHAR, 'N', x_paid_flag),
191: decode(x_payment_amount, FND_API.G_MISS_NUM, x_amount, x_payment_amount),
192: decode(x_attribute_category, FND_API.G_MISS_CHAR, null, x_attribute_category),
193: decode(x_attribute1, FND_API.G_MISS_CHAR, null, x_attribute1),
194: decode(x_attribute2, FND_API.G_MISS_CHAR, null, x_attribute2),
195: decode(x_attribute3, FND_API.G_MISS_CHAR, null, x_attribute3),
196: decode(x_attribute4, FND_API.G_MISS_CHAR, null, x_attribute4),
197: decode(x_attribute5, FND_API.G_MISS_CHAR, null, x_attribute5),
190: decode(x_paid_flag, FND_API.G_MISS_CHAR, 'N', x_paid_flag),
191: decode(x_payment_amount, FND_API.G_MISS_NUM, x_amount, x_payment_amount),
192: decode(x_attribute_category, FND_API.G_MISS_CHAR, null, x_attribute_category),
193: decode(x_attribute1, FND_API.G_MISS_CHAR, null, x_attribute1),
194: decode(x_attribute2, FND_API.G_MISS_CHAR, null, x_attribute2),
195: decode(x_attribute3, FND_API.G_MISS_CHAR, null, x_attribute3),
196: decode(x_attribute4, FND_API.G_MISS_CHAR, null, x_attribute4),
197: decode(x_attribute5, FND_API.G_MISS_CHAR, null, x_attribute5),
198: decode(x_attribute6, FND_API.G_MISS_CHAR, null, x_attribute6),
191: decode(x_payment_amount, FND_API.G_MISS_NUM, x_amount, x_payment_amount),
192: decode(x_attribute_category, FND_API.G_MISS_CHAR, null, x_attribute_category),
193: decode(x_attribute1, FND_API.G_MISS_CHAR, null, x_attribute1),
194: decode(x_attribute2, FND_API.G_MISS_CHAR, null, x_attribute2),
195: decode(x_attribute3, FND_API.G_MISS_CHAR, null, x_attribute3),
196: decode(x_attribute4, FND_API.G_MISS_CHAR, null, x_attribute4),
197: decode(x_attribute5, FND_API.G_MISS_CHAR, null, x_attribute5),
198: decode(x_attribute6, FND_API.G_MISS_CHAR, null, x_attribute6),
199: decode(x_attribute7, FND_API.G_MISS_CHAR, null, x_attribute7),
192: decode(x_attribute_category, FND_API.G_MISS_CHAR, null, x_attribute_category),
193: decode(x_attribute1, FND_API.G_MISS_CHAR, null, x_attribute1),
194: decode(x_attribute2, FND_API.G_MISS_CHAR, null, x_attribute2),
195: decode(x_attribute3, FND_API.G_MISS_CHAR, null, x_attribute3),
196: decode(x_attribute4, FND_API.G_MISS_CHAR, null, x_attribute4),
197: decode(x_attribute5, FND_API.G_MISS_CHAR, null, x_attribute5),
198: decode(x_attribute6, FND_API.G_MISS_CHAR, null, x_attribute6),
199: decode(x_attribute7, FND_API.G_MISS_CHAR, null, x_attribute7),
200: decode(x_attribute8, FND_API.G_MISS_CHAR, null, x_attribute8),
193: decode(x_attribute1, FND_API.G_MISS_CHAR, null, x_attribute1),
194: decode(x_attribute2, FND_API.G_MISS_CHAR, null, x_attribute2),
195: decode(x_attribute3, FND_API.G_MISS_CHAR, null, x_attribute3),
196: decode(x_attribute4, FND_API.G_MISS_CHAR, null, x_attribute4),
197: decode(x_attribute5, FND_API.G_MISS_CHAR, null, x_attribute5),
198: decode(x_attribute6, FND_API.G_MISS_CHAR, null, x_attribute6),
199: decode(x_attribute7, FND_API.G_MISS_CHAR, null, x_attribute7),
200: decode(x_attribute8, FND_API.G_MISS_CHAR, null, x_attribute8),
201: decode(x_attribute9, FND_API.G_MISS_CHAR, null, x_attribute9),
194: decode(x_attribute2, FND_API.G_MISS_CHAR, null, x_attribute2),
195: decode(x_attribute3, FND_API.G_MISS_CHAR, null, x_attribute3),
196: decode(x_attribute4, FND_API.G_MISS_CHAR, null, x_attribute4),
197: decode(x_attribute5, FND_API.G_MISS_CHAR, null, x_attribute5),
198: decode(x_attribute6, FND_API.G_MISS_CHAR, null, x_attribute6),
199: decode(x_attribute7, FND_API.G_MISS_CHAR, null, x_attribute7),
200: decode(x_attribute8, FND_API.G_MISS_CHAR, null, x_attribute8),
201: decode(x_attribute9, FND_API.G_MISS_CHAR, null, x_attribute9),
202: decode(x_attribute10, FND_API.G_MISS_CHAR, null, x_attribute10),
195: decode(x_attribute3, FND_API.G_MISS_CHAR, null, x_attribute3),
196: decode(x_attribute4, FND_API.G_MISS_CHAR, null, x_attribute4),
197: decode(x_attribute5, FND_API.G_MISS_CHAR, null, x_attribute5),
198: decode(x_attribute6, FND_API.G_MISS_CHAR, null, x_attribute6),
199: decode(x_attribute7, FND_API.G_MISS_CHAR, null, x_attribute7),
200: decode(x_attribute8, FND_API.G_MISS_CHAR, null, x_attribute8),
201: decode(x_attribute9, FND_API.G_MISS_CHAR, null, x_attribute9),
202: decode(x_attribute10, FND_API.G_MISS_CHAR, null, x_attribute10),
203: decode(x_attribute11, FND_API.G_MISS_CHAR, null, x_attribute11),
196: decode(x_attribute4, FND_API.G_MISS_CHAR, null, x_attribute4),
197: decode(x_attribute5, FND_API.G_MISS_CHAR, null, x_attribute5),
198: decode(x_attribute6, FND_API.G_MISS_CHAR, null, x_attribute6),
199: decode(x_attribute7, FND_API.G_MISS_CHAR, null, x_attribute7),
200: decode(x_attribute8, FND_API.G_MISS_CHAR, null, x_attribute8),
201: decode(x_attribute9, FND_API.G_MISS_CHAR, null, x_attribute9),
202: decode(x_attribute10, FND_API.G_MISS_CHAR, null, x_attribute10),
203: decode(x_attribute11, FND_API.G_MISS_CHAR, null, x_attribute11),
204: decode(x_attribute12, FND_API.G_MISS_CHAR, null, x_attribute12),
197: decode(x_attribute5, FND_API.G_MISS_CHAR, null, x_attribute5),
198: decode(x_attribute6, FND_API.G_MISS_CHAR, null, x_attribute6),
199: decode(x_attribute7, FND_API.G_MISS_CHAR, null, x_attribute7),
200: decode(x_attribute8, FND_API.G_MISS_CHAR, null, x_attribute8),
201: decode(x_attribute9, FND_API.G_MISS_CHAR, null, x_attribute9),
202: decode(x_attribute10, FND_API.G_MISS_CHAR, null, x_attribute10),
203: decode(x_attribute11, FND_API.G_MISS_CHAR, null, x_attribute11),
204: decode(x_attribute12, FND_API.G_MISS_CHAR, null, x_attribute12),
205: decode(x_attribute13, FND_API.G_MISS_CHAR, null, x_attribute13),
198: decode(x_attribute6, FND_API.G_MISS_CHAR, null, x_attribute6),
199: decode(x_attribute7, FND_API.G_MISS_CHAR, null, x_attribute7),
200: decode(x_attribute8, FND_API.G_MISS_CHAR, null, x_attribute8),
201: decode(x_attribute9, FND_API.G_MISS_CHAR, null, x_attribute9),
202: decode(x_attribute10, FND_API.G_MISS_CHAR, null, x_attribute10),
203: decode(x_attribute11, FND_API.G_MISS_CHAR, null, x_attribute11),
204: decode(x_attribute12, FND_API.G_MISS_CHAR, null, x_attribute12),
205: decode(x_attribute13, FND_API.G_MISS_CHAR, null, x_attribute13),
206: decode(x_attribute14, FND_API.G_MISS_CHAR, null, x_attribute14),
199: decode(x_attribute7, FND_API.G_MISS_CHAR, null, x_attribute7),
200: decode(x_attribute8, FND_API.G_MISS_CHAR, null, x_attribute8),
201: decode(x_attribute9, FND_API.G_MISS_CHAR, null, x_attribute9),
202: decode(x_attribute10, FND_API.G_MISS_CHAR, null, x_attribute10),
203: decode(x_attribute11, FND_API.G_MISS_CHAR, null, x_attribute11),
204: decode(x_attribute12, FND_API.G_MISS_CHAR, null, x_attribute12),
205: decode(x_attribute13, FND_API.G_MISS_CHAR, null, x_attribute13),
206: decode(x_attribute14, FND_API.G_MISS_CHAR, null, x_attribute14),
207: decode(x_attribute15, FND_API.G_MISS_CHAR, null, x_attribute15),
200: decode(x_attribute8, FND_API.G_MISS_CHAR, null, x_attribute8),
201: decode(x_attribute9, FND_API.G_MISS_CHAR, null, x_attribute9),
202: decode(x_attribute10, FND_API.G_MISS_CHAR, null, x_attribute10),
203: decode(x_attribute11, FND_API.G_MISS_CHAR, null, x_attribute11),
204: decode(x_attribute12, FND_API.G_MISS_CHAR, null, x_attribute12),
205: decode(x_attribute13, FND_API.G_MISS_CHAR, null, x_attribute13),
206: decode(x_attribute14, FND_API.G_MISS_CHAR, null, x_attribute14),
207: decode(x_attribute15, FND_API.G_MISS_CHAR, null, x_attribute15),
208: G_LAST_UPDATE_DATE,
201: decode(x_attribute9, FND_API.G_MISS_CHAR, null, x_attribute9),
202: decode(x_attribute10, FND_API.G_MISS_CHAR, null, x_attribute10),
203: decode(x_attribute11, FND_API.G_MISS_CHAR, null, x_attribute11),
204: decode(x_attribute12, FND_API.G_MISS_CHAR, null, x_attribute12),
205: decode(x_attribute13, FND_API.G_MISS_CHAR, null, x_attribute13),
206: decode(x_attribute14, FND_API.G_MISS_CHAR, null, x_attribute14),
207: decode(x_attribute15, FND_API.G_MISS_CHAR, null, x_attribute15),
208: G_LAST_UPDATE_DATE,
209: G_LAST_UPDATED_BY,
202: decode(x_attribute10, FND_API.G_MISS_CHAR, null, x_attribute10),
203: decode(x_attribute11, FND_API.G_MISS_CHAR, null, x_attribute11),
204: decode(x_attribute12, FND_API.G_MISS_CHAR, null, x_attribute12),
205: decode(x_attribute13, FND_API.G_MISS_CHAR, null, x_attribute13),
206: decode(x_attribute14, FND_API.G_MISS_CHAR, null, x_attribute14),
207: decode(x_attribute15, FND_API.G_MISS_CHAR, null, x_attribute15),
208: G_LAST_UPDATE_DATE,
209: G_LAST_UPDATED_BY,
210: G_LAST_UPDATE_LOGIN,
203: decode(x_attribute11, FND_API.G_MISS_CHAR, null, x_attribute11),
204: decode(x_attribute12, FND_API.G_MISS_CHAR, null, x_attribute12),
205: decode(x_attribute13, FND_API.G_MISS_CHAR, null, x_attribute13),
206: decode(x_attribute14, FND_API.G_MISS_CHAR, null, x_attribute14),
207: decode(x_attribute15, FND_API.G_MISS_CHAR, null, x_attribute15),
208: G_LAST_UPDATE_DATE,
209: G_LAST_UPDATED_BY,
210: G_LAST_UPDATE_LOGIN,
211: G_CREATION_DATE,
297: fetch c into l_oldrec;
298: close c;
299:
300: UPDATE cn_posting_details SET
301: status = decode(x_status, FND_API.G_MISS_CHAR,
302: l_oldrec.status, x_status),
303: loaded_date = decode(x_loaded_date, FND_API.G_MISS_DATE,
304: l_oldrec.loaded_date, x_loaded_date),
305: attribute_category = decode(x_attribute_category,
299:
300: UPDATE cn_posting_details SET
301: status = decode(x_status, FND_API.G_MISS_CHAR,
302: l_oldrec.status, x_status),
303: loaded_date = decode(x_loaded_date, FND_API.G_MISS_DATE,
304: l_oldrec.loaded_date, x_loaded_date),
305: attribute_category = decode(x_attribute_category,
306: FND_API.G_MISS_CHAR,
307: l_oldrec.attribute_category,
302: l_oldrec.status, x_status),
303: loaded_date = decode(x_loaded_date, FND_API.G_MISS_DATE,
304: l_oldrec.loaded_date, x_loaded_date),
305: attribute_category = decode(x_attribute_category,
306: FND_API.G_MISS_CHAR,
307: l_oldrec.attribute_category,
308: x_attribute_category),
309: attribute1 = decode(x_attribute1, FND_API.G_MISS_CHAR,
310: l_oldrec.attribute1, x_attribute1),
305: attribute_category = decode(x_attribute_category,
306: FND_API.G_MISS_CHAR,
307: l_oldrec.attribute_category,
308: x_attribute_category),
309: attribute1 = decode(x_attribute1, FND_API.G_MISS_CHAR,
310: l_oldrec.attribute1, x_attribute1),
311: attribute2 = decode(x_attribute2, FND_API.G_MISS_CHAR,
312: l_oldrec.attribute2, x_attribute2),
313: attribute3 = decode(x_attribute3, FND_API.G_MISS_CHAR,
307: l_oldrec.attribute_category,
308: x_attribute_category),
309: attribute1 = decode(x_attribute1, FND_API.G_MISS_CHAR,
310: l_oldrec.attribute1, x_attribute1),
311: attribute2 = decode(x_attribute2, FND_API.G_MISS_CHAR,
312: l_oldrec.attribute2, x_attribute2),
313: attribute3 = decode(x_attribute3, FND_API.G_MISS_CHAR,
314: l_oldrec.attribute3, x_attribute3),
315: attribute4 = decode(x_attribute4, FND_API.G_MISS_CHAR,
309: attribute1 = decode(x_attribute1, FND_API.G_MISS_CHAR,
310: l_oldrec.attribute1, x_attribute1),
311: attribute2 = decode(x_attribute2, FND_API.G_MISS_CHAR,
312: l_oldrec.attribute2, x_attribute2),
313: attribute3 = decode(x_attribute3, FND_API.G_MISS_CHAR,
314: l_oldrec.attribute3, x_attribute3),
315: attribute4 = decode(x_attribute4, FND_API.G_MISS_CHAR,
316: l_oldrec.attribute4, x_attribute4),
317: attribute5 = decode(x_attribute5, FND_API.G_MISS_CHAR,
311: attribute2 = decode(x_attribute2, FND_API.G_MISS_CHAR,
312: l_oldrec.attribute2, x_attribute2),
313: attribute3 = decode(x_attribute3, FND_API.G_MISS_CHAR,
314: l_oldrec.attribute3, x_attribute3),
315: attribute4 = decode(x_attribute4, FND_API.G_MISS_CHAR,
316: l_oldrec.attribute4, x_attribute4),
317: attribute5 = decode(x_attribute5, FND_API.G_MISS_CHAR,
318: l_oldrec.attribute5, x_attribute5),
319: attribute6 = decode(x_attribute6, FND_API.G_MISS_CHAR,
313: attribute3 = decode(x_attribute3, FND_API.G_MISS_CHAR,
314: l_oldrec.attribute3, x_attribute3),
315: attribute4 = decode(x_attribute4, FND_API.G_MISS_CHAR,
316: l_oldrec.attribute4, x_attribute4),
317: attribute5 = decode(x_attribute5, FND_API.G_MISS_CHAR,
318: l_oldrec.attribute5, x_attribute5),
319: attribute6 = decode(x_attribute6, FND_API.G_MISS_CHAR,
320: l_oldrec.attribute6, x_attribute6),
321: attribute7 = decode(x_attribute7, FND_API.G_MISS_CHAR,
315: attribute4 = decode(x_attribute4, FND_API.G_MISS_CHAR,
316: l_oldrec.attribute4, x_attribute4),
317: attribute5 = decode(x_attribute5, FND_API.G_MISS_CHAR,
318: l_oldrec.attribute5, x_attribute5),
319: attribute6 = decode(x_attribute6, FND_API.G_MISS_CHAR,
320: l_oldrec.attribute6, x_attribute6),
321: attribute7 = decode(x_attribute7, FND_API.G_MISS_CHAR,
322: l_oldrec.attribute7, x_attribute7),
323: attribute8 = decode(x_attribute8, FND_API.G_MISS_CHAR,
317: attribute5 = decode(x_attribute5, FND_API.G_MISS_CHAR,
318: l_oldrec.attribute5, x_attribute5),
319: attribute6 = decode(x_attribute6, FND_API.G_MISS_CHAR,
320: l_oldrec.attribute6, x_attribute6),
321: attribute7 = decode(x_attribute7, FND_API.G_MISS_CHAR,
322: l_oldrec.attribute7, x_attribute7),
323: attribute8 = decode(x_attribute8, FND_API.G_MISS_CHAR,
324: l_oldrec.attribute8, x_attribute8),
325: attribute9 = decode(x_attribute9, FND_API.G_MISS_CHAR,
319: attribute6 = decode(x_attribute6, FND_API.G_MISS_CHAR,
320: l_oldrec.attribute6, x_attribute6),
321: attribute7 = decode(x_attribute7, FND_API.G_MISS_CHAR,
322: l_oldrec.attribute7, x_attribute7),
323: attribute8 = decode(x_attribute8, FND_API.G_MISS_CHAR,
324: l_oldrec.attribute8, x_attribute8),
325: attribute9 = decode(x_attribute9, FND_API.G_MISS_CHAR,
326: l_oldrec.attribute9, x_attribute9),
327: attribute10 = decode(x_attribute10, FND_API.G_MISS_CHAR,
321: attribute7 = decode(x_attribute7, FND_API.G_MISS_CHAR,
322: l_oldrec.attribute7, x_attribute7),
323: attribute8 = decode(x_attribute8, FND_API.G_MISS_CHAR,
324: l_oldrec.attribute8, x_attribute8),
325: attribute9 = decode(x_attribute9, FND_API.G_MISS_CHAR,
326: l_oldrec.attribute9, x_attribute9),
327: attribute10 = decode(x_attribute10, FND_API.G_MISS_CHAR,
328: l_oldrec.attribute10, x_attribute10),
329: attribute11 = decode(x_attribute11, FND_API.G_MISS_CHAR,
323: attribute8 = decode(x_attribute8, FND_API.G_MISS_CHAR,
324: l_oldrec.attribute8, x_attribute8),
325: attribute9 = decode(x_attribute9, FND_API.G_MISS_CHAR,
326: l_oldrec.attribute9, x_attribute9),
327: attribute10 = decode(x_attribute10, FND_API.G_MISS_CHAR,
328: l_oldrec.attribute10, x_attribute10),
329: attribute11 = decode(x_attribute11, FND_API.G_MISS_CHAR,
330: l_oldrec.attribute11, x_attribute11),
331: attribute12 = decode(x_attribute12, FND_API.G_MISS_CHAR,
325: attribute9 = decode(x_attribute9, FND_API.G_MISS_CHAR,
326: l_oldrec.attribute9, x_attribute9),
327: attribute10 = decode(x_attribute10, FND_API.G_MISS_CHAR,
328: l_oldrec.attribute10, x_attribute10),
329: attribute11 = decode(x_attribute11, FND_API.G_MISS_CHAR,
330: l_oldrec.attribute11, x_attribute11),
331: attribute12 = decode(x_attribute12, FND_API.G_MISS_CHAR,
332: l_oldrec.attribute12, x_attribute12),
333: attribute13 = decode(x_attribute13, FND_API.G_MISS_CHAR,
327: attribute10 = decode(x_attribute10, FND_API.G_MISS_CHAR,
328: l_oldrec.attribute10, x_attribute10),
329: attribute11 = decode(x_attribute11, FND_API.G_MISS_CHAR,
330: l_oldrec.attribute11, x_attribute11),
331: attribute12 = decode(x_attribute12, FND_API.G_MISS_CHAR,
332: l_oldrec.attribute12, x_attribute12),
333: attribute13 = decode(x_attribute13, FND_API.G_MISS_CHAR,
334: l_oldrec.attribute13, x_attribute13),
335: attribute14 = decode(x_attribute14, FND_API.G_MISS_CHAR,
329: attribute11 = decode(x_attribute11, FND_API.G_MISS_CHAR,
330: l_oldrec.attribute11, x_attribute11),
331: attribute12 = decode(x_attribute12, FND_API.G_MISS_CHAR,
332: l_oldrec.attribute12, x_attribute12),
333: attribute13 = decode(x_attribute13, FND_API.G_MISS_CHAR,
334: l_oldrec.attribute13, x_attribute13),
335: attribute14 = decode(x_attribute14, FND_API.G_MISS_CHAR,
336: l_oldrec.attribute14, x_attribute14),
337: attribute15 = decode(x_attribute15, FND_API.G_MISS_CHAR,
331: attribute12 = decode(x_attribute12, FND_API.G_MISS_CHAR,
332: l_oldrec.attribute12, x_attribute12),
333: attribute13 = decode(x_attribute13, FND_API.G_MISS_CHAR,
334: l_oldrec.attribute13, x_attribute13),
335: attribute14 = decode(x_attribute14, FND_API.G_MISS_CHAR,
336: l_oldrec.attribute14, x_attribute14),
337: attribute15 = decode(x_attribute15, FND_API.G_MISS_CHAR,
338: l_oldrec.attribute15, x_attribute15),
339: last_update_date = G_LAST_UPDATE_DATE,
333: attribute13 = decode(x_attribute13, FND_API.G_MISS_CHAR,
334: l_oldrec.attribute13, x_attribute13),
335: attribute14 = decode(x_attribute14, FND_API.G_MISS_CHAR,
336: l_oldrec.attribute14, x_attribute14),
337: attribute15 = decode(x_attribute15, FND_API.G_MISS_CHAR,
338: l_oldrec.attribute15, x_attribute15),
339: last_update_date = G_LAST_UPDATE_DATE,
340: last_updated_by = G_LAST_UPDATED_BY,
341: last_update_login = G_LAST_UPDATE_LOGIN;