APPS.OE_SHIP_CONFIRMATION_PUB dependencies on OE_SETS

Line 3529: corresponding set from oe_sets table. handle lock

3525: Handle_Requested_Quantity
3526: 3613716 -- extend fields ordered_quantuty,ship_tolerance_below
3527: and ship_tolerance_above
3528: 3670530 -- If the order line belongs to a set, lock the
3529: corresponding set from oe_sets table. handle lock
3530: exception in the exception handler. also, move the
3531: code to lock order lines to a separate block
3532: ------------------------------------------------------------*/
3533: PROCEDURE Handle_NonBulk_Mode

Line 3703: -- locking OE_SETS table also

3699: END IF;
3700: RAISE;
3701: END ;
3702:
3703: -- locking OE_SETS table also
3704: BEGIN
3705: IF p_ship_line_rec.ship_set_id(I) IS NOT NULL AND
3706: p_ship_line_rec.ship_set_id(I) <> l_ship_set_id THEN
3707: SELECT Set_id

Line 3709: FROM OE_SETS

3705: IF p_ship_line_rec.ship_set_id(I) IS NOT NULL AND
3706: p_ship_line_rec.ship_set_id(I) <> l_ship_set_id THEN
3707: SELECT Set_id
3708: INTO l_ship_set_id
3709: FROM OE_SETS
3710: WHERE set_id = p_ship_line_rec.ship_set_id(I)
3711: FOR UPDATE NOWAIT ;
3712: IF l_debug_level > 0 THEN
3713: oe_debug_pub.add('locked ship set id : '|| l_ship_set_id);

Line 3739: FROM OE_SETS

3735: p_ship_line_rec.arrival_set_id(I) <> l_arrival_set_id THEN
3736:
3737: SELECT Set_id
3738: INTO l_arrival_set_id
3739: FROM OE_SETS
3740: WHERE set_id = p_ship_line_rec.arrival_set_id(I)
3741: FOR UPDATE NOWAIT ;
3742: IF l_debug_level > 0 THEN
3743: oe_debug_pub.add('locked arrival set id : ' || l_arrival_set_id);

Line 3840: UPDATE OE_SETS

3836:
3837: IF p_ship_line_rec.arrival_set_id(I) IS NOT NULL AND
3838: p_ship_line_rec.arrival_set_id(I) <> J
3839: THEN
3840: UPDATE OE_SETS
3841: SET SET_STATUS = 'C'
3842: WHERE SET_ID = p_ship_line_rec.arrival_set_id(I)
3843: AND SET_STATUS <> 'C';
3844:

Line 3903: UPDATE OE_SETS

3899: --:= l_set_tbl(p_ship_line_rec.ship_set_id(I)) +1;
3900: ELSE
3901: l_set_tbl(p_ship_line_rec.ship_set_id(I)) := 1;
3902:
3903: UPDATE OE_SETS
3904: SET SET_STATUS = 'C'
3905: WHERE SET_ID = p_ship_line_rec.ship_set_id(I)
3906: AND SET_STATUS <> 'C';
3907:

Line 4599: UPDATE oe_sets

4595: END IF;
4596:
4597: FORALL i in p_start_index..p_end_index
4598:
4599: UPDATE oe_sets
4600: SET set_status = 'C'
4601: WHERE set_id = p_ship_line_rec.ship_set_id(i)
4602: AND SET_STATUS <> 'C'
4603: AND p_ship_line_rec.error_flag(i) = 'N';

Line 4611: UPDATE oe_sets

4607: END IF;
4608:
4609: -- { bug3309470: close arrival sets also
4610: FORALL i IN p_start_index..p_end_index
4611: UPDATE oe_sets
4612: SET set_status = 'C'
4613: WHERE set_id = p_ship_line_rec.arrival_set_id(i)
4614: AND SET_STATUS <> 'C'
4615: AND p_ship_line_rec.error_flag(i) = 'N';