DBA Data[Home] [Help]

APPS.OE_ORDER_ADJ_PVT dependencies on OE_LINE_PRICE_AATTR_UTIL

Line 3505: Oe_Line_Price_Aattr_util.Convert_Miss_To_Null (l_old_Line_Adj_Att_rec);

3501: -- Set missing old record elements to NULL.
3502:
3503: adj_debug('Entering OE_Line_Adj_Att_Util.Convert_Miss_To_Null', 1);
3504: -- l_old_Line_Adj_Att_rec :=
3505: Oe_Line_Price_Aattr_util.Convert_Miss_To_Null (l_old_Line_Adj_Att_rec);
3506:
3507: ELSIF l_Line_Adj_Att_rec.operation = OE_GLOBALS.G_OPR_UPDATE
3508: OR l_Line_Adj_Att_rec.operation = OE_GLOBALS.G_OPR_DELETE
3509: THEN

Line 3519: Oe_Line_Price_Aattr_util.Query_Row

3515: IF l_old_Line_Adj_Att_rec.Price_adj_attrib_id = FND_API.G_MISS_NUM
3516: THEN
3517:
3518:
3519: Oe_Line_Price_Aattr_util.Query_Row
3520: ( p_Price_Adj_Attrib_id => l_Line_Adj_Att_rec.Price_adj_attrib_id
3521: , x_Line_Adj_Att_rec => l_old_Line_Adj_Att_rec
3522: );
3523:

Line 3529: Oe_Line_Price_Aattr_util.Convert_Miss_To_Null (l_old_Line_Adj_Att_rec);

3525:
3526: -- Set missing old record elements to NULL.
3527:
3528: -- l_old_Line_Adj_Att_rec :=
3529: Oe_Line_Price_Aattr_util.Convert_Miss_To_Null (l_old_Line_Adj_Att_rec);
3530:
3531: END IF;
3532:
3533: -- Complete new record from old

Line 3536: Oe_Line_Price_Aattr_util.Complete_Record

3532:
3533: -- Complete new record from old
3534:
3535: -- l_Line_Adj_Att_rec :=
3536: Oe_Line_Price_Aattr_util.Complete_Record
3537: ( p_x_Line_Adj_Att_rec => l_Line_Adj_Att_rec
3538: , p_old_Line_Adj_Att_rec => l_old_Line_Adj_Att_rec
3539: );
3540:

Line 3586: Oe_Line_Price_Aattr_util.Apply_Attribute_Changes

3582: THEN
3583:
3584: -- This will also log request/s to check duplicity of
3585: -- price adjustment entered
3586: Oe_Line_Price_Aattr_util.Apply_Attribute_Changes
3587: ( p_x_Line_Adj_Att_rec => l_Line_Adj_Att_rec
3588: , p_old_Line_Adj_Att_rec => l_old_Line_Adj_Att_rec
3589: --, x_Line_Adj_Att_rec => l_Line_Adj_Att_rec
3590: );

Line 3605: Oe_Line_Price_Aattr_util.Delete_Row

3601: IF l_control_rec.write_to_db THEN
3602:
3603: IF l_Line_Adj_Att_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
3604:
3605: Oe_Line_Price_Aattr_util.Delete_Row
3606: ( p_Price_Adj_Attrib_id => l_Line_Adj_Att_rec.Price_adj_attrib_id
3607: );
3608:
3609: ELSE

Line 3619: Oe_Line_Price_Aattr_util.Update_Row (l_Line_Adj_Att_rec);

3615: l_Line_Adj_Att_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
3616:
3617: IF l_Line_Adj_Att_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3618:
3619: Oe_Line_Price_Aattr_util.Update_Row (l_Line_Adj_Att_rec);
3620:
3621: ELSIF l_Line_Adj_Att_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
3622:
3623: l_Line_Adj_Att_rec.creation_date := SYSDATE;

Line 3626: Oe_Line_Price_Aattr_util.Insert_Row (l_Line_Adj_Att_rec);

3622:
3623: l_Line_Adj_Att_rec.creation_date := SYSDATE;
3624: l_Line_Adj_Att_rec.created_by := FND_GLOBAL.USER_ID;
3625:
3626: Oe_Line_Price_Aattr_util.Insert_Row (l_Line_Adj_Att_rec);
3627:
3628: END IF;
3629:
3630: END IF;

Line 7167: Oe_Line_Price_Aattr_util.Query_Rows(

7163:
7164: G_STMT_NO := 'Query_Adj_Attribs#15';
7165:
7166:
7167: Oe_Line_Price_Aattr_util.Query_Rows(
7168: p_price_adjustment_id => p_price_adjustment_id
7169: , x_Line_Adj_Att_Tbl=>L_Line_Adj_Att_Tbl);
7170:
7171: -- Append to the tbl with Delete flag set.