166: if (c%notfound) then
167: close c;
168: fnd_message.set_name('CN', 'CN_RECORD_DELETED');
169: fnd_msg_pub.add;
170: raise fnd_api.g_exc_unexpected_error;
171: end if;
172: close c;
173:
174: if (tlinfo.object_version_number <> x_object_version_number) then
173:
174: if (tlinfo.object_version_number <> x_object_version_number) then
175: fnd_message.set_name('CN', 'CN_INVALID_OBJECT_VERSION');
176: fnd_msg_pub.add;
177: raise fnd_api.g_exc_unexpected_error;
178: end if;
179:
180: END LOCK_ROW;
181:
219:
220: X_OBJECT_VERSION_NUMBER := X_OBJECT_VERSION_NUMBER + 1;
221:
222: update CN_CALC_FORMULAS set
223: NAME = Decode(X_NAME, fnd_api.g_miss_char, name, x_name),
224: DESCRIPTION = Decode(X_DESCRIPTION, fnd_api.g_miss_char, description, x_description),
225: FORMULA_STATUS = Decode(X_FORMULA_STATUS, fnd_api.g_miss_char, formula_status, x_formula_status),
226: FORMULA_TYPE = Decode(X_FORMULA_TYPE, fnd_api.g_miss_char, formula_type, x_formula_type),
227: TRX_GROUP_CODE = Decode(X_TRX_GROUP_CODE, fnd_api.g_miss_char, trx_group_code, x_trx_group_code),
220: X_OBJECT_VERSION_NUMBER := X_OBJECT_VERSION_NUMBER + 1;
221:
222: update CN_CALC_FORMULAS set
223: NAME = Decode(X_NAME, fnd_api.g_miss_char, name, x_name),
224: DESCRIPTION = Decode(X_DESCRIPTION, fnd_api.g_miss_char, description, x_description),
225: FORMULA_STATUS = Decode(X_FORMULA_STATUS, fnd_api.g_miss_char, formula_status, x_formula_status),
226: FORMULA_TYPE = Decode(X_FORMULA_TYPE, fnd_api.g_miss_char, formula_type, x_formula_type),
227: TRX_GROUP_CODE = Decode(X_TRX_GROUP_CODE, fnd_api.g_miss_char, trx_group_code, x_trx_group_code),
228: NUMBER_DIM = Decode(X_NUMBER_DIM, fnd_api.g_miss_char, number_dim, x_number_dim),
221:
222: update CN_CALC_FORMULAS set
223: NAME = Decode(X_NAME, fnd_api.g_miss_char, name, x_name),
224: DESCRIPTION = Decode(X_DESCRIPTION, fnd_api.g_miss_char, description, x_description),
225: FORMULA_STATUS = Decode(X_FORMULA_STATUS, fnd_api.g_miss_char, formula_status, x_formula_status),
226: FORMULA_TYPE = Decode(X_FORMULA_TYPE, fnd_api.g_miss_char, formula_type, x_formula_type),
227: TRX_GROUP_CODE = Decode(X_TRX_GROUP_CODE, fnd_api.g_miss_char, trx_group_code, x_trx_group_code),
228: NUMBER_DIM = Decode(X_NUMBER_DIM, fnd_api.g_miss_char, number_dim, x_number_dim),
229: CUMULATIVE_FLAG = Decode(X_CUMULATIVE_FLAG, fnd_api.g_miss_char, cumulative_flag, x_cumulative_flag),
222: update CN_CALC_FORMULAS set
223: NAME = Decode(X_NAME, fnd_api.g_miss_char, name, x_name),
224: DESCRIPTION = Decode(X_DESCRIPTION, fnd_api.g_miss_char, description, x_description),
225: FORMULA_STATUS = Decode(X_FORMULA_STATUS, fnd_api.g_miss_char, formula_status, x_formula_status),
226: FORMULA_TYPE = Decode(X_FORMULA_TYPE, fnd_api.g_miss_char, formula_type, x_formula_type),
227: TRX_GROUP_CODE = Decode(X_TRX_GROUP_CODE, fnd_api.g_miss_char, trx_group_code, x_trx_group_code),
228: NUMBER_DIM = Decode(X_NUMBER_DIM, fnd_api.g_miss_char, number_dim, x_number_dim),
229: CUMULATIVE_FLAG = Decode(X_CUMULATIVE_FLAG, fnd_api.g_miss_char, cumulative_flag, x_cumulative_flag),
230: ITD_FLAG = Decode(X_ITD_FLAG, fnd_api.g_miss_char, itd_flag, x_itd_flag),
223: NAME = Decode(X_NAME, fnd_api.g_miss_char, name, x_name),
224: DESCRIPTION = Decode(X_DESCRIPTION, fnd_api.g_miss_char, description, x_description),
225: FORMULA_STATUS = Decode(X_FORMULA_STATUS, fnd_api.g_miss_char, formula_status, x_formula_status),
226: FORMULA_TYPE = Decode(X_FORMULA_TYPE, fnd_api.g_miss_char, formula_type, x_formula_type),
227: TRX_GROUP_CODE = Decode(X_TRX_GROUP_CODE, fnd_api.g_miss_char, trx_group_code, x_trx_group_code),
228: NUMBER_DIM = Decode(X_NUMBER_DIM, fnd_api.g_miss_char, number_dim, x_number_dim),
229: CUMULATIVE_FLAG = Decode(X_CUMULATIVE_FLAG, fnd_api.g_miss_char, cumulative_flag, x_cumulative_flag),
230: ITD_FLAG = Decode(X_ITD_FLAG, fnd_api.g_miss_char, itd_flag, x_itd_flag),
231: SPLIT_FLAG = Decode(X_SPLIT_FLAG, fnd_api.g_miss_char, split_flag, x_split_flag),
224: DESCRIPTION = Decode(X_DESCRIPTION, fnd_api.g_miss_char, description, x_description),
225: FORMULA_STATUS = Decode(X_FORMULA_STATUS, fnd_api.g_miss_char, formula_status, x_formula_status),
226: FORMULA_TYPE = Decode(X_FORMULA_TYPE, fnd_api.g_miss_char, formula_type, x_formula_type),
227: TRX_GROUP_CODE = Decode(X_TRX_GROUP_CODE, fnd_api.g_miss_char, trx_group_code, x_trx_group_code),
228: NUMBER_DIM = Decode(X_NUMBER_DIM, fnd_api.g_miss_char, number_dim, x_number_dim),
229: CUMULATIVE_FLAG = Decode(X_CUMULATIVE_FLAG, fnd_api.g_miss_char, cumulative_flag, x_cumulative_flag),
230: ITD_FLAG = Decode(X_ITD_FLAG, fnd_api.g_miss_char, itd_flag, x_itd_flag),
231: SPLIT_FLAG = Decode(X_SPLIT_FLAG, fnd_api.g_miss_char, split_flag, x_split_flag),
232: THRESHOLD_ALL_TIER_FLAG = Decode(X_THRESHOLD_ALL_TIER_FLAG, fnd_api.g_miss_char, threshold_all_tier_flag, x_threshold_all_tier_flag),
225: FORMULA_STATUS = Decode(X_FORMULA_STATUS, fnd_api.g_miss_char, formula_status, x_formula_status),
226: FORMULA_TYPE = Decode(X_FORMULA_TYPE, fnd_api.g_miss_char, formula_type, x_formula_type),
227: TRX_GROUP_CODE = Decode(X_TRX_GROUP_CODE, fnd_api.g_miss_char, trx_group_code, x_trx_group_code),
228: NUMBER_DIM = Decode(X_NUMBER_DIM, fnd_api.g_miss_char, number_dim, x_number_dim),
229: CUMULATIVE_FLAG = Decode(X_CUMULATIVE_FLAG, fnd_api.g_miss_char, cumulative_flag, x_cumulative_flag),
230: ITD_FLAG = Decode(X_ITD_FLAG, fnd_api.g_miss_char, itd_flag, x_itd_flag),
231: SPLIT_FLAG = Decode(X_SPLIT_FLAG, fnd_api.g_miss_char, split_flag, x_split_flag),
232: THRESHOLD_ALL_TIER_FLAG = Decode(X_THRESHOLD_ALL_TIER_FLAG, fnd_api.g_miss_char, threshold_all_tier_flag, x_threshold_all_tier_flag),
233: MODELING_FLAG = Decode(X_MODELING_FLAG, fnd_api.g_miss_char, modeling_flag, x_modeling_flag),
226: FORMULA_TYPE = Decode(X_FORMULA_TYPE, fnd_api.g_miss_char, formula_type, x_formula_type),
227: TRX_GROUP_CODE = Decode(X_TRX_GROUP_CODE, fnd_api.g_miss_char, trx_group_code, x_trx_group_code),
228: NUMBER_DIM = Decode(X_NUMBER_DIM, fnd_api.g_miss_char, number_dim, x_number_dim),
229: CUMULATIVE_FLAG = Decode(X_CUMULATIVE_FLAG, fnd_api.g_miss_char, cumulative_flag, x_cumulative_flag),
230: ITD_FLAG = Decode(X_ITD_FLAG, fnd_api.g_miss_char, itd_flag, x_itd_flag),
231: SPLIT_FLAG = Decode(X_SPLIT_FLAG, fnd_api.g_miss_char, split_flag, x_split_flag),
232: THRESHOLD_ALL_TIER_FLAG = Decode(X_THRESHOLD_ALL_TIER_FLAG, fnd_api.g_miss_char, threshold_all_tier_flag, x_threshold_all_tier_flag),
233: MODELING_FLAG = Decode(X_MODELING_FLAG, fnd_api.g_miss_char, modeling_flag, x_modeling_flag),
234: PERF_MEASURE_ID = Decode(X_PERF_MEASURE_ID, fnd_api.g_miss_char, perf_measure_id, x_perf_measure_id),
227: TRX_GROUP_CODE = Decode(X_TRX_GROUP_CODE, fnd_api.g_miss_char, trx_group_code, x_trx_group_code),
228: NUMBER_DIM = Decode(X_NUMBER_DIM, fnd_api.g_miss_char, number_dim, x_number_dim),
229: CUMULATIVE_FLAG = Decode(X_CUMULATIVE_FLAG, fnd_api.g_miss_char, cumulative_flag, x_cumulative_flag),
230: ITD_FLAG = Decode(X_ITD_FLAG, fnd_api.g_miss_char, itd_flag, x_itd_flag),
231: SPLIT_FLAG = Decode(X_SPLIT_FLAG, fnd_api.g_miss_char, split_flag, x_split_flag),
232: THRESHOLD_ALL_TIER_FLAG = Decode(X_THRESHOLD_ALL_TIER_FLAG, fnd_api.g_miss_char, threshold_all_tier_flag, x_threshold_all_tier_flag),
233: MODELING_FLAG = Decode(X_MODELING_FLAG, fnd_api.g_miss_char, modeling_flag, x_modeling_flag),
234: PERF_MEASURE_ID = Decode(X_PERF_MEASURE_ID, fnd_api.g_miss_char, perf_measure_id, x_perf_measure_id),
235: OUTPUT_EXP_ID = Decode(X_OUTPUT_EXP_ID, fnd_api.g_miss_char, output_exp_id, x_output_exp_id),
228: NUMBER_DIM = Decode(X_NUMBER_DIM, fnd_api.g_miss_char, number_dim, x_number_dim),
229: CUMULATIVE_FLAG = Decode(X_CUMULATIVE_FLAG, fnd_api.g_miss_char, cumulative_flag, x_cumulative_flag),
230: ITD_FLAG = Decode(X_ITD_FLAG, fnd_api.g_miss_char, itd_flag, x_itd_flag),
231: SPLIT_FLAG = Decode(X_SPLIT_FLAG, fnd_api.g_miss_char, split_flag, x_split_flag),
232: THRESHOLD_ALL_TIER_FLAG = Decode(X_THRESHOLD_ALL_TIER_FLAG, fnd_api.g_miss_char, threshold_all_tier_flag, x_threshold_all_tier_flag),
233: MODELING_FLAG = Decode(X_MODELING_FLAG, fnd_api.g_miss_char, modeling_flag, x_modeling_flag),
234: PERF_MEASURE_ID = Decode(X_PERF_MEASURE_ID, fnd_api.g_miss_char, perf_measure_id, x_perf_measure_id),
235: OUTPUT_EXP_ID = Decode(X_OUTPUT_EXP_ID, fnd_api.g_miss_char, output_exp_id, x_output_exp_id),
236: F_OUTPUT_EXP_ID = Decode(X_F_OUTPUT_EXP_ID, fnd_api.g_miss_char, f_output_exp_id, x_f_output_exp_id),
229: CUMULATIVE_FLAG = Decode(X_CUMULATIVE_FLAG, fnd_api.g_miss_char, cumulative_flag, x_cumulative_flag),
230: ITD_FLAG = Decode(X_ITD_FLAG, fnd_api.g_miss_char, itd_flag, x_itd_flag),
231: SPLIT_FLAG = Decode(X_SPLIT_FLAG, fnd_api.g_miss_char, split_flag, x_split_flag),
232: THRESHOLD_ALL_TIER_FLAG = Decode(X_THRESHOLD_ALL_TIER_FLAG, fnd_api.g_miss_char, threshold_all_tier_flag, x_threshold_all_tier_flag),
233: MODELING_FLAG = Decode(X_MODELING_FLAG, fnd_api.g_miss_char, modeling_flag, x_modeling_flag),
234: PERF_MEASURE_ID = Decode(X_PERF_MEASURE_ID, fnd_api.g_miss_char, perf_measure_id, x_perf_measure_id),
235: OUTPUT_EXP_ID = Decode(X_OUTPUT_EXP_ID, fnd_api.g_miss_char, output_exp_id, x_output_exp_id),
236: F_OUTPUT_EXP_ID = Decode(X_F_OUTPUT_EXP_ID, fnd_api.g_miss_char, f_output_exp_id, x_f_output_exp_id),
237: ATTRIBUTE_CATEGORY = Decode(X_ATTRIBUTE_CATEGORY, fnd_api.g_miss_char, attribute_category, x_attribute_category),
230: ITD_FLAG = Decode(X_ITD_FLAG, fnd_api.g_miss_char, itd_flag, x_itd_flag),
231: SPLIT_FLAG = Decode(X_SPLIT_FLAG, fnd_api.g_miss_char, split_flag, x_split_flag),
232: THRESHOLD_ALL_TIER_FLAG = Decode(X_THRESHOLD_ALL_TIER_FLAG, fnd_api.g_miss_char, threshold_all_tier_flag, x_threshold_all_tier_flag),
233: MODELING_FLAG = Decode(X_MODELING_FLAG, fnd_api.g_miss_char, modeling_flag, x_modeling_flag),
234: PERF_MEASURE_ID = Decode(X_PERF_MEASURE_ID, fnd_api.g_miss_char, perf_measure_id, x_perf_measure_id),
235: OUTPUT_EXP_ID = Decode(X_OUTPUT_EXP_ID, fnd_api.g_miss_char, output_exp_id, x_output_exp_id),
236: F_OUTPUT_EXP_ID = Decode(X_F_OUTPUT_EXP_ID, fnd_api.g_miss_char, f_output_exp_id, x_f_output_exp_id),
237: ATTRIBUTE_CATEGORY = Decode(X_ATTRIBUTE_CATEGORY, fnd_api.g_miss_char, attribute_category, x_attribute_category),
238: ATTRIBUTE1 = Decode(X_ATTRIBUTE1, fnd_api.g_miss_char, attribute1, x_attribute1),
231: SPLIT_FLAG = Decode(X_SPLIT_FLAG, fnd_api.g_miss_char, split_flag, x_split_flag),
232: THRESHOLD_ALL_TIER_FLAG = Decode(X_THRESHOLD_ALL_TIER_FLAG, fnd_api.g_miss_char, threshold_all_tier_flag, x_threshold_all_tier_flag),
233: MODELING_FLAG = Decode(X_MODELING_FLAG, fnd_api.g_miss_char, modeling_flag, x_modeling_flag),
234: PERF_MEASURE_ID = Decode(X_PERF_MEASURE_ID, fnd_api.g_miss_char, perf_measure_id, x_perf_measure_id),
235: OUTPUT_EXP_ID = Decode(X_OUTPUT_EXP_ID, fnd_api.g_miss_char, output_exp_id, x_output_exp_id),
236: F_OUTPUT_EXP_ID = Decode(X_F_OUTPUT_EXP_ID, fnd_api.g_miss_char, f_output_exp_id, x_f_output_exp_id),
237: ATTRIBUTE_CATEGORY = Decode(X_ATTRIBUTE_CATEGORY, fnd_api.g_miss_char, attribute_category, x_attribute_category),
238: ATTRIBUTE1 = Decode(X_ATTRIBUTE1, fnd_api.g_miss_char, attribute1, x_attribute1),
239: ATTRIBUTE2 = Decode(X_ATTRIBUTE2, fnd_api.g_miss_char, attribute2, x_attribute2),
232: THRESHOLD_ALL_TIER_FLAG = Decode(X_THRESHOLD_ALL_TIER_FLAG, fnd_api.g_miss_char, threshold_all_tier_flag, x_threshold_all_tier_flag),
233: MODELING_FLAG = Decode(X_MODELING_FLAG, fnd_api.g_miss_char, modeling_flag, x_modeling_flag),
234: PERF_MEASURE_ID = Decode(X_PERF_MEASURE_ID, fnd_api.g_miss_char, perf_measure_id, x_perf_measure_id),
235: OUTPUT_EXP_ID = Decode(X_OUTPUT_EXP_ID, fnd_api.g_miss_char, output_exp_id, x_output_exp_id),
236: F_OUTPUT_EXP_ID = Decode(X_F_OUTPUT_EXP_ID, fnd_api.g_miss_char, f_output_exp_id, x_f_output_exp_id),
237: ATTRIBUTE_CATEGORY = Decode(X_ATTRIBUTE_CATEGORY, fnd_api.g_miss_char, attribute_category, x_attribute_category),
238: ATTRIBUTE1 = Decode(X_ATTRIBUTE1, fnd_api.g_miss_char, attribute1, x_attribute1),
239: ATTRIBUTE2 = Decode(X_ATTRIBUTE2, fnd_api.g_miss_char, attribute2, x_attribute2),
240: ATTRIBUTE3 = Decode(X_ATTRIBUTE3, fnd_api.g_miss_char, attribute3, x_attribute3),
233: MODELING_FLAG = Decode(X_MODELING_FLAG, fnd_api.g_miss_char, modeling_flag, x_modeling_flag),
234: PERF_MEASURE_ID = Decode(X_PERF_MEASURE_ID, fnd_api.g_miss_char, perf_measure_id, x_perf_measure_id),
235: OUTPUT_EXP_ID = Decode(X_OUTPUT_EXP_ID, fnd_api.g_miss_char, output_exp_id, x_output_exp_id),
236: F_OUTPUT_EXP_ID = Decode(X_F_OUTPUT_EXP_ID, fnd_api.g_miss_char, f_output_exp_id, x_f_output_exp_id),
237: ATTRIBUTE_CATEGORY = Decode(X_ATTRIBUTE_CATEGORY, fnd_api.g_miss_char, attribute_category, x_attribute_category),
238: ATTRIBUTE1 = Decode(X_ATTRIBUTE1, fnd_api.g_miss_char, attribute1, x_attribute1),
239: ATTRIBUTE2 = Decode(X_ATTRIBUTE2, fnd_api.g_miss_char, attribute2, x_attribute2),
240: ATTRIBUTE3 = Decode(X_ATTRIBUTE3, fnd_api.g_miss_char, attribute3, x_attribute3),
241: ATTRIBUTE4 = Decode(X_ATTRIBUTE4, fnd_api.g_miss_char, attribute4, x_attribute4),
234: PERF_MEASURE_ID = Decode(X_PERF_MEASURE_ID, fnd_api.g_miss_char, perf_measure_id, x_perf_measure_id),
235: OUTPUT_EXP_ID = Decode(X_OUTPUT_EXP_ID, fnd_api.g_miss_char, output_exp_id, x_output_exp_id),
236: F_OUTPUT_EXP_ID = Decode(X_F_OUTPUT_EXP_ID, fnd_api.g_miss_char, f_output_exp_id, x_f_output_exp_id),
237: ATTRIBUTE_CATEGORY = Decode(X_ATTRIBUTE_CATEGORY, fnd_api.g_miss_char, attribute_category, x_attribute_category),
238: ATTRIBUTE1 = Decode(X_ATTRIBUTE1, fnd_api.g_miss_char, attribute1, x_attribute1),
239: ATTRIBUTE2 = Decode(X_ATTRIBUTE2, fnd_api.g_miss_char, attribute2, x_attribute2),
240: ATTRIBUTE3 = Decode(X_ATTRIBUTE3, fnd_api.g_miss_char, attribute3, x_attribute3),
241: ATTRIBUTE4 = Decode(X_ATTRIBUTE4, fnd_api.g_miss_char, attribute4, x_attribute4),
242: ATTRIBUTE5 = Decode(X_ATTRIBUTE5, fnd_api.g_miss_char, attribute5, x_attribute5),
235: OUTPUT_EXP_ID = Decode(X_OUTPUT_EXP_ID, fnd_api.g_miss_char, output_exp_id, x_output_exp_id),
236: F_OUTPUT_EXP_ID = Decode(X_F_OUTPUT_EXP_ID, fnd_api.g_miss_char, f_output_exp_id, x_f_output_exp_id),
237: ATTRIBUTE_CATEGORY = Decode(X_ATTRIBUTE_CATEGORY, fnd_api.g_miss_char, attribute_category, x_attribute_category),
238: ATTRIBUTE1 = Decode(X_ATTRIBUTE1, fnd_api.g_miss_char, attribute1, x_attribute1),
239: ATTRIBUTE2 = Decode(X_ATTRIBUTE2, fnd_api.g_miss_char, attribute2, x_attribute2),
240: ATTRIBUTE3 = Decode(X_ATTRIBUTE3, fnd_api.g_miss_char, attribute3, x_attribute3),
241: ATTRIBUTE4 = Decode(X_ATTRIBUTE4, fnd_api.g_miss_char, attribute4, x_attribute4),
242: ATTRIBUTE5 = Decode(X_ATTRIBUTE5, fnd_api.g_miss_char, attribute5, x_attribute5),
243: ATTRIBUTE6 = Decode(X_ATTRIBUTE6, fnd_api.g_miss_char, attribute6, x_attribute6),
236: F_OUTPUT_EXP_ID = Decode(X_F_OUTPUT_EXP_ID, fnd_api.g_miss_char, f_output_exp_id, x_f_output_exp_id),
237: ATTRIBUTE_CATEGORY = Decode(X_ATTRIBUTE_CATEGORY, fnd_api.g_miss_char, attribute_category, x_attribute_category),
238: ATTRIBUTE1 = Decode(X_ATTRIBUTE1, fnd_api.g_miss_char, attribute1, x_attribute1),
239: ATTRIBUTE2 = Decode(X_ATTRIBUTE2, fnd_api.g_miss_char, attribute2, x_attribute2),
240: ATTRIBUTE3 = Decode(X_ATTRIBUTE3, fnd_api.g_miss_char, attribute3, x_attribute3),
241: ATTRIBUTE4 = Decode(X_ATTRIBUTE4, fnd_api.g_miss_char, attribute4, x_attribute4),
242: ATTRIBUTE5 = Decode(X_ATTRIBUTE5, fnd_api.g_miss_char, attribute5, x_attribute5),
243: ATTRIBUTE6 = Decode(X_ATTRIBUTE6, fnd_api.g_miss_char, attribute6, x_attribute6),
244: ATTRIBUTE7 = Decode(X_ATTRIBUTE7, fnd_api.g_miss_char, attribute7, x_attribute7),
237: ATTRIBUTE_CATEGORY = Decode(X_ATTRIBUTE_CATEGORY, fnd_api.g_miss_char, attribute_category, x_attribute_category),
238: ATTRIBUTE1 = Decode(X_ATTRIBUTE1, fnd_api.g_miss_char, attribute1, x_attribute1),
239: ATTRIBUTE2 = Decode(X_ATTRIBUTE2, fnd_api.g_miss_char, attribute2, x_attribute2),
240: ATTRIBUTE3 = Decode(X_ATTRIBUTE3, fnd_api.g_miss_char, attribute3, x_attribute3),
241: ATTRIBUTE4 = Decode(X_ATTRIBUTE4, fnd_api.g_miss_char, attribute4, x_attribute4),
242: ATTRIBUTE5 = Decode(X_ATTRIBUTE5, fnd_api.g_miss_char, attribute5, x_attribute5),
243: ATTRIBUTE6 = Decode(X_ATTRIBUTE6, fnd_api.g_miss_char, attribute6, x_attribute6),
244: ATTRIBUTE7 = Decode(X_ATTRIBUTE7, fnd_api.g_miss_char, attribute7, x_attribute7),
245: ATTRIBUTE8 = Decode(X_ATTRIBUTE8, fnd_api.g_miss_char, attribute8, x_attribute8),
238: ATTRIBUTE1 = Decode(X_ATTRIBUTE1, fnd_api.g_miss_char, attribute1, x_attribute1),
239: ATTRIBUTE2 = Decode(X_ATTRIBUTE2, fnd_api.g_miss_char, attribute2, x_attribute2),
240: ATTRIBUTE3 = Decode(X_ATTRIBUTE3, fnd_api.g_miss_char, attribute3, x_attribute3),
241: ATTRIBUTE4 = Decode(X_ATTRIBUTE4, fnd_api.g_miss_char, attribute4, x_attribute4),
242: ATTRIBUTE5 = Decode(X_ATTRIBUTE5, fnd_api.g_miss_char, attribute5, x_attribute5),
243: ATTRIBUTE6 = Decode(X_ATTRIBUTE6, fnd_api.g_miss_char, attribute6, x_attribute6),
244: ATTRIBUTE7 = Decode(X_ATTRIBUTE7, fnd_api.g_miss_char, attribute7, x_attribute7),
245: ATTRIBUTE8 = Decode(X_ATTRIBUTE8, fnd_api.g_miss_char, attribute8, x_attribute8),
246: ATTRIBUTE9 = Decode(X_ATTRIBUTE9, fnd_api.g_miss_char, attribute9, x_attribute9),
239: ATTRIBUTE2 = Decode(X_ATTRIBUTE2, fnd_api.g_miss_char, attribute2, x_attribute2),
240: ATTRIBUTE3 = Decode(X_ATTRIBUTE3, fnd_api.g_miss_char, attribute3, x_attribute3),
241: ATTRIBUTE4 = Decode(X_ATTRIBUTE4, fnd_api.g_miss_char, attribute4, x_attribute4),
242: ATTRIBUTE5 = Decode(X_ATTRIBUTE5, fnd_api.g_miss_char, attribute5, x_attribute5),
243: ATTRIBUTE6 = Decode(X_ATTRIBUTE6, fnd_api.g_miss_char, attribute6, x_attribute6),
244: ATTRIBUTE7 = Decode(X_ATTRIBUTE7, fnd_api.g_miss_char, attribute7, x_attribute7),
245: ATTRIBUTE8 = Decode(X_ATTRIBUTE8, fnd_api.g_miss_char, attribute8, x_attribute8),
246: ATTRIBUTE9 = Decode(X_ATTRIBUTE9, fnd_api.g_miss_char, attribute9, x_attribute9),
247: ATTRIBUTE10 = Decode(X_ATTRIBUTE10, fnd_api.g_miss_char, attribute10, x_attribute10),
240: ATTRIBUTE3 = Decode(X_ATTRIBUTE3, fnd_api.g_miss_char, attribute3, x_attribute3),
241: ATTRIBUTE4 = Decode(X_ATTRIBUTE4, fnd_api.g_miss_char, attribute4, x_attribute4),
242: ATTRIBUTE5 = Decode(X_ATTRIBUTE5, fnd_api.g_miss_char, attribute5, x_attribute5),
243: ATTRIBUTE6 = Decode(X_ATTRIBUTE6, fnd_api.g_miss_char, attribute6, x_attribute6),
244: ATTRIBUTE7 = Decode(X_ATTRIBUTE7, fnd_api.g_miss_char, attribute7, x_attribute7),
245: ATTRIBUTE8 = Decode(X_ATTRIBUTE8, fnd_api.g_miss_char, attribute8, x_attribute8),
246: ATTRIBUTE9 = Decode(X_ATTRIBUTE9, fnd_api.g_miss_char, attribute9, x_attribute9),
247: ATTRIBUTE10 = Decode(X_ATTRIBUTE10, fnd_api.g_miss_char, attribute10, x_attribute10),
248: ATTRIBUTE11 = Decode(X_ATTRIBUTE11, fnd_api.g_miss_char, attribute11, x_attribute11),
241: ATTRIBUTE4 = Decode(X_ATTRIBUTE4, fnd_api.g_miss_char, attribute4, x_attribute4),
242: ATTRIBUTE5 = Decode(X_ATTRIBUTE5, fnd_api.g_miss_char, attribute5, x_attribute5),
243: ATTRIBUTE6 = Decode(X_ATTRIBUTE6, fnd_api.g_miss_char, attribute6, x_attribute6),
244: ATTRIBUTE7 = Decode(X_ATTRIBUTE7, fnd_api.g_miss_char, attribute7, x_attribute7),
245: ATTRIBUTE8 = Decode(X_ATTRIBUTE8, fnd_api.g_miss_char, attribute8, x_attribute8),
246: ATTRIBUTE9 = Decode(X_ATTRIBUTE9, fnd_api.g_miss_char, attribute9, x_attribute9),
247: ATTRIBUTE10 = Decode(X_ATTRIBUTE10, fnd_api.g_miss_char, attribute10, x_attribute10),
248: ATTRIBUTE11 = Decode(X_ATTRIBUTE11, fnd_api.g_miss_char, attribute11, x_attribute11),
249: ATTRIBUTE12 = Decode(X_ATTRIBUTE12, fnd_api.g_miss_char, attribute12, x_attribute12),
242: ATTRIBUTE5 = Decode(X_ATTRIBUTE5, fnd_api.g_miss_char, attribute5, x_attribute5),
243: ATTRIBUTE6 = Decode(X_ATTRIBUTE6, fnd_api.g_miss_char, attribute6, x_attribute6),
244: ATTRIBUTE7 = Decode(X_ATTRIBUTE7, fnd_api.g_miss_char, attribute7, x_attribute7),
245: ATTRIBUTE8 = Decode(X_ATTRIBUTE8, fnd_api.g_miss_char, attribute8, x_attribute8),
246: ATTRIBUTE9 = Decode(X_ATTRIBUTE9, fnd_api.g_miss_char, attribute9, x_attribute9),
247: ATTRIBUTE10 = Decode(X_ATTRIBUTE10, fnd_api.g_miss_char, attribute10, x_attribute10),
248: ATTRIBUTE11 = Decode(X_ATTRIBUTE11, fnd_api.g_miss_char, attribute11, x_attribute11),
249: ATTRIBUTE12 = Decode(X_ATTRIBUTE12, fnd_api.g_miss_char, attribute12, x_attribute12),
250: ATTRIBUTE13 = Decode(X_ATTRIBUTE13, fnd_api.g_miss_char, attribute13, x_attribute13),
243: ATTRIBUTE6 = Decode(X_ATTRIBUTE6, fnd_api.g_miss_char, attribute6, x_attribute6),
244: ATTRIBUTE7 = Decode(X_ATTRIBUTE7, fnd_api.g_miss_char, attribute7, x_attribute7),
245: ATTRIBUTE8 = Decode(X_ATTRIBUTE8, fnd_api.g_miss_char, attribute8, x_attribute8),
246: ATTRIBUTE9 = Decode(X_ATTRIBUTE9, fnd_api.g_miss_char, attribute9, x_attribute9),
247: ATTRIBUTE10 = Decode(X_ATTRIBUTE10, fnd_api.g_miss_char, attribute10, x_attribute10),
248: ATTRIBUTE11 = Decode(X_ATTRIBUTE11, fnd_api.g_miss_char, attribute11, x_attribute11),
249: ATTRIBUTE12 = Decode(X_ATTRIBUTE12, fnd_api.g_miss_char, attribute12, x_attribute12),
250: ATTRIBUTE13 = Decode(X_ATTRIBUTE13, fnd_api.g_miss_char, attribute13, x_attribute13),
251: ATTRIBUTE14 = Decode(X_ATTRIBUTE14, fnd_api.g_miss_char, attribute14, x_attribute14),
244: ATTRIBUTE7 = Decode(X_ATTRIBUTE7, fnd_api.g_miss_char, attribute7, x_attribute7),
245: ATTRIBUTE8 = Decode(X_ATTRIBUTE8, fnd_api.g_miss_char, attribute8, x_attribute8),
246: ATTRIBUTE9 = Decode(X_ATTRIBUTE9, fnd_api.g_miss_char, attribute9, x_attribute9),
247: ATTRIBUTE10 = Decode(X_ATTRIBUTE10, fnd_api.g_miss_char, attribute10, x_attribute10),
248: ATTRIBUTE11 = Decode(X_ATTRIBUTE11, fnd_api.g_miss_char, attribute11, x_attribute11),
249: ATTRIBUTE12 = Decode(X_ATTRIBUTE12, fnd_api.g_miss_char, attribute12, x_attribute12),
250: ATTRIBUTE13 = Decode(X_ATTRIBUTE13, fnd_api.g_miss_char, attribute13, x_attribute13),
251: ATTRIBUTE14 = Decode(X_ATTRIBUTE14, fnd_api.g_miss_char, attribute14, x_attribute14),
252: ATTRIBUTE15 = Decode(X_ATTRIBUTE15, fnd_api.g_miss_char, attribute15, x_attribute15),
245: ATTRIBUTE8 = Decode(X_ATTRIBUTE8, fnd_api.g_miss_char, attribute8, x_attribute8),
246: ATTRIBUTE9 = Decode(X_ATTRIBUTE9, fnd_api.g_miss_char, attribute9, x_attribute9),
247: ATTRIBUTE10 = Decode(X_ATTRIBUTE10, fnd_api.g_miss_char, attribute10, x_attribute10),
248: ATTRIBUTE11 = Decode(X_ATTRIBUTE11, fnd_api.g_miss_char, attribute11, x_attribute11),
249: ATTRIBUTE12 = Decode(X_ATTRIBUTE12, fnd_api.g_miss_char, attribute12, x_attribute12),
250: ATTRIBUTE13 = Decode(X_ATTRIBUTE13, fnd_api.g_miss_char, attribute13, x_attribute13),
251: ATTRIBUTE14 = Decode(X_ATTRIBUTE14, fnd_api.g_miss_char, attribute14, x_attribute14),
252: ATTRIBUTE15 = Decode(X_ATTRIBUTE15, fnd_api.g_miss_char, attribute15, x_attribute15),
253: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
246: ATTRIBUTE9 = Decode(X_ATTRIBUTE9, fnd_api.g_miss_char, attribute9, x_attribute9),
247: ATTRIBUTE10 = Decode(X_ATTRIBUTE10, fnd_api.g_miss_char, attribute10, x_attribute10),
248: ATTRIBUTE11 = Decode(X_ATTRIBUTE11, fnd_api.g_miss_char, attribute11, x_attribute11),
249: ATTRIBUTE12 = Decode(X_ATTRIBUTE12, fnd_api.g_miss_char, attribute12, x_attribute12),
250: ATTRIBUTE13 = Decode(X_ATTRIBUTE13, fnd_api.g_miss_char, attribute13, x_attribute13),
251: ATTRIBUTE14 = Decode(X_ATTRIBUTE14, fnd_api.g_miss_char, attribute14, x_attribute14),
252: ATTRIBUTE15 = Decode(X_ATTRIBUTE15, fnd_api.g_miss_char, attribute15, x_attribute15),
253: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
254: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
247: ATTRIBUTE10 = Decode(X_ATTRIBUTE10, fnd_api.g_miss_char, attribute10, x_attribute10),
248: ATTRIBUTE11 = Decode(X_ATTRIBUTE11, fnd_api.g_miss_char, attribute11, x_attribute11),
249: ATTRIBUTE12 = Decode(X_ATTRIBUTE12, fnd_api.g_miss_char, attribute12, x_attribute12),
250: ATTRIBUTE13 = Decode(X_ATTRIBUTE13, fnd_api.g_miss_char, attribute13, x_attribute13),
251: ATTRIBUTE14 = Decode(X_ATTRIBUTE14, fnd_api.g_miss_char, attribute14, x_attribute14),
252: ATTRIBUTE15 = Decode(X_ATTRIBUTE15, fnd_api.g_miss_char, attribute15, x_attribute15),
253: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
254: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
255: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
248: ATTRIBUTE11 = Decode(X_ATTRIBUTE11, fnd_api.g_miss_char, attribute11, x_attribute11),
249: ATTRIBUTE12 = Decode(X_ATTRIBUTE12, fnd_api.g_miss_char, attribute12, x_attribute12),
250: ATTRIBUTE13 = Decode(X_ATTRIBUTE13, fnd_api.g_miss_char, attribute13, x_attribute13),
251: ATTRIBUTE14 = Decode(X_ATTRIBUTE14, fnd_api.g_miss_char, attribute14, x_attribute14),
252: ATTRIBUTE15 = Decode(X_ATTRIBUTE15, fnd_api.g_miss_char, attribute15, x_attribute15),
253: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
254: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
255: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
256: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER
271:
272: if (sql%notfound) then
273: fnd_message.set_name('CN', 'CN_RECORD_DELETED');
274: fnd_msg_pub.add;
275: raise fnd_api.g_exc_error;
276: end if;
277:
278: end DELETE_ROW;
279: