APPS.OE_SHIP_CONFIRMATION_PUB dependencies on OE_SETS

Line 3711: corresponding set from oe_sets table. handle lock

3707: Handle_Requested_Quantity
3708: 3613716 -- extend fields ordered_quantuty,ship_tolerance_below
3709: and ship_tolerance_above
3710: 3670530 -- If the order line belongs to a set, lock the
3711: corresponding set from oe_sets table. handle lock
3712: exception in the exception handler. also, move the
3713: code to lock order lines to a separate block
3714: ------------------------------------------------------------*/
3715: PROCEDURE Handle_NonBulk_Mode

Line 3901: -- locking OE_SETS table also

3897: END IF;
3898: RAISE;
3899: END ;
3900:
3901: -- locking OE_SETS table also
3902: BEGIN
3903: IF p_ship_line_rec.ship_set_id(I) IS NOT NULL AND
3904: p_ship_line_rec.ship_set_id(I) <> l_ship_set_id THEN
3905: SELECT Set_id

Line 3907: FROM OE_SETS

3903: IF p_ship_line_rec.ship_set_id(I) IS NOT NULL AND
3904: p_ship_line_rec.ship_set_id(I) <> l_ship_set_id THEN
3905: SELECT Set_id
3906: INTO l_ship_set_id
3907: FROM OE_SETS
3908: WHERE set_id = p_ship_line_rec.ship_set_id(I)
3909: FOR UPDATE NOWAIT ;
3910: IF l_debug_level > 0 THEN
3911: oe_debug_pub.add('locked ship set id : '|| l_ship_set_id);

Line 3937: FROM OE_SETS

3933: p_ship_line_rec.arrival_set_id(I) <> l_arrival_set_id THEN
3934:
3935: SELECT Set_id
3936: INTO l_arrival_set_id
3937: FROM OE_SETS
3938: WHERE set_id = p_ship_line_rec.arrival_set_id(I)
3939: FOR UPDATE NOWAIT ;
3940: IF l_debug_level > 0 THEN
3941: oe_debug_pub.add('locked arrival set id : ' || l_arrival_set_id);

Line 4038: UPDATE OE_SETS

4034:
4035: IF p_ship_line_rec.arrival_set_id(I) IS NOT NULL AND
4036: p_ship_line_rec.arrival_set_id(I) <> J
4037: THEN
4038: UPDATE OE_SETS
4039: SET SET_STATUS = 'C'
4040: WHERE SET_ID = p_ship_line_rec.arrival_set_id(I)
4041: AND SET_STATUS <> 'C';
4042:

Line 4105: UPDATE OE_SETS

4101: -- l_set_tbl(p_ship_line_rec.ship_set_id(I)) := 1;-- Bug 8795918
4102: --l_set_tbl(l_ship_set_id_mod) := 1; commented for bug 14777162
4103: l_set_tbl(l_ship_set_id_mod) := l_ship_set_id_mod; --Bug 14777162
4104:
4105: UPDATE OE_SETS
4106: SET SET_STATUS = 'C'
4107: WHERE SET_ID = p_ship_line_rec.ship_set_id(I)
4108: AND SET_STATUS <> 'C';
4109:

Line 4944: UPDATE oe_sets

4940: END IF;
4941:
4942: FORALL i in p_start_index..p_end_index
4943:
4944: UPDATE oe_sets
4945: SET set_status = 'C'
4946: WHERE set_id = p_ship_line_rec.ship_set_id(i)
4947: AND SET_STATUS <> 'C'
4948: AND p_ship_line_rec.error_flag(i) = 'N';

Line 4956: UPDATE oe_sets

4952: END IF;
4953:
4954: -- { bug3309470: close arrival sets also
4955: FORALL i IN p_start_index..p_end_index
4956: UPDATE oe_sets
4957: SET set_status = 'C'
4958: WHERE set_id = p_ship_line_rec.arrival_set_id(i)
4959: AND SET_STATUS <> 'C'
4960: AND p_ship_line_rec.error_flag(i) = 'N';