eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_WORD_REPLACEMENTS1_PKG dependencies on FND_API

Line 55: (decode(x_CONDITION_ID, FND_API.G_MISS_NUM, NULL, x_CONDITION_ID) IS NULL)

51: AND delete_flag = 'N'
52: AND original_word = UPPER(x_ORIGINAL_WORD)
53: AND (condition_id IS NULL
54: OR
55: (decode(x_CONDITION_ID, FND_API.G_MISS_NUM, NULL, x_CONDITION_ID) IS NULL)
56: OR
57: ( (condition_id = x_condition_id)
58: AND ( nvl(user_spec_cond_value,FND_API.G_MISS_CHAR) = nvl(x_user_spec_cond_value,FND_API.G_MISS_CHAR )
59: OR nvl(replacement_word,FND_API.G_MISS_CHAR) = nvl(upper(x_replacement_word),FND_API.G_MISS_CHAR)

Line 58: AND ( nvl(user_spec_cond_value,FND_API.G_MISS_CHAR) = nvl(x_user_spec_cond_value,FND_API.G_MISS_CHAR )

54: OR
55: (decode(x_CONDITION_ID, FND_API.G_MISS_NUM, NULL, x_CONDITION_ID) IS NULL)
56: OR
57: ( (condition_id = x_condition_id)
58: AND ( nvl(user_spec_cond_value,FND_API.G_MISS_CHAR) = nvl(x_user_spec_cond_value,FND_API.G_MISS_CHAR )
59: OR nvl(replacement_word,FND_API.G_MISS_CHAR) = nvl(upper(x_replacement_word),FND_API.G_MISS_CHAR)
60: )
61: )
62: );

Line 59: OR nvl(replacement_word,FND_API.G_MISS_CHAR) = nvl(upper(x_replacement_word),FND_API.G_MISS_CHAR)

55: (decode(x_CONDITION_ID, FND_API.G_MISS_NUM, NULL, x_CONDITION_ID) IS NULL)
56: OR
57: ( (condition_id = x_condition_id)
58: AND ( nvl(user_spec_cond_value,FND_API.G_MISS_CHAR) = nvl(x_user_spec_cond_value,FND_API.G_MISS_CHAR )
59: OR nvl(replacement_word,FND_API.G_MISS_CHAR) = nvl(upper(x_replacement_word),FND_API.G_MISS_CHAR)
60: )
61: )
62: );
63:

Line 94: IF (x_ORIGINAL_WORD IS NULL OR x_ORIGINAL_WORD = FND_API.G_MISS_CHAR)

90: FND_MESSAGE.SET_TOKEN( 'WORD', UPPER(x_REPLACEMENT_WORD) );
91: FND_MSG_PUB.ADD;
92: END IF;
93: /* Original Word is Mandatory */
94: IF (x_ORIGINAL_WORD IS NULL OR x_ORIGINAL_WORD = FND_API.G_MISS_CHAR)
95: THEN
96: x_msg_count := x_msg_count+1;
97: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DQM_WR_ORIG_WORD_MANDATORY' );
98: FND_MSG_PUB.ADD;

Line 212: decode( x_WORD_LIST_ID, FND_API.G_MISS_NUM, NULL, x_WORD_LIST_ID),

208: STAGED_FLAG,
209: DELETE_FLAG
210: )
211: VALUES (
212: decode( x_WORD_LIST_ID, FND_API.G_MISS_NUM, NULL, x_WORD_LIST_ID),
213: decode( x_ORIGINAL_WORD, FND_API.G_MISS_CHAR, NULL, UPPER(x_ORIGINAL_WORD)),
214: decode( x_REPLACEMENT_WORD, FND_API.G_MISS_CHAR, NULL, UPPER(x_REPLACEMENT_WORD)),
215: decode( x_TYPE, FND_API.G_MISS_CHAR, NULL, x_TYPE),
216: decode( x_COUNTRY_CODE, FND_API.G_MISS_CHAR, NULL, x_COUNTRY_CODE),

Line 213: decode( x_ORIGINAL_WORD, FND_API.G_MISS_CHAR, NULL, UPPER(x_ORIGINAL_WORD)),

209: DELETE_FLAG
210: )
211: VALUES (
212: decode( x_WORD_LIST_ID, FND_API.G_MISS_NUM, NULL, x_WORD_LIST_ID),
213: decode( x_ORIGINAL_WORD, FND_API.G_MISS_CHAR, NULL, UPPER(x_ORIGINAL_WORD)),
214: decode( x_REPLACEMENT_WORD, FND_API.G_MISS_CHAR, NULL, UPPER(x_REPLACEMENT_WORD)),
215: decode( x_TYPE, FND_API.G_MISS_CHAR, NULL, x_TYPE),
216: decode( x_COUNTRY_CODE, FND_API.G_MISS_CHAR, NULL, x_COUNTRY_CODE),
217: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,x_LAST_UPDATE_DATE),

Line 214: decode( x_REPLACEMENT_WORD, FND_API.G_MISS_CHAR, NULL, UPPER(x_REPLACEMENT_WORD)),

210: )
211: VALUES (
212: decode( x_WORD_LIST_ID, FND_API.G_MISS_NUM, NULL, x_WORD_LIST_ID),
213: decode( x_ORIGINAL_WORD, FND_API.G_MISS_CHAR, NULL, UPPER(x_ORIGINAL_WORD)),
214: decode( x_REPLACEMENT_WORD, FND_API.G_MISS_CHAR, NULL, UPPER(x_REPLACEMENT_WORD)),
215: decode( x_TYPE, FND_API.G_MISS_CHAR, NULL, x_TYPE),
216: decode( x_COUNTRY_CODE, FND_API.G_MISS_CHAR, NULL, x_COUNTRY_CODE),
217: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,x_LAST_UPDATE_DATE),
218: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),

Line 215: decode( x_TYPE, FND_API.G_MISS_CHAR, NULL, x_TYPE),

211: VALUES (
212: decode( x_WORD_LIST_ID, FND_API.G_MISS_NUM, NULL, x_WORD_LIST_ID),
213: decode( x_ORIGINAL_WORD, FND_API.G_MISS_CHAR, NULL, UPPER(x_ORIGINAL_WORD)),
214: decode( x_REPLACEMENT_WORD, FND_API.G_MISS_CHAR, NULL, UPPER(x_REPLACEMENT_WORD)),
215: decode( x_TYPE, FND_API.G_MISS_CHAR, NULL, x_TYPE),
216: decode( x_COUNTRY_CODE, FND_API.G_MISS_CHAR, NULL, x_COUNTRY_CODE),
217: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,x_LAST_UPDATE_DATE),
218: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
219: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, NULL,x_CREATION_DATE),

Line 216: decode( x_COUNTRY_CODE, FND_API.G_MISS_CHAR, NULL, x_COUNTRY_CODE),

212: decode( x_WORD_LIST_ID, FND_API.G_MISS_NUM, NULL, x_WORD_LIST_ID),
213: decode( x_ORIGINAL_WORD, FND_API.G_MISS_CHAR, NULL, UPPER(x_ORIGINAL_WORD)),
214: decode( x_REPLACEMENT_WORD, FND_API.G_MISS_CHAR, NULL, UPPER(x_REPLACEMENT_WORD)),
215: decode( x_TYPE, FND_API.G_MISS_CHAR, NULL, x_TYPE),
216: decode( x_COUNTRY_CODE, FND_API.G_MISS_CHAR, NULL, x_COUNTRY_CODE),
217: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,x_LAST_UPDATE_DATE),
218: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
219: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, NULL,x_CREATION_DATE),
220: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),

Line 217: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,x_LAST_UPDATE_DATE),

213: decode( x_ORIGINAL_WORD, FND_API.G_MISS_CHAR, NULL, UPPER(x_ORIGINAL_WORD)),
214: decode( x_REPLACEMENT_WORD, FND_API.G_MISS_CHAR, NULL, UPPER(x_REPLACEMENT_WORD)),
215: decode( x_TYPE, FND_API.G_MISS_CHAR, NULL, x_TYPE),
216: decode( x_COUNTRY_CODE, FND_API.G_MISS_CHAR, NULL, x_COUNTRY_CODE),
217: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,x_LAST_UPDATE_DATE),
218: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
219: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, NULL,x_CREATION_DATE),
220: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
221: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),

Line 218: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),

214: decode( x_REPLACEMENT_WORD, FND_API.G_MISS_CHAR, NULL, UPPER(x_REPLACEMENT_WORD)),
215: decode( x_TYPE, FND_API.G_MISS_CHAR, NULL, x_TYPE),
216: decode( x_COUNTRY_CODE, FND_API.G_MISS_CHAR, NULL, x_COUNTRY_CODE),
217: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,x_LAST_UPDATE_DATE),
218: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
219: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, NULL,x_CREATION_DATE),
220: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
221: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
222: decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE_CATEGORY),

Line 219: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, NULL,x_CREATION_DATE),

215: decode( x_TYPE, FND_API.G_MISS_CHAR, NULL, x_TYPE),
216: decode( x_COUNTRY_CODE, FND_API.G_MISS_CHAR, NULL, x_COUNTRY_CODE),
217: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,x_LAST_UPDATE_DATE),
218: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
219: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, NULL,x_CREATION_DATE),
220: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
221: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
222: decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE_CATEGORY),
223: decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE1),

Line 220: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),

216: decode( x_COUNTRY_CODE, FND_API.G_MISS_CHAR, NULL, x_COUNTRY_CODE),
217: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,x_LAST_UPDATE_DATE),
218: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
219: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, NULL,x_CREATION_DATE),
220: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
221: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
222: decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE_CATEGORY),
223: decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE1),
224: decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE2),

Line 221: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),

217: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,x_LAST_UPDATE_DATE),
218: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
219: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, NULL,x_CREATION_DATE),
220: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
221: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
222: decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE_CATEGORY),
223: decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE1),
224: decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE2),
225: decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE3),

Line 222: decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE_CATEGORY),

218: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
219: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, NULL,x_CREATION_DATE),
220: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
221: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
222: decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE_CATEGORY),
223: decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE1),
224: decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE2),
225: decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE3),
226: decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE4),

Line 223: decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE1),

219: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, NULL,x_CREATION_DATE),
220: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
221: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
222: decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE_CATEGORY),
223: decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE1),
224: decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE2),
225: decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE3),
226: decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE4),
227: decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE5),

Line 224: decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE2),

220: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
221: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
222: decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE_CATEGORY),
223: decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE1),
224: decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE2),
225: decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE3),
226: decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE4),
227: decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE5),
228: decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE6),

Line 225: decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE3),

221: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
222: decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE_CATEGORY),
223: decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE1),
224: decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE2),
225: decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE3),
226: decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE4),
227: decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE5),
228: decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE6),
229: decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE7),

Line 226: decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE4),

222: decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE_CATEGORY),
223: decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE1),
224: decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE2),
225: decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE3),
226: decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE4),
227: decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE5),
228: decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE6),
229: decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE7),
230: decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE8),

Line 227: decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE5),

223: decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE1),
224: decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE2),
225: decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE3),
226: decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE4),
227: decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE5),
228: decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE6),
229: decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE7),
230: decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE8),
231: decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE9),

Line 228: decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE6),

224: decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE2),
225: decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE3),
226: decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE4),
227: decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE5),
228: decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE6),
229: decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE7),
230: decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE8),
231: decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE9),
232: decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE10),

Line 229: decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE7),

225: decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE3),
226: decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE4),
227: decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE5),
228: decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE6),
229: decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE7),
230: decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE8),
231: decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE9),
232: decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE10),
233: decode( x_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE11),

Line 230: decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE8),

226: decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE4),
227: decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE5),
228: decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE6),
229: decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE7),
230: decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE8),
231: decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE9),
232: decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE10),
233: decode( x_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE11),
234: decode( x_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE12),

Line 231: decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE9),

227: decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE5),
228: decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE6),
229: decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE7),
230: decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE8),
231: decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE9),
232: decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE10),
233: decode( x_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE11),
234: decode( x_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE12),
235: decode( x_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE13),

Line 232: decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE10),

228: decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE6),
229: decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE7),
230: decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE8),
231: decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE9),
232: decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE10),
233: decode( x_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE11),
234: decode( x_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE12),
235: decode( x_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE13),
236: decode( x_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE14),

Line 233: decode( x_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE11),

229: decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE7),
230: decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE8),
231: decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE9),
232: decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE10),
233: decode( x_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE11),
234: decode( x_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE12),
235: decode( x_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE13),
236: decode( x_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE14),
237: decode( x_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE15),

