APPS.OE_ORDER_PVT dependencies on OE_LOT_SERIAL_UTIL

Line 5038: OE_Lot_Serial_Util.Convert_Miss_To_Null (l_old_Lot_Serial_rec);

5034: l_Lot_Serial_rec.db_flag := FND_API.G_FALSE;
5035:
5036: -- Set missing old record elements to NULL.
5037:
5038: OE_Lot_Serial_Util.Convert_Miss_To_Null (l_old_Lot_Serial_rec);
5039:
5040: ELSIF l_Lot_Serial_rec.operation = OE_GLOBALS.G_OPR_UPDATE
5041: OR l_Lot_Serial_rec.operation = OE_GLOBALS.G_OPR_DELETE
5042: THEN

Line 5051: OE_Lot_Serial_Util.Query_Row

5047:
5048: IF l_old_Lot_Serial_rec.lot_serial_id = FND_API.G_MISS_NUM
5049: THEN
5050:
5051: OE_Lot_Serial_Util.Query_Row
5052: ( p_lot_serial_id => l_Lot_Serial_rec.lot_serial_id
5053: , x_Lot_Serial_rec => l_old_Lot_Serial_rec
5054: );
5055:

Line 5060: OE_Lot_Serial_Util.Convert_Miss_To_Null (l_old_Lot_Serial_rec);

5056: ELSE
5057:
5058: -- Set missing old record elements to NULL.
5059:
5060: OE_Lot_Serial_Util.Convert_Miss_To_Null (l_old_Lot_Serial_rec);
5061:
5062: END IF;
5063:
5064: -- Complete new record from old

Line 5066: OE_Lot_Serial_Util.Complete_Record

5062: END IF;
5063:
5064: -- Complete new record from old
5065:
5066: OE_Lot_Serial_Util.Complete_Record
5067: ( p_x_Lot_Serial_rec => l_Lot_Serial_rec
5068: , p_old_Lot_Serial_rec => l_old_Lot_Serial_rec
5069: );
5070:

Line 5095: OE_Lot_Serial_Util.Clear_Dependent_Attr

5091: -- Clear dependent attributes.
5092:
5093: IF l_control_rec.clear_dependents THEN
5094:
5095: OE_Lot_Serial_Util.Clear_Dependent_Attr
5096: ( p_x_Lot_Serial_rec => l_Lot_Serial_rec
5097: , p_old_Lot_Serial_rec => l_old_Lot_Serial_rec
5098: );
5099:

Line 5118: OE_Lot_Serial_Util.Apply_Attribute_Changes

5114:
5115: IF l_control_rec.change_attributes
5116: THEN
5117:
5118: OE_Lot_Serial_Util.Apply_Attribute_Changes
5119: ( p_x_Lot_Serial_rec => l_Lot_Serial_rec
5120: , p_old_Lot_Serial_rec => l_old_Lot_Serial_rec
5121: );
5122:

Line 5160: OE_Lot_Serial_Util.Delete_Row

5156: IF l_control_rec.write_to_db THEN
5157:
5158: IF l_Lot_Serial_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
5159:
5160: OE_Lot_Serial_Util.Delete_Row
5161: ( p_lot_serial_id => l_Lot_Serial_rec.lot_serial_id
5162: );
5163:
5164: ELSE

Line 5174: OE_Lot_Serial_Util.Update_Row (l_Lot_Serial_rec);

5170: l_Lot_Serial_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
5171:
5172: IF l_Lot_Serial_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
5173:
5174: OE_Lot_Serial_Util.Update_Row (l_Lot_Serial_rec);
5175:
5176: ELSIF l_Lot_Serial_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
5177:
5178: l_Lot_Serial_rec.creation_date := SYSDATE;

Line 5181: OE_Lot_Serial_Util.Insert_Row (l_Lot_Serial_rec);

5177:
5178: l_Lot_Serial_rec.creation_date := SYSDATE;
5179: l_Lot_Serial_rec.created_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
5180:
5181: OE_Lot_Serial_Util.Insert_Row (l_Lot_Serial_rec);
5182:
5183: END IF;
5184:
5185: END IF;

Line 10863: OE_Lot_Serial_Util.Lock_Row

10859: WHILE I IS NOT NULL LOOP
10860:
10861: IF p_x_Lot_Serial_tbl(I).operation = OE_GLOBALS.G_OPR_LOCK THEN
10862:
10863: OE_Lot_Serial_Util.Lock_Row
10864: ( p_x_Lot_Serial_rec => p_x_Lot_Serial_tbl(I)
10865: , x_return_status => l_return_status
10866: );
10867:

Line 11314: OE_Lot_Serial_Util.Query_Rows

11310:
11311: -- Get Lot_Serial ( parent = line )
11312:
11313: l_Lot_Serial_tbl.delete; --6052770
11314: OE_Lot_Serial_Util.Query_Rows
11315: ( p_line_id => x_line_tbl(I2).line_id
11316: , x_Lot_Serial_tbl => l_Lot_Serial_tbl
11317: );
11318: