DBA Data[Home] [Help]

APPS.QP_QP_FORM_FORMULA dependencies on QP_FORMULA_UTIL

Line 163: l_FORMULA_val_rec := QP_Formula_Util.Get_Values

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:

Line 319: IF p_attr_id = QP_Formula_Util.G_DESCRIPTION THEN

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

Line 321: ELSIF p_attr_id = QP_Formula_Util.G_END_DATE_ACTIVE 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

Line 323: ELSIF p_attr_id = QP_Formula_Util.G_FORMULA 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

Line 325: ELSIF p_attr_id = QP_Formula_Util.G_NAME 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

Line 327: ELSIF p_attr_id = QP_Formula_Util.G_PRICE_FORMULA 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

Line 329: ELSIF p_attr_id = QP_Formula_Util.G_START_DATE_ACTIVE THEN

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

Line 331: ELSIF p_attr_id = QP_Formula_Util.G_ATTRIBUTE1

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

Line 332: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE10

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

Line 333: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE11

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

Line 334: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE12

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

Line 335: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE13

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

Line 336: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE14

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

Line 337: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE15

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

Line 338: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE2

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

Line 339: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE3

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

Line 340: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE4

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

Line 341: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE5

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

Line 342: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE6

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

Line 343: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE7

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

Line 344: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE8

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:

Line 345: OR p_attr_id = QP_Formula_Util.G_ATTRIBUTE9

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;

Line 346: OR p_attr_id = QP_Formula_Util.G_CONTEXT

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;

Line 442: l_FORMULA_val_rec := QP_Formula_Util.Get_Values

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:

Line 1316: g_FORMULA_rec := QP_Formula_Util.Query_Row

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;