DBA Data[Home] [Help]

APPS.QP_PRICE_FORMULA_PVT dependencies on QP_FORMULA_LINES_UTIL

Line 326: QP_Formula_Lines_Util.Convert_Miss_To_Null (l_old_FORMULA_LINES_rec);

322:
323: -- Set missing old record elements to NULL.
324:
325: l_old_FORMULA_LINES_rec :=
326: QP_Formula_Lines_Util.Convert_Miss_To_Null (l_old_FORMULA_LINES_rec);
327:
328: ELSIF l_FORMULA_LINES_rec.operation = QP_GLOBALS.G_OPR_UPDATE
329: OR l_FORMULA_LINES_rec.operation = QP_GLOBALS.G_OPR_DELETE
330: THEN

Line 339: l_old_FORMULA_LINES_rec := QP_Formula_Lines_Util.Query_Row

335:
336: IF l_old_FORMULA_LINES_rec.price_formula_line_id = FND_API.G_MISS_NUM
337: THEN
338:
339: l_old_FORMULA_LINES_rec := QP_Formula_Lines_Util.Query_Row
340: ( p_price_formula_line_id => l_FORMULA_LINES_rec.price_formula_line_id
341: );
342:
343: ELSE

Line 348: QP_Formula_Lines_Util.Convert_Miss_To_Null (l_old_FORMULA_LINES_rec);

344:
345: -- Set missing old record elements to NULL.
346:
347: l_old_FORMULA_LINES_rec :=
348: QP_Formula_Lines_Util.Convert_Miss_To_Null (l_old_FORMULA_LINES_rec);
349:
350: END IF;
351:
352: -- Complete new record from old

Line 354: l_FORMULA_LINES_rec := QP_Formula_Lines_Util.Complete_Record

350: END IF;
351:
352: -- Complete new record from old
353:
354: l_FORMULA_LINES_rec := QP_Formula_Lines_Util.Complete_Record
355: ( p_FORMULA_LINES_rec => l_FORMULA_LINES_rec
356: , p_old_FORMULA_LINES_rec => l_old_FORMULA_LINES_rec
357: );
358:

Line 392: QP_Formula_Lines_Util.Clear_Dependent_Attr

388: IF l_control_rec.change_attributes THEN
389:
390: l_p_FORMULA_LINES_rec := l_FORMULA_LINES_rec; --[prarasto]
391:
392: QP_Formula_Lines_Util.Clear_Dependent_Attr
393: ( p_FORMULA_LINES_rec => l_p_FORMULA_LINES_rec
394: , p_old_FORMULA_LINES_rec => l_old_FORMULA_LINES_rec
395: , x_FORMULA_LINES_rec => l_FORMULA_LINES_rec
396: );

Line 423: QP_Formula_Lines_Util.Apply_Attribute_Changes

419: THEN
420:
421: l_p_FORMULA_LINES_rec := l_FORMULA_LINES_rec; --[prarasto]
422:
423: QP_Formula_Lines_Util.Apply_Attribute_Changes
424: ( p_FORMULA_LINES_rec => l_p_FORMULA_LINES_rec
425: , p_old_FORMULA_LINES_rec => l_old_FORMULA_LINES_rec
426: , x_FORMULA_LINES_rec => l_FORMULA_LINES_rec
427: );

Line 466: QP_Formula_Lines_Util.Delete_Row

462: IF l_control_rec.write_to_db THEN
463:
464: IF l_FORMULA_LINES_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
465:
466: QP_Formula_Lines_Util.Delete_Row
467: ( p_price_formula_line_id => l_FORMULA_LINES_rec.price_formula_line_id
468: );
469:
470: ELSE

Line 480: QP_Formula_Lines_Util.Update_Row (l_FORMULA_LINES_rec);

476: l_FORMULA_LINES_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
477:
478: IF l_FORMULA_LINES_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
479:
480: QP_Formula_Lines_Util.Update_Row (l_FORMULA_LINES_rec);
481:
482: ELSIF l_FORMULA_LINES_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
483:
484: l_FORMULA_LINES_rec.creation_date := SYSDATE;

Line 487: QP_Formula_Lines_Util.Insert_Row (l_FORMULA_LINES_rec);

483:
484: l_FORMULA_LINES_rec.creation_date := SYSDATE;
485: l_FORMULA_LINES_rec.created_by := FND_GLOBAL.USER_ID;
486:
487: QP_Formula_Lines_Util.Insert_Row (l_FORMULA_LINES_rec);
488:
489: END IF;
490:
491: END IF;

Line 918: QP_Formula_Lines_Util.Lock_Row

914: FOR I IN 1..p_FORMULA_LINES_tbl.COUNT LOOP
915:
916: IF p_FORMULA_LINES_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN
917:
918: QP_Formula_Lines_Util.Lock_Row
919: ( p_FORMULA_LINES_rec => p_FORMULA_LINES_tbl(I)
920: , x_FORMULA_LINES_rec => l_FORMULA_LINES_rec
921: , x_return_status => l_return_status
922: );

Line 1066: l_FORMULA_LINES_tbl := QP_Formula_Lines_Util.Query_Rows

1062: );
1063:
1064: -- Get FORMULA_LINES ( parent = FORMULA )
1065:
1066: l_FORMULA_LINES_tbl := QP_Formula_Lines_Util.Query_Rows
1067: ( p_price_formula_id => l_FORMULA_rec.price_formula_id
1068: );
1069:
1070: