APPS.WMS_CONTAINER_PVT dependencies on MTL_CLIENT_PARAMETERS

Line 739: FROM MTL_CLIENT_PARAMETERS

735: l_client_id NUMBER;
736: l_client_rec inv_cache.ct_rec_type;
737: BEGIN
738: SELECT client_id INTO l_client_id
739: FROM MTL_CLIENT_PARAMETERS
740: WHERE client_code = p_client_code;
741:
742: inv_cache.get_client_default_parameters
743: ( p_client_id => l_client_id,

Line 1228: FROM mtl_client_parameters

1224:
1225: BEGIN
1226:
1227: SELECT lpn_starting_number INTO l_lpn_start_num
1228: FROM mtl_client_parameters
1229: WHERE client_id = p_client_id
1230: FOR UPDATE;
1231:
1232: UPDATE mtl_client_parameters

Line 1232: UPDATE mtl_client_parameters

1228: FROM mtl_client_parameters
1229: WHERE client_id = p_client_id
1230: FOR UPDATE;
1231:
1232: UPDATE mtl_client_parameters
1233: SET lpn_starting_number = l_lpn_start_num+p_qty,
1234: last_update_date = SYSDATE,
1235: last_updated_by = FND_GLOBAL.USER_ID
1236: WHERE client_id = p_client_id;