159: x_start_date_active := l_x_FORMULA_rec.start_date_active;
160:
161: -- Load display out parameters if any
162:
163: l_FORMULA_val_rec := QP_Formula_Util.Get_Values
164: ( p_FORMULA_rec => l_x_FORMULA_rec
165: );
166: x_price_formula := l_FORMULA_val_rec.price_formula;
167:
315: );
316:
317: l_old_FORMULA_rec := l_FORMULA_rec;
318:
319: IF p_attr_id = QP_Formula_Util.G_DESCRIPTION THEN
320: l_FORMULA_rec.description := p_attr_value;
321: ELSIF p_attr_id = QP_Formula_Util.G_END_DATE_ACTIVE THEN
322: l_FORMULA_rec.end_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
323: ELSIF p_attr_id = QP_Formula_Util.G_FORMULA THEN
317: l_old_FORMULA_rec := l_FORMULA_rec;
318:
319: IF p_attr_id = QP_Formula_Util.G_DESCRIPTION THEN
320: l_FORMULA_rec.description := p_attr_value;
321: ELSIF p_attr_id = QP_Formula_Util.G_END_DATE_ACTIVE THEN
322: l_FORMULA_rec.end_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
323: ELSIF p_attr_id = QP_Formula_Util.G_FORMULA THEN
324: l_FORMULA_rec.formula := p_attr_value;
325: ELSIF p_attr_id = QP_Formula_Util.G_NAME THEN
319: IF p_attr_id = QP_Formula_Util.G_DESCRIPTION THEN
320: l_FORMULA_rec.description := p_attr_value;
321: ELSIF p_attr_id = QP_Formula_Util.G_END_DATE_ACTIVE THEN
322: l_FORMULA_rec.end_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
323: ELSIF p_attr_id = QP_Formula_Util.G_FORMULA THEN
324: l_FORMULA_rec.formula := p_attr_value;
325: ELSIF p_attr_id = QP_Formula_Util.G_NAME THEN
326: l_FORMULA_rec.name := p_attr_value;
327: ELSIF p_attr_id = QP_Formula_Util.G_PRICE_FORMULA THEN
321: ELSIF p_attr_id = QP_Formula_Util.G_END_DATE_ACTIVE THEN
322: l_FORMULA_rec.end_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
323: ELSIF p_attr_id = QP_Formula_Util.G_FORMULA THEN
324: l_FORMULA_rec.formula := p_attr_value;
325: ELSIF p_attr_id = QP_Formula_Util.G_NAME THEN
326: l_FORMULA_rec.name := p_attr_value;
327: ELSIF p_attr_id = QP_Formula_Util.G_PRICE_FORMULA THEN
328: l_FORMULA_rec.price_formula_id := TO_NUMBER(p_attr_value);
329: ELSIF p_attr_id = QP_Formula_Util.G_START_DATE_ACTIVE THEN
323: ELSIF p_attr_id = QP_Formula_Util.G_FORMULA THEN
324: l_FORMULA_rec.formula := p_attr_value;
325: ELSIF p_attr_id = QP_Formula_Util.G_NAME THEN
326: l_FORMULA_rec.name := p_attr_value;
327: ELSIF p_attr_id = QP_Formula_Util.G_PRICE_FORMULA THEN
328: l_FORMULA_rec.price_formula_id := TO_NUMBER(p_attr_value);
329: ELSIF p_attr_id = QP_Formula_Util.G_START_DATE_ACTIVE THEN
330: l_FORMULA_rec.start_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
331: ELSIF p_attr_id = QP_Formula_Util.G_ATTRIBUTE1
325: ELSIF p_attr_id = QP_Formula_Util.G_NAME THEN
326: l_FORMULA_rec.name := p_attr_value;
327: ELSIF p_attr_id = QP_Formula_Util.G_PRICE_FORMULA THEN
328: l_FORMULA_rec.price_formula_id := TO_NUMBER(p_attr_value);
329: ELSIF p_attr_id = QP_Formula_Util.G_START_DATE_ACTIVE THEN
330: l_FORMULA_rec.start_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
331: ELSIF p_attr_id = QP_Formula_Util.G_ATTRIBUTE1
332: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE10
333: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE11
327: ELSIF p_attr_id = QP_Formula_Util.G_PRICE_FORMULA THEN
328: l_FORMULA_rec.price_formula_id := TO_NUMBER(p_attr_value);
329: ELSIF p_attr_id = QP_Formula_Util.G_START_DATE_ACTIVE THEN
330: l_FORMULA_rec.start_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
331: ELSIF p_attr_id = QP_Formula_Util.G_ATTRIBUTE1
332: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE10
333: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE11
334: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE12
335: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE13
328: l_FORMULA_rec.price_formula_id := TO_NUMBER(p_attr_value);
329: ELSIF p_attr_id = QP_Formula_Util.G_START_DATE_ACTIVE THEN
330: l_FORMULA_rec.start_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
331: ELSIF p_attr_id = QP_Formula_Util.G_ATTRIBUTE1
332: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE10
333: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE11
334: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE12
335: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE13
336: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE14
329: ELSIF p_attr_id = QP_Formula_Util.G_START_DATE_ACTIVE THEN
330: l_FORMULA_rec.start_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
331: ELSIF p_attr_id = QP_Formula_Util.G_ATTRIBUTE1
332: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE10
333: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE11
334: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE12
335: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE13
336: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE14
337: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE15
330: l_FORMULA_rec.start_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
331: ELSIF p_attr_id = QP_Formula_Util.G_ATTRIBUTE1
332: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE10
333: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE11
334: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE12
335: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE13
336: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE14
337: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE15
338: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE2
331: ELSIF p_attr_id = QP_Formula_Util.G_ATTRIBUTE1
332: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE10
333: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE11
334: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE12
335: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE13
336: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE14
337: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE15
338: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE2
339: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE3
332: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE10
333: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE11
334: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE12
335: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE13
336: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE14
337: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE15
338: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE2
339: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE3
340: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE4
333: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE11
334: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE12
335: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE13
336: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE14
337: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE15
338: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE2
339: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE3
340: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE4
341: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE5
334: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE12
335: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE13
336: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE14
337: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE15
338: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE2
339: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE3
340: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE4
341: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE5
342: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE6
335: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE13
336: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE14
337: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE15
338: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE2
339: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE3
340: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE4
341: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE5
342: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE6
343: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE7
336: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE14
337: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE15
338: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE2
339: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE3
340: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE4
341: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE5
342: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE6
343: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE7
344: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE8
337: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE15
338: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE2
339: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE3
340: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE4
341: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE5
342: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE6
343: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE7
344: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE8
345: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE9
338: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE2
339: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE3
340: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE4
341: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE5
342: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE6
343: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE7
344: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE8
345: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE9
346: OR p_attr_id = QP_Formula_Util.G_CONTEXT
339: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE3
340: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE4
341: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE5
342: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE6
343: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE7
344: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE8
345: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE9
346: OR p_attr_id = QP_Formula_Util.G_CONTEXT
347: THEN
340: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE4
341: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE5
342: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE6
343: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE7
344: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE8
345: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE9
346: OR p_attr_id = QP_Formula_Util.G_CONTEXT
347: THEN
348:
341: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE5
342: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE6
343: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE7
344: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE8
345: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE9
346: OR p_attr_id = QP_Formula_Util.G_CONTEXT
347: THEN
348:
349: l_FORMULA_rec.attribute1 := p_attribute1;
342: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE6
343: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE7
344: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE8
345: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE9
346: OR p_attr_id = QP_Formula_Util.G_CONTEXT
347: THEN
348:
349: l_FORMULA_rec.attribute1 := p_attribute1;
350: l_FORMULA_rec.attribute10 := p_attribute10;
438: x_price_formula := FND_API.G_MISS_CHAR;
439:
440: -- Load display out parameters if any
441:
442: l_FORMULA_val_rec := QP_Formula_Util.Get_Values
443: ( p_FORMULA_rec => l_x_FORMULA_rec
444: , p_old_FORMULA_rec => l_FORMULA_rec
445: );
446:
1312: THEN
1313:
1314: -- Query row from DB
1315:
1316: g_FORMULA_rec := QP_Formula_Util.Query_Row
1317: ( p_price_formula_id => p_price_formula_id
1318: );
1319:
1320: g_FORMULA_rec.db_flag := FND_API.G_TRUE;