APPS.WSM_LBJ_INTERFACE_PVT dependencies on WSM_RESERVATIONS_PVT

Line 11257: If wsm_reservations_pvt.check_reservation_exists(p_wip_entity_id => v_wlji_wip_entity_id(v_idx),

11253: else
11254: l_stmt_num := 950.2;
11255: --AH Add:SO LBJ changes--
11256:
11257: If wsm_reservations_pvt.check_reservation_exists(p_wip_entity_id => v_wlji_wip_entity_id(v_idx),
11258: p_org_id => v_wlji_org_id(v_idx),
11259: p_inventory_item_id => v_wlji_item_id(v_idx)
11260: )
11261: then

Line 11263: wsm_reservations_pvt.modify_reservations_jobupdate (

11259: p_inventory_item_id => v_wlji_item_id(v_idx)
11260: )
11261: then
11262: l_stmt_num := 950.3;
11263: wsm_reservations_pvt.modify_reservations_jobupdate (
11264:
11265: p_wip_entity_id => v_wlji_wip_entity_id(v_idx),
11266: p_old_net_qty => round(v_wlji_net_quantity(v_idx),wip_constants.max_displayed_precision),
11267: p_new_net_qty => round(v_wlji_net_quantity(v_idx),wip_constants.max_displayed_precision),

Line 11353: If wsm_reservations_pvt.check_reservation_exists(p_wip_entity_id => v_wlji_wip_entity_id(v_idx),

11349: DECLARE
11350: l_net_qty_old NUMBER;
11351: BEGIN
11352:
11353: If wsm_reservations_pvt.check_reservation_exists(p_wip_entity_id => v_wlji_wip_entity_id(v_idx),
11354: p_org_id => v_wlji_org_id(v_idx),
11355: p_inventory_item_id => v_wlji_item_id(v_idx)
11356: )
11357: then

Line 11365: wsm_reservations_pvt.modify_reservations_jobupdate (

11361: where wip_entity_id = v_wlji_wip_entity_id(v_idx);
11362:
11363: if v_wlji_net_quantity(v_idx) < l_net_qty_old then --net qty has become lesser.So reduce rsvtn
11364:
11365: wsm_reservations_pvt.modify_reservations_jobupdate (
11366: p_wip_entity_id => v_wlji_wip_entity_id(v_idx),
11367: p_old_net_qty => l_net_qty_old ,
11368: p_new_net_qty => round(v_wlji_net_quantity(v_idx),wip_constants.max_displayed_precision),
11369: p_inventory_item_id => v_wlji_item_id(v_idx),