DBA Data[Home] [Help]

APPS.PA_RES_MANAGEMENT_AMG_PUB dependencies on FND_FLEX_DESCVAL

Line 231: fnd_flex_descval.set_context_value(p_attribute_category);

227: -- return;
228: --END IF;
229:
230: -- DEFINE ID COLUMNS
231: fnd_flex_descval.set_context_value(p_attribute_category);
232: fnd_flex_descval.set_column_value('ATTRIBUTE1', px_attribute1);
233: fnd_flex_descval.set_column_value('ATTRIBUTE2', px_attribute2);
234: fnd_flex_descval.set_column_value('ATTRIBUTE3', px_attribute3);
235: fnd_flex_descval.set_column_value('ATTRIBUTE4', px_attribute4);

Line 232: fnd_flex_descval.set_column_value('ATTRIBUTE1', px_attribute1);

228: --END IF;
229:
230: -- DEFINE ID COLUMNS
231: fnd_flex_descval.set_context_value(p_attribute_category);
232: fnd_flex_descval.set_column_value('ATTRIBUTE1', px_attribute1);
233: fnd_flex_descval.set_column_value('ATTRIBUTE2', px_attribute2);
234: fnd_flex_descval.set_column_value('ATTRIBUTE3', px_attribute3);
235: fnd_flex_descval.set_column_value('ATTRIBUTE4', px_attribute4);
236: fnd_flex_descval.set_column_value('ATTRIBUTE5', px_attribute5);

Line 233: fnd_flex_descval.set_column_value('ATTRIBUTE2', px_attribute2);

229:
230: -- DEFINE ID COLUMNS
231: fnd_flex_descval.set_context_value(p_attribute_category);
232: fnd_flex_descval.set_column_value('ATTRIBUTE1', px_attribute1);
233: fnd_flex_descval.set_column_value('ATTRIBUTE2', px_attribute2);
234: fnd_flex_descval.set_column_value('ATTRIBUTE3', px_attribute3);
235: fnd_flex_descval.set_column_value('ATTRIBUTE4', px_attribute4);
236: fnd_flex_descval.set_column_value('ATTRIBUTE5', px_attribute5);
237: fnd_flex_descval.set_column_value('ATTRIBUTE6', px_attribute6);

Line 234: fnd_flex_descval.set_column_value('ATTRIBUTE3', px_attribute3);

230: -- DEFINE ID COLUMNS
231: fnd_flex_descval.set_context_value(p_attribute_category);
232: fnd_flex_descval.set_column_value('ATTRIBUTE1', px_attribute1);
233: fnd_flex_descval.set_column_value('ATTRIBUTE2', px_attribute2);
234: fnd_flex_descval.set_column_value('ATTRIBUTE3', px_attribute3);
235: fnd_flex_descval.set_column_value('ATTRIBUTE4', px_attribute4);
236: fnd_flex_descval.set_column_value('ATTRIBUTE5', px_attribute5);
237: fnd_flex_descval.set_column_value('ATTRIBUTE6', px_attribute6);
238: fnd_flex_descval.set_column_value('ATTRIBUTE7', px_attribute7);

Line 235: fnd_flex_descval.set_column_value('ATTRIBUTE4', px_attribute4);

231: fnd_flex_descval.set_context_value(p_attribute_category);
232: fnd_flex_descval.set_column_value('ATTRIBUTE1', px_attribute1);
233: fnd_flex_descval.set_column_value('ATTRIBUTE2', px_attribute2);
234: fnd_flex_descval.set_column_value('ATTRIBUTE3', px_attribute3);
235: fnd_flex_descval.set_column_value('ATTRIBUTE4', px_attribute4);
236: fnd_flex_descval.set_column_value('ATTRIBUTE5', px_attribute5);
237: fnd_flex_descval.set_column_value('ATTRIBUTE6', px_attribute6);
238: fnd_flex_descval.set_column_value('ATTRIBUTE7', px_attribute7);
239: fnd_flex_descval.set_column_value('ATTRIBUTE8', px_attribute8);

Line 236: fnd_flex_descval.set_column_value('ATTRIBUTE5', px_attribute5);

232: fnd_flex_descval.set_column_value('ATTRIBUTE1', px_attribute1);
233: fnd_flex_descval.set_column_value('ATTRIBUTE2', px_attribute2);
234: fnd_flex_descval.set_column_value('ATTRIBUTE3', px_attribute3);
235: fnd_flex_descval.set_column_value('ATTRIBUTE4', px_attribute4);
236: fnd_flex_descval.set_column_value('ATTRIBUTE5', px_attribute5);
237: fnd_flex_descval.set_column_value('ATTRIBUTE6', px_attribute6);
238: fnd_flex_descval.set_column_value('ATTRIBUTE7', px_attribute7);
239: fnd_flex_descval.set_column_value('ATTRIBUTE8', px_attribute8);
240: fnd_flex_descval.set_column_value('ATTRIBUTE9', px_attribute9);

Line 237: fnd_flex_descval.set_column_value('ATTRIBUTE6', px_attribute6);

233: fnd_flex_descval.set_column_value('ATTRIBUTE2', px_attribute2);
234: fnd_flex_descval.set_column_value('ATTRIBUTE3', px_attribute3);
235: fnd_flex_descval.set_column_value('ATTRIBUTE4', px_attribute4);
236: fnd_flex_descval.set_column_value('ATTRIBUTE5', px_attribute5);
237: fnd_flex_descval.set_column_value('ATTRIBUTE6', px_attribute6);
238: fnd_flex_descval.set_column_value('ATTRIBUTE7', px_attribute7);
239: fnd_flex_descval.set_column_value('ATTRIBUTE8', px_attribute8);
240: fnd_flex_descval.set_column_value('ATTRIBUTE9', px_attribute9);
241: fnd_flex_descval.set_column_value('ATTRIBUTE10', px_attribute10);

Line 238: fnd_flex_descval.set_column_value('ATTRIBUTE7', px_attribute7);

234: fnd_flex_descval.set_column_value('ATTRIBUTE3', px_attribute3);
235: fnd_flex_descval.set_column_value('ATTRIBUTE4', px_attribute4);
236: fnd_flex_descval.set_column_value('ATTRIBUTE5', px_attribute5);
237: fnd_flex_descval.set_column_value('ATTRIBUTE6', px_attribute6);
238: fnd_flex_descval.set_column_value('ATTRIBUTE7', px_attribute7);
239: fnd_flex_descval.set_column_value('ATTRIBUTE8', px_attribute8);
240: fnd_flex_descval.set_column_value('ATTRIBUTE9', px_attribute9);
241: fnd_flex_descval.set_column_value('ATTRIBUTE10', px_attribute10);
242: fnd_flex_descval.set_column_value('ATTRIBUTE11', px_attribute11);

Line 239: fnd_flex_descval.set_column_value('ATTRIBUTE8', px_attribute8);

235: fnd_flex_descval.set_column_value('ATTRIBUTE4', px_attribute4);
236: fnd_flex_descval.set_column_value('ATTRIBUTE5', px_attribute5);
237: fnd_flex_descval.set_column_value('ATTRIBUTE6', px_attribute6);
238: fnd_flex_descval.set_column_value('ATTRIBUTE7', px_attribute7);
239: fnd_flex_descval.set_column_value('ATTRIBUTE8', px_attribute8);
240: fnd_flex_descval.set_column_value('ATTRIBUTE9', px_attribute9);
241: fnd_flex_descval.set_column_value('ATTRIBUTE10', px_attribute10);
242: fnd_flex_descval.set_column_value('ATTRIBUTE11', px_attribute11);
243: fnd_flex_descval.set_column_value('ATTRIBUTE12', px_attribute12);

Line 240: fnd_flex_descval.set_column_value('ATTRIBUTE9', px_attribute9);

236: fnd_flex_descval.set_column_value('ATTRIBUTE5', px_attribute5);
237: fnd_flex_descval.set_column_value('ATTRIBUTE6', px_attribute6);
238: fnd_flex_descval.set_column_value('ATTRIBUTE7', px_attribute7);
239: fnd_flex_descval.set_column_value('ATTRIBUTE8', px_attribute8);
240: fnd_flex_descval.set_column_value('ATTRIBUTE9', px_attribute9);
241: fnd_flex_descval.set_column_value('ATTRIBUTE10', px_attribute10);
242: fnd_flex_descval.set_column_value('ATTRIBUTE11', px_attribute11);
243: fnd_flex_descval.set_column_value('ATTRIBUTE12', px_attribute12);
244: fnd_flex_descval.set_column_value('ATTRIBUTE13', px_attribute13);

Line 241: fnd_flex_descval.set_column_value('ATTRIBUTE10', px_attribute10);

237: fnd_flex_descval.set_column_value('ATTRIBUTE6', px_attribute6);
238: fnd_flex_descval.set_column_value('ATTRIBUTE7', px_attribute7);
239: fnd_flex_descval.set_column_value('ATTRIBUTE8', px_attribute8);
240: fnd_flex_descval.set_column_value('ATTRIBUTE9', px_attribute9);
241: fnd_flex_descval.set_column_value('ATTRIBUTE10', px_attribute10);
242: fnd_flex_descval.set_column_value('ATTRIBUTE11', px_attribute11);
243: fnd_flex_descval.set_column_value('ATTRIBUTE12', px_attribute12);
244: fnd_flex_descval.set_column_value('ATTRIBUTE13', px_attribute13);
245: fnd_flex_descval.set_column_value('ATTRIBUTE14', px_attribute14);

Line 242: fnd_flex_descval.set_column_value('ATTRIBUTE11', px_attribute11);

238: fnd_flex_descval.set_column_value('ATTRIBUTE7', px_attribute7);
239: fnd_flex_descval.set_column_value('ATTRIBUTE8', px_attribute8);
240: fnd_flex_descval.set_column_value('ATTRIBUTE9', px_attribute9);
241: fnd_flex_descval.set_column_value('ATTRIBUTE10', px_attribute10);
242: fnd_flex_descval.set_column_value('ATTRIBUTE11', px_attribute11);
243: fnd_flex_descval.set_column_value('ATTRIBUTE12', px_attribute12);
244: fnd_flex_descval.set_column_value('ATTRIBUTE13', px_attribute13);
245: fnd_flex_descval.set_column_value('ATTRIBUTE14', px_attribute14);
246: fnd_flex_descval.set_column_value('ATTRIBUTE15', px_attribute15);

Line 243: fnd_flex_descval.set_column_value('ATTRIBUTE12', px_attribute12);

239: fnd_flex_descval.set_column_value('ATTRIBUTE8', px_attribute8);
240: fnd_flex_descval.set_column_value('ATTRIBUTE9', px_attribute9);
241: fnd_flex_descval.set_column_value('ATTRIBUTE10', px_attribute10);
242: fnd_flex_descval.set_column_value('ATTRIBUTE11', px_attribute11);
243: fnd_flex_descval.set_column_value('ATTRIBUTE12', px_attribute12);
244: fnd_flex_descval.set_column_value('ATTRIBUTE13', px_attribute13);
245: fnd_flex_descval.set_column_value('ATTRIBUTE14', px_attribute14);
246: fnd_flex_descval.set_column_value('ATTRIBUTE15', px_attribute15);
247: px_attribute1 := null;

Line 244: fnd_flex_descval.set_column_value('ATTRIBUTE13', px_attribute13);

240: fnd_flex_descval.set_column_value('ATTRIBUTE9', px_attribute9);
241: fnd_flex_descval.set_column_value('ATTRIBUTE10', px_attribute10);
242: fnd_flex_descval.set_column_value('ATTRIBUTE11', px_attribute11);
243: fnd_flex_descval.set_column_value('ATTRIBUTE12', px_attribute12);
244: fnd_flex_descval.set_column_value('ATTRIBUTE13', px_attribute13);
245: fnd_flex_descval.set_column_value('ATTRIBUTE14', px_attribute14);
246: fnd_flex_descval.set_column_value('ATTRIBUTE15', px_attribute15);
247: px_attribute1 := null;
248: px_attribute2 := null;

Line 245: fnd_flex_descval.set_column_value('ATTRIBUTE14', px_attribute14);

241: fnd_flex_descval.set_column_value('ATTRIBUTE10', px_attribute10);
242: fnd_flex_descval.set_column_value('ATTRIBUTE11', px_attribute11);
243: fnd_flex_descval.set_column_value('ATTRIBUTE12', px_attribute12);
244: fnd_flex_descval.set_column_value('ATTRIBUTE13', px_attribute13);
245: fnd_flex_descval.set_column_value('ATTRIBUTE14', px_attribute14);
246: fnd_flex_descval.set_column_value('ATTRIBUTE15', px_attribute15);
247: px_attribute1 := null;
248: px_attribute2 := null;
249: px_attribute3 := null;

Line 246: fnd_flex_descval.set_column_value('ATTRIBUTE15', px_attribute15);

242: fnd_flex_descval.set_column_value('ATTRIBUTE11', px_attribute11);
243: fnd_flex_descval.set_column_value('ATTRIBUTE12', px_attribute12);
244: fnd_flex_descval.set_column_value('ATTRIBUTE13', px_attribute13);
245: fnd_flex_descval.set_column_value('ATTRIBUTE14', px_attribute14);
246: fnd_flex_descval.set_column_value('ATTRIBUTE15', px_attribute15);
247: px_attribute1 := null;
248: px_attribute2 := null;
249: px_attribute3 := null;
250: px_attribute4 := null;

Line 263: IF (fnd_flex_descval.validate_desccols( 'PA',p_desc_flex_name,'D', sysdate)) then

259: px_attribute13 := null;
260: px_attribute14 := null;
261: px_attribute15 := null;
262: -- VALIDATE
263: IF (fnd_flex_descval.validate_desccols( 'PA',p_desc_flex_name,'D', sysdate)) then
264: x_msg_data := 'VALID: ' || fnd_flex_descval.concatenated_ids;
265: x_return_status := 'S';
266: FOR j IN 1 ..15 LOOP --Bug 7240954
267: l_segment_column_name(j) := ltrim(rtrim(FND_FLEX_DESCVAL.segment_column_name(j)));

Line 264: x_msg_data := 'VALID: ' || fnd_flex_descval.concatenated_ids;

260: px_attribute14 := null;
261: px_attribute15 := null;
262: -- VALIDATE
263: IF (fnd_flex_descval.validate_desccols( 'PA',p_desc_flex_name,'D', sysdate)) then
264: x_msg_data := 'VALID: ' || fnd_flex_descval.concatenated_ids;
265: x_return_status := 'S';
266: FOR j IN 1 ..15 LOOP --Bug 7240954
267: l_segment_column_name(j) := ltrim(rtrim(FND_FLEX_DESCVAL.segment_column_name(j)));
268: l_attribute(j) := ltrim(rtrim(FND_FLEX_DESCVAL.segment_id(j)));

Line 267: l_segment_column_name(j) := ltrim(rtrim(FND_FLEX_DESCVAL.segment_column_name(j)));

263: IF (fnd_flex_descval.validate_desccols( 'PA',p_desc_flex_name,'D', sysdate)) then
264: x_msg_data := 'VALID: ' || fnd_flex_descval.concatenated_ids;
265: x_return_status := 'S';
266: FOR j IN 1 ..15 LOOP --Bug 7240954
267: l_segment_column_name(j) := ltrim(rtrim(FND_FLEX_DESCVAL.segment_column_name(j)));
268: l_attribute(j) := ltrim(rtrim(FND_FLEX_DESCVAL.segment_id(j)));
269:
270: IF l_segment_column_name(j) = 'ATTRIBUTE1' Then
271: px_attribute1 := l_attribute(j);

Line 268: l_attribute(j) := ltrim(rtrim(FND_FLEX_DESCVAL.segment_id(j)));

264: x_msg_data := 'VALID: ' || fnd_flex_descval.concatenated_ids;
265: x_return_status := 'S';
266: FOR j IN 1 ..15 LOOP --Bug 7240954
267: l_segment_column_name(j) := ltrim(rtrim(FND_FLEX_DESCVAL.segment_column_name(j)));
268: l_attribute(j) := ltrim(rtrim(FND_FLEX_DESCVAL.segment_id(j)));
269:
270: IF l_segment_column_name(j) = 'ATTRIBUTE1' Then
271: px_attribute1 := l_attribute(j);
272: ELSIF l_segment_column_name(j) = 'ATTRIBUTE2' Then

Line 303: x_msg_data := 'INVALID: ' || fnd_flex_descval.error_message;

299: px_attribute15 := l_attribute(j);
300: END IF;
301: END LOOP;
302: ELSE
303: x_msg_data := 'INVALID: ' || fnd_flex_descval.error_message;
304: x_return_status := 'E';
305: END IF;
306: EXCEPTION
307: WHEN OTHERS THEN