APPS.QP_PRICE_LIST_PVT dependencies on OE_PRICE_LIST_LINE_UTIL

Line 329: OE_Price_List_Line_Util.Convert_Miss_To_Null (l_old_PRICE_LIST_LINE_rec);

325:
326: -- Set missing old record elements to NULL.
327:
328: l_old_PRICE_LIST_LINE_rec :=
329: OE_Price_List_Line_Util.Convert_Miss_To_Null (l_old_PRICE_LIST_LINE_rec);
330:
331: ELSIF l_PRICE_LIST_LINE_rec.operation = OE_GLOBALS.G_OPR_UPDATE
332: OR l_PRICE_LIST_LINE_rec.operation = OE_GLOBALS.G_OPR_DELETE
333: THEN

Line 342: l_old_PRICE_LIST_LINE_rec := OE_Price_List_Line_Util.Query_Row

338:
339: IF l_old_PRICE_LIST_LINE_rec.price_list_line_id = FND_API.G_MISS_NUM
340: THEN
341:
342: l_old_PRICE_LIST_LINE_rec := OE_Price_List_Line_Util.Query_Row
343: ( p_price_list_line_id => l_PRICE_LIST_LINE_rec.price_list_line_id
344: , p_price_list_id => l_PRICE_LIST_LINE_rec.price_list_id
345: );
346:

Line 352: OE_Price_List_Line_Util.Convert_Miss_To_Null (l_old_PRICE_LIST_LINE_rec);

348:
349: -- Set missing old record elements to NULL.
350:
351: l_old_PRICE_LIST_LINE_rec :=
352: OE_Price_List_Line_Util.Convert_Miss_To_Null (l_old_PRICE_LIST_LINE_rec);
353:
354: END IF;
355:
356: -- Complete new record from old

Line 358: l_PRICE_LIST_LINE_rec := OE_Price_List_Line_Util.Complete_Record

354: END IF;
355:
356: -- Complete new record from old
357:
358: l_PRICE_LIST_LINE_rec := OE_Price_List_Line_Util.Complete_Record
359: ( p_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
360: , p_old_PRICE_LIST_LINE_rec => l_old_PRICE_LIST_LINE_rec
361: );
362:

Line 393: OE_Price_List_Line_Util.Clear_Dependent_Attr

389: -- Clear dependent attributes.
390:
391: IF l_control_rec.change_attributes THEN
392: l_p_PRICE_LIST_LINE_rec := l_PRICE_LIST_LINE_rec;
393: OE_Price_List_Line_Util.Clear_Dependent_Attr
394: ( p_PRICE_LIST_LINE_rec => l_p_PRICE_LIST_LINE_rec
395: , p_old_PRICE_LIST_LINE_rec => l_old_PRICE_LIST_LINE_rec
396: , x_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
397: );

Line 420: OE_Price_List_Line_Util.Apply_Attribute_Changes

416: IF l_control_rec.default_attributes
417: OR l_control_rec.change_attributes
418: THEN
419: l_p_PRICE_LIST_LINE_rec := l_PRICE_LIST_LINE_rec;
420: OE_Price_List_Line_Util.Apply_Attribute_Changes
421: ( p_PRICE_LIST_LINE_rec => l_p_PRICE_LIST_LINE_rec
422: , p_old_PRICE_LIST_LINE_rec => l_old_PRICE_LIST_LINE_rec
423: , x_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
424: );

Line 463: OE_Price_List_Line_Util.Delete_Row

459: IF l_control_rec.write_to_db THEN
460:
461: IF l_PRICE_LIST_LINE_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
462:
463: OE_Price_List_Line_Util.Delete_Row
464: ( p_price_list_line_id => l_PRICE_LIST_LINE_rec.price_list_line_id
465: );
466:
467: ELSE

Line 477: OE_Price_List_Line_Util.Update_Row (l_PRICE_LIST_LINE_rec);

473: l_PRICE_LIST_LINE_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
474:
475: IF l_PRICE_LIST_LINE_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
476:
477: OE_Price_List_Line_Util.Update_Row (l_PRICE_LIST_LINE_rec);
478:
479: ELSIF l_PRICE_LIST_LINE_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
480:
481: l_PRICE_LIST_LINE_rec.creation_date := SYSDATE;

Line 484: OE_Price_List_Line_Util.Insert_Row (l_PRICE_LIST_LINE_rec);

480:
481: l_PRICE_LIST_LINE_rec.creation_date := SYSDATE;
482: l_PRICE_LIST_LINE_rec.created_by := FND_GLOBAL.USER_ID;
483:
484: OE_Price_List_Line_Util.Insert_Row (l_PRICE_LIST_LINE_rec);
485:
486: END IF;
487:
488: END IF;

Line 891: OE_Price_List_Line_Util.Lock_Row

887: FOR I IN 1..p_PRICE_LIST_LINE_tbl.COUNT LOOP
888:
889: IF p_PRICE_LIST_LINE_tbl(I).operation = OE_GLOBALS.G_OPR_LOCK THEN
890:
891: OE_Price_List_Line_Util.Lock_Row
892: ( p_PRICE_LIST_LINE_rec => p_PRICE_LIST_LINE_tbl(I)
893: , x_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
894: , x_return_status => l_return_status
895: );

Line 1039: l_PRICE_LIST_LINE_tbl := OE_Price_List_Line_Util.Query_Rows

1035: );
1036:
1037: -- Get PRICE_LIST_LINE ( parent = PRICE_LIST )
1038:
1039: l_PRICE_LIST_LINE_tbl := OE_Price_List_Line_Util.Query_Rows
1040: ( p_price_list_id => p_price_list_id);
1041:
1042: -- l_PRICE_LIST_LINE_rec := OE_Price_List_Line_Util.Query_Row
1043: -- ( p_price_list_line_id => l_PRICE_LIST_LINE_rec.price_list_line_id);

Line 1042: -- l_PRICE_LIST_LINE_rec := OE_Price_List_Line_Util.Query_Row

1038:
1039: l_PRICE_LIST_LINE_tbl := OE_Price_List_Line_Util.Query_Rows
1040: ( p_price_list_id => p_price_list_id);
1041:
1042: -- l_PRICE_LIST_LINE_rec := OE_Price_List_Line_Util.Query_Row
1043: -- ( p_price_list_line_id => l_PRICE_LIST_LINE_rec.price_list_line_id);
1044:
1045: -- Load out parameters
1046: