DBA Data[Home] [Help]

APPS.CN_PREPOSTDETAILS dependencies on FND_API

Line 92: l_return_status VARCHAR2(30) := FND_API.G_RET_STS_SUCCESS;

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 );

Line 173: decode(x_status, FND_API.G_MISS_CHAR, 'UNLOADED', x_status),

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,

Line 174: decode(x_loaded_date, FND_API.G_MISS_CHAR, null, x_loaded_date),

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,

Line 189: decode(x_hold_flag, FND_API.G_MISS_CHAR, 'N', x_hold_flag),

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),

Line 190: decode(x_paid_flag, FND_API.G_MISS_CHAR, 'N', x_paid_flag),

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),

Line 191: decode(x_payment_amount, FND_API.G_MISS_NUM, x_amount, x_payment_amount),

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),

Line 192: decode(x_attribute_category, FND_API.G_MISS_CHAR, null, x_attribute_category),

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),

Line 193: decode(x_attribute1, FND_API.G_MISS_CHAR, null, x_attribute1),

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),

Line 194: decode(x_attribute2, FND_API.G_MISS_CHAR, null, x_attribute2),

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),

Line 195: decode(x_attribute3, FND_API.G_MISS_CHAR, null, x_attribute3),

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),

Line 196: decode(x_attribute4, FND_API.G_MISS_CHAR, null, x_attribute4),

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),

Line 197: decode(x_attribute5, FND_API.G_MISS_CHAR, null, x_attribute5),

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),

Line 198: decode(x_attribute6, FND_API.G_MISS_CHAR, null, x_attribute6),

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),

Line 199: decode(x_attribute7, FND_API.G_MISS_CHAR, null, x_attribute7),

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),

Line 200: decode(x_attribute8, FND_API.G_MISS_CHAR, null, x_attribute8),

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),

Line 201: decode(x_attribute9, FND_API.G_MISS_CHAR, null, x_attribute9),

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),

Line 202: decode(x_attribute10, FND_API.G_MISS_CHAR, null, x_attribute10),

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),

Line 203: decode(x_attribute11, FND_API.G_MISS_CHAR, null, x_attribute11),

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),

Line 204: decode(x_attribute12, FND_API.G_MISS_CHAR, null, x_attribute12),

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,

Line 205: decode(x_attribute13, FND_API.G_MISS_CHAR, null, x_attribute13),

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,

Line 206: decode(x_attribute14, FND_API.G_MISS_CHAR, null, x_attribute14),

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,

Line 207: decode(x_attribute15, FND_API.G_MISS_CHAR, null, x_attribute15),

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,

Line 301: status = decode(x_status, FND_API.G_MISS_CHAR,

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,

Line 303: loaded_date = decode(x_loaded_date, FND_API.G_MISS_DATE,

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,

Line 306: 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,
308: x_attribute_category),
309: attribute1 = decode(x_attribute1, FND_API.G_MISS_CHAR,
310: l_oldrec.attribute1, x_attribute1),

Line 309: attribute1 = decode(x_attribute1, FND_API.G_MISS_CHAR,

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,

Line 311: attribute2 = decode(x_attribute2, 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,

Line 313: attribute3 = decode(x_attribute3, 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,

Line 315: attribute4 = decode(x_attribute4, 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,

Line 317: attribute5 = decode(x_attribute5, 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,

Line 319: attribute6 = decode(x_attribute6, 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,

Line 321: attribute7 = decode(x_attribute7, 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,

Line 323: attribute8 = decode(x_attribute8, 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,

Line 325: attribute9 = decode(x_attribute9, 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,

Line 327: attribute10 = decode(x_attribute10, 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,

Line 329: attribute11 = decode(x_attribute11, 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,

Line 331: attribute12 = decode(x_attribute12, 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,

Line 333: attribute13 = decode(x_attribute13, 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,

Line 335: attribute14 = decode(x_attribute14, 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,

Line 337: attribute15 = decode(x_attribute15, FND_API.G_MISS_CHAR,

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;