Line 234: decode( x_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE12),

230: decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE8),
231: decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE9),
232: decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE10),
233: decode( x_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE11),
234: decode( x_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE12),
235: decode( x_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE13),
236: decode( x_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE14),
237: decode( x_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE15),
238: 1,

Line 235: decode( x_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE13),

231: decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE9),
232: decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE10),
233: decode( x_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE11),
234: decode( x_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE12),
235: decode( x_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE13),
236: decode( x_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE14),
237: decode( x_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE15),
238: 1,
239: decode(x_CONDITION_ID, FND_API.G_MISS_NUM, NULL, x_CONDITION_ID),

Line 236: decode( x_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE14),

232: decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE10),
233: decode( x_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE11),
234: decode( x_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE12),
235: decode( x_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE13),
236: decode( x_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE14),
237: decode( x_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE15),
238: 1,
239: decode(x_CONDITION_ID, FND_API.G_MISS_NUM, NULL, x_CONDITION_ID),
240: decode(x_USER_SPEC_COND_VALUE,FND_API.G_MISS_CHAR,null,x_USER_SPEC_COND_VALUE),

Line 237: decode( x_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE15),

233: decode( x_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE11),
234: decode( x_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE12),
235: decode( x_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE13),
236: decode( x_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE14),
237: decode( x_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE15),
238: 1,
239: decode(x_CONDITION_ID, FND_API.G_MISS_NUM, NULL, x_CONDITION_ID),
240: decode(x_USER_SPEC_COND_VALUE,FND_API.G_MISS_CHAR,null,x_USER_SPEC_COND_VALUE),
241: 'N',

Line 239: decode(x_CONDITION_ID, FND_API.G_MISS_NUM, NULL, x_CONDITION_ID),

235: decode( x_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE13),
236: decode( x_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE14),
237: decode( x_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE15),
238: 1,
239: decode(x_CONDITION_ID, FND_API.G_MISS_NUM, NULL, x_CONDITION_ID),
240: decode(x_USER_SPEC_COND_VALUE,FND_API.G_MISS_CHAR,null,x_USER_SPEC_COND_VALUE),
241: 'N',
242: 'N'
243: );

Line 240: decode(x_USER_SPEC_COND_VALUE,FND_API.G_MISS_CHAR,null,x_USER_SPEC_COND_VALUE),

236: decode( x_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE14),
237: decode( x_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE15),
238: 1,
239: decode(x_CONDITION_ID, FND_API.G_MISS_NUM, NULL, x_CONDITION_ID),
240: decode(x_USER_SPEC_COND_VALUE,FND_API.G_MISS_CHAR,null,x_USER_SPEC_COND_VALUE),
241: 'N',
242: 'N'
243: );
244: OPEN C;

Line 269: AND nvl(user_spec_cond_value,FND_API.G_MISS_CHAR) = nvl(x_user_spec_cond_value,FND_API.G_MISS_CHAR)

265: CURSOR C IS SELECT STAGED_FLAG FROM HZ_WORD_REPLACEMENTS
266: WHERE WORD_LIST_ID = x_WORD_LIST_ID
267: AND ORIGINAL_WORD = x_ORIGINAL_WORD
268: AND NVL(CONDITION_ID,-99) = NVL(X_CONDITION_ID,-99)
269: AND nvl(user_spec_cond_value,FND_API.G_MISS_CHAR) = nvl(x_user_spec_cond_value,FND_API.G_MISS_CHAR)
270: AND DELETE_FLAG = 'N';
271: l_staged_flag varchar2(1);
272: BEGIN
273: OPEN C;

Line 285: AND nvl(user_spec_cond_value,FND_API.G_MISS_CHAR) = nvl(x_user_spec_cond_value,FND_API.G_MISS_CHAR)

281: DELETE FROM HZ_WORD_REPLACEMENTS
282: WHERE WORD_LIST_ID = x_WORD_LIST_ID
283: AND ORIGINAL_WORD = x_ORIGINAL_WORD
284: AND NVL(CONDITION_ID,-99) = NVL(X_CONDITION_ID,-99)
285: AND nvl(user_spec_cond_value,FND_API.G_MISS_CHAR) = nvl(x_user_spec_cond_value,FND_API.G_MISS_CHAR)
286: AND DELETE_FLAG = 'N'
287: AND STAGED_FLAG = 'N';
288: ELSE
289: UPDATE HZ_WORD_REPLACEMENTS

Line 294: AND nvl(user_spec_cond_value,FND_API.G_MISS_CHAR) = nvl(x_user_spec_cond_value,FND_API.G_MISS_CHAR)

290: SET DELETE_FLAG = 'Y'
291: WHERE WORD_LIST_ID = x_WORD_LIST_ID
292: AND ORIGINAL_WORD = x_ORIGINAL_WORD
293: AND NVL(CONDITION_ID,-99) = NVL(X_CONDITION_ID,-99)
294: AND nvl(user_spec_cond_value,FND_API.G_MISS_CHAR) = nvl(x_user_spec_cond_value,FND_API.G_MISS_CHAR)
295: AND DELETE_FLAG = 'N'
296: AND STAGED_FLAG = 'Y' ;
297: END IF;
298: END Delete_Row;

Line 358: (decode(x_CONDITION_ID, FND_API.G_MISS_NUM, NULL, x_CONDITION_ID) IS NULL)

354: AND delete_flag = 'N'
355: AND original_word = UPPER(x_ORIGINAL_WORD)
356: AND (condition_id IS NULL
357: OR
358: (decode(x_CONDITION_ID, FND_API.G_MISS_NUM, NULL, x_CONDITION_ID) IS NULL)
359: OR
360: ( (condition_id = x_condition_id)
361: AND ( nvl(user_spec_cond_value,FND_API.G_MISS_CHAR) = nvl(x_user_spec_cond_value,FND_API.G_MISS_CHAR )
362: OR nvl(replacement_word,FND_API.G_MISS_CHAR) = nvl(upper(x_replacement_word),FND_API.G_MISS_CHAR)

Line 361: AND ( nvl(user_spec_cond_value,FND_API.G_MISS_CHAR) = nvl(x_user_spec_cond_value,FND_API.G_MISS_CHAR )

357: OR
358: (decode(x_CONDITION_ID, FND_API.G_MISS_NUM, NULL, x_CONDITION_ID) IS NULL)
359: OR
360: ( (condition_id = x_condition_id)
361: AND ( nvl(user_spec_cond_value,FND_API.G_MISS_CHAR) = nvl(x_user_spec_cond_value,FND_API.G_MISS_CHAR )
362: OR nvl(replacement_word,FND_API.G_MISS_CHAR) = nvl(upper(x_replacement_word),FND_API.G_MISS_CHAR)
363: )
364: )
365: )

Line 362: OR nvl(replacement_word,FND_API.G_MISS_CHAR) = nvl(upper(x_replacement_word),FND_API.G_MISS_CHAR)

358: (decode(x_CONDITION_ID, FND_API.G_MISS_NUM, NULL, x_CONDITION_ID) IS NULL)
359: OR
360: ( (condition_id = x_condition_id)
361: AND ( nvl(user_spec_cond_value,FND_API.G_MISS_CHAR) = nvl(x_user_spec_cond_value,FND_API.G_MISS_CHAR )
362: OR nvl(replacement_word,FND_API.G_MISS_CHAR) = nvl(upper(x_replacement_word),FND_API.G_MISS_CHAR)
363: )
364: )
365: )
366: AND rowid <> x_Rowid;

Line 469: REPLACEMENT_WORD = decode(x_REPLACEMENT_WORD,NULL,REPLACEMENT_WORD, FND_API.G_MISS_CHAR, NULL,UPPER(x_REPLACEMENT_WORD)),

465: p_object_version_number := NVL(X_object_version_number, 1) + 1;
466:
467: Update HZ_WORD_REPLACEMENTS
468: SET
469: REPLACEMENT_WORD = decode(x_REPLACEMENT_WORD,NULL,REPLACEMENT_WORD, FND_API.G_MISS_CHAR, NULL,UPPER(x_REPLACEMENT_WORD)),
470: TYPE = decode( x_TYPE,NULL,TYPE,FND_API.G_MISS_CHAR, NULL, x_TYPE),
471: COUNTRY_CODE = decode( x_COUNTRY_CODE, NULL, COUNTRY_CODE,FND_API.G_MISS_CHAR, NULL, x_COUNTRY_CODE),
472: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, NULL,LAST_UPDATE_DATE,FND_API.G_MISS_DATE,NULL,x_LAST_UPDATE_DATE),
473: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, NULL,LAST_UPDATED_BY,FND_API.G_MISS_NUM,NULL,x_LAST_UPDATED_BY),

Line 470: TYPE = decode( x_TYPE,NULL,TYPE,FND_API.G_MISS_CHAR, NULL, x_TYPE),

466:
467: Update HZ_WORD_REPLACEMENTS
468: SET
469: REPLACEMENT_WORD = decode(x_REPLACEMENT_WORD,NULL,REPLACEMENT_WORD, FND_API.G_MISS_CHAR, NULL,UPPER(x_REPLACEMENT_WORD)),
470: TYPE = decode( x_TYPE,NULL,TYPE,FND_API.G_MISS_CHAR, NULL, x_TYPE),
471: COUNTRY_CODE = decode( x_COUNTRY_CODE, NULL, COUNTRY_CODE,FND_API.G_MISS_CHAR, NULL, x_COUNTRY_CODE),
472: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, NULL,LAST_UPDATE_DATE,FND_API.G_MISS_DATE,NULL,x_LAST_UPDATE_DATE),
473: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, NULL,LAST_UPDATED_BY,FND_API.G_MISS_NUM,NULL,x_LAST_UPDATED_BY),
474: -- Bug 3032780

Line 471: COUNTRY_CODE = decode( x_COUNTRY_CODE, NULL, COUNTRY_CODE,FND_API.G_MISS_CHAR, NULL, x_COUNTRY_CODE),

467: Update HZ_WORD_REPLACEMENTS
468: SET
469: REPLACEMENT_WORD = decode(x_REPLACEMENT_WORD,NULL,REPLACEMENT_WORD, FND_API.G_MISS_CHAR, NULL,UPPER(x_REPLACEMENT_WORD)),
470: TYPE = decode( x_TYPE,NULL,TYPE,FND_API.G_MISS_CHAR, NULL, x_TYPE),
471: COUNTRY_CODE = decode( x_COUNTRY_CODE, NULL, COUNTRY_CODE,FND_API.G_MISS_CHAR, NULL, x_COUNTRY_CODE),
472: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, NULL,LAST_UPDATE_DATE,FND_API.G_MISS_DATE,NULL,x_LAST_UPDATE_DATE),
473: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, NULL,LAST_UPDATED_BY,FND_API.G_MISS_NUM,NULL,x_LAST_UPDATED_BY),
474: -- Bug 3032780
475: /*

Line 472: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, NULL,LAST_UPDATE_DATE,FND_API.G_MISS_DATE,NULL,x_LAST_UPDATE_DATE),

468: SET
469: REPLACEMENT_WORD = decode(x_REPLACEMENT_WORD,NULL,REPLACEMENT_WORD, FND_API.G_MISS_CHAR, NULL,UPPER(x_REPLACEMENT_WORD)),
470: TYPE = decode( x_TYPE,NULL,TYPE,FND_API.G_MISS_CHAR, NULL, x_TYPE),
471: COUNTRY_CODE = decode( x_COUNTRY_CODE, NULL, COUNTRY_CODE,FND_API.G_MISS_CHAR, NULL, x_COUNTRY_CODE),
472: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, NULL,LAST_UPDATE_DATE,FND_API.G_MISS_DATE,NULL,x_LAST_UPDATE_DATE),
473: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, NULL,LAST_UPDATED_BY,FND_API.G_MISS_NUM,NULL,x_LAST_UPDATED_BY),
474: -- Bug 3032780
475: /*
476: CREATION_DATE = decode( x_CREATION_DATE, NULL,CREATION_DATE,FND_API.G_MISS_DATE,NULL,x_CREATION_DATE),

Line 473: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, NULL,LAST_UPDATED_BY,FND_API.G_MISS_NUM,NULL,x_LAST_UPDATED_BY),

469: REPLACEMENT_WORD = decode(x_REPLACEMENT_WORD,NULL,REPLACEMENT_WORD, FND_API.G_MISS_CHAR, NULL,UPPER(x_REPLACEMENT_WORD)),
470: TYPE = decode( x_TYPE,NULL,TYPE,FND_API.G_MISS_CHAR, NULL, x_TYPE),
471: COUNTRY_CODE = decode( x_COUNTRY_CODE, NULL, COUNTRY_CODE,FND_API.G_MISS_CHAR, NULL, x_COUNTRY_CODE),
472: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, NULL,LAST_UPDATE_DATE,FND_API.G_MISS_DATE,NULL,x_LAST_UPDATE_DATE),
473: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, NULL,LAST_UPDATED_BY,FND_API.G_MISS_NUM,NULL,x_LAST_UPDATED_BY),
474: -- Bug 3032780
475: /*
476: CREATION_DATE = decode( x_CREATION_DATE, NULL,CREATION_DATE,FND_API.G_MISS_DATE,NULL,x_CREATION_DATE),
477: CREATED_BY = decode( x_CREATED_BY, NULL,CREATED_BY,FND_API.G_MISS_NUM,NULL,x_CREATED_BY),

Line 476: CREATION_DATE = decode( x_CREATION_DATE, NULL,CREATION_DATE,FND_API.G_MISS_DATE,NULL,x_CREATION_DATE),

472: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, NULL,LAST_UPDATE_DATE,FND_API.G_MISS_DATE,NULL,x_LAST_UPDATE_DATE),
473: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, NULL,LAST_UPDATED_BY,FND_API.G_MISS_NUM,NULL,x_LAST_UPDATED_BY),
474: -- Bug 3032780
475: /*
476: CREATION_DATE = decode( x_CREATION_DATE, NULL,CREATION_DATE,FND_API.G_MISS_DATE,NULL,x_CREATION_DATE),
477: CREATED_BY = decode( x_CREATED_BY, NULL,CREATED_BY,FND_API.G_MISS_NUM,NULL,x_CREATED_BY),
478: */
479: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, NULL,LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,NULL,x_LAST_UPDATE_LOGIN),
480: ATTRIBUTE_CATEGORY = decode( x_ATTRIBUTE_CATEGORY, NULL,ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE_CATEGORY),

Line 477: CREATED_BY = decode( x_CREATED_BY, NULL,CREATED_BY,FND_API.G_MISS_NUM,NULL,x_CREATED_BY),

473: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, NULL,LAST_UPDATED_BY,FND_API.G_MISS_NUM,NULL,x_LAST_UPDATED_BY),
474: -- Bug 3032780
475: /*
476: CREATION_DATE = decode( x_CREATION_DATE, NULL,CREATION_DATE,FND_API.G_MISS_DATE,NULL,x_CREATION_DATE),
477: CREATED_BY = decode( x_CREATED_BY, NULL,CREATED_BY,FND_API.G_MISS_NUM,NULL,x_CREATED_BY),
478: */
479: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, NULL,LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,NULL,x_LAST_UPDATE_LOGIN),
480: ATTRIBUTE_CATEGORY = decode( x_ATTRIBUTE_CATEGORY, NULL,ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE_CATEGORY),
481: ATTRIBUTE1 = decode( x_ATTRIBUTE1, NULL,ATTRIBUTE1,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE1),

Line 479: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, NULL,LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,NULL,x_LAST_UPDATE_LOGIN),

475: /*
476: CREATION_DATE = decode( x_CREATION_DATE, NULL,CREATION_DATE,FND_API.G_MISS_DATE,NULL,x_CREATION_DATE),
477: CREATED_BY = decode( x_CREATED_BY, NULL,CREATED_BY,FND_API.G_MISS_NUM,NULL,x_CREATED_BY),
478: */
479: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, NULL,LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,NULL,x_LAST_UPDATE_LOGIN),
480: ATTRIBUTE_CATEGORY = decode( x_ATTRIBUTE_CATEGORY, NULL,ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE_CATEGORY),
481: ATTRIBUTE1 = decode( x_ATTRIBUTE1, NULL,ATTRIBUTE1,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE1),
482: ATTRIBUTE2 = decode( x_ATTRIBUTE2, NULL,ATTRIBUTE2,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE2),
483: ATTRIBUTE3 = decode( x_ATTRIBUTE3, NULL,ATTRIBUTE3,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE3),

Line 480: ATTRIBUTE_CATEGORY = decode( x_ATTRIBUTE_CATEGORY, NULL,ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE_CATEGORY),

476: CREATION_DATE = decode( x_CREATION_DATE, NULL,CREATION_DATE,FND_API.G_MISS_DATE,NULL,x_CREATION_DATE),
477: CREATED_BY = decode( x_CREATED_BY, NULL,CREATED_BY,FND_API.G_MISS_NUM,NULL,x_CREATED_BY),
478: */
479: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, NULL,LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,NULL,x_LAST_UPDATE_LOGIN),
480: ATTRIBUTE_CATEGORY = decode( x_ATTRIBUTE_CATEGORY, NULL,ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE_CATEGORY),
481: ATTRIBUTE1 = decode( x_ATTRIBUTE1, NULL,ATTRIBUTE1,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE1),
482: ATTRIBUTE2 = decode( x_ATTRIBUTE2, NULL,ATTRIBUTE2,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE2),
483: ATTRIBUTE3 = decode( x_ATTRIBUTE3, NULL,ATTRIBUTE3,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE3),
484: ATTRIBUTE4 = decode( x_ATTRIBUTE4, NULL,ATTRIBUTE4,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE4),

Line 481: ATTRIBUTE1 = decode( x_ATTRIBUTE1, NULL,ATTRIBUTE1,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE1),

477: CREATED_BY = decode( x_CREATED_BY, NULL,CREATED_BY,FND_API.G_MISS_NUM,NULL,x_CREATED_BY),
478: */
479: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, NULL,LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,NULL,x_LAST_UPDATE_LOGIN),
480: ATTRIBUTE_CATEGORY = decode( x_ATTRIBUTE_CATEGORY, NULL,ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE_CATEGORY),
481: ATTRIBUTE1 = decode( x_ATTRIBUTE1, NULL,ATTRIBUTE1,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE1),
482: ATTRIBUTE2 = decode( x_ATTRIBUTE2, NULL,ATTRIBUTE2,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE2),
483: ATTRIBUTE3 = decode( x_ATTRIBUTE3, NULL,ATTRIBUTE3,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE3),
484: ATTRIBUTE4 = decode( x_ATTRIBUTE4, NULL,ATTRIBUTE4,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE4),
485: ATTRIBUTE5 = decode( x_ATTRIBUTE5, NULL,ATTRIBUTE5,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE5),

Line 482: ATTRIBUTE2 = decode( x_ATTRIBUTE2, NULL,ATTRIBUTE2,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE2),

478: */
479: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, NULL,LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,NULL,x_LAST_UPDATE_LOGIN),
480: ATTRIBUTE_CATEGORY = decode( x_ATTRIBUTE_CATEGORY, NULL,ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE_CATEGORY),
481: ATTRIBUTE1 = decode( x_ATTRIBUTE1, NULL,ATTRIBUTE1,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE1),
482: ATTRIBUTE2 = decode( x_ATTRIBUTE2, NULL,ATTRIBUTE2,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE2),
483: ATTRIBUTE3 = decode( x_ATTRIBUTE3, NULL,ATTRIBUTE3,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE3),
484: ATTRIBUTE4 = decode( x_ATTRIBUTE4, NULL,ATTRIBUTE4,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE4),
485: ATTRIBUTE5 = decode( x_ATTRIBUTE5, NULL,ATTRIBUTE5,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE5),
486: ATTRIBUTE6 = decode( x_ATTRIBUTE6, NULL,ATTRIBUTE6,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE6),

Line 483: ATTRIBUTE3 = decode( x_ATTRIBUTE3, NULL,ATTRIBUTE3,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE3),

479: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, NULL,LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,NULL,x_LAST_UPDATE_LOGIN),
480: ATTRIBUTE_CATEGORY = decode( x_ATTRIBUTE_CATEGORY, NULL,ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE_CATEGORY),
481: ATTRIBUTE1 = decode( x_ATTRIBUTE1, NULL,ATTRIBUTE1,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE1),
482: ATTRIBUTE2 = decode( x_ATTRIBUTE2, NULL,ATTRIBUTE2,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE2),
483: ATTRIBUTE3 = decode( x_ATTRIBUTE3, NULL,ATTRIBUTE3,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE3),
484: ATTRIBUTE4 = decode( x_ATTRIBUTE4, NULL,ATTRIBUTE4,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE4),
485: ATTRIBUTE5 = decode( x_ATTRIBUTE5, NULL,ATTRIBUTE5,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE5),
486: ATTRIBUTE6 = decode( x_ATTRIBUTE6, NULL,ATTRIBUTE6,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE6),
487: ATTRIBUTE7 = decode( x_ATTRIBUTE7, NULL,ATTRIBUTE7,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE7),

Line 484: ATTRIBUTE4 = decode( x_ATTRIBUTE4, NULL,ATTRIBUTE4,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE4),

480: ATTRIBUTE_CATEGORY = decode( x_ATTRIBUTE_CATEGORY, NULL,ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE_CATEGORY),
481: ATTRIBUTE1 = decode( x_ATTRIBUTE1, NULL,ATTRIBUTE1,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE1),
482: ATTRIBUTE2 = decode( x_ATTRIBUTE2, NULL,ATTRIBUTE2,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE2),
483: ATTRIBUTE3 = decode( x_ATTRIBUTE3, NULL,ATTRIBUTE3,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE3),
484: ATTRIBUTE4 = decode( x_ATTRIBUTE4, NULL,ATTRIBUTE4,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE4),
485: ATTRIBUTE5 = decode( x_ATTRIBUTE5, NULL,ATTRIBUTE5,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE5),
486: ATTRIBUTE6 = decode( x_ATTRIBUTE6, NULL,ATTRIBUTE6,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE6),
487: ATTRIBUTE7 = decode( x_ATTRIBUTE7, NULL,ATTRIBUTE7,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE7),
488: ATTRIBUTE8 = decode( x_ATTRIBUTE8, NULL,ATTRIBUTE8,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE8),

Line 485: ATTRIBUTE5 = decode( x_ATTRIBUTE5, NULL,ATTRIBUTE5,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE5),

481: ATTRIBUTE1 = decode( x_ATTRIBUTE1, NULL,ATTRIBUTE1,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE1),
482: ATTRIBUTE2 = decode( x_ATTRIBUTE2, NULL,ATTRIBUTE2,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE2),
483: ATTRIBUTE3 = decode( x_ATTRIBUTE3, NULL,ATTRIBUTE3,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE3),
484: ATTRIBUTE4 = decode( x_ATTRIBUTE4, NULL,ATTRIBUTE4,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE4),
485: ATTRIBUTE5 = decode( x_ATTRIBUTE5, NULL,ATTRIBUTE5,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE5),
486: ATTRIBUTE6 = decode( x_ATTRIBUTE6, NULL,ATTRIBUTE6,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE6),
487: ATTRIBUTE7 = decode( x_ATTRIBUTE7, NULL,ATTRIBUTE7,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE7),
488: ATTRIBUTE8 = decode( x_ATTRIBUTE8, NULL,ATTRIBUTE8,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE8),
489: ATTRIBUTE9 = decode( x_ATTRIBUTE9, NULL,ATTRIBUTE9,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE9),

Line 486: ATTRIBUTE6 = decode( x_ATTRIBUTE6, NULL,ATTRIBUTE6,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE6),

482: ATTRIBUTE2 = decode( x_ATTRIBUTE2, NULL,ATTRIBUTE2,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE2),
483: ATTRIBUTE3 = decode( x_ATTRIBUTE3, NULL,ATTRIBUTE3,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE3),
484: ATTRIBUTE4 = decode( x_ATTRIBUTE4, NULL,ATTRIBUTE4,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE4),
485: ATTRIBUTE5 = decode( x_ATTRIBUTE5, NULL,ATTRIBUTE5,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE5),
486: ATTRIBUTE6 = decode( x_ATTRIBUTE6, NULL,ATTRIBUTE6,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE6),
487: ATTRIBUTE7 = decode( x_ATTRIBUTE7, NULL,ATTRIBUTE7,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE7),
488: ATTRIBUTE8 = decode( x_ATTRIBUTE8, NULL,ATTRIBUTE8,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE8),
489: ATTRIBUTE9 = decode( x_ATTRIBUTE9, NULL,ATTRIBUTE9,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE9),
490: ATTRIBUTE10 = decode( x_ATTRIBUTE10, NULL,ATTRIBUTE10,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE10),

Line 487: ATTRIBUTE7 = decode( x_ATTRIBUTE7, NULL,ATTRIBUTE7,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE7),

483: ATTRIBUTE3 = decode( x_ATTRIBUTE3, NULL,ATTRIBUTE3,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE3),
484: ATTRIBUTE4 = decode( x_ATTRIBUTE4, NULL,ATTRIBUTE4,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE4),
485: ATTRIBUTE5 = decode( x_ATTRIBUTE5, NULL,ATTRIBUTE5,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE5),
486: ATTRIBUTE6 = decode( x_ATTRIBUTE6, NULL,ATTRIBUTE6,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE6),
487: ATTRIBUTE7 = decode( x_ATTRIBUTE7, NULL,ATTRIBUTE7,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE7),
488: ATTRIBUTE8 = decode( x_ATTRIBUTE8, NULL,ATTRIBUTE8,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE8),
489: ATTRIBUTE9 = decode( x_ATTRIBUTE9, NULL,ATTRIBUTE9,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE9),
490: ATTRIBUTE10 = decode( x_ATTRIBUTE10, NULL,ATTRIBUTE10,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE10),
491: ATTRIBUTE11 = decode( x_ATTRIBUTE11, NULL,ATTRIBUTE11,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE11),

Line 488: ATTRIBUTE8 = decode( x_ATTRIBUTE8, NULL,ATTRIBUTE8,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE8),

484: ATTRIBUTE4 = decode( x_ATTRIBUTE4, NULL,ATTRIBUTE4,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE4),
485: ATTRIBUTE5 = decode( x_ATTRIBUTE5, NULL,ATTRIBUTE5,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE5),
486: ATTRIBUTE6 = decode( x_ATTRIBUTE6, NULL,ATTRIBUTE6,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE6),
487: ATTRIBUTE7 = decode( x_ATTRIBUTE7, NULL,ATTRIBUTE7,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE7),
488: ATTRIBUTE8 = decode( x_ATTRIBUTE8, NULL,ATTRIBUTE8,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE8),
489: ATTRIBUTE9 = decode( x_ATTRIBUTE9, NULL,ATTRIBUTE9,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE9),
490: ATTRIBUTE10 = decode( x_ATTRIBUTE10, NULL,ATTRIBUTE10,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE10),
491: ATTRIBUTE11 = decode( x_ATTRIBUTE11, NULL,ATTRIBUTE11,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE11),
492: ATTRIBUTE12 = decode( x_ATTRIBUTE12, NULL,ATTRIBUTE12,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE12),

Line 489: ATTRIBUTE9 = decode( x_ATTRIBUTE9, NULL,ATTRIBUTE9,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE9),

485: ATTRIBUTE5 = decode( x_ATTRIBUTE5, NULL,ATTRIBUTE5,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE5),
486: ATTRIBUTE6 = decode( x_ATTRIBUTE6, NULL,ATTRIBUTE6,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE6),
487: ATTRIBUTE7 = decode( x_ATTRIBUTE7, NULL,ATTRIBUTE7,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE7),
488: ATTRIBUTE8 = decode( x_ATTRIBUTE8, NULL,ATTRIBUTE8,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE8),
489: ATTRIBUTE9 = decode( x_ATTRIBUTE9, NULL,ATTRIBUTE9,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE9),
490: ATTRIBUTE10 = decode( x_ATTRIBUTE10, NULL,ATTRIBUTE10,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE10),
491: ATTRIBUTE11 = decode( x_ATTRIBUTE11, NULL,ATTRIBUTE11,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE11),
492: ATTRIBUTE12 = decode( x_ATTRIBUTE12, NULL,ATTRIBUTE12,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE12),
493: ATTRIBUTE13 = decode( x_ATTRIBUTE13, NULL,ATTRIBUTE13,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE13),

Line 490: ATTRIBUTE10 = decode( x_ATTRIBUTE10, NULL,ATTRIBUTE10,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE10),

486: ATTRIBUTE6 = decode( x_ATTRIBUTE6, NULL,ATTRIBUTE6,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE6),
487: ATTRIBUTE7 = decode( x_ATTRIBUTE7, NULL,ATTRIBUTE7,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE7),
488: ATTRIBUTE8 = decode( x_ATTRIBUTE8, NULL,ATTRIBUTE8,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE8),
489: ATTRIBUTE9 = decode( x_ATTRIBUTE9, NULL,ATTRIBUTE9,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE9),
490: ATTRIBUTE10 = decode( x_ATTRIBUTE10, NULL,ATTRIBUTE10,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE10),
491: ATTRIBUTE11 = decode( x_ATTRIBUTE11, NULL,ATTRIBUTE11,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE11),
492: ATTRIBUTE12 = decode( x_ATTRIBUTE12, NULL,ATTRIBUTE12,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE12),
493: ATTRIBUTE13 = decode( x_ATTRIBUTE13, NULL,ATTRIBUTE13,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE13),
494: ATTRIBUTE14 = decode( x_ATTRIBUTE14, NULL,ATTRIBUTE14,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE14),

Line 491: ATTRIBUTE11 = decode( x_ATTRIBUTE11, NULL,ATTRIBUTE11,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE11),

487: ATTRIBUTE7 = decode( x_ATTRIBUTE7, NULL,ATTRIBUTE7,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE7),
488: ATTRIBUTE8 = decode( x_ATTRIBUTE8, NULL,ATTRIBUTE8,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE8),
489: ATTRIBUTE9 = decode( x_ATTRIBUTE9, NULL,ATTRIBUTE9,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE9),
490: ATTRIBUTE10 = decode( x_ATTRIBUTE10, NULL,ATTRIBUTE10,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE10),
491: ATTRIBUTE11 = decode( x_ATTRIBUTE11, NULL,ATTRIBUTE11,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE11),
492: ATTRIBUTE12 = decode( x_ATTRIBUTE12, NULL,ATTRIBUTE12,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE12),
493: ATTRIBUTE13 = decode( x_ATTRIBUTE13, NULL,ATTRIBUTE13,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE13),
494: ATTRIBUTE14 = decode( x_ATTRIBUTE14, NULL,ATTRIBUTE14,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE14),
495: ATTRIBUTE15 = decode( x_ATTRIBUTE15, NULL,ATTRIBUTE15,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE15),

Line 492: ATTRIBUTE12 = decode( x_ATTRIBUTE12, NULL,ATTRIBUTE12,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE12),

488: ATTRIBUTE8 = decode( x_ATTRIBUTE8, NULL,ATTRIBUTE8,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE8),
489: ATTRIBUTE9 = decode( x_ATTRIBUTE9, NULL,ATTRIBUTE9,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE9),
490: ATTRIBUTE10 = decode( x_ATTRIBUTE10, NULL,ATTRIBUTE10,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE10),
491: ATTRIBUTE11 = decode( x_ATTRIBUTE11, NULL,ATTRIBUTE11,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE11),
492: ATTRIBUTE12 = decode( x_ATTRIBUTE12, NULL,ATTRIBUTE12,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE12),
493: ATTRIBUTE13 = decode( x_ATTRIBUTE13, NULL,ATTRIBUTE13,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE13),
494: ATTRIBUTE14 = decode( x_ATTRIBUTE14, NULL,ATTRIBUTE14,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE14),
495: ATTRIBUTE15 = decode( x_ATTRIBUTE15, NULL,ATTRIBUTE15,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE15),
496: OBJECT_VERSION_NUMBER = p_object_version_number,

Line 493: ATTRIBUTE13 = decode( x_ATTRIBUTE13, NULL,ATTRIBUTE13,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE13),

489: ATTRIBUTE9 = decode( x_ATTRIBUTE9, NULL,ATTRIBUTE9,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE9),
490: ATTRIBUTE10 = decode( x_ATTRIBUTE10, NULL,ATTRIBUTE10,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE10),
491: ATTRIBUTE11 = decode( x_ATTRIBUTE11, NULL,ATTRIBUTE11,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE11),
492: ATTRIBUTE12 = decode( x_ATTRIBUTE12, NULL,ATTRIBUTE12,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE12),
493: ATTRIBUTE13 = decode( x_ATTRIBUTE13, NULL,ATTRIBUTE13,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE13),
494: ATTRIBUTE14 = decode( x_ATTRIBUTE14, NULL,ATTRIBUTE14,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE14),
495: ATTRIBUTE15 = decode( x_ATTRIBUTE15, NULL,ATTRIBUTE15,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE15),
496: OBJECT_VERSION_NUMBER = p_object_version_number,
497: CONDITION_ID = decode(x_CONDITION_ID, NULL, CONDITION_ID,FND_API.G_MISS_NUM,NULL, x_CONDITION_ID),

Line 494: ATTRIBUTE14 = decode( x_ATTRIBUTE14, NULL,ATTRIBUTE14,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE14),

490: ATTRIBUTE10 = decode( x_ATTRIBUTE10, NULL,ATTRIBUTE10,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE10),
491: ATTRIBUTE11 = decode( x_ATTRIBUTE11, NULL,ATTRIBUTE11,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE11),
492: ATTRIBUTE12 = decode( x_ATTRIBUTE12, NULL,ATTRIBUTE12,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE12),
493: ATTRIBUTE13 = decode( x_ATTRIBUTE13, NULL,ATTRIBUTE13,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE13),
494: ATTRIBUTE14 = decode( x_ATTRIBUTE14, NULL,ATTRIBUTE14,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE14),
495: ATTRIBUTE15 = decode( x_ATTRIBUTE15, NULL,ATTRIBUTE15,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE15),
496: OBJECT_VERSION_NUMBER = p_object_version_number,
497: CONDITION_ID = decode(x_CONDITION_ID, NULL, CONDITION_ID,FND_API.G_MISS_NUM,NULL, x_CONDITION_ID),
498: USER_SPEC_COND_VALUE= decode(x_USER_SPEC_COND_VALUE,NULL,USER_SPEC_COND_VALUE,FND_API.G_MISS_CHAR, NULL,x_USER_SPEC_COND_VALUE)

Line 495: ATTRIBUTE15 = decode( x_ATTRIBUTE15, NULL,ATTRIBUTE15,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE15),

491: ATTRIBUTE11 = decode( x_ATTRIBUTE11, NULL,ATTRIBUTE11,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE11),
492: ATTRIBUTE12 = decode( x_ATTRIBUTE12, NULL,ATTRIBUTE12,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE12),
493: ATTRIBUTE13 = decode( x_ATTRIBUTE13, NULL,ATTRIBUTE13,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE13),
494: ATTRIBUTE14 = decode( x_ATTRIBUTE14, NULL,ATTRIBUTE14,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE14),
495: ATTRIBUTE15 = decode( x_ATTRIBUTE15, NULL,ATTRIBUTE15,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE15),
496: OBJECT_VERSION_NUMBER = p_object_version_number,
497: CONDITION_ID = decode(x_CONDITION_ID, NULL, CONDITION_ID,FND_API.G_MISS_NUM,NULL, x_CONDITION_ID),
498: USER_SPEC_COND_VALUE= decode(x_USER_SPEC_COND_VALUE,NULL,USER_SPEC_COND_VALUE,FND_API.G_MISS_CHAR, NULL,x_USER_SPEC_COND_VALUE)
499: where rowid = X_RowId;

Line 497: CONDITION_ID = decode(x_CONDITION_ID, NULL, CONDITION_ID,FND_API.G_MISS_NUM,NULL, x_CONDITION_ID),

493: ATTRIBUTE13 = decode( x_ATTRIBUTE13, NULL,ATTRIBUTE13,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE13),
494: ATTRIBUTE14 = decode( x_ATTRIBUTE14, NULL,ATTRIBUTE14,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE14),
495: ATTRIBUTE15 = decode( x_ATTRIBUTE15, NULL,ATTRIBUTE15,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE15),
496: OBJECT_VERSION_NUMBER = p_object_version_number,
497: CONDITION_ID = decode(x_CONDITION_ID, NULL, CONDITION_ID,FND_API.G_MISS_NUM,NULL, x_CONDITION_ID),
498: USER_SPEC_COND_VALUE= decode(x_USER_SPEC_COND_VALUE,NULL,USER_SPEC_COND_VALUE,FND_API.G_MISS_CHAR, NULL,x_USER_SPEC_COND_VALUE)
499: where rowid = X_RowId;
500:
501: If (SQL%NOTFOUND) then

Line 498: USER_SPEC_COND_VALUE= decode(x_USER_SPEC_COND_VALUE,NULL,USER_SPEC_COND_VALUE,FND_API.G_MISS_CHAR, NULL,x_USER_SPEC_COND_VALUE)

494: ATTRIBUTE14 = decode( x_ATTRIBUTE14, NULL,ATTRIBUTE14,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE14),
495: ATTRIBUTE15 = decode( x_ATTRIBUTE15, NULL,ATTRIBUTE15,FND_API.G_MISS_CHAR, NULL,x_ATTRIBUTE15),
496: OBJECT_VERSION_NUMBER = p_object_version_number,
497: CONDITION_ID = decode(x_CONDITION_ID, NULL, CONDITION_ID,FND_API.G_MISS_NUM,NULL, x_CONDITION_ID),
498: USER_SPEC_COND_VALUE= decode(x_USER_SPEC_COND_VALUE,NULL,USER_SPEC_COND_VALUE,FND_API.G_MISS_CHAR, NULL,x_USER_SPEC_COND_VALUE)
499: where rowid = X_RowId;
500:
501: If (SQL%NOTFOUND) then
502: RAISE NO_DATA_FOUND;