APPS.OE_ORDER_PVT dependencies on OE_LOT_SERIAL_UTIL

Line 5180: OE_Lot_Serial_Util.Convert_Miss_To_Null (l_old_Lot_Serial_rec);

5176: l_Lot_Serial_rec.db_flag := FND_API.G_FALSE;
5177:
5178: -- Set missing old record elements to NULL.
5179:
5180: OE_Lot_Serial_Util.Convert_Miss_To_Null (l_old_Lot_Serial_rec);
5181:
5182: ELSIF l_Lot_Serial_rec.operation = OE_GLOBALS.G_OPR_UPDATE
5183: OR l_Lot_Serial_rec.operation = OE_GLOBALS.G_OPR_DELETE
5184: THEN

Line 5193: OE_Lot_Serial_Util.Query_Row

5189:
5190: IF l_old_Lot_Serial_rec.lot_serial_id = FND_API.G_MISS_NUM
5191: THEN
5192:
5193: OE_Lot_Serial_Util.Query_Row
5194: ( p_lot_serial_id => l_Lot_Serial_rec.lot_serial_id
5195: , x_Lot_Serial_rec => l_old_Lot_Serial_rec
5196: );
5197:

Line 5202: OE_Lot_Serial_Util.Convert_Miss_To_Null (l_old_Lot_Serial_rec);

5198: ELSE
5199:
5200: -- Set missing old record elements to NULL.
5201:
5202: OE_Lot_Serial_Util.Convert_Miss_To_Null (l_old_Lot_Serial_rec);
5203:
5204: END IF;
5205:
5206: -- Complete new record from old

Line 5208: OE_Lot_Serial_Util.Complete_Record

5204: END IF;
5205:
5206: -- Complete new record from old
5207:
5208: OE_Lot_Serial_Util.Complete_Record
5209: ( p_x_Lot_Serial_rec => l_Lot_Serial_rec
5210: , p_old_Lot_Serial_rec => l_old_Lot_Serial_rec
5211: );
5212:

Line 5237: OE_Lot_Serial_Util.Clear_Dependent_Attr

5233: -- Clear dependent attributes.
5234:
5235: IF l_control_rec.clear_dependents THEN
5236:
5237: OE_Lot_Serial_Util.Clear_Dependent_Attr
5238: ( p_x_Lot_Serial_rec => l_Lot_Serial_rec
5239: , p_old_Lot_Serial_rec => l_old_Lot_Serial_rec
5240: );
5241:

Line 5260: OE_Lot_Serial_Util.Apply_Attribute_Changes

5256:
5257: IF l_control_rec.change_attributes
5258: THEN
5259:
5260: OE_Lot_Serial_Util.Apply_Attribute_Changes
5261: ( p_x_Lot_Serial_rec => l_Lot_Serial_rec
5262: , p_old_Lot_Serial_rec => l_old_Lot_Serial_rec
5263: );
5264:

Line 5302: OE_Lot_Serial_Util.Delete_Row

5298: IF l_control_rec.write_to_db THEN
5299:
5300: IF l_Lot_Serial_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
5301:
5302: OE_Lot_Serial_Util.Delete_Row
5303: ( p_lot_serial_id => l_Lot_Serial_rec.lot_serial_id
5304: );
5305:
5306: ELSE

Line 5316: OE_Lot_Serial_Util.Update_Row (l_Lot_Serial_rec);

5312: l_Lot_Serial_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
5313:
5314: IF l_Lot_Serial_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
5315:
5316: OE_Lot_Serial_Util.Update_Row (l_Lot_Serial_rec);
5317:
5318: ELSIF l_Lot_Serial_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
5319:
5320: l_Lot_Serial_rec.creation_date := SYSDATE;

Line 5323: OE_Lot_Serial_Util.Insert_Row (l_Lot_Serial_rec);

5319:
5320: l_Lot_Serial_rec.creation_date := SYSDATE;
5321: l_Lot_Serial_rec.created_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
5322:
5323: OE_Lot_Serial_Util.Insert_Row (l_Lot_Serial_rec);
5324:
5325: END IF;
5326:
5327: END IF;

Line 11092: OE_Lot_Serial_Util.Lock_Row

11088: WHILE I IS NOT NULL LOOP
11089:
11090: IF p_x_Lot_Serial_tbl(I).operation = OE_GLOBALS.G_OPR_LOCK THEN
11091:
11092: OE_Lot_Serial_Util.Lock_Row
11093: ( p_x_Lot_Serial_rec => p_x_Lot_Serial_tbl(I)
11094: , x_return_status => l_return_status
11095: );
11096:

Line 11543: OE_Lot_Serial_Util.Query_Rows

11539:
11540: -- Get Lot_Serial ( parent = line )
11541:
11542: l_Lot_Serial_tbl.delete; --6052770
11543: OE_Lot_Serial_Util.Query_Rows
11544: ( p_line_id => x_line_tbl(I2).line_id
11545: , x_Lot_Serial_tbl => l_Lot_Serial_tbl
11546: );
11547: