DBA Data[Home] [Help]

APPS.OE_SHIPPING_INTEGRATION_PVT dependencies on OE_SETS

Line 948: UPDATE OE_SETS

944:
945: IF l_line_rec.arrival_set_id IS NOT NULL AND
946: l_line_rec.arrival_set_id <> FND_API.G_MISS_NUM THEN
947: -- Update the set status to closed.
948: UPDATE OE_SETS
949: SET SET_STATUS = 'C'
950: WHERE SET_ID = l_line_rec.arrival_set_id;
951:
952: IF l_debug_level > 0 THEN

Line 3805: UPDATE OE_SETS

3801: END IF;
3802:
3803: IF l_line_rec.arrival_set_id IS NOT NULL AND
3804: l_line_rec.arrival_set_id <> FND_API.G_MISS_NUM THEN
3805: UPDATE OE_SETS
3806: SET SET_STATUS = 'C'
3807: WHERE SET_ID = l_line_rec.arrival_set_id;
3808: IF l_debug_level > 0 THEN
3809: oe_debug_pub.add( 'SET CLOSED: '|| L_LINE_REC.ARRIVAL_SET_ID , 3 ) ;

Line 4251: UPDATE OE_SETS

4247: oe_debug_pub.add( 'NUMBER OF LINES IN THE SET '|| TO_CHAR ( L_LINE_TBL.COUNT ) , 3 ) ;
4248: END IF;
4249: -- Update the set status to closed.
4250:
4251: UPDATE OE_SETS
4252: SET SET_STATUS = 'C'
4253: WHERE SET_ID = p_ship_set_id;
4254:
4255: IF l_debug_level > 0 THEN