156: procedure UPDATE_ROW
157: (X_FORMULA_INPUT_ID IN CN_FORMULA_INPUTS.FORMULA_INPUT_ID%TYPE,
158: X_CALC_FORMULA_ID IN CN_FORMULA_INPUTS.CALC_FORMULA_ID%TYPE,
159: X_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.CALC_SQL_EXP_ID%TYPE,
160: X_F_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.F_CALC_SQL_EXP_ID%TYPE := CN_API.G_MISS_NUM,
161: X_RATE_DIM_SEQUENCE IN CN_FORMULA_INPUTS.RATE_DIM_SEQUENCE%TYPE,
162: X_CUMULATIVE_FLAG IN CN_FORMULA_INPUTS.CUMULATIVE_FLAG%TYPE,
163: X_SPLIT_FLAG IN CN_FORMULA_INPUTS.SPLIT_FLAG%TYPE,
164: X_ATTRIBUTE_CATEGORY IN CN_FORMULA_INPUTS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
160: X_F_CALC_SQL_EXP_ID IN CN_FORMULA_INPUTS.F_CALC_SQL_EXP_ID%TYPE := CN_API.G_MISS_NUM,
161: X_RATE_DIM_SEQUENCE IN CN_FORMULA_INPUTS.RATE_DIM_SEQUENCE%TYPE,
162: X_CUMULATIVE_FLAG IN CN_FORMULA_INPUTS.CUMULATIVE_FLAG%TYPE,
163: X_SPLIT_FLAG IN CN_FORMULA_INPUTS.SPLIT_FLAG%TYPE,
164: X_ATTRIBUTE_CATEGORY IN CN_FORMULA_INPUTS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
165: X_ATTRIBUTE1 IN CN_FORMULA_INPUTS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
166: X_ATTRIBUTE2 IN CN_FORMULA_INPUTS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
167: X_ATTRIBUTE3 IN CN_FORMULA_INPUTS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
168: X_ATTRIBUTE4 IN CN_FORMULA_INPUTS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
161: X_RATE_DIM_SEQUENCE IN CN_FORMULA_INPUTS.RATE_DIM_SEQUENCE%TYPE,
162: X_CUMULATIVE_FLAG IN CN_FORMULA_INPUTS.CUMULATIVE_FLAG%TYPE,
163: X_SPLIT_FLAG IN CN_FORMULA_INPUTS.SPLIT_FLAG%TYPE,
164: X_ATTRIBUTE_CATEGORY IN CN_FORMULA_INPUTS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
165: X_ATTRIBUTE1 IN CN_FORMULA_INPUTS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
166: X_ATTRIBUTE2 IN CN_FORMULA_INPUTS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
167: X_ATTRIBUTE3 IN CN_FORMULA_INPUTS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
168: X_ATTRIBUTE4 IN CN_FORMULA_INPUTS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
169: X_ATTRIBUTE5 IN CN_FORMULA_INPUTS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
162: X_CUMULATIVE_FLAG IN CN_FORMULA_INPUTS.CUMULATIVE_FLAG%TYPE,
163: X_SPLIT_FLAG IN CN_FORMULA_INPUTS.SPLIT_FLAG%TYPE,
164: X_ATTRIBUTE_CATEGORY IN CN_FORMULA_INPUTS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
165: X_ATTRIBUTE1 IN CN_FORMULA_INPUTS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
166: X_ATTRIBUTE2 IN CN_FORMULA_INPUTS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
167: X_ATTRIBUTE3 IN CN_FORMULA_INPUTS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
168: X_ATTRIBUTE4 IN CN_FORMULA_INPUTS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
169: X_ATTRIBUTE5 IN CN_FORMULA_INPUTS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
170: X_ATTRIBUTE6 IN CN_FORMULA_INPUTS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
163: X_SPLIT_FLAG IN CN_FORMULA_INPUTS.SPLIT_FLAG%TYPE,
164: X_ATTRIBUTE_CATEGORY IN CN_FORMULA_INPUTS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
165: X_ATTRIBUTE1 IN CN_FORMULA_INPUTS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
166: X_ATTRIBUTE2 IN CN_FORMULA_INPUTS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
167: X_ATTRIBUTE3 IN CN_FORMULA_INPUTS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
168: X_ATTRIBUTE4 IN CN_FORMULA_INPUTS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
169: X_ATTRIBUTE5 IN CN_FORMULA_INPUTS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
170: X_ATTRIBUTE6 IN CN_FORMULA_INPUTS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
171: X_ATTRIBUTE7 IN CN_FORMULA_INPUTS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
164: X_ATTRIBUTE_CATEGORY IN CN_FORMULA_INPUTS.ATTRIBUTE_CATEGORY%TYPE := CN_API.G_MISS_CHAR,
165: X_ATTRIBUTE1 IN CN_FORMULA_INPUTS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
166: X_ATTRIBUTE2 IN CN_FORMULA_INPUTS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
167: X_ATTRIBUTE3 IN CN_FORMULA_INPUTS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
168: X_ATTRIBUTE4 IN CN_FORMULA_INPUTS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
169: X_ATTRIBUTE5 IN CN_FORMULA_INPUTS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
170: X_ATTRIBUTE6 IN CN_FORMULA_INPUTS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
171: X_ATTRIBUTE7 IN CN_FORMULA_INPUTS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
172: X_ATTRIBUTE8 IN CN_FORMULA_INPUTS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
165: X_ATTRIBUTE1 IN CN_FORMULA_INPUTS.ATTRIBUTE1%TYPE := CN_API.G_MISS_CHAR,
166: X_ATTRIBUTE2 IN CN_FORMULA_INPUTS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
167: X_ATTRIBUTE3 IN CN_FORMULA_INPUTS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
168: X_ATTRIBUTE4 IN CN_FORMULA_INPUTS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
169: X_ATTRIBUTE5 IN CN_FORMULA_INPUTS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
170: X_ATTRIBUTE6 IN CN_FORMULA_INPUTS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
171: X_ATTRIBUTE7 IN CN_FORMULA_INPUTS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
172: X_ATTRIBUTE8 IN CN_FORMULA_INPUTS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
173: X_ATTRIBUTE9 IN CN_FORMULA_INPUTS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
166: X_ATTRIBUTE2 IN CN_FORMULA_INPUTS.ATTRIBUTE2%TYPE := CN_API.G_MISS_CHAR,
167: X_ATTRIBUTE3 IN CN_FORMULA_INPUTS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
168: X_ATTRIBUTE4 IN CN_FORMULA_INPUTS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
169: X_ATTRIBUTE5 IN CN_FORMULA_INPUTS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
170: X_ATTRIBUTE6 IN CN_FORMULA_INPUTS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
171: X_ATTRIBUTE7 IN CN_FORMULA_INPUTS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
172: X_ATTRIBUTE8 IN CN_FORMULA_INPUTS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
173: X_ATTRIBUTE9 IN CN_FORMULA_INPUTS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
174: X_ATTRIBUTE10 IN CN_FORMULA_INPUTS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
167: X_ATTRIBUTE3 IN CN_FORMULA_INPUTS.ATTRIBUTE3%TYPE := CN_API.G_MISS_CHAR,
168: X_ATTRIBUTE4 IN CN_FORMULA_INPUTS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
169: X_ATTRIBUTE5 IN CN_FORMULA_INPUTS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
170: X_ATTRIBUTE6 IN CN_FORMULA_INPUTS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
171: X_ATTRIBUTE7 IN CN_FORMULA_INPUTS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
172: X_ATTRIBUTE8 IN CN_FORMULA_INPUTS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
173: X_ATTRIBUTE9 IN CN_FORMULA_INPUTS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
174: X_ATTRIBUTE10 IN CN_FORMULA_INPUTS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
175: X_ATTRIBUTE11 IN CN_FORMULA_INPUTS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
168: X_ATTRIBUTE4 IN CN_FORMULA_INPUTS.ATTRIBUTE4%TYPE := CN_API.G_MISS_CHAR,
169: X_ATTRIBUTE5 IN CN_FORMULA_INPUTS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
170: X_ATTRIBUTE6 IN CN_FORMULA_INPUTS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
171: X_ATTRIBUTE7 IN CN_FORMULA_INPUTS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
172: X_ATTRIBUTE8 IN CN_FORMULA_INPUTS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
173: X_ATTRIBUTE9 IN CN_FORMULA_INPUTS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
174: X_ATTRIBUTE10 IN CN_FORMULA_INPUTS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
175: X_ATTRIBUTE11 IN CN_FORMULA_INPUTS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
176: X_ATTRIBUTE12 IN CN_FORMULA_INPUTS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
169: X_ATTRIBUTE5 IN CN_FORMULA_INPUTS.ATTRIBUTE5%TYPE := CN_API.G_MISS_CHAR,
170: X_ATTRIBUTE6 IN CN_FORMULA_INPUTS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
171: X_ATTRIBUTE7 IN CN_FORMULA_INPUTS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
172: X_ATTRIBUTE8 IN CN_FORMULA_INPUTS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
173: X_ATTRIBUTE9 IN CN_FORMULA_INPUTS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
174: X_ATTRIBUTE10 IN CN_FORMULA_INPUTS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
175: X_ATTRIBUTE11 IN CN_FORMULA_INPUTS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
176: X_ATTRIBUTE12 IN CN_FORMULA_INPUTS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
177: X_ATTRIBUTE13 IN CN_FORMULA_INPUTS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
170: X_ATTRIBUTE6 IN CN_FORMULA_INPUTS.ATTRIBUTE6%TYPE := CN_API.G_MISS_CHAR,
171: X_ATTRIBUTE7 IN CN_FORMULA_INPUTS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
172: X_ATTRIBUTE8 IN CN_FORMULA_INPUTS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
173: X_ATTRIBUTE9 IN CN_FORMULA_INPUTS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
174: X_ATTRIBUTE10 IN CN_FORMULA_INPUTS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
175: X_ATTRIBUTE11 IN CN_FORMULA_INPUTS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
176: X_ATTRIBUTE12 IN CN_FORMULA_INPUTS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
177: X_ATTRIBUTE13 IN CN_FORMULA_INPUTS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
178: X_ATTRIBUTE14 IN CN_FORMULA_INPUTS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
171: X_ATTRIBUTE7 IN CN_FORMULA_INPUTS.ATTRIBUTE7%TYPE := CN_API.G_MISS_CHAR,
172: X_ATTRIBUTE8 IN CN_FORMULA_INPUTS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
173: X_ATTRIBUTE9 IN CN_FORMULA_INPUTS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
174: X_ATTRIBUTE10 IN CN_FORMULA_INPUTS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
175: X_ATTRIBUTE11 IN CN_FORMULA_INPUTS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
176: X_ATTRIBUTE12 IN CN_FORMULA_INPUTS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
177: X_ATTRIBUTE13 IN CN_FORMULA_INPUTS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
178: X_ATTRIBUTE14 IN CN_FORMULA_INPUTS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
179: X_ATTRIBUTE15 IN CN_FORMULA_INPUTS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
172: X_ATTRIBUTE8 IN CN_FORMULA_INPUTS.ATTRIBUTE8%TYPE := CN_API.G_MISS_CHAR,
173: X_ATTRIBUTE9 IN CN_FORMULA_INPUTS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
174: X_ATTRIBUTE10 IN CN_FORMULA_INPUTS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
175: X_ATTRIBUTE11 IN CN_FORMULA_INPUTS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
176: X_ATTRIBUTE12 IN CN_FORMULA_INPUTS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
177: X_ATTRIBUTE13 IN CN_FORMULA_INPUTS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
178: X_ATTRIBUTE14 IN CN_FORMULA_INPUTS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
179: X_ATTRIBUTE15 IN CN_FORMULA_INPUTS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
180: X_OBJECT_VERSION_NUMBER IN CN_FORMULA_INPUTS.OBJECT_VERSION_NUMBER%TYPE,
173: X_ATTRIBUTE9 IN CN_FORMULA_INPUTS.ATTRIBUTE9%TYPE := CN_API.G_MISS_CHAR,
174: X_ATTRIBUTE10 IN CN_FORMULA_INPUTS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
175: X_ATTRIBUTE11 IN CN_FORMULA_INPUTS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
176: X_ATTRIBUTE12 IN CN_FORMULA_INPUTS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
177: X_ATTRIBUTE13 IN CN_FORMULA_INPUTS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
178: X_ATTRIBUTE14 IN CN_FORMULA_INPUTS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
179: X_ATTRIBUTE15 IN CN_FORMULA_INPUTS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
180: X_OBJECT_VERSION_NUMBER IN CN_FORMULA_INPUTS.OBJECT_VERSION_NUMBER%TYPE,
181: X_LAST_UPDATE_DATE IN CN_FORMULA_INPUTS.LAST_UPDATE_DATE%TYPE := SYSDATE,
174: X_ATTRIBUTE10 IN CN_FORMULA_INPUTS.ATTRIBUTE10%TYPE := CN_API.G_MISS_CHAR,
175: X_ATTRIBUTE11 IN CN_FORMULA_INPUTS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
176: X_ATTRIBUTE12 IN CN_FORMULA_INPUTS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
177: X_ATTRIBUTE13 IN CN_FORMULA_INPUTS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
178: X_ATTRIBUTE14 IN CN_FORMULA_INPUTS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
179: X_ATTRIBUTE15 IN CN_FORMULA_INPUTS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
180: X_OBJECT_VERSION_NUMBER IN CN_FORMULA_INPUTS.OBJECT_VERSION_NUMBER%TYPE,
181: X_LAST_UPDATE_DATE IN CN_FORMULA_INPUTS.LAST_UPDATE_DATE%TYPE := SYSDATE,
182: X_LAST_UPDATED_BY IN CN_FORMULA_INPUTS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
175: X_ATTRIBUTE11 IN CN_FORMULA_INPUTS.ATTRIBUTE11%TYPE := CN_API.G_MISS_CHAR,
176: X_ATTRIBUTE12 IN CN_FORMULA_INPUTS.ATTRIBUTE12%TYPE := CN_API.G_MISS_CHAR,
177: X_ATTRIBUTE13 IN CN_FORMULA_INPUTS.ATTRIBUTE13%TYPE := CN_API.G_MISS_CHAR,
178: X_ATTRIBUTE14 IN CN_FORMULA_INPUTS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
179: X_ATTRIBUTE15 IN CN_FORMULA_INPUTS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
180: X_OBJECT_VERSION_NUMBER IN CN_FORMULA_INPUTS.OBJECT_VERSION_NUMBER%TYPE,
181: X_LAST_UPDATE_DATE IN CN_FORMULA_INPUTS.LAST_UPDATE_DATE%TYPE := SYSDATE,
182: X_LAST_UPDATED_BY IN CN_FORMULA_INPUTS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
183: X_LAST_UPDATE_LOGIN IN CN_FORMULA_INPUTS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS