APPS.CN_RATE_DIM_TIERS_PKG dependencies on FND_API

Line 153: raise fnd_api.g_exc_unexpected_error;

149: if (c%notfound) then
150: close c;
151: fnd_message.set_name('CN', 'CN_RECORD_DELETED');
152: fnd_msg_pub.add;
153: raise fnd_api.g_exc_unexpected_error;
154: end if;
155: close c;
156:
157: if (tlinfo.object_version_number <> x_object_version_number) then

Line 160: raise fnd_api.g_exc_unexpected_error;

156:
157: if (tlinfo.object_version_number <> x_object_version_number) then
158: fnd_message.set_name('CN', 'CN_RECORD_CHANGED');
159: fnd_msg_pub.add;
160: raise fnd_api.g_exc_unexpected_error;
161: end if;
162:
163: END LOCK_ROW;
164:

Line 168: X_DIM_UNIT_CODE IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE := FND_API.G_MISS_CHAR,

164:
165: procedure UPDATE_ROW (
166: X_RATE_DIM_TIER_ID IN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE,
167: X_RATE_DIMENSION_ID IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
168: X_DIM_UNIT_CODE IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE := FND_API.G_MISS_CHAR,
169: X_MINIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := FND_API.G_MISS_NUM,
170: X_MAXIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := FND_API.G_MISS_NUM,
171: X_MIN_EXP_ID IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := FND_API.G_MISS_NUM,
172: X_MAX_EXP_ID IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := FND_API.G_MISS_NUM,

Line 169: X_MINIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := FND_API.G_MISS_NUM,

165: procedure UPDATE_ROW (
166: X_RATE_DIM_TIER_ID IN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE,
167: X_RATE_DIMENSION_ID IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
168: X_DIM_UNIT_CODE IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE := FND_API.G_MISS_CHAR,
169: X_MINIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := FND_API.G_MISS_NUM,
170: X_MAXIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := FND_API.G_MISS_NUM,
171: X_MIN_EXP_ID IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := FND_API.G_MISS_NUM,
172: X_MAX_EXP_ID IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := FND_API.G_MISS_NUM,
173: X_STRING_VALUE IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := FND_API.G_MISS_CHAR,

Line 170: X_MAXIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := FND_API.G_MISS_NUM,

166: X_RATE_DIM_TIER_ID IN CN_RATE_DIM_TIERS.RATE_DIM_TIER_ID%TYPE,
167: X_RATE_DIMENSION_ID IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
168: X_DIM_UNIT_CODE IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE := FND_API.G_MISS_CHAR,
169: X_MINIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := FND_API.G_MISS_NUM,
170: X_MAXIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := FND_API.G_MISS_NUM,
171: X_MIN_EXP_ID IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := FND_API.G_MISS_NUM,
172: X_MAX_EXP_ID IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := FND_API.G_MISS_NUM,
173: X_STRING_VALUE IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := FND_API.G_MISS_CHAR,
174: X_TIER_SEQUENCE IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := FND_API.G_MISS_NUM,

Line 171: X_MIN_EXP_ID IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := FND_API.G_MISS_NUM,

167: X_RATE_DIMENSION_ID IN CN_RATE_DIM_TIERS.RATE_DIMENSION_ID%TYPE,
168: X_DIM_UNIT_CODE IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE := FND_API.G_MISS_CHAR,
169: X_MINIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := FND_API.G_MISS_NUM,
170: X_MAXIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := FND_API.G_MISS_NUM,
171: X_MIN_EXP_ID IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := FND_API.G_MISS_NUM,
172: X_MAX_EXP_ID IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := FND_API.G_MISS_NUM,
173: X_STRING_VALUE IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := FND_API.G_MISS_CHAR,
174: X_TIER_SEQUENCE IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := FND_API.G_MISS_NUM,
175: X_ATTRIBUTE_CATEGORY IN CN_RATE_DIM_TIERS.ATTRIBUTE_CATEGORY%TYPE := FND_API.G_MISS_CHAR,

Line 172: X_MAX_EXP_ID IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := FND_API.G_MISS_NUM,

168: X_DIM_UNIT_CODE IN CN_RATE_DIM_TIERS.DIM_UNIT_CODE%TYPE := FND_API.G_MISS_CHAR,
169: X_MINIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := FND_API.G_MISS_NUM,
170: X_MAXIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := FND_API.G_MISS_NUM,
171: X_MIN_EXP_ID IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := FND_API.G_MISS_NUM,
172: X_MAX_EXP_ID IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := FND_API.G_MISS_NUM,
173: X_STRING_VALUE IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := FND_API.G_MISS_CHAR,
174: X_TIER_SEQUENCE IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := FND_API.G_MISS_NUM,
175: X_ATTRIBUTE_CATEGORY IN CN_RATE_DIM_TIERS.ATTRIBUTE_CATEGORY%TYPE := FND_API.G_MISS_CHAR,
176: X_ATTRIBUTE1 IN CN_RATE_DIM_TIERS.ATTRIBUTE1%TYPE := FND_API.G_MISS_CHAR,

Line 173: X_STRING_VALUE IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := FND_API.G_MISS_CHAR,

169: X_MINIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MINIMUM_AMOUNT%TYPE := FND_API.G_MISS_NUM,
170: X_MAXIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := FND_API.G_MISS_NUM,
171: X_MIN_EXP_ID IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := FND_API.G_MISS_NUM,
172: X_MAX_EXP_ID IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := FND_API.G_MISS_NUM,
173: X_STRING_VALUE IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := FND_API.G_MISS_CHAR,
174: X_TIER_SEQUENCE IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := FND_API.G_MISS_NUM,
175: X_ATTRIBUTE_CATEGORY IN CN_RATE_DIM_TIERS.ATTRIBUTE_CATEGORY%TYPE := FND_API.G_MISS_CHAR,
176: X_ATTRIBUTE1 IN CN_RATE_DIM_TIERS.ATTRIBUTE1%TYPE := FND_API.G_MISS_CHAR,
177: X_ATTRIBUTE2 IN CN_RATE_DIM_TIERS.ATTRIBUTE2%TYPE := FND_API.G_MISS_CHAR,

Line 174: X_TIER_SEQUENCE IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := FND_API.G_MISS_NUM,

170: X_MAXIMUM_AMOUNT IN CN_RATE_DIM_TIERS.MAXIMUM_AMOUNT%TYPE := FND_API.G_MISS_NUM,
171: X_MIN_EXP_ID IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := FND_API.G_MISS_NUM,
172: X_MAX_EXP_ID IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := FND_API.G_MISS_NUM,
173: X_STRING_VALUE IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := FND_API.G_MISS_CHAR,
174: X_TIER_SEQUENCE IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := FND_API.G_MISS_NUM,
175: X_ATTRIBUTE_CATEGORY IN CN_RATE_DIM_TIERS.ATTRIBUTE_CATEGORY%TYPE := FND_API.G_MISS_CHAR,
176: X_ATTRIBUTE1 IN CN_RATE_DIM_TIERS.ATTRIBUTE1%TYPE := FND_API.G_MISS_CHAR,
177: X_ATTRIBUTE2 IN CN_RATE_DIM_TIERS.ATTRIBUTE2%TYPE := FND_API.G_MISS_CHAR,
178: X_ATTRIBUTE3 IN CN_RATE_DIM_TIERS.ATTRIBUTE3%TYPE := FND_API.G_MISS_CHAR,

Line 175: X_ATTRIBUTE_CATEGORY IN CN_RATE_DIM_TIERS.ATTRIBUTE_CATEGORY%TYPE := FND_API.G_MISS_CHAR,

171: X_MIN_EXP_ID IN CN_RATE_DIM_TIERS.MIN_EXP_ID%TYPE := FND_API.G_MISS_NUM,
172: X_MAX_EXP_ID IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := FND_API.G_MISS_NUM,
173: X_STRING_VALUE IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := FND_API.G_MISS_CHAR,
174: X_TIER_SEQUENCE IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := FND_API.G_MISS_NUM,
175: X_ATTRIBUTE_CATEGORY IN CN_RATE_DIM_TIERS.ATTRIBUTE_CATEGORY%TYPE := FND_API.G_MISS_CHAR,
176: X_ATTRIBUTE1 IN CN_RATE_DIM_TIERS.ATTRIBUTE1%TYPE := FND_API.G_MISS_CHAR,
177: X_ATTRIBUTE2 IN CN_RATE_DIM_TIERS.ATTRIBUTE2%TYPE := FND_API.G_MISS_CHAR,
178: X_ATTRIBUTE3 IN CN_RATE_DIM_TIERS.ATTRIBUTE3%TYPE := FND_API.G_MISS_CHAR,
179: X_ATTRIBUTE4 IN CN_RATE_DIM_TIERS.ATTRIBUTE4%TYPE := FND_API.G_MISS_CHAR,

Line 176: X_ATTRIBUTE1 IN CN_RATE_DIM_TIERS.ATTRIBUTE1%TYPE := FND_API.G_MISS_CHAR,

172: X_MAX_EXP_ID IN CN_RATE_DIM_TIERS.MAX_EXP_ID%TYPE := FND_API.G_MISS_NUM,
173: X_STRING_VALUE IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := FND_API.G_MISS_CHAR,
174: X_TIER_SEQUENCE IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := FND_API.G_MISS_NUM,
175: X_ATTRIBUTE_CATEGORY IN CN_RATE_DIM_TIERS.ATTRIBUTE_CATEGORY%TYPE := FND_API.G_MISS_CHAR,
176: X_ATTRIBUTE1 IN CN_RATE_DIM_TIERS.ATTRIBUTE1%TYPE := FND_API.G_MISS_CHAR,
177: X_ATTRIBUTE2 IN CN_RATE_DIM_TIERS.ATTRIBUTE2%TYPE := FND_API.G_MISS_CHAR,
178: X_ATTRIBUTE3 IN CN_RATE_DIM_TIERS.ATTRIBUTE3%TYPE := FND_API.G_MISS_CHAR,
179: X_ATTRIBUTE4 IN CN_RATE_DIM_TIERS.ATTRIBUTE4%TYPE := FND_API.G_MISS_CHAR,
180: X_ATTRIBUTE5 IN CN_RATE_DIM_TIERS.ATTRIBUTE5%TYPE := FND_API.G_MISS_CHAR,

Line 177: X_ATTRIBUTE2 IN CN_RATE_DIM_TIERS.ATTRIBUTE2%TYPE := FND_API.G_MISS_CHAR,

173: X_STRING_VALUE IN CN_RATE_DIM_TIERS.STRING_VALUE%TYPE := FND_API.G_MISS_CHAR,
174: X_TIER_SEQUENCE IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := FND_API.G_MISS_NUM,
175: X_ATTRIBUTE_CATEGORY IN CN_RATE_DIM_TIERS.ATTRIBUTE_CATEGORY%TYPE := FND_API.G_MISS_CHAR,
176: X_ATTRIBUTE1 IN CN_RATE_DIM_TIERS.ATTRIBUTE1%TYPE := FND_API.G_MISS_CHAR,
177: X_ATTRIBUTE2 IN CN_RATE_DIM_TIERS.ATTRIBUTE2%TYPE := FND_API.G_MISS_CHAR,
178: X_ATTRIBUTE3 IN CN_RATE_DIM_TIERS.ATTRIBUTE3%TYPE := FND_API.G_MISS_CHAR,
179: X_ATTRIBUTE4 IN CN_RATE_DIM_TIERS.ATTRIBUTE4%TYPE := FND_API.G_MISS_CHAR,
180: X_ATTRIBUTE5 IN CN_RATE_DIM_TIERS.ATTRIBUTE5%TYPE := FND_API.G_MISS_CHAR,
181: X_ATTRIBUTE6 IN CN_RATE_DIM_TIERS.ATTRIBUTE6%TYPE := FND_API.G_MISS_CHAR,

Line 178: X_ATTRIBUTE3 IN CN_RATE_DIM_TIERS.ATTRIBUTE3%TYPE := FND_API.G_MISS_CHAR,

174: X_TIER_SEQUENCE IN CN_RATE_DIM_TIERS.TIER_SEQUENCE%TYPE := FND_API.G_MISS_NUM,
175: X_ATTRIBUTE_CATEGORY IN CN_RATE_DIM_TIERS.ATTRIBUTE_CATEGORY%TYPE := FND_API.G_MISS_CHAR,
176: X_ATTRIBUTE1 IN CN_RATE_DIM_TIERS.ATTRIBUTE1%TYPE := FND_API.G_MISS_CHAR,
177: X_ATTRIBUTE2 IN CN_RATE_DIM_TIERS.ATTRIBUTE2%TYPE := FND_API.G_MISS_CHAR,
178: X_ATTRIBUTE3 IN CN_RATE_DIM_TIERS.ATTRIBUTE3%TYPE := FND_API.G_MISS_CHAR,
179: X_ATTRIBUTE4 IN CN_RATE_DIM_TIERS.ATTRIBUTE4%TYPE := FND_API.G_MISS_CHAR,
180: X_ATTRIBUTE5 IN CN_RATE_DIM_TIERS.ATTRIBUTE5%TYPE := FND_API.G_MISS_CHAR,
181: X_ATTRIBUTE6 IN CN_RATE_DIM_TIERS.ATTRIBUTE6%TYPE := FND_API.G_MISS_CHAR,
182: X_ATTRIBUTE7 IN CN_RATE_DIM_TIERS.ATTRIBUTE7%TYPE := FND_API.G_MISS_CHAR,

Line 179: X_ATTRIBUTE4 IN CN_RATE_DIM_TIERS.ATTRIBUTE4%TYPE := FND_API.G_MISS_CHAR,

175: X_ATTRIBUTE_CATEGORY IN CN_RATE_DIM_TIERS.ATTRIBUTE_CATEGORY%TYPE := FND_API.G_MISS_CHAR,
176: X_ATTRIBUTE1 IN CN_RATE_DIM_TIERS.ATTRIBUTE1%TYPE := FND_API.G_MISS_CHAR,
177: X_ATTRIBUTE2 IN CN_RATE_DIM_TIERS.ATTRIBUTE2%TYPE := FND_API.G_MISS_CHAR,
178: X_ATTRIBUTE3 IN CN_RATE_DIM_TIERS.ATTRIBUTE3%TYPE := FND_API.G_MISS_CHAR,
179: X_ATTRIBUTE4 IN CN_RATE_DIM_TIERS.ATTRIBUTE4%TYPE := FND_API.G_MISS_CHAR,
180: X_ATTRIBUTE5 IN CN_RATE_DIM_TIERS.ATTRIBUTE5%TYPE := FND_API.G_MISS_CHAR,
181: X_ATTRIBUTE6 IN CN_RATE_DIM_TIERS.ATTRIBUTE6%TYPE := FND_API.G_MISS_CHAR,
182: X_ATTRIBUTE7 IN CN_RATE_DIM_TIERS.ATTRIBUTE7%TYPE := FND_API.G_MISS_CHAR,
183: X_ATTRIBUTE8 IN CN_RATE_DIM_TIERS.ATTRIBUTE8%TYPE := FND_API.G_MISS_CHAR,

Line 180: X_ATTRIBUTE5 IN CN_RATE_DIM_TIERS.ATTRIBUTE5%TYPE := FND_API.G_MISS_CHAR,

176: X_ATTRIBUTE1 IN CN_RATE_DIM_TIERS.ATTRIBUTE1%TYPE := FND_API.G_MISS_CHAR,
177: X_ATTRIBUTE2 IN CN_RATE_DIM_TIERS.ATTRIBUTE2%TYPE := FND_API.G_MISS_CHAR,
178: X_ATTRIBUTE3 IN CN_RATE_DIM_TIERS.ATTRIBUTE3%TYPE := FND_API.G_MISS_CHAR,
179: X_ATTRIBUTE4 IN CN_RATE_DIM_TIERS.ATTRIBUTE4%TYPE := FND_API.G_MISS_CHAR,
180: X_ATTRIBUTE5 IN CN_RATE_DIM_TIERS.ATTRIBUTE5%TYPE := FND_API.G_MISS_CHAR,
181: X_ATTRIBUTE6 IN CN_RATE_DIM_TIERS.ATTRIBUTE6%TYPE := FND_API.G_MISS_CHAR,
182: X_ATTRIBUTE7 IN CN_RATE_DIM_TIERS.ATTRIBUTE7%TYPE := FND_API.G_MISS_CHAR,
183: X_ATTRIBUTE8 IN CN_RATE_DIM_TIERS.ATTRIBUTE8%TYPE := FND_API.G_MISS_CHAR,
184: X_ATTRIBUTE9 IN CN_RATE_DIM_TIERS.ATTRIBUTE9%TYPE := FND_API.G_MISS_CHAR,

Line 181: X_ATTRIBUTE6 IN CN_RATE_DIM_TIERS.ATTRIBUTE6%TYPE := FND_API.G_MISS_CHAR,

177: X_ATTRIBUTE2 IN CN_RATE_DIM_TIERS.ATTRIBUTE2%TYPE := FND_API.G_MISS_CHAR,
178: X_ATTRIBUTE3 IN CN_RATE_DIM_TIERS.ATTRIBUTE3%TYPE := FND_API.G_MISS_CHAR,
179: X_ATTRIBUTE4 IN CN_RATE_DIM_TIERS.ATTRIBUTE4%TYPE := FND_API.G_MISS_CHAR,
180: X_ATTRIBUTE5 IN CN_RATE_DIM_TIERS.ATTRIBUTE5%TYPE := FND_API.G_MISS_CHAR,
181: X_ATTRIBUTE6 IN CN_RATE_DIM_TIERS.ATTRIBUTE6%TYPE := FND_API.G_MISS_CHAR,
182: X_ATTRIBUTE7 IN CN_RATE_DIM_TIERS.ATTRIBUTE7%TYPE := FND_API.G_MISS_CHAR,
183: X_ATTRIBUTE8 IN CN_RATE_DIM_TIERS.ATTRIBUTE8%TYPE := FND_API.G_MISS_CHAR,
184: X_ATTRIBUTE9 IN CN_RATE_DIM_TIERS.ATTRIBUTE9%TYPE := FND_API.G_MISS_CHAR,
185: X_ATTRIBUTE10 IN CN_RATE_DIM_TIERS.ATTRIBUTE10%TYPE := FND_API.G_MISS_CHAR,

Line 182: X_ATTRIBUTE7 IN CN_RATE_DIM_TIERS.ATTRIBUTE7%TYPE := FND_API.G_MISS_CHAR,

178: X_ATTRIBUTE3 IN CN_RATE_DIM_TIERS.ATTRIBUTE3%TYPE := FND_API.G_MISS_CHAR,
179: X_ATTRIBUTE4 IN CN_RATE_DIM_TIERS.ATTRIBUTE4%TYPE := FND_API.G_MISS_CHAR,
180: X_ATTRIBUTE5 IN CN_RATE_DIM_TIERS.ATTRIBUTE5%TYPE := FND_API.G_MISS_CHAR,
181: X_ATTRIBUTE6 IN CN_RATE_DIM_TIERS.ATTRIBUTE6%TYPE := FND_API.G_MISS_CHAR,
182: X_ATTRIBUTE7 IN CN_RATE_DIM_TIERS.ATTRIBUTE7%TYPE := FND_API.G_MISS_CHAR,
183: X_ATTRIBUTE8 IN CN_RATE_DIM_TIERS.ATTRIBUTE8%TYPE := FND_API.G_MISS_CHAR,
184: X_ATTRIBUTE9 IN CN_RATE_DIM_TIERS.ATTRIBUTE9%TYPE := FND_API.G_MISS_CHAR,
185: X_ATTRIBUTE10 IN CN_RATE_DIM_TIERS.ATTRIBUTE10%TYPE := FND_API.G_MISS_CHAR,
186: X_ATTRIBUTE11 IN CN_RATE_DIM_TIERS.ATTRIBUTE11%TYPE := FND_API.G_MISS_CHAR,

Line 183: X_ATTRIBUTE8 IN CN_RATE_DIM_TIERS.ATTRIBUTE8%TYPE := FND_API.G_MISS_CHAR,

179: X_ATTRIBUTE4 IN CN_RATE_DIM_TIERS.ATTRIBUTE4%TYPE := FND_API.G_MISS_CHAR,
180: X_ATTRIBUTE5 IN CN_RATE_DIM_TIERS.ATTRIBUTE5%TYPE := FND_API.G_MISS_CHAR,
181: X_ATTRIBUTE6 IN CN_RATE_DIM_TIERS.ATTRIBUTE6%TYPE := FND_API.G_MISS_CHAR,
182: X_ATTRIBUTE7 IN CN_RATE_DIM_TIERS.ATTRIBUTE7%TYPE := FND_API.G_MISS_CHAR,
183: X_ATTRIBUTE8 IN CN_RATE_DIM_TIERS.ATTRIBUTE8%TYPE := FND_API.G_MISS_CHAR,
184: X_ATTRIBUTE9 IN CN_RATE_DIM_TIERS.ATTRIBUTE9%TYPE := FND_API.G_MISS_CHAR,
185: X_ATTRIBUTE10 IN CN_RATE_DIM_TIERS.ATTRIBUTE10%TYPE := FND_API.G_MISS_CHAR,
186: X_ATTRIBUTE11 IN CN_RATE_DIM_TIERS.ATTRIBUTE11%TYPE := FND_API.G_MISS_CHAR,
187: X_ATTRIBUTE12 IN CN_RATE_DIM_TIERS.ATTRIBUTE12%TYPE := FND_API.G_MISS_CHAR,

Line 184: X_ATTRIBUTE9 IN CN_RATE_DIM_TIERS.ATTRIBUTE9%TYPE := FND_API.G_MISS_CHAR,

180: X_ATTRIBUTE5 IN CN_RATE_DIM_TIERS.ATTRIBUTE5%TYPE := FND_API.G_MISS_CHAR,
181: X_ATTRIBUTE6 IN CN_RATE_DIM_TIERS.ATTRIBUTE6%TYPE := FND_API.G_MISS_CHAR,
182: X_ATTRIBUTE7 IN CN_RATE_DIM_TIERS.ATTRIBUTE7%TYPE := FND_API.G_MISS_CHAR,
183: X_ATTRIBUTE8 IN CN_RATE_DIM_TIERS.ATTRIBUTE8%TYPE := FND_API.G_MISS_CHAR,
184: X_ATTRIBUTE9 IN CN_RATE_DIM_TIERS.ATTRIBUTE9%TYPE := FND_API.G_MISS_CHAR,
185: X_ATTRIBUTE10 IN CN_RATE_DIM_TIERS.ATTRIBUTE10%TYPE := FND_API.G_MISS_CHAR,
186: X_ATTRIBUTE11 IN CN_RATE_DIM_TIERS.ATTRIBUTE11%TYPE := FND_API.G_MISS_CHAR,
187: X_ATTRIBUTE12 IN CN_RATE_DIM_TIERS.ATTRIBUTE12%TYPE := FND_API.G_MISS_CHAR,
188: X_ATTRIBUTE13 IN CN_RATE_DIM_TIERS.ATTRIBUTE13%TYPE := FND_API.G_MISS_CHAR,

Line 185: X_ATTRIBUTE10 IN CN_RATE_DIM_TIERS.ATTRIBUTE10%TYPE := FND_API.G_MISS_CHAR,

181: X_ATTRIBUTE6 IN CN_RATE_DIM_TIERS.ATTRIBUTE6%TYPE := FND_API.G_MISS_CHAR,
182: X_ATTRIBUTE7 IN CN_RATE_DIM_TIERS.ATTRIBUTE7%TYPE := FND_API.G_MISS_CHAR,
183: X_ATTRIBUTE8 IN CN_RATE_DIM_TIERS.ATTRIBUTE8%TYPE := FND_API.G_MISS_CHAR,
184: X_ATTRIBUTE9 IN CN_RATE_DIM_TIERS.ATTRIBUTE9%TYPE := FND_API.G_MISS_CHAR,
185: X_ATTRIBUTE10 IN CN_RATE_DIM_TIERS.ATTRIBUTE10%TYPE := FND_API.G_MISS_CHAR,
186: X_ATTRIBUTE11 IN CN_RATE_DIM_TIERS.ATTRIBUTE11%TYPE := FND_API.G_MISS_CHAR,
187: X_ATTRIBUTE12 IN CN_RATE_DIM_TIERS.ATTRIBUTE12%TYPE := FND_API.G_MISS_CHAR,
188: X_ATTRIBUTE13 IN CN_RATE_DIM_TIERS.ATTRIBUTE13%TYPE := FND_API.G_MISS_CHAR,
189: X_ATTRIBUTE14 IN CN_RATE_DIM_TIERS.ATTRIBUTE14%TYPE := FND_API.G_MISS_CHAR,

Line 186: X_ATTRIBUTE11 IN CN_RATE_DIM_TIERS.ATTRIBUTE11%TYPE := FND_API.G_MISS_CHAR,

182: X_ATTRIBUTE7 IN CN_RATE_DIM_TIERS.ATTRIBUTE7%TYPE := FND_API.G_MISS_CHAR,
183: X_ATTRIBUTE8 IN CN_RATE_DIM_TIERS.ATTRIBUTE8%TYPE := FND_API.G_MISS_CHAR,
184: X_ATTRIBUTE9 IN CN_RATE_DIM_TIERS.ATTRIBUTE9%TYPE := FND_API.G_MISS_CHAR,
185: X_ATTRIBUTE10 IN CN_RATE_DIM_TIERS.ATTRIBUTE10%TYPE := FND_API.G_MISS_CHAR,
186: X_ATTRIBUTE11 IN CN_RATE_DIM_TIERS.ATTRIBUTE11%TYPE := FND_API.G_MISS_CHAR,
187: X_ATTRIBUTE12 IN CN_RATE_DIM_TIERS.ATTRIBUTE12%TYPE := FND_API.G_MISS_CHAR,
188: X_ATTRIBUTE13 IN CN_RATE_DIM_TIERS.ATTRIBUTE13%TYPE := FND_API.G_MISS_CHAR,
189: X_ATTRIBUTE14 IN CN_RATE_DIM_TIERS.ATTRIBUTE14%TYPE := FND_API.G_MISS_CHAR,
190: X_ATTRIBUTE15 IN CN_RATE_DIM_TIERS.ATTRIBUTE15%TYPE := FND_API.G_MISS_CHAR,

Line 187: X_ATTRIBUTE12 IN CN_RATE_DIM_TIERS.ATTRIBUTE12%TYPE := FND_API.G_MISS_CHAR,

183: X_ATTRIBUTE8 IN CN_RATE_DIM_TIERS.ATTRIBUTE8%TYPE := FND_API.G_MISS_CHAR,
184: X_ATTRIBUTE9 IN CN_RATE_DIM_TIERS.ATTRIBUTE9%TYPE := FND_API.G_MISS_CHAR,
185: X_ATTRIBUTE10 IN CN_RATE_DIM_TIERS.ATTRIBUTE10%TYPE := FND_API.G_MISS_CHAR,
186: X_ATTRIBUTE11 IN CN_RATE_DIM_TIERS.ATTRIBUTE11%TYPE := FND_API.G_MISS_CHAR,
187: X_ATTRIBUTE12 IN CN_RATE_DIM_TIERS.ATTRIBUTE12%TYPE := FND_API.G_MISS_CHAR,
188: X_ATTRIBUTE13 IN CN_RATE_DIM_TIERS.ATTRIBUTE13%TYPE := FND_API.G_MISS_CHAR,
189: X_ATTRIBUTE14 IN CN_RATE_DIM_TIERS.ATTRIBUTE14%TYPE := FND_API.G_MISS_CHAR,
190: X_ATTRIBUTE15 IN CN_RATE_DIM_TIERS.ATTRIBUTE15%TYPE := FND_API.G_MISS_CHAR,
191: X_LAST_UPDATE_DATE IN CN_RATE_DIM_TIERS.LAST_UPDATE_DATE%TYPE := SYSDATE,

Line 188: X_ATTRIBUTE13 IN CN_RATE_DIM_TIERS.ATTRIBUTE13%TYPE := FND_API.G_MISS_CHAR,

184: X_ATTRIBUTE9 IN CN_RATE_DIM_TIERS.ATTRIBUTE9%TYPE := FND_API.G_MISS_CHAR,
185: X_ATTRIBUTE10 IN CN_RATE_DIM_TIERS.ATTRIBUTE10%TYPE := FND_API.G_MISS_CHAR,
186: X_ATTRIBUTE11 IN CN_RATE_DIM_TIERS.ATTRIBUTE11%TYPE := FND_API.G_MISS_CHAR,
187: X_ATTRIBUTE12 IN CN_RATE_DIM_TIERS.ATTRIBUTE12%TYPE := FND_API.G_MISS_CHAR,
188: X_ATTRIBUTE13 IN CN_RATE_DIM_TIERS.ATTRIBUTE13%TYPE := FND_API.G_MISS_CHAR,
189: X_ATTRIBUTE14 IN CN_RATE_DIM_TIERS.ATTRIBUTE14%TYPE := FND_API.G_MISS_CHAR,
190: X_ATTRIBUTE15 IN CN_RATE_DIM_TIERS.ATTRIBUTE15%TYPE := FND_API.G_MISS_CHAR,
191: X_LAST_UPDATE_DATE IN CN_RATE_DIM_TIERS.LAST_UPDATE_DATE%TYPE := SYSDATE,
192: X_LAST_UPDATED_BY IN CN_RATE_DIM_TIERS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,

Line 189: X_ATTRIBUTE14 IN CN_RATE_DIM_TIERS.ATTRIBUTE14%TYPE := FND_API.G_MISS_CHAR,

185: X_ATTRIBUTE10 IN CN_RATE_DIM_TIERS.ATTRIBUTE10%TYPE := FND_API.G_MISS_CHAR,
186: X_ATTRIBUTE11 IN CN_RATE_DIM_TIERS.ATTRIBUTE11%TYPE := FND_API.G_MISS_CHAR,
187: X_ATTRIBUTE12 IN CN_RATE_DIM_TIERS.ATTRIBUTE12%TYPE := FND_API.G_MISS_CHAR,
188: X_ATTRIBUTE13 IN CN_RATE_DIM_TIERS.ATTRIBUTE13%TYPE := FND_API.G_MISS_CHAR,
189: X_ATTRIBUTE14 IN CN_RATE_DIM_TIERS.ATTRIBUTE14%TYPE := FND_API.G_MISS_CHAR,
190: X_ATTRIBUTE15 IN CN_RATE_DIM_TIERS.ATTRIBUTE15%TYPE := FND_API.G_MISS_CHAR,
191: X_LAST_UPDATE_DATE IN CN_RATE_DIM_TIERS.LAST_UPDATE_DATE%TYPE := SYSDATE,
192: X_LAST_UPDATED_BY IN CN_RATE_DIM_TIERS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
193: X_LAST_UPDATE_LOGIN IN CN_RATE_DIM_TIERS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID,

Line 190: X_ATTRIBUTE15 IN CN_RATE_DIM_TIERS.ATTRIBUTE15%TYPE := FND_API.G_MISS_CHAR,

186: X_ATTRIBUTE11 IN CN_RATE_DIM_TIERS.ATTRIBUTE11%TYPE := FND_API.G_MISS_CHAR,
187: X_ATTRIBUTE12 IN CN_RATE_DIM_TIERS.ATTRIBUTE12%TYPE := FND_API.G_MISS_CHAR,
188: X_ATTRIBUTE13 IN CN_RATE_DIM_TIERS.ATTRIBUTE13%TYPE := FND_API.G_MISS_CHAR,
189: X_ATTRIBUTE14 IN CN_RATE_DIM_TIERS.ATTRIBUTE14%TYPE := FND_API.G_MISS_CHAR,
190: X_ATTRIBUTE15 IN CN_RATE_DIM_TIERS.ATTRIBUTE15%TYPE := FND_API.G_MISS_CHAR,
191: X_LAST_UPDATE_DATE IN CN_RATE_DIM_TIERS.LAST_UPDATE_DATE%TYPE := SYSDATE,
192: X_LAST_UPDATED_BY IN CN_RATE_DIM_TIERS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
193: X_LAST_UPDATE_LOGIN IN CN_RATE_DIM_TIERS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID,
194: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_RATE_DIM_TIERS.OBJECT_VERSION_NUMBER%TYPE) IS

Line 199: DIM_UNIT_CODE = Decode(X_DIM_UNIT_CODE, fnd_api.g_miss_char, dim_unit_code, x_dim_unit_code),

195:
196: BEGIN
197: X_OBJECT_VERSION_NUMBER := X_OBJECT_VERSION_NUMBER + 1;
198: update CN_RATE_DIM_TIERS set
199: DIM_UNIT_CODE = Decode(X_DIM_UNIT_CODE, fnd_api.g_miss_char, dim_unit_code, x_dim_unit_code),
200: MINIMUM_AMOUNT = Decode(X_MINIMUM_AMOUNT, fnd_api.g_miss_num, minimum_amount, x_minimum_amount),
201: MAXIMUM_AMOUNT = Decode(X_MAXIMUM_AMOUNT, fnd_api.g_miss_num, maximum_amount, x_maximum_amount),
202: MIN_EXP_ID = Decode(X_MIN_EXP_ID, fnd_api.g_miss_num, min_exp_id, x_min_exp_id),
203: MAX_EXP_ID = Decode(X_MAX_EXP_ID, fnd_api.g_miss_num, max_exp_id, x_max_exp_id),

Line 200: MINIMUM_AMOUNT = Decode(X_MINIMUM_AMOUNT, fnd_api.g_miss_num, minimum_amount, x_minimum_amount),

196: BEGIN
197: X_OBJECT_VERSION_NUMBER := X_OBJECT_VERSION_NUMBER + 1;
198: update CN_RATE_DIM_TIERS set
199: DIM_UNIT_CODE = Decode(X_DIM_UNIT_CODE, fnd_api.g_miss_char, dim_unit_code, x_dim_unit_code),
200: MINIMUM_AMOUNT = Decode(X_MINIMUM_AMOUNT, fnd_api.g_miss_num, minimum_amount, x_minimum_amount),
201: MAXIMUM_AMOUNT = Decode(X_MAXIMUM_AMOUNT, fnd_api.g_miss_num, maximum_amount, x_maximum_amount),
202: MIN_EXP_ID = Decode(X_MIN_EXP_ID, fnd_api.g_miss_num, min_exp_id, x_min_exp_id),
203: MAX_EXP_ID = Decode(X_MAX_EXP_ID, fnd_api.g_miss_num, max_exp_id, x_max_exp_id),
204: STRING_VALUE = Decode(X_STRING_VALUE, fnd_api.g_miss_char, string_value, x_string_value),

Line 201: MAXIMUM_AMOUNT = Decode(X_MAXIMUM_AMOUNT, fnd_api.g_miss_num, maximum_amount, x_maximum_amount),

197: X_OBJECT_VERSION_NUMBER := X_OBJECT_VERSION_NUMBER + 1;
198: update CN_RATE_DIM_TIERS set
199: DIM_UNIT_CODE = Decode(X_DIM_UNIT_CODE, fnd_api.g_miss_char, dim_unit_code, x_dim_unit_code),
200: MINIMUM_AMOUNT = Decode(X_MINIMUM_AMOUNT, fnd_api.g_miss_num, minimum_amount, x_minimum_amount),
201: MAXIMUM_AMOUNT = Decode(X_MAXIMUM_AMOUNT, fnd_api.g_miss_num, maximum_amount, x_maximum_amount),
202: MIN_EXP_ID = Decode(X_MIN_EXP_ID, fnd_api.g_miss_num, min_exp_id, x_min_exp_id),
203: MAX_EXP_ID = Decode(X_MAX_EXP_ID, fnd_api.g_miss_num, max_exp_id, x_max_exp_id),
204: STRING_VALUE = Decode(X_STRING_VALUE, fnd_api.g_miss_char, string_value, x_string_value),
205: TIER_SEQUENCE = Decode(X_TIER_SEQUENCE, fnd_api.g_miss_num, tier_sequence, x_tier_sequence),

Line 202: MIN_EXP_ID = Decode(X_MIN_EXP_ID, fnd_api.g_miss_num, min_exp_id, x_min_exp_id),

198: update CN_RATE_DIM_TIERS set
199: DIM_UNIT_CODE = Decode(X_DIM_UNIT_CODE, fnd_api.g_miss_char, dim_unit_code, x_dim_unit_code),
200: MINIMUM_AMOUNT = Decode(X_MINIMUM_AMOUNT, fnd_api.g_miss_num, minimum_amount, x_minimum_amount),
201: MAXIMUM_AMOUNT = Decode(X_MAXIMUM_AMOUNT, fnd_api.g_miss_num, maximum_amount, x_maximum_amount),
202: MIN_EXP_ID = Decode(X_MIN_EXP_ID, fnd_api.g_miss_num, min_exp_id, x_min_exp_id),
203: MAX_EXP_ID = Decode(X_MAX_EXP_ID, fnd_api.g_miss_num, max_exp_id, x_max_exp_id),
204: STRING_VALUE = Decode(X_STRING_VALUE, fnd_api.g_miss_char, string_value, x_string_value),
205: TIER_SEQUENCE = Decode(X_TIER_SEQUENCE, fnd_api.g_miss_num, tier_sequence, x_tier_sequence),
206: ATTRIBUTE_CATEGORY = Decode(X_ATTRIBUTE_CATEGORY, fnd_api.g_miss_char, attribute_category, x_attribute_category),

Line 203: MAX_EXP_ID = Decode(X_MAX_EXP_ID, fnd_api.g_miss_num, max_exp_id, x_max_exp_id),

199: DIM_UNIT_CODE = Decode(X_DIM_UNIT_CODE, fnd_api.g_miss_char, dim_unit_code, x_dim_unit_code),
200: MINIMUM_AMOUNT = Decode(X_MINIMUM_AMOUNT, fnd_api.g_miss_num, minimum_amount, x_minimum_amount),
201: MAXIMUM_AMOUNT = Decode(X_MAXIMUM_AMOUNT, fnd_api.g_miss_num, maximum_amount, x_maximum_amount),
202: MIN_EXP_ID = Decode(X_MIN_EXP_ID, fnd_api.g_miss_num, min_exp_id, x_min_exp_id),
203: MAX_EXP_ID = Decode(X_MAX_EXP_ID, fnd_api.g_miss_num, max_exp_id, x_max_exp_id),
204: STRING_VALUE = Decode(X_STRING_VALUE, fnd_api.g_miss_char, string_value, x_string_value),
205: TIER_SEQUENCE = Decode(X_TIER_SEQUENCE, fnd_api.g_miss_num, tier_sequence, x_tier_sequence),
206: ATTRIBUTE_CATEGORY = Decode(X_ATTRIBUTE_CATEGORY, fnd_api.g_miss_char, attribute_category, x_attribute_category),
207: ATTRIBUTE1 = Decode(X_ATTRIBUTE1, fnd_api.g_miss_char, attribute1, x_attribute1),

Line 204: STRING_VALUE = Decode(X_STRING_VALUE, fnd_api.g_miss_char, string_value, x_string_value),

200: MINIMUM_AMOUNT = Decode(X_MINIMUM_AMOUNT, fnd_api.g_miss_num, minimum_amount, x_minimum_amount),
201: MAXIMUM_AMOUNT = Decode(X_MAXIMUM_AMOUNT, fnd_api.g_miss_num, maximum_amount, x_maximum_amount),
202: MIN_EXP_ID = Decode(X_MIN_EXP_ID, fnd_api.g_miss_num, min_exp_id, x_min_exp_id),
203: MAX_EXP_ID = Decode(X_MAX_EXP_ID, fnd_api.g_miss_num, max_exp_id, x_max_exp_id),
204: STRING_VALUE = Decode(X_STRING_VALUE, fnd_api.g_miss_char, string_value, x_string_value),
205: TIER_SEQUENCE = Decode(X_TIER_SEQUENCE, fnd_api.g_miss_num, tier_sequence, x_tier_sequence),
206: ATTRIBUTE_CATEGORY = Decode(X_ATTRIBUTE_CATEGORY, fnd_api.g_miss_char, attribute_category, x_attribute_category),
207: ATTRIBUTE1 = Decode(X_ATTRIBUTE1, fnd_api.g_miss_char, attribute1, x_attribute1),
208: ATTRIBUTE2 = Decode(X_ATTRIBUTE2, fnd_api.g_miss_char, attribute2, x_attribute2),

Line 205: TIER_SEQUENCE = Decode(X_TIER_SEQUENCE, fnd_api.g_miss_num, tier_sequence, x_tier_sequence),

201: MAXIMUM_AMOUNT = Decode(X_MAXIMUM_AMOUNT, fnd_api.g_miss_num, maximum_amount, x_maximum_amount),
202: MIN_EXP_ID = Decode(X_MIN_EXP_ID, fnd_api.g_miss_num, min_exp_id, x_min_exp_id),
203: MAX_EXP_ID = Decode(X_MAX_EXP_ID, fnd_api.g_miss_num, max_exp_id, x_max_exp_id),
204: STRING_VALUE = Decode(X_STRING_VALUE, fnd_api.g_miss_char, string_value, x_string_value),
205: TIER_SEQUENCE = Decode(X_TIER_SEQUENCE, fnd_api.g_miss_num, tier_sequence, x_tier_sequence),
206: ATTRIBUTE_CATEGORY = Decode(X_ATTRIBUTE_CATEGORY, fnd_api.g_miss_char, attribute_category, x_attribute_category),
207: ATTRIBUTE1 = Decode(X_ATTRIBUTE1, fnd_api.g_miss_char, attribute1, x_attribute1),
208: ATTRIBUTE2 = Decode(X_ATTRIBUTE2, fnd_api.g_miss_char, attribute2, x_attribute2),
209: ATTRIBUTE3 = Decode(X_ATTRIBUTE3, fnd_api.g_miss_char, attribute3, x_attribute3),

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

202: MIN_EXP_ID = Decode(X_MIN_EXP_ID, fnd_api.g_miss_num, min_exp_id, x_min_exp_id),
203: MAX_EXP_ID = Decode(X_MAX_EXP_ID, fnd_api.g_miss_num, max_exp_id, x_max_exp_id),
204: STRING_VALUE = Decode(X_STRING_VALUE, fnd_api.g_miss_char, string_value, x_string_value),
205: TIER_SEQUENCE = Decode(X_TIER_SEQUENCE, fnd_api.g_miss_num, tier_sequence, x_tier_sequence),
206: ATTRIBUTE_CATEGORY = Decode(X_ATTRIBUTE_CATEGORY, fnd_api.g_miss_char, attribute_category, x_attribute_category),
207: ATTRIBUTE1 = Decode(X_ATTRIBUTE1, fnd_api.g_miss_char, attribute1, x_attribute1),
208: ATTRIBUTE2 = Decode(X_ATTRIBUTE2, fnd_api.g_miss_char, attribute2, x_attribute2),
209: ATTRIBUTE3 = Decode(X_ATTRIBUTE3, fnd_api.g_miss_char, attribute3, x_attribute3),
210: ATTRIBUTE4 = Decode(X_ATTRIBUTE4, fnd_api.g_miss_char, attribute4, x_attribute4),

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

203: MAX_EXP_ID = Decode(X_MAX_EXP_ID, fnd_api.g_miss_num, max_exp_id, x_max_exp_id),
204: STRING_VALUE = Decode(X_STRING_VALUE, fnd_api.g_miss_char, string_value, x_string_value),
205: TIER_SEQUENCE = Decode(X_TIER_SEQUENCE, fnd_api.g_miss_num, tier_sequence, x_tier_sequence),
206: ATTRIBUTE_CATEGORY = Decode(X_ATTRIBUTE_CATEGORY, fnd_api.g_miss_char, attribute_category, x_attribute_category),
207: ATTRIBUTE1 = Decode(X_ATTRIBUTE1, fnd_api.g_miss_char, attribute1, x_attribute1),
208: ATTRIBUTE2 = Decode(X_ATTRIBUTE2, fnd_api.g_miss_char, attribute2, x_attribute2),
209: ATTRIBUTE3 = Decode(X_ATTRIBUTE3, fnd_api.g_miss_char, attribute3, x_attribute3),
210: ATTRIBUTE4 = Decode(X_ATTRIBUTE4, fnd_api.g_miss_char, attribute4, x_attribute4),
211: ATTRIBUTE5 = Decode(X_ATTRIBUTE5, fnd_api.g_miss_char, attribute5, x_attribute5),

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

204: STRING_VALUE = Decode(X_STRING_VALUE, fnd_api.g_miss_char, string_value, x_string_value),
205: TIER_SEQUENCE = Decode(X_TIER_SEQUENCE, fnd_api.g_miss_num, tier_sequence, x_tier_sequence),
206: ATTRIBUTE_CATEGORY = Decode(X_ATTRIBUTE_CATEGORY, fnd_api.g_miss_char, attribute_category, x_attribute_category),
207: ATTRIBUTE1 = Decode(X_ATTRIBUTE1, fnd_api.g_miss_char, attribute1, x_attribute1),
208: ATTRIBUTE2 = Decode(X_ATTRIBUTE2, fnd_api.g_miss_char, attribute2, x_attribute2),
209: ATTRIBUTE3 = Decode(X_ATTRIBUTE3, fnd_api.g_miss_char, attribute3, x_attribute3),
210: ATTRIBUTE4 = Decode(X_ATTRIBUTE4, fnd_api.g_miss_char, attribute4, x_attribute4),
211: ATTRIBUTE5 = Decode(X_ATTRIBUTE5, fnd_api.g_miss_char, attribute5, x_attribute5),
212: ATTRIBUTE6 = Decode(X_ATTRIBUTE6, fnd_api.g_miss_char, attribute6, x_attribute6),

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

205: TIER_SEQUENCE = Decode(X_TIER_SEQUENCE, fnd_api.g_miss_num, tier_sequence, x_tier_sequence),
206: ATTRIBUTE_CATEGORY = Decode(X_ATTRIBUTE_CATEGORY, fnd_api.g_miss_char, attribute_category, x_attribute_category),
207: ATTRIBUTE1 = Decode(X_ATTRIBUTE1, fnd_api.g_miss_char, attribute1, x_attribute1),
208: ATTRIBUTE2 = Decode(X_ATTRIBUTE2, fnd_api.g_miss_char, attribute2, x_attribute2),
209: ATTRIBUTE3 = Decode(X_ATTRIBUTE3, fnd_api.g_miss_char, attribute3, x_attribute3),
210: ATTRIBUTE4 = Decode(X_ATTRIBUTE4, fnd_api.g_miss_char, attribute4, x_attribute4),
211: ATTRIBUTE5 = Decode(X_ATTRIBUTE5, fnd_api.g_miss_char, attribute5, x_attribute5),
212: ATTRIBUTE6 = Decode(X_ATTRIBUTE6, fnd_api.g_miss_char, attribute6, x_attribute6),
213: ATTRIBUTE7 = Decode(X_ATTRIBUTE7, fnd_api.g_miss_char, attribute7, x_attribute7),

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

206: ATTRIBUTE_CATEGORY = Decode(X_ATTRIBUTE_CATEGORY, fnd_api.g_miss_char, attribute_category, x_attribute_category),
207: ATTRIBUTE1 = Decode(X_ATTRIBUTE1, fnd_api.g_miss_char, attribute1, x_attribute1),
208: ATTRIBUTE2 = Decode(X_ATTRIBUTE2, fnd_api.g_miss_char, attribute2, x_attribute2),
209: ATTRIBUTE3 = Decode(X_ATTRIBUTE3, fnd_api.g_miss_char, attribute3, x_attribute3),
210: ATTRIBUTE4 = Decode(X_ATTRIBUTE4, fnd_api.g_miss_char, attribute4, x_attribute4),
211: ATTRIBUTE5 = Decode(X_ATTRIBUTE5, fnd_api.g_miss_char, attribute5, x_attribute5),
212: ATTRIBUTE6 = Decode(X_ATTRIBUTE6, fnd_api.g_miss_char, attribute6, x_attribute6),
213: ATTRIBUTE7 = Decode(X_ATTRIBUTE7, fnd_api.g_miss_char, attribute7, x_attribute7),
214: ATTRIBUTE8 = Decode(X_ATTRIBUTE8, fnd_api.g_miss_char, attribute8, x_attribute8),

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

207: ATTRIBUTE1 = Decode(X_ATTRIBUTE1, fnd_api.g_miss_char, attribute1, x_attribute1),
208: ATTRIBUTE2 = Decode(X_ATTRIBUTE2, fnd_api.g_miss_char, attribute2, x_attribute2),
209: ATTRIBUTE3 = Decode(X_ATTRIBUTE3, fnd_api.g_miss_char, attribute3, x_attribute3),
210: ATTRIBUTE4 = Decode(X_ATTRIBUTE4, fnd_api.g_miss_char, attribute4, x_attribute4),
211: ATTRIBUTE5 = Decode(X_ATTRIBUTE5, fnd_api.g_miss_char, attribute5, x_attribute5),
212: ATTRIBUTE6 = Decode(X_ATTRIBUTE6, fnd_api.g_miss_char, attribute6, x_attribute6),
213: ATTRIBUTE7 = Decode(X_ATTRIBUTE7, fnd_api.g_miss_char, attribute7, x_attribute7),
214: ATTRIBUTE8 = Decode(X_ATTRIBUTE8, fnd_api.g_miss_char, attribute8, x_attribute8),
215: ATTRIBUTE9 = Decode(X_ATTRIBUTE9, fnd_api.g_miss_char, attribute9, x_attribute9),

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

208: ATTRIBUTE2 = Decode(X_ATTRIBUTE2, fnd_api.g_miss_char, attribute2, x_attribute2),
209: ATTRIBUTE3 = Decode(X_ATTRIBUTE3, fnd_api.g_miss_char, attribute3, x_attribute3),
210: ATTRIBUTE4 = Decode(X_ATTRIBUTE4, fnd_api.g_miss_char, attribute4, x_attribute4),
211: ATTRIBUTE5 = Decode(X_ATTRIBUTE5, fnd_api.g_miss_char, attribute5, x_attribute5),
212: ATTRIBUTE6 = Decode(X_ATTRIBUTE6, fnd_api.g_miss_char, attribute6, x_attribute6),
213: ATTRIBUTE7 = Decode(X_ATTRIBUTE7, fnd_api.g_miss_char, attribute7, x_attribute7),
214: ATTRIBUTE8 = Decode(X_ATTRIBUTE8, fnd_api.g_miss_char, attribute8, x_attribute8),
215: ATTRIBUTE9 = Decode(X_ATTRIBUTE9, fnd_api.g_miss_char, attribute9, x_attribute9),
216: ATTRIBUTE10 = Decode(X_ATTRIBUTE10, fnd_api.g_miss_char, attribute10, x_attribute10),

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

209: ATTRIBUTE3 = Decode(X_ATTRIBUTE3, fnd_api.g_miss_char, attribute3, x_attribute3),
210: ATTRIBUTE4 = Decode(X_ATTRIBUTE4, fnd_api.g_miss_char, attribute4, x_attribute4),
211: ATTRIBUTE5 = Decode(X_ATTRIBUTE5, fnd_api.g_miss_char, attribute5, x_attribute5),
212: ATTRIBUTE6 = Decode(X_ATTRIBUTE6, fnd_api.g_miss_char, attribute6, x_attribute6),
213: ATTRIBUTE7 = Decode(X_ATTRIBUTE7, fnd_api.g_miss_char, attribute7, x_attribute7),
214: ATTRIBUTE8 = Decode(X_ATTRIBUTE8, fnd_api.g_miss_char, attribute8, x_attribute8),
215: ATTRIBUTE9 = Decode(X_ATTRIBUTE9, fnd_api.g_miss_char, attribute9, x_attribute9),
216: ATTRIBUTE10 = Decode(X_ATTRIBUTE10, fnd_api.g_miss_char, attribute10, x_attribute10),
217: ATTRIBUTE11 = Decode(X_ATTRIBUTE11, fnd_api.g_miss_char, attribute11, x_attribute11),

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

210: ATTRIBUTE4 = Decode(X_ATTRIBUTE4, fnd_api.g_miss_char, attribute4, x_attribute4),
211: ATTRIBUTE5 = Decode(X_ATTRIBUTE5, fnd_api.g_miss_char, attribute5, x_attribute5),
212: ATTRIBUTE6 = Decode(X_ATTRIBUTE6, fnd_api.g_miss_char, attribute6, x_attribute6),
213: ATTRIBUTE7 = Decode(X_ATTRIBUTE7, fnd_api.g_miss_char, attribute7, x_attribute7),
214: ATTRIBUTE8 = Decode(X_ATTRIBUTE8, fnd_api.g_miss_char, attribute8, x_attribute8),
215: ATTRIBUTE9 = Decode(X_ATTRIBUTE9, fnd_api.g_miss_char, attribute9, x_attribute9),
216: ATTRIBUTE10 = Decode(X_ATTRIBUTE10, fnd_api.g_miss_char, attribute10, x_attribute10),
217: ATTRIBUTE11 = Decode(X_ATTRIBUTE11, fnd_api.g_miss_char, attribute11, x_attribute11),
218: ATTRIBUTE12 = Decode(X_ATTRIBUTE12, fnd_api.g_miss_char, attribute12, x_attribute12),

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

211: ATTRIBUTE5 = Decode(X_ATTRIBUTE5, fnd_api.g_miss_char, attribute5, x_attribute5),
212: ATTRIBUTE6 = Decode(X_ATTRIBUTE6, fnd_api.g_miss_char, attribute6, x_attribute6),
213: ATTRIBUTE7 = Decode(X_ATTRIBUTE7, fnd_api.g_miss_char, attribute7, x_attribute7),
214: ATTRIBUTE8 = Decode(X_ATTRIBUTE8, fnd_api.g_miss_char, attribute8, x_attribute8),
215: ATTRIBUTE9 = Decode(X_ATTRIBUTE9, fnd_api.g_miss_char, attribute9, x_attribute9),
216: ATTRIBUTE10 = Decode(X_ATTRIBUTE10, fnd_api.g_miss_char, attribute10, x_attribute10),
217: ATTRIBUTE11 = Decode(X_ATTRIBUTE11, fnd_api.g_miss_char, attribute11, x_attribute11),
218: ATTRIBUTE12 = Decode(X_ATTRIBUTE12, fnd_api.g_miss_char, attribute12, x_attribute12),
219: ATTRIBUTE13 = Decode(X_ATTRIBUTE13, fnd_api.g_miss_char, attribute13, x_attribute13),

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

212: ATTRIBUTE6 = Decode(X_ATTRIBUTE6, fnd_api.g_miss_char, attribute6, x_attribute6),
213: ATTRIBUTE7 = Decode(X_ATTRIBUTE7, fnd_api.g_miss_char, attribute7, x_attribute7),
214: ATTRIBUTE8 = Decode(X_ATTRIBUTE8, fnd_api.g_miss_char, attribute8, x_attribute8),
215: ATTRIBUTE9 = Decode(X_ATTRIBUTE9, fnd_api.g_miss_char, attribute9, x_attribute9),
216: ATTRIBUTE10 = Decode(X_ATTRIBUTE10, fnd_api.g_miss_char, attribute10, x_attribute10),
217: ATTRIBUTE11 = Decode(X_ATTRIBUTE11, fnd_api.g_miss_char, attribute11, x_attribute11),
218: ATTRIBUTE12 = Decode(X_ATTRIBUTE12, fnd_api.g_miss_char, attribute12, x_attribute12),
219: ATTRIBUTE13 = Decode(X_ATTRIBUTE13, fnd_api.g_miss_char, attribute13, x_attribute13),
220: ATTRIBUTE14 = Decode(X_ATTRIBUTE14, fnd_api.g_miss_char, attribute14, x_attribute14),

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

213: ATTRIBUTE7 = Decode(X_ATTRIBUTE7, fnd_api.g_miss_char, attribute7, x_attribute7),
214: ATTRIBUTE8 = Decode(X_ATTRIBUTE8, fnd_api.g_miss_char, attribute8, x_attribute8),
215: ATTRIBUTE9 = Decode(X_ATTRIBUTE9, fnd_api.g_miss_char, attribute9, x_attribute9),
216: ATTRIBUTE10 = Decode(X_ATTRIBUTE10, fnd_api.g_miss_char, attribute10, x_attribute10),
217: ATTRIBUTE11 = Decode(X_ATTRIBUTE11, fnd_api.g_miss_char, attribute11, x_attribute11),
218: ATTRIBUTE12 = Decode(X_ATTRIBUTE12, fnd_api.g_miss_char, attribute12, x_attribute12),
219: ATTRIBUTE13 = Decode(X_ATTRIBUTE13, fnd_api.g_miss_char, attribute13, x_attribute13),
220: ATTRIBUTE14 = Decode(X_ATTRIBUTE14, fnd_api.g_miss_char, attribute14, x_attribute14),
221: ATTRIBUTE15 = Decode(X_ATTRIBUTE15, fnd_api.g_miss_char, attribute15, x_attribute15),

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

214: ATTRIBUTE8 = Decode(X_ATTRIBUTE8, fnd_api.g_miss_char, attribute8, x_attribute8),
215: ATTRIBUTE9 = Decode(X_ATTRIBUTE9, fnd_api.g_miss_char, attribute9, x_attribute9),
216: ATTRIBUTE10 = Decode(X_ATTRIBUTE10, fnd_api.g_miss_char, attribute10, x_attribute10),
217: ATTRIBUTE11 = Decode(X_ATTRIBUTE11, fnd_api.g_miss_char, attribute11, x_attribute11),
218: ATTRIBUTE12 = Decode(X_ATTRIBUTE12, fnd_api.g_miss_char, attribute12, x_attribute12),
219: ATTRIBUTE13 = Decode(X_ATTRIBUTE13, fnd_api.g_miss_char, attribute13, x_attribute13),
220: ATTRIBUTE14 = Decode(X_ATTRIBUTE14, fnd_api.g_miss_char, attribute14, x_attribute14),
221: ATTRIBUTE15 = Decode(X_ATTRIBUTE15, fnd_api.g_miss_char, attribute15, x_attribute15),
222: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

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

215: ATTRIBUTE9 = Decode(X_ATTRIBUTE9, fnd_api.g_miss_char, attribute9, x_attribute9),
216: ATTRIBUTE10 = Decode(X_ATTRIBUTE10, fnd_api.g_miss_char, attribute10, x_attribute10),
217: ATTRIBUTE11 = Decode(X_ATTRIBUTE11, fnd_api.g_miss_char, attribute11, x_attribute11),
218: ATTRIBUTE12 = Decode(X_ATTRIBUTE12, fnd_api.g_miss_char, attribute12, x_attribute12),
219: ATTRIBUTE13 = Decode(X_ATTRIBUTE13, fnd_api.g_miss_char, attribute13, x_attribute13),
220: ATTRIBUTE14 = Decode(X_ATTRIBUTE14, fnd_api.g_miss_char, attribute14, x_attribute14),
221: ATTRIBUTE15 = Decode(X_ATTRIBUTE15, fnd_api.g_miss_char, attribute15, x_attribute15),
222: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
223: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

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

216: ATTRIBUTE10 = Decode(X_ATTRIBUTE10, fnd_api.g_miss_char, attribute10, x_attribute10),
217: ATTRIBUTE11 = Decode(X_ATTRIBUTE11, fnd_api.g_miss_char, attribute11, x_attribute11),
218: ATTRIBUTE12 = Decode(X_ATTRIBUTE12, fnd_api.g_miss_char, attribute12, x_attribute12),
219: ATTRIBUTE13 = Decode(X_ATTRIBUTE13, fnd_api.g_miss_char, attribute13, x_attribute13),
220: ATTRIBUTE14 = Decode(X_ATTRIBUTE14, fnd_api.g_miss_char, attribute14, x_attribute14),
221: ATTRIBUTE15 = Decode(X_ATTRIBUTE15, fnd_api.g_miss_char, attribute15, x_attribute15),
222: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
223: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
224: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

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

217: ATTRIBUTE11 = Decode(X_ATTRIBUTE11, fnd_api.g_miss_char, attribute11, x_attribute11),
218: ATTRIBUTE12 = Decode(X_ATTRIBUTE12, fnd_api.g_miss_char, attribute12, x_attribute12),
219: ATTRIBUTE13 = Decode(X_ATTRIBUTE13, fnd_api.g_miss_char, attribute13, x_attribute13),
220: ATTRIBUTE14 = Decode(X_ATTRIBUTE14, fnd_api.g_miss_char, attribute14, x_attribute14),
221: ATTRIBUTE15 = Decode(X_ATTRIBUTE15, fnd_api.g_miss_char, attribute15, x_attribute15),
222: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
223: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
224: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
225: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER

Line 231: raise fnd_api.g_exc_unexpected_error;

227:
228: if (sql%notfound) then
229: fnd_message.set_name('CN', 'CN_RECORD_DELETED');
230: fnd_msg_pub.add;
231: raise fnd_api.g_exc_unexpected_error;
232: end if;
233: end UPDATE_ROW;
234:
235: procedure DELETE_ROW (

Line 244: raise fnd_api.g_exc_unexpected_error;

240:
241: if (sql%notfound) then
242: fnd_message.set_name('CN', 'CN_RECORD_DELETED');
243: fnd_msg_pub.add;
244: raise fnd_api.g_exc_unexpected_error;
245: end if;
246:
247: end DELETE_ROW;
248: