DBA Data[Home] [Help]

APPS.WSM_LBJ_INTERFACE_PVT dependencies on WSM_RESERVATIONS_PVT

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

11151: else
11152: l_stmt_num := 950.2;
11153: --AH Add:SO LBJ changes--
11154:
11155: If wsm_reservations_pvt.check_reservation_exists(p_wip_entity_id => v_wlji_wip_entity_id(v_idx),
11156: p_org_id => v_wlji_org_id(v_idx),
11157: p_inventory_item_id => v_wlji_item_id(v_idx)
11158: )
11159: then

Line 11161: wsm_reservations_pvt.modify_reservations_jobupdate (

11157: p_inventory_item_id => v_wlji_item_id(v_idx)
11158: )
11159: then
11160: l_stmt_num := 950.3;
11161: wsm_reservations_pvt.modify_reservations_jobupdate (
11162:
11163: p_wip_entity_id => v_wlji_wip_entity_id(v_idx),
11164: p_old_net_qty => round(v_wlji_net_quantity(v_idx),wip_constants.max_displayed_precision),
11165: p_new_net_qty => round(v_wlji_net_quantity(v_idx),wip_constants.max_displayed_precision),

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

11247: DECLARE
11248: l_net_qty_old NUMBER;
11249: BEGIN
11250:
11251: If wsm_reservations_pvt.check_reservation_exists(p_wip_entity_id => v_wlji_wip_entity_id(v_idx),
11252: p_org_id => v_wlji_org_id(v_idx),
11253: p_inventory_item_id => v_wlji_item_id(v_idx)
11254: )
11255: then

Line 11263: wsm_reservations_pvt.modify_reservations_jobupdate (

11259: where wip_entity_id = v_wlji_wip_entity_id(v_idx);
11260:
11261: if v_wlji_net_quantity(v_idx) < l_net_qty_old then --net qty has become lesser.So reduce rsvtn
11262:
11263: wsm_reservations_pvt.modify_reservations_jobupdate (
11264: p_wip_entity_id => v_wlji_wip_entity_id(v_idx),
11265: p_old_net_qty => l_net_qty_old ,
11266: p_new_net_qty => round(v_wlji_net_quantity(v_idx),wip_constants.max_displayed_precision),
11267: p_inventory_item_id => v_wlji_item_id(v_idx),