DBA Data[Home] [Help]

APPS.CN_CALC_SQL_EXPS_PKG dependencies on FND_API

Line 172: raise fnd_api.g_exc_unexpected_error;

168: if (c%notfound) then
169: close c;
170: fnd_message.set_name('CN', 'CN_RECORD_DELETED');
171: fnd_msg_pub.add;
172: raise fnd_api.g_exc_unexpected_error;
173: end if;
174: close c;
175:
176: if (tlinfo.object_version_number <> p_object_version_number) then

Line 179: raise fnd_api.g_exc_unexpected_error;

175:
176: if (tlinfo.object_version_number <> p_object_version_number) then
177: fnd_message.set_name('CN', 'CN_RECORD_CHANGED');
178: fnd_msg_pub.add;
179: raise fnd_api.g_exc_unexpected_error;
180: end if;
181:
182: END LOCK_ROW;
183:

Line 223: NAME = Decode(X_NAME, fnd_api.g_miss_char, name, x_name),

219:
220: X_OBJECT_VERSION_NUMBER := X_OBJECT_VERSION_NUMBER + 1;
221:
222: update CN_CALC_SQL_EXPS 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: STATUS = Decode(X_STATUS, fnd_api.g_miss_char, status, x_status),
226: EXP_TYPE_CODE = Decode(X_EXP_TYPE_CODE, fnd_api.g_miss_char, exp_type_code, x_exp_type_code),
227: EXPRESSION_DISP = Decode(X_EXPRESSION_DISP, fnd_api.g_miss_char, dbms_lob.substr(expression_disp), x_expression_disp),

Line 224: DESCRIPTION = Decode(X_DESCRIPTION, fnd_api.g_miss_char, description, x_description),

220: X_OBJECT_VERSION_NUMBER := X_OBJECT_VERSION_NUMBER + 1;
221:
222: update CN_CALC_SQL_EXPS 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: STATUS = Decode(X_STATUS, fnd_api.g_miss_char, status, x_status),
226: EXP_TYPE_CODE = Decode(X_EXP_TYPE_CODE, fnd_api.g_miss_char, exp_type_code, x_exp_type_code),
227: EXPRESSION_DISP = Decode(X_EXPRESSION_DISP, fnd_api.g_miss_char, dbms_lob.substr(expression_disp), x_expression_disp),
228: SQL_SELECT = Decode(X_SQL_SELECT, fnd_api.g_miss_char, dbms_lob.substr(sql_select), x_sql_select),

Line 225: STATUS = Decode(X_STATUS, fnd_api.g_miss_char, status, x_status),

221:
222: update CN_CALC_SQL_EXPS 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: STATUS = Decode(X_STATUS, fnd_api.g_miss_char, status, x_status),
226: EXP_TYPE_CODE = Decode(X_EXP_TYPE_CODE, fnd_api.g_miss_char, exp_type_code, x_exp_type_code),
227: EXPRESSION_DISP = Decode(X_EXPRESSION_DISP, fnd_api.g_miss_char, dbms_lob.substr(expression_disp), x_expression_disp),
228: SQL_SELECT = Decode(X_SQL_SELECT, fnd_api.g_miss_char, dbms_lob.substr(sql_select), x_sql_select),
229: SQL_FROM = Decode(X_SQL_FROM, fnd_api.g_miss_char, dbms_lob.substr(sql_from), x_sql_from),

Line 226: EXP_TYPE_CODE = Decode(X_EXP_TYPE_CODE, fnd_api.g_miss_char, exp_type_code, x_exp_type_code),

222: update CN_CALC_SQL_EXPS 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: STATUS = Decode(X_STATUS, fnd_api.g_miss_char, status, x_status),
226: EXP_TYPE_CODE = Decode(X_EXP_TYPE_CODE, fnd_api.g_miss_char, exp_type_code, x_exp_type_code),
227: EXPRESSION_DISP = Decode(X_EXPRESSION_DISP, fnd_api.g_miss_char, dbms_lob.substr(expression_disp), x_expression_disp),
228: SQL_SELECT = Decode(X_SQL_SELECT, fnd_api.g_miss_char, dbms_lob.substr(sql_select), x_sql_select),
229: SQL_FROM = Decode(X_SQL_FROM, fnd_api.g_miss_char, dbms_lob.substr(sql_from), x_sql_from),
230: PIPED_SQL_SELECT = Decode(X_PIPED_SQL_SELECT, fnd_api.g_miss_char, dbms_lob.substr(piped_sql_select), x_piped_sql_select),

Line 227: EXPRESSION_DISP = Decode(X_EXPRESSION_DISP, fnd_api.g_miss_char, dbms_lob.substr(expression_disp), x_expression_disp),

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: STATUS = Decode(X_STATUS, fnd_api.g_miss_char, status, x_status),
226: EXP_TYPE_CODE = Decode(X_EXP_TYPE_CODE, fnd_api.g_miss_char, exp_type_code, x_exp_type_code),
227: EXPRESSION_DISP = Decode(X_EXPRESSION_DISP, fnd_api.g_miss_char, dbms_lob.substr(expression_disp), x_expression_disp),
228: SQL_SELECT = Decode(X_SQL_SELECT, fnd_api.g_miss_char, dbms_lob.substr(sql_select), x_sql_select),
229: SQL_FROM = Decode(X_SQL_FROM, fnd_api.g_miss_char, dbms_lob.substr(sql_from), x_sql_from),
230: PIPED_SQL_SELECT = Decode(X_PIPED_SQL_SELECT, fnd_api.g_miss_char, dbms_lob.substr(piped_sql_select), x_piped_sql_select),
231: PIPED_SQL_FROM = Decode(X_PIPED_SQL_FROM, fnd_api.g_miss_char, dbms_lob.substr(piped_sql_from), x_piped_sql_from),

Line 228: SQL_SELECT = Decode(X_SQL_SELECT, fnd_api.g_miss_char, dbms_lob.substr(sql_select), x_sql_select),

224: DESCRIPTION = Decode(X_DESCRIPTION, fnd_api.g_miss_char, description, x_description),
225: STATUS = Decode(X_STATUS, fnd_api.g_miss_char, status, x_status),
226: EXP_TYPE_CODE = Decode(X_EXP_TYPE_CODE, fnd_api.g_miss_char, exp_type_code, x_exp_type_code),
227: EXPRESSION_DISP = Decode(X_EXPRESSION_DISP, fnd_api.g_miss_char, dbms_lob.substr(expression_disp), x_expression_disp),
228: SQL_SELECT = Decode(X_SQL_SELECT, fnd_api.g_miss_char, dbms_lob.substr(sql_select), x_sql_select),
229: SQL_FROM = Decode(X_SQL_FROM, fnd_api.g_miss_char, dbms_lob.substr(sql_from), x_sql_from),
230: PIPED_SQL_SELECT = Decode(X_PIPED_SQL_SELECT, fnd_api.g_miss_char, dbms_lob.substr(piped_sql_select), x_piped_sql_select),
231: PIPED_SQL_FROM = Decode(X_PIPED_SQL_FROM, fnd_api.g_miss_char, dbms_lob.substr(piped_sql_from), x_piped_sql_from),
232: PIPED_EXPRESSION_DISP = Decode(X_PIPED_EXPRESSION_DISP, fnd_api.g_miss_char, dbms_lob.substr(piped_expression_disp), x_piped_expression_disp),

Line 229: SQL_FROM = Decode(X_SQL_FROM, fnd_api.g_miss_char, dbms_lob.substr(sql_from), x_sql_from),

225: STATUS = Decode(X_STATUS, fnd_api.g_miss_char, status, x_status),
226: EXP_TYPE_CODE = Decode(X_EXP_TYPE_CODE, fnd_api.g_miss_char, exp_type_code, x_exp_type_code),
227: EXPRESSION_DISP = Decode(X_EXPRESSION_DISP, fnd_api.g_miss_char, dbms_lob.substr(expression_disp), x_expression_disp),
228: SQL_SELECT = Decode(X_SQL_SELECT, fnd_api.g_miss_char, dbms_lob.substr(sql_select), x_sql_select),
229: SQL_FROM = Decode(X_SQL_FROM, fnd_api.g_miss_char, dbms_lob.substr(sql_from), x_sql_from),
230: PIPED_SQL_SELECT = Decode(X_PIPED_SQL_SELECT, fnd_api.g_miss_char, dbms_lob.substr(piped_sql_select), x_piped_sql_select),
231: PIPED_SQL_FROM = Decode(X_PIPED_SQL_FROM, fnd_api.g_miss_char, dbms_lob.substr(piped_sql_from), x_piped_sql_from),
232: PIPED_EXPRESSION_DISP = Decode(X_PIPED_EXPRESSION_DISP, fnd_api.g_miss_char, dbms_lob.substr(piped_expression_disp), x_piped_expression_disp),
233: ATTRIBUTE_CATEGORY = Decode(X_ATTRIBUTE_CATEGORY, fnd_api.g_miss_char, attribute_category, x_attribute_category),

Line 230: PIPED_SQL_SELECT = Decode(X_PIPED_SQL_SELECT, fnd_api.g_miss_char, dbms_lob.substr(piped_sql_select), x_piped_sql_select),

226: EXP_TYPE_CODE = Decode(X_EXP_TYPE_CODE, fnd_api.g_miss_char, exp_type_code, x_exp_type_code),
227: EXPRESSION_DISP = Decode(X_EXPRESSION_DISP, fnd_api.g_miss_char, dbms_lob.substr(expression_disp), x_expression_disp),
228: SQL_SELECT = Decode(X_SQL_SELECT, fnd_api.g_miss_char, dbms_lob.substr(sql_select), x_sql_select),
229: SQL_FROM = Decode(X_SQL_FROM, fnd_api.g_miss_char, dbms_lob.substr(sql_from), x_sql_from),
230: PIPED_SQL_SELECT = Decode(X_PIPED_SQL_SELECT, fnd_api.g_miss_char, dbms_lob.substr(piped_sql_select), x_piped_sql_select),
231: PIPED_SQL_FROM = Decode(X_PIPED_SQL_FROM, fnd_api.g_miss_char, dbms_lob.substr(piped_sql_from), x_piped_sql_from),
232: PIPED_EXPRESSION_DISP = Decode(X_PIPED_EXPRESSION_DISP, fnd_api.g_miss_char, dbms_lob.substr(piped_expression_disp), x_piped_expression_disp),
233: ATTRIBUTE_CATEGORY = Decode(X_ATTRIBUTE_CATEGORY, fnd_api.g_miss_char, attribute_category, x_attribute_category),
234: ATTRIBUTE1 = Decode(X_ATTRIBUTE1, fnd_api.g_miss_char, attribute1, x_attribute1),

Line 231: PIPED_SQL_FROM = Decode(X_PIPED_SQL_FROM, fnd_api.g_miss_char, dbms_lob.substr(piped_sql_from), x_piped_sql_from),

227: EXPRESSION_DISP = Decode(X_EXPRESSION_DISP, fnd_api.g_miss_char, dbms_lob.substr(expression_disp), x_expression_disp),
228: SQL_SELECT = Decode(X_SQL_SELECT, fnd_api.g_miss_char, dbms_lob.substr(sql_select), x_sql_select),
229: SQL_FROM = Decode(X_SQL_FROM, fnd_api.g_miss_char, dbms_lob.substr(sql_from), x_sql_from),
230: PIPED_SQL_SELECT = Decode(X_PIPED_SQL_SELECT, fnd_api.g_miss_char, dbms_lob.substr(piped_sql_select), x_piped_sql_select),
231: PIPED_SQL_FROM = Decode(X_PIPED_SQL_FROM, fnd_api.g_miss_char, dbms_lob.substr(piped_sql_from), x_piped_sql_from),
232: PIPED_EXPRESSION_DISP = Decode(X_PIPED_EXPRESSION_DISP, fnd_api.g_miss_char, dbms_lob.substr(piped_expression_disp), x_piped_expression_disp),
233: ATTRIBUTE_CATEGORY = Decode(X_ATTRIBUTE_CATEGORY, fnd_api.g_miss_char, attribute_category, x_attribute_category),
234: ATTRIBUTE1 = Decode(X_ATTRIBUTE1, fnd_api.g_miss_char, attribute1, x_attribute1),
235: ATTRIBUTE2 = Decode(X_ATTRIBUTE2, fnd_api.g_miss_char, attribute2, x_attribute2),

Line 232: PIPED_EXPRESSION_DISP = Decode(X_PIPED_EXPRESSION_DISP, fnd_api.g_miss_char, dbms_lob.substr(piped_expression_disp), x_piped_expression_disp),

228: SQL_SELECT = Decode(X_SQL_SELECT, fnd_api.g_miss_char, dbms_lob.substr(sql_select), x_sql_select),
229: SQL_FROM = Decode(X_SQL_FROM, fnd_api.g_miss_char, dbms_lob.substr(sql_from), x_sql_from),
230: PIPED_SQL_SELECT = Decode(X_PIPED_SQL_SELECT, fnd_api.g_miss_char, dbms_lob.substr(piped_sql_select), x_piped_sql_select),
231: PIPED_SQL_FROM = Decode(X_PIPED_SQL_FROM, fnd_api.g_miss_char, dbms_lob.substr(piped_sql_from), x_piped_sql_from),
232: PIPED_EXPRESSION_DISP = Decode(X_PIPED_EXPRESSION_DISP, fnd_api.g_miss_char, dbms_lob.substr(piped_expression_disp), x_piped_expression_disp),
233: ATTRIBUTE_CATEGORY = Decode(X_ATTRIBUTE_CATEGORY, fnd_api.g_miss_char, attribute_category, x_attribute_category),
234: ATTRIBUTE1 = Decode(X_ATTRIBUTE1, fnd_api.g_miss_char, attribute1, x_attribute1),
235: ATTRIBUTE2 = Decode(X_ATTRIBUTE2, fnd_api.g_miss_char, attribute2, x_attribute2),
236: ATTRIBUTE3 = Decode(X_ATTRIBUTE3, fnd_api.g_miss_char, attribute3, x_attribute3),

