DBA Data[Home] [Help]

APPS.QP_LIST_HEADERS_PVT dependencies on QP_PRICE_LIST_LINE_UTIL

Line 403: QP_Price_List_Line_Util.Convert_Miss_To_Null (l_old_PRICE_LIST_LINE_rec);

399:
400: -- Set missing old record elements to NULL.
401:
402: l_old_PRICE_LIST_LINE_rec :=
403: QP_Price_List_Line_Util.Convert_Miss_To_Null (l_old_PRICE_LIST_LINE_rec);
404:
405: ELSIF l_PRICE_LIST_LINE_rec.operation = QP_GLOBALS.G_OPR_UPDATE
406: OR l_PRICE_LIST_LINE_rec.operation = QP_GLOBALS.G_OPR_DELETE
407: THEN

Line 416: l_old_PRICE_LIST_LINE_rec := QP_Price_List_Line_Util.Query_Row

412:
413: IF l_old_PRICE_LIST_LINE_rec.list_line_id = FND_API.G_MISS_NUM
414: THEN
415:
416: l_old_PRICE_LIST_LINE_rec := QP_Price_List_Line_Util.Query_Row
417: ( p_list_line_id => l_PRICE_LIST_LINE_rec.list_line_id
418: );
419:
420: ELSE

Line 425: QP_Price_List_Line_Util.Convert_Miss_To_Null (l_old_PRICE_LIST_LINE_rec);

421:
422: -- Set missing old record elements to NULL.
423:
424: l_old_PRICE_LIST_LINE_rec :=
425: QP_Price_List_Line_Util.Convert_Miss_To_Null (l_old_PRICE_LIST_LINE_rec);
426:
427: END IF;
428:
429: -- Complete new record from old

Line 431: l_PRICE_LIST_LINE_rec := QP_Price_List_Line_Util.Complete_Record

427: END IF;
428:
429: -- Complete new record from old
430:
431: l_PRICE_LIST_LINE_rec := QP_Price_List_Line_Util.Complete_Record
432: ( p_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
433: , p_old_PRICE_LIST_LINE_rec => l_old_PRICE_LIST_LINE_rec
434: );
435:

Line 497: QP_Price_List_Line_Util.Clear_Dependent_Attr

493: -- Clear dependent attributes.
494:
495: IF l_control_rec.change_attributes THEN
496: l_p_PRICE_LIST_LINE_rec := l_PRICE_LIST_LINE_rec;
497: QP_Price_List_Line_Util.Clear_Dependent_Attr
498: ( p_PRICE_LIST_LINE_rec => l_p_PRICE_LIST_LINE_rec
499: , p_old_PRICE_LIST_LINE_rec => l_old_PRICE_LIST_LINE_rec
500: , x_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
501: );

Line 553: QP_Price_List_Line_Util.Apply_Attribute_Changes

549: IF l_control_rec.default_attributes
550: OR l_control_rec.change_attributes
551: THEN
552: l_p_PRICE_LIST_LINE_rec := l_PRICE_LIST_LINE_rec;
553: QP_Price_List_Line_Util.Apply_Attribute_Changes
554: ( p_PRICE_LIST_LINE_rec => l_p_PRICE_LIST_LINE_rec
555: , p_old_PRICE_LIST_LINE_rec => l_old_PRICE_LIST_LINE_rec
556: , x_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
557: );

Line 596: QP_Price_List_Line_Util.Delete_Row

592: IF l_control_rec.write_to_db THEN
593:
594: IF l_PRICE_LIST_LINE_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
595:
596: QP_Price_List_Line_Util.Delete_Row
597: ( p_list_line_id => l_PRICE_LIST_LINE_rec.list_line_id
598: );
599:
600: ELSE

Line 610: QP_Price_List_Line_Util.Update_Row (l_PRICE_LIST_LINE_rec);

606: l_PRICE_LIST_LINE_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
607:
608: IF l_PRICE_LIST_LINE_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
609:
610: QP_Price_List_Line_Util.Update_Row (l_PRICE_LIST_LINE_rec);
611:
612: ELSIF l_PRICE_LIST_LINE_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
613:
614: l_PRICE_LIST_LINE_rec.creation_date := SYSDATE;

Line 617: QP_Price_List_Line_Util.Insert_Row (l_PRICE_LIST_LINE_rec);

613:
614: l_PRICE_LIST_LINE_rec.creation_date := SYSDATE;
615: l_PRICE_LIST_LINE_rec.created_by := FND_GLOBAL.USER_ID;
616:
617: QP_Price_List_Line_Util.Insert_Row (l_PRICE_LIST_LINE_rec);
618:
619: IF l_PRICE_LIST_LINE_rec.operation = QP_GLOBALS.G_OPR_CREATE
620: AND l_PRICE_LIST_LINE_rec.PRICE_BREAK_HEADER_index IS NOT NULL
621: AND l_PRICE_LIST_LINE_rec.PRICE_BREAK_HEADER_index <> FND_API.G_MISS_NUM

Line 2452: QP_Price_List_Line_Util.Lock_Row

2448: FOR I IN 1..p_PRICE_LIST_LINE_tbl.COUNT LOOP
2449:
2450: IF p_PRICE_LIST_LINE_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN
2451:
2452: QP_Price_List_Line_Util.Lock_Row
2453: ( p_PRICE_LIST_LINE_rec => p_PRICE_LIST_LINE_tbl(I)
2454: , x_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
2455: , x_return_status => l_return_status
2456: );

Line 2652: l_PRICE_LIST_LINE_tbl := QP_Price_List_Line_Util.Query_Rows

2648: );
2649:
2650: -- Get PRICE_LIST_LINE ( parent = PRICE_LIST )
2651:
2652: l_PRICE_LIST_LINE_tbl := QP_Price_List_Line_Util.Query_Rows
2653: ( p_list_header_id => l_PRICE_LIST_rec.list_header_id
2654: );
2655:
2656: