DBA Data[Home] [Help]

APPS.OE_SHIPPING_INTEGRATION_PVT dependencies on OE_SETS

Line 950: UPDATE OE_SETS

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

Line 3817: UPDATE OE_SETS

3813: END IF;
3814:
3815: IF l_line_rec.arrival_set_id IS NOT NULL AND
3816: l_line_rec.arrival_set_id <> FND_API.G_MISS_NUM THEN
3817: UPDATE OE_SETS
3818: SET SET_STATUS = 'C'
3819: WHERE SET_ID = l_line_rec.arrival_set_id;
3820: IF l_debug_level > 0 THEN
3821: oe_debug_pub.add( 'SET CLOSED: '|| L_LINE_REC.ARRIVAL_SET_ID , 3 ) ;

Line 4266: UPDATE OE_SETS

4262: oe_debug_pub.add( 'NUMBER OF LINES IN THE SET '|| TO_CHAR ( L_LINE_TBL.COUNT ) , 3 ) ;
4263: END IF;
4264: -- Update the set status to closed.
4265:
4266: UPDATE OE_SETS
4267: SET SET_STATUS = 'C'
4268: WHERE SET_ID = p_ship_set_id;
4269:
4270: IF l_debug_level > 0 THEN