Line 233: ATTRIBUTE_CATEGORY = Decode(X_ATTRIBUTE_CATEGORY, fnd_api.g_miss_char, attribute_category, x_attribute_category),

229: SQL_FROM = Decode(X_SQL_FROM, fnd_api.g_miss_char, dbms_lob.substr(sql_from), x_sql_from),
230: PIPED_SQL_SELECT = Decode(X_PIPED_SQL_SELECT, fnd_api.g_miss_char, dbms_lob.substr(piped_sql_select), x_piped_sql_select),
231: PIPED_SQL_FROM = Decode(X_PIPED_SQL_FROM, fnd_api.g_miss_char, dbms_lob.substr(piped_sql_from), x_piped_sql_from),
232: PIPED_EXPRESSION_DISP = Decode(X_PIPED_EXPRESSION_DISP, fnd_api.g_miss_char, dbms_lob.substr(piped_expression_disp), x_piped_expression_disp),
233: ATTRIBUTE_CATEGORY = Decode(X_ATTRIBUTE_CATEGORY, fnd_api.g_miss_char, attribute_category, x_attribute_category),
234: ATTRIBUTE1 = Decode(X_ATTRIBUTE1, fnd_api.g_miss_char, attribute1, x_attribute1),
235: ATTRIBUTE2 = Decode(X_ATTRIBUTE2, fnd_api.g_miss_char, attribute2, x_attribute2),
236: ATTRIBUTE3 = Decode(X_ATTRIBUTE3, fnd_api.g_miss_char, attribute3, x_attribute3),
237: ATTRIBUTE4 = Decode(X_ATTRIBUTE4, fnd_api.g_miss_char, attribute4, x_attribute4),

Line 234: ATTRIBUTE1 = Decode(X_ATTRIBUTE1, fnd_api.g_miss_char, attribute1, x_attribute1),

230: PIPED_SQL_SELECT = Decode(X_PIPED_SQL_SELECT, fnd_api.g_miss_char, dbms_lob.substr(piped_sql_select), x_piped_sql_select),
231: PIPED_SQL_FROM = Decode(X_PIPED_SQL_FROM, fnd_api.g_miss_char, dbms_lob.substr(piped_sql_from), x_piped_sql_from),
232: PIPED_EXPRESSION_DISP = Decode(X_PIPED_EXPRESSION_DISP, fnd_api.g_miss_char, dbms_lob.substr(piped_expression_disp), x_piped_expression_disp),
233: ATTRIBUTE_CATEGORY = Decode(X_ATTRIBUTE_CATEGORY, fnd_api.g_miss_char, attribute_category, x_attribute_category),
234: ATTRIBUTE1 = Decode(X_ATTRIBUTE1, fnd_api.g_miss_char, attribute1, x_attribute1),
235: ATTRIBUTE2 = Decode(X_ATTRIBUTE2, fnd_api.g_miss_char, attribute2, x_attribute2),
236: ATTRIBUTE3 = Decode(X_ATTRIBUTE3, fnd_api.g_miss_char, attribute3, x_attribute3),
237: ATTRIBUTE4 = Decode(X_ATTRIBUTE4, fnd_api.g_miss_char, attribute4, x_attribute4),
238: ATTRIBUTE5 = Decode(X_ATTRIBUTE5, fnd_api.g_miss_char, attribute5, x_attribute5),

Line 235: ATTRIBUTE2 = Decode(X_ATTRIBUTE2, fnd_api.g_miss_char, attribute2, x_attribute2),

231: PIPED_SQL_FROM = Decode(X_PIPED_SQL_FROM, fnd_api.g_miss_char, dbms_lob.substr(piped_sql_from), x_piped_sql_from),
232: PIPED_EXPRESSION_DISP = Decode(X_PIPED_EXPRESSION_DISP, fnd_api.g_miss_char, dbms_lob.substr(piped_expression_disp), x_piped_expression_disp),
233: ATTRIBUTE_CATEGORY = Decode(X_ATTRIBUTE_CATEGORY, fnd_api.g_miss_char, attribute_category, x_attribute_category),
234: ATTRIBUTE1 = Decode(X_ATTRIBUTE1, fnd_api.g_miss_char, attribute1, x_attribute1),
235: ATTRIBUTE2 = Decode(X_ATTRIBUTE2, fnd_api.g_miss_char, attribute2, x_attribute2),
236: ATTRIBUTE3 = Decode(X_ATTRIBUTE3, fnd_api.g_miss_char, attribute3, x_attribute3),
237: ATTRIBUTE4 = Decode(X_ATTRIBUTE4, fnd_api.g_miss_char, attribute4, x_attribute4),
238: ATTRIBUTE5 = Decode(X_ATTRIBUTE5, fnd_api.g_miss_char, attribute5, x_attribute5),
239: ATTRIBUTE6 = Decode(X_ATTRIBUTE6, fnd_api.g_miss_char, attribute6, x_attribute6),

Line 236: ATTRIBUTE3 = Decode(X_ATTRIBUTE3, fnd_api.g_miss_char, attribute3, x_attribute3),

232: PIPED_EXPRESSION_DISP = Decode(X_PIPED_EXPRESSION_DISP, fnd_api.g_miss_char, dbms_lob.substr(piped_expression_disp), x_piped_expression_disp),
233: ATTRIBUTE_CATEGORY = Decode(X_ATTRIBUTE_CATEGORY, fnd_api.g_miss_char, attribute_category, x_attribute_category),
234: ATTRIBUTE1 = Decode(X_ATTRIBUTE1, fnd_api.g_miss_char, attribute1, x_attribute1),
235: ATTRIBUTE2 = Decode(X_ATTRIBUTE2, fnd_api.g_miss_char, attribute2, x_attribute2),
236: ATTRIBUTE3 = Decode(X_ATTRIBUTE3, fnd_api.g_miss_char, attribute3, x_attribute3),
237: ATTRIBUTE4 = Decode(X_ATTRIBUTE4, fnd_api.g_miss_char, attribute4, x_attribute4),
238: ATTRIBUTE5 = Decode(X_ATTRIBUTE5, fnd_api.g_miss_char, attribute5, x_attribute5),
239: ATTRIBUTE6 = Decode(X_ATTRIBUTE6, fnd_api.g_miss_char, attribute6, x_attribute6),
240: ATTRIBUTE7 = Decode(X_ATTRIBUTE7, fnd_api.g_miss_char, attribute7, x_attribute7),

Line 237: ATTRIBUTE4 = Decode(X_ATTRIBUTE4, fnd_api.g_miss_char, attribute4, x_attribute4),

233: ATTRIBUTE_CATEGORY = Decode(X_ATTRIBUTE_CATEGORY, fnd_api.g_miss_char, attribute_category, x_attribute_category),
234: ATTRIBUTE1 = Decode(X_ATTRIBUTE1, fnd_api.g_miss_char, attribute1, x_attribute1),
235: ATTRIBUTE2 = Decode(X_ATTRIBUTE2, fnd_api.g_miss_char, attribute2, x_attribute2),
236: ATTRIBUTE3 = Decode(X_ATTRIBUTE3, fnd_api.g_miss_char, attribute3, x_attribute3),
237: ATTRIBUTE4 = Decode(X_ATTRIBUTE4, fnd_api.g_miss_char, attribute4, x_attribute4),
238: ATTRIBUTE5 = Decode(X_ATTRIBUTE5, fnd_api.g_miss_char, attribute5, x_attribute5),
239: ATTRIBUTE6 = Decode(X_ATTRIBUTE6, fnd_api.g_miss_char, attribute6, x_attribute6),
240: ATTRIBUTE7 = Decode(X_ATTRIBUTE7, fnd_api.g_miss_char, attribute7, x_attribute7),
241: ATTRIBUTE8 = Decode(X_ATTRIBUTE8, fnd_api.g_miss_char, attribute8, x_attribute8),

Line 238: ATTRIBUTE5 = Decode(X_ATTRIBUTE5, fnd_api.g_miss_char, attribute5, x_attribute5),

234: ATTRIBUTE1 = Decode(X_ATTRIBUTE1, fnd_api.g_miss_char, attribute1, x_attribute1),
235: ATTRIBUTE2 = Decode(X_ATTRIBUTE2, fnd_api.g_miss_char, attribute2, x_attribute2),
236: ATTRIBUTE3 = Decode(X_ATTRIBUTE3, fnd_api.g_miss_char, attribute3, x_attribute3),
237: ATTRIBUTE4 = Decode(X_ATTRIBUTE4, fnd_api.g_miss_char, attribute4, x_attribute4),
238: ATTRIBUTE5 = Decode(X_ATTRIBUTE5, fnd_api.g_miss_char, attribute5, x_attribute5),
239: ATTRIBUTE6 = Decode(X_ATTRIBUTE6, fnd_api.g_miss_char, attribute6, x_attribute6),
240: ATTRIBUTE7 = Decode(X_ATTRIBUTE7, fnd_api.g_miss_char, attribute7, x_attribute7),
241: ATTRIBUTE8 = Decode(X_ATTRIBUTE8, fnd_api.g_miss_char, attribute8, x_attribute8),
242: ATTRIBUTE9 = Decode(X_ATTRIBUTE9, fnd_api.g_miss_char, attribute9, x_attribute9),

Line 239: ATTRIBUTE6 = Decode(X_ATTRIBUTE6, fnd_api.g_miss_char, attribute6, x_attribute6),

235: ATTRIBUTE2 = Decode(X_ATTRIBUTE2, fnd_api.g_miss_char, attribute2, x_attribute2),
236: ATTRIBUTE3 = Decode(X_ATTRIBUTE3, fnd_api.g_miss_char, attribute3, x_attribute3),
237: ATTRIBUTE4 = Decode(X_ATTRIBUTE4, fnd_api.g_miss_char, attribute4, x_attribute4),
238: ATTRIBUTE5 = Decode(X_ATTRIBUTE5, fnd_api.g_miss_char, attribute5, x_attribute5),
239: ATTRIBUTE6 = Decode(X_ATTRIBUTE6, fnd_api.g_miss_char, attribute6, x_attribute6),
240: ATTRIBUTE7 = Decode(X_ATTRIBUTE7, fnd_api.g_miss_char, attribute7, x_attribute7),
241: ATTRIBUTE8 = Decode(X_ATTRIBUTE8, fnd_api.g_miss_char, attribute8, x_attribute8),
242: ATTRIBUTE9 = Decode(X_ATTRIBUTE9, fnd_api.g_miss_char, attribute9, x_attribute9),
243: ATTRIBUTE10 = Decode(X_ATTRIBUTE10, fnd_api.g_miss_char, attribute10, x_attribute10),

Line 240: ATTRIBUTE7 = Decode(X_ATTRIBUTE7, fnd_api.g_miss_char, attribute7, x_attribute7),

236: ATTRIBUTE3 = Decode(X_ATTRIBUTE3, fnd_api.g_miss_char, attribute3, x_attribute3),
237: ATTRIBUTE4 = Decode(X_ATTRIBUTE4, fnd_api.g_miss_char, attribute4, x_attribute4),
238: ATTRIBUTE5 = Decode(X_ATTRIBUTE5, fnd_api.g_miss_char, attribute5, x_attribute5),
239: ATTRIBUTE6 = Decode(X_ATTRIBUTE6, fnd_api.g_miss_char, attribute6, x_attribute6),
240: ATTRIBUTE7 = Decode(X_ATTRIBUTE7, fnd_api.g_miss_char, attribute7, x_attribute7),
241: ATTRIBUTE8 = Decode(X_ATTRIBUTE8, fnd_api.g_miss_char, attribute8, x_attribute8),
242: ATTRIBUTE9 = Decode(X_ATTRIBUTE9, fnd_api.g_miss_char, attribute9, x_attribute9),
243: ATTRIBUTE10 = Decode(X_ATTRIBUTE10, fnd_api.g_miss_char, attribute10, x_attribute10),
244: ATTRIBUTE11 = Decode(X_ATTRIBUTE11, fnd_api.g_miss_char, attribute11, x_attribute11),

Line 241: ATTRIBUTE8 = Decode(X_ATTRIBUTE8, fnd_api.g_miss_char, attribute8, x_attribute8),

237: ATTRIBUTE4 = Decode(X_ATTRIBUTE4, fnd_api.g_miss_char, attribute4, x_attribute4),
238: ATTRIBUTE5 = Decode(X_ATTRIBUTE5, fnd_api.g_miss_char, attribute5, x_attribute5),
239: ATTRIBUTE6 = Decode(X_ATTRIBUTE6, fnd_api.g_miss_char, attribute6, x_attribute6),
240: ATTRIBUTE7 = Decode(X_ATTRIBUTE7, fnd_api.g_miss_char, attribute7, x_attribute7),
241: ATTRIBUTE8 = Decode(X_ATTRIBUTE8, fnd_api.g_miss_char, attribute8, x_attribute8),
242: ATTRIBUTE9 = Decode(X_ATTRIBUTE9, fnd_api.g_miss_char, attribute9, x_attribute9),
243: ATTRIBUTE10 = Decode(X_ATTRIBUTE10, fnd_api.g_miss_char, attribute10, x_attribute10),
244: ATTRIBUTE11 = Decode(X_ATTRIBUTE11, fnd_api.g_miss_char, attribute11, x_attribute11),
245: ATTRIBUTE12 = Decode(X_ATTRIBUTE12, fnd_api.g_miss_char, attribute12, x_attribute12),

Line 242: ATTRIBUTE9 = Decode(X_ATTRIBUTE9, fnd_api.g_miss_char, attribute9, x_attribute9),

238: ATTRIBUTE5 = Decode(X_ATTRIBUTE5, fnd_api.g_miss_char, attribute5, x_attribute5),
239: ATTRIBUTE6 = Decode(X_ATTRIBUTE6, fnd_api.g_miss_char, attribute6, x_attribute6),
240: ATTRIBUTE7 = Decode(X_ATTRIBUTE7, fnd_api.g_miss_char, attribute7, x_attribute7),
241: ATTRIBUTE8 = Decode(X_ATTRIBUTE8, fnd_api.g_miss_char, attribute8, x_attribute8),
242: ATTRIBUTE9 = Decode(X_ATTRIBUTE9, fnd_api.g_miss_char, attribute9, x_attribute9),
243: ATTRIBUTE10 = Decode(X_ATTRIBUTE10, fnd_api.g_miss_char, attribute10, x_attribute10),
244: ATTRIBUTE11 = Decode(X_ATTRIBUTE11, fnd_api.g_miss_char, attribute11, x_attribute11),
245: ATTRIBUTE12 = Decode(X_ATTRIBUTE12, fnd_api.g_miss_char, attribute12, x_attribute12),
246: ATTRIBUTE13 = Decode(X_ATTRIBUTE13, fnd_api.g_miss_char, attribute13, x_attribute13),

Line 243: ATTRIBUTE10 = Decode(X_ATTRIBUTE10, fnd_api.g_miss_char, attribute10, x_attribute10),

239: ATTRIBUTE6 = Decode(X_ATTRIBUTE6, fnd_api.g_miss_char, attribute6, x_attribute6),
240: ATTRIBUTE7 = Decode(X_ATTRIBUTE7, fnd_api.g_miss_char, attribute7, x_attribute7),
241: ATTRIBUTE8 = Decode(X_ATTRIBUTE8, fnd_api.g_miss_char, attribute8, x_attribute8),
242: ATTRIBUTE9 = Decode(X_ATTRIBUTE9, fnd_api.g_miss_char, attribute9, x_attribute9),
243: ATTRIBUTE10 = Decode(X_ATTRIBUTE10, fnd_api.g_miss_char, attribute10, x_attribute10),
244: ATTRIBUTE11 = Decode(X_ATTRIBUTE11, fnd_api.g_miss_char, attribute11, x_attribute11),
245: ATTRIBUTE12 = Decode(X_ATTRIBUTE12, fnd_api.g_miss_char, attribute12, x_attribute12),
246: ATTRIBUTE13 = Decode(X_ATTRIBUTE13, fnd_api.g_miss_char, attribute13, x_attribute13),
247: ATTRIBUTE14 = Decode(X_ATTRIBUTE14, fnd_api.g_miss_char, attribute14, x_attribute14),

Line 244: ATTRIBUTE11 = Decode(X_ATTRIBUTE11, fnd_api.g_miss_char, attribute11, x_attribute11),

240: ATTRIBUTE7 = Decode(X_ATTRIBUTE7, fnd_api.g_miss_char, attribute7, x_attribute7),
241: ATTRIBUTE8 = Decode(X_ATTRIBUTE8, fnd_api.g_miss_char, attribute8, x_attribute8),
242: ATTRIBUTE9 = Decode(X_ATTRIBUTE9, fnd_api.g_miss_char, attribute9, x_attribute9),
243: ATTRIBUTE10 = Decode(X_ATTRIBUTE10, fnd_api.g_miss_char, attribute10, x_attribute10),
244: ATTRIBUTE11 = Decode(X_ATTRIBUTE11, fnd_api.g_miss_char, attribute11, x_attribute11),
245: ATTRIBUTE12 = Decode(X_ATTRIBUTE12, fnd_api.g_miss_char, attribute12, x_attribute12),
246: ATTRIBUTE13 = Decode(X_ATTRIBUTE13, fnd_api.g_miss_char, attribute13, x_attribute13),
247: ATTRIBUTE14 = Decode(X_ATTRIBUTE14, fnd_api.g_miss_char, attribute14, x_attribute14),
248: ATTRIBUTE15 = Decode(X_ATTRIBUTE15, fnd_api.g_miss_char, attribute15, x_attribute15),

Line 245: ATTRIBUTE12 = Decode(X_ATTRIBUTE12, fnd_api.g_miss_char, attribute12, x_attribute12),

241: ATTRIBUTE8 = Decode(X_ATTRIBUTE8, fnd_api.g_miss_char, attribute8, x_attribute8),
242: ATTRIBUTE9 = Decode(X_ATTRIBUTE9, fnd_api.g_miss_char, attribute9, x_attribute9),
243: ATTRIBUTE10 = Decode(X_ATTRIBUTE10, fnd_api.g_miss_char, attribute10, x_attribute10),
244: ATTRIBUTE11 = Decode(X_ATTRIBUTE11, fnd_api.g_miss_char, attribute11, x_attribute11),
245: ATTRIBUTE12 = Decode(X_ATTRIBUTE12, fnd_api.g_miss_char, attribute12, x_attribute12),
246: ATTRIBUTE13 = Decode(X_ATTRIBUTE13, fnd_api.g_miss_char, attribute13, x_attribute13),
247: ATTRIBUTE14 = Decode(X_ATTRIBUTE14, fnd_api.g_miss_char, attribute14, x_attribute14),
248: ATTRIBUTE15 = Decode(X_ATTRIBUTE15, fnd_api.g_miss_char, attribute15, x_attribute15),
249: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 246: ATTRIBUTE13 = Decode(X_ATTRIBUTE13, fnd_api.g_miss_char, attribute13, x_attribute13),

242: ATTRIBUTE9 = Decode(X_ATTRIBUTE9, fnd_api.g_miss_char, attribute9, x_attribute9),
243: ATTRIBUTE10 = Decode(X_ATTRIBUTE10, fnd_api.g_miss_char, attribute10, x_attribute10),
244: ATTRIBUTE11 = Decode(X_ATTRIBUTE11, fnd_api.g_miss_char, attribute11, x_attribute11),
245: ATTRIBUTE12 = Decode(X_ATTRIBUTE12, fnd_api.g_miss_char, attribute12, x_attribute12),
246: ATTRIBUTE13 = Decode(X_ATTRIBUTE13, fnd_api.g_miss_char, attribute13, x_attribute13),
247: ATTRIBUTE14 = Decode(X_ATTRIBUTE14, fnd_api.g_miss_char, attribute14, x_attribute14),
248: ATTRIBUTE15 = Decode(X_ATTRIBUTE15, fnd_api.g_miss_char, attribute15, x_attribute15),
249: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
250: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 247: ATTRIBUTE14 = Decode(X_ATTRIBUTE14, fnd_api.g_miss_char, attribute14, x_attribute14),

243: ATTRIBUTE10 = Decode(X_ATTRIBUTE10, fnd_api.g_miss_char, attribute10, x_attribute10),
244: ATTRIBUTE11 = Decode(X_ATTRIBUTE11, fnd_api.g_miss_char, attribute11, x_attribute11),
245: ATTRIBUTE12 = Decode(X_ATTRIBUTE12, fnd_api.g_miss_char, attribute12, x_attribute12),
246: ATTRIBUTE13 = Decode(X_ATTRIBUTE13, fnd_api.g_miss_char, attribute13, x_attribute13),
247: ATTRIBUTE14 = Decode(X_ATTRIBUTE14, fnd_api.g_miss_char, attribute14, x_attribute14),
248: ATTRIBUTE15 = Decode(X_ATTRIBUTE15, fnd_api.g_miss_char, attribute15, x_attribute15),
249: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
250: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
251: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 248: ATTRIBUTE15 = Decode(X_ATTRIBUTE15, fnd_api.g_miss_char, attribute15, x_attribute15),

244: ATTRIBUTE11 = Decode(X_ATTRIBUTE11, fnd_api.g_miss_char, attribute11, x_attribute11),
245: ATTRIBUTE12 = Decode(X_ATTRIBUTE12, fnd_api.g_miss_char, attribute12, x_attribute12),
246: ATTRIBUTE13 = Decode(X_ATTRIBUTE13, fnd_api.g_miss_char, attribute13, x_attribute13),
247: ATTRIBUTE14 = Decode(X_ATTRIBUTE14, fnd_api.g_miss_char, attribute14, x_attribute14),
248: ATTRIBUTE15 = Decode(X_ATTRIBUTE15, fnd_api.g_miss_char, attribute15, x_attribute15),
249: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
250: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
251: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
252: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER

Line 269: raise fnd_api.g_exc_unexpected_error;

265:
266: if (sql%notfound) then
267: fnd_message.set_name('CN', 'CN_RECORD_DELETED');
268: fnd_msg_pub.add;
269: raise fnd_api.g_exc_unexpected_error;
270: end if;
271:
272: end DELETE_ROW;
273: