DBA Data[Home] [Help]

APPS.OE_ORDER_ADJ_PVT dependencies on OE_LINE_PRICE_AATTR_UTIL

Line 3422: Oe_Line_Price_Aattr_util.Convert_Miss_To_Null (l_old_Line_Adj_Att_rec);

3418: -- Set missing old record elements to NULL.
3419:
3420: adj_debug('Entering OE_Line_Adj_Att_Util.Convert_Miss_To_Null', 1);
3421: -- l_old_Line_Adj_Att_rec :=
3422: Oe_Line_Price_Aattr_util.Convert_Miss_To_Null (l_old_Line_Adj_Att_rec);
3423:
3424: ELSIF l_Line_Adj_Att_rec.operation = OE_GLOBALS.G_OPR_UPDATE
3425: OR l_Line_Adj_Att_rec.operation = OE_GLOBALS.G_OPR_DELETE
3426: THEN

Line 3436: Oe_Line_Price_Aattr_util.Query_Row

3432: IF l_old_Line_Adj_Att_rec.Price_adj_attrib_id = FND_API.G_MISS_NUM
3433: THEN
3434:
3435:
3436: Oe_Line_Price_Aattr_util.Query_Row
3437: ( p_Price_Adj_Attrib_id => l_Line_Adj_Att_rec.Price_adj_attrib_id
3438: , x_Line_Adj_Att_rec => l_old_Line_Adj_Att_rec
3439: );
3440:

Line 3446: Oe_Line_Price_Aattr_util.Convert_Miss_To_Null (l_old_Line_Adj_Att_rec);

3442:
3443: -- Set missing old record elements to NULL.
3444:
3445: -- l_old_Line_Adj_Att_rec :=
3446: Oe_Line_Price_Aattr_util.Convert_Miss_To_Null (l_old_Line_Adj_Att_rec);
3447:
3448: END IF;
3449:
3450: -- Complete new record from old

Line 3453: Oe_Line_Price_Aattr_util.Complete_Record

3449:
3450: -- Complete new record from old
3451:
3452: -- l_Line_Adj_Att_rec :=
3453: Oe_Line_Price_Aattr_util.Complete_Record
3454: ( p_x_Line_Adj_Att_rec => l_Line_Adj_Att_rec
3455: , p_old_Line_Adj_Att_rec => l_old_Line_Adj_Att_rec
3456: );
3457:

Line 3503: Oe_Line_Price_Aattr_util.Apply_Attribute_Changes

3499: THEN
3500:
3501: -- This will also log request/s to check duplicity of
3502: -- price adjustment entered
3503: Oe_Line_Price_Aattr_util.Apply_Attribute_Changes
3504: ( p_x_Line_Adj_Att_rec => l_Line_Adj_Att_rec
3505: , p_old_Line_Adj_Att_rec => l_old_Line_Adj_Att_rec
3506: --, x_Line_Adj_Att_rec => l_Line_Adj_Att_rec
3507: );

Line 3522: Oe_Line_Price_Aattr_util.Delete_Row

3518: IF l_control_rec.write_to_db THEN
3519:
3520: IF l_Line_Adj_Att_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
3521:
3522: Oe_Line_Price_Aattr_util.Delete_Row
3523: ( p_Price_Adj_Attrib_id => l_Line_Adj_Att_rec.Price_adj_attrib_id
3524: );
3525:
3526: ELSE

Line 3536: Oe_Line_Price_Aattr_util.Update_Row (l_Line_Adj_Att_rec);

3532: l_Line_Adj_Att_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
3533:
3534: IF l_Line_Adj_Att_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3535:
3536: Oe_Line_Price_Aattr_util.Update_Row (l_Line_Adj_Att_rec);
3537:
3538: ELSIF l_Line_Adj_Att_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
3539:
3540: l_Line_Adj_Att_rec.creation_date := SYSDATE;

Line 3543: Oe_Line_Price_Aattr_util.Insert_Row (l_Line_Adj_Att_rec);

3539:
3540: l_Line_Adj_Att_rec.creation_date := SYSDATE;
3541: l_Line_Adj_Att_rec.created_by := FND_GLOBAL.USER_ID;
3542:
3543: Oe_Line_Price_Aattr_util.Insert_Row (l_Line_Adj_Att_rec);
3544:
3545: END IF;
3546:
3547: END IF;

Line 7075: Oe_Line_Price_Aattr_util.Query_Rows(

7071:
7072: G_STMT_NO := 'Query_Adj_Attribs#15';
7073:
7074:
7075: Oe_Line_Price_Aattr_util.Query_Rows(
7076: p_price_adjustment_id => p_price_adjustment_id
7077: , x_Line_Adj_Att_Tbl=>L_Line_Adj_Att_Tbl);
7078:
7079: -- Append to the tbl with Delete flag